FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
15,014 rows where City = "" sorted by Registration_Number
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Registration_Date (date), Registrant_Date (date)
These facets timed out: Foreign_Principal_Termination_Date
State >30
Registration_Number >30 ✖
- Hill and Knowlton Strategies, LLC 263
- North American Precis Syndicate 175
- Gebhardt, H.A. 158
- Modern Education Services, Inc. 154
- Ruder Finn, Inc. 126
- Arnold & Porter Kaye Scholer LLP 121
- Amtorg Trading Corporation 108
- Squire Patton Boggs, LLP 102
- Association Films, Inc. 95
- Burson-Marsteller 80
- Daniel J. Edelman, Inc. 80
- Koenig, Harry D. 67
- Fleishman-Hillard, Inc. 67
- Jones Day 64
- Akin, Gump, Strauss, Hauer & Feld, LLP 64
- Covington & Burling 57
- IPG DXTRA, Inc 56
- Hogan Lovells US LLP 55
- van Kloberg & Associates, Ltd. 55
- Dow, Lohnes & Albertson, L.L.P. 54
- DLA Piper US LLP 52
- GCI Group, Inc. 51
- Development Counsellors International 45
- International Council of Cruise Lines 44
- Netherland Publishing Corporation 43
- Keating Group, Inc. 43
- O'Connor & Hannan, L.L.P. 43
- Robinsons, Inc. 41
- Daniels, Houlihan & Palmeter 40
- Shaw, Pittman, Potts & Trowbridge 40
- …
Registrant_Name >30
- Hill and Knowlton Strategies, LLC 263
- North American Precis Syndicate 175
- Gebhardt, H.A. 158
- Modern Education Services, Inc. 154
- Ruder Finn, Inc. 138
- Arnold & Porter Kaye Scholer LLP 121
- Daniel J. Edelman, Inc. 114
- Amtorg Trading Corporation 108
- Squire Patton Boggs, LLP 102
- Association Films, Inc. 95
- Burson-Marsteller 82
- Fleishman-Hillard, Inc. 78
- Koenig, Harry D. 67
- Akin, Gump, Strauss, Hauer & Feld, LLP 64
- Jones Day 64
- Covington & Burling 60
- IPG DXTRA, Inc 56
- Hogan Lovells US LLP 55
- van Kloberg & Associates, Ltd. 55
- Dow, Lohnes & Albertson, L.L.P. 54
- DLA Piper US LLP 52
- GCI Group, Inc. 51
- APCO Worldwide, Inc. 47
- Development Counsellors International 45
- Shaw, Pittman, Potts & Trowbridge 45
- International Council of Cruise Lines 44
- Netherland Publishing Corporation 44
- Keating Group, Inc. 43
- O'Connor & Hannan, L.L.P. 43
- Robinsons, Inc. 41
- …
Foreign_Principal >30
- Embassy of Japan 65
- Government of Haiti 32
- Republic of Haiti 30
- Jamaica Tourist Board 29
- Hong Kong Trade Development Council 27
- Government of the Dominican Republic 25
- Intourist 23
- Japan External Trade Organization 23
- CEDOK 18
- Government of Jamaica 18
- Japan Trade Center 18
- Republic of the Philippines 18
- Government of Canada 17
- Government of Israel 17
- Republic of Indonesia 17
- Algoma Steel Corporation, Ltd. 16
- French Government Tourist Office 16
- Japan External Trade Organization (JETRO) 16
- Japan Fisheries Association 16
- Republic of Liberia 16
- Republic of Panama 16
- Dominican Republic 15
- Federal Republic of Nigeria 15
- Government of Guatemala 15
- Government of Japan 15
- Government of Pakistan 15
- Dofasco, Inc. 14
- German Information Center 14
- Kingdom of Saudi Arabia 14
- Korea National Tourism Corporation 14
- …
Country/Location_Represented >30
- JAPAN 1,070
- CANADA 750
- MEXICO 551
- GREAT BRITAIN 544
- FRANCE 500
- GERMANY, FEDERAL REPUBLIC OF 390
- KOREA, SOUTH 348
- INTERNATIONAL 310
- USSR 296
- ISRAEL 267
- TAIWAN 224
- CHINA 217
- ITALY 216
- NETHERLANDS 216
- DOMINICAN REPUBLIC 214
- RUSSIA 214
- SWITZERLAND 190
- CUBA 182
- SAUDI ARABIA 181
- AUSTRALIA 170
- BRAZIL 169
- GERMANY 167
- SPAIN 163
- HAITI 160
- PHILIPPINES 159
- POLAND 159
- SOUTH AFRICA 153
- SWEDEN 151
- PANAMA 147
- VENEZUELA 145
- …
City 1
- - · 15,014 ✖
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 | ||||
8967 | 8967 | 1942-07-03 | China Defense Supplies, Inc. | 1942-07-03 | CHINA | Lawrence, William S. 3 | 1942-07-03 | Lawrence, William S. | Washington | DC | |||
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 | ||||
11503 | 11503 | 1951-09-11 | Polish Research & Information Service | 1950-11-16 | POLAND | Black, Helen 6 | 1942-07-06 | Black, Helen | New York | NY | |||
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 | |||||
9028 | 9028 | 1942-07-06 | Danish Travel Information Bureau | 1942-07-06 | DENMARK | Christensen, Valdemar Emil 7 | 1942-07-06 | Christensen, Valdemar Emil | New York | NY | |||
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 | |||||
15009 | 15009 | 1950-12-11 | South African Railways & Harbours | 1944-02-10 | SOUTH AFRICA | Gotham Advertising Company 17 | 1942-07-08 | Gotham Advertising Company | Washington | DC | |||
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 | ||||
9087 | 9087 | 1942-07-08 | Consulate General of Switzerland | 1942-07-08 | SWITZERLAND | Marx, Karl T. 18 | 1942-07-08 | Marx, Karl T. | New York | NY | |||
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 | ||||
9116 | 9116 | 1946-07-09 | Sino-Korean People's League | 1942-07-09 | KOREA, SOUTH | Haan, Kilsoo Kenneth 23 | 1942-07-09 | Haan, Kilsoo Kenneth | Honolulu | HI | |||
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 | ||||
9114 | 9114 | 1943-07-09 | Finnish-American Trading Corporation | 1942-07-09 | FINLAND | Jarvinen, Vilho Olavi 24 | 1942-07-09 | Jarvinen, Vilho Olavi | New York | NY | |||
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 | ||||
9112 | 9112 | 1942-07-09 | Dr. Syngman Rhee | 1942-07-09 | KOREA, SOUTH | Chang, Kee Young 26 | 1942-07-09 | Chang, Kee Young | Washington | DC | |||
2234 | 2234 | 1948-02-06 | Spanish Embassy | 1942-07-09 | SPAIN | LeRoy & Denslow 27 | 1942-07-09 | LeRoy & Denslow | Washington | DC | |||
3204 | 3204 | 1950-03-01 | French Consulate | 1950-06-05 | FRANCE | LeRoy & Denslow 27 | 1942-07-09 | LeRoy & Denslow | Washington | DC | |||
9118 | 9118 | 1950-07-09 | Argentine Embassy | 1943-07-30 | ARGENTINA | LeRoy & Denslow 27 | 1942-07-09 | LeRoy & Denslow | Washington | DC | |||
9119 | 9119 | 1950-07-09 | Legation of Finland | 1944-02-02 | FINLAND | LeRoy & Denslow 27 | 1942-07-09 | LeRoy & Denslow | Washington | DC | |||
13777 | 13777 | 1947-11-07 | Legation of Hungary | 1946-07-11 | HUNGARY | LeRoy & Denslow 27 | 1942-07-09 | LeRoy & Denslow | Washington | DC | |||
14103 | 14103 | 1945-11-21 | Legation of Sweden, Department of Finnish Interests | 1944-07-28 | SWEDEN | LeRoy & Denslow 27 | 1942-07-09 | LeRoy & Denslow | Washington | DC | |||
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 | ||||
9473 | 9473 | 1943-07-26 | Spanish Library of Information | 1942-07-09 | SPAIN | Carpenter, Charles M. 29 | 1942-07-09 | Carpenter, Charles M. | New York | NY | |||
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. | |||||
1176 | 1176 | 1945-01-10 | Johann Luehne, Sr. | 1942-07-10 | GERMANY, FEDERAL REPUBLIC OF | Luehne Jr., John H. 33 | 1942-07-10 | Luehne Jr., John H. | Chicago | IL | |||
1177 | 1177 | 1945-01-10 | Modene Louis Rachin | 1942-07-10 | GERMANY, FEDERAL REPUBLIC OF | Luehne Jr., John H. 33 | 1942-07-10 | Luehne Jr., John H. | Chicago | IL | |||
780 | 780 | 1959-01-01 | Arab Information Center | 1956-02-03 | EGYPT | Caples Company 34 | 1943-03-03 | Caples Company | New York | NY | |||
1956 | 1956 | 1954-02-01 | Swiss National Travel Office | 1954-02-12 | SWITZERLAND | Caples Company 34 | 1943-03-03 | Caples Company | New York | NY | |||
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 | ||||
2129 | 2129 | 1961-02-03 | Japan Tourist Association | 1958-08-04 | JAPAN | Caples Company 34 | 1943-03-03 | Caples Company | New York | NY | |||
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 | ||||
2132 | 2132 | 1961-02-03 | Scandinavian Travel Commission (Members are: Danish, Finnish, Norwegian & Swedish National Travel Offices) | 1957-08-13 | DENMARK | Caples Company 34 | 1943-03-03 | Caples Company | New York | NY | |||
2133 | 2133 | 1961-02-03 | South Africa Tourist Corporation | 1951-01-31 | SOUTH AFRICA | Caples Company 34 | 1943-03-03 | Caples Company | New York | NY | |||
2134 | 2134 | 1961-02-03 | Swedish American Line | 1955-01-27 | SWEDEN | Caples Company 34 | 1943-03-03 | Caples Company | Gothenburg | ||||
2135 | 2135 | 1961-02-03 | Swiss National Travel Office | 1955-04-04 | SWITZERLAND | Caples Company 34 | 1943-03-03 | Caples Company | New York | NY | |||
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 | |||||
2138 | 2138 | 1961-02-03 | Yugoslav State Tourist Office | 1953-02-10 | YUGOSLAVIA | Caples Company 34 | 1943-03-03 | Caples Company | New York | NY | |||
3205 | 3205 | 1953-03-01 | Hotels Executive (British Transport) | 1950-06-12 | GREAT BRITAIN | Caples Company 34 | 1943-03-03 | Caples Company | Londgon |
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]) );