FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
45 rows where Address_1 = "Rome" and Country/Location_Represented = "ITALY" sorted by Registration_Number
This data as json, CSV (advanced)
Registrant_Name 16
- ASL International, Inc. 1
- Alenia of U.S.A., Inc. 1
- Bartucci-Samuel, Inc. 1
- Burson-Marsteller 1
- Clifton, Chester V. 1
- Dickstein Shapiro, LLP 1
- Hughes, Hubbard & Reed 1
- Keating Group, Inc. 1
- King & Spalding 1
- Mandaback & Simms, Inc. 1
- Mazzaglia, Enzo 1
- Partito Repubblicano Italiano/U.S.A. Sezione Ugo La Malfa 1
- Peter Rothholz Associates, Inc. 1
- Rogers & Wells, LLP 1
- Royer & Babyak 1
- Susan Davis International & Public Affairs 1
Foreign_Principal 15
- Banca Nazionale del Lavoro 2
- Aeritalia 1
- Alenia (Formerly: Aeritalia Societa Aeorspaziale Italiana, P.A.) 1
- Alitalia 1
- Atlante Hotels 1
- Giancarlo Parretti 1
- Government of Italy, Senator Giulio Andreotti 1
- International Olive Oil Council 1
- Italian Government Travel Office (ENIT), New York 1
- Italian Institute for Foreign Trade (Istituto Nazionale Per Il Commercio Estero-Ice) 1
- Partido Repubblicano Italiano 1
- Partito Repubblicano Italiano/U.S.A. 1
- Sekur, S.p.A. - Pirelli Group 1
- Selenia Industrie Electroniche Associate, S.P.A. 1
- Selenia, S.p.A 1
State 1
- - 16
Country/Location_Represented 1
- ITALY · 16 ✖
City 1
- - 16
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2553 | 2553 | 1986-02-15 | Selenia, S.p.A | 1986-01-27 | ITALY | Burson-Marsteller 2469 | 1973-10-23 | Burson-Marsteller | Rome | ||||
3608 | 3608 | 1993-03-11 | Atlante Hotels | 1989-06-23 | ITALY | Keating Group, Inc. 2478 | 1973-11-23 | Keating Group, Inc. | Rome | ||||
6763 | 6763 | 1979-05-24 | Aeritalia | 1978-06-29 | ITALY | Clifton, Chester V. 2561 | 1975-03-04 | Clifton, Chester V. | Rome | ||||
12869 | 12869 | 1983-10-20 | Italian Government Travel Office (ENIT), New York | 1981-04-02 | ITALY | Peter Rothholz Associates, Inc. 2830 | 1977-09-16 | Peter Rothholz Associates, Inc. | Rome | ||||
9569 | 9569 | 1993-07-28 | Alitalia | 1983-09-30 | ITALY | Dickstein Shapiro, LLP 3028 | 1979-06-07 | Dickstein Shapiro, LLP | Rome | ||||
3456 | 3456 | 1992-03-05 | Alenia (Formerly: Aeritalia Societa Aeorspaziale Italiana, P.A.) | 1982-08-11 | ITALY | Alenia of U.S.A., Inc. 3399 | 1982-08-11 | Alenia of U.S.A., Inc. | Rome | ||||
11716 | 11716 | 1991-09-19 | Banca Nazionale del Lavoro | 1990-09-25 | ITALY | Rogers & Wells, LLP 3428 | 1982-12-10 | Rogers & Wells, LLP | Rome | ||||
12032 | 12032 | 1991-09-30 | Partido Repubblicano Italiano | 1991-10-30 | ITALY | Susan Davis International & Public Affairs 3444 | 1983-02-16 | Susan Davis International & Public Affairs | Rome | ||||
3501 | 3501 | 1986-03-07 | Italian Institute for Foreign Trade (Istituto Nazionale Per Il Commercio Estero-Ice) | 1983-08-10 | ITALY | Mandaback & Simms, Inc. 3507 | 1983-08-10 | Mandaback & Simms, Inc. | Rome | ||||
8962 | 8962 | 1987-07-02 | Selenia Industrie Electroniche Associate, S.P.A. | 1986-10-15 | ITALY | Mazzaglia, Enzo 3897 | 1986-10-15 | Mazzaglia, Enzo | Rome | ||||
7065 | 7065 | 1988-05-31 | International Olive Oil Council | 1986-11-21 | ITALY | Bartucci-Samuel, Inc. 3909 | 1986-11-21 | Bartucci-Samuel, Inc. | Rome | ||||
5410 | 5410 | 1993-04-19 | Partito Repubblicano Italiano/U.S.A. | 1987-02-24 | ITALY | Partito Repubblicano Italiano/U.S.A. Sezione Ugo La Malfa 3939 | 1987-02-24 | Partito Repubblicano Italiano/U.S.A. Sezione Ugo La Malfa | Rome | ||||
5658 | 5658 | 1995-04-28 | Banca Nazionale del Lavoro | 1992-07-22 | ITALY | King & Spalding 4352 | 1990-03-16 | King & Spalding | Rome | ||||
2988 | 2988 | 1992-02-28 | Sekur, S.p.A. - Pirelli Group | 1991-11-29 | ITALY | ASL International, Inc. 4598 | 1991-11-29 | ASL International, Inc. | Rome | ||||
7879 | 7879 | 1994-06-16 | Government of Italy, Senator Giulio Andreotti | 1993-05-19 | ITALY | Hughes, Hubbard & Reed 4804 | 1993-05-19 | Hughes, Hubbard & Reed | Rome | ||||
16325 | 16325 | 1995-12-31 | Giancarlo Parretti | 1995-12-12 | ITALY | Royer & Babyak 5086 | 1995-12-12 | Royer & Babyak | Rome |
Advanced export
JSON shape: default, array, newline-delimited
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]) );