ESIOS indicator 1342
Demanda en La Palma
HoraEnergíaLive
Energía de adquisición en el subsistema de La Palma perteneciente al sistema no peninsular de Canarias.
Publicación: diariamente a las 7:45 con los datos del día D-2.
Coverage2026-11-13
Publication lag3 days
ZonesLa Palma
Query it
The last week with data, filtered by this indicator. Always filter by indicator_id: the table holds every indicator.
SELECT
datetime,
geo_name,
value
FROM esios.indicators
WHERE indicator_id = 1342
AND datetime >= '2026-11-07' AND datetime < '2026-11-14'
ORDER BY datetime, geo_namefrom joltio import Client
client = Client() # JOLTIO_API_KEY
result = client.data.query("""SELECT
datetime,
geo_name,
value
FROM esios.indicators
WHERE indicator_id = 1342
AND datetime >= '2026-11-07' AND datetime < '2026-11-14'
ORDER BY datetime, geo_name""")
print(result)SQL=$(cat <<'SQL'
SELECT
datetime,
geo_name,
value
FROM esios.indicators
WHERE indicator_id = 1342
AND datetime >= '2026-11-07' AND datetime < '2026-11-14'
ORDER BY datetime, geo_name
SQL
)
curl https://api.joltio.app/data/query \
-H "X-API-Key: $JOLTIO_API_KEY" \
--json "$(jq -n --arg sql "$SQL" '{sql: $sql}')"Recent revisions
2026-11-15 09:012026-11-10 – 2026-11-126 changed · 0 gaps filled · 0 removed2026-11-11 09:012026-11-06 – 2026-11-0811 changed · 0 gaps filled · 0 removed2026-11-03 18:002026-10-31 – 2026-11-018 changed · 0 gaps filled · 0 removed2026-10-30 18:002026-10-27 – 2026-10-2823 changed · 0 gaps filled · 0 removed2026-10-29 15:542026-03-01 – 2026-05-311178 changed · 0 gaps filled · 0 removed