FARA_All_ForeignPrincipals

List of all foreign principals (active and terminated)

Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history

12 rows where Registration_Number = 77

View and edit SQL

Suggested facets: Foreign_Principal_Registration_Date, Address_1, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)

Country/Location_Represented

State

  • 12

City

  • 12
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
1802 1943-02-01 Alfredo Lluro 1943-03-12 PANAMA 77 77 1942-08-01 Pan-American Associated Enterprises          
1803 1943-02-01 Alfredo Lluro 1942-08-01 PANAMA 77 77 1942-08-01 Pan-American Associated Enterprises          
1804 1943-02-01 Alfredo Pellicer (Empresario de Espectacules) 1942-08-01 CURACAO 77 77 1942-08-01 Pan-American Associated Enterprises          
1805 1943-02-01 Carlos Lamena Falcon 1942-08-01 VENEZUELA 77 77 1942-08-01 Pan-American Associated Enterprises Caracas        
1806 1943-02-01 Don Miguel Angle De Chacon 1942-08-01 EL SALVADOR 77 77 1942-08-01 Pan-American Associated Enterprises San Salvador        
1807 1943-02-01 F. Rodriquez Rosa 1943-03-12 MEXICO 77 77 1942-08-01 Pan-American Associated Enterprises          
1808 1943-02-01 Hector Cabral 1943-03-12 PERU 77 77 1942-08-01 Pan-American Associated Enterprises Lima        
1809 1943-02-01 Horacio Perez 1942-08-01 DOMINICAN REPUBLIC 77 77 1942-08-01 Pan-American Associated Enterprises Cuidad, Trujillo        
1810 1943-02-01 Manuel F. Canosa 1943-03-12 CUBA 77 77 1942-08-01 Pan-American Associated Enterprises Havana        
1811 1943-02-01 Organizacione Cinematografica de Representaciones Artisticas 1943-03-12 ARGENTINA 77 77 1942-08-01 Pan-American Associated Enterprises Buenos Aires        
1812 1943-02-01 Pedro F. Gotay 1943-03-12 PUERTO RICO 77 77 1942-08-01 Pan-American Associated Enterprises San Juan        
1813 1943-02-01 Roberto Crespo 1942-08-01 COLOMBIA 77 77 1942-08-01 Pan-American Associated Enterprises Medellin        

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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)
);
Powered by Datasette · Query took 193.374ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history