FARA_All_Registrants
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
6 rows where "Termination_Date" is on date 2007-03-31 sorted by State
This data as json, CSV (advanced)
Suggested facets: Business_Name, Registration_Date (date)
City 6
- Cypress 1
- Falls Church 1
- Highland 1
- North Barrington 1
- Rossville 1
- Washington 1
Address_1 6
Registration_Number | Registration_Date | Termination_Date | Name | Business_Name | Address_1 | Address_2 | City | State ▼ | Zip |
---|---|---|---|---|---|---|---|---|---|
5612 | 2004-03-17 | 2007-03-31 | Willkie Farr & Gallagher, LLP | 1875 K Street, N.W. | Washington | DC | 20006 | ||
5710 | 2005-09-09 | 2007-03-31 | Johnson, James M. | 39 Brown Road | Rossville | GA | 30741 | ||
5611 | 2004-03-12 | 2007-03-31 | Clark Consulting | 102 South Wynstone Park Drive | North Barrington | IL | 60010 | ||
5669 | 2005-02-14 | 2007-03-31 | Iler Interests, LP | The Strategic Alliance | 11410 Carson Field Lane | Cypress | TX | 77433 | |
5675 | 2005-03-23 | 2007-03-31 | Gee, Howard | 6546 West 10760 North | Highland | UT | 84003 | ||
5771 | 2006-09-29 | 2007-03-31 | Adams, Gregory Robert | 7214 Hyde Road | Falls Church | VA | 22043 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE [FARA_All_Registrants] ( [Registration_Number] INTEGER PRIMARY KEY, [Registration_Date] TEXT, [Termination_Date] TEXT, [Name] TEXT, [Business_Name] TEXT, [Address_1] TEXT, [Address_2] TEXT, [City] TEXT, [State] TEXT, [Zip] TEXT, FOREIGN KEY([Registration_Number]) REFERENCES [FARA_All_Registrants]([Registration_Number]) );