FARA_All_Registrants

Table actions
List of all registrant data (active and terminated)

Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history

14 rows where Address_1 = "30 Rockefeller Plaza" and City = "New York"

✎ View and edit SQL

This data as json, CSV (advanced)

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

State 1

City 1

  • New York · 14 ✖

Address_1 1

  • 30 Rockefeller Plaza · 14 ✖
Registration_Number ▼ Registration_Date Termination_Date Name Business_Name Address_1 Address_2 City State Zip
19 1942-07-08 1943-01-08 H.A. Bruno & Associates   30 Rockefeller Plaza   New York NY  
220 1943-11-01 1944-11-01 Birdwell, Russell J.   30 Rockefeller Plaza   New York NY  
449 1947-04-03 1949-12-31 Greek Government Office of Information   30 Rockefeller Plaza Rooms 1519 & 1817 New York NY  
703 1952-01-02 1953-01-02 Fulton, Walter & Halley   30 Rockefeller Plaza   New York NY  
1253 1959-08-17 1960-02-26 Ask Mr. Foster Travel Service, Inc.   30 Rockefeller Plaza   New York NY  
1742 1964-05-25 1966-04-19 Diamond, Leonard W.   30 Rockefeller Plaza   New York NY 10020
2557 1975-02-05 1976-02-19 Deleveaux, E. John   30 Rockefeller Plaza   New York NY 10020
3116 1980-06-30 1981-06-29 Roberts & Holland   30 Rockefeller Plaza   New York NY 10020
3233 1981-04-13 1988-05-02 Roberts & Holland   30 Rockefeller Plaza 20th Floor New York NY 10112
3376 1982-06-02 1985-01-18 Eliel, Stefan E.   30 Rockefeller Plaza   New York NY 10020
3381 1982-06-16 1984-01-06 Armao & Company, Inc.   30 Rockefeller Plaza Suite 4510 New York NY 10112
3451 1983-01-28 1992-08-28 Needham & Grohmann, Inc.   30 Rockefeller Plaza   New York NY 10112
4148 1988-06-20 1990-07-11 Donovan, Leisure, Newton & Irvine   30 Rockefeller Plaza 40th Floor New York NY 10112
4394 1990-07-05 1992-12-31 Berman/Godek Communications, Inc.   30 Rockefeller Plaza Suite 2818 New York NY 10112

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