FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
12 rows where "Short_Form_Termination_Date" is on date 1986-06-30 and State = "NY"
This data as json, CSV (advanced)
Suggested facets: Address_1, Zip, Short_Form_Termination_Date (date)
Registration_Number 9
- White & Case, LLP 3
- New York Bureau of the Telegraph Agency of Russia (TASS) 2
- National Film Board of Canada 1
- IDA Ireland 1
- East Asia Travel Association 1
- Netherlands/Antilles Economic Mission 1
- Hill & Knowlton, Inc. 1
- Martin, Marshall, Jaccoma & Mitchell Advertising, Inc. 1
- Gavin Anderson Doremus & Company 1
Registrant_Name 9
- White & Case, LLP 3
- New York Bureau of the Telegraph Agency of Russia (TASS) 2
- East Asia Travel Association 1
- Gavin Anderson Doremus & Company 1
- Hill & Knowlton, Inc. 1
- IDA Ireland 1
- Martin, Marshall, Jaccoma & Mitchell Advertising, Inc. 1
- National Film Board of Canada 1
- Netherlands/Antilles Economic Mission 1
State 1
- NY · 12 ✖
City 1
- New York 12
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
21049 | 21049 | 1986-06-30 | 1981-01-14 | Lioutyi | Alexander | New York Bureau of the Telegraph Agency of Russia (TASS) 464 | 1947-06-03 | New York Bureau of the Telegraph Agency of Russia (TASS) | 50 Rockefeller Plaza | New York | NY | 10020 | |
21051 | 21051 | 1986-06-30 | 1982-03-04 | Shalnev | Alexander | New York Bureau of the Telegraph Agency of Russia (TASS) 464 | 1947-06-03 | New York Bureau of the Telegraph Agency of Russia (TASS) | 50 Rockefeller Plaza | New York | NY | 10020 | |
21052 | 21052 | 1986-06-30 | 1986-04-09 | Sacklen | Mats A. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
21053 | 21053 | 1986-06-30 | 1986-04-18 | Taguchi | Kazunari | East Asia Travel Association 2423 | 1973-05-07 | East Asia Travel Association | C/O Tourism Auth. of Thailand | 304 Park Avenue South, 8th Floor | New York | NY | 10010 |
21058 | 21058 | 1986-06-30 | 1985-06-04 | Dieckhaus | Mary Jo | Gavin Anderson Doremus & Company 3378 | 1982-06-15 | Gavin Anderson Doremus & Company | 11 West 42nd Street | 8th Floor | New York | NY | 10036 |
21060 | 21060 | 1986-06-30 | 1948-06-28 | Sims | Lillian Adelaide | National Film Board of Canada 437 | 1944-04-21 | National Film Board of Canada | 1123 Broadway | Suite 307 | New York | NY | 10010 |
21061 | 21061 | 1986-06-30 | 1977-07-08 | Douglas | William H. | Hill & Knowlton, Inc. 2740 | 1976-12-17 | Hill & Knowlton, Inc. | 420 Lexington Avenue | New York | NY | 10017 | |
21062 | 21062 | 1986-06-30 | 1979-07-23 | Sturtevant | Robert S. | Martin, Marshall, Jaccoma & Mitchell Advertising, Inc. 3043 | 1979-07-23 | Martin, Marshall, Jaccoma & Mitchell Advertising, Inc. | 41 Madison Avenue | New York | NY | 10010 | |
21063 | 21063 | 1986-06-30 | 1984-09-18 | Grace | Manuel G. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
21064 | 21064 | 1986-06-30 | 1984-09-27 | Pietersz | Edward A. | Netherlands/Antilles Economic Mission 2477 | 1973-11-20 | Netherlands/Antilles Economic Mission | 1114 Avenue of the Americas | New York | NY | 10036 | |
21065 | 21065 | 1986-06-30 | 1983-10-07 | Hazlitt | Elizabeth M. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
21067 | 21067 | 1986-06-30 | 1977-11-28 | Gargan | Anthony P. | IDA Ireland 1770 | 1964-07-10 | IDA Ireland | 345 Park Avenue | 17th Floor | New York | NY | 10154 |
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]) );