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

Search:

descending

Link	rowid ▼	Foreign_Principal_Termination_Date	Foreign_Principal	Foreign_Principal_Registration_Date	Country/Location_Represented	Registration_Number	Registrant_Date	Registrant_Name	Address_1	State
721	721	1967-01-01	Government of France	1952-12-05	FRANCE	746 746	1952-12-02	Squire, Sanders & Dempsey, L.L.P.	Paris
1952	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	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	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	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	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	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	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	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	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	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	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	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	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	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	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	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	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	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	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	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

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)
);