home / fara

Menu
  • Search all tables
  • GraphQL API

FARA_All_ShortForms

Table actions
  • GraphQL API for FARA_All_ShortForms
List of all short form registrants (active and terminated)

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

35 rows where Registrant_Name = "Swedish Information Service"

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

These facets timed out: Registration_Number

State 1

  • NY 35

Registrant_Name 1

  • Swedish Information Service · 35 ✖

City 1

  • New York 35
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
12350 12350 1946-04-01 1945-03-07 Lindahl Mac Olof Ernst Leonard Swedish Information Service 70 1942-07-28 Swedish Information Service 825 Third Avenue   New York NY 10022
12675 12675 1973-04-03 1968-04-26 Berggren Haakan Swedish Information Service 70 1942-07-28 Swedish Information Service 825 Third Avenue   New York NY 10022
19631 19631 1954-06-16 1950-08-25 Bergsten Beulah Eleanor Swedish Information Service 70 1942-07-28 Swedish Information Service 825 Third Avenue   New York NY 10022
20771 20771 1965-06-30 1964-12-15 Litell Richard John Swedish Information Service 70 1942-07-28 Swedish Information Service 825 Third Avenue   New York NY 10022
20783 20783 1966-06-30 1960-08-25 Malmstrom Lars Swedish Information Service 70 1942-07-28 Swedish Information Service 825 Third Avenue   New York NY 10022
20860 20860 1973-06-30 1963-01-02 Weisman Eli L. Swedish Information Service 70 1942-07-28 Swedish Information Service 825 Third Avenue   New York NY 10022
20862 20862 1973-06-30 1955-02-18 Nasholm Stig Daniel Swedish Information Service 70 1942-07-28 Swedish Information Service 825 Third Avenue   New York NY 10022
20863 20863 1973-06-30 1973-03-02 Usslar Evazvon Swedish Information Service 70 1942-07-28 Swedish Information Service 825 Third Avenue   New York NY 10022
20864 20864 1973-06-30 1955-03-08 Sydlowski Mildred Patricia Swedish Information Service 70 1942-07-28 Swedish Information Service 825 Third Avenue   New York NY 10022
20866 20866 1973-06-30 1947-03-14 Anderson Helen E. Swedish Information Service 70 1942-07-28 Swedish Information Service 825 Third Avenue   New York NY 10022
20867 20867 1973-06-30 1951-03-14 Horn Claes Johan Fredrik Swedish Information Service 70 1942-07-28 Swedish Information Service 825 Third Avenue   New York NY 10022
20868 20868 1973-06-30 1954-03-15 Nilert Tore Henrik Swedish Information Service 70 1942-07-28 Swedish Information Service 825 Third Avenue   New York NY 10022
20869 20869 1973-06-30 1948-03-24 Hansson Jenny Margitta Swedish Information Service 70 1942-07-28 Swedish Information Service 825 Third Avenue   New York NY 10022
20871 20871 1973-06-30 1947-04-02 Lundbeck G. Hilmer , Jr. Swedish Information Service 70 1942-07-28 Swedish Information Service 825 Third Avenue   New York NY 10022
20873 20873 1973-06-30 1970-05-13 Eneberg Brune Ivar Swedish Information Service 70 1942-07-28 Swedish Information Service 825 Third Avenue   New York NY 10022
20874 20874 1973-06-30 1951-05-21 Johaneson Nils Rudolf Swedish Information Service 70 1942-07-28 Swedish Information Service 825 Third Avenue   New York NY 10022
20875 20875 1973-06-30 1946-05-29 Ollen Olof Lennart Emanuel Swedish Information Service 70 1942-07-28 Swedish Information Service 825 Third Avenue   New York NY 10022
20876 20876 1973-06-30 1951-06-18 Johnson Ester Petersen Swedish Information Service 70 1942-07-28 Swedish Information Service 825 Third Avenue   New York NY 10022
20877 20877 1973-06-30 1947-08-01 Ekman Elon Viktor Swedish Information Service 70 1942-07-28 Swedish Information Service 825 Third Avenue   New York NY 10022
20878 20878 1973-06-30 1972-08-23 Holm Kjell Gunnar Swedish Information Service 70 1942-07-28 Swedish Information Service 825 Third Avenue   New York NY 10022
20879 20879 1973-06-30 1966-10-04 Heckscher Eva Swedish Information Service 70 1942-07-28 Swedish Information Service 825 Third Avenue   New York NY 10022
20881 20881 1973-06-30 1973-11-07 Ankarcrona Jacob Swedish Information Service 70 1942-07-28 Swedish Information Service 825 Third Avenue   New York NY 10022
20882 20882 1973-06-30 1973-11-07 Jarnegard Styrbjorn Swedish Information Service 70 1942-07-28 Swedish Information Service 825 Third Avenue   New York NY 10022
20883 20883 1973-06-30 1966-11-08 Feldt Marna Swedish Information Service 70 1942-07-28 Swedish Information Service 825 Third Avenue   New York NY 10022
22056 22056 1965-07-01 1945-03-07 Kastrup Hans Sture Allan Swedish Information Service 70 1942-07-28 Swedish Information Service 825 Third Avenue   New York NY 10022
24672 24672 1972-07-31 1968-02-21 Friberg Karin Swedish Information Service 70 1942-07-28 Swedish Information Service 825 Third Avenue   New York NY 10022
26992 26992 1966-08-19 1965-07-30 Odlander Ingemar Hertur Roland Swedish Information Service 70 1942-07-28 Swedish Information Service 825 Third Avenue   New York NY 10022
27873 27873 1969-08-31 1968-04-26 Beer G. Ulrica Blume Swedish Information Service 70 1942-07-28 Swedish Information Service 825 Third Avenue   New York NY 10022
34158 34158 1968-10-31 1968-04-26 Pretorius Stanley H. Swedish Information Service 70 1942-07-28 Swedish Information Service 825 Third Avenue   New York NY 10022
36619 36619 1971-11-30 1969-07-29 Johnsson Hans V.A. Swedish Information Service 70 1942-07-28 Swedish Information Service 825 Third Avenue   New York NY 10022
37300 37300 1972-12-01 1969-11-04 Tegnemark K.I. Margareta Swedish Information Service 70 1942-07-28 Swedish Information Service 825 Third Avenue   New York NY 10022
37576 37576 1954-12-02 1951-09-06 Alsen Nils Olof (Olle) Swedish Information Service 70 1942-07-28 Swedish Information Service 825 Third Avenue   New York NY 10022
37716 37716 1967-12-04 1965-07-30 Pers Anders Harald Swedish Information Service 70 1942-07-28 Swedish Information Service 825 Third Avenue   New York NY 10022
39727 39727 1962-12-31 1945-03-07 Lundbergh Holger Swedish Information Service 70 1942-07-28 Swedish Information Service 825 Third Avenue   New York NY 10022
39785 39785 1965-12-31 1963-04-17 Bolang Carl Olof Swedish Information Service 70 1942-07-28 Swedish Information Service 825 Third Avenue   New York NY 10022

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])
);
Powered by Datasette · Queries took 2876.397ms · 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