FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
20 rows where Address_2 = "Suite 810" and State = "DC"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Date, Registration_Date, Zip, Short_Form_Date (date), Registration_Date (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8835 | 8835 | 2004-03-01 | 2003-08-07 | Cushing | Mark | Winstead Consulting Group LLC 5573 | 2003-08-07 | Winstead Consulting Group LLC | 1450 G Street, N.W. | Suite 810 | Washington | DC | 20005 |
8836 | 8836 | 2004-03-01 | 2003-08-07 | Flukinger | Scott | Winstead Consulting Group LLC 5573 | 2003-08-07 | Winstead Consulting Group LLC | 1450 G Street, N.W. | Suite 810 | Washington | DC | 20005 |
8837 | 8837 | 2004-03-01 | 2003-08-07 | Grainger | Amanda | Winstead Consulting Group LLC 5573 | 2003-08-07 | Winstead Consulting Group LLC | 1450 G Street, N.W. | Suite 810 | Washington | DC | 20005 |
8838 | 8838 | 2004-03-01 | 2003-08-07 | Hanson | Jill | Winstead Consulting Group LLC 5573 | 2003-08-07 | Winstead Consulting Group LLC | 1450 G Street, N.W. | Suite 810 | Washington | DC | 20005 |
8839 | 8839 | 2004-03-01 | 2003-08-07 | LaForge | Bill | Winstead Consulting Group LLC 5573 | 2003-08-07 | Winstead Consulting Group LLC | 1450 G Street, N.W. | Suite 810 | Washington | DC | 20005 |
8840 | 8840 | 2004-03-01 | 2003-08-07 | McClure | Fred | Winstead Consulting Group LLC 5573 | 2003-08-07 | Winstead Consulting Group LLC | 1450 G Street, N.W. | Suite 810 | Washington | DC | 20005 |
12460 | 12460 | 1986-04-01 | 1985-06-07 | Lukis | Sylvester | U.S.-China - Shantou Technology Trade & Investment Resources 3688 | 1985-06-07 | U.S.-China - Shantou Technology Trade & Investment Resources | 2000 L Street, N.W. | Suite 810 | Washington | DC | 20036 |
17223 | 17223 | 1982-05-27 | 1980-08-08 | Barnett | Robert E. | Barnett, Yingling & Shay, P.C. 3136 | 1980-08-08 | Barnett, Yingling & Shay, P.C. | 1090 Vermont Avenue, N.W. | Suite 810 | Washington | DC | 20005 |
17224 | 17224 | 1982-05-27 | 1980-08-08 | Yingling | Edward L. | Barnett, Yingling & Shay, P.C. 3136 | 1980-08-08 | Barnett, Yingling & Shay, P.C. | 1090 Vermont Avenue, N.W. | Suite 810 | Washington | DC | 20005 |
19017 | 19017 | 1988-06-07 | 1987-03-18 | Luh | Bor H. | U.S.-China - Shantou Technology Trade & Investment Resources 3688 | 1985-06-07 | U.S.-China - Shantou Technology Trade & Investment Resources | 2000 L Street, N.W. | Suite 810 | Washington | DC | 20036 |
19018 | 19018 | 1988-06-07 | 1985-12-02 | Post | William Noble , II | U.S.-China - Shantou Technology Trade & Investment Resources 3688 | 1985-06-07 | U.S.-China - Shantou Technology Trade & Investment Resources | 2000 L Street, N.W. | Suite 810 | Washington | DC | 20036 |
23243 | 23243 | 1988-07-15 | 1986-02-04 | Williams | Eleazer A. | U.S.-China - Shantou Technology Trade & Investment Resources 3688 | 1985-06-07 | U.S.-China - Shantou Technology Trade & Investment Resources | 2000 L Street, N.W. | Suite 810 | Washington | DC | 20036 |
23248 | 23248 | 1988-07-15 | 1985-06-07 | Chen | Richard | U.S.-China - Shantou Technology Trade & Investment Resources 3688 | 1985-06-07 | U.S.-China - Shantou Technology Trade & Investment Resources | 2000 L Street, N.W. | Suite 810 | Washington | DC | 20036 |
23249 | 23249 | 1988-07-15 | 1985-06-07 | Cramer | William C. | U.S.-China - Shantou Technology Trade & Investment Resources 3688 | 1985-06-07 | U.S.-China - Shantou Technology Trade & Investment Resources | 2000 L Street, N.W. | Suite 810 | Washington | DC | 20036 |
23250 | 23250 | 1988-07-15 | 1985-06-12 | Cramer | Mark C. | U.S.-China - Shantou Technology Trade & Investment Resources 3688 | 1985-06-07 | U.S.-China - Shantou Technology Trade & Investment Resources | 2000 L Street, N.W. | Suite 810 | Washington | DC | 20036 |
23251 | 23251 | 1988-07-15 | 1985-06-13 | Chen | Agnes | U.S.-China - Shantou Technology Trade & Investment Resources 3688 | 1985-06-07 | U.S.-China - Shantou Technology Trade & Investment Resources | 2000 L Street, N.W. | Suite 810 | Washington | DC | 20036 |
28489 | 28489 | 2006-08-31 | 2005-12-23 | Stanton | Peter V. | Stanton Communications 5724 | 2005-12-23 | Stanton Communications | 1150 Connecticut Avenue, NW | Suite 810 | Washington | DC | 20036 |
40627 | 40627 | 1990-12-31 | 1990-06-20 | Davis | Susan | Capitol Resources Group 4386 | 1990-06-20 | Capitol Resources Group | 1155 - 15th Street, N.W. | Suite 810 | Washington | DC | 20005 |
40628 | 40628 | 1990-12-31 | 1990-06-20 | Govan | Michael J. | Capitol Resources Group 4386 | 1990-06-20 | Capitol Resources Group | 1155 - 15th Street, N.W. | Suite 810 | Washington | DC | 20005 |
40630 | 40630 | 1990-12-31 | 1990-06-20 | Nunes | H. James | Capitol Resources Group 4386 | 1990-06-20 | Capitol Resources Group | 1155 - 15th Street, N.W. | Suite 810 | Washington | DC | 20005 |
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]) );