FARA_All_ForeignPrincipals

Table actions
List of all foreign principals (active and terminated)

Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history

39 rows where Registrant_Name = "Milbank, Tweed, Hadley & McCloy"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Foreign_Principal_Termination_Date, Foreign_Principal_Registration_Date, Address_1, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)

State 4

Registrant_Name 1

  • Milbank, Tweed, Hadley & McCloy · 39 ✖

City 1

  • - 39
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        
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

CSV options: 

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])
);