{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Introduction","Visual corporate structure","Raw_data"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Introduction","index":0,"n_rows":17,"n_cols":11,"rows_kept":17,"cut":false,"hidden":false,"merged":[[14,2,14,7],[15,2,15,7],[16,2,16,7],[12,2,12,7],[13,2,13,7],[11,2,11,7],[11,10,16,25]]}
[]
[]
[]
[]
[]
[null,"Overview and information"]
[]
[null,null,"Number of subsidiaries","Number of countries","Number of layers"]
[null,"Pertamina",100,26,7]
[]
[]
[null,null,"Variable Definition",null,null,null,null,null,null,null,"Click the button \"Launch\" to visualise the corporate structure. \n\nEach node in the structure contains the following information:\nCompany Name_Country Incorporation_Industry_(Percentage of shares owned by its direct parent company) [*number of subsidiaries with the same information regarding name, country and industry, but different tax registration number] \n\n"]
[null,"Company Name","Name of the subsidiary"]
[null,"Country Incorporation","Country of incorporations of the subsidiary"]
[null,"Industry","Industry in which the subsidiary operates"]
[null,"Percentage_share","Percentage of shares owned by its direct parent company"]
[null,"Layer No.","Refers to the layer in the corporate structure where the company is located. When layer_number is 1, it means that it is the direct subsidiary. When layer_number is 2, it means that it is owned directly by a direct subsidiary."]

