FARA_All_Registrants
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
118 rows where City = "Alexandria"
This data as json, CSV (advanced)
Address_1 16
- 5500 Layne Estates Court 3
- 1423 Powhatan Street 1
- 1803 Olive Court 1
- 2111 Eisenhower Avenue 1
- 2503 Hayes Street 1
- 277 S. Pickett Street 1
- 301 South Saint Asaph Street 1
- 3306 Gentle Court 1
- 4218 Dandridge Terrace 1
- 5001 Rosemont Avenue 1
- 520 North Washington Street 1
- 5500 Layne Estate Ct. 1
- 6019 Tower Court 1
- 6310 Maryview Street 1
- 6511 Princeton Drive 1
- 703 Norfolk Lane 1
State 1
- VA 18
City 1
- Alexandria · 18 ✖
Registration_Number ▼ | Registration_Date | Termination_Date | Name | Business_Name | Address_1 | Address_2 | City | State | Zip |
---|---|---|---|---|---|---|---|---|---|
6525 | 2018-02-14 | 2018-03-31 | Chwat, John | 1423 Powhatan Street | Suite 1 | Alexandria | VA | 22314 | |
6541 | 2018-04-13 | 2018-05-22 | Amagai Policy Advisors LLC | 4218 Dandridge Terrace | Alexandria | VA | 22309 | ||
6602 | 2018-10-19 | Corallo Media Strategies, Inc | 520 North Washington Street | Alexandria | VA | 22314 | |||
6606 | 2018-11-05 | 2019-04-01 | Courville Consultants, LLC | 277 S. Pickett Street | Unit 402 | Alexandria | VA | 22304 | |
6626 | 2019-01-08 | Robert G. Joseph | 301 South Saint Asaph Street | Alexandria | VA | 22314 | |||
6695 | 2019-06-26 | 2019-12-31 | Long, KaLeigh | 5001 Rosemont Avenue | Alexandria | VA | 22309 | ||
6717 | 2019-09-04 | 2019-12-31 | Lewis Jr., Robert E. | 5500 Layne Estate Ct. | Alexandria | VA | 22310 | ||
6798 | 2020-03-05 | Somaliland Mission USA, LLC | 6019 Tower Court | Alexandria | VA | 22304 | |||
6844 | 2020-07-15 | 2022-11-30 | Blueprint Communications, LLC | 2111 Eisenhower Avenue | Suite 400 | Alexandria | VA | 22314 | |
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 | |||
7016 | 2021-09-19 | 2021-12-31 | MWM Murray Consulting, LLC | 6511 Princeton Drive | Alexandria | VA | 22307 | ||
7046 | 2021-11-15 | The Gallagher Group, LLC | 2503 Hayes Street | Alexandria | VA | 22302 | |||
7066 | 2022-01-04 | 2022-12-31 | The Van Aucker Group | 5500 Layne Estates Court | Alexandria | VA | 22310 | ||
7245 | 2023-03-16 | The Marshall Harris Group | 703 Norfolk Lane | Alexandria | VA | 22314 | |||
7260 | 2023-04-18 | The Van Aucker Group | 5500 Layne Estates Court | Alexandria | VA | 22310 | |||
7276 | 2023-05-19 | Ambrose Partners LLC | 1803 Olive Court | Alexandria | VA | 22308 |
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]) );