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 2002-10-31 sorted by City
This data as json, CSV (advanced)
Suggested facets: Address_2, Zip, Registration_Date (date)
Address_1 6
City 5
- Washington 2
- Alexandria 1
- Basel 1
- Dana Point 1
- Pittsburgh 1
Registration_Number | Registration_Date | Termination_Date | Name | Business_Name | Address_1 | Address_2 | City ▼ | State | Zip |
---|---|---|---|---|---|---|---|---|---|
5284 | 1998-10-15 | 2002-10-31 | EAW Group, Inc. | 10 Prince Street | Alexandria | VA | 22314 | ||
5107 | 1996-04-30 | 2002-10-31 | Kaiser, Donald | F. Hoffmann-La Roche, Ltd. | CH 4070 | Basel | |||
4619 | 1992-02-12 | 2002-10-31 | Leone & Leone, Ltd. | 24743 Del Prado PMB #327 | Dana Point | CA | 92629-2852 | ||
4724 | 1992-10-20 | 2002-10-31 | Tripp, Umbach & Associates, Inc. | Fort Pitt Commons, Suite 220 | 445 Fort Pitt Boulevard | Pittsburgh | PA | 15219 | |
5389 | 2000-10-03 | 2002-10-31 | MWW Group | 1747 Pennsylvania Avenue, N.W. | Suite 1150 | Washington | DC | 20006 | |
5427 | 2001-04-24 | 2002-10-31 | Valis Associates | 1700 Pennsylvania Avenue, N.W. | Suite 950 | Washington | DC | 20006 |
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]) );