FARA_All_ShortForms

Table actions
List of all short form registrants (active and terminated)

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

20 rows where Registration_Number = 573

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Short_Form_Date, Short_Form_Last_Name, Short_Form_Date (date), Registration_Date (date)

State 1

Registration_Number 1

  • Finnish Tourist Board, New York · 20 ✖

Registrant_Name 1

City 1

Link rowid ▼ Short_Form_Termination_Date Short_Form_Date Short_Form_Last_Name Short_Form_First_Name Registration_Number Registration_Date Registrant_Name Address_1 Address_2 City State Zip
3397 3397 1976-01-08 1974-08-09 Kulmala Kirsti Kyllikki Finnish Tourist Board, New York 573 1949-05-31 Finnish Tourist Board, New York 655 Third Avenue Suite 1810 New York NY 10017-5617
4924 4924 1968-01-31 1955-06-01 Ramo Eva Erika Finnish Tourist Board, New York 573 1949-05-31 Finnish Tourist Board, New York 655 Third Avenue Suite 1810 New York NY 10017-5617
7883 7883 1978-02-28 1976-02-04 Jokilehto Kari Finnish Tourist Board, New York 573 1949-05-31 Finnish Tourist Board, New York 655 Third Avenue Suite 1810 New York NY 10017-5617
7932 7932 1987-02-28 1984-07-20 Pakarinen Ulla Maija Finnish Tourist Board, New York 573 1949-05-31 Finnish Tourist Board, New York 655 Third Avenue Suite 1810 New York NY 10017-5617
14938 14938 2006-04-30 2002-09-04 Conte Maria Finnish Tourist Board, New York 573 1949-05-31 Finnish Tourist Board, New York 655 Third Avenue Suite 1810 New York NY 10017-5617
17554 17554 1953-05-31 1949-05-31 Ruchomaki Ilma Rosalie Finnish Tourist Board, New York 573 1949-05-31 Finnish Tourist Board, New York 655 Third Avenue Suite 1810 New York NY 10017-5617
20854 20854 1972-06-30 1968-10-21 Jokilehto Kari Berndt Finnish Tourist Board, New York 573 1949-05-31 Finnish Tourist Board, New York 655 Third Avenue Suite 1810 New York NY 10017-5617
20855 20855 1972-06-30 1968-10-21 Jokilehto Maj-Britt Linnea Finnish Tourist Board, New York 573 1949-05-31 Finnish Tourist Board, New York 655 Third Avenue Suite 1810 New York NY 10017-5617
27911 27911 1975-08-31 1974-08-09 Paavola Timo Ilmari Finnish Tourist Board, New York 573 1949-05-31 Finnish Tourist Board, New York 655 Third Avenue Suite 1810 New York NY 10017-5617
30910 30910 1973-09-30 1968-10-21 Hoving Goran V. Finnish Tourist Board, New York 573 1949-05-31 Finnish Tourist Board, New York 655 Third Avenue Suite 1810 New York NY 10017-5617
30916 30916 1975-09-30 1972-09-26 Lahti Raimo Kalevi Finnish Tourist Board, New York 573 1949-05-31 Finnish Tourist Board, New York 655 Third Avenue Suite 1810 New York NY 10017-5617
34002 34002 1946-10-30 1949-05-31 Ramo Herman Rudolf Kristian Finnish Tourist Board, New York 573 1949-05-31 Finnish Tourist Board, New York 655 Third Avenue Suite 1810 New York NY 10017-5617
34003 34003 1949-10-30 1949-12-29 Ramo Herman Kalevi Klas Finnish Tourist Board, New York 573 1949-05-31 Finnish Tourist Board, New York 655 Third Avenue Suite 1810 New York NY 10017-5617
34058 34058 1987-10-30 1984-09-11 Saukola Pirjo Finnish Tourist Board, New York 573 1949-05-31 Finnish Tourist Board, New York 655 Third Avenue Suite 1810 New York NY 10017-5617
36626 36626 1972-11-30 1972-12-21 Kaukonen Ulla-Maija Finnish Tourist Board, New York 573 1949-05-31 Finnish Tourist Board, New York 655 Third Avenue Suite 1810 New York NY 10017-5617
36707 36707 1988-11-30 1984-07-20 Kurki Yrjo Pekka Finnish Tourist Board, New York 573 1949-05-31 Finnish Tourist Board, New York 655 Third Avenue Suite 1810 New York NY 10017-5617
39531 39531 1954-12-31 1954-09-07 Lampi Leona Lillian Finnish Tourist Board, New York 573 1949-05-31 Finnish Tourist Board, New York 655 Third Avenue Suite 1810 New York NY 10017-5617
41490 41490 2006-12-31 1976-02-04 Messia de Prado Nino C. Finnish Tourist Board, New York 573 1949-05-31 Finnish Tourist Board, New York 655 Third Avenue Suite 1810 New York NY 10017-5617
41511 41511 2006-12-31 2002-09-04 Niskanen Helena Finnish Tourist Board, New York 573 1949-05-31 Finnish Tourist Board, New York 655 Third Avenue Suite 1810 New York NY 10017-5617
41512 41512 2006-12-31 2002-09-04 Nordin Kerstin E. Finnish Tourist Board, New York 573 1949-05-31 Finnish Tourist Board, New York 655 Third Avenue Suite 1810 New York NY 10017-5617

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [FARA_All_ShortForms] (
   [Short_Form_Termination_Date] TEXT,
   [Short_Form_Date] TEXT,
   [Short_Form_Last_Name] TEXT,
   [Short_Form_First_Name] TEXT,
   [Registration_Number] INTEGER,
   [Registration_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])
);