FARA_All_ShortForms

Table actions
List of all short form registrants (active and terminated)

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

41 rows where Registration_Number = 568

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

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

State 1

Registration_Number 1

  • Italian Government Tourist Board, New York · 41 ✖

City 1

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
249 249   1992-01-31 Cenzuales Giovanni Italian Government Tourist Board, New York 568 1949-04-21 Italian Government Tourist Board, New York 686 Park Avenue 3rd Floor New York NY 10065
250 250   1992-01-31 Manassero Dennis Italian Government Tourist Board, New York 568 1949-04-21 Italian Government Tourist Board, New York 686 Park Avenue 3rd Floor New York NY 10065
251 251   1992-01-31 Scaldaferri Maria C. Italian Government Tourist Board, New York 568 1949-04-21 Italian Government Tourist Board, New York 686 Park Avenue 3rd Floor New York NY 10065
317 317   1988-02-05 Nardone Silverio Italian Government Tourist Board, New York 568 1949-04-21 Italian Government Tourist Board, New York 686 Park Avenue 3rd Floor New York NY 10065
572 572   1994-03-15 Petti Agostino Italian Government Tourist Board, New York 568 1949-04-21 Italian Government Tourist Board, New York 686 Park Avenue 3rd Floor New York NY 10065
1500 1500   1992-07-28 Talignani Robert Renato Italian Government Tourist Board, New York 568 1949-04-21 Italian Government Tourist Board, New York 686 Park Avenue 3rd Floor New York NY 10065
1971 1971   2017-10-17 Bortolin Marcia Italian Government Tourist Board, New York 568 1949-04-21 Italian Government Tourist Board, New York 686 Park Avenue 3rd Floor New York NY 10065
1972 1972   2017-10-17 Brazzini Francesco Italian Government Tourist Board, New York 568 1949-04-21 Italian Government Tourist Board, New York 686 Park Avenue 3rd Floor New York NY 10065
1973 1973   2017-10-17 Frasca Cosmo A. Italian Government Tourist Board, New York 568 1949-04-21 Italian Government Tourist Board, New York 686 Park Avenue 3rd Floor New York NY 10065
1974 1974   2017-10-17 Orlando Caterina Italian Government Tourist Board, New York 568 1949-04-21 Italian Government Tourist Board, New York 686 Park Avenue 3rd Floor New York NY 10065
1975 1975   2017-10-17 Sancilio Giuseppina Miranda Italian Government Tourist Board, New York 568 1949-04-21 Italian Government Tourist Board, New York 686 Park Avenue 3rd Floor New York NY 10065
6798 6798 1973-02-14 1964-01-27 Scala Pasquale Italian Government Tourist Board, New York 568 1949-04-21 Italian Government Tourist Board, New York 686 Park Avenue 3rd Floor New York NY 10065
6799 6799 1973-02-14 1949-04-04 Inzerillo Josephine Italian Government Tourist Board, New York 568 1949-04-21 Italian Government Tourist Board, New York 686 Park Avenue 3rd Floor New York NY 10065
6800 6800 1973-02-14 1967-12-20 Doelger Manolita T. Italian Government Tourist Board, New York 568 1949-04-21 Italian Government Tourist Board, New York 686 Park Avenue 3rd Floor New York NY 10065
6900 6900 1966-02-15 1964-01-27 Caretti Gianmaria Italian Government Tourist Board, New York 568 1949-04-21 Italian Government Tourist Board, New York 686 Park Avenue 3rd Floor New York NY 10065
11658 11658 1992-03-31 1992-01-31 Spagnol Franco Italian Government Tourist Board, New York 568 1949-04-21 Italian Government Tourist Board, New York 686 Park Avenue 3rd Floor New York NY 10065
11679 11679 1992-03-31 1975-09-25 Inzerillo Josephine Italian Government Tourist Board, New York 568 1949-04-21 Italian Government Tourist Board, New York 686 Park Avenue 3rd Floor New York NY 10065
12379 12379 1963-04-01 1958-08-12 Alost Aurelie Ann Italian Government Tourist Board, New York 568 1949-04-21 Italian Government Tourist Board, New York 686 Park Avenue 3rd Floor New York NY 10065
12712 12712 1954-04-04 1949-11-22 Cacaci Albert Italian Government Tourist Board, New York 568 1949-04-21 Italian Government Tourist Board, New York 686 Park Avenue 3rd Floor New York NY 10065
16695 16695 1993-05-19 1992-07-28 Gracci Alba B. Italian Government Tourist Board, New York 568 1949-04-21 Italian Government Tourist Board, New York 686 Park Avenue 3rd Floor New York NY 10065
16696 16696 1993-05-19 1990-08-07 Massimo Claudia Italian Government Tourist Board, New York 568 1949-04-21 Italian Government Tourist Board, New York 686 Park Avenue 3rd Floor New York NY 10065
20727 20727 1962-06-30 1952-05-21 Bentivoglio Giovanni Italian Government Tourist Board, New York 568 1949-04-21 Italian Government Tourist Board, New York 686 Park Avenue 3rd Floor New York NY 10065
20757 20757 1965-06-30 1956-03-16 Chilleri Luigi Ferdinando Italian Government Tourist Board, New York 568 1949-04-21 Italian Government Tourist Board, New York 686 Park Avenue 3rd Floor New York NY 10065
21168 21168 1992-06-30 1987-02-03 Baglioni Maria Antonietta Italian Government Tourist Board, New York 568 1949-04-21 Italian Government Tourist Board, New York 686 Park Avenue 3rd Floor New York NY 10065
21169 21169 1992-06-30 1987-02-03 Lombardi Umberto Italian Government Tourist Board, New York 568 1949-04-21 Italian Government Tourist Board, New York 686 Park Avenue 3rd Floor New York NY 10065
22515 22515 1969-07-03 1967-12-20 Zanzotto Tommaso Italian Government Tourist Board, New York 568 1949-04-21 Italian Government Tourist Board, New York 686 Park Avenue 3rd Floor New York NY 10065
24175 24175 1983-07-27 1971-01-31 Tommasi Emilio Italian Government Tourist Board, New York 568 1949-04-21 Italian Government Tourist Board, New York 686 Park Avenue 3rd Floor New York NY 10065
24659 24659 1969-07-31 1965-05-13 Guerrieri Renato Italian Government Tourist Board, New York 568 1949-04-21 Italian Government Tourist Board, New York 686 Park Avenue 3rd Floor New York NY 10065
25335 25335 2018-07-31 2017-10-17 Persampieri Salvatore Italian Government Tourist Board, New York 568 1949-04-21 Italian Government Tourist Board, New York 686 Park Avenue 3rd Floor New York NY 10065
26290 26290 2018-08-08 2017-10-17 La Ferrara Antonio Italian Government Tourist Board, New York 568 1949-04-21 Italian Government Tourist Board, New York 686 Park Avenue 3rd Floor New York NY 10065
26881 26881 1993-08-17 1992-01-31 Marino Teresa G. Italian Government Tourist Board, New York 568 1949-04-21 Italian Government Tourist Board, New York 686 Park Avenue 3rd Floor New York NY 10065
26882 26882 1993-08-17 1992-07-28 Coppola Pasqualina Italian Government Tourist Board, New York 568 1949-04-21 Italian Government Tourist Board, New York 686 Park Avenue 3rd Floor New York NY 10065
28839 28839 1986-09-01 1983-12-23 Gavio Lionello Italian Government Tourist Board, New York 568 1949-04-21 Italian Government Tourist Board, New York 686 Park Avenue 3rd Floor New York NY 10065
30806 30806 1952-09-30 1950-12-28 Theodoli Philip M. Italian Government Tourist Board, New York 568 1949-04-21 Italian Government Tourist Board, New York 686 Park Avenue 3rd Floor New York NY 10065
30841 30841 1962-09-30 1962-03-30 Siani Alfredo F. Italian Government Tourist Board, New York 568 1949-04-21 Italian Government Tourist Board, New York 686 Park Avenue 3rd Floor New York NY 10065
31792 31792 1964-10-01 1949-04-04 Doelger Manolita T. Italian Government Tourist Board, New York 568 1949-04-21 Italian Government Tourist Board, New York 686 Park Avenue 3rd Floor New York NY 10065
32232 32232 1954-10-04 1950-12-28 Naizzito Beatrice Italian Government Tourist Board, New York 568 1949-04-21 Italian Government Tourist Board, New York 686 Park Avenue 3rd Floor New York NY 10065
35782 35782 1954-11-15 1949-04-04 Bonelli Piero Italian Government Tourist Board, New York 568 1949-04-21 Italian Government Tourist Board, New York 686 Park Avenue 3rd Floor New York NY 10065
36372 36372 1991-11-25 1985-06-28 Colombo Vincenzo Italian Government Tourist Board, New York 568 1949-04-21 Italian Government Tourist Board, New York 686 Park Avenue 3rd Floor New York NY 10065
39511 39511 1950-12-31 1949-04-04 Beveridge Elisa Schiavoni Italian Government Tourist Board, New York 568 1949-04-21 Italian Government Tourist Board, New York 686 Park Avenue 3rd Floor New York NY 10065
39572 39572 1957-12-31 1957-02-04 Vittori Guido Italian Government Tourist Board, New York 568 1949-04-21 Italian Government Tourist Board, New York 686 Park Avenue 3rd Floor New York NY 10065

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