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

9 rows where Address_1 = "1345 Avenue of the Americas"

View and edit SQL

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

State

City

Address_1

  • 1345 Avenue of the Americas · 9
Registration_Number Registration_Date Termination_Date Name Business_Name Address_1 Address_2 City State Zip
2812 1977-07-20 1979-02-27 Marschalk Company, Inc.   1345 Avenue of the Americas   New York NY 10019
3383 1982-06-16 1991-01-31 Promotional Concept Group, Inc.   1345 Avenue of the Americas   New York NY 10105
3411 1982-09-27 1989-09-07 N.W. Ayer & Son, Inc. N.W. Ayer, Inc. 1345 Avenue of the Americas   New York NY 10105
3670 1985-03-29 1989-11-02 Lowe Marschalk, Inc.   1345 Avenue of the Americas   New York NY 10105
3761 1985-12-10 1986-12-23 Howard J. Rubenstein Associates, Inc.   1345 Avenue of the Americas   New York NY 10105
4778 1993-03-12 2005-09-30 Rubenstein Associates, Inc.   1345 Avenue of the Americas 30th Floor New York NY 10105-0109
5871 2008-06-19 2008-07-09 Rubenstein Associates, Inc.   1345 Avenue of the Americas   New York NY 10105
6049 2011-07-21 2011-09-30 Rubenstein Public Relations   1345 Avenue of the Americas   New York NY 10105
6311 2015-08-07 2016-09-30 Rubenstein Public Relations   1345 Avenue of the Americas   New York NY 10105

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