You are browsing sample data. Buy download of full dataset or subscribe to API access with one of our member plans.
| legal_issue_x_state_x_city_x_lawyer.id | legal_issue_x_state_x_city.id | legal_issue_x_state.id | legal_issue.id | legal_issue.ts | legal_issue.title | state.city_id | state.id | state.ts | state.title | city.id | city.ts | city.title | state.legal_issue_x_state_id | lawyer.id | lawyer.ts | lawyer.title | lawyer.areas_of_law | lawyer.state_bar_summary | lawyer.representative_clients | lawyer.representative_clients_reference | lawyer.firm_address | lawyer.office_our |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1 | 1 | 1 | 2018-10-30 02:19:38 | ADMINISTRATIVE LAW | {
"1": {
"city.id": 1,
"city.ts": "2018-10-31 05:12:27",
"city.title": "Adamsville"
},
"2": {
"city.id": 2,
"city.ts": "2018-10-31 05:12:27",
"city.title": "Adger"
},
"3": {
"city.id": 3,
"city.ts": "2018-10-31 05:12:27",
"city.title": "Alabaster"
},
"4": {
"city.id": 4,
"city.ts": "2018-10-31 04:02:56",
"city.title": "Alexander City"
},
"5": {
"city.id": 5,
"city.ts": "2018-10-31 05:12:27",
"city.title": "Alton"
}
} |
1 | 2018-10-30 03:40:02 | Alabama | 1 | 2018-10-31 05:12:27 | Adamsville | { "1": { "legal_issue_x_state.id": 1, "legal_issue.id": 1, "legal_issue.ts": "2018-10-30 02:19:38", "legal_issue.title": "ADMINISTRATIVE LAW" } } | 1 | 2018-10-31 02:59:38 | The Dodd Law Firm LLC | ||||||
| 3 | 1 | 1 | 1 | 2018-10-30 02:19:38 | ADMINISTRATIVE LAW | {
"1": {
"city.id": 1,
"city.ts": "2018-10-31 05:12:27",
"city.title": "Adamsville"
},
"2": {
"city.id": 2,
"city.ts": "2018-10-31 05:12:27",
"city.title": "Adger"
},
"3": {
"city.id": 3,
"city.ts": "2018-10-31 05:12:27",
"city.title": "Alabaster"
},
"4": {
"city.id": 4,
"city.ts": "2018-10-31 04:02:56",
"city.title": "Alexander City"
},
"5": {
"city.id": 5,
"city.ts": "2018-10-31 05:12:27",
"city.title": "Alton"
}
} |
1 | 2018-10-30 03:40:02 | Alabama | 1 | 2018-10-31 05:12:27 | Adamsville | { "1": { "legal_issue_x_state.id": 1, "legal_issue.id": 1, "legal_issue.ts": "2018-10-30 02:19:38", "legal_issue.title": "ADMINISTRATIVE LAW" } } | 3 | 2018-10-31 02:59:38 | Wrady & Michel LLC | ||||||
| 7 | 2 | 1 | 1 | 2018-10-30 02:19:38 | ADMINISTRATIVE LAW | {
"1": {
"city.id": 1,
"city.ts": "2018-10-31 05:12:27",
"city.title": "Adamsville"
},
"2": {
"city.id": 2,
"city.ts": "2018-10-31 05:12:27",
"city.title": "Adger"
},
"3": {
"city.id": 3,
"city.ts": "2018-10-31 05:12:27",
"city.title": "Alabaster"
},
"4": {
"city.id": 4,
"city.ts": "2018-10-31 04:02:56",
"city.title": "Alexander City"
},
"5": {
"city.id": 5,
"city.ts": "2018-10-31 05:12:27",
"city.title": "Alton"
}
} |
1 | 2018-10-30 03:40:02 | Alabama | 2 | 2018-10-31 05:12:27 | Adger | { "1": { "legal_issue_x_state.id": 1, "legal_issue.id": 1, "legal_issue.ts": "2018-10-30 02:19:38", "legal_issue.title": "ADMINISTRATIVE LAW" } } | 1 | 2018-10-31 02:59:38 | The Dodd Law Firm LLC | ||||||
| 5 | 2 | 1 | 1 | 2018-10-30 02:19:38 | ADMINISTRATIVE LAW | {
"1": {
"city.id": 1,
"city.ts": "2018-10-31 05:12:27",
"city.title": "Adamsville"
},
"2": {
"city.id": 2,
"city.ts": "2018-10-31 05:12:27",
"city.title": "Adger"
},
"3": {
"city.id": 3,
"city.ts": "2018-10-31 05:12:27",
"city.title": "Alabaster"
},
"4": {
"city.id": 4,
"city.ts": "2018-10-31 04:02:56",
"city.title": "Alexander City"
},
"5": {
"city.id": 5,
"city.ts": "2018-10-31 05:12:27",
"city.title": "Alton"
}
} |
1 | 2018-10-30 03:40:02 | Alabama | 2 | 2018-10-31 05:12:27 | Adger | { "1": { "legal_issue_x_state.id": 1, "legal_issue.id": 1, "legal_issue.ts": "2018-10-30 02:19:38", "legal_issue.title": "ADMINISTRATIVE LAW" } } | 3 | 2018-10-31 02:59:38 | Wrady & Michel LLC | ||||||
| 9 | 3 | 1 | 1 | 2018-10-30 02:19:38 | ADMINISTRATIVE LAW | {
"1": {
"city.id": 1,
"city.ts": "2018-10-31 05:12:27",
"city.title": "Adamsville"
},
"2": {
"city.id": 2,
"city.ts": "2018-10-31 05:12:27",
"city.title": "Adger"
},
"3": {
"city.id": 3,
"city.ts": "2018-10-31 05:12:27",
"city.title": "Alabaster"
},
"4": {
"city.id": 4,
"city.ts": "2018-10-31 04:02:56",
"city.title": "Alexander City"
},
"5": {
"city.id": 5,
"city.ts": "2018-10-31 05:12:27",
"city.title": "Alton"
}
} |
1 | 2018-10-30 03:40:02 | Alabama | 3 | 2018-10-31 05:12:27 | Alabaster | { "1": { "legal_issue_x_state.id": 1, "legal_issue.id": 1, "legal_issue.ts": "2018-10-30 02:19:38", "legal_issue.title": "ADMINISTRATIVE LAW" } } | 1 | 2018-10-31 02:59:38 | The Dodd Law Firm LLC | ||||||
| 19 | 3 | 1 | 1 | 2018-10-30 02:19:38 | ADMINISTRATIVE LAW | {
"1": {
"city.id": 1,
"city.ts": "2018-10-31 05:12:27",
"city.title": "Adamsville"
},
"2": {
"city.id": 2,
"city.ts": "2018-10-31 05:12:27",
"city.title": "Adger"
},
"3": {
"city.id": 3,
"city.ts": "2018-10-31 05:12:27",
"city.title": "Alabaster"
},
"4": {
"city.id": 4,
"city.ts": "2018-10-31 04:02:56",
"city.title": "Alexander City"
},
"5": {
"city.id": 5,
"city.ts": "2018-10-31 05:12:27",
"city.title": "Alton"
}
} |
1 | 2018-10-30 03:40:02 | Alabama | 3 | 2018-10-31 05:12:27 | Alabaster | { "1": { "legal_issue_x_state.id": 1, "legal_issue.id": 1, "legal_issue.ts": "2018-10-30 02:19:38", "legal_issue.title": "ADMINISTRATIVE LAW" } } | 3 | 2018-10-31 02:59:38 | Wrady & Michel LLC | ||||||
| 11 | 3 | 1 | 1 | 2018-10-30 02:19:38 | ADMINISTRATIVE LAW | {
"1": {
"city.id": 1,
"city.ts": "2018-10-31 05:12:27",
"city.title": "Adamsville"
},
"2": {
"city.id": 2,
"city.ts": "2018-10-31 05:12:27",
"city.title": "Adger"
},
"3": {
"city.id": 3,
"city.ts": "2018-10-31 05:12:27",
"city.title": "Alabaster"
},
"4": {
"city.id": 4,
"city.ts": "2018-10-31 04:02:56",
"city.title": "Alexander City"
},
"5": {
"city.id": 5,
"city.ts": "2018-10-31 05:12:27",
"city.title": "Alton"
}
} |
1 | 2018-10-30 03:40:02 | Alabama | 3 | 2018-10-31 05:12:27 | Alabaster | { "1": { "legal_issue_x_state.id": 1, "legal_issue.id": 1, "legal_issue.ts": "2018-10-30 02:19:38", "legal_issue.title": "ADMINISTRATIVE LAW" } } | 11 | 2018-10-31 03:02:38 | Lloyd & Hogan, PC | ||||||
| 15 | 3 | 1 | 1 | 2018-10-30 02:19:38 | ADMINISTRATIVE LAW | {
"1": {
"city.id": 1,
"city.ts": "2018-10-31 05:12:27",
"city.title": "Adamsville"
},
"2": {
"city.id": 2,
"city.ts": "2018-10-31 05:12:27",
"city.title": "Adger"
},
"3": {
"city.id": 3,
"city.ts": "2018-10-31 05:12:27",
"city.title": "Alabaster"
},
"4": {
"city.id": 4,
"city.ts": "2018-10-31 04:02:56",
"city.title": "Alexander City"
},
"5": {
"city.id": 5,
"city.ts": "2018-10-31 05:12:27",
"city.title": "Alton"
}
} |
1 | 2018-10-30 03:40:02 | Alabama | 3 | 2018-10-31 05:12:27 | Alabaster | { "1": { "legal_issue_x_state.id": 1, "legal_issue.id": 1, "legal_issue.ts": "2018-10-30 02:19:38", "legal_issue.title": "ADMINISTRATIVE LAW" } } | 15 | 2018-10-31 03:02:38 | John D. Saxon, P.C. | ||||||
| 17 | 3 | 1 | 1 | 2018-10-30 02:19:38 | ADMINISTRATIVE LAW | {
"1": {
"city.id": 1,
"city.ts": "2018-10-31 05:12:27",
"city.title": "Adamsville"
},
"2": {
"city.id": 2,
"city.ts": "2018-10-31 05:12:27",
"city.title": "Adger"
},
"3": {
"city.id": 3,
"city.ts": "2018-10-31 05:12:27",
"city.title": "Alabaster"
},
"4": {
"city.id": 4,
"city.ts": "2018-10-31 04:02:56",
"city.title": "Alexander City"
},
"5": {
"city.id": 5,
"city.ts": "2018-10-31 05:12:27",
"city.title": "Alton"
}
} |
1 | 2018-10-30 03:40:02 | Alabama | 3 | 2018-10-31 05:12:27 | Alabaster | { "1": { "legal_issue_x_state.id": 1, "legal_issue.id": 1, "legal_issue.ts": "2018-10-30 02:19:38", "legal_issue.title": "ADMINISTRATIVE LAW" } } | 17 | 2018-10-31 03:02:38 | Waldrep Stewart & Kendrick, LLC | ||||||
| 21 | 3 | 1 | 1 | 2018-10-30 02:19:38 | ADMINISTRATIVE LAW | {
"1": {
"city.id": 1,
"city.ts": "2018-10-31 05:12:27",
"city.title": "Adamsville"
},
"2": {
"city.id": 2,
"city.ts": "2018-10-31 05:12:27",
"city.title": "Adger"
},
"3": {
"city.id": 3,
"city.ts": "2018-10-31 05:12:27",
"city.title": "Alabaster"
},
"4": {
"city.id": 4,
"city.ts": "2018-10-31 04:02:56",
"city.title": "Alexander City"
},
"5": {
"city.id": 5,
"city.ts": "2018-10-31 05:12:27",
"city.title": "Alton"
}
} |
1 | 2018-10-30 03:40:02 | Alabama | 3 | 2018-10-31 05:12:27 | Alabaster | { "1": { "legal_issue_x_state.id": 1, "legal_issue.id": 1, "legal_issue.ts": "2018-10-30 02:19:38", "legal_issue.title": "ADMINISTRATIVE LAW" } } | 21 | 2018-10-31 03:02:38 | Spain & Gillon, L.L.C. | ||||||
| 23 | 3 | 1 | 1 | 2018-10-30 02:19:38 | ADMINISTRATIVE LAW | {
"1": {
"city.id": 1,
"city.ts": "2018-10-31 05:12:27",
"city.title": "Adamsville"
},
"2": {
"city.id": 2,
"city.ts": "2018-10-31 05:12:27",
"city.title": "Adger"
},
"3": {
"city.id": 3,
"city.ts": "2018-10-31 05:12:27",
"city.title": "Alabaster"
},
"4": {
"city.id": 4,
"city.ts": "2018-10-31 04:02:56",
"city.title": "Alexander City"
},
"5": {
"city.id": 5,
"city.ts": "2018-10-31 05:12:27",
"city.title": "Alton"
}
} |
1 | 2018-10-30 03:40:02 | Alabama | 3 | 2018-10-31 05:12:27 | Alabaster | { "1": { "legal_issue_x_state.id": 1, "legal_issue.id": 1, "legal_issue.ts": "2018-10-30 02:19:38", "legal_issue.title": "ADMINISTRATIVE LAW" } } | 23 | 2018-10-31 03:02:38 | Rumberger, Kirk & Caldwell Professional Association | ||||||
| 25 | 3 | 1 | 1 | 2018-10-30 02:19:38 | ADMINISTRATIVE LAW | {
"1": {
"city.id": 1,
"city.ts": "2018-10-31 05:12:27",
"city.title": "Adamsville"
},
"2": {
"city.id": 2,
"city.ts": "2018-10-31 05:12:27",
"city.title": "Adger"
},
"3": {
"city.id": 3,
"city.ts": "2018-10-31 05:12:27",
"city.title": "Alabaster"
},
"4": {
"city.id": 4,
"city.ts": "2018-10-31 04:02:56",
"city.title": "Alexander City"
},
"5": {
"city.id": 5,
"city.ts": "2018-10-31 05:12:27",
"city.title": "Alton"
}
} |
1 | 2018-10-30 03:40:02 | Alabama | 3 | 2018-10-31 05:12:27 | Alabaster | { "1": { "legal_issue_x_state.id": 1, "legal_issue.id": 1, "legal_issue.ts": "2018-10-30 02:19:38", "legal_issue.title": "ADMINISTRATIVE LAW" } } | 25 | 2018-10-31 03:02:38 | Leitman, Siegal & Payne P.C. | ||||||
| 27 | 3 | 1 | 1 | 2018-10-30 02:19:38 | ADMINISTRATIVE LAW | {
"1": {
"city.id": 1,
"city.ts": "2018-10-31 05:12:27",
"city.title": "Adamsville"
},
"2": {
"city.id": 2,
"city.ts": "2018-10-31 05:12:27",
"city.title": "Adger"
},
"3": {
"city.id": 3,
"city.ts": "2018-10-31 05:12:27",
"city.title": "Alabaster"
},
"4": {
"city.id": 4,
"city.ts": "2018-10-31 04:02:56",
"city.title": "Alexander City"
},
"5": {
"city.id": 5,
"city.ts": "2018-10-31 05:12:27",
"city.title": "Alton"
}
} |
1 | 2018-10-30 03:40:02 | Alabama | 3 | 2018-10-31 05:12:27 | Alabaster | { "1": { "legal_issue_x_state.id": 1, "legal_issue.id": 1, "legal_issue.ts": "2018-10-30 02:19:38", "legal_issue.title": "ADMINISTRATIVE LAW" } } | 27 | 2018-10-31 03:02:38 | Wilkerson & Bryan, P.C. | ||||||
| 29 | 3 | 1 | 1 | 2018-10-30 02:19:38 | ADMINISTRATIVE LAW | {
"1": {
"city.id": 1,
"city.ts": "2018-10-31 05:12:27",
"city.title": "Adamsville"
},
"2": {
"city.id": 2,
"city.ts": "2018-10-31 05:12:27",
"city.title": "Adger"
},
"3": {
"city.id": 3,
"city.ts": "2018-10-31 05:12:27",
"city.title": "Alabaster"
},
"4": {
"city.id": 4,
"city.ts": "2018-10-31 04:02:56",
"city.title": "Alexander City"
},
"5": {
"city.id": 5,
"city.ts": "2018-10-31 05:12:27",
"city.title": "Alton"
}
} |
1 | 2018-10-30 03:40:02 | Alabama | 3 | 2018-10-31 05:12:27 | Alabaster | { "1": { "legal_issue_x_state.id": 1, "legal_issue.id": 1, "legal_issue.ts": "2018-10-30 02:19:38", "legal_issue.title": "ADMINISTRATIVE LAW" } } | 29 | 2018-10-31 03:02:38 | Rushton, Stakely, Johnston & Garrett, P.A. | ||||||
| 31 | 3 | 1 | 1 | 2018-10-30 02:19:38 | ADMINISTRATIVE LAW | {
"1": {
"city.id": 1,
"city.ts": "2018-10-31 05:12:27",
"city.title": "Adamsville"
},
"2": {
"city.id": 2,
"city.ts": "2018-10-31 05:12:27",
"city.title": "Adger"
},
"3": {
"city.id": 3,
"city.ts": "2018-10-31 05:12:27",
"city.title": "Alabaster"
},
"4": {
"city.id": 4,
"city.ts": "2018-10-31 04:02:56",
"city.title": "Alexander City"
},
"5": {
"city.id": 5,
"city.ts": "2018-10-31 05:12:27",
"city.title": "Alton"
}
} |
1 | 2018-10-30 03:40:02 | Alabama | 3 | 2018-10-31 05:12:27 | Alabaster | { "1": { "legal_issue_x_state.id": 1, "legal_issue.id": 1, "legal_issue.ts": "2018-10-30 02:19:38", "legal_issue.title": "ADMINISTRATIVE LAW" } } | 31 | 2018-10-31 03:02:38 | Hartman Simons & Wood LLP | ||||||
| 33 | 3 | 1 | 1 | 2018-10-30 02:19:38 | ADMINISTRATIVE LAW | {
"1": {
"city.id": 1,
"city.ts": "2018-10-31 05:12:27",
"city.title": "Adamsville"
},
"2": {
"city.id": 2,
"city.ts": "2018-10-31 05:12:27",
"city.title": "Adger"
},
"3": {
"city.id": 3,
"city.ts": "2018-10-31 05:12:27",
"city.title": "Alabaster"
},
"4": {
"city.id": 4,
"city.ts": "2018-10-31 04:02:56",
"city.title": "Alexander City"
},
"5": {
"city.id": 5,
"city.ts": "2018-10-31 05:12:27",
"city.title": "Alton"
}
} |
1 | 2018-10-30 03:40:02 | Alabama | 3 | 2018-10-31 05:12:27 | Alabaster | { "1": { "legal_issue_x_state.id": 1, "legal_issue.id": 1, "legal_issue.ts": "2018-10-30 02:19:38", "legal_issue.title": "ADMINISTRATIVE LAW" } } | 33 | 2018-10-31 03:02:38 | Lanier Ford Shaver & Payne P.C. | ||||||
| 35 | 3 | 1 | 1 | 2018-10-30 02:19:38 | ADMINISTRATIVE LAW | {
"1": {
"city.id": 1,
"city.ts": "2018-10-31 05:12:27",
"city.title": "Adamsville"
},
"2": {
"city.id": 2,
"city.ts": "2018-10-31 05:12:27",
"city.title": "Adger"
},
"3": {
"city.id": 3,
"city.ts": "2018-10-31 05:12:27",
"city.title": "Alabaster"
},
"4": {
"city.id": 4,
"city.ts": "2018-10-31 04:02:56",
"city.title": "Alexander City"
},
"5": {
"city.id": 5,
"city.ts": "2018-10-31 05:12:27",
"city.title": "Alton"
}
} |
1 | 2018-10-30 03:40:02 | Alabama | 3 | 2018-10-31 05:12:27 | Alabaster | { "1": { "legal_issue_x_state.id": 1, "legal_issue.id": 1, "legal_issue.ts": "2018-10-30 02:19:38", "legal_issue.title": "ADMINISTRATIVE LAW" } } | 35 | 2018-10-31 03:02:38 | Brunini, Grantham, Grower & Hewes, PLLC | ||||||
| 37 | 3 | 1 | 1 | 2018-10-30 02:19:38 | ADMINISTRATIVE LAW | {
"1": {
"city.id": 1,
"city.ts": "2018-10-31 05:12:27",
"city.title": "Adamsville"
},
"2": {
"city.id": 2,
"city.ts": "2018-10-31 05:12:27",
"city.title": "Adger"
},
"3": {
"city.id": 3,
"city.ts": "2018-10-31 05:12:27",
"city.title": "Alabaster"
},
"4": {
"city.id": 4,
"city.ts": "2018-10-31 04:02:56",
"city.title": "Alexander City"
},
"5": {
"city.id": 5,
"city.ts": "2018-10-31 05:12:27",
"city.title": "Alton"
}
} |
1 | 2018-10-30 03:40:02 | Alabama | 3 | 2018-10-31 05:12:27 | Alabaster | { "1": { "legal_issue_x_state.id": 1, "legal_issue.id": 1, "legal_issue.ts": "2018-10-30 02:19:38", "legal_issue.title": "ADMINISTRATIVE LAW" } } | 37 | 2018-10-31 03:02:38 | Porter, Porter & Hassinger, P.C. | ||||||
| 55 | 4 | 1 | 1 | 2018-10-30 02:19:38 | ADMINISTRATIVE LAW | {
"1": {
"city.id": 1,
"city.ts": "2018-10-31 05:12:27",
"city.title": "Adamsville"
},
"2": {
"city.id": 2,
"city.ts": "2018-10-31 05:12:27",
"city.title": "Adger"
},
"3": {
"city.id": 3,
"city.ts": "2018-10-31 05:12:27",
"city.title": "Alabaster"
},
"4": {
"city.id": 4,
"city.ts": "2018-10-31 04:02:56",
"city.title": "Alexander City"
},
"5": {
"city.id": 5,
"city.ts": "2018-10-31 05:12:27",
"city.title": "Alton"
}
} |
1 | 2018-10-30 03:40:02 | Alabama | 4 | 2018-10-31 04:02:56 | Alexander City | { "1": { "legal_issue_x_state.id": 1, "legal_issue.id": 1, "legal_issue.ts": "2018-10-30 02:19:38", "legal_issue.title": "ADMINISTRATIVE LAW" } } | 27 | 2018-10-31 03:02:38 | Wilkerson & Bryan, P.C. | ||||||
| 51 | 4 | 1 | 1 | 2018-10-30 02:19:38 | ADMINISTRATIVE LAW | {
"1": {
"city.id": 1,
"city.ts": "2018-10-31 05:12:27",
"city.title": "Adamsville"
},
"2": {
"city.id": 2,
"city.ts": "2018-10-31 05:12:27",
"city.title": "Adger"
},
"3": {
"city.id": 3,
"city.ts": "2018-10-31 05:12:27",
"city.title": "Alabaster"
},
"4": {
"city.id": 4,
"city.ts": "2018-10-31 04:02:56",
"city.title": "Alexander City"
},
"5": {
"city.id": 5,
"city.ts": "2018-10-31 05:12:27",
"city.title": "Alton"
}
} |
1 | 2018-10-30 03:40:02 | Alabama | 4 | 2018-10-31 04:02:56 | Alexander City | { "1": { "legal_issue_x_state.id": 1, "legal_issue.id": 1, "legal_issue.ts": "2018-10-30 02:19:38", "legal_issue.title": "ADMINISTRATIVE LAW" } } | 29 | 2018-10-31 03:02:38 | Rushton, Stakely, Johnston & Garrett, P.A. | ||||||
| 39 | 4 | 1 | 1 | 2018-10-30 02:19:38 | ADMINISTRATIVE LAW | {
"1": {
"city.id": 1,
"city.ts": "2018-10-31 05:12:27",
"city.title": "Adamsville"
},
"2": {
"city.id": 2,
"city.ts": "2018-10-31 05:12:27",
"city.title": "Adger"
},
"3": {
"city.id": 3,
"city.ts": "2018-10-31 05:12:27",
"city.title": "Alabaster"
},
"4": {
"city.id": 4,
"city.ts": "2018-10-31 04:02:56",
"city.title": "Alexander City"
},
"5": {
"city.id": 5,
"city.ts": "2018-10-31 05:12:27",
"city.title": "Alton"
}
} |
1 | 2018-10-30 03:40:02 | Alabama | 4 | 2018-10-31 04:02:56 | Alexander City | { "1": { "legal_issue_x_state.id": 1, "legal_issue.id": 1, "legal_issue.ts": "2018-10-30 02:19:38", "legal_issue.title": "ADMINISTRATIVE LAW" } } | 39 | 2018-10-31 03:02:58 | James M. Sizemore, Jr. | ||||||
| 41 | 4 | 1 | 1 | 2018-10-30 02:19:38 | ADMINISTRATIVE LAW | {
"1": {
"city.id": 1,
"city.ts": "2018-10-31 05:12:27",
"city.title": "Adamsville"
},
"2": {
"city.id": 2,
"city.ts": "2018-10-31 05:12:27",
"city.title": "Adger"
},
"3": {
"city.id": 3,
"city.ts": "2018-10-31 05:12:27",
"city.title": "Alabaster"
},
"4": {
"city.id": 4,
"city.ts": "2018-10-31 04:02:56",
"city.title": "Alexander City"
},
"5": {
"city.id": 5,
"city.ts": "2018-10-31 05:12:27",
"city.title": "Alton"
}
} |
1 | 2018-10-30 03:40:02 | Alabama | 4 | 2018-10-31 04:02:56 | Alexander City | { "1": { "legal_issue_x_state.id": 1, "legal_issue.id": 1, "legal_issue.ts": "2018-10-30 02:19:38", "legal_issue.title": "ADMINISTRATIVE LAW" } } | 41 | 2018-10-31 03:02:58 | Slaten Law, P.C. | ||||||
| 43 | 4 | 1 | 1 | 2018-10-30 02:19:38 | ADMINISTRATIVE LAW | {
"1": {
"city.id": 1,
"city.ts": "2018-10-31 05:12:27",
"city.title": "Adamsville"
},
"2": {
"city.id": 2,
"city.ts": "2018-10-31 05:12:27",
"city.title": "Adger"
},
"3": {
"city.id": 3,
"city.ts": "2018-10-31 05:12:27",
"city.title": "Alabaster"
},
"4": {
"city.id": 4,
"city.ts": "2018-10-31 04:02:56",
"city.title": "Alexander City"
},
"5": {
"city.id": 5,
"city.ts": "2018-10-31 05:12:27",
"city.title": "Alton"
}
} |
1 | 2018-10-30 03:40:02 | Alabama | 4 | 2018-10-31 04:02:56 | Alexander City | { "1": { "legal_issue_x_state.id": 1, "legal_issue.id": 1, "legal_issue.ts": "2018-10-30 02:19:38", "legal_issue.title": "ADMINISTRATIVE LAW" } } | 43 | 2018-10-31 03:02:58 | Mooty & Associates, P.C. Attorneys at Law | ||||||
| 45 | 4 | 1 | 1 | 2018-10-30 02:19:38 | ADMINISTRATIVE LAW | {
"1": {
"city.id": 1,
"city.ts": "2018-10-31 05:12:27",
"city.title": "Adamsville"
},
"2": {
"city.id": 2,
"city.ts": "2018-10-31 05:12:27",
"city.title": "Adger"
},
"3": {
"city.id": 3,
"city.ts": "2018-10-31 05:12:27",
"city.title": "Alabaster"
},
"4": {
"city.id": 4,
"city.ts": "2018-10-31 04:02:56",
"city.title": "Alexander City"
},
"5": {
"city.id": 5,
"city.ts": "2018-10-31 05:12:27",
"city.title": "Alton"
}
} |
1 | 2018-10-30 03:40:02 | Alabama | 4 | 2018-10-31 04:02:56 | Alexander City | { "1": { "legal_issue_x_state.id": 1, "legal_issue.id": 1, "legal_issue.ts": "2018-10-30 02:19:38", "legal_issue.title": "ADMINISTRATIVE LAW" } } | 45 | 2018-10-31 03:02:58 | Copeland, Franco, Screws & Gill, P.A. | ||||||
| 47 | 4 | 1 | 1 | 2018-10-30 02:19:38 | ADMINISTRATIVE LAW | {
"1": {
"city.id": 1,
"city.ts": "2018-10-31 05:12:27",
"city.title": "Adamsville"
},
"2": {
"city.id": 2,
"city.ts": "2018-10-31 05:12:27",
"city.title": "Adger"
},
"3": {
"city.id": 3,
"city.ts": "2018-10-31 05:12:27",
"city.title": "Alabaster"
},
"4": {
"city.id": 4,
"city.ts": "2018-10-31 04:02:56",
"city.title": "Alexander City"
},
"5": {
"city.id": 5,
"city.ts": "2018-10-31 05:12:27",
"city.title": "Alton"
}
} |
1 | 2018-10-30 03:40:02 | Alabama | 4 | 2018-10-31 04:02:56 | Alexander City | { "1": { "legal_issue_x_state.id": 1, "legal_issue.id": 1, "legal_issue.ts": "2018-10-30 02:19:38", "legal_issue.title": "ADMINISTRATIVE LAW" } } | 47 | 2018-10-31 03:02:58 | Melton, Espy & Williams, P.C. | ||||||
| 49 | 4 | 1 | 1 | 2018-10-30 02:19:38 | ADMINISTRATIVE LAW | {
"1": {
"city.id": 1,
"city.ts": "2018-10-31 05:12:27",
"city.title": "Adamsville"
},
"2": {
"city.id": 2,
"city.ts": "2018-10-31 05:12:27",
"city.title": "Adger"
},
"3": {
"city.id": 3,
"city.ts": "2018-10-31 05:12:27",
"city.title": "Alabaster"
},
"4": {
"city.id": 4,
"city.ts": "2018-10-31 04:02:56",
"city.title": "Alexander City"
},
"5": {
"city.id": 5,
"city.ts": "2018-10-31 05:12:27",
"city.title": "Alton"
}
} |
1 | 2018-10-30 03:40:02 | Alabama | 4 | 2018-10-31 04:02:56 | Alexander City | { "1": { "legal_issue_x_state.id": 1, "legal_issue.id": 1, "legal_issue.ts": "2018-10-30 02:19:38", "legal_issue.title": "ADMINISTRATIVE LAW" } } | 49 | 2018-10-31 03:02:58 | Ryals & Agricola P.C. | ||||||
| 53 | 4 | 1 | 1 | 2018-10-30 02:19:38 | ADMINISTRATIVE LAW | {
"1": {
"city.id": 1,
"city.ts": "2018-10-31 05:12:27",
"city.title": "Adamsville"
},
"2": {
"city.id": 2,
"city.ts": "2018-10-31 05:12:27",
"city.title": "Adger"
},
"3": {
"city.id": 3,
"city.ts": "2018-10-31 05:12:27",
"city.title": "Alabaster"
},
"4": {
"city.id": 4,
"city.ts": "2018-10-31 04:02:56",
"city.title": "Alexander City"
},
"5": {
"city.id": 5,
"city.ts": "2018-10-31 05:12:27",
"city.title": "Alton"
}
} |
1 | 2018-10-30 03:40:02 | Alabama | 4 | 2018-10-31 04:02:56 | Alexander City | { "1": { "legal_issue_x_state.id": 1, "legal_issue.id": 1, "legal_issue.ts": "2018-10-30 02:19:38", "legal_issue.title": "ADMINISTRATIVE LAW" } } | 53 | 2018-10-31 03:02:58 | Gilpin Givhan, PC | ||||||
| 61 | 4 | 1 | 1 | 2018-10-30 02:19:38 | ADMINISTRATIVE LAW | {
"1": {
"city.id": 1,
"city.ts": "2018-10-31 05:12:27",
"city.title": "Adamsville"
},
"2": {
"city.id": 2,
"city.ts": "2018-10-31 05:12:27",
"city.title": "Adger"
},
"3": {
"city.id": 3,
"city.ts": "2018-10-31 05:12:27",
"city.title": "Alabaster"
},
"4": {
"city.id": 4,
"city.ts": "2018-10-31 04:02:56",
"city.title": "Alexander City"
},
"5": {
"city.id": 5,
"city.ts": "2018-10-31 05:12:27",
"city.title": "Alton"
}
} |
1 | 2018-10-30 03:40:02 | Alabama | 4 | 2018-10-31 04:02:56 | Alexander City | { "1": { "legal_issue_x_state.id": 1, "legal_issue.id": 1, "legal_issue.ts": "2018-10-30 02:19:38", "legal_issue.title": "ADMINISTRATIVE LAW" } } | 61 | 2018-10-31 03:02:58 | Blair and Parsons, P.C. | ||||||
| 63 | 4 | 1 | 1 | 2018-10-30 02:19:38 | ADMINISTRATIVE LAW | {
"1": {
"city.id": 1,
"city.ts": "2018-10-31 05:12:27",
"city.title": "Adamsville"
},
"2": {
"city.id": 2,
"city.ts": "2018-10-31 05:12:27",
"city.title": "Adger"
},
"3": {
"city.id": 3,
"city.ts": "2018-10-31 05:12:27",
"city.title": "Alabaster"
},
"4": {
"city.id": 4,
"city.ts": "2018-10-31 04:02:56",
"city.title": "Alexander City"
},
"5": {
"city.id": 5,
"city.ts": "2018-10-31 05:12:27",
"city.title": "Alton"
}
} |
1 | 2018-10-30 03:40:02 | Alabama | 4 | 2018-10-31 04:02:56 | Alexander City | { "1": { "legal_issue_x_state.id": 1, "legal_issue.id": 1, "legal_issue.ts": "2018-10-30 02:19:38", "legal_issue.title": "ADMINISTRATIVE LAW" } } | 63 | 2018-10-31 03:02:58 | Morrow, Romine & Pearson, P.C. | ||||||
| 77 | 5 | 1 | 1 | 2018-10-30 02:19:38 | ADMINISTRATIVE LAW | {
"1": {
"city.id": 1,
"city.ts": "2018-10-31 05:12:27",
"city.title": "Adamsville"
},
"2": {
"city.id": 2,
"city.ts": "2018-10-31 05:12:27",
"city.title": "Adger"
},
"3": {
"city.id": 3,
"city.ts": "2018-10-31 05:12:27",
"city.title": "Alabaster"
},
"4": {
"city.id": 4,
"city.ts": "2018-10-31 04:02:56",
"city.title": "Alexander City"
},
"5": {
"city.id": 5,
"city.ts": "2018-10-31 05:12:27",
"city.title": "Alton"
}
} |
1 | 2018-10-30 03:40:02 | Alabama | 5 | 2018-10-31 05:12:27 | Alton | { "1": { "legal_issue_x_state.id": 1, "legal_issue.id": 1, "legal_issue.ts": "2018-10-30 02:19:38", "legal_issue.title": "ADMINISTRATIVE LAW" } } | 1 | 2018-10-31 02:59:38 | The Dodd Law Firm LLC | ||||||
| legal_issue_x_state_x_city_x_lawyer.id | legal_issue_x_state_x_city.id | legal_issue_x_state.id | legal_issue.id | legal_issue.ts | legal_issue.title | state.city_id | state.id | state.ts | state.title | city.id | city.ts | city.title | state.legal_issue_x_state_id | lawyer.id | lawyer.ts | lawyer.title | lawyer.areas_of_law | lawyer.state_bar_summary | lawyer.representative_clients | lawyer.representative_clients_reference | lawyer.firm_address | lawyer.office_our |