FARA_All_ForeignPrincipals

Table actions
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 Registration_Number = 2036

✎ 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)

Country/Location_Represented 8

State 4

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
1502 1502 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  
1518 1518 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  
1519 1519 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        
1520 1520 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  
1521 1521 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  
1522 1522 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  
1523 1523 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        
1524 1524 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        
1525 1525 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  
1526 1526 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        
2491 2491 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  
2493 2493 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  
3542 3542 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  
5641 5641 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  
5793 5793 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  
6779 6779 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  
6780 6780 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  
6782 6782 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  
6785 6785 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  
6786 6786 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          
6787 6787 1994-05-24 Royal Viking Line 1972-10-01 INTERNATIONAL International Council of Cruise Lines 2036 1967-07-25 International Council of Cruise Lines          
8294 8294 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  
8304 8304 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  
8333 8333 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  
8874 8874 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        
9710 9710 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        
10203 10203 1974-08-08 Norwegian Cruiseships 1972-10-01 INTERNATIONAL International Council of Cruise Lines 2036 1967-07-25 International Council of Cruise Lines Oslo        
11321 11321 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  
11623 11623 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  
11775 11775 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  
14117 14117 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  
14118 14118 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  
14119 14119 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  
14120 14120 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        
14121 14121 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  
14122 14122 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  
14123 14123 1990-11-21 Sitmar Cruises 1974-03-15 INTERNATIONAL International Council of Cruise Lines 2036 1967-07-25 International Council of Cruise Lines          
14639 14639 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  
14707 14707 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        
14710 14710 1995-12-01 Sun Line 1969-03-01 INTERNATIONAL International Council of Cruise Lines 2036 1967-07-25 International Council of Cruise Lines       NY  
15667 15667 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  
15690 15690 1972-12-31 Paquet Line 1969-03-01 INTERNATIONAL International Council of Cruise Lines 2036 1967-07-25 International Council of Cruise Lines          
15800 15800 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  
16061 16061 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])
);