FARA_All_Registrants
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
22 rows where Address_2 = "Suite 600" and Zip = 20036
This data as json, CSV (advanced)
Suggested facets: Name, Registration_Date (date), Termination_Date (date)
Address_1 14
- 1300 Connecticut Avenue, N.W. 4
- 1300 Connecticut Avenue, NW 4
- 1100 Connecticut Avenue, N.W. 2
- 1101 Connecticut Avenue, N.W. 2
- 1001 Connecticut Avenue, N.W. 1
- 1050 Connecticut Avenue, NW 1
- 1120 - 19th Street, N.W. 1
- 1130 Connecticut Avenue, NW 1
- 1140 - 19th Street, N.W. 1
- 1225 19th Street, N.W. 1
- 1250 Connecticut Avenue, N.W. 1
- 1300 Connecticut Avenue N.W. 1
- 1850 M Street, NW 1
- 1901 L Street, N.W. 1
State 1
- DC 22
City 1
- Washington 22
Registration_Number ▼ | Registration_Date | Termination_Date | Name | Business_Name | Address_1 | Address_2 | City | State | Zip |
---|---|---|---|---|---|---|---|---|---|
3023 | 1979-05-18 | 1980-12-31 | Nossaman, Krueger & Marsh | 1140 - 19th Street, N.W. | Suite 600 | Washington | DC | 20036 | |
3132 | 1980-08-05 | 1981-06-19 | Waldman, Raymond J. | 1101 Connecticut Avenue, N.W. | Suite 600 | Washington | DC | 20036 | |
3387 | 1982-07-08 | 1996-01-08 | Schiff, Hardin & Waite | 1101 Connecticut Avenue, N.W. | Suite 600 | Washington | DC | 20036 | |
4064 | 1987-11-30 | 1994-11-30 | Richard A. Frank Law Offices | 1120 - 19th Street, N.W. | Suite 600 | Washington | DC | 20036 | |
4170 | 1988-08-18 | 1989-05-30 | Government Research Corporation | 1250 Connecticut Avenue, N.W. | Suite 600 | Washington | DC | 20036 | |
4229 | 1989-03-22 | 1989-12-12 | Storch & Brenner | 1001 Connecticut Avenue, N.W. | Suite 600 | Washington | DC | 20036 | |
4302 | 1989-10-06 | 1995-12-31 | Lepon, McCarthy, White & Holzworth | 1225 19th Street, N.W. | Suite 600 | Washington | DC | 20036 | |
4766 | 1993-02-12 | 1996-08-31 | Johnson, Smith, Dover, Kitzmiller & Stewart, Inc. | 1300 Connecticut Avenue, N.W. | Suite 600 | Washington | DC | 20036 | |
4783 | 1993-03-26 | 1993-06-04 | McClure, Trotter & Mentz | 1100 Connecticut Avenue, N.W. | Suite 600 | Washington | DC | 20036 | |
4830 | 1993-05-13 | 1993-12-30 | McClure, Trotter & Mentz, Chartered | 1100 Connecticut Avenue, N.W. | Suite 600 | Washington | DC | 20036 | |
4922 | 1994-06-22 | 2001-02-08 | Federation of Electric Power Companies of Japan | 1901 L Street, N.W. | Suite 600 | Washington | DC | 20036 | |
5004 | 1995-03-13 | 1995-09-30 | Fratelli Group | 1300 Connecticut Avenue, N.W. | Suite 600 | Washington | DC | 20036 | |
5428 | 2001-05-07 | 2002-05-31 | Griffin, Johnson, Dover & Stewart Inc. | 1300 Connecticut Avenue, N.W. | Suite 600 | Washington | DC | 20036 | |
5447 | 2001-07-20 | 2002-01-31 | Fratelli Group | 1300 Connecticut Avenue N.W. | Suite 600 | Washington | DC | 20036 | |
5526 | 2002-10-18 | 2005-04-30 | Johnson, Madigan, Peck, Boland, Dover & Stewart, Inc. | 1300 Connecticut Avenue, N.W. | Suite 600 | Washington | DC | 20036 | |
5776 | 2006-11-17 | 2009-05-31 | Peck, Madigan, Jones & Stewart, Inc. | 1300 Connecticut Avenue, NW | Suite 600 | Washington | DC | 20036 | |
5795 | 2007-02-26 | 2008-04-23 | Dezenhall Resources, Ltd. | 1130 Connecticut Avenue, NW | Suite 600 | Washington | DC | 20036 | |
5799 | 2007-03-22 | 2007-04-30 | Fratelli Group | 1300 Connecticut Avenue, NW | Suite 600 | Washington | DC | 20036 | |
5965 | 2009-12-15 | 2017-10-31 | Hills Stern & Morley, LLP | 1850 M Street, NW | Suite 600 | Washington | DC | 20036 | |
6036 | 2011-04-22 | 2011-10-31 | Peck, Madigan, Jones & Stewart | 1300 Connecticut Avenue, NW | Suite 600 | Washington | DC | 20036 | |
6172 | 2013-06-10 | 2017-02-28 | Peck, Madigan, Jones & Stewart, Inc. | 1300 Connecticut Avenue, NW | Suite 600 | Washington | DC | 20036 | |
6506 | 2018-01-12 | 2020-01-31 | Manatt, Phelps & Phillips LLP | 1050 Connecticut Avenue, NW | Suite 600 | 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]) );