FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
16 rows where "Foreign_Principal_Termination_Date" is on date 2006-03-31 and Registrant_Name = "White & Case, LLP" sorted by Foreign_Principal_Registration_Date
This data as json, CSV (advanced)
Suggested facets: Address_2, Registrant_Date (date)
Foreign_Principal 16
- Government of Abu Dhabi 1
- Government of Sweden 1
- Kingdom of Morocco 1
- Poland Ministry of Privatization 1
- Republic of Bulgaria 1
- Republic of Costa Rica 1
- Republic of Finland 1
- Republic of Gabon 1
- Republic of Hungary 1
- Republic of Macedonia 1
- Republic of Singapore 1
- Republic of South Africa 1
- Republic of Ukraine 1
- Republic of the Philippines 1
- State Bank of Vietnam 1
- State of Qatar 1
Country/Location_Represented 16
- BULGARIA 1
- COSTA RICA 1
- FINLAND 1
- GABON 1
- HUNGARY 1
- MACEDONIA 1
- MOROCCO 1
- PHILIPPINES 1
- POLAND 1
- QATAR 1
- SINGAPORE 1
- SOUTH AFRICA 1
- SWEDEN 1
- UKRAINE 1
- UNITED ARAB EMIRATES 1
- VIETNAM 1
Foreign_Principal_Registration_Date (date) 10 ✖
- 2006-05-31 5
- 2005-11-01 3
- 1978-05-02 1
- 1979-01-24 1
- 1985-05-16 1
- 1992-04-09 1
- 1996-04-24 1
- 1999-12-16 1
- 2004-04-16 1
- 2005-04-14 1
State 1
- - 16
Registrant_Name 1
- White & Case, LLP · 16 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4662 | 4662 | 2006-03-31 | Republic of Gabon | 1978-05-02 | GABON | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | Libreville | ||||
4665 | 4665 | 2006-03-31 | Republic of Singapore | 1979-01-24 | SINGAPORE | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | |||||
4655 | 4655 | 2006-03-31 | Kingdom of Morocco | 1985-05-16 | MOROCCO | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | Rabat | ||||
4659 | 4659 | 2006-03-31 | Republic of Bulgaria | 1992-04-09 | BULGARIA | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | Sofia | ||||
4669 | 4669 | 2006-03-31 | State Bank of Vietnam | 1996-04-24 | VIETNAM | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | Hanoi | ||||
4667 | 4667 | 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 | ||||
4658 | 4658 | 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 | ||||
4668 | 4668 | 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 | ||||
4660 | 4660 | 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 | ||
4664 | 4664 | 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 | ||||
4670 | 4670 | 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 | |||
4650 | 4650 | 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 | |||
4652 | 4652 | 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 | |||
4661 | 4661 | 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 | |||
4663 | 4663 | 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 | |||
4666 | 4666 | 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 |
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]) );