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

87 rows where Registration_Number = 574 and State = "NY"

✖
✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

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

State 1

  • NY · 87 ✖

Registration_Number 1

  • European Travel Commission · 87 ✖

Registrant_Name 1

  • European Travel Commission 87

City 1

  • New York 87
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
2503 2503 1954-01-01 1952-06-14 Axelos Christian A. European Travel Commission 574 1949-06-30 European Travel Commission c/o Spring O'Brien 30 West 26th Street, 4th Floor New York NY 10010
2707 2707 1991-01-01 1989-04-10 Hodes Stephen J. European Travel Commission 574 1949-06-30 European Travel Commission c/o Spring O'Brien 30 West 26th Street, 4th Floor New York NY 10010
2732 2732 1995-01-01 1993-08-09 Moustras Christos European Travel Commission 574 1949-06-30 European Travel Commission c/o Spring O'Brien 30 West 26th Street, 4th Floor New York NY 10010
2749 2749 1996-01-01 1995-08-14 Vella George N. European Travel Commission 574 1949-06-30 European Travel Commission c/o Spring O'Brien 30 West 26th Street, 4th Floor New York NY 10010
5036 5036 1989-01-31 1985-08-06 Raeymaekers Frederique European Travel Commission 574 1949-06-30 European Travel Commission c/o Spring O'Brien 30 West 26th Street, 4th Floor New York NY 10010
5205 5205 1999-01-31 1997-08-15 Hamblin Jeff European Travel Commission 574 1949-06-30 European Travel Commission c/o Spring O'Brien 30 West 26th Street, 4th Floor New York NY 10010
5274 5274 2003-01-31 2000-03-28 Gustavsson Einar European Travel Commission 574 1949-06-30 European Travel Commission c/o Spring O'Brien 30 West 26th Street, 4th Floor New York NY 10010
5689 5689 1973-02-01 1951-02-05 Dessau Axel Carl Julius European Travel Commission 574 1949-06-30 European Travel Commission c/o Spring O'Brien 30 West 26th Street, 4th Floor New York NY 10010
6493 6493 1958-02-10 1956-04-06 Matijasevic Scepan European Travel Commission 574 1949-06-30 European Travel Commission c/o Spring O'Brien 30 West 26th Street, 4th Floor New York NY 10010
6575 6575 1994-02-10 1987-02-19 Ford Donald L. European Travel Commission 574 1949-06-30 European Travel Commission c/o Spring O'Brien 30 West 26th Street, 4th Floor New York NY 10010
8078 8078 1997-02-28 1991-08-08 Raeymaekers Frederique European Travel Commission 574 1949-06-30 European Travel Commission c/o Spring O'Brien 30 West 26th Street, 4th Floor New York NY 10010
8732 8732 1979-03-01 1972-12-01 Bertram Johan George European Travel Commission 574 1949-06-30 European Travel Commission c/o Spring O'Brien 30 West 26th Street, 4th Floor New York NY 10010
11352 11352 1959-03-31 1949-06-06 Pillichody Henry European Travel Commission 574 1949-06-30 European Travel Commission c/o Spring O'Brien 30 West 26th Street, 4th Floor New York NY 10010
11378 11378 1962-03-31 1961-03-23 Atakent Ihsan European Travel Commission 574 1949-06-30 European Travel Commission c/o Spring O'Brien 30 West 26th Street, 4th Floor New York NY 10010
12089 12089 2011-03-31 2003-08-12 Franklin Rob European Travel Commission 574 1949-06-30 European Travel Commission c/o Spring O'Brien 30 West 26th Street, 4th Floor New York NY 10010
12093 12093 2011-03-31 2009-08-31 Perol Jean Philippe European Travel Commission 574 1949-06-30 European Travel Commission c/o Spring O'Brien 30 West 26th Street, 4th Floor New York NY 10010
12390 12390 1967-04-01 1949-06-30 Durnin Kevin European Travel Commission 574 1949-06-30 European Travel Commission c/o Spring O'Brien 30 West 26th Street, 4th Floor New York NY 10010
12426 12426 1978-04-01 1973-04-10 Dessau Axel European Travel Commission 574 1949-06-30 European Travel Commission c/o Spring O'Brien 30 West 26th Street, 4th Floor New York NY 10010
12430 12430 1981-04-01 1979-08-21 Bastian Anne European Travel Commission 574 1949-06-30 European Travel Commission c/o Spring O'Brien 30 West 26th Street, 4th Floor New York NY 10010
14409 14409 1950-04-30 1949-06-06 de Croisset Philippe Wiener European Travel Commission 574 1949-06-30 European Travel Commission c/o Spring O'Brien 30 West 26th Street, 4th Floor New York NY 10010
14444 14444 1964-04-30 1964-04-30 Bardy Rene European Travel Commission 574 1949-06-30 European Travel Commission c/o Spring O'Brien 30 West 26th Street, 4th Floor New York NY 10010
14464 14464 1968-04-30 1952-09-12 Ramo Herman Rudolf Kristian European Travel Commission 574 1949-06-30 European Travel Commission c/o Spring O'Brien 30 West 26th Street, 4th Floor New York NY 10010
15289 15289 1954-05-01 1951-02-05 Palmaro Marcel Auguste European Travel Commission 574 1949-06-30 European Travel Commission c/o Spring O'Brien 30 West 26th Street, 4th Floor New York NY 10010
15294 15294 1955-05-01 1949-06-06 Martens Fernand Jean-Frederic European Travel Commission 574 1949-06-30 European Travel Commission c/o Spring O'Brien 30 West 26th Street, 4th Floor New York NY 10010
16857 16857 1950-05-22 1950-05-22 Eren Nuri European Travel Commission 574 1949-06-30 European Travel Commission c/o Spring O'Brien 30 West 26th Street, 4th Floor New York NY 10010
16987 16987 1950-05-24 1949-03-24 Olsen Knut European Travel Commission 574 1949-06-30 European Travel Commission c/o Spring O'Brien 30 West 26th Street, 4th Floor New York NY 10010
18308 18308 1950-06-01 1949-04-05 Wolff Andre Bernard European Travel Commission 574 1949-06-30 European Travel Commission c/o Spring O'Brien 30 West 26th Street, 4th Floor New York NY 10010
18312 18312 1953-06-01 1951-03-30 de Manziarly Alexandre European Travel Commission 574 1949-06-30 European Travel Commission c/o Spring O'Brien 30 West 26th Street, 4th Floor New York NY 10010
18373 18373 1961-06-01 1956-04-06 Notari Josette European Travel Commission 574 1949-06-30 European Travel Commission c/o Spring O'Brien 30 West 26th Street, 4th Floor New York NY 10010
18785 18785 1952-06-04 1951-02-05 Roussos Stavros G. European Travel Commission 574 1949-06-30 European Travel Commission c/o Spring O'Brien 30 West 26th Street, 4th Floor New York NY 10010
18937 18937 1949-06-06 1949-06-06 Law Louis Stephen European Travel Commission 574 1949-06-30 European Travel Commission c/o Spring O'Brien 30 West 26th Street, 4th Floor New York NY 10010
18938 18938 1949-06-06 1949-06-06 Nordholm Birger Josef European Travel Commission 574 1949-06-30 European Travel Commission c/o Spring O'Brien 30 West 26th Street, 4th Floor New York NY 10010
18940 18940 1953-06-06 1952-07-14 Devereaux Ann Sill European Travel Commission 574 1949-06-30 European Travel Commission c/o Spring O'Brien 30 West 26th Street, 4th Floor New York NY 10010
19011 19011 1966-06-07 1965-05-07 Ulus Erdogan European Travel Commission 574 1949-06-30 European Travel Commission c/o Spring O'Brien 30 West 26th Street, 4th Floor New York NY 10010
20706 20706 1960-06-30 1958-07-08 Jason John Frees European Travel Commission 574 1949-06-30 European Travel Commission c/o Spring O'Brien 30 West 26th Street, 4th Floor New York NY 10010
23511 23511 1988-07-18 1951-02-26 Pillichody Olga Anna Broman European Travel Commission 574 1949-06-30 European Travel Commission c/o Spring O'Brien 30 West 26th Street, 4th Floor New York NY 10010
23512 23512 1988-07-18 1951-02-26 Turbayne James Terris European Travel Commission 574 1949-06-30 European Travel Commission c/o Spring O'Brien 30 West 26th Street, 4th Floor New York NY 10010
23513 23513 1988-07-18 1964-04-27 Gille Ake Leonard European Travel Commission 574 1949-06-30 European Travel Commission c/o Spring O'Brien 30 West 26th Street, 4th Floor New York NY 10010
23514 23514 1988-07-18 1960-05-05 Prag Per European Travel Commission 574 1949-06-30 European Travel Commission c/o Spring O'Brien 30 West 26th Street, 4th Floor New York NY 10010
23515 23515 1988-07-18 1965-05-07 Leventis Gregory P. European Travel Commission 574 1949-06-30 European Travel Commission c/o Spring O'Brien 30 West 26th Street, 4th Floor New York NY 10010
23516 23516 1988-07-18 1964-05-25 Perez Enrique Garcia-Herraiz European Travel Commission 574 1949-06-30 European Travel Commission c/o Spring O'Brien 30 West 26th Street, 4th Floor New York NY 10010
23520 23520 1988-07-18 1974-06-06 Lahti Raimo European Travel Commission 574 1949-06-30 European Travel Commission c/o Spring O'Brien 30 West 26th Street, 4th Floor New York NY 10010
23524 23524 1988-07-18 1965-07-27 Evans Francine Aimee (nee Houbet) European Travel Commission 574 1949-06-30 European Travel Commission c/o Spring O'Brien 30 West 26th Street, 4th Floor New York NY 10010
23525 23525 1988-07-18 1986-07-29 McSullivan Donal F. European Travel Commission 574 1949-06-30 European Travel Commission c/o Spring O'Brien 30 West 26th Street, 4th Floor New York NY 10010
23526 23526 1988-07-18 1979-09-14 Krueger Hermann European Travel Commission 574 1949-06-30 European Travel Commission c/o Spring O'Brien 30 West 26th Street, 4th Floor New York NY 10010
23527 23527 1988-07-18 1955-09-30 d'Andrade Jose Freire European Travel Commission 574 1949-06-30 European Travel Commission c/o Spring O'Brien 30 West 26th Street, 4th Floor New York NY 10010
23528 23528 1988-07-18 1972-10-12 Tommasi Dr. Emilio European Travel Commission 574 1949-06-30 European Travel Commission c/o Spring O'Brien 30 West 26th Street, 4th Floor New York NY 10010
23529 23529 1988-07-18 1957-10-28 De Maerel Peter A. European Travel Commission 574 1949-06-30 European Travel Commission c/o Spring O'Brien 30 West 26th Street, 4th Floor New York NY 10010
23530 23530 1988-07-18 1958-10-29 Loesch Yolande European Travel Commission 574 1949-06-30 European Travel Commission c/o Spring O'Brien 30 West 26th Street, 4th Floor New York NY 10010
23532 23532 1988-07-18 1966-11-16 Baumann Hans J. European Travel Commission 574 1949-06-30 European Travel Commission c/o Spring O'Brien 30 West 26th Street, 4th Floor New York NY 10010
23533 23533 1988-07-18 1965-11-22 Guerrieri Dr. Renato European Travel Commission 574 1949-06-30 European Travel Commission c/o Spring O'Brien 30 West 26th Street, 4th Floor New York NY 10010
23534 23534 1988-07-18 1966-12-12 Mattesich Rudolf F. European Travel Commission 574 1949-06-30 European Travel Commission c/o Spring O'Brien 30 West 26th Street, 4th Floor New York NY 10010
23535 23535 1988-07-18 1966-12-15 Surmelioglu Naime Hande European Travel Commission 574 1949-06-30 European Travel Commission c/o Spring O'Brien 30 West 26th Street, 4th Floor New York NY 10010
25437 25437 1954-08-01 1951-02-26 Baumann Karl A. European Travel Commission 574 1949-06-30 European Travel Commission c/o Spring O'Brien 30 West 26th Street, 4th Floor New York NY 10010
25459 25459 1966-08-01 1961-03-23 Pudar Stojan European Travel Commission 574 1949-06-30 European Travel Commission c/o Spring O'Brien 30 West 26th Street, 4th Floor New York NY 10010
26319 26319 1993-08-09 1986-08-15 Janaillac Jean-Marc European Travel Commission 574 1949-06-30 European Travel Commission c/o Spring O'Brien 30 West 26th Street, 4th Floor New York NY 10010
28741 28741 1957-09-01 1953-08-06 Watt Donald Beates , Jr. European Travel Commission 574 1949-06-30 European Travel Commission c/o Spring O'Brien 30 West 26th Street, 4th Floor New York NY 10010
28747 28747 1960-09-01 1957-06-03 Alphand Andre European Travel Commission 574 1949-06-30 European Travel Commission c/o Spring O'Brien 30 West 26th Street, 4th Floor New York NY 10010
28751 28751 1960-09-01 1960-08-08 Baertschi Hans European Travel Commission 574 1949-06-30 European Travel Commission c/o Spring O'Brien 30 West 26th Street, 4th Floor New York NY 10010
28785 28785 1972-09-01 1971-02-26 Ditrie Jacques European Travel Commission 574 1949-06-30 European Travel Commission c/o Spring O'Brien 30 West 26th Street, 4th Floor New York NY 10010
28807 28807 1979-09-01 1972-10-16 Sauvayre George European Travel Commission 574 1949-06-30 European Travel Commission c/o Spring O'Brien 30 West 26th Street, 4th Floor New York NY 10010
30847 30847 1964-09-30 1949-06-06 Doelger Manolita Thompson European Travel Commission 574 1949-06-30 European Travel Commission c/o Spring O'Brien 30 West 26th Street, 4th Floor New York NY 10010
30964 30964 1984-09-30 1984-06-27 Lovschal Steen I. European Travel Commission 574 1949-06-30 European Travel Commission c/o Spring O'Brien 30 West 26th Street, 4th Floor New York NY 10010
31762 31762 1950-10-01 1949-08-12 Brandvik Johan Mathius European Travel Commission 574 1949-06-30 European Travel Commission c/o Spring O'Brien 30 West 26th Street, 4th Floor New York NY 10010
31768 31768 1956-10-01 1956-04-06 Vivier Daniel A. Le Roy du European Travel Commission 574 1949-06-30 European Travel Commission c/o Spring O'Brien 30 West 26th Street, 4th Floor New York NY 10010
31866 31866 1982-10-01 1979-08-31 Haralambopoulos Harry European Travel Commission 574 1949-06-30 European Travel Commission c/o Spring O'Brien 30 West 26th Street, 4th Floor New York NY 10010
34794 34794 1954-11-01 1951-02-05 Simonsen Svein Erlend Winge European Travel Commission 574 1949-06-30 European Travel Commission c/o Spring O'Brien 30 West 26th Street, 4th Floor New York NY 10010
34829 34829 1965-11-01 1961-11-21 Dias Jorge Carlos Lopez Goncalves European Travel Commission 574 1949-06-30 European Travel Commission c/o Spring O'Brien 30 West 26th Street, 4th Floor New York NY 10010
35934 35934 1973-11-16 1967-07-18 Valadao Ramiro European Travel Commission 574 1949-06-30 European Travel Commission c/o Spring O'Brien 30 West 26th Street, 4th Floor New York NY 10010
36624 36624 1972-11-30 1972-11-01 Patzak Heinz European Travel Commission 574 1949-06-30 European Travel Commission c/o Spring O'Brien 30 West 26th Street, 4th Floor New York NY 10010
37222 37222 1954-12-01 1953-07-17 Prevosek Bozidar European Travel Commission 574 1949-06-30 European Travel Commission c/o Spring O'Brien 30 West 26th Street, 4th Floor New York NY 10010
37229 37229 1956-12-01 1954-03-15 de Koenigswarter Jules European Travel Commission 574 1949-06-30 European Travel Commission c/o Spring O'Brien 30 West 26th Street, 4th Floor New York NY 10010
37246 37246 1962-12-01 1949-04-21 Mattesich Rudolf F. European Travel Commission 574 1949-06-30 European Travel Commission c/o Spring O'Brien 30 West 26th Street, 4th Floor New York NY 10010
37251 37251 1963-12-01 1955-04-07 Baumann Hans J. European Travel Commission 574 1949-06-30 European Travel Commission c/o Spring O'Brien 30 West 26th Street, 4th Floor New York NY 10010
37814 37814 1952-12-06 1951-02-26 Stone Gil European Travel Commission 574 1949-06-30 European Travel Commission c/o Spring O'Brien 30 West 26th Street, 4th Floor New York NY 10010
37815 37815 1957-12-06 1951-04-03 Staudt Corneille European Travel Commission 574 1949-06-30 European Travel Commission c/o Spring O'Brien 30 West 26th Street, 4th Floor New York NY 10010
39664 39664 1959-12-31 1950-01-11 van der Laan Foeko Hendrik Wiebe European Travel Commission 574 1949-06-30 European Travel Commission c/o Spring O'Brien 30 West 26th Street, 4th Floor New York NY 10010
39675 39675 1959-12-31 1955-08-30 Koefoed Henning European Travel Commission 574 1949-06-30 European Travel Commission c/o Spring O'Brien 30 West 26th Street, 4th Floor New York NY 10010
39691 39691 1960-12-31 1960-08-03 Manyas Nezih European Travel Commission 574 1949-06-30 European Travel Commission c/o Spring O'Brien 30 West 26th Street, 4th Floor New York NY 10010
39695 39695 1960-12-31 1958-09-08 Popovic Dr. Vouislav European Travel Commission 574 1949-06-30 European Travel Commission c/o Spring O'Brien 30 West 26th Street, 4th Floor New York NY 10010
39776 39776 1964-12-31 1963-05-14 Dogancay Dr. Burhan European Travel Commission 574 1949-06-30 European Travel Commission c/o Spring O'Brien 30 West 26th Street, 4th Floor New York NY 10010
39971 39971 1974-12-31 1973-11-07 Mrkela Djuro European Travel Commission 574 1949-06-30 European Travel Commission c/o Spring O'Brien 30 West 26th Street, 4th Floor New York NY 10010
40765 40765 1993-12-31 1991-08-08 Bouquier Michel European Travel Commission 574 1949-06-30 European Travel Commission c/o Spring O'Brien 30 West 26th Street, 4th Floor New York NY 10010
41104 41104 1998-12-31 1996-09-03 Boye-Moeller Jarl European Travel Commission 574 1949-06-30 European Travel Commission c/o Spring O'Brien 30 West 26th Street, 4th Floor New York NY 10010
41153 41153 1999-12-31 1999-08-20 Buhler Joseph E. European Travel Commission 574 1949-06-30 European Travel Commission c/o Spring O'Brien 30 West 26th Street, 4th Floor New York NY 10010
41272 41272 2002-12-31 1999-08-20 Costa Frederico European Travel Commission 574 1949-06-30 European Travel Commission c/o Spring O'Brien 30 West 26th Street, 4th Floor New York NY 10010
41630 41630 2008-12-31 2003-08-12 Raeymaekers Frederique European Travel Commission 574 1949-06-30 European Travel Commission c/o Spring O'Brien 30 West 26th Street, 4th Floor New York NY 10010

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