List of all registrant data (active and terminated)

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

8 rows where Address_1 = "1919 Pennsylvania Avenue, N.W." and State = "DC"

View and edit SQL

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

State

City

Address_1

  • 1919 Pennsylvania Avenue, N.W. · 8
Registration_Number ▼ Registration_Date Termination_Date Name Business_Name Address_1 Address_2 City State Zip
1001 1957-02-21 1983-06-30 Arter, Hadden & Hemmendinger   1919 Pennsylvania Avenue, N.W. Suite 400 Washington DC 20006
3686 1985-06-03 1985-12-31 Arter & Hadden   1919 Pennsylvania Avenue, N.W. Suite 400 Washington DC 20006
4040 1987-09-22 1988-12-31 National Strategies & Marketing Group, Inc.   1919 Pennsylvania Avenue, N.W. Suite 704 Washington DC 20006
4267 1989-06-23 1995-12-31 International Advisory Services Group, Ltd.   1919 Pennsylvania Avenue, N.W. Suite 800 Washington DC 20006
5043 1995-09-07 2006-03-31 AWS Services   1919 Pennsylvania Avenue, N.W. Suite 200 Washington DC 20006
5208 1997-09-15 2008-08-28 Porter, Wright, Morris & Arthur, LLP   1919 Pennsylvania Avenue, N.W. Suite 500 Washington DC 20006
5422 2001-03-27 2002-12-31 Miller Thomson LLP Miller Thomson Wickens & Lebow LLP 1919 Pennsylvania Avenue, N.W. Suite 610 Washington DC 20006
5727 2006-01-17 2008-01-31 Carmen Group Incorporated   1919 Pennsylvania Avenue, N.W. Fifth Floor Washington DC 20006

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