{"sheet":"Visual corporate structure","index":1,"n_rows":102,"n_cols":7,"rows_kept":102,"cut":false,"hidden":false,"merged":[]}
["Company","Layer 1","Layer 2","Layer 3","Layer 4","Layer 5","Layer 6"]
["Pertamina(Indonesia)"]
[null,"Badak Natural Gas Liquefaction Company, PT_Indonesia_Manufacturing(50.01)"]
[null,"Conoco Philips Algeria Ltd_Algeria_Mining(100)"]
[null,"Elnusa Tbk., PT_Indonesia_Mining(41.1)"]
[null,null,"Elnusa Fabrikasi Konstruksi, PT_Indonesia_Retail_trade(97.35)"]
[null,null,"Sigma Cipta Utama, PT_Indonesia_Services(99.99)"]
[null,null,"Elnusa Patra Ritel, Pt_Indonesia_Manufacturing(98)"]
[null,null,null,"PT Elnusa Daya Kreatif_Indonesia(99.99)"]
[null,null,"Patra Nusa Data, PT_Indonesia_Services(70)"]
[null,null,"Elnusa Oilfield Services, Pt_Indonesia_Mining(99.99)"]
[null,null,"Elnusa Trans Samudera PT_Indonesia(99.58)"]
[null,null,"Elnusa Geosains Indonesia, Pt_Indonesia_Services(99.99)"]
[null,null,"Elnusa Petrofin, PT_Indonesia_Wholesale_trade(99.99)"]
[null,"Maritindo_Indonesia(50.01)"]
[null,"Nusantara Regas, PT_Indonesia_Trans.&Comm.&Util.(60)"]
[null,"Patra Jasa, PT_Indonesia_Financials(99.98)"]
[null,"Pelita Air Service, PT_Indonesia_Trans.&Comm.&Util.(99.99)"]
[null,"Pertamina Bina Medika, PT_Indonesia_Services(99.98)"]
[null,"Pertamina Drilling Services Indonesia, PT_Indonesia_Mining(99.89)"]
[null,"Pertamina E & P Libya Ltd Company_Libya_Mining(99)"]
[null,"Pertamina EP Cepu, PT_Indonesia_Mining(99)"]
[null,"Pertamina EP, PT_Indonesia_Mining(99.99)"]
[null,"Pertamina Energy Services Pte. Ltd._Singapore_Wholesale_trade(100)"]
[null,"Pertamina Ep Cepu Alas Dara & Kemuning, Pt_Indonesia(99)"]
[null,"Pertamina Gas, PT (Pertagas)_Indonesia_Mining(99.99)"]
[null,null,"Perta-Samtan Gas , PT_Indonesia_Manufacturing(66)"]
[null,null,"Pertagas Niaga, PT_Indonesia_Retail_trade(99)"]
[null,null,"Perta Kalimantan Gas, PT_Indonesia_Trans.&Comm.&Util.(70)"]
[null,null,"Perta Daya Gas, PT_Indonesia_Manufacturing(65)"]
[null,null,"Perta Arun Gas, PT_Indonesia_Manufacturing(90)"]
[null,"Pertamina Geothermal Energy, PT_Indonesia_Trans.&Comm.&Util.(90.06)"]
[null,"Pertamina Hulu Energi, PT_Indonesia_Mining(98.72)"]
[null,"Pertamina Hulu Indonesia Pt_Indonesia(99.93)"]
[null,"Pertamina Internasional Eksplorasi dan Produksi (PIEP), PT_Indonesia_Mining(99.99)"]
[null,null,"Etablissements Maurel Et Prom_France_Mining(74)"]
[null,null,null,"Maurel Et Prom Italia S.R.L._Italy_Trans.&Comm.&Util.(100)"]
[null,null,null,"Maurel & Prom West Africa_Belgium_Services(100)"]
[null,null,null,null,"Maurel & Prom Gabon S.A._Gabon_Mining(100)"]
[null,null,null,"Maurel & Prom Exploration Production France_France_Financials(100)"]
[null,null,null,"Maurel & Prom Netherlands B.V._Netherlands_Financials(100)"]
[null,null,null,"Maurel & Prom Exploration Production Gabon Sa_Gabon(100)"]
[null,null,null,"Mp West Canada_France_Financials(100)"]
[null,null,null,null,"Mp Energy West Canada Corp._Canada(100)"]
[null,null,null,"Maurel & Prom Assistance Technique International Sa_Switzerland_Services(99.99)"]
[null,null,null,"Maurel & Prom Angola_France_Mining(100)"]
[null,null,null,"Maurel & Prom Assistance Technique_France_Services(100)"]
[null,null,null,null,"Prestoil Kouilou_Congo(100)"]
[null,null,null,"Maurel Et Prom Congo_Congo(100)"]
[null,null,null,"Maurel & Prom Volney 5_France_Mining(100)"]
[null,null,null,"Maurel & Prom Drilling Services B.V._Netherlands_Financials(100)"]
[null,null,null,null,"Caroil_France_Mining(100)"]
[null,null,null,null,null,"Caroil_Gabon(100)"]
[null,null,null,null,null,"Caroil_United Republic of Tanzania(100)"]
[null,null,null,null,null,"Caroil S A Sucursal Colombia_Colombia_Mining(100)"]
[null,null,null,null,null,"Caroil S.A.S. FOREIGN_Cameroon(100)"]
[null,null,null,null,null,"Caroil S.A.S. FOREIGN_Congo(100)"]
[null,null,null,null,null,"Caroil S.A.S. FOREIGN_Uganda(100)"]
[null,null,null,"Mp East Asia_France_Financials(100)"]
[null,null,null,"Maurel & Prom Colombia B.V._Netherlands_Wholesale_trade(50.01)"]
[null,null,null,null,"Maurel & Prom Colombia B.V._Netherlands_Mining(100)"]
[null,null,null,null,"Maurel Et Prom Oleo E Gas Do Brasil Ltda_Brazil_Mining(99)"]
[null,null,null,null,"Maurel Y Prom Colombia B V_Colombia_Mining(100)"]
[null,null,null,"Saint-Aubin Exploration & Production Quebec Inc_Canada(100)"]
[null,null,null,"Maurel & Prom Syria_Syrian Arab Republic_Services(100)"]
[null,null,null,"Cardinal Drilling_Nigeria(40)"]
[null,null,null,"Zetah Noumbi Limited_Bahamas(49)"]
[null,null,null,"M&P Developpement Gabon_Gabon(100)"]
[null,null,null,"Maurel & Prom Exploration Production Tanzania Ltd_United Republic of Tanzania(100)"]
[null,null,null,"Maurel & Prom Amerique Latine_France_Financials(100)"]
[null,null,null,null,"Maurel Et Prom Peru Sac_Peru_Mining(100)"]
[null,null,null,null,"Maurel & Prom Peru Sac_Peru(100)"]
[null,null,null,null,"Maurel & Prom Mnazi Bay Holdings_France_Financials(100)"]
[null,null,null,null,null,"Cyprus Mnazi Bay Limited_Cyprus(60.07)"]
[null,null,null,null,null,null,"Cyprus Mnazi Bay FOREIGN_United Republic of Tanzania(100)"]
[null,null,null,"Maurel & Prom West Africa_France_Financials(100)"]
[null,null,null,"Saint-Aubin Energie Quebec Inc._Canada(100)"]
[null,"Pertamina Internasional Shipping, Pt_Indonesia(99.5)"]
[null,"Pertamina International Timor S.A._Timor-Leste(50)"]
[null,"Pertamina Kilang Internastional Pt_Indonesia(99.9)"]
[null,"Pertamina Lubricants, Pt_Indonesia_Manufacturing(99.95)"]
[null,null,"Amaco Production Co Ltd_Thailand_Manufacturing(74)"]
[null,"Pertamina Patra Niaga, PT_Indonesia_Mining(99.9)"]
[null,"Pertamina Pedeve Indonesia, PT_Indonesia_Financials(99.93)"]
[null,"Pertamina Power Indonesia, Pt_Indonesia(99)"]
[null,"Pertamina Retail, PT_Indonesia_Wholesale_trade(99.99)"]
[null,null,"Pertamina International Timor S.A._Timor-Leste(45)"]
[null,"Pertamina Training & Consulting, PT_Indonesia_Services(91)"]
[null,"Pertamina Trans Kontinental, PT_Indonesia_Trans.&Comm.&Util.(99.99)"]
[null,null,"Peteka Karya Gapura, PT_Indonesia_Manufacturing(99)"]
[null,null,"Trans Yeong Maritime, PT_Indonesia_Manufacturing(50.01)"]
[null,"Sari Ampenan, PT_Indonesia_Trans.&Comm.&Util.(50.01)"]
[null,"Tugu Pratama Indonesia Tbk., PT_Indonesia_Financials(65)"]
[null,null,"Trb (London) Limited_United Kingdom_Financials(100)"]
[null,null,null,"Trb (London) Limited_United Kingdom_Financials(100)"]
[null,null,"Tugu Insurance Company Limited_Hong Kong_Financials(27.5)"]
[null,null,"Pt Asuransi Tugu Partama Indonesia Tbk_Indonesia(30)"]
[null,null,"Tugu Pratama Interindo, Pt_Indonesia_Financials(99.99)"]
[null,null,null,"Tugu Reasuransi Indonesia, PT_Indonesia_Financials(65.05)"]
[null,null,null,"Tugu Insurance Company Limited_Hong Kong_Financials(72.5)"]
[null,null,null,"Synergy Risk Management Consultants, PT_Indonesia_Services(99.9)"]
[null,null,null,"Pratama Mitra Sejati, PT_Indonesia_Financials(99.9)"]

