FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
17 rows where Foreign_Principal = "Government of Canada"
This data as json, CSV (advanced)
Suggested facets: Registration_Number, Registrant_Date, Address_1, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Registrant_Name
- Preston, Gates & Ellis, L.L.P. 2
- APCO Associates 1
- APCO Worldwide, Inc. 1
- Akin, Gump, Strauss, Hauer & Feld, LLP 1
- Arnold & Porter Kaye Scholer, LLP 1
- Berry, Max N. 1
- Campaign Planning, Inc. 1
- Coudert Brothers 1
- Covington & Burling 1
- Hill and Knowlton Strategies, LLC 1
- Market Opinion Research 1
- Miller & Chevalier, Chartered 1
- O'Melveny & Myers 1
- Paul, Hastings, Janofsky & Walker 1
- Schneider, Jan 1
- Weil, Gotshal & Manges, L.L.P. 1
Foreign_Principal
- Government of Canada · 17 ✖
Country/Location_Represented
- CANADA 17
City
- - 17
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2704 | 2704 | 1988-02-26 | Government of Canada | 1986-08-11 | CANADA | 3862 3862 | 1986-07-25 | Campaign Planning, Inc. | |||||
3910 | 3910 | 1988-03-28 | Government of Canada | 1988-02-18 | CANADA | 3301 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | |||||
4254 | 4254 | 1989-03-31 | Government of Canada | 1987-11-13 | CANADA | 3597 3597 | 1984-06-20 | APCO Associates | Washington | DC | |||
4668 | 4668 | 1987-04-01 | Government of Canada | 1986-03-12 | CANADA | 3795 3795 | 1986-03-12 | Market Opinion Research | |||||
4856 | 4856 | 1994-04-08 | Government of Canada | 1993-04-29 | CANADA | 3567 3567 | 1984-03-22 | Preston, Gates & Ellis, L.L.P. | Ottawa, Ontario | ||||
5696 | 5696 | 1998-04-30 | Government of Canada | 1987-03-23 | CANADA | 3626 3626 | 1984-10-31 | Miller & Chevalier, Chartered | |||||
5926 | 5926 | 1991-05-01 | Government of Canada | 1989-12-04 | CANADA | 2216 2216 | 1970-10-30 | Berry, Max N. | Washington | DC | |||
6392 | 6392 | 1993-05-21 | Government of Canada | 1992-09-03 | CANADA | 4561 4561 | 1991-09-03 | APCO Worldwide, Inc. | Washington | DC | |||
6796 | 6796 | 1991-05-31 | Government of Canada | 1991-02-08 | CANADA | 3567 3567 | 1984-03-22 | Preston, Gates & Ellis, L.L.P. | Washington | DC | |||
7109 | 7109 | 2001-06-01 | Government of Canada | 1996-07-17 | CANADA | 5121 5121 | 1996-07-17 | Paul, Hastings, Janofsky & Walker | Ottawa | ||||
7486 | 7486 | 1985-06-15 | Government of Canada | 1984-02-07 | CANADA | 3492 3492 | 1983-06-24 | Akin, Gump, Strauss, Hauer & Feld, LLP | |||||
8609 | 8609 | 1968-07-03 | Government of Canada | 1962-06-19 | CANADA | 523 523 | 1948-04-16 | Covington & Burling | Washington | DC | |||
9624 | 9624 | 1991-08-01 | Government of Canada | 1987-10-19 | CANADA | 3346 3346 | 1982-03-12 | O'Melveny & Myers | Ottawa | ||||
12221 | 12221 | 1986-10-15 | Government of Canada | 1983-08-23 | CANADA | 3546 3546 | 1983-08-23 | Schneider, Jan | Ottawa | ||||
12587 | 12587 | 1994-10-27 | Government of Canada | 1989-11-03 | CANADA | 3743 3743 | 1985-10-02 | Coudert Brothers | Washington | DC | |||
14768 | 14768 | 1993-12-22 | Government of Canada | 1987-07-09 | CANADA | 1750 1750 | 1964-06-04 | Arnold & Porter Kaye Scholer, LLP | |||||
14892 | 14892 | 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) );