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

21 rows where Registration_Number = 746

View and edit SQL

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

State

City

  • 21
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
721 1967-01-01 Government of France 1952-12-05 FRANCE 746 746 1952-12-02 Squire, Sanders & Dempsey, L.L.P. Paris        
1952 1957-02-02 Ufficio Italiano dei Cambi 1955-01-05 ITALY 746 746 1952-12-02 Squire, Sanders & Dempsey, L.L.P. Rome        
2043 1977-02-04 Government of Italy 1952-12-05 ITALY 746 746 1952-12-02 Squire, Sanders & Dempsey, L.L.P. Washington     DC  
2517 1974-02-20 Corporacion Nacional de Hoteles Y Turismo (CONAHOTU) 1972-07-05 VENEZUELA 746 746 1952-12-02 Squire, Sanders & Dempsey, L.L.P. Caracas        
2518 1974-02-20 Embassy of India 1969-07-03 INDIA 746 746 1952-12-02 Squire, Sanders & Dempsey, L.L.P. Washington     DC  
7085 1965-06-02 Embassy of the Federal Republic of Cameroon 1962-07-19 CAMEROON 746 746 1952-12-02 Squire, Sanders & Dempsey, L.L.P. Washington     DC  
7086 1965-06-02 Republic of Congo 1962-07-19 CONGO, DEMOCRATIC REPUBLIC OF THE 746 746 1952-12-02 Squire, Sanders & Dempsey, L.L.P. Washington     DC  
7087 1965-06-02 Republic of Gabon 1962-07-19 GABON 746 746 1952-12-02 Squire, Sanders & Dempsey, L.L.P. Washington     DC  
7088 1965-06-02 Republic of Tchad (Chad) 1963-07-08 CHAD 746 746 1952-12-02 Squire, Sanders & Dempsey, L.L.P. Washington     DC  
7089 1965-06-02 Republic of the Ivory Coast 1960-09-30 COTE D'IVOIRE (IVORY COAST) 746 746 1952-12-02 Squire, Sanders & Dempsey, L.L.P. Washington     DC  
7133 1966-06-03 Embassy of the Republic of Togo 1962-08-03 TOGO 746 746 1952-12-02 Squire, Sanders & Dempsey, L.L.P. Washington     DC  
7135 1971-06-03 Government of the Kingdom of Belgium 1968-01-10 BELGIUM 746 746 1952-12-02 Squire, Sanders & Dempsey, L.L.P. Brussels        
8902 1962-07-19 Malek Mansour Solat-Ghashghai 1957-09-16 IRAN 746 746 1952-12-02 Squire, Sanders & Dempsey, L.L.P. Washington     DC  
11333 1984-09-28 Republic of Togo 1979-03-07 TOGO 746 746 1952-12-02 Squire, Sanders & Dempsey, L.L.P. New York     NY  
14057 1954-12-02 Cassa per il Messogiorno 1952-12-05 ITALY 746 746 1952-12-02 Squire, Sanders & Dempsey, L.L.P. Rome        
14058 1959-12-02 Italian Federation of Farmers' Cooperatives 1952-12-05 ITALY 746 746 1952-12-02 Squire, Sanders & Dempsey, L.L.P. Washington     DC  
14059 1959-12-02 Government of Austria 1952-12-05 AUSTRIA 746 746 1952-12-02 Squire, Sanders & Dempsey, L.L.P. Washington     DC  
14060 1959-12-02 Italian Technical Delegation 1952-12-02 ITALY 746 746 1952-12-02 Squire, Sanders & Dempsey, L.L.P. Washington     DC  
14070 1997-12-02 Embassy of Belgium 1952-12-05 BELGIUM 746 746 1952-12-02 Squire, Sanders & Dempsey, L.L.P. Washington     DC  
14897 1961-12-31 Instituto de Acucar e do Alcol 1960-03-01 BRAZIL 746 746 1952-12-02 Squire, Sanders & Dempsey, L.L.P. Rio de Janeiro        
15387 1989-12-31 California Steel Industries, Inc. 1989-09-07 INTERNATIONAL 746 746 1952-12-02 Squire, Sanders & Dempsey, L.L.P. Fontana     CA  

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 149.726ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history