FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
12,537 rows where State = "" sorted by Registration_Number
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Registrant_Name >30
- Hill and Knowlton Strategies, LLC 197
- Gebhardt, H.A. 158
- Modern Education Services, Inc. 140
- Ruder Finn, Inc. 128
- Daniel J. Edelman, Inc. 113
- Arnold & Porter Kaye Scholer LLP 112
- Amtorg Trading Corporation 108
- Squire Patton Boggs, LLP 94
- Fleishman-Hillard, Inc. 75
- Koenig, Harry D. 67
- Burson-Marsteller 66
- Jones Day 59
- Akin, Gump, Strauss, Hauer & Feld, LLP 56
- Development Counsellors International 48
- IPG DXTRA, Inc 48
- Hogan Lovells US LLP 47
- White & Case, LLP 47
- Covington & Burling 44
- DLA Piper US LLP 43
- Netherland Publishing Corporation 43
- GCI Group, Inc. 42
- APCO Worldwide, Inc. 37
- Union Nacional Sinarquista 37
- JWI, LLC 36
- Daniels, Houlihan & Palmeter 35
- Pan-American Coffee Bureau 35
- Dow, Lohnes & Albertson, L.L.P. 34
- Milbank, Tweed, Hadley & McCloy 34
- Fasturn, Inc. 33
- Kelly, Nason, Inc. 33
- …
Foreign_Principal >30
- Jamaica Tourist Board 26
- Government of the Dominican Republic 24
- Hong Kong Trade Development Council 24
- Republic of Haiti 24
- Intourist 20
- Government of Haiti 19
- Republic of the Philippines 18
- CEDOK 17
- Algoma Steel Corporation, Ltd. 16
- Federal Republic of Nigeria 16
- Government of Jamaica 16
- Government of Aruba 15
- Government of Pakistan 15
- Republic of Liberia 15
- Dofasco, Inc. 14
- Republic of Indonesia 14
- Dominican Republic 13
- Government of Guatemala 13
- Japan Fisheries Association 13
- Korea Trade Promotion Corporation 13
- Republic of Panama 13
- Kingdom of Morocco 12
- Mexican National Tourist Council 12
- ORBIS 12
- Scottish Development Agency 12
- Canadian Tubular Producers' Association 11
- Electronic Industries Association of Japan 11
- Embassy of Japan 11
- Government of Bermuda 11
- Government of Canada 11
- …
Country/Location_Represented >30
- CANADA 716
- JAPAN 712
- MEXICO 513
- GREAT BRITAIN 470
- FRANCE 364
- GERMANY, FEDERAL REPUBLIC OF 324
- KOREA, SOUTH 282
- RUSSIA 226
- USSR 224
- CHINA 205
- DOMINICAN REPUBLIC 205
- ISRAEL 187
- TAIWAN 181
- NETHERLANDS 176
- SAUDI ARABIA 156
- ITALY 153
- INTERNATIONAL 144
- SWITZERLAND 144
- GERMANY 143
- UKRAINE 140
- AUSTRALIA 139
- PHILIPPINES 139
- CUBA 138
- BRAZIL 137
- POLAND 132
- HAITI 130
- PANAMA 126
- SWEDEN 124
- VENEZUELA 124
- JAMAICA 119
- …
City >30
- - 11,594
- Kyiv 29
- Dubai 22
- London 22
- Moscow 22
- Riyadh 20
- Baghdad 19
- Doha 18
- Abu Dhabi 15
- Brussels 12
- Seoul 12
- Tbilisi 12
- Monrovia 11
- Bogota 10
- San Salvador 10
- Tokyo 10
- Toronto 10
- Tripoli 10
- Amman 9
- Beijing 9
- Bucharest 9
- Cairo 9
- Abuja 8
- Georgetown 8
- Quito 8
- Abidjan 7
- Belgrade 7
- Berlin 7
- Kiev 7
- Washington 7
- …
State 1
- - · 12,537 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13838 | 13838 | 1942-11-09 | Agence Teleradio | 1942-09-14 | FRANCE | Estrangin, Gustave Fritsch 1 | 1942-09-14 | Estrangin, Gustave Fritsch | Vichy | ||||
8795 | 8795 | 1945-07-01 | Direccion General del Turismo (Direction General of Tourism) | 1942-07-03 | SPAIN | Garcia-Rubiera, Marcelino 2 | 1942-07-03 | Garcia-Rubiera, Marcelino | Madrid | ||||
8968 | 8968 | 1943-07-03 | Associated Distributors Party, Ltd. | 1942-07-03 | AUSTRALIA | Auten, Harold 4 | 1942-07-03 | Auten, Harold | Sydney | ||||
8969 | 8969 | 1943-07-03 | British Empire Films (N.Z.), Ltd. | 1942-07-03 | NEW ZEALAND | Auten, Harold 4 | 1942-07-03 | Auten, Harold | Wellington | ||||
8970 | 8970 | 1943-07-03 | British Empire Films Party, Ltd., Australia | 1942-07-03 | AUSTRALIA | Auten, Harold 4 | 1942-07-03 | Auten, Harold | Sydney | ||||
8971 | 8971 | 1943-07-03 | British Empire Films Party, Ltd., England | 1942-07-03 | GREAT BRITAIN | Auten, Harold 4 | 1942-07-03 | Auten, Harold | London, England | ||||
8972 | 8972 | 1943-07-03 | Cinesound Productions Party, Ltd. | 1942-07-03 | AUSTRALIA | Auten, Harold 4 | 1942-07-03 | Auten, Harold | |||||
8973 | 8973 | 1943-07-03 | Greater Union Theatres Party, Ltd. | 1942-07-03 | AUSTRALIA | Auten, Harold 4 | 1942-07-03 | Auten, Harold | |||||
8974 | 8974 | 1943-07-03 | Theatre Management, Ltd. | 1942-07-03 | NEW ZEALAND | Auten, Harold 4 | 1942-07-03 | Auten, Harold | Wellington | ||||
9029 | 9029 | 1946-07-06 | Exiled Autonomous Basque Government/Jose' A. de Aguirre | 1942-07-06 | GREAT BRITAIN | De La Sota y Aburto, Manuel 5 | 1942-07-06 | De La Sota y Aburto, Manuel | Londong, England | ||||
9030 | 9030 | 1946-07-06 | Basque Delegation in the U.S.A. | 1943-03-10 | GREAT BRITAIN | De La Sota y Aburto, Manuel 5 | 1942-07-06 | De La Sota y Aburto, Manuel | London, England | ||||
11496 | 11496 | 1951-09-11 | Agerpress | 1951-04-20 | ROMANIA | Black, Helen 6 | 1942-07-06 | Black, Helen | Bucharest | ||||
11497 | 11497 | 1951-09-11 | China Photo Service | 1950-11-16 | CHINA | Black, Helen 6 | 1942-07-06 | Black, Helen | Peking | ||||
11498 | 11498 | 1951-09-11 | Czechopress, Feature-Photo Service | 1950-11-16 | CZECHOSLOVAKIA | Black, Helen 6 | 1942-07-06 | Black, Helen | Prague | ||||
11499 | 11499 | 1951-09-11 | Hungarian Bulletin | 1950-11-16 | HUNGARY | Black, Helen 6 | 1942-07-06 | Black, Helen | Budapest | ||||
11500 | 11500 | 1951-09-11 | Mezhdunarodnaya Kniga | 1942-07-06 | USSR | Black, Helen 6 | 1942-07-06 | Black, Helen | |||||
11501 | 11501 | 1951-09-11 | Olga de Wolkonsky | 1949-08-05 | ARGENTINA | Black, Helen 6 | 1942-07-06 | Black, Helen | Buenos Aires | ||||
11502 | 11502 | 1951-09-11 | Photoagency | 1944-03-13 | USSR | Black, Helen 6 | 1942-07-06 | Black, Helen | Moscow | ||||
11504 | 11504 | 1951-09-11 | Presslit (Press & Publisher Literary Agency of the U.S.S.R.) | 1944-03-13 | USSR | Black, Helen 6 | 1942-07-06 | Black, Helen | Moscow | ||||
11505 | 11505 | 1951-09-11 | TASS (Telegraph Agency of the U.S.S.R.) | 1942-07-06 | USSR | Black, Helen 6 | 1942-07-06 | Black, Helen | |||||
9052 | 9052 | 1942-07-07 | Societe Nationale des Chemins de Fer Francais | 1942-07-07 | FRANCE | French National Railroads, New York 8 | 1942-07-07 | French National Railroads, New York | |||||
1316 | 1316 | 1973-01-15 | Suomen-Matkat (Association Finland-Travel) | 1942-07-07 | FINLAND | Finnish Information Center 9 | 1942-07-07 | Finnish Information Center | Helsinki | ||||
3827 | 3827 | 1943-03-17 | Ministry of Foreign Affairs | 1943-03-17 | FINLAND | Finnish Information Center 9 | 1942-07-07 | Finnish Information Center | Helsinki | ||||
1293 | 1293 | 1943-01-15 | Ministry for Foreign Affairs | 1943-03-17 | FINLAND | Ramo, Herman Rudolf Kristian 10 | 1942-07-07 | Ramo, Herman Rudolf Kristian | Helsinki | ||||
1294 | 1294 | 1943-01-15 | Suomen-Matkat (Association Finland Travel) | 1942-07-07 | FINLAND | Ramo, Herman Rudolf Kristian 10 | 1942-07-07 | Ramo, Herman Rudolf Kristian | Helsinki | ||||
1057 | 1057 | 1949-01-03 | His Imperial Highness The Grand Duke Wladimir of Russia | 1942-07-07 | USSR | Pouschine, Ivan 11 | 1942-07-07 | Pouschine, Ivan | Madrid | ||||
9051 | 9051 | 1942-07-07 | Exiled Autonomous Basque Government | 1942-07-07 | GREAT BRITAIN | De La Sota y Macmahon, Ramon 12 | 1942-07-07 | De La Sota y Macmahon, Ramon | London, England | ||||
8835 | 8835 | 1971-07-01 | Swedish Government | 1942-07-06 | SWEDEN | Swedish-American Chamber of Commerce, Inc. 13 | 1942-07-06 | Swedish-American Chamber of Commerce, Inc. | Stockholm | ||||
10822 | 10822 | 1972-08-29 | ABL&P Widengren | 1969-08-05 | SWEDEN | Swedish-American Chamber of Commerce, Inc. 13 | 1942-07-06 | Swedish-American Chamber of Commerce, Inc. | Vingaker | ||||
10823 | 10823 | 1972-08-29 | Port of Gothenburg | 1969-08-05 | SWEDEN | Swedish-American Chamber of Commerce, Inc. 13 | 1942-07-06 | Swedish-American Chamber of Commerce, Inc. | Gothenburg | ||||
9088 | 9088 | 1943-07-08 | Internatioal Transport Workers' Federation | 1942-07-08 | INTERNATIONAL | Lipsett, Alexander S. 14 | 1942-07-08 | Lipsett, Alexander S. | Bedford, England | ||||
1136 | 1136 | 1946-01-08 | Agencia Maritima | 1944-08-04 | ARGENTINA | Garcia & Diaz 16 | 1942-07-08 | Garcia & Diaz | Buenos Aires | ||||
1137 | 1137 | 1946-01-08 | Antonio Menchaca y Compania | 1944-08-04 | SPAIN | Garcia & Diaz 16 | 1942-07-08 | Garcia & Diaz | Bilbao | ||||
1138 | 1138 | 1946-01-08 | Auxiliar Maritima | 1944-08-04 | SPAIN | Garcia & Diaz 16 | 1942-07-08 | Garcia & Diaz | Bilbao | ||||
1139 | 1139 | 1946-01-08 | Compania Espanola de Navegacion Maritima, S.A. | 1942-07-08 | SPAIN | Garcia & Diaz 16 | 1942-07-08 | Garcia & Diaz | Barcelona | ||||
1140 | 1140 | 1946-01-08 | Compania Naviera Espanola | 1944-08-04 | SPAIN | Garcia & Diaz 16 | 1942-07-08 | Garcia & Diaz | Madrid | ||||
1141 | 1141 | 1946-01-08 | Compania Naviera Vascongada | 1944-08-04 | SPAIN | Garcia & Diaz 16 | 1942-07-08 | Garcia & Diaz | |||||
1142 | 1142 | 1946-01-08 | Compania Trasatlantica, Administrada por el Estado-Apartado | 1942-07-08 | SPAIN | Garcia & Diaz 16 | 1942-07-08 | Garcia & Diaz | Madrid | ||||
1143 | 1143 | 1946-01-08 | Compania Trasmediterranea | 1942-07-08 | SPAIN | Garcia & Diaz 16 | 1942-07-08 | Garcia & Diaz | Madrid | ||||
1144 | 1144 | 1946-01-08 | Guayaquil & Quito Railway Company | 1944-08-04 | ECUADOR | Garcia & Diaz 16 | 1942-07-08 | Garcia & Diaz | Quito | ||||
1145 | 1145 | 1946-01-08 | Hellenic Lines, Ltd. | 1942-07-08 | GREECE | Garcia & Diaz 16 | 1942-07-08 | Garcia & Diaz | Pireaus | ||||
1146 | 1146 | 1946-01-08 | Hijo de Ramon Ramos | 1944-08-04 | SPAIN | Garcia & Diaz 16 | 1942-07-08 | Garcia & Diaz | Barcelona | ||||
1147 | 1147 | 1946-01-08 | Islena Maritima, S.A. | 1943-03-09 | SPAIN | Garcia & Diaz 16 | 1942-07-08 | Garcia & Diaz | Madrid | ||||
1148 | 1148 | 1946-01-08 | Jose Navas Escuder | 1944-08-04 | SPAIN | Garcia & Diaz 16 | 1942-07-08 | Garcia & Diaz | Barcelona | ||||
1149 | 1149 | 1946-01-08 | Orion Compania Naviera | 1944-08-04 | SPAIN | Garcia & Diaz 16 | 1942-07-08 | Garcia & Diaz | Madrid | ||||
1150 | 1150 | 1946-01-08 | Sud Americana de Exportacion e Importacion S.R., Ltda. | 1943-03-09 | ARGENTINA | Garcia & Diaz 16 | 1942-07-08 | Garcia & Diaz | Buenos Aires | ||||
1151 | 1151 | 1946-01-08 | West Hartlepool Steam Navigation Company | 1942-07-08 | GREAT BRITAIN | Garcia & Diaz 16 | 1942-07-08 | Garcia & Diaz | London, England | ||||
15003 | 15003 | 1950-12-11 | Belgian Information Center | 1942-07-08 | BELGIUM | Gotham Advertising Company 17 | 1942-07-08 | Gotham Advertising Company | |||||
15004 | 15004 | 1950-12-11 | Fred L. Myers & Son | 1942-07-08 | JAMAICA | Gotham Advertising Company 17 | 1942-07-08 | Gotham Advertising Company | Kingston | ||||
15005 | 15005 | 1950-12-11 | Gotham (Australasia) Party, Ltd. | 1942-07-08 | AUSTRALIA | Gotham Advertising Company 17 | 1942-07-08 | Gotham Advertising Company | Sydney | ||||
15006 | 15006 | 1950-12-11 | Hiram Walker & Sons, Ltd. | 1944-08-09 | CANADA | Gotham Advertising Company 17 | 1942-07-08 | Gotham Advertising Company | Walkerville | ||||
15007 | 15007 | 1950-12-11 | Publicity & Travel Department | 1942-07-08 | SOUTH AFRICA | Gotham Advertising Company 17 | 1942-07-08 | Gotham Advertising Company | Johannesburg | ||||
15008 | 15008 | 1950-12-11 | South African Government | 1942-07-08 | SOUTH AFRICA | Gotham Advertising Company 17 | 1942-07-08 | Gotham Advertising Company | |||||
15010 | 15010 | 1950-12-11 | William P. Harley, Ltd. | 1942-07-08 | GREAT BRITAIN | Gotham Advertising Company 17 | 1942-07-08 | Gotham Advertising Company | Liverpool | ||||
1135 | 1135 | 1943-01-08 | Canadian Advertising Agency, Ltd. | 1942-07-08 | CANADA | H.A. Bruno & Associates 19 | 1942-07-08 | H.A. Bruno & Associates | Montreal | ||||
2892 | 2892 | 1946-02-28 | Confederacion Regional Obrera Mexicana | 1942-07-08 | MEXICO | Haberman, Roberto 20 | 1942-07-08 | Haberman, Roberto | Mexico City | ||||
9117 | 9117 | 1946-07-09 | Korean National Front Federation | 1942-07-09 | KOREA, SOUTH | Haan, Kilsoo Kenneth 23 | 1942-07-09 | Haan, Kilsoo Kenneth | Chungking | ||||
4146 | 4146 | 1943-03-30 | Department of Fomento, Republic of the U.S. of Venezuela | 1942-07-09 | VENEZUELA | Arroyo, Julian Avelino 25 | 1942-07-09 | Arroyo, Julian Avelino | Caracas | ||||
9113 | 9113 | 1942-07-09 | Vicesecretaria de Educacion Popular | 1942-07-09 | SPAIN | Spanish Library of Information 28 | 1942-07-09 | Spanish Library of Information | Madrid | ||||
1164 | 1164 | 1945-01-09 | Erez Israel (Palestine) Foundation Fund Keren Hayesod, Ltd. | 1942-07-09 | ISRAEL | Blumenfeld, Kurt 30 | 1942-07-09 | Blumenfeld, Kurt | Behavia, Jerusalem | ||||
770 | 770 | 1944-01-01 | Jewish Agency for Palestine | 1942-07-09 | PALESTINE | Rosenbluth, Martin (Michael) 31 | 1942-07-09 | Rosenbluth, Martin (Michael) | 77 Great Russell, London | ||||
14854 | 14854 | 1946-12-07 | A. Saadeh | 1943-04-23 | ARGENTINA | Syrian National Party in the U.S. 32 | 1942-07-24 | Syrian National Party in the U.S. | Buenos Aires | ||||
14857 | 14857 | 1946-12-07 | Nihmeh Thabet | 1943-04-23 | SYRIA | Syrian National Party in the U.S. 32 | 1942-07-24 | Syrian National Party in the U.S. | Beer Hasan | ||||
14858 | 14858 | 1946-12-07 | Syrian National Party | 1942-07-24 | SYRIA | Syrian National Party in the U.S. 32 | 1942-07-24 | Syrian National Party in the U.S. | |||||
2123 | 2123 | 1961-02-03 | Associated British & Irish Railway | 1943-03-03 | GREAT BRITAIN | Caples Company 34 | 1943-03-03 | Caples Company | London, England | ||||
2124 | 2124 | 1961-02-03 | British Railways | 1950-06-12 | GREAT BRITAIN | Caples Company 34 | 1943-03-03 | Caples Company | London | ||||
2125 | 2125 | 1961-02-03 | East Africa Tourist Travel Association | 1950-05-19 | KENYA | Caples Company 34 | 1943-03-03 | Caples Company | Nairobi | ||||
2126 | 2126 | 1961-02-03 | Finnair - Aeroo/y | 1961-02-03 | FINLAND | Caples Company 34 | 1943-03-03 | Caples Company | Helsinki | ||||
2127 | 2127 | 1961-02-03 | Fogra Failte (National Tourist Publicity Organization for Ireland | 1952-07-21 | IRELAND | Caples Company 34 | 1943-03-03 | Caples Company | Dublin | ||||
2128 | 2128 | 1961-02-03 | Industrial Development Authority | 1958-08-04 | IRELAND | Caples Company 34 | 1943-03-03 | Caples Company | Dublin | ||||
2130 | 2130 | 1961-02-03 | National Railways of Mexico | 1943-03-03 | MEXICO | Caples Company 34 | 1943-03-03 | Caples Company | Mexico City | ||||
2131 | 2131 | 1961-02-03 | Punch | 1949-06-27 | GREAT BRITAIN | Caples Company 34 | 1943-03-03 | Caples Company | London, England | ||||
2134 | 2134 | 1961-02-03 | Swedish American Line | 1955-01-27 | SWEDEN | Caples Company 34 | 1943-03-03 | Caples Company | Gothenburg | ||||
2136 | 2136 | 1961-02-03 | Tourist Promotion Board, City of Vienna | 1959-02-02 | AUSTRIA | Caples Company 34 | 1943-03-03 | Caples Company | |||||
2137 | 2137 | 1961-02-03 | Ulster Transport Authority | 1950-06-12 | IRELAND | Caples Company 34 | 1943-03-03 | Caples Company | |||||
3205 | 3205 | 1953-03-01 | Hotels Executive (British Transport) | 1950-06-12 | GREAT BRITAIN | Caples Company 34 | 1943-03-03 | Caples Company | Londgon | ||||
4288 | 4288 | 1952-03-31 | Argentine Airlines, Fama Service | 1950-05-19 | ARGENTINA | Caples Company 34 | 1943-03-03 | Caples Company | Buenos Aires | ||||
4296 | 4296 | 1956-03-31 | Inverurie Hotel Company, Ltd. (Belmont Manor Hotel) | 1953-07-20 | BERMUDA | Caples Company 34 | 1943-03-03 | Caples Company | Warwick | ||||
4297 | 4297 | 1956-03-31 | Montego Beach Hotel Company, Ltd. | 1953-02-10 | JAMAICA | Caples Company 34 | 1943-03-03 | Caples Company | Montego Bay | ||||
4833 | 4833 | 1960-04-01 | Coras Iompair Eireann (Irish Transport Company) | 1950-06-12 | IRELAND | Caples Company 34 | 1943-03-03 | Caples Company | Dublin | ||||
5270 | 5270 | 1956-04-15 | British West Indian Airways | 1955-08-16 | TRINIDAD AND TOBAGO | Caples Company 34 | 1943-03-03 | Caples Company | Port-of-Spain | ||||
8234 | 8234 | 1959-06-30 | African Car Hire, Ltd. | 1952-01-28 | SOUTH AFRICA | Caples Company 34 | 1943-03-03 | Caples Company | Cape Town | ||||
15551 | 15551 | 1955-12-31 | Mexican Government Tourist Bureau | 1954-07-22 | MEXICO | Caples Company 34 | 1943-03-03 | Caples Company | |||||
15590 | 15590 | 1959-12-31 | Aerlinte Eireann Teoranta (Irish Airlines) | 1958-08-04 | IRELAND | Caples Company 34 | 1943-03-03 | Caples Company | Dublin | ||||
15595 | 15595 | 1959-12-31 | Shannon Free Airport Development Authority | 1958-08-04 | IRELAND | Caples Company 34 | 1943-03-03 | Caples Company | |||||
9150 | 9150 | 1943-07-10 | Department of Fomento, Venezuelan Government | 1942-07-10 | VENEZUELA | Franklin, Emilio 35 | 1942-07-10 | Franklin, Emilio | |||||
14602 | 14602 | 1946-12-01 | Commission of Government of Newfoundland | 1942-07-11 | NETHERLANDS | Newfoundland Government Information Bureau 37 | 1942-07-11 | Newfoundland Government Information Bureau | St. John's | ||||
6726 | 6726 | 1945-05-23 | Comision Nacional de Propaganda y Defensa del Tabaco Habano, Ministerio de Agricultura, Republica de Cuba | 1942-07-11 | CUBA | Arnaz y Alberni, Desiderio 38 | 1942-07-11 | Arnaz y Alberni, Desiderio | Habana | ||||
9165 | 9165 | 1942-07-11 | Cuban Tourist Commission (Corporacion Nacional del Turismo) | 1942-07-11 | CUBA | Ardois, Luis Fernandez 40 | 1942-07-11 | Ardois, Luis Fernandez | Havana | ||||
9249 | 9249 | 1946-07-15 | Accion Republicana Espanola | 1942-07-13 | MEXICO | Asensio, Jose' 41 | 1942-07-13 | Asensio, Jose' | |||||
3798 | 3798 | 1943-03-16 | Dr. Willibald N. Ploechl, Chairman of Free Austrian National Council | 1942-07-13 | AUSTRIA | Gassner, Josef Hieronymus 43 | 1942-07-13 | Gassner, Josef Hieronymus | |||||
4826 | 4826 | 1943-04-01 | Austrian Nation, Austrian Federal Government, Federation of Austrians (Underground Movement) | 1942-07-13 | AUSTRIA | Ploechl, Willibald Maria 44 | 1942-07-13 | Ploechl, Willibald Maria | |||||
1954 | 1954 | 1952-02-01 | Hamburg-American Line | 1942-07-14 | GERMANY, FEDERAL REPUBLIC OF | Knauth, Arnold Whitman 45 | 1942-07-14 | Knauth, Arnold Whitman | Hamburg | ||||
2368 | 2368 | 1946-02-11 | Asociacion Monarquica Espanola | 1942-07-15 | SPAIN | De Agustin, Don Manuel 47 | 1942-07-15 | De Agustin, Don Manuel | |||||
15514 | 15514 | 1942-12-31 | Dutch Central Transport Workers' Union | 1943-03-13 | NETHERLANDS | Van Den Berge, Petrus Jacobus 48 | 1942-07-15 | Van Den Berge, Petrus Jacobus | London, Englad | ||||
3735 | 3735 | 1943-03-15 | French Ambassador Gaston Henry-Haye | 1943-03-15 | FRANCE | Jules-Bois, Henri Antoine 51 | 1942-07-16 | Jules-Bois, Henri Antoine | |||||
3736 | 3736 | 1943-03-15 | French Embassy | 1942-07-16 | FRANCE | Jules-Bois, Henri Antoine 51 | 1942-07-16 | Jules-Bois, Henri Antoine | |||||
7809 | 7809 | 1946-06-15 | Comite' International du Bois | 1942-07-16 | INTERNATIONAL | Glesinger, Egon 52 | 1942-07-16 | Glesinger, Egon | Brussels | ||||
661 | 661 | Swiss Federal Railroads | 1943-03-01 | SWITZERLAND | Switzerland Tourism 55 | 1943-03-01 | Switzerland Tourism | Berne | |||||
662 | 662 | Swiss National Tourist Office | 1973-03-27 | SWITZERLAND | Switzerland Tourism 55 | 1943-03-01 | Switzerland Tourism | Zurich |
Advanced export
JSON shape: default, array, newline-delimited
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]) );