FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
6 rows where Address_1 = "San Salvador" and Foreign_Principal = "Government of El Salvador"
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Registrant_Name 6
State 1
- - 6
Foreign_Principal 1
- Government of El Salvador · 6 ✖
Country/Location_Represented 1
City 1
- - 6
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7818 | 7818 | 1979-06-15 | Government of El Salvador | 1979-03-15 | EL SALVADOR | Berry, Max N. 2216 | 1970-10-30 | Berry, Max N. | San Salvador | ||||
11072 | 11072 | 2001-08-31 | Government of El Salvador | 2000-06-02 | EL SALVADOR | Holland & Knight 3718 | 1985-08-07 | Holland & Knight | San Salvador | ||||
13046 | 13046 | 1976-10-26 | Government of El Salvador | 1976-03-10 | EL SALVADOR | Daniels, Houlihan & Palmeter 2072 | 1968-01-30 | Daniels, Houlihan & Palmeter | San Salvador | ||||
13798 | 13798 | 1979-11-07 | Government of El Salvador | 1977-09-26 | EL SALVADOR | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | San Salvador | ||||
15763 | 15763 | 1976-12-31 | Government of El Salvador | 1965-08-16 | EL SALVADOR | Pan-American Coffee Bureau 406 | 1946-12-06 | Pan-American Coffee Bureau | San Salvador | ||||
16160 | 16160 | 1990-12-31 | Government of El Salvador | 1990-04-18 | EL SALVADOR | FMR Group, Inc. 4381 | 1990-04-18 | FMR Group, Inc. | San Salvador |
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]) );