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

67 rows where Registrant_Name = "DLA Piper 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

  • Government of Thailand 2
  • AECL Technologies, Inc. 1
  • Azerbaijan Railways CJSC 1
  • Borse Dubai Limited 1
  • Centro Industrial de Laboratorios Farmaceuticos Argentinos (CILFA) 1
  • Consolidated Grain & Barge Company 1
  • Deambinox, S.A. 1
  • Egyptian Civil Aviation Authority 1
  • Embassy of the Hellenic Republic 1
  • Embassy of the Islamic Republic of Afghanistan 1
  • Embassy of the United Arab Emirates 1
  • Embassy of the United Kingdom 1
  • Executive Office of Dubai 1
  • Foreign Ministry of the Republic of Montenegro 1
  • Foreign Ministry of the Republic of Slovenia 1
  • German State of Rheinland-Pfalz 1
  • Government of Alberta 1
  • Government of Bermuda 1
  • Government of Chile, Embassy 1
  • Government of Ethiopia (Embassy) 1
  • Government of Ethiopia, Embassy 1
  • Government of Gabon 1
  • Government of Haiti 1
  • Government of India, Embassy 1
  • Government of Japan, Embassy 1
  • Government of Mexico, Embassy 1
  • Government of Oman (as Directed by Patton, Boggs & Blow) 1
  • Government of Slovenia, Embassy 1
  • Government of Spain, Embassy 1
  • Government of State of Mexico 1
  • …

Country/Location_Represented >30

  • MEXICO 6
  • UNITED ARAB EMIRATES 5
  • CANADA 3
  • SAUDI ARABIA 3
  • AFGHANISTAN 2
  • ARGENTINA 2
  • ETHIOPIA 2
  • FRANCE 2
  • INTERNATIONAL 2
  • JAPAN 2
  • SLOVENIA 2
  • THAILAND 2
  • AZERBAIJAN 1
  • BAHRAIN 1
  • BERMUDA 1
  • CHILE 1
  • COTE D'IVOIRE (IVORY COAST) 1
  • CYPRUS 1
  • DOMINICAN REPUBLIC 1
  • ECUADOR 1
  • EGYPT 1
  • GABON 1
  • GERMANY 1
  • GREECE 1
  • GUATEMALA 1
  • HAITI 1
  • INDIA 1
  • JORDAN 1
  • KAZAKHSTAN 1
  • KOSOVA 1
  • …

City 8

  • - 52
  • Washington 7
  • Dubai 3
  • Amman 1
  • Dulles 1
  • Edmonton 1
  • Santo Domingo 1
  • Tamaulipas 1

State 7

  • - 42
  • DC 18
  • NY 2
  • VA 2
  • FL 1
  • MD 1
  • MO 1

