FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
15 rows where "Foreign_Principal_Registration_Date" is on date 1959-09-15 sorted by Address_1
This data as json, CSV (advanced)
Suggested facets: Registration_Number, Registrant_Date, Address_1
Foreign_Principal 15
- Bank of Canada 1
- Bank of France 1
- Bank of Greece 1
- Bank of Israel 1
- Bank of Italy 1
- Central Bank of Chile 1
- Central Bank of the Philippines 1
- Commonwealth Bank of Australia 1
- Development Bank of Brazil 1
- Government of Italy 1
- Japan Export Trade Promotion Agency (JETRO) 1
- National Bank of Cuba 1
- Netherlands Bank 1
- Nord-Aviation, S.A. 1
- Reserve Bank of South Africa 1
Country/Location_Represented 13
- FRANCE 2
- ITALY 2
- AUSTRALIA 1
- BRAZIL 1
- CANADA 1
- CHILE 1
- CUBA 1
- GREECE 1
- ISRAEL 1
- JAPAN 1
- NETHERLANDS 1
- PHILIPPINES 1
- SOUTH AFRICA 1
Registrant_Name 4
Registrant_Date (date) 3 ✖
- 1959-09-15 13
- 1954-01-21 1
- 1955-09-08 1
State 1
- - 15
City 1
- - 15
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1975 | 1975 | 1967-02-01 | Government of Italy | 1959-09-15 | ITALY | Boykin & De Francis 812 | 1954-01-21 | Boykin & De Francis | |||||
11614 | 11614 | 1962-09-15 | Netherlands Bank | 1959-09-15 | NETHERLANDS | EMB, Ltd. 1270 | 1959-09-15 | EMB, Ltd. | Amsterdam | ||||
11603 | 11603 | 1962-09-15 | Bank of Greece | 1959-09-15 | GREECE | EMB, Ltd. 1270 | 1959-09-15 | EMB, Ltd. | Athens | ||||
15593 | 15593 | 1959-12-31 | National Bank of Cuba | 1959-09-15 | CUBA | EMB, Ltd. 1270 | 1959-09-15 | EMB, Ltd. | Havana | ||||
11604 | 11604 | 1962-09-15 | Bank of Israel | 1959-09-15 | ISRAEL | EMB, Ltd. 1270 | 1959-09-15 | EMB, Ltd. | Jerusalem | ||||
11609 | 11609 | 1962-09-15 | Central Bank of the Philippines | 1959-09-15 | PHILIPPINES | EMB, Ltd. 1270 | 1959-09-15 | EMB, Ltd. | Manila | ||||
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 | ||||
15066 | 15066 | 1968-12-13 | Nord-Aviation, S.A. | 1959-09-15 | FRANCE | American Surveys 1269 | 1959-09-15 | American Surveys | Paris | ||||
11616 | 11616 | 1962-09-15 | Reserve Bank of South Africa | 1959-09-15 | SOUTH AFRICA | EMB, Ltd. 1270 | 1959-09-15 | EMB, Ltd. | Pretoria | ||||
11613 | 11613 | 1962-09-15 | Development Bank of Brazil | 1959-09-15 | BRAZIL | EMB, Ltd. 1270 | 1959-09-15 | EMB, Ltd. | Rio de Janeiro | ||||
11605 | 11605 | 1962-09-15 | Bank of Italy | 1959-09-15 | ITALY | EMB, Ltd. 1270 | 1959-09-15 | EMB, Ltd. | Rome | ||||
15591 | 15591 | 1959-12-31 | Central Bank of Chile | 1959-09-15 | CHILE | EMB, Ltd. 1270 | 1959-09-15 | EMB, Ltd. | Santiago | ||||
11610 | 11610 | 1962-09-15 | Commonwealth Bank of Australia | 1959-09-15 | AUSTRALIA | EMB, Ltd. 1270 | 1959-09-15 | EMB, Ltd. | Sydney | ||||
9655 | 9655 | 1962-07-31 | Japan Export Trade Promotion Agency (JETRO) | 1959-09-15 | JAPAN | Dewey, Ballantine, Bushby, Palmer & Wood 909 | 1955-09-08 | Dewey, Ballantine, Bushby, Palmer & Wood | Tokyo |
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]) );