31:Te06,({ version: "2.0", class: "dataset", label: "Area by NUTS 3 region", source: "ESTAT", updated: "2025-02-14T23:00:00+0100", value: { "0": 30667 }, id: ["freq", "landuse", "unit", "geo", "time"], size: [1, 1, 1, 1, 1], dimension: { freq: { label: "Time frequency", category: { index: { A: 0 }, label: { A: "Annual" } } }, landuse: { label: "Land use", category: { index: { TOTAL: 0 }, label: { TOTAL: "Total area" } } }, unit: { label: "Unit of measure", category: { index: { KM2: 0 }, label: { KM2: "Square kilometre" } } }, geo: { label: "Geopolitical entity (reporting)", category: { index: { BE: 0 }, label: { BE: "Belgium" } } }, time: { label: "Time", category: { index: { "2025": 0 }, label: { "2025": "2025" } } } }, extension: { lang: "EN", id: "REG_AREA3", agencyId: "ESTAT", version: "1.0", datastructure: { id: "REG_AREA3", agencyId: "ESTAT", version: "33.0" }, annotation: [ { type: "CREATED", date: "2017-12-19T16:08:14+0100" }, { type: "DISSEMINATION_DOI_XML", title: '\u003Cadms:identifier xmlns:adms="http://www.w3.org/ns/adms#" xmlns:skos="http://www.w3.org/2004/02/skos/core.html" xmlns:dct="http://purl.org/dc/terms/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#"\u003E\u003Cadms:Identifier rdf:about="https://doi.org/10.2908/REG_AREA3"\u003E\u003Cskos:notation rdf:datatype="http://purl.org/spar/datacite/doi"\u003E10.2908/REG_AREA3\u003C/skos:notation\u003E\u003Cdct:creator rdf:resource="http://publications.europa.eu/resource/authority/corporate-body/ESTAT"/\u003E\u003Cdct:issued rdf:datatype="http://www.w3.org/2001/XMLSchema#date"\u003E2023-01-19\u003C/dct:issued\u003E\u003C/adms:Identifier\u003E\u003C/adms:identifier\u003E' }, { type: "DISSEMINATION_OBJECT_TYPE", title: "DATASET" }, { type: "DISSEMINATION_TIMESTAMP_DATA", date: "2025-02-14T23:00:00+0100" }, { type: "DISSEMINATION_TIMESTAMP_GLOBAL", date: "2025-04-10T23:00:00+0200" }, { type: "DISSEMINATION_TIMESTAMP_PLANNED", date: "2025-04-10T23:00:00+0200" }, { type: "ESMS_HTML", title: "Explanatory texts (metadata)", href: "https://ec.europa.eu/eurostat/cache/metadata/en/reg_area3_esms.htm" }, { type: "ESMS_SDMX", title: "Explanatory texts (metadata)", href: "https://ec.europa.eu/eurostat/api/dissemination/files?file=metadata/reg_area3_esms.sdmx.zip" }, { type: "OBS_COUNT", title: "50224" }, { type: "OBS_PERIOD_OVERALL_LATEST", title: "2025" }, { type: "OBS_PERIOD_OVERALL_OLDEST", title: "2013" }, { type: "SOURCE_INSTITUTIONS", text: "Eurostat" }, { type: "UPDATE_DATA", date: "2025-02-14T23:00:00+0100" }, { type: "UPDATE_STRUCTURE", date: "2025-02-14T23:00:00+0100" } ], "positions-with-no-data": { freq: [], landuse: [], unit: [], geo: [], time: [] } } })32:Td32,countries = [ // --- EU Member States --- { code: "AT", latitude: 47.516231, longitude: 14.550072, name: "Austria" }, { code: "BE", latitude: 50.503887, longitude: 4.469936, name: "Belgium" }, { code: "BG", latitude: 42.733883, longitude: 25.48583, name: "Bulgaria" }, { code: "HR", latitude: 45.1, longitude: 15.2, name: "Croatia" }, { code: "CY", latitude: 35.126413, longitude: 33.429859, name: "Cyprus" }, { code: "CZ", latitude: 49.817492, longitude: 15.472962, name: "Czechia" }, { code: "DK", latitude: 56.26392, longitude: 9.501785, name: "Denmark" }, { code: "EE", latitude: 58.595272, longitude: 25.013607, name: "Estonia" }, { code: "FI", latitude: 61.92411, longitude: 25.748151, name: "Finland" }, { code: "FR", latitude: 46.603354, longitude: 1.888334, name: "France" }, { code: "DE", latitude: 51.165691, longitude: 10.451526, name: "Germany" }, { code: "EL", latitude: 39.074208, longitude: 21.824312, name: "Greece" }, // Eurostat uses EL, not GR { code: "HU", latitude: 47.162494, longitude: 19.503304, name: "Hungary" }, { code: "IE", latitude: 53.41291, longitude: -8.24389, name: "Ireland" }, { code: "IT", latitude: 41.87194, longitude: 12.56738, name: "Italy" }, { code: "LV", latitude: 56.879635, longitude: 24.603189, name: "Latvia" }, { code: "LT", latitude: 55.169438, longitude: 23.881275, name: "Lithuania" }, { code: "LU", latitude: 49.815273, longitude: 6.129583, name: "Luxembourg" }, { code: "MT", latitude: 35.937496, longitude: 14.375416, name: "Malta" }, { code: "NL", latitude: 52.132633, longitude: 5.291266, name: "Netherlands" }, { code: "PL", latitude: 51.919438, longitude: 19.145136, name: "Poland" }, { code: "PT", latitude: 39.399872, longitude: -8.224454, name: "Portugal" }, { code: "RO", latitude: 45.943161, longitude: 24.96676, name: "Romania" }, { code: "SK", latitude: 48.669026, longitude: 19.699024, name: "Slovakia" }, { code: "SI", latitude: 46.151241, longitude: 14.995463, name: "Slovenia" }, { code: "ES", latitude: 40.463667, longitude: -3.74922, name: "Spain" }, { code: "SE", latitude: 60.128161, longitude: 18.643501, name: "Sweden" }, // --- EFTA --- { code: "IS", latitude: 64.963051, longitude: -19.020835, name: "Iceland" }, { code: "LI", latitude: 47.166, longitude: 9.555373, name: "Liechtenstein" }, { code: "NO", latitude: 60.472024, longitude: 8.468946, name: "Norway" }, { code: "CH", latitude: 46.818188, longitude: 8.227512, name: "Switzerland" }, // --- Candidates & potential candidates --- { code: "AL", latitude: 41.153332, longitude: 20.168331, name: "Albania" }, { code: "BA", latitude: 43.915886, longitude: 17.679076, name: "Bosnia and Herzegovina" }, { code: "ME", latitude: 42.708678, longitude: 19.37439, name: "Montenegro" }, { code: "MK", latitude: 41.608635, longitude: 21.745275, name: "North Macedonia" }, { code: "RS", latitude: 44.016521, longitude: 21.005859, name: "Serbia" }, { code: "TR", latitude: 38.963745, longitude: 35.243322, name: "Türkiye" }, { code: "UA", latitude: 48.379433, longitude: 31.16558, name: "Ukraine" }, { code: "MD", latitude: 47.411631, longitude: 28.369885, name: "Moldova" }, { code: "GE", latitude: 42.315407, longitude: 43.356892, name: "Georgia" }, { code: "XK", latitude: 42.602636, longitude: 20.902977, name: "Kosovo*" } ]33:T9d7,getAllStats = { // Helper to fetch + index one URL for a given country code const fetchStat = async (code, url) => { const results = await fromEurostat(url); return results[0].value ?? null; }; // Build per-country tasks (each country fetches all needed endpoints in parallel) const countryTasks = countries.map(({ code }) => (async () => { const urls = { area: `https://ec.europa.eu/eurostat/api/dissemination/statistics/1.0/data/reg_area3?format=JSON&geo=${encodeURIComponent( code )}&unit=KM2&landuse=TOTAL&lang=EN`, population: `https://ec.europa.eu/eurostat/api/dissemination/statistics/1.0/data/tps00001?format=JSON&indic_de=JAN&lang=EN&geo=${encodeURIComponent( code )}`, lifeExpectancy: `https://ec.europa.eu/eurostat/api/dissemination/statistics/1.0/data/tps00205?format=JSON&geo=${encodeURIComponent( code )}&unit=YR&sex=T&age=Y_LT1&lang=EN`, unemployment: `https://ec.europa.eu/eurostat/api/dissemination/statistics/1.0/data/lfst_r_lfu3rt?format=json&lang=en&isced11=TOTAL&sex=T&age=Y_GE25&time=2024&geo=${encodeURIComponent( code )}`, GDP: `https://ec.europa.eu/eurostat/api/dissemination/statistics/1.0/data/nama_10r_3gdp?format=json&lang=en&unit=MIO_EUR&time=2023&geo=${encodeURIComponent( code )}`, GDPPerCapita: `https://ec.europa.eu/eurostat/api/dissemination/statistics/1.0/data/nama_10r_3gdp?format=json&lang=en&unit=EUR_HAB&time=2023&geo=${encodeURIComponent( code )}` }; // Fetch all in parallel for this country (fail-soft with Promise.allSettled) const entries = await Promise.allSettled( Object.entries(urls).map(async ([k, url]) => [ k, await fetchStat(code, url) ]) ); // Collect results (null on failures) const obj = {}; for (const r of entries) { if (r.status === "fulfilled") { const [k, v] = r.value; obj[k] = v; } else { // optional: log or mark as null on failure // console.warn(`Failed ${code} ${k}`, r.reason); const k = r.reason?.value?.[0] ?? null; // not always available if (k && typeof k === "string") obj[k] = null; } } return [code, obj]; })() ); // Wait for all countries const pairs = await Promise.all(countryTasks); // Build the final map { code: {...stats} } return Object.fromEntries(pairs); }34:[] 2f:{"title":"Eurostat statistics API","cells":[{"id":0,"value":"# Eurostat statistics API","pinned":false,"hidden":false,"mode":"md"},{"id":5,"value":"Lets get hands on with the [Eurostat statistics API](https://ec.europa.eu/eurostat/web/user-guides/data-browser/api-data-access/api-getting-started#statistics_API) and pull in some stats!","pinned":false,"hidden":false,"mode":"md"},{"id":103,"value":"viewof country = Inputs.select(\n countries.map((c) => c.name),\n { label: \"Select a country\" }\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":83,"value":"

Factsheet

\n \n \n \n \n \n \n \n \n

Area	${area ? area.toLocaleString() + ' km²' : 'not available'}
Population	${population ? population.toLocaleString(): 'not available'}
Life Expectancy	${lifeExpectancy ?lifeExpectancy + ' years': 'not available'}
Unemployment Rate	${unemployment ?unemployment + '%': 'not available'}
Gross Domestic Product (GDP)	${GDP ? '€' + formatter.format((GDP*1000000)) + '': 'not available'}
GDP per Capita	${GDPPerCapita ? '€' + GDPPerCapita.toLocaleString():'not available'}
Sheep population	${sheep ? (sheep*1000).toLocaleString() + ' sheep':'not available'}

","pinned":false,"hidden":false,"mode":"html"},{"id":11,"value":"You can use the [query builder](https://ec.europa.eu/eurostat/web/query-builder/tool) to build API calls like so: https://ec.europa.eu/eurostat/api/dissemination/statistics/1.0/data/reg_area3?format=JSON&geo=BE&unit=KM2&landuse=TOTAL&lang=EN&TIME=2025","pinned":false,"hidden":false,"mode":"md"},{"id":133,"value":"Which will give you a [jsonstat](https://json-stat.org/) response like this:","pinned":false,"hidden":false,"mode":"md"},{"id":136,"value":"$31","pinned":false,"hidden":false,"mode":"ojs"},{"id":274,"value":"### Jsonstat-toolkit","pinned":false,"hidden":false,"mode":"md"},{"id":259,"value":"You can format these responses using [jsonstat-toolkit](https://jsonstat.com/)","pinned":false,"hidden":false,"mode":"md"},{"id":263,"value":"url = \"https://ec.europa.eu/eurostat/api/dissemination/statistics/1.0/data/tesem120?lang=en&time=2024&time=2023\"","pinned":true,"hidden":false,"mode":"ojs"},{"id":276,"value":"dataset = JSONstat(url)","pinned":true,"hidden":false,"mode":"ojs"},{"id":285,"value":"belgiumCategory = dataset.Dimension(\"geo\").Category(\"BE\")","pinned":true,"hidden":false,"mode":"ojs"},{"id":279,"value":"dataPoint = dataset.Data(belgiumCategory.index)","pinned":true,"hidden":false,"mode":"ojs"},{"id":291,"value":"filtered = dataset.Dice({ time: [\"2024\"] }, { clone: true }) // filter the dataset (e.g. extract a specific year)","pinned":true,"hidden":false,"mode":"ojs"},{"id":293,"value":"data = filtered.toTable({ type: \"arrobj\" }) // convert to array of objects","pinned":true,"hidden":false,"mode":"ojs"},{"id":272,"value":"For more information please refer to this notebook: https://observablehq.com/@jsonstat/toolkit","pinned":false,"hidden":false,"mode":"md"},{"id":63,"value":"## Stats","pinned":false,"hidden":false,"mode":"md"},{"id":145,"value":"Here are the requests we made to populate our factsheet...","pinned":false,"hidden":false,"mode":"md"},{"id":31,"value":"area = getValue(\n await fromEurostat(\n `https://ec.europa.eu/eurostat/api/dissemination/statistics/1.0/data/reg_area3?format=JSON&geo=${selectedCountryCode}&unit=KM2&landuse=TOTAL&lang=EN&TIME=2025`\n )\n)","pinned":true,"hidden":false,"mode":"ojs"},{"id":58,"value":"population = getValue(\n await fromEurostat(\n `https://ec.europa.eu/eurostat/api/dissemination/statistics/1.0/data/tps00001?format=JSON&indic_de=JAN&lang=EN&geo=${selectedCountryCode}`\n )\n)","pinned":true,"hidden":false,"mode":"ojs"},{"id":66,"value":"lifeExpectancy = getValue(\n await fromEurostat(\n `https://ec.europa.eu/eurostat/api/dissemination/statistics/1.0/data/tps00205?format=JSON&geo=${selectedCountryCode}&unit=YR&sex=T&age=Y_LT1&lang=EN`\n )\n)","pinned":true,"hidden":false,"mode":"ojs"},{"id":71,"value":"unemployment = getValue(\n await fromEurostat(\n `https://ec.europa.eu/eurostat/api/dissemination/statistics/1.0/data/lfst_r_lfu3rt?format=json&lang=en&isced11=TOTAL&sex=T&age=Y_GE25&time=2024&geo=${selectedCountryCode}`\n )\n)","pinned":true,"hidden":false,"mode":"ojs"},{"id":74,"value":"GDP = getValue(\n await fromEurostat(\n `https://ec.europa.eu/eurostat/api/dissemination/statistics/1.0/data/nama_10r_3gdp?format=json&lang=en&unit=MIO_EUR&time=2023&geo=${selectedCountryCode}`\n )\n)","pinned":true,"hidden":false,"mode":"ojs"},{"id":80,"value":"GDPPerCapita = getValue(\n await fromEurostat(\n `https://ec.europa.eu/eurostat/api/dissemination/statistics/1.0/data/nama_10r_3gdp?format=json&lang=en&unit=EUR_HAB&time=2023&geo=${selectedCountryCode}`\n )\n)","pinned":true,"hidden":false,"mode":"ojs"},{"id":160,"value":"sheep = getValue(\n await fromEurostat(\n `https://ec.europa.eu/eurostat/api/dissemination/statistics/1.0/data/agr_r_animal?format=JSON&unit=THS_HD&animals=A4100&lang=EN&TIME=2024&geo=${selectedCountryCode}`\n )\n)","pinned":true,"hidden":false,"mode":"ojs"},{"id":19,"value":"$32","pinned":false,"hidden":false,"mode":"ojs"},{"id":110,"value":"$33","pinned":false,"hidden":false,"mode":"ojs"},{"id":50,"value":"### Helpers","pinned":false,"hidden":false,"mode":"md"},{"id":223,"value":"// we are only requesting one record, so its always the first item in the response array\ngetValue = (results) => (results[0] ? results[0].value : null)","pinned":true,"hidden":false,"mode":"ojs"},{"id":43,"value":"// convert eurostat API response into an array of objects\n// e.g. [{id: \"AT\", label: \"Austria\", value: 390.94}]\nasync function fromEurostat(query) {\n const result = await d3.json(query);\n const category = result.dimension.geo.category;\n return Object.keys(category.index).map((key) => ({\n id: key,\n label: category.label[key],\n value: result.value[category.index[key]]\n }));\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":172,"value":"formatter = new Intl.NumberFormat(undefined, {\n notation: \"compact\", // \"compact\" gives \"1M\" / \"1 million\"\n compactDisplay: \"long\" // \"short\" = \"1M\", \"long\" = \"1 million\"\n})","pinned":true,"hidden":false,"mode":"ojs"},{"id":177,"value":"flagUrl = selectedCountryCode.toLowerCase() == \"el\"\n ? `https://flagcdn.com/w80/gr.png`\n : `https://flagcdn.com/w80/${selectedCountryCode.toLowerCase()}.png` // 160px wide, expection for greece (uses GR code)","pinned":true,"hidden":false,"mode":"ojs"},{"id":39,"value":"selectedCountryCode = countries.find((d) => d.name == country).code","pinned":false,"hidden":false,"mode":"ojs"},{"id":25,"value":"import { autoSelect } from \"@jashkenas/inputs\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":265,"value":"JSONstat = require(\"jsonstat-toolkit@2.0.0\").catch(() => window[\"JSONstat\"])","pinned":true,"hidden":false,"mode":"ojs"},{"id":252,"value":"Kosovo* - This designation is without prejudice to positions on status, and is in line with UNSCR 1244/1999 and the ICJ Opinion on the Kosovo declaration of independence.","pinned":false,"hidden":false,"mode":"md"}],"files":"$W34","stdlib":"1","titling":"auto"}