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

24 rows where Registration_Number = 62

View and edit SQL

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)

State

Country/Location_Represented

City

  • 24
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
5206 1945-04-23 Chargeurs Reunis - Compagnie Sud-Atlantique 1942-07-27 FRANCE 62 62 1942-07-27 Compagnie Generale Transatlantique (French Line) Paris        
5207 1946-04-23 Air France 1942-07-27 FRANCE 62 62 1942-07-27 Compagnie Generale Transatlantique (French Line) Paris        
9104 1960-07-27 Compagnie Generale d'Armement Maritime 1942-07-27 FRANCE 62 62 1942-07-27 Compagnie Generale Transatlantique (French Line) Paris        
9105 1960-07-27 Compagnie Nantaise des Chargeurs de L'Quest 1957-02-21 FRANCE 62 62 1942-07-27 Compagnie Generale Transatlantique (French Line) Nantes        
9106 1960-07-27 Compagnie d'Affretement et de Transport (C.A.T) 1958-09-29 FRANCE 62 62 1942-07-27 Compagnie Generale Transatlantique (French Line) Paris        
9107 1960-07-27 Societe Nationale d'Affretement 1942-07-27 FRANCE 62 62 1942-07-27 Compagnie Generale Transatlantique (French Line) Paris        
9108 1960-07-27 Societe Nouvelle d'Affretement et de Courtage 1957-05-02 FRANCE 62 62 1942-07-27 Compagnie Generale Transatlantique (French Line) Dinard        
9109 1960-07-27 Societe d'Armements de Gerance et d'Etudes Techniques 1942-07-27 FRANCE 62 62 1942-07-27 Compagnie Generale Transatlantique (French Line) Paris        
9110 1960-07-27 Air France Transatlantique 1942-07-27 FRANCE 62 62 1942-07-27 Compagnie Generale Transatlantique (French Line) Paris        
9111 1960-07-27 Association Petroliere 1944-03-10 FRANCE 62 62 1942-07-27 Compagnie Generale Transatlantique (French Line) Paris        
9112 1960-07-27 Compagnie Auxiliaire de Navigation 1942-07-27 FRANCE 62 62 1942-07-27 Compagnie Generale Transatlantique (French Line) Paris        
9113 1960-07-27 Compagnie Generale Transatlantique 1942-07-27 FRANCE 62 62 1942-07-27 Compagnie Generale Transatlantique (French Line) Paris        
9114 1960-07-27 Compagnie Havraise de Navigation a Vapeur 1957-02-21 FRANCE 62 62 1942-07-27 Compagnie Generale Transatlantique (French Line) Paris        
9115 1960-07-27 Compagnie de Navigation Europeenne 1957-02-21 FRANCE 62 62 1942-07-27 Compagnie Generale Transatlantique (French Line) Marseille        
9116 1960-07-27 French Colonial Supply Mission (for the Account of the Governor of Martinique) (F.W.I.) 1944-07-29 FRANCE 62 62 1942-07-27 Compagnie Generale Transatlantique (French Line) New York     NY  
9117 1960-07-27 Maurel & Prom 1942-07-27 FRANCE 62 62 1942-07-27 Compagnie Generale Transatlantique (French Line) Paris        
9118 1960-07-27 Messageries Maritimes 1942-07-27 FRANCE 62 62 1942-07-27 Compagnie Generale Transatlantique (French Line) Paris        
9119 1960-07-27 Mission des Transports Maritimes (French Maritime Commission) 1942-07-27 FRANCE 62 62 1942-07-27 Compagnie Generale Transatlantique (French Line) Paris        
9120 1960-07-27 Societe Francasie des Transports Petroliers 1942-07-27 FRANCE 62 62 1942-07-27 Compagnie Generale Transatlantique (French Line) Paris        
9121 1960-07-27 Societe Generale des Transports Maritimes a Vapeur 1942-07-27 FRANCE 62 62 1942-07-27 Compagnie Generale Transatlantique (French Line) Paris        
9122 1960-07-27 Societe Maritime Nationale 1957-02-21 FRANCE 62 62 1942-07-27 Compagnie Generale Transatlantique (French Line) Paris        
9123 1960-07-27 Societe Navale Caennaise 1957-02-21 FRANCE 62 62 1942-07-27 Compagnie Generale Transatlantique (French Line) Paris        
9124 1960-07-27 Societe des Voyages et Hotels Nord-Africains 1942-07-27 FRANCE 62 62 1942-07-27 Compagnie Generale Transatlantique (French Line) Paris        
9125 1960-07-27 Union Industrielle et Maritime 1957-02-21 FRANCE 62 62 1942-07-27 Compagnie Generale Transatlantique (French Line) Paris        

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