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"

View and edit SQL

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

State

Address_1

  • 420 Lexington Avenue · 10
Registration_Number ▼ Registration_Date Termination_Date Name Business_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

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