Thailand Open Data Studio — Gov Data Joins 🇹🇭

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

Sources: dev.data.go.th catalogue (39,150+ datasets), provincial datastore hosts (*.gdcatalog.go.th), and the National Statistical Office API (catalogapi.nso.go.th).

Licence: datasets are Open Data Common or Creative Commons Attributions as stated on each source record. Years are converted from Buddhist Era (พ.ศ.) to CE (subtract 543).

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 — GDP, GDP per capita, population (national, current prices, million baht)
• T2 Inflation & CPI by Year — headline inflation rate × provincial CPI (all items)
• T3 Labour Market by Year — labour force participation × employment-to-population × unemployment (national)
• T4 Tourism by Year (Nan) — Thai/foreign/total tourists × visitors
• T5 Health & Longevity by Year — life expectancy (male/female) × death rate (NSO surveys)
• T6 Demography & Migration by Year — annual population (national) × population density × non-Thai citizens

Custom joins: bring your own dataset IDs (CKAN resource UUIDs or NSO table codes), key columns, join type (inner/left), aggregation (none/sum/mean), and API filters.

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

Pull 1-5 datasets raw by ID (CKAN resource UUID or NSO table code like OS_02_0015_01), 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-converts BE→CE)
customJoinType	select	inner	inner / left
customParams	textfield	—	JSON API 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 two NSO tables 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":["OS_02_0015_01","OS_01_00014_01"],"format":"json"}'

Notes

• All APIs are public and keyless (dev.data.go.th, provincial hosts, NSO).
• The dev catalogue is a development environment — endpoints may change. Provincial hosts are the more stable target.
• Data quality varies; some dev datasets are test data (e.g. Titanic). Presets use only verified production series.