Malaysia Open Data Studio — Gov Data Joins

Cross-dataset joins on Malaysia's official open data (data.gov.my), delivered as clean CSV / JSON / XLSX — with AI-ready output and CC BY 4.0 attribution built in.

This Actor is a value layer on the official data.gov.my API. It does not scrape the website and it does not charge for data that is already free — it sells the work: joining, cleaning, and packaging government open data for people who need it in a usable shape.

Why use this Actor

• No scraping. Uses the official, keyless API (api.data.gov.my) — stable, licensed, CC BY 4.0.
• Real joins, not raw dumps. 11 ready-made preset bundles + custom joins (pick your own datasets and keys).
• Drop-in for spreadsheets. CSV / XLSX output opens directly in Excel, Google Sheets, or Numbers.
• AI-ready. Every run can emit a JSON Schema + data dictionary + sample rows — designed for LLM/RAG ingestion.
• Attribution handled. CC BY 4.0 source metadata is attached to every output, so you stay compliant with zero effort.
• Webhooks. Push results straight to your pipeline (3 retries, backoff).

Presets

All presets emit one flat, joined table. (state, year) joins include 16 states / federal territories (incl. W.P. KL, Labuan, Putrajaya).

B1 — Economy by State — population × household income × CPI, joined on (state, year).

• population_thousands, income_mean_rm, income_median_rm, cpi_annual_2010_100

B2 — Demography by State — population × births × deaths × crime, joined on (state, year).

• population_thousands, births, birth_rate_per_1000, deaths, death_rate_per_1000, crimes_total

B3 — Labour Market & Mobility — labour force (quarterly, annualised) × passport issuances, joined on (state, year).

• labour_force_thousands, employed_thousands, unemployed_thousands, participation_rate_pct, unemployment_rate_pct, passports_issued

B4 — Prices & Inflation (National) — fuel prices (weekly, annualised) × headline CPI × core CPI, joined on (year).

• fuel_ron95_rm, fuel_ron97_rm, fuel_diesel_rm, cpi_headline_2010_100, cpi_core_2010_100

B5 — Health & Pandemic by State — COVID-19 cases × vaccine registrations × organ pledges, joined on (state, year).

• covid_new_cases, covid_active_cases, covid_recoveries, vax_registrations, organ_pledges

B6 — Public Transport Ridership (National) — rail & bus ridership × KTMB services, joined on (year).

• ridership_lrt_ampang, ridership_lrt_kelana_jaya, ridership_mrt_kajang, ridership_mrt_putrajaya, ridership_monorail, ridership_komuter, ridership_ets, ridership_intercity, ridership_shuttle_tebrau, ridership_bus_rkl, ridership_ktmb_total

B7 — Education by State — schools × teachers × enrolment × upper-secondary completion, joined on (state, year).

• schools_total, teachers_total, students_total, completion_rate_upper_secondary_pct

B8 — Tourism & Arrivals (National) — monthly international arrivals (total, female, male), annualised by (year).

• arrivals_total, arrivals_female, arrivals_male

B9 — Agriculture & Commodities by State — crops × fish landings × timber × minerals, joined on (state, year).

• crop_planted_area_ha, crop_production_tonnes, fish_landings_tonnes, timber_production_m3, mineral_production_tonnes

B10 — Public Safety by State — crime × prisoners × drug addicts, joined on (state, year).

• crimes_total, prisoners_total, drug_addicts_total

B11 — Healthcare Capacity by State — hospital beds × healthcare staff × STD cases × maternal deaths, joined on (state, year).

• hospital_beds_total, healthcare_staff_total, std_cases_total, maternal_deaths, maternal_death_rate_per_100k

Custom join — bring your own 2–6 data.gov.my dataset ids, choose join keys (year auto-extracts from date, or raw fields like state/district), join type (inner/left), optional aggregation (sum/mean), and API filters. Example: household income × poverty by district (480 rows, 2019–2024).

Input

field	type	default	description
preset	enum	B1	B1–B11 or custom
customDatasets	string list	—	custom join: dataset ids (2–6)
customKey	string list	["state","year"]	custom join: key columns (year = date field's year)
customJoinType	enum	inner	inner / left
customParams	string	—	JSON object of extra API params (e.g. {"filter": "overall@division"})
customAgg	enum	none	none / sum / mean
format	enum	json	json / csv / xlsx
webhookUrl	string	—	POST the result file here after the run (optional)
aiReady	bool	true	Emit JSON Schema + dictionary + samples
includeAttribution	bool	true	Attach CC BY 4.0 metadata sidecar

Output

Key-value store:

• <preset>_join.<json|csv|xlsx> — the joined table
• <preset>_ai_ready.json — schema + data dictionary + sample rows (LLM/RAG)
• <preset>_attribution.json — CC BY 4.0 source metadata
• <preset>_verification.json — row count, year range, state coverage, source rows

Dataset (default) — run verification record.

Cost

$0.00999 per run (pay-per-event, one joined-pull charge ≈ $9.99 / 1,000 pulls). The underlying data comes from Malaysia's official free API (data.gov.my, CC BY 4.0) — you pay for the join + packaging, not the data. Apify compute is negligible for this size of run (~$0.002).

Roadmap

• Scheduled delta runs driven by next_update (subscription plans $5–25/mo)
• Drift monitoring alerts (we flag stale government metadata)
• Google Sheets / BigQuery / S3 push

Attribution

Malaysia Open Data — data.gov.my. Licensed under CC BY 4.0. See <preset>_attribution.json in every run output.