FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
16,939 rows sorted by Registrant_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
- …
Registrant_Date (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 >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 797
- MEXICO 569
- GREAT BRITAIN 542
- FRANCE 489
- KOREA, SOUTH 422
- GERMANY, FEDERAL REPUBLIC OF 387
- INTERNATIONAL 328
- USSR 297
- ISRAEL 285
- CHINA 266
- TAIWAN 251
- RUSSIA 240
- SAUDI ARABIA 237
- DOMINICAN REPUBLIC 227
- ITALY 226
- NETHERLANDS 218
- SWITZERLAND 196
- TURKEY 187
- CUBA 180
- AUSTRALIA 179
- GERMANY 178
- BRAZIL 175
- POLAND 175
- HAITI 173
- PHILIPPINES 170
- VENEZUELA 165
- PANAMA 163
- SPAIN 158
- SOUTH AFRICA 155
- …
City >30
- - 14,882
- 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9521 | 9521 | 1960-07-27 | Air France Transatlantique | 1942-07-27 | FRANCE | Compagnie Generale Transatlantique (French Line) 62 | 1942-07-27 | Compagnie Generale Transatlantique (French Line) | Paris | ||||
9522 | 9522 | 1960-07-27 | Association Petroliere | 1944-03-10 | FRANCE | Compagnie Generale Transatlantique (French Line) 62 | 1942-07-27 | Compagnie Generale Transatlantique (French Line) | Paris | ||||
9523 | 9523 | 1960-07-27 | Compagnie Auxiliaire de Navigation | 1942-07-27 | FRANCE | Compagnie Generale Transatlantique (French Line) 62 | 1942-07-27 | Compagnie Generale Transatlantique (French Line) | Paris | ||||
9524 | 9524 | 1960-07-27 | Compagnie Generale Transatlantique | 1942-07-27 | FRANCE | Compagnie Generale Transatlantique (French Line) 62 | 1942-07-27 | Compagnie Generale Transatlantique (French Line) | Paris | ||||
9525 | 9525 | 1960-07-27 | Compagnie Havraise de Navigation a Vapeur | 1957-02-21 | FRANCE | Compagnie Generale Transatlantique (French Line) 62 | 1942-07-27 | Compagnie Generale Transatlantique (French Line) | Paris | ||||
9526 | 9526 | 1960-07-27 | Compagnie de Navigation Europeenne | 1957-02-21 | FRANCE | Compagnie Generale Transatlantique (French Line) 62 | 1942-07-27 | Compagnie Generale Transatlantique (French Line) | Marseille | ||||
9527 | 9527 | 1960-07-27 | French Colonial Supply Mission (for the Account of the Governor of Martinique) (F.W.I.) | 1944-07-29 | FRANCE | Compagnie Generale Transatlantique (French Line) 62 | 1942-07-27 | Compagnie Generale Transatlantique (French Line) | New York | NY | |||
9528 | 9528 | 1960-07-27 | Maurel & Prom | 1942-07-27 | FRANCE | Compagnie Generale Transatlantique (French Line) 62 | 1942-07-27 | Compagnie Generale Transatlantique (French Line) | Paris | ||||
9529 | 9529 | 1960-07-27 | Messageries Maritimes | 1942-07-27 | FRANCE | Compagnie Generale Transatlantique (French Line) 62 | 1942-07-27 | Compagnie Generale Transatlantique (French Line) | Paris | ||||
9530 | 9530 | 1960-07-27 | Mission des Transports Maritimes (French Maritime Commission) | 1942-07-27 | FRANCE | Compagnie Generale Transatlantique (French Line) 62 | 1942-07-27 | Compagnie Generale Transatlantique (French Line) | Paris | ||||
9531 | 9531 | 1960-07-27 | Societe Francasie des Transports Petroliers | 1942-07-27 | FRANCE | Compagnie Generale Transatlantique (French Line) 62 | 1942-07-27 | Compagnie Generale Transatlantique (French Line) | Paris | ||||
9532 | 9532 | 1960-07-27 | Societe Generale des Transports Maritimes a Vapeur | 1942-07-27 | FRANCE | Compagnie Generale Transatlantique (French Line) 62 | 1942-07-27 | Compagnie Generale Transatlantique (French Line) | Paris | ||||
9533 | 9533 | 1960-07-27 | Societe Maritime Nationale | 1957-02-21 | FRANCE | Compagnie Generale Transatlantique (French Line) 62 | 1942-07-27 | Compagnie Generale Transatlantique (French Line) | Paris | ||||
9534 | 9534 | 1960-07-27 | Societe Navale Caennaise | 1957-02-21 | FRANCE | Compagnie Generale Transatlantique (French Line) 62 | 1942-07-27 | Compagnie Generale Transatlantique (French Line) | Paris | ||||
9535 | 9535 | 1960-07-27 | Societe des Voyages et Hotels Nord-Africains | 1942-07-27 | FRANCE | Compagnie Generale Transatlantique (French Line) 62 | 1942-07-27 | Compagnie Generale Transatlantique (French Line) | Paris | ||||
9536 | 9536 | 1960-07-27 | Union Industrielle et Maritime | 1957-02-21 | FRANCE | Compagnie Generale Transatlantique (French Line) 62 | 1942-07-27 | Compagnie Generale Transatlantique (French Line) | Paris | ||||
11786 | 11786 | 1993-09-23 | Swedish Tourist Board | 1942-07-27 | SWEDEN | Swedish Tourist Office 68 | 1942-07-27 | Swedish Tourist Office | Stockholm | ||||
15515 | 15515 | 1942-12-31 | Broadcast Exchange of Australia Party, Ltd. | 1942-07-27 | AUSTRALIA | Brown, Howard C. 64 | 1942-07-27 | Brown, Howard C. | Melbourne | ||||
8185 | 8185 | 1946-06-30 | Stockholms Superfosfat Fabriks A.B. (Stockholm's Superphosphate Company) | 1945-03-02 | SWEDEN | Swedish Industries Fund, Inc. 69 | 1942-07-28 | Swedish Industries Fund, Inc. | |||||
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. | |||||
8188 | 8188 | 1946-06-30 | A.B. Gasaccumulator | 1945-03-02 | 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. | |||||
8193 | 8193 | 1946-06-30 | A.B. Svenska Ostasiastiska Kompaniet (Swedish East Asiatic Company | 1945-03-02 | SWEDEN | Swedish Industries Fund, Inc. 69 | 1942-07-28 | Swedish Industries Fund, Inc. | |||||
8194 | 8194 | 1946-06-30 | A.B. Tirfing S.S. Line | 1945-03-02 | 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. | |||||
8202 | 8202 | 1946-06-30 | Stora Kopparbergs Company | 1945-03-02 | 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. | |||||
8204 | 8204 | 1946-06-30 | Swedish-America-Mexico Line | 1945-03-02 | 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 | ||||
13794 | 13794 | 1973-11-07 | Swedish Ministry for Foreign Affairs | 1973-05-24 | 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 | |||||
9657 | 9657 | 1964-07-31 | Autotransporte Touristico Espanol, S.A. | 1956-04-13 | SPAIN | Kelly, Nason, Inc. 71 | 1942-07-30 | Kelly, Nason, Inc. | Madrid | ||||
9658 | 9658 | 1964-07-31 | Bermuda Hotels, Inc. | 1942-07-30 | BERMUDA | Kelly, Nason, Inc. 71 | 1942-07-30 | Kelly, Nason, Inc. | Hamilton | ||||
9659 | 9659 | 1964-07-31 | British Colonial Hotel | 1953-09-18 | BAHAMAS | Kelly, Nason, Inc. 71 | 1942-07-30 | Kelly, Nason, Inc. | Nassau | ||||
9660 | 9660 | 1964-07-31 | Burns House, Ltd. | 1955-03-31 | BAHAMAS | Kelly, Nason, Inc. 71 | 1942-07-30 | Kelly, Nason, Inc. | Nassau | ||||
9661 | 9661 | 1964-07-31 | Cabo Blanco Fishing Club | 1956-04-13 | PERU | Kelly, Nason, Inc. 71 | 1942-07-30 | Kelly, Nason, Inc. | Cabo Blanco | ||||
9664 | 9664 | 1964-07-31 | City Gift Shop | 1957-04-08 | BAHAMAS | Kelly, Nason, Inc. 71 | 1942-07-30 | Kelly, Nason, Inc. | Nassau | ||||
9665 | 9665 | 1964-07-31 | Cremo Cheese Company | 1953-03-30 | DENMARK | Kelly, Nason, Inc. 71 | 1942-07-30 | Kelly, Nason, Inc. | Copenhagen | ||||
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 | ||||
9668 | 9668 | 1964-07-31 | Egyptian State Department of Tourism | 1955-03-31 | EGYPT | Kelly, Nason, Inc. 71 | 1942-07-30 | Kelly, Nason, Inc. | Cairo | ||||
9669 | 9669 | 1964-07-31 | French Leave | 1960-03-03 | BAHAMAS | Kelly, Nason, Inc. 71 | 1942-07-30 | Kelly, Nason, Inc. | Eleuthera | ||||
9671 | 9671 | 1964-07-31 | Harold G. Christie | 1942-07-30 | BAHAMAS | Kelly, Nason, Inc. 71 | 1942-07-30 | Kelly, Nason, Inc. | Nassau | ||||
9672 | 9672 | 1964-07-31 | House of 4711"" | 1962-03-06 | GERMANY, FEDERAL REPUBLIC OF | Kelly, Nason, Inc. 71 | 1942-07-30 | Kelly, Nason, Inc. | Cologne | ||||
9673 | 9673 | 1964-07-31 | Iberia Airlines of Spain | 1957-01-28 | SPAIN | Kelly, Nason, Inc. 71 | 1942-07-30 | Kelly, Nason, Inc. | Madrid | ||||
9674 | 9674 | 1964-07-31 | Incres Cia Navigacion, S.A. | 1952-09-25 | PANAMA | Kelly, Nason, Inc. 71 | 1942-07-30 | Kelly, Nason, Inc. | Panama City | ||||
9675 | 9675 | 1964-07-31 | Incres Compagnia de Navigacion, S.A. | 1955-03-31 | ITALY | Kelly, Nason, Inc. 71 | 1942-07-30 | Kelly, Nason, Inc. | Genoa | ||||
9676 | 9676 | 1964-07-31 | Italian Airlines | 1953-09-18 | ITALY | Kelly, Nason, Inc. 71 | 1942-07-30 | Kelly, Nason, Inc. | New York | NY | |||
9677 | 9677 | 1964-07-31 | Italian National Tourist Office | 1950-03-24 | ITALY | Kelly, Nason, Inc. 71 | 1942-07-30 | Kelly, Nason, Inc. | New York | NY | |||
9678 | 9678 | 1964-07-31 | James Lovick & Company, Ltd. | 1955-03-31 | CANADA | Kelly, Nason, Inc. 71 | 1942-07-30 | Kelly, Nason, Inc. | Montreal | ||||
9679 | 9679 | 1964-07-31 | Japan Tourist Association | 1960-03-03 | JAPAN | Kelly, Nason, Inc. 71 | 1942-07-30 | Kelly, Nason, Inc. | New York | NY | |||
9680 | 9680 | 1964-07-31 | Japan Trade Center/Japan Camera Information & Service Center | 1956-04-13 | JAPAN | Kelly, Nason, Inc. 71 | 1942-07-30 | Kelly, Nason, Inc. | New York | NY | |||
9681 | 9681 | 1964-07-31 | Japan Travel Information Office/Japan Travel Bureau | 1953-09-18 | JAPAN | Kelly, Nason, Inc. 71 | 1942-07-30 | Kelly, Nason, Inc. | New York | NY | |||
9682 | 9682 | 1964-07-31 | Kingdom of Greece/National Tourist Organization | 1954-10-12 | GREECE | Kelly, Nason, Inc. 71 | 1942-07-30 | Kelly, Nason, Inc. | Athens | ||||
9683 | 9683 | 1964-07-31 | Lauro Lines/Polazzo Lauro | 1955-03-31 | ITALY | Kelly, Nason, Inc. 71 | 1942-07-30 | Kelly, Nason, Inc. | Naples | ||||
9684 | 9684 | 1964-07-31 | Linjebuss International, A.B. | 1956-04-13 | SWEDEN | Kelly, Nason, Inc. 71 | 1942-07-30 | Kelly, Nason, Inc. | Stockholm | ||||
9685 | 9685 | 1964-07-31 | Lyford Cay Development Company, Ltd. | 1957-09-17 | BAHAMAS | Kelly, Nason, Inc. 71 | 1942-07-30 | Kelly, Nason, Inc. | Nassau | ||||
9686 | 9686 | 1964-07-31 | Montagu Beach Hotel | 1960-03-03 | BAHAMAS | Kelly, Nason, Inc. 71 | 1942-07-30 | Kelly, Nason, Inc. | Nassau | ||||
9687 | 9687 | 1964-07-31 | Nassau Yachthaven | 1953-03-30 | BAHAMAS | Kelly, Nason, Inc. 71 | 1942-07-30 | Kelly, Nason, Inc. | Nassau | ||||
9688 | 9688 | 1964-07-31 | Nova Scotia Ministry of Industry & Publicity | 1950-03-24 | CANADA | Kelly, Nason, Inc. 71 | 1942-07-30 | Kelly, Nason, Inc. | Halifax, Nova Scotia | ||||
9689 | 9689 | 1964-07-31 | Palmdale Villas | 1956-04-13 | BAHAMAS | Kelly, Nason, Inc. 71 | 1942-07-30 | Kelly, Nason, Inc. | Nassau | ||||
9690 | 9690 | 1964-07-31 | Perret & Berthoud, S.A. | 1955-03-31 | SWITZERLAND | Kelly, Nason, Inc. 71 | 1942-07-30 | Kelly, Nason, Inc. | Geneva | ||||
9691 | 9691 | 1964-07-31 | Pilot House Club | 1962-12-10 | BAHAMAS | Kelly, Nason, Inc. 71 | 1942-07-30 | Kelly, Nason, Inc. | Nassau | ||||
9692 | 9692 | 1964-07-31 | Princess Hotel of Bermuda, Ltd. | 1955-03-31 | BERMUDA | Kelly, Nason, Inc. 71 | 1942-07-30 | Kelly, Nason, Inc. | Hamilton | ||||
9693 | 9693 | 1964-07-31 | Spanish State Tourist Department | 1950-03-24 | SPAIN | Kelly, Nason, Inc. 71 | 1942-07-30 | Kelly, Nason, Inc. | New York | NY | |||
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 | ||||
9696 | 9696 | 1964-07-31 | United Arab Republic Tourist Office | 1958-10-08 | UNITED ARAB EMIRATES | Kelly, Nason, Inc. 71 | 1942-07-30 | Kelly, Nason, Inc. | Cairo | ||||
9697 | 9697 | 1964-07-31 | Yarmouth County Tourist Committee | 1952-06-20 | CANADA | Kelly, Nason, Inc. 71 | 1942-07-30 | Kelly, Nason, Inc. | Nova Scotia | ||||
9698 | 9698 | 1964-07-31 | Yugoslav State Tourist Office | 1957-09-17 | YUGOSLAVIA | Kelly, Nason, Inc. 71 | 1942-07-30 | Kelly, Nason, Inc. | Zagreb | ||||
1939 | 1939 | 1943-02-01 | Alfredo Lluro | 1943-03-12 | PANAMA | Pan-American Associated Enterprises 77 | 1942-08-01 | Pan-American Associated Enterprises | |||||
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 | ||||
1944 | 1944 | 1943-02-01 | F. Rodriquez Rosa | 1943-03-12 | MEXICO | Pan-American Associated Enterprises 77 | 1942-08-01 | Pan-American Associated Enterprises | |||||
1945 | 1945 | 1943-02-01 | Hector Cabral | 1943-03-12 | PERU | Pan-American Associated Enterprises 77 | 1942-08-01 | Pan-American Associated Enterprises | Lima |
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]) );