FARA_All_RegistrantDocs
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
21 rows where Document_Type = "Short-Form" and Registrant_Name = "FINNISH TOURIST BOARD, NEW YORK"
This data as json, CSV (advanced)
Registrant_Name 1
- FINNISH TOURIST BOARD, NEW YORK · 21 ✖
Foreign_Principal_Name 1
- - 21
Foreign_Principal_Country 1
- - 21
Document_Type 1
- Short-Form · 21 ✖
Link | rowid ▼ | Date_Stamped | Registrant_Name | Registration_Number | Document_Type | Short_Form_Name | Foreign_Principal_Name | Foreign_Principal_Country | URL |
---|---|---|---|---|---|---|---|---|---|
14001 | 14001 | 1976-02-04 | FINNISH TOURIST BOARD, NEW YORK | Finnish Tourist Board, New York 573 | Short-Form | KARI JOKILEHTO | Available-FARA-Public-Office | ||
14002 | 14002 | 1976-02-04 | FINNISH TOURIST BOARD, NEW YORK | Finnish Tourist Board, New York 573 | Short-Form | NINO DE PRADO | Available-FARA-Public-Office | ||
56410 | 56410 | 1949-05-31 | FINNISH TOURIST BOARD, NEW YORK | Finnish Tourist Board, New York 573 | Short-Form | HERMAN RUDOLF KRISTIAN RAMO | Available-FARA-Public-Office | ||
56411 | 56411 | 1949-05-31 | FINNISH TOURIST BOARD, NEW YORK | Finnish Tourist Board, New York 573 | Short-Form | ILMA ROSALIE RUCHOMAKI | Available-FARA-Public-Office | ||
57160 | 57160 | 1955-06-01 | FINNISH TOURIST BOARD, NEW YORK | Finnish Tourist Board, New York 573 | Short-Form | EVA ERIKA RAMO | Available-FARA-Public-Office | ||
71223 | 71223 | 1984-07-01 | FINNISH TOURIST BOARD, NEW YORK | Finnish Tourist Board, New York 573 | Short-Form | NINO C. MESSIA DE PRADO | Available-FARA-Public-Office | ||
71224 | 71224 | 1984-07-01 | FINNISH TOURIST BOARD, NEW YORK | Finnish Tourist Board, New York 573 | Short-Form | YRJO PEKKA KURKI | Available-FARA-Public-Office | ||
86452 | 86452 | 1974-08-09 | FINNISH TOURIST BOARD, NEW YORK | Finnish Tourist Board, New York 573 | Short-Form | KIRSTI KYLLIKKI KULMALA | Available-FARA-Public-Office | ||
86453 | 86453 | 1974-08-09 | FINNISH TOURIST BOARD, NEW YORK | Finnish Tourist Board, New York 573 | Short-Form | RAIMO KALEVI LAHTI | Available-FARA-Public-Office | ||
86454 | 86454 | 1974-08-09 | FINNISH TOURIST BOARD, NEW YORK | Finnish Tourist Board, New York 573 | Short-Form | TIMO ILMARI PAAVOLA | Available-FARA-Public-Office | ||
91803 | 91803 | 1972-09-01 | FINNISH TOURIST BOARD, NEW YORK | Finnish Tourist Board, New York 573 | Short-Form | RAIMO KALEVI LAHTI | Available-FARA-Public-Office | ||
96075 | 96075 | 1954-09-07 | FINNISH TOURIST BOARD, NEW YORK | Finnish Tourist Board, New York 573 | Short-Form | HERMAN KALEVI KLAS RAMO | Available-FARA-Public-Office | ||
96076 | 96076 | 1954-09-07 | FINNISH TOURIST BOARD, NEW YORK | Finnish Tourist Board, New York 573 | Short-Form | LEONA LILLIAN LAMPI | Available-FARA-Public-Office | ||
102945 | 102945 | 1968-10-01 | FINNISH TOURIST BOARD, NEW YORK | Finnish Tourist Board, New York 573 | Short-Form | GORAN V. HOVING | Available-FARA-Public-Office | ||
102946 | 102946 | 1968-10-01 | FINNISH TOURIST BOARD, NEW YORK | Finnish Tourist Board, New York 573 | Short-Form | KARI BERNDT JOKILEHTO | Available-FARA-Public-Office | ||
102947 | 102947 | 1968-10-01 | FINNISH TOURIST BOARD, NEW YORK | Finnish Tourist Board, New York 573 | Short-Form | MAJ-BRITT LINNEA JOKILEHTO | Available-FARA-Public-Office | ||
113990 | 113990 | 1968-11-01 | FINNISH TOURIST BOARD, NEW YORK | Finnish Tourist Board, New York 573 | Short-Form | GORAN V. HOVING | Available-FARA-Public-Office | ||
113991 | 113991 | 1968-11-01 | FINNISH TOURIST BOARD, NEW YORK | Finnish Tourist Board, New York 573 | Short-Form | KARI BERNDT JOKILEHTO | Available-FARA-Public-Office | ||
113992 | 113992 | 1968-11-01 | FINNISH TOURIST BOARD, NEW YORK | Finnish Tourist Board, New York 573 | Short-Form | MAJ-BRITT LINNEA JOKILEHTO | Available-FARA-Public-Office | ||
123610 | 123610 | 1949-12-01 | FINNISH TOURIST BOARD, NEW YORK | Finnish Tourist Board, New York 573 | Short-Form | HERMAN KALEVI KLAS RAMO | Available-FARA-Public-Office | ||
124251 | 124251 | 1972-12-01 | FINNISH TOURIST BOARD, NEW YORK | Finnish Tourist Board, New York 573 | Short-Form | ULLA-MAIJA KAUKONEN | Available-FARA-Public-Office |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [FARA_All_RegistrantDocs] ( [Date_Stamped] TEXT, [Registrant_Name] TEXT, [Registration_Number] INTEGER, [Document_Type] TEXT, [Short_Form_Name] TEXT, [Foreign_Principal_Name] TEXT, [Foreign_Principal_Country] TEXT, [URL] TEXT, FOREIGN KEY([Registration_Number]) REFERENCES [FARA_All_Registrants]([Registration_Number]) );