FARA_All_RegistrantDocs
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
19 rows where Document_Type = "Exhibit AB" and Registrant_Name = "MANATT, PHELPS & PHILLIPS"
This data as json, CSV (advanced)
Foreign_Principal_Name 15
- NEC CORPORATION 4
- REPUBLIC OF CYPRUS 2
- ASOCIACION COLOMBIANA DE EXPORTADORES DE FLORES (ASOCOFLORES 1
- CEMEX, S.A. 1
- CONACEX NORESTE, A.C. 1
- EMBASSY OF THE UNITED MEXICAN STATES (MEXICO) 1
- GOVERNMENT OF COSTA RICA 1
- GOVERNMENT OF JAMAICA 1
- GOVERNMENT OF THE REPUBLIC OF MONTENEGRO, TRADE MISSION OF U 1
- GOVERNMENT OF THE UKRAINE 1
- JAMAICA BROADCASTING CORPORATION 1
- SECRETARIA DE AGRICULTURA, GANADERIA Y DESARROLLO RURAL 1
- SOCIAL DEMOCRATIC & LABOUR PARTY OF NORTHERN IRELAND 1
- THE GOVERNMENT OF THE REPUBLIC OF UZBEKISTAN 1
- VITRO, S.A. 1
Foreign_Principal_Country 10
- MEXICO 5
- JAPAN 4
- CYPRUS 2
- JAMAICA 2
- COLOMBIA 1
- COSTA RICA 1
- MONTENEGRO 1
- NORTHERN IRELAND 1
- UKRAINE 1
- UZBEKISTAN 1
Registrant_Name 1
- MANATT, PHELPS & PHILLIPS · 19 ✖
Document_Type 1
- Exhibit AB · 19 ✖
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]) );