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

21 rows where Address_1 = "630 Fifth Avenue"

View and edit SQL

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

State

City

Address_1

  • 630 Fifth Avenue · 21
Registration_Number Registration_Date Termination_Date Name Business_Name Address_1 Address_2 City State Zip
69 1942-07-28 1946-06-30 Swedish Industries Fund, Inc.   630 Fifth Avenue   New York NY  
450 1947-04-04 1959-01-29 Universal Trading Corporation   630 Fifth Avenue   New York NY  
505 1947-12-01 1993-03-12 U.S. Office of the British Broadcasting Corporation   630 Fifth Avenue   New York NY 10111
736 1952-07-23 1970-12-09 Scandinavian Railways   630 Fifth Avenue Room 901 New York NY 10020
915 1955-10-10 1991-06-30 Yugoslav National Tourist Office   630 Fifth Avenue Suite 280 New York NY 10111
1322 1960-01-13 1988-12-31 Egyptian Government Tourist Office   630 Fifth Avenue   New York NY 10020
1659 1963-10-04 1964-12-31 Keene Jr., John Macauley   630 Fifth Avenue Room 2016 New York NY  
1751 1964-06-04 1966-12-15 Camche, Joel T.   630 Fifth Avenue   New York NY 10020
1879 1965-04-12 1976-12-31 Mexican Government Ministry of Tourism, New York   630 Fifth Avenue Suite 351 New York NY 10020
2279 1971-09-22 1982-07-01 Australian Tourist Commission, New York   630 Fifth Avenue Room 467 New York NY 10111
2328 1972-03-27 1991-12-31 New Zealand Tourist & Publicity Office   630 Fifth Avenue Suite 530 New York NY 10111
2334 1972-04-19 1976-10-21 Malev Hungarian Airlines   630 Fifth Avenue   New York NY 10020
2487 1974-01-08 1979-05-30 Nova Scotia Government Tourist Information Office   630 Fifth Avenue Suite 3115 New York NY 10020
2498 1974-02-25 1977-02-18 Marquardt, H. William   630 Fifth Avenue Suite 2440 New York NY 10020
2610 1975-09-25 1981-08-01 Tunisian National Tourist Office   630 Fifth Avenue Suite 863 New York NY 10020
2815 1977-07-28 1992-10-16 MISR Travel   630 Fifth Avenue Suite 555 New York NY 10111
2817 1977-08-02 1983-03-28 Airbus Industrie of North America, Inc.   630 Fifth Avenue   New York NY 10111
2982 1978-12-05 1981-06-16 Tunisian Trade Office   630 Fifth Avenue Suite 863 New York NY 10020
3011 1979-04-02 1981-08-01 Tunisia Investment Promotion Agency   630 Fifth Avenue Suite 862 New York NY 10020
3523 1983-09-29 1985-10-25 Villares Overseas Corporation   630 Fifth Avenue Suite 1750 New York NY 10111
4361 1990-04-02 1997-04-30 Saskatchewan Economic Diversification & Trade Office   630 Fifth Avenue Suite 2107 New York NY 10111

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