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

12 rows where Address_1 = "610 Fifth Avenue"

View and edit SQL

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

State

City

Address_1

  • 610 Fifth Avenue · 12
Registration_Number ▼ Registration_Date Termination_Date Name Business_Name Address_1 Address_2 City State Zip
8 1942-07-07 1942-07-07 French National Railroads, New York   610 Fifth Avenue   New York NY  
67 1942-07-27 1942-07-27 French Information Center, Inc.   610 Fifth Avenue   New York NY  
294 1945-02-27 1945-02-27 Boyer, Richard James Fildes   610 Fifth Avenue   New York NY  
335 1945-12-26 1988-12-31 French National Railroads, New York   610 Fifth Avenue   New York NY 10020
364 1946-07-25 1985-01-22 French Government Tourist Office   610 Fifth Avenue   New York NY 10020
1240 1959-06-23 1993-06-23 Intourist U.S.A., Inc.   610 Fifth Avenue Suite 603 New York NY 10020
1859 1965-02-24 1967-03-29 S.S. Koppe & Company, Inc.   610 Fifth Avenue   New York NY 10020
2115 1968-12-02 1971-07-19 Koppe International, Ltd.   610 Fifth Avenue   New York NY 10020
2342 1977-05-09 1993-02-09 Government of Antigua & Barbuda Department of Tourism   610 Fifth Avenue Suite 311 New York NY 10020
2368 1972-08-15 1980-02-15 French Industrial Development Agency   610 Fifth Avenue   New York NY 10020
2742 1976-12-28 1981-04-17 Lattey, Gordon Antigua Department of Tourism 610 Fifth Avenue   New York NY 10020
3776 1986-02-10 1989-07-31 Hellenic Development Corporation   610 Fifth Avenue Suite 308 New York NY 10020

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 47.851ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history