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

23 rows where State = "MA"

View and edit SQL

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

City

State

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
106   Consulate General of Japan in Boston 2014-04-09 JAPAN 6213 6213 2014-04-09 Policy Agency, LLC Federal Reserve Plaza, 22nd Floor 600 Atlantic Avenue   Boston MA 02210
636   The Consulate General of Japan in Boston 2020-06-25 JAPAN 6841 6841 2020-06-25 Bowen McDonald Peard 600 Atlantic Avenue, 22nd Floor   Boston MA 02210
1114 1956-01-11 Consul Basil L. Tsamissis, Consul of Greece 1955-05-03 GREECE 864 864 1955-01-04 Margold, Stella K. Boston     MA  
2509 1992-02-18 Terje Korsnes, Honorary Consul of Norway in Boston 1992-02-18 NORWAY 4431 4431 1990-08-07 Harron & Associates Brookline     MA  
2527 1943-02-20 Pieroni Brothers & Brunilde Maddaleni 1942-08-20 ITALY 112 112 1942-08-20 Ghiloni, Alfred R. Boston     MA  
3461 1984-03-12 Eelam Tamils Association of America 1982-04-23 SRI LANKA 2956 2956 1978-09-14 Blaustein Associates, Ltd. Somerville     MA  
3968 1992-03-30 Devon & Cornwall Development 1991-06-24 GREAT BRITAIN 4491 4491 1991-04-01 Kuett & Company, Inc. Woburn     MA  
5068 2019-04-16 CRRC MA Corporation 2019-02-01 CHINA 6170 6170 2013-05-14 Mercury Public Affairs, LLC 108 Myrtle Street   Quincy MA 02171
7794 1990-06-29 Devon & Cornwall Development Bureau 1989-12-27 GREAT BRITAIN 4254 4254 1989-05-17 Ketchum Communications, Inc., Through Ketchum P.R., New York Woburn     MA  
7799 1993-06-29 British Consulate General 1988-06-09 GREAT BRITAIN 4147 4147 1988-06-09 Hampe, Richard A. Boston     MA  
9449 2006-07-31 Kashala for President 2006-04-28 CONGO, REPUBLIC OF THE 5693 5693 2005-07-01 Dutko Worldwide, LLC 687 Highland Avenue Suite 11 Needham MA 02494
9649 2011-08-02 Consulate General of Canada Boston 2011-05-25 CANADA 6044 6044 2011-05-25 Conover + Company Communications, Inc. Three Copley Place Suite 400 Boston MA 02116
10181 1942-08-20 Louis (Luigi) Pieroni 1942-08-20 ITALY 114 114 1942-08-20 Ghiloni, Alfred R. Boston     MA  
10204 1989-08-21 Khurshid Hadi 1987-02-05 PAKISTAN 3934 3934 1987-02-05 Cone Communications West Newton     MA  
10317 1995-08-26 British Consulate General 1990-02-06 GREAT BRITAIN 4337 4337 1990-02-06 Doyle & Nelson Boston     MA  
11242 1995-09-19 Devon & Cornwall Development Bureau 1988-04-21 GREAT BRITAIN 3661 3661 1985-03-19 Spring O'Brien & Company, Inc. Woburn     MA  
11307 2019-09-23 Consulate General of the Republic of Korea 2018-05-14 KOREA, SOUTH 6557 6557 2018-05-14 Sachem Strategies, LLC 300 Washington Street #251   Newton MA 02458
11543 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 4625 4625 1992-03-03 Horst & Frisch, Inc. Boston     MA  
13349 1989-11-14 British Consulate General 1988-02-16 GREAT BRITAIN 4091 4091 1988-02-16 Doyle & Nelson Boston     MA  
13599 1993-11-23 Serono Laboratories, Inc. 1992-05-29 SWITZERLAND 3971 3971 1987-04-29 Levine & Company Norvel     MA  
13920 2005-11-30 Taipei Economic and Cultural Office in Boston 2005-08-31 TAIWAN 3911 3911 1986-12-01 CMGRP, Inc. 99 Summer Street Suite 801 Boston MA 02110
14315 1986-12-10 Puma U.S.A., Inc. 1985-07-31 GERMANY, FEDERAL REPUBLIC OF 3428 3428 1982-12-10 Rogers & Wells, LLP Framingham     MA  
14319 1992-12-10 Astra Pharmaceuticals 1991-12-11 SWEDEN 3301 3301 1981-11-10 Hill and Knowlton Strategies, LLC Westborough     MA  

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 · Query took 165.622ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history