Air quality monitoring by hour, ACT, version 2026-10-13

Files

• data.csv51 MB CSV: UTF-8 without a byte-order mark, RFC 4180 quoting, one header row using the normalised field names. Opens in Excel, Numbers and Sheets.
• data.csv-metadata.json4.8 KB
• data.csv.gz11 MB CSV (gzip): The same CSV, gzipped, at about a tenth of the size. curl, pandas, DuckDB and R read it directly.
• data.duckdb DuckDB: One DuckDB database with a records table of typed columns, a fields table and a publicdata metadata table. It attaches read-only over HTTPS, so DuckDB, Python and R can query it without downloading it.
• data.ndjson143 MB NDJSON: The first line is the provenance header, then one JSON object per line. For streaming and for tools that read line by line.
• data.parquet8.2 MB Parquet: Columnar and typed. The smallest download and the fastest to query. Reads directly in DuckDB, pandas, Polars, Arrow and Spark. The provenance header is in the file metadata.
• data.sqlite61 MB SQLite: One database with a records table, a fields table and a publicdata metadata table. Open it with any SQLite client.
• manifest.json1.8 KB
• schema.json2.6 KB
• schema.sql1.9 KB
• source.csv52 MB

Excel is not offered because the table is 51.1 MB as CSV, over the 50 MB limit for Excel. JSON is not offered because the table is 143.3 MB as NDJSON, over the 50 MB limit for JSON.

SHA256SUMS holds the SHA-256 of every file in this version under the name it downloads as. Check what you downloaded with sha256sum -c --ignore-missing SHA256SUMS in the same folder. On a Mac, use shasum -a 256 -c --ignore-missing SHA256SUMS. Each list is signed by the deploy that wrote it: gh attestation verify SHA256SUMS --repo National-Digital/publicdata.au --source-ref refs/heads/main shows it came from this project's main branch.

Smaller files by field: by/name/.

Change from 2026-10-06

386,997 rows in 2026-10-06 and 387,521 in this version. No key is declared, so rows are compared by count only. The comparison is in diff/2026-10-06..2026-10-13.json.