How to Use Eurostat dataset observations in VS Code
Returns filtered observations from a selected Eurostat dataset in structured JSON-stat data. Use it when you need a specific combination of countries, periods, units, and categories beyond the dedicated price comparisons.
Prompts to try with Eurostat dataset observations in VS Code
Copy an example into VS Code, or ask in your own words.
Use Eurostat dataset observations to retrieve 2022–2024 food and non-alcoholic beverage price level indices from prc_ppp_ind_1 for Germany and France, then save a CSV with readable labels.
Use Eurostat dataset observations to look this up and give me the result as a table. Save the result in ./assets.
Pull the latest numbers from Eurostat dataset observations and tell me what changed since last week.
Check Eurostat dataset observations and summarize what you find in three bullet points.
Pull the newest data from Eurostat dataset observations and give me the result as a table.
How to set up Eurostat dataset observations in VS Code
Pick the way that suits you. Each takes about two minutes.
Use Spiral's MCP server
- Add the hosted server
Use Add to VS Code on the console's Agents & MCP page, or run:
code --add-mcp '{"name":"spiral","type":"http","url":"https://api.spiral.ai/mcp"}' - Sign in
VS Code asks you to sign in when it first starts the server: sign in to Spiral and click Authorize. No API key. Run MCP: List Servers from the Command Palette to check that Spiral is running.
Use the Spiral skill
- Send VS Code this message
Your agent reads Spiral's skill and sets itself up.
set up https://spiral.ai/SKILL.md
- Sign in or paste a key
Approve Spiral in the browser, or give the agent a key from the console.
Use the Spiral CLI
- Install and sign in
Installs the Spiral CLI, signs you in and adds its skill to your coding agents.
npx -y spiral-cli@latest init
Call the Spiral API
- Create an API key
In the console, under API keys.
- Run Eurostat dataset observations
One request; the result comes back by polling or a webhook.
curl https://api.spiral.ai/v1/runs \ -H "Authorization: Bearer $SPIRAL_API_KEY" \ -H "Content-Type: application/json" \ -H "Idempotency-Key: $(uuidgen)" \ -d '{ "provider": "alexandria", "model": "ec-europa-eu/indicators/query_data", "input": { "code": "<code>" } }'
Then paste one of the prompts above: VS Code finds Eurostat dataset observations on Spiral, shows the price and runs it.
Eurostat dataset observations providers and prices
Spiral runs Eurostat dataset observations through Alexandria. Open a card for today's price, with every fee included.
Settings you can ask for
Ask VS Code for any of these in your prompt.
| Setting | Allowed values | Default | Description |
|---|---|---|---|
| Lang | en, fr, or de | en | lang |
Every API field of Eurostat (ec.europa.eu) · Query data is on its tool page: open its card above.
What can you do with Eurostat dataset observations in VS Code?
Build a European comparison table that keeps country price indices and city purchasing power parities on clearly labeled scales. A coding agent can inspect Eurostat’s dimensions and turn selected observations into charts in your project.
Prepare an office location comparison
Build a brief for Berlin, Paris, and Madrid with national consumption price levels and separate city purchasing power comparisons. Identify the series and check their units before presenting the results.
Write a relocation planning brief
Compare France, Germany, and Spain at the country level, then add Paris, Berlin, and Madrid using the EU officials’ city consumption basket. Explain the different populations and reference scales.
Compare procurement categories across countries
Find the relevant price comparison series and compare food and non-alcoholic beverage indices for Germany, France, and Poland. Use published category averages as context for supplier research.
Examine the effect of excluding rents
Compare Berlin and Paris purchasing power parities with rents included and excluded for the same half-year. Show how the published comparison changes when housing costs are treated differently.
Check a European cost comparison before publication
Locate the cited series, inspect its definitions, and retrieve the relevant country or city observations. Check that the article distinguishes Brussels=1 city parities from EU27=100 country indices.
Build a statistics teaching example
Use France and Germany, plus Paris and Berlin, to demonstrate dataset discovery, statistical dimensions, and reference scales. Have students explain why country price indices and city purchasing power parities answer different questions.
Produce a revision bulletin
Recheck selected country indices and city parities against previously saved observations. Report new periods separately from changes to existing periods, since Eurostat serves the latest dataset version.
More on Eurostat dataset observations and VS Code
Overview
Eurostat dataset observations in other agents
Questions about Eurostat dataset observations in VS Code
Can VS Code use Eurostat dataset observations?
Yes. Add Spiral to VS Code as an MCP server, and VS Code can find and run Eurostat dataset observations like any built-in tool.
How much does Eurostat dataset observations cost in VS Code?
$0.00873 per call. You pay from your Spiral balance as you go, with no subscription, and a failed run is not charged. Your VS Code plan is separate.
Do I need an Alexandria account to use Eurostat dataset observations in VS Code?
No. Spiral runs Eurostat dataset observations on its own Alexandria account. You sign in to Spiral once and never paste a key.
How long does it take to set up Eurostat dataset observations in VS Code?
About two minutes: add the hosted server, then sign in.
Does VS Code wait while Eurostat dataset observations runs?
Eurostat dataset observations runs in the background. VS Code starts the run, checks on it and gives you the json when it's ready.
How often does Eurostat refresh its database?
Eurostat refreshes datasets at 11:00 and 23:00 CET when new data or structural changes are available. Those refresh times do not mean every statistical series receives new observations twice daily.
Can I retrieve the figures exactly as originally published?
Eurostat serves the latest dataset version and does not maintain documented past versions in this database. An older reference year can therefore contain revised observations.
How far back do detailed purchasing power comparisons go?
All 64 analytical categories in prc_ppp_ind_1 are available from 2022 for the 36 participating countries. Earlier estimates for 1995–2021 cover GDP and its main components.
Can I reuse Eurostat data in a commercial report?
Eurostat generally permits commercial reuse with source acknowledgment, subject to its exceptions. Its notice excludes commercial reuse of data for countries outside the EU, EFTA, and official acceding or candidate countries, including US, Japanese, and Chinese data.
Start using Eurostat dataset observations in VS Code
One Spiral account for every tool your agent needs. No subscription; you pay per run.
Paste this into VS Code:
set up https://spiral.ai/SKILL.md


