FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
18 rows where Registrant_Name = "DLA Piper US LLP" and State = "DC" sorted by Zip descending
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Termination_Date, Address_1, Zip, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Foreign_Principal 18
- Embassy of the Islamic Republic of Afghanistan 1
- Embassy of the United Arab Emirates 1
- Embassy of the United Kingdom 1
- Government of Chile, Embassy 1
- Government of Ethiopia (Embassy) 1
- Government of Ethiopia, Embassy 1
- Government of Japan, Embassy 1
- Government of Mexico, Embassy 1
- Government of Slovenia, Embassy 1
- Government of Spain, Embassy 1
- Government of Turkey, Embassy 1
- Government of Uruguay 1
- Government of the Republic of Cote D'Ivoire, Embassy 1
- Interim Government of Afghanistan, Embassy 1
- Republic of China (Taiwan) through the Taipei Economic and Cultural Representative Office in the United States 1
- Republic of Cyprus Government, Embassy 1
- Republic of Ecuador, Embassy 1
- Republic of Kazakhstan, Embassy through Howard Communications 1
Country/Location_Represented 16
- AFGHANISTAN 2
- ETHIOPIA 2
- CHILE 1
- COTE D'IVOIRE (IVORY COAST) 1
- CYPRUS 1
- ECUADOR 1
- JAPAN 1
- KAZAKHSTAN 1
- MEXICO 1
- SLOVENIA 1
- SPAIN 1
- TAIWAN 1
- TURKEY 1
- UNITED ARAB EMIRATES 1
- UNITED KINGDOM 1
- URUGUAY 1
City 2
- - 11
- Washington 7
State 1
- DC · 18 ✖
Registrant_Name 1
- DLA Piper US LLP · 18 ✖
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 ▲ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1032 | 1032 | 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 | |
1469 | 1469 | 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 | |
3083 | 3083 | 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 | |
4773 | 4773 | 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 | |
7710 | 7710 | 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 | |
11184 | 11184 | 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 | |
13928 | 13928 | 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 | |
2224 | 2224 | 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 | |||
2225 | 2225 | 1999-02-05 | Government of Uruguay | 1995-11-16 | URUGUAY | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | Washington | DC | |||
2227 | 2227 | 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 | |||
2230 | 2230 | 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 | |||
3344 | 3344 | 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 | |||
4951 | 4951 | 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 | |||
10043 | 10043 | 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 | |||
10113 | 10113 | 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 | |||
10137 | 10137 | 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 | |||
11662 | 11662 | 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 | |||
13174 | 13174 | 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 |
Advanced export
JSON shape: default, array, newline-delimited
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]) );