FARA_All_Registrants
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
20 rows where Address_2 = "Suite 700" and Zip = 20036
This data as json, CSV (advanced)
Suggested facets: Name, Business_Name, Registration_Date (date), Termination_Date (date)
Address_1 14
- 1333 New Hampshire Avenue, NW 5
- 1133 21st Street, N.W. 2
- 1220 - 19th Street, N.W. 2
- 1015 18th Street, NW 1
- 1025 Connecticut Avenue, N.W. 1
- 1133 Connecticut Avenue, N.W. 1
- 1146 - 19th Street, N.W. 1
- 1150 Connecticut Avenue, N.W. 1
- 1200 18th Street, NW 1
- 1200 18th Street, NW 1
- 1201 Connecticut Avenue, N.W. 1
- 1615 L Street, N.W. 1
- 1920 L Street, N.W. 1
- 2033 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 |
---|---|---|---|---|---|---|---|---|---|
2633 | 1975-11-25 | 1981-06-26 | Hydeman, Mason & Goodell, P.C. | 1220 - 19th Street, N.W. | Suite 700 | Washington | DC | 20036 | |
2929 | 1978-07-18 | 1985-10-17 | Santarelli, Donald E. | 2033 M Street, N.W. | Suite 700 | Washington | DC | 20036 | |
3317 | 1981-12-29 | 1998-06-20 | Weil, Gotshal & Manges, L.L.P. | 1615 L Street, N.W. | Suite 700 | Washington | DC | 20036 | |
3444 | 1983-02-16 | 1993-03-24 | Susan Davis International & Public Affairs | 1146 - 19th Street, N.W. | Suite 700 | Washington | DC | 20036 | |
3516 | 1983-08-25 | 1984-09-26 | Cadwalader, Wickersham & Taft | 1333 New Hampshire Avenue, NW | Suite 700 | Washington | DC | 20036 | |
3665 | 1985-04-05 | 1986-08-14 | Cadwalader, Wickersham & Taft | 1333 New Hampshire Avenue, NW | Suite 700 | Washington | DC | 20036 | |
3881 | 1986-09-12 | 1990-12-26 | Leva, Hawes, Mason, Martin & Bebchick | 1220 - 19th Street, N.W. | Suite 700 | Washington | DC | 20036 | |
4022 | 1987-08-11 | 1988-08-22 | Miner, Fraser & Gabriel Public Affairs, Inc. | 1025 Connecticut Avenue, N.W. | Suite 700 | Washington | DC | 20036 | |
4083 | 1988-01-21 | 1992-10-22 | Cadwalader, Wickersham & Taft | 1333 New Hampshire Avenue, NW | Suite 700 | Washington | DC | 20036 | |
4583 | 1991-11-05 | 1991-11-01 | Kamber Group | 1920 L Street, N.W. | Suite 700 | Washington | DC | 20036 | |
4598 | 1991-11-29 | 1992-02-28 | ASL International, Inc. | 1133 Connecticut Avenue, N.W. | Suite 700 | Washington | DC | 20036 | |
4897 | 1994-02-22 | 1994-08-31 | Mullenholz, Brimsek & Belair | 1150 Connecticut Avenue, N.W. | Suite 700 | Washington | DC | 20036 | |
5033 | 1995-06-30 | 1996-11-15 | Cadwalader, Wickersham & Taft | 1333 New Hampshire Avenue, NW | Suite 700 | Washington | DC | 20036 | |
5169 | 1997-04-07 | 1998-10-31 | Foreign Policy Group | 1333 New Hampshire Avenue, NW | Suite 700 | Washington | DC | 20036 | |
5270 | 1998-08-17 | 1999-08-31 | Merritt Group, Ltd. | 1133 21st Street, N.W. | Suite 700 | Washington | DC | 20036 | |
5326 | 1999-08-31 | 2000-02-29 | Janus-Merritt Strategies, LLC | 1133 21st Street, N.W. | Suite 700 | Washington | DC | 20036 | |
5330 | 1999-09-27 | 1999-09-27 | Boros & Garofalo, P.C. | 1201 Connecticut Avenue, N.W. | Suite 700 | Washington | DC | 20036 | |
5580 | 2003-10-06 | 2007-07-31 | Israel Consult, Inc. | I*Consult | 1015 18th Street, NW | Suite 700 | Washington | DC | 20036 |
6559 | 2018-05-25 | 2018-08-31 | Dijkstal, Haydee Johanna | 1200 18th Street, NW | Suite 700 | Washington | DC | 20036 | |
7223 | 2023-01-30 | Media Theory LLC | 1200 18th Street, NW | Suite 700 | 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]) );