home / fara

Menu
  • Search all tables
  • GraphQL API

FARA_All_ForeignPrincipals

Table actions
  • GraphQL API for 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

44 rows where Registrant_Name = "International Council of Cruise Lines"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Foreign_Principal_Termination_Date, Foreign_Principal_Registration_Date, Address_1, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)

Foreign_Principal >30

  • Bahama Cruise Line, Inc. 1
  • Canadian Pacific 1
  • Carnival Cruise Lines 1
  • Celebrity Cruises, Inc. (formerly: Chandris America Lines, S.A.) 1
  • Clipper Line 1
  • Commodore Cruise Lines 1
  • Costa Line, Inc. 1
  • Crystal Cruises 1
  • Cunard Line 1
  • Dolphin Cruise Lines 1
  • Epirotiki Lines, Inc. 1
  • Fantasy Cruises 1
  • Flagship Cruises, Ltd. 1
  • French Line 1
  • German-Atlantic Line 1
  • Gotaas Larsen, Inc. (Eastern Steamship Lines) 1
  • Greek Line, Inc. 1
  • Hapag-Lloyd, A.G. 1
  • Hellenic Mediterranean Line Company, Ltd. 1
  • Holland-American Line 1
  • Home Lines 1
  • Incres Line 1
  • Italian Line 1
  • Italian Line Cruises International 1
  • National Hellenic America Line, C/O Chandris Line 1
  • North German Lloyd 1
  • Norwegian Caribbean Lines (Klosters Rederi) 1
  • Norwegian Cruiseships 1
  • Norwegian-American Line 1
  • Ocean Cruise Lines, S.A. 1
  • …

Country/Location_Represented 8

  • INTERNATIONAL 34
  • GREECE 3
  • ITALY 2
  • CANADA 1
  • FRANCE 1
  • GERMANY, FEDERAL REPUBLIC OF 1
  • NORWAY 1
  • SWEDEN 1

State 4

  • NY 22
  • - 13
  • FL 6
  • CA 3

Registrant_Name 1

  • International Council of Cruise Lines · 44 ✖

