FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
69 rows where "Registration_Date" is on date 1942-07-27
This data as json, CSV (advanced)
Suggested facets: Zip, Registration_Date (date)
Registration_Number 4
Registrant_Name 4
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 | ||
8947 | 8947 | 1950-03-02 | 1943-05-20 | Hedin | Naboth | Swedish Tourist Office 68 | 1942-07-27 | Swedish Tourist Office | 655 Third Avenue | 18th Floor | New York | NY | 10017 |
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 | ||
10645 | 10645 | 1964-03-24 | 1953-03-11 | Pagel | Alex John | Swedish Tourist Office 68 | 1942-07-27 | Swedish Tourist Office | 655 Third Avenue | 18th Floor | New York | NY | 10017 |
12380 | 12380 | 1963-04-01 | 1960-08-25 | Nystrom | Jan Olof Gustaf | Swedish Tourist Office 68 | 1942-07-27 | Swedish Tourist Office | 655 Third Avenue | 18th Floor | New York | NY | 10017 |
12756 | 12756 | 1966-04-05 | 1966-04-05 | Schou | Jack | Swedish Tourist Office 68 | 1942-07-27 | Swedish Tourist Office | 655 Third Avenue | 18th Floor | New York | NY | 10017 |
13058 | 13058 | 1946-04-10 | 1943-05-20 | Pagel | Alex J. | Swedish Tourist Office 68 | 1942-07-27 | Swedish Tourist Office | 655 Third Avenue | 18th Floor | New York | NY | 10017 |
13598 | 13598 | 1956-04-17 | 1954-01-15 | Tranaeus | Jarl Einar | Swedish Tourist Office 68 | 1942-07-27 | Swedish Tourist Office | 655 Third Avenue | 18th Floor | New York | NY | 10017 |
17001 | 17001 | 1965-05-24 | 1947-08-19 | Kastrup | Hans Sture Allan | Swedish Tourist Office 68 | 1942-07-27 | Swedish Tourist Office | 655 Third Avenue | 18th Floor | New York | NY | 10017 |
17215 | 17215 | 1966-05-27 | 1966-04-05 | Ohrstrom | Nils A. | Swedish Tourist Office 68 | 1942-07-27 | Swedish Tourist Office | 655 Third Avenue | 18th Floor | New York | NY | 10017 |
17548 | 17548 | 1949-05-31 | 1948-05-06 | Norberg | Gard Ellwyn | Swedish Tourist Office 68 | 1942-07-27 | Swedish Tourist Office | 655 Third Avenue | 18th Floor | New York | NY | 10017 |
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 | ||
19504 | 19504 | 1970-06-15 | 1970-06-01 | Conradson | Edgar A. | Swedish Tourist Office 68 | 1942-07-27 | Swedish Tourist Office | 655 Third Avenue | 18th Floor | New York | NY | 10017 |
20640 | 20640 | 1953-06-30 | 1951-03-12 | Sjogren | Karl Erik Gustaf | Swedish Tourist Office 68 | 1942-07-27 | Swedish Tourist Office | 655 Third Avenue | 18th Floor | New York | NY | 10017 |
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 | ||
22050 | 22050 | 1962-07-01 | 1961-01-18 | Nordberg | Curt Bjorn Morgan | Swedish Tourist Office 68 | 1942-07-27 | Swedish Tourist Office | 655 Third Avenue | 18th Floor | New York | NY | 10017 |
22092 | 22092 | 1972-07-01 | 1964-04-20 | Gille | Ake | Swedish Tourist Office 68 | 1942-07-27 | Swedish Tourist Office | 655 Third Avenue | 18th Floor | New York | NY | 10017 |
22512 | 22512 | 1968-07-03 | 1967-10-17 | Bonde | Thord | Swedish Tourist Office 68 | 1942-07-27 | Swedish Tourist Office | 655 Third Avenue | 18th Floor | New York | NY | 10017 |
22941 | 22941 | 1968-07-11 | 1965-09-03 | Naslundh | Lars Erik Gote | Swedish Tourist Office 68 | 1942-07-27 | Swedish Tourist Office | 655 Third Avenue | 18th Floor | New York | NY | 10017 |
24122 | 24122 | 1942-07-27 | 1942-07-27 | Atkins | Leslie C. | Anchor Line, Ltd. 66 | 1942-07-27 | Anchor Line, Ltd. | 12-14 St. Vincent Place | Glasgow | |||
24123 | 24123 | 1942-07-27 | 1942-07-27 | Hanssler | John A. | Anchor Line, Ltd. 66 | 1942-07-27 | Anchor Line, Ltd. | 12-14 St. Vincent Place | Glasgow | |||
24124 | 24124 | 1942-07-27 | 1942-07-27 | Whitmore | F.W. | Anchor Line, Ltd. 66 | 1942-07-27 | Anchor Line, Ltd. | 12-14 St. Vincent Place | Glasgow | |||
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 | ||
25436 | 25436 | 1952-08-01 | 1947-02-24 | Ekman | Elon Victor | Swedish Tourist Office 68 | 1942-07-27 | Swedish Tourist Office | 655 Third Avenue | 18th Floor | New York | NY | 10017 |
26303 | 26303 | 1965-08-09 | 1964-04-01 | Gronkvist | Uno | Swedish Tourist Office 68 | 1942-07-27 | Swedish Tourist Office | 655 Third Avenue | 18th Floor | New York | NY | 10017 |
35641 | 35641 | 1973-11-12 | 1954-01-15 | Tholand | Nils Kristian Gustav | Swedish Tourist Office 68 | 1942-07-27 | Swedish Tourist Office | 655 Third Avenue | 18th Floor | New York | NY | 10017 |
35642 | 35642 | 1973-11-12 | 1947-02-24 | Lonegren | Sigfrid K. | Swedish Tourist Office 68 | 1942-07-27 | Swedish Tourist Office | 655 Third Avenue | 18th Floor | New York | NY | 10017 |
35643 | 35643 | 1973-11-12 | 1956-03-12 | Malmstrom | Lars Gosta | Swedish Tourist Office 68 | 1942-07-27 | Swedish Tourist Office | 655 Third Avenue | 18th Floor | New York | NY | 10017 |
35645 | 35645 | 1973-11-12 | 1946-04-24 | Henriknilert | Tore | Swedish Tourist Office 68 | 1942-07-27 | Swedish Tourist Office | 655 Third Avenue | 18th Floor | New York | NY | 10017 |
36633 | 36633 | 1977-11-30 | 1937-01-01 | Prag | Per | Swedish Tourist Office 68 | 1942-07-27 | Swedish Tourist Office | 655 Third Avenue | 18th Floor | New York | NY | 10017 |
37371 | 37371 | 1983-12-01 | 1980-10-07 | Conradi | Trond | Swedish Tourist Office 68 | 1942-07-27 | Swedish Tourist Office | 655 Third Avenue | 18th Floor | New York | NY | 10017 |
39472 | 39472 | 1942-12-31 | 1942-07-27 | Brown | Howard C. | Brown, Howard C. 64 | 1942-07-27 | Brown, Howard C. | 6404 Sunset Boulevard | Hollywood | CA | ||
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 | ||
39687 | 39687 | 1960-12-31 | 1943-05-20 | Nordholm | Birger Josef | Swedish Tourist Office 68 | 1942-07-27 | Swedish Tourist Office | 655 Third Avenue | 18th Floor | New York | NY | 10017 |
39886 | 39886 | 1970-12-31 | 1968-07-05 | Moller | Britt Marie | Swedish Tourist Office 68 | 1942-07-27 | Swedish Tourist Office | 655 Third Avenue | 18th Floor | New York | NY | 10017 |
39908 | 39908 | 1972-12-31 | 1970-01-27 | Munktell | Agneta | Swedish Tourist Office 68 | 1942-07-27 | Swedish Tourist Office | 655 Third Avenue | 18th Floor | New York | NY | 10017 |
39957 | 39957 | 1974-12-31 | 1973-02-22 | Axen | Per Ulrik | Swedish Tourist Office 68 | 1942-07-27 | Swedish Tourist Office | 655 Third Avenue | 18th Floor | New York | NY | 10017 |
40004 | 40004 | 1976-12-31 | 1973-02-22 | Malmstrom | Ingred Astrid Louise | Swedish Tourist Office 68 | 1942-07-27 | Swedish Tourist Office | 655 Third Avenue | 18th Floor | New York | NY | 10017 |
40477 | 40477 | 1988-12-31 | 1943-04-21 | Johanneson | Nils R. | Swedish Tourist Office 68 | 1942-07-27 | Swedish Tourist Office | 655 Third Avenue | 18th Floor | New York | NY | 10017 |
40491 | 40491 | 1988-12-31 | 1943-05-20 | Izard | Forrest | Swedish Tourist Office 68 | 1942-07-27 | Swedish Tourist Office | 655 Third Avenue | 18th Floor | New York | NY | 10017 |
40492 | 40492 | 1988-12-31 | 1943-05-20 | Lundbeck | G. Hilmer | Swedish Tourist Office 68 | 1942-07-27 | Swedish Tourist Office | 655 Third Avenue | 18th Floor | New York | NY | 10017 |
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]) );