FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
15 rows where Address_1 = "Milano" and Country/Location_Represented = "ITALY" sorted by City
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Termination_Date, Registration_Number, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date)
Foreign_Principal 14
- Agusta Group 2
- Agusta Aviation Corporation 1
- Anci (Via Dogana 1, Milano, Italy) 1
- Assicurazione Nazionale Imprese Assicuratrici 1
- Associazione Nazionale fra le Imprese Assicuratrici (ANIA) 1
- BRACCO, S.p.A. 1
- Ferruzzi Finanziaria, S.p.A. 1
- Foundation for International Culture 1
- ISAGRO, S.R.L. Formerly Agrimont, S.R.L. 1
- Micam-Anci (Via Digana 1, Milano, Italy) 1
- Micam-Anci (Via Dogana 1, Milano, Italy) 1
- Rumianca, S.p.A. 1
- Saiedue Trade Fair 1
- Societa Cavi Pirelli, S.p.A. 1
Registrant_Name 13
- Daniels, Houlihan & Palmeter 2
- Hopkins & Sutter 2
- Alikonis, Robert John 1
- Capitoline/MS&L 1
- Cassidy & Associates, Inc. 1
- Fasturn, Inc. 1
- Ginn, Edington, Wade & Sanders, Inc. 1
- Hill and Knowlton Strategies, LLC 1
- Jellinek, Schwartz & Connolly, Inc. 1
- McMillan Group, L.L.C. 1
- Moore, Powell A. 1
- Ruder Finn, Inc. 1
- Ruder, Finn & Rotman International Partners, Ltd. 1
State 1
- - 15
Country/Location_Represented 1
- ITALY · 15 ✖
City 1
- - 15
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2418 | 2418 | 1996-02-12 | BRACCO, S.p.A. | 1995-06-23 | ITALY | McMillan Group, L.L.C. 5028 | 1995-06-23 | McMillan Group, L.L.C. | Milano | ||||
6807 | 6807 | 1983-05-25 | Anci (Via Dogana 1, Milano, Italy) | 1978-08-10 | ITALY | Daniels, Houlihan & Palmeter 2072 | 1968-01-30 | Daniels, Houlihan & Palmeter | Milano | ||||
6813 | 6813 | 1983-05-25 | Micam-Anci (Via Digana 1, Milano, Italy) | 1979-11-26 | ITALY | Fasturn, Inc. 2944 | 1978-08-09 | Fasturn, Inc. | Milano | ||||
6814 | 6814 | 1983-05-25 | Micam-Anci (Via Dogana 1, Milano, Italy) | 1975-09-15 | ITALY | Daniels, Houlihan & Palmeter 2072 | 1968-01-30 | Daniels, Houlihan & Palmeter | Milano | ||||
6908 | 6908 | 1992-05-29 | Associazione Nazionale fra le Imprese Assicuratrici (ANIA) | 1992-02-11 | ITALY | Hopkins & Sutter 4362 | 1990-04-11 | Hopkins & Sutter | Milano | ||||
7138 | 7138 | 1995-05-31 | Agusta Group | 1993-09-02 | ITALY | Capitoline/MS&L 4529 | 1991-06-20 | Capitoline/MS&L | Milano | ||||
7846 | 7846 | 1993-06-15 | Saiedue Trade Fair | 1986-10-03 | ITALY | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | Milano | ||||
8159 | 8159 | 1984-06-29 | Foundation for International Culture | 1983-04-26 | ITALY | Ruder, Finn & Rotman International Partners, Ltd. 3462 | 1983-04-26 | Ruder, Finn & Rotman International Partners, Ltd. | Milano | ||||
8450 | 8450 | 1990-06-30 | Agusta Aviation Corporation | 1988-05-02 | ITALY | Ginn, Edington, Wade & Sanders, Inc. 4134 | 1988-05-02 | Ginn, Edington, Wade & Sanders, Inc. | Milano | ||||
11354 | 11354 | 1993-09-03 | Agusta Group | 1990-07-18 | ITALY | Moore, Powell A. 4402 | 1990-07-18 | Moore, Powell A. | Milano | ||||
14276 | 14276 | 1979-11-27 | Rumianca, S.p.A. | 1978-05-24 | ITALY | Alikonis, Robert John 2789 | 1977-06-06 | Alikonis, Robert John | Milano | ||||
14946 | 14946 | 1992-12-10 | Ferruzzi Finanziaria, S.p.A. | 1989-08-04 | ITALY | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | Milano | ||||
15257 | 15257 | 1993-12-20 | Societa Cavi Pirelli, S.p.A. | 1989-05-25 | ITALY | Cassidy & Associates, Inc. 4259 | 1989-05-25 | Cassidy & Associates, Inc. | Milano | ||||
16262 | 16262 | 1994-12-31 | ISAGRO, S.R.L. Formerly Agrimont, S.R.L. | 1991-09-30 | ITALY | Jellinek, Schwartz & Connolly, Inc. 4345 | 1990-02-23 | Jellinek, Schwartz & Connolly, Inc. | Milano | ||||
16289 | 16289 | 1995-12-31 | Assicurazione Nazionale Imprese Assicuratrici | 1995-10-06 | ITALY | Hopkins & Sutter 4362 | 1990-04-11 | Hopkins & Sutter | Milano |
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]) );