FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
40 rows where "Registrant_Date" is on date 1965-01-11 sorted by Registrant_Date
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Termination_Date, Foreign_Principal_Registration_Date, Registration_Number, Address_1, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date)
Foreign_Principal >30
- Japan Development Bank 2
- Association of International Bond Dealers 1
- Banca Nazionale del Lavoro 1
- Banco Central del Uruguay 1
- Banco Espirito Santo e Commericial de Lisboa 1
- Banco Nacional de Mexico (Banamex")" 1
- Banco do Brasil, S.A. 1
- Banco do Estado de Sao Paulo, S.A. 1
- Bank Melli Iran 1
- Bank of Japan 1
- Bank of Japan, New York Representative Office (as Agent of the Government of Japan) 1
- British Petroleum Company, Ltd. 1
- Compagnie Francaise de Petroles 1
- Corporacion de Fomento de la Produccion de Chile 1
- Embassy of Iceland 1
- Embassy of Japan 1
- Export Development Corporation (Canada) 1
- Government of Iceland 1
- Government of Japan 1
- Government of Kuwait 1
- Government of Mexico 1
- Hispanica de Petroleos, S.A. 1
- International Primary Market Association 1
- Investments Fund of Venezuela (Republic of Venezuela) 1
- JDS International Consulting 1
- Japan Forming Machinery Association 1
- Japan Machine Tool Builders' Association 1
- Japan Machinery Exporters' Association 1
- Japan Metal Forming Machine Builders' Association 1
- Japan Tobacco, Inc. 1
- …
Country/Location_Represented 23
Registrant_Name 2
City 1
- - 40
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1211 | 1211 | 1988-01-11 | Banca Nazionale del Lavoro | 1974-02-20 | ITALY | Milbank, Tweed, Hadley & McCloy 1839 | 1965-01-11 | Milbank, Tweed, Hadley & McCloy | Rome | ||||
1212 | 1212 | 1988-01-11 | Banco do Brasil, S.A. | 1967-10-10 | BRAZIL | Milbank, Tweed, Hadley & McCloy 1839 | 1965-01-11 | Milbank, Tweed, Hadley & McCloy | |||||
1213 | 1213 | 1988-01-11 | Banco do Estado de Sao Paulo, S.A. | 1971-02-17 | BRAZIL | Milbank, Tweed, Hadley & McCloy 1839 | 1965-01-11 | Milbank, Tweed, Hadley & McCloy | Sao Paulo | ||||
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 | ||||
1216 | 1216 | 1988-01-11 | Government of Kuwait | 1985-03-01 | KUWAIT | Milbank, Tweed, Hadley & McCloy 1839 | 1965-01-11 | Milbank, Tweed, Hadley & McCloy | |||||
1217 | 1217 | 1988-01-11 | Government of Mexico | 1974-02-20 | MEXICO | Milbank, Tweed, Hadley & McCloy 1839 | 1965-01-11 | Milbank, Tweed, Hadley & McCloy | |||||
1219 | 1219 | 1988-01-11 | Midland Bank, PLC | 1987-07-02 | GREAT BRITAIN | Milbank, Tweed, Hadley & McCloy 1839 | 1965-01-11 | Milbank, Tweed, Hadley & McCloy | Poultry London | ||||
1239 | 1239 | 1988-01-12 | Embassy of Japan | 1987-04-16 | JAPAN | Milbank, Tweed, Hadley & McCloy 1839 | 1965-01-11 | Milbank, Tweed, Hadley & McCloy | Washington | DC | |||
1241 | 1241 | 1989-01-12 | People's Republic of China | 1986-01-23 | CHINA | Milbank, Tweed, Hadley & McCloy 1839 | 1965-01-11 | Milbank, Tweed, Hadley & McCloy | Washington | DC | |||
1326 | 1326 | 1987-01-15 | Japan Machine Tool Builders' Association | 1986-08-11 | JAPAN | Milbank, Tweed, Hadley & McCloy 1839 | 1965-01-11 | Milbank, Tweed, Hadley & McCloy | Tokyo | ||||
1327 | 1327 | 1987-01-15 | Japan Machinery Exporters' Association | 1986-08-11 | JAPAN | Milbank, Tweed, Hadley & McCloy 1839 | 1965-01-11 | Milbank, Tweed, Hadley & McCloy | Tokyo | ||||
1328 | 1328 | 1987-01-15 | Japan Metal Forming Machine Builders' Association | 1986-08-11 | JAPAN | Milbank, Tweed, Hadley & McCloy 1839 | 1965-01-11 | Milbank, Tweed, Hadley & McCloy | Tokyo | ||||
1330 | 1330 | 1987-01-15 | Japan Forming Machinery Association | 1986-09-17 | JAPAN | Milbank, Tweed, Hadley & McCloy 1839 | 1965-01-11 | Milbank, Tweed, Hadley & McCloy | Tokyo | ||||
2356 | 2356 | 1992-02-10 | Banco Nacional de Mexico (Banamex")" | 1991-03-27 | MEXICO | Milbank, Tweed, Hadley & McCloy 1839 | 1965-01-11 | Milbank, Tweed, Hadley & McCloy | Isabel la Catolica | ||||
2538 | 2538 | 1966-02-15 | Liberian Agricultural Services, Ltd. (Partially owned by the Republic of Liberia) | 1965-01-11 | LIBERIA | Greater Iowa Trading Corporation 1840 | 1965-01-11 | Greater Iowa Trading Corporation | Monrovia | ||||
2780 | 2780 | 1974-02-25 | Japan Development Bank | 1965-01-11 | JAPAN | Milbank, Tweed, Hadley & McCloy 1839 | 1965-01-11 | Milbank, Tweed, Hadley & McCloy | Tokyo | ||||
2932 | 2932 | 1982-02-28 | Republic of Zaire | 1974-02-20 | ZAIRE | Milbank, Tweed, Hadley & McCloy 1839 | 1965-01-11 | Milbank, Tweed, Hadley & McCloy | Kinshasa | ||||
6417 | 6417 | 1978-05-09 | Bank of Japan | 1975-08-20 | JAPAN | Milbank, Tweed, Hadley & McCloy 1839 | 1965-01-11 | Milbank, Tweed, Hadley & McCloy | Tokyo | ||||
6418 | 6418 | 1978-05-09 | Government of Iceland | 1965-01-11 | ICELAND | Milbank, Tweed, Hadley & McCloy 1839 | 1965-01-11 | Milbank, Tweed, Hadley & McCloy | Reykjavik | ||||
6419 | 6419 | 1978-05-09 | Government of Japan | 1965-01-11 | JAPAN | Milbank, Tweed, Hadley & McCloy 1839 | 1965-01-11 | Milbank, Tweed, Hadley & McCloy | Tokyo | ||||
6420 | 6420 | 1978-05-09 | Perusahaan Pertambangan Minyak Dan Gas Bumi Negara | 1977-03-01 | INDONESIA | Milbank, Tweed, Hadley & McCloy 1839 | 1965-01-11 | Milbank, Tweed, Hadley & McCloy | Djakarta | ||||
7373 | 7373 | 1979-06-01 | Bank Melli Iran | 1978-07-06 | IRAN | Milbank, Tweed, Hadley & McCloy 1839 | 1965-01-11 | Milbank, Tweed, Hadley & McCloy | Teheran | ||||
8836 | 8836 | 1972-07-01 | Bank of Japan, New York Representative Office (as Agent of the Government of Japan) | 1965-01-11 | JAPAN | Milbank, Tweed, Hadley & McCloy 1839 | 1965-01-11 | Milbank, Tweed, Hadley & McCloy | New York | NY | |||
8840 | 8840 | 1972-07-01 | Metropolis of Tokyo | 1965-01-11 | JAPAN | Milbank, Tweed, Hadley & McCloy 1839 | 1965-01-11 | Milbank, Tweed, Hadley & McCloy | Tokyo | ||||
8851 | 8851 | 1979-07-01 | Nippon Telegraph & Telephone Public Corporation | 1965-01-11 | JAPAN | Milbank, Tweed, Hadley & McCloy 1839 | 1965-01-11 | Milbank, Tweed, Hadley & McCloy | Tokyo | ||||
9154 | 9154 | 1977-07-10 | Investments Fund of Venezuela (Republic of Venezuela) | 1974-12-16 | VENEZUELA | Milbank, Tweed, Hadley & McCloy 1839 | 1965-01-11 | Milbank, Tweed, Hadley & McCloy | Caracas | ||||
9177 | 9177 | 1969-07-11 | Corporacion de Fomento de la Produccion de Chile | 1968-08-01 | CHILE | Milbank, Tweed, Hadley & McCloy 1839 | 1965-01-11 | Milbank, Tweed, Hadley & McCloy | Santiago | ||||
9182 | 9182 | 1985-07-11 | British Petroleum Company, Ltd. | 1971-08-13 | GREAT BRITAIN | Milbank, Tweed, Hadley & McCloy 1839 | 1965-01-11 | Milbank, Tweed, Hadley & McCloy | London | ||||
9199 | 9199 | 1991-07-12 | Association of International Bond Dealers | 1990-07-11 | INTERNATIONAL | Milbank, Tweed, Hadley & McCloy 1839 | 1965-01-11 | Milbank, Tweed, Hadley & McCloy | Zurich | ||||
9200 | 9200 | 1991-07-12 | International Primary Market Association | 1990-07-11 | INTERNATIONAL | Milbank, Tweed, Hadley & McCloy 1839 | 1965-01-11 | Milbank, Tweed, Hadley & McCloy | London, England | ||||
9720 | 9720 | 1978-07-31 | Westdeutsche Landesbank Girozentrale | 1975-08-20 | GERMANY, FEDERAL REPUBLIC OF | Milbank, Tweed, Hadley & McCloy 1839 | 1965-01-11 | Milbank, Tweed, Hadley & McCloy | |||||
9743 | 9743 | 1987-07-31 | Japan Tobacco, Inc. | 1986-08-27 | JAPAN | Milbank, Tweed, Hadley & McCloy 1839 | 1965-01-11 | Milbank, Tweed, Hadley & McCloy | Tokyo | ||||
11404 | 11404 | 1976-09-07 | Turkish Airlines, Inc. | 1975-08-21 | TURKEY | Milbank, Tweed, Hadley & McCloy 1839 | 1965-01-11 | Milbank, Tweed, Hadley & McCloy | Istanbul | ||||
11934 | 11934 | 1975-09-30 | Banco Central del Uruguay | 1972-08-09 | URUGUAY | Milbank, Tweed, Hadley & McCloy 1839 | 1965-01-11 | Milbank, Tweed, Hadley & McCloy | Montevideo | ||||
11975 | 11975 | 1986-09-30 | Embassy of Iceland | 1986-08-08 | ICELAND | Milbank, Tweed, Hadley & McCloy 1839 | 1965-01-11 | Milbank, Tweed, Hadley & McCloy | Washington | DC | |||
13730 | 13730 | 1986-11-05 | JDS International Consulting | 1986-08-29 | ANGOLA | Milbank, Tweed, Hadley & McCloy 1839 | 1965-01-11 | Milbank, Tweed, Hadley & McCloy | Pennsville | NJ | |||
14659 | 14659 | 1979-12-01 | Banco Espirito Santo e Commericial de Lisboa | 1975-08-20 | PORTUGAL | Milbank, Tweed, Hadley & McCloy 1839 | 1965-01-11 | Milbank, Tweed, Hadley & McCloy | Lisbon | ||||
14661 | 14661 | 1979-12-01 | Japan Development Bank | 1975-02-18 | JAPAN | Milbank, Tweed, Hadley & McCloy 1839 | 1965-01-11 | Milbank, Tweed, Hadley & McCloy | Tokyo | ||||
15797 | 15797 | 1978-12-31 | Compagnie Francaise de Petroles | 1971-08-13 | FRANCE | Milbank, Tweed, Hadley & McCloy 1839 | 1965-01-11 | Milbank, Tweed, Hadley & McCloy | Paris | ||||
15804 | 15804 | 1978-12-31 | Hispanica de Petroleos, S.A. | 1971-08-13 | SPAIN | Milbank, Tweed, Hadley & McCloy 1839 | 1965-01-11 | Milbank, Tweed, Hadley & McCloy | Madrid |
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]) );