query
Counts, sums, averages, minimums and maximums by group
Groups and totals of any dataset in the newest loaded version. Filters work as they do on rows. Each filter is field=operator.value in the query string, and every filter must match. A number or date field compares as a number or date, and a text field compares as text. Values are case-sensitive, except that like and ilike ignore case in the ASCII letters A to Z. Prefix not. to negate a filter, as not.eq.value. Operators: eq.value, neq.value, gt.value, gte.value, lt.value, lte.value, like.*text*, ilike.*text*, in.(a,b,c), is.null.
get/api/v1/datasets/{slug}/aggregate
Request
- Base URL: https://publicdata.au
- URL: https://publicdata.au/api/v1/datasets/{slug}/aggregate
- Auth: none declared
Path parameters
slug'qld-road-crash-locations' | 'qld-road-casualties' | 'qld-road-crash-driver-demographics' | 'qld-road-crash-restraint-helmet-use' | 'vic-road-crashes' | 'qld-road-crash-vehicle-types' | 'sa-road-crash-locations' | 'act-road-crashes' | 'qld-road-crash-factors' | 'tas-road-crashes' | 'au-road-deaths' | 'nsw-recorded-crime-by-lga' | 'acnc-register' | 'vic-recorded-offences-by-lga' | 'vic-recorded-offences-by-suburb' | 'nt-crime-statistics' | 'nsw-road-crashes' | 'vic-rents-by-suburb' | 'au-migration-program-outcome' | 'au-migration-program-by-citizenship' | 'au-humanitarian-program-grants' | 'au-settler-arrivals-by-country' | 'au-permanent-additions-by-country' | 'rba-cash-rate' | 'rba-money-market-daily' | 'rba-retail-deposit-rates' | 'vic-median-house-prices-by-suburb' | 'rba-paid-deposit-rates' | 'vic-water-storage-levels' | 'rba-indicator-lending-rates' | 'vic-water-storages' | 'au-water-storages' | 'rogs-homelessness-services' | 'rogs-corrective-services' | 'rogs-youth-justice' | 'au-homelessness-services-monthly' | 'au-fdv-victims-recorded-crime' | 'au-fdv-hospitalisations' | 'au-domestic-homicide-victims' | 'au-suicide-deaths-by-state' | 'au-suicide-deaths-by-age' | 'au-shark-incidents' | 'nt-fuel-prices-history' | 'nt-mineral-production' | 'nsw-public-libraries' | 'tas-libraries-locations' | 'vic-public-libraries' | 'abs-sa2-2021' | 'abs-lga-2025' | 'abs-suburbs-localities-2021' | 'abs-postal-areas-2021' | 'abs-state-electoral-divisions-2025' | 'abs-federal-electoral-divisions-2025' | 'abs-states-territories-2021' | 'qld-top-baby-names' | 'qld-top-baby-names-1960-2005' | 'qld-births-by-month' | 'qld-births-by-mothers-postcode' | 'qld-deaths-by-month' | 'qld-deaths-by-suburb' | 'qld-deaths-by-postcode-and-quarter' | 'qld-offences-monthly' | 'qld-traffic-infringements-issued' | 'qld-traffic-infringement-payments' | 'qld-mobile-speed-camera-sites' | 'qld-speed-camera-trailer-sites' | 'qld-vehicle-registrations-by-suburb' | 'qld-motorcycle-registrations' | 'qld-new-vehicle-registrations-daily' | 'qld-vehicle-registration-transfers' | 'qld-driver-licence-renewals-early' | 'qld-registration-renewals-daily' | 'qld-vessel-registrations' | 'qld-new-recreational-vessel-registrations' | 'qld-jp-signing-locations' | 'qld-qbcc-licensed-contractors' | 'qld-consumer-complaints' | 'qld-fair-trading-enforcement-actions' | 'qld-fair-trading-licences-by-region' | 'qld-registered-organisations-by-region' | 'qld-fuel-prices' | 'qld-elective-surgery-by-category' | 'qld-elective-surgery-by-specialty' | 'qld-emergency-department-facilities' | 'qld-emergency-department-waits-now' | 'qld-emergency-department-busyness' | 'qld-public-dental-waiting-lists' | 'qld-tmr-contract-disclosure' | 'qld-ehealth-contract-disclosure' | 'qld-dpi-contract-disclosure' | 'qld-qleave-contract-disclosure' | 'qld-urban-fire-stations' | 'qld-rural-fire-stations' | 'qld-police-stations' | 'qld-bushfire-incidents-current' | 'qld-heritage-register' | 'qld-flood-extent-2010-bundaberg' | 'qld-flood-extent-2011-january' | 'qld-flood-extent-2011-april' | 'qld-flood-extent-2012-south-west' | 'qld-flood-extent-2013-bundaberg' | 'qld-flood-extent-2017-fitzroy' | 'qld-flood-extent-2017-logan-albert' | 'qld-flood-extent-2019-western' | 'qld-land-valuation-trends' | 'qld-land-valuation-trends-2002-2009' | 'qld-valuation-objection-rates' | 'qld-coastal-waves-gold-coast' | 'qld-coastal-waves-tweed-heads' | 'qld-coastal-waves-brisbane' | 'qld-coastal-waves-mooloolaba' | 'qld-coastal-waves-mackay' | 'qld-coastal-waves-townsville' | 'qld-coastal-waves-cairns' | 'qld-prison-locations' | 'qld-coal-exports-by-mine-and-country' | 'qld-coal-production-by-mine' | 'qld-coal-exports-by-country' | 'qld-coal-saleable-production' | 'qld-petroleum-gas-production' | 'qld-petroleum-gas-reserves' | 'qld-locality-boundaries' | 'qld-youth-detention-daily-by-age' | 'qld-youth-detention-daily-by-centre' | 'qld-youth-detention-daily-by-indigenous-status' | 'qld-youth-detention-daily-by-legal-status' | 'qld-youth-detention-daily-by-sex' | 'qld-pool-safety-register-pools' | 'qld-pool-safety-certificates' | 'qld-pool-safety-inspectors' | 'qld-unclaimed-money' | 'qld-school-details' | 'qld-state-school-enrolments-february' | 'qld-school-catchments-junior-secondary' | 'qld-school-catchments-primary' | 'qld-school-catchments-senior-secondary' | 'qld-gaming-machines-by-sa2' | 'qld-gaming-machines-by-sa4' | 'qld-gaming-machines-clubs' | 'qld-gaming-machines-hotels' | 'qld-gaming-machines-total' | 'qld-gambling-expenditure' | 'qld-gaming-machine-ranges' | 'qld-notifiable-diseases-2010-2014' | 'qld-social-housing-register' | 'nt-urban-public-housing-wait-list' | 'qld-social-housing-maintenance' | 'qld-public-housing-dwellings' | 'qld-surface-water-gauging-stations' | 'qld-traffic-by-hour-and-day' | 'qld-traffic-census' | 'qld-translink-citytrain-punctuality' | 'qld-translink-complaints' | 'qld-translink-fines-warnings' | 'qld-translink-passenger-injuries' | 'qld-translink-patronage-regional' | 'qld-translink-patronage-seq' | 'qld-translink-seq-bus-punctuality' | 'qld-translink-taxi-subsidy' | 'qld-translink-tram-punctuality' | 'qld-regional-bus-patronage' | 'qld-traveltrain-patronage' | 'qld-translink-origin-destination-stops' | 'qld-translink-origin-destination-trips' | 'qld-all-abilities-playgrounds' | 'qld-brisbane-dog-off-leash-areas' | 'qld-brisbane-park-barbecues' | 'qld-shark-control-catch-lengths' | 'qld-shark-control-catch-numbers' | 'qld-shark-control-gbr-catches' | 'qld-crocodile-distribution-surveys' | 'qld-crocwatch-sightings-2010-2015' | 'qld-crocwatch-sightings-2016' | 'qld-crocwatch-sightings-2017' | 'qld-public-libraries-directory' | 'qld-public-library-branch-statistics' | 'qld-public-library-council-statistics' | 'nsw-popular-baby-names' | 'nsw-top-baby-names-by-lga-male' | 'nsw-top-baby-names-by-lga-female' | 'nsw-bdm-registrations-monthly' | 'nsw-bdm-disposal-methods-monthly' | 'nsw-public-holidays' | 'nsw-school-term-dates' | 'nsw-dwelling-completions' | 'nsw-boat-licences-registrations-by-postcode' | 'nsw-public-schools' | 'nsw-school-intake-zones-primary' | 'nsw-school-intake-zones-secondary' | 'nsw-school-intake-zones-future' | 'nsw-liquor-licence-premises' | 'nsw-primary-class-sizes' | 'nsw-traffic-count-stations' | 'nsw-traffic-volume-yearly' | 'nsw-rental-bond-lodgements-2021' | 'nsw-rental-bond-lodgements-2022' | 'nsw-rental-bond-lodgements-2023' | 'nsw-rental-bond-lodgements-2024' | 'nsw-rental-bond-lodgements-2025' | 'nsw-rental-bond-refunds-2021' | 'nsw-rental-bond-refunds-2022' | 'nsw-rental-bond-refunds-2023' | 'nsw-rental-bond-refunds-2024' | 'nsw-rental-bond-refunds-2025' | 'nsw-beachwatch-sites' | 'vic-heritage-register' | 'vic-driver-licence-transfers-from-victoria' | 'vic-school-locations' | 'vic-school-zones-primary-2027' | 'vic-school-zones-year7-2027' | 'vic-traffic-volume-aadt-2019' | 'vic-greater-dandenong-registered-dogs' | 'vic-golden-plains-animal-registrations' | 'vic-southern-grampians-animal-registrations' | 'vic-cfa-incident-responses' | 'vic-ambulance-response-times-by-lga' | 'vic-ambulance-response-times-by-town' | 'vic-mfb-fire-station-locations' | 'vic-prison-locations' | 'vic-measles-exposure-sites' | 'vic-beach-report-enterococci' | 'vic-beach-report-sites' | 'vic-air-quality-hourly' | 'vic-road-safety-camera-fines-by-site' | 'vic-traffic-infringements-vs-official-warnings' | 'vic-deaths-registered-by-month' | 'vic-marriages-registered-by-month' | 'vic-registered-events-by-calendar-year' | 'vic-registered-events-by-financial-year' | 'vic-important-dates' | 'vic-land-tax-by-municipality' | 'vic-unclaimed-money-claims' | 'vic-unclaimed-money-payments' | 'vic-land-transfer-duty-by-postcode' | 'vic-consumer-enforcement-outcomes' | 'vic-liquor-licences' | 'vic-gaming-expenditure-by-venue' | 'vic-gaming-expenditure-by-venue-history' | 'vic-melbourne-water-daily-storage' | 'vic-median-unit-prices-by-suburb' | 'vic-median-vacant-land-prices-by-suburb' | 'vic-mobile-road-safety-camera-locations' | 'vic-vehicle-registrations-by-postcode' | 'vic-vehicle-registrations-by-model' | 'vic-new-vehicle-registrations-monthly' | 'vic-driver-licence-transfers-to-victoria' | 'vic-metro-train-station-patronage' | 'vic-regional-train-station-patronage' | 'vic-stream-restrictions' | 'vic-ballarat-lightning-observations' | 'sa-fire-history' | 'sa-river-murray-flood-100gl' | 'sa-river-murray-flood-120gl' | 'sa-river-murray-flood-130gl' | 'sa-river-murray-flood-140gl' | 'sa-river-murray-flood-160gl' | 'sa-river-murray-flood-180gl' | 'sa-river-murray-flood-200gl' | 'sa-river-murray-flood-250gl' | 'sa-river-murray-flood-300gl' | 'sa-river-murray-flood-341gl' | 'sa-river-murray-flood-2022' | 'sa-baby-names-boys' | 'sa-baby-names-girls' | 'sa-crime-statistics' | 'sa-family-domestic-abuse-offences' | 'sa-metro-median-house-prices' | 'sa-private-rents-by-suburb' | 'sa-private-rents-by-postcode' | 'sa-camera-expiation-offences' | 'sa-police-expiation-offences' | 'sa-camera-detections-not-accepted' | 'sa-mobile-camera-location-codes' | 'sa-registered-vehicles-by-postcode' | 'sa-registered-vehicles-by-colour' | 'sa-registered-vehicles-by-body-type' | 'sa-drivers-licences-by-postcode' | 'sa-suburb-boundaries' | 'sa-heritage-places' | 'sa-traffic-volumes' | 'sa-high-school-zones' | 'sa-primary-school-zones' | 'sa-public-hospitals' | 'sa-private-hospitals' | 'sa-liquor-gaming-licences-2018' | 'sa-boat-registrations' | 'sa-dogs-cats-registered-animals' | 'sa-dogs-cats-owners' | 'sa-dog-cat-incidents' | 'sa-air-quality-monitoring-sites' | 'sa-school-enrolments-by-type' | 'sa-reservoir-volumes' | 'sa-adelaide-city-barbecues' | 'sa-public-housing-dwellings' | 'sa-public-housing-households' | 'sa-public-housing-new-households' | 'sa-food-enforcement-food-service' | 'sa-food-enforcement-food-transporter' | 'sa-food-enforcement-processor-manufacturer' | 'sa-food-enforcement-retail' | 'act-bdm-registrations' | 'act-historic-death-index' | 'act-historic-marriage-index' | 'act-traffic-camera-offences' | 'act-traffic-camera-offences-2010-2021' | 'act-parking-offences' | 'act-mobile-speed-camera-visits' | 'act-traffic-camera-locations' | 'act-mobile-distraction-camera-locations' | 'act-vehicles-registered' | 'act-licences-transferred-interstate' | 'act-licences-transferred-to-act' | 'act-engineers-register' | 'act-mutual-recognition-register' | 'act-police-stations' | 'act-air-quality' | 'act-lakes-rivers-water-quality' | 'act-contracts-register-2016-2017' | 'act-recreational-water-quality-2019-20' | 'act-notifiable-invoices' | 'act-barbecues' | 'wa-slwa-obituaries-index' | 'wa-public-libraries' | 'wa-public-housing-dwelling-age-by-suburb' | 'wa-dpird-weather-stations' | 'wa-wave-stations-current' | 'wa-wave-stations-historic' | 'wa-traffic-digest' | 'act-2003-bushfire' | 'act-recreational-water-quality-2018-19' | 'tas-deaths-1803-1939' | 'tas-rental-bonds-lodged-2016-11' | 'tas-rental-bonds-closed-2016-11' | 'tas-accredited-building-practitioners-2017' | 'nt-crocodile-captures' | 'nt-crocodile-capture-zones' | 'nt-bushfire-brigade-locations' | 'au-births-by-age-of-mother' | 'au-births-by-age-of-father' | 'au-births-by-state' | 'au-building-approvals-by-lga-2025-26' | 'au-public-holidays-2021-2025' | 'au-modified-monash-model-by-suburb' | 'au-youth-detention-population-quarterly' | 'au-child-care-services-by-sa3-2012-2016' | 'au-hospitals-myhospitals' | 'au-ed-patients-seen-on-time' | 'au-elective-surgery-waiting-times' | 'au-elective-surgery-waiting-times-by-procedure' | 'au-elective-surgery-waiting-times-by-specialty' | 'au-taxable-income-by-postcode-2023-24' | 'au-emergency-services-facilities' | 'au-localities-nsw' | 'au-localities-vic' | 'au-localities-wa' | 'au-localities-sa' | 'au-localities-tas' | 'au-localities-nt' | 'au-localities-act' | 'au-localities-ot' | 'qld-median-rents-by-suburb' | 'qld-median-rents-by-postcode' | 'au-government-procurement-totals-2008-2012' | 'au-national-heritage-list-places' | 'au-commonwealth-heritage-list-places' | 'au-population-by-lga-2025' | 'nsw-rest-areas' | 'wa-road-stopping-places' | 'sa-rest-areas-state-maintained' | 'tas-roadside-stops' required
The dataset's slug, as in its page URL /d/<slug>/.
Query parameters
groupstring
On aggregate, fields to group by, comma-separated.
metricstring
On aggregate, count, sum.field, avg.field, min.field or max.field, comma-separated. count when absent.
orderstring
field.asc or field.desc, comma-separated. When absent, rows come in the order of the file they are read from. For the newest versions that is the version's own data.parquet, which keeps the publisher's order unless the dataset sorted it. Any other version is read from the Parquet file the answer names in file, and when that file is sorted the answer names its sort in order, which ties follow too.
limitinteger
Rows per page, 1 to 10,000. 100 when absent.
offsetinteger
Rows to skip. The next URL in each answer sets it for you.
format'json' | 'ndjson' | 'csv'
json, ndjson or csv. JSON carries the provenance header, and the others carry it in response headers.
Response
Rows with the version, licence and attribution. next is the URL of the following page, or null. An answer read or counted from a Parquet file names it in file, or its period parts in parts, and a sorted file's sort in order.
Changes
No recorded changes to this operation across all 1 revision of this API.