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 = "500 Fifth Avenue"

Search:

descending

Registration_Number	Registration_Date	Termination_Date	Name	Address_1	Address_2	City	State	Zip
603	1950-01-04		South African Tourism	500 Fifth Avenue	Suite 2200	New York	NY	10110-0002
628	1950-06-19	1960-06-30	Selvage & Lee, Inc.	500 Fifth Avenue		New York	NY
1454	1961-05-29	1964-09-25	Selvage & Lee, Inc.	500 Fifth Avenue		New York	NY
1960	1966-02-04	1966-02-04	James F. Fox, Inc.	500 Fifth Avenue	Room 2225	New York	NY	10036
1994	1966-11-30	1968-05-30	Lipper, Jerome	500 Fifth Avenue		New York	NY
2038	1967-08-15	1968-03-18	James F. Fox, Inc.	500 Fifth Avenue	Room 2225	New York	NY	10036
2086	1968-04-04	1986-04-01	Polish National Tourist Office, New York	500 Fifth Avenue		New York	NY	10036
2160	1969-08-27	1970-09-24	James F. Fox, Inc.	500 Fifth Avenue		New York	NY	10036
4114	1988-04-04	1991-02-19	Souham & Associates, Inc.	500 Fifth Avenue		New York	NY	10036
4174	1988-08-30	1990-04-06	International Public Relations Affiliates	500 Fifth Avenue	Suite 850	New York	NY	10112
4434	1990-11-13	1991-05-31	Cosmo Public Relations	500 Fifth Avenue	Suite 300	New York	NY	10110

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