FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
11 rows where Address_2 = "Suite 110G" and State = "DC"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Termination_Date, Short_Form_Date, Short_Form_Termination_Date (date), Short_Form_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3636 | 3636 | 2018-01-12 | 2017-10-24 | Held | Elizabeth | White House Writers Group, Inc. 6477 | 2017-10-24 | White House Writers Group, Inc. | 1025 Thomas Jefferson Street, NW | Suite 110G | Washington | DC | 20007 |
9288 | 9288 | 2020-03-06 | 2018-03-08 | Schneider | Emily | White House Writers Group, Inc. 6477 | 2017-10-24 | White House Writers Group, Inc. | 1025 Thomas Jefferson Street, NW | Suite 110G | Washington | DC | 20007 |
14310 | 14310 | 2020-04-28 | 2018-01-29 | Cialdella | Michael | White House Writers Group, Inc. 6477 | 2017-10-24 | White House Writers Group, Inc. | 1025 Thomas Jefferson Street, NW | Suite 110G | Washington | DC | 20007 |
14311 | 14311 | 2020-04-28 | 2018-03-08 | van Schaijik | Lucy | White House Writers Group, Inc. 6477 | 2017-10-24 | White House Writers Group, Inc. | 1025 Thomas Jefferson Street, NW | Suite 110G | Washington | DC | 20007 |
14312 | 14312 | 2020-04-28 | 2018-08-02 | McGrath Jr. | C. Dean | White House Writers Group, Inc. 6477 | 2017-10-24 | White House Writers Group, Inc. | 1025 Thomas Jefferson Street, NW | Suite 110G | Washington | DC | 20007 |
14313 | 14313 | 2020-04-28 | 2018-08-09 | Styrna | Pawel | White House Writers Group, Inc. 6477 | 2017-10-24 | White House Writers Group, Inc. | 1025 Thomas Jefferson Street, NW | Suite 110G | Washington | DC | 20007 |
14314 | 14314 | 2020-04-28 | 2017-10-24 | Hughes | G. Philip | White House Writers Group, Inc. 6477 | 2017-10-24 | White House Writers Group, Inc. | 1025 Thomas Jefferson Street, NW | Suite 110G | Washington | DC | 20007 |
14315 | 14315 | 2020-04-28 | 2017-10-24 | Judge | Clark S. | White House Writers Group, Inc. 6477 | 2017-10-24 | White House Writers Group, Inc. | 1025 Thomas Jefferson Street, NW | Suite 110G | Washington | DC | 20007 |
14316 | 14316 | 2020-04-28 | 2017-10-24 | Sabas | Matthew | White House Writers Group, Inc. 6477 | 2017-10-24 | White House Writers Group, Inc. | 1025 Thomas Jefferson Street, NW | Suite 110G | Washington | DC | 20007 |
14317 | 14317 | 2020-04-28 | 2017-10-24 | Wellisz | Anna Chodakiewicz | White House Writers Group, Inc. 6477 | 2017-10-24 | White House Writers Group, Inc. | 1025 Thomas Jefferson Street, NW | Suite 110G | Washington | DC | 20007 |
14318 | 14318 | 2020-04-28 | 2018-10-31 | Jablonska | Monika | White House Writers Group, Inc. 6477 | 2017-10-24 | White House Writers Group, Inc. | 1025 Thomas Jefferson Street, NW | Suite 110G | Washington | DC | 20007 |
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]) );