home / fara

Menu
  • Search all tables
  • GraphQL API

FARA_All_ForeignPrincipals

Table actions
  • GraphQL API for FARA_All_ForeignPrincipals
List of all foreign principals (active and terminated)

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

59 rows where Country/Location_Represented = "FINLAND"

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

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

Registrant_Name >30

  • Arent Fox Kintner Plotkin & Kahn, PLLC 5
  • Finnish Tourist Board, New York 5
  • Finnish Information Center 2
  • LeRoy & Denslow 2
  • Myriad International Marketing, LLC 2
  • Ogilvie, Taylor & Associates, Inc. 2
  • Parrish & Company, Inc. 2
  • Ramo, Herman Rudolf Kristian 2
  • Tribune Films, Inc. 2
  • Alden Films, Business Education Films, Films of the Nations 1
  • Aranow, Brodsky, Bohlinger, Einhorn & Dann 1
  • Barbara Burns & Associates, Inc. 1
  • Berry, Max N. 1
  • Burson-Marsteller 1
  • Caples Company 1
  • Covington & Burling 1
  • David Haworth Associates, Inc. 1
  • Development Counsellors International 1
  • Edelman International Corporation 1
  • Exclusively Finland Marketing Services 1
  • Finnish Tourist Board, Los Angeles 1
  • Flack, Douglas J. 1
  • Freed, William Herzl 1
  • Geyer & Oswald, Inc. 1
  • Hamel, Park, McCabe & Saunders 1
  • Haworth, James David Stewart 1
  • Hill and Knowlton Strategies, LLC 1
  • Jarvinen, Vilho Olavi 1
  • Karen Weiner Escalera Associates, Inc. 1
  • Latvala, Waino Kaune 1
  • …

Foreign_Principal >30

  • Finnish Tourist Board 4
  • Finnish Foreign Trade Association 3
  • Finnish National Tourist Office 3
  • Legation of Finland 3
  • Consulate General of Finland 2
  • Embassy of Finland 2
  • Finnair 2
  • Finnfacts Institute 2
  • Finnish State Railways 2
  • Invest in Finland Bureau 2
  • Outokumpu Oy 2
  • Republic of Finland 2
  • Bankruptcy Estate of Wartsila Marine Industries, Inc. 1
  • Business Finland 1
  • City of Helsinki 1
  • Finland National Tourist Office 1
  • Finland Promotion Board 1
  • Finlandia Association 1
  • Finnair - Aeroo/y 1
  • Finnair OY 1
  • Finnish Guarantee Board 1
  • Finnish Tourist Association 1
  • Finnish Tourist Board (Through the Finnish Tourist Board in New York) 1
  • Finnish Tourist Board, for Ministry of Trade & Commerce of Finland 1
  • Finnish-American Trading Corporation 1
  • Finska Angfartygs Aktiebolaget 1
  • Hjalmar Johan Procope 1
  • MASA Yards, Inc. 1
  • Metallverken, A.B. 1
  • Ministry for Foreign Affairs 1
  • …

State 4

  • - 43
  • NY 10
  • DC 5
  • GA 1

Country/Location_Represented 1

  • FINLAND · 59 ✖

