Eurostat Electricity Prices for Household Consumers

Semi-annual electricity prices for household consumers across European countries by consumption band, tax component, and currency, Eurostat table nrg_pc_204. Non-geospatial companion table, join key is the country code column geo (NUTS-0), converted to cloud-native Parquet.

What households pay for electricity across Europe, semester by semester since 2007. This is Eurostat table nrg_pc_204, 65,412 observations covering 41 countries and territories plus the EU27 and euro area aggregates, collected under Regulation (EU) 2016/1952 as consumption-weighted national average prices per six-month period. New semesters land each April and October, and Eurostat's own price statistics article is written from this table. It is the official record of the 2022 energy crisis, Germany's all-tax price for a typical household rose from 0.33 to a 0.41 euro per kilowatt-hour peak in the first half of 2023.

Agents, AGENTS.md decodes every dimension and carries the aggregate-row trap.

Quick Start

The data asset is plain Parquet, so pandas, DuckDB, and Polars all read it directly. Paths are relative to this directory, and the same code works against the published URL.

Reading a Price Correctly

Every price is qualified by four dimensions, and comparisons only mean something within a fixed combination. The band, how much the household consumes per year, where KWH2500-4999 is the band Eurostat headlines. The tax level, X_TAX before taxes, X_VAT before VAT, I_TAX what a household actually pays. The currency, where EUR is nominal, NAC is national currency, and PPS adjusts for price levels, Bulgaria's 2025-S2 price is 0.14 EUR but 0.22 PPS, and the gap is the point. And the semester string, 2025-S2 meaning July to December 2025.

Schema

The same descriptions live in table:columns on the collection, so tools that read STAC see them too.

Join to Geometry

This table carries no geometry. The geo codes join to the Natural Earth countries Collection in this catalog on ISO_A2_EH, after remapping Eurostat's two non-ISO codes. Greece is EL and the United Kingdom is UK. The raw ISO_A2 column would silently drop France, Norway, and Kosovo, Natural Earth stores -99 there.

Malta and Liechtenstein stay unmatched, the 1:110m basemap has no polygon for them, and the EU27_2020 and EA aggregates have no geometry by nature.

Limitations

These are averages over suppliers and six months, not offers, Eurostat itself notes there is no single price for electricity. One number per country per semester, nothing sub-national. Values from the second half of 2021 onward embed government subsidies and caps, so 2022 to 2024 understate underlying costs in heavily supported countries, and Romania's 59 percent jump in late 2025 is a cap ending, not a market shock. Data before 2007 lives in a separate, methodologically incompatible table, never splice them.

Provenance and License

License, CC-BY-4.0. Attribution, Source, Eurostat. Providers, Eurostat (producer, licensor), Portolan SDI (host). Original source, https://ec.europa.eu/eurostat/api/dissemination/sdmx/2.1/data/nrg_pc_204/?format=SDMX-CSV&compressed=false . Rows, 65,466. Columns, 13. Cloud-native asset, eurostat-electricity-prices.parquet (Parquet). Non-geospatial table, the bounding box is the area of interest the data pertains to, [-31.5, 34.0, 46.5, 71.5]. The upstream source is a live endpoint, so it is referenced by URL only and not archived as a source asset.