Consumption Data – ES

Getting access to Validated Historical Consumption Data through Spain's Datadis service.

In Spain, data is managed and made accessible by the DSOs. However, in 2019 ASEME (Association of electrical companies in Spain), CIDE (Association of small electric energy distribution companies in Spain), E-distribución Digital Networks S.LU. (electricity distributor of Endesa Group), E-REDES (EdP Group’s electricity distributaion company in Spain), i-DE Redes Eléctricas Inteligentes (Iberdrola’s electricity distributor), UFD (Naturgy group electricity distributor) and VIESGO created Datadis ( https://datadis.es ) to publish aggregated consumption data, but also act as a Consent Administrator for customers and broker between them and the DSOs, which act as Metered Data Administrators.

General information


screenshot from https://datadis.es taken 2021-01-12		Name: Datadis
Centralised Consent Administrator for de-centralised Metered Data Administrators
Website: https://www.datadis.es
Metering grid area: Whole of Spain
Consent administration responsibility region of Datadis

Onboarding as an Eligible Party

[TO_BE_DONE]

Requesting data as an Eligible Party

[TO_BE_DONE]

Data Transfer

Once the consent for a given CUPS has been given, you can access daily, weekly and monthly consumption. Files will be flowing back in the following format:

Daily (hourly consumption):

<?xml version='1.0'?>
<consumos>
    <consumos>
        <CUPS>ES0022000006150AAAAAAA</CUPS>
        <Fecha>2021/09/07</Fecha>
        <Hora>01:00</Hora>
        <Consumo_kWh>0,597</Consumo_kWh>
        <metodo_obtencion>Real</metodo_obtencion>
    </consumos>
    <consumos>
        <CUPS>ES0022000006150AAAAAAA</CUPS>
        <Fecha>2021/09/07</Fecha>
        <Hora>02:00</Hora>
        <Consumo_kWh>0,664</Consumo_kWh>
        <metodo_obtencion>Real</metodo_obtencion>
    </consumos>
    <consumos>
        <CUPS>ES0022000006150AAAAAAA</CUPS>
        <Fecha>2021/09/07</Fecha>
        <Hora>03:00</Hora>
        <Consumo_kWh>0,096</Consumo_kWh>
        <metodo_obtencion>Real</metodo_obtencion>
    </consumos>
    <consumos>
        <CUPS>ES0022000006150AAAAAAA</CUPS>
        <Fecha>2021/09/07</Fecha>
        <Hora>04:00</Hora>
        <Consumo_kWh>0,085</Consumo_kWh>
        <metodo_obtencion>Real</metodo_obtencion>
    </consumos>
    <consumos>
        <CUPS>ES0022000006150AAAAAAA</CUPS>
        <Fecha>2021/09/07</Fecha>
        <Hora>05:00</Hora>
        <Consumo_kWh>0,08</Consumo_kWh>
        <metodo_obtencion>Real</metodo_obtencion>
    </consumos>
    <consumos>
        <CUPS>ES0022000006150AAAAAAA</CUPS>
        <Fecha>2021/09/07</Fecha>
        <Hora>06:00</Hora>
        <Consumo_kWh>0,092</Consumo_kWh>
        <metodo_obtencion>Real</metodo_obtencion>
    </consumos>
    <consumos>
        <CUPS>ES0022000006150AAAAAAA</CUPS>
        <Fecha>2021/09/07</Fecha>
        <Hora>07:00</Hora>
        <Consumo_kWh>0,106</Consumo_kWh>
        <metodo_obtencion>Real</metodo_obtencion>
    </consumos>
    <consumos>
        <CUPS>ES0022000006150AAAAAAA</CUPS>
        <Fecha>2021/09/07</Fecha>
        <Hora>08:00</Hora>
        <Consumo_kWh>0,696</Consumo_kWh>
        <metodo_obtencion>Real</metodo_obtencion>
    </consumos>
    <consumos>
        <CUPS>ES0022000006150AAAAAAA</CUPS>
        <Fecha>2021/09/07</Fecha>
        <Hora>09:00</Hora>
        <Consumo_kWh>0,559</Consumo_kWh>
        <metodo_obtencion>Real</metodo_obtencion>
    </consumos>
    <consumos>
        <CUPS>ES0022000006150AAAAAAA</CUPS>
        <Fecha>2021/09/07</Fecha>
        <Hora>10:00</Hora>
        <Consumo_kWh>0,51</Consumo_kWh>
        <metodo_obtencion>Real</metodo_obtencion>
    </consumos>
    <consumos>
        <CUPS>ES0022000006150AAAAAAA</CUPS>
        <Fecha>2021/09/07</Fecha>
        <Hora>11:00</Hora>
        <Consumo_kWh>0,231</Consumo_kWh>
        <metodo_obtencion>Real</metodo_obtencion>
    </consumos>
    <consumos>
        <CUPS>ES0022000006150AAAAAAA</CUPS>
        <Fecha>2021/09/07</Fecha>
        <Hora>12:00</Hora>
        <Consumo_kWh>0,178</Consumo_kWh>
        <metodo_obtencion>Real</metodo_obtencion>
    </consumos>
    <consumos>
        <CUPS>ES0022000006150AAAAAAA</CUPS>
        <Fecha>2021/09/07</Fecha>
        <Hora>13:00</Hora>
        <Consumo_kWh>0,166</Consumo_kWh>
        <metodo_obtencion>Real</metodo_obtencion>
    </consumos>
    <consumos>
        <CUPS>ES0022000006150AAAAAAA</CUPS>
        <Fecha>2021/09/07</Fecha>
        <Hora>14:00</Hora>
        <Consumo_kWh>1,089</Consumo_kWh>
        <metodo_obtencion>Real</metodo_obtencion>
    </consumos>
    <consumos>
        <CUPS>ES0022000006150AAAAAAA</CUPS>
        <Fecha>2021/09/07</Fecha>
        <Hora>15:00</Hora>
        <Consumo_kWh>0,463</Consumo_kWh>
        <metodo_obtencion>Real</metodo_obtencion>
    </consumos>
    <consumos>
        <CUPS>ES0022000006150AAAAAAA</CUPS>
        <Fecha>2021/09/07</Fecha>
        <Hora>16:00</Hora>
        <Consumo_kWh>1,292</Consumo_kWh>
        <metodo_obtencion>Real</metodo_obtencion>
    </consumos>
    <consumos>
        <CUPS>ES0022000006150AAAAAAA</CUPS>
        <Fecha>2021/09/07</Fecha>
        <Hora>17:00</Hora>
        <Consumo_kWh>0,856</Consumo_kWh>
        <metodo_obtencion>Real</metodo_obtencion>
    </consumos>
    <consumos>
        <CUPS>ES0022000006150AAAAAAA</CUPS>
        <Fecha>2021/09/07</Fecha>
        <Hora>18:00</Hora>
        <Consumo_kWh>1,202</Consumo_kWh>
        <metodo_obtencion>Real</metodo_obtencion>
    </consumos>
    <consumos>
        <CUPS>ES0022000006150AAAAAAA</CUPS>
        <Fecha>2021/09/07</Fecha>
        <Hora>19:00</Hora>
        <Consumo_kWh>0,11</Consumo_kWh>
        <metodo_obtencion>Real</metodo_obtencion>
    </consumos>
    <consumos>
        <CUPS>ES0022000006150AAAAAAA</CUPS>
        <Fecha>2021/09/07</Fecha>
        <Hora>20:00</Hora>
        <Consumo_kWh>0,207</Consumo_kWh>
        <metodo_obtencion>Real</metodo_obtencion>
    </consumos>
    <consumos>
        <CUPS>ES0022000006150AAAAAAA</CUPS>
        <Fecha>2021/09/07</Fecha>
        <Hora>21:00</Hora>
        <Consumo_kWh>0,474</Consumo_kWh>
        <metodo_obtencion>Real</metodo_obtencion>
    </consumos>
    <consumos>
        <CUPS>ES0022000006150AAAAAAA</CUPS>
        <Fecha>2021/09/07</Fecha>
        <Hora>22:00</Hora>
        <Consumo_kWh>0,309</Consumo_kWh>
        <metodo_obtencion>Real</metodo_obtencion>
    </consumos>
    <consumos>
        <CUPS>ES0022000006150AAAAAAA</CUPS>
        <Fecha>2021/09/07</Fecha>
        <Hora>23:00</Hora>
        <Consumo_kWh>0,352</Consumo_kWh>
        <metodo_obtencion>Real</metodo_obtencion>
    </consumos>
    <consumos>
        <CUPS>ES0022000006150AAAAAAA</CUPS>
        <Fecha>2021/09/07</Fecha>
        <Hora>24:00</Hora>
        <Consumo_kWh>0,326</Consumo_kWh>
        <metodo_obtencion>Real</metodo_obtencion>
    </consumos>
</consumos>

Week consumption (daily):

<?xml version='1.0'?>
<consumos>
    <consumos>
        <CUPS>ES0022000006150AAAAAAA</CUPS>
        <Fecha>2021/09/06</Fecha>
        <Consumo_kWh>11,06</Consumo_kWh>
    </consumos>
    <consumos>
        <CUPS>ES0022000006150AAAAAAA</CUPS>
        <Fecha>2021/09/07</Fecha>
        <Consumo_kWh>10,74</Consumo_kWh>
    </consumos>
</consumos>

Month consumption (daily):

<?xml version='1.0'?>
<consumos>
    <consumos>
        <CUPS>ES0022000006150AAAAAAA</CUPS>
        <Fecha>2020/09</Fecha>
        <Consumo_kWh>430,95</Consumo_kWh>
    </consumos>
    <consumos>
        <CUPS>ES0022000006150AAAAAAA</CUPS>
        <Fecha>2020/10</Fecha>
        <Consumo_kWh>467,49</Consumo_kWh>
    </consumos>
    <consumos>
        <CUPS>ES0022000006150AAAAAAA</CUPS>
        <Fecha>2020/11</Fecha>
        <Consumo_kWh>450,11</Consumo_kWh>
    </consumos>
    <consumos>
        <CUPS>ES0022000006150AAAAAAA</CUPS>
        <Fecha>2020/12</Fecha>
        <Consumo_kWh>466,04</Consumo_kWh>
    </consumos>
    <consumos>
        <CUPS>ES0022000006150AAAAAAA</CUPS>
        <Fecha>2021/01</Fecha>
        <Consumo_kWh>509,24</Consumo_kWh>
    </consumos>
    <consumos>
        <CUPS>ES0022000006150AAAAAAA</CUPS>
        <Fecha>2021/02</Fecha>
        <Consumo_kWh>440,22</Consumo_kWh>
    </consumos>
    <consumos>
        <CUPS>ES0022000006150AAAAAAA</CUPS>
        <Fecha>2021/03</Fecha>
        <Consumo_kWh>467,41</Consumo_kWh>
    </consumos>
    <consumos>
        <CUPS>ES0022000006150AAAAAAA</CUPS>
        <Fecha>2021/04</Fecha>
        <Consumo_kWh>426,41</Consumo_kWh>
    </consumos>
    <consumos>
        <CUPS>ES0022000006150AAAAAAA</CUPS>
        <Fecha>2021/05</Fecha>
        <Consumo_kWh>385,09</Consumo_kWh>
    </consumos>
    <consumos>
        <CUPS>ES0022000006150AAAAAAA</CUPS>
        <Fecha>2021/06</Fecha>
        <Consumo_kWh>315,9</Consumo_kWh>
    </consumos>
    <consumos>
        <CUPS>ES0022000006150AAAAAAA</CUPS>
        <Fecha>2021/07</Fecha>
        <Consumo_kWh>334,84</Consumo_kWh>
    </consumos>
    <consumos>
        <CUPS>ES0022000006150AAAAAAA</CUPS>
        <Fecha>2021/08</Fecha>
        <Consumo_kWh>163,42</Consumo_kWh>
    </consumos>
    <consumos>
        <CUPS>ES0022000006150AAAAAAA</CUPS>
        <Fecha>2021/09</Fecha>
        <Consumo_kWh>88,76</Consumo_kWh>
    </consumos>
</consumos>

Additionally, you can download master/consumption data from Datadis:

<?xml version='1.0'?>
<datoscontractuales>
    <datoscontractuales>
        <CUPS>ES0022000006150AAAAAAA</CUPS>
        <distribuidora>UFD</distribuidora>
        <comercializadora>COMERCIALIZADORA REGULADA, GAS &amp; POWER, S.A.</comercializadora>
        <tarifaAcceso>2.0TD PEAJE ATR</tarifaAcceso>
        <tensionConexion>Baja 220</tensionConexion>
        <potenciaContratadakW>5,5</potenciaContratadakW>
        <modoControlPotencia/>
        <discriminacionHoraria/>
        <fechaInicioVigencia>1981/10/30</fechaInicioVigencia>
        <fechafinVigencia/>
        <provincia>MADRID</provincia>
        <municipio>MADRID-MADRID</municipio>
        <codigoPostal>28033</codigoPostal>
    </datoscontractuales>
</datoscontractuales>

Step-by-Step description – putting knowledge into code

[TO_BE_DONE]

Leave a comment