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 = "DLA Piper US LLP"

✎ View and edit SQL

This data as json, atom, 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 · 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
56 56   Azerbaijan Railways CJSC 2019-10-09 AZERBAIJAN 3712 3712 1985-08-05 DLA Piper US LLP D. Aliyeva 230 Baku AZ1010      
173 173   Embassy of the Hellenic Republic 2018-09-28 GREECE 3712 3712 1985-08-05 DLA Piper US LLP          
174 174   Embassy of the Islamic Republic of Afghanistan 2018-09-20 AFGHANISTAN 3712 3712 1985-08-05 DLA Piper US LLP          
250 250   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        
290 290   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      
381 381   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      
523 523   Palestine Monetary Authority 2015-07-23 PALESTINE 3712 3712 1985-08-05 DLA Piper US LLP P.O. Box 452 Ramallah      
974 974 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
1384 1384 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
1551 1551 2003-01-30 Foreign Ministry of the Republic of Montenegro 2001-02-22 MONTENEGRO 3712 3712 1985-08-05 DLA Piper US LLP Podgorica        
1552 1552 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        
1738 1738 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        
2048 2048 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        
2076 2076 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        
2098 2098 1999-02-05 Government of Chile, Embassy 1997-10-03 CHILE 3712 3712 1985-08-05 DLA Piper US LLP Washington     DC  
2099 2099 1999-02-05 Government of Uruguay 1995-11-16 URUGUAY 3712 3712 1985-08-05 DLA Piper US LLP Washington     DC  
2100 2100 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        
2101 2101 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  
2102 2102 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        
2103 2103 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  
2104 2104 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  
2113 2113 1988-02-06 Deambinox, S.A. 1987-12-11 FRANCE 3712 3712 1985-08-05 DLA Piper US LLP Nantes        
2919 2919 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
3145 3145 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  
3157 3157 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  
3213 3213 1995-03-03 Oerlikon-Buhrle, Ltd. 1985-12-09 SWITZERLAND 3712 3712 1985-08-05 DLA Piper US LLP          
3308 3308 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        
4541 4541 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
4680 4680 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  
5280 5280 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        
5769 5769 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        
5906 5906 2016-05-01 Royal Embassy of Saudi Arabia 2015-03-31 SAUDI ARABIA 3712 3712 1985-08-05 DLA Piper US LLP          
6361 6361 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    
7046 7046 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        
7055 7055 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    
7299 7299 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    
7301 7301 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
9416 9416 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        
9546 9546 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  
9609 9609 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  
9632 9632 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  
9642 9642 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        
9643 9643 1996-08-05 Republic of Palau 1995-10-13 PALAU 3712 3712 1985-08-05 DLA Piper US LLP Koror        
9644 9644 1999-08-05 Government of Gabon 1999-07-01 GABON 3712 3712 1985-08-05 DLA Piper US LLP Libreville        
9645 9645 2001-08-05 United Arab Emirates 1998-10-23 UNITED ARAB EMIRATES 3712 3712 1985-08-05 DLA Piper US LLP Abu Dhabi        
9646 9646 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        
10600 10600 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        
10744 10744 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        
10761 10761 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        
11106 11106 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  
11107 11107 2010-09-15 Government of Alberta 2009-04-14 CANADA 3712 3712 1985-08-05 DLA Piper US LLP P.O. Box 1333   Edmonton    
11617 11617 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.        
11838 11838 1990-10-03 Consolidated Grain & Barge Company 1988-09-19 JAPAN 3712 3712 1985-08-05 DLA Piper US LLP St. Louis     MO  
12518 12518 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        
12519 12519 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  
13198 13198 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    
13237 13237 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
13296 13296 1993-11-15 Institute of International Bankers 1991-11-25 INTERNATIONAL 3712 3712 1985-08-05 DLA Piper US LLP New York     NY  
13297 13297 1993-11-15 Matra Aerospace, Inc. 1989-05-25 FRANCE 3712 3712 1985-08-05 DLA Piper US LLP Arlington     VA  
13801 13801 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        
14465 14465 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    
15525 15525 1995-12-31 AECL Technologies, Inc. 1995-10-13 CANADA 3712 3712 1985-08-05 DLA Piper US LLP Rockville     MD  
15540 15540 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        
15581 15581 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)
);
Powered by Datasette · Query took 151.244ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history