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

10 rows where Address_1 = "420 Lexington Avenue"

Search:

descending

Registration_Number ▼	Registration_Date	Termination_Date	Name	Address_1	Address_2	City	State	Zip
1030	1957-05-29	1972-07-17	Nordlinger, Riegelman, Benetar & Charney	420 Lexington Avenue		New York	NY	10012
1853	1965-02-10	1997-06-30	Tea Council of the U.S.A., Inc.	420 Lexington Avenue	Suite 825	New York	NY	10170
2445	1973-07-31	1977-06-30	Michael Finn Associates, Inc.	420 Lexington Avenue		New York	NY	10017
2537	1974-10-04	1974-10-04	Dialog, Public Communications Div. of J. Walter Thompson Co.	420 Lexington Avenue		New York	NY	10017
2740	1976-12-17	1986-10-22	Hill & Knowlton, Inc.	420 Lexington Avenue		New York	NY	10017
2996	1979-02-08	1980-12-01	J. Walter Thompson Company	420 Lexington Avenue		New York	NY	10017
4411	1990-09-12	1993-03-31	Carl Byoir & Associates	420 Lexington Avenue		New York	NY	10017
4819	1993-06-18	1995-06-30	Brouillard Communications	420 Lexington Avenue		New York	NY	10170
5006	1995-04-03		Friends of Sinn Fein, Inc.	420 Lexington Avenue	Suite 300	New York	NY	10170
6596	2018-09-27		TRG Advisory Services, LLC	420 Lexington Avenue	Suite 2520	New York	NY	10170

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