Australia Open Data Studio — Gov Data Joins
Pricing
from $20.00 / 1,000 joined pulls
Australia Open Data Studio — Gov Data Joins
Value layer on Australia's official open data API (data.gov.au): 6 cross-dataset join presets (Energy & Climate, Material Consumption, Innovation & Industry, Tourism & Aid, Society & Road Safety, Threatened Species) + custom joins, CSV/JSON/XLSX delivery, AI-ready output with CC BY 4.0 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 Australia's official open data into clean CSV/JSON/XLSX with AI-ready output and attribution.
Sister actor to my-open-data-studio and sg-open-data-studio — same value-layer engine, Australia data source (data.gov.au).
Why this exists
Every preset pulls multiple official data.gov.au 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
- A1 — Energy & Climate by Year: Renewable energy share × energy intensity × CO2 emissions per capita (SDG indicators), 1990–2015.
- A2 — Material Consumption by Year: Domestic material consumption total × per capita by material category (biomass, fossil fuels, metal ores, non-metallic minerals), 1970–2017.
- A3 — Innovation & Industry by Year: R&D expenditure % GDP × manufacturing value-added % GDP × manufacturing employment share, 1981–2015.
- A4 — Tourism & Aid by Year: Tourism direct GDP share × net ODA % GNI, 2000–2016.
- A5 — Society & Road Safety by Year: Road fatalities per 100k × youth not in education (NEET), 2000–2017.
- A6 — Threatened Species by Year: Species listed under the EPBC Act by taxonomic group (flora, birds, mammals, fish, reptiles, frogs), 2000–2020.
Custom joins
Choose preset=custom and supply your own data.gov.au datastore resource ids (UUIDs), key columns, optional filters, and aggregation. The engine probes each dataset and guesses numeric fields if you don't specify them.
Input
| Field | Default | Description |
|---|---|---|
| preset | A1 | A1-A6 or custom |
| format | json | json, csv, xlsx |
| customDatasets | [] | resource ids for custom joins |
| customKey | year | key column for custom joins |
| webhookUrl | "" | POST the joined file to a webhook |
Output
{preset}_join.{json,csv,xlsx}— the joined file{preset}_attribution.json— source/licence metadata{preset}_ai_ready.json— JSON Schema + data dictionary + sample rows for LLM/RAG ingestion{preset}_verification.json— row counts per source, join stats, year range
Source
data.gov.au — Australia's official open data portal. Datasets are licensed under CC BY 4.0 unless otherwise stated on the source record; attribution is attached to every output.
data.gov.au's public API is keyless. The actor paces its fetches within a comfortable rate; large datasets take longer but never fail on rate limits.