Registrant_Name 1

  • DLA Piper US LLP · 67 ✖
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
266 266   German State of Rheinland-Pfalz 2003-09-25 GERMANY DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP Ministry of the Interior and for Sports Office of the State Secretary Schillerplatz 3 - 5 55116 Ma        
440 440   Liberian International Ship and Corporate Registry (LISCR, LLC) 2021-08-10 LIBERIA DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP 22980 Indian Creek Drive, #200   Dulles VA 20166
1006 1006 2017-01-01 Republic of Ecuador, Embassy 2016-08-26 ECUADOR DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP 2535 15th Street, NW   Washington DC 20009
1435 1435 2009-01-22 Government of Turkey, Embassy 2007-05-10 TURKEY DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP 2525 Massachusetts Avenue, NW   Washington DC 20008
1613 1613 2003-01-30 Foreign Ministry of the Republic of Montenegro 2001-02-22 MONTENEGRO DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP Podgorica        
1614 1614 2003-01-30 President of Kosova 2002-12-26 KOSOVA DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP Government Building, Room E-106 Mother Teresa Street Pristina        
1801 1801 2002-01-31 Ministry of Foreign Affairs of the Republic of Yemen 2001-02-22 YEMEN DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP Sana'a        
2129 2129 2006-02-03 Government of State of Mexico 2003-12-24 MEXICO DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP Lic. Carlos Rello c/o Continental Outsourcing SA de CV Iglesia 2E - 1205/1206 Tizapan, Del. Alvar        
2158 2158 2005-02-04 Government of Thailand 2003-10-28 THAILAND DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP Central Administrative Office Government House Nakhon Pathorn Road Bangkok 10300        
2181 2181 1999-02-05 Government of Chile, Embassy 1997-10-03 CHILE DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP Washington     DC  
2182 2182 1999-02-05 Government of Uruguay 1995-11-16 URUGUAY DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP Washington     DC  
2183 2183 1999-02-05 Government of the Marshall Islands, Minister of Foreign Affairs 1996-02-21 MARSHALL ISLANDS DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP Majuro        
2184 2184 2000-02-05 Government of Slovenia, Embassy 1998-09-23 SLOVENIA DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP 1525 New Hampshire Avenue, N.W.     DC  
2185 2185 2000-02-05 Governor of Cordoba, Argentina 1999-04-28 ARGENTINA DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP Chacabuco 1300 Barrio Nueva Cordoba Codigo Postal 5000        
2186 2186 2000-02-05 United Nations Industrial Development Organization 1999-10-04 INTERNATIONAL DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP United Office of New York One United Nations Plaza, Room DC1-1110 New York     NY  
2187 2187 2001-02-05 Government of Mexico, Embassy 1998-12-16 MEXICO DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP 1911 Pennsylvania Avenue, N.W     DC  
2196 2196 1988-02-06 Deambinox, S.A. 1987-12-11 FRANCE DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP Nantes        
3029 3029 2007-02-28 Government of Japan, Embassy 2006-07-26 JAPAN DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP 2520 Massachusetts Avenue, NW   Washington DC 20008
3089 3089 2021-02-28 Government of the Democratic Republic of Timor-Leste 2016-06-26 TIMOR-LESTE (EAST TIMOR) DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP Maritime Boundary Office 1st Floor, West Wing Building, Government Palace Avenida Marginal Dili      
3090 3090 2021-02-28 Innovation Norway 2020-03-11 NORWAY DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP Akersgata 13 0158 Oslo      
3273 3273 2004-03-01 Government of Haiti 2003-05-07 HAITI DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP Plaza 2650, 2nd Floor 2650 S.W. 27th Avenue Miami 33133     FL  
3285 3285 2013-03-01 Interim Government of Afghanistan, Embassy 2002-03-26 AFGHANISTAN DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP 2000 L Street, N.W. Suite 200 20036     DC  
3349 3349 1995-03-03 Oerlikon-Buhrle, Ltd. 1985-12-09 SWITZERLAND DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP          
3445 3445 2003-03-07 Government of India, Embassy 1998-07-13 INDIA DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP 2107 Massachusetts Ave., NW, Washington, DC        
4694 4694 2018-03-31 Embassy of the United Arab Emirates 2008-12-15 UNITED ARAB EMIRATES DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP 3522 International Court, NW   Washington DC 20008
4858 4858 2004-04-01 Republic of Cyprus Government, Embassy 2001-02-22 CYPRUS DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP 2211 R Street, N.W. 20008     DC  
5485 5485 2001-04-25 Egyptian Civil Aviation Authority 2000-05-15 EGYPT DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP General Abd ElFattah M. Kato, Chairman Cairo        
5981 5981 2016-04-30 PRONACOM (Programa Nacional de la Competitividad) 2015-12-07 GUATEMALA DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP 13 Calle 13 zona 10 Edificio Atlantis, Torre 2, Nivel 3, Oficina 302        
6132 6132 2016-05-01 Royal Embassy of Saudi Arabia 2015-03-31 SAUDI ARABIA DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP          
6599 6599 2012-05-22 Presidential Campaign of Hipolito Mejia 2012-01-30 DOMINICAN REPUBLIC DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP Calle Alberto Larancuent #8 Ensanche Naco Distrito Nacional, Republic Dominicana Santo Domingo    
7295 7295 2002-06-01 Sinergia 7 (on behalf of the Government of the State of Chihuahua, Mexico) 2002-09-04 MEXICO DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP Blvd. Adolfo Lopez Mateos No. 1986 Col. Los Alpes DF Mexico 01010        
7304 7304 2008-06-01 Borse Dubai Limited 2007-11-02 UNITED ARAB EMIRATES DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP P.O. Box 74777, Level 14 - The Gate Dubai International Financial Centre Dubai    
7564 7564 2009-06-09 State of Tamaulipas 2008-04-22 MEXICO DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP Palacio de Gobierno 3er Piso, 15 y 16 Juarez Zona Centro CP 87000 Ciudad Victoria Tamaulipas    
7566 7566 2017-06-09 Embassy of the United Kingdom 2017-05-18 UNITED KINGDOM DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP 3100 Massachusetts Avenue, NW   Washington DC 20008
9720 9720 2013-07-31 Government of Bermuda 2013-05-23 BERMUDA DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP 300 Parliament Street 2nd Floor Hamilton HM 12        
9864 9864 2006-08-01 Government of Spain, Embassy 2004-01-28 SPAIN DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP 2375 Pennsylvania Avenue, N.W. 20037     DC  
9933 9933 2004-08-03 Government of Ethiopia (Embassy) 1999-04-28 ETHIOPIA DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP 2134 Kalorama Road, N.W. Washington, D.C. 20008     DC  
9956 9956 2005-08-04 Republic of Kazakhstan, Embassy through Howard Communications 2001-07-23 KAZAKHSTAN DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP The Embassy of the Republic of Kazakhstan 1401 16th Street N.W. 20036     DC  
9966 9966 1996-08-05 Government of Oman (as Directed by Patton, Boggs & Blow) 1994-09-19 OMAN DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP Muscat        
9967 9967 1996-08-05 Republic of Palau 1995-10-13 PALAU DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP Koror        
9968 9968 1999-08-05 Government of Gabon 1999-07-01 GABON DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP Libreville        
9969 9969 2001-08-05 United Arab Emirates 1998-10-23 UNITED ARAB EMIRATES DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP Abu Dhabi        
9970 9970 2003-08-05 Government of Thailand 2002-02-04 THAILAND DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP Central Administrative Office Government House Nakhon Pathorn Road Bangkok 10300        
10935 10935 2009-08-31 Kingdom of Saudi Arabia Ministry of Commerce and Industry 2009-04-03 SAUDI ARABIA DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP Riyadh, 11162        
10989 10989 2020-08-31 Embassy of the Islamic Republic of Afghanistan 2018-09-20 AFGHANISTAN DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP 2341 Wyoming Avenue   Washington DC 20008
10991 10991 2020-08-31 Kingdom of Bahrain 2014-05-20 BAHRAIN DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP Ministry of Foreign Affairs P.O. Box 547 Government Road Manama      
11094 11094 2002-09-01 Sinergia 7 (on behalf of the Government of the State of Hidalgo, Mexico) 2002-09-04 MEXICO DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP Blvd. Adolfo Lopez Mateos No. 1986 Col. Los Alpes DF Mexico 01010        
11111 11111 2017-09-01 Kingdom of Saudi Arabia Ministry of Foreign Affairs 2016-05-31 SAUDI ARABIA DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP P.O. Box 55937 Riyadh City, 11544        
11462 11462 2007-09-15 Government of the Republic of Cote D'Ivoire, Embassy 2002-10-30 COTE D'IVOIRE (IVORY COAST) DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP 3421 Massachusetts Avenue, N.W. 20008     DC  
11463 11463 2010-09-15 Government of Alberta 2009-04-14 CANADA DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP P.O. Box 1333   Edmonton    
11989 11989 2009-09-30 Senado de Mexico 2001-04-26 MEXICO DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP Senado de Mexico Mexico, D.G.        
12232 12232 1990-10-03 Consolidated Grain & Barge Company 1988-09-19 JAPAN DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP St. Louis     MO  
12311 12311 2019-10-07 Embassy of the Hellenic Republic 2018-09-28 GREECE DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP          
12551 12551 2020-10-16 Azerbaijan Railways CJSC 2019-10-09 AZERBAIJAN DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP D. Aliyeva 230 Baku AZ1010      
12939 12939 2002-10-30 Government of the Republic of Malawi 2002-02-04 MALAWI DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP Private Bag 301 Capital City Lilongwe 3 Central Africa        
12940 12940 2002-10-30 Republic of China (Taiwan) through the Taipei Economic and Cultural Representative Office in the United States 1998-01-06 TAIWAN DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP Washington     DC  
13636 13636 2021-11-10 The Royal Hashemite Court 2021-09-30 JORDAN DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP The Royal Palace   Amman    
13645 13645 2008-11-11 Executive Office of Dubai 2008-06-26 UNITED ARAB EMIRATES DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP Emirates Towers, Level 38 P.O. Box 73311 Dubai    
13686 13686 2008-11-13 Government of Ethiopia, Embassy 2006-05-04 ETHIOPIA DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP 3506 International Drive, NW   Washington DC 20008
13746 13746 1993-11-15 Institute of International Bankers 1991-11-25 INTERNATIONAL DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP New York     NY  
13747 13747 1993-11-15 Matra Aerospace, Inc. 1989-05-25 FRANCE DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP Arlington     VA  
14258 14258 2002-11-30 Foreign Ministry of the Republic of Slovenia 2002-02-04 SLOVENIA DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP Ministry of Foreign Affairs Presernova 25 1000 Ljubljana        
14958 14958 2008-12-18 Sheikh Mohammed Bin Rashid Al Maktoum, Prime Minister and Vice President of the United Arab Emirates, et al 2006-11-20 UNITED ARAB EMIRATES DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP c/o Dr. Habib Al Mulla Emirates Towers, Level 38 - P.O. Box 73311 Dubai    
16023 16023 1995-12-31 AECL Technologies, Inc. 1995-10-13 CANADA DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP Rockville     MD  
16038 16038 1995-12-31 Centro Industrial de Laboratorios Farmaceuticos Argentinos (CILFA) 1995-06-02 ARGENTINA DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP Buenos Aires        
16079 16079 1995-12-31 J.D. Irving 1985-08-05 CANADA DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP St. John New Brusn.        
16643 16643 2021-12-31 Palestine Monetary Authority 2015-07-23 PALESTINE DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP P.O. Box 452 Ramallah      

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