FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
10 rows where Short_Form_Last_Name = "Smith" and State = "VA"
This data as json, CSV (advanced)
Suggested facets: Address_1, Address_2, Zip
Registration_Number 10
Registrant_Name 8
City 5
- Arlington 4
- Alexandria 3
- Dulles 1
- Fairfax 1
- Reston 1
State 1
- VA · 10 ✖
Link | rowid ▼ | Short_Form_Termination_Date | Short_Form_Date | Short_Form_Last_Name | Short_Form_First_Name | Registration_Number | Registration_Date | Registrant_Name | Address_1 | Address_2 | City | State | Zip |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8597 | 8597 | 2020-02-29 | 2019-11-04 | Smith | Nicole | Miller/Wenhold Capitol Strategies 6640 | 2019-02-21 | Miller/Wenhold Capitol Strategies | 10340 Democracy Lane | Suite 300 | Fairfax | VA | 22030 |
8866 | 8866 | 2009-03-01 | 2009-04-28 | Smith | Clifton | Alcalde & Fay, Ltd. 5898 | 2008-12-09 | Alcalde & Fay, Ltd. | 2111 Wilson Boulevard | 8th Floor | Arlington | VA | 22201 |
9048 | 9048 | 1994-03-03 | 1992-05-21 | Smith | David S. | International Registries, Inc. 4533 | 1991-07-01 | International Registries, Inc. | 11495 Commerce Park Drive | Reston | VA | 20191-1506 | |
10176 | 10176 | 2023-03-17 | 2021-07-26 | Smith | Dallas Duane | LISCR, LLC 5490 | 2002-04-02 | LISCR, LLC | 22980 Indian Creek Drive | Suite 200 | Dulles | VA | 20166 |
11167 | 11167 | 1993-03-30 | 1993-03-30 | Smith | J. Brian | Smith & Harroff, Inc. 4765 | 1993-02-09 | Smith & Harroff, Inc. | 11 Canal Center Plaza | Suite 104 | Alexandria | VA | 22314 |
14967 | 14967 | 2008-04-30 | 2008-04-15 | Smith | J. Brian | Smith & Harroff, Inc. 5862 | 2008-04-15 | Smith & Harroff, Inc. | 99 Canal Center Plaza | #310 | Alexandria | VA | 22314 |
21018 | 21018 | 1984-06-30 | 1983-02-24 | Smith | Arnold | Bronz & Farrell 1740 | 1964-05-22 | Bronz & Farrell | 1735 Jefferson Davis Highway | Suite 200 | Arlington | VA | 22202 |
29851 | 29851 | 1988-09-15 | 1987-06-29 | Smith | J. Brian | Smith & Harroff, Inc. 4000 | 1987-06-29 | Smith & Harroff, Inc. | 11 Canal Center Plaza | Suite 104 | Alexandria | VA | 22314 |
34238 | 34238 | 1983-10-31 | 1976-06-07 | Smith | Hilton C. | American Trade & Finance Company 2692 | 1976-05-19 | American Trade & Finance Company | 2001 Jefferson Davis Highway | Room 603 | Arlington | VA | 22202 |
37609 | 37609 | 1985-12-02 | 1984-03-14 | Smith | Robert William | Alcalde & Fay 3571 | 1984-03-14 | Alcalde & Fay | 2111 Wilson Boulevard | Suite 850 | Arlington | VA | 22201 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [FARA_All_ShortForms] ( [Short_Form_Termination_Date] TEXT, [Short_Form_Date] TEXT, [Short_Form_Last_Name] TEXT, [Short_Form_First_Name] TEXT, [Registration_Number] INTEGER, [Registration_Date] TEXT, [Registrant_Name] TEXT, [Address_1] TEXT, [Address_2] TEXT, [City] TEXT, [State] TEXT, [Zip] TEXT, FOREIGN KEY([Registration_Number]) REFERENCES [FARA_All_Registrants]([Registration_Number]) );