FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
16 rows where City = "" and State = "MA" sorted by Foreign_Principal_Termination_Date
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Registration_Date, Registrant_Date, Address_1, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Foreign_Principal_Termination_Date 16 ✖
- 1942-08-20 1
- 1943-02-20 1
- 1956-01-11 1
- 1984-03-12 1
- 1986-12-10 1
- 1989-08-21 1
- 1989-11-14 1
- 1990-06-29 1
- 1992-02-18 1
- 1992-03-30 1
- 1992-09-30 1
- 1992-12-10 1
- 1993-06-29 1
- 1993-11-23 1
- 1995-08-26 1
- 1995-09-19 1
Registrant_Name 14
- Doyle & Nelson 2
- Ghiloni, Alfred R. 2
- Blaustein Associates, Ltd. 1
- Cone Communications 1
- Hampe, Richard A. 1
- Harron & Associates 1
- Hill and Knowlton Strategies, LLC 1
- Horst & Frisch, Inc. 1
- Ketchum Communications, Inc., Through Ketchum P.R., New York 1
- Kuett & Company, Inc. 1
- Levine & Company 1
- Margold, Stella K. 1
- Rogers & Wells, LLP 1
- Spring O'Brien & Company, Inc. 1
Foreign_Principal 13
- British Consulate General 3
- Devon & Cornwall Development Bureau 2
- Astra Pharmaceuticals 1
- Consul Basil L. Tsamissis, Consul of Greece 1
- Devon & Cornwall Development 1
- Eelam Tamils Association of America 1
- Industrial Development Authority of Ireland, an Agency of the Gov't. of the Republic of Ireland Through Ropes & Gray 1
- Khurshid Hadi 1
- Louis (Luigi) Pieroni 1
- Pieroni Brothers & Brunilde Maddaleni 1
- Puma U.S.A., Inc. 1
- Serono Laboratories, Inc. 1
- Terje Korsnes, Honorary Consul of Norway in Boston 1
Country/Location_Represented 10
- GREAT BRITAIN 6
- ITALY 2
- GERMANY, FEDERAL REPUBLIC OF 1
- GREECE 1
- IRELAND 1
- NORWAY 1
- PAKISTAN 1
- SRI LANKA 1
- SWEDEN 1
- SWITZERLAND 1
State 1
- MA · 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10624 | 10624 | 1942-08-20 | Louis (Luigi) Pieroni | 1942-08-20 | ITALY | Ghiloni, Alfred R. 114 | 1942-08-20 | Ghiloni, Alfred R. | Boston | MA | |||
2675 | 2675 | 1943-02-20 | Pieroni Brothers & Brunilde Maddaleni | 1942-08-20 | ITALY | Ghiloni, Alfred R. 112 | 1942-08-20 | Ghiloni, Alfred R. | Boston | MA | |||
1203 | 1203 | 1956-01-11 | Consul Basil L. Tsamissis, Consul of Greece | 1955-05-03 | GREECE | Margold, Stella K. 864 | 1955-01-04 | Margold, Stella K. | Boston | MA | |||
3659 | 3659 | 1984-03-12 | Eelam Tamils Association of America | 1982-04-23 | SRI LANKA | Blaustein Associates, Ltd. 2956 | 1978-09-14 | Blaustein Associates, Ltd. | Somerville | MA | |||
14941 | 14941 | 1986-12-10 | Puma U.S.A., Inc. | 1985-07-31 | GERMANY, FEDERAL REPUBLIC OF | Rogers & Wells, LLP 3428 | 1982-12-10 | Rogers & Wells, LLP | Framingham | MA | |||
10647 | 10647 | 1989-08-21 | Khurshid Hadi | 1987-02-05 | PAKISTAN | Cone Communications 3934 | 1987-02-05 | Cone Communications | West Newton | MA | |||
13943 | 13943 | 1989-11-14 | British Consulate General | 1988-02-16 | GREAT BRITAIN | Doyle & Nelson 4091 | 1988-02-16 | Doyle & Nelson | Boston | MA | |||
8167 | 8167 | 1990-06-29 | Devon & Cornwall Development Bureau | 1989-12-27 | GREAT BRITAIN | Ketchum Communications, Inc., Through Ketchum P.R., New York 4254 | 1989-05-17 | Ketchum Communications, Inc., Through Ketchum P.R., New York | Woburn | MA | |||
2657 | 2657 | 1992-02-18 | Terje Korsnes, Honorary Consul of Norway in Boston | 1992-02-18 | NORWAY | Harron & Associates 4431 | 1990-08-07 | Harron & Associates | Brookline | MA | |||
4181 | 4181 | 1992-03-30 | Devon & Cornwall Development | 1991-06-24 | GREAT BRITAIN | Kuett & Company, Inc. 4491 | 1991-04-01 | Kuett & Company, Inc. | Woburn | MA | |||
12037 | 12037 | 1992-09-30 | Industrial Development Authority of Ireland, an Agency of the Gov't. of the Republic of Ireland Through Ropes & Gray | 1992-03-03 | IRELAND | Horst & Frisch, Inc. 4625 | 1992-03-03 | Horst & Frisch, Inc. | Boston | MA | |||
14945 | 14945 | 1992-12-10 | Astra Pharmaceuticals | 1991-12-11 | SWEDEN | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | Westborough | MA | |||
8172 | 8172 | 1993-06-29 | British Consulate General | 1988-06-09 | GREAT BRITAIN | Hampe, Richard A. 4147 | 1988-06-09 | Hampe, Richard A. | Boston | MA | |||
14197 | 14197 | 1993-11-23 | Serono Laboratories, Inc. | 1992-05-29 | SWITZERLAND | Levine & Company 3971 | 1987-04-29 | Levine & Company | Norvel | MA | |||
10767 | 10767 | 1995-08-26 | British Consulate General | 1990-02-06 | GREAT BRITAIN | Doyle & Nelson 4337 | 1990-02-06 | Doyle & Nelson | Boston | MA | |||
11722 | 11722 | 1995-09-19 | Devon & Cornwall Development Bureau | 1988-04-21 | GREAT BRITAIN | Spring O'Brien & Company, Inc. 3661 | 1985-03-19 | Spring O'Brien & Company, Inc. | Woburn | MA |
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]) );