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 Registrant_Date
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Registrant_Name >30
- Southern Advertising, Inc. 7
- Movimiento de Liberacion Dominicana de la Union Patriotica 6
- U.S.-Cuban Sugar Council 5
- Cleary, Gottlieb, Steen & Hamilton, LLP 4
- Brauer, Robert R. 3
- Ek, John 3
- Samuel E. Stavisky & Associates, Inc. 3
- Movimiento Democrata Cristiano de Cuba (F. Badue Branch) 2
- Movimiento Insurreccional Libertad 2
- Pan-American Coffee Bureau 2
- Pehle, Riemer, Luxford & Naiden 2
- Power, Julio E. 2
- Quinn, Arthur Lee 2
- Skelly, John T. 2
- Ardois, Luis Fernandez 1
- Austin Jr., Guilford Marks 1
- Baldwin & Mermey 1
- Barron, Arnaldo Goenaga 1
- Bernard Relin & Associates, Inc. 1
- Bernard Relin Associates 1
- Boeri, Louis J. 1
- Bras, Juan A. 1
- Bravo Casal, Benigno 1
- Carr & Warren 1
- Chester, Edmund Albert 1
- Comite Ortodox de Nueva York 1
- Communications Counselors, Inc. 1
- Cuban Tourist Commission, Miami Office 1
- Daniels, Carroll Samuel 1
- De Carreras, Josefa Moreno 1
- …
Foreign_Principal >30
- Republic of Cuba 4
- Banco Nacional de Cuba 3
- Cuban Tourist Commission 3
- Asociacion de Colonos de Cuba (Cuban Sugar Cane Growers' Association) 2
- Cuban Sugar Cane Growers' Association 2
- Fidel Castro 2
- Movimiento de Liberacion Dominicana de la Union Patriotica Dominicana y Demas Organizaciones Asociadas 2
- National Bank of Cuba 2
- National Cuban Sugar Mill Owners' Association 2
- Partido Revolucionario Cubano (Autentico) 2
- 26th of July Movement & Roberto Suarez 1
- Ambos Mundos Hotel 1
- American Chamber of Commerce of Cuba 1
- Asociacion Nacional de Hacendados (National Cuban Sugar Mill Owners' Association) 1
- Asociacion Nacional de Hacendados de Cuba (National Cuban Sugar Mills Owners' Association) 1
- Autentico Party 1
- Bank of Agricultural & Industrial Development of Cuba 1
- Candido (Previous acting foreign principal deceased) 1
- Captain Alfred Guerra/Officinas Primer Ministro, Captain of Investigation 1
- Caribbean Sugar Company 1
- Carlos M. Cantillo 1
- Carlos Prio Socarras & the Government of Cuba 1
- Cecilio Grullon 1
- Comdt. Ramiro Valdes/G2 Army 1
- Compania Cubana 1
- Corporacion Nacional del Turismo de Cuba (Cuban Tourist Commission) 1
- Cuban Tourist Commission (Corporacion Nacional del Turismo) 1
- Dr. Juan Orta/General Director 1
- Edmund C. Chester 1
- El Mundo 1
- …
State 1
- - 86
Country/Location_Represented 1
- CUBA · 86 ✖
City 1
- - 86
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 | ||||
1947 | 1947 | 1943-02-01 | Manuel F. Canosa | 1943-03-12 | CUBA | Pan-American Associated Enterprises 77 | 1942-08-01 | Pan-American Associated Enterprises | Havana | ||||
1617 | 1617 | 1952-01-30 | Ernesto Santa Cruz | 1947-01-31 | CUBA | Junta de Cultura Espanola 273 | 1944-07-31 | Junta de Cultura Espanola | 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 | ||||
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 | ||||
8119 | 8119 | 1952-06-27 | Carlos Prio Socarras & the Government of Cuba | 1952-03-17 | CUBA | Bernard Relin Associates 359 | 1946-05-27 | Bernard Relin Associates | 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 | ||||
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 | ||||
4290 | 4290 | 1953-03-31 | Bank of Agricultural & Industrial Development of Cuba | 1951-09-17 | CUBA | Pehle, Riemer, Luxford & Naiden 439 | 1947-02-17 | Pehle, Riemer, Luxford & Naiden | Havana | ||||
4291 | 4291 | 1953-03-31 | National Bank of Cuba | 1951-09-17 | CUBA | Pehle, Riemer, Luxford & Naiden 439 | 1947-02-17 | Pehle, Riemer, Luxford & Naiden | Havana | ||||
6314 | 6314 | 1948-05-04 | American Chamber of Commerce of Cuba | 1947-07-01 | CUBA | Baldwin & Mermey 475 | 1947-07-01 | Baldwin & Mermey | Havana | ||||
2093 | 2093 | 1968-02-02 | Cuban Sugar Cane Growers' Association | 1958-02-19 | CUBA | Cleary, Gottlieb, Steen & Hamilton, LLP 508 | 1948-01-19 | Cleary, Gottlieb, Steen & Hamilton, LLP | Havana | ||||
2094 | 2094 | 1968-02-02 | National Cuban Sugar Mill Owners' Association | 1958-02-19 | CUBA | Cleary, Gottlieb, Steen & Hamilton, LLP 508 | 1948-01-19 | Cleary, Gottlieb, Steen & Hamilton, LLP | Havana | ||||
7008 | 7008 | 1956-05-31 | Cuban Sugar Cane Growers' Association | 1955-02-02 | CUBA | Cleary, Gottlieb, Steen & Hamilton, LLP 508 | 1948-01-19 | Cleary, Gottlieb, Steen & Hamilton, LLP | Havana | ||||
7009 | 7009 | 1956-05-31 | National Cuban Sugar Mill Owners' Association | 1955-02-02 | CUBA | Cleary, Gottlieb, Steen & Hamilton, LLP 508 | 1948-01-19 | Cleary, Gottlieb, Steen & Hamilton, LLP | 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 | ||||
3857 | 3857 | 1957-03-18 | Edmund C. Chester | 1952-09-18 | CUBA | Erbe, Carl 742 | 1952-09-18 | Erbe, Carl | 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 | ||||
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 | ||||
8803 | 8803 | 1957-07-01 | Ambos Mundos Hotel | 1955-12-09 | CUBA | Southern Advertising, Inc. 849 | 1954-11-08 | Southern Advertising, Inc. | Havana | ||||
8804 | 8804 | 1957-07-01 | Cuban Tourist Commission | 1954-11-08 | CUBA | Southern Advertising, Inc. 849 | 1954-11-08 | Southern Advertising, Inc. | Havana | ||||
8805 | 8805 | 1957-07-01 | Hotel Copacabana | 1956-06-15 | CUBA | Southern Advertising, Inc. 849 | 1954-11-08 | Southern Advertising, Inc. | Havana | ||||
8806 | 8806 | 1957-07-01 | Packard Hotel | 1954-11-08 | CUBA | Southern Advertising, Inc. 849 | 1954-11-08 | Southern Advertising, Inc. | Havana | ||||
8807 | 8807 | 1957-07-01 | Presidente Hotel | 1957-11-08 | CUBA | Southern Advertising, Inc. 849 | 1954-11-08 | Southern Advertising, Inc. | Havana | ||||
8809 | 8809 | 1957-07-01 | Tropicana Night Club | 1956-06-15 | CUBA | Southern Advertising, Inc. 849 | 1954-11-08 | Southern Advertising, Inc. | Havana | ||||
8810 | 8810 | 1957-07-01 | Vedado Hotel | 1957-11-08 | CUBA | Southern Advertising, Inc. 849 | 1954-11-08 | Southern Advertising, Inc. | 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 | ||||
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 | ||||
15421 | 15421 | 1959-12-28 | Cuban Tourist Commission | 1956-10-10 | CUBA | Boeri, Louis J. 982 | 1956-10-10 | Boeri, Louis J. | Havana | ||||
4302 | 4302 | 1959-03-31 | Republic of Cuba | 1957-10-18 | CUBA | Communications Counselors, Inc. 996 | 1957-02-04 | Communications Counselors, Inc. | 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 | ||||
13912 | 13912 | 1958-11-13 | Autentico Party | 1957-11-13 | CUBA | Prio Socarras, Carlos 1082 | 1957-11-13 | Prio Socarras, Carlos | Havana | ||||
785 | 785 | 1960-01-01 | Asociacion Nacional de Hacendados (National Cuban Sugar Mill Owners' Association) | 1958-01-29 | CUBA | Samuel E. Stavisky & Associates, Inc. 1110 | 1958-01-29 | Samuel E. Stavisky & Associates, Inc. | Havana | ||||
786 | 786 | 1960-01-01 | Asociacion de Colonos de Cuba (Cuban Sugar Cane Growers' Association) | 1958-01-29 | CUBA | Samuel E. Stavisky & Associates, Inc. 1110 | 1958-01-29 | Samuel E. Stavisky & Associates, Inc. | Havana | ||||
1391 | 1391 | 1960-01-18 | Banco Nacional de Cuba | 1958-01-29 | CUBA | Samuel E. Stavisky & Associates, Inc. 1110 | 1958-01-29 | Samuel E. Stavisky & Associates, Inc. | Havana | ||||
6332 | 6332 | 1958-05-05 | Carlos M. Cantillo | 1958-03-18 | CUBA | Power, Julio E. 1123 | 1958-03-18 | Power, Julio E. | Havana | ||||
15585 | 15585 | 1958-12-31 | L. Perez Coujil | 1958-03-18 | CUBA | Power, Julio E. 1123 | 1958-03-18 | Power, Julio E. | Havana | ||||
3886 | 3886 | 1958-03-19 | Roberto Fernandez Miranda | 1958-03-19 | CUBA | De Carreras, Josefa Moreno 1124 | 1958-03-19 | De Carreras, Josefa Moreno | 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 | ||||
2121 | 2121 | 1959-02-03 | 26th of July Movement & Roberto Suarez | 1959-02-03 | CUBA | Bras, Juan A. 1198 | 1959-02-03 | Bras, Juan A. | Havana | ||||
2344 | 2344 | 1959-02-10 | Fidel Castro | 1959-02-10 | CUBA | Ryan Jr., Charles Edward 1200 | 1959-02-10 | Ryan Jr., Charles Edward | Havana | ||||
3476 | 3476 | 1959-03-06 | Partido Ortodox - July 26 | 1959-03-06 | CUBA | Barron, Arnaldo Goenaga 1207 | 1959-03-06 | Barron, Arnaldo Goenaga | Havana | ||||
3477 | 3477 | 1959-03-06 | Partido Ortodox | 1959-03-06 | CUBA | Comite Ortodox de Nueva York 1208 | 1959-03-06 | Comite Ortodox de Nueva York | Havana | ||||
4076 | 4076 | 1962-03-27 | German Amado-Blanco | 1959-03-27 | CUBA | Austin Jr., Guilford Marks 1214 | 1959-03-27 | Austin Jr., Guilford Marks | 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 | ||||
1301 | 1301 | 1962-01-15 | Cecilio Grullon | 1959-05-25 | CUBA | Movimiento de Liberacion Dominicana de la Union Patriotica 1231 | 1959-05-25 | Movimiento de Liberacion Dominicana de la Union Patriotica | Havana | ||||
1302 | 1302 | 1962-01-15 | Francisco Canto | 1959-05-25 | CUBA | Movimiento de Liberacion Dominicana de la Union Patriotica 1231 | 1959-05-25 | Movimiento de Liberacion Dominicana de la Union Patriotica | Havana | ||||
1303 | 1303 | 1962-01-15 | Francisco Castellanos | 1959-05-25 | CUBA | Movimiento de Liberacion Dominicana de la Union Patriotica 1231 | 1959-05-25 | Movimiento de Liberacion Dominicana de la Union Patriotica | Havana | ||||
1307 | 1307 | 1962-01-15 | Juan Isidro Jimenez Grullon | 1959-05-25 | CUBA | Movimiento de Liberacion Dominicana de la Union Patriotica 1231 | 1959-05-25 | Movimiento de Liberacion Dominicana de la Union Patriotica | Havana | ||||
1308 | 1308 | 1962-01-15 | Luis Aquiles Mejia | 1959-05-25 | CUBA | Movimiento de Liberacion Dominicana de la Union Patriotica 1231 | 1959-05-25 | Movimiento de Liberacion Dominicana de la Union Patriotica | Havana | ||||
1309 | 1309 | 1962-01-15 | Movimiento de Liberacion Dominicana de la Union Patriotica Dominicana y Demas Organizaciones Asociadas | 1959-07-06 | CUBA | Movimiento de Liberacion Dominicana de la Union Patriotica 1231 | 1959-05-25 | Movimiento de Liberacion Dominicana de la Union Patriotica | Havana | ||||
2537 | 2537 | 1961-02-15 | Republic of Cuba | 1959-06-15 | CUBA | Kangles, Constantine N. 1237 | 1959-06-15 | Kangles, Constantine N. | Havana | ||||
9454 | 9454 | 1959-07-24 | Huge Lajonchere | 1959-07-24 | CUBA | Kolby, Edmund 1249 | 1959-07-24 | Kolby, Edmund | Havana | ||||
15593 | 15593 | 1959-12-31 | National Bank of Cuba | 1959-09-15 | CUBA | EMB, Ltd. 1270 | 1959-09-15 | EMB, Ltd. | 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 | ||||
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 | ||||
3213 | 3213 | 1960-03-01 | Cuban Tourist Commission | 1960-01-11 | CUBA | Menendez, Jose Ramon 1321 | 1960-01-11 | Menendez, Jose Ramon | 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 | ||||
8816 | 8816 | 1960-07-01 | National Tourist Commission of Cuba (Instituto Nacional de la Industria Turistica)(INIT) | 1960-04-05 | CUBA | Louis-Rowe-Fisher-Lockhart Enterprises, Inc. 1348 | 1960-04-05 | Louis-Rowe-Fisher-Lockhart Enterprises, Inc. | Havana | ||||
5450 | 5450 | 1962-04-21 | Banco Nacional de Cuba | 1960-10-21 | CUBA | Patton & Kanner 1403 | 1960-10-21 | Patton & Kanner | Havana | ||||
1255 | 1255 | 1961-01-13 | Revolutionary Provisional Government of Cuba | 1961-01-13 | CUBA | Santos-Buch, Charles A. 1419 | 1961-01-13 | Santos-Buch, Charles A. | Havana | ||||
3478 | 3478 | 1961-03-06 | Instituto Nacional de Reforma Agararia (INRA) | 1961-03-06 | CUBA | Jules A. Des Angles Company, Inc. 1432 | 1961-03-06 | Jules A. Des Angles Company, Inc. | Havana | ||||
4843 | 4843 | 1963-04-01 | Republic of Cuba, National Institute of Agrarian Reform, Industrial Division | 1961-04-12 | CUBA | Daniels, Carroll Samuel 1438 | 1961-04-12 | Daniels, Carroll Samuel | Havana | ||||
6795 | 6795 | 1961-05-25 | El Mundo | 1961-05-25 | CUBA | Lecour Ibarra, Mario 1453 | 1961-05-25 | Lecour Ibarra, Mario | Havana | ||||
13696 | 13696 | 1963-11-04 | Republic of Cuba | 1961-08-15 | CUBA | Carr & Warren 1473 | 1961-08-15 | Carr & Warren | 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 | ||||
14144 | 14144 | 1961-11-22 | Unidad Revolucionaria | 1961-11-22 | CUBA | Unidad Revolucionaria 1492 | 1961-11-22 | Unidad Revolucionaria | Havana | ||||
7605 | 7605 | 1962-06-05 | Movimiento Insurreccional Libertad Underground in Cuba | 1962-04-10 | CUBA | Movimiento Insurreccional Libertad 1497 | 1961-12-05 | Movimiento Insurreccional Libertad | Havana | ||||
7606 | 7606 | 1962-06-05 | People of Cuba (Under Red Rule) | 1961-12-05 | CUBA | Movimiento Insurreccional Libertad 1497 | 1961-12-05 | Movimiento Insurreccional Libertad | Havana | ||||
1459 | 1459 | 1968-01-22 | Republic of Cuba (Import/Export Bank of Cuba)(Consejo de Cultura de Cuba) | 1962-01-22 | CUBA | Smith, Scheuermann & Jones 1513 | 1962-01-22 | Smith, Scheuermann & Jones | 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 | ||||
6315 | 6315 | 1964-05-04 | Military Intelligence Service (G-2) - Cuban Revolutionary Army | 1964-05-04 | CUBA | Bravo Casal, Benigno 1735 | 1964-05-04 | Bravo Casal, Benigno | Havana | ||||
11483 | 11483 | 1968-09-10 | Republic of Cuba | 1964-05-04 | CUBA | Rabinowitz & Boudin 1734 | 1964-05-04 | Rabinowitz & Boudin | Havana | ||||
3416 | 3416 | 1965-03-04 | Jose Socarras (Rubido") (Acting foreign principal) (Actual foreign principal killed)" | 1965-03-04 | CUBA | Movimiento Democrata Cristiano de Cuba (F. Badue Branch) 1863 | 1965-03-04 | Movimiento Democrata Cristiano de Cuba (F. Badue Branch) | 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 | ||||
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 |
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]) );