List of all registrant data (active and terminated)

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

10 rows where Address_1 = "1730 Pennsylvania Avenue, N.W." and State = "DC"

View and edit SQL

Suggested facets: Name, Address_2, Termination_Date (date)

State

City

Address_1

  • 1730 Pennsylvania Avenue, N.W. · 10
Registration_Number ▼ Registration_Date Termination_Date Name Business_Name Address_1 Address_2 City State Zip
2449 1973-08-09 1974-03-13 Daniel J. Edelman, Inc.   1730 Pennsylvania Avenue, N.W. Suite 460 Washington DC 20006
2523 1974-07-01 1974-07-01 Daniel J. Edelman, Inc.   1730 Pennsylvania Avenue, N.W. Suite 460 Washington DC 20006
2548 1974-11-29 1982-12-30 Edelman International Corporation   1730 Pennsylvania Avenue, N.W. Room 460 Washington DC 20006
2640 1975-12-15 1976-06-14 Daniel J. Edelman, Inc.   1730 Pennsylvania Avenue, N.W.   Washington DC 20006
2658 1976-02-05 1981-04-14 Sidley & Austin   1730 Pennsylvania Avenue, N.W.   Washington DC 20006
3468 1983-05-18 1984-05-25 Edelman International Corporation   1730 Pennsylvania Avenue, N.W. Suite 460 Washington DC 20006
3538 1983-11-15 1985-02-13 Charls E. Walker Associates, Inc.   1730 Pennsylvania Avenue, N.W.   Washington DC 20006
4180 1988-09-30 1989-10-12 Charls E. Walker Associates, Inc.   1730 Pennsylvania Avenue, N.W.   Washington DC 20006
4352 1990-03-16 1995-04-28 King & Spalding   1730 Pennsylvania Avenue, N.W. Suite 1200 Washington DC 20006
4446 1990-12-12 1996-06-30 Walker/Potter Associates, Inc.   1730 Pennsylvania Avenue, N.W. Suite 200 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])
);