FARA_All_Registrants
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
10 rows where Address_2 = "7th Floor" and City = "Washington" sorted by Address_1
This data as json, CSV (advanced)
Suggested facets: Name, Zip, Termination_Date (date)
Registration_Date (date) 10 ✖
- 1964-11-13 1
- 1983-04-20 1
- 1988-01-22 1
- 1990-05-24 1
- 1992-07-27 1
- 2013-04-08 1
- 2013-09-16 1
- 2016-06-06 1
- 2016-06-10 1
- 2020-11-03 1
Address_1 7
State 1
- DC 10
City 1
- Washington · 10 ✖
Registration_Number | Registration_Date | Termination_Date | Name | Business_Name | Address_1 ▼ | Address_2 | City | State | Zip |
---|---|---|---|---|---|---|---|---|---|
3458 | 1983-04-20 | 1984-06-30 | Van Ness, Feldman, Sutcliffe, Curtis & Levenberg | 1050 Thomas Jeff. Street, N.W. | 7th Floor | Washington | DC | 20007 | |
4085 | 1988-01-22 | 1990-02-21 | Van Ness, Feldman & Curtis, P.C. | 1050 Thomas Jeff. Street, N.W. | 7th Floor | Washington | DC | 20007 | |
4379 | 1990-05-24 | 1991-12-20 | Van Ness, Feldman & Curtis, P.C. | 1050 Thomas Jeff. Street, N.W. | 7th Floor | Washington | DC | 20007 | |
4696 | 1992-07-27 | 1997-07-31 | Van Ness, Feldman, A Professional Corporation | 1050 Thomas Jefferson Street, N.W. | 7th Floor | Washington | DC | 20007-3877 | |
6163 | 2013-04-08 | 2015-06-30 | Bryan Cave, LLP | 1155 F Street, NW | 7th Floor | Washington | DC | 20004 | |
6356 | 2016-06-06 | 2019-04-18 | Bryan Cave, LLP | 1155 F Street, NW | 7th Floor | Washington | DC | 20004 | |
1815 | 1964-11-13 | 1994-12-13 | Prather, Seeger, Doolittle & Farmer | 1600 M Street, N.W. | 7th Floor | Washington | DC | 20036 | |
6358 | 2016-06-10 | 2016-08-01 | Peter Mirijanian Public Affairs | 1776 K Street, NW | 7th Floor | Washington | DC | 20006 | |
6883 | 2020-11-03 | 2020-11-20 | Consilio Group | 20 F Street, NW | 7th Floor | Washington | DC | 20001-6700 | |
6188 | 2013-09-16 | 2013-12-31 | Carmen Group, Inc. | 505 9th Street, NW | 7th Floor | Washington | DC | 20004 |
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]) );