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

15 rows where Address_2 = "6th Floor"

✎ View and edit SQL

This data as json, CSV (advanced)

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

State 3

Registration_Number ▼ Registration_Date Termination_Date Name Business_Name Address_1 Address_2 City State Zip
596 1949-11-07 1993-03-30 Amtorg Trading Corporation   15 West 36th Street 6th Floor New York NY 10018
2370 1972-08-21 2010-02-28 Costa Rican Board of Trade   108 East 66th Street 6th Floor New York NY 10065
3216 1981-03-26 1979-03-18 Jamaica National Investment Promotion, Ltd.   866 Second Avenue 6th Floor New York NY 10017
3778 1986-02-13 1989-04-10 Bozell, Jacobs, Kenyon & Eckhardt, Public Relations   75 Rockefeller Plaza 6th Floor New York NY 10219
4178 1988-09-23 1991-09-23 Geske, Alvin J.   1016 - 16th Street, N.W. 6th Floor Washington DC 20036
4746 1992-09-03 1995-09-30 Mann, Richard J.   850 Third Avenue 6th Floor New York NY 10022
5114 1996-06-17 1996-08-15 Hunt, Darryl L.   820 Second Avenue 6th Floor New York NY 10017
5149 1996-09-30 1996-10-25 MWW/Strategic Communications, Inc.   1 Meadowlands Plaza 6th Floor East Rutherford NJ 07073
5274 1998-09-17 2002-09-30 Baker, Donelson, Bearman & Caldwell   555 Eleventh Street, N.W. 6th Floor Washington DC 20004
5484 2002-03-11 2003-03-31 Medley Global Advisors   451 Greenwich Street 6th Floor New York NY 10013
5963 2009-11-18 2016-12-31 Sanitas International, LLC   1101 Pennsylvania Avenue, NW 6th Floor Washington DC 20004
5985 2010-04-28 2011-06-30 Lanny J. Davis & Associates, LLC   600 13th Street, NW 6th Floor Washington DC 20005
6396 2016-11-30 2022-09-30 CGCN Group   1307 New York Avenue, NW 6th Floor Washington DC 20005
6502 2017-12-21 2019-04-01 Cogent Strategies LLC   2550 M Street, NW 6th Floor Washington DC 20037
6884 2020-10-30 2021-03-31 Copper Strategies LLC   411 Lafayette Street 6th Floor New York NY 10003

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