List of all foreign principals (active and terminated)

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

18 rows where Registrant_Name = "Finn Partners, Inc." sorted by City

View and edit SQL

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

State

Registrant_Name

  • Finn Partners, Inc. · 18
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
686   Travel Alberta 2020-10-29 CANADA 6212 6212 2014-03-10 Finn Partners, Inc. 400, 1601 9 Avenue SE Calgary, Alberta TG2 0H4      
988 2020-01-01 Turkish Exporters Assembly Turkey Promotion Group 2019-10-30 TURKEY 6212 6212 2014-03-10 Finn Partners, Inc. Dis Ticaret Kimpleksi Cobancesme Mevkii Sanayi Cd. B Blok Kat:9 Yenibosna - Istanbul      
3031 2018-02-28 Officina De Visitantes Y Convenciones de la Riviera Nayarit 2014-03-10 MEXICO 6212 6212 2014-03-10 Finn Partners, Inc. Avenida Paseo d los Cocoteros 85 Sur Local 18      
3657 2019-03-15 Ministry of Trade, Industry of Energy (MOTIE) of Korea 2018-11-09 KOREA, SOUTH 6212 6212 2014-03-10 Finn Partners, Inc. Government Complex 402 Hannuri-daero Seijiong-si      
4662 2021-03-31 Jamaica Tourist Board 2014-03-10 JAMAICA 6212 6212 2014-03-10 Finn Partners, Inc. 64 Knutsford Blvd. Kingston 5        
4882 2021-04-05 The Department for International Trade 2020-04-30 UNITED KINGDOM 6212 6212 2014-03-10 Finn Partners, Inc. 3 Whitehall Place London, SW1A 2AW      
7049 2015-05-31 Via Rail Canada, Inc. 2014-03-10 CANADA 6212 6212 2014-03-10 Finn Partners, Inc. 300-1150 Station St Vancouver, BC V6A 4C7      
16334 2014-12-31 Ministry of Tourism of Ecuador through EKOS Corp. 2014-10-28 ECUADOR 6212 6212 2014-03-10 Finn Partners, Inc.          
16394 2017-12-31 Ministry of Culture and Tourism of Turkey 2017-10-26 TURKEY 6212 6212 2014-03-10 Finn Partners, Inc. Ismet Inonu Bulvari, No: 32 Emek, Ankara, 06100      
16412 2018-12-31 Ministry of Culture and Tourism of Turkey 2018-10-24 TURKEY 6212 6212 2014-03-10 Finn Partners, Inc. Ismet Inonu Bulvari No:32 Emek Ankara 06100      
149   Dubai Corporation for Tourism and Commerce Marketing 2020-12-01 UNITED ARAB EMIRATES 6212 6212 2014-03-10 Finn Partners, Inc. 4th Floor. One Central, The Offices 2, Dubai World Trade Centre. PO Box 594 Dubai    
331   Hong Kong Tourism Board 2020-10-29 HONG KONG 6212 6212 2014-03-10 Finn Partners, Inc. 5901 W. Century Boulevard Suite 650 Los Angeles CA 90045
7047 2015-05-31 Korea International Trade Association 2015-04-15 KOREA, SOUTH 6212 6212 2014-03-10 Finn Partners, Inc. 460 Park Avenue, 4th Floor   New York NY 10022
16356 2015-12-31 Turkish Culture and Tourist Office 2014-03-10 TURKEY 6212 6212 2014-03-10 Finn Partners, Inc. 825 3rd Avenue   New York NY 10022
14183 2017-11-30 Korean Ministry of Trade, Industry and Energy 2017-04-25 KOREA, SOUTH 6212 6212 2014-03-10 Finn Partners, Inc. 2450 Massachusetts Avenue, NW   Washington DC 20008
16359 2016-12-31 Embassy of Japan through Akin Gump Strauss Hauer & Feld LLP 2016-08-03 JAPAN 6212 6212 2014-03-10 Finn Partners, Inc. 1333 New Hampshire Avenue, NW   Washington DC 20036
16364 2016-12-31 Embassy of the Republic of Korea 2014-03-10 KOREA, SOUTH 6212 6212 2014-03-10 Finn Partners, Inc. 2450 Massachusetts Avenue, NW   Washington DC  
16392 2017-12-31 Korea International Trade Association 2017-10-26 KOREA, SOUTH 6212 6212 2014-03-10 Finn Partners, Inc. 1660 L Street, NW #401   Washington DC 20036

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