UK Open Data Studio — Gov Data Joins
Pricing
from $20.00 / 1,000 joined pulls
UK Open Data Studio — Gov Data Joins
Value layer on the UK ONS open data API: 6 join presets (GDP, Inflation, Labour, Population, Trade, Housing) + custom joins + raw extraction, CSV/JSON/XLSX, AI-ready output, OGL v3 attribution.
Pricing
from $20.00 / 1,000 joined pulls
Rating
0.0
(0)
Developer
subimpact network
Maintained by CommunityActor stats
0
Bookmarked
2
Total users
1
Monthly active users
2 days ago
Last modified
Categories
Features
Share
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, CSVcurl -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 rawcurl -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.
Run monitoring and privacy
If a run fails or times out, this Actor tells its developer the run ID and status, so we can fix problems fast. It never sends your input, your results or your account data.