FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
12 rows where Registrant_Name = "Covington & Burling, LLP" sorted by Address_2
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Registration_Date, Registration_Number, Registrant_Date, Address_2, Zip, Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Foreign_Principal 12
- Alassane Ouattara, President, Republic of Cote d'Ivoire 1
- Commonwealth of Australia, Embassy 1
- Corporacion Colombia Internacional CCI 1
- Embassy of New Zealand 1
- Embassy of Republic of Korea in United States 1
- Embassy of the Grand Duchy of Luxembourg 1
- Government of Spain, Embassy 1
- Korea Atomic Energy Research Institute (KAERI) 1
- Principality of Liechtenstein, Embassy 1
- Republic of Cyprus, Embassy 1
- Republic of the Philippines, Embassy 1
- United Mexican States 1
Country/Location_Represented 11
- KOREA, SOUTH 2
- AUSTRALIA 1
- COLOMBIA 1
- COTE D'IVOIRE (IVORY COAST) 1
- CYPRUS 1
- LIECHTENSTEIN 1
- LUXEMBOURG 1
- MEXICO 1
- NEW ZEALAND 1
- PHILIPPINES 1
- SPAIN 1
City 2
- - 7
- Washington 5
Registrant_Name 1
- Covington & Burling, LLP · 12 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3112 | 3112 | 2015-02-28 | Embassy of New Zealand | 2013-06-10 | NEW ZEALAND | Covington & Burling, LLP 5852 | 2008-02-05 | Covington & Burling, LLP | 37 Observatory Circle, NW | Washington | DC | 20008 | |
3121 | 3121 | 2017-02-28 | Government of Spain, Embassy | 2011-06-03 | SPAIN | Covington & Burling, LLP 5852 | 2008-02-05 | Covington & Burling, LLP | 2375 Pennsylvania Avenue, NW | Washington | DC | 20037 | |
5150 | 5150 | 2013-04-10 | Embassy of the Grand Duchy of Luxembourg | 2013-03-01 | LUXEMBOURG | Covington & Burling, LLP 5852 | 2008-02-05 | Covington & Burling, LLP | 2200 Massachusetts Avenue, NW | Washington | DC | 20008 | |
7205 | 7205 | 2006-05-31 | Commonwealth of Australia, Embassy | 2004-05-07 | AUSTRALIA | Covington & Burling, LLP 5621 | 2004-05-07 | Covington & Burling, LLP | 1601 Massachusetts Avenue, N.W. 20036 | ||||
10544 | 10544 | 2010-08-15 | Republic of the Philippines, Embassy | 2008-02-05 | PHILIPPINES | Covington & Burling, LLP 5852 | 2008-02-05 | Covington & Burling, LLP | 1600 Massachusetts Avenue, NW | Washington | DC | 20036 | |
10588 | 10588 | 2012-08-17 | Principality of Liechtenstein, Embassy | 2008-07-08 | LIECHTENSTEIN | Covington & Burling, LLP 5852 | 2008-02-05 | Covington & Burling, LLP | 1600 Massachusetts Avenue, NW | Washington | DC | 20036 | |
11120 | 11120 | 2007-08-31 | Republic of Cyprus, Embassy | 2004-05-07 | CYPRUS | Covington & Burling, LLP 5621 | 2004-05-07 | Covington & Burling, LLP | 2211 R Street, N.W. 20008 | DC | |||
11738 | 11738 | 2012-09-20 | Korea Atomic Energy Research Institute (KAERI) | 2011-12-07 | KOREA, SOUTH | Covington & Burling, LLP 5852 | 2008-02-05 | Covington & Burling, LLP | 1045 Daedeokdaero Yuseong, Daejeon, 305-353 | ||||
16729 | 16729 | 2013-12-31 | Embassy of Republic of Korea in United States | 2012-11-15 | KOREA, SOUTH | Covington & Burling, LLP 5852 | 2008-02-05 | Covington & Burling, LLP | |||||
11677 | 11677 | 2015-09-16 | Corporacion Colombia Internacional CCI | 2014-12-01 | COLOMBIA | Covington & Burling, LLP 5852 | 2008-02-05 | Covington & Burling, LLP | Calle 16 No. 6-66 - piso 7 | Bogota D.C. | |||
8017 | 8017 | 2010-06-22 | United Mexican States | 2009-07-29 | MEXICO | Covington & Burling, LLP 5852 | 2008-02-05 | Covington & Burling, LLP | Secretaria de Hacienda y Credito Publico | Palacio Nacional S/N, Col. Centro, C.P. 06000 Cuauhtemoc, Distrito Federal | |||
11140 | 11140 | 2011-08-31 | Alassane Ouattara, President, Republic of Cote d'Ivoire | 2011-01-12 | COTE D'IVOIRE (IVORY COAST) | Covington & Burling, LLP 5852 | 2008-02-05 | Covington & Burling, LLP | H.E. Alassane D. Ouattara | President of the Republic of Cote d'Ivoire |
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]) );