City 1

  • - 59
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
88 88   Business Finland 2021-11-29 FINLAND Myriad International Marketing, LLC 6549 2018-04-30 Myriad International Marketing, LLC          
790 790 1963-01-01 Finnair 1961-08-01 FINLAND Geyer & Oswald, Inc. 1468 1961-08-01 Geyer & Oswald, Inc. New York     NY  
1293 1293 1943-01-15 Ministry for Foreign Affairs 1943-03-17 FINLAND Ramo, Herman Rudolf Kristian 10 1942-07-07 Ramo, Herman Rudolf Kristian Helsinki        
1294 1294 1943-01-15 Suomen-Matkat (Association Finland Travel) 1942-07-07 FINLAND Ramo, Herman Rudolf Kristian 10 1942-07-07 Ramo, Herman Rudolf Kristian Helsinki        
1316 1316 1973-01-15 Suomen-Matkat (Association Finland-Travel) 1942-07-07 FINLAND Finnish Information Center 9 1942-07-07 Finnish Information Center Helsinki        
1742 1742 1990-01-31 Finnish Tourist Board 1983-08-10 FINLAND Promotional Concept Group, Inc. 3383 1982-06-16 Promotional Concept Group, Inc.          
2039 2039 1991-02-01 Bankruptcy Estate of Wartsila Marine Industries, Inc. 1990-03-20 FINLAND Arent Fox Kintner Plotkin & Kahn, PLLC 2661 1976-02-18 Arent Fox Kintner Plotkin & Kahn, PLLC Helsinki        
2126 2126 1961-02-03 Finnair - Aeroo/y 1961-02-03 FINLAND Caples Company 34 1943-03-03 Caples Company Helsinki        
2422 2422 1996-02-12 Consulate General of Finland 1976-06-30 FINLAND Alden Films, Business Education Films, Films of the Nations 2100 1968-08-12 Alden Films, Business Education Films, Films of the Nations New York     NY  
2655 2655 1992-02-18 Outokumpu Oy 1987-03-28 FINLAND Arent Fox Kintner Plotkin & Kahn, PLLC 2661 1976-02-18 Arent Fox Kintner Plotkin & Kahn, PLLC Helsinki        
2887 2887 2015-02-27 Embassy of Finland 2014-12-22 FINLAND Roth, Susan 6154 2013-02-10 Roth, Susan          
2908 2908 1969-02-28 Finnish Tourist Association 1949-05-31 FINLAND Finnish Tourist Board, New York 573 1949-05-31 Finnish Tourist Board, New York          
2940 2940 1983-02-28 Vaisala Oy 1980-09-17 FINLAND Hamel, Park, McCabe & Saunders 1425 1961-02-07 Hamel, Park, McCabe & Saunders          
2968 2968 1991-02-28 Finland Promotion Board 1990-10-24 FINLAND Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC Helsinki        
3225 3225 1969-03-01 Ministry of Public Works & Communications of Finland 1951-07-19 FINLAND Finnish Tourist Board, New York 573 1949-05-31 Finnish Tourist Board, New York          
3320 3320 1997-03-01 Finnish Tourist Board, for Ministry of Trade & Commerce of Finland 1995-10-06 FINLAND Exclusively Finland Marketing Services 5055 1995-10-06 Exclusively Finland Marketing Services Helsinki        
3398 3398 1986-03-03 Finnish Foreign Trade Association 1982-10-22 FINLAND North-South Communications, Inc. 3418 1982-10-22 North-South Communications, Inc. Helsinki        
3661 3661 1985-03-12 Finnish Foreign Trade Association 1980-05-13 FINLAND Ogilvie, Taylor & Associates, Inc. 3105 1980-05-13 Ogilvie, Taylor & Associates, Inc. Helsinki        
3827 3827 1943-03-17 Ministry of Foreign Affairs 1943-03-17 FINLAND Finnish Information Center 9 1942-07-07 Finnish Information Center Helsinki        
4372 4372 1979-03-31 Finnish Foreign Trade Association 1979-02-22 FINLAND Ogilvie, Taylor & Associates, Inc. 2880 1978-04-04 Ogilvie, Taylor & Associates, Inc. Helsinki        
4404 4404 1983-03-31 Finnish National Tourist Office 1974-08-13 FINLAND Public Service Audience Planners 2452 1979-08-23 Public Service Audience Planners New York     NY  
4538 4538 1995-03-31 Finnish Tourist Board (Through the Finnish Tourist Board in New York) 1987-08-25 FINLAND Finnish Tourist Board, Los Angeles 4030 1987-08-25 Finnish Tourist Board, Los Angeles Helsinki        
4661 4661 2006-03-31 Republic of Finland 2006-05-31 FINLAND White & Case, LLP 2759 1977-03-09 White & Case, LLP Snell Maninkatu 1A Helsinki 00023      
5132 5132 1980-04-10 Finnish Tourist Board 1973-04-05 FINLAND Scandinavian National Tourist Office 2372 1972-08-24 Scandinavian National Tourist Office Helsinki        
5986 5986 2000-04-30 Invest in Finland Bureau 1997-06-18 FINLAND Burson-Marsteller 2469 1973-10-23 Burson-Marsteller Helsinki        
6154 6154 1973-05-01 Consulate General of Finland 1967-08-11 FINLAND Freed, William Herzl 735 1952-07-22 Freed, William Herzl New York     NY  
6818 6818 1984-05-25 Finnfacts Institute 1983-03-17 FINLAND Edelman International Corporation 3468 1983-05-18 Edelman International Corporation          
7007 7007 1950-05-31 Finnish State Railways 1949-06-28 FINLAND Finnish Tourist Board, New York 573 1949-05-31 Finnish Tourist Board, New York Helsinki        
7101 7101 1991-05-31 Finnair OY 1988-11-28 FINLAND Ruder Finn, Inc. 1481 1961-09-27 Ruder Finn, Inc. Helsinki        
7500 7500 1993-06-02 Valio Finnish Co-operative Dairies Association 1980-06-03 FINLAND Berry, Max N. 2216 1970-10-30 Berry, Max N.          
7769 7769 1992-06-12 MASA Yards, Inc. 1990-10-01 FINLAND Parrish & Company, Inc. 3179 1980-12-12 Parrish & Company, Inc. Helsinki        
7929 7929 2020-06-18 Vist Finland 2020-06-18 FINLAND Myriad International Marketing, LLC 6549 2018-04-30 Myriad International Marketing, LLC          
9114 9114 1943-07-09 Finnish-American Trading Corporation 1942-07-09 FINLAND Jarvinen, Vilho Olavi 24 1942-07-09 Jarvinen, Vilho Olavi New York     NY  
9119 9119 1950-07-09 Legation of Finland 1944-02-02 FINLAND LeRoy & Denslow 27 1942-07-09 LeRoy & Denslow Washington     DC  
9335 9335 1952-07-18 Finska Angfartygs Aktiebolaget 1951-03-06 FINLAND Poore, John G. 663 1951-03-06 Poore, John G.          
9704 9704 1969-07-31 Embassy of Finland 1964-10-29 FINLAND Tribune Films, Inc. 1810 1964-10-29 Tribune Films, Inc. Washington     DC  
9803 9803 1994-07-31 Finnish Tourist Board 1988-11-23 FINLAND West Glen Communications 4191 1988-11-23 West Glen Communications New York     NY  
9947 9947 1942-08-01 Hjalmar Johan Procope 1942-08-01 FINLAND Ramsay, Johan V.V. 74 1942-08-01 Ramsay, Johan V.V. Washington     DC  
10602 10602 1991-08-18 Finnish Guarantee Board 1990-03-20 FINLAND Arent Fox Kintner Plotkin & Kahn, PLLC 2661 1976-02-18 Arent Fox Kintner Plotkin & Kahn, PLLC Helsinki        
10649 10649 1990-08-21 Metallverken, A.B. 1989-03-24 FINLAND Winthrop, Stimson, Putnam & Roberts, Washington Office 3873 1986-08-21 Winthrop, Stimson, Putnam & Roberts, Washington Office Vasteras        
10760 10760 1976-08-26 Finnish National Tourist Office 1972-10-04 FINLAND Tribune Films, Inc. 1810 1964-10-29 Tribune Films, Inc. New York     NY  
11226 11226 1975-09-01 Finnish National Tourist Office 1970-06-10 FINLAND M. Silver Associates, Inc. 2200 1970-06-10 M. Silver Associates, Inc. New York     NY  
11236 11236 1980-09-01 Outokumpu Oy 1977-03-15 FINLAND Arent Fox Kintner Plotkin & Kahn, PLLC 2661 1976-02-18 Arent Fox Kintner Plotkin & Kahn, PLLC Helsinki        
11359 11359 1946-09-04 Finlandia Association 1946-02-18 FINLAND Latvala, Waino Kaune 344 1946-02-18 Latvala, Waino Kaune Helsinki        
12595 12595 1984-10-11 Finnair 1982-12-01 FINLAND North American Precis Syndicate 2836 1977-10-12 North American Precis Syndicate       NY  
12966 12966 1943-10-24 Legation of Finland 1942-09-24 FINLAND LeRoy & Denslow 132 1942-09-24 LeRoy & Denslow Washington     DC  
13274 13274 1990-10-31 Oy Wartsila, A.B. 1981-06-01 FINLAND Parrish & Company, Inc. 3179 1980-12-12 Parrish & Company, Inc. Helsinki        
14016 14016 1977-11-16 Legation of Finland 1949-07-08 FINLAND Covington & Burling 523 1948-04-16 Covington & Burling Washington     DC  
15184 15184 1986-12-17 Finnfacts Institute 1984-09-11 FINLAND David Haworth Associates, Inc. 3653 1984-09-11 David Haworth Associates, Inc.          
15200 15200 1967-12-18 Republic of Finland 1964-05-13 FINLAND Aranow, Brodsky, Bohlinger, Einhorn & Dann 1731 1964-05-13 Aranow, Brodsky, Bohlinger, Einhorn & Dann Helsinki        
15405 15405 1985-12-27 Finland National Tourist Office 1976-06-18 FINLAND Patricof, Pat E. 2700 1976-06-18 Patricof, Pat E. New York     NY  
15730 15730 1974-12-31 Finnish State Railways 1964-04-03 FINLAND Finnish Tourist Board, New York 573 1949-05-31 Finnish Tourist Board, New York          
15872 15872 1981-12-31 Valmet OY 1981-04-06 FINLAND Flack, Douglas J. 3185 1980-12-31 Flack, Douglas J.          
15989 15989 1986-12-31 TVW Paper Machines, Inc. 1985-06-27 FINLAND Arent Fox Kintner Plotkin & Kahn, PLLC 2661 1976-02-18 Arent Fox Kintner Plotkin & Kahn, PLLC Atlanta     GA  
16129 16129 1989-12-31 Ministry for Foreign Affairs, Finland 1988-02-19 FINLAND Haworth, James David Stewart 4090 1988-02-19 Haworth, James David Stewart Helsinki        
16385 16385 1996-12-31 Finnish Tourist Board 1987-09-25 FINLAND Karen Weiner Escalera Associates, Inc. 3405 1982-08-27 Karen Weiner Escalera Associates, Inc. Helsinki        
16434 16434 1998-12-31 City of Helsinki 1997-08-04 FINLAND Barbara Burns & Associates, Inc. 4600 1991-12-06 Barbara Burns & Associates, Inc. Helsinki        
16500 16500 2001-12-31 Invest in Finland Bureau 2001-03-19 FINLAND Development Counsellors International 4777 1993-03-12 Development Counsellors International Aleksanterinkatu 17, P.O. Box 800 FIN-00101 Helsinki        
16605 16605 2006-12-31 Ministry of Trade & Industry 1973-10-30 FINLAND Finnish Tourist Board, New York 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])
);
Powered by Datasette · Queries took 346.416ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
  • Sort ascending
  • Sort descending
  • Facet by this
  • Hide this column
  • Show all columns
  • Show not-blank rows