FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
34 rows where Registration_Number = 62 sorted by Address_2
This data as json, CSV (advanced)
Suggested facets: Short_Form_Termination_Date (date)
State 1
- NY 34
Registration_Number 1
- Compagnie Generale Transatlantique (French Line) · 34 ✖
Registration_Date (date) 1 ✖
- 1942-07-27 34
Registrant_Name 1
City 1
- New York 34
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8605 | 8605 | 1946-03-01 | 1942-07-27 | Rousselle | Pierre | Compagnie Generale Transatlantique (French Line) 62 | 1942-07-27 | Compagnie Generale Transatlantique (French Line) | 17 State Street | New York | NY | ||
9675 | 9675 | 1945-03-12 | 1942-07-27 | de Linclays | Henri Morin | Compagnie Generale Transatlantique (French Line) 62 | 1942-07-27 | Compagnie Generale Transatlantique (French Line) | 17 State Street | New York | NY | ||
19262 | 19262 | 1945-06-12 | 1942-07-27 | Simon | Georges C. | Compagnie Generale Transatlantique (French Line) 62 | 1942-07-27 | Compagnie Generale Transatlantique (French Line) | 17 State Street | New York | NY | ||
20652 | 20652 | 1956-06-30 | 1946-10-21 | Quedec | Andre | Compagnie Generale Transatlantique (French Line) 62 | 1942-07-27 | Compagnie Generale Transatlantique (French Line) | 17 State Street | New York | NY | ||
24137 | 24137 | 1960-07-27 | 1960-03-01 | Balderiotti | Ottorino | Compagnie Generale Transatlantique (French Line) 62 | 1942-07-27 | Compagnie Generale Transatlantique (French Line) | 17 State Street | New York | NY | ||
24138 | 24138 | 1960-07-27 | 1960-03-04 | Flandreau | Guy Jean | Compagnie Generale Transatlantique (French Line) 62 | 1942-07-27 | Compagnie Generale Transatlantique (French Line) | 17 State Street | New York | NY | ||
24139 | 24139 | 1960-07-27 | 1959-03-20 | Latour | Jacques | Compagnie Generale Transatlantique (French Line) 62 | 1942-07-27 | Compagnie Generale Transatlantique (French Line) | 17 State Street | New York | NY | ||
24140 | 24140 | 1960-07-27 | 1942-07-27 | Borde | Pierre | Compagnie Generale Transatlantique (French Line) 62 | 1942-07-27 | Compagnie Generale Transatlantique (French Line) | 17 State Street | New York | NY | ||
24141 | 24141 | 1960-07-27 | 1942-07-27 | Castelnau | Marcel | Compagnie Generale Transatlantique (French Line) 62 | 1942-07-27 | Compagnie Generale Transatlantique (French Line) | 17 State Street | New York | NY | ||
24142 | 24142 | 1960-07-27 | 1942-07-27 | Courtois | Fernand P. | Compagnie Generale Transatlantique (French Line) 62 | 1942-07-27 | Compagnie Generale Transatlantique (French Line) | 17 State Street | New York | NY | ||
24143 | 24143 | 1960-07-27 | 1942-07-27 | Dendievel | P.H. | Compagnie Generale Transatlantique (French Line) 62 | 1942-07-27 | Compagnie Generale Transatlantique (French Line) | 17 State Street | New York | NY | ||
24144 | 24144 | 1960-07-27 | 1942-07-27 | Estachy | Robert | Compagnie Generale Transatlantique (French Line) 62 | 1942-07-27 | Compagnie Generale Transatlantique (French Line) | 17 State Street | New York | NY | ||
24145 | 24145 | 1960-07-27 | 1942-07-27 | Friant | Louis le | Compagnie Generale Transatlantique (French Line) 62 | 1942-07-27 | Compagnie Generale Transatlantique (French Line) | 17 State Street | New York | NY | ||
24146 | 24146 | 1960-07-27 | 1942-07-27 | Laluque | Jules | Compagnie Generale Transatlantique (French Line) 62 | 1942-07-27 | Compagnie Generale Transatlantique (French Line) | 17 State Street | New York | NY | ||
24147 | 24147 | 1960-07-27 | 1942-07-27 | Lebon | Jean | Compagnie Generale Transatlantique (French Line) 62 | 1942-07-27 | Compagnie Generale Transatlantique (French Line) | 17 State Street | New York | NY | ||
24148 | 24148 | 1960-07-27 | 1942-07-27 | Masson | Albert T. | Compagnie Generale Transatlantique (French Line) 62 | 1942-07-27 | Compagnie Generale Transatlantique (French Line) | 17 State Street | New York | NY | ||
24149 | 24149 | 1960-07-27 | 1942-07-27 | Moraillon | Georges J. | Compagnie Generale Transatlantique (French Line) 62 | 1942-07-27 | Compagnie Generale Transatlantique (French Line) | 17 State Street | New York | NY | ||
24150 | 24150 | 1960-07-27 | 1942-07-27 | Shepherd | Jeanne Henderickx | Compagnie Generale Transatlantique (French Line) 62 | 1942-07-27 | Compagnie Generale Transatlantique (French Line) | 17 State Street | New York | NY | ||
24151 | 24151 | 1960-07-27 | 1942-07-27 | Snelgrove | Madeleine | Compagnie Generale Transatlantique (French Line) 62 | 1942-07-27 | Compagnie Generale Transatlantique (French Line) | 17 State Street | New York | NY | ||
24152 | 24152 | 1960-07-27 | 1958-09-15 | Laluque | Jules | Compagnie Generale Transatlantique (French Line) 62 | 1942-07-27 | Compagnie Generale Transatlantique (French Line) | 17 State Street | New York | NY | ||
24153 | 24153 | 1960-07-27 | 1959-09-25 | Weber | Frank Anthony , Jr. | Compagnie Generale Transatlantique (French Line) 62 | 1942-07-27 | Compagnie Generale Transatlantique (French Line) | 17 State Street | New York | NY | ||
24154 | 24154 | 1960-07-27 | 1946-10-21 | Douguet | Jacques Y. | Compagnie Generale Transatlantique (French Line) 62 | 1942-07-27 | Compagnie Generale Transatlantique (French Line) | 17 State Street | New York | NY | ||
24155 | 24155 | 1960-07-27 | 1946-10-21 | de Berc | Guy | Compagnie Generale Transatlantique (French Line) 62 | 1942-07-27 | Compagnie Generale Transatlantique (French Line) | 17 State Street | New York | NY | ||
24156 | 24156 | 1960-07-27 | 1952-10-24 | Maltby | Germaine | Compagnie Generale Transatlantique (French Line) 62 | 1942-07-27 | Compagnie Generale Transatlantique (French Line) | 17 State Street | New York | NY | ||
24157 | 24157 | 1960-07-27 | 1956-11-14 | Courtois | Fernand Pierre | Compagnie Generale Transatlantique (French Line) 62 | 1942-07-27 | Compagnie Generale Transatlantique (French Line) | 17 State Street | New York | NY | ||
24158 | 24158 | 1960-07-27 | 1956-11-14 | Emery | Chester A. | Compagnie Generale Transatlantique (French Line) 62 | 1942-07-27 | Compagnie Generale Transatlantique (French Line) | 17 State Street | New York | NY | ||
24159 | 24159 | 1960-07-27 | 1956-11-14 | Geminiani | Mario | Compagnie Generale Transatlantique (French Line) 62 | 1942-07-27 | Compagnie Generale Transatlantique (French Line) | 17 State Street | New York | NY | ||
24160 | 24160 | 1960-07-27 | 1956-11-14 | Hogan | Charles Joseph | Compagnie Generale Transatlantique (French Line) 62 | 1942-07-27 | Compagnie Generale Transatlantique (French Line) | 17 State Street | New York | NY | ||
24161 | 24161 | 1960-07-27 | 1956-11-14 | Nolan | James Francis | Compagnie Generale Transatlantique (French Line) 62 | 1942-07-27 | Compagnie Generale Transatlantique (French Line) | 17 State Street | New York | NY | ||
24162 | 24162 | 1960-07-27 | 1956-11-14 | Rossi | Peter John | Compagnie Generale Transatlantique (French Line) 62 | 1942-07-27 | Compagnie Generale Transatlantique (French Line) | 17 State Street | New York | NY | ||
24163 | 24163 | 1960-07-27 | 1956-11-14 | Scotto | John | Compagnie Generale Transatlantique (French Line) 62 | 1942-07-27 | Compagnie Generale Transatlantique (French Line) | 17 State Street | New York | NY | ||
24164 | 24164 | 1960-07-27 | 1956-11-14 | Vesco | Jean Emile | Compagnie Generale Transatlantique (French Line) 62 | 1942-07-27 | Compagnie Generale Transatlantique (French Line) | 17 State Street | New York | NY | ||
39639 | 39639 | 1957-12-31 | 1956-11-14 | Delaporte | Marcel J. | Compagnie Generale Transatlantique (French Line) 62 | 1942-07-27 | Compagnie Generale Transatlantique (French Line) | 17 State Street | New York | NY | ||
39679 | 39679 | 1959-12-31 | 1956-11-14 | Chatron | Max | Compagnie Generale Transatlantique (French Line) 62 | 1942-07-27 | Compagnie Generale Transatlantique (French Line) | 17 State Street | New York | NY |
Advanced export
JSON shape: default, array, newline-delimited
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]) );