home / fara

Menu
  • Search all tables
  • GraphQL API

FARA_All_ForeignPrincipals

Table actions
  • GraphQL API for 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

8 rows where Country/Location_Represented = "CANADA" and Foreign_Principal = "Hydro-Quebec"

✖
✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

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

Registrant_Name 8

  • Burson-Marsteller 1
  • Cameron McKenna, LLP 1
  • Chartwell Communications 1
  • Kimbell Sherman & Ellis 1
  • Nixon, Hargrave, Devans & Doyle, L.L.P. 1
  • Parlato Productions, Inc. 1
  • Paul A. London & Associates, Inc. 1
  • Shandwick 1

State 1

  • - 8

Foreign_Principal 1

  • Hydro-Quebec · 8 ✖

Country/Location_Represented 1

  • CANADA · 8 ✖

City 1

  • - 8
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
1846 1846 2003-01-31 Hydro-Quebec 1997-01-08 CANADA Cameron McKenna, LLP 5150 1997-01-08 Cameron McKenna, LLP Montreal, Quebec        
4177 4177 1990-03-30 Hydro-Quebec 1989-09-27 CANADA Chartwell Communications 4298 1989-09-27 Chartwell Communications Montreal        
7164 7164 1997-05-31 Hydro-Quebec 1993-11-05 CANADA Shandwick 4866 1993-11-05 Shandwick Montreal, Quebec        
7878 7878 1993-06-16 Hydro-Quebec 1987-02-06 CANADA Paul A. London & Associates, Inc. 3935 1987-02-06 Paul A. London & Associates, Inc. Quebec        
13367 13367 1997-10-31 Hydro-Quebec 1991-04-25 CANADA Kimbell Sherman & Ellis 4506 1991-04-25 Kimbell Sherman & Ellis Montreal, Quebec        
14098 14098 1997-11-20 Hydro-Quebec 1991-11-20 CANADA Nixon, Hargrave, Devans & Doyle, L.L.P. 4596 1991-11-20 Nixon, Hargrave, Devans & Doyle, L.L.P. Montreal, Quebec        
14223 14223 1993-11-24 Hydro-Quebec 1993-01-28 CANADA Burson-Marsteller 2469 1973-10-23 Burson-Marsteller Montreal, Quebec        
14871 14871 1990-12-07 Hydro-Quebec 1989-10-25 CANADA Parlato Productions, Inc. 4311 1989-10-25 Parlato Productions, Inc. Montreal, Quebec        

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 · Queries took 217.667ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
  • Sort ascending
  • Sort descending
  • Facet by this
  • Hide this column
  • Show all columns
  • Show not-blank rows