FARA_All_Registrants
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
10 rows where Address_1 = "801 Pennsylvania Avenue, N.W." and State = "DC" sorted by Registration_Number descending
This data as json, CSV (advanced)
Suggested facets: Address_2, Zip, Registration_Date (date), Termination_Date (date)
Registration_Number ▲ | Registration_Date | Termination_Date | Name | Business_Name | Address_1 | Address_2 | City | State | Zip |
---|---|---|---|---|---|---|---|---|---|
5450 | 2001-08-03 | 2005-03-30 | Wilson Associates, LLC | 801 Pennsylvania Avenue, N.W. | Suite 730 | Washington | DC | 20004 | |
5298 | 1999-01-28 | 2000-01-31 | Lonie, David Morrison | 801 Pennsylvania Avenue, N.W. | Suite 750 | Washington | DC | 20110 | |
5179 | 1997-05-12 | 2001-06-30 | Hooper, Owen & Winburn | 801 Pennsylvania Avenue, N.W. | Suite 730 | Washington | DC | 20004 | |
5025 | 1995-06-19 | 1995-11-15 | Fulbright & Jaworski, L.L.P. | 801 Pennsylvania Avenue, N.W. | Washington | DC | 20004 | ||
4971 | 1994-11-14 | 1996-05-31 | American Basque Foundation, Inc. | 801 Pennsylvania Avenue, N.W. | Suite 820 | Washington | DC | 20004 | |
4599 | 1991-11-08 | 1993-12-13 | European-American Chamber of Commerce in Washington, DC, Inc | 801 Pennsylvania Avenue, N.W. | Washington | DC | 20004 | ||
4414 | 1990-09-19 | 1996-02-09 | Hooper, Hooper, Owen & Gould | 801 Pennsylvania Avenue, N.W. | Suite 730 | Washington | DC | 20004 | |
4397 | 1990-07-12 | 1994-08-17 | Baker, Worthington, Crossley, Stansberry & Woolf | 801 Pennsylvania Avenue, N.W. | Suite 800 | Washington | DC | 20004 | |
4333 | 1990-01-17 | 1992-07-31 | Paul Laxalt Group | 801 Pennsylvania Avenue, N.W. | Suite 750 | Washington | DC | 20004-2167 | |
4208 | 1989-01-23 | 2000-01-23 | Shearman & Sterling | 801 Pennsylvania Avenue, N.W. | Suite 900 | Washington | DC | 20004-2604 |
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]) );