FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
30 rows where Address_1 = "Ottawa" sorted by Foreign_Principal_Registration_Date
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Termination_Date, Registrant_Date, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date)
Foreign_Principal 27
- Government of Canada 3
- Tourism Canada 2
- Aerospace Industries Association of Canada 1
- Aerospace Industries Association of Canada (AIAC) 1
- Asbestos Institute 1
- Bank of Canada 1
- Brewers' Association of Canada 1
- Canadian Broadcasting Corporation 1
- Canadian Centennial Commission 1
- Canadian Forest Industries Council 1
- Canadian Government Office of Tourism 1
- Canadian Shipowners' Association (formerly: Dominion Marine Association) 1
- Canadian Steel Producers' Association 1
- Eldorado Resources, Ltd. 1
- Embassy of the Federal Republic of Germany 1
- Export Development Corporation (Canada) 1
- External Affairs Department, Government of Canada 1
- Government of Canada (National Film Board) 1
- Government of Canada, Department of External Affairs 1
- Government of Canada, Postmater General, Olympic Coin Program 1
- Grey, Clark, Shih & Associates, Ltd. 1
- Industry Canada 1
- National Film Board of Canada 1
- Peter Clark 1
- Revenue Canada - Customs & Excise 1
- SNA Canada, Inc. 1
- Superintendent of Patents, Office of Assistant Deputy Minister 1
Registrant_Name 24
- CANAMCO 4
- APCO Associates 2
- Hill and Knowlton Strategies, LLC 2
- Strategic Policy, Inc. 2
- Aaron D. Cushman & Associates, Inc. 1
- Arent, Fox, Kintner, Plotkin & Kahn 1
- Dailey & Associates 1
- Daniel J. Edelman, Inc. 1
- Dewey Ballantine 1
- EMB, Ltd. 1
- Edward Gottlieb & Associates, Ltd. 1
- Government Research Corporation 1
- Green, Shirley L. 1
- Groen, Maurice T. 1
- Hansen, Paul W. 1
- Italcambio, Inc. 1
- Larson & Taylor 1
- Marathon International Productions, Inc. 1
- Milbank, Tweed, Hadley & McCloy 1
- North American Precis Syndicate 1
- O'Melveny & Myers 1
- Paul, Hastings, Janofsky & Walker 1
- Romanko, Daniel 1
- Schneider, Jan 1
Registrant_Date (date) 24 ✖
- 1986-09-19 4
- 1981-11-10 2
- 1984-06-20 2
- 1989-01-13 2
- 1946-04-10 1
- 1959-09-15 1
- 1963-05-14 1
- 1964-02-28 1
- 1965-01-11 1
- 1965-04-19 1
- 1965-11-19 1
- 1967-10-31 1
- 1971-12-27 1
- 1973-09-12 1
- 1975-04-07 1
- 1977-10-12 1
- 1981-10-06 1
- 1982-03-12 1
- 1983-08-23 1
- 1985-03-12 1
- 1985-11-27 1
- 1986-08-07 1
- 1988-08-18 1
- 1996-07-17 1
Country/Location_Represented 2
State 1
- - 30
City 1
- - 30
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14855 | 14855 | 1946-12-07 | National Film Board of Canada | 1946-04-10 | CANADA | Groen, Maurice T. 351 | 1946-04-10 | Groen, Maurice T. | Ottawa | ||||
11601 | 11601 | 1962-09-15 | Bank of Canada | 1959-09-15 | CANADA | EMB, Ltd. 1270 | 1959-09-15 | EMB, Ltd. | Ottawa | ||||
11219 | 11219 | 1967-09-01 | Embassy of the Federal Republic of Germany | 1965-02-28 | GERMANY, FEDERAL REPUBLIC OF | Marathon International Productions, Inc. 1695 | 1964-02-28 | Marathon International Productions, Inc. | Ottawa | ||||
14159 | 14159 | 1967-11-22 | Superintendent of Patents, Office of Assistant Deputy Minister | 1965-04-19 | CANADA | Larson & Taylor 1885 | 1965-04-19 | Larson & Taylor | Ottawa | ||||
6662 | 6662 | 1966-05-20 | Government of Canada (National Film Board) | 1965-11-19 | CANADA | Green, Shirley L. 1939 | 1965-11-19 | Green, Shirley L. | Ottawa | ||||
8828 | 8828 | 1967-07-01 | Canadian Broadcasting Corporation | 1966-06-10 | CANADA | Arent, Fox, Kintner, Plotkin & Kahn 1628 | 1963-05-14 | Arent, Fox, Kintner, Plotkin & Kahn | Ottawa | ||||
14331 | 14331 | 1967-11-30 | Canadian Centennial Commission | 1967-10-31 | CANADA | Edward Gottlieb & Associates, Ltd. 2061 | 1967-10-31 | Edward Gottlieb & Associates, Ltd. | Ottawa | ||||
1215 | 1215 | 1988-01-11 | Export Development Corporation (Canada) | 1974-02-20 | CANADA | Milbank, Tweed, Hadley & McCloy 1839 | 1965-01-11 | Milbank, Tweed, Hadley & McCloy | Ottawa | ||||
3656 | 3656 | 1977-03-12 | Government of Canada, Postmater General, Olympic Coin Program | 1974-09-18 | CANADA | Italcambio, Inc. 2460 | 1973-09-12 | Italcambio, Inc. | Ottawa | ||||
15930 | 15930 | 1985-12-31 | Canadian Government Office of Tourism | 1982-05-17 | CANADA | Aaron D. Cushman & Associates, Inc. 2572 | 1975-04-07 | Aaron D. Cushman & Associates, Inc. | Ottawa | ||||
12708 | 12708 | 1986-10-15 | Government of Canada | 1983-08-23 | CANADA | Schneider, Jan 3546 | 1983-08-23 | Schneider, Jan | Ottawa | ||||
3271 | 3271 | 1984-03-01 | Tourism Canada | 1984-10-05 | CANADA | Dailey & Associates 2299 | 1971-12-27 | Dailey & Associates | Ottawa | ||||
7747 | 7747 | 1986-06-11 | Government of Canada, Department of External Affairs | 1985-05-20 | CANADA | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | Ottawa | ||||
15999 | 15999 | 1987-12-31 | Canadian Forest Industries Council | 1985-05-21 | CANADA | APCO Associates 3597 | 1984-06-20 | APCO Associates | Ottawa | ||||
16050 | 16050 | 1988-12-31 | Eldorado Resources, Ltd. | 1985-12-18 | CANADA | APCO Associates 3597 | 1984-06-20 | APCO Associates | Ottawa | ||||
7399 | 7399 | 1987-06-01 | Asbestos Institute | 1986-06-19 | CANADA | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | Ottawa | ||||
15173 | 15173 | 1991-12-16 | Canadian Steel Producers' Association | 1986-08-07 | CANADA | Romanko, Daniel 3866 | 1986-08-07 | Romanko, Daniel | Ottawa | ||||
1794 | 1794 | 1996-01-31 | Canadian Shipowners' Association (formerly: Dominion Marine Association) | 1986-09-19 | CANADA | CANAMCO 3884 | 1986-09-19 | CANAMCO | Ottawa | ||||
12028 | 12028 | 1990-09-30 | Tourism Canada | 1986-12-02 | CANADA | Daniel J. Edelman, Inc. 3657 | 1985-03-12 | Daniel J. Edelman, Inc. | Ottawa | ||||
10017 | 10017 | 1991-08-01 | Government of Canada | 1987-10-19 | CANADA | O'Melveny & Myers 3346 | 1982-03-12 | O'Melveny & Myers | Ottawa | ||||
14773 | 14773 | 1993-12-03 | Aerospace Industries Association of Canada | 1987-11-02 | CANADA | CANAMCO 3884 | 1986-09-19 | CANAMCO | Ottawa | ||||
6973 | 6973 | 1989-05-30 | SNA Canada, Inc. | 1988-08-18 | CANADA | Government Research Corporation 4170 | 1988-08-18 | Government Research Corporation | Ottawa | ||||
4066 | 4066 | 1991-03-26 | External Affairs Department, Government of Canada | 1988-11-04 | CANADA | Hansen, Paul W. 3282 | 1981-10-06 | Hansen, Paul W. | Ottawa | ||||
9223 | 9223 | 1996-07-13 | Grey, Clark, Shih & Associates, Ltd. | 1989-01-13 | CANADA | Strategic Policy, Inc. 4206 | 1989-01-13 | Strategic Policy, Inc. | Ottawa | ||||
13024 | 13024 | 1989-10-25 | Revenue Canada - Customs & Excise | 1989-08-08 | CANADA | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | Ottawa | ||||
1450 | 1450 | 1994-01-21 | Peter Clark | 1992-02-11 | CANADA | Dewey Ballantine 3759 | 1985-11-27 | Dewey Ballantine | Ottawa | ||||
9222 | 9222 | 1996-07-13 | Brewers' Association of Canada | 1994-02-10 | CANADA | Strategic Policy, Inc. 4206 | 1989-01-13 | Strategic Policy, Inc. | Ottawa | ||||
1795 | 1795 | 1996-01-31 | Aerospace Industries Association of Canada (AIAC) | 1994-07-20 | CANADA | CANAMCO 3884 | 1986-09-19 | CANAMCO | Ottawa | ||||
7434 | 7434 | 2001-06-01 | Government of Canada | 1996-07-17 | CANADA | Paul, Hastings, Janofsky & Walker 5121 | 1996-07-17 | Paul, Hastings, Janofsky & Walker | Ottawa | ||||
16391 | 16391 | 1996-12-31 | Industry Canada | 1996-07-23 | CANADA | CANAMCO 3884 | 1986-09-19 | CANAMCO | Ottawa |
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]) );