home / fara

Menu
  • Search all tables
  • GraphQL API

FARA_All_ForeignPrincipals

Table actions
  • GraphQL API for 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

65 rows where Registrant_Name = "Hogan Lovells US LLP" sorted by Country/Location_Represented

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Address_2, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date)

Foreign_Principal >30

  • Embassy of Japan 2
  • Aermacchi, S.p.A. 1
  • Algoma Steel, Inc. 1
  • Andra AP-fonden (AP2) Swedish National Pension Fund 1
  • Aviastar Joint Stock Company 1
  • Avions de Transport Regional, Groupement d'Interet Economique 1
  • Borse Dubai Limited 1
  • Cervecerias del Baru 1
  • Committee of European National Shipowners' Associations (CENSA) 1
  • Continental Construction, Ltd. 1
  • Daimler-Benz, A.G. (DBAG")" 1
  • Defense Analyses Institute 1
  • Elbim Bank 1
  • Embassy of Afghanistan 1
  • Embassy of Ivory Coast 1
  • Embassy of Singapore 1
  • Embassy of the Bolivarian Republic of Venezuela 1
  • Embassy of the Hashemite Kingdom of Jordan 1
  • Fjarde AP-fonden (AP4) Swedish National Pension Fund 1
  • Forsta AP-fonden (AP1) Swedish National Pension Fund 1
  • Georgian Dream Party 1
  • Georgian Oil and Gas Corporation 1
  • Georgian Railways, Ltd. 1
  • Globe Nuclear Services & Supply (GNSS), Ltd. 1
  • Government of Antigua and Barbuda 1
  • Government of Czech & Slovak Federative Republic 1
  • Government of El Salvador, Embassy 1
  • Government of Haiti 1
  • Government of Ontario, Ministry of Natural Resources and Forestry, and Ministry of Citizenship, Immigration and International Trade 1
  • Government of Poland 1
  • …

Country/Location_Represented >30

  • RUSSIA 6
  • SWEDEN 4
  • BAHAMAS 3
  • GEORGIA 3
  • INTERNATIONAL 3
  • JAPAN 3
  • KOREA, SOUTH 3
  • AFGHANISTAN 2
  • CANADA 2
  • CHINA 2
  • CZECHOSLOVAKIA 2
  • GREAT BRITAIN 2
  • PANAMA 2
  • SAUDI ARABIA 2
  • TAIWAN 2
  • UNITED ARAB EMIRATES 2
  • VENEZUELA 2
  • ANTIGUA & BARBUDA 1
  • COTE D'IVOIRE (IVORY COAST) 1
  • CYPRUS 1
  • ECUADOR 1
  • EL SALVADOR 1
  • FRANCE 1
  • GERMANY 1
  • GREECE 1
  • HAITI 1
  • INDIA 1
  • INDONESIA 1
  • ITALY 1
  • JORDAN 1
  • …

City 7

  • - 55
  • Washington 5
  • Dubai 1
  • Gloucestershire 1
  • Nassau 1
  • Ontario 1
  • Quito 1

State 4

  • - 47
  • DC 16
  • CT 1
  • NY 1

Registrant_Name 1

  • Hogan Lovells US LLP · 65 ✖
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
3186 3186 2020-02-29 Embassy of Afghanistan 2019-03-13 AFGHANISTAN Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP 2341 Wyoming Avenue, NW   Washington DC 20008
11178 11178 2019-08-31 Islamic Republic of Afghanistan 2018-09-26 AFGHANISTAN Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP          
11176 11176 2019-08-31 Government of Antigua and Barbuda 2012-08-24 ANTIGUA & BARBUDA Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP Attorney General's Chambers Government Office Complex Parliament Drive P.O. Box 118 St. Johns      
3033 3033 1999-02-28 Ministries of Foreign Affairs, Justice, Tourism & Economic Affairs of the Government of the Commonwealth of Bahamas 1977-06-24 BAHAMAS Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP Washington     DC  
3075 3075 2006-02-28 Government of the Commonwealth of Bahamas 2001-01-19 BAHAMAS Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP Cecil V. Wallace - Whitfield Center West Bay Street Nassau        
3129 3129 2018-02-28 Government of the Commonwealth of The Bahamas 2014-05-30 BAHAMAS Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP Cecil V. Wallace-Whitfield Center West Bay St. Nassau    
7259 7259 2016-05-31 Government of Ontario, Ministry of Natural Resources and Forestry, and Ministry of Citizenship, Immigration and International Trade 1987-05-29 CANADA Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP Suite 400 70 Foster Drive Sault Ste Marie Ontario    
11055 11055 1998-08-31 Algoma Steel, Inc. 1994-05-23 CANADA Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP Ontario        
11103 11103 2006-08-31 Liaoning Province Government 2003-12-31 CHINA Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP Legal Affairs Office of Liaoning Province Government #45 Beiling Avenue, Shenyang 110032, P.R.        
11122 11122 2008-08-31 Government of the People's Republic of China 2004-01-09 CHINA Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP Ministry of Commerce 2 Dong Chang An Avenue, Beijing 100731, P.R. China        
3057 3057 2003-02-28 Embassy of Ivory Coast 2002-09-19 COTE D'IVOIRE (IVORY COAST) Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP 3421 Massachusetts Avenue, N.W. 20007     DC  
3161 3161 2000-02-29 Government of the Republic of Cyprus, Embassy 1997-10-03 CYPRUS Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP Washington     DC  
2649 2649 1991-02-18 Government of Czech & Slovak Federative Republic 1990-09-14 CZECHOSLOVAKIA Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP Praha        
2650 2650 1991-02-18 Government of the Czech Republic 1990-09-14 CZECHOSLOVAKIA Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP Praha        
11172 11172 2018-08-31 Unidad de Analisis Financiero y Economico 2017-06-19 ECUADOR Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP Avenida Republica de Salvador N36-161 y Avenida Naciones Unidades Quito    
3050 3050 2002-02-28 Government of El Salvador, Embassy 1997-06-17 EL SALVADOR Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP Washington     DC  
961 961 1996-01-01 Avions de Transport Regional, Groupement d'Interet Economique 1994-11-30 FRANCE Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP Blagnac Cedex        
3063 3063 2004-02-28 Georgian Railways, Ltd. 2003-01-24 GEORGIA Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP 15 Tamar Mepe Avenue Tbilisi 380012        
3142 3142 2021-02-28 Georgian Dream Party 2020-02-08 GEORGIA Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP #3, Erekle 2nd Square        
11175 11175 2019-08-31 Georgian Oil and Gas Corporation 2017-11-03 GEORGIA Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP 0190, Tbillisi, Georgia 21 Kakheti Highway      
11732 11732 1993-09-20 Daimler-Benz, A.G. (DBAG")" 1989-05-15 GERMANY Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP Stuttgart        
968 968 1996-01-01 Grand Metropolitan, Inc. 1993-05-18 GREAT BRITAIN Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP Westport     CT  
11800 11800 1992-09-24 Underwriters at Lloyd's, London 1987-11-13 GREAT BRITAIN Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP London        
11067 11067 2000-08-31 Defense Analyses Institute 1999-07-09 GREECE Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP Stadiou 2 Athens 10564        
11043 11043 1996-08-31 Government of Haiti 1993-06-03 HAITI Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP Washington     DC  
3874 3874 1993-03-18 Continental Construction, Ltd. 1992-07-07 INDIA Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP New Delhi        
11156 11156 2016-08-31 Yayasan Diaspora Indonesia Global 2015-06-30 INDONESIA Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP Graha Irama 15th Floor Suite A JI HR Rasuna Said, Blok X-1, Kav 1-2 Jakarta 12950      
2647 2647 1990-02-18 Committee of European National Shipowners' Associations (CENSA) 1971-02-18 INTERNATIONAL Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP London        
11037 11037 1995-08-31 Human Frontier Science Program 1993-09-14 INTERNATIONAL Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP ]        
12831 12831 1991-10-18 International Council of Cruise Lines (ICCL") (Formerly: International Committee of Passenger Lines)" 1985-11-04 INTERNATIONAL Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP New York     NY  
2031 2031 1989-02-01 Aermacchi, S.p.A. 1987-08-10 ITALY Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP Varese        
167 167   Embassy of Japan 2001-04-19 JAPAN Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP 2-2-1 Kasumigaseki Chiyoda-ku, Tokyo 100        
3160 3160 2000-02-29 Embassy of Japan 1971-05-07 JAPAN Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP Washington     DC  
11068 11068 2000-08-31 Nippon Telegraph & Telephone Corporation 1994-01-24 JAPAN Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP Tokyo        
11173 11173 2019-08-31 Embassy of the Hashemite Kingdom of Jordan 2016-10-20 JORDAN Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP 3504 International Drive, NW   Washington DC 20008
3165 3165 2000-02-29 Korea International Trade Association 1999-07-14 KOREA, SOUTH Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP Trade Tower 159-1 Sansung-dong Kangnam-Ku Seoul        
3872 3872 1992-03-18 Korea Foreign Trade Association 1991-01-03 KOREA, SOUTH Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP Seoul        
11799 11799 1992-09-24 Korean Soybean Processors' Association 1989-11-22 KOREA, SOUTH Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP Seoul        
3115 3115 2015-02-28 Pemex-Exploracion Y Produccion 2011-04-01 MEXICO Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP Av. Paseo Tabasco 1203 Torre Empresarial, Piso 14 Col. Lindavista, C.P. 86050      
11075 11075 2001-08-31 Palau National Communications Corporation 2001-07-27 PALAU Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP P.O. Box 99 Koror, Palau, PW 96940 Republic of Palau        
3008 3008 1996-02-28 Cervecerias del Baru 1995-12-26 PANAMA Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP Panama        
3069 3069 2005-02-28 Ministry of Trade of Panama 2004-04-19 PANAMA Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP Ministerio de Ccomercio e Industrias de la Republica de Panama, Plaza Edison Piso 3, Ave. El Paical,        
14870 14870 1990-12-07 Government of Poland 1989-11-17 POLAND Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP Warsaw        
3074 3074 2006-02-28 Government of Qatar, Embassy 2003-07-14 QATAR Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP 4200 Wisconsin Avenue, N.W. 20016     DC  
974 974 1996-01-01 Volga-Dnepr J.S. Cargo Airline 1993-12-20 RUSSIA Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP Ulyanovsk        
3019 3019 1997-02-28 Elbim Bank 1996-02-16 RUSSIA Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP Moscow        
3031 3031 1999-02-28 Joint Stock Commercial Bank - UNIBEST 1997-10-27 RUSSIA Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP Moscow        
4124 4124 1995-03-28 Globe Nuclear Services & Supply (GNSS), Ltd. 1991-11-21 RUSSIA Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP Washington     DC  
4125 4125 1995-03-28 Techsnabexport, Ltd. (Tenex) 1992-04-07 RUSSIA Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP Moscow        
12053 12053 1994-09-30 Aviastar Joint Stock Company 1993-12-20 RUSSIA Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP Antonova        
614 614   Royal Embassy of Saudi Arabia, Washington, D.C. 2007-09-24 SAUDI ARABIA Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP 601 New Hampshire Avenue, NW   Washington DC 20037
11950 11950 1980-09-30 Government of Saudi Arabia 1976-08-10 SAUDI ARABIA Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP Washington     DC  
3336 3336 2007-03-01 Embassy of Singapore 2006-02-02 SINGAPORE Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP 3501 International Place, NW   Washington DC 20008
11158 11158 2017-08-31 Andra AP-fonden (AP2) Swedish National Pension Fund 2016-05-16 SWEDEN Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP Ostra Hamngatan 26-26 P.O. Box 11155 SE-404 24 Goteborg      
11161 11161 2017-08-31 Fjarde AP-fonden (AP4) Swedish National Pension Fund 2016-05-16 SWEDEN Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP Regeringsgatan 30-32 P.O. Box 3069 SE-103 61 Stockholm      
11162 11162 2017-08-31 Forsta AP-fonden (AP1) Swedish National Pension Fund 2016-05-16 SWEDEN Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP Regeringsgatan 28 P.O. Box 16294 SE-103 25 Stockholm      
11166 11166 2017-08-31 Tredje AP-fonden (AP3) Swedish National Pension Fund 2016-05-16 SWEDEN Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP Vasagatan 7 P.O. Box 1176 SE - 111 91 Stockholm      
3878 3878 1993-03-18 United Microelectronics Corporation (UMC")" 1992-05-20 TAIWAN Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP Hsin-Chu City        
7786 7786 1996-06-13 Taipei Economic & Cultural Representative Office (Formerly: China External Trade Development Council) 1990-02-12 TAIWAN Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP Taipei        
9998 9998 1985-08-01 Government of the Republic of Uganda 1984-08-17 UGANDA Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP Washington     DC  
734 734   UK Office of Victor Pinchuk Foundation 2023-02-16 UKRAINE Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP Third Floor, 95 The Promenade Cheltenham   Gloucestershire    
3173 3173 2008-02-29 Borse Dubai Limited 2007-10-19 UNITED ARAB EMIRATES Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP P.O. Box 74777, Level 14, The Gate Dubai International Financial Centre, Dubai    
14664 14664 1980-12-01 United Arab Emirates 1975-12-18 UNITED ARAB EMIRATES Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP Washington     DC  
3137 3137 2019-02-28 Government of the Bolivarian Republic of Venezuela 2016-03-16 VENEZUELA Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP Av. Los Illustres, cruce con calle Francisco Lazo Marti Edificio Procuraduria General de la Republica Piso 8, Urb. Santa Monica, Caracas 1040      
4756 4756 2016-03-31 Embassy of the Bolivarian Republic of Venezuela 2014-12-17 VENEZUELA Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP 1099 30th Street, NW   Washington DC 20007

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 · Queries took 289.572ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
  • Sort ascending
  • Sort descending
  • Facet by this
  • Hide this column
  • Show all columns
  • Show not-blank rows