UK Open Data Studio — Gov Data Joins 🇬🇧

Value layer on the UK's official open data. Join cross-dataset indicators into clean, AI-ready tables — or pull raw datasets by ID.

Source: ONS beta API (Office for National Statistics open data API, keyless). The data.gov.uk CKAN catalogue is a metadata directory — its datastore API returns 403 and resources are HTML links — so the value layer pulls structured time series directly from the ONS API.

Licence: ONS data is published under the Open Government Licence v3.0 (crown copyright). Years are native CE.

Features

Studio mode (value layer) — $0.02/joined-pull

Six cross-dataset join presets, delivered as CSV / JSON / XLSX with an AI-ready package (JSON Schema + data dictionary + sample rows) and attribution sidecar:

• T1 GDP & Economy by Year — annual GDP index for England (chained volume measure, all industries)
• T2 Inflation by Year — CPIH all-items index (overall), December values
• T3 Labour Market by Year — employment × unemployment × economic inactivity rates (16+, seasonally adjusted)
• T4 Population by Year — UK mid-year population estimates (total, all ages)
• T5 Trade by Year — UK total exports and imports (whole world, monthly means)
• T6 Housing by Year — Index of Private Housing Rental Prices (UK, December values)

Custom joins: bring your own ONS dataset IDs, key columns, join type (inner/left), aggregation (none/sum/mean), and dimension filters.

Extract mode (raw data pull) — $0.01/extract-pull

Pull 1-5 ONS datasets raw by ID (e.g. cpih01, labour-market, regional-gdp-by-year), no join, no reshape. Per-dataset files + manifest + attribution.

Input

Field	Type	Default	Notes
mode	select	studio	studio = value layer, extract = raw pull
preset	select	T1	T1-T6 or custom
datasetIds	stringList	—	extract mode: 1-5 IDs
customDatasets	stringList	—	custom join: 2-6 IDs
customKey	stringList	[year]	join keys ('year' auto-extracts from ONS Time labels)
customJoinType	select	inner	inner / left
customParams	textfield	—	JSON dimension filters
customAgg	select	none	none / sum / mean
format	select	json	json / csv / xlsx
webhookUrl	textfield	—	optional POST target
aiReady	checkbox	true	AI-ready package
includeAttribution	checkbox	true	attribution sidecar

Output

• Dataset: one summary record per run (mode, preset, rows, format, files, year range, run URL) — rendered as a table in the Output tab.
• Key-value store: the joined/extracted file, *_verification.json, *_attribution.json, *_ai_ready.json (studio) or per-dataset files + extract_manifest.json (extract).

Example

# Studio: GDP & Economy preset, CSV
curl -X POST "https://api.apify.com/v2/acts/<ACTOR_ID>/runs?token=$APIFY_TOKEN" \
  -H "Content-Type: application/json" \
  -d '{"preset":"T1","format":"csv"}'

# Extract: pull CPIH + labour market raw
curl -X POST "https://api.apify.com/v2/acts/<ACTOR_ID>/runs?token=$APIFY_TOKEN" \
  -H "Content-Type: application/json" \
  -d '{"mode":"extract","datasetIds":["cpih01","labour-market"],"format":"json"}'

Notes

• The ONS beta API is public and keyless; no API key required.
• The API is a beta service — endpoints may change.
• The data.gov.uk CKAN datastore is disabled (403), so presets use the ONS API only.