FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
15 rows where "Foreign_Principal_Termination_Date" is on date 1974-12-31 sorted by City
This data as json, CSV (advanced)
Suggested facets: Registration_Number, Registrant_Date, Foreign_Principal_Registration_Date (date)
Foreign_Principal 15
- Alpine Tourist Commission 1
- Alpine Tourist Office 1
- British Virgin Islands Tourist Board 1
- Bulgarian State Tourist Office 1
- Communications Affiliates (Bahamas), Ltd. 1
- Compagnie Internationale des Wagons-Lits 1
- Consejo Estatel del Azucar 1
- Federation of Central American Sugar Producers 1
- Fiji Visitors' Bureau 1
- Finnish State Railways 1
- Government of the Dominican Republic 1
- Ministry of Commerce & Industry (Tourist Section) of Cyprus 1
- People's National Congress of Guyana 1
- Syndicat de Distillateurs et Producteurs de Sucre de Madagascar 1
- Yugoslavian State Tourist Office 1
Country/Location_Represented 14
- DOMINICAN REPUBLIC 2
- BAHAMAS 1
- BULGARIA 1
- CYPRUS 1
- FIJI 1
- FINLAND 1
- FRANCE 1
- GUATEMALA 1
- GUYANA 1
- INTERNATIONAL 1
- MADAGASCAR 1
- SWITZERLAND 1
- VIRGIN ISLANDS 1
- YUGOSLAVIA 1
Registrant_Name 12
- Bozell & Jacobs Public Relations, Inc. 3
- James N. Juliana Associates 2
- Dailey & Associates 1
- Eastern Caribbean Tourist Association 1
- European Travel Commission 1
- Finnish Tourist Board, New York 1
- French National Railroads, New York 1
- James, Oscar S. 1
- Marplan Research, Inc. 1
- Ramirez-Eva, Arnoldo 1
- Tribune Films, Inc. 1
- Williams & King 1
City 1
- - 15
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15720 | 15720 | 1974-12-31 | Fiji Visitors' Bureau | 1972-01-17 | FIJI | Dailey & Associates 2299 | 1971-12-27 | Dailey & Associates | Suva | ||||
15721 | 15721 | 1974-12-31 | People's National Congress of Guyana | 1968-03-19 | GUYANA | James, Oscar S. 2080 | 1968-03-19 | James, Oscar S. | Georgetown | ||||
15722 | 15722 | 1974-12-31 | Alpine Tourist Commission | 1973-07-24 | INTERNATIONAL | Tribune Films, Inc. 1810 | 1964-10-29 | Tribune Films, Inc. | New York | NY | |||
15723 | 15723 | 1974-12-31 | Alpine Tourist Office | 1974-06-24 | SWITZERLAND | Bozell & Jacobs Public Relations, Inc. 2522 | 1974-06-24 | Bozell & Jacobs Public Relations, Inc. | New York | NY | |||
15724 | 15724 | 1974-12-31 | British Virgin Islands Tourist Board | 1973-10-30 | VIRGIN ISLANDS | Eastern Caribbean Tourist Association 2472 | 1973-10-30 | Eastern Caribbean Tourist Association | Tortola | ||||
15725 | 15725 | 1974-12-31 | Bulgarian State Tourist Office | 1974-06-24 | BULGARIA | Bozell & Jacobs Public Relations, Inc. 2522 | 1974-06-24 | Bozell & Jacobs Public Relations, Inc. | New York | NY | |||
15726 | 15726 | 1974-12-31 | Communications Affiliates (Bahamas), Ltd. | 1969-02-26 | BAHAMAS | Marplan Research, Inc. 2124 | 1969-02-26 | Marplan Research, Inc. | Nassau | ||||
15727 | 15727 | 1974-12-31 | Compagnie Internationale des Wagons-Lits | 1971-12-21 | FRANCE | French National Railroads, New York 335 | 1945-12-26 | French National Railroads, New York | |||||
15728 | 15728 | 1974-12-31 | Consejo Estatel del Azucar | 1968-03-25 | DOMINICAN REPUBLIC | James N. Juliana Associates 2083 | 1968-03-25 | James N. Juliana Associates | Santo Domingo | ||||
15729 | 15729 | 1974-12-31 | Federation of Central American Sugar Producers | 1970-06-01 | GUATEMALA | Ramirez-Eva, Arnoldo 2197 | 1970-06-01 | Ramirez-Eva, Arnoldo | Guatemala City | ||||
15730 | 15730 | 1974-12-31 | Finnish State Railways | 1964-04-03 | FINLAND | Finnish Tourist Board, New York 573 | 1949-05-31 | Finnish Tourist Board, New York | |||||
15731 | 15731 | 1974-12-31 | Government of the Dominican Republic | 1971-04-27 | DOMINICAN REPUBLIC | James N. Juliana Associates 2083 | 1968-03-25 | James N. Juliana Associates | Santo Domingo | ||||
15732 | 15732 | 1974-12-31 | Ministry of Commerce & Industry (Tourist Section) of Cyprus | 1973-11-26 | CYPRUS | European Travel Commission 574 | 1949-06-30 | European Travel Commission | Nicosia | ||||
15733 | 15733 | 1974-12-31 | Syndicat de Distillateurs et Producteurs de Sucre de Madagascar | 1974-03-06 | MADAGASCAR | Williams & King 2502 | 1974-03-08 | Williams & King | |||||
15734 | 15734 | 1974-12-31 | Yugoslavian State Tourist Office | 1974-06-24 | YUGOSLAVIA | Bozell & Jacobs Public Relations, Inc. 2522 | 1974-06-24 | Bozell & Jacobs Public Relations, Inc. | 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]) );