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, 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
53 53   Azerbaijan Railways CJSC 2019-10-09 AZERBAIJAN 3712 3712 1985-08-05 DLA Piper US LLP D. Aliyeva 230 Baku AZ1010      
166 166   Embassy of the Islamic Republic of Afghanistan 2018-09-20 AFGHANISTAN 3712 3712 1985-08-05 DLA Piper US LLP          
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        
279 279   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      
365 365   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      
494 494   Palestine Monetary Authority 2015-07-23 PALESTINE 3712 3712 1985-08-05 DLA Piper US LLP P.O. Box 452 Ramallah      
948 948 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
1363 1363 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
1532 1532 2003-01-30 Foreign Ministry of the Republic of Montenegro 2001-02-22 MONTENEGRO 3712 3712 1985-08-05 DLA Piper US LLP Podgorica        
1533 1533 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        
1720 1720 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        
2035 2035 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        
2063 2063 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        
2085 2085 1999-02-05 Government of Chile, Embassy 1997-10-03 CHILE 3712 3712 1985-08-05 DLA Piper US LLP Washington     DC  
2086 2086 1999-02-05 Government of Uruguay 1995-11-16 URUGUAY 3712 3712 1985-08-05 DLA Piper US LLP Washington     DC  
2087 2087 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        
2088 2088 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  
2089 2089 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        
2090 2090 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  
2091 2091 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  
2100 2100 1988-02-06 Deambinox, S.A. 1987-12-11 FRANCE 3712 3712 1985-08-05 DLA Piper US LLP Nantes        
2914 2914 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
3144 3144 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  
3156 3156 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  
3214 3214 1995-03-03 Oerlikon-Buhrle, Ltd. 1985-12-09 SWITZERLAND 3712 3712 1985-08-05 DLA Piper US LLP          
3309 3309 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        
4547 4547 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
4694 4694 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  
5301 5301 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        
5792 5792 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        
5930 5930 2016-05-01 Royal Embassy of Saudi Arabia 2015-03-31 SAUDI ARABIA 3712 3712 1985-08-05 DLA Piper US LLP          
6387 6387 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    
7074 7074 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        
7083 7083 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    
7332 7332 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    
7334 7334 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
9459 9459 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        
9591 9591 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  
9656 9656 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  
9679 9679 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  
9689 9689 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        
9690 9690 1996-08-05 Republic of Palau 1995-10-13 PALAU 3712 3712 1985-08-05 DLA Piper US LLP Koror        
9691 9691 1999-08-05 Government of Gabon 1999-07-01 GABON 3712 3712 1985-08-05 DLA Piper US LLP Libreville        
9692 9692 2001-08-05 United Arab Emirates 1998-10-23 UNITED ARAB EMIRATES 3712 3712 1985-08-05 DLA Piper US LLP Abu Dhabi        
9693 9693 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        
10651 10651 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        
10797 10797 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        
10814 10814 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        
11159 11159 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  
11160 11160 2010-09-15 Government of Alberta 2009-04-14 CANADA 3712 3712 1985-08-05 DLA Piper US LLP P.O. Box 1333   Edmonton    
11671 11671 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.        
11895 11895 1990-10-03 Consolidated Grain & Barge Company 1988-09-19 JAPAN 3712 3712 1985-08-05 DLA Piper US LLP St. Louis     MO  
11973 11973 2019-10-07 Embassy of the Hellenic Republic 2018-09-28 GREECE 3712 3712 1985-08-05 DLA Piper US LLP          
12581 12581 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        
12582 12582 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  
13267 13267 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    
13306 13306 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
13366 13366 1993-11-15 Institute of International Bankers 1991-11-25 INTERNATIONAL 3712 3712 1985-08-05 DLA Piper US LLP New York     NY  
13367 13367 1993-11-15 Matra Aerospace, Inc. 1989-05-25 FRANCE 3712 3712 1985-08-05 DLA Piper US LLP Arlington     VA  
13872 13872 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        
14549 14549 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    
15612 15612 1995-12-31 AECL Technologies, Inc. 1995-10-13 CANADA 3712 3712 1985-08-05 DLA Piper US LLP Rockville     MD  
15627 15627 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        
15668 15668 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 184.916ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history