{"help": "https://energydata.info/en/api/3/action/help_show?name=datastore_search", "success": true, "result": {"include_total": true, "limit": 100, "records_format": "objects", "resource_id": "e30ee1a3-7a10-48f6-8e9a-e3ce7a569dda", "total_estimation_threshold": null, "records": [{"_id":1,"No.":"Note: All data should be appropriately adjusted to reflect only the distribution business, and to exclude, as much as possible, any external shocks such as currency devaluation, etc. ","Quantitative variables":"","UNITS":"","Descriptions":""},{"_id":2,"No.":"","Quantitative variables":"OUTPUT VARIABLES","UNITS":"","Descriptions":""},{"_id":3,"No.":"1.0","Quantitative variables":"Total Number of Connections (Residential and Non-residential) in the utility area.","UNITS":"number","Descriptions":"This is the total number of connections (subscribers) in the utility area (ie. Number of residential and non-residential connections)"},{"_id":4,"No.":"2.0","Quantitative variables":"Total number of residential connections in the utility area","UNITS":"number","Descriptions":"This is total number of residential connections (subscribers) in the utility area."},{"_id":5,"No.":"3.0","Quantitative variables":"Total electricity sold per year ","UNITS":"MWh","Descriptions":"This is the same as total electricity supplied in MWh. It basically refers to the amount of electricity that was put on the network. "},{"_id":6,"No.":"4.0","Quantitative variables":"Length of distribution network**","UNITS":"km","Descriptions":"Network km should be reported by voltage. Only networks whose voltages are classified by the country’s regulator as distribution should be added in the distribution network length measure. Different types of tension should be recorded in the Extravariables section.   "},{"_id":7,"No.":"","Quantitative variables":"INPUT VARIABLES","UNITS":"","Descriptions":""},{"_id":8,"No.":"5.0","Quantitative variables":"Total number of employees**","UNITS":"number ","Descriptions":"This is the total number of employees related to electricity distribution activities. Ideally we need the end of year number. If not available, then the Full Time Employment number (FTE). If there is outsourcing, please add it as an extravariable at the end of the excel sheet. "},{"_id":9,"No.":"6.0","Quantitative variables":"Average wholesale price paid per MWh","UNITS":"local nominal currency","Descriptions":"Average Wholesale Price per MWh paid by the distribution company to the supplier of electricity. (A second option is to compute: Energy purchased expenditure ($) / Total MWh bought (MWh).   "},{"_id":10,"No.":"7.0","Quantitative variables":"Average transmission charges per MWh purchased","UNITS":"local nominal currency","Descriptions":"Average Transmission Charges per MWh Purchased from a Transmission Company (If Any) (Transmission charges expenditure ($) / Total MWh bought (MWh)).   "},{"_id":11,"No.":"8.0","Quantitative variables":"OPEX (operation expenditures) of the distribution services.**","UNITS":"local nominal currency","Descriptions":"OPEX consists of operating and maintenance costs, customer service and accounts expenses, sales expenses, administrative and general expenses. Usually, the biggest items of OPEX are labour, materials and third party service contract expenses. OPEX should reflect the operations of the distribution segment and therefore should not include purchases of electricity and taxes, transmission payments, and depreciation. The spreadsheet should make clear how the OPEX was calculated (data should be as disaggregate as possible, indicated in the extravariables). "},{"_id":12,"No.":"9.0","Quantitative variables":"CAPEX (capital expenditures) of the distribution service.**","UNITS":"local nominal currency","Descriptions":"CAPEX consists of the expenditures to acquire, expand, repair, or renovate fixed assets, implying the purchase of goods and services whose benefits extend beyond the year and add to the company’s assets. CAPEX represents the annual gross capital outlays of a company."},{"_id":13,"No.":"10.0","Quantitative variables":"TOTEX (total expenditures) of the distribution service ","UNITS":"local nominal currency","Descriptions":"TOTEX is the sum of OPEX and CAPEX (TOTEX = OPEX + CAPEX)."},{"_id":14,"No.":"","Quantitative variables":"OPERATING PERFORMANCE","UNITS":"","Descriptions":""},{"_id":15,"No.":"11.0","Quantitative variables":"Total Energy losses in distribution per year (due to technical losses and illegal connections)","UNITS":"%","Descriptions":"Total Energy losses. Total distribution losses should aggregate technical and non-technical (commercial losses). "},{"_id":16,"No.":"12.0","Quantitative variables":"Energy losses in distribution per year due to technical losses","UNITS":"%","Descriptions":"Energy losses due to technical reasons (i.e.Dissipation of power in electrical system components).  "},{"_id":17,"No.":"13.0","Quantitative variables":"Energy losses in distribution per year due to non-technical losses. ","UNITS":"%","Descriptions":"Energy losses due to non-technical or commercial losses (i.e. Theft of service (illegal connections), non-payment, and losses due to failure in the billing system).  "},{"_id":18,"No.":"","Quantitative variables":"QUALITY AND CUSTOMER SERVICES","UNITS":"","Descriptions":""},{"_id":19,"No.":"14.0","Quantitative variables":"Average duration of interruptions per subscriber ","UNITS":"hours / year","Descriptions":"This is the number of hours-subscriber the system was without power in a year, divided by the total number of subscribers. "},{"_id":20,"No.":"15.0","Quantitative variables":"Average frequency of interruptions per subscriber ","UNITS":"# interruptions / year","Descriptions":"The average number of interruptions experienced by a consumer unit during one year.  "},{"_id":21,"No.":"16.0","Quantitative variables":"Number of residential subscribers per 100 households in the concession area (Residential coverage)","UNITS":"# / 100 households","Descriptions":"Ration of residential connections per 100 households (within the area of operation). In other words, the percentage of households connected in each concession area (residential service coverage = residential connection / number of households) "},{"_id":22,"No.":"17.0","Quantitative variables":"Number of customer complaints per year","UNITS":"number ","Descriptions":"Total number of complaints filled out by customers every year due to failures in the distribution service."},{"_id":23,"No.":"18.0","Quantitative variables":"Average duration between customer complaint and the solution of the problem ","UNITS":"hours or days","Descriptions":"Average time that passes between the placement of a complaint by a customer and the solution of the problem that generated the complaint."},{"_id":24,"No.":"","Quantitative variables":"PRICES","UNITS":"","Descriptions":""},{"_id":25,"No.":"19.0","Quantitative variables":"Average residential tariff ","UNITS":"local nominal currency / MWh","Descriptions":"Please provide any available information calculated by the utility, regulatory agencies or similar entities (e.g. statistics offices) on average price per MWh of electricity sold to residential consumers, including both fixed and variable components, in local nominal currency."},{"_id":26,"No.":"20.0","Quantitative variables":"Average industrial tariff ","UNITS":"local nominal currency / MWh","Descriptions":"Please provide any available information calculated by the utility, regulatory agencies or similar entities (e.g. statistics offices) on average price per MWh of electricity sold to industrial consumers, including both fixed and variable components, in local nominal currency."},{"_id":27,"No.":"21.0","Quantitative variables":"Installation Fee (residential)","UNITS":"local nominal currency","Descriptions":"The price of instaling the electricity service to a residential customer (one time, fixed cost)."},{"_id":28,"No.":"22.0","Quantitative variables":"Installation Fee (Industrial)","UNITS":"local nominal currency","Descriptions":"The price of instaling the electricity service to a industrial customer (one time, fixed cost)."},{"_id":29,"No.":"","Quantitative variables":"Ownership","UNITS":"","Descriptions":""},{"_id":30,"No.":"23.0","Quantitative variables":"% of private ownership","UNITS":"%","Descriptions":""},{"_id":31,"No.":"","Quantitative variables":"","UNITS":"","Descriptions":""},{"_id":32,"No.":"** If there is any disaggregated data for these particular variables, please add the in the Extravariable section.","Quantitative variables":"","UNITS":"","Descriptions":""},{"_id":33,"No.":"Please add any additional data used to fill in the main template or other variables you consider of relevance ","Quantitative variables":"","UNITS":"","Descriptions":""},{"_id":34,"No.":"Extra Variables","Quantitative variables":"","UNITS":"","Descriptions":""},{"_id":35,"No.":"1.0","Quantitative variables":"Area covered","UNITS":"km^2","Descriptions":""},{"_id":36,"No.":"2.0","Quantitative variables":"Total population in area covered","UNITS":"number","Descriptions":""},{"_id":37,"No.":"3.0","Quantitative variables":"Length of network (Low Tension)","UNITS":"km","Descriptions":""},{"_id":38,"No.":"4.0","Quantitative variables":"Length of network (Medium tension)","UNITS":"km","Descriptions":""},{"_id":39,"No.":"5.0","Quantitative variables":"Length of network (High tension)","UNITS":"km","Descriptions":""},{"_id":40,"No.":"6.0","Quantitative variables":"Outsourcing (employees)","UNITS":"number","Descriptions":""},{"_id":41,"No.":"7.0","Quantitative variables":"OPEX (disaggregated)","UNITS":"local nominal currency","Descriptions":""},{"_id":42,"No.":"8.0","Quantitative variables":"CAPEX (disaggregated)","UNITS":"local nominal currency","Descriptions":""}], "fields": [{"id": "_id", "type": "int"}, {"id": "No.", "type": "text"}, {"id": "Quantitative variables", "type": "text"}, {"id": "UNITS", "type": "text"}, {"id": "Descriptions", "type": "text"}], "_links": {"start": "/api/3/action/datastore_search?resource_id=e30ee1a3-7a10-48f6-8e9a-e3ce7a569dda", "next": "/api/3/action/datastore_search?resource_id=e30ee1a3-7a10-48f6-8e9a-e3ce7a569dda&offset=100"}, "total": 42, "total_was_estimated": false}}