Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
1 row where Address_1 = "55 Leonard Street", Registration_Number = 111 and State = "NY"
✎ View and edit SQL
Suggested facets: Registration_Date (date), Termination_Date (date)
|111||1942-09-01||1943-10-07||American Chapter of the Religious Emergency Council||55 Leonard Street||New York||NY|
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) );