FARA_All_Registrants

List of all registrant data (active and terminated)

Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history

33 rows where City = "Brooklyn"

View and edit SQL

Suggested facets: Business_Name, Address_2, Zip, Registration_Date (date), Termination_Date (date)

State

City

  • Brooklyn · 33
Registration_Number Registration_Date Termination_Date Name Business_Name Address_1 Address_2 City State Zip
57 1942-07-20 1945-01-20 Banach, Francis-Louis Edward   Station West Box 20 Brooklyn NY  
192 1943-05-14 1943-05-14 Lie, Haakon Steen   Norwegian Seamens' Union 156 Montague Street Brooklyn NY  
209 1943-09-17 1946-03-17 Swedish Seamens' Union   156 Montague Street   Brooklyn NY  
210 1943-09-23 1943-09-23 Malo, Jesus Gonzalez   70 Middagh Street   Brooklyn NY  
348 1946-03-22 1947-03-23 Awad, Habib Joseph   4 Dean Street   Brooklyn NY  
605 1950-01-11 1951-07-11 Family Export & Shipping Company, Inc.   377 Blake Avenue   Brooklyn NY  
642 1950-09-27 1953-09-15 Ozolins, Alexander   451 Union Street   Brooklyn NY 11213
651 1950-11-22 1957-11-22 Parcels to Russia, Inc.   1530 Bedford Avenue   Brooklyn NY  
695 1951-11-14 1960-03-02 Stewart, John   20 Sidney Place   Brooklyn NY 10012
1042 1957-06-25 1962-09-01 Al-Bayan   139 Atlantic Avenue   Brooklyn NY  
1474 1961-08-24 1965-08-24 Partido Revolucionario Cubano (Autentico)   90 St. Marks Avenue   Brooklyn NY  
1502 1961-12-18 1961-12-18 Union Nationale des Ouvriers d'Haiti en Exil   315 Adelphi Street   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  
1577 1962-10-24 1962-10-24 Mallen, George W.   126 Smith Street   Brooklyn NY  
1693 1964-02-24 1972-03-08 Penaco Information Service   C/O Aaron T. Peters, Jr. 566 Greene Avenue Brooklyn NY 11216
1757 1964-06-12 1977-03-31 Robert W. Schofield & Associates, Inc.   C/O Leona Carney 38 Livingston Street Brooklyn NY  
1975 1966-04-07 1970-01-21 Mbaeva, Nathaniel Veiue   320 Eastern Parkway   Brooklyn NY 11225
2040 1967-08-23 1969-08-29 Muundjua, Festus U.   64 South Oxford Street   Brooklyn NY  
2218 1970-11-09 1973-10-05 Provisional Government of Namibia   1060 Union Street   Brooklyn NY 11225
2282 1971-10-04 1973-08-01 Angola Office   C/O Raymond Fernandes Mbala 179 Linden Boulevard #5K Brooklyn NY 11226
2472 1973-10-30 1986-12-31 Eastern Caribbean Tourist Association   509 East 51st Street   Brooklyn NY 11203
2662 1976-02-24 1979-02-23 Riruako, Kuaima Isaac   291 Martens Street Apartment 3C Brooklyn NY 11226
4176 1988-09-13 1988-12-31 Becker, Brett G.   Midwood Station Post Office Box 425 Brooklyn NY 11230
4905 1994-03-29 1994-03-29 Foochs, Arkadiy I.   McLan Building 4121 Eighteenth Avenue Brooklyn NY 11218
5225 1998-01-13 1998-01-13 MIS United Enterprises, Inc.   507 Ditmas Avenue   Brooklyn NY 11218
5991 2010-06-18 2010-06-18 Precision Product, Inc.   18 Steuben Street   Brooklyn NY 11205
6033 2011-04-11 2011-04-11 Supporters of the Irish Labour Party, Inc.   207 Clinton Street #3   Brooklyn NY 11201
6097 2012-04-25 2019-03-31 Friedlander Group   1227 44th Street   Brooklyn NY 11219
6151 2013-01-15 2013-05-13 Galletto, Giacomo   100 Jay Street Apt #29D   Brooklyn NY 11201
6182 2013-08-19 2014-11-02 Build South Africa   P.O. Box 22082   Brooklyn NY 11202
6231 2014-07-03 2014-07-03 mcSQUARED PR Inc.   649 Morgan Avenue Suite 2G Brooklyn NY 11222
6521 2016-11-15   Pakistan Muslim League (Nawaz) USA   818 Coney Island Avenue   Brooklyn NY 11218
6703 2019-07-22   Berkman Law Office, LLC   111 Livingston Street Suite 1928 Brooklyn NY 11201

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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)
);
Powered by Datasette · Query took 40.256ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history