home / fara

Menu
  • Search all tables
  • GraphQL API

FARA_All_ForeignPrincipals

Table actions
  • GraphQL API for FARA_All_ForeignPrincipals
List of all foreign principals (active and terminated)

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

39 rows where Country/Location_Represented = "ITALY" and State = "NY"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Registration_Number, Registrant_Date, Address_1, Zip, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)

Registrant_Name 29

  • Association Films, Inc. 4
  • North American Precis Syndicate 4
  • Hill and Knowlton Strategies, LLC 2
  • International Council of Cruise Lines 2
  • Keating Group, Inc. 2
  • Kelly, Nason, Inc. 2
  • Basti Associates 1
  • CIT Travel Service, Inc. 1
  • De Guinzbourg, Victor 1
  • De Mejo, Oscar 1
  • Development Counsellors International, Ltd. 1
  • Dickstein Shapiro, LLP 1
  • Donald N. Martin & Company, Inc. 1
  • Dorf & Stanton Communications 1
  • Express Trading Corporation 1
  • Finley, McDermott & Company 1
  • Gardner Advertising Company, Inc. 1
  • Gaynor & Ducas, Division of Gaynor & Company, Inc. 1
  • Gold & Liebengood, Inc. 1
  • Martial & Company, Inc. 1
  • McCann-Erickson, Inc. 1
  • Modern Education Services, Inc. 1
  • Montana, Vanni Buscemi 1
  • Motivational Communications, Inc. 1
  • Peter Rothholz Associates, Inc. 1
  • Project Associates UK Ltd. 1
  • Rogers & Wells, LLP 1
  • Schoenfeld Film Distribution Corporation 1
  • Van Brunt & Company Advertising-Marketing, Inc. 1

Foreign_Principal 27

  • Italian Trade Commission 6
  • Italian Government Travel Office 3
  • Italian Line 3
  • Italian State Tourist Office 3
  • Italian Government Tourist Office 2
  • Adriatica Line 1
  • Alitalia 1
  • Alitalia Airlines 1
  • Alitalia Airlines, Linee Aeree Italiane S.p.A. 1
  • Alitalia-Linee Aeree Italiane, S.p.A. 1
  • Finmeccanica North America 1
  • Giovanni Runtich (Runexim) 1
  • Giuseppe, Mario, Celestino Tieri 1
  • Hill & Knowlton for the Italian Tourist Office 1
  • International Gold Corporation, Ltd. 1
  • Italcable U.S.A., Inc. 1
  • Italian Airlines 1
  • Italian Commercial Consulate of New York 1
  • Italian Counsellors International, U.S. Representative for Mezzogiorno Office 1
  • Italian Government Tourist Office (IGTO) 1
  • Italian Line Cruises International 1
  • Italian National Tourist Office 1
  • Italian State Tourist Office (ENIT) 1
  • Italian Wine Council 1
  • Italian Wine Promotion Center 1
  • Office of the Permanent Observer of the Holy See to the United Nations 1
  • Permanent Mission of Italy to the United Nations 1

City 2

  • - 38
  • New York 1

State 1

  • NY · 39 ✖

Country/Location_Represented 1

  • ITALY · 39 ✖
