publicdata.au publicdata.au on GitHub

Properties with pool safety certificates, Queensland, version 2024-09-02

latest
Rows 113,800Fields 11Fetched 3 October 2026Source SHA-256 454c50cc442a915d…

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.arrow4.2 MB 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.csv10 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.json3.4 KB
  • data.csv.gz2.6 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.json32 MB JSON: One object with a publicdata header (publisher, licence, attribution, version, source hash), a fields list and a records array of 113,800 objects with typed values. Blank cells are null.
  • data.ndjson32 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.parquet1.8 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.sqlite9.5 MB SQLite: One database with a records table, a fields table and a publicdata metadata table. Open it with any SQLite client.
  • data.xlsx6.7 MB Excel: One workbook with a records sheet of 113,800 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.json1.6 KB
  • schema.sql1.4 KB
  • source.csv25 MB

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

Queensland Building and Construction Commission, Queensland Government, Pool safety register, sourced 3 October 2026, https://www.data.qld.gov.au/dataset/poolsafetyregister, licensed under CC BY 4.0.

Provenance

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

05k10k15k2011 No: 6,1832011 Yes: 15720112012 No: 5,7012012 Yes: 1192013 No: 5,8422013 Yes: 8720132014 No: 5,6032014 Yes: 522015 No: 5,6452015 Yes: 5420152016 No: 7,0312016 Yes: 822017 No: 8,0042017 Yes: 8520172018 No: 8,8972018 Yes: 982019 No: 8,5132019 Yes: 12020192020 No: 9,1622020 Yes: 912021 No: 10,1222021 Yes: 7020212022 No: 11,8282022 Yes: 1132023 No: 13,0072023 Yes: 1322023
NoYes
Properties whose listed certificate was submitted per year by shared pool, 2011 to 2023. Rows where date submitted is at least 2010-12-01 are drawn. 2010 is not drawn because the rows begin on 1 December 2010. 2024 is not drawn because the rows run to 2 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, with a link to the diff file.