List of all foreign principals (active and terminated)

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

58 rows where Country/Location_Represented = "FINLAND"

View and edit SQL

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

State

Country/Location_Represented

  • FINLAND · 58

City

  • - 58
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
700 1963-01-01 Finnair 1961-08-01 FINLAND 1468 1468 1961-08-01 Geyer & Oswald, Inc. New York     NY  
1193 1943-01-15 Ministry for Foreign Affairs 1943-03-17 FINLAND 10 10 1942-07-07 Ramo, Herman Rudolf Kristian Helsinki        
1194 1943-01-15 Suomen-Matkat (Association Finland Travel) 1942-07-07 FINLAND 10 10 1942-07-07 Ramo, Herman Rudolf Kristian Helsinki        
1216 1973-01-15 Suomen-Matkat (Association Finland-Travel) 1942-07-07 FINLAND 9 9 1942-07-07 Finnish Information Center Helsinki        
1632 1990-01-31 Finnish Tourist Board 1983-08-10 FINLAND 3383 3383 1982-06-16 Promotional Concept Group, Inc.          
1921 1991-02-01 Bankruptcy Estate of Wartsila Marine Industries, Inc. 1990-03-20 FINLAND 2661 2661 1976-02-18 Arent Fox Kintner Plotkin & Kahn, PLLC Helsinki        
2004 1961-02-03 Finnair - Aeroo/y 1961-02-03 FINLAND 34 34 1943-03-03 Caples Company Helsinki        
2295 1996-02-12 Consulate General of Finland 1976-06-30 FINLAND 2100 2100 1968-08-12 Alden Films, Business Education Films, Films of the Nations New York     NY  
2520 1992-02-18 Outokumpu Oy 1987-03-28 FINLAND 2661 2661 1976-02-18 Arent Fox Kintner Plotkin & Kahn, PLLC Helsinki        
2744 2015-02-27 Embassy of Finland 2014-12-22 FINLAND 6154 6154 2013-02-10 Roth, Susan          
2765 1969-02-28 Finnish Tourist Association 1949-05-31 FINLAND 573 573 1949-05-31 Finnish Tourist Board, New York          
2797 1983-02-28 Vaisala Oy 1980-09-17 FINLAND 1425 1425 1961-02-07 Hamel, Park, McCabe & Saunders          
2825 1991-02-28 Finland Promotion Board 1990-10-24 FINLAND 3301 3301 1981-11-10 Hill and Knowlton Strategies, LLC Helsinki        
3069 1969-03-01 Ministry of Public Works & Communications of Finland 1951-07-19 FINLAND 573 573 1949-05-31 Finnish Tourist Board, New York          
3164 1997-03-01 Finnish Tourist Board, for Ministry of Trade & Commerce of Finland 1995-10-06 FINLAND 5055 5055 1995-10-06 Exclusively Finland Marketing Services Helsinki        
3235 1986-03-03 Finnish Foreign Trade Association 1982-10-22 FINLAND 3418 3418 1982-10-22 North-South Communications, Inc. Helsinki        
3487 1985-03-12 Finnish Foreign Trade Association 1980-05-13 FINLAND 3105 3105 1980-05-13 Ogilvie, Taylor & Associates, Inc. Helsinki        
3648 1943-03-17 Ministry of Foreign Affairs 1943-03-17 FINLAND 9 9 1942-07-07 Finnish Information Center Helsinki        
4186 1979-03-31 Finnish Foreign Trade Association 1979-02-22 FINLAND 2880 2880 1978-04-04 Ogilvie, Taylor & Associates, Inc. Helsinki        
4218 1983-03-31 Finnish National Tourist Office 1974-08-13 FINLAND 2452 2452 1979-08-23 Public Service Audience Planners New York     NY  
4352 1995-03-31 Finnish Tourist Board (Through the Finnish Tourist Board in New York) 1987-08-25 FINLAND 4030 4030 1987-08-25 Finnish Tourist Board, Los Angeles Helsinki        
4475 2006-03-31 Republic of Finland 2006-05-31 FINLAND 2759 2759 1977-03-09 White & Case, LLP Snell Maninkatu 1A Helsinki 00023      
4922 1980-04-10 Finnish Tourist Board 1973-04-05 FINLAND 2372 2372 1972-08-24 Scandinavian National Tourist Office Helsinki        
5762 2000-04-30 Invest in Finland Bureau 1997-06-18 FINLAND 2469 2469 1973-10-23 Burson-Marsteller Helsinki        
5886 2020-04-30 Vist Finland 2020-06-18 FINLAND 6549 6549 2018-04-30 Myriad International Marketing, LLC          
5925 1973-05-01 Consulate General of Finland 1967-08-11 FINLAND 735 735 1952-07-22 Freed, William Herzl New York     NY  
6573 1984-05-25 Finnfacts Institute 1983-03-17 FINLAND 3468 3468 1983-05-18 Edelman International Corporation          
6756 1950-05-31 Finnish State Railways 1949-06-28 FINLAND 573 573 1949-05-31 Finnish Tourist Board, New York Helsinki        
6850 1991-05-31 Finnair OY 1988-11-28 FINLAND 1481 1481 1961-09-27 Ruder Finn, Inc. Helsinki        
7228 1993-06-02 Valio Finnish Co-operative Dairies Association 1980-06-03 FINLAND 2216 2216 1970-10-30 Berry, Max N.          
7494 1992-06-12 MASA Yards, Inc. 1990-10-01 FINLAND 3179 3179 1980-12-12 Parrish & Company, Inc. Helsinki        
8806 1943-07-09 Finnish-American Trading Corporation 1942-07-09 FINLAND 24 24 1942-07-09 Jarvinen, Vilho Olavi New York     NY  
8811 1950-07-09 Legation of Finland 1944-02-02 FINLAND 27 27 1942-07-09 LeRoy & Denslow Washington     DC  
9023 1952-07-18 Finska Angfartygs Aktiebolaget 1951-03-06 FINLAND 663 663 1951-03-06 Poore, John G.          
9387 1969-07-31 Embassy of Finland 1964-10-29 FINLAND 1810 1810 1964-10-29 Tribune Films, Inc. Washington     DC  
9486 1994-07-31 Finnish Tourist Board 1988-11-23 FINLAND 4191 4191 1988-11-23 West Glen Communications New York     NY  
9625 1942-08-01 Hjalmar Johan Procope 1942-08-01 FINLAND 74 74 1942-08-01 Ramsay, Johan V.V. Washington     DC  
10270 1991-08-18 Finnish Guarantee Board 1990-03-20 FINLAND 2661 2661 1976-02-18 Arent Fox Kintner Plotkin & Kahn, PLLC Helsinki        
10315 1990-08-21 Metallverken, A.B. 1989-03-24 FINLAND 3873 3873 1986-08-21 Winthrop, Stimson, Putnam & Roberts, Washington Office Vasteras        
10420 1976-08-26 Finnish National Tourist Office 1972-10-04 FINLAND 1810 1810 1964-10-29 Tribune Films, Inc. New York     NY  
10873 1975-09-01 Finnish National Tourist Office 1970-06-10 FINLAND 2200 2200 1970-06-10 M. Silver Associates, Inc. New York     NY  
10883 1980-09-01 Outokumpu Oy 1977-03-15 FINLAND 2661 2661 1976-02-18 Arent Fox Kintner Plotkin & Kahn, PLLC Helsinki        
11005 1946-09-04 Finlandia Association 1946-02-18 FINLAND 344 344 1946-02-18 Latvala, Waino Kaune Helsinki        
12187 1984-10-11 Finnair 1982-12-01 FINLAND 2836 2836 1977-10-12 North American Precis Syndicate       NY  
12549 1943-10-24 Legation of Finland 1942-09-24 FINLAND 132 132 1942-09-24 LeRoy & Denslow Washington     DC  
12855 1990-10-31 Oy Wartsila, A.B. 1981-06-01 FINLAND 3179 3179 1980-12-12 Parrish & Company, Inc. Helsinki        
13579 1977-11-16 Legation of Finland 1949-07-08 FINLAND 523 523 1948-04-16 Covington & Burling Washington     DC  
14723 1986-12-17 Finnfacts Institute 1984-09-11 FINLAND 3653 3653 1984-09-11 David Haworth Associates, Inc.          
14738 1967-12-18 Republic of Finland 1964-05-13 FINLAND 1731 1731 1964-05-13 Aranow, Brodsky, Bohlinger, Einhorn & Dann Helsinki        
14939 1985-12-27 Finland National Tourist Office 1976-06-18 FINLAND 2700 2700 1976-06-18 Patricof, Pat E. New York     NY  
15258 1974-12-31 Finnish State Railways 1964-04-03 FINLAND 573 573 1949-05-31 Finnish Tourist Board, New York          
15400 1981-12-31 Valmet OY 1981-04-06 FINLAND 3185 3185 1980-12-31 Flack, Douglas J.          
15517 1986-12-31 TVW Paper Machines, Inc. 1985-06-27 FINLAND 2661 2661 1976-02-18 Arent Fox Kintner Plotkin & Kahn, PLLC Atlanta     GA  
15657 1989-12-31 Ministry for Foreign Affairs, Finland 1988-02-19 FINLAND 4090 4090 1988-02-19 Haworth, James David Stewart Helsinki        
15913 1996-12-31 Finnish Tourist Board 1987-09-25 FINLAND 3405 3405 1982-08-27 Karen Weiner Escalera Associates, Inc. Helsinki        
15962 1998-12-31 City of Helsinki 1997-08-04 FINLAND 4600 4600 1991-12-06 Barbara Burns & Associates, Inc. Helsinki        
16028 2001-12-31 Invest in Finland Bureau 2001-03-19 FINLAND 4777 4777 1993-03-12 Development Counsellors International Aleksanterinkatu 17, P.O. Box 800 FIN-00101 Helsinki        
16133 2006-12-31 Ministry of Trade & Industry 1973-10-30 FINLAND 573 573 1949-05-31 Finnish Tourist Board, New York          

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