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

17 rows where Foreign_Principal = "Government of Canada"

Search:

descending

Link	rowid ▼	Foreign_Principal_Termination_Date	Foreign_Principal	Foreign_Principal_Registration_Date	Country/Location_Represented	Registration_Number	Registrant_Date	Registrant_Name	Address_1	State
2704	2704	1988-02-26	Government of Canada	1986-08-11	CANADA	3862 3862	1986-07-25	Campaign Planning, Inc.
3905	3905	1988-03-28	Government of Canada	1988-02-18	CANADA	3301 3301	1981-11-10	Hill and Knowlton Strategies, LLC
4249	4249	1989-03-31	Government of Canada	1987-11-13	CANADA	3597 3597	1984-06-20	APCO Associates	Washington	DC
4662	4662	1987-04-01	Government of Canada	1986-03-12	CANADA	3795 3795	1986-03-12	Market Opinion Research
4844	4844	1994-04-08	Government of Canada	1993-04-29	CANADA	3567 3567	1984-03-22	Preston, Gates & Ellis, L.L.P.	Ottawa, Ontario
5684	5684	1998-04-30	Government of Canada	1987-03-23	CANADA	3626 3626	1984-10-31	Miller & Chevalier, Chartered
5910	5910	1991-05-01	Government of Canada	1989-12-04	CANADA	2216 2216	1970-10-30	Berry, Max N.	Washington	DC
6373	6373	1993-05-21	Government of Canada	1992-09-03	CANADA	4561 4561	1991-09-03	APCO Worldwide, Inc.	Washington	DC
6776	6776	1991-05-31	Government of Canada	1991-02-08	CANADA	3567 3567	1984-03-22	Preston, Gates & Ellis, L.L.P.	Washington	DC
7088	7088	2001-06-01	Government of Canada	1996-07-17	CANADA	5121 5121	1996-07-17	Paul, Hastings, Janofsky & Walker	Ottawa
7462	7462	1985-06-15	Government of Canada	1984-02-07	CANADA	3492 3492	1983-06-24	Akin, Gump, Strauss, Hauer & Feld, LLP
8581	8581	1968-07-03	Government of Canada	1962-06-19	CANADA	523 523	1948-04-16	Covington & Burling	Washington	DC
9589	9589	1991-08-01	Government of Canada	1987-10-19	CANADA	3346 3346	1982-03-12	O'Melveny & Myers	Ottawa
12157	12157	1986-10-15	Government of Canada	1983-08-23	CANADA	3546 3546	1983-08-23	Schneider, Jan	Ottawa
12520	12520	1994-10-27	Government of Canada	1989-11-03	CANADA	3743 3743	1985-10-02	Coudert Brothers	Washington	DC
14681	14681	1993-12-22	Government of Canada	1987-07-09	CANADA	1750 1750	1964-06-04	Arnold & Porter Kaye Scholer, LLP
14805	14805	1994-12-29	Government of Canada	1991-09-27	CANADA	3317 3317	1981-12-29	Weil, Gotshal & Manges, L.L.P.	Ottawa, Ontario

Advanced export

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)
);