FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
14 rows where "Short_Form_Termination_Date" is on date 1985-08-31
This data as json, CSV (advanced)
Suggested facets: Short_Form_Date, Address_1, Address_2, Short_Form_Termination_Date (date), Short_Form_Date (date)
Registration_Number 11
- Kuomintang of China 2
- Japan National Tourist Organization, Hawaii 2
- Ogilvy & Mather U.S., a Division of The Ogilvy Group, Inc. 2
- Switzerland Tourism 1
- Bahamas Tourist Office 1
- Grenada Board of Tourism 1
- Hannaford Company, Inc. 1
- Newman & Holtzinger, P.C. 1
- O'Connor & Hannan, L.L.P. 1
- Austrian Trade Commission in the U.S., Houston 1
- Office of the Government of Alberta 1
Registrant_Name 11
- Japan National Tourist Organization, Hawaii 2
- Kuomintang of China 2
- Ogilvy & Mather U.S., a Division of The Ogilvy Group, Inc. 2
- Austrian Trade Commission in the U.S., Houston 1
- Bahamas Tourist Office 1
- Grenada Board of Tourism 1
- Hannaford Company, Inc. 1
- Newman & Holtzinger, P.C. 1
- O'Connor & Hannan, L.L.P. 1
- Office of the Government of Alberta 1
- Switzerland Tourism 1
City 6
- New York 5
- Washington 3
- Honolulu 2
- San Francisco 2
- Houston 1
- Nassau 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
28080 | 28080 | 1985-08-31 | 1983-01-20 | Zuffi | Enrico | Switzerland Tourism 55 | 1943-03-01 | Switzerland Tourism | 608 Fifth Avenue | New York | NY | 10020-2303 | |
28081 | 28081 | 1985-08-31 | 1984-01-27 | Hood | Dave D. | Grenada Board of Tourism 2378 | 1972-09-10 | Grenada Board of Tourism | 317 Madison Avenue | Suite 1522 | New York | NY | 10017 |
28082 | 28082 | 1985-08-31 | 1979-03-13 | Saunders | Emmett G. | Bahamas Tourist Office 2310 | 1972-01-27 | Bahamas Tourist Office | Ministry of Tourism | Post Office Box N-3701 | Nassau | ||
28083 | 28083 | 1985-08-31 | 1983-04-11 | Evans | Thomas B. , Jr. | O'Connor & Hannan, L.L.P. 2972 | 1978-10-25 | O'Connor & Hannan, L.L.P. | 1666 K Street, N.W. | Suite 500 | Washington | DC | 20006 |
28084 | 28084 | 1985-08-31 | 1983-04-20 | Harding | Brenton | Office of the Government of Alberta 3459 | 1983-04-20 | Office of the Government of Alberta | 450 Park Avenue | Suite 1502 | New York | NY | 10020 |
28085 | 28085 | 1985-08-31 | 1978-05-04 | Reis | Harold F. | Newman & Holtzinger, P.C. 2895 | 1978-05-04 | Newman & Holtzinger, P.C. | 1615 L Street, N.W. | Suite 1000 | Washington | DC | 20036 |
28086 | 28086 | 1985-08-31 | 1983-06-15 | Madlener | Helmet | Austrian Trade Commission in the U.S., Houston 3410 | 1982-09-20 | Austrian Trade Commission in the U.S., Houston | 1300 Post Oak Boulevard | Suite 1700 | Houston | TX | 77056 |
28087 | 28087 | 1985-08-31 | 1985-06-19 | Williams | Harold R. | Hannaford Company, Inc. 2850 | 1977-11-29 | Hannaford Company, Inc. | 655 - 15th Street, N.W. | Suite 200 | Washington | DC | 20005 |
28088 | 28088 | 1985-08-31 | 1972-07-03 | Ikeda | Atsushi | Japan National Tourist Organization, Hawaii 2351 | 1972-07-03 | Japan National Tourist Organization, Hawaii | 2270 Kalakaua Avenue | Suite 1703 | Honolulu | HI | 96815 |
28089 | 28089 | 1985-08-31 | 1983-08-17 | Tanaka | Isokazu | Japan National Tourist Organization, Hawaii 2351 | 1972-07-03 | Japan National Tourist Organization, Hawaii | 2270 Kalakaua Avenue | Suite 1703 | Honolulu | HI | 96815 |
28090 | 28090 | 1985-08-31 | 1975-08-21 | Suen | Donald | Kuomintang of China 282 | 1945-01-01 | Kuomintang of China | (Headquarters in America) | 844 Stockton Street | San Francisco | CA | 94108 |
28091 | 28091 | 1985-08-31 | 1980-09-15 | Guariglia | Charles R. | 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 |
28092 | 28092 | 1985-08-31 | 1980-09-15 | Verbeck | Pieter L. | 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 |
28093 | 28093 | 1985-08-31 | 1949-09-19 | Liu | Pei Chi | Kuomintang of China 282 | 1945-01-01 | Kuomintang of China | (Headquarters in America) | 844 Stockton Street | San Francisco | CA | 94108 |
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]) );