FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
16,939 rows
This data as json, CSV (advanced)
Registrant_Name >30
- Hill and Knowlton Strategies, LLC 91
- Modern Education Services, Inc. 44
- Arnold & Porter Kaye Scholer LLP 43
- Squire Patton Boggs, LLP 42
- North American Precis Syndicate 41
- Ruder Finn, Inc. 32
- Pan-American Coffee Bureau 30
- NHK Cosmomedia America, Inc. 29
- Akin, Gump, Strauss, Hauer & Feld, LLP 27
- IPG DXTRA, Inc 27
- Burson-Marsteller 26
- Cassidy & Associates, Inc. 21
- U.S.-Cuban Sugar Council 21
- Daniel J. Edelman, Inc. 20
- Tromson Monroe Advertising, Inc. 17
- Association of Japanese Textile Imports, Inc. 15
- International Council of Cruise Lines 14
- Podesta Group, Inc. 14
- Swedish Information Service 14
- Finley Kumble Wagner Heine Underberg Manley Myerson & Casey 13
- Robinsons, Inc. 13
- Siegel, Leah 13
- Solov, Liuba 13
- O'Connor & Hannan, L.L.P. 12
- American/Chinese Export Corporation 11
- Association Films, Inc. 11
- BGR Government Affairs, LLC 11
- Caribbean Tourism Organization, USA Inc. 11
- DLA Piper US LLP 11
- Larson & Taylor 11
- …
Foreign_Principal_Termination_Date (date) >30 ✖
- 1995-12-31 102
- 1988-12-31 55
- 1989-12-31 52
- 1990-12-31 47
- 1986-12-31 46
- 1993-12-10 45
- 1976-12-31 40
- 1991-12-31 40
- 1987-12-31 39
- 1996-12-31 35
- 1990-11-30 32
- 2005-12-31 32
- 1973-12-31 27
- 1999-12-31 27
- 2020-12-31 26
- 1980-12-31 25
- 2012-12-31 25
- 2017-12-31 25
- 2019-12-31 24
- 1994-12-31 23
- 2018-12-31 23
- 2021-12-31 23
- 1957-12-31 22
- 2008-12-31 22
- 2009-12-31 22
- 1981-12-31 21
- 1984-12-31 21
- 1985-12-31 21
- 1998-12-31 21
- 2001-12-31 21
- …
Foreign_Principal >30
- Embassy of Japan 19
- Embassy of the Republic of Korea 18
- Government of Haiti 10
- Government of the Dominican Republic 9
- Hong Kong Trade Development Council 7
- Korea National Tourism Corporation 7
- Republic of Panama 6
- Government of El Salvador 5
- Government of India 5
- Hashemite Kingdom of Jordan 5
- Japan External Trade Organization 5
- Kingdom of Saudi Arabia 5
- National Security Council of Georgia 5
- Republic of Gabon 5
- Republic of Haiti 5
- Aeromexico 4
- Algoma Steel Corporation, Ltd. 4
- Arab Republic of Egypt 4
- Association of Cambodian Intellectuals 4
- Belgian National Tourist Office 4
- Embassy of the State of Qatar 4
- European Travel Commission 4
- Federal Republic of Nigeria 4
- French Government Tourist Office 4
- Government of Chile 4
- Government of Costa Rica 4
- Jamaica Tourist Board 4
- Kingdom of Morocco, Embassy 4
- Novosti Press Agency 4
- Republic of Indonesia 4
- …
Country/Location_Represented >30
- JAPAN 213
- CANADA 165
- MEXICO 142
- FRANCE 128
- KOREA, SOUTH 115
- GREAT BRITAIN 110
- INTERNATIONAL 81
- CHINA 62
- ISRAEL 60
- GERMANY 51
- SWITZERLAND 51
- CUBA 47
- DOMINICAN REPUBLIC 47
- TURKEY 47
- SAUDI ARABIA 45
- TAIWAN 45
- BRAZIL 44
- GERMANY, FEDERAL REPUBLIC OF 43
- ITALY 42
- USSR 42
- SPAIN 40
- SWEDEN 38
- COLOMBIA 37
- NETHERLANDS 36
- AUSTRALIA 35
- POLAND 35
- UNITED ARAB EMIRATES 35
- UKRAINE 33
- ARGENTINA 32
- ROMANIA 32
- …
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13498 | 13498 | 2019-10-31 | Kobe Steel, Ltd. | 2017-11-28 | JAPAN | BCW LLC 6227 | 2014-06-18 | BCW LLC | 9-12, Kita - Shinagawa 5-chome | Shinagawa-ku Tokyo 141-8688 | |||
13499 | 13499 | 2019-10-31 | Minderoo Foundation Pty Ltd. | 2019-09-23 | AUSTRALIA | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 80 Birdwood Parade | Dalkeith WA 6009 Australia | |||
13500 | 13500 | 2019-10-31 | Nabil Karoui | 2019-09-26 | TUNISIA | Dickens & Madson Canada Inc. 6200 | 2013-12-11 | Dickens & Madson Canada Inc. | |||||
13501 | 13501 | 2019-10-31 | Office of the Prime Minister of Japan | 2017-09-19 | JAPAN | Fleishman-Hillard, Inc. 5801 | 2007-04-16 | Fleishman-Hillard, Inc. | 2-3-1, Nagata-cho Chiyoda-ku, Tokyo | ||||
13502 | 13502 | 2019-10-31 | Olfa Terras-Rambourg | 2019-09-03 | TUNISIA | America to Africa Consulting, LLC (A2A) 6715 | 2019-09-03 | America to Africa Consulting, LLC (A2A) | 74 rue d'Assas | 75006 Paris FRANCE | |||
13503 | 13503 | 2019-10-31 | Republic of Fiji | 2018-11-02 | FIJI | QORVIS LLC 5483 | 2002-03-06 | QORVIS LLC | 9th Floor Suvavou House, Victoria Parade | PO Box 2212, Government Buildings Suva | |||
13504 | 13504 | 2019-10-31 | Urenco, Ltd. | 1996-11-08 | GREAT BRITAIN | Urenco, Inc. 5137 | 1996-11-08 | Urenco, Inc. | Buckinghamshire | ||||
13505 | 13505 | 2019-10-31 | Virgo Star, Inc. on behalf of CRRC North America, Inc. | 2019-07-18 | CHINA | Crossroads Strategies LLC 6702 | 2019-07-18 | Crossroads Strategies LLC | One Rockeller Plaza | Suite 2802 | New York | NY | 10020 |
13506 | 13506 | 2020-10-31 | Abu Dhabi Investment Authority (ADIA) | 2018-07-09 | UNITED ARAB EMIRATES | FTI Consulting LLP 6569 | 2018-07-09 | FTI Consulting LLP | 211 Corniche, PO Box 3600 | Abu Dhabi | |||
13507 | 13507 | 2020-10-31 | PromPeru | 2013-07-03 | PERU | Development Counsellors International 4777 | 1993-03-12 | Development Counsellors International | Ave. Republica de Panama No 3655 | San Isidro, Lima 27 | |||
13508 | 13508 | 2021-10-31 | Egyptian Ministry of International Cooperation | 2021-09-02 | EGYPT | APCO Worldwide LLC 6582 | 2018-08-22 | APCO Worldwide LLC | 8 Adly Street | Abdeen | Cairo | ||
13509 | 13509 | 2021-10-31 | Iftikhar Ur Rehman Durrani | 2021-07-17 | PAKISTAN | Grenier Consulting LLC 6979 | 2021-07-17 | Grenier Consulting LLC | House No. 2-A, Street No. 14A, Sector F-7/2 | Islamabad, Islamabad Capital Territory | |||
13510 | 13510 | 2021-10-31 | Letterone Investment Holdings S.A. | 2020-09-03 | LUXEMBOURG | Teneo Strategy LLC 6698 | 2019-07-08 | Teneo Strategy LLC | 1-3 Boulevard de la Foire | L-1528 Luxembourg | |||
13511 | 13511 | 2021-10-31 | Province of Alberta, Canada | 2020-11-13 | CANADA | Crossroads Strategies LLC 6891 | 2020-11-13 | Crossroads Strategies LLC | 501 Pennsylvania Avenue, NW | Washington | DC | 20001 | |
13512 | 13512 | 2022-10-31 | Korea Atomic Energy Research Institute | 2011-10-07 | KOREA, SOUTH | Lowe-Lee, Florence 6067 | 2011-10-07 | Lowe-Lee, Florence | 305-600, Daedoekdae-ro 1045, | Yuseong, Daejeon | |||
13513 | 13513 | 1944-11-01 | King Carol of Romania | 1944-05-02 | ROMANIA | Rose III, Clarence S. 250 | 1944-05-02 | Rose III, Clarence S. | |||||
13514 | 13514 | 1944-11-01 | Madame Lupesca of Romania | 1944-05-02 | ROMANIA | Rose III, Clarence S. 250 | 1944-05-02 | Rose III, Clarence S. | |||||
13515 | 13515 | 1945-11-01 | Delegation Abroad of the Austrian Trade Unions (Auslandsvertretung der Freien Gewerkschaften Ocsterreichs) | 1944-12-18 | AUSTRIA | Austrian Labor Committee 129 | 1942-09-29 | Austrian Labor Committee | London, England | ||||
13516 | 13516 | 1950-11-01 | Pravda | 1950-05-01 | USSR | Rassadin, Grigorii 623 | 1950-05-01 | Rassadin, Grigorii | Moscow | ||||
13517 | 13517 | 1950-11-01 | Republic of Indonesia | 1949-01-04 | INDONESIA | Robert R. Nathan Associates, Inc. 352 | 1946-04-22 | Robert R. Nathan Associates, Inc. | |||||
13518 | 13518 | 1950-11-01 | Republic of the United States of Indonesia | 1950-04-03 | INDONESIA | Robert R. Nathan Associates, Inc. 352 | 1946-04-22 | Robert R. Nathan Associates, Inc. | |||||
13519 | 13519 | 1951-11-01 | Jose Valadez Navarro | 1946-09-17 | MEXICO | Union Nacional Sinarquista 123 | 1942-09-14 | Union Nacional Sinarquista | |||||
13520 | 13520 | 1951-11-01 | Luis Martinez Narezo | 1949-05-02 | MEXICO | Union Nacional Sinarquista 123 | 1942-09-14 | Union Nacional Sinarquista | |||||
13521 | 13521 | 1953-11-01 | Government of the Republic of Cuba | 1952-09-02 | CUBA | Chester, Edmund Albert 740 | 1952-09-02 | Chester, Edmund Albert | Havana | ||||
13522 | 13522 | 1954-11-01 | Embassy of Japan | 1954-04-23 | JAPAN | Shohan, Charles Judah 824 | 1954-04-23 | Shohan, Charles Judah | Washington | DC | |||
13523 | 13523 | 1954-11-01 | Pravda | 1950-05-01 | USSR | Filippov, Ivan 624 | 1950-05-01 | Filippov, Ivan | Moscow | ||||
13524 | 13524 | 1955-11-01 | Government of the Republic of Guatemala | 1956-03-21 | GUATEMALA | George Peabody & Associates, Inc. 768 | 1953-05-26 | George Peabody & Associates, Inc. | Guatemala City | ||||
13525 | 13525 | 1957-11-01 | Partido Dominicano | 1957-05-03 | DOMINICAN REPUBLIC | Paulino, Manuel 1020 | 1957-05-03 | Paulino, Manuel | Diudad Trujillo | ||||
13526 | 13526 | 1959-11-01 | Government of Turkey | 1955-09-08 | TURKEY | Mintzer, George J. 908 | 1955-09-08 | Mintzer, George J. | Ankara | ||||
13527 | 13527 | 1959-11-01 | Imperial Ethiopian Government | 1958-12-17 | ETHIOPIA | Scott, Robert Day 1191 | 1958-12-17 | Scott, Robert Day | Addis Ababa | ||||
13528 | 13528 | 1960-11-01 | Dominican Republic | 1947-01-09 | DOMINICAN REPUBLIC | Cummings, Sellers, Reeves & Conner 420 | 1947-01-09 | Cummings, Sellers, Reeves & Conner | Washington | DC | |||
13529 | 13529 | 1960-11-01 | Government of Spain | 1949-02-08 | SPAIN | Cummings, Sellers, Reeves & Conner 420 | 1947-01-09 | Cummings, Sellers, Reeves & Conner | Washington | DC | |||
13530 | 13530 | 1960-11-01 | Minister of Foreign Relations of the Republic of Nicaragua | 1959-08-21 | NICARAGUA | Max Rogel, Inc. 1255 | 1959-08-21 | Max Rogel, Inc. | Managua | ||||
13531 | 13531 | 1960-11-01 | Province of Newfoundland | 1951-01-10 | NETHERLANDS | Cummings, Sellers, Reeves & Conner 420 | 1947-01-09 | Cummings, Sellers, Reeves & Conner | St. John's | ||||
13532 | 13532 | 1961-11-01 | Dominican Military Aviacion (AMD) | 1958-01-10 | DOMINICAN REPUBLIC | Garcia Jr., Enrique A. 1103 | 1958-01-10 | Garcia Jr., Enrique A. | |||||
13533 | 13533 | 1961-11-01 | Dominion Republic (Crown Life Insurance Company & Dominion Military Air Force) | 1958-01-10 | DOMINICAN REPUBLIC | Garcia Jr., Enrique A. 1103 | 1958-01-10 | Garcia Jr., Enrique A. | Cuidad, Trujillo | ||||
13534 | 13534 | 1961-11-01 | Dr. Rafael L. Trujillo, Jr. | 1962-02-19 | DOMINICAN REPUBLIC | Garcia Jr., Enrique A. 1103 | 1958-01-10 | Garcia Jr., Enrique A. | |||||
13535 | 13535 | 1961-11-01 | Government of the Republic of Vietnam | 1961-05-15 | VIETNAM | Kunen, James L. 1450 | 1961-05-15 | Kunen, James L. | Washington | DC | |||
13536 | 13536 | 1961-11-01 | Lt. Gen. Jose Arizmendi Trujillo Molina | 1958-09-09 | DOMINICAN REPUBLIC | Garcia Jr., Enrique A. 1103 | 1958-01-10 | Garcia Jr., Enrique A. | Cuidad, Trujillo | ||||
13537 | 13537 | 1964-11-01 | Republic of the Sudan | 1964-06-15 | SUDAN | Edward K. Moss International 1483 | 1961-10-04 | Edward K. Moss International | Washington | DC | |||
13538 | 13538 | 1964-11-01 | Universal Transport Corporation Establishment | 1962-08-20 | SWITZERLAND | Keesing, John Maurice 1091 | 1957-11-27 | Keesing, John Maurice | Leichtenstein | ||||
13539 | 13539 | 1965-11-01 | Morenco Film Corporation Party, Ltd. | 1964-10-06 | AUSTRALIA | Bretz, Rudy 1799 | 1964-10-06 | Bretz, Rudy | Victoria | ||||
13540 | 13540 | 1969-11-01 | French Government Tourist Office | 1959-12-21 | FRANCE | DDB Worldwide Communications Group, Inc. 1066 | 1957-09-16 | DDB Worldwide Communications Group, Inc. | Paris | ||||
13541 | 13541 | 1970-11-01 | Tokyo Shibaura Electric Company, Ltd. | 1968-01-06 | JAPAN | Steele, Donald Dickinson 2030 | 1967-06-20 | Steele, Donald Dickinson | Tokyo | ||||
13542 | 13542 | 1971-11-01 | Korean Embassy, Information Office | 1970-11-30 | KOREA, SOUTH | Modern Education Services, Inc. 1803 | 1964-10-19 | Modern Education Services, Inc. | |||||
13543 | 13543 | 1971-11-01 | Provisional Government of Israel | 1948-10-12 | ISRAEL | Israel Information Services 543 | 1948-10-12 | Israel Information Services | Hakiryah | ||||
13544 | 13544 | 1973-11-01 | Yugosalv Airlines (JAT) | 1972-02-22 | YUGOSLAVIA | Cannon Advertising Associates, Inc. 1945 | 1965-12-14 | Cannon Advertising Associates, Inc. | New York | NY | |||
13545 | 13545 | 1977-11-01 | Manuel Carvajal Industrial & Commercial Free Zone | 1977-11-18 | COLOMBIA | Warren Weil Public Relations 1530 | 1962-03-23 | Warren Weil Public Relations | |||||
13546 | 13546 | 1979-11-01 | Mitsubishi Bank, Ltd. | 1979-11-21 | JAPAN | Edelman International Corporation 2548 | 1974-11-29 | Edelman International Corporation | Chicago | IL | |||
13547 | 13547 | 1981-11-01 | Conzinc Riotinto of Australia, Ltd. | 1981-09-10 | AUSTRALIA | Fraser Associates, Inc. 2844 | 1977-11-08 | Fraser Associates, Inc. | Melbourne, Victoria | ||||
13548 | 13548 | 1981-11-01 | Toyota Motor Sales U.S.A., Inc. | 1981-09-10 | JAPAN | Fraser Associates, Inc. 2844 | 1977-11-08 | Fraser Associates, Inc. | Washington | DC | |||
13549 | 13549 | 1981-11-01 | Toyota Motor Sales, Ltd. | 1976-10-08 | JAPAN | Armstrong, Rodney E. 2724 | 1976-10-08 | Armstrong, Rodney E. | Toyko | ||||
13550 | 13550 | 1982-11-01 | Airbus Industrie (U.S. Rep: DGA International, Washington, D.C.) | 1977-07-13 | FRANCE | Edelman International Corporation 2548 | 1974-11-29 | Edelman International Corporation | Toulouse | ||||
13551 | 13551 | 1982-11-01 | American Chamber of Commerce of the Dominican Republic | 1982-12-10 | DOMINICAN REPUBLIC | Blatchford, Epstein & Brady 3160 | 1980-10-31 | Blatchford, Epstein & Brady | Santo Domingo | ||||
13552 | 13552 | 1982-11-01 | Electronic Industries Association of Japan | 1981-10-13 | JAPAN | Edelman International Corporation 2548 | 1974-11-29 | Edelman International Corporation | Tokyo | ||||
13553 | 13553 | 1982-11-01 | Gulf Air | 1977-11-22 | INTERNATIONAL | Barkett, Mitchell 2436 | 1973-06-18 | Barkett, Mitchell | New York | NY | |||
13554 | 13554 | 1982-11-01 | Howaldswerke - Deutsche Werft, A.G. | 1979-04-30 | GERMANY, FEDERAL REPUBLIC OF | DSP, Inc. 3014 | 1979-04-30 | DSP, Inc. | |||||
13555 | 13555 | 1982-11-01 | PLM Company | 1971-03-18 | FRANCE | Clement-Petrocik Company 2249 | 1971-03-18 | Clement-Petrocik Company | Paris | ||||
13556 | 13556 | 1982-11-01 | Salvadorean Coalition for Freedom & Independence, Inc. | 1982-10-14 | EL SALVADOR | Fraser Associates, Inc. 2844 | 1977-11-08 | Fraser Associates, Inc. | Coral Gables | FL | |||
13557 | 13557 | 1982-11-01 | Sofreavia (U.S. Rep: DGA International, Washington, D.C.) | 1979-10-18 | FRANCE | Edelman International Corporation 2548 | 1974-11-29 | Edelman International Corporation | Paris | ||||
13558 | 13558 | 1983-11-01 | Direccion General de Comunicacion Secretaria de Hacienda y Credito Publico | 1981-04-20 | MEXICO | Peggy Dyer & Associates 3230 | 1981-04-20 | Peggy Dyer & Associates | |||||
13559 | 13559 | 1983-11-01 | Embassy of Japan | 1983-05-19 | JAPAN | Wilbur F. Monroe Associates, Inc. 2888 | 1978-04-20 | Wilbur F. Monroe Associates, Inc. | |||||
13560 | 13560 | 1984-11-01 | Government of Peru | 1984-07-27 | PERU | Cole Corette & Abrutyn, P.C. 2968 | 1978-10-18 | Cole Corette & Abrutyn, P.C. | Lima | ||||
13561 | 13561 | 1984-11-01 | Palestine Liberation Organization | 1965-01-22 | JORDAN | Palestine Liberation Organization, New York 1845 | 1965-01-22 | Palestine Liberation Organization, New York | Jerusalem | ||||
13562 | 13562 | 1984-11-01 | Palestine Liberation Organization | 1967-04-17 | EGYPT | Palestine Liberation Organization, New York 1845 | 1965-01-22 | Palestine Liberation Organization, New York | Cairo | ||||
13563 | 13563 | 1985-11-01 | De Acero, S.A. de C.V. | 1985-06-04 | MEXICO | Manchester Associates, Ltd. 3046 | 1979-08-09 | Manchester Associates, Ltd. | Monterray | ||||
13564 | 13564 | 1985-11-01 | Government of the Principality of Liechtenstein | 1985-10-30 | LIECHTENSTEIN | Fontayne Group, Inc. 3752 | 1985-10-30 | Fontayne Group, Inc. | |||||
13565 | 13565 | 1985-11-01 | Greek National Tourist Organization, New York Office | 1984-01-01 | GREECE | AC&R Advertising, Inc. 3211 | 1981-03-11 | AC&R Advertising, Inc. | |||||
13566 | 13566 | 1986-11-01 | Coordination Council for North America Affairs | 1983-11-28 | TAIWAN | Anderson & Pendleton, C.A. 2696 | 1976-06-09 | Anderson & Pendleton, C.A. | Washington | DC | |||
13567 | 13567 | 1986-11-01 | Corporacion Nacional del Cobre de Chile | 1984-02-25 | CHILE | Anderson & Pendleton, C.A. 2696 | 1976-06-09 | Anderson & Pendleton, C.A. | Santiago | ||||
13568 | 13568 | 1986-11-01 | Corporacion del Cobre, U.S.A., Inc. (CODELCO) | 1981-01-22 | CHILE | Anderson & Pendleton, C.A. 2696 | 1976-06-09 | Anderson & Pendleton, C.A. | New York | NY | |||
13569 | 13569 | 1986-11-01 | InterRedec | 1986-11-24 | NETHERLANDS ANTILLES | King & Spalding 3812 | 1986-04-10 | King & Spalding | GA | ||||
13570 | 13570 | 1986-11-01 | Scottish Development Agency | 1982-06-16 | SCOTLAND | Promotional Concept Group, Inc. 3383 | 1982-06-16 | Promotional Concept Group, Inc. | |||||
13571 | 13571 | 1987-11-01 | Japan Tobacco, Inc. | 1986-12-01 | JAPAN | IPG DXTRA, Inc 3911 | 1986-12-01 | IPG DXTRA, Inc | Tokyo | ||||
13572 | 13572 | 1987-11-01 | Marc Rich & Company | 1985-09-05 | SWITZERLAND | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | Zug | ||||
13573 | 13573 | 1987-11-01 | Spar Aerospace, Ltd. | 1981-08-12 | CANADA | Botsford, Charles G. 3268 | 1981-08-12 | Botsford, Charles G. | Ontario | ||||
13574 | 13574 | 1988-11-01 | Ueki America Corporation | 1988-11-01 | JAPAN | Francis & Nichols, Inc., P.S. 4186 | 1988-11-01 | Francis & Nichols, Inc., P.S. | Seattle | WA | |||
13575 | 13575 | 1990-11-01 | Diehl GmbH & Company | 1985-11-01 | GERMANY | Perkins Coie 3753 | 1985-11-01 | Perkins Coie | Pegnitz | ||||
13576 | 13576 | 1990-11-01 | Government of Nicaragua | 1990-10-03 | NICARAGUA | Dorf & Stanton Communications, Inc. 4416 | 1990-10-03 | Dorf & Stanton Communications, Inc. | Managua | ||||
13577 | 13577 | 1990-11-01 | ISPAT | 1990-08-16 | TRINIDAD AND TOBAGO | Manchester Trade, Inc. 4149 | 1988-06-22 | Manchester Trade, Inc. | Couve | ||||
13578 | 13578 | 1990-11-01 | Planeta North America, Inc. | 1990-10-01 | GERMAN DEMOCRATIC REPUBLIC | Jack H. McDonald Company 3956 | 1987-04-01 | Jack H. McDonald Company | Great Neck | NY | |||
13579 | 13579 | 1990-11-01 | RAM System GmbH | 1985-11-01 | GERMANY | Perkins Coie 3753 | 1985-11-01 | Perkins Coie | Ottobrunn | ||||
13580 | 13580 | 1990-11-01 | Republic of Ciskei | 1986-09-29 | CISKEI | Ciskei Trade Mission, Ltd. 3891 | 1986-09-29 | Ciskei Trade Mission, Ltd. | |||||
13581 | 13581 | 1991-11-01 | People's Republic of Angola | 1986-07-10 | ANGOLA | Baenen, Richard Anthony 3853 | 1986-07-10 | Baenen, Richard Anthony | Luanda | ||||
13582 | 13582 | 1991-11-01 | A.J. Lazarus for Eurailpass | 1991-07-11 | INTERNATIONAL | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | New York | NY | |||
13583 | 13583 | 1991-11-01 | Ambassador Paul Lusaka, Embassy of Zambia | 1991-11-05 | ZAMBIA | Kamber Group 4583 | 1991-11-05 | Kamber Group | Washington | DC | |||
13584 | 13584 | 1991-11-01 | Antigua & Barbuda Department of Tourism | 1978-09-11 | ANTIGUA & BARBUDA | Henry Davis Corporation 2952 | 1978-09-11 | Henry Davis Corporation | New York | NY | |||
13585 | 13585 | 1991-11-01 | Austrian Press & Information Service | 1991-03-29 | AUSTRIA | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | New York | NY | |||
13586 | 13586 | 1991-11-01 | Embassy of Australia | 1991-03-29 | AUSTRALIA | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | Washington | DC | |||
13587 | 13587 | 1991-11-01 | Embassy of Japan | 1990-12-21 | JAPAN | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | Washington | DC | |||
13588 | 13588 | 1991-11-01 | Eurailpass | 1990-12-21 | INTERNATIONAL | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | New York | NY | |||
13589 | 13589 | 1991-11-01 | French Government Tourist Office | 1991-03-29 | FRANCE | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | New York | NY | |||
13590 | 13590 | 1991-11-01 | Government of Israel Trade Center | 1991-03-29 | ISRAEL | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | New York | NY | |||
13591 | 13591 | 1991-11-01 | Government of Israel, Ministry of Justice | 1990-10-12 | ISRAEL | Morgan, Lewis & Bockius, L.L.P. 3794 | 1986-03-12 | Morgan, Lewis & Bockius, L.L.P. | Jerusalem | ||||
13592 | 13592 | 1991-11-01 | Hong Kong Tourist Organization | 1991-07-11 | HONG KONG | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | New York | NY | |||
13593 | 13593 | 1991-11-01 | Israel National Airline | 1991-10-10 | ISRAEL | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | New York | NY | |||
13594 | 13594 | 1991-11-01 | Italian Government Tourist Office | 1991-10-10 | ITALY | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | New York | NY | |||
13595 | 13595 | 1991-11-01 | Korea National Tourism Corporation | 1991-03-29 | KOREA, SOUTH | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | Los Angeles | CA | |||
13596 | 13596 | 1991-11-01 | Korea National Tourism Corporation | 1991-07-11 | KOREA, SOUTH | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | Los Angeles | CA | |||
13597 | 13597 | 1991-11-01 | Portugese National Tourist Office | 1991-10-10 | PORTUGAL | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | New York | NY |
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]) );