FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
23 rows where Country/Location_Represented = "PHILIPPINES" and State = "DC"
This data as json, CSV (advanced)
Registrant_Name 9
Foreign_Principal 8
- Republic of the Philippines, Embassy 2
- Embassy of Republic of the Philippines 1
- Embassy of the Philippines 1
- Government of the Philippines 1
- Government of the Republic of the Philippines 1
- Philippine Sugar Commission 1
- Republic of the Philippines 1
- Veterans, Widows, Dependent Children & Parents Who Claim Veterans Benefits 1
City 2
- - 6
- Washington 3
State 1
- DC · 9 ✖
Country/Location_Represented 1
- PHILIPPINES · 9 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9832 | 9832 | 2000-07-31 | Government of the Republic of the Philippines | 1994-07-08 | PHILIPPINES | Icon Group 4926 | 1994-07-08 | Icon Group | Washington | DC | |||
10543 | 10543 | 2010-08-15 | Republic of the Philippines, Embassy | 2008-02-05 | PHILIPPINES | Eizenstat, Stuart E. 5851 | 2008-02-05 | Eizenstat, Stuart E. | 1600 Massachusetts Avenue, NW | Washington | DC | 20036 | |
10544 | 10544 | 2010-08-15 | Republic of the Philippines, Embassy | 2008-02-05 | PHILIPPINES | Covington & Burling, LLP 5852 | 2008-02-05 | Covington & Burling, LLP | 1600 Massachusetts Avenue, NW | Washington | DC | 20036 | |
11098 | 11098 | 2006-08-31 | Embassy of Republic of the Philippines | 2005-12-23 | PHILIPPINES | Stanton Communications 5724 | 2005-12-23 | Stanton Communications | 1600 Massachusetts Avenue, NW | Washington | DC | 20036 | |
12357 | 12357 | 1986-10-01 | Republic of the Philippines | 1986-09-21 | PHILIPPINES | TKC International, Inc. 3075 | 1979-12-13 | TKC International, Inc. | Washington | DC | |||
12997 | 12997 | 1984-10-25 | Philippine Sugar Commission | 1983-08-15 | PHILIPPINES | O'Neill & Haase, P.C. 3509 | 1983-08-15 | O'Neill & Haase, P.C. | Washington | DC | |||
13422 | 13422 | 2005-10-31 | Government of the Philippines | 2001-07-19 | PHILIPPINES | Bannerman & Associates, Inc. 3964 | 1987-04-28 | Bannerman & Associates, Inc. | 1600 Massachusetts Avenue, N.W. 20036 | DC | |||
14056 | 14056 | 1982-11-18 | Embassy of the Philippines | 1982-08-03 | PHILIPPINES | Stuart, John McHugh 3395 | 1982-08-03 | Stuart, John McHugh | DC | ||||
15461 | 15461 | 1961-12-30 | Veterans, Widows, Dependent Children & Parents Who Claim Veterans Benefits | 1960-11-29 | PHILIPPINES | Erana, Mariano A. 1411 | 1960-11-29 | Erana, Mariano A. | Washington | DC |
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]) );