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 = "499 South Capitol Street, S.W." and City = "Washington"

View and edit SQL

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

State

City

  • Washington · 9

Address_1

  • 499 South Capitol Street, S.W. · 9
Registration_Number ▼ Registration_Date Termination_Date Name Business_Name Address_1 Address_2 City State Zip
3144 1980-04-27 1981-12-23 Davis & McLeod   499 South Capitol Street, S.W. Suite 407 Washington DC 20003
3445 1983-02-18 1985-03-31 Bill Hecht & Associates, Inc.   499 South Capitol Street, S.W. Suite 507 Washington DC 20003
3655 1985-03-08 1993-11-12 Snyder, Ball, Kriser & Associates, Inc.   499 South Capitol Street, S.W. Suite 520 Washington DC 20003
3740 1985-09-26 1990-07-05 Hecht, Spencer & Associates, Inc.   499 South Capitol Street, S.W. Suite 507 Washington DC 20003
4884 1994-01-13 1995-07-31 Hecht, Spencer & Associates, Inc.   499 South Capitol Street, S.W. Suite 507 Washington DC 20003
5352 2000-01-07 2003-07-31 Livingston-Solomon Group, L.L.C.   499 South Capitol Street, S.W. Suite 600 Washington DC 20003
5355 2000-01-31 2011-12-31 Jones, Walker, Waechter, Poitevent, Carrere & Denegre, LLP   499 South Capitol Street, S.W. Suite 600 Washington DC 20003
5474 2002-02-19 2004-02-28 Livingston/Moffett Global Consultants, LLC (LMG)   499 South Capitol Street, S.W. Suite 600 Washington DC 20003
5569 2003-07-28 2005-12-31 Brewster/Jory Associates, LLC Capitol Hill Consulting Group 499 South Capitol Street, S.W. Suite 608 Washington DC 20003

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