eurostat.consumer_spend
stable Standard
Household consumption spending by purpose (COICOP category) for up to 10 European countries plus the EU27 aggregate, annual, as a JSON-stat cube.
GET /v1/eurostat/consumer_spend
What you get#
One Eurostat record in Onekey's unified shape, in data. If the record does not exist you get a 404 not_found and are not charged.
What it costs#
- Standard · 1 credit for a fresh fetch, charged only when it succeeds.
- Free when served from cache (0.2 credit for a cached response over 100 KB).
- Free if the request is invalid (never charged) or the source fails or reports not found (refunded).
Parameters#
| Name | Type | Required | Default | What it is | Constraints |
|---|---|---|---|---|---|
geo | string | no | EU27_2020 | Reporting country codes joined by + (URL-encode it as %2B), up to 11: two-letter Eurostat codes (DE, FR, EL for Greece...) and/or EU27_2020 / EA20, e.g. DE%2BFR%2BEU27_2020 | max 120 chars; must match (?:[A-Z]{2}|EU27_2020|EA20)(?:\+(?:[A-Z]{2}|EU27_2020|EA20)){0,10}; trimmed, upper |
coicop | string | no | TOTAL | COICOP 1999 purpose code, e.g. TOTAL, CP01 (food and non-alcoholic beverages), CP07 (transport), CP11 (restaurants and hotels), CP111 (catering) | max 10 chars; must match TOTAL|CP(?:0[1-9]|1[0-2])\d?|CP122_127; trimmed, upper |
unit | string | no | CP_MEUR | Unit of measure: CP_MEUR (current prices, million euro), CP_MNAC (million national currency), CP_EUR_HAB / CP_NAC_HAB (per capita), PC_TOT (share of total), PC_GDP (share of GDP), CLV20_MEUR / CLV15_MEUR (chain-linked volumes), CLV_PCH_PRE (volume change on previous year), PD20_EUR (price index 2020=100) | max 16 chars; must match CP_MEUR|CP_MNAC|CP_EUR_HAB|CP_NAC_HAB|PC_TOT|PC_GDP|CLV20_MEUR|CLV15_MEUR|CLV10_MEUR|CLV20_MNAC|CLV15_MNAC|CLV10_MNAC|CLV_I20|CLV_I15|CLV_PCH_PRE|PYP_MEUR|PYP_MNAC|PD20_EUR|PD15_EUR|PD20_NAC|PD15_NAC|PD_PCH_PRE_EUR|PD_PCH_PRE_NAC; trimmed, upper |
start | string | no | 2015 | First year (YYYY) | max 4 chars; must match (?:19[5-9]\d|20\d{2}); trimmed |
end | string | no | 2100 | Last year (YYYY); the default 2100 means the latest year published | max 4 chars; must match (?:19[5-9]\d|20\d{2}|2100); trimmed |
Request#
curl "https://api.onekey.dev/v1/eurostat/consumer_spend?geo=DE%2BFR%2BEU27_2020&coicop=CP01&start=2020" \
-H "x-api-key: YOUR_API_KEY"Try it
Add your key to run this call right here. No key? Get one free. The key stays in this tab.
Recorded response#
A real Eurostat response, recorded and returned in Onekey's shape. Fields the platform does not provide are null.
{
"success": true,
"data": {
"entity": {
"name": "Household final consumption expenditure by purpose (COICOP 1999)"
},
"ext": {
"updated": "2026-10-21T23:00:00+0200",
"dimensions": [
"freq",
"unit",
"coicop",
"geo",
"time"
],
"size": [
1,
1,
1,
3,
6
],
"values": {
"0": 1005677.9,
"1": 1029814.4,
"2": 1110216.7,
"6": 194450,
"7": 200574,
"8": 216357,
"12": 177214,
"13": 176438,
"14": 182900
},
"flags": {
"6": "p",
"7": "p",
"8": "p",
"13": "p",
"14": "p"
},
"geo": {
"index": {
"EU27_2020": 0,
"DE": 1,
"FR": 2
},
"label": {
"EU27_2020": "European Union - 27 countries (from 2020)",
"DE": "Germany",
"FR": "France"
}
},
"time": {
"index": {
"2020": 0,
"2021": 1,
"2022": 2,
"2023": 3,
"2024": 4,
"2025": 5
},
"label": {
"2020": "2020",
"2021": "2021",
"2022": "2022",
"2023": "2023",
"2024": "2024",
"2025": "2025"
}
},
"coicop": {
"index": {
"CP01": 0
},
"label": {
"CP01": "Food and non-alcoholic beverages"
}
},
"unit": {
"index": {
"CP_MEUR": 0
},
"label": {
"CP_MEUR": "Current prices, million euro"
}
}
}
},
"metadata": {
"platform": "eurostat",
"endpoint": "consumer_spend",
"cached": false,
"stale": false,
"age_s": 0,
"fetched_at": "2026-01-01T12:00:00+00:00",
"credits_charged": 1,
"request_id": "7f3a9c2e5b1d4c8fa2e6d0b9c4f18e37"
},
"error": null
}Field mapping#
How this endpoint's source fields become Onekey's unified schema. Fields the source lacks come back as null.
| Source path | Onekey field | Transform |
|---|---|---|
label | entity.name | - |
updated | ext.updated | - |
id | ext.dimensions | - |
size | ext.size | - |
value | ext.values | - |
status | ext.flags | - |
dimension.geo.category | ext.geo | - |
dimension.time.category | ext.time | - |
dimension.coicop.category | ext.coicop | - |
dimension.unit.category | ext.unit | - |
Caching and freshness#
- Fresh for about 6 hours. Repeat calls in that window are served from cache and are free.
- Between 6 hours and 7 days the cached copy is still served instantly and marked
stale: truewhile Onekey refreshes it in the background. - If the source is down when a refresh is needed, the last copy can be served for up to 7 days more (marked stale).
- A "not found" is remembered for 1 hour and is free.
- The cache is shared across all customers, which is what keeps repeat calls cheap.
What can go wrong#
| Status | Code | What to do |
|---|---|---|
| 401 | unauthorized | Check the x-api-key header. |
| 402 | insufficient_credits | Add credits; your balance must cover the price. |
| 404 | not_found | That record does not exist. Free; do not retry. |
| 422 | invalid_params | Fix the parameters using the table above. Free. |
| 429 | rate_limited | Wait Retry-After seconds, then retry. |
| 502 | upstream_error | The source failed. Refunded; retry with backoff. |
See Errors for the full list and retry guidance.
Status: stable (verified against the live source).