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
243 243   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        
491 491   Palestine Monetary Authority 2015-07-23 PALESTINE 3712 3712 1985-08-05 DLA Piper US LLP P.O. Box 452 Ramallah      
938 938 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
1359 1359 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
1533 1533 2003-01-30 Foreign Ministry of the Republic of Montenegro 2001-02-22 MONTENEGRO 3712 3712 1985-08-05 DLA Piper US LLP Podgorica        
1534 1534 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        
1721 1721 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        
2043 2043 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        
2071 2071 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        
2094 2094 1999-02-05 Government of Chile, Embassy 1997-10-03 CHILE 3712 3712 1985-08-05 DLA Piper US LLP Washington     DC  
2095 2095 1999-02-05 Government of Uruguay 1995-11-16 URUGUAY 3712 3712 1985-08-05 DLA Piper US LLP Washington     DC  
2096 2096 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        
2097 2097 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  
2098 2098 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        
2099 2099 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  
2100 2100 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  
2109 2109 1988-02-06 Deambinox, S.A. 1987-12-11 FRANCE 3712 3712 1985-08-05 DLA Piper US LLP Nantes        
2932 2932 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
2991 2991 2021-02-28 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      
2992 2992 2021-02-28 Innovation Norway 2020-03-11 NORWAY 3712 3712 1985-08-05 DLA Piper US LLP Akersgata 13 0158 Oslo      
3168 3168 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  
3180 3180 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  
3239 3239 1995-03-03 Oerlikon-Buhrle, Ltd. 1985-12-09 SWITZERLAND 3712 3712 1985-08-05 DLA Piper US LLP          
3334 3334 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        
4576 4576 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
4734 4734 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  
5353 5353 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        
5846 5846 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        
5989 5989 2016-05-01 Royal Embassy of Saudi Arabia 2015-03-31 SAUDI ARABIA 3712 3712 1985-08-05 DLA Piper US LLP          
6449 6449 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    
7139 7139 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        
7148 7148 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    
7402 7402 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    
7404 7404 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
9540 9540 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        
9682 9682 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  
9749 9749 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  
9772 9772 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  
9782 9782 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        
9783 9783 1996-08-05 Republic of Palau 1995-10-13 PALAU 3712 3712 1985-08-05 DLA Piper US LLP Koror        
9784 9784 1999-08-05 Government of Gabon 1999-07-01 GABON 3712 3712 1985-08-05 DLA Piper US LLP Libreville        
9785 9785 2001-08-05 United Arab Emirates 1998-10-23 UNITED ARAB EMIRATES 3712 3712 1985-08-05 DLA Piper US LLP Abu Dhabi        
9786 9786 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        
10748 10748 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        
10800 10800 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
10802 10802 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      
10900 10900 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        
10917 10917 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        
11265 11265 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  
11266 11266 2010-09-15 Government of Alberta 2009-04-14 CANADA 3712 3712 1985-08-05 DLA Piper US LLP P.O. Box 1333   Edmonton    
11783 11783 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.        
12013 12013 1990-10-03 Consolidated Grain & Barge Company 1988-09-19 JAPAN 3712 3712 1985-08-05 DLA Piper US LLP St. Louis     MO  
12092 12092 2019-10-07 Embassy of the Hellenic Republic 2018-09-28 GREECE 3712 3712 1985-08-05 DLA Piper US LLP          
12330 12330 2020-10-16 Azerbaijan Railways CJSC 2019-10-09 AZERBAIJAN 3712 3712 1985-08-05 DLA Piper US LLP D. Aliyeva 230 Baku AZ1010      
12714 12714 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        
12715 12715 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  
13406 13406 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    
13446 13446 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
13506 13506 1993-11-15 Institute of International Bankers 1991-11-25 INTERNATIONAL 3712 3712 1985-08-05 DLA Piper US LLP New York     NY  
13507 13507 1993-11-15 Matra Aerospace, Inc. 1989-05-25 FRANCE 3712 3712 1985-08-05 DLA Piper US LLP Arlington     VA  
14015 14015 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        
14702 14702 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    
15765 15765 1995-12-31 AECL Technologies, Inc. 1995-10-13 CANADA 3712 3712 1985-08-05 DLA Piper US LLP Rockville     MD  
15780 15780 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        
15821 15821 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)
);