Eurostat statistics
ec.europa.eu/eurostat/web/main
European official statistics from Eurostat, whole-office scope: each data product the EU statistical office disseminates becomes its own DuckDB table, named after its Eurostat code, with that dataset's own dimensions (geo, unit, age, sex, na_item, coicop, siec…) as real columns — so `SELECT geo, period, value FROM tps00001` reads like the indicator it is about instead of decoding a series key. The office publishes 7,570 of them and the `catalogue` table carries a row for every one; how many a deployment actually fetches is bounded by its `maxCells` parameter, and `catalogue.loaded` is the column that says which products have a table here. Each table is described from Eurostat's own catalogue metadata: title, theme path, product type, covered period range and cube size. Two companions come with them: `catalogue`, the complete Eurostat table of contents with update dates, coverage and ready-made browser and API links, and `geographies`, decoding every reporting geo code (countries, candidates, EFTA, EU and euro-area aggregates) into English names. Periods keep Eurostat's own coding alongside a sortable start date, values keep Eurostat's revision flags, and figures are merged in place on every run because Eurostat revises what it has published.
CC-BY-4.0Creative Commons Attribution 4.0 International
Attribution, terms and provenanceWhat you must carry if you reuse this
- Attribution
- Source of data: Eurostat (https://ec.europa.eu/eurostat)
- Notes
- Eurostat authorises reuse of its statistical data and metadata for commercial and non-commercial purposes provided the source is acknowledged (Commission Decision 2011/833/EU; site content licensed CC BY 4.0). Everything this connector republishes is Eurostat-produced statistics and metadata disseminated through its own public API (source agency ESTAT); Eurostat's general permission does not extend to material it identifies as belonging to third parties, which this connector does not republish. Values are republished as retrieved, with Eurostat's own revision flags in the status column of each dataset table; modified representations of the data must be identified as such to end users. Cite a dataset by its Eurostat code: the code names both the lake table here and the source dataset, and catalogue.dataset_url links its landing page on Eurostat's site, from which Eurostat's own DOI for it is reachable.
- Version
- snapshot 2026-09-03 · 01M1KKH2CDPTKF23E29A33KP5R
- Machine-readable:
- llms.txtmanifest.jsoncatalog
Tables
Open a table for its columnsLoading the schema…
Queries
Copy a snippet, or run it in the playgroundQuery it yourselfConnection snippets for DuckDB — Parquet or the live lake
Generated from this exact manifest version, so the URLs are the ones actually published.
ATTACH IF NOT EXISTS 'ducklake:https://data-directory.fsn1.your-objectstorage.com/catalog/catalog.ducklake' AS "datadirectory" (READ_ONLY);
SELECT *
FROM datadirectory.eurostat.aact_ali01
LIMIT 10;