FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
7 rows where Registrant_Name = "Baker & McKenzie" sorted by Country/Location_Represented
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 7
- British Columbia (Province of) 1
- Canadian Forest Industries Council 1
- Munchener Ruckuersicherungs - Gesellschaft 1
- Textile Garment Manufacturers' Association of Uruguay 1
- The Government of the Democratic Republic of Congo 1
- Trizec-Hahn Corporation (formerly: Horsham Corporation) 1
- Zurich Insurance Company 1
Country/Location_Represented 5
Registrant_Date (date) 3 ✖
- 1991-11-12 5
- 1984-04-17 1
- 2020-05-08 1
State 1
- - 7
Registrant_Name 1
- Baker & McKenzie · 7 ✖
City 1
- - 7
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8541 | 8541 | 1996-06-30 | Canadian Forest Industries Council | 1994-04-18 | CANADA | Baker & McKenzie 4591 | 1991-11-12 | Baker & McKenzie | Vancouver, B.C. | ||||
8577 | 8577 | 1998-06-30 | Trizec-Hahn Corporation (formerly: Horsham Corporation) | 1991-11-12 | CANADA | Baker & McKenzie 4591 | 1991-11-12 | Baker & McKenzie | Toronto, Ontario | ||||
12085 | 12085 | 1997-09-30 | British Columbia (Province of) | 1997-06-20 | CANADA | Baker & McKenzie 4591 | 1991-11-12 | Baker & McKenzie | Victoria, BC | ||||
693 | 693 | The Government of the Democratic Republic of Congo | 2020-05-08 | CONGO, DEMOCRATIC REPUBLIC OF THE | Baker & McKenzie 6821 | 2020-05-08 | Baker & McKenzie | Kinshasa | |||||
8898 | 8898 | 1993-07-01 | Munchener Ruckuersicherungs - Gesellschaft | 1992-12-18 | GERMANY | Baker & McKenzie 4591 | 1991-11-12 | Baker & McKenzie | Munich | ||||
8899 | 8899 | 1993-07-01 | Zurich Insurance Company | 1992-12-18 | SWITZERLAND | Baker & McKenzie 4591 | 1991-11-12 | Baker & McKenzie | Zurich | ||||
12703 | 12703 | 1985-10-15 | Textile Garment Manufacturers' Association of Uruguay | 1984-04-17 | URUGUAY | Baker & McKenzie 3574 | 1984-04-17 | Baker & McKenzie |
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]) );