FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
16 rows where Address_1 = "Vancouver" and Country/Location_Represented = "CANADA"
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Termination_Date, Registration_Number, Registrant_Date, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Registrant_Name 13
- Etchison, Don L. 2
- Hill & Knowlton, Inc. 2
- Winston & Strawn 2
- Cooper, Mitchell J. 1
- David Apter & Associates 1
- Derus Media Service, Inc. 1
- Fierst, Herbert A. 1
- Hill and Knowlton Strategies, LLC 1
- McHenry & Staffier 1
- Nossaman, Guthner, Knox & Elliott 1
- Piper & Marbury 1
- R. Duffy Wall & Associates, Inc. 1
- Ryan, Askren & Mathewson 1
Foreign_Principal 11
- Canadian Forest Industries Council 4
- Cominco, Ltd. 2
- Council of Forest Industries of British Columbia 2
- British Columbia Hydro & Power Authority 1
- Business Council of British Columbia 1
- Canadian Softwood Lumber Committee 1
- Consolidated Red Cedar Shingle Association 1
- Contemporary Communications, Ltd. 1
- Council of the Forest Industries of British Columbia 1
- Ministry of Energy 1
- Westcoast Transmission Company, Ltd. (Westcoast) 1
State 1
- - 16
Country/Location_Represented 1
- CANADA · 16 ✖
City 1
- - 16
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2612 | 2612 | 1943-02-17 | Consolidated Red Cedar Shingle Association | 1942-08-17 | CANADA | Ryan, Askren & Mathewson 99 | 1942-08-17 | Ryan, Askren & Mathewson | Vancouver | ||||
4123 | 4123 | 1995-03-28 | Cominco, Ltd. | 1994-07-22 | CANADA | R. Duffy Wall & Associates, Inc. 3737 | 1985-09-25 | R. Duffy Wall & Associates, Inc. | Vancouver | ||||
4160 | 4160 | 1985-03-30 | Council of Forest Industries of British Columbia | 1963-04-05 | CANADA | Cooper, Mitchell J. 1615 | 1963-04-05 | Cooper, Mitchell J. | Vancouver | ||||
4441 | 4441 | 1988-03-31 | British Columbia Hydro & Power Authority | 1987-09-29 | CANADA | Nossaman, Guthner, Knox & Elliott 4046 | 1987-09-29 | Nossaman, Guthner, Knox & Elliott | Vancouver | ||||
4913 | 4913 | 1988-04-01 | Contemporary Communications, Ltd. | 1986-03-19 | CANADA | Derus Media Service, Inc. 3799 | 1986-03-19 | Derus Media Service, Inc. | Vancouver | ||||
5244 | 5244 | 1989-04-13 | Canadian Forest Industries Council | 1986-08-13 | CANADA | Winston & Strawn 3869 | 1986-08-13 | Winston & Strawn | Vancouver | ||||
5851 | 5851 | 1990-04-30 | Cominco, Ltd. | 1988-03-29 | CANADA | Piper & Marbury 4111 | 1988-03-29 | Piper & Marbury | Vancouver | ||||
6765 | 6765 | 1983-05-24 | Canadian Softwood Lumber Committee | 1983-02-24 | CANADA | Hill & Knowlton, Inc. 2740 | 1976-12-17 | Hill & Knowlton, Inc. | Vancouver | ||||
10129 | 10129 | 1978-08-04 | Westcoast Transmission Company, Ltd. (Westcoast) | 1977-06-30 | CANADA | McHenry & Staffier 2803 | 1977-06-30 | McHenry & Staffier | Vancouver | ||||
11565 | 11565 | 1993-09-13 | Canadian Forest Industries Council | 1989-03-10 | CANADA | Winston & Strawn 3869 | 1986-08-13 | Winston & Strawn | Vancouver | ||||
11981 | 11981 | 1987-09-30 | Council of Forest Industries of British Columbia | 1963-01-10 | CANADA | Fierst, Herbert A. 1590 | 1963-01-10 | Fierst, Herbert A. | Vancouver | ||||
12925 | 12925 | 1986-10-22 | Canadian Forest Industries Council | 1985-04-25 | CANADA | Hill & Knowlton, Inc. 2740 | 1976-12-17 | Hill & Knowlton, Inc. | Vancouver | ||||
14696 | 14696 | 1991-12-01 | Business Council of British Columbia | 1988-12-07 | CANADA | Etchison, Don L. 4193 | 1988-12-07 | Etchison, Don L. | Vancouver | ||||
14697 | 14697 | 1991-12-01 | Ministry of Energy | 1989-07-06 | CANADA | Etchison, Don L. 4193 | 1988-12-07 | Etchison, Don L. | Vancouver | ||||
15640 | 15640 | 1965-12-31 | Council of the Forest Industries of British Columbia | 1964-02-13 | CANADA | David Apter & Associates 1690 | 1964-02-13 | David Apter & Associates | Vancouver | ||||
15954 | 15954 | 1986-12-31 | Canadian Forest Industries Council | 1987-08-24 | CANADA | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | Vancouver |
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]) );