FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
15 rows where Address_1 = "" and Country/Location_Represented = "FINLAND" sorted by Zip
This data as json, CSV (advanced)
Suggested facets: Registration_Number, Registrant_Date, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Foreign_Principal 14
- Finnfacts Institute 2
- Business Finland 1
- Embassy of Finland 1
- Finnair 1
- Finnish State Railways 1
- Finnish Tourist Association 1
- Finnish Tourist Board 1
- Finska Angfartygs Aktiebolaget 1
- Ministry of Public Works & Communications of Finland 1
- Ministry of Trade & Industry 1
- Vaisala Oy 1
- Valio Finnish Co-operative Dairies Association 1
- Valmet OY 1
- Vist Finland 1
Registrant_Name 11
- Finnish Tourist Board, New York 4
- Myriad International Marketing, LLC 2
- Berry, Max N. 1
- David Haworth Associates, Inc. 1
- Edelman International Corporation 1
- Flack, Douglas J. 1
- Hamel, Park, McCabe & Saunders 1
- North American Precis Syndicate 1
- Poore, John G. 1
- Promotional Concept Group, Inc. 1
- Roth, Susan 1
Country/Location_Represented 1
- FINLAND · 15 ✖
City 1
- - 15
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 | ||||||
1742 | 1742 | 1990-01-31 | Finnish Tourist Board | 1983-08-10 | FINLAND | Promotional Concept Group, Inc. 3383 | 1982-06-16 | Promotional Concept Group, Inc. | |||||
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 | |||||
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 | |||||
6818 | 6818 | 1984-05-25 | Finnfacts Institute | 1983-03-17 | FINLAND | Edelman International Corporation 3468 | 1983-05-18 | Edelman International Corporation | |||||
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. | |||||
7929 | 7929 | 2020-06-18 | Vist Finland | 2020-06-18 | FINLAND | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | |||||
9335 | 9335 | 1952-07-18 | Finska Angfartygs Aktiebolaget | 1951-03-06 | FINLAND | Poore, John G. 663 | 1951-03-06 | Poore, John G. | |||||
12595 | 12595 | 1984-10-11 | Finnair | 1982-12-01 | FINLAND | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | NY | ||||
15184 | 15184 | 1986-12-17 | Finnfacts Institute | 1984-09-11 | FINLAND | David Haworth Associates, Inc. 3653 | 1984-09-11 | David Haworth Associates, Inc. | |||||
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. | |||||
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
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]) );