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

11 rows where Address_1 = "50 Rockefeller Plaza"

Search:

descending

Registration_Number	Registration_Date	Termination_Date	Name	Business_Name	Address_1	Address_2	City	State	Zip
1	1942-09-14	1942-11-09	Estrangin, Gustave Fritsch		50 Rockefeller Plaza	Room 523	New York	NY
130	1942-09-29	1942-09-29	Fernier, Rene		50 Rockefeller Plaza	Room 523	New York	NY
140	1942-10-14	1942-10-14	Peron, Andre Antoine		50 Rockefeller Plaza	Room 523	New York	NY
141	1942-10-15	1942-10-15	D'Aumale, Claude		50 Rockefeller Plaza		New York	NY
223	1943-12-02	1957-12-31	Agence France-Presse (France-Presse News Agency)		50 Rockefeller Plaza		New York	NY	10020
283	1944-11-10	1946-06-30	Falkowski, Edward J.	Polpress News	50 Rockefeller Plaza		New York	NY
405	1946-12-02	1969-11-25	Belgian Government Information Center		50 Rockefeller Plaza		New York	NY	10020
464	1947-06-03	1992-09-30	New York Bureau of the Telegraph Agency of Russia (TASS)		50 Rockefeller Plaza		New York	NY	10020
589	1949-09-15	1952-03-15	Netherland Publishing Corporation		50 Rockefeller Plaza		New York	NY
835	1954-07-06	1969-06-09	Belgian Chamber of Commerce in the U.S., Inc.		50 Rockefeller Plaza		New York	NY	10020
1370	1960-06-13	1965-02-26	Belgian Industrial Information Service		50 Rockefeller Plaza		New York	NY	10020

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)
);