home / fara

Menu
  • Search all tables
  • GraphQL API

FARA_All_ForeignPrincipals

Table actions
  • GraphQL API for 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

This data as json, CSV (advanced)

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

Foreign_Principal >30

  • Arab Bank PLC 1
  • Association of German Banks 1
  • Bank of Zaire 1
  • Central Bank of Costa Rica 1
  • Central Bank of the Republic of Turkey 1
  • City of Amsterdam Kingdom of the Netherlands 1
  • Democratic Socialist Republic of Sri Lanka 1
  • Deutsche Bahn AG 1
  • Federal Republic of Nigeria 1
  • Government of Abu Dhabi 1
  • Government of Sweden 1
  • Government of the Kingdom of Saudi Arabia 1
  • Government of the Republic of Singapore 1
  • Great Socialist People's Libyan Arab Jamahiriya 1
  • Hashemite Kingdom of Jordan, Embassy 1
  • Islamic Republic of Pakistan 1
  • Isle of Man 1
  • Kingdom of Jordan 1
  • Kingdom of Morocco 1
  • Kingdom of Thailand 1
  • Poland Ministry of Privatization 1
  • Polish People's Republic 1
  • Republic of Azerbaijan 1
  • Republic of Bulgaria 1
  • Republic of Costa Rica 1
  • Republic of Croatia 1
  • Republic of Finland 1
  • Republic of Gabon 1
  • Republic of Guinea 1
  • Republic of Honduras 1
  • …

Country/Location_Represented >30

  • JORDAN 3
  • CHANNEL ISLANDS 2
  • COSTA RICA 2
  • GERMANY 2
  • POLAND 2
  • SINGAPORE 2
  • AZERBAIJAN 1
  • BULGARIA 1
  • CROATIA 1
  • FINLAND 1
  • GABON 1
  • GUINEA 1
  • HONDURAS 1
  • HUNGARY 1
  • INDONESIA 1
  • IRAQ 1
  • ISLE OF MAN 1
  • KYRGYZSTAN 1
  • LIBYA 1
  • MACEDONIA 1
  • MOROCCO 1
  • NETHERLANDS 1
  • NIGERIA 1
  • PAKISTAN 1
  • PANAMA 1
  • PERU 1
  • PHILIPPINES 1
  • QATAR 1
  • RUSSIA 1
  • SAUDI ARABIA 1
  • …

City 9

  • - 39
  • Amman 2
  • Washington 2
  • Berlin 1
  • British 1
  • Jersey 1
  • Moscow 1
  • Riyadh 1
  • San Jose 1

State 2

  • - 47
  • DC 2

Registrant_Name 1

  • 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
