List of all registrant data (active and terminated)

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

12 rows where Address_1 = "600 New Hampshire Avenue, N.W."

View and edit SQL

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

State

City

Address_1

  • 600 New Hampshire Avenue, N.W. · 12
Registration_Number ▼ Registration_Date Termination_Date Name Business_Name Address_1 Address_2 City State Zip
2960 1978-10-02 1978-11-13 Birenbaum, David E.   600 New Hampshire Avenue, N.W. Suite 1000 Washington DC 20037
2976 1978-11-07 1980-06-16 Fried, Frank, Harris, Shriver & Kampelman   600 New Hampshire Avenue, N.W. Suite 1000 Washington DC 10037
3199 1981-02-18 1983-03-19 Fried, Frank, Harris, Shriver & Kampelman A Partnership Including Professional Corporations 600 New Hampshire Avenue, N.W.   Washington DC 20037
3541 1983-12-13 1993-06-13 Fierce, Donald L. Fierce & Associates 600 New Hampshire Avenue, N.W. Suite 1150 Washington DC 20037
3817 1986-04-23 1987-12-09 McCamish, Ingram, Martin & Brown, a Professional Corporation   600 New Hampshire Avenue, N.W. Suite 915 Washington DC 20037
4121 1988-03-21 1996-10-08 Dyer, Ellis & Joseph, P.C.   600 New Hampshire Avenue, N.W. Suite 1000 Washington DC 20037
4131 1988-03-25 1993-04-27 Wallace, Sidney A.   600 New Hampshire Avenue, N.W. Suite 1000 Washington DC 20037
4355 1990-03-21 1990-06-29 O'Brien, David D. David O'Brien & Associates 600 New Hampshire Avenue, N.W. Suite 1010 Washington DC 20037
4570 1991-09-23 1991-10-31 Rogers Jr., Edward M.   600 New Hampshire Avenue, N.W. Suite 1010 Washington DC 20037
4929 1994-07-22 2013-01-31 Blank Rome, LLP   600 New Hampshire Avenue, N.W. Watergate Washington DC 20037
5345 1999-12-01 2003-06-30 Dyer Ellis & Joseph, P.C.   600 New Hampshire Avenue, N.W. 11th Floor Washington DC 20037
5654 2004-10-29 2008-12-31 Fierce, Isakowitz & Blalock   600 New Hampshire Avenue, N.W. Suite 1000 Washington DC 20037

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