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

20 rows where Foreign_Principal = "Republic of the Philippines"

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	City	State
1759	1759	2007-01-31	Republic of the Philippines	2005-08-02	PHILIPPINES	5435 5435	2001-05-29	Venable, LLP	#5 V. Luna Road, Diliman	Quezon City
3768	3768	1994-03-22	Republic of the Philippines	1993-04-09	PHILIPPINES	4561 4561	1991-09-03	APCO Worldwide, Inc.	Manila
3802	3802	1993-03-24	Republic of the Philippines	1989-09-26	PHILIPPINES	4300 4300	1989-09-26	Fidelity Pacific Group, L.P.	Manila
4454	4454	2006-03-31	Republic of the Philippines	2005-04-14	PHILIPPINES	2759 2759	1977-03-09	White & Case, LLP	Office of the Solicitor General
5128	5128	1958-04-19	Republic of the Philippines	1957-06-24	PHILIPPINES	1041 1041	1957-06-24	Furness, Robert Charles	Manila
5132	5132	1965-04-19	Republic of the Philippines	1964-09-15	PHILIPPINES	1790 1790	1964-09-15	Sullivan & Cromwell
6956	6956	2019-05-31	Republic of the Philippines	2018-09-06	PHILIPPINES	6227 6227	2014-06-18	BCW LLC	DOF Building, BSP Complex, Roxas Blvd., 1004 Metro Manila
7174	7174	1980-06-03	Republic of the Philippines	1978-07-21	PHILIPPINES	2932 2932	1978-07-21	Foley, Lardner, Hollabaugh & Jacobs
7175	7175	1980-06-03	Republic of the Philippines	1978-07-21	PHILIPPINES	2933 2933	1978-07-21	Lucas, Friedman & Mann
8474	8474	1987-07-01	Republic of the Philippines	1986-09-26	PHILIPPINES	2165 2165	1969-10-09	Squire Patton Boggs, LLP	Manila
9596	9596	1994-08-01	Republic of the Philippines	1993-04-16	PHILIPPINES	3856 3856	1986-07-11	GCI Group, Inc.	Manila
9613	9613	2003-08-01	Republic of the Philippines	2002-04-08	PHILIPPINES	5492 5492	2002-04-08	Rhoads-Weber Shandwick Government Relations	Department of National Defense Room 202, DND Building Camp Emilio, Aguinaldo Quezen City
10151	10151	1954-08-18	Republic of the Philippines	1954-08-18	PHILIPPINES	841 841	1954-08-18	McDaniel, John Shepherd	Manila
11829	11829	1986-10-01	Republic of the Philippines	1986-09-21	PHILIPPINES	3075 3075	1979-12-13	TKC International, Inc.	Washington		DC
12230	12230	1949-10-17	Republic of the Philippines	1949-10-17	PHILIPPINES	592 592	1949-10-17	Pacis, Vicente Albano	Manila
12258	12258	1960-10-18	Republic of the Philippines	1958-04-17	PHILIPPINES	1132 1132	1958-04-17	McCarthy, Matthew E.
13271	13271	1978-11-10	Republic of the Philippines	1977-11-04	PHILIPPINES	2319 2319	1972-02-18	Doremus & Company	Manila
15046	15046	1972-12-31	Republic of the Philippines	1971-02-14	PHILIPPINES	1195 1195	1959-01-29	Philippine Tourist & Travel Association	Manila
15529	15529	1990-12-31	Republic of the Philippines	1990-02-09	PHILIPPINES	4266 4266	1989-06-12	Orrick, Herrington & Sutcliffe	San Francisco		CA
15980	15980	2007-12-31	Republic of the Philippines	2007-02-05	PHILIPPINES	5791 5791	2007-02-05	Squire Sanders Public Advocacy, LLC	Malacanang Palace	Manila

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