FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
16,939 rows sorted by Foreign_Principal_Registration_Date
This data as json, CSV (advanced)
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
- …
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 799
- MEXICO 569
- GREAT BRITAIN 543
- FRANCE 488
- KOREA, SOUTH 422
- GERMANY, FEDERAL REPUBLIC OF 387
- INTERNATIONAL 328
- USSR 299
- ISRAEL 285
- CHINA 267
- TAIWAN 251
- RUSSIA 240
- SAUDI ARABIA 237
- DOMINICAN REPUBLIC 227
- ITALY 226
- NETHERLANDS 219
- SWITZERLAND 196
- TURKEY 187
- CUBA 180
- AUSTRALIA 178
- GERMANY 178
- POLAND 176
- BRAZIL 175
- HAITI 173
- PHILIPPINES 170
- SPAIN 166
- VENEZUELA 165
- PANAMA 163
- SOUTH AFRICA 156
- …
City >30
- - 14,914
- 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8186 | 8186 | 1946-06-30 | A.B. Bofors Nobelkrut | 1942-07-28 | SWEDEN | Swedish Industries Fund, Inc. 69 | 1942-07-28 | Swedish Industries Fund, Inc. | |||||
8187 | 8187 | 1946-06-30 | A.B. Elektrolux | 1942-07-28 | SWEDEN | Swedish Industries Fund, Inc. 69 | 1942-07-28 | Swedish Industries Fund, Inc. | |||||
8189 | 8189 | 1946-06-30 | A.B. Ljungstroms Angturbin | 1942-07-28 | SWEDEN | Swedish Industries Fund, Inc. 69 | 1942-07-28 | Swedish Industries Fund, Inc. | |||||
8190 | 8190 | 1946-06-30 | A.B. Separator | 1942-07-28 | SWEDEN | Swedish Industries Fund, Inc. 69 | 1942-07-28 | Swedish Industries Fund, Inc. | |||||
8191 | 8191 | 1946-06-30 | A.B. Svenska Amerikalinjen | 1942-07-28 | SWEDEN | Swedish Industries Fund, Inc. 69 | 1942-07-28 | Swedish Industries Fund, Inc. | |||||
8192 | 8192 | 1946-06-30 | A.B. Svenska Kullager Fabriken | 1942-07-28 | SWEDEN | Swedish Industries Fund, Inc. 69 | 1942-07-28 | Swedish Industries Fund, Inc. | |||||
8195 | 8195 | 1946-06-30 | A.B. de Lavals Angturbin | 1942-07-28 | SWEDEN | Swedish Industries Fund, Inc. 69 | 1942-07-28 | Swedish Industries Fund, Inc. | |||||
8196 | 8196 | 1946-06-30 | Axel Axelson Johnson | 1942-07-28 | SWEDEN | Swedish Industries Fund, Inc. 69 | 1942-07-28 | Swedish Industries Fund, Inc. | |||||
8197 | 8197 | 1946-06-30 | Brostrom-Koncernen | 1942-07-28 | SWEDEN | Swedish Industries Fund, Inc. 69 | 1942-07-28 | Swedish Industries Fund, Inc. | |||||
8198 | 8198 | 1946-06-30 | Elektriska Svetsnings A.B. | 1942-07-28 | SWEDEN | Swedish Industries Fund, Inc. 69 | 1942-07-28 | Swedish Industries Fund, Inc. | |||||
8199 | 8199 | 1946-06-30 | Kooperativa Forbundet | 1942-07-28 | SWEDEN | Swedish Industries Fund, Inc. 69 | 1942-07-28 | Swedish Industries Fund, Inc. | |||||
8201 | 8201 | 1946-06-30 | Sandvikens Jernverks A.B. | 1942-07-28 | SWEDEN | Swedish Industries Fund, Inc. 69 | 1942-07-28 | Swedish Industries Fund, Inc. | |||||
8203 | 8203 | 1946-06-30 | Svenska Cellulosa-Aktiebolaget | 1942-07-28 | SWEDEN | Swedish Industries Fund, Inc. 69 | 1942-07-28 | Swedish Industries Fund, Inc. | |||||
8205 | 8205 | 1946-06-30 | Telefon A.B. L.M. Ericsson | 1942-07-28 | SWEDEN | Swedish Industries Fund, Inc. 69 | 1942-07-28 | Swedish Industries Fund, Inc. | |||||
13781 | 13781 | 1973-11-07 | ASEA (Swedish General Electric Company) | 1942-07-28 | SWEDEN | Swedish Information Service 70 | 1942-07-28 | Swedish Information Service | |||||
13782 | 13782 | 1973-11-07 | Ahlen & Akerlund | 1942-07-28 | SWEDEN | Swedish Information Service 70 | 1942-07-28 | Swedish Information Service | Stockholm | ||||
13783 | 13783 | 1973-11-07 | Albert Bonnier Publishing House | 1942-07-28 | SWEDEN | Swedish Information Service 70 | 1942-07-28 | Swedish Information Service | Stockholm | ||||
13784 | 13784 | 1973-11-07 | Bofors | 1942-07-28 | SWEDEN | Swedish Information Service 70 | 1942-07-28 | Swedish Information Service | Bofors | ||||
13785 | 13785 | 1973-11-07 | Cellulosa Company | 1942-07-28 | SWEDEN | Swedish Information Service 70 | 1942-07-28 | Swedish Information Service | Stockholm | ||||
13786 | 13786 | 1973-11-07 | Cooperative Union | 1942-07-28 | SWEDEN | Swedish Information Service 70 | 1942-07-28 | Swedish Information Service | Stockholm | ||||
13787 | 13787 | 1973-11-07 | Enskilda Banken | 1942-07-28 | SWEDEN | Swedish Information Service 70 | 1942-07-28 | Swedish Information Service | Stockholm | ||||
13788 | 13788 | 1973-11-07 | Grangesberg Company | 1942-07-28 | SWEDEN | Swedish Information Service 70 | 1942-07-28 | Swedish Information Service | Stockholm | ||||
13789 | 13789 | 1973-11-07 | SKF (Swedish Ball Bearing Company) | 1942-07-28 | SWEDEN | Swedish Information Service 70 | 1942-07-28 | Swedish Information Service | Gothenburg | ||||
13790 | 13790 | 1973-11-07 | Skandinaviska Banken | 1942-07-28 | SWEDEN | Swedish Information Service 70 | 1942-07-28 | Swedish Information Service | Stockholm | ||||
13791 | 13791 | 1973-11-07 | Stora Kopparbergs Mining Company | 1942-07-28 | SWEDEN | Swedish Information Service 70 | 1942-07-28 | Swedish Information Service | Falun | ||||
13792 | 13792 | 1973-11-07 | Svenska Handelsbanken | 1942-07-28 | SWEDEN | Swedish Information Service 70 | 1942-07-28 | Swedish Information Service | Gothenburg | ||||
13793 | 13793 | 1973-11-07 | Swedish Government | 1942-07-28 | SWEDEN | Swedish Information Service 70 | 1942-07-28 | Swedish Information Service | Stockholm | ||||
1615 | 1615 | 1943-01-30 | Development Board, Department of the Bahamas Government | 1942-07-30 | BAHAMAS | Kelly, John C. 72 | 1942-07-30 | Kelly, John C. | Nassau | ||||
1616 | 1616 | 1947-01-30 | Foreign Government of the Slovak Free State | 1942-07-30 | CZECHOSLOVAKIA | Koren, Louis 73 | 1942-07-30 | Koren, Louis | |||||
9658 | 9658 | 1964-07-31 | Bermuda Hotels, Inc. | 1942-07-30 | BERMUDA | Kelly, Nason, Inc. 71 | 1942-07-30 | Kelly, Nason, Inc. | Hamilton | ||||
9666 | 9666 | 1964-07-31 | Development Board, Department of the Bahamas Government | 1942-07-30 | BAHAMAS | Kelly, Nason, Inc. 71 | 1942-07-30 | Kelly, Nason, Inc. | Nassau | ||||
9667 | 9667 | 1964-07-31 | Duke of Windsor | 1942-07-30 | BAHAMAS | Kelly, Nason, Inc. 71 | 1942-07-30 | Kelly, Nason, Inc. | Nassau | ||||
9671 | 9671 | 1964-07-31 | Harold G. Christie | 1942-07-30 | BAHAMAS | Kelly, Nason, Inc. 71 | 1942-07-30 | Kelly, Nason, Inc. | Nassau | ||||
9694 | 9694 | 1964-07-31 | St. Adele Lodge | 1942-07-30 | CANADA | Kelly, Nason, Inc. 71 | 1942-07-30 | Kelly, Nason, Inc. | |||||
9695 | 9695 | 1964-07-31 | Tourist Trade Development Board of Jamaica | 1942-07-30 | JAMAICA | Kelly, Nason, Inc. 71 | 1942-07-30 | Kelly, Nason, Inc. | Kingston | ||||
1940 | 1940 | 1943-02-01 | Alfredo Lluro | 1942-08-01 | PANAMA | Pan-American Associated Enterprises 77 | 1942-08-01 | Pan-American Associated Enterprises | |||||
1941 | 1941 | 1943-02-01 | Alfredo Pellicer (Empresario de Espectacules) | 1942-08-01 | CURACAO | Pan-American Associated Enterprises 77 | 1942-08-01 | Pan-American Associated Enterprises | |||||
1942 | 1942 | 1943-02-01 | Carlos Lamena Falcon | 1942-08-01 | VENEZUELA | Pan-American Associated Enterprises 77 | 1942-08-01 | Pan-American Associated Enterprises | Caracas | ||||
1943 | 1943 | 1943-02-01 | Don Miguel Angle De Chacon | 1942-08-01 | EL SALVADOR | Pan-American Associated Enterprises 77 | 1942-08-01 | Pan-American Associated Enterprises | San Salvador | ||||
1946 | 1946 | 1943-02-01 | Horacio Perez | 1942-08-01 | DOMINICAN REPUBLIC | Pan-American Associated Enterprises 77 | 1942-08-01 | Pan-American Associated Enterprises | Cuidad, Trujillo | ||||
1950 | 1950 | 1943-02-01 | Roberto Crespo | 1942-08-01 | COLOMBIA | Pan-American Associated Enterprises 77 | 1942-08-01 | Pan-American Associated Enterprises | Medellin | ||||
9644 | 9644 | 1943-07-31 | J. Zoltowski, Financial Counselor of the Embassy of Poland in Washington | 1942-08-01 | POLAND | Nagorski, Bohdan 76 | 1942-08-01 | Nagorski, Bohdan | New York | NY | |||
9947 | 9947 | 1942-08-01 | Hjalmar Johan Procope | 1942-08-01 | FINLAND | Ramsay, Johan V.V. 74 | 1942-08-01 | Ramsay, Johan V.V. | Washington | DC | |||
2118 | 2118 | 1952-02-03 | National Tsing Hua University | 1942-08-03 | CHINA | China Institute in America, Inc. 79 | 1942-08-03 | China Institute in America, Inc. | Kunming | ||||
10083 | 10083 | 1942-08-03 | Minister of Foreign Relations of the Government of Guatemala | 1942-08-03 | GUATEMALA | Larcegui, Francisco de S. 80 | 1942-08-03 | Larcegui, Francisco de S. | |||||
10084 | 10084 | 1942-08-03 | Spanish Library of Information | 1942-08-03 | SPAIN | Larcegui, Francisco de S. 80 | 1942-08-03 | Larcegui, Francisco de S. | New York | NY | |||
10578 | 10578 | 1972-08-17 | Alfred Falter | 1942-08-03 | CANADA | Gdynia American Line, Inc. 81 | 1942-08-03 | Gdynia American Line, Inc. | New York | NY | |||
10579 | 10579 | 1972-08-17 | Baltic Union Shipbrokers, Ltd. | 1942-08-03 | GREAT BRITAIN | Gdynia American Line, Inc. 81 | 1942-08-03 | Gdynia American Line, Inc. | London, England | ||||
10580 | 10580 | 1972-08-17 | Gdynia America Shipping Lines, Ltd. | 1942-08-03 | GREAT BRITAIN | Gdynia American Line, Inc. 81 | 1942-08-03 | Gdynia American Line, Inc. | London, England | ||||
10581 | 10581 | 1972-08-17 | Polish Steamship Agency, Ltd. | 1942-08-03 | POLAND | Gdynia American Line, Inc. 81 | 1942-08-03 | Gdynia American Line, Inc. | London, England | ||||
2533 | 2533 | 1943-02-15 | No foreign principal listed | 1942-08-05 | CANADA | Krier-Becker, Lily 82 | 1942-08-05 | Krier-Becker, Lily | Montreal | ||||
4275 | 4275 | 1944-03-31 | American Friends of Polish Democracy | 1942-08-07 | POLAND | Lazell, Reverend J. Arthur 85 | 1942-08-07 | Lazell, Reverend J. Arthur | New York | NY | |||
4276 | 4276 | 1944-03-31 | New Europe | 1942-08-07 | POLAND | Lazell, Reverend J. Arthur 85 | 1942-08-07 | Lazell, Reverend J. Arthur | New York | NY | |||
10183 | 10183 | 1946-08-07 | Federation of British Industries | 1942-08-07 | GREAT BRITAIN | British Empire Chamber of Commerce in the U.S.A., Inc. 84 | 1942-08-07 | British Empire Chamber of Commerce in the U.S.A., Inc. | London | ||||
11597 | 11597 | 1945-09-15 | Catalan National Council | 1942-08-07 | GREAT BRITAIN | Catalan National Council (U.S. Delegation) 83 | 1942-08-07 | Catalan National Council (U.S. Delegation) | London, England | ||||
13931 | 13931 | 1945-11-14 | American Friends of Polish Democracy | 1942-08-07 | POLAND | American Friends of Polish Democracy 86 | 1942-08-07 | American Friends of Polish Democracy | |||||
13932 | 13932 | 1945-11-14 | Polish Labor Group (Poland Fights")" | 1942-08-07 | POLAND | American Friends of Polish Democracy 86 | 1942-08-07 | American Friends of Polish Democracy | |||||
2367 | 2367 | 1943-02-11 | Government of Peru, David Dasso, Minister of Finance & Commerce | 1942-08-11 | PERU | Davis, Gerhold O. 89 | 1942-08-11 | Davis, Gerhold O. | Lima | ||||
10261 | 10261 | 1946-08-11 | Confederation of Switzerland (Swiss Consulate) | 1942-08-11 | SWITZERLAND | Ratzer & Bridge 88 | 1942-08-11 | Ratzer & Bridge | Los Angeles | ||||
2390 | 2390 | 1947-02-12 | Republic of Estonia | 1942-08-12 | ESTONIA | Markus, Johannes Ernst 90 | 1942-08-12 | Markus, Johannes Ernst | New York | NY | |||
2391 | 2391 | 1947-02-12 | Republic of Estonia | 1942-08-12 | USSR | Jaakson, Ernst Rudolf 91 | 1942-08-12 | Jaakson, Ernst Rudolf | New York | NY | |||
4825 | 4825 | 1943-04-01 | All-Union Combine Mezhdunarodnaya Kniga | 1942-08-12 | RUSSIA | Four Continent Book Corporation 94 | 1942-08-12 | Four Continent Book Corporation | Moscow | ||||
9640 | 9640 | 1943-07-31 | Canadian National Express | 1942-08-12 | CANADA | Fountain, Joseph H. 93 | 1942-08-12 | Fountain, Joseph H. | |||||
9641 | 9641 | 1943-07-31 | Canadian National Railways Company | 1942-08-12 | CANADA | Fountain, Joseph H. 93 | 1942-08-12 | Fountain, Joseph H. | |||||
9642 | 9642 | 1943-07-31 | Canadian National Steamships | 1942-08-12 | CANADA | Fountain, Joseph H. 93 | 1942-08-12 | Fountain, Joseph H. | |||||
9643 | 9643 | 1943-07-31 | Canadian National Telegraph Corporation | 1942-08-12 | CANADA | Fountain, Joseph H. 93 | 1942-08-12 | Fountain, Joseph H. | |||||
9645 | 9645 | 1943-07-31 | Trans-Canada Airlines & Several Subsidiaries | 1942-08-12 | CANADA | Fountain, Joseph H. 93 | 1942-08-12 | Fountain, Joseph H. | |||||
10284 | 10284 | 1943-08-12 | Palestine Correspondence Agency | 1942-08-12 | PALESTINE | Palcor Agency 92 | 1942-08-12 | Palcor Agency | Jerusalem | ||||
2460 | 2460 | 1945-02-14 | Brandon Mesritz & Company | 1942-08-14 | NETHERLANDS | Bernard Preyer Company 96 | 1942-08-14 | Bernard Preyer Company | |||||
2462 | 2462 | 1945-02-14 | N.V. Indisch Kantoor van Koopman & Company | 1942-08-14 | NETHERLANDS | Bernard Preyer Company 96 | 1942-08-14 | Bernard Preyer Company | |||||
3589 | 3589 | 1943-03-11 | Credito Minero y Mercantil, S.A. | 1942-08-14 | MEXICO | Jordan, H.A. 95 | 1942-08-14 | Jordan, H.A. | Mexico City | ||||
10348 | 10348 | 1943-08-15 | Adam Stricker | 1942-08-15 | GERMANY, FEDERAL REPUBLIC OF | Gebhardt, H.A. 97 | 1942-08-15 | Gebhardt, H.A. | |||||
10349 | 10349 | 1943-08-15 | Adolph Lipschuetz | 1942-08-15 | GERMANY, FEDERAL REPUBLIC OF | Gebhardt, H.A. 97 | 1942-08-15 | Gebhardt, H.A. | |||||
10350 | 10350 | 1943-08-15 | Albert Friedrich Wilhelm | 1942-08-15 | GERMANY, FEDERAL REPUBLIC OF | Gebhardt, H.A. 97 | 1942-08-15 | Gebhardt, H.A. | |||||
10351 | 10351 | 1943-08-15 | Alois Muller | 1942-08-15 | GERMANY, FEDERAL REPUBLIC OF | Gebhardt, H.A. 97 | 1942-08-15 | Gebhardt, H.A. | |||||
10352 | 10352 | 1943-08-15 | Anna Kley | 1942-08-15 | GERMANY, FEDERAL REPUBLIC OF | Gebhardt, H.A. 97 | 1942-08-15 | Gebhardt, H.A. | |||||
10353 | 10353 | 1943-08-15 | Anna Willmy nee Stricker | 1942-08-15 | GERMANY, FEDERAL REPUBLIC OF | Gebhardt, H.A. 97 | 1942-08-15 | Gebhardt, H.A. | |||||
10354 | 10354 | 1943-08-15 | Anton Muller | 1942-08-15 | GERMANY, FEDERAL REPUBLIC OF | Gebhardt, H.A. 97 | 1942-08-15 | Gebhardt, H.A. | |||||
10355 | 10355 | 1943-08-15 | Anton Stricker | 1942-08-15 | GERMANY, FEDERAL REPUBLIC OF | Gebhardt, H.A. 97 | 1942-08-15 | Gebhardt, H.A. | |||||
10356 | 10356 | 1943-08-15 | August Kley | 1942-08-15 | GERMANY, FEDERAL REPUBLIC OF | Gebhardt, H.A. 97 | 1942-08-15 | Gebhardt, H.A. | |||||
10357 | 10357 | 1943-08-15 | Auguste Ackermann | 1942-08-15 | GERMANY, FEDERAL REPUBLIC OF | Gebhardt, H.A. 97 | 1942-08-15 | Gebhardt, H.A. | |||||
10358 | 10358 | 1943-08-15 | Auguste Figge | 1942-08-15 | GERMANY, FEDERAL REPUBLIC OF | Gebhardt, H.A. 97 | 1942-08-15 | Gebhardt, H.A. | |||||
10359 | 10359 | 1943-08-15 | Bernhard Kopp | 1942-08-15 | GERMANY, FEDERAL REPUBLIC OF | Gebhardt, H.A. 97 | 1942-08-15 | Gebhardt, H.A. | |||||
10360 | 10360 | 1943-08-15 | Berta Steimel | 1942-08-15 | GERMANY, FEDERAL REPUBLIC OF | Gebhardt, H.A. 97 | 1942-08-15 | Gebhardt, H.A. | |||||
10361 | 10361 | 1943-08-15 | Berta Tucholsky | 1942-08-15 | GERMANY, FEDERAL REPUBLIC OF | Gebhardt, H.A. 97 | 1942-08-15 | Gebhardt, H.A. | |||||
10362 | 10362 | 1943-08-15 | Bertha Oberst | 1942-08-15 | GERMANY, FEDERAL REPUBLIC OF | Gebhardt, H.A. 97 | 1942-08-15 | Gebhardt, H.A. | |||||
10363 | 10363 | 1943-08-15 | Carl Neithold | 1942-08-15 | GERMANY, FEDERAL REPUBLIC OF | Gebhardt, H.A. 97 | 1942-08-15 | Gebhardt, H.A. | |||||
10364 | 10364 | 1943-08-15 | Carl Rettkowski, Jr. | 1942-08-15 | GERMANY, FEDERAL REPUBLIC OF | Gebhardt, H.A. 97 | 1942-08-15 | Gebhardt, H.A. | |||||
10365 | 10365 | 1943-08-15 | Christian Bidenbach | 1942-08-15 | GERMANY, FEDERAL REPUBLIC OF | Gebhardt, H.A. 97 | 1942-08-15 | Gebhardt, H.A. | |||||
10366 | 10366 | 1943-08-15 | Christian Kley | 1942-08-15 | GERMANY, FEDERAL REPUBLIC OF | Gebhardt, H.A. 97 | 1942-08-15 | Gebhardt, H.A. | |||||
10367 | 10367 | 1943-08-15 | Curt Rettkowski | 1942-08-15 | GERMANY, FEDERAL REPUBLIC OF | Gebhardt, H.A. 97 | 1942-08-15 | Gebhardt, H.A. | |||||
10368 | 10368 | 1943-08-15 | Elisabeth Kreyser | 1942-08-15 | GERMANY, FEDERAL REPUBLIC OF | Gebhardt, H.A. 97 | 1942-08-15 | Gebhardt, H.A. | |||||
10369 | 10369 | 1943-08-15 | Elisabeth Paetsch | 1942-08-15 | GERMANY, FEDERAL REPUBLIC OF | Gebhardt, H.A. 97 | 1942-08-15 | Gebhardt, H.A. | |||||
10370 | 10370 | 1943-08-15 | Elise Fritz | 1942-08-15 | GERMANY, FEDERAL REPUBLIC OF | Gebhardt, H.A. 97 | 1942-08-15 | Gebhardt, H.A. | |||||
10371 | 10371 | 1943-08-15 | Elise Meck nee Finskh | 1942-08-15 | GERMANY, FEDERAL REPUBLIC OF | Gebhardt, H.A. 97 | 1942-08-15 | Gebhardt, H.A. | |||||
10372 | 10372 | 1943-08-15 | Elise Natter | 1942-08-15 | GERMANY, FEDERAL REPUBLIC OF | Gebhardt, H.A. 97 | 1942-08-15 | Gebhardt, H.A. | |||||
10373 | 10373 | 1943-08-15 | Elise Oberst | 1942-08-15 | GERMANY, FEDERAL REPUBLIC OF | Gebhardt, H.A. 97 | 1942-08-15 | Gebhardt, H.A. | |||||
10374 | 10374 | 1943-08-15 | Else Huhs nee Lueders | 1942-08-15 | GERMANY, FEDERAL REPUBLIC OF | Gebhardt, H.A. 97 | 1942-08-15 | Gebhardt, H.A. | |||||
10375 | 10375 | 1943-08-15 | Emil Becker | 1942-08-15 | GERMANY, FEDERAL REPUBLIC OF | Gebhardt, H.A. 97 | 1942-08-15 | Gebhardt, H.A. | |||||
10376 | 10376 | 1943-08-15 | Emil Kreher | 1942-08-15 | GERMANY, FEDERAL REPUBLIC OF | Gebhardt, H.A. 97 | 1942-08-15 | Gebhardt, H.A. |
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]) );