City 1

  • - 44
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
1467 1467 1971-01-25 North German Lloyd 1967-07-25 GERMANY, FEDERAL REPUBLIC OF International Council of Cruise Lines 2036 1967-07-25 International Council of Cruise Lines New York     NY  
1483 1483 1996-01-25 Carnival Cruise Lines 1979-05-14 INTERNATIONAL International Council of Cruise Lines 2036 1967-07-25 International Council of Cruise Lines Miami     FL  
1484 1484 1996-01-25 Celebrity Cruises, Inc. (formerly: Chandris America Lines, S.A.) 1970-04-30 INTERNATIONAL International Council of Cruise Lines 2036 1967-07-25 International Council of Cruise Lines Piraeus        
1485 1485 1996-01-25 Commodore Cruise Lines 1992-09-10 INTERNATIONAL International Council of Cruise Lines 2036 1967-07-25 International Council of Cruise Lines Coral Gables     FL  
1486 1486 1996-01-25 Costa Line, Inc. 1969-01-25 INTERNATIONAL International Council of Cruise Lines 2036 1967-07-25 International Council of Cruise Lines New York     NY  
1487 1487 1996-01-25 Cunard Line 1967-07-25 INTERNATIONAL International Council of Cruise Lines 2036 1967-07-25 International Council of Cruise Lines New York     NY  
1488 1488 1996-01-25 Norwegian Caribbean Lines (Klosters Rederi) 1978-03-02 INTERNATIONAL International Council of Cruise Lines 2036 1967-07-25 International Council of Cruise Lines Oslo        
1489 1489 1996-01-25 Premier Cruise Lines, Ltd. 1985-08-29 INTERNATIONAL International Council of Cruise Lines 2036 1967-07-25 International Council of Cruise Lines Georgetown        
1490 1490 1996-01-25 Royal Caribbean Cruise Line, Inc. 1971-01-08 INTERNATIONAL International Council of Cruise Lines 2036 1967-07-25 International Council of Cruise Lines       NY  
1491 1491 1996-01-25 Royal Olympic Cruises, Ltd. 1996-02-23 GREECE International Council of Cruise Lines 2036 1967-07-25 International Council of Cruise Lines Piraeus        
2445 2445 1994-02-14 Dolphin Cruise Lines 1992-09-10 INTERNATIONAL International Council of Cruise Lines 2036 1967-07-25 International Council of Cruise Lines Miami     FL  
2447 2447 1994-02-14 Regency Cruises, Inc. 1993-08-23 INTERNATIONAL International Council of Cruise Lines 2036 1967-07-25 International Council of Cruise Lines New York     NY  
3476 3476 1984-03-09 Norwegian-American Line 1967-07-25 NORWAY International Council of Cruise Lines 2036 1967-07-25 International Council of Cruise Lines New York     NY  
5538 5538 1975-04-28 Greek Line, Inc. 1967-07-25 GREECE International Council of Cruise Lines 2036 1967-07-25 International Council of Cruise Lines New York     NY  
5689 5689 1970-04-30 National Hellenic America Line, C/O Chandris Line 1967-07-25 GREECE International Council of Cruise Lines 2036 1967-07-25 International Council of Cruise Lines New York     NY  
6660 6660 1994-05-24 Crystal Cruises 1989-08-03 INTERNATIONAL International Council of Cruise Lines 2036 1967-07-25 International Council of Cruise Lines Los Angeles     CA  
6661 6661 1994-05-24 Fantasy Cruises 1993-08-23 INTERNATIONAL International Council of Cruise Lines 2036 1967-07-25 International Council of Cruise Lines Miami     FL  
6663 6663 1994-05-24 Holland-American Line 1967-07-25 INTERNATIONAL International Council of Cruise Lines 2036 1967-07-25 International Council of Cruise Lines New York     NY  
6666 6666 1994-05-24 Princess Cruises 1992-09-10 INTERNATIONAL International Council of Cruise Lines 2036 1967-07-25 International Council of Cruise Lines Los Angeles     CA  
6667 6667 1994-05-24 Royal Cruise Line, Ltd. 1986-08-19 INTERNATIONAL International Council of Cruise Lines 2036 1967-07-25 International Council of Cruise Lines          
6668 6668 1994-05-24 Royal Viking Line 1972-10-01 INTERNATIONAL International Council of Cruise Lines 2036 1967-07-25 International Council of Cruise Lines          
8147 8147 1974-06-30 Hapag-Lloyd, A.G. 1971-01-25 INTERNATIONAL International Council of Cruise Lines 2036 1967-07-25 International Council of Cruise Lines       NY  
8157 8157 1976-06-30 Italian Line 1967-07-25 ITALY International Council of Cruise Lines 2036 1967-07-25 International Council of Cruise Lines New York     NY  
8186 8186 1980-06-30 Italian Line Cruises International 1979-05-14 ITALY International Council of Cruise Lines 2036 1967-07-25 International Council of Cruise Lines New York     NY  
8717 8717 1988-07-01 Pearl Cruises of Scandinavia 1985-03-01 INTERNATIONAL International Council of Cruise Lines 2036 1967-07-25 International Council of Cruise Lines Copenhagen        
9539 9539 1973-07-31 Hellenic Mediterranean Line Company, Ltd. 1972-10-01 INTERNATIONAL International Council of Cruise Lines 2036 1967-07-25 International Council of Cruise Lines Piraeus        
10026 10026 1974-08-08 Norwegian Cruiseships 1972-10-01 INTERNATIONAL International Council of Cruise Lines 2036 1967-07-25 International Council of Cruise Lines Oslo        
11127 11127 1975-09-02 Swedish-American Line 1967-07-25 SWEDEN International Council of Cruise Lines 2036 1967-07-25 International Council of Cruise Lines New York     NY  
11427 11427 1974-09-15 French Line 1967-07-25 FRANCE International Council of Cruise Lines 2036 1967-07-25 International Council of Cruise Lines New York     NY  
11578 11578 1975-09-23 Incres Line 1967-07-25 INTERNATIONAL International Council of Cruise Lines 2036 1967-07-25 International Council of Cruise Lines New York     NY  
13879 13879 1990-11-21 Bahama Cruise Line, Inc. 1982-03-04 INTERNATIONAL International Council of Cruise Lines 2036 1967-07-25 International Council of Cruise Lines New York     NY  
13880 13880 1990-11-21 Canadian Pacific 1967-07-25 CANADA International Council of Cruise Lines 2036 1967-07-25 International Council of Cruise Lines New York     NY  
13881 13881 1990-11-21 Gotaas Larsen, Inc. (Eastern Steamship Lines) 1978-03-09 INTERNATIONAL International Council of Cruise Lines 2036 1967-07-25 International Council of Cruise Lines Miami     FL  
13882 13882 1990-11-21 Ocean Cruise Lines, S.A. 1985-03-01 INTERNATIONAL International Council of Cruise Lines 2036 1967-07-25 International Council of Cruise Lines Basel        
13883 13883 1990-11-21 P&O Lines, Inc. 1967-07-25 INTERNATIONAL International Council of Cruise Lines 2036 1967-07-25 International Council of Cruise Lines San Francisco     CA  
13884 13884 1990-11-21 Scandinavian World Cruises 1982-03-04 INTERNATIONAL International Council of Cruise Lines 2036 1967-07-25 International Council of Cruise Lines Miami     FL  
13885 13885 1990-11-21 Sitmar Cruises 1974-03-15 INTERNATIONAL International Council of Cruise Lines 2036 1967-07-25 International Council of Cruise Lines          
14396 14396 1973-12-01 German-Atlantic Line 1969-01-25 INTERNATIONAL International Council of Cruise Lines 2036 1967-07-25 International Council of Cruise Lines New York     NY  
14464 14464 1995-12-01 Epirotiki Lines, Inc. 1974-03-15 INTERNATIONAL International Council of Cruise Lines 2036 1967-07-25 International Council of Cruise Lines Piraeus        
14467 14467 1995-12-01 Sun Line 1969-03-01 INTERNATIONAL International Council of Cruise Lines 2036 1967-07-25 International Council of Cruise Lines       NY  
15408 15408 1969-12-31 Clipper Line 1967-07-25 INTERNATIONAL International Council of Cruise Lines 2036 1967-07-25 International Council of Cruise Lines New York     NY  
15431 15431 1972-12-31 Paquet Line 1969-03-01 INTERNATIONAL International Council of Cruise Lines 2036 1967-07-25 International Council of Cruise Lines          
15541 15541 1978-12-31 Flagship Cruises, Ltd. 1975-05-02 INTERNATIONAL International Council of Cruise Lines 2036 1967-07-25 International Council of Cruise Lines       NY  
15802 15802 1988-12-31 Home Lines 1967-07-25 INTERNATIONAL International Council of Cruise Lines 2036 1967-07-25 International Council of Cruise Lines New York     NY  

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 · Queries took 168.433ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history