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 Country/Location_Represented = "PAKISTAN" and Foreign_Principal = "Government of Pakistan"

✖
✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Registration_Number, Registrant_Date, 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

  • PAKISTAN · 17 ✖
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
1986 1986 1977-02-01 Government of Pakistan 1975-04-28 PAKISTAN LeBoeuf, Lamb, Leiby & MacRae 2169 1969-11-10 LeBoeuf, Lamb, Leiby & MacRae Islamabad        
2033 2033 1989-02-01 Government of Pakistan 1988-11-02 PAKISTAN Whalen Company, Inc. 3637 1985-01-09 Whalen Company, Inc. Islamabad        
2621 2621 1990-02-17 Government of Pakistan 1987-02-18 PAKISTAN Washington International Group, Inc. 3320 1982-01-05 Washington International Group, Inc. Islamabad        
3157 3157 1996-02-29 Government of Pakistan 1996-01-19 PAKISTAN MQS, Inc. 5093 1996-01-19 MQS, Inc. Karachi        
3232 3232 1972-03-01 Government of Pakistan 1962-07-13 PAKISTAN Surrey, Karasik, Gould and Efron 1178 1958-10-09 Surrey, Karasik, Gould and Efron          
6637 6637 1960-05-18 Government of Pakistan 1960-05-18 PAKISTAN Schaffer Organization 1360 1960-05-18 Schaffer Organization New York     NY  
8270 8270 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        
8393 8393 1985-06-30 Government of Pakistan 1980-11-17 PAKISTAN Scott, Harrison & McLeod 3167 1980-11-17 Scott, Harrison & McLeod          
8920 8920 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    
8981 8981 1968-07-03 Government of Pakistan 1948-12-17 PAKISTAN Covington & Burling 523 1948-04-16 Covington & Burling          
10144 10144 1994-08-05 Government of Pakistan 1990-10-03 PAKISTAN Washington International Group, Inc. 3320 1982-01-05 Washington International Group, Inc. Islamabad        
10323 10323 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        
11099 11099 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    
12526 12526 1972-10-07 Government of Pakistan 1960-11-02 PAKISTAN Brackman, Arnold C. 1406 1960-11-02 Brackman, Arnold C. Washington     DC  
14501 14501 2002-11-30 Government of Pakistan 2002-10-01 PAKISTAN Sterling International Consulting Corporation 5519 2002-10-01 Sterling International Consulting Corporation Islamabad        
15077 15077 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        
16328 16328 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])
);