FARA_All_ForeignPrincipals

Table actions
List of all foreign principals (active and terminated)

Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history

14 rows where City = "Washington", Country/Location_Represented = "PAKISTAN" and State = "DC"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Foreign_Principal_Termination_Date, Registration_Number, Registrant_Date, Address_1, Address_2, Zip, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)

State 1

Country/Location_Represented 1

  • PAKISTAN · 14 ✖

City 1

  • Washington · 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
1229 1229 2020-01-11 Embassy of Pakistan 2019-07-26 PAKISTAN Holland & Knight 3718 1985-08-07 Holland & Knight 3517 International Court, NW   Washington DC 20008
1357 1357 2009-01-15 Ministry of Commerce, Government of Pakistan, Embassy 2007-10-31 PAKISTAN Dewey & LeBoeuf, LLP 5835 2007-10-31 Dewey & LeBoeuf, LLP Embassy of Pakistan 3517 International Court, NW Washington DC 20008
1363 1363 2021-01-15 Islamic Republic of Pakistan 2020-04-25 PAKISTAN Linden Government Solutions, LLC 6682 2019-05-19 Linden Government Solutions, LLC 3517 International Ct NW   Washington DC 20008
1868 1868 2007-01-31 Ministry of Commerce of the Government of Pakistan, Embassy 2006-06-01 PAKISTAN Quinn Gillespie & Associates, LLC 5753 2006-06-01 Quinn Gillespie & Associates, LLC 3517 International Court, NW   Washington DC 20008
4701 4701 2010-03-31 Embassy of the Islamic Republic of Pakistan 2009-07-14 PAKISTAN Cassidy & Associates, Inc. 5643 2004-09-10 Cassidy & Associates, Inc. 3617 International Court, NW   Washington DC 20008
6719 6719 2008-05-22 Embassy of Pakistan 2007-12-31 PAKISTAN Ogilvy Public Relations Worldwide 5807 2007-05-07 Ogilvy Public Relations Worldwide 3517 International Court, NW   Washington DC 20008
6720 6720 2008-05-22 Government of the Islamic Republic of Pakistan, Embassy 2005-06-06 PAKISTAN Van Scoyoc Associates, Inc. 5401 2000-12-14 Van Scoyoc Associates, Inc. 3517 International Court, NW   Washington DC 20008
7004 7004 2022-05-30 Embassy of Pakistan 2022-03-26 PAKISTAN South/North Communications LLC 6972 2021-06-10 South/North Communications LLC 3517 International Court NW   Washington DC 20008
9898 9898 2013-07-31 The Embassy of the Islamic Republic of Pakistan 2008-05-09 PAKISTAN Locke Lord Strategies, L.P. 5856 2008-03-07 Locke Lord Strategies, L.P. 3517 International Court   Washington DC 20008
12180 12180 2007-09-30 Ministry of Commerce, Government of Pakistan, Embassy 2007-06-21 PAKISTAN Hunton & Williams, LLP 5627 2004-06-15 Hunton & Williams, LLP 3517 International Court, NW   Washington DC 20008
13837 13837 2007-11-08 Embassy of the Islamic Republic of Pakistan 2007-10-04 PAKISTAN Cassidy & Associates, Inc. 5643 2004-09-10 Cassidy & Associates, Inc. 3517 International Court, NW   Washington DC 20008
14084 14084 2020-11-19 The Islamic Republic of Pakistan in the United States 2020-08-31 PAKISTAN BLJ Worldwide LTD 5875 2008-06-17 BLJ Worldwide LTD 3517 International Court NW   Washington DC 20008
14741 14741 2021-12-01 Council on Pakistan Relations 2021-06-10 PAKISTAN South/North Communications LLC 6972 2021-06-10 South/North Communications LLC 1455 Pennsylvania Avenue, NW Suite 400 Washington DC 20004
16922 16922 2022-12-31 Embassy of the Islamic Republic of Pakistan 2021-11-16 PAKISTAN Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 3517 International Ct NW   Washington DC 20008

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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