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

31 rows where Registration_Number = 68

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

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

State 1

Registration_Number 1

  • Swedish Tourist Office · 31 ✖

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
8947 8947 1950-03-02 1943-05-20 Hedin Naboth Swedish Tourist Office 68 1942-07-27 Swedish Tourist Office 655 Third Avenue 18th Floor New York NY 10017
10645 10645 1964-03-24 1953-03-11 Pagel Alex John Swedish Tourist Office 68 1942-07-27 Swedish Tourist Office 655 Third Avenue 18th Floor New York NY 10017
12380 12380 1963-04-01 1960-08-25 Nystrom Jan Olof Gustaf Swedish Tourist Office 68 1942-07-27 Swedish Tourist Office 655 Third Avenue 18th Floor New York NY 10017
12756 12756 1966-04-05 1966-04-05 Schou Jack Swedish Tourist Office 68 1942-07-27 Swedish Tourist Office 655 Third Avenue 18th Floor New York NY 10017
13058 13058 1946-04-10 1943-05-20 Pagel Alex J. Swedish Tourist Office 68 1942-07-27 Swedish Tourist Office 655 Third Avenue 18th Floor New York NY 10017
13598 13598 1956-04-17 1954-01-15 Tranaeus Jarl Einar Swedish Tourist Office 68 1942-07-27 Swedish Tourist Office 655 Third Avenue 18th Floor New York NY 10017
17001 17001 1965-05-24 1947-08-19 Kastrup Hans Sture Allan Swedish Tourist Office 68 1942-07-27 Swedish Tourist Office 655 Third Avenue 18th Floor New York NY 10017
17215 17215 1966-05-27 1966-04-05 Ohrstrom Nils A. Swedish Tourist Office 68 1942-07-27 Swedish Tourist Office 655 Third Avenue 18th Floor New York NY 10017
17548 17548 1949-05-31 1948-05-06 Norberg Gard Ellwyn Swedish Tourist Office 68 1942-07-27 Swedish Tourist Office 655 Third Avenue 18th Floor New York NY 10017
19504 19504 1970-06-15 1970-06-01 Conradson Edgar A. Swedish Tourist Office 68 1942-07-27 Swedish Tourist Office 655 Third Avenue 18th Floor New York NY 10017
20640 20640 1953-06-30 1951-03-12 Sjogren Karl Erik Gustaf Swedish Tourist Office 68 1942-07-27 Swedish Tourist Office 655 Third Avenue 18th Floor New York NY 10017
22050 22050 1962-07-01 1961-01-18 Nordberg Curt Bjorn Morgan Swedish Tourist Office 68 1942-07-27 Swedish Tourist Office 655 Third Avenue 18th Floor New York NY 10017
22092 22092 1972-07-01 1964-04-20 Gille Ake Swedish Tourist Office 68 1942-07-27 Swedish Tourist Office 655 Third Avenue 18th Floor New York NY 10017
22512 22512 1968-07-03 1967-10-17 Bonde Thord Swedish Tourist Office 68 1942-07-27 Swedish Tourist Office 655 Third Avenue 18th Floor New York NY 10017
22941 22941 1968-07-11 1965-09-03 Naslundh Lars Erik Gote Swedish Tourist Office 68 1942-07-27 Swedish Tourist Office 655 Third Avenue 18th Floor New York NY 10017
25436 25436 1952-08-01 1947-02-24 Ekman Elon Victor Swedish Tourist Office 68 1942-07-27 Swedish Tourist Office 655 Third Avenue 18th Floor New York NY 10017
26303 26303 1965-08-09 1964-04-01 Gronkvist Uno Swedish Tourist Office 68 1942-07-27 Swedish Tourist Office 655 Third Avenue 18th Floor New York NY 10017
35641 35641 1973-11-12 1954-01-15 Tholand Nils Kristian Gustav Swedish Tourist Office 68 1942-07-27 Swedish Tourist Office 655 Third Avenue 18th Floor New York NY 10017
35642 35642 1973-11-12 1947-02-24 Lonegren Sigfrid K. Swedish Tourist Office 68 1942-07-27 Swedish Tourist Office 655 Third Avenue 18th Floor New York NY 10017
35643 35643 1973-11-12 1956-03-12 Malmstrom Lars Gosta Swedish Tourist Office 68 1942-07-27 Swedish Tourist Office 655 Third Avenue 18th Floor New York NY 10017
35645 35645 1973-11-12 1946-04-24 Henriknilert Tore Swedish Tourist Office 68 1942-07-27 Swedish Tourist Office 655 Third Avenue 18th Floor New York NY 10017
36633 36633 1977-11-30 1937-01-01 Prag Per Swedish Tourist Office 68 1942-07-27 Swedish Tourist Office 655 Third Avenue 18th Floor New York NY 10017
37371 37371 1983-12-01 1980-10-07 Conradi Trond Swedish Tourist Office 68 1942-07-27 Swedish Tourist Office 655 Third Avenue 18th Floor New York NY 10017
39687 39687 1960-12-31 1943-05-20 Nordholm Birger Josef Swedish Tourist Office 68 1942-07-27 Swedish Tourist Office 655 Third Avenue 18th Floor New York NY 10017
39886 39886 1970-12-31 1968-07-05 Moller Britt Marie Swedish Tourist Office 68 1942-07-27 Swedish Tourist Office 655 Third Avenue 18th Floor New York NY 10017
39908 39908 1972-12-31 1970-01-27 Munktell Agneta Swedish Tourist Office 68 1942-07-27 Swedish Tourist Office 655 Third Avenue 18th Floor New York NY 10017
39957 39957 1974-12-31 1973-02-22 Axen Per Ulrik Swedish Tourist Office 68 1942-07-27 Swedish Tourist Office 655 Third Avenue 18th Floor New York NY 10017
40004 40004 1976-12-31 1973-02-22 Malmstrom Ingred Astrid Louise Swedish Tourist Office 68 1942-07-27 Swedish Tourist Office 655 Third Avenue 18th Floor New York NY 10017
40477 40477 1988-12-31 1943-04-21 Johanneson Nils R. Swedish Tourist Office 68 1942-07-27 Swedish Tourist Office 655 Third Avenue 18th Floor New York NY 10017
40491 40491 1988-12-31 1943-05-20 Izard Forrest Swedish Tourist Office 68 1942-07-27 Swedish Tourist Office 655 Third Avenue 18th Floor New York NY 10017
40492 40492 1988-12-31 1943-05-20 Lundbeck G. Hilmer Swedish Tourist Office 68 1942-07-27 Swedish Tourist Office 655 Third Avenue 18th Floor New York NY 10017

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