FARA_All_ForeignPrincipals

List of all foreign principals (active and terminated)

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

49 rows where Registrant_Name = "White & Case, LLP"

View and edit SQL

Suggested facets: Foreign_Principal_Termination_Date, Address_2, Zip, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)

State

Registrant_Name

  • White & Case, LLP · 49
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
3344 1991-03-09 Association of German Banks 1987-05-15 GERMANY 2759 2759 1977-03-09 White & Case, LLP          
3345 1991-03-09 Bank of Zaire 1980-01-24 ZAIRE 2759 2759 1977-03-09 White & Case, LLP Gombe        
3346 1991-03-09 Central Bank of Costa Rica 1981-10-13 COSTA RICA 2759 2759 1977-03-09 White & Case, LLP San Jose        
3347 1991-03-09 Democratic Socialist Republic of Sri Lanka 1982-10-08 SRI LANKA 2759 2759 1977-03-09 White & Case, LLP Colombo        
3348 1991-03-09 Islamic Republic of Pakistan 1988-12-23 PAKISTAN 2759 2759 1977-03-09 White & Case, LLP Islamabad        
3349 1991-03-09 Republic of Honduras 1984-04-09 HONDURAS 2759 2759 1977-03-09 White & Case, LLP          
3350 1991-03-09 Republic of Peru 1981-10-13 PERU 2759 2759 1977-03-09 White & Case, LLP Lima        
3351 1991-03-09 Republic of Tunisia 1988-06-20 TUNISIA 2759 2759 1977-03-09 White & Case, LLP Tunis        
3376 1998-03-10 Polish People's Republic 1991-10-09 POLAND 2759 2759 1977-03-09 White & Case, LLP Warsaw        
3377 1998-03-10 Central Bank of the Republic of Turkey 1978-11-09 TURKEY 2759 2759 1977-03-09 White & Case, LLP Ankara        
3378 1998-03-10 Republic of Suriname 1985-05-16 SURINAME 2759 2759 1977-03-09 White & Case, LLP Paramaribo        
4420 2006-03-31 Government of Abu Dhabi 2006-05-31 UNITED ARAB EMIRATES 2759 2759 1977-03-09 White & Case, LLP Adwea Building P.O. Box 6120 Abu Dhabi      
4422 2006-03-31 Government of Sweden 2006-05-31 SWEDEN 2759 2759 1977-03-09 White & Case, LLP Box 240 Stockholm 101 24      
4425 2006-03-31 Kingdom of Morocco 1985-05-16 MOROCCO 2759 2759 1977-03-09 White & Case, LLP Rabat        
4428 2006-03-31 Poland Ministry of Privatization 2004-04-16 POLAND 2759 2759 1977-03-09 White & Case, LLP Ministry of Economy Ministerstwo Gospodarki Department Handlu; USLUG Plac Trzech Krzyzy 3/5; 00-50        
4429 2006-03-31 Republic of Bulgaria 1992-04-09 BULGARIA 2759 2759 1977-03-09 White & Case, LLP Sofia        
4430 2006-03-31 Republic of Costa Rica 2005-11-01 COSTA RICA 2759 2759 1977-03-09 White & Case, LLP Avenida 3a Calle 40 Apartado 1278-1007 San Jose    
4431 2006-03-31 Republic of Finland 2006-05-31 FINLAND 2759 2759 1977-03-09 White & Case, LLP Snell Maninkatu 1A Helsinki 00023      
4432 2006-03-31 Republic of Gabon 1978-05-02 GABON 2759 2759 1977-03-09 White & Case, LLP Libreville        
4433 2006-03-31 Republic of Hungary 2006-05-31 HUNGARY 2759 2759 1977-03-09 White & Case, LLP Csalogany U 9-11 Budapest, H-1027      
4434 2006-03-31 Republic of Macedonia 2005-11-01 MACEDONIA 2759 2759 1977-03-09 White & Case, LLP Dame Cruev 14, 1000 Skopje        
4435 2006-03-31 Republic of Singapore 1979-01-24 SINGAPORE 2759 2759 1977-03-09 White & Case, LLP          
4436 2006-03-31 Republic of South Africa 2006-05-31 SOUTH AFRICA 2759 2759 1977-03-09 White & Case, LLP 399 Duncan Street Hatfield 0083      
4437 2006-03-31 Republic of Ukraine 1999-12-16 UKRAINE 2759 2759 1977-03-09 White & Case, LLP Head of External Debt Department Ministry of Finance Klev        
4438 2006-03-31 Republic of the Philippines 2005-04-14 PHILIPPINES 2759 2759 1977-03-09 White & Case, LLP Office of the Solicitor General        
4439 2006-03-31 State Bank of Vietnam 1996-04-24 VIETNAM 2759 2759 1977-03-09 White & Case, LLP Hanoi        
4440 2006-03-31 State of Qatar 2005-11-01 QATAR 2759 2759 1977-03-09 White & Case, LLP Supreme Council Box 23224 Doha State      
4684 2007-04-01 Republic of Indonesia 1977-03-09 INDONESIA 2759 2759 1977-03-09 White & Case, LLP Jakarta        
4686 2009-04-01 Kingdom of Jordan 2006-05-31 JORDAN 2759 2759 1977-03-09 White & Case, LLP Shmaisani West P.O. Box 941536 Amman    
4689 2014-04-01 Deutsche Bahn AG 2011-12-21 GERMANY 2759 2759 1977-03-09 White & Case, LLP Potsdamer Platz 2   Berlin    
4690 2014-04-01 Hashemite Kingdom of Jordan, Embassy 2010-11-02 JORDAN 2759 2759 1977-03-09 White & Case, LLP 3504 International Drive, NW   Washington DC 20008
8819 2006-07-15 Republic of Iraq 2004-10-13 IRAQ 2759 2759 1977-03-09 White & Case, LLP CPA Contracting Authority Republic Presidential Compound Baghdad, Iraq APO AE 09316        
10733 1989-09-01 Republic of Panama 1981-10-13 PANAMA 2759 2759 1977-03-09 White & Case, LLP Panama City        
10940 1997-09-10 Republic of Krgyzstan 1997-11-13 KYRGYZSTAN 2759 2759 1977-03-09 White & Case, LLP Bishkek (Frunze)        
11045 2006-09-14 Republic of Azerbaijan 2003-10-31 AZERBAIJAN 2759 2759 1977-03-09 White & Case, LLP 0        
11789 2005-10-01 Federal Republic of Nigeria 1990-04-09 NIGERIA 2759 2759 1977-03-09 White & Case, LLP Lagos        
11790 2005-10-01 Republic of Croatia 1996-10-11 CROATIA 2759 2759 1977-03-09 White & Case, LLP Zagreb        
11791 2005-10-01 Republic of Guinea 1985-01-15 GUINEA 2759 2759 1977-03-09 White & Case, LLP Conakry        
11792 2005-10-01 Republic of Uzbekistan 1997-11-13 UZBEKISTAN 2759 2759 1977-03-09 White & Case, LLP Taskhent        
11793 2006-10-01 Government of the Kingdom of Saudi Arabia 2005-07-20 SAUDI ARABIA 2759 2759 1977-03-09 White & Case, LLP     Riyadh    
11798 2008-10-01 City of Amsterdam Kingdom of the Netherlands 2004-04-16 NETHERLANDS 2759 2759 1977-03-09 White & Case, LLP Nauta Ditilh PostBus 7113 ML - 1007 JC Amsterdam        
11799 2008-10-01 Kingdom of Thailand 1989-10-10 THAILAND 2759 2759 1977-03-09 White & Case, LLP Bangkok        
11802 2010-10-01 Isle of Man 2005-11-01 ISLE OF MAN 2759 2759 1977-03-09 White & Case, LLP IOM Government Office Douglan, IM1 9 PG British    
11809 2012-10-01 Arab Bank PLC 2011-10-31 JORDAN 2759 2759 1977-03-09 White & Case, LLP P.O. Box 950545   Amman    
12970 2009-11-01 Techsnabexport (Tenex) 2008-10-02 RUSSIA 2759 2759 1977-03-09 White & Case, LLP 28/3, Ozerkovskaya Nab.,   Moscow    
14385 2010-12-14 Great Socialist People's Libyan Arab Jamahiriya 2008-03-07 LIBYA 2759 2759 1977-03-09 White & Case, LLP 2600 Virginia Avenue, NW Suite 705 Washington DC 20037
15978 2013-12-31 Government of the Republic of Singapore 2012-04-30 SINGAPORE 2759 2759 1977-03-09 White & Case, LLP Ministry of Finance The Treasury 100 High Street, #10-01 Singapore 179434      
15984 2013-12-31 States of Guernsey 2007-05-09 CHANNEL ISLANDS 2759 2759 1977-03-09 White & Case, LLP          
15985 2013-12-31 States of Jersey 2007-05-09 CHANNEL ISLANDS 2759 2759 1977-03-09 White & Case, LLP Cyril Le Marquand House P.O. Box 140 St. Helier Jersey    

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)
);
Powered by Datasette · Query took 153.997ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history