FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
15 rows where Registrant_Name = "Covington & Burling" and State = "DC" sorted by Registrant_Date
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Termination_Date, Foreign_Principal_Registration_Date, Foreign_Principal_Termination_Date (date)
Foreign_Principal 15
- Ambassador of the Kingdom of Denmark 1
- Dominion of Canada 1
- Embassy of the Republic of South Africa 1
- Government of Canada 1
- Government of Ecuador 1
- Government of Greece 1
- Government of Lebanon 1
- Government of Venezuela 1
- Government of the Kingdom of Cambodia 1
- Government of the Republic of Korea 1
- Greek Ambassador - Permanent Representatives of Greece to the United Nations 1
- His Excellency, Senor Don Fernando Berckemeyer 1
- His Excellency, the Colombian Ambassador Senor Dr. Don Gonzalo Restrepo-Jaramillo 1
- Iranian Ambassador 1
- Legation of Finland 1
Foreign_Principal_Registration_Date (date) 13 ✖
- 1948-04-16 3
- 1948-07-08 1
- 1949-07-08 1
- 1950-08-17 1
- 1952-11-21 1
- 1959-08-27 1
- 1960-05-16 1
- 1960-07-13 1
- 1961-01-10 1
- 1961-02-27 1
- 1962-06-19 1
- 1964-04-29 1
- 1965-09-27 1
Country/Location_Represented 13
State 1
- DC · 15 ✖
Registrant_Name 1
- Covington & Burling · 15 ✖
Registrant_Date (date) 1 ✖
- 1948-04-16 15
City 1
- - 15
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
819 | 819 | 1973-01-01 | Iranian Ambassador | 1948-04-16 | IRAN | Covington & Burling 523 | 1948-04-16 | Covington & Burling | Washington | DC | |||
2120 | 2120 | 1955-02-03 | Dominion of Canada | 1952-11-21 | CANADA | Covington & Burling 523 | 1948-04-16 | Covington & Burling | Washington | DC | |||
5338 | 5338 | 1965-04-17 | Ambassador of the Kingdom of Denmark | 1948-04-16 | DENMARK | Covington & Burling 523 | 1948-04-16 | Covington & Burling | Washington | DC | |||
5340 | 5340 | 1967-04-17 | Government of Lebanon | 1960-05-16 | LEBANON | Covington & Burling 523 | 1948-04-16 | Covington & Burling | Washington | DC | |||
6281 | 6281 | 1966-05-03 | Embassy of the Republic of South Africa | 1965-09-27 | SOUTH AFRICA | Covington & Burling 523 | 1948-04-16 | Covington & Burling | Washington | DC | |||
8980 | 8980 | 1968-07-03 | Government of Canada | 1962-06-19 | CANADA | Covington & Burling 523 | 1948-04-16 | Covington & Burling | Washington | DC | |||
8982 | 8982 | 1968-07-03 | Government of Venezuela | 1959-08-27 | VENEZUELA | Covington & Burling 523 | 1948-04-16 | Covington & Burling | Washington | DC | |||
8983 | 8983 | 1968-07-03 | His Excellency, the Colombian Ambassador Senor Dr. Don Gonzalo Restrepo-Jaramillo | 1948-07-08 | COLOMBIA | Covington & Burling 523 | 1948-04-16 | Covington & Burling | Washington | DC | |||
9319 | 9319 | 1950-07-17 | Greek Ambassador - Permanent Representatives of Greece to the United Nations | 1948-04-16 | GREECE | Covington & Burling 523 | 1948-04-16 | Covington & Burling | Washington | DC | |||
9953 | 9953 | 1961-08-01 | Government of the Republic of Korea | 1961-02-27 | KOREA, SOUTH | Covington & Burling 523 | 1948-04-16 | Covington & Burling | Washington | DC | |||
11680 | 11680 | 1964-09-17 | Government of Greece | 1964-04-29 | GREECE | Covington & Burling 523 | 1948-04-16 | Covington & Burling | Washington | DC | |||
14014 | 14014 | 1977-11-16 | Government of Ecuador | 1960-07-13 | ECUADOR | Covington & Burling 523 | 1948-04-16 | Covington & Burling | Washington | DC | |||
14015 | 14015 | 1977-11-16 | His Excellency, Senor Don Fernando Berckemeyer | 1950-08-17 | PERU | Covington & Burling 523 | 1948-04-16 | Covington & Burling | Washington | DC | |||
14016 | 14016 | 1977-11-16 | Legation of Finland | 1949-07-08 | FINLAND | Covington & Burling 523 | 1948-04-16 | Covington & Burling | Washington | DC | |||
14934 | 14934 | 1962-12-10 | Government of the Kingdom of Cambodia | 1961-01-10 | CAMBODIA | Covington & Burling 523 | 1948-04-16 | Covington & Burling | 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]) );