FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
19 rows where "Short_Form_Termination_Date" is on date 1986-06-30
This data as json, CSV (advanced)
Suggested facets: Short_Form_Date, Registration_Date, Zip, Short_Form_Date (date), Registration_Date (date)
Registration_Number 16
- White & Case, LLP 3
- New York Bureau of the Telegraph Agency of Russia (TASS) 2
- National Film Board of Canada 1
- Cleary, Gottlieb, Steen & Hamilton, LLP 1
- Squire, Sanders & Dempsey, L.L.P. 1
- Japan Economic Institute of America 1
- Tourism Australia 1
- China Books & Periodicals, Inc. 1
- Government of the Province of Alberta 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
- One NorthEast 1
Registrant_Name 16
- White & Case, LLP 3
- New York Bureau of the Telegraph Agency of Russia (TASS) 2
- China Books & Periodicals, Inc. 1
- Cleary, Gottlieb, Steen & Hamilton, LLP 1
- East Asia Travel Association 1
- Gavin Anderson Doremus & Company 1
- Government of the Province of Alberta 1
- Hill & Knowlton, Inc. 1
- IDA Ireland 1
- Japan Economic Institute of America 1
- Martin, Marshall, Jaccoma & Mitchell Advertising, Inc. 1
- National Film Board of Canada 1
- Netherlands/Antilles Economic Mission 1
- One NorthEast 1
- Squire, Sanders & Dempsey, L.L.P. 1
- Tourism Australia 1
City 6
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 | |
21050 | 21050 | 1986-06-30 | 1974-02-20 | Pfizenmayer | Rickard Frank | Squire, Sanders & Dempsey, L.L.P. 746 | 1952-12-02 | Squire, Sanders & Dempsey, L.L.P. | 1201 Pennsylvania Avenue, N.W. | Post Office Box 407 | Washington | DC | 20044-0407 |
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 |
21054 | 21054 | 1986-06-30 | 1983-05-25 | Martin | Kenneth S. | One NorthEast 3476 | 1983-05-25 | One NorthEast | Meadows Corporate Center | 2850 West Golf Road, Suite 401 | Rolling Meadows | IL | 60008-4033 |
21055 | 21055 | 1986-06-30 | 1983-06-02 | Palivoda | Randolph J. | Government of the Province of Alberta 1720 | 1964-04-30 | Government of the Province of Alberta | Fed. & Intergovtmental Affairs | 10025 Jasper Avenue, #2200 | Edmonton, Alberta | ||
21056 | 21056 | 1986-06-30 | 1981-06-04 | McKeown | Kathleen M. | China Books & Periodicals, Inc. 1350 | 1960-04-06 | China Books & Periodicals, Inc. | 2929 - 24th Street | San Francisco | CA | 94110 | |
21057 | 21057 | 1986-06-30 | 1985-06-04 | Begni | Vera | Tourism Australia 1032 | 1957-06-03 | Tourism Australia | 2029 Century Park East | Suite 3150 | Los Angeles | CA | 90067 |
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 |
21059 | 21059 | 1986-06-30 | 1985-06-12 | Hoptman | Sheri L. | Japan Economic Institute of America 929 | 1956-01-25 | Japan Economic Institute of America | P.O.Box 65780 | Washington | DC | 20035-5780 | |
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 | |
21066 | 21066 | 1986-06-30 | 1985-11-05 | Paine | Peter S. , Jr. | Cleary, Gottlieb, Steen & Hamilton, LLP 508 | 1948-01-19 | Cleary, Gottlieb, Steen & Hamilton, LLP | 2000 Pennsylvania Avenue, NW | Washington | DC | 20006-1801 | |
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]) );