ESIOS indicator 1821
Generación T.Real enlace Mallorca-Menorca SNP
Cinco minutosPotenciaLive
Generación medida en tiempo real en el enlace Mallorca-Menorca en el sistema Balear.
Publicación: cada 10 minutos con la información de las tres últimas horas del día D-1 hasta la hora actual del día D.
Coverage2026-11-16
Publication lagSame day
ZonesBaleares
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 = 1821
AND datetime >= '2026-11-10' AND datetime < '2026-11-17'
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 = 1821
AND datetime >= '2026-11-10' AND datetime < '2026-11-17'
ORDER BY datetime, geo_name""")
print(result)SQL=$(cat <<'SQL'
SELECT
datetime,
geo_name,
value
FROM esios.indicators
WHERE indicator_id = 1821
AND datetime >= '2026-11-10' AND datetime < '2026-11-17'
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 23:212026-11-12 – 2026-11-151 changed · 0 gaps filled · 0 removed2026-11-12 08:332026-11-11 – 2026-11-111 changed · 0 gaps filled · 0 removed2026-11-11 08:332026-11-09 – 2026-11-091 changed · 0 gaps filled · 0 removed2026-11-09 08:312026-11-07 – 2026-11-071 changed · 0 gaps filled · 0 removed2026-11-07 23:522026-11-04 – 2026-11-071 changed · 0 gaps filled · 0 removed