FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
12 rows where Foreign_Principal_Registration_Date = "1959-09-15" and Registrant_Name = "EMB, Ltd."
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Termination_Date, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Foreign_Principal 12
Country/Location_Represented 12
- AUSTRALIA 1
- BRAZIL 1
- CANADA 1
- CHILE 1
- CUBA 1
- FRANCE 1
- GREECE 1
- ISRAEL 1
- ITALY 1
- NETHERLANDS 1
- PHILIPPINES 1
- SOUTH AFRICA 1
State 1
- - 12
Registrant_Name 1
- EMB, Ltd. · 12 ✖
City 1
- - 12
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11601 | 11601 | 1962-09-15 | Bank of Canada | 1959-09-15 | CANADA | EMB, Ltd. 1270 | 1959-09-15 | EMB, Ltd. | Ottawa | ||||
11602 | 11602 | 1962-09-15 | Bank of France | 1959-09-15 | FRANCE | EMB, Ltd. 1270 | 1959-09-15 | EMB, Ltd. | Paris | ||||
11603 | 11603 | 1962-09-15 | Bank of Greece | 1959-09-15 | GREECE | EMB, Ltd. 1270 | 1959-09-15 | EMB, Ltd. | Athens | ||||
11604 | 11604 | 1962-09-15 | Bank of Israel | 1959-09-15 | ISRAEL | EMB, Ltd. 1270 | 1959-09-15 | EMB, Ltd. | Jerusalem | ||||
11605 | 11605 | 1962-09-15 | Bank of Italy | 1959-09-15 | ITALY | EMB, Ltd. 1270 | 1959-09-15 | EMB, Ltd. | Rome | ||||
11609 | 11609 | 1962-09-15 | Central Bank of the Philippines | 1959-09-15 | PHILIPPINES | EMB, Ltd. 1270 | 1959-09-15 | EMB, Ltd. | Manila | ||||
11610 | 11610 | 1962-09-15 | Commonwealth Bank of Australia | 1959-09-15 | AUSTRALIA | EMB, Ltd. 1270 | 1959-09-15 | EMB, Ltd. | Sydney | ||||
11613 | 11613 | 1962-09-15 | Development Bank of Brazil | 1959-09-15 | BRAZIL | EMB, Ltd. 1270 | 1959-09-15 | EMB, Ltd. | Rio de Janeiro | ||||
11614 | 11614 | 1962-09-15 | Netherlands Bank | 1959-09-15 | NETHERLANDS | EMB, Ltd. 1270 | 1959-09-15 | EMB, Ltd. | Amsterdam | ||||
11616 | 11616 | 1962-09-15 | Reserve Bank of South Africa | 1959-09-15 | SOUTH AFRICA | EMB, Ltd. 1270 | 1959-09-15 | EMB, Ltd. | Pretoria | ||||
15591 | 15591 | 1959-12-31 | Central Bank of Chile | 1959-09-15 | CHILE | EMB, Ltd. 1270 | 1959-09-15 | EMB, Ltd. | Santiago | ||||
15593 | 15593 | 1959-12-31 | National Bank of Cuba | 1959-09-15 | CUBA | EMB, Ltd. 1270 | 1959-09-15 | EMB, Ltd. | Havana |
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]) );