FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
20 rows where Address_1 = "Alberta" sorted by Zip
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Termination_Date, Foreign_Principal_Registration_Date, Registration_Number, Registrant_Date, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date)
Foreign_Principal 19
- Husky Oil, Ltd. 2
- Alberta Gas Trunk Line (Canada), Ltd. (AGTL (Canada)) 1
- Alberta Gas Trunk Line Company, Ltd. 1
- Alberta Ministry of Economic Development & Tourism (formerly Department of Federal and Intergovernmental Affairs) 1
- Department of Industry & Development, Government of the Province of Alberta, Canada 1
- Foothills Pipe Lines (Yukon), Ltd. 1
- Foothills Pipe Lines (Yukon), Ltd. (Foothills Yukon) 1
- Foothills Pipe Lines, Ltd. 1
- Foothills Pipe Lines, Ltd. (Foothills) 1
- Government of Alberta 1
- Government of Alberta, Canada 1
- Government of the Province of Alberta 1
- NOVA, an Alberta Corporation 1
- Nova, Corporation of Alberta 1
- Novacor Chemicals 1
- Novacor Chemicals, Ltd. 1
- Pan-Alberta Gas, Ltd. 1
- Province of Alberta, Canada, Department of Business Development & Tourism 1
- West Fraser Pulp (formerly: AEC Forest Products) 1
Registrant_Name 11
- McHenry & Staffier 4
- McHenry & Staffier, P.C. 4
- Wexler, Reynolds, Fuller, Harrison & Schule, Inc. 4
- APCO Worldwide, Inc. 1
- Bernie Klein Technical Advertising, Inc. 1
- Duncan, Weinberg, Palmer & Miller, P.C. 1
- Government of the Province of Alberta 1
- Hill and Knowlton Strategies, LLC 1
- Kearns International 1
- Office of the Government of Alberta 1
- Smith McCabe, Ltd. 1
Registrant_Date (date) 11 ✖
- 1977-06-30 4
- 1981-11-16 4
- 1981-11-20 4
- 1964-04-30 1
- 1964-05-19 1
- 1974-10-24 1
- 1977-03-24 1
- 1981-11-10 1
- 1983-04-20 1
- 1991-09-03 1
- 1992-06-26 1
State 1
- - 20
Country/Location_Represented 1
- CANADA 20
City 1
- - 20
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 ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1559 | 1559 | 1993-01-27 | Government of Alberta, Canada | 1992-09-08 | CANADA | Smith McCabe, Ltd. 4687 | 1992-06-26 | Smith McCabe, Ltd. | Alberta | ||||
4554 | 4554 | 1996-03-31 | West Fraser Pulp (formerly: AEC Forest Products) | 1992-09-04 | CANADA | APCO Worldwide, Inc. 4561 | 1991-09-03 | APCO Worldwide, Inc. | Alberta | ||||
4847 | 4847 | 1965-04-01 | Department of Industry & Development, Government of the Province of Alberta, Canada | 1964-05-19 | CANADA | Bernie Klein Technical Advertising, Inc. 1737 | 1964-05-19 | Bernie Klein Technical Advertising, Inc. | Alberta | ||||
6320 | 6320 | 1984-05-04 | Husky Oil, Ltd. | 1984-04-03 | CANADA | Wexler, Reynolds, Fuller, Harrison & Schule, Inc. 3306 | 1981-11-20 | Wexler, Reynolds, Fuller, Harrison & Schule, Inc. | Alberta | ||||
7056 | 7056 | 1984-05-31 | Husky Oil, Ltd. | 1984-03-21 | CANADA | McHenry & Staffier, P.C. 3304 | 1981-11-16 | McHenry & Staffier, P.C. | Alberta | ||||
9759 | 9759 | 1989-07-31 | Government of Alberta | 1989-05-31 | CANADA | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | Alberta | ||||
10009 | 10009 | 1990-08-01 | Foothills Pipe Lines (Yukon), Ltd. | 1981-11-20 | CANADA | Wexler, Reynolds, Fuller, Harrison & Schule, Inc. 3306 | 1981-11-20 | Wexler, Reynolds, Fuller, Harrison & Schule, Inc. | Alberta | ||||
10011 | 10011 | 1990-08-01 | NOVA, an Alberta Corporation | 1984-08-17 | CANADA | Wexler, Reynolds, Fuller, Harrison & Schule, Inc. 3306 | 1981-11-20 | Wexler, Reynolds, Fuller, Harrison & Schule, Inc. | Alberta | ||||
10012 | 10012 | 1990-08-01 | Novacor Chemicals, Ltd. | 1984-08-17 | CANADA | Wexler, Reynolds, Fuller, Harrison & Schule, Inc. 3306 | 1981-11-20 | Wexler, Reynolds, Fuller, Harrison & Schule, Inc. | Alberta | ||||
10124 | 10124 | 1978-08-04 | Alberta Gas Trunk Line (Canada), Ltd. (AGTL (Canada)) | 1977-06-30 | CANADA | McHenry & Staffier 2803 | 1977-06-30 | McHenry & Staffier | Alberta | ||||
10125 | 10125 | 1978-08-04 | Alberta Gas Trunk Line Company, Ltd. | 1977-06-30 | CANADA | McHenry & Staffier 2803 | 1977-06-30 | McHenry & Staffier | Alberta | ||||
10127 | 10127 | 1978-08-04 | Foothills Pipe Lines (Yukon), Ltd. (Foothills Yukon) | 1977-06-30 | CANADA | McHenry & Staffier 2803 | 1977-06-30 | McHenry & Staffier | Alberta | ||||
10128 | 10128 | 1978-08-04 | Foothills Pipe Lines, Ltd. (Foothills) | 1977-06-30 | CANADA | McHenry & Staffier 2803 | 1977-06-30 | McHenry & Staffier | Alberta | ||||
10279 | 10279 | 1994-08-11 | Pan-Alberta Gas, Ltd. | 1983-06-17 | CANADA | McHenry & Staffier, P.C. 3304 | 1981-11-16 | McHenry & Staffier, P.C. | Alberta | ||||
12951 | 12951 | 1975-10-23 | Province of Alberta, Canada, Department of Business Development & Tourism | 1975-10-30 | CANADA | Kearns International 2542 | 1974-10-24 | Kearns International | Alberta | ||||
14660 | 14660 | 1979-12-01 | Foothills Pipe Lines, Ltd. | 1977-03-24 | CANADA | Duncan, Weinberg, Palmer & Miller, P.C. 2763 | 1977-03-24 | Duncan, Weinberg, Palmer & Miller, P.C. | Alberta | ||||
14980 | 14980 | 1993-12-10 | Nova, Corporation of Alberta | 1984-08-11 | CANADA | McHenry & Staffier, P.C. 3304 | 1981-11-16 | McHenry & Staffier, P.C. | Alberta | ||||
14981 | 14981 | 1993-12-10 | Novacor Chemicals | 1984-08-11 | CANADA | McHenry & Staffier, P.C. 3304 | 1981-11-16 | McHenry & Staffier, P.C. | Alberta | ||||
15141 | 15141 | 1995-12-15 | Alberta Ministry of Economic Development & Tourism (formerly Department of Federal and Intergovernmental Affairs) | 1983-04-20 | CANADA | Office of the Government of Alberta 3459 | 1983-04-20 | Office of the Government of Alberta | Alberta | ||||
15314 | 15314 | 1992-12-22 | Government of the Province of Alberta | 1964-04-30 | CANADA | Government of the Province of Alberta 1720 | 1964-04-30 | Government of the Province of Alberta | Alberta |
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]) );