FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
22 rows where Country/Location_Represented = "CUBA" and State = "FL"
This data as json, CSV (advanced)
Foreign_Principal 8
Registrant_Name 6
State 1
- FL · 8 ✖
Country/Location_Represented 1
- CUBA · 8 ✖
City 1
- - 8
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10289 | 10289 | 1963-08-12 | Ejercito Libertador de Cuba | 1963-07-08 | CUBA | Betancourt, Ernesto F. 1644 | 1963-07-08 | Betancourt, Ernesto F. | Miami | FL | |||
10754 | 10754 | 1956-08-26 | Dr. Carlos Prio Socarras | 1954-02-26 | CUBA | Fiallo, Rene 818 | 1954-02-26 | Fiallo, Rene | Miami | FL | |||
10878 | 10878 | 1963-08-31 | Consulate of Cuba | 1961-03-30 | CUBA | Fernandez, Carlos B. 1409 | 1960-11-22 | Fernandez, Carlos B. | Miami | FL | |||
11825 | 11825 | 1960-09-26 | Hector Garcia Soto | 1960-09-26 | CUBA | Asencio, Armando J. 1395 | 1960-09-26 | Asencio, Armando J. | Miami | FL | |||
13913 | 13913 | 1958-11-13 | Junta de Liberacion | 1957-11-13 | CUBA | Prio Socarras, Carlos 1082 | 1957-11-13 | Prio Socarras, Carlos | Miami | FL | |||
14145 | 14145 | 1963-11-22 | Cuban Air Force, Attache' (Captain Randolfo Cossio) | 1961-03-30 | CUBA | Fernandez, Carlos B. 1409 | 1960-11-22 | Fernandez, Carlos B. | Miami | FL | |||
14149 | 14149 | 1963-11-22 | Frente Revolucionario Democratico | 1960-11-22 | CUBA | Fernandez, Carlos B. 1409 | 1960-11-22 | Fernandez, Carlos B. | Miami | FL | |||
15401 | 15401 | 1963-12-27 | Movimiento Democrata Cristiano (Christian Democrat Movement) (Underground) | 1961-12-07 | CUBA | Movimiento Democrata Cristiano de Cuba (MDC) 1498 | 1961-12-07 | Movimiento Democrata Cristiano de Cuba (MDC) | Miami | FL |
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]) );