FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
182 rows where Country/Location_Represented = "CUBA" sorted by Registrant_Name
This data as json, CSV (advanced)
Registrant_Name >30
- U.S.-Cuban Sugar Council 21
- Southern Advertising, Inc. 7
- Movimiento de Liberacion Dominicana de la Union Patriotica 6
- Samuel E. Stavisky & Associates, Inc. 4
- Pehle, Riemer, Luxford & Naiden 3
- Prio Socarras, Carlos 3
- Movimiento Insurreccional Libertad 2
- Pan-American Coffee Bureau 2
- Patton & Kanner 2
- Power, Julio E. 2
- Quinn, Arthur Lee 2
- Riera-Gomez, Eliseo 2
- Skelly, John T. 2
- Movimiento Revolucionario 30 de Noviembre, Frank Pais 1
- Movimiento Revolucionario del Pueblo (En El Exilio) 1
- National Counsel Associates 1
- National Federation of Negro Societies of Cuba 1
- O'Mahoney, Joseph C. 1
- Ochoa, Emilio Laureano Y Ochoa 1
- Organizacion de Cubanos Anti-Comunistas de Nueva York 1
- Ortega, Osmin C. 1
- Pan-American Associated Enterprises 1
- Partido Revolucionario Cubano (Autentico) 1
- Pena, Salvador Cancio 1
- Prensa Latina 1
- Primer Liceo Autentico De Nueva York 1
- Rabelo, Ricardo Artigas 1
- Rabinowitz & Boudin 1
- Ronny Caire Advertising Agency, Inc. 1
- Ryan Jr., Charles Edward 1
- …
Registrant_Date (date) >30 ✖
- 1946-03-07 21
- 1954-11-08 7
- 1959-05-25 6
- 1958-01-29 4
- 1947-02-17 3
- 1946-12-06 2
- 1953-12-03 2
- 1957-11-13 2
- 1958-03-18 2
- 1958-09-22 2
- 1959-12-14 2
- 1960-10-21 2
- 1961-12-05 2
- 1942-08-01 1
- 1953-07-29 1
- 1953-12-01 1
- 1953-12-23 1
- 1954-04-26 1
- 1954-11-15 1
- 1955-08-09 1
- 1957-03-26 1
- 1958-01-14 1
- 1959-02-10 1
- 1959-04-27 1
- 1959-10-12 1
- 1959-12-08 1
- 1961-01-13 1
- 1961-04-24 1
- 1961-08-24 1
- 1961-11-22 1
- …
Foreign_Principal >30
- Fidel Castro 3
- Asociacion de Colonos de Cuba (Cuban Sugar Cane Growers' Association) 2
- Banco Nacional de Cuba 2
- Movimiento de Liberacion Dominicana de la Union Patriotica Dominicana y Demas Organizaciones Asociadas 2
- No foreign principal listed 2
- Partido Revolucionario Cubano (Autentico) 2
- Republic of Cuba 2
- 26th of July Movement 1
- Ambos Mundos Hotel 1
- American Sugar Refing Company 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
- Atlantica del Golfo Sugar Company 1
- Autentico Party 1
- Bank of Agricultural & Industrial Development of Cuba 1
- Caribbean Sugar Company 1
- Carlos M. Cantillo 1
- Carlos Prio Socarras 1
- Cecilio Grullon 1
- Central Altagracia Sugar Company 1
- Central Hormiguero, S.A. 1
- Central Violeta Sugar Company 1
- Compania Azucarera Soledad, S.A. 1
- Compania Cubana 1
- Cuban Atlantic Sugar Company 1
- Cuban Democratic Revolutionary Front, New Orleans Chapter 1
- Cuban Tourist Commission 1
- Cuban-American Sugar Company 1
- Dr. Julio Garceran 1
- Embassy of Cuba 1
- …
Address_1 14 ✖
- Havana 46
- - 14
- New York 5
- Miami 3
- Washington 3
- Flemington 2
- Wilmington 2
- Camaguey 1
- Habana 1
- Hormiguero 1
- New Orleans 1
- Oriente 1
- Sierra Maestra 1
- Underground 1
Country/Location_Represented 1
- CUBA · 82 ✖
City 1
- - 82
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||
7029 | 7029 | 1964-05-31 | No foreign principal listed | 1963-08-22 | CUBA | Movimiento Revolucionario 30 de Noviembre, Frank Pais 1654 | 1963-08-22 | Movimiento Revolucionario 30 de Noviembre, Frank Pais | Miami | FL | |||
2102 | 2102 | 1968-02-02 | Movimiento Revolucionario del Pueblo | 1962-02-02 | CUBA | Movimiento Revolucionario del Pueblo (En El Exilio) 1516 | 1962-02-02 | Movimiento Revolucionario del Pueblo (En El Exilio) | Underground | ||||
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 | ||||
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 | ||||
12969 | 12969 | 1962-10-24 | Federacion Nacional de Sociedades Negras | 1961-04-24 | CUBA | National Federation of Negro Societies of Cuba 1442 | 1961-04-24 | National Federation of Negro Societies of Cuba | New York | NY | |||
9579 | 9579 | 1954-07-29 | United States Cuban Sugar Council | 1953-07-29 | CUBA | O'Mahoney, Joseph C. 783 | 1953-07-29 | O'Mahoney, Joseph C. | Washington | DC | |||
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 | ||||
14889 | 14889 | 1959-12-08 | No foreign principal listed | 1959-12-08 | CUBA | Organizacion de Cubanos Anti-Comunistas de Nueva York 1306 | 1959-12-08 | Organizacion de Cubanos Anti-Comunistas de Nueva York | |||||
5611 | 5611 | 1959-04-27 | 26th of July Movement | 1959-04-27 | CUBA | Ortega, Osmin C. 1222 | 1959-04-27 | Ortega, Osmin C. | |||||
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 | ||||
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 | ||||
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 | ||||
5450 | 5450 | 1962-04-21 | Banco Nacional de Cuba | 1960-10-21 | CUBA | Patton & Kanner 1403 | 1960-10-21 | Patton & Kanner | Havana | ||||
5451 | 5451 | 1962-04-21 | Republic of Cuba | 1960-10-21 | CUBA | Patton & Kanner 1403 | 1960-10-21 | Patton & Kanner | Miami | FL | |||
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 | ||||
14617 | 14617 | 1959-12-01 | Embassy of Cuba | 1959-02-06 | CUBA | Pehle, Riemer, Luxford & Naiden 439 | 1947-02-17 | Pehle, Riemer, Luxford & Naiden | Washington | DC | |||
6131 | 6131 | 1958-05-01 | Emilio Ochoa Ochoa | 1954-11-15 | CUBA | Pena, Salvador Cancio 852 | 1954-11-15 | Pena, Salvador Cancio | |||||
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 | ||||
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 | ||||
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 | ||||
7317 | 7317 | 1955-06-01 | Namless, unorganized groups | 1953-12-01 | CUBA | Prio Socarras, Carlos 800 | 1953-12-01 | Prio Socarras, Carlos | |||||
13912 | 13912 | 1958-11-13 | Autentico Party | 1957-11-13 | CUBA | Prio Socarras, Carlos 1082 | 1957-11-13 | Prio Socarras, Carlos | Havana | ||||
13913 | 13913 | 1958-11-13 | Junta de Liberacion | 1957-11-13 | CUBA | Prio Socarras, Carlos 1082 | 1957-11-13 | Prio Socarras, Carlos | Miami | FL | |||
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 | ||||
8018 | 8018 | 1957-06-23 | Nameless unorganized groups in Cuba seeking the restorat. of liberty, democracy & constitutional form of Gov't. in Cuba | 1953-12-23 | CUBA | Rabelo, Ricardo Artigas 806 | 1953-12-23 | Rabelo, Ricardo Artigas | |||||
11483 | 11483 | 1968-09-10 | Republic of Cuba | 1964-05-04 | CUBA | Rabinowitz & Boudin 1734 | 1964-05-04 | Rabinowitz & Boudin | Havana | ||||
7512 | 7512 | 1957-06-03 | Carlos Prio Socarras | 1954-10-20 | CUBA | Riera-Gomez, Eliseo 804 | 1953-12-03 | Riera-Gomez, Eliseo | |||||
7513 | 7513 | 1957-06-03 | Nameless unorganized groups | 1953-12-03 | CUBA | Riera-Gomez, Eliseo 804 | 1953-12-03 | Riera-Gomez, Eliseo | |||||
6924 | 6924 | 1962-05-30 | Cuban Democratic Revolutionary Front, New Orleans Chapter | 1961-12-29 | CUBA | Ronny Caire Advertising Agency, Inc. 1504 | 1961-12-29 | Ronny Caire Advertising Agency, Inc. | New Orleans | ||||
2344 | 2344 | 1959-02-10 | Fidel Castro | 1959-02-10 | CUBA | Ryan Jr., Charles Edward 1200 | 1959-02-10 | Ryan Jr., Charles Edward | 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 | ||||
8241 | 8241 | 1960-06-30 | U.S.-Cuban Sugar Council | 1958-01-29 | CUBA | Samuel E. Stavisky & Associates, Inc. 1110 | 1958-01-29 | Samuel E. Stavisky & Associates, Inc. | Washington | DC | |||
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 | ||||
9610 | 9610 | 1970-07-30 | Segundo Frente Nacional Del Escambray | 1964-01-30 | CUBA | Segundo Frente Nacional Del Escambray 1686 | 1964-01-30 | Segundo Frente Nacional Del Escambray | |||||
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 | ||||
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 | ||||
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 | ||||
14203 | 14203 | 1964-11-24 | Dr. Julio Garceran | 1963-01-14 | CUBA | Stone & Bittel 1591 | 1963-01-14 | Stone & Bittel | |||||
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 | ||||
15544 | 15544 | 1955-12-31 | Central Violeta Sugar Company | 1946-03-07 | CUBA | U.S.-Cuban Sugar Council 347 | 1946-03-07 | U.S.-Cuban Sugar Council | Camaguey | ||||
15545 | 15545 | 1955-12-31 | Cuban Atlantic Sugar Company | 1946-03-07 | CUBA | U.S.-Cuban Sugar Council 347 | 1946-03-07 | U.S.-Cuban Sugar Council | Wilmington | DE | |||
15546 | 15546 | 1955-12-31 | Cuban-American Sugar Company | 1946-03-07 | CUBA | U.S.-Cuban Sugar Council 347 | 1946-03-07 | U.S.-Cuban Sugar Council | Flemington | NJ | |||
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 | ||||
15548 | 15548 | 1955-12-31 | Francisco Sugar Company | 1946-03-07 | CUBA | U.S.-Cuban Sugar Council 347 | 1946-03-07 | U.S.-Cuban Sugar Council | New York | NY | |||
15549 | 15549 | 1955-12-31 | Guantanamo Sugar Company | 1946-03-07 | CUBA | U.S.-Cuban Sugar Council 347 | 1946-03-07 | U.S.-Cuban Sugar Council | Flemington | NJ | |||
15550 | 15550 | 1955-12-31 | Manati Sugar Company | 1946-03-07 | CUBA | U.S.-Cuban Sugar Council 347 | 1946-03-07 | U.S.-Cuban Sugar Council | New York | NY | |||
15552 | 15552 | 1955-12-31 | New Niquero Sugar Company | 1946-03-07 | CUBA | U.S.-Cuban Sugar Council 347 | 1946-03-07 | U.S.-Cuban Sugar Council | New York | NY | |||
15554 | 15554 | 1955-12-31 | Punta Alegre Sugar Corporation | 1946-03-07 | CUBA | U.S.-Cuban Sugar Council 347 | 1946-03-07 | U.S.-Cuban Sugar Council | Wilmington | DE | |||
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 | ||||
15556 | 15556 | 1955-12-31 | Tuinucu Sugar Company | 1946-03-07 | CUBA | U.S.-Cuban Sugar Council 347 | 1946-03-07 | U.S.-Cuban Sugar Council | New York | NY | |||
15601 | 15601 | 1961-12-31 | American Sugar Refing Company | 1961-08-23 | CUBA | U.S.-Cuban Sugar Council 347 | 1946-03-07 | U.S.-Cuban Sugar Council | |||||
15602 | 15602 | 1961-12-31 | Atlantica del Golfo Sugar Company | 1961-08-23 | CUBA | U.S.-Cuban Sugar Council 347 | 1946-03-07 | U.S.-Cuban Sugar Council | |||||
15603 | 15603 | 1961-12-31 | Central Altagracia Sugar Company | 1961-08-23 | CUBA | U.S.-Cuban Sugar Council 347 | 1946-03-07 | U.S.-Cuban Sugar Council | |||||
15604 | 15604 | 1961-12-31 | Central Hormiguero, S.A. | 1946-10-22 | CUBA | U.S.-Cuban Sugar Council 347 | 1946-03-07 | U.S.-Cuban Sugar Council | Hormiguero | ||||
15605 | 15605 | 1961-12-31 | Compania Azucarera Soledad, S.A. | 1961-08-23 | CUBA | U.S.-Cuban Sugar Council 347 | 1946-03-07 | U.S.-Cuban Sugar Council | |||||
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 | ||||
15612 | 15612 | 1961-12-31 | Miranda Sugar Estates | 1951-02-01 | CUBA | U.S.-Cuban Sugar Council 347 | 1946-03-07 | U.S.-Cuban Sugar Council | Oriente | ||||
15615 | 15615 | 1961-12-31 | United Fruit Company | 1961-08-23 | CUBA | U.S.-Cuban Sugar Council 347 | 1946-03-07 | U.S.-Cuban Sugar Council | |||||
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 | ||||
14144 | 14144 | 1961-11-22 | Unidad Revolucionaria | 1961-11-22 | CUBA | Unidad Revolucionaria 1492 | 1961-11-22 | Unidad Revolucionaria | Havana | ||||
1551 | 1551 | 1959-01-27 | Republic of Cuba, Ministry of the Government | 1957-06-18 | CUBA | Universal Research & Consultants, Inc. 1013 | 1957-03-26 | Universal Research & Consultants, Inc. | Habana | ||||
9233 | 9233 | 1958-07-14 | Fidel Castro | 1958-01-14 | CUBA | Vazquez, Jose Infanzon 1105 | 1958-01-14 | Vazquez, Jose Infanzon | Sierra Maestra |
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]) );