Data hub
SQL workbench
Read-only SQL over the Closing the Gap register, progress data, Social Justice Report 2025 recommendations, ingested observations. Turn on live mode to re-run as data changes.
Saved queries
Tables (schema analytics)
target_id, outcome, summary, policies, partners, undrip, principles, rationale, evidence, econ_lenscode, target_id, indicator, unit, baseline_*, latest_*, target_value, target_year, status, assessment, pct_toward_targettarget_id, sdgtarget_id, articlesdg, goaltarget_id, outcome, framework (SDG | UNDRIP | SJR 2025), ref, label, econ_lensrec_no, chapter, chapter_title, area, domain, page, title, summary, basis, cross_cutting, undrip_articles, priority_reformsrec_no, title, area, domain, cross_cutting, target_id, outcomerec_no, title, target_id, topic, format, dataset_url, last_checkedissue_id, theme, title, summary, ctg_targets, priority_reforms, undrip_articles, sdgs, sjr_recs, measures, wathaga_role, evidenceissue_id, issue, theme, solution, description, lead, horizon, basisindicator_key, title, group_name, unit, better, description, citation, source_url, latest_yearindicator_key, indicator, unit, better, iso3, country, region, year, valuekind, tribunal_id, name, state, category, status, key_date, area_sqkm, lat, lon, details (jsonb)mine_id, name, commodity_group, status, state, lat, lonfacility_id, name, sector, industry, state, lat, lon, report_year, air_kg, water_kg, land_kg, substances, top_substancesmine_id, mine, commodity_group, status, state, npi_facility, distance_km, report_year, air_kg, water_kg, land_kg, top_substancesosm_id, name, operator, suburb, state, lat, lon, osm_urlevent_id, hazard, alert_level, name, from_date, to_date, severity, is_current, lat, lonstate, offence, year, victims, rate_per_100ktarget, measure, year_label, jurisdiction, population, value, unit, topic, raw (jsonb)started_at, finished_at, datasets, changed, rows, errorsfile_id, file_name, file_type, size_mb, folder, labels, uploaded_by, uploaded_at (live)file_id, label (live)happened_at, member, kind, detail (live)Log in to query your organisation's org_* tables.