FARA_All_ShortForms

List of all short form registrants (active and terminated)

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

34 rows where Registration_Number = 62

View and edit SQL

Suggested facets: Short_Form_Termination_Date, Short_Form_Date, Short_Form_Termination_Date (date), Short_Form_Date (date), Registration_Date (date)

State

Registration_Number

City

Link rowid ▼ Short_Form_Termination_Date Short_Form_Date Short_Form_Last_Name Short_Form_First_Name Registration_Number Registration_Date Registrant_Name Address_1 Address_2 City State Zip
8140 1946-03-01 1942-07-27 Rousselle Pierre 62 62 1942-07-27 Compagnie Generale Transatlantique (French Line) 17 State Street   New York NY  
9142 1945-03-12 1942-07-27 de Linclays Henri Morin 62 62 1942-07-27 Compagnie Generale Transatlantique (French Line) 17 State Street   New York NY  
18196 1945-06-12 1942-07-27 Simon Georges C. 62 62 1942-07-27 Compagnie Generale Transatlantique (French Line) 17 State Street   New York NY  
19542 1956-06-30 1946-10-21 Quedec Andre 62 62 1942-07-27 Compagnie Generale Transatlantique (French Line) 17 State Street   New York NY  
22847 1960-07-27 1960-03-01 Balderiotti Ottorino 62 62 1942-07-27 Compagnie Generale Transatlantique (French Line) 17 State Street   New York NY  
22848 1960-07-27 1960-03-04 Flandreau Guy Jean 62 62 1942-07-27 Compagnie Generale Transatlantique (French Line) 17 State Street   New York NY  
22849 1960-07-27 1959-03-20 Latour Jacques 62 62 1942-07-27 Compagnie Generale Transatlantique (French Line) 17 State Street   New York NY  
22850 1960-07-27 1942-07-27 Borde Pierre 62 62 1942-07-27 Compagnie Generale Transatlantique (French Line) 17 State Street   New York NY  
22851 1960-07-27 1942-07-27 Castelnau Marcel 62 62 1942-07-27 Compagnie Generale Transatlantique (French Line) 17 State Street   New York NY  
22852 1960-07-27 1942-07-27 Courtois Fernand P. 62 62 1942-07-27 Compagnie Generale Transatlantique (French Line) 17 State Street   New York NY  
22853 1960-07-27 1942-07-27 Dendievel P.H. 62 62 1942-07-27 Compagnie Generale Transatlantique (French Line) 17 State Street   New York NY  
22854 1960-07-27 1942-07-27 Estachy Robert 62 62 1942-07-27 Compagnie Generale Transatlantique (French Line) 17 State Street   New York NY  
22855 1960-07-27 1942-07-27 Friant Louis le 62 62 1942-07-27 Compagnie Generale Transatlantique (French Line) 17 State Street   New York NY  
22856 1960-07-27 1942-07-27 Laluque Jules 62 62 1942-07-27 Compagnie Generale Transatlantique (French Line) 17 State Street   New York NY  
22857 1960-07-27 1942-07-27 Lebon Jean 62 62 1942-07-27 Compagnie Generale Transatlantique (French Line) 17 State Street   New York NY  
22858 1960-07-27 1942-07-27 Masson Albert T. 62 62 1942-07-27 Compagnie Generale Transatlantique (French Line) 17 State Street   New York NY  
22859 1960-07-27 1942-07-27 Moraillon Georges J. 62 62 1942-07-27 Compagnie Generale Transatlantique (French Line) 17 State Street   New York NY  
22860 1960-07-27 1942-07-27 Shepherd Jeanne Henderickx 62 62 1942-07-27 Compagnie Generale Transatlantique (French Line) 17 State Street   New York NY  
22861 1960-07-27 1942-07-27 Snelgrove Madeleine 62 62 1942-07-27 Compagnie Generale Transatlantique (French Line) 17 State Street   New York NY  
22862 1960-07-27 1958-09-15 Laluque Jules 62 62 1942-07-27 Compagnie Generale Transatlantique (French Line) 17 State Street   New York NY  
22863 1960-07-27 1959-09-25 Weber Frank Anthony , Jr. 62 62 1942-07-27 Compagnie Generale Transatlantique (French Line) 17 State Street   New York NY  
22864 1960-07-27 1946-10-21 Douguet Jacques Y. 62 62 1942-07-27 Compagnie Generale Transatlantique (French Line) 17 State Street   New York NY  
22865 1960-07-27 1946-10-21 de Berc Guy 62 62 1942-07-27 Compagnie Generale Transatlantique (French Line) 17 State Street   New York NY  
22866 1960-07-27 1952-10-24 Maltby Germaine 62 62 1942-07-27 Compagnie Generale Transatlantique (French Line) 17 State Street   New York NY  
22867 1960-07-27 1956-11-14 Courtois Fernand Pierre 62 62 1942-07-27 Compagnie Generale Transatlantique (French Line) 17 State Street   New York NY  
22868 1960-07-27 1956-11-14 Emery Chester A. 62 62 1942-07-27 Compagnie Generale Transatlantique (French Line) 17 State Street   New York NY  
22869 1960-07-27 1956-11-14 Geminiani Mario 62 62 1942-07-27 Compagnie Generale Transatlantique (French Line) 17 State Street   New York NY  
22870 1960-07-27 1956-11-14 Hogan Charles Joseph 62 62 1942-07-27 Compagnie Generale Transatlantique (French Line) 17 State Street   New York NY  
22871 1960-07-27 1956-11-14 Nolan James Francis 62 62 1942-07-27 Compagnie Generale Transatlantique (French Line) 17 State Street   New York NY  
22872 1960-07-27 1956-11-14 Rossi Peter John 62 62 1942-07-27 Compagnie Generale Transatlantique (French Line) 17 State Street   New York NY  
22873 1960-07-27 1956-11-14 Scotto John 62 62 1942-07-27 Compagnie Generale Transatlantique (French Line) 17 State Street   New York NY  
22874 1960-07-27 1956-11-14 Vesco Jean Emile 62 62 1942-07-27 Compagnie Generale Transatlantique (French Line) 17 State Street   New York NY  
37608 1957-12-31 1956-11-14 Delaporte Marcel J. 62 62 1942-07-27 Compagnie Generale Transatlantique (French Line) 17 State Street   New York NY  
37648 1959-12-31 1956-11-14 Chatron Max 62 62 1942-07-27 Compagnie Generale Transatlantique (French Line) 17 State Street   New York NY  

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [FARA_All_ShortForms] (
   [Short_Form_Termination_Date] TEXT,
   [Short_Form_Date] TEXT,
   [Short_Form_Last_Name] TEXT,
   [Short_Form_First_Name] TEXT,
   [Registration_Number] INTEGER,
   [Registration_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 374.654ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history