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

17 rows where Foreign_Principal = "Government of Israel"

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
270	270		Government of Israel	1992-07-27	ISRAEL	3731 3731	1985-09-13	Sidley Austin, LLP	Jerusalem
1577	1577	1961-01-31	Government of Israel	1960-12-07	ISRAEL	523 523	1948-04-16	Covington & Burling	Asbury Park	NJ
2554	2554	1992-02-22	Government of Israel	1992-01-09	ISRAEL	3856 3856	1986-07-11	GCI Group, Inc.	New York	NY
2580	2580	1975-02-24	Government of Israel	1974-07-24	ISRAEL	2527 2527	1974-07-24	Loeb, Rhoades & Company	Washington	DC
2608	2608	1960-02-25	Government of Israel	1950-04-04	ISRAEL	345 345	1946-02-25	Gass, Oscar	Hakiryah
3373	3373	1996-03-10	Government of Israel	1995-05-12	ISRAEL	3274 3274	1981-09-10	Powell, Goldstein, Frazer & Murphy, L.L.P.	Washington	DC
3588	3588	1970-03-16	Government of Israel	1950-02-28	ISRAEL	540 540	1948-09-16	Ginsburg, Feldman & Bress	Washington	DC
6064	6064	1992-05-08	Government of Israel	1992-01-09	ISRAEL	4561 4561	1991-09-03	APCO Worldwide, Inc.	New York	NY
6683	6683	1984-05-31	Government of Israel	1977-05-10	ISRAEL	1481 1481	1961-09-27	Ruder Finn, Inc.
7218	7218	1963-06-06	Government of Israel	1960-12-06	ISRAEL	1412 1412	1960-12-06	Cerceo, Alfred G.	Asbury Park	NJ
8861	8861	1987-07-17	Government of Israel	1986-08-19	ISRAEL	3872 3872	1986-08-19	Hoffman, Ira E.	New York	NY
9564	9564	1966-08-02	Government of Israel	1965-04-23	ISRAEL	1888 1888	1965-04-23	Paul, Weiss, Rifkind, Wharton & Garrison	Jerusalem
10178	10178	1956-08-24	Government of Israel	1956-08-24	ISRAEL	972 972	1956-08-24	Brown, Darwin Charles	Washington	DC
10234	10234	1985-08-26	Government of Israel	1971-07-29	ISRAEL	2272 2272	1971-07-29	Law Offices of Cohen & Uretz
13092	13092	1962-11-07	Government of Israel	1960-12-27	ISRAEL	1416 1416	1960-12-27	Resnick, Zimel
14035	14035	1978-12-03	Government of Israel	1977-10-21	ISRAEL	1750 1750	1964-06-04	Arnold & Porter Kaye Scholer, LLP
14548	14548	1992-12-21	Government of Israel	1983-05-20	ISRAEL	3473 3473	1983-05-20	Fried, Frank, Harris, Shriver & Jacobson

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