You are browsing sample data. Buy download of full dataset or subscribe to API access with one of our member plans.
city_x_lawyer.id | city.id | city.ts | city.title | city.state | state.id | state.ts | state.title | lawyer.id | lawyer.ts | lawyer.title | lawyer.phone | lawyer.address | lawyer.city | lawyer.state | lawyer.zip |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
26 | 3 | 2018-02-10 20:24:55 | Aliceville | Alabama | 1 | 2018-02-08 22:10:59 | Alabama | 26 | 2018-02-08 22:17:10 | Pate David H Attorney At Law | (205) 367-1901 | 56 Court Sq | Carrollton | AL | 35447 |
27 | 3 | 2018-02-10 20:24:55 | Aliceville | Alabama | 1 | 2018-02-08 22:10:59 | Alabama | 27 | 2018-02-08 22:17:10 | District Attorney | (205) 375-9741 | Reform, | Reform | AL | 35481 |
28 | 3 | 2018-02-10 20:24:55 | Aliceville | Alabama | 1 | 2018-02-08 22:10:59 | Alabama | 28 | 2018-02-08 22:17:10 | B McCool Timothy Attorney | (205) 367-8125 | 100 Phoenix Ave | Carrollton | AL | 35447 |
29 | 3 | 2018-02-10 20:24:55 | Aliceville | Alabama | 1 | 2018-02-08 22:10:59 | Alabama | 29 | 2018-02-08 22:17:10 | District Attorney Office | (205) 367-9911 | Carrollton, | Carrollton | AL | 35447 |
30 | 3 | 2018-02-10 20:24:55 | Aliceville | Alabama | 1 | 2018-02-08 22:10:59 | Alabama | 30 | 2018-02-08 22:17:10 | Kirksey & Paluzzi Attorneys | (205) 367-2126 | 60 Tuscaloosa Ave | Carrollton | AL | 35447 |
19162 | 3 | 2018-02-10 20:24:55 | Aliceville | Alabama | 1 | 2018-02-08 22:10:59 | Alabama | 19162 | 2018-02-10 20:24:50 | Junkin Pearson Harrison Junkin & Pate LLC | (205) 367-1901 | 20 Tuscaloosa Ave | Carrollton | AL | 35447 |
19163 | 3 | 2018-02-10 20:24:55 | Aliceville | Alabama | 1 | 2018-02-08 22:10:59 | Alabama | 19163 | 2018-02-10 20:24:50 | King William D IV | (205) 367-8631 | 56 Courthouse Square CRTN3 | Carrollton | AL | 35447 |
19164 | 3 | 2018-02-10 20:24:55 | Aliceville | Alabama | 1 | 2018-02-08 22:10:59 | Alabama | 19164 | 2018-02-10 20:24:50 | McCool Tim Atty | (205) 367-8125 | 100 Phoenix Ave | Carrollton | AL | 35447 |
19165 | 3 | 2018-02-10 20:24:55 | Aliceville | Alabama | 1 | 2018-02-08 22:10:59 | Alabama | 19165 | 2018-02-10 20:24:50 | William D King | (205) 367-8921 | 56 Court Sq | Carrollton | AL | 35447 |
19166 | 3 | 2018-02-10 20:24:55 | Aliceville | Alabama | 1 | 2018-02-08 22:10:59 | Alabama | 19166 | 2018-02-10 20:24:50 | Junkin Pearson Harrison Junkin & Pate LLC | (205) 367-1901 | PO Box 126 | Carrollton | AL | 35447 |
31 | 4 | 2018-02-10 20:25:43 | Andalusia | Alabama | 1 | 2018-02-08 22:10:59 | Alabama | 31 | 2018-02-08 22:17:14 | Lyons Brantley W | (334) 527-4196 | Brantley, | Brantley | AL | 36009 |
32 | 4 | 2018-02-10 20:25:43 | Andalusia | Alabama | 1 | 2018-02-08 22:10:59 | Alabama | 32 | 2018-02-08 22:17:14 | The Loggins Firm LLC | (334) 493-9761 | 100 N College St | Opp | AL | 36467 |
33 | 4 | 2018-02-10 20:25:43 | Andalusia | Alabama | 1 | 2018-02-08 22:10:59 | Alabama | 33 | 2018-02-08 22:17:14 | Brock & Stout Attorneys At Law | (334) 222-5600 | 29 S Court Sq | Andalusia | AL | 36420 |
34 | 4 | 2018-02-10 20:25:43 | Andalusia | Alabama | 1 | 2018-02-08 22:10:59 | Alabama | 34 | 2018-02-08 22:17:14 | Brock & Stout Attorneys At Law | (334) 222-5600 | 211 Dunson St | Andalusia | AL | 36420 |
35 | 4 | 2018-02-10 20:25:43 | Andalusia | Alabama | 1 | 2018-02-08 22:10:59 | Alabama | 35 | 2018-02-08 22:17:14 | Stephanie Attorney Cotton At Law | (334) 427-1120 | 1 E Court Sq | Andalusia | AL | 36420 |
36 | 4 | 2018-02-10 20:25:43 | Andalusia | Alabama | 1 | 2018-02-08 22:10:59 | Alabama | 36 | 2018-02-08 22:17:14 | Sylvester Attorney Rod At Law | (334) 222-9199 | 109 S Cotton St | Andalusia | AL | 36420 |
37 | 4 | 2018-02-10 20:25:43 | Andalusia | Alabama | 1 | 2018-02-08 22:10:59 | Alabama | 37 | 2018-02-08 22:17:14 | Stewart Attorney Stephanie At Law | (334) 427-1120 | 109 S Cotton St | Andalusia | AL | 36420 |
38 | 4 | 2018-02-10 20:25:43 | Andalusia | Alabama | 1 | 2018-02-08 22:10:59 | Alabama | 38 | 2018-02-08 22:17:14 | Rod Attorney Sylvester At Law | (334) 222-9199 | 205 Church St | Andalusia | AL | 36420 |
39 | 4 | 2018-02-10 20:25:43 | Andalusia | Alabama | 1 | 2018-02-08 22:10:59 | Alabama | 39 | 2018-02-08 22:17:14 | Bryan Corey D Attorney At Law LLC | (334) 222-8220 | 119 E Three Notch St | Andalusia | AL | 36420 |
40 | 4 | 2018-02-10 20:25:43 | Andalusia | Alabama | 1 | 2018-02-08 22:10:59 | Alabama | 40 | 2018-02-08 22:17:14 | Boothe Bart M LLC Attorney At Law | (334) 493-8100 | 808 US Highway 84 E | Opp | AL | 36467 |
19177 | 4 | 2018-02-10 20:25:43 | Andalusia | Alabama | 1 | 2018-02-08 22:10:59 | Alabama | 19177 | 2018-02-10 20:25:01 | Charles M Burgess III Attorney At Law | (334) 493-1313 | 140 E Covington Ave | Opp | AL | 36467 |
19178 | 4 | 2018-02-10 20:25:43 | Andalusia | Alabama | 1 | 2018-02-08 22:10:59 | Alabama | 19178 | 2018-02-10 20:25:01 | Virginia W Grimes Attorney | (334) 222-3333 | 5 E Court Sq | Andalusia | AL | 36420 |
19179 | 4 | 2018-02-10 20:25:43 | Andalusia | Alabama | 1 | 2018-02-08 22:10:59 | Alabama | 19179 | 2018-02-10 20:25:01 | Eugenia L Loggins Attorney | (334) 493-9761 | 100 N College St | Opp | AL | 36467 |
19180 | 4 | 2018-02-10 20:25:43 | Andalusia | Alabama | 1 | 2018-02-08 22:10:59 | Alabama | 19180 | 2018-02-10 20:25:01 | James R Clifton Attorney | (334) 222-3177 | 109 Opp Ave | Andalusia | AL | 36420 |
19181 | 4 | 2018-02-10 20:25:43 | Andalusia | Alabama | 1 | 2018-02-08 22:10:59 | Alabama | 19181 | 2018-02-10 20:25:01 | J Mark Murphy Attorney | (334) 222-3333 | 5 E Court Sq | Andalusia | AL | 36420 |
19182 | 4 | 2018-02-10 20:25:43 | Andalusia | Alabama | 1 | 2018-02-08 22:10:59 | Alabama | 19182 | 2018-02-10 20:25:01 | Timothy B Loggins Attorney | (334) 493-9761 | 100 N College St | Opp | AL | 36467 |
19183 | 4 | 2018-02-10 20:25:43 | Andalusia | Alabama | 1 | 2018-02-08 22:10:59 | Alabama | 19183 | 2018-02-10 20:25:01 | Diana D Mock Attorney | (334) 222-0828 | 214 Church St | Andalusia | AL | 36420 |
19184 | 4 | 2018-02-10 20:25:43 | Andalusia | Alabama | 1 | 2018-02-08 22:10:59 | Alabama | 19184 | 2018-02-10 20:25:01 | Powell Law Firm | (334) 222-4103 | 100 Opp Ave | Andalusia | AL | 36420 |
19185 | 4 | 2018-02-10 20:25:43 | Andalusia | Alabama | 1 | 2018-02-08 22:10:59 | Alabama | 19185 | 2018-02-10 20:25:01 | The Woodard Law Firm | (334) 222-9115 | 1213 E Three Notch St | Andalusia | AL | 36420 |
19186 | 4 | 2018-02-10 20:25:43 | Andalusia | Alabama | 1 | 2018-02-08 22:10:59 | Alabama | 19186 | 2018-02-10 20:25:22 | Scherf Law Firm LLC | (334) 222-0544 | 113 Opp Ave | Andalusia | AL | 36420 |
city_x_lawyer.id | city.id | city.ts | city.title | city.state | state.id | state.ts | state.title | lawyer.id | lawyer.ts | lawyer.title | lawyer.phone | lawyer.address | lawyer.city | lawyer.state | lawyer.zip |