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
2702	2702	1988-02-26	Government of Canada	1986-08-11	CANADA	3862 3862	1986-07-25	Campaign Planning, Inc.
3892	3892	1988-03-28	Government of Canada	1988-02-18	CANADA	3301 3301	1981-11-10	Hill and Knowlton Strategies, LLC
4233	4233	1989-03-31	Government of Canada	1987-11-13	CANADA	3597 3597	1984-06-20	APCO Associates	Washington	DC
4638	4638	1987-04-01	Government of Canada	1986-03-12	CANADA	3795 3795	1986-03-12	Market Opinion Research
4815	4815	1994-04-08	Government of Canada	1993-04-29	CANADA	3567 3567	1984-03-22	Preston, Gates & Ellis, L.L.P.	Ottawa, Ontario
5648	5648	1998-04-30	Government of Canada	1987-03-23	CANADA	3626 3626	1984-10-31	Miller & Chevalier, Chartered
5872	5872	1991-05-01	Government of Canada	1989-12-04	CANADA	2216 2216	1970-10-30	Berry, Max N.	Washington	DC
6333	6333	1993-05-21	Government of Canada	1992-09-03	CANADA	4561 4561	1991-09-03	APCO Worldwide, Inc.	Washington	DC
6733	6733	1991-05-31	Government of Canada	1991-02-08	CANADA	3567 3567	1984-03-22	Preston, Gates & Ellis, L.L.P.	Washington	DC
7045	7045	2001-06-01	Government of Canada	1996-07-17	CANADA	5121 5121	1996-07-17	Paul, Hastings, Janofsky & Walker	Ottawa
7412	7412	1985-06-15	Government of Canada	1984-02-07	CANADA	3492 3492	1983-06-24	Akin, Gump, Strauss, Hauer & Feld, LLP
8523	8523	1968-07-03	Government of Canada	1962-06-19	CANADA	523 523	1948-04-16	Covington & Burling	Washington	DC
9521	9521	1991-08-01	Government of Canada	1987-10-19	CANADA	3346 3346	1982-03-12	O'Melveny & Myers	Ottawa
12072	12072	1986-10-15	Government of Canada	1983-08-23	CANADA	3546 3546	1983-08-23	Schneider, Jan	Ottawa
12431	12431	1994-10-27	Government of Canada	1989-11-03	CANADA	3743 3743	1985-10-02	Coudert Brothers	Washington	DC
14569	14569	1993-12-22	Government of Canada	1987-07-09	CANADA	1750 1750	1964-06-04	Arnold & Porter Kaye Scholer, LLP
14692	14692	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)
);