FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
8 rows where City = "New York" and Short_Form_First_Name = "William F."
This data as json, CSV (advanced)
Suggested facets: Address_2, Zip, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5697 | 5697 | 1974-02-01 | 1974-02-01 | Noonan | William F. | Burson-Marsteller 2364 | 1972-08-03 | Burson-Marsteller | 866 Third Avenue | New York | NY | 10022 | |
7054 | 7054 | 1970-02-16 | 1968-04-02 | Hill | William F. | Bronhill Associates, Inc. 2085 | 1968-04-02 | Bronhill Associates, Inc. | 666 Fifth Avenue | New York | NY | 10019 | |
9943 | 9943 | 1985-03-15 | 1980-12-01 | Griffith | William F. | Inter-American News Services, Inc. 3172 | 1980-12-01 | Inter-American News Services, Inc. | 720 Fifth Avenue | New York | NY | 10019 | |
10079 | 10079 | 2002-03-16 | 1984-10-16 | Mattes | William F. | DDB Worldwide Communications Group, Inc. 1066 | 1957-09-16 | DDB Worldwide Communications Group, Inc. | 437 Madison Avenue | New York | NY | 10022 | |
12678 | 12678 | 1980-04-03 | 1979-08-29 | Campbell | William F. | Bozell & Jacobs Public Relations, Inc. 3052 | 1979-08-29 | Bozell & Jacobs Public Relations, Inc. | 1 Dag Hammarskjold Plaza | New York | NY | 10017 | |
15396 | 15396 | 1989-05-01 | 1971-01-31 | Welch | William F. | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 301 East 57th Street | New York | NY | 10022 | |
22089 | 22089 | 1972-07-01 | 1972-02-23 | Shek | William F. | Hong Kong Trade Development Council, Inc. 2181 | 1970-01-19 | Hong Kong Trade Development Council, Inc. | 219 East 46th Street | New York | NY | 10017 | |
27743 | 27743 | 1974-08-30 | 1974-01-21 | Treadwell | William F. | Tea Council of the U.S.A., Inc. 1853 | 1965-02-10 | Tea Council of the U.S.A., Inc. | 420 Lexington Avenue | Suite 825 | New York | NY | 10170 |
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]) );