FARA_All_ForeignPrincipals

Table actions
List of all foreign principals (active and terminated)

Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history

27 rows where Registration_Number = 6212

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Foreign_Principal_Termination_Date, Foreign_Principal_Registration_Date, Address_1, Address_2, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)

State 4

Registrant_Name 1

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
240 240   Enterprise Ireland 2023-01-09 IRELAND Finn Partners, Inc. 6212 2014-03-10 Finn Partners, Inc. 345 Park Avenue, 17th Floor   New York NY 10154
318 318   Grenada Tourism Authority 2021-10-29 GRENADA Finn Partners, Inc. 6212 2014-03-10 Finn Partners, Inc. Burns Point in the parish of Saint George State of Grenada West Indies      
330 330   Hong Kong Tourism Board 2020-10-29 HONG KONG Finn Partners, Inc. 6212 2014-03-10 Finn Partners, Inc. 5901 W. Century Boulevard Suite 650 Los Angeles CA 90045
575 575   Qatar Museums 2022-04-21 QATAR Finn Partners, Inc. 6212 2014-03-10 Finn Partners, Inc. PO Box 2777   Doha    
649 649   St. Kitts Tourism Authority 2022-04-21 ST. KITTS AND NEVIS Finn Partners, Inc. 6212 2014-03-10 Finn Partners, Inc. Pelican Mall, PO Box 132   Basseterre    
678 678   Taste of Iceland 2023-03-27 ICELAND Finn Partners, Inc. 6212 2014-03-10 Finn Partners, Inc. Sundagaroar 2   Reykjavik    
719 719   Travel Alberta 2020-10-29 CANADA Finn Partners, Inc. 6212 2014-03-10 Finn Partners, Inc. 400, 1601 9 Avenue SE Calgary, Alberta TG2 0H4      
1040 1040 2020-01-01 Turkish Exporters Assembly Turkey Promotion Group 2019-10-30 TURKEY Finn Partners, Inc. 6212 2014-03-10 Finn Partners, Inc. Dis Ticaret Kimpleksi Cobancesme Mevkii Sanayi Cd. B Blok Kat:9 Yenibosna - Istanbul      
1499 1499 2023-01-24 Ministry of Presidential Affairs 2022-04-21 UNITED ARAB EMIRATES Finn Partners, Inc. 6212 2014-03-10 Finn Partners, Inc. Al Khubeirah   Abu Dhabi, UAE    
3132 3132 2018-02-28 Officina De Visitantes Y Convenciones de la Riviera Nayarit 2014-03-10 MEXICO Finn Partners, Inc. 6212 2014-03-10 Finn Partners, Inc. Avenida Paseo d los Cocoteros 85 Sur Local 18      
3154 3154 2023-02-28 Dubai Corporation for Tourism and Commerce Marketing 2020-12-01 UNITED ARAB EMIRATES Finn Partners, Inc. 6212 2014-03-10 Finn Partners, Inc. 4th Floor. One Central, The Offices 2, Dubai World Trade Centre. PO Box 594 Dubai    
3462 3462 2021-03-05 The Department for International Trade 2020-04-30 UNITED KINGDOM Finn Partners, Inc. 6212 2014-03-10 Finn Partners, Inc. 3 Whitehall Place London, SW1A 2AW      
3792 3792 2019-03-15 Ministry of Trade, Industry of Energy (MOTIE) of Korea 2018-11-09 KOREA, SOUTH Finn Partners, Inc. 6212 2014-03-10 Finn Partners, Inc. Government Complex 402 Hannuri-daero Seijiong-si      
4806 4806 2021-03-31 Jamaica Tourist Board 2014-03-10 JAMAICA Finn Partners, Inc. 6212 2014-03-10 Finn Partners, Inc. 64 Knutsford Blvd. Kingston 5        
7254 7254 2015-05-31 Korea International Trade Association 2015-04-15 KOREA, SOUTH Finn Partners, Inc. 6212 2014-03-10 Finn Partners, Inc. 460 Park Avenue, 4th Floor   New York NY 10022
7256 7256 2015-05-31 Via Rail Canada, Inc. 2014-03-10 CANADA Finn Partners, Inc. 6212 2014-03-10 Finn Partners, Inc. 300-1150 Station St Vancouver, BC V6A 4C7      
8787 8787 2022-06-30 Kamina Johnson Smith 2022-06-06 JAMAICA Finn Partners, Inc. 6212 2014-03-10 Finn Partners, Inc. 2 Port Royal Street   Kingston    
8946 8946 2022-07-01 The Royal Hashemite Court 2021-10-29 JORDAN Finn Partners, Inc. 6212 2014-03-10 Finn Partners, Inc. XW6V+VH4   Amman    
14568 14568 2017-11-30 Korean Ministry of Trade, Industry and Energy 2017-04-25 KOREA, SOUTH Finn Partners, Inc. 6212 2014-03-10 Finn Partners, Inc. 2450 Massachusetts Avenue, NW   Washington DC 20008
16752 16752 2014-12-31 Ministry of Tourism of Ecuador through EKOS Corp. 2014-10-28 ECUADOR Finn Partners, Inc. 6212 2014-03-10 Finn Partners, Inc.          
16774 16774 2015-12-31 Turkish Culture and Tourist Office 2014-03-10 TURKEY Finn Partners, Inc. 6212 2014-03-10 Finn Partners, Inc. 825 3rd Avenue   New York NY 10022
16777 16777 2016-12-31 Embassy of Japan through Akin Gump Strauss Hauer & Feld LLP 2016-08-03 JAPAN Finn Partners, Inc. 6212 2014-03-10 Finn Partners, Inc. 1333 New Hampshire Avenue, NW   Washington DC 20036
16782 16782 2016-12-31 Embassy of the Republic of Korea 2014-03-10 KOREA, SOUTH Finn Partners, Inc. 6212 2014-03-10 Finn Partners, Inc. 2450 Massachusetts Avenue, NW   Washington DC  
16811 16811 2017-12-31 Korea International Trade Association 2017-10-26 KOREA, SOUTH Finn Partners, Inc. 6212 2014-03-10 Finn Partners, Inc. 1660 L Street, NW #401   Washington DC 20036
16813 16813 2017-12-31 Ministry of Culture and Tourism of Turkey 2017-10-26 TURKEY Finn Partners, Inc. 6212 2014-03-10 Finn Partners, Inc. Ismet Inonu Bulvari, No: 32 Emek, Ankara, 06100      
16831 16831 2018-12-31 Ministry of Culture and Tourism of Turkey 2018-10-24 TURKEY Finn Partners, Inc. 6212 2014-03-10 Finn Partners, Inc. Ismet Inonu Bulvari No:32 Emek Ankara 06100      
16927 16927 2022-12-31 Lisboa Tourism Association 2022-08-05 PORTUGAL Finn Partners, Inc. 6212 2014-03-10 Finn Partners, Inc. Rua do Arsenal 15   Lisboa    

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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])
);