FARA_All_ForeignPrincipals

Table actions
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 = "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)

State

Registrant_Name

  • DLA Piper 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
239 239   German State of Rheinland-Pfalz 2003-09-25 GERMANY 3712 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        
275 275   Government of the Democratic Republic of Timor-Leste 2016-06-26 TIMOR-LESTE (EAST TIMOR) 3712 3712 1985-08-05 DLA Piper US LLP Maritime Boundary Office 1st Floor, West Wing Building, Government Palace Avenida Marginal Dili      
317 317   Innovation Norway 2020-03-11 NORWAY 3712 3712 1985-08-05 DLA Piper US LLP Akersgata 13 0158 Oslo      
488 488   Palestine Monetary Authority 2015-07-23 PALESTINE 3712 3712 1985-08-05 DLA Piper US LLP P.O. Box 452 Ramallah      
936 936 2017-01-01 Republic of Ecuador, Embassy 2016-08-26 ECUADOR 3712 3712 1985-08-05 DLA Piper US LLP 2535 15th Street, NW   Washington DC 20009
1355 1355 2009-01-22 Government of Turkey, Embassy 2007-05-10 TURKEY 3712 3712 1985-08-05 DLA Piper US LLP 2525 Massachusetts Avenue, NW   Washington DC 20008
1529 1529 2003-01-30 Foreign Ministry of the Republic of Montenegro 2001-02-22 MONTENEGRO 3712 3712 1985-08-05 DLA Piper US LLP Podgorica        
1530 1530 2003-01-30 President of Kosova 2002-12-26 KOSOVA 3712 3712 1985-08-05 DLA Piper US LLP Government Building, Room E-106 Mother Teresa Street Pristina        
1717 1717 2002-01-31 Ministry of Foreign Affairs of the Republic of Yemen 2001-02-22 YEMEN 3712 3712 1985-08-05 DLA Piper US LLP Sana'a        
2037 2037 2006-02-03 Government of State of Mexico 2003-12-24 MEXICO 3712 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        
2065 2065 2005-02-04 Government of Thailand 2003-10-28 THAILAND 3712 3712 1985-08-05 DLA Piper US LLP Central Administrative Office Government House Nakhon Pathorn Road Bangkok 10300        
2088 2088 1999-02-05 Government of Chile, Embassy 1997-10-03 CHILE 3712 3712 1985-08-05 DLA Piper US LLP Washington     DC  
2089 2089 1999-02-05 Government of Uruguay 1995-11-16 URUGUAY 3712 3712 1985-08-05 DLA Piper US LLP Washington     DC  
2090 2090 1999-02-05 Government of the Marshall Islands, Minister of Foreign Affairs 1996-02-21 MARSHALL ISLANDS 3712 3712 1985-08-05 DLA Piper US LLP Majuro        
2091 2091 2000-02-05 Government of Slovenia, Embassy 1998-09-23 SLOVENIA 3712 3712 1985-08-05 DLA Piper US LLP 1525 New Hampshire Avenue, N.W.     DC  
2092 2092 2000-02-05 Governor of Cordoba, Argentina 1999-04-28 ARGENTINA 3712 3712 1985-08-05 DLA Piper US LLP Chacabuco 1300 Barrio Nueva Cordoba Codigo Postal 5000        
2093 2093 2000-02-05 United Nations Industrial Development Organization 1999-10-04 INTERNATIONAL 3712 3712 1985-08-05 DLA Piper US LLP United Office of New York One United Nations Plaza, Room DC1-1110 New York     NY  
2094 2094 2001-02-05 Government of Mexico, Embassy 1998-12-16 MEXICO 3712 3712 1985-08-05 DLA Piper US LLP 1911 Pennsylvania Avenue, N.W     DC  
2103 2103 1988-02-06 Deambinox, S.A. 1987-12-11 FRANCE 3712 3712 1985-08-05 DLA Piper US LLP Nantes        
2924 2924 2007-02-28 Government of Japan, Embassy 2006-07-26 JAPAN 3712 3712 1985-08-05 DLA Piper US LLP 2520 Massachusetts Avenue, NW   Washington DC 20008
3156 3156 2004-03-01 Government of Haiti 2003-05-07 HAITI 3712 3712 1985-08-05 DLA Piper US LLP Plaza 2650, 2nd Floor 2650 S.W. 27th Avenue Miami 33133     FL  
3168 3168 2013-03-01 Interim Government of Afghanistan, Embassy 2002-03-26 AFGHANISTAN 3712 3712 1985-08-05 DLA Piper US LLP 2000 L Street, N.W. Suite 200 20036     DC  
3227 3227 1995-03-03 Oerlikon-Buhrle, Ltd. 1985-12-09 SWITZERLAND 3712 3712 1985-08-05 DLA Piper US LLP          
3322 3322 2003-03-07 Government of India, Embassy 1998-07-13 INDIA 3712 3712 1985-08-05 DLA Piper US LLP 2107 Massachusetts Ave., NW, Washington, DC        
4561 4561 2018-03-31 Embassy of the United Arab Emirates 2008-12-15 UNITED ARAB EMIRATES 3712 3712 1985-08-05 DLA Piper US LLP 3522 International Court, NW   Washington DC 20008
4710 4710 2004-04-01 Republic of Cyprus Government, Embassy 2001-02-22 CYPRUS 3712 3712 1985-08-05 DLA Piper US LLP 2211 R Street, N.W. 20008     DC  
5325 5325 2001-04-25 Egyptian Civil Aviation Authority 2000-05-15 EGYPT 3712 3712 1985-08-05 DLA Piper US LLP General Abd ElFattah M. Kato, Chairman Cairo        
5817 5817 2016-04-30 PRONACOM (Programa Nacional de la Competitividad) 2015-12-07 GUATEMALA 3712 3712 1985-08-05 DLA Piper US LLP 13 Calle 13 zona 10 Edificio Atlantis, Torre 2, Nivel 3, Oficina 302        
5960 5960 2016-05-01 Royal Embassy of Saudi Arabia 2015-03-31 SAUDI ARABIA 3712 3712 1985-08-05 DLA Piper US LLP          
6420 6420 2012-05-22 Presidential Campaign of Hipolito Mejia 2012-01-30 DOMINICAN REPUBLIC 3712 3712 1985-08-05 DLA Piper US LLP Calle Alberto Larancuent #8 Ensanche Naco Distrito Nacional, Republic Dominicana Santo Domingo    
7110 7110 2002-06-01 Sinergia 7 (on behalf of the Government of the State of Chihuahua, Mexico) 2002-09-04 MEXICO 3712 3712 1985-08-05 DLA Piper US LLP Blvd. Adolfo Lopez Mateos No. 1986 Col. Los Alpes DF Mexico 01010        
7119 7119 2008-06-01 Borse Dubai Limited 2007-11-02 UNITED ARAB EMIRATES 3712 3712 1985-08-05 DLA Piper US LLP P.O. Box 74777, Level 14 - The Gate Dubai International Financial Centre Dubai    
7372 7372 2009-06-09 State of Tamaulipas 2008-04-22 MEXICO 3712 3712 1985-08-05 DLA Piper US LLP Palacio de Gobierno 3er Piso, 15 y 16 Juarez Zona Centro CP 87000 Ciudad Victoria Tamaulipas    
7374 7374 2017-06-09 Embassy of the United Kingdom 2017-05-18 UNITED KINGDOM 3712 3712 1985-08-05 DLA Piper US LLP 3100 Massachusetts Avenue, NW   Washington DC 20008
9508 9508 2013-07-31 Government of Bermuda 2013-05-23 BERMUDA 3712 3712 1985-08-05 DLA Piper US LLP 300 Parliament Street 2nd Floor Hamilton HM 12        
9649 9649 2006-08-01 Government of Spain, Embassy 2004-01-28 SPAIN 3712 3712 1985-08-05 DLA Piper US LLP 2375 Pennsylvania Avenue, N.W. 20037     DC  
9716 9716 2004-08-03 Government of Ethiopia (Embassy) 1999-04-28 ETHIOPIA 3712 3712 1985-08-05 DLA Piper US LLP 2134 Kalorama Road, N.W. Washington, D.C. 20008     DC  
9739 9739 2005-08-04 Republic of Kazakhstan, Embassy through Howard Communications 2001-07-23 KAZAKHSTAN 3712 3712 1985-08-05 DLA Piper US LLP The Embassy of the Republic of Kazakhstan 1401 16th Street N.W. 20036     DC  
9749 9749 1996-08-05 Government of Oman (as Directed by Patton, Boggs & Blow) 1994-09-19 OMAN 3712 3712 1985-08-05 DLA Piper US LLP Muscat        
9750 9750 1996-08-05 Republic of Palau 1995-10-13 PALAU 3712 3712 1985-08-05 DLA Piper US LLP Koror        
9751 9751 1999-08-05 Government of Gabon 1999-07-01 GABON 3712 3712 1985-08-05 DLA Piper US LLP Libreville        
9752 9752 2001-08-05 United Arab Emirates 1998-10-23 UNITED ARAB EMIRATES 3712 3712 1985-08-05 DLA Piper US LLP Abu Dhabi        
9753 9753 2003-08-05 Government of Thailand 2002-02-04 THAILAND 3712 3712 1985-08-05 DLA Piper US LLP Central Administrative Office Government House Nakhon Pathorn Road Bangkok 10300        
10715 10715 2009-08-31 Kingdom of Saudi Arabia Ministry of Commerce and Industry 2009-04-03 SAUDI ARABIA 3712 3712 1985-08-05 DLA Piper US LLP Riyadh, 11162        
10767 10767 2020-08-31 Embassy of the Islamic Republic of Afghanistan 2018-09-20 AFGHANISTAN 3712 3712 1985-08-05 DLA Piper US LLP 2341 Wyoming Avenue   Washington DC 20008
10768 10768 2020-08-31 Kingdom of Bahrain 2014-05-20 BAHRAIN 3712 3712 1985-08-05 DLA Piper US LLP Ministry of Foreign Affairs P.O. Box 547 Government Road Manama      
10866 10866 2002-09-01 Sinergia 7 (on behalf of the Government of the State of Hidalgo, Mexico) 2002-09-04 MEXICO 3712 3712 1985-08-05 DLA Piper US LLP Blvd. Adolfo Lopez Mateos No. 1986 Col. Los Alpes DF Mexico 01010        
10883 10883 2017-09-01 Kingdom of Saudi Arabia Ministry of Foreign Affairs 2016-05-31 SAUDI ARABIA 3712 3712 1985-08-05 DLA Piper US LLP P.O. Box 55937 Riyadh City, 11544        
11230 11230 2007-09-15 Government of the Republic of Cote D'Ivoire, Embassy 2002-10-30 COTE D'IVOIRE (IVORY COAST) 3712 3712 1985-08-05 DLA Piper US LLP 3421 Massachusetts Avenue, N.W. 20008     DC  
11231 11231 2010-09-15 Government of Alberta 2009-04-14 CANADA 3712 3712 1985-08-05 DLA Piper US LLP P.O. Box 1333   Edmonton    
11747 11747 2009-09-30 Senado de Mexico 2001-04-26 MEXICO 3712 3712 1985-08-05 DLA Piper US LLP Senado de Mexico Mexico, D.G.        
11977 11977 1990-10-03 Consolidated Grain & Barge Company 1988-09-19 JAPAN 3712 3712 1985-08-05 DLA Piper US LLP St. Louis     MO  
12056 12056 2019-10-07 Embassy of the Hellenic Republic 2018-09-28 GREECE 3712 3712 1985-08-05 DLA Piper US LLP          
12293 12293 2020-10-16 Azerbaijan Railways CJSC 2019-10-09 AZERBAIJAN 3712 3712 1985-08-05 DLA Piper US LLP D. Aliyeva 230 Baku AZ1010      
12677 12677 2002-10-30 Government of the Republic of Malawi 2002-02-04 MALAWI 3712 3712 1985-08-05 DLA Piper US LLP Private Bag 301 Capital City Lilongwe 3 Central Africa        
12678 12678 2002-10-30 Republic of China (Taiwan) through the Taipei Economic and Cultural Representative Office in the United States 1998-01-06 TAIWAN 3712 3712 1985-08-05 DLA Piper US LLP Washington     DC  
13368 13368 2008-11-11 Executive Office of Dubai 2008-06-26 UNITED ARAB EMIRATES 3712 3712 1985-08-05 DLA Piper US LLP Emirates Towers, Level 38 P.O. Box 73311 Dubai    
13408 13408 2008-11-13 Government of Ethiopia, Embassy 2006-05-04 ETHIOPIA 3712 3712 1985-08-05 DLA Piper US LLP 3506 International Drive, NW   Washington DC 20008
13468 13468 1993-11-15 Institute of International Bankers 1991-11-25 INTERNATIONAL 3712 3712 1985-08-05 DLA Piper US LLP New York     NY  
13469 13469 1993-11-15 Matra Aerospace, Inc. 1989-05-25 FRANCE 3712 3712 1985-08-05 DLA Piper US LLP Arlington     VA  
13977 13977 2002-11-30 Foreign Ministry of the Republic of Slovenia 2002-02-04 SLOVENIA 3712 3712 1985-08-05 DLA Piper US LLP Ministry of Foreign Affairs Presernova 25 1000 Ljubljana        
14663 14663 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 3712 3712 1985-08-05 DLA Piper US LLP c/o Dr. Habib Al Mulla Emirates Towers, Level 38 - P.O. Box 73311 Dubai    
15726 15726 1995-12-31 AECL Technologies, Inc. 1995-10-13 CANADA 3712 3712 1985-08-05 DLA Piper US LLP Rockville     MD  
15741 15741 1995-12-31 Centro Industrial de Laboratorios Farmaceuticos Argentinos (CILFA) 1995-06-02 ARGENTINA 3712 3712 1985-08-05 DLA Piper US LLP Buenos Aires        
15782 15782 1995-12-31 J.D. Irving 1985-08-05 CANADA 3712 3712 1985-08-05 DLA Piper US LLP St. John New Brusn.        

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)
);