FARA_All_Registrants
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
15 rows where City = "Washington" and Zip = 20024
This data as json, CSV (advanced)
Suggested facets: Termination_Date, Name, Address_2, Registration_Date (date), Termination_Date (date)
Registration_Number ▼ | Registration_Date | Termination_Date | Name | Business_Name | Address_1 | Address_2 | City | State | Zip |
---|---|---|---|---|---|---|---|---|---|
2570 | 1975-04-01 | 1979-09-26 | Cramer & Lipsen | 475 L'Enfant Plaza, S.W. | Suite 4100 | Washington | DC | 20024 | |
2808 | 1977-07-22 | 1980-12-31 | Nicaraguan-American Trade Council | 475 L'Enfant Plaza, S.W. | Washington | DC | 20024 | ||
3166 | 1980-11-17 | 1981-04-15 | Synergistic Solutions, Inc. | 510 N Street, S.W. | Suite N-622 | Washington | DC | 20024 | |
3207 | 1981-03-09 | 1982-11-08 | Carter, Robert S. | 700 - 7th Street, S.W. | Washington | DC | 20024 | ||
3246 | 1981-06-10 | 1984-06-12 | Arthur A. Fletcher & Associates | 513 G Street, S.W. | Washington | DC | 20024 | ||
3375 | 1982-05-28 | 1983-04-19 | Holland & Knight | 600 Maryland Avenue, S.W. | Suite 700 | Washington | DC | 20024 | |
3592 | 1984-06-04 | 1984-11-02 | Schlossberg-Cassidy & Associates, Inc. | 955 L'Enfant Plaza North, S.W. | Suite 1401 | Washington | DC | 20024 | |
3854 | 1986-07-11 | 1988-06-30 | South/North Development Group, Ltd. | 610 - 4th Place, S.W. | Washington | DC | 20024 | ||
4219 | 1989-02-21 | 1990-03-06 | South/North Development Group, Ltd. | 610 - 4th Place, S.W. | Washington | DC | 20024 | ||
4836 | 1993-08-02 | 1993-08-31 | James, John D. | 116 G Street, S.W. | Washington | DC | 20024 | ||
5401 | 2000-12-14 | 2021-12-31 | Van Scoyoc Associates, Inc. | 800 Maine Avenue, SW | Suite 800 | Washington | DC | 20024 | |
6401 | 2017-01-20 | Cornerstone Government Affairs | 800 Maine Avenue, SW | Floor 7 | Washington | DC | 20024 | ||
6408 | 2017-03-14 | DiNino Associates, LLC | 800 Maine Avenue, SW | Floor 7 | Washington | DC | 20024 | ||
6516 | 2018-01-31 | U.S. Mission of the Syrian Democratic Council | 800 Maine Avenue, SW | Suite 200 | Washington | DC | 20024 | ||
7088 | 2022-03-04 | 2022-06-02 | LobbyDC.com LLC dba Raffaniello & Associates, LLC | 800 Maine Avenue, SW | Suite 700 | Washington | DC | 20024 |
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]) );