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.id | state.ts | state.title | state.city_id | 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 | 2018-10-30 03:40:02 | Alabama | {
"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-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 | 2018-10-30 03:40:02 | Alabama | {
"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-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 | 2018-10-30 03:40:02 | Alabama | {
"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"
}
} |
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 | 2018-10-30 03:40:02 | Alabama | {
"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"
}
} |
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 | 2018-10-30 03:40:02 | Alabama | {
"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"
}
} |
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 | 2018-10-30 03:40:02 | Alabama | {
"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"
}
} |
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 | 2018-10-30 03:40:02 | Alabama | {
"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"
}
} |
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 | 2018-10-30 03:40:02 | Alabama | {
"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"
}
} |
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 | 2018-10-30 03:40:02 | Alabama | {
"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"
}
} |
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 | 2018-10-30 03:40:02 | Alabama | {
"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"
}
} |
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 | 2018-10-30 03:40:02 | Alabama | {
"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"
}
} |
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 | 2018-10-30 03:40:02 | Alabama | {
"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"
}
} |
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 | 2018-10-30 03:40:02 | Alabama | {
"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"
}
} |
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 | 2018-10-30 03:40:02 | Alabama | {
"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"
}
} |
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 | 2018-10-30 03:40:02 | Alabama | {
"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"
}
} |
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 | 2018-10-30 03:40:02 | Alabama | {
"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"
}
} |
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 | 2018-10-30 03:40:02 | Alabama | {
"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"
}
} |
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 | 2018-10-30 03:40:02 | Alabama | {
"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"
}
} |
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 | 2018-10-30 03:40:02 | Alabama | {
"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"
}
} |
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 | 2018-10-30 03:40:02 | Alabama | {
"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"
}
} |
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 | 2018-10-30 03:40:02 | Alabama | {
"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"
}
} |
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 | 2018-10-30 03:40:02 | Alabama | {
"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"
}
} |
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 | 2018-10-30 03:40:02 | Alabama | {
"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"
}
} |
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 | 2018-10-30 03:40:02 | Alabama | {
"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"
}
} |
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 | 2018-10-30 03:40:02 | Alabama | {
"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"
}
} |
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 | 2018-10-30 03:40:02 | Alabama | {
"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"
}
} |
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 | 2018-10-30 03:40:02 | Alabama | {
"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"
}
} |
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 | 2018-10-30 03:40:02 | Alabama | {
"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"
}
} |
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 | 2018-10-30 03:40:02 | Alabama | {
"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"
}
} |
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 | 2018-10-30 03:40:02 | Alabama | {
"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"
}
} |
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.id | state.ts | state.title | state.city_id | 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 |