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 2013-12-31

View and edit SQL

Suggested facets: Zip, Registration_Date (date)

State

Termination_Date (date)

  • 2013-12-31 · 9
Registration_Number ▼ Registration_Date Termination_Date Name Business_Name Address_1 Address_2 City State Zip
5895 2008-12-01 2013-12-31 Oromo Liberation Front Foreign Relations Office in North America (OLF-FRONA)   P.O. Box 21762   Washington DC 20009
5966 2009-12-16 2013-12-31 HDMK, LLC   1000 Vermont Avenue, NW Suite 800 Washington DC 20005
6082 2011-12-21 2013-12-31 LTL Strategies   4545 42nd Street, NW Suite 306 Washington DC 20016
6090 2012-02-17 2013-12-31 Command Consulting Group, LLC (CCG)   1501 M Street, NW Fifth Floor Washington DC 20005
6107 2012-06-06 2013-12-31 West Wing Writers, LLC   1150 Connecticut Avenue, NW Suite 505 Washington DC 20036
6146 2012-12-20 2013-12-31 Hillenby, LLC   1216 King Street Suite 200 Alexandria VA 22314
6178 2013-08-07 2013-12-31 HL Group Partners, LLC   853 Broadway 18th Floor New York NY 10003
6179 2013-08-09 2013-12-31 Cassidy & Associates, Inc.   733 10th Street, NW Suite 400 Washington DC 20001
6188 2013-09-16 2013-12-31 Carmen Group, Inc.   505 9th Street, NW 7th Floor Washington DC 20004

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