3512 3512 1991-03-09 Association of German Banks 1987-05-15 GERMANY White & Case, LLP 2759 1977-03-09 White & Case, LLP          
3513 3513 1991-03-09 Bank of Zaire 1980-01-24 ZAIRE White & Case, LLP 2759 1977-03-09 White & Case, LLP Gombe        
3514 3514 1991-03-09 Central Bank of Costa Rica 1981-10-13 COSTA RICA White & Case, LLP 2759 1977-03-09 White & Case, LLP San Jose        
3515 3515 1991-03-09 Democratic Socialist Republic of Sri Lanka 1982-10-08 SRI LANKA White & Case, LLP 2759 1977-03-09 White & Case, LLP Colombo        
3516 3516 1991-03-09 Islamic Republic of Pakistan 1988-12-23 PAKISTAN White & Case, LLP 2759 1977-03-09 White & Case, LLP Islamabad        
3517 3517 1991-03-09 Republic of Honduras 1984-04-09 HONDURAS White & Case, LLP 2759 1977-03-09 White & Case, LLP          
3518 3518 1991-03-09 Republic of Peru 1981-10-13 PERU White & Case, LLP 2759 1977-03-09 White & Case, LLP Lima        
3519 3519 1991-03-09 Republic of Tunisia 1988-06-20 TUNISIA White & Case, LLP 2759 1977-03-09 White & Case, LLP Tunis        
3545 3545 1998-03-10 Polish People's Republic 1991-10-09 POLAND White & Case, LLP 2759 1977-03-09 White & Case, LLP Warsaw        
3546 3546 1998-03-10 Central Bank of the Republic of Turkey 1978-11-09 TURKEY White & Case, LLP 2759 1977-03-09 White & Case, LLP Ankara        
3547 3547 1998-03-10 Republic of Suriname 1985-05-16 SURINAME White & Case, LLP 2759 1977-03-09 White & Case, LLP Paramaribo        
4610 4610 2006-03-31 Government of Abu Dhabi 2006-05-31 UNITED ARAB EMIRATES White & Case, LLP 2759 1977-03-09 White & Case, LLP Adwea Building P.O. Box 6120 Abu Dhabi      
4612 4612 2006-03-31 Government of Sweden 2006-05-31 SWEDEN White & Case, LLP 2759 1977-03-09 White & Case, LLP Box 240 Stockholm 101 24      
4615 4615 2006-03-31 Kingdom of Morocco 1985-05-16 MOROCCO White & Case, LLP 2759 1977-03-09 White & Case, LLP Rabat        
4618 4618 2006-03-31 Poland Ministry of Privatization 2004-04-16 POLAND White & Case, LLP 2759 1977-03-09 White & Case, LLP Ministry of Economy Ministerstwo Gospodarki Department Handlu; USLUG Plac Trzech Krzyzy 3/5; 00-50        
4619 4619 2006-03-31 Republic of Bulgaria 1992-04-09 BULGARIA White & Case, LLP 2759 1977-03-09 White & Case, LLP Sofia        
4620 4620 2006-03-31 Republic of Costa Rica 2005-11-01 COSTA RICA White & Case, LLP 2759 1977-03-09 White & Case, LLP Avenida 3a Calle 40 Apartado 1278-1007 San Jose    
4621 4621 2006-03-31 Republic of Finland 2006-05-31 FINLAND White & Case, LLP 2759 1977-03-09 White & Case, LLP Snell Maninkatu 1A Helsinki 00023      
4622 4622 2006-03-31 Republic of Gabon 1978-05-02 GABON White & Case, LLP 2759 1977-03-09 White & Case, LLP Libreville        
4623 4623 2006-03-31 Republic of Hungary 2006-05-31 HUNGARY White & Case, LLP 2759 1977-03-09 White & Case, LLP Csalogany U 9-11 Budapest, H-1027      
4624 4624 2006-03-31 Republic of Macedonia 2005-11-01 MACEDONIA White & Case, LLP 2759 1977-03-09 White & Case, LLP Dame Cruev 14, 1000 Skopje        
4625 4625 2006-03-31 Republic of Singapore 1979-01-24 SINGAPORE White & Case, LLP 2759 1977-03-09 White & Case, LLP          
4626 4626 2006-03-31 Republic of South Africa 2006-05-31 SOUTH AFRICA White & Case, LLP 2759 1977-03-09 White & Case, LLP 399 Duncan Street Hatfield 0083      
4627 4627 2006-03-31 Republic of Ukraine 1999-12-16 UKRAINE White & Case, LLP 2759 1977-03-09 White & Case, LLP Head of External Debt Department Ministry of Finance Klev        
4628 4628 2006-03-31 Republic of the Philippines 2005-04-14 PHILIPPINES White & Case, LLP 2759 1977-03-09 White & Case, LLP Office of the Solicitor General        
4629 4629 2006-03-31 State Bank of Vietnam 1996-04-24 VIETNAM White & Case, LLP 2759 1977-03-09 White & Case, LLP Hanoi        
4630 4630 2006-03-31 State of Qatar 2005-11-01 QATAR White & Case, LLP 2759 1977-03-09 White & Case, LLP Supreme Council Box 23224 Doha State      
4905 4905 2007-04-01 Republic of Indonesia 1977-03-09 INDONESIA White & Case, LLP 2759 1977-03-09 White & Case, LLP Jakarta        
4907 4907 2009-04-01 Kingdom of Jordan 2006-05-31 JORDAN White & Case, LLP 2759 1977-03-09 White & Case, LLP Shmaisani West P.O. Box 941536 Amman    
4910 4910 2014-04-01 Deutsche Bahn AG 2011-12-21 GERMANY White & Case, LLP 2759 1977-03-09 White & Case, LLP Potsdamer Platz 2   Berlin    
4911 4911 2014-04-01 Hashemite Kingdom of Jordan, Embassy 2010-11-02 JORDAN White & Case, LLP 2759 1977-03-09 White & Case, LLP 3504 International Drive, NW   Washington DC 20008
9215 9215 2006-07-15 Republic of Iraq 2004-10-13 IRAQ White & Case, LLP 2759 1977-03-09 White & Case, LLP CPA Contracting Authority Republic Presidential Compound Baghdad, Iraq APO AE 09316        
11204 11204 1989-09-01 Republic of Panama 1981-10-13 PANAMA White & Case, LLP 2759 1977-03-09 White & Case, LLP Panama City        
11417 11417 1997-09-10 Republic of Krgyzstan 1997-11-13 KYRGYZSTAN White & Case, LLP 2759 1977-03-09 White & Case, LLP Bishkek (Frunze)        
11524 11524 2006-09-14 Republic of Azerbaijan 2003-10-31 AZERBAIJAN White & Case, LLP 2759 1977-03-09 White & Case, LLP 0        
12323 12323 2005-10-01 Federal Republic of Nigeria 1990-04-09 NIGERIA White & Case, LLP 2759 1977-03-09 White & Case, LLP Lagos        
12324 12324 2005-10-01 Republic of Croatia 1996-10-11 CROATIA White & Case, LLP 2759 1977-03-09 White & Case, LLP Zagreb        
12325 12325 2005-10-01 Republic of Guinea 1985-01-15 GUINEA White & Case, LLP 2759 1977-03-09 White & Case, LLP Conakry        
12326 12326 2005-10-01 Republic of Uzbekistan 1997-11-13 UZBEKISTAN White & Case, LLP 2759 1977-03-09 White & Case, LLP Taskhent        
12327 12327 2006-10-01 Government of the Kingdom of Saudi Arabia 2005-07-20 SAUDI ARABIA White & Case, LLP 2759 1977-03-09 White & Case, LLP     Riyadh    
12332 12332 2008-10-01 City of Amsterdam Kingdom of the Netherlands 2004-04-16 NETHERLANDS White & Case, LLP 2759 1977-03-09 White & Case, LLP Nauta Ditilh PostBus 7113 ML - 1007 JC Amsterdam        
12333 12333 2008-10-01 Kingdom of Thailand 1989-10-10 THAILAND White & Case, LLP 2759 1977-03-09 White & Case, LLP Bangkok        
12336 12336 2010-10-01 Isle of Man 2005-11-01 ISLE OF MAN White & Case, LLP 2759 1977-03-09 White & Case, LLP IOM Government Office Douglan, IM1 9 PG British    
12343 12343 2012-10-01 Arab Bank PLC 2011-10-31 JORDAN White & Case, LLP 2759 1977-03-09 White & Case, LLP P.O. Box 950545   Amman    
13560 13560 2009-11-01 Techsnabexport (Tenex) 2008-10-02 RUSSIA White & Case, LLP 2759 1977-03-09 White & Case, LLP 28/3, Ozerkovskaya Nab.,   Moscow    
15033 15033 2010-12-14 Great Socialist People's Libyan Arab Jamahiriya 2008-03-07 LIBYA White & Case, LLP 2759 1977-03-09 White & Case, LLP 2600 Virginia Avenue, NW Suite 705 Washington DC 20037
16650 16650 2013-12-31 Government of the Republic of Singapore 2012-04-30 SINGAPORE White & Case, LLP 2759 1977-03-09 White & Case, LLP Ministry of Finance The Treasury 100 High Street, #10-01 Singapore 179434      
16657 16657 2013-12-31 States of Guernsey 2007-05-09 CHANNEL ISLANDS White & Case, LLP 2759 1977-03-09 White & Case, LLP          
16658 16658 2013-12-31 States of Jersey 2007-05-09 CHANNEL ISLANDS White & Case, LLP 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 · Queries took 157.088ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history