FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
15 rows where City = "New York" and "Short_Form_Termination_Date" is on date 1985-12-31
This data as json, CSV (advanced)
Suggested facets: Short_Form_Date, Address_2
Registration_Number 10
- IDA Ireland 3
- Van Brunt & Company Advertising-Marketing, Inc. 2
- Government of Ontario, Canada 2
- Ogilvy & Mather U.S., a Division of The Ogilvy Group, Inc. 2
- VisitBritain 1
- Ruder Finn, Inc. 1
- Mexican Tourism Board 1
- Milbank, Tweed, Hadley & McCloy 1
- Zambia National Tourist Board 1
- Cayman Islands Department of Tourism 1
Registrant_Name 10
- IDA Ireland 3
- Government of Ontario, Canada 2
- Ogilvy & Mather U.S., a Division of The Ogilvy Group, Inc. 2
- Van Brunt & Company Advertising-Marketing, Inc. 2
- Cayman Islands Department of Tourism 1
- Mexican Tourism Board 1
- Milbank, Tweed, Hadley & McCloy 1
- Ruder Finn, Inc. 1
- VisitBritain 1
- Zambia National Tourist Board 1
State 1
- NY 15
City 1
- New York · 15 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
40305 | 40305 | 1985-12-31 | 1937-01-01 | Mulayantanda | Tasker B. | Zambia National Tourist Board 2293 | 1971-12-06 | Zambia National Tourist Board | 800 Second Avenue | Ninth Floor | New York | NY | 10017 |
40309 | 40309 | 1985-12-31 | 1982-01-12 | Berrol | Ed | 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 |
40310 | 40310 | 1985-12-31 | 1982-01-12 | Kilgore | Joe | 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 |
40312 | 40312 | 1985-12-31 | 1978-03-01 | Murray | Ralph C. | Milbank, Tweed, Hadley & McCloy 1839 | 1965-01-11 | Milbank, Tweed, Hadley & McCloy | 1 Chase Manhattan Plaza | New York | NY | 10005 | |
40315 | 40315 | 1985-12-31 | 1981-03-24 | Baker | Noel A. | IDA Ireland 1770 | 1964-07-10 | IDA Ireland | 345 Park Avenue | 17th Floor | New York | NY | 10154 |
40316 | 40316 | 1985-12-31 | 1984-03-27 | MacNeil | G. Gordon N. | Government of Ontario, Canada 2087 | 1968-04-11 | Government of Ontario, Canada | 800 Third Avenue | Suite 2800 | New York | NY | 10022 |
40319 | 40319 | 1985-12-31 | 1961-05-07 | Van Brunt | Carl | Van Brunt & Company Advertising-Marketing, Inc. 1704 | 1964-04-02 | Van Brunt & Company Advertising-Marketing, Inc. | 7 Dey Street | New York | NY | 10017 | |
40320 | 40320 | 1985-12-31 | 1981-05-07 | Gass | Robert | Van Brunt & Company Advertising-Marketing, Inc. 1704 | 1964-04-02 | Van Brunt & Company Advertising-Marketing, Inc. | 7 Dey Street | New York | NY | 10017 | |
40321 | 40321 | 1985-12-31 | 1984-05-25 | Detre | Frank C. | Cayman Islands Department of Tourism 2500 | 1974-03-04 | Cayman Islands Department of Tourism | 350 5th Avenue | Suite 4620 | New York | NY | 10118-1801 |
40323 | 40323 | 1985-12-31 | 1964-06-09 | Lecube | Miguel Angel Alejo Lopez | Mexican Tourism Board 1754 | 1964-06-09 | Mexican Tourism Board | 400 Madison Avenue | Suite 11C | New York | NY | 10017 |
40335 | 40335 | 1985-12-31 | 1961-09-27 | Weissman | Norman | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 301 East 57th Street | New York | NY | 10022 | |
40336 | 40336 | 1985-12-31 | 1980-09-30 | Mallory | James C. | IDA Ireland 1770 | 1964-07-10 | IDA Ireland | 345 Park Avenue | 17th Floor | New York | NY | 10154 |
40339 | 40339 | 1985-12-31 | 1984-11-15 | Eastwood | John M. | Government of Ontario, Canada 2087 | 1968-04-11 | Government of Ontario, Canada | 800 Third Avenue | Suite 2800 | New York | NY | 10022 |
40340 | 40340 | 1985-12-31 | 1983-11-18 | Lynn | Kenneth G. | IDA Ireland 1770 | 1964-07-10 | IDA Ireland | 345 Park Avenue | 17th Floor | New York | NY | 10154 |
40341 | 40341 | 1985-12-31 | 1982-11-23 | Spain | David Andrew | VisitBritain 579 | 1949-07-07 | VisitBritain | 885 Second Avenue | 28th Floor | New York | NY | 10017 |
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]) );