FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
18 rows where "Foreign_Principal_Termination_Date" is on date 1981-08-31 and State = ""
This data as json, CSV (advanced)
Suggested facets: Registration_Number, Registrant_Date, Registrant_Date (date)
Foreign_Principal 18
- Al-Litalia Air Lines 1
- Asociacion de Amigos del Pais 1
- Canadian National Railways 1
- Gazelle Film Productions, Limited 1
- German Federal Railroad 1
- Government of Western Somoa 1
- Government of the Federal Republic of Germany 1
- National Office of Tourism & Information of Dominican Republic 1
- New Zealand Government Travel Commissioner 1
- Noranda Mines 1
- Office du Tourism de Novelle Caledonia 1
- Penang Development Corporation 1
- Quebec Government 1
- Queensland Government Tourist Bureau 1
- Republic of China Tourism Bureau 1
- Sabah Tourist Association 1
- Tonga Visitors Bureau 1
- Tourist Development Corp., Ministry Comerce/Industry Malaysia 1
Country/Location_Represented 13
- CANADA 3
- MALAYSIA 3
- GERMANY, FEDERAL REPUBLIC OF 2
- AUSTRALIA 1
- CHINA 1
- DOMINICAN REPUBLIC 1
- GREAT BRITAIN 1
- GUATEMALA 1
- ITALY 1
- NEW CALEDONIA 1
- NEW ZEALAND 1
- TONGA 1
- WESTERN SAMOA 1
Registrant_Name 3
State 1
- - · 18 ✖
City 1
- - 18
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10903 | 10903 | 1981-08-31 | Al-Litalia Air Lines | 1965-06-29 | ITALY | Association Films, Inc. 1814 | 1964-11-06 | Association Films, Inc. | Rome | ||||
10905 | 10905 | 1981-08-31 | Asociacion de Amigos del Pais | 1980-11-09 | GUATEMALA | Hannaford Company, Inc. 2850 | 1977-11-29 | Hannaford Company, Inc. | Guatemala City | ||||
10908 | 10908 | 1981-08-31 | Canadian National Railways | 1970-06-17 | CANADA | Association Films, Inc. 1814 | 1964-11-06 | Association Films, Inc. | Montreal, Quebec | ||||
10919 | 10919 | 1981-08-31 | Gazelle Film Productions, Limited | 1974-03-07 | GREAT BRITAIN | Association Films, Inc. 1814 | 1964-11-06 | Association Films, Inc. | Bristol | ||||
10921 | 10921 | 1981-08-31 | German Federal Railroad | 1964-11-06 | GERMANY, FEDERAL REPUBLIC OF | Association Films, Inc. 1814 | 1964-11-06 | Association Films, Inc. | Frankfurt | ||||
10927 | 10927 | 1981-08-31 | Government of Western Somoa | 1980-04-30 | WESTERN SAMOA | Association Films, Inc. 1814 | 1964-11-06 | Association Films, Inc. | Apia | ||||
10928 | 10928 | 1981-08-31 | Government of the Federal Republic of Germany | 1964-11-06 | GERMANY, FEDERAL REPUBLIC OF | Association Films, Inc. 1814 | 1964-11-06 | Association Films, Inc. | Bonn | ||||
10943 | 10943 | 1981-08-31 | National Office of Tourism & Information of Dominican Republic | 1979-05-04 | DOMINICAN REPUBLIC | Thomas L. Richmond, Inc. 3015 | 1979-05-04 | Thomas L. Richmond, Inc. | |||||
10945 | 10945 | 1981-08-31 | New Zealand Government Travel Commissioner | 1964-11-06 | NEW ZEALAND | Association Films, Inc. 1814 | 1964-11-06 | Association Films, Inc. | Wellington | ||||
10946 | 10946 | 1981-08-31 | Noranda Mines | 1975-01-14 | CANADA | Association Films, Inc. 1814 | 1964-11-06 | Association Films, Inc. | Toronto, Ontario | ||||
10947 | 10947 | 1981-08-31 | Office du Tourism de Novelle Caledonia | 1980-04-30 | NEW CALEDONIA | Association Films, Inc. 1814 | 1964-11-06 | Association Films, Inc. | Nounea | ||||
10949 | 10949 | 1981-08-31 | Penang Development Corporation | 1980-04-30 | MALAYSIA | Association Films, Inc. 1814 | 1964-11-06 | Association Films, Inc. | Penang | ||||
10951 | 10951 | 1981-08-31 | Quebec Government | 1972-12-21 | CANADA | Association Films, Inc. 1814 | 1964-11-06 | Association Films, Inc. | Montreal, Quebec | ||||
10952 | 10952 | 1981-08-31 | Queensland Government Tourist Bureau | 1977-06-26 | AUSTRALIA | Association Films, Inc. 1814 | 1964-11-06 | Association Films, Inc. | Brisbane | ||||
10954 | 10954 | 1981-08-31 | Republic of China Tourism Bureau | 1980-04-30 | CHINA | Association Films, Inc. 1814 | 1964-11-06 | Association Films, Inc. | San Francisco | ||||
10957 | 10957 | 1981-08-31 | Sabah Tourist Association | 1973-07-24 | MALAYSIA | Association Films, Inc. 1814 | 1964-11-06 | Association Films, Inc. | Sabah | ||||
10962 | 10962 | 1981-08-31 | Tonga Visitors Bureau | 1977-01-03 | TONGA | Association Films, Inc. 1814 | 1964-11-06 | Association Films, Inc. | Nuku'alofa | ||||
10964 | 10964 | 1981-08-31 | Tourist Development Corp., Ministry Comerce/Industry Malaysia | 1973-07-24 | MALAYSIA | Association Films, Inc. 1814 | 1964-11-06 | Association Films, Inc. | Kuls Lumpur |
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]) );