List of all short form registrants (active and terminated)

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

30 rows where Registration_Number = 55

View and edit SQL

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

State

Registration_Number

Registrant_Name

City

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
969   2007-06-18 Herrmann Alexander 55 55 1943-03-01 Switzerland Tourism 608 Fifth Avenue   New York NY 10020-2303
3317 1973-01-12 1961-09-25 Lehmann Max Paul 55 55 1943-03-01 Switzerland Tourism 608 Fifth Avenue   New York NY 10020-2303
4692 1990-01-31 1971-07-14 Isler Willy 55 55 1943-03-01 Switzerland Tourism 608 Fifth Avenue   New York NY 10020-2303
4703 1991-01-31 1985-01-12 Dulio Bernardino 55 55 1943-03-01 Switzerland Tourism 608 Fifth Avenue   New York NY 10020-2303
8810 1973-03-07 1943-03-01 Dossenbach Frederick 55 55 1943-03-01 Switzerland Tourism 608 Fifth Avenue   New York NY 10020-2303
8811 1973-03-07 1943-09-28 Dossenbach Marie Widmer 55 55 1943-03-01 Switzerland Tourism 608 Fifth Avenue   New York NY 10020-2303
10713 1959-03-31 1944-02-02 Pillichody Henry 55 55 1943-03-01 Switzerland Tourism 608 Fifth Avenue   New York NY 10020-2303
10793 1972-03-31 1967-09-06 Grandjean Marcel J.-P. 55 55 1943-03-01 Switzerland Tourism 608 Fifth Avenue   New York NY 10020-2303
10920 1986-03-31 1982-09-17 Fragniere Marcel 55 55 1943-03-01 Switzerland Tourism 608 Fifth Avenue   New York NY 10020-2303
14147 2007-04-30 2004-07-08 Enzler Raphael Adrian 55 55 1943-03-01 Switzerland Tourism 608 Fifth Avenue   New York NY 10020-2303
16784 1993-05-31 1990-10-01 Klee Helmut Arthur 55 55 1943-03-01 Switzerland Tourism 608 Fifth Avenue   New York NY 10020-2303
16961 2001-05-31 1986-04-28 Knoepfel Monika 55 55 1943-03-01 Switzerland Tourism 608 Fifth Avenue   New York NY 10020-2303
18726 1953-06-19 1951-02-15 Koelliker Ernest A. 55 55 1943-03-01 Switzerland Tourism 608 Fifth Avenue   New York NY 10020-2303
19553 1957-06-30 1955-07-08 Reed Kenneth Milford , Jr. 55 55 1943-03-01 Switzerland Tourism 608 Fifth Avenue   New York NY 10020-2303
19721 1972-06-30 1969-01-22 Egli Gody 55 55 1943-03-01 Switzerland Tourism 608 Fifth Avenue   New York NY 10020-2303
19807 1978-06-30 1972-07-21 Baroni Bruno 55 55 1943-03-01 Switzerland Tourism 608 Fifth Avenue   New York NY 10020-2303
20380 2004-06-30 2000-07-18 Eberhard Urs 55 55 1943-03-01 Switzerland Tourism 608 Fifth Avenue   New York NY 10020-2303
21498 1967-07-08 1955-07-08 Baertschi Hans 55 55 1943-03-01 Switzerland Tourism 608 Fifth Avenue   New York NY 10020-2303
22878 1979-07-27 1973-08-07 Zoebeli Urs Christian 55 55 1943-03-01 Switzerland Tourism 608 Fifth Avenue   New York NY 10020-2303
23366 1978-07-31 1973-02-22 Meier Hana Rudolf 55 55 1943-03-01 Switzerland Tourism 608 Fifth Avenue   New York NY 10020-2303
23477 1990-07-31 1987-06-16 Zoebeli Urs Christian 55 55 1943-03-01 Switzerland Tourism 608 Fifth Avenue   New York NY 10020-2303
26443 1971-08-31 1943-09-28 Scherer William W. 55 55 1943-03-01 Switzerland Tourism 608 Fifth Avenue   New York NY 10020-2303
26641 1985-08-31 1983-01-20 Zuffi Enrico 55 55 1943-03-01 Switzerland Tourism 608 Fifth Avenue   New York NY 10020-2303
31444 1986-10-17 1982-09-17 Ueltschi Peter 55 55 1943-03-01 Switzerland Tourism 608 Fifth Avenue   New York NY 10020-2303
32623 1987-10-31 1986-10-28 Senn Daniel 55 55 1943-03-01 Switzerland Tourism 608 Fifth Avenue   New York NY 10020-2303
35443 1956-12-01 1953-10-19 Birmann Alfred werner Herbert 55 55 1943-03-01 Switzerland Tourism 608 Fifth Avenue   New York NY 10020-2303
37073 1977-12-22 1973-02-16 Fueglister Paul 55 55 1943-03-01 Switzerland Tourism 608 Fifth Avenue   New York NY 10020-2303
37979 1966-12-31 1965-09-23 Spengler Hans 55 55 1943-03-01 Switzerland Tourism 608 Fifth Avenue   New York NY 10020-2303
38299 1980-12-31 1968-09-05 Bruderer Walter 55 55 1943-03-01 Switzerland Tourism 608 Fifth Avenue   New York NY 10020-2303
39289 1999-12-31 1993-08-24 Buhler Joseph E. 55 55 1943-03-01 Switzerland Tourism 608 Fifth Avenue   New York NY 10020-2303

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