FARA_All_RegistrantDocs

Table actions
List of URLs to all registrant docs (available in PDF format)

Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history

8 rows where Foreign_Principal_Country = "CANADA" and Foreign_Principal_Name = "HYDRO-QUEBEC"

✎ View and edit SQL

This data as json, CSV (advanced)

Foreign_Principal_Name 1

  • HYDRO-QUEBEC · 8 ✖

Foreign_Principal_Country 1

  • CANADA · 8 ✖

Document_Type 1

Link rowid ▼ Date_Stamped Registrant_Name Registration_Number Document_Type Short_Form_Name Foreign_Principal_Name Foreign_Principal_Country URL
2293 2293 1993-01-01 BURSON-MARSTELLER Burson-Marsteller 2469 Exhibit AB   HYDRO-QUEBEC CANADA https://efile.fara.gov/docs/2469-Exhibit-AB-19930101-CZMSOM02.pdf
2529 2529 1993-01-01 NIXON, HARGROVE & DOYLE, LLP Nixon, Hargrave, Devans & Doyle, L.L.P. 4596 Exhibit AB   HYDRO-QUEBEC CANADA https://efile.fara.gov/docs/4596-Exhibit-AB-19930101-D1W3SF04.pdf
4027 4027 1997-01-08 MORLEY CASKIN Cameron McKenna, LLP 5150 Exhibit AB   HYDRO-QUEBEC CANADA https://efile.fara.gov/docs/5150-Exhibit-AB-19970108-E571DX93.pdf
11663 11663 1987-02-01 PAUL A. LONDON & ASSOCIATES, INC. Paul A. London & Associates, Inc. 3935 Exhibit AB   HYDRO-QUEBEC CANADA https://efile.fara.gov/docs/3935-Exhibit-AB-19870201-D1HO6Y04.pdf
35597 35597 1991-04-01 KIMBELL SHERMAN & ELLIS Kimbell Sherman & Ellis 4506 Exhibit AB   HYDRO-QUEBEC CANADA https://efile.fara.gov/docs/4506-Exhibit-AB-19910401-D1UR9Q04.pdf
43265 43265 1998-04-27 SHANDWICK Shandwick 4866 Exhibit AB   HYDRO-QUEBEC CANADA https://efile.fara.gov/docs/4866-Exhibit-AB-19980427-F9D24901.pdf
115791 115791 1991-11-01 NIXON, HARGROVE & DOYLE, LLP Nixon, Hargrave, Devans & Doyle, L.L.P. 4596 Exhibit AB   HYDRO-QUEBEC CANADA https://efile.fara.gov/docs/4596-Exhibit-AB-19911101-D1UY0L04.pdf
116577 116577 1993-11-01 SHANDWICK Shandwick 4866 Exhibit AB   HYDRO-QUEBEC CANADA https://efile.fara.gov/docs/4866-Exhibit-AB-19931101-D1YGRN02.pdf

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [FARA_All_RegistrantDocs] (
   [Date_Stamped] TEXT,
   [Registrant_Name] TEXT,
   [Registration_Number] INTEGER,
   [Document_Type] TEXT,
   [Short_Form_Name] TEXT,
   [Foreign_Principal_Name] TEXT,
   [Foreign_Principal_Country] TEXT,
   [URL] TEXT,
   FOREIGN KEY([Registration_Number]) REFERENCES [FARA_All_Registrants]([Registration_Number])
);