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 = "655 - 15th Street, N.W."

View and edit SQL

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

State

City

Address_1

  • 655 - 15th Street, N.W. · 10
Registration_Number ▼ Registration_Date Termination_Date Name Business_Name Address_1 Address_2 City State Zip
948 1956-04-24 1993-07-23 Tanaka, Michele N. Tanaka, Ritger & Middleton 655 - 15th Street, N.W. Suite 800 Washington DC 20005
2850 1977-11-29 1995-11-29 Hannaford Company, Inc.   655 - 15th Street, N.W. Suite 200 Washington DC 20005
3041 1979-07-17 1984-09-06 Craig J. Spence & Associates, Inc.   655 - 15th Street, N.W. Suite 310 Washington DC 20005
3504 1983-08-03 1993-04-23 Parsons, Richard Michael   655 - 15th Street, N.W. Suite 320 Washington DC 20005
3580 1984-05-01 1985-05-06 Marlowe, Howard D.   655 - 15th Street, N.W.   Washington DC 20005
3626 1984-10-31 1998-04-30 Miller & Chevalier, Chartered   655 - 15th Street, N.W. Suite 900 Washington DC 20005-5701
4211 1989-01-27 1991-04-02 Washington Policy & Analysis   655 - 15th Street, N.W. 9th Floor Washington DC 20005-5701
4497 1991-04-05 1993-07-15 Eurafrica Communications, Inc.   655 - 15th Street, N.W. Suite 200 Washington DC 20005
4558 1991-08-22 1995-05-03 Kirkland & Ellis   655 - 15th Street, N.W. Suite 1200 Washington DC 20005
4879 1993-12-17 1995-03-10 Lentz, John W.   655 - 15th Street, N.W.   Washington DC 20005

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