FARA_All_Registrants
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
3 rows where "Registration_Date" is on date 1975-12-10
This data as json, CSV (advanced)
Suggested facets: Business_Name, Address_2, Registration_Date (date), Termination_Date (date)
City 3
Address_1 3
Registration_Number ▼ | Registration_Date | Termination_Date | Name | Business_Name | Address_1 | Address_2 | City | State | Zip |
---|---|---|---|---|---|---|---|---|---|
2637 | 1975-12-10 | 1977-03-14 | Stanley Ross | Capitan Haya 43 | Madrid 20 | ||||
2638 | 1975-12-10 | 1993-12-10 | Film Comm, Inc. | FILMCOMM/Audience Planners | 641 North Avenue | Glendale Heights | IL | 60139 | |
2639 | 1975-12-10 | 1992-02-05 | Graydon Associates, Inc. | 216 Maple Avenue | Post Office Box 566 | Red Bank | NJ | 07701 |
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]) );