FARA_All_Registrants
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
13 rows where Address_2 = "Suite 300", State = "DC" and Zip = 20036
This data as json, CSV (advanced)
Suggested facets: Name, Business_Name, Registration_Date (date), Termination_Date (date)
Address_1 12
- 1900 M Street, NW 2
- 1133 21st Street, N.W. 1
- 1155 - 21st Street, N.W. 1
- 1155 Connecticut Avenue, N.W. 1
- 1200 - 19th Street, NW 1
- 1200 19th Street, NW 1
- 1200 New Hampshire Avenue, NW 1
- 1201 Connecticut Avenue, N.W. 1
- 1350 Connecticut Avenue, NW 1
- 1710 Rhode Island Avenue, N.W. 1
- 1900 L Street, N.W. 1
- 1901 L Street, N.W. 1
State 1
- DC · 13 ✖
City 1
- Washington 13
Registration_Number ▼ | Registration_Date | Termination_Date | Name | Business_Name | Address_1 | Address_2 | City | State | Zip |
---|---|---|---|---|---|---|---|---|---|
4255 | 1989-05-12 | 1990-02-06 | Carpa, Douglas J. | 1155 Connecticut Avenue, N.W. | Suite 300 | Washington | DC | 20036 | |
4278 | 1989-08-10 | 1990-06-26 | Dawson Mathis & Associates, Inc. | 1900 L Street, N.W. | Suite 300 | Washington | DC | 20036 | |
4858 | 1993-10-07 | 1995-03-31 | Williams & Jensen, P.C. | 1155 - 21st Street, N.W. | Suite 300 | Washington | DC | 20036 | |
5105 | 1996-04-12 | 1998-04-30 | Ketchum Communications, Inc. | Ketchum Public Relations | 1201 Connecticut Avenue, N.W. | Suite 300 | Washington | DC | 20036 |
5189 | 1997-06-30 | 1997-06-30 | Ogilvy, Adams & Rinehart | 1901 L Street, N.W. | Suite 300 | Washington | DC | 20036 | |
5346 | 1999-12-09 | 2004-06-30 | Skol & Associates, Inc. | 1710 Rhode Island Avenue, N.W. | Suite 300 | Washington | DC | 20036 | |
5397 | 2000-11-16 | 2001-05-31 | Manning, Selvage & Lee | 1133 21st Street, N.W. | Suite 300 | Washington | DC | 20036 | |
5685 | 2005-05-18 | 2006-11-30 | Chadbourne & Parke, LLP | 1200 New Hampshire Avenue, NW | Suite 300 | Washington | DC | 20036 | |
5733 | 2006-02-21 | 2011-03-30 | Trout Cacheris, PLLC | 1350 Connecticut Avenue, NW | Suite 300 | Washington | DC | 20036 | |
6063 | 2011-09-16 | 2014-06-02 | Squire Sanders Public Advocacy, LLC | 1200 19th Street, NW | Suite 300 | Washington | DC | 20036 | |
6073 | 2011-09-26 | 2013-03-31 | Squire Sanders (US) LLP. | 1200 - 19th Street, NW | Suite 300 | Washington | DC | 20036 | |
6230 | 2014-06-24 | 2015-06-30 | Lanny J. Davis & Associates, LLC | 1900 M Street, NW | Suite 300 | Washington | DC | 20036 | |
6329 | 2015-12-04 | 2016-06-30 | Lanny J. Davis & Associates, LLC | 1900 M Street, NW | Suite 300 | Washington | DC | 20036 |
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]) );