FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
2,986 rows where Address_1 = "" sorted by City
This data as json, CSV (advanced)
Suggested facets: Address_2, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date)
Registrant_Name >30
- Gebhardt, H.A. 158
- Modern Education Services, Inc. 128
- North American Precis Syndicate 89
- Koenig, Harry D. 67
- Hill and Knowlton Strategies, LLC 40
- Ruder Finn, Inc. 38
- Union Nacional Sinarquista 37
- Development Counsellors International, Ltd. 29
- Tromson Monroe Advertising, Inc. 27
- Robert R. Nathan Associates, Inc. 26
- Tanaka, Michele N. 24
- Swedish Industries Fund, Inc. 20
- Jones Day 18
- Manchester Associates, Ltd. 18
- Amtorg Trading Corporation 17
- International Public Relations Company, Ltd. 16
- Arnold & Porter Kaye Scholer LLP 15
- Myriad International Marketing, LLC 15
- Hamel, Park, McCabe & Saunders 14
- Keating Group, Inc. 14
- Wald, Harkrader & Ross 13
- Burson-Marsteller 12
- L.A. Motley & Company 12
- Shaw, Pittman, Potts & Trowbridge 12
- Sontheimer Hazlett, Ltd. 12
- Fleishman-Hillard, Inc. 11
- Peter Martin Associates, Inc. 11
- Surrey & Morse 11
- Berry, Max N. 10
- Chapman, DiSalle & Friedman 10
- …
Registrant_Date (date) >30 ✖
- 1942-08-15 158
- 1964-10-19 128
- 1977-10-12 89
- 1942-10-29 67
- 1981-11-10 40
- 1942-09-14 37
- 1961-09-27 36
- 1961-01-30 29
- 1946-04-22 27
- 1973-01-09 27
- 1956-04-24 24
- 1979-08-09 24
- 1942-07-28 21
- 1982-12-10 19
- 1949-11-07 17
- 1966-03-14 16
- 1964-06-04 15
- 2018-04-30 15
- 1961-02-07 14
- 1973-10-23 14
- 1973-11-23 14
- 1981-05-10 13
- 1963-07-19 12
- 1975-02-21 12
- 1985-08-15 12
- 1976-01-05 11
- 1943-09-28 10
- 1955-01-21 10
- 1970-10-30 10
- 1976-10-18 10
- …
Foreign_Principal >30
- Hong Kong Trade Development Council 13
- Embassy of Japan 11
- Mexican National Tourist Council 9
- Government of Haiti 8
- Instituto Panameno de Turismo 8
- Australian Tourist Commission 6
- Government of Canada 6
- Government of Mexico 6
- Jamaica Tourist Board 6
- Republic of Panama 6
- Union Nacional Sinarquista 6
- Aeromexico 5
- CEDOK 5
- Government of Israel 5
- Intourist 5
- Japan Fisheries Association 5
- Scottish Development Agency 5
- Aeroport de Paris 4
- Austrian Press & Information Service 4
- Barbados Industrial Development Corporation 4
- Canadian Tubular Producers' Association 4
- Electronic Industries Association of Japan 4
- Embassy of Argentina 4
- German Information Center 4
- Government of Colombia 4
- Government of the Cayman Islands 4
- Japan National Tourist Organization 4
- Kingdom of Morocco 4
- Neptune Orient Lines, Ltd. 4
- No foreign principal listed 4
- …
Country/Location_Represented >30
- MEXICO 254
- GERMANY, FEDERAL REPUBLIC OF 238
- CANADA 141
- JAPAN 127
- FRANCE 100
- USSR 92
- GREAT BRITAIN 82
- PANAMA 56
- HONG KONG 50
- KOREA, SOUTH 49
- ISRAEL 45
- SWEDEN 43
- DOMINICAN REPUBLIC 41
- BRAZIL 40
- VENEZUELA 40
- ITALY 38
- TAIWAN 36
- AUSTRALIA 35
- AUSTRIA 34
- PHILIPPINES 34
- SAUDI ARABIA 34
- INTERNATIONAL 32
- JAMAICA 32
- SOUTH AFRICA 32
- CHINA 31
- GUATEMALA 31
- CUBA 30
- NETHERLANDS 30
- POLAND 29
- SWITZERLAND 26
- …
City >30
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6 | 6 | Center for Facilitation of Investments (through L' Association des Industries d' Haiti (ADIH) | 2021-04-22 | HAITI | Sorini, Samet & Associates, LLC 5839 | 2007-11-12 | Sorini, Samet & Associates, LLC | ||||||
15 | 15 | People's Republic of Bangladesh (through Nelson Mullins Riley & Scarborough LLP) | 2023-04-28 | BANGLADESH | Moran Global Strategies, Inc. 7255 | 2023-04-10 | Moran Global Strategies, Inc. | ||||||
17 | 17 | People's Republic of Bangladesh | 2022-03-21 | BANGLADESH | Nurnberger & Associates, Inc. 6907 | 2021-01-13 | Nurnberger & Associates, Inc. | ||||||
20 | 20 | Sudan People's Liberation Movement - North | 2012-02-23 | SUDAN | Sprague, Esther Marie 6091 | 2012-02-23 | Sprague, Esther Marie | ||||||
21 | 21 | Sudan People's Liberation Movement Revolutionary Democratic Current | 2023-05-15 | SUDAN | Sprague, Esther Marie 6091 | 2012-02-23 | Sprague, Esther Marie | ||||||
28 | 28 | Ad Hoc Board of Petroleos de Venezuela, S.A. (PDVSA Ad Hoc Board")" | 2021-10-06 | VENEZUELA | Horacio Francisco Medina Herrera 7023 | 2021-10-06 | Horacio Francisco Medina Herrera | ||||||
36 | 36 | Agrobank | 2023-01-23 | UZBEKISTAN | Friedlander Consulting Group LLC 7009 | 2021-09-03 | Friedlander Consulting Group LLC | ||||||
45 | 45 | All-Ukrainian Industry Association Federation of Employers of the Oil and Gas Industry"" | 2020-01-05 | UKRAINE | Yorktown Solutions, LLC 6491 | 2017-11-19 | Yorktown Solutions, LLC | ||||||
52 | 52 | Association for the Promotion of the Autonomous Region of Madeira | 2021-11-29 | PORTUGAL | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | ||||||
55 | 55 | Atomenergoremont PLC | 2021-12-23 | BULGARIA | QORVIS LLC 5483 | 2002-03-06 | QORVIS LLC | ||||||
61 | 61 | B.N. Barkat Holdings and Studio Ltd | 2023-05-24 | ISRAEL | Rubenstein Associates, Inc. 7247 | 2023-03-21 | Rubenstein Associates, Inc. | ||||||
65 | 65 | Banco Central de Venezuela represented by the Ad-hoc Board | 2023-06-02 | VENEZUELA | Arnold & Porter Kaye Scholer LLP 1750 | 1964-06-04 | Arnold & Porter Kaye Scholer LLP | ||||||
72 | 72 | Bergey Ryskaliyev | 2019-05-31 | KAZAKHSTAN | Wiles, Lanny 6664 | 2019-04-15 | Wiles, Lanny | ||||||
88 | 88 | Business Finland | 2021-11-29 | FINLAND | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | ||||||
89 | 89 | Business France | 2020-09-04 | FRANCE | Dozier, Daniel P. 6866 | 2020-09-04 | Dozier, Daniel P. | ||||||
93 | 93 | Cambodia National Rescue Party | 2021-11-10 | CAMBODIA | Sochua Mu Leiper 7042 | 2021-11-10 | Sochua Mu Leiper | ||||||
102 | 102 | Catalan National Assembly in the United States of America Association | 2022-11-29 | SPAIN | Miquel Fernandez Barros 7197 | 2022-11-29 | Miquel Fernandez Barros | ||||||
110 | 110 | Chimediin Saikhanbileg | 2021-01-26 | MONGOLIA | Amsterdam & Partners, LLP 6325 | 2015-10-26 | Amsterdam & Partners, LLP | ||||||
114 | 114 | China-United States Exchange Foundation | 2011-07-14 | CHINA | BLJ Worldwide LTD 5875 | 2008-06-17 | BLJ Worldwide LTD | ||||||
124 | 124 | Consulate General of Japan in Atlanta | 2022-08-11 | JAPAN | Gilbert, Harrell, Sumerford & Martin 7155 | 2022-08-11 | Gilbert, Harrell, Sumerford & Martin | ||||||
129 | 129 | Coordination of the Movements of the Azawad (CMA) | 2017-10-30 | MALI | Independent Diplomat, Inc. 5860 | 2008-04-03 | Independent Diplomat, Inc. | ||||||
135 | 135 | DEACERO S.A.P.I. de .C,V, (DEACERO) | 2022-03-17 | MEXICO | DEACERO S.A.P.I. de C.V. (DEACERO) 7013 | 2021-09-07 | DEACERO S.A.P.I. de C.V. (DEACERO) | ||||||
144 | 144 | Destination British Columbia | 2023-05-30 | CANADA | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | ||||||
146 | 146 | Deutsche Zentrale fuer Tourismus (German National Tourist Board) | 1950-02-28 | GERMANY | German National Tourist Office 616 | 1950-02-28 | German National Tourist Office | ||||||
183 | 183 | Embassy of Philippines | 2022-12-30 | PHILIPPINES | Sorini, Samet & Associates, LLC 5839 | 2007-11-12 | Sorini, Samet & Associates, LLC | ||||||
212 | 212 | Embassy of the Republic of Rwanda in Washington, D.C-USA | 2018-12-18 | RWANDA | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | ||||||
229 | 229 | Embassy of the United Arab Emirates via Akin Gump Strauss Hauer & Feld LLP | 2020-02-13 | UNITED ARAB EMIRATES | American Defense International, Inc. 6567 | 2018-07-05 | American Defense International, Inc. | ||||||
231 | 231 | Embassy of the United Arab Emirates | 2022-04-11 | UNITED ARAB EMIRATES | FGS Global (US) LLC (FKA FGH Holdings LLC) 5666 | 2005-01-31 | FGS Global (US) LLC (FKA FGH Holdings LLC) | ||||||
236 | 236 | Emirates Nuclear Energy Company | 2023-04-27 | UNITED ARAB EMIRATES | Charles Hayes Peterson 7264 | 2023-04-27 | Charles Hayes Peterson | ||||||
241 | 241 | Euromax Resources Ltd. | 2019-11-20 | CANADA | Halcyon Associates 6752 | 2019-11-20 | Halcyon Associates | ||||||
242 | 242 | Executive of the World Zionist Organization, Jerusalem | 1971-09-21 | ISRAEL | World Zionist Organization - American Section, Inc. 2278 | 1971-09-21 | World Zionist Organization - American Section, Inc. | ||||||
257 | 257 | Freedom at Home and Abroad, on behalf of Campaign for Freedom LTD | 2023-08-01 | UNITED KINGDOM | NP Consulting Inc. 7301 | 2023-08-01 | NP Consulting Inc. | ||||||
282 | 282 | Government of Hong Kong | 1968-10-29 | HONG KONG | Hong Kong Tourism Board 2110 | 1968-10-29 | Hong Kong Tourism Board | ||||||
299 | 299 | Government of the Cayman Islands | 1974-03-04 | CAYMAN ISLANDS | Cayman Islands Department of Tourism 2500 | 1974-03-04 | Cayman Islands Department of Tourism | ||||||
327 | 327 | Hikvision USA, Inc. | 2022-10-14 | CHINA | Sidley Austin LLP 3731 | 1985-09-13 | Sidley Austin LLP | ||||||
331 | 331 | Hong Kong Trade Development Council | 1970-01-19 | HONG KONG | Hong Kong Trade Development Council, Inc. 2181 | 1970-01-19 | Hong Kong Trade Development Council, Inc. | ||||||
363 | 363 | Italian National Tourist Board | 2022-12-13 | ITALY | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | ||||||
364 | 364 | JNG Shareholders Group | 1993-12-10 | JAPAN | NHK Cosmomedia America, Inc. 4490 | 1991-03-26 | NHK Cosmomedia America, Inc. | ||||||
376 | 376 | Japan National Tourist Organization | 2021-11-29 | JAPAN | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | ||||||
377 | 377 | Japanese National Tourism Organization through All Nippon Airways | 2021-12-06 | JAPAN | Harris, Waheeda 7053 | 2021-12-06 | Harris, Waheeda | ||||||
402 | 402 | Komala Party of Iranian Kurdistan | 2018-09-27 | IRAN | Bayaziddi, Salah 6595 | 2018-09-27 | Bayaziddi, Salah | ||||||
404 | 404 | Korea Institute for International Economic Policy (KIEP) | 1990-02-28 | KOREA, SOUTH | Korea Economic Institute 3327 | 1982-02-01 | Korea Economic Institute | ||||||
407 | 407 | Korea International Trade Association, Inc. | 2020-01-31 | KOREA, SOUTH | K&L Gates, LLP 6331 | 2015-12-18 | K&L Gates, LLP | ||||||
410 | 410 | Korea Trade-Investment Promotion Agency | 1963-04-17 | KOREA, SOUTH | KOTRA 1619 | 1963-04-17 | KOTRA | ||||||
416 | 416 | Kurdistan Regional Government | 2014-04-14 | IRAQ | Greenberg Traurig, LLP 5712 | 2005-10-03 | Greenberg Traurig, LLP | ||||||
428 | 428 | Les Transformateurs | 2023-05-16 | CHAD | Scribe Strategies & Advisors, Inc. 6305 | 2015-07-20 | Scribe Strategies & Advisors, Inc. | ||||||
438 | 438 | Libyan Asset Recovery and Management Office | 2021-05-28 | LIBYA | Holland & Knight 3718 | 1985-08-07 | Holland & Knight | ||||||
459 | 459 | Ministry of Commerce and Industries, Republic of Panama | 2022-11-14 | PANAMA | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | ||||||
472 | 472 | Ministry of Foreign Affairs of Japan Embassy | 2019-05-28 | JAPAN | Prime Policy Group 6377 | 2016-09-19 | Prime Policy Group | ||||||
500 | 500 | Mr.Julio Herrera Velutini | 2022-12-19 | ITALY | Sonoran Policy Group, LLC D/B/A Stryk Global Diplomacy 6399 | 2016-12-11 | Sonoran Policy Group, LLC D/B/A Stryk Global Diplomacy | ||||||
509 | 509 | NSW Government | 2022-07-22 | AUSTRALIA | NSW Government US Office Inc. 7145 | 2022-07-22 | NSW Government US Office Inc. | ||||||
513 | 513 | National Council of Resistance of Iran | 2019-09-26 | IRAN | Mukasey, Michael B. 6727 | 2019-09-26 | Mukasey, Michael B. | ||||||
550 | 550 | Pakistan Tehreek-e-Insaaf USA | 2023-02-21 | PAKISTAN | Praia Consultants LLC 6857 | 2020-08-18 | Praia Consultants LLC | ||||||
558 | 558 | Petróleos de Venezuela, S.A. (PDVSA) | 2021-04-30 | VENEZUELA | PDV USA, Inc. 6903 | 2020-12-31 | PDV USA, Inc. | ||||||
560 | 560 | Polish Institute of International Affairs (PISM) | 2022-01-21 | POLAND | Doran, Peter B. 7073 | 2022-01-21 | Doran, Peter B. | ||||||
578 | 578 | Quebec Government | 1964-09-02 | CANADA | Quebec Government Office 1787 | 1964-09-02 | Quebec Government Office | ||||||
588 | 588 | Republic of India | 2020-10-08 | INDIA | Williams Group 6790 | 2020-02-06 | Williams Group | ||||||
594 | 594 | Republic of Singapore | 1973-03-27 | SINGAPORE | Singapore Tourism Board 2414 | 1973-03-27 | Singapore Tourism Board | ||||||
596 | 596 | Republic of Turkey | 2020-06-29 | TURKEY | Saltzman & Evinch, PLLC 6842 | 2020-06-29 | Saltzman & Evinch, PLLC | ||||||
607 | 607 | Robert Kyagulanyi Ssentamu (AKA Bobi Wine) | 2018-09-12 | UGANDA | Vanguard Africa 6411 | 2017-03-26 | Vanguard Africa | ||||||
628 | 628 | Scottish Enterprise (formerly: Scottish Development Agency) | 1979-04-17 | SCOTLAND | Scottish Enterprise 3013 | 1979-04-17 | Scottish Enterprise | ||||||
635 | 635 | Singapore Economic Development Board | 1967-02-02 | SINGAPORE | Singapore Economic Development Board 2003 | 1967-02-02 | Singapore Economic Development Board | ||||||
650 | 650 | St. Lucia Tourist Board | 1976-03-15 | SAINT LUCIA | St. Lucia Tourism Authority 2668 | 1976-03-15 | St. Lucia Tourism Authority | ||||||
651 | 651 | Stark Communications (on behalf of Kerala Tourism) | 2023-05-30 | INDIA | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | ||||||
652 | 652 | State of Israel, Embassy | 1988-01-20 | ISRAEL | Arnold & Porter Kaye Scholer LLP 1750 | 1964-06-04 | Arnold & Porter Kaye Scholer LLP | ||||||
672 | 672 | Taiwan External Trade Development Council (TAITRA) | 1985-02-28 | TAIWAN | Taiwan Trade Center New York Inc. 3652 | 1985-02-28 | Taiwan Trade Center New York Inc. | ||||||
679 | 679 | Tech Island Limited | 2023-07-13 | TAIWAN | Jeffrey Bader LLC 7295 | 2023-07-13 | Jeffrey Bader LLC | ||||||
682 | 682 | The Ad Hoc Board of Petroleos de Venezuela, S.A. (PDVSA Ad Hoc Board) | 2021-08-20 | VENEZUELA | CITGO Petroleum Corporation (CPC) 6996 | 2021-08-20 | CITGO Petroleum Corporation (CPC) | ||||||
683 | 683 | The Ad Hoc Board of Petroleos de Venezuela, S.A. (or, PDVSA Ad Hoc Board")" | 2022-06-01 | VENEZUELA | White & Case LLP 6393 | 2016-11-21 | White & Case LLP | ||||||
691 | 691 | The Government of Ukraine, The Ministry of Culture and Information Policy through GroupM Sp z.o.o. | 2022-08-19 | UKRAINE | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | ||||||
694 | 694 | The Government of the Democratic Republic of the Congo, Ministry of Communications and Media | 2022-03-25 | CONGO, DEMOCRATIC REPUBLIC OF THE | Scribe Strategies & Advisors, Inc. 6305 | 2015-07-20 | Scribe Strategies & Advisors, Inc. | ||||||
695 | 695 | The Government of the Republic of the Philippines | 2020-04-30 | PHILIPPINES | BCW LLC 6227 | 2014-06-18 | BCW LLC | ||||||
703 | 703 | The Ministry of Trade, Industry and Energy of the Republic of Korea | 2022-02-04 | KOREA, SOUTH | Holland & Knight 3718 | 1985-08-07 | Holland & Knight | ||||||
716 | 716 | Tourism and Events Queensland | 2022-06-15 | AUSTRALIA | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | ||||||
723 | 723 | Tundu Lissu | 2019-02-25 | TANZANIA | Vanguard Africa 6411 | 2017-03-26 | Vanguard Africa | ||||||
729 | 729 | Turkish Republic of Northern Cyprus, H.E. Mr. Ersin Tatar | 1975-10-16 | CYPRUS | Representative of the Turkish Republic of Northern Cyprus 2619 | 1975-10-16 | Representative of the Turkish Republic of Northern Cyprus | ||||||
733 | 733 | UAE Government Media Office | 2022-12-30 | UNITED ARAB EMIRATES | Fleishman-Hillard, Inc. 5801 | 2007-04-16 | Fleishman-Hillard, Inc. | ||||||
741 | 741 | United Arab Emirates Space Agency | 2022-10-21 | UNITED ARAB EMIRATES | Fleishman-Hillard, Inc. 5801 | 2007-04-16 | Fleishman-Hillard, Inc. | ||||||
750 | 750 | Visit Buenos Aires | 2022-12-13 | ARGENTINA | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | ||||||
753 | 753 | Visit Wales | 2018-05-03 | GREAT BRITAIN | VisitBritain 579 | 1949-07-07 | VisitBritain | ||||||
754 | 754 | VisitDenmark | 1950-07-25 | DENMARK | VisitDenmark 634 | 1950-07-25 | VisitDenmark | ||||||
756 | 756 | WWF-UK (World Wide Fund for Nature) | 2023-07-04 | UNITED KINGDOM | Searby PLLC 7215 | 2023-01-09 | Searby PLLC | ||||||
762 | 762 | Council for the Administration and Protection of the Assets (CAPA")" | 2021-08-20 | VENEZUELA | CITGO Holding, Inc. (CITGOH) 6995 | 2021-08-20 | CITGO Holding, Inc. (CITGOH) | ||||||
763 | 763 | Council for the Administration and Protection of the Assets (CAPA")" | 2021-08-20 | VENEZUELA | PDV Holding, Inc. (PDVH) 6997 | 2021-08-20 | PDV Holding, Inc. (PDVH) | ||||||
764 | 764 | Council for the Administration and Protection of the Assets (CAPA")" | 2021-11-22 | VENEZUELA | Willkie Farr & Gallagher LLP 7047 | 2021-11-22 | Willkie Farr & Gallagher LLP | ||||||
772 | 772 | 1945-01-01 | Mr. Otto Strasser | 1944-08-18 | CANADA | Stasser, Rev. Paul, O.S.B. 276 | 1944-08-18 | Stasser, Rev. Paul, O.S.B. | |||||
773 | 773 | 1947-01-01 | Udo Rukser & Albert Theile (Deutsche Blaetter) | 1946-01-23 | CHILE | Paetel, Karl O. 337 | 1946-01-23 | Paetel, Karl O. | |||||
783 | 783 | 1959-01-01 | Fidel Castro Ruz | 1957-02-06 | CUBA | Club Patriotico 26 de Julio de Miami 998 | 1957-02-06 | Club Patriotico 26 de Julio de Miami | |||||
784 | 784 | 1959-01-01 | Underground Groups | 1957-02-06 | CUBA | Club Patriotico 26 de Julio de Miami 998 | 1957-02-06 | Club Patriotico 26 de Julio de Miami | |||||
787 | 787 | 1962-01-01 | Eduardo Martelino (Press Counsel) | 1961-10-13 | PHILIPPINES | Co-Ordinated Marketing Agency, Inc. 1487 | 1961-10-13 | Co-Ordinated Marketing Agency, Inc. | |||||
791 | 791 | 1964-01-01 | Bodegas Pedro Domecq, S.A. | 1964-09-01 | PALESTINE | Leiser, Henri 1786 | 1964-09-01 | Leiser, Henri | |||||
792 | 792 | 1964-01-01 | Centro de Cultura por Correspondencia (CCC) | 1964-09-01 | SPAIN | Leiser, Henri 1786 | 1964-09-01 | Leiser, Henri | |||||
793 | 793 | 1964-01-01 | Frente Civico Mexicano de Afirmacion Revolucionaria | 1963-03-26 | MEXICO | Frente Civico Mexicano de Afirmacion Revolucionaria 1612 | 1963-03-26 | Frente Civico Mexicano de Afirmacion Revolucionaria | |||||
794 | 794 | 1964-01-01 | Hotel Los Monteros | 1964-09-01 | SPAIN | Leiser, Henri 1786 | 1964-09-01 | Leiser, Henri | |||||
795 | 795 | 1964-01-01 | Iberia Airlines | 1964-09-01 | SPAIN | Leiser, Henri 1786 | 1964-09-01 | Leiser, Henri | |||||
796 | 796 | 1964-01-01 | Ministerio de Informacion y Turismo (Spanish Government) | 1964-09-01 | SPAIN | Leiser, Henri 1786 | 1964-09-01 | Leiser, Henri | |||||
797 | 797 | 1964-01-01 | Muebles Darro (Furniture Company) | 1964-09-01 | SPAIN | Leiser, Henri 1786 | 1964-09-01 | Leiser, Henri | |||||
798 | 798 | 1964-01-01 | Novinsko-izdavacko Preduzece Borba" (Papers Publishing Company "Borba")" | 1961-07-03 | YUGOSLAVIA | Milic, Zivko 1464 | 1961-07-03 | Milic, Zivko | |||||
813 | 813 | 1972-01-01 | Ministry of Commerce & Industry | 1970-12-09 | PANAMA | Warren Weil Public Relations 1530 | 1962-03-23 | Warren Weil Public Relations | |||||
814 | 814 | 1972-01-01 | Panama Government Investment Development Center | 1971-11-10 | PANAMA | Warren Weil Public Relations 1530 | 1962-03-23 | Warren Weil Public Relations |
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]) );