Link rowid ▼ Foreign_Principal_Termination_Date Foreign_Principal Foreign_Principal_Registration_Date Country/Location_Represented Registration_Number Registrant_Date Registrant_Name Address_1 Address_2 City State Zip
816 816 1973-01-01 Alitalia Airlines, Linee Aeree Italiane S.p.A. 1960-08-12 ITALY Gardner Advertising Company, Inc. 1385 1960-08-12 Gardner Advertising Company, Inc. New York     NY  
1192 1192 1994-01-10 Italian Trade Commission 1992-07-17 ITALY Rogers & Wells, LLP 3428 1982-12-10 Rogers & Wells, LLP New York     NY  
1402 1402 1994-01-18 Italian Trade Commission 1991-06-04 ITALY Finley, McDermott & Company 4523 1991-06-04 Finley, McDermott & Company New York     NY  
1475 1475 1992-01-23 Finmeccanica North America 1991-01-24 ITALY Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC New York     NY  
1493 1493 1986-01-24 Italcable U.S.A., Inc. 1982-06-02 ITALY Dickstein Shapiro, LLP 3028 1979-06-07 Dickstein Shapiro, LLP New York     NY  
1693 1693 1971-01-31 Italian State Tourist Office 1964-07-15 ITALY Donald N. Martin & Company, Inc. 1381 1960-07-29 Donald N. Martin & Company, Inc. New York     NY  
2343 2343 1959-02-10 Alitalia 1958-10-22 ITALY Martial & Company, Inc. 1182 1958-10-22 Martial & Company, Inc. New York     NY  
3840 3840 1983-03-17 Italian Government Tourist Office 1975-11-26 ITALY Modern Education Services, Inc. 1803 1964-10-19 Modern Education Services, Inc.       NY  
4598 4598 2001-03-31 Italian Trade Commission 2001-02-05 ITALY Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC Fashion Center 499 Park Avenue New York 10022     NY  
4893 4893 1985-04-01 Italian Trade Commission 1978-05-02 ITALY Van Brunt & Company Advertising-Marketing, Inc. 1704 1964-04-02 Van Brunt & Company Advertising-Marketing, Inc. New York     NY  
4914 4914 1988-04-01 Italian Trade Commission 1983-05-17 ITALY Dorf & Stanton Communications 3471 1983-05-17 Dorf & Stanton Communications New York     NY  
5323 5323 1986-04-16 International Gold Corporation, Ltd. 1985-07-09 ITALY Gold & Liebengood, Inc. 3700 1985-07-09 Gold & Liebengood, Inc. New York     NY  
5342 5342 1969-04-17 Office of the Permanent Observer of the Holy See to the United Nations 1968-10-17 ITALY De Guinzbourg, Victor 2107 1968-10-17 De Guinzbourg, Victor New York     NY  
5804 5804 1975-04-30 Italian Line 1974-07-02 ITALY Keating Group, Inc. 2478 1973-11-23 Keating Group, Inc. New York     NY  
6370 6370 2022-05-06 Permanent Mission of Italy to the United Nations 2021-10-06 ITALY Project Associates UK Ltd. 7024 2021-10-06 Project Associates UK Ltd. 885 2nd Avenue, 49th Floor   New York NY 10017
6477 6477 1993-05-12 Hill & Knowlton for the Italian Tourist Office 1993-01-14 ITALY North American Precis Syndicate 2836 1977-10-12 North American Precis Syndicate New York     NY  
6641 6641 1979-05-18 Italian Government Travel Office 1979-05-03 ITALY Gaynor & Ducas, Division of Gaynor & Company, Inc. 3017 1979-05-03 Gaynor & Ducas, Division of Gaynor & Company, Inc. New York     NY  
7041 7041 1970-05-31 Italian Line 1967-09-19 ITALY Association Films, Inc. 1814 1964-11-06 Association Films, Inc. New York City     NY  
7555 7555 1952-06-04 Giuseppe, Mario, Celestino Tieri 1947-06-04 ITALY CIT Travel Service, Inc. 465 1947-06-04 CIT Travel Service, Inc. New York     NY  
7762 7762 1978-06-12 Italian Government Tourist Office (IGTO) 1978-06-12 ITALY Basti Associates 2913 1978-06-12 Basti Associates New York     NY  
8051 8051 1953-06-24 Giovanni Runtich (Runexim) 1961-06-25 ITALY Express Trading Corporation 678 1951-06-25 Express Trading Corporation New York     NY  
8302 8302 1976-06-30 Alitalia Airlines 1973-04-17 ITALY Association Films, Inc. 1814 1964-11-06 Association Films, Inc. New York City     NY  
8304 8304 1976-06-30 Italian Line 1967-07-25 ITALY International Council of Cruise Lines 2036 1967-07-25 International Council of Cruise Lines New York     NY  
8321 8321 1978-06-30 Italian Wine Promotion Center 1978-07-04 ITALY Peter Rothholz Associates, Inc. 2830 1977-09-16 Peter Rothholz Associates, Inc. New York     NY  
8327 8327 1979-06-30 Italian Government Travel Office 1967-10-16 ITALY Schoenfeld Film Distribution Corporation 2056 1967-10-16 Schoenfeld Film Distribution Corporation       NY  
8333 8333 1980-06-30 Italian Line Cruises International 1979-05-14 ITALY International Council of Cruise Lines 2036 1967-07-25 International Council of Cruise Lines New York     NY  
8852 8852 1980-07-01 Italian Government Travel Office 1975-04-07 ITALY Motivational Communications, Inc. 2571 1975-04-07 Motivational Communications, Inc. New York     NY  
9676 9676 1964-07-31 Italian Airlines 1953-09-18 ITALY Kelly, Nason, Inc. 71 1942-07-30 Kelly, Nason, Inc. New York     NY  
9677 9677 1964-07-31 Italian National Tourist Office 1950-03-24 ITALY Kelly, Nason, Inc. 71 1942-07-30 Kelly, Nason, Inc. New York     NY  
10895 10895 1977-08-31 Italian State Tourist Office 1964-06-02 ITALY McCann-Erickson, Inc. 1746 1964-06-02 McCann-Erickson, Inc. New York     NY  
10904 10904 1981-08-31 Alitalia-Linee Aeree Italiane, S.p.A. 1965-06-29 ITALY Association Films, Inc. 1814 1964-11-06 Association Films, Inc. New York City     NY  
10934 10934 1981-08-31 Italian State Tourist Office 1964-11-06 ITALY Association Films, Inc. 1814 1964-11-06 Association Films, Inc. New York City     NY  
12622 12622 1986-10-12 Italian Wine Council 1985-11-05 ITALY North American Precis Syndicate 2836 1977-10-12 North American Precis Syndicate       NY  
13020 13020 1989-10-25 Italian Trade Commission 1987-10-22 ITALY North American Precis Syndicate 2836 1977-10-12 North American Precis Syndicate       NY  
13594 13594 1991-11-01 Italian Government Tourist Office 1991-10-10 ITALY North American Precis Syndicate 2836 1977-10-12 North American Precis Syndicate New York     NY  
14621 14621 1964-12-01 Italian Commercial Consulate of New York 1964-04-07 ITALY De Mejo, Oscar 1706 1964-04-07 De Mejo, Oscar New York     NY  
14648 14648 1975-12-01 Adriatica Line 1974-12-31 ITALY Keating Group, Inc. 2478 1973-11-23 Keating Group, Inc. New York     NY  
15663 15663 1968-12-31 Italian State Tourist Office (ENIT) 1965-01-26 ITALY Montana, Vanni Buscemi 1846 1965-01-26 Montana, Vanni Buscemi New York     NY  
15842 15842 1980-12-31 Italian Counsellors International, U.S. Representative for Mezzogiorno Office 1980-12-19 ITALY Development Counsellors International, Ltd. 1421 1961-01-30 Development Counsellors International, Ltd.       NY  

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [FARA_All_ForeignPrincipals] (
   [Foreign_Principal_Termination_Date] TEXT,
   [Foreign_Principal] TEXT,
   [Foreign_Principal_Registration_Date] TEXT,
   [Country/Location_Represented] TEXT,
   [Registration_Number] INTEGER,
   [Registrant_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 181.319ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history