FARA_All_Registrants
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
9 rows where City = "Alexandria" and Zip = 22310 sorted by State
This data as json, CSV (advanced)
Suggested facets: Termination_Date, Name, Registration_Date (date), Termination_Date (date)
Registration_Number | Registration_Date | Termination_Date | Name | Business_Name | Address_1 | Address_2 | City | State ▼ | Zip |
---|---|---|---|---|---|---|---|---|---|
3165 | 1980-11-12 | 1988-08-01 | De Lopez, Sangwar | 6425 Carriage Drive | Alexandria | VA | 22310 | ||
4987 | 1995-01-30 | 1995-03-01 | Will Cofer Associates, Inc. | 4001 Pine Brook Road | Alexandria | VA | 22310 | ||
5155 | 1997-01-29 | 1999-12-31 | McCabe, Bernard J., Jr. | P.O. Box 30024 | Alexandria | VA | 22310 | ||
6717 | 2019-09-04 | 2019-12-31 | Lewis Jr., Robert E. | 5500 Layne Estate Ct. | Alexandria | VA | 22310 | ||
6940 | 2021-03-21 | 2022-08-16 | Williams, Stephen | 3306 Gentle Court | Alexandria | VA | 22310 | ||
7006 | 2021-09-01 | 2022-08-22 | Strom Public Affairs | 5500 Layne Estates Court | Alexandria | VA | 22310 | ||
7012 | 2021-09-06 | Wissler, John Eric | 6310 Maryview Street | Alexandria | VA | 22310 | |||
7066 | 2022-01-04 | 2022-12-31 | The Van Aucker Group | 5500 Layne Estates Court | Alexandria | VA | 22310 | ||
7260 | 2023-04-18 | The Van Aucker Group | 5500 Layne Estates Court | Alexandria | VA | 22310 |
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]) );