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 "Termination_Date" is on date 2008-12-31

View and edit SQL

Suggested facets: Business_Name, Address_2, Registration_Date (date)

State

Termination_Date (date)

  • 2008-12-31 · 9
Registration_Number ▼ Registration_Date Termination_Date Name Business_Name Address_1 Address_2 City State Zip
5486 2002-03-15 2008-12-31 Small Business Corporation (f/k/a Small & Medium Industry Promotion Corporation "SMIPC") Korea Business Development Center 1952 Gallows Road Suite 110 Vienna VA 22182
5551 2003-04-08 2008-12-31 Parvin, C. Landon   902 Sylvania Avenue   Fredericksburg VA 22401
5654 2004-10-29 2008-12-31 Fierce, Isakowitz & Blalock   600 New Hampshire Avenue, N.W. Suite 1000 Washington DC 20037
5667 2005-02-01 2008-12-31 G2 Worldwide, Inc.   200 5th Avenue   New York NY 10010
5779 2006-12-07 2008-12-31 Tramposch, Albert   2111 Preston Square Court   Falls Church VA 22043
5796 2007-02-27 2008-12-31 Powell Goldstein, LLP   901 New York Avenue, NW Third Floor Washington DC 20001
5800 2007-04-16 2008-12-31 Rivers, Stephen M.   2470 Corinth Avenue   Los Angeles CA 90064-3198
5843 2007-12-28 2008-12-31 August, Lang & Husak AL&H 4630 Montgomery Avenue Suite 400 Bethesda MD 20814
5854 2008-02-22 2008-12-31 Hyde Park Communications, Inc.   1101 17th Street, NW Suite 508 Washington DC 20036

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