FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
11 rows where City = "New York" and Short_Form_First_Name = "William G."
This data as json, CSV (advanced)
Suggested facets: Short_Form_Last_Name, Address_1, Zip, Short_Form_Termination_Date (date), Short_Form_Date (date), Registration_Date (date)
Registration_Number 11
- Netherlands Chamber of Commerce in the U.S., Inc. 1
- Reich, Magdalene B. 1
- Baar, Bennett & Fullen 1
- Baar, Bennett & Fullen 1
- Kramer, Marx, Greenlee & Backus 1
- Casey, Lane & Mittendorf 1
- Quebec Government Office 1
- Government of Ontario, Canada 1
- Jamaica National Investment Promotion, Ltd. 1
- Saatchi & Saatchi North America, Inc. 1
- Kreab Gavin Anderson (USA), Inc. 1
Registrant_Name 10
- Baar, Bennett & Fullen 2
- Casey, Lane & Mittendorf 1
- Government of Ontario, Canada 1
- Jamaica National Investment Promotion, Ltd. 1
- Kramer, Marx, Greenlee & Backus 1
- Kreab Gavin Anderson (USA), Inc. 1
- Netherlands Chamber of Commerce in the U.S., Inc. 1
- Quebec Government Office 1
- Reich, Magdalene B. 1
- Saatchi & Saatchi North America, Inc. 1
State 1
- NY 11
City 1
- New York · 11 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7754 | 7754 | 1953-02-27 | 1952-01-25 | Fullen | William G. | Baar, Bennett & Fullen 712 | 1952-01-25 | Baar, Bennett & Fullen | 29 Broadway | New York | NY | ||
9010 | 9010 | 1977-03-03 | 1973-07-02 | Reich | William G. | Reich, Magdalene B. 652 | 1950-11-29 | Reich, Magdalene B. | 1220 Second Avenue | New York | NY | 10012 | |
16837 | 16837 | 2009-05-21 | 2007-08-09 | McBride | William G. | Kreab Gavin Anderson (USA), Inc. 5824 | 2007-08-09 | Kreab Gavin Anderson (USA), Inc. | 515 Madison Avenue | 18th Floor | New York | NY | 10022 |
20281 | 20281 | 1975-06-26 | 1967-11-13 | Blake | William G. | Netherlands Chamber of Commerce in the U.S., Inc. 456 | 1947-04-16 | Netherlands Chamber of Commerce in the U.S., Inc. | One Rockefeller Plaza | New York | NY | 10020 | |
21002 | 21002 | 1983-06-30 | 1981-03-26 | Whiting | William G. | Jamaica National Investment Promotion, Ltd. 3216 | 1981-03-26 | Jamaica National Investment Promotion, Ltd. | 866 Second Avenue | 6th Floor | New York | NY | 10017 |
26306 | 26306 | 1973-08-09 | 1970-09-16 | Brayley | William G. | Quebec Government Office 1787 | 1964-09-02 | Quebec Government Office | One Rockefeller Plaza | Suite 2600 | New York | NY | 10020-2102 |
28889 | 28889 | 1989-09-01 | 1988-08-24 | Gibbons | William G. | Saatchi & Saatchi North America, Inc. 3605 | 1984-07-24 | Saatchi & Saatchi North America, Inc. | Saatchi & Saatchi Building | 375 Hudson Street, 10th Floor | New York | NY | 10014-3620 |
32840 | 32840 | 1976-10-15 | 1972-08-31 | Cinnamond | William G. | Casey, Lane & Mittendorf 1553 | 1962-07-02 | Casey, Lane & Mittendorf | 26 Broadway | New York | NY | 10004 | |
33045 | 33045 | 1961-10-17 | 1956-04-17 | Fullen | William G. | Baar, Bennett & Fullen 946 | 1956-04-17 | Baar, Bennett & Fullen | 29 Broadway | New York | NY | ||
35975 | 35975 | 1967-11-17 | 1959-11-09 | Kaelin | William G. | Kramer, Marx, Greenlee & Backus 1293 | 1959-11-09 | Kramer, Marx, Greenlee & Backus | 29 Broadway | New York | NY | 10006 | |
37375 | 37375 | 1984-12-01 | 1980-07-22 | Ritchie | William G. | Government of Ontario, Canada 2087 | 1968-04-11 | Government of Ontario, Canada | 800 Third Avenue | Suite 2800 | New York | NY | 10022 |
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]) );