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

8 rows where Country/Location_Represented = "CANADA" and Foreign_Principal = "Grand Council of the Crees (of Quebec)"

✎ View and edit SQL

This data as json, CSV (advanced)

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

State 1

  • - 8

Foreign_Principal 1

  • Grand Council of the Crees (of 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
936 936 1991-01-01 Grand Council of the Crees (of Quebec) 1989-06-16 CANADA Pierson, Semmes & Bemis 2988 1979-01-17 Pierson, Semmes & Bemis Quebec        
5518 5518 1992-04-24 Grand Council of the Crees (of Quebec) 1991-09-17 CANADA Alsop, Denny 4565 1991-09-17 Alsop, Denny Ontario        
6214 6214 1994-05-01 Grand Council of the Crees (of Quebec) 1991-04-25 CANADA Goodman Group, Ltd. 4505 1991-04-25 Goodman Group, Ltd. Ottawa, Ontario        
8623 8623 2002-06-30 Grand Council of the Crees (of Quebec) 1989-06-19 CANADA Law Office of James A. Dumont, P.C. 4265 1989-06-19 Law Office of James A. Dumont, P.C. Ottawa, Ontario        
9801 9801 1993-07-31 Grand Council of the Crees (of Quebec) 1991-07-25 CANADA E Cubed Company, Inc. (The E3 Company) 4547 1991-07-25 E Cubed Company, Inc. (The E3 Company) Ottawa, Ontario        
10141 10141 1992-08-05 Grand Council of the Crees (of Quebec) 1992-03-19 CANADA Malkin & Ross 4636 1992-03-19 Malkin & Ross Ontario        
12040 12040 1992-09-30 Grand Council of the Crees (of Quebec) 1992-03-17 CANADA PROTECT (Prudent Residents Opposed Elec. Cable Transmission) 4633 1992-03-17 PROTECT (Prudent Residents Opposed Elec. Cable Transmission) Ontario        
13359 13359 1996-10-31 Grand Council of the Crees (of Quebec) 1992-03-13 CANADA Stewart, Ann Haslam 4632 1992-03-13 Stewart, Ann Haslam 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])
);