Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)
State
Registrant_Name
Foreign_Principal
Country/Location_Represented
City
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1 | Embassy of the People's Republic of China in the United States | 2017-06-29 | CHINA | 5875 5875 | 2008-06-17 | BLJ Worldwide LTD | 3905 International Place, NW | Washington | DC | 20008 | ||
| 2 | 2 | Embassy of the People's Republic of China | 2005-07-21 | CHINA | 2165 2165 | 1969-10-09 | Squire Patton Boggs, LLP | 2300 Connecticut Avenue, NW | Washington | DC | 20008 | ||
| 3 | 3 | Ethiopian People's Revolutionary Party | 1993-04-07 | ETHIOPIA | 4789 4789 | 1993-04-07 | Ethiopian People's Revolutionary Party | Paris | |||||
| 4 | 4 | European People's Party | 2019-01-28 | BELGIUM | 6630 6630 | 2019-01-28 | Shepura, Nathan | 10 Rue de Commerce | Brussels 1000 | ||||
| 5 | 5 | Government of the Republic of Cote d'Ivoire | 2010-12-28 | COTE D'IVOIRE (IVORY COAST) | 4990 4990 | 1995-02-06 | JWI, LLC | Abidjan | |||||
| 6 | 6 | Government of Haiti through L'Association des Industries d'Haiti (ADIH) | 2019-05-24 | HAITI | 5839 5839 | 2007-11-12 | Sorini, Samet & Associates, LLC | Ministere de I'Economie et des FInances d'Haiti | 5, Avenue Charles Sumner, Port-au-Prince | ||||
| 7 | 7 | Government of the People's Democratic Republic of Algeria, Embassy | 2007-05-25 | ALGERIA | 4776 4776 | 1993-03-02 | Foley Hoag, LLP | 2118 Kalorama Road, NW | Washington | DC | 20008 | ||
| 8 | 8 | Government of the People's Republic of Bangladesh, Embassy | 2013-09-23 | BANGLADESH | 5430 5430 | 2001-05-10 | BGR Government Affairs, LLC | 3510 International Drive, NW | Washington | DC | 20008 | ||
| 9 | 9 | Government of the Republic of Cote d'Ivoire (on behalf of JWI, LLC) | 2019-09-05 | COTE D'IVOIRE (IVORY COAST) | 5666 5666 | 2005-01-31 | Glover Park Group, LLC | Government of the Republic of Cote d'Ivoire | Abdijan | ||||
| 10 | 10 | Her Majesty's Treasury | 2020-06-27 | UNITED KINGDOM | 6653 6653 | 2019-03-22 | Steptoe & Johnson, LLP | 1 Horse Guard Road | London SW1A 2HQ | ||||
| 11 | 11 | Ministry of Foreign Affairs and Int'l Cooperation | 2020-05-11 | MOROCCO | 5666 5666 | 2005-01-31 | Glover Park Group, LLC | 7 rue F Roosevelt | Rabat | ||||
| 12 | 12 | People's Daily Overseas Edition | 1996-12-03 | CHINA | 5143 5143 | 1996-12-03 | Hai Tian Development U.S.A., Inc. | Beijing | |||||
| 13 | 13 | People's Democracy Party (HDP) | 2017-09-09 | TURKEY | 6460 6460 | 2017-09-09 | Ozcan, Giran | Barbaros Mh. Tahran Cd. Buklum Sk. No: 117 Kavaklidere/Cankaya | ANKARA | ||||
| 14 | 14 | People's Democratic Republic of Algeria | 2018-11-06 | ALGERIA | 6608 6608 | 2018-11-06 | Keene, David A. d/b/a Keene Consulting | Algiers | |||||
| 15 | 15 | People's Republic of China Embassy | 2015-01-19 | CHINA | 6274 6274 | 2015-01-19 | Rogich Communications Group | 3505 International Place, NW | Washington | DC | 20008 | ||
| 16 | 16 | Petroleos de Venezuela, S.A.'s Ad-Hoc Board of Directors | 2019-10-25 | VENEZUELA | 6743 6743 | 2019-10-25 | Paul Hastings LLP | 2409 California Street, N.W. | Washington | ||||
| 17 | 17 | Republican People's Party of Turkey (CHP) | 2013-05-06 | TURKEY | 6168 6168 | 2013-05-06 | CHP Representation to the United States, LLC | CUMHURIYET HALK PARTISI (CHP) GENEL MERKEZI | Anadolu Bulvari No: 12 Sogutozu/ANKARA | ||||
| 18 | 18 | Salman Sufi, Director General, Strategic Reforms Unit, Punjab Chief Minister's Office | 2020-07-30 | PAKISTAN | 6839 6839 | 2020-07-30 | Kivvit, LLC | Club Road, G.O.R.1, Lahore, Pakistan | |||||
| 19 | 19 | Sudan People's Liberation Movement - North | 2012-02-23 | SUDAN | 6091 6091 | 2012-02-23 | Sprague, Esther Marie | ||||||
| 20 | 20 | ANO TV-Novosti | 2017-11-10 | RUSSIA | 6485 6485 | 2017-11-10 | T&R Productions LLC | 111020 Borovaya St. 3 | Moscow | ||||
| 21 | 21 | ANTONOV Company ( a State Company) | 2018-09-17 | UKRAINE | 6592 6592 | 2018-09-14 | Batra, Ravi | Tupolev Street | Kiev | ||||
| 22 | 22 | APNU + AFC Coalition | 2020-03-31 | GUYANA | 6809 6809 | 2020-03-31 | JJ&B, LLC | 61 Hadfield Street, Werk en Rust | Georgetown | ||||
| 23 | 23 | Abdul Sattar | 2018-09-06 | BANGLADESH | 6587 6587 | 2018-09-06 | Blue Star Strategies, LLC | 83 Wise Road | London E15 2TG | ||||
| 24 | 24 | Abu Dhabi Investment Authority (ADIA) | 2018-07-09 | UNITED ARAB EMIRATES | 6569 6569 | 2018-07-09 | FTI Consulting LLP | 211 Corniche, PO Box 3600 | Abu Dhabi | ||||
| 25 | 25 | Abu Dhabi Investment Authority | 2011-01-07 | UNITED ARAB EMIRATES | 5666 5666 | 2005-01-31 | Glover Park Group, LLC | 211 Comiche Road, PO Box 3600 | Abu Dhabi | ||||
| 26 | 26 | Abu Dhabi Tourism and Culture Authority | 2012-09-14 | UNITED ARAB EMIRATES | 6134 6134 | 2012-09-14 | Department of Culture Tourism - Abu Dhabi (New York Branch) | P.O. Box 94000 | Abu Dhabi | ||||
| 27 | 27 | Ad Hoc Board of Petroleos de Venezuela, S.A. | 2019-10-03 | VENEZUELA | 6735 6735 | 2019-10-03 | Potomac Group LLC | 2409 California Street, NW | Washington | DC | 20008 | ||
| 28 | 28 | Advantage Austria at the Austrian Federal Economic Chamber (WKO) | 2013-11-04 | AUSTRIA | 6193 6193 | 2013-11-04 | Austrian Trade Commission, Chicago | Wiedner Hauptstrasse 63 | 1045 Vienna | ||||
| 29 | 29 | African Energy Chamber | 2019-08-15 | SOUTH AFRICA | 6399 6399 | 2016-12-11 | Sonoran Policy Group, LLC | ||||||
| 30 | 30 | Agency for Information and Mass Communication under the President of the Republic of Uzbekistan | 2019-11-20 | UZBEKISTAN | 6753 6753 | 2019-11-20 | Frontier Consulting, LLC | Alisher Navoi, 30 | Tashkent | ||||
| 31 | 31 | Agility Public Warehousing Company K.S.C.P. through Quinn Emanuel Urquhart & Sullivan, LLP | 2019-08-06 | KUWAIT | 6379 6379 | 2016-09-20 | S.G.R. LLC Government Relations and Lobbying | P.O. Box 25418 | Safet 13115 | ||||
| 32 | 32 | Agility Public Warehousing Company KSCP | 2019-08-02 | KUWAIT | 6705 6705 | 2019-08-02 | Quinn Emanuel Urquhart & Sullivan, LLP | P.O. Box 25418 | Safat, 13115 | ||||
| 33 | 33 | Aidenvironment (under grant from the Norwegian Agency for Development Cooperation) | 2019-08-23 | NORWAY | 6710 6710 | 2019-08-23 | Waxman Consulting, Inc. DBA Waxman Strategies | Barentszplein 7 1013 NJ Amsterdam Netherlands | |||||
| 34 | 34 | Akin Gump Strauss Hauer & Feld LLP on behalf of the Embassy of the United Arab Emirates | 2017-12-29 | UNITED ARAB EMIRATES | 6504 6504 | 2017-12-29 | Bullpen Strategy Group, Inc. | 3522 International Court, NW | Suite 400 | Washington | DC | 20008 | |
| 35 | 35 | Akin, Gump, Strauss, Hauer & Feld, on behalf of the Republic of the Marshall Islands | 2018-05-24 | MARSHALL ISLANDS | 6558 6558 | 2018-05-24 | Oliver Group, Inc. | 2433 Massachusetts Avenue, NW | Washington | DC | 20008 | ||
| 36 | 36 | Ali Hadad | 2020-07-27 | ALGERIA | 6399 6399 | 2016-12-11 | Sonoran Policy Group, LLC | Care of Sabrina Run | 63 Rue Pierre Charron 75008 Paris France | ||||
| 37 | 37 | All-Ukrainian Industry Association Federation of Employers of the Oil and Gas Industry"" | 2020-01-05 | UKRAINE | 6491 6491 | 2017-11-19 | Yorktown Solutions, LLC | ||||||
| 38 | 38 | Alternative National Congress of Liberia (ANC Liberia) | 2019-10-02 | LIBERIA | 6731 6731 | 2019-10-02 | ANC-Global, Inc. | Airfield Short Cut, Sinkor | Monrovia | ||||
| 39 | 39 | Arab Project Party Iraq | 2019-06-11 | IRAQ | 6688 6688 | 2019-06-11 | Morris Global Strategies LLC | Baghdad, Mansur District, 14 Ramadan Street | Mishmisheh Building, 1st Floor, AL Radwan Company | ||||
| 40 | 40 | Aruba Tourism Authority (ATA) | 2019-04-22 | ARUBA | 6652 6652 | 2019-03-18 | Zeno Group, Inc. | LG. Smith Blvd. 9 - P.O. Box 1019 | Oranjestad | ||||
| 41 | 41 | Association of Banks in Lebanon | 2020-05-19 | LEBANON | 6825 6825 | 2020-05-19 | Carlos Abadi | Gouraud Street | Beirut | ||||
| 42 | 42 | Association of Cyprus Banks | 2019-08-28 | CYPRUS | 5198 5198 | 1997-07-31 | Pillsbury Winthrop Shaw Pittman, LLP | 15, Demetriou Karatasou Str., | 4th Floor, Flat 401 Nicosia 2024 | ||||
| 43 | 43 | Association of Enterprises UKRMETALURGPROM | 2019-08-29 | UKRAINE | 6344 6344 | 2016-03-25 | Livingston Group, LLC | 49000 Dnipro, Dnipropetrovsk | |||||
| 44 | 44 | Association of German Chambers of Industry and Commerce (Deutscher Industrie - und Handelstag) | 1989-07-21 | GERMANY | 4274 4274 | 1989-07-21 | Representative of German Industry and Trade | Bonn | |||||
| 45 | 45 | Assyrian Democratic Movement | 2016-02-28 | IRAQ | 6339 6339 | 2016-02-28 | Nineveh Plain Defense Fund | District 712, Street 4 Hay Almuthana | Baghdad | ||||
| 46 | 46 | Atanas, Plame and Hristina Bobokov | 2020-07-10 | BULGARIA | 6707 6707 | 2019-08-15 | Alexandria Group International LLC | 20 Zlaten Rog Street | 5th Floor | ||||
| 47 | 47 | Atanas, Plamen, and Hristina Bobokov | 2020-07-10 | BULGARIA | 6707 6707 | 2019-08-15 | Alexandria Group International LLC | ||||||
| 48 | 48 | Atheel al-Nujaifi | 2014-09-29 | IRAQ | 6255 6255 | 2014-09-29 | Chartwell Consultancy, LLC | ||||||
| 49 | 49 | Atiku Abubakar and the Peoples Democratic Party of Nigeria (PDP) | 2019-04-02 | NIGERIA | 6654 6654 | 2019-04-02 | Fein & DelValle, PLLC | Abuja | |||||
| 50 | 50 | Atiku Abubakar, PDP Candidate for President of Nigeria | 2019-02-12 | NIGERIA | 6637 6637 | 2019-02-12 | Barnett, John | Asokoro, Abuja, FCT | |||||
| 51 | 51 | Atout France-France Tourism Development Agency | 2019-03-08 | FRANCE | 6621 6621 | 2018-12-21 | Media Planning International Corporation | 79/81 rue de Clichy 75009 Paris | |||||
| 52 | 52 | Australian National Travel Association | 1957-06-03 | AUSTRALIA | 1032 1032 | 1957-06-03 | Tourism Australia | Melbourne | |||||
| 53 | 53 | Austrian National Tourist Office | 1947-10-03 | AUSTRIA | 495 495 | 1947-10-03 | Austrian Tourist Office, Inc. | New York | NY | ||||
| 54 | 54 | Azerbaijan Railways CJSC | 2019-10-09 | AZERBAIJAN | 3712 3712 | 1985-08-05 | DLA Piper US LLP | D. Aliyeva 230 | Baku AZ1010 | ||||
| 55 | 55 | Bahamas Ministry of Tourism | 1972-01-27 | BAHAMAS | 2310 2310 | 1972-01-27 | Bahamas Tourist Office | Nassau | |||||
| 56 | 56 | Bahamas Ministry of Tourism | 2017-08-08 | BAHAMAS | 3911 3911 | 1986-12-01 | CMGRP, Inc. | Bolam House, George Street | Nassau | ||||
| 57 | 57 | Banthoon Lamsam, on behalf of Kasikornbank Public Company Ltd. | 2018-07-05 | THAILAND | 6568 6568 | 2018-07-05 | Luque PLLC | 1 Soi Rat Burana 27/1 | Rat Burana Road Bangkok 10140 | ||||
| 58 | 58 | Barcelona Turisme Convention Bureau | 2017-04-25 | SPAIN | 4777 4777 | 1993-03-12 | Development Counsellors International | Passatge de la Concepcio, 7-9 | 08008 Barcelona | ||||
| 59 | 59 | Barzan Aeronautical LLC | 2018-07-20 | QATAR | 6573 6573 | 2018-07-20 | Ott, Bielitzki & O'Neill PLLC | 170 Meeting Street | Suite 110 | Charleston | SC | 29401 | |
| 60 | 60 | Barzan Holdings QSTP LLC | 2019-02-11 | QATAR | 6635 6635 | 2019-02-11 | Barzan Aeronautical LLC | Burj Doha-Floor 30 Building 16 Zone 60 | P.O. Box 210 Doha | ||||
| 61 | 61 | Bavarian Ministry of Economic Affairs, Infrastructure, Transport and Technology | 2011-01-07 | GERMANY | 6015 6015 | 2011-01-07 | Bavarian U.S. Offices for Economic Development, LLC | Prinzregentenstrasse 28 | 80538 Munich | ||||
| 62 | 62 | Benitez Strategies | 2018-06-26 | MEXICO | 6566 6566 | 2018-06-26 | Felipe Carlos Benitez Rojas | 1015 15th Street, NW | Suite 600 | Washington | DC | 20005 | |
| 63 | 63 | Bergey Ryskaliyev | 2019-05-31 | KAZAKHSTAN | 6664 6664 | 2019-04-15 | Wiles, Lanny | ||||||
| 64 | 64 | Bermuda Business Development Agency | 2020-07-30 | BERMUDA | 6839 6839 | 2020-07-30 | Kivvit, LLC | 1 Church Street Maxwell Roberts Building, 6th Floor, Hamilton | |||||
| 65 | 65 | Bermuda Tourism Authority | 2014-08-21 | BERMUDA | 430 430 | 1947-01-30 | Bermuda Tourism Authority | 22 Church Street Hamilton HM 11 | |||||
| 66 | 66 | Biometrics Institute | 2020-03-19 | INTERNATIONAL | 6802 6802 | 2020-03-19 | RAM Identity Strategies LLC | 66 Prescot Street | London UK E1 8NN | ||||
| 67 | 67 | Bolivarian Republic of Venezuela under President Juan Guaido | 2019-02-11 | VENEZUELA | 1750 1750 | 1964-06-04 | Arnold & Porter Kaye Scholer, LLP | Carlos Vecchio, Ambassador of the Bolivarian Republic of Venuzuela under President Juan Guaido | 2409 California Street, NW | Washington | DC | 20008 | |
| 68 | 68 | Bolivarian Republic of Venezuela under President Juan Guaido | 2019-05-18 | VENEZUELA | 6681 6681 | 2019-05-18 | Buchheit, Lee C. | 2409 California Street, NW | Washington | DC | 20008 | ||
| 69 | 69 | Boulos, Reginald | 2020-01-27 | HAITI | 6788 6788 | 2020-01-27 | Shamlin, Richard | 20 Boulevard Toussaint Louverture | Port au Prince, HT6120 | ||||
| 70 | 70 | Brand South Africa | 2016-03-21 | SOUTH AFRICA | 6342 6342 | 2016-03-21 | Brand South Africa | 103 Central Street Houghton Johannesburg, 2198 | |||||
| 71 | 71 | British Tourist Authority | 1949-07-07 | GREAT BRITAIN | 579 579 | 1949-07-07 | VisitBritain | London | |||||
| 72 | 72 | British Virgin Islands Tourist Board & Film Commission | 2019-01-14 | BRITISH VIRGIN ISLANDS | 6492 6492 | 2017-11-27 | MMGY Global, LLC | ||||||
| 73 | 73 | British Virgin Islands Tourist Board | 1982-04-08 | BRITISH VIRGIN ISLANDS | 3354 3354 | 1982-04-08 | British Virgin Islands Tourist Board | Tortola | |||||
| 74 | 74 | British Virgin Islands Tourist Board | 2018-04-30 | BRITISH VIRGIN ISLANDS | 6549 6549 | 2018-04-30 | Myriad International Marketing, LLC | Decastro Street 2nd Floor, Akara Building | Road Town, Tortola, BVI | ||||
| 75 | 75 | Bureau of Foreign Trade, Ministry of Economic Affairs, Government of the Republic of China (BOFT) | 1987-06-23 | TAIWAN | 3988 3988 | 1987-05-28 | Crowell & Moring International, Ltd. | Washington | DC | ||||
| 76 | 76 | CCTV | 2019-08-02 | CHINA | 6633 6633 | 2019-08-02 | MediaLinks TV, LLC | 1A Guanghua Road | Chaoyang District Beijing 1000020 | ||||
| 77 | 77 | CJSC Belarusian Oil Company BNK LTD. | 2019-08-12 | BELARUS | 6706 6706 | 2019-08-12 | Gencarelli, David F. | 4a-305 Leshinsky Street 220140 Minsk Belarus | |||||
| 78 | 78 | CJSC Belarusian Oil Company | 2019-11-01 | BELARUS | 6706 6706 | 2019-08-12 | Gencarelli, David F. | 4a-305 Leshinsky Street | 220140, Minsk | ||||
| 79 | 79 | Canadian Ambassador (Canadian Embassy to the United States in Washington, DC) | 2019-03-28 | CANADA | 6570 6570 | 2018-07-10 | LGND, LLC | 501 Pennsylvania Ave SE | Washington | DC | 20001 | ||
| 80 | 80 | Canadian Commercial Corporation | 2010-01-11 | CANADA | 5971 5971 | 2010-01-11 | O'Brien Gentry & Scott, LLC | 1100 - 50 O'Connor Street | Ottawa | ||||
| 81 | 81 | Candidata A Diputada De Ultramar Ivelin Pepen Cedeno | 2020-05-16 | DOMINICAN REPUBLIC | 6823 6823 | 2020-05-16 | Federacion De Alcades Pedaneo | 419 Buttonwood Street | Reading | PA | 19601 | ||
| 82 | 82 | Caribbean Tourism Development Company | 2008-03-27 | INTERNATIONAL | 5910 5910 | 2008-03-27 | Caribbean Tourism Development Company | Ground Floor, Harbour Centre | Georgetown | ||||
| 83 | 83 | Caribbean Tourism Organization | 1994-03-02 | INTERNATIONAL | 991 991 | 1956-12-31 | Caribbean Tourism Organization, USA Inc. | St. Michael | |||||
| 84 | 84 | Cayman Islands Department of Tourism | 2016-09-26 | CAYMAN ISLANDS | 6177 6177 | 2013-08-07 | Coyne Public Relations, LLC | Government Administration Building Box 134 | 133 Elgin Avenue Grand Cayman KY 1-9000 | ||||
| 85 | 85 | Cayman Islands Ministry of Financial Services, Commerce & Environment | 2016-09-02 | CAYMAN ISLANDS | 5198 5198 | 1997-07-31 | Pillsbury Winthrop Shaw Pittman, LLP | Government Administration Building, Box 126 | 133 Elgin Avenue, Grand Cayman KY1-9000 | ||||
| 86 | 86 | Center for International Policy (under grant from the Norwegian Agency for Development Cooperation) | 2019-08-23 | NORWAY | 6710 6710 | 2019-08-23 | Waxman Consulting, Inc. DBA Waxman Strategies | 2000 M Street, NW | Suite 720 | Washington | DC | 20036 | |
| 87 | 87 | Center for Studies and Media Affairs at the Saudi Royal Court | 2016-09-20 | SAUDI ARABIA | 2165 2165 | 1969-10-09 | Squire Patton Boggs, LLP | Riyadh PO Box 11111 | |||||
| 88 | 88 | Centro de Inteligencia Estrategica - Gobierno de Ecuador | 2020-06-13 | ECUADOR | 6835 6835 | 2020-06-13 | Balsera Communications | Av. Eloy Alfaro y Rio Santiago | Quito, Lumbisi | ||||
| 89 | 89 | Chamber of Commerce and Industry of Serbia | 2019-11-12 | SERBIA | 6491 6491 | 2017-11-19 | Yorktown Solutions, LLC | Resavska 13-15 | Belgrade 11000 | ||||
| 90 | 90 | China Council for the Promotion of International Trade (CCPIT) | 2012-07-06 | CHINA | 6113 6113 | 2012-07-06 | Representative Office in the USA, China Council for the Promotion of International Trade (CCPIT) | 1 Fuxingmenwai Street | Beijing 100860 | ||||
| 91 | 91 | China Daily of Beijing, China | 1983-04-19 | CHINA | 3457 3457 | 1983-04-19 | China Daily Distribution Corporation | Beijing | |||||
| 92 | 92 | China National Tourism Administration (formerly: China International Travel Service) | 1981-12-30 | CHINA | 3318 3318 | 1981-12-30 | China National Tourist Office | Beijing | |||||
| 93 | 93 | China Telecom (Americas) Corporation | 2019-10-18 | CHINA | 6642 6642 | 2019-03-06 | Levick Strategic Communications, LP | 607 Herndon Pkwy #201 | Herndon | VA | 20170 | ||
| 94 | 94 | China Telecom Americas | 2019-03-20 | CHINA | 6585 6585 | 2018-08-30 | Ogilvy Group, LLC | 607 Herndon Parkway | Suite 201 | Herndon | VA | 20170 | |
| 95 | 95 | China-United States Exchange Foundation | 2019-03-01 | CHINA | 5430 5430 | 2001-05-10 | BGR Government Affairs, LLC | 20/F, Yardley Commercial Building No. 3 Connaught Road West | Sheung Wan, Hong Kong | ||||
| 96 | 96 | China-United States Exchange Foundation | 2011-07-14 | CHINA | 5875 5875 | 2008-06-17 | BLJ Worldwide LTD | ||||||
| 97 | 97 | China-United States Exchange Foundation | 2018-08-31 | CHINA | 6584 6584 | 2018-08-31 | Wilson Global Communications, LLC | 20/F Yardley Commercial Building, No. 3 | Connaught Rd West, SHeung Wan, Hong Kong | ||||
| 98 | 98 | China-United States Exchange Foundation | 2018-11-19 | CHINA | 6328 6328 | 2015-11-19 | Capitol Counsel, LLC | 20/F, Yardley Commercial Building No. 3 Connaught Road West | Sheung Wan, Hong Kong | ||||
| 99 | 99 | City of Sunderland, England | 1998-03-01 | GREAT BRITAIN | 5246 5246 | 1998-03-01 | Oliver A. Dulle Jr. & Company | Colima Avenue, Sunderland Enterprise Park, Sunderland | |||||
| 100 | 100 | Claudio De Simone | 2020-04-05 | SWITZERLAND | 6742 6742 | 2019-10-25 | Schulman Bhattacharya LLC | Routte des Chenolettes | 1660 Chateau Doex |
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) );