Agent Guidance, Eurostat Electricity Prices for Household Consumers
Semi-annual household electricity prices, one row per combination of
consumption band, tax level, currency, country, and semester, verified
unique on those five. Filter all five dimensions before comparing
anything. The headline combination is nrg_cons = 'KWH2500-4999',
tax = 'I_TAX', currency = 'EUR'.
Query the Parquet data asset in place with DuckDB, read_parquet('eurostat-electricity-prices.parquet'), or load it with pandas.
Quirks
EU27_2020 and EA sit in geo alongside countries, so unfiltered
rankings place the EU average mid-table as if it were a country.
Exclude them for country-level analysis.
The LAST UPDATE column is frozen at one 2019 timestamp on all 65,412
rows of this snapshot while data runs to 2025-S2. It also has a space
in its name, quote it as "LAST UPDATE".
The panel is ragged. The UK stops after 2020-S1, Ukraine after
2021-S1, Iceland lags a semester, and 2007-S1 has only 8 reporters.
TOT_KWH is itself a weighted average of the five bands and exists
only from 2017-S2. Never mix it into a band aggregate.
For euro-area countries NAC duplicates EUR, so counting rows across
currencies triple-counts observations.
About 2 percent of rows carry flags, e estimated, p provisional, d
definition differs, and provisional values are revised in later
snapshots, so this fixed copy can disagree with the live API on
recent semesters.
Tested Queries
Latest prices ranked, aggregates excluded.
A time series with real dates from the semester strings.
The tax ladder, what levies add.
Related Collections
reference/natural-earth-countries is the geometry partner, join
recipe in the README of this Collection. Sibling Eurostat tables
outside this catalog, nrg_pc_205 for non-household prices and
nrg_pc_204_c for price components, share the same dimension scheme.
Converted from Eurostat's SDMX-CSV API output, a live endpoint, to
Parquet with DuckDB on July 21, 2026.