FARA_All_Registrants
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
13 rows where Address_1 = "1001 Pennsylvania Avenue, N.W." and State = "DC" sorted by City
This data as json, CSV (advanced)
Suggested facets: Name, Business_Name, Address_2, Zip, Registration_Date (date)
Termination_Date (date) 12 ✖
- 1991-05-06 1
- 1992-12-21 1
- 1993-08-13 1
- 1993-09-01 1
- 1994-01-31 1
- 1994-04-15 1
- 1994-09-15 1
- 1994-11-30 1
- 1995-01-11 1
- 1995-05-03 1
- 1997-11-30 1
- 2002-09-10 1
State 1
- DC · 13 ✖
City 1
- Washington 13
Address_1 1
- 1001 Pennsylvania Avenue, N.W. · 13 ✖
Registration_Number | Registration_Date | Termination_Date | Name | Business_Name | Address_1 | Address_2 | City ▼ | State | Zip |
---|---|---|---|---|---|---|---|---|---|
3274 | 1981-09-10 | 2002-09-10 | Powell, Goldstein, Frazer & Murphy, L.L.P. | 1001 Pennsylvania Avenue, N.W. | 6th Floor, South | Washington | DC | 20004 | |
3473 | 1983-05-20 | 1992-12-21 | Fried, Frank, Harris, Shriver & Jacobson | 1001 Pennsylvania Avenue, N.W. | Suite 800 | Washington | DC | 20004-2505 | |
3956 | 1987-04-01 | 1991-05-06 | Jack H. McDonald Company | 1001 Pennsylvania Avenue, N.W. | Suite 625 South | Washington | DC | 20004 | |
3987 | 1987-05-29 | 1994-09-15 | Crowell & Moring | 1001 Pennsylvania Avenue, N.W. | 10th Floor | Washington | DC | 20004-2595 | |
3988 | 1987-05-28 | Crowell & Moring International, LLC | C&M International, Ltd. | 1001 Pennsylvania Avenue, N.W. | Suite 1275 | Washington | DC | 20004-2595 | |
4682 | 1992-06-08 | 1993-09-01 | Capitol Group, Inc. | 1001 Pennsylvania Avenue, N.W. | Suite 1385 | Washington | DC | 20004 | |
4779 | 1993-03-15 | 1994-04-15 | Saul, Ewing, Remick & Saul | 1001 Pennsylvania Avenue, N.W. | Suite 850, North Tower | Washington | DC | 20004 | |
4810 | 1993-05-28 | 1993-08-13 | Hofman, Steven I. | 1001 Pennsylvania Avenue, N.W. | Suite 350 N | Washington | DC | 20004 | |
4821 | 1993-06-23 | 1995-01-11 | Fried, Frank, Harris, Shriver & Jacobson | 1001 Pennsylvania Avenue, N.W. | Suite 800 | Washington | DC | 20004-2505 | |
4849 | 1993-09-17 | 1994-01-31 | Law Firm of Latham & Watkins, a Partnership | 1001 Pennsylvania Avenue, N.W. | 13th Floor | Washington | DC | 20004-2505 | |
4958 | 1994-10-03 | 1995-05-03 | Crowell & Moring | 1001 Pennsylvania Avenue, N.W. | Washington | DC | 20004-2595 | ||
4970 | 1994-11-08 | 1994-11-30 | Deloitte & Touche, L.L.P. | 1001 Pennsylvania Avenue, N.W. | Suite 350 North | Washington | DC | 20004-2505 | |
5082 | 1995-11-29 | 1997-11-30 | Mahoney, Maureen E. | 1001 Pennsylvania Avenue, N.W. | Suite 1300 | 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]) );