FARA_All_ForeignPrincipals

List of all foreign principals (active and terminated)

Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history

39 rows where Registration_Number = 71

✎ View and edit SQL

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)

State

Registrant_Name

City

  • 39
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
9241 9241 1964-07-31 Autotransporte Touristico Espanol, S.A. 1956-04-13 SPAIN 71 71 1942-07-30 Kelly, Nason, Inc. Madrid        
9242 9242 1964-07-31 Bermuda Hotels, Inc. 1942-07-30 BERMUDA 71 71 1942-07-30 Kelly, Nason, Inc. Hamilton        
9243 9243 1964-07-31 British Colonial Hotel 1953-09-18 BAHAMAS 71 71 1942-07-30 Kelly, Nason, Inc. Nassau        
9244 9244 1964-07-31 Burns House, Ltd. 1955-03-31 BAHAMAS 71 71 1942-07-30 Kelly, Nason, Inc. Nassau        
9245 9245 1964-07-31 Cabo Blanco Fishing Club 1956-04-13 PERU 71 71 1942-07-30 Kelly, Nason, Inc. Cabo Blanco        
9248 9248 1964-07-31 City Gift Shop 1957-04-08 BAHAMAS 71 71 1942-07-30 Kelly, Nason, Inc. Nassau        
9249 9249 1964-07-31 Cremo Cheese Company 1953-03-30 DENMARK 71 71 1942-07-30 Kelly, Nason, Inc. Copenhagen        
9250 9250 1964-07-31 Development Board, Department of the Bahamas Government 1942-07-30 BAHAMAS 71 71 1942-07-30 Kelly, Nason, Inc. Nassau        
9251 9251 1964-07-31 Duke of Windsor 1942-07-30 BAHAMAS 71 71 1942-07-30 Kelly, Nason, Inc. Nassau        
9252 9252 1964-07-31 Egyptian State Department of Tourism 1955-03-31 EGYPT 71 71 1942-07-30 Kelly, Nason, Inc. Cairo        
9253 9253 1964-07-31 French Leave 1960-03-03 BAHAMAS 71 71 1942-07-30 Kelly, Nason, Inc. Eleuthera        
9255 9255 1964-07-31 Harold G. Christie 1942-07-30 BAHAMAS 71 71 1942-07-30 Kelly, Nason, Inc. Nassau        
9256 9256 1964-07-31 House of 4711"" 1962-03-06 GERMANY, FEDERAL REPUBLIC OF 71 71 1942-07-30 Kelly, Nason, Inc. Cologne        
9257 9257 1964-07-31 Iberia Airlines of Spain 1957-01-28 SPAIN 71 71 1942-07-30 Kelly, Nason, Inc. Madrid        
9258 9258 1964-07-31 Incres Cia Navigacion, S.A. 1952-09-25 PANAMA 71 71 1942-07-30 Kelly, Nason, Inc. Panama City        
9259 9259 1964-07-31 Incres Compagnia de Navigacion, S.A. 1955-03-31 ITALY 71 71 1942-07-30 Kelly, Nason, Inc. Genoa        
9260 9260 1964-07-31 Italian Airlines 1953-09-18 ITALY 71 71 1942-07-30 Kelly, Nason, Inc. New York     NY  
9261 9261 1964-07-31 Italian National Tourist Office 1950-03-24 ITALY 71 71 1942-07-30 Kelly, Nason, Inc. New York     NY  
9262 9262 1964-07-31 James Lovick & Company, Ltd. 1955-03-31 CANADA 71 71 1942-07-30 Kelly, Nason, Inc. Montreal        
9263 9263 1964-07-31 Japan Tourist Association 1960-03-03 JAPAN 71 71 1942-07-30 Kelly, Nason, Inc. New York     NY  
9264 9264 1964-07-31 Japan Trade Center/Japan Camera Information & Service Center 1956-04-13 JAPAN 71 71 1942-07-30 Kelly, Nason, Inc. New York     NY  
9265 9265 1964-07-31 Japan Travel Information Office/Japan Travel Bureau 1953-09-18 JAPAN 71 71 1942-07-30 Kelly, Nason, Inc. New York     NY  
9266 9266 1964-07-31 Kingdom of Greece/National Tourist Organization 1954-10-12 GREECE 71 71 1942-07-30 Kelly, Nason, Inc. Athens        
9267 9267 1964-07-31 Lauro Lines/Polazzo Lauro 1955-03-31 ITALY 71 71 1942-07-30 Kelly, Nason, Inc. Naples        
9268 9268 1964-07-31 Linjebuss International, A.B. 1956-04-13 SWEDEN 71 71 1942-07-30 Kelly, Nason, Inc. Stockholm        
9269 9269 1964-07-31 Lyford Cay Development Company, Ltd. 1957-09-17 BAHAMAS 71 71 1942-07-30 Kelly, Nason, Inc. Nassau        
9270 9270 1964-07-31 Montagu Beach Hotel 1960-03-03 BAHAMAS 71 71 1942-07-30 Kelly, Nason, Inc. Nassau        
9271 9271 1964-07-31 Nassau Yachthaven 1953-03-30 BAHAMAS 71 71 1942-07-30 Kelly, Nason, Inc. Nassau        
9272 9272 1964-07-31 Nova Scotia Ministry of Industry & Publicity 1950-03-24 CANADA 71 71 1942-07-30 Kelly, Nason, Inc. Halifax, Nova Scotia        
9273 9273 1964-07-31 Palmdale Villas 1956-04-13 BAHAMAS 71 71 1942-07-30 Kelly, Nason, Inc. Nassau        
9274 9274 1964-07-31 Perret & Berthoud, S.A. 1955-03-31 SWITZERLAND 71 71 1942-07-30 Kelly, Nason, Inc. Geneva        
9275 9275 1964-07-31 Pilot House Club 1962-12-10 BAHAMAS 71 71 1942-07-30 Kelly, Nason, Inc. Nassau        
9276 9276 1964-07-31 Princess Hotel of Bermuda, Ltd. 1955-03-31 BERMUDA 71 71 1942-07-30 Kelly, Nason, Inc. Hamilton        
9277 9277 1964-07-31 Spanish State Tourist Department 1950-03-24 SPAIN 71 71 1942-07-30 Kelly, Nason, Inc. New York     NY  
9278 9278 1964-07-31 St. Adele Lodge 1942-07-30 CANADA 71 71 1942-07-30 Kelly, Nason, Inc.          
9279 9279 1964-07-31 Tourist Trade Development Board of Jamaica 1942-07-30 JAMAICA 71 71 1942-07-30 Kelly, Nason, Inc. Kingston        
9280 9280 1964-07-31 United Arab Republic Tourist Office 1958-10-08 UNITED ARAB EMIRATES 71 71 1942-07-30 Kelly, Nason, Inc. Cairo        
9281 9281 1964-07-31 Yarmouth County Tourist Committee 1952-06-20 CANADA 71 71 1942-07-30 Kelly, Nason, Inc. Nova Scotia        
9282 9282 1964-07-31 Yugoslav State Tourist Office 1957-09-17 YUGOSLAVIA 71 71 1942-07-30 Kelly, Nason, Inc. Zagreb        

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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)
);
Powered by Datasette · Query took 162.199ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history