Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
This data as json, atom, 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)
Registrant_Name
City
Foreign_Principal
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 | 1867 | 1977-02-01 | Government of Pakistan | 1975-04-28 | PAKISTAN | 2169 2169 | 1969-11-10 | LeBoeuf, Lamb, Leiby & MacRae | Islamabad | ||||
| 1914 | 1914 | 1989-02-01 | Government of Pakistan | 1988-11-02 | PAKISTAN | 3637 3637 | 1985-01-09 | Whalen Company, Inc. | Islamabad | ||||
| 2474 | 2474 | 1990-02-17 | Government of Pakistan | 1987-02-18 | PAKISTAN | 3320 3320 | 1982-01-05 | Washington International Group, Inc. | Islamabad | ||||
| 2976 | 2976 | 1996-02-29 | Government of Pakistan | 1996-01-19 | PAKISTAN | 5093 5093 | 1996-01-19 | MQS, Inc. | Karachi | ||||
| 3045 | 3045 | 1972-03-01 | Government of Pakistan | 1962-07-13 | PAKISTAN | 1178 1178 | 1958-10-09 | Surrey, Karasik, Gould and Efron | |||||
| 6281 | 6281 | 1960-05-18 | Government of Pakistan | 1960-05-18 | PAKISTAN | 1360 1360 | 1960-05-18 | Schaffer Organization | New York | NY | |||
| 7844 | 7844 | 1968-06-30 | Government of Pakistan | 1963-08-23 | PAKISTAN | 1636 1636 | 1963-06-06 | Patton, Blow, Verrill, Brand & Boggs | Karachi | ||||
| 7967 | 7967 | 1985-06-30 | Government of Pakistan | 1980-11-17 | PAKISTAN | 3167 3167 | 1980-11-17 | Scott, Harrison & McLeod | |||||
| 8468 | 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 | 8524 | 1968-07-03 | Government of Pakistan | 1948-12-17 | PAKISTAN | 523 523 | 1948-04-16 | Covington & Burling | |||||
| 9640 | 9640 | 1994-08-05 | Government of Pakistan | 1990-10-03 | PAKISTAN | 3320 3320 | 1982-01-05 | Washington International Group, Inc. | Islamabad | ||||
| 9814 | 9814 | 1990-08-13 | Government of Pakistan | 1989-01-06 | PAKISTAN | 4200 4200 | 1989-01-06 | Mark A. Siegel & Associates, Inc. | Islamabad | ||||
| 10570 | 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 | 11907 | 1972-10-07 | Government of Pakistan | 1960-11-02 | PAKISTAN | 1406 1406 | 1960-11-02 | Brackman, Arnold C. | Washington | DC | |||
| 13803 | 13803 | 2002-11-30 | Government of Pakistan | 2002-10-01 | PAKISTAN | 5519 5519 | 2002-10-01 | Sterling International Consulting Corporation | Islamabad | ||||
| 14344 | 14344 | 1996-12-13 | Government of Pakistan | 1994-05-17 | PAKISTAN | 4200 4200 | 1989-01-06 | Mark A. Siegel & Associates, Inc. | Islamabad | ||||
| 15570 | 15570 | 1995-12-31 | Government of Pakistan | 1995-01-30 | PAKISTAN | 2469 2469 | 1973-10-23 | Burson-Marsteller | Islamabad |
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) );