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 State
This data as json, CSV (advanced)
Registrant_Name >30
- U.S.-Cuban Sugar Council 21
- Brauer, Robert R. 7
- Junta de Liberacion Cubana 7
- Ek, John 5
- Fernandez, Carlos B. 3
- Hogan, Donald W. 2
- Pan-American Coffee Bureau 2
- Prio Socarras, Carlos 2
- Quinn, Arthur Lee 2
- Skelly, John T. 2
- 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
- Club 26 de Julio de Miami 1
- Cuban Chamber of Commerce in the U.S., Inc. 1
- Cuban Tourist Commission, Miami Office 1
- EMB, Ltd. 1
- Erice, Michael A. 1
- Fanelli, Joseph A. 1
- Federacion Estudiantil Universitaria (of Cuba In Exile) 1
- Fiallo, Rene 1
- Frente Revolucionario Democratico 1
- Friends of Cuba In Exile 1
- Frontaura, Pablo 1
- Griffin, John David 1
- Kem, James P. 1
- …
Foreign_Principal >30
- Republic of Cuba 4
- No foreign principal listed 2
- Partido Revolucionario Cubano (Autentico) 2
- United States Cuban Sugar Council 2
- 26 de Julio Committee in Exile 1
- 26 de Julio, Country in Exile 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
- Autentico Party 1
- Candido (Previous acting foreign principal deceased) 1
- Captain Alfred Guerra/Officinas Primer Ministro, Captain of Investigation 1
- Caribbean Sugar Company 1
- Carlos Prio Socarras 1
- Central Altagracia Sugar Company 1
- Central Hormiguero, S.A. 1
- Central Violeta Sugar Company 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
- 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
- …
Country/Location_Represented 1
- CUBA · 91 ✖
City 1
- - 91
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||
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 | ||||
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 | ||||
14203 | 14203 | 1964-11-24 | Dr. Julio Garceran | 1963-01-14 | CUBA | Stone & Bittel 1591 | 1963-01-14 | Stone & Bittel | |||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
1119 | 1119 | 1959-01-07 | Embassy of the Republic of Cuba | 1958-10-08 | CUBA | Lum, Fairlie & Foster 1175 | 1958-10-08 | Lum, Fairlie & Foster | Washington | DC | |||
2431 | 2431 | 1961-02-13 | Republic of Cuba | 1960-03-22 | CUBA | Fanelli, Joseph A. 1342 | 1960-03-22 | Fanelli, Joseph A. | Washington | DC | |||
2899 | 2899 | 1959-02-28 | Embassy of Republic of Cuba (Ambassador Nicholas Arroyo) | 1958-10-22 | CUBA | Martial & Company, Inc. 1182 | 1958-10-22 | Martial & Company, Inc. | Washington | DC | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
1664 | 1664 | 1958-01-31 | Directorio Obrero Revolucionario | 1957-11-27 | CUBA | Junta de Liberacion Cubana 1086 | 1957-11-27 | Junta de Liberacion Cubana | Miami | FL | |||
1665 | 1665 | 1958-01-31 | Directorio Revolucionario | 1957-11-27 | CUBA | Junta de Liberacion Cubana 1086 | 1957-11-27 | Junta de Liberacion Cubana | Miami | FL | |||
1666 | 1666 | 1958-01-31 | Federacion Estudiantil Universitaria | 1957-11-27 | CUBA | Junta de Liberacion Cubana 1086 | 1957-11-27 | Junta de Liberacion Cubana | Miami | FL | |||
1669 | 1669 | 1958-01-31 | Movimiento 26 de Julio | 1957-11-27 | CUBA | Junta de Liberacion Cubana 1086 | 1957-11-27 | Junta de Liberacion Cubana | Miami | FL | |||
1670 | 1670 | 1958-01-31 | Organizacion Autentica | 1957-11-27 | CUBA | Junta de Liberacion Cubana 1086 | 1957-11-27 | Junta de Liberacion Cubana | Miami | FL | |||
1671 | 1671 | 1958-01-31 | Partido Revolucionario Cubano (Autentico) | 1957-11-27 | CUBA | Junta de Liberacion Cubana 1086 | 1957-11-27 | Junta de Liberacion Cubana | Miami | FL | |||
1672 | 1672 | 1958-01-31 | Partido del Pueblo Cubano (Ortodoxos) | 1957-11-27 | CUBA | Junta de Liberacion Cubana 1086 | 1957-11-27 | Junta de Liberacion Cubana | Miami | FL | |||
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 | |||
2534 | 2534 | 1954-02-15 | Carlos Prio Socarras | 1954-02-15 | CUBA | Griffin, John David 815 | 1954-02-15 | Griffin, John David | Miami | FL | |||
5451 | 5451 | 1962-04-21 | Republic of Cuba | 1960-10-21 | CUBA | Patton & Kanner 1403 | 1960-10-21 | Patton & Kanner | Miami | FL | |||
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 | |||
7933 | 7933 | 1959-06-19 | 26 de Julio Committee in Exile | 1959-06-19 | CUBA | Hogan, Donald W. 1238 | 1959-06-19 | Hogan, Donald W. | Miami | FL | |||
8233 | 8233 | 1959-06-30 | 26 de Julio, Country in Exile | 1959-06-19 | CUBA | Hogan, Donald W. 1238 | 1959-06-19 | Hogan, Donald W. | Miami | FL | |||
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 | |||
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 | |||
11825 | 11825 | 1960-09-26 | Hector Garcia Soto | 1960-09-26 | CUBA | Asencio, Armando J. 1395 | 1960-09-26 | Asencio, Armando J. | Miami | FL | |||
13913 | 13913 | 1958-11-13 | Junta de Liberacion | 1957-11-13 | CUBA | Prio Socarras, Carlos 1082 | 1957-11-13 | Prio Socarras, Carlos | Miami | FL | |||
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 | |||
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 | |||
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 | |||
1063 | 1063 | 1945-01-04 | No Foreign Principal Listed (Cuba mentioned on initial statement as country) | 1945-01-04 | CUBA | Cuban Chamber of Commerce in the U.S., Inc. 287 | 1945-01-04 | Cuban Chamber of Commerce in the U.S., Inc. | New York | NY | |||
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 | |||
12696 | 12696 | 1967-10-15 | Oscar Gutierrez | 1966-09-28 | CUBA | Brauer, Robert R. 1961 | 1966-02-07 | Brauer, Robert R. | New York | NY | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 |
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]) );