Singapore Open Data Studio — Gov Data Joins
Pricing
from $20.00 / 1,000 joined pulls
Singapore Open Data Studio — Gov Data Joins
Value layer on Singapore's official open data API (data.gov.sg): 6 cross-dataset join presets (Housing & HDB, Demography, Labour, Vehicles & COE, Education, Health) + custom joins, CSV/JSON/XLSX delivery, webhooks, AI-ready output with Singapore Open Data Licence attribution.
Pricing
from $20.00 / 1,000 joined pulls
Rating
0.0
(0)
Developer
subimpact
Maintained by CommunityActor stats
0
Bookmarked
2
Total users
1
Monthly active users
3 days ago
Last modified
Categories
Share
Join Singapore's official open data into clean CSV/JSON/XLSX with AI-ready output and attribution.
Sister actor to my-open-data-studio — same value-layer engine, Singapore data source (data.gov.sg).
What it does
Every preset pulls multiple official data.gov.sg datasets, aligns them on a common key (year), and delivers one flat joined file. Raw APIs can't do this — that's the value layer.
Presets
- S1 — Housing & HDB by Year: HDB dwelling units under management × completed units, by financial year.
- S2 — Demography by Year: Total deaths × live births, by year.
- S3 — Labour Market by Year: Female LFPR × female employment rate × resident long-term unemployment, by year.
- S4 — Vehicles & COE by Year: COE quota (all categories) × cars by engine capacity, by year.
- S5 — Education by Year: Primary enrolment × secondary enrolment × secondary teachers (both sexes), by year.
- S6 — Health by Year: Public hospital admissions × doctors per 10k × male life expectancy, by year.
Custom joins
Choose preset=custom and supply your own data.gov.sg dataset ids (d_...), key columns, optional filters, and aggregation. The engine probes each dataset and guesses numeric fields if you don't specify them.
Inputs
| Input | Default | Description |
|---|---|---|
| preset | S1 | S1-S6 or custom |
| customDatasets | [] | Dataset ids for custom joins |
| customKey | ["year"] | Key columns for custom joins |
| customJoinType | inner | inner or left |
| customParams | {} | JSON filters applied to every dataset |
| customAgg | none | none, sum, or mean |
| format | json | json, csv, or xlsx |
| webhookUrl | (empty) | POST result file after run |
| aiReady | true | Emit JSON Schema + data dictionary |
| includeAttribution | true | Attach source/licence sidecar |
Output
Key-value store records: <preset>_join.<ext>, <preset>_ai_ready.json, <preset>_attribution.json, <preset>_verification.json. Dataset records (JSON) are always emitted alongside the file.
Pricing
Pay per joined pull (single event). Usage (compute) is billed to the user's Apify account; the event price is the creator's revenue.
Data & licence
Source: data.gov.sg — Singapore's official open data portal (Singapore Department of Statistics, HDB, MOH, MOE, MOM, LTA, ICA, NEA, and more). Licensed under the Singapore Open Data Licence (CC BY 4.0-based). Attribution is attached to every output.
Rate limits
data.gov.sg's public API is keyless but rate-limited (datastore: 4 calls/10s without a key). The actor paces its fetches within the limit; large datasets take longer but never fail on rate limits.
