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

17 rows where Foreign_Principal = "Government of Pakistan"

✎ View and edit SQL

This data as json, CSV (advanced)

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

State 3

City 2

Foreign_Principal 1

  • Government of Pakistan · 17 ✖

Country/Location_Represented 1

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
1946 1946 1977-02-01 Government of Pakistan 1975-04-28 PAKISTAN LeBoeuf, Lamb, Leiby & MacRae 2169 1969-11-10 LeBoeuf, Lamb, Leiby & MacRae Islamabad        
1993 1993 1989-02-01 Government of Pakistan 1988-11-02 PAKISTAN Whalen Company, Inc. 3637 1985-01-09 Whalen Company, Inc. Islamabad        
2570 2570 1990-02-17 Government of Pakistan 1987-02-18 PAKISTAN Washington International Group, Inc. 3320 1982-01-05 Washington International Group, Inc. Islamabad        
3098 3098 1996-02-29 Government of Pakistan 1996-01-19 PAKISTAN MQS, Inc. 5093 1996-01-19 MQS, Inc. Karachi        
3173 3173 1972-03-01 Government of Pakistan 1962-07-13 PAKISTAN Surrey, Karasik, Gould and Efron 1178 1958-10-09 Surrey, Karasik, Gould and Efron          
6515 6515 1960-05-18 Government of Pakistan 1960-05-18 PAKISTAN Schaffer Organization 1360 1960-05-18 Schaffer Organization New York     NY  
8119 8119 1968-06-30 Government of Pakistan 1963-08-23 PAKISTAN Patton, Blow, Verrill, Brand & Boggs 1636 1963-06-06 Patton, Blow, Verrill, Brand & Boggs Karachi        
8242 8242 1985-06-30 Government of Pakistan 1980-11-17 PAKISTAN Scott, Harrison & McLeod 3167 1980-11-17 Scott, Harrison & McLeod          
8759 8759 2007-07-01 Government of Pakistan 2005-12-01 PAKISTAN JWT Asiatic, a division of WPP Marketing Communications (Pvt.) Ltd. 5722 2005-12-01 JWT Asiatic, a division of WPP Marketing Communications (Pvt.) Ltd. Information & Broadcasting Division 4th Floor Cabinet Block Islamabad    
8817 8817 1968-07-03 Government of Pakistan 1948-12-17 PAKISTAN Covington & Burling 523 1948-04-16 Covington & Burling          
9963 9963 1994-08-05 Government of Pakistan 1990-10-03 PAKISTAN Washington International Group, Inc. 3320 1982-01-05 Washington International Group, Inc. Islamabad        
10141 10141 1990-08-13 Government of Pakistan 1989-01-06 PAKISTAN Mark A. Siegel & Associates, Inc. 4200 1989-01-06 Mark A. Siegel & Associates, Inc. Islamabad        
10904 10904 2006-08-31 Government of Pakistan 2005-09-26 PAKISTAN Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC Information and Broadcasting Division 4th Floor - Cabinet Block Islamabad    
12301 12301 1972-10-07 Government of Pakistan 1960-11-02 PAKISTAN Brackman, Arnold C. 1406 1960-11-02 Brackman, Arnold C. Washington     DC  
14259 14259 2002-11-30 Government of Pakistan 2002-10-01 PAKISTAN Sterling International Consulting Corporation 5519 2002-10-01 Sterling International Consulting Corporation Islamabad        
14826 14826 1996-12-13 Government of Pakistan 1994-05-17 PAKISTAN Mark A. Siegel & Associates, Inc. 4200 1989-01-06 Mark A. Siegel & Associates, Inc. Islamabad        
16065 16065 1995-12-31 Government of Pakistan 1995-01-30 PAKISTAN Burson-Marsteller 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])
);