FARA_All_Registrants
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
13 rows where Address_2 = "Suite 650", City = "Washington" and State = "DC"
This data as json, CSV (advanced)
Suggested facets: Zip, Termination_Date (date)
Registration_Date (date) 13 ✖
- 1977-08-08 1
- 1979-12-13 1
- 1983-06-24 1
- 1989-01-13 1
- 1993-11-08 1
- 1998-11-16 1
- 2009-03-06 1
- 2012-06-14 1
- 2012-07-23 1
- 2015-09-29 1
- 2016-09-14 1
- 2017-11-09 1
- 2018-09-10 1
Address_1 12
State 1
- DC · 13 ✖
City 1
- Washington · 13 ✖
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 | |
4206 | 1989-01-13 | 1997-07-13 | Strategic Policy, Inc. | 1615 L Street, N.W. | Suite 650 | Washington | DC | 20036 | |
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
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]) );