FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
14 rows where Address_1 = "Washington" and Country/Location_Represented = "PAKISTAN" sorted by State
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Termination_Date, Foreign_Principal_Registration_Date, Registration_Number, Registrant_Date, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date)
Registrant_Name 13
- Brackman, Arnold C. 2
- Adams, John B. 1
- Beeson, Caroline J. 1
- Fein, Bruce 1
- Foster & Wilkinson 1
- Gold & Liebengood, Inc. 1
- Hooper, Owen & Winburn 1
- Jurdem Thomas Associates 1
- Olson, Kenneth G. 1
- Preston, Gates & Ellis, L.L.P. 1
- Speers, Peter Carter 1
- Squire Patton Boggs, LLP 1
- van Kloberg & Associates, Ltd. 1
Registrant_Date (date) 12 ✖
- 1953-07-16 2
- 1960-11-02 2
- 1969-10-09 1
- 1979-05-22 1
- 1982-08-05 1
- 1983-05-09 1
- 1984-03-13 1
- 1984-03-22 1
- 1985-04-10 1
- 1985-07-09 1
- 1996-06-10 1
- 1997-05-12 1
Foreign_Principal 7
State 1
- DC 14
Country/Location_Represented 1
- PAKISTAN · 14 ✖
City 1
- - 14
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
907 | 907 | 1988-01-01 | Export Promotion Bureau, Government of Pakistan | 1985-04-10 | PAKISTAN | Foster & Wilkinson 3669 | 1985-04-10 | Foster & Wilkinson | Washington | DC | |||
1367 | 1367 | 1959-01-16 | Pakistan Information Service | 1953-07-16 | PAKISTAN | Adams, John B. 780 | 1953-07-16 | Adams, John B. | Washington | DC | |||
1395 | 1395 | 1985-01-18 | Export Promotion Bureau, Government of Pakistan | 1984-03-13 | PAKISTAN | Beeson, Caroline J. 3565 | 1984-03-13 | Beeson, Caroline J. | Washington | DC | |||
4944 | 4944 | 1998-04-01 | Embassy of Pakistan | 1997-08-07 | PAKISTAN | Fein, Bruce 5111 | 1996-06-10 | Fein, Bruce | Washington | DC | |||
5479 | 5479 | 1997-04-22 | Embassy of Pakistan | 1995-05-10 | PAKISTAN | Preston, Gates & Ellis, L.L.P. 3567 | 1984-03-22 | Preston, Gates & Ellis, L.L.P. | Washington | DC | |||
6358 | 6358 | 1980-05-06 | Government of Pakistan & Ambassador H.E.S.M. Kahn | 1979-05-22 | PAKISTAN | Jurdem Thomas Associates 3026 | 1979-05-22 | Jurdem Thomas Associates | Washington | DC | |||
8034 | 8034 | 1993-06-23 | Embassy of Pakistan | 1993-01-08 | PAKISTAN | van Kloberg & Associates, Ltd. 3466 | 1983-05-09 | van Kloberg & Associates, Ltd. | Washington | DC | |||
8605 | 8605 | 2001-06-30 | Government of Pakistan, Embassy | 1997-05-12 | PAKISTAN | Hooper, Owen & Winburn 5179 | 1997-05-12 | Hooper, Owen & Winburn | Washington | DC | |||
8606 | 8606 | 2001-06-30 | Government of Pakistan, Embassy | 1994-11-30 | PAKISTAN | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | Washington | DC | |||
12526 | 12526 | 1972-10-07 | Government of Pakistan | 1960-11-02 | PAKISTAN | Brackman, Arnold C. 1406 | 1960-11-02 | Brackman, Arnold C. | Washington | DC | |||
13779 | 13779 | 1972-11-07 | Pakistan | 1971-01-31 | PAKISTAN | Brackman, Arnold C. 1406 | 1960-11-02 | Brackman, Arnold C. | Washington | DC | |||
14455 | 14455 | 1995-11-30 | Government of Pakistan, Embassy | 1995-10-30 | PAKISTAN | Gold & Liebengood, Inc. 3700 | 1985-07-09 | Gold & Liebengood, Inc. | Washington | DC | |||
14938 | 14938 | 1982-12-10 | Embassy of Pakistan | 1982-08-05 | PAKISTAN | Olson, Kenneth G. 3397 | 1982-08-05 | Olson, Kenneth G. | Washington | DC | |||
15586 | 15586 | 1958-12-31 | Pakistan Information Service | 1953-07-16 | PAKISTAN | Speers, Peter Carter 781 | 1953-07-16 | Speers, Peter Carter | 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]) );