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

28 rows where Registration_Number = 2052

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

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

State 1

  • NY 28

Registration_Number 1

  • Alpine Tourist Office · 28 ✖

Registrant_Name 1

  • Alpine Tourist Office 28

City 1

  • New York 28
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
2641 2641 1986-01-01 1976-09-07 Krueger Hermann Alpine Tourist Office 2052 1967-09-27 Alpine Tourist Office C/O Austrian Tourist Office, Inc. 608 Fifth Avenue New York NY 10020
6432 6432 2017-02-08 2015-08-14 Herrmann Alexander Alpine Tourist Office 2052 1967-09-27 Alpine Tourist Office C/O Austrian Tourist Office, Inc. 608 Fifth Avenue New York NY 10020
6878 6878 2014-02-14 2008-06-05 Gigl Michael Alpine Tourist Office 2052 1967-09-27 Alpine Tourist Office C/O Austrian Tourist Office, Inc. 608 Fifth Avenue New York NY 10020
10374 10374 1978-03-20 1976-06-15 Tommasi Emilio Alpine Tourist Office 2052 1967-09-27 Alpine Tourist Office C/O Austrian Tourist Office, Inc. 608 Fifth Avenue New York NY 10020
10866 10866 1986-03-27 1976-10-01 Klee Helmut Alpine Tourist Office 2052 1967-09-27 Alpine Tourist Office C/O Austrian Tourist Office, Inc. 608 Fifth Avenue New York NY 10020
11116 11116 1973-03-30 1970-06-04 Djuranovic Vojislav Alpine Tourist Office 2052 1967-09-27 Alpine Tourist Office C/O Austrian Tourist Office, Inc. 608 Fifth Avenue New York NY 10020
11835 11835 2000-03-31 1998-04-20 Pio Trippa Dott. Alpine Tourist Office 2052 1967-09-27 Alpine Tourist Office C/O Austrian Tourist Office, Inc. 608 Fifth Avenue New York NY 10020
14956 14956 2007-04-30 2004-07-27 Enzler Raphael Alpine Tourist Office 2052 1967-09-27 Alpine Tourist Office C/O Austrian Tourist Office, Inc. 608 Fifth Avenue New York NY 10020
21498 21498 2004-06-30 2001-04-09 Eberhard Urs Alpine Tourist Office 2052 1967-09-27 Alpine Tourist Office C/O Austrian Tourist Office, Inc. 608 Fifth Avenue New York NY 10020
24793 24793 1990-07-31 1989-04-04 Zoebeli Urs Christian Alpine Tourist Office 2052 1967-09-27 Alpine Tourist Office C/O Austrian Tourist Office, Inc. 608 Fifth Avenue New York NY 10020
28911 28911 1996-09-01 1995-07-03 Winkler Anton Alpine Tourist Office 2052 1967-09-27 Alpine Tourist Office C/O Austrian Tourist Office, Inc. 608 Fifth Avenue New York NY 10020
31858 31858 1980-10-01 1973-06-16 Patzak Heinz Alpine Tourist Office 2052 1967-09-27 Alpine Tourist Office C/O Austrian Tourist Office, Inc. 608 Fifth Avenue New York NY 10020
34159 34159 1968-10-31 1969-05-21 Bardy Rene Alpine Tourist Office 2052 1967-09-27 Alpine Tourist Office C/O Austrian Tourist Office, Inc. 608 Fifth Avenue New York NY 10020
37279 37279 1969-12-01 1967-12-04 Baumann Hans J. Alpine Tourist Office 2052 1967-09-27 Alpine Tourist Office C/O Austrian Tourist Office, Inc. 608 Fifth Avenue New York NY 10020
37280 37280 1969-12-01 1967-12-04 Guerrieri Renato Alpine Tourist Office 2052 1967-09-27 Alpine Tourist Office C/O Austrian Tourist Office, Inc. 608 Fifth Avenue New York NY 10020
39876 39876 1969-12-31 1968-09-03 Mattesich Rudolph F. Alpine Tourist Office 2052 1967-09-27 Alpine Tourist Office C/O Austrian Tourist Office, Inc. 608 Fifth Avenue New York NY 10020
39882 39882 1970-12-31 1970-02-09 Tommasi Emilio Alpine Tourist Office 2052 1967-09-27 Alpine Tourist Office C/O Austrian Tourist Office, Inc. 608 Fifth Avenue New York NY 10020
39885 39885 1970-12-31 1970-06-04 Egli Gody Alpine Tourist Office 2052 1967-09-27 Alpine Tourist Office C/O Austrian Tourist Office, Inc. 608 Fifth Avenue New York NY 10020
39922 39922 1972-12-31 1970-06-04 Born Claus J. Alpine Tourist Office 2052 1967-09-27 Alpine Tourist Office C/O Austrian Tourist Office, Inc. 608 Fifth Avenue New York NY 10020
39929 39929 1972-12-31 1967-12-04 Lehmann Max P. Alpine Tourist Office 2052 1967-09-27 Alpine Tourist Office C/O Austrian Tourist Office, Inc. 608 Fifth Avenue New York NY 10020
39936 39936 1973-12-31 1973-03-16 Tery Joseph A. Alpine Tourist Office 2052 1967-09-27 Alpine Tourist Office C/O Austrian Tourist Office, Inc. 608 Fifth Avenue New York NY 10020
39946 39946 1973-12-31 1973-06-16 Bruderer Walter Alpine Tourist Office 2052 1967-09-27 Alpine Tourist Office C/O Austrian Tourist Office, Inc. 608 Fifth Avenue New York NY 10020
39979 39979 1975-12-31 1973-06-16 Baroni Bruno Alpine Tourist Office 2052 1967-09-27 Alpine Tourist Office C/O Austrian Tourist Office, Inc. 608 Fifth Avenue New York NY 10020
39981 39981 1975-12-31 1974-06-24 Mrkela Djuro Alpine Tourist Office 2052 1967-09-27 Alpine Tourist Office C/O Austrian Tourist Office, Inc. 608 Fifth Avenue New York NY 10020
40503 40503 1988-12-31 1974-06-26 Andrews John Paul Alpine Tourist Office 2052 1967-09-27 Alpine Tourist Office C/O Austrian Tourist Office, Inc. 608 Fifth Avenue New York NY 10020
41133 41133 1999-12-31 1998-04-20 Buhler Joseph E. Alpine Tourist Office 2052 1967-09-27 Alpine Tourist Office C/O Austrian Tourist Office, Inc. 608 Fifth Avenue New York NY 10020
41185 41185 2000-12-31 1998-04-20 Neuhold Erich Alpine Tourist Office 2052 1967-09-27 Alpine Tourist Office C/O Austrian Tourist Office, Inc. 608 Fifth Avenue New York NY 10020
41555 41555 2007-12-31 2007-06-18 Herrmann Alexander Alpine Tourist Office 2052 1967-09-27 Alpine Tourist Office C/O Austrian Tourist Office, Inc. 608 Fifth Avenue New York NY 10020

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 496.114ms · 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