publicdata.au publicdata.au on GitHub

Public holiday dates by state and territory, Australia, 2021 to 2025, version 2024-09-24

latest
Rows 532Fields 6Fetched 3 October 2026Source SHA-256 4126fe21c5c96994…

This version is kept for as long as this site exists, and its URL can be cited. Its files change only for the reasons the terms give, and each change is recorded in its notes. The publisher's file is here as source.csv, byte for byte.

Files

  • data.arrow16 KB Arrow: Arrow IPC file (Feather v2), zstd compressed, with the provenance in the schema metadata. Memory-maps in pyarrow, Polars, Arrow JS and R without parsing.
  • data.csv93 KB 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.json2.2 KB
  • data.csv.gz6.5 KB 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.json139 KB JSON: One object with a publicdata header (publisher, licence, attribution, version, source hash), a fields list and a records array of 532 objects with typed values. Blank cells are null.
  • data.ndjson138 KB 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.parquet14 KB 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.sqlite135 KB SQLite: One database with a records table, a fields table and a publicdata metadata table. Open it with any SQLite client.
  • data.xlsx31 KB Excel: One workbook with a records sheet of 532 typed rows, a fields sheet and a publicdata sheet with the provenance. Dates are real Excel dates. Opens in Excel, Numbers, LibreOffice and Sheets.
  • manifest.json1.7 KB
  • schema.json663 B
  • schema.sql725 B
  • source.csv89 KB

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.

Attribution the licence asks for

Department of the Prime Minister and Cabinet, Australian Government, Australian Public Holidays Dates Machine Readable Dataset, sourced 3 October 2026, https://data.gov.au/data/dataset/australian-holidays-machine-readable-dataset, licensed under CC BY 3.0 AU.

Provenance

Fetched from data.gov.au on 3 October 2026. The portal listed the licence as Creative Commons Attribution 3.0 Australia at that moment. manifest.json has every detail.

0501001502021 act: 152021 nsw: 142021 nt: 152021 qld: 142021 sa: 152021 tas: 122021 vic: 152021 wa: 1320212022 act: 152022 nsw: 142022 nt: 142022 qld: 142022 sa: 142022 tas: 112022 vic: 152022 wa: 1220222023 act: 142023 nsw: 132023 nt: 152023 qld: 142023 sa: 142023 tas: 112023 vic: 142023 wa: 122023
actnswntqldsatasvicwa
Holidays per year by state or territory, 2021 to 2023. 2024 and 2025 are not drawn because the rows run to 24 September 2024. A count of rows in this version, worked out in the build.
Change from the version before

First version followed here.

When the publisher releases again, this panel shows rows added, removed and changed by id, with a link to the diff file.