FARA_All_Registrants
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
9 rows where Termination_Date = "1980-12-31" and "Termination_Date" is on date 1980-12-31
This data as json, CSV (advanced)
Suggested facets: Business_Name, Address_2, Zip, Registration_Date (date), Termination_Date (date)
Address_1 9
City 3
- Washington 4
- New York 3
- Los Angeles 2
Registration_Number ▼ | Registration_Date | Termination_Date | Name | Business_Name | Address_1 | Address_2 | City | State | Zip |
---|---|---|---|---|---|---|---|---|---|
402 | 1946-11-26 | 1980-12-31 | Chinese Information Service | 159 Lexington Avenue | New York | NY | 10016 | ||
1969 | 1966-03-18 | 1980-12-31 | Chinese Information Service, Pacific Coast Bureau | 3440 Wilshire Boulevard | Suite 1108 | Los Angeles | CA | 90010 | |
2380 | 1972-09-20 | 1980-12-31 | Gabriel, Jack P. | Ceylon Tourist Board | 2007 Wilshire Boulevard | Los Angeles | CA | 90057 | |
2735 | 1976-11-17 | 1980-12-31 | Parke-Scott, Ltd | 502 Park Avenue | New York | NY | 10022 | ||
2808 | 1977-07-22 | 1980-12-31 | Nicaraguan-American Trade Council | 475 L'Enfant Plaza, S.W. | Washington | DC | 20024 | ||
3023 | 1979-05-18 | 1980-12-31 | Nossaman, Krueger & Marsh | 1140 - 19th Street, N.W. | Suite 600 | Washington | DC | 20036 | |
3049 | 1979-08-14 | 1980-12-31 | Maggio, Michael | 1801 Columbia Road, N.W. | Suite 100 | Washington | DC | 20009 | |
3071 | 1979-11-30 | 1980-12-31 | China Exhibition Corporation | 591 Park Avenue | New York | NY | 10021 | ||
3148 | 1980-09-10 | 1980-12-31 | Jewell, David A. | Potomac Public Affairs, Ltd. | 1625 Massachusetts Avenue, NW | Washington | DC | 20036 |
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]) );