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

17 rows where Foreign_Principal = "Government of Pakistan"

View and edit SQL

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

State

City

Foreign_Principal

  • Government of Pakistan · 17

Country/Location_Represented

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
1867 1977-02-01 Government of Pakistan 1975-04-28 PAKISTAN 2169 2169 1969-11-10 LeBoeuf, Lamb, Leiby & MacRae Islamabad        
1914 1989-02-01 Government of Pakistan 1988-11-02 PAKISTAN 3637 3637 1985-01-09 Whalen Company, Inc. Islamabad        
2474 1990-02-17 Government of Pakistan 1987-02-18 PAKISTAN 3320 3320 1982-01-05 Washington International Group, Inc. Islamabad        
2976 1996-02-29 Government of Pakistan 1996-01-19 PAKISTAN 5093 5093 1996-01-19 MQS, Inc. Karachi        
3045 1972-03-01 Government of Pakistan 1962-07-13 PAKISTAN 1178 1178 1958-10-09 Surrey, Karasik, Gould and Efron          
6281 1960-05-18 Government of Pakistan 1960-05-18 PAKISTAN 1360 1360 1960-05-18 Schaffer Organization New York     NY  
7844 1968-06-30 Government of Pakistan 1963-08-23 PAKISTAN 1636 1636 1963-06-06 Patton, Blow, Verrill, Brand & Boggs Karachi        
7967 1985-06-30 Government of Pakistan 1980-11-17 PAKISTAN 3167 3167 1980-11-17 Scott, Harrison & McLeod          
8468 2007-07-01 Government of Pakistan 2005-12-01 PAKISTAN 5722 5722 2005-12-01 JWT Asiatic, a division of WPP Marketing Communications (Pvt.) Ltd. Information & Broadcasting Division 4th Floor Cabinet Block Islamabad    
8524 1968-07-03 Government of Pakistan 1948-12-17 PAKISTAN 523 523 1948-04-16 Covington & Burling          
9640 1994-08-05 Government of Pakistan 1990-10-03 PAKISTAN 3320 3320 1982-01-05 Washington International Group, Inc. Islamabad        
9814 1990-08-13 Government of Pakistan 1989-01-06 PAKISTAN 4200 4200 1989-01-06 Mark A. Siegel & Associates, Inc. Islamabad        
10570 2006-08-31 Government of Pakistan 2005-09-26 PAKISTAN 3301 3301 1981-11-10 Hill and Knowlton Strategies, LLC Information and Broadcasting Division 4th Floor - Cabinet Block Islamabad    
11907 1972-10-07 Government of Pakistan 1960-11-02 PAKISTAN 1406 1406 1960-11-02 Brackman, Arnold C. Washington     DC  
13803 2002-11-30 Government of Pakistan 2002-10-01 PAKISTAN 5519 5519 2002-10-01 Sterling International Consulting Corporation Islamabad        
14344 1996-12-13 Government of Pakistan 1994-05-17 PAKISTAN 4200 4200 1989-01-06 Mark A. Siegel & Associates, Inc. Islamabad        
15570 1995-12-31 Government of Pakistan 1995-01-30 PAKISTAN 2469 2469 1973-10-23 Burson-Marsteller Islamabad        

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)
);
Powered by Datasette · Query took 407.612ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history