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

23 rows where Address_2 = "10th Floor"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Termination_Date, Name, 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
2799 1977-06-29 1987-12-31 Finley Kumble Wagner Heine Underberg Manley Myerson & Casey   1120 Connecticut Avenue, N.W. 10th Floor Washington DC 20036
2861 1978-01-25 1985-02-20 Metzger, Shadyac & Schwarz   1275 K Street, N.W. 10th Floor Washington DC 20005
3713 1985-08-06 1988-06-06 Darius International, Inc.   311 East 72nd Street 10th Floor New York NY 10021
3987 1987-05-29 1994-09-15 Crowell & Moring   1001 Pennsylvania Avenue, N.W. 10th Floor Washington DC 20004-2595
4310 1989-10-23 1996-12-31 Brock Group   1155 Connecticut Avenue, N.W. 10th Floor Washington DC 20036
4419 1990-10-09   Deutsche Telekom, Inc.   One Rockefeller Plaza 10th Floor New York NY 10020
4445 1990-12-07 1991-02-14 U.S.A. Expo, Inc.   440 Park Avenue, South 10th Floor New York NY 10016
4772 1993-03-01 1995-05-01 Paul, Hastings, Janofsky & Walker   1299 Pennsylvania Avenue, N.W. 10th Floor Washington DC 20004-2400
4805 1993-05-19 2000-11-30 Gibney, Anthony & Flaherty, L.L.P.   665 Fifth Avenue 10th Floor New York NY 10022-5305
4816 1993-06-11 1994-05-16 Raftis Associates   1575 I Street, N.W. 10th Floor Washington DC 20005
4993 1995-02-08 1995-08-31 Cutler & Stanfield   700 - 14th Street, N.W. 10th Floor Washington DC 20005
5121 1996-07-17 2001-07-31 Paul, Hastings, Janofsky & Walker   1299 Pennsylvania Avenue, N.W. 10th Floor Washington DC 20004-2400
5146 1996-12-19 1999-12-31 Barbour Griffith & Rogers   1275 Pennsylvania Avenue, NW 10th Floor Washington DC 20004
5362 2000-03-29 2000-03-29 Wilson & Wasserstein, Inc.   1401 K Street, N.W. 10th Floor Washington DC 20005
5431 2001-05-11 2002-08-01 IEP Advisors, LLP   1275 Pennsylvania Avenue, N.W. 10th Floor Washington DC 20004
5713 2005-10-19 2006-04-30 Business Council for International Understanding, Inc. (BCIU)   1212 Avenue of the Americas 10th Floor New York NY 10036
5735 2006-03-07 2006-09-30 IEP Advisors, LLP   1275 Pennsylvania Avenue, NW 10th Floor Washington DC 20004
5782 2006-12-26 2006-12-26 Coltrin & Associates, Inc.   1212 Avenue of the Americas 10th Floor New York NY 10036
6523 2018-02-12 2018-03-28 CLS Strategies   1615 L Street, NW 10th Floor Washington DC 20036
6544 2018-04-25 2019-12-15 Policy Impact Strategic Communications, Inc.   1155 Connecticut Avenue, NW 10th Floor Washington DC 20036
6705 2019-08-02 2021-08-31 Quinn Emanuel Urquhart & Sullivan, LLP   865 South Figueroa Street 10th Floor Los Angeles CA 90017
6766 2019-12-11 2020-03-01 CLS Strategies   1615 L Street, NW 10th Floor Washington DC 20036
6775 2019-12-26   Melnik, Steven V.   One Rockefeller Plaza 10th Floor New York NY 10020

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