FARA_All_Registrants
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
20 rows where Address_2 = "Suite 400" and Zip = 20036
This data as json, CSV (advanced)
Suggested facets: Registration_Date (date), Termination_Date (date)
Address_1 19
- 1220 - 19th Street, N.W. 2
- 1020 - 19th Street, N.W. 1
- 1020 19th Street 1
- 1020 Nineteenth Street, N.W. 1
- 1025 Connecticut Avenue, N.W. 1
- 1129 - 20th Street, N.W. 1
- 1130 17th Street, N.W. 1
- 1155 - 21st Street, N.W. 1
- 1155 Connecticut Avenue, N.W. 1
- 1225 - 19th Street, N.W. 1
- 1233 - 20th Street, N.W. 1
- 1300 - 19th Street, N.W. 1
- 1320 - 19th Street, N.W. 1
- 1333 New Hampshire Ave., N.W. 1
- 1400 16th Street, NW 1
- 1615 L Street, NW 1
- 1705 DeSales Street, N.W. 1
- 1828 L Street, NW 1
- 1900 M Street, N.W. 1
State 1
- DC 20
City 1
- Washington 20
Registration_Number ▼ | Registration_Date | Termination_Date | Name | Business_Name | Address_1 | Address_2 | City | State | Zip |
---|---|---|---|---|---|---|---|---|---|
2852 | 1977-12-15 | 1979-06-15 | Akin, Gump, Hauer & Feld | 1333 New Hampshire Ave., N.W. | Suite 400 | Washington | DC | 20036 | |
3064 | 1979-10-02 | 1982-12-13 | Lee Edwards & Associates, Inc. | 1705 DeSales Street, N.W. | Suite 400 | Washington | DC | 20036 | |
3158 | 1980-10-20 | 1983-09-30 | Motsi, Jacob Ramokoena | 1320 - 19th Street, N.W. | Suite 400 | Washington | DC | 20036 | |
3331 | 1982-01-26 | 1982-07-31 | Hale, Russell & Gray | 1025 Connecticut Avenue, N.W. | Suite 400 | Washington | DC | 20036 | |
3466 | 1983-05-09 | 1994-05-09 | van Kloberg & Associates, Ltd. | 1129 - 20th Street, N.W. | Suite 400 | Washington | DC | 20036 | |
3485 | 1983-06-16 | 1992-10-02 | Oppenheimer, Wolff & Donnelly | 1020 - 19th Street, N.W. | Suite 400 | Washington | DC | 20036 | |
3884 | 1986-09-19 | 1996-12-31 | CANAMCO | 1220 - 19th Street, N.W. | Suite 400 | Washington | DC | 20036 | |
4127 | 1988-06-11 | 1993-04-08 | Paul H. DeLaney, Jr. | 1155 Connecticut Avenue, N.W. | Suite 400 | Washington | DC | 20036 | |
4169 | 1988-08-23 | 1989-10-20 | Afri-Trust International (Ati-Afribank) | 1155 - 21st Street, N.W. | Suite 400 | Washington | DC | 20036 | |
4412 | 1990-09-19 | 1991-03-31 | Porter, Wright, Morris & Arthur | 1233 - 20th Street, N.W. | Suite 400 | Washington | DC | 20036 | |
4524 | 1991-05-23 | 1994-05-30 | Miller, Canfield, Paddock & Stone, P.L.C. | 1225 - 19th Street, N.W. | Suite 400 | Washington | DC | 20036 | |
4586 | 1991-11-06 | 1992-12-31 | Office of the Republic of Slovenia | 1300 - 19th Street, N.W. | Suite 400 | Washington | DC | 20036 | |
5015 | 1995-04-14 | 1996-04-30 | Law Office of Richard Littell | 1220 - 19th Street, N.W. | Suite 400 | Washington | DC | 20036 | |
5387 | 2000-09-28 | 2000-09-30 | International Strategic & Consulting Group, Inc. | 1020 Nineteenth Street, N.W. | Suite 400 | Washington | DC | 20036 | |
5575 | 2003-08-14 | 2005-02-28 | Bisceglie & Walsh | 1130 17th Street, N.W. | Suite 400 | Washington | DC | 20036 | |
5649 | 2004-10-08 | 2013-04-04 | Levick Strategic Communications | 1900 M Street, N.W. | Suite 400 | Washington | DC | 20036 | |
5717 | 2005-10-26 | 2006-04-30 | Saint-Louis & Johnson, P.C. | 1020 19th Street | Suite 400 | Washington | DC | 20036 | |
5816 | 2007-06-25 | 2007-12-15 | Olsson, Phil | 1400 16th Street, NW | Suite 400 | Washington | DC | 20036 | |
6140 | 2012-10-05 | 2013-11-01 | DCI Group, LLC | 1828 L Street, NW | Suite 400 | Washington | DC | 20036 | |
6170 | 2013-05-14 | Mercury Public Affairs, LLC | 1615 L Street, NW | Suite 400 | 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]) );