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"
This data as json, CSV (advanced)
Registrant_Name >30
- U.S.-Cuban Sugar Council 21
- Brauer, Robert R. 5
- Ek, John 5
- Fernandez, Carlos B. 3
- Pan-American Coffee Bureau 2
- Prio Socarras, Carlos 2
- Quinn, Arthur Lee 2
- Skelly, John T. 2
- Ardois, Luis Fernandez 1
- Asencio, Armando J. 1
- Bernard Relin & Associates, Inc. 1
- Bernenguer, John 1
- Betancourt, Ernesto F. 1
- Boeri, Louis J. 1
- Carr & Warren 1
- Chester, Edmund Albert 1
- Consejo de Liberacion Interno en Armas (C.L.I.A.) 1
- Cuban Army of Liberation - Organizing Commission 1
- Cuban Revolutionary Party (Autentico) 1
- Cuban Tourist Commission, Miami Office 1
- Del Rio, Daniel A. 1
- EMB, Ltd. 1
- Erice, Michael A. 1
- Federacion Estudiantil Universitaria (of Cuba In Exile) 1
- Fiallo, Rene 1
- Frente Revolucionario Democratico 1
- Frontaura, Pablo 1
- Kem, James P. 1
- Kolby, Edmund 1
- Megias Y Perez, Sergio Meneleo 1
- …
Registrant_Date (date) >30 ✖
- 1946-03-07 21
- 1960-03-09 5
- 1966-02-07 5
- 1960-11-22 3
- 1946-12-06 2
- 1957-11-13 2
- 1958-09-22 2
- 1959-12-14 2
- 1942-07-11 1
- 1946-11-04 1
- 1947-02-17 1
- 1952-09-02 1
- 1953-06-23 1
- 1953-07-29 1
- 1954-02-26 1
- 1954-04-26 1
- 1954-08-06 1
- 1954-12-14 1
- 1955-08-09 1
- 1955-12-23 1
- 1956-10-10 1
- 1957-07-18 1
- 1958-01-14 1
- 1958-03-18 1
- 1958-10-09 1
- 1959-05-11 1
- 1959-07-24 1
- 1959-09-15 1
- 1959-10-12 1
- 1959-12-08 1
- …
Foreign_Principal_Registration_Date (date) >30 ✖
- 1946-03-07 13
- 1960-03-09 5
- 1961-08-23 5
- 1957-11-13 2
- 1958-09-22 2
- 1959-12-14 2
- 1961-03-30 2
- 1942-07-11 1
- 1946-04-29 1
- 1946-10-22 1
- 1946-11-04 1
- 1946-12-06 1
- 1951-02-01 1
- 1952-09-02 1
- 1953-06-23 1
- 1953-07-29 1
- 1954-02-26 1
- 1954-04-26 1
- 1954-08-06 1
- 1954-12-14 1
- 1955-08-09 1
- 1955-12-23 1
- 1956-10-10 1
- 1957-07-18 1
- 1958-01-14 1
- 1958-03-18 1
- 1958-10-09 1
- 1959-02-06 1
- 1959-05-11 1
- 1959-07-24 1
- …
Foreign_Principal >30
- Partido Revolucionario Cubano (Autentico) 3
- Fidel Castro 2
- Republic of Cuba 2
- United States Cuban Sugar Council 2
- 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
- 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
- Central Altagracia Sugar Company 1
- Central Hormiguero, S.A. 1
- Central Violeta Sugar Company 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
- Corporacion Nacional del Turismo de Cuba (Cuban Tourist Commission) 1
- Cuban Air Force, Attache' (Captain Randolfo Cossio) 1
- Cuban Atlantic Sugar Company 1
- Cuban Delegation to the United Nations 1
- Cuban Tourist Commission 1
- Cuban Tourist Commission (Corporacion Nacional del Turismo) 1
- Cuban-American Sugar Company 1
- Dr. Carlos Prio Socarras 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||
9233 | 9233 | 1958-07-14 | Fidel Castro | 1958-01-14 | CUBA | Vazquez, Jose Infanzon 1105 | 1958-01-14 | Vazquez, Jose Infanzon | Sierra Maestra | ||||
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) | |||||
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 | ||||
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) | |||||
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 | ||||
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 | |||||
9454 | 9454 | 1959-07-24 | Huge Lajonchere | 1959-07-24 | CUBA | Kolby, Edmund 1249 | 1959-07-24 | Kolby, Edmund | Havana | ||||
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 | |||
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 | |||||
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 | ||||
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 | |||
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.) | |||||
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 | |||
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 | ||||
11483 | 11483 | 1968-09-10 | Republic of Cuba | 1964-05-04 | CUBA | Rabinowitz & Boudin 1734 | 1964-05-04 | Rabinowitz & Boudin | Havana | ||||
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) | |||||
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 | |||
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 | |||||
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 | ||||
12565 | 12565 | 1958-10-09 | July 26th Movement | 1958-10-09 | CUBA | Bernenguer, John 1179 | 1958-10-09 | Bernenguer, John | Sierra Maestra | ||||
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 | ||||
12696 | 12696 | 1967-10-15 | Oscar Gutierrez | 1966-09-28 | CUBA | Brauer, Robert R. 1961 | 1966-02-07 | Brauer, Robert R. | New York | NY | |||
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 | ||||
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 | |||
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 | ||||
13913 | 13913 | 1958-11-13 | Junta de Liberacion | 1957-11-13 | CUBA | Prio Socarras, Carlos 1082 | 1957-11-13 | Prio Socarras, Carlos | Miami | FL | |||
14144 | 14144 | 1961-11-22 | Unidad Revolucionaria | 1961-11-22 | CUBA | Unidad Revolucionaria 1492 | 1961-11-22 | Unidad Revolucionaria | 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 | |||
14203 | 14203 | 1964-11-24 | Dr. Julio Garceran | 1963-01-14 | CUBA | Stone & Bittel 1591 | 1963-01-14 | Stone & Bittel | |||||
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 | ||||
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 | ||||
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 | |||
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 | |||||
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 | ||||
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 | |||
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 | |||
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 | ||||
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 | |||
15584 | 15584 | 1958-12-31 | Cuban Delegation to the United Nations | 1955-12-23 | CUBA | Frontaura, Pablo 926 | 1955-12-23 | Frontaura, Pablo | New York | NY | |||
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 | ||||
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 | ||||
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]) );