FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
14 rows where Registrant_Name = "Hamel, Park, McCabe & Saunders" sorted by Registrant_Date
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Termination_Date, Foreign_Principal_Registration_Date, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date)
Foreign_Principal 14
- Americana, Azucarera Tropical 1
- Azucarera Nacional, S.A. Compania Azucarera Le Estrella, S.A. 1
- Belize Sugar Industries, Ltd. 1
- Compania Azucarera Tababuela 1
- Compania Azucarera Valdez, S.A. 1
- Government of Barbados 1
- Government of Republic of Panama 1
- Joseph Muller Corporation Zurich 1
- Redpath Sugars 1
- Ronda, S.A. 1
- Sociedad Agricola Industrial 1
- Tate & Lyle, Ltd. 1
- Vaisala Oy 1
- West Indies Sugar Association, Inc. 1
Country/Location_Represented 8
- ECUADOR 4
- BARBADOS 2
- PANAMA 2
- SWITZERLAND 2
- BELIZE 1
- CANADA 1
- FINLAND 1
- GREAT BRITAIN 1
State 1
- - 14
Registrant_Name 1
- Hamel, Park, McCabe & Saunders · 14 ✖
Registrant_Date (date) 1 ✖
- 1961-02-07 14
City 1
- - 14
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2545 | 2545 | 1978-02-15 | Americana, Azucarera Tropical | 1971-04-14 | ECUADOR | Hamel, Park, McCabe & Saunders 1425 | 1961-02-07 | Hamel, Park, McCabe & Saunders | |||||
2546 | 2546 | 1978-02-15 | Compania Azucarera Tababuela | 1971-04-14 | ECUADOR | Hamel, Park, McCabe & Saunders 1425 | 1961-02-07 | Hamel, Park, McCabe & Saunders | |||||
2547 | 2547 | 1978-02-15 | Compania Azucarera Valdez, S.A. | 1961-02-07 | ECUADOR | Hamel, Park, McCabe & Saunders 1425 | 1961-02-07 | Hamel, Park, McCabe & Saunders | |||||
2548 | 2548 | 1978-02-15 | Sociedad Agricola Industrial | 1966-10-03 | ECUADOR | Hamel, Park, McCabe & Saunders 1425 | 1961-02-07 | Hamel, Park, McCabe & Saunders | |||||
2933 | 2933 | 1983-02-28 | Government of Barbados | 1970-08-20 | BARBADOS | Hamel, Park, McCabe & Saunders 1425 | 1961-02-07 | Hamel, Park, McCabe & Saunders | |||||
2938 | 2938 | 1983-02-28 | Tate & Lyle, Ltd. | 1969-05-05 | GREAT BRITAIN | Hamel, Park, McCabe & Saunders 1425 | 1961-02-07 | Hamel, Park, McCabe & Saunders | |||||
2940 | 2940 | 1983-02-28 | Vaisala Oy | 1980-09-17 | FINLAND | Hamel, Park, McCabe & Saunders 1425 | 1961-02-07 | Hamel, Park, McCabe & Saunders | |||||
9983 | 9983 | 1981-08-01 | Azucarera Nacional, S.A. Compania Azucarera Le Estrella, S.A. | 1965-03-10 | PANAMA | Hamel, Park, McCabe & Saunders 1425 | 1961-02-07 | Hamel, Park, McCabe & Saunders | |||||
9984 | 9984 | 1981-08-01 | Belize Sugar Industries, Ltd. | 1967-02-16 | BELIZE | Hamel, Park, McCabe & Saunders 1425 | 1961-02-07 | Hamel, Park, McCabe & Saunders | |||||
9985 | 9985 | 1981-08-01 | Government of Republic of Panama | 1971-04-14 | PANAMA | Hamel, Park, McCabe & Saunders 1425 | 1961-02-07 | Hamel, Park, McCabe & Saunders | |||||
9987 | 9987 | 1981-08-01 | West Indies Sugar Association, Inc. | 1961-02-07 | BARBADOS | Hamel, Park, McCabe & Saunders 1425 | 1961-02-07 | Hamel, Park, McCabe & Saunders | |||||
11237 | 11237 | 1981-09-01 | Redpath Sugars | 1981-04-08 | CANADA | Hamel, Park, McCabe & Saunders 1425 | 1961-02-07 | Hamel, Park, McCabe & Saunders | |||||
12327 | 12327 | 1977-10-01 | Ronda, S.A. | 1977-09-08 | SWITZERLAND | Hamel, Park, McCabe & Saunders 1425 | 1961-02-07 | Hamel, Park, McCabe & Saunders | |||||
15349 | 15349 | 1982-12-23 | Joseph Muller Corporation Zurich | 1982-08-19 | SWITZERLAND | Hamel, Park, McCabe & Saunders 1425 | 1961-02-07 | Hamel, Park, McCabe & Saunders |
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]) );