FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
16,939 rows 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)
State >30
Registrant_Name >30
- Hill and Knowlton Strategies, LLC 277
- North American Precis Syndicate 175
- Gebhardt, H.A. 158
- Modern Education Services, Inc. 154
- Daniel J. Edelman, Inc. 150
- Ruder Finn, Inc. 148
- Squire Patton Boggs, LLP 133
- Arnold & Porter Kaye Scholer LLP 130
- Amtorg Trading Corporation 108
- Association Films, Inc. 95
- Fleishman-Hillard, Inc. 90
- Akin, Gump, Strauss, Hauer & Feld, LLP 86
- Burson-Marsteller 86
- DLA Piper US LLP 68
- Koenig, Harry D. 67
- Hogan Lovells US LLP 65
- Jones Day 64
- IPG DXTRA, Inc 61
- Covington & Burling 60
- APCO Worldwide, Inc. 58
- BGR Government Affairs, LLC 57
- Development Counsellors International 56
- van Kloberg & Associates, Ltd. 55
- Dow, Lohnes & Albertson, L.L.P. 54
- GCI Group, Inc. 51
- Mercury Public Affairs, LLC 49
- White & Case, LLP 49
- FGS Global (US) LLC (FKA FGH Holdings LLC) 45
- Shaw, Pittman, Potts & Trowbridge 45
- Holland & Knight 44
- …
Registrant_Date >30 ✖
- 1981-11-10 277
- 1977-10-12 176
- 1942-08-15 158
- 1964-10-19 156
- 1964-06-04 134
- 1969-10-09 133
- 1961-09-27 132
- 1983-06-24 114
- 1984-11-15 113
- 1949-11-07 108
- 1964-11-06 95
- 1982-12-10 91
- 1973-10-23 86
- 1942-10-29 68
- 1985-08-05 68
- 1986-02-05 67
- 1971-02-18 66
- 1993-03-12 63
- 1986-12-01 61
- 1948-04-16 58
- 2001-05-10 57
- 1983-03-17 55
- 1983-05-09 55
- 1986-07-11 52
- 1977-03-09 49
- 2013-05-14 49
- 1942-09-14 48
- 1979-08-09 46
- 1979-12-13 46
- 1985-08-07 45
- …
Foreign_Principal_Termination_Date >30 ✖
- - 769
- 1943-08-15 158
- 1995-12-31 102
- 1945-04-29 67
- 1981-08-31 65
- 1992-04-30 64
- 1988-12-31 55
- 1989-12-31 52
- 1991-10-31 51
- 1990-12-31 47
- 1986-12-31 46
- 1991-05-31 46
- 1993-12-10 45
- 1952-04-25 43
- 1964-07-31 42
- 1976-12-31 40
- 1991-12-31 40
- 1993-03-30 40
- 1987-12-31 39
- 1996-12-31 35
- 1989-05-30 32
- 1990-11-30 32
- 2005-12-31 32
- 1943-03-31 31
- 1964-02-26 31
- 1993-03-11 30
- 1983-06-30 29
- 1989-10-25 29
- 1996-02-14 29
- 2006-03-31 28
- …
Foreign_Principal_Registration_Date >30 ✖
- 1942-08-15 158
- 1988-02-17 46
- 1989-05-31 34
- 1988-08-18 32
- 1943-03-31 31
- 1942-07-28 27
- 1942-10-29 25
- 1949-09-15 23
- 1942-08-26 21
- 1949-11-07 21
- 1942-07-27 19
- 1991-03-26 19
- 2005-01-31 19
- 1950-05-01 17
- 1986-08-11 17
- 1988-11-23 17
- 2018-04-30 17
- 1971-11-18 16
- 1974-01-21 16
- 1991-11-26 16
- 1942-07-08 15
- 1944-11-03 15
- 1945-05-04 15
- 1959-09-15 15
- 1979-06-27 15
- 1981-10-02 15
- 1959-09-25 14
- 1963-12-16 14
- 1967-07-25 14
- 1982-12-01 14
- …
Foreign_Principal >30
- Embassy of Japan 95
- Embassy of the Republic of Korea 38
- Government of Haiti 33
- Embassy of the State of Qatar 31
- Hong Kong Trade Development Council 31
- Republic of Haiti 30
- Jamaica Tourist Board 29
- Government of the Dominican Republic 25
- Intourist 24
- Japan External Trade Organization 23
- Royal Embassy of Saudi Arabia 21
- Republic of the Philippines 20
- CEDOK 18
- Government of Jamaica 18
- Japan Trade Center 18
- Government of Canada 17
- Government of Israel 17
- Government of Japan 17
- Government of Pakistan 17
- Republic of Indonesia 17
- Republic of Panama 17
- Algoma Steel Corporation, Ltd. 16
- Federal Republic of Nigeria 16
- French Government Tourist Office 16
- Government of Guatemala 16
- Japan External Trade Organization (JETRO) 16
- Japan Fisheries Association 16
- Republic of Liberia 16
- Dominican Republic 15
- Government of Aruba 15
- …
Country/Location_Represented >30
- JAPAN 1,156
- CANADA 800
- MEXICO 571
- GREAT BRITAIN 548
- FRANCE 508
- KOREA, SOUTH 426
- GERMANY, FEDERAL REPUBLIC OF 390
- INTERNATIONAL 331
- USSR 302
- ISRAEL 286
- CHINA 268
- TAIWAN 251
- RUSSIA 240
- SAUDI ARABIA 237
- DOMINICAN REPUBLIC 227
- ITALY 226
- NETHERLANDS 223
- SWITZERLAND 197
- TURKEY 187
- AUSTRALIA 184
- CUBA 182
- GERMANY 178
- POLAND 177
- BRAZIL 175
- SPAIN 174
- HAITI 173
- PHILIPPINES 170
- VENEZUELA 167
- PANAMA 163
- SOUTH AFRICA 158
- …
City >30
- - 15,014
- Washington 730
- New York 102
- Kyiv 29
- Dubai 22
- London 22
- Moscow 22
- Riyadh 20
- Baghdad 19
- Doha 18
- Los Angeles 16
- 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
- Houston 9
- Abuja 8
- Georgetown 8
- Quito 8
- Abidjan 7
- …
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]) );