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

17 rows where State = "CT"

View and edit SQL

Suggested facets: Registration_Number, 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
305   H.Q. Energy Services (U.S.) Inc. 2020-07-09 CANADA 6522 6522 2018-02-10 Forbes Tate Partners LLC 225 Asylum Street 27th Floor Hartford CT 06103
890 1996-01-01 Grand Metropolitan, Inc. 1993-05-18 GREAT BRITAIN 2244 2244 1971-02-18 Hogan Lovells US LLP Westport     CT  
1708 1998-01-31 Norwegian Seafood Export Council 1994-07-15 NORWAY 4973 4973 1994-07-15 Gilman, Bradley D. Woodbury     CT  
2204 1998-02-09 Bayer Inc., Subsidiary of Bayer, A.G., (formerly: Miles, Inc., Subsidiary of Bayer, A.G.) 1989-08-08 GERMANY 2751 2751 1977-02-10 Barnes, Richardson & Colburn West Haven     CT  
2599 1993-02-24 Rolls-Royce, Inc. 1989-06-14 GREAT BRITAIN 3586 3586 1984-05-10 Lipsen, Whitten & Diamond Greenwich     CT  
2814 1991-02-28 Scottish Development Agency 1991-02-20 SCOTLAND 4474 4474 1991-02-20 Einstein & Sandom, Inc. Stamford     CT  
3669 1993-03-18 Perrier Group 1990-12-03 FRANCE 2661 2661 1976-02-18 Arent Fox Kintner Plotkin & Kahn, PLLC Greenwich     CT  
5918 1995-05-01 Pirelli Armstrong Tire Corporation 1994-11-30 ITALY 3700 3700 1985-07-09 Gold & Liebengood, Inc. New Haven     CT  
6265 2003-05-15 Virgin Atlantic Airways, Ltd. 1996-06-24 BRITISH VIRGIN ISLANDS 5129 5129 1996-06-24 CMG Communications, L.L.C. Norwalk     CT  
6494 1983-05-25 Norseland Foods, Inc. 1980-04-16 NORWAY 2072 2072 1968-01-30 Daniels, Houlihan & Palmeter Stamford     CT  
8952 1985-07-19 Texasgulf, Inc. 1982-05-13 FRANCE 3369 3369 1982-05-13 Kilgore & Kilgore, Inc.       CT  
9561 1983-08-01 Holland-America Line, N.V. 1981-07-13 FRANCE 3258 3258 1981-07-13 Preston, Thorgrimson, Ellis & Holman       CT  
10553 1990-08-31 SOFECIA 1990-03-07 FRANCE 3452 3452 1983-03-17 Dow, Lohnes & Albertson, L.L.P. Stamford     CT  
10603 1998-08-31 Asea Brown Boveri 1990-10-30 INTERNATIONAL 1481 1481 1961-09-27 Ruder Finn, Inc. Stamford     CT  
10854 1987-09-02 MTU of North America, Inc., for Motoren-und-Turbinen-Union Friedrichshafen GmbH 1987-09-02 GERMANY, FEDERAL REPUBLIC OF 3273 3273 1981-09-02 Hyman Fine & Associates, Ltd.       CT  
14745 1990-12-26 Rhone-Poulenc Basic Chemicals Company 1990-05-22 FRANCE 4377 4377 1990-05-22 Sindt, Robert H. Shelton     CT  
15297 1985-12-31 Motoren-und-Turbinen-Union Friedrichshafen GmbH 1985-09-16 GERMANY, FEDERAL REPUBLIC OF 3273 3273 1981-09-02 Hyman Fine & Associates, Ltd.       CT  

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