FARA_All_RegistrantDocs
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
5 rows where Registrant_Name = "WHITE & CASE, LLP" and Registration_Number = 2759
This data as json, CSV (advanced)
Document_Type 2
Registrant_Name 1
- WHITE & CASE, LLP · 5 ✖
Foreign_Principal_Name 1
- - 5
Foreign_Principal_Country 1
- - 5
Link | rowid ▼ | Date_Stamped | Registrant_Name | Registration_Number | Document_Type | Short_Form_Name | Foreign_Principal_Name | Foreign_Principal_Country | URL |
---|---|---|---|---|---|---|---|---|---|
7400 | 7400 | 1999-01-25 | WHITE & CASE, LLP | White & Case, LLP 2759 | Amendment | https://efile.fara.gov/docs/2759-Amendment-19990125-F6861702.pdf | |||
7655 | 7655 | 1999-01-26 | WHITE & CASE, LLP | White & Case, LLP 2759 | Amendment | https://efile.fara.gov/docs/2759-Amendment-19990126-F6BUIS05.pdf | |||
26411 | 26411 | 1998-03-09 | WHITE & CASE, LLP | White & Case, LLP 2759 | Supplemental Statement | https://efile.fara.gov/docs/2759-Supplemental-Statement-19980309-ET0AQ105.pdf | |||
26413 | 26413 | 1999-03-09 | WHITE & CASE, LLP | White & Case, LLP 2759 | Supplemental Statement | https://efile.fara.gov/docs/2759-Supplemental-Statement-19990309-FBJ5QR01.pdf | |||
96517 | 96517 | 1998-09-09 | WHITE & CASE, LLP | White & Case, LLP 2759 | Supplemental Statement | https://efile.fara.gov/docs/2759-Supplemental-Statement-19980909-F334T104.pdf |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [FARA_All_RegistrantDocs] ( [Date_Stamped] TEXT, [Registrant_Name] TEXT, [Registration_Number] INTEGER, [Document_Type] TEXT, [Short_Form_Name] TEXT, [Foreign_Principal_Name] TEXT, [Foreign_Principal_Country] TEXT, [URL] TEXT, FOREIGN KEY([Registration_Number]) REFERENCES [FARA_All_Registrants]([Registration_Number]) );