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 Foreign_Principal_Termination_Date
This data as json, CSV (advanced)
Registrant_Name >30
- U.S.-Cuban Sugar Council 9
- Brauer, Robert R. 7
- Movimiento de Liberacion Dominicana de la Union Patriotica 6
- Ek, John 5
- Fernandez, Carlos B. 3
- Cleary, Gottlieb, Steen & Hamilton, LLP 2
- Movimiento Democrata Cristiano de Cuba (F. Badue Branch) 2
- Movimiento Insurreccional Libertad 2
- Pan-American Coffee Bureau 2
- Patton & Kanner 2
- Quinn, Arthur Lee 2
- Samuel E. Stavisky & Associates, Inc. 2
- Aguero Fernandez, Osvaldo Arsenio 1
- Alzuri Y Carballo, Pedro De Jesus 1
- Anti-Communist Pan-American Association 1
- Asencio, Armando J. 1
- Austin Jr., Guilford Marks 1
- Betancourt, Ernesto F. 1
- Bravo Casal, Benigno 1
- Carr & Warren 1
- Club 26 de Julio de Miami 1
- Consejo de Liberacion Interno en Armas (C.L.I.A.) 1
- Cuba Libre (Movimiento del Pueblo Libre) 1
- Cuban Army of Liberation - Organizing Commission 1
- Cuban Revolutionary Party (Autentico) 1
- Cuban Tourist Commission, New York Office 1
- Daniels, Carroll Samuel 1
- Fanelli, Joseph A. 1
- Federacion Estudiantil Universitaria (of Cuba In Exile) 1
- Frente Revolucionario Democratico 1
- …
Foreign_Principal >30
- Republic of Cuba 5
- Banco Nacional de Cuba 2
- Partido Revolucionario Cubano (Autentico) 2
- (Registrant Applied for a Waiver of the Requirement to Disclose the Name & Address of its Foreign Principal) 1
- American Sugar Refing Company 1
- Asociacion Nacional de Hacendados de Cuba (National Cuban Sugar Mills Owners' Association) 1
- Asociacion de Colonos de Cuba (Cuban Sugar Cane Growers' Association) 1
- Atlantica del Golfo Sugar Company 1
- Candido (Previous acting foreign principal deceased) 1
- Captain Alfred Guerra/Officinas Primer Ministro, Captain of Investigation 1
- Cecilio Grullon 1
- Central Altagracia Sugar Company 1
- Central Hormiguero, S.A. 1
- Club 26 de Julio de Miami 1
- Comdt. A. Colome Furre Ibarra 1
- Comdt. Manual Pinciro 1
- Comdt. Ramiro Valdes/G2 Army 1
- Compania Azucarera Soledad, S.A. 1
- Compania Cubana 1
- Consulate of Cuba 1
- Cuban Air Force, Attache' (Captain Randolfo Cossio) 1
- Cuban Democratic Revolutionary Front, New Orleans Chapter 1
- Cuban Sugar Cane Growers' Association 1
- Cuban Tourist Commission 1
- Dr. Juan Orta/General Director 1
- Dr. Julio Garceran 1
- Ejercito Libertador de Cuba 1
- Ejercito Libertador de Cuba (Libertad y Soberarania) 1
- El Mundo 1
- Federacion Estudiantil Universitaria, Cuba (Underground) 1
- …
Country/Location_Represented 1
- CUBA · 83 ✖
City 1
- - 83
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||
3213 | 3213 | 1960-03-01 | Cuban Tourist Commission | 1960-01-11 | CUBA | Menendez, Jose Ramon 1321 | 1960-01-11 | Menendez, Jose Ramon | Havana | ||||
7778 | 7778 | 1960-06-13 | Instituto Nacional de la Industria Turistica (INIT) | 1960-06-13 | CUBA | Cuban Tourist Commission, New York Office 1369 | 1960-06-13 | Cuban Tourist Commission, New York Office | Habana | ||||
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 | |||
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 | ||||
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 | ||||
11453 | 11453 | 1960-09-09 | Comdt. A. Colome Furre Ibarra | 1960-03-09 | CUBA | Ek, John 1338 | 1960-03-09 | Ek, John | Mariano | ||||
11454 | 11454 | 1960-09-09 | Comdt. Manual Pinciro | 1960-03-09 | CUBA | Ek, John 1338 | 1960-03-09 | Ek, John | Mariano | ||||
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 | ||||
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 | ||||
11825 | 11825 | 1960-09-26 | Hector Garcia Soto | 1960-09-26 | CUBA | Asencio, Armando J. 1395 | 1960-09-26 | Asencio, Armando J. | Miami | FL | |||
15338 | 15338 | 1960-12-23 | United States Cuban Sugar Council | 1953-06-23 | CUBA | Kem, James P. 776 | 1953-06-23 | Kem, James P. | 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 | ||||
1962 | 1962 | 1961-02-01 | Club 26 de Julio de Miami | 1961-02-01 | CUBA | Club 26 de Julio de Miami 1423 | 1961-02-01 | Club 26 de Julio de Miami | Miami | FL | |||
1964 | 1964 | 1961-02-01 | Revolucion Newspaper | 1961-05-03 | CUBA | Aguero Fernandez, Osvaldo Arsenio 1448 | 1961-05-03 | Aguero Fernandez, Osvaldo Arsenio | Habana | ||||
2431 | 2431 | 1961-02-13 | Republic of Cuba | 1960-03-22 | CUBA | Fanelli, Joseph A. 1342 | 1960-03-22 | Fanelli, Joseph A. | Washington | DC | |||
2537 | 2537 | 1961-02-15 | Republic of Cuba | 1959-06-15 | CUBA | Kangles, Constantine N. 1237 | 1959-06-15 | Kangles, Constantine N. | 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 | ||||
5337 | 5337 | 1961-04-17 | (Registrant Applied for a Waiver of the Requirement to Disclose the Name & Address of its Foreign Principal) | 1960-12-23 | CUBA | Anti-Communist Pan-American Association 1415 | 1960-12-23 | Anti-Communist Pan-American Association | |||||
6795 | 6795 | 1961-05-25 | El Mundo | 1961-05-25 | CUBA | Lecour Ibarra, Mario 1453 | 1961-05-25 | Lecour Ibarra, Mario | Havana | ||||
7604 | 7604 | 1961-06-05 | La Revolucion | 1961-06-05 | CUBA | Alzuri Y Carballo, Pedro De Jesus 1455 | 1961-06-05 | Alzuri Y Carballo, Pedro De Jesus | La Habana | ||||
9338 | 9338 | 1961-07-18 | Moviemento Revolucionario 26 de Julio | 1960-07-18 | CUBA | Movimiento 26 de Julio (26th of July Movement) 1379 | 1960-07-18 | Movimiento 26 de Julio (26th of July Movement) | |||||
11914 | 11914 | 1961-09-30 | Frente Revolutionario Democratia (FRD) (Democratic Revolutionary Front) | 1961-02-23 | CUBA | Frente Revolucionario Democratico 1427 | 1961-02-23 | Frente Revolucionario Democratico | |||||
14144 | 14144 | 1961-11-22 | Unidad Revolucionaria | 1961-11-22 | CUBA | Unidad Revolucionaria 1492 | 1961-11-22 | Unidad Revolucionaria | Havana | ||||
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 | ||||
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 | ||||
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 | ||||
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 | |||
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 | ||||
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 | ||||
9442 | 9442 | 1962-07-23 | Oppressed People of Cuba | 1962-07-23 | CUBA | Cuban Army of Liberation - Organizing Commission 1562 | 1962-07-23 | Cuban Army of Liberation - Organizing Commission | |||||
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 | |||
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 | ||||
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 | |||
10878 | 10878 | 1963-08-31 | Consulate of Cuba | 1961-03-30 | CUBA | Fernandez, Carlos B. 1409 | 1960-11-22 | Fernandez, Carlos B. | Miami | FL | |||
11559 | 11559 | 1963-09-13 | Federacion Estudiantil Universitaria, Cuba (Underground) | 1962-04-25 | CUBA | Federacion Estudiantil Universitaria (of Cuba In Exile) 1542 | 1962-05-04 | Federacion Estudiantil Universitaria (of Cuba In Exile) | |||||
13696 | 13696 | 1963-11-04 | Republic of Cuba | 1961-08-15 | CUBA | Carr & Warren 1473 | 1961-08-15 | Carr & Warren | Havana | ||||
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 | |||
5596 | 5596 | 1964-04-26 | Movimiento del Pueblo Libre | 1960-04-26 | CUBA | Cuba Libre (Movimiento del Pueblo Libre) 1356 | 1960-04-26 | Cuba Libre (Movimiento del Pueblo Libre) | Habana | ||||
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 | ||||
6355 | 6355 | 1964-05-06 | Ejercito Libertador de Cuba (Libertad y Soberarania) | 1962-11-06 | CUBA | Friends of Cuba In Exile 1579 | 1962-11-06 | Friends of Cuba In Exile | Miami | FL | |||
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 | |||
14203 | 14203 | 1964-11-24 | Dr. Julio Garceran | 1963-01-14 | CUBA | Stone & Bittel 1591 | 1963-01-14 | Stone & Bittel | |||||
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 | ||||
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 | ||||
9359 | 9359 | 1966-07-19 | Partido Revolucionario Cubano (Autentico) | 1963-01-30 | CUBA | Cuban Revolutionary Party (Autentico) 1594 | 1963-01-30 | Cuban Revolutionary Party (Autentico) | |||||
12696 | 12696 | 1967-10-15 | Oscar Gutierrez | 1966-09-28 | CUBA | Brauer, Robert R. 1961 | 1966-02-07 | Brauer, Robert R. | New York | NY | |||
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 | ||||
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 | ||||
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 | ||||
10635 | 10635 | 1968-08-21 | None | 1965-04-15 | CUBA | Consejo de Liberacion Interno en Armas (C.L.I.A.) 1883 | 1965-04-15 | Consejo de Liberacion Interno en Armas (C.L.I.A.) | |||||
11483 | 11483 | 1968-09-10 | Republic of Cuba | 1964-05-04 | CUBA | Rabinowitz & Boudin 1734 | 1964-05-04 | Rabinowitz & Boudin | 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 | ||||
2540 | 2540 | 1969-02-15 | Jesus Jimenez Escobar | 1968-03-22 | CUBA | Brauer, Robert R. 1961 | 1966-02-07 | Brauer, Robert R. | New York | NY | |||
3597 | 3597 | 1970-03-11 | Jose Raul Viera | 1969-09-17 | CUBA | Brauer, Robert R. 1961 | 1966-02-07 | Brauer, Robert R. | New York | NY | |||
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 | |||||
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 | ||||
14299 | 14299 | 1975-11-29 | Orlando F. Pereira | 1971-03-26 | CUBA | Brauer, Robert R. 1961 | 1966-02-07 | Brauer, Robert R. | New York | NY | |||
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 | ||||
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]) );