FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
6 rows where Short_Form_Date = "2019-05-16" and "Short_Form_Date" is on date 2019-05-16
This data as json, CSV (advanced)
Suggested facets: Short_Form_Termination_Date, Address_1, Address_2, Short_Form_Termination_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8391 | 8391 | 2020-02-28 | 2019-05-16 | Hopcraft | Ross | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
13935 | 13935 | 2020-04-22 | 2019-05-16 | Crosby | William D. | Livingston Group, LLC 6344 | 2016-03-25 | Livingston Group, LLC | 499 S. Capitol Street, SW | Suite 600 | Washington | DC | 20003 |
16349 | 16349 | 2022-05-14 | 2019-05-16 | Ban | Hocheol | Korea National Tourism Organization, New Jersey 2614 | 1975-10-04 | Korea National Tourism Organization, New Jersey | 400 Kelby Street | Suite 1602 | Fort Lee | NJ | 07024 |
20060 | 20060 | 2019-06-22 | 2019-05-16 | Shuman | Katherine | Audience Partners Worldwide LLC 6657 | 2019-04-08 | Audience Partners Worldwide LLC | 630 W. Germantown Avenue | Suite 250 | Plymouth Meeting | PA | 19462 |
22381 | 22381 | 2021-07-01 | 2019-05-16 | Bigham | Madison | GMJ Global, LLC 6612 | 2018-12-06 | GMJ Global, LLC | 202 Hilltop Drive | Nyack | NJ | 10960 | |
22382 | 22382 | 2021-07-01 | 2019-05-16 | Blandon | Pamela | GMJ Global, LLC 6612 | 2018-12-06 | GMJ Global, LLC | 202 Hilltop Drive | Nyack | NJ | 10960 |
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]) );