FARA_All_Registrants

Table actions
List of all registrant data (active and terminated)

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

15 rows where Address_2 = "Suite 650"

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Zip, Registration_Date (date), Termination_Date (date)

State 3

City 3

Registration_Number ▼ Registration_Date Termination_Date Name Business_Name Address_1 Address_2 City State Zip
2821 1977-08-08 1980-09-23 Lindstrom, Talbot   1333 New Hampshire Avenue, NW Suite 650 Washington DC 20006
3075 1979-12-13 1999-12-13 TKC International, Inc.   2121 K Street, N.W. Suite 650 Washington DC 20037
3489 1983-06-24 1996-02-14 Global U.S.A., Inc.   2121 K Street, N.W. Suite 650 Washington DC 20037
3530 1983-10-18 1986-01-23 Advance International Corporation   7270 Northwest 12th Street Suite 650 Miami FL 33126
4206 1989-01-13 1997-07-13 Strategic Policy, Inc.   1615 L Street, N.W. Suite 650 Washington DC 20036
4461 1991-01-10 1995-12-01 Chalk, O. Roy   1655 North Fort Myer Drive Suite 650 Arlington VA 22209
4867 1993-11-08 1995-05-17 Smith, E. Del   1130 Connecticut Avenue, N.W. Suite 650 Washington DC 20036
5288 1998-11-16 2000-05-31 Roth, L. James   2121 K Street N.W. Suite 650 Washington DC 20037
5914 2009-03-06 2010-05-31 Clark & Weinstock   701 8th Street, NW Suite 650 Washington DC 20001
6110 2012-06-14 2014-03-31 Venn Strategies, LLC   805 15th Street, NW Suite 650 Washington DC 20005
6116 2012-07-23 2014-01-31 Gray Global Strategies, Inc.   300 New Jersey Avenue, NW Suite 650 Washington DC 20001
6320 2015-09-29 2019-07-18 Rokk Solutions, LLC   1701 K Street, NW Suite 650 Washington DC 20006
6374 2016-09-14 2016-11-30 kglobal LLC   2001 L Street, NW Suite 650 Washington DC 20036
6487 2017-11-09 2018-11-30 Playmaker Strategies, LLC   750 Ninth Street, NW Suite 650 Washington DC 20001
6590 2018-09-10 2019-03-01 Energy Resources International, Inc.   1015 18th Street NW Suite 650 Washington DC 20012

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