FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
86 rows where Address_1 = "Havana" and Country/Location_Represented = "CUBA" sorted by Zip
This data as json, CSV (advanced)
Foreign_Principal >30
- Partido Revolucionario Cubano (Autentico) 2
- Republic of Cuba 2
- Asociacion Nacional de Hacendados de Cuba (National Cuban Sugar Mills Owners' Association) 1
- Asociacion de Colonos de Cuba (Cuban Sugar Cane Growers' Association) 1
- Autentico Party 1
- Banco Nacional de Cuba 1
- Candido (Previous acting foreign principal deceased) 1
- Captain Alfred Guerra/Officinas Primer Ministro, Captain of Investigation 1
- Caribbean Sugar Company 1
- Comdt. Ramiro Valdes/G2 Army 1
- Compania Cubana 1
- Corporacion Nacional del Turismo de Cuba (Cuban Tourist Commission) 1
- Cuban Tourist Commission 1
- Cuban Tourist Commission (Corporacion Nacional del Turismo) 1
- Dr. Juan Orta/General Director 1
- Fidel Castro 1
- Fidelity Sugar Company 1
- Government of Cuba 1
- Government of the Republic of Cuba 1
- Huge Lajonchere 1
- Instituto Nacional de Estabilizacion del Cafe' 1
- Jorge Quintana 1
- L. Perez Coujil 1
- Manuel Antonio De Varona Y Loredo 1
- Military Intelligence Service, Cuban Army, Cuban Government 1
- Movimiento de Liberacion Dominicana de la Union Patriotica Dominicana y Demas Organizaciones Asociadas 1
- National Bank of Cuba 1
- Organizacion Tecnica Publicitaria Latino Americana, S.A. 1
- Partido Ortodox de Cuba (Partido del Pueblo) 1
- Prensa Latina, Agencia Informativa Latino-Americana, Sociedad Anonima 1
- …
Registrant_Name 27
- U.S.-Cuban Sugar Council 5
- Brauer, Robert R. 3
- Ek, John 3
- Pan-American Coffee Bureau 2
- Quinn, Arthur Lee 2
- Skelly, John T. 2
- Ardois, Luis Fernandez 1
- Bernard Relin & Associates, Inc. 1
- Boeri, Louis J. 1
- Carr & Warren 1
- Chester, Edmund Albert 1
- Cuban Tourist Commission, Miami Office 1
- Del Rio, Daniel A. 1
- EMB, Ltd. 1
- Erice, Michael A. 1
- Kolby, Edmund 1
- Megias Y Perez, Sergio Meneleo 1
- Movimiento Democrata Cristiano de Cuba (F. Badue Branch) 1
- National Counsel Associates 1
- Ochoa, Emilio Laureano Y Ochoa 1
- Partido Revolucionario Cubano (Autentico) 1
- Power, Julio E. 1
- Prensa Latina 1
- Primer Liceo Autentico De Nueva York 1
- Prio Socarras, Carlos 1
- Rabinowitz & Boudin 1
- Unidad Revolucionaria 1
State 1
- - 38
Country/Location_Represented 1
- CUBA · 38 ✖
City 1
- - 38
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 ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9165 | 9165 | 1942-07-11 | Cuban Tourist Commission (Corporacion Nacional del Turismo) | 1942-07-11 | CUBA | Ardois, Luis Fernandez 40 | 1942-07-11 | Ardois, Luis Fernandez | Havana | ||||
9357 | 9357 | 1959-07-19 | Banco Nacional de Cuba | 1957-07-18 | CUBA | Del Rio, Daniel A. 1045 | 1957-07-18 | Del Rio, Daniel A. | Havana | ||||
9374 | 9374 | 1975-07-20 | Prensa Latina, Agencia Informativa Latino-Americana, Sociedad Anonima | 1962-04-16 | CUBA | Prensa Latina 1537 | 1962-04-16 | Prensa Latina | Havana | ||||
9454 | 9454 | 1959-07-24 | Huge Lajonchere | 1959-07-24 | CUBA | Kolby, Edmund 1249 | 1959-07-24 | Kolby, Edmund | Havana | ||||
10158 | 10158 | 1955-08-06 | Manuel Antonio De Varona Y Loredo | 1954-08-06 | CUBA | Megias Y Perez, Sergio Meneleo 839 | 1954-08-06 | Megias Y Perez, Sergio Meneleo | Havana | ||||
10223 | 10223 | 1955-08-09 | Partido Revolucionario Cubano (Autentico) | 1955-08-09 | CUBA | Primer Liceo Autentico De Nueva York 904 | 1955-08-09 | Primer Liceo Autentico De Nueva York | Havana | ||||
11452 | 11452 | 1960-09-09 | Captain Alfred Guerra/Officinas Primer Ministro, Captain of Investigation | 1960-03-09 | CUBA | Ek, John 1338 | 1960-03-09 | Ek, John | Havana | ||||
11455 | 11455 | 1960-09-09 | Comdt. Ramiro Valdes/G2 Army | 1960-03-09 | CUBA | Ek, John 1338 | 1960-03-09 | Ek, John | Havana | ||||
11456 | 11456 | 1960-09-09 | Dr. Juan Orta/General Director | 1960-03-09 | CUBA | Ek, John 1338 | 1960-03-09 | Ek, John | Havana | ||||
11483 | 11483 | 1968-09-10 | Republic of Cuba | 1964-05-04 | CUBA | Rabinowitz & Boudin 1734 | 1964-05-04 | Rabinowitz & Boudin | Havana | ||||
11758 | 11758 | 1960-09-22 | Asociacion Nacional de Hacendados de Cuba (National Cuban Sugar Mills Owners' Association) | 1958-09-22 | CUBA | Quinn, Arthur Lee 1170 | 1958-09-22 | Quinn, Arthur Lee | Havana | ||||
11759 | 11759 | 1960-09-22 | Asociacion de Colonos de Cuba (Cuban Sugar Cane Growers' Association) | 1958-09-22 | CUBA | Quinn, Arthur Lee 1170 | 1958-09-22 | Quinn, Arthur Lee | Havana | ||||
12300 | 12300 | 1955-10-01 | Partido Ortodox de Cuba (Partido del Pueblo) | 1954-04-26 | CUBA | Ochoa, Emilio Laureano Y Ochoa 825 | 1954-04-26 | Ochoa, Emilio Laureano Y Ochoa | Havana | ||||
12309 | 12309 | 1968-10-01 | Candido (Previous acting foreign principal deceased) | 1965-08-17 | CUBA | Movimiento Democrata Cristiano de Cuba (F. Badue Branch) 1863 | 1965-03-04 | Movimiento Democrata Cristiano de Cuba (F. Badue Branch) | Havana | ||||
12592 | 12592 | 1968-10-11 | Ramiro del Rio | 1966-02-07 | CUBA | Brauer, Robert R. 1961 | 1966-02-07 | Brauer, Robert R. | Havana | ||||
12609 | 12609 | 1959-10-12 | Movimiento de Liberacion Dominicana de la Union Patriotica Dominicana y Demas Organizaciones Asociadas | 1959-10-12 | CUBA | National Counsel Associates 1284 | 1959-10-12 | National Counsel Associates | Havana | ||||
12886 | 12886 | 1959-10-21 | Organizacion Tecnica Publicitaria Latino Americana, S.A. | 1959-05-11 | CUBA | Bernard Relin & Associates, Inc. 1225 | 1959-05-11 | Bernard Relin & Associates, Inc. | Havana | ||||
13521 | 13521 | 1953-11-01 | Government of the Republic of Cuba | 1952-09-02 | CUBA | Chester, Edmund Albert 740 | 1952-09-02 | Chester, Edmund Albert | Havana | ||||
13696 | 13696 | 1963-11-04 | Republic of Cuba | 1961-08-15 | CUBA | Carr & Warren 1473 | 1961-08-15 | Carr & Warren | Havana | ||||
13912 | 13912 | 1958-11-13 | Autentico Party | 1957-11-13 | CUBA | Prio Socarras, Carlos 1082 | 1957-11-13 | Prio Socarras, Carlos | Havana | ||||
14144 | 14144 | 1961-11-22 | Unidad Revolucionaria | 1961-11-22 | CUBA | Unidad Revolucionaria 1492 | 1961-11-22 | Unidad Revolucionaria | Havana | ||||
14300 | 14300 | 1975-11-29 | Telesfere Diaz Portillo | 1969-01-23 | CUBA | Brauer, Robert R. 1961 | 1966-02-07 | Brauer, Robert R. | Havana | ||||
14301 | 14301 | 1975-11-29 | Telesforo Diaz Portillo | 1972-03-26 | CUBA | Brauer, Robert R. 1961 | 1966-02-07 | Brauer, Robert R. | Havana | ||||
14328 | 14328 | 1965-11-30 | Partido Revolucionario Cubano (Autentico) | 1961-08-24 | CUBA | Partido Revolucionario Cubano (Autentico) 1474 | 1961-08-24 | Partido Revolucionario Cubano (Autentico) | Havana | ||||
15082 | 15082 | 1954-12-14 | Military Intelligence Service, Cuban Army, Cuban Government | 1954-12-14 | CUBA | Erice, Michael A. 859 | 1954-12-14 | Erice, Michael A. | Havana | ||||
15084 | 15084 | 1959-12-14 | Fidel Castro | 1959-12-14 | CUBA | Skelly, John T. 1312 | 1959-12-14 | Skelly, John T. | Havana | ||||
15085 | 15085 | 1959-12-14 | Jorge Quintana | 1959-12-14 | CUBA | Skelly, John T. 1312 | 1959-12-14 | Skelly, John T. | Havana | ||||
15421 | 15421 | 1959-12-28 | Cuban Tourist Commission | 1956-10-10 | CUBA | Boeri, Louis J. 982 | 1956-10-10 | Boeri, Louis J. | Havana | ||||
15543 | 15543 | 1955-12-31 | Caribbean Sugar Company | 1946-03-07 | CUBA | U.S.-Cuban Sugar Council 347 | 1946-03-07 | U.S.-Cuban Sugar Council | Havana | ||||
15547 | 15547 | 1955-12-31 | Fidelity Sugar Company | 1946-03-07 | CUBA | U.S.-Cuban Sugar Council 347 | 1946-03-07 | U.S.-Cuban Sugar Council | Havana | ||||
15555 | 15555 | 1955-12-31 | Tanamo Sugar Company | 1946-03-07 | CUBA | U.S.-Cuban Sugar Council 347 | 1946-03-07 | U.S.-Cuban Sugar Council | Havana | ||||
15585 | 15585 | 1958-12-31 | L. Perez Coujil | 1958-03-18 | CUBA | Power, Julio E. 1123 | 1958-03-18 | Power, Julio E. | Havana | ||||
15592 | 15592 | 1959-12-31 | Corporacion Nacional del Turismo de Cuba (Cuban Tourist Commission) | 1946-11-04 | CUBA | Cuban Tourist Commission, Miami Office 390 | 1946-11-04 | Cuban Tourist Commission, Miami Office | Havana | ||||
15593 | 15593 | 1959-12-31 | National Bank of Cuba | 1959-09-15 | CUBA | EMB, Ltd. 1270 | 1959-09-15 | EMB, Ltd. | Havana | ||||
15606 | 15606 | 1961-12-31 | Compania Cubana | 1946-04-29 | CUBA | U.S.-Cuban Sugar Council 347 | 1946-03-07 | U.S.-Cuban Sugar Council | Havana | ||||
15616 | 15616 | 1961-12-31 | Vertientes-Camaguey Sugar Company | 1946-03-07 | CUBA | U.S.-Cuban Sugar Council 347 | 1946-03-07 | U.S.-Cuban Sugar Council | Havana | ||||
15749 | 15749 | 1976-12-31 | Instituto Nacional de Estabilizacion del Cafe' | 1946-12-06 | CUBA | Pan-American Coffee Bureau 406 | 1946-12-06 | Pan-American Coffee Bureau | Havana | ||||
15762 | 15762 | 1976-12-31 | Government of Cuba | 1965-08-16 | CUBA | Pan-American Coffee Bureau 406 | 1946-12-06 | Pan-American Coffee Bureau | Havana |
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]) );