FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
19 rows where Address_2 = "Suite 505" and City = "Washington"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Date, Short_Form_First_Name, Registration_Date, Zip
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
874 | 874 | 2023-04-25 | Hindin | Zachary | West Wing Writers, LLC 6367 | 2016-08-10 | West Wing Writers, LLC | 1150 Connecticut Avenue, NW | Suite 505 | Washington | DC | 20036 | |
1586 | 1586 | 2016-08-10 | Farber | Annie | West Wing Writers, LLC 6367 | 2016-08-10 | West Wing Writers, LLC | 1150 Connecticut Avenue, NW | Suite 505 | Washington | DC | 20036 | |
1587 | 1587 | 2016-08-10 | LaFleur | Vinca | West Wing Writers, LLC 6367 | 2016-08-10 | West Wing Writers, LLC | 1150 Connecticut Avenue, NW | Suite 505 | Washington | DC | 20036 | |
1795 | 1795 | 2019-09-16 | Davis Van Atta | Casey | West Wing Writers, LLC 6367 | 2016-08-10 | West Wing Writers, LLC | 1150 Connecticut Avenue, NW | Suite 505 | Washington | DC | 20036 | |
2612 | 2612 | 1983-01-01 | 1980-01-21 | Yuan | John C. C. | United Friends, Inc. 3083 | 1980-01-21 | United Friends, Inc. | 1511 K Street, N.W. | Suite 505 | Washington | DC | 20005 |
2884 | 2884 | 2011-01-01 | 2008-03-04 | LaFleur | Vinca | West Wing Writers, LLC 5838 | 2007-11-09 | West Wing Writers, LLC | 1150 Connecticut Avenue, NW | Suite 505 | Washington | DC | 20036 |
2886 | 2886 | 2011-01-01 | 2008-06-30 | Orzulak | Paul | West Wing Writers, LLC 5838 | 2007-11-09 | West Wing Writers, LLC | 1150 Connecticut Avenue, NW | Suite 505 | Washington | DC | 20036 |
2891 | 2891 | 2011-01-01 | 2007-11-09 | Shesol | Jeff | West Wing Writers, LLC 5838 | 2007-11-09 | West Wing Writers, LLC | 1150 Connecticut Avenue, NW | Suite 505 | Washington | DC | 20036 |
5908 | 5908 | 2020-02-01 | 2019-10-22 | Heng Devan | Shaan | West Wing Writers, LLC 6367 | 2016-08-10 | West Wing Writers, LLC | 1150 Connecticut Avenue, NW | Suite 505 | Washington | DC | 20036 |
11522 | 11522 | 1983-03-31 | 1980-01-21 | Lo | G. S. | United Friends, Inc. 3083 | 1980-01-21 | United Friends, Inc. | 1511 K Street, N.W. | Suite 505 | Washington | DC | 20005 |
12598 | 12598 | 2020-04-01 | 2018-04-27 | Graham | Katherine Childs | West Wing Writers, LLC 6367 | 2016-08-10 | West Wing Writers, LLC | 1150 Connecticut Avenue, NW | Suite 505 | Washington | DC | 20036 |
25655 | 25655 | 2008-08-01 | 2008-03-04 | Rooney | Megan | West Wing Writers, LLC 5838 | 2007-11-09 | West Wing Writers, LLC | 1150 Connecticut Avenue, NW | Suite 505 | Washington | DC | 20036 |
29099 | 29099 | 1981-09-03 | 1981-03-27 | O'Connell | Terrence M. , II | Keefe Company 3217 | 1981-03-27 | Keefe Company | 1625 Massachusetts Avenue, NW | Suite 505 | Washington | DC | 20036 |
29100 | 29100 | 1981-09-03 | 1981-03-27 | Hickman | Bert Ingalls , Jr. | Keefe Company 3217 | 1981-03-27 | Keefe Company | 1625 Massachusetts Avenue, NW | Suite 505 | Washington | DC | 20036 |
29101 | 29101 | 1981-09-03 | 1981-03-27 | Keefe | Robert J. | Keefe Company 3217 | 1981-03-27 | Keefe Company | 1625 Massachusetts Avenue, NW | Suite 505 | Washington | DC | 20036 |
34636 | 34636 | 2011-10-31 | 2011-10-19 | Shesol | Jeff | West Wing Writers, LLC 6072 | 2011-10-19 | West Wing Writers, LLC | 1150 Connecticut Avenue, NW | Suite 505 | Washington | DC | 20036 |
40451 | 40451 | 1988-12-31 | 1980-01-21 | Hu | Tsu-Wang | United Friends, Inc. 3083 | 1980-01-21 | United Friends, Inc. | 1511 K Street, N.W. | Suite 505 | Washington | DC | 20005 |
41868 | 41868 | 2013-12-31 | 2012-06-06 | Shesol | Jeffrey | West Wing Writers, LLC 6107 | 2012-06-06 | West Wing Writers, LLC | 1150 Connecticut Avenue, NW | Suite 505 | Washington | DC | 20036 |
41870 | 41870 | 2013-12-31 | 2012-06-25 | Karlin-Neumann | Zev | West Wing Writers, LLC 6107 | 2012-06-06 | West Wing Writers, LLC | 1150 Connecticut Avenue, NW | Suite 505 | Washington | DC | 20036 |
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]) );