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

64 rows where Registrant_Name = "Hogan Lovells US LLP"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Address_2, Zip, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_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 6

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

State 4

  • - 46
  • DC 16
  • CT 1
  • NY 1

Registrant_Name 1

  • Hogan Lovells US LLP · 64 ✖
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
164 164   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        
612 612   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
935 935 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        
942 942 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  
948 948 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        
1992 1992 1989-02-01 Aermacchi, S.p.A. 1987-08-10 ITALY Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP Varese        
2597 2597 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        
2599 2599 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        
2600 2600 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        
2955 2955 1996-02-28 Cervecerias del Baru 1995-12-26 PANAMA Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP Panama        
2966 2966 1997-02-28 Elbim Bank 1996-02-16 RUSSIA Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP Moscow        
2978 2978 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        
2980 2980 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  
2997 2997 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  
3004 3004 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  
3010 3010 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        
3016 3016 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,        
3021 3021 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  
3022 3022 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        
3062 3062 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      
3076 3076 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    
3084 3084 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      
3089 3089 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        
3102 3102 2000-02-29 Embassy of Japan 1971-05-07 JAPAN Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP Washington     DC  
3103 3103 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  
3107 3107 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        
3115 3115 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    
3128 3128 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
3278 3278 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
3798 3798 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        
3800 3800 1993-03-18 Continental Construction, Ltd. 1992-07-07 INDIA Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP New Delhi        
3804 3804 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        
4047 4047 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  
4048 4048 1995-03-28 Techsnabexport, Ltd. (Tenex) 1992-04-07 RUSSIA Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP Moscow        
4678 4678 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
7135 7135 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    
7646 7646 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        
9823 9823 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  
10846 10846 1995-08-31 Human Frontier Science Program 1993-09-14 INTERNATIONAL Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP ]        
10852 10852 1996-08-31 Government of Haiti 1993-06-03 HAITI Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP Washington     DC  
10864 10864 1998-08-31 Algoma Steel, Inc. 1994-05-23 CANADA Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP Ontario        
10876 10876 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        
10877 10877 2000-08-31 Nippon Telegraph & Telephone Corporation 1994-01-24 JAPAN Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP Tokyo        
10884 10884 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        
10912 10912 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.        
10931 10931 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        
10965 10965 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      
10967 10967 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      
10970 10970 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      
10971 10971 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      
10975 10975 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      
10981 10981 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    
10982 10982 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
10984 10984 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      
10985 10985 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      
10987 10987 2019-08-31 Islamic Republic of Afghanistan 2018-09-26 AFGHANISTAN Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP          
11535 11535 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        
11602 11602 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        
11603 11603 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        
11748 11748 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  
11851 11851 1994-09-30 Aviastar Joint Stock Company 1993-12-20 RUSSIA Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP Antonova        
12603 12603 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  
14421 14421 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  
14623 14623 1990-12-07 Government of Poland 1989-11-17 POLAND Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP Warsaw        

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