{"sheet":"Raw_data","index":2,"n_rows":101,"n_cols":4,"rows_kept":101,"cut":false,"hidden":true,"merged":[]}
["Information","Layer No.","Parent Identifier","Direct Parent Identifier"]
["Badak Natural Gas Liquefaction Company, PT_Indonesia_Manufacturing(50.01)",1,"001",""]
["Conoco Philips Algeria Ltd_Algeria_Mining(100)",1,"002",""]
["Elnusa Tbk., PT_Indonesia_Mining(41.1)",1,"003",""]
["Elnusa Fabrikasi Konstruksi, PT_Indonesia_Retail_trade(97.35)",2,"003001","003"]
["Sigma Cipta Utama, PT_Indonesia_Services(99.99)",2,"003002","003"]
["Elnusa Patra Ritel, Pt_Indonesia_Manufacturing(98)",2,"003003","003"]
["PT Elnusa Daya Kreatif_Indonesia(99.99)",3,"003003001","003003"]
["Patra Nusa Data, PT_Indonesia_Services(70)",2,"003004","003"]
["Elnusa Oilfield Services, Pt_Indonesia_Mining(99.99)",2,"003005","003"]
["Elnusa Trans Samudera PT_Indonesia(99.58)",2,"003006","003"]
["Elnusa Geosains Indonesia, Pt_Indonesia_Services(99.99)",2,"003007","003"]
["Elnusa Petrofin, PT_Indonesia_Wholesale_trade(99.99)",2,"003008","003"]
["Maritindo_Indonesia(50.01)",1,"004",""]
["Nusantara Regas, PT_Indonesia_Trans.&Comm.&Util.(60)",1,"005",""]
["Patra Jasa, PT_Indonesia_Financials(99.98)",1,"006",""]
["Pelita Air Service, PT_Indonesia_Trans.&Comm.&Util.(99.99)",1,"007",""]
["Pertamina Bina Medika, PT_Indonesia_Services(99.98)",1,"008",""]
["Pertamina Drilling Services Indonesia, PT_Indonesia_Mining(99.89)",1,"009",""]
["Pertamina E & P Libya Ltd Company_Libya_Mining(99)",1,"010",""]
["Pertamina EP Cepu, PT_Indonesia_Mining(99)",1,"011",""]
["Pertamina EP, PT_Indonesia_Mining(99.99)",1,"012",""]
["Pertamina Energy Services Pte. Ltd._Singapore_Wholesale_trade(100)",1,"013",""]
["Pertamina Ep Cepu Alas Dara & Kemuning, Pt_Indonesia(99)",1,"014",""]
["Pertamina Gas, PT (Pertagas)_Indonesia_Mining(99.99)",1,"015",""]
["Perta-Samtan Gas , PT_Indonesia_Manufacturing(66)",2,"015001","015"]
["Pertagas Niaga, PT_Indonesia_Retail_trade(99)",2,"015002","015"]
["Perta Kalimantan Gas, PT_Indonesia_Trans.&Comm.&Util.(70)",2,"015003","015"]
["Perta Daya Gas, PT_Indonesia_Manufacturing(65)",2,"015004","015"]
["Perta Arun Gas, PT_Indonesia_Manufacturing(90)",2,"015005","015"]
["Pertamina Geothermal Energy, PT_Indonesia_Trans.&Comm.&Util.(90.06)",1,"016",""]
["Pertamina Hulu Energi, PT_Indonesia_Mining(98.72)",1,"017",""]
["Pertamina Hulu Indonesia Pt_Indonesia(99.93)",1,"018",""]
["Pertamina Internasional Eksplorasi dan Produksi (PIEP), PT_Indonesia_Mining(99.99)",1,"019",""]
["Etablissements Maurel Et Prom_France_Mining(74)",2,"019001","019"]
["Maurel Et Prom Italia S.R.L._Italy_Trans.&Comm.&Util.(100)",3,"019001001","019001"]
["Maurel & Prom West Africa_Belgium_Services(100)",3,"019001002","019001"]
["Maurel & Prom Gabon S.A._Gabon_Mining(100)",4,"019001002001","019001002"]
["Maurel & Prom Exploration Production France_France_Financials(100)",3,"019001003","019001"]
["Maurel & Prom Netherlands B.V._Netherlands_Financials(100)",3,"019001004","019001"]
["Maurel & Prom Exploration Production Gabon Sa_Gabon(100)",3,"019001005","019001"]
["Mp West Canada_France_Financials(100)",3,"019001006","019001"]
["Mp Energy West Canada Corp._Canada(100)",4,"019001006001","019001006"]
["Maurel & Prom Assistance Technique International Sa_Switzerland_Services(99.99)",3,"019001007","019001"]
["Maurel & Prom Angola_France_Mining(100)",3,"019001008","019001"]
["Maurel & Prom Assistance Technique_France_Services(100)",3,"019001009","019001"]
["Prestoil Kouilou_Congo(100)",4,"019001009001","019001009"]
["Maurel Et Prom Congo_Congo(100)",3,"019001010","019001"]
["Maurel & Prom Volney 5_France_Mining(100)",3,"019001011","019001"]
["Maurel & Prom Drilling Services B.V._Netherlands_Financials(100)",3,"019001012","019001"]
["Caroil_France_Mining(100)",4,"019001012001","019001012"]
["Caroil_Gabon(100)",5,"019001012001001","019001012001"]
["Caroil_United Republic of Tanzania(100)",5,"019001012001002","019001012001"]
["Caroil S A Sucursal Colombia_Colombia_Mining(100)",5,"019001012001003","019001012001"]
["Caroil S.A.S. FOREIGN_Cameroon(100)",5,"019001012001004","019001012001"]
["Caroil S.A.S. FOREIGN_Congo(100)",5,"019001012001005","019001012001"]
["Caroil S.A.S. FOREIGN_Uganda(100)",5,"019001012001006","019001012001"]
["Mp East Asia_France_Financials(100)",3,"019001013","019001"]
["Maurel & Prom Colombia B.V._Netherlands_Wholesale_trade(50.01)",3,"019001014","019001"]
["Maurel & Prom Colombia B.V._Netherlands_Mining(100)",4,"019001014001","019001014"]
["Maurel Et Prom Oleo E Gas Do Brasil Ltda_Brazil_Mining(99)",4,"019001014002","019001014"]
["Maurel Y Prom Colombia B V_Colombia_Mining(100)",4,"019001014003","019001014"]
["Saint-Aubin Exploration & Production Quebec Inc_Canada(100)",3,"019001015","019001"]
["Maurel & Prom Syria_Syrian Arab Republic_Services(100)",3,"019001016","019001"]
["Cardinal Drilling_Nigeria(40)",3,"019001017","019001"]
["Zetah Noumbi Limited_Bahamas(49)",3,"019001018","019001"]
["M&P Developpement Gabon_Gabon(100)",3,"019001019","019001"]
["Maurel & Prom Exploration Production Tanzania Ltd_United Republic of Tanzania(100)",3,"019001020","019001"]
["Maurel & Prom Amerique Latine_France_Financials(100)",3,"019001021","019001"]
["Maurel Et Prom Peru Sac_Peru_Mining(100)",4,"019001021001","019001021"]
["Maurel & Prom Peru Sac_Peru(100)",4,"019001021002","019001021"]
["Maurel & Prom Mnazi Bay Holdings_France_Financials(100)",4,"019001021003","019001021"]
["Cyprus Mnazi Bay Limited_Cyprus(60.07)",5,"019001021003001","019001021003"]
["Cyprus Mnazi Bay FOREIGN_United Republic of Tanzania(100)",6,"019001021003001001","019001021003001"]
["Maurel & Prom West Africa_France_Financials(100)",3,"019001022","019001"]
["Saint-Aubin Energie Quebec Inc._Canada(100)",3,"019001023","019001"]
["Pertamina Internasional Shipping, Pt_Indonesia(99.5)",1,"020",""]
["Pertamina International Timor S.A._Timor-Leste(50)",1,"021",""]
["Pertamina Kilang Internastional Pt_Indonesia(99.9)",1,"022",""]
["Pertamina Lubricants, Pt_Indonesia_Manufacturing(99.95)",1,"023",""]
["Amaco Production Co Ltd_Thailand_Manufacturing(74)",2,"023001","023"]
["Pertamina Patra Niaga, PT_Indonesia_Mining(99.9)",1,"024",""]
["Pertamina Pedeve Indonesia, PT_Indonesia_Financials(99.93)",1,"025",""]
["Pertamina Power Indonesia, Pt_Indonesia(99)",1,"026",""]
["Pertamina Retail, PT_Indonesia_Wholesale_trade(99.99)",1,"027",""]
["Pertamina International Timor S.A._Timor-Leste(45)",2,"027001","027"]
["Pertamina Training & Consulting, PT_Indonesia_Services(91)",1,"028",""]
["Pertamina Trans Kontinental, PT_Indonesia_Trans.&Comm.&Util.(99.99)",1,"029",""]
["Peteka Karya Gapura, PT_Indonesia_Manufacturing(99)",2,"029001","029"]
["Trans Yeong Maritime, PT_Indonesia_Manufacturing(50.01)",2,"029002","029"]
["Sari Ampenan, PT_Indonesia_Trans.&Comm.&Util.(50.01)",1,"030",""]
["Tugu Pratama Indonesia Tbk., PT_Indonesia_Financials(65)",1,"031",""]
["Trb (London) Limited_United Kingdom_Financials(100)",2,"031001","031"]
["Trb (London) Limited_United Kingdom_Financials(100)",3,"031001001","031001"]
["Tugu Insurance Company Limited_Hong Kong_Financials(27.5)",2,"031002","031"]
["Pt Asuransi Tugu Partama Indonesia Tbk_Indonesia(30)",2,"031003","031"]
["Tugu Pratama Interindo, Pt_Indonesia_Financials(99.99)",2,"031004","031"]
["Tugu Reasuransi Indonesia, PT_Indonesia_Financials(65.05)",3,"031004001","031004"]
["Tugu Insurance Company Limited_Hong Kong_Financials(72.5)",3,"031004002","031004"]
["Synergy Risk Management Consultants, PT_Indonesia_Services(99.9)",3,"031004003","031004"]
["Pratama Mitra Sejati, PT_Indonesia_Financials(99.9)",3,"031004004","031004"]