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)
Suggested facets: Foreign_Principal_Registration_Date, Registration_Number, Registrant_Date, Address_1, Address_2, Zip, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date)
Registrant_Name 21
- Bannerman & Associates, Inc. 3
- Covington & Burling, LLP 1
- Eizenstat, Stuart E. 1
- Erana, Mariano A. 1
- Fitzmaurice, Walter 1
- Foster, Mary Claude 1
- Gilman Group 1
- Haley, Maria Luisa M. (MH International) 1
- Hill and Knowlton Strategies, LLC 1
- Icon Group 1
- Johnston, Rod K. 1
- Ki, Fiona 1
- National Lecture Management, Inc. 1
- Natividad, Irene 1
- O'Neill & Haase, P.C. 1
- S.K.C. & Associates 1
- Sawyer Miller Group 1
- Squire Patton Boggs, LLP 1
- Stanton Communications 1
- Stuart, John McHugh 1
- TKC International, Inc. 1
Foreign_Principal_Termination_Date 21 ✖
- 1998-04-27 2
- 2010-08-15 2
- 1953-06-15 1
- 1958-01-22 1
- 1961-12-30 1
- 1982-11-18 1
- 1984-05-01 1
- 1984-10-25 1
- 1986-10-01 1
- 1988-05-31 1
- 1988-06-15 1
- 1990-05-11 1
- 1992-02-14 1
- 1992-04-10 1
- 2000-07-31 1
- 2001-06-30 1
- 2002-04-18 1
- 2005-10-31 1
- 2006-08-31 1
- 2009-03-05 1
- 2010-04-30 1
Registrant_Date (date) 20 ✖
- 1987-04-28 3
- 2008-02-05 2
- 1950-08-16 1
- 1958-01-22 1
- 1960-11-29 1
- 1969-10-09 1
- 1979-12-13 1
- 1981-11-10 1
- 1982-08-03 1
- 1983-08-15 1
- 1984-05-01 1
- 1986-02-12 1
- 1987-05-22 1
- 1988-04-07 1
- 1990-02-27 1
- 1994-07-08 1
- 2001-10-12 1
- 2005-12-23 1
- 2008-08-21 1
- 2009-04-15 1
Foreign_Principal 16
- Embassy of the Philippines 3
- Government of the Republic of the Philippines 3
- Republic of the Philippines, Embassy 3
- Government of the Philippines 2
- A.L. Valencia 1
- Ambassador Ariel Abadilla Republic of the Philippines, Embassy 1
- Embassy of Philippines 1
- Embassy of Republic of the Philippines 1
- Government of the Philippines, Embassy 1
- Melchior Aquino 1
- Office of Media Affairs Embassy of the Philippines 1
- Philippine Sugar Commission 1
- Prisco Entines 1
- Republic of the Philippines 1
- Romula V. Manlapig - Commercial Counselor, Embassy 1
- Veterans, Widows, Dependent Children & Parents Who Claim Veterans Benefits 1
City 2
- - 18
- Washington 5
State 1
- DC · 23 ✖
Country/Location_Represented 1
- PHILIPPINES · 23 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1457 | 1457 | 1958-01-22 | A.L. Valencia | 1958-01-22 | PHILIPPINES | Fitzmaurice, Walter 1109 | 1958-01-22 | Fitzmaurice, Walter | Washington | DC | |||
2489 | 2489 | 1992-02-14 | Embassy of the Philippines | 1990-02-27 | PHILIPPINES | Natividad, Irene 4346 | 1990-02-27 | Natividad, Irene | Washington | DC | |||
3460 | 3460 | 2009-03-05 | Republic of the Philippines, Embassy | 2008-08-21 | PHILIPPINES | Gilman Group 5879 | 2008-08-21 | Gilman Group | 1600 Massachusetts Avenue, NW | Washington | DC | 20036 | |
5144 | 5144 | 1992-04-10 | Government of the Republic of the Philippines | 1988-05-31 | PHILIPPINES | Sawyer Miller Group 3777 | 1986-02-12 | Sawyer Miller Group | Washington | DC | |||
5384 | 5384 | 2002-04-18 | Ambassador Ariel Abadilla Republic of the Philippines, Embassy | 2001-10-12 | PHILIPPINES | Haley, Maria Luisa M. (MH International) 5461 | 2001-10-12 | Haley, Maria Luisa M. (MH International) | 1600 Massachusetts Avenue, N.W. 20036 | DC | |||
5625 | 5625 | 1998-04-27 | Government of the Philippines | 1994-06-01 | PHILIPPINES | Bannerman & Associates, Inc. 3964 | 1987-04-28 | Bannerman & Associates, Inc. | Washington | DC | |||
5626 | 5626 | 1998-04-27 | Government of the Philippines, Embassy | 1994-06-01 | PHILIPPINES | Bannerman & Associates, Inc. 3964 | 1987-04-28 | Bannerman & Associates, Inc. | Washington | DC | |||
6063 | 6063 | 2010-04-30 | Romula V. Manlapig - Commercial Counselor, Embassy | 2009-04-15 | PHILIPPINES | Ki, Fiona 5930 | 2009-04-15 | Ki, Fiona | Philippines Embassy | 1600 Massachusetts Avenue, NW | Washington | DC | 20036 |
6189 | 6189 | 1984-05-01 | Office of Media Affairs Embassy of the Philippines | 1984-05-01 | PHILIPPINES | Foster, Mary Claude 3578 | 1984-05-01 | Foster, Mary Claude | Washington | DC | |||
6456 | 6456 | 1990-05-11 | Embassy of the Philippines | 1990-03-13 | PHILIPPINES | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | Washington | DC | |||
7064 | 7064 | 1988-05-31 | Embassy of Philippines | 1987-05-22 | PHILIPPINES | S.K.C. & Associates 3984 | 1987-05-22 | S.K.C. & Associates | Washington | DC | |||
7812 | 7812 | 1953-06-15 | Melchior Aquino | 1952-09-19 | PHILIPPINES | National Lecture Management, Inc. 638 | 1950-08-16 | National Lecture Management, Inc. | Washington | DC | |||
7832 | 7832 | 1988-06-15 | Prisco Entines | 1988-04-07 | PHILIPPINES | Johnston, Rod K. 4116 | 1988-04-07 | Johnston, Rod K. | Washington | DC | |||
8608 | 8608 | 2001-06-30 | Government of the Republic of the Philippines | 1995-10-05 | PHILIPPINES | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | Washington | DC | |||
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]) );