FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
30 rows where State = "AL" sorted by Zip
This data as json, CSV (advanced)
Suggested facets: Short_Form_Termination_Date, Short_Form_Last_Name, Short_Form_First_Name, Address_1, Zip, Registration_Date (date)
Short_Form_Date (date) 11 ✖
- 2022-10-06 8
- 2005-10-25 5
- 1990-06-29 4
- 2006-02-21 4
- 1990-01-10 3
- 1977-07-08 1
- 1980-07-24 1
- 1990-02-26 1
- 2006-08-31 1
- 2007-03-08 1
- 2018-11-30 1
Registration_Number 7
Registration_Date 7 ✖
- 2005-10-25 11
- 2022-10-06 8
- 1987-04-09 4
- 1990-06-29 4
- 1977-07-08 1
- 1980-07-14 1
- 2018-11-30 1
Registrant_Name 7
City 4
- Birmingham 13
- HUEYTOWN 8
- Mobile 8
- Haylesville 1
State 1
- AL · 30 ✖
Link | rowid | Short_Form_Termination_Date | Short_Form_Date | Short_Form_Last_Name | Short_Form_First_Name | Registration_Number | Registration_Date | Registrant_Name | Address_1 | Address_2 | City | State | Zip ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1903 | 1903 | 2022-10-06 | Brooks III | Hycall | The Brooks Law Firm PC 7178 | 2022-10-06 | The Brooks Law Firm PC | 275 FOREST ROAD | SUITE 100 | HUEYTOWN | AL | 35023 | |
1904 | 1904 | 2022-10-06 | Brooks | Charles Isaac | The Brooks Law Firm PC 7178 | 2022-10-06 | The Brooks Law Firm PC | 275 FOREST ROAD | SUITE 100 | HUEYTOWN | AL | 35023 | |
1906 | 1906 | 2022-10-06 | Gibson | Jesse | The Brooks Law Firm PC 7178 | 2022-10-06 | The Brooks Law Firm PC | 275 FOREST ROAD | SUITE 100 | HUEYTOWN | AL | 35023 | |
1907 | 1907 | 2022-10-06 | Gitwaza | Muhirwa Paul | The Brooks Law Firm PC 7178 | 2022-10-06 | The Brooks Law Firm PC | 275 FOREST ROAD | SUITE 100 | HUEYTOWN | AL | 35023 | |
1908 | 1908 | 2022-10-06 | Hill | Frederick | The Brooks Law Firm PC 7178 | 2022-10-06 | The Brooks Law Firm PC | 275 FOREST ROAD | SUITE 100 | HUEYTOWN | AL | 35023 | |
1909 | 1909 | 2022-10-06 | McCollum | Laurice Gulley | The Brooks Law Firm PC 7178 | 2022-10-06 | The Brooks Law Firm PC | 275 FOREST ROAD | SUITE 100 | HUEYTOWN | AL | 35023 | |
1910 | 1910 | 2022-10-06 | Nyahoza | Edouard | The Brooks Law Firm PC 7178 | 2022-10-06 | The Brooks Law Firm PC | 275 FOREST ROAD | SUITE 100 | HUEYTOWN | AL | 35023 | |
1911 | 1911 | 2022-10-06 | Uwimbabazi | Claudine | The Brooks Law Firm PC 7178 | 2022-10-06 | The Brooks Law Firm PC | 275 FOREST ROAD | SUITE 100 | HUEYTOWN | AL | 35023 | |
5023 | 5023 | 1988-01-31 | 1977-07-08 | Behoiram | Dora | EBSCO Industries, Inc. 2805 | 1977-07-08 | EBSCO Industries, Inc. | Post Office Box 1943 | Birmingham | AL | 35201 | |
3251 | 3251 | 2009-01-05 | 2006-02-21 | Hancock | Robert D. | Maynard, Cooper and Gale, P.C. 5716 | 2005-10-25 | Maynard, Cooper and Gale, P.C. | 1901 Sixth Avenue North | 2400 AmSouth/Harbert Plaza | Birmingham | AL | 35203 |
3584 | 3584 | 2008-01-11 | 2006-02-21 | Caputo | Pascal B. | Maynard, Cooper and Gale, P.C. 5716 | 2005-10-25 | Maynard, Cooper and Gale, P.C. | 1901 Sixth Avenue North | 2400 AmSouth/Harbert Plaza | Birmingham | AL | 35203 |
6700 | 6700 | 2010-02-12 | 2005-10-25 | Cleveland III | Ollie Ancil (Tres) | Maynard, Cooper and Gale, P.C. 5716 | 2005-10-25 | Maynard, Cooper and Gale, P.C. | 1901 Sixth Avenue North | 2400 AmSouth/Harbert Plaza | Birmingham | AL | 35203 |
6701 | 6701 | 2010-02-12 | 2005-10-25 | Drew | Mark L. | Maynard, Cooper and Gale, P.C. 5716 | 2005-10-25 | Maynard, Cooper and Gale, P.C. | 1901 Sixth Avenue North | 2400 AmSouth/Harbert Plaza | Birmingham | AL | 35203 |
6702 | 6702 | 2010-02-12 | 2005-10-25 | Enslen | Alan F. | Maynard, Cooper and Gale, P.C. 5716 | 2005-10-25 | Maynard, Cooper and Gale, P.C. | 1901 Sixth Avenue North | 2400 AmSouth/Harbert Plaza | Birmingham | AL | 35203 |
14288 | 14288 | 2006-04-28 | 2005-10-25 | Ogletree | Elizabeth T. | Maynard, Cooper and Gale, P.C. 5716 | 2005-10-25 | Maynard, Cooper and Gale, P.C. | 1901 Sixth Avenue North | 2400 AmSouth/Harbert Plaza | Birmingham | AL | 35203 |
14926 | 14926 | 2006-04-30 | 2006-02-21 | Falk | EmiIy A. | Maynard, Cooper and Gale, P.C. 5716 | 2005-10-25 | Maynard, Cooper and Gale, P.C. | 1901 Sixth Avenue North | 2400 AmSouth/Harbert Plaza | Birmingham | AL | 35203 |
14927 | 14927 | 2006-04-30 | 2006-02-21 | Lucas | Melinda J. | Maynard, Cooper and Gale, P.C. 5716 | 2005-10-25 | Maynard, Cooper and Gale, P.C. | 1901 Sixth Avenue North | 2400 AmSouth/Harbert Plaza | Birmingham | AL | 35203 |
14959 | 14959 | 2007-04-30 | 2006-08-31 | Sims | E. Tyler | Maynard, Cooper and Gale, P.C. 5716 | 2005-10-25 | Maynard, Cooper and Gale, P.C. | 1901 Sixth Avenue North | 2400 AmSouth/Harbert Plaza | Birmingham | AL | 35203 |
14961 | 14961 | 2007-04-30 | 2005-10-25 | Mitchell | James L. | Maynard, Cooper and Gale, P.C. 5716 | 2005-10-25 | Maynard, Cooper and Gale, P.C. | 1901 Sixth Avenue North | 2400 AmSouth/Harbert Plaza | Birmingham | AL | 35203 |
29647 | 29647 | 2008-09-12 | 2007-03-08 | Colvin | Adam R. | Maynard, Cooper and Gale, P.C. 5716 | 2005-10-25 | Maynard, Cooper and Gale, P.C. | 1901 Sixth Avenue North | 2400 AmSouth/Harbert Plaza | Birmingham | AL | 35203 |
21938 | 21938 | 2019-06-30 | 2018-11-30 | Keeley | Gregory | Dreadnaught, LLC 6610 | 2018-11-30 | Dreadnaught, LLC | 644 39th Street South | Birmingham | AL | 35222 | |
2593 | 2593 | 1981-01-01 | 1980-07-24 | Coleman | Henry Randolph | Carter, William A. 3120 | 1980-07-14 | Carter, William A. | Tidwell Industries | Post Office Box 679 | Haylesville | AL | 35565 |
20527 | 20527 | 1990-06-29 | 1990-01-10 | Chase | Karen | Edwards, Jack 3958 | 1987-04-09 | Edwards, Jack | 3000 First National Bank Bldg. | Post Office Box 123 | Mobile | AL | 36601 |
20528 | 20528 | 1990-06-29 | 1990-01-10 | Ervin | James Larance | Edwards, Jack 3958 | 1987-04-09 | Edwards, Jack | 3000 First National Bank Bldg. | Post Office Box 123 | Mobile | AL | 36601 |
20529 | 20529 | 1990-06-29 | 1990-01-10 | McCoy | Douglas L. | Edwards, Jack 3958 | 1987-04-09 | Edwards, Jack | 3000 First National Bank Bldg. | Post Office Box 123 | Mobile | AL | 36601 |
20530 | 20530 | 1990-06-29 | 1990-02-26 | Edwards | Jack | Edwards, Jack 3958 | 1987-04-09 | Edwards, Jack | 3000 First National Bank Bldg. | Post Office Box 123 | Mobile | AL | 36601 |
20533 | 20533 | 1990-06-29 | 1990-06-29 | Chase | Karen | Hand, Arendall, Bedsole, Greaves & Johnson 4396 | 1990-06-29 | Hand, Arendall, Bedsole, Greaves & Johnson | 3000 First National Bank Bldg. | Post Office Box 123 | Mobile | AL | 36601 |
20534 | 20534 | 1990-06-29 | 1990-06-29 | Edwards | Jack | Hand, Arendall, Bedsole, Greaves & Johnson 4396 | 1990-06-29 | Hand, Arendall, Bedsole, Greaves & Johnson | 3000 First National Bank Bldg. | Post Office Box 123 | Mobile | AL | 36601 |
20535 | 20535 | 1990-06-29 | 1990-06-29 | Ervin | James Lawrence | Hand, Arendall, Bedsole, Greaves & Johnson 4396 | 1990-06-29 | Hand, Arendall, Bedsole, Greaves & Johnson | 3000 First National Bank Bldg. | Post Office Box 123 | Mobile | AL | 36601 |
20536 | 20536 | 1990-06-29 | 1990-06-29 | McCoy | Douglas L. | Hand, Arendall, Bedsole, Greaves & Johnson 4396 | 1990-06-29 | Hand, Arendall, Bedsole, Greaves & Johnson | 3000 First National Bank Bldg. | Post Office Box 123 | Mobile | AL | 36601 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [FARA_All_ShortForms] ( [Short_Form_Termination_Date] TEXT, [Short_Form_Date] TEXT, [Short_Form_Last_Name] TEXT, [Short_Form_First_Name] TEXT, [Registration_Number] INTEGER, [Registration_Date] TEXT, [Registrant_Name] TEXT, [Address_1] TEXT, [Address_2] TEXT, [City] TEXT, [State] TEXT, [Zip] TEXT, FOREIGN KEY([Registration_Number]) REFERENCES [FARA_All_Registrants]([Registration_Number]) );