FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
31 rows where "Registration_Date" is on date 1943-03-01 and Registration_Number = 55
This data as json, CSV (advanced)
Suggested facets: Registration_Date (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1253 | 1253 | 2007-06-18 | Herrmann | Alexander | Switzerland Tourism 55 | 1943-03-01 | Switzerland Tourism | 608 Fifth Avenue | New York | NY | 10020-2303 | ||
1463 | 1463 | 2021-07-22 | Zemp | Claudio | Switzerland Tourism 55 | 1943-03-01 | Switzerland Tourism | 608 Fifth Avenue | New York | NY | 10020-2303 | ||
3613 | 3613 | 1973-01-12 | 1961-09-25 | Lehmann | Max Paul | Switzerland Tourism 55 | 1943-03-01 | Switzerland Tourism | 608 Fifth Avenue | New York | NY | 10020-2303 | |
5056 | 5056 | 1990-01-31 | 1971-07-14 | Isler | Willy | Switzerland Tourism 55 | 1943-03-01 | Switzerland Tourism | 608 Fifth Avenue | New York | NY | 10020-2303 | |
5067 | 5067 | 1991-01-31 | 1985-01-12 | Dulio | Bernardino | Switzerland Tourism 55 | 1943-03-01 | Switzerland Tourism | 608 Fifth Avenue | New York | NY | 10020-2303 | |
9378 | 9378 | 1973-03-07 | 1943-03-01 | Dossenbach | Frederick | Switzerland Tourism 55 | 1943-03-01 | Switzerland Tourism | 608 Fifth Avenue | New York | NY | 10020-2303 | |
9379 | 9379 | 1973-03-07 | 1943-09-28 | Dossenbach | Marie Widmer | Switzerland Tourism 55 | 1943-03-01 | Switzerland Tourism | 608 Fifth Avenue | New York | NY | 10020-2303 | |
11346 | 11346 | 1959-03-31 | 1944-02-02 | Pillichody | Henry | Switzerland Tourism 55 | 1943-03-01 | Switzerland Tourism | 608 Fifth Avenue | New York | NY | 10020-2303 | |
11426 | 11426 | 1972-03-31 | 1967-09-06 | Grandjean | Marcel J.-P. | Switzerland Tourism 55 | 1943-03-01 | Switzerland Tourism | 608 Fifth Avenue | New York | NY | 10020-2303 | |
11553 | 11553 | 1986-03-31 | 1982-09-17 | Fragniere | Marcel | Switzerland Tourism 55 | 1943-03-01 | Switzerland Tourism | 608 Fifth Avenue | New York | NY | 10020-2303 | |
14955 | 14955 | 2007-04-30 | 2004-07-08 | Enzler | Raphael Adrian | Switzerland Tourism 55 | 1943-03-01 | Switzerland Tourism | 608 Fifth Avenue | New York | NY | 10020-2303 | |
17768 | 17768 | 1993-05-31 | 1990-10-01 | Klee | Helmut Arthur | Switzerland Tourism 55 | 1943-03-01 | Switzerland Tourism | 608 Fifth Avenue | New York | NY | 10020-2303 | |
17945 | 17945 | 2001-05-31 | 1986-04-28 | Knoepfel | Monika | Switzerland Tourism 55 | 1943-03-01 | Switzerland Tourism | 608 Fifth Avenue | New York | NY | 10020-2303 | |
19837 | 19837 | 1953-06-19 | 1951-02-15 | Koelliker | Ernest A. | Switzerland Tourism 55 | 1943-03-01 | Switzerland Tourism | 608 Fifth Avenue | New York | NY | 10020-2303 | |
20676 | 20676 | 1957-06-30 | 1955-07-08 | Reed | Kenneth Milford , Jr. | Switzerland Tourism 55 | 1943-03-01 | Switzerland Tourism | 608 Fifth Avenue | New York | NY | 10020-2303 | |
20844 | 20844 | 1972-06-30 | 1969-01-22 | Egli | Gody | Switzerland Tourism 55 | 1943-03-01 | Switzerland Tourism | 608 Fifth Avenue | New York | NY | 10020-2303 | |
20930 | 20930 | 1978-06-30 | 1972-07-21 | Baroni | Bruno | Switzerland Tourism 55 | 1943-03-01 | Switzerland Tourism | 608 Fifth Avenue | New York | NY | 10020-2303 | |
21503 | 21503 | 2004-06-30 | 2000-07-18 | Eberhard | Urs | Switzerland Tourism 55 | 1943-03-01 | Switzerland Tourism | 608 Fifth Avenue | New York | NY | 10020-2303 | |
22745 | 22745 | 1967-07-08 | 1955-07-08 | Baertschi | Hans | Switzerland Tourism 55 | 1943-03-01 | Switzerland Tourism | 608 Fifth Avenue | New York | NY | 10020-2303 | |
24170 | 24170 | 1979-07-27 | 1973-08-07 | Zoebeli | Urs Christian | Switzerland Tourism 55 | 1943-03-01 | Switzerland Tourism | 608 Fifth Avenue | New York | NY | 10020-2303 | |
24691 | 24691 | 1978-07-31 | 1973-02-22 | Meier | Hana Rudolf | Switzerland Tourism 55 | 1943-03-01 | Switzerland Tourism | 608 Fifth Avenue | New York | NY | 10020-2303 | |
24802 | 24802 | 1990-07-31 | 1987-06-16 | Zoebeli | Urs Christian | Switzerland Tourism 55 | 1943-03-01 | Switzerland Tourism | 608 Fifth Avenue | New York | NY | 10020-2303 | |
27882 | 27882 | 1971-08-31 | 1943-09-28 | Scherer | William W. | Switzerland Tourism 55 | 1943-03-01 | Switzerland Tourism | 608 Fifth Avenue | New York | NY | 10020-2303 | |
28080 | 28080 | 1985-08-31 | 1983-01-20 | Zuffi | Enrico | Switzerland Tourism 55 | 1943-03-01 | Switzerland Tourism | 608 Fifth Avenue | New York | NY | 10020-2303 | |
33062 | 33062 | 1986-10-17 | 1982-09-17 | Ueltschi | Peter | Switzerland Tourism 55 | 1943-03-01 | Switzerland Tourism | 608 Fifth Avenue | New York | NY | 10020-2303 | |
34270 | 34270 | 1987-10-31 | 1986-10-28 | Senn | Daniel | Switzerland Tourism 55 | 1943-03-01 | Switzerland Tourism | 608 Fifth Avenue | New York | NY | 10020-2303 | |
37231 | 37231 | 1956-12-01 | 1953-10-19 | Birmann | Alfred werner Herbert | Switzerland Tourism 55 | 1943-03-01 | Switzerland Tourism | 608 Fifth Avenue | New York | NY | 10020-2303 | |
38928 | 38928 | 1977-12-22 | 1973-02-16 | Fueglister | Paul | Switzerland Tourism 55 | 1943-03-01 | Switzerland Tourism | 608 Fifth Avenue | New York | NY | 10020-2303 | |
39844 | 39844 | 1966-12-31 | 1965-09-23 | Spengler | Hans | Switzerland Tourism 55 | 1943-03-01 | Switzerland Tourism | 608 Fifth Avenue | New York | NY | 10020-2303 | |
40164 | 40164 | 1980-12-31 | 1968-09-05 | Bruderer | Walter | Switzerland Tourism 55 | 1943-03-01 | Switzerland Tourism | 608 Fifth Avenue | New York | NY | 10020-2303 | |
41154 | 41154 | 1999-12-31 | 1993-08-24 | Buhler | Joseph E. | Switzerland Tourism 55 | 1943-03-01 | Switzerland Tourism | 608 Fifth Avenue | New York | NY | 10020-2303 |
Advanced export
JSON shape: default, array, newline-delimited
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]) );