FARA_All_Registrants
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
14 rows where City = "Brooklyn" and Zip = "" sorted by Name
This data as json, CSV (advanced)
Suggested facets: Registration_Date (date), Termination_Date (date)
Address_1 14
Address_2 4 ✖
- - 11
- 156 Montague Street 1
- 38 Livingston Street 1
- Box 20 1
Business_Name 2 ✖
State 1
- NY 14
City 1
- Brooklyn · 14 ✖
Registration_Number | Registration_Date | Termination_Date | Name ▼ | Business_Name | Address_1 | Address_2 | City | State | Zip |
---|---|---|---|---|---|---|---|---|---|
1042 | 1957-06-25 | 1962-09-01 | Al-Bayan | 139 Atlantic Avenue | Brooklyn | NY | |||
348 | 1946-03-22 | 1947-03-23 | Awad, Habib Joseph | 4 Dean Street | Brooklyn | NY | |||
57 | 1942-07-20 | 1945-01-20 | Banach, Francis-Louis Edward | Station West | Box 20 | Brooklyn | NY | ||
605 | 1950-01-11 | 1951-07-11 | Family Export & Shipping Company, Inc. | 377 Blake Avenue | Brooklyn | NY | |||
1534 | 1962-04-04 | 1962-03-20 | L'Union Nationale des Ouvriers d'Haiti en Exil | (National Union of Haitian Workers In Exile) | 144 Lefferts Avenue | Brooklyn | NY | ||
192 | 1943-05-14 | 1943-05-14 | Lie, Haakon Steen | Norwegian Seamens' Union | 156 Montague Street | Brooklyn | NY | ||
1577 | 1962-10-24 | 1962-10-24 | Mallen, George W. | 126 Smith Street | Brooklyn | NY | |||
210 | 1943-09-23 | 1943-09-23 | Malo, Jesus Gonzalez | 70 Middagh Street | Brooklyn | NY | |||
2040 | 1967-08-23 | 1969-08-29 | Muundjua, Festus U. | 64 South Oxford Street | Brooklyn | NY | |||
651 | 1950-11-22 | 1957-11-22 | Parcels to Russia, Inc. | 1530 Bedford Avenue | Brooklyn | NY | |||
1474 | 1961-08-24 | 1965-08-24 | Partido Revolucionario Cubano (Autentico) | 90 St. Marks Avenue | Brooklyn | NY | |||
1757 | 1964-06-12 | 1977-03-31 | Robert W. Schofield & Associates, Inc. | C/O Leona Carney | 38 Livingston Street | Brooklyn | NY | ||
209 | 1943-09-17 | 1946-03-17 | Swedish Seamens' Union | 156 Montague Street | Brooklyn | NY | |||
1502 | 1961-12-18 | 1961-12-18 | Union Nationale des Ouvriers d'Haiti en Exil | 315 Adelphi Street | Brooklyn | NY |
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]) );