FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
9 rows where City = "New York" and Short_Form_First_Name = "John D."
This data as json, CSV (advanced)
Suggested facets: Address_1, Address_2, Zip, Short_Form_Termination_Date (date), 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4101 | 4101 | 1996-01-19 | 1991-08-12 | Bergen | John D. | GCI Group, Inc. 3856 | 1986-07-11 | GCI Group, Inc. | 825 Third Avenue | 24th Floor | New York | NY | 10022-7519 |
15637 | 15637 | 1994-05-03 | 1974-08-12 | Walker | John D. | Ogilvy & Mather U.S., a Division of The Ogilvy Group, Inc. 2530 | 1974-08-12 | Ogilvy & Mather U.S., a Division of The Ogilvy Group, Inc. | 309 West 49th Street | Worldwide Plaza | New York | NY | 10019-7399 |
20837 | 20837 | 1971-06-30 | 1970-10-20 | Walker | John D. | Ogilvy & Mather, Inc. 1826 | 1964-12-03 | Ogilvy & Mather, Inc. | 2 East 48th Street | New York | NY | 10017 | |
22711 | 22711 | 1994-07-07 | 1993-05-11 | Forbes | John D. | GCI Group, Inc. 3856 | 1986-07-11 | GCI Group, Inc. | 825 Third Avenue | 24th Floor | New York | NY | 10022-7519 |
26155 | 26155 | 1981-08-07 | 1981-03-23 | Husband | John D. | Doremus & Company 2319 | 1972-02-18 | Doremus & Company | 120 Broadway | New York | NY | 10271 | |
34006 | 34006 | 1958-10-30 | 1957-05-18 | Wareham | John D. | Pan-American Public Relations, Ltd. 1019 | 1957-04-30 | Pan-American Public Relations, Ltd. | 375 Fifth Avenue | New York | NY | ||
39379 | 39379 | 1988-12-30 | 1973-04-10 | Humphrys | John D. | U.S. Office of the British Broadcasting Corporation 505 | 1947-12-01 | U.S. Office of the British Broadcasting Corporation | 630 Fifth Avenue | New York | NY | 10111 | |
40257 | 40257 | 1983-12-31 | 1982-06-21 | Lynch | John D. | Jamaica Tourist Board, New York 1445 | 1961-05-03 | Jamaica Tourist Board, New York | 767 Third Avenue | 2nd Floor, Suite 2127 | New York | NY | 10017 |
40700 | 40700 | 1991-12-31 | 1985-08-13 | Rasmussen | John D. | New Zealand Tourist & Publicity Office 2328 | 1972-03-27 | New Zealand Tourist & Publicity Office | 630 Fifth Avenue | Suite 530 | New York | NY | 10111 |
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]) );