FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
28 rows where Foreign_Principal_Termination_Date = "1989-10-25" and Registrant_Date = "1977-10-12"
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Registration_Date, Address_1, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Foreign_Principal 28
- Austrian Press & Information Service 1
- Autonomous University of Guadalajara 1
- Bahamas Tourist Office 1
- Burson-Marsteller for the Industrial Development Board of Northern Ireland 1
- Ceylon Tea Bureau 1
- Chinese Cultural Center 1
- City of West Berlin 1
- City of West Berlin, New York 1
- Consulate General of Israel 1
- D.J. Edelman for Tourism Canada 1
- Electronic Industries Association of Japan (Hill & Knowlton) 1
- Embassy of Japan 1
- Eurailpass 1
- European Travel Commission, New York 1
- French Government Tourist Office 1
- Hong Kong Tourist Organization 1
- Industrial Development Board of Northern Ireland 1
- Israel Government Tourist Office 1
- Israel Ministry of Tourism 1
- Italian Trade Commission 1
- Jamaica Tourist Board Office 1
- Japan National Tourist Organization 1
- Malaysian Airline System 1
- Revenue Canada - Customs & Excise 1
- Romanian National Tourist Office 1
- Swedish Tourist Board 1
- Swiss National Tourist Office 1
- Tea Board of India 1
Country/Location_Represented 20
- ISRAEL 3
- JAPAN 3
- CANADA 2
- FRANCE 2
- GERMANY, FEDERAL REPUBLIC OF 2
- NORTHERN IRELAND 2
- AUSTRIA 1
- BAHAMAS 1
- CHINA 1
- HONG KONG 1
- INDIA 1
- INTERNATIONAL 1
- ITALY 1
- JAMAICA 1
- MALAYSIA 1
- MEXICO 1
- ROMANIA 1
- SRI LANKA 1
- SWEDEN 1
- SWITZERLAND 1
Registrant_Name 1
City 1
- - 28
Link | rowid ▼ | Foreign_Principal_Termination_Date | Foreign_Principal | Foreign_Principal_Registration_Date | Country/Location_Represented | Registration_Number | Registrant_Date | Registrant_Name | Address_1 | Address_2 | City | State | Zip |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13000 | 13000 | 1989-10-25 | Austrian Press & Information Service | 1986-12-12 | AUSTRIA | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | |||||
13001 | 13001 | 1989-10-25 | Autonomous University of Guadalajara | 1989-09-20 | MEXICO | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | San Antonio | TX | |||
13002 | 13002 | 1989-10-25 | Bahamas Tourist Office | 1988-10-12 | BAHAMAS | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | New York | NY | |||
13003 | 13003 | 1989-10-25 | Burson-Marsteller for the Industrial Development Board of Northern Ireland | 1988-10-03 | NORTHERN IRELAND | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | New York | NY | |||
13004 | 13004 | 1989-10-25 | Ceylon Tea Bureau | 1988-09-13 | SRI LANKA | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | New York | NY | |||
13005 | 13005 | 1989-10-25 | Chinese Cultural Center | 1988-10-12 | CHINA | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | New York | NY | |||
13006 | 13006 | 1989-10-25 | City of West Berlin | 1989-09-20 | GERMANY, FEDERAL REPUBLIC OF | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | New York | NY | |||
13007 | 13007 | 1989-10-25 | City of West Berlin, New York | 1988-07-25 | GERMANY, FEDERAL REPUBLIC OF | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | New York | NY | |||
13008 | 13008 | 1989-10-25 | Consulate General of Israel | 1988-07-25 | ISRAEL | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | New York | NY | |||
13009 | 13009 | 1989-10-25 | D.J. Edelman for Tourism Canada | 1988-10-12 | CANADA | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | New York | NY | |||
13010 | 13010 | 1989-10-25 | Electronic Industries Association of Japan (Hill & Knowlton) | 1989-09-20 | JAPAN | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | Washington | DC | |||
13011 | 13011 | 1989-10-25 | Embassy of Japan | 1987-08-17 | JAPAN | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | DC | ||||
13012 | 13012 | 1989-10-25 | Eurailpass | 1987-02-28 | FRANCE | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | NY | ||||
13013 | 13013 | 1989-10-25 | European Travel Commission, New York | 1988-07-25 | INTERNATIONAL | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | New York | NY | |||
13014 | 13014 | 1989-10-25 | French Government Tourist Office | 1985-04-18 | FRANCE | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | NY | ||||
13016 | 13016 | 1989-10-25 | Hong Kong Tourist Organization | 1988-12-08 | HONG KONG | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | New York | NY | |||
13017 | 13017 | 1989-10-25 | Industrial Development Board of Northern Ireland | 1988-02-09 | NORTHERN IRELAND | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | NY | ||||
13018 | 13018 | 1989-10-25 | Israel Government Tourist Office | 1989-08-08 | ISRAEL | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | New York | NY | |||
13019 | 13019 | 1989-10-25 | Israel Ministry of Tourism | 1989-04-13 | ISRAEL | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | New York | NY | |||
13020 | 13020 | 1989-10-25 | Italian Trade Commission | 1987-10-22 | ITALY | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | NY | ||||
13021 | 13021 | 1989-10-25 | Jamaica Tourist Board Office | 1989-04-13 | JAMAICA | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | New York | NY | |||
13022 | 13022 | 1989-10-25 | Japan National Tourist Organization | 1989-09-20 | JAPAN | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | New York | NY | |||
13023 | 13023 | 1989-10-25 | Malaysian Airline System | 1988-04-12 | MALAYSIA | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | Los Angeles | CA | |||
13024 | 13024 | 1989-10-25 | Revenue Canada - Customs & Excise | 1989-08-08 | CANADA | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | Ottawa | ||||
13025 | 13025 | 1989-10-25 | Romanian National Tourist Office | 1987-12-28 | ROMANIA | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | NY | ||||
13026 | 13026 | 1989-10-25 | Swedish Tourist Board | 1983-05-04 | SWEDEN | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | NY | ||||
13027 | 13027 | 1989-10-25 | Swiss National Tourist Office | 1986-05-21 | SWITZERLAND | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | NY | ||||
13028 | 13028 | 1989-10-25 | Tea Board of India | 1989-04-13 | INDIA | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | New York | NY |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [FARA_All_ForeignPrincipals] ( [Foreign_Principal_Termination_Date] TEXT, [Foreign_Principal] TEXT, [Foreign_Principal_Registration_Date] TEXT, [Country/Location_Represented] TEXT, [Registration_Number] INTEGER, [Registrant_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]) );