FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
11 rows where City = "", Registrant_Name = "DLA Piper US LLP" and State = "DC"
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Foreign_Principal 11
- Government of Chile, Embassy 1
- Government of Ethiopia (Embassy) 1
- Government of Mexico, Embassy 1
- Government of Slovenia, Embassy 1
- Government of Spain, 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 Kazakhstan, Embassy through Howard Communications 1
Country/Location_Represented 11
- AFGHANISTAN 1
- CHILE 1
- COTE D'IVOIRE (IVORY COAST) 1
- CYPRUS 1
- ETHIOPIA 1
- KAZAKHSTAN 1
- MEXICO 1
- SLOVENIA 1
- SPAIN 1
- TAIWAN 1
- URUGUAY 1
Address_1 9 ✖
- Washington 3
- 1525 New Hampshire Avenue, N.W. 1
- 1911 Pennsylvania Avenue, N.W 1
- 2000 L Street, N.W. Suite 200 20036 1
- 2134 Kalorama Road, N.W. Washington, D.C. 20008 1
- 2211 R Street, N.W. 20008 1
- 2375 Pennsylvania Avenue, N.W. 20037 1
- 3421 Massachusetts Avenue, N.W. 20008 1
- The Embassy of the Republic of Kazakhstan 1401 16th Street N.W. 20036 1
State 1
- DC · 11 ✖
Registrant_Name 1
- DLA Piper US LLP · 11 ✖
City 1
- - · 11 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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]) );