--- title: Properties with pool safety certificates, Queensland resource: https://publicdata.au/d/qld-pool-safety-certificates/ publisher: Queensland Building and Construction Commission licence: CC BY 4.0 licence_url: https://creativecommons.org/licenses/by/4.0/ version: 2024-09-02 rows: 113800 fields: 11 source: https://www.data.qld.gov.au/dataset/1b4c7d46-7e52-4c77-ab79-6e935dd5c691/resource/68b4583f-9611-46e6-8302-d28ecc43b421/download/certificates_at_2024-08-012024-08-01-06.40.57.734.csv source_sha256: 454c50cc442a915d0391d66350b6f27d92239ae9857b2861b372d7cadf297356 language: en-AU operator: National Digital not_endorsed: true --- # Properties with pool safety certificates, Queensland Queensland properties whose pools have been issued pool safety certificates, with the date each was submitted. Published by Queensland Building and Construction Commission under CC BY 4.0 and republished here in other formats, with cells typed and suppressed values made null. Queensland Building and Construction Commission has not endorsed this site. Also called: Queensland pool safety certificates register, QBCC pool safety certificate search, Pool compliance certificates Queensland. ## Download Latest version, redirects to `https://publicdata.au/d/qld-pool-safety-certificates/v/2024-09-02/`: - csv: https://publicdata.au/d/qld-pool-safety-certificates/latest/data.csv (10 MB) - xlsx: https://publicdata.au/d/qld-pool-safety-certificates/latest/data.xlsx (6.7 MB) - json: https://publicdata.au/d/qld-pool-safety-certificates/latest/data.json (32 MB) - parquet: https://publicdata.au/d/qld-pool-safety-certificates/latest/data.parquet (1.8 MB) - sqlite: https://publicdata.au/d/qld-pool-safety-certificates/latest/data.sqlite (9.5 MB) - duckdb: https://publicdata.au/d/qld-pool-safety-certificates/latest/data.duckdb (3.0 MB) - ndjson: https://publicdata.au/d/qld-pool-safety-certificates/latest/data.ndjson (32 MB) - arrow: https://publicdata.au/d/qld-pool-safety-certificates/latest/data.arrow (4.2 MB) - csv.gz: https://publicdata.au/d/qld-pool-safety-certificates/latest/data.csv.gz (2.6 MB) Pinned version 2024-09-02: `https://publicdata.au/d/qld-pool-safety-certificates/v/2024-09-02/data.`. Dated versions never change. ## Query The query API returns only the rows you ask for, as JSON, NDJSON or CSV, from the same typed rows as the files. It needs no key. Rows: https://publicdata.au/api/v1/datasets/qld-pool-safety-certificates/rows. Counts and sums: https://publicdata.au/api/v1/datasets/qld-pool-safety-certificates/aggregate. - Rows: https://publicdata.au/api/v1/datasets/qld-pool-safety-certificates/rows?limit=5 - Aggregate: https://publicdata.au/api/v1/datasets/qld-pool-safety-certificates/aggregate?group=shared_pool_property&metric=count 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 with `ilike`. 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`. - `select`: Fields to return, comma-separated. Every field when absent. - `order`: `field.asc` or `field.desc`, comma-separated. The publisher's row order when absent. - `limit`: Rows per page, 1 to 10,000. 100 when absent. - `offset`: Rows to skip. The `next` URL in each answer sets it for you. - `group`: On `aggregate`, fields to group by, comma-separated. - `metric`: On `aggregate`, `count`, `sum.field`, `avg.field`, `min.field` or `max.field`, comma-separated. `count` when absent. - `format`: `json`, `ndjson` or `csv`. JSON carries the provenance header, and the others carry it in response headers. Without a version the API answers from the newest loaded version, and that answer changes when the publisher releases again. Put `versions//` before `rows` or `aggregate` for an answer that never changes. `/api/v1/datasets//versions` lists the loaded versions. The API allows 60 requests in 10 seconds from one address. Above that it answers 429 for 10 seconds with a `Retry-After` header, a `RateLimit-Policy` header and a JSON body that gives the limit. Every API answer carries the same `RateLimit-Policy`. A client should wait the `Retry-After` seconds, or read the files, which have no limit. OpenAPI for this dataset: https://publicdata.au/d/qld-pool-safety-certificates/openapi.json ## Explore Charts and dashboards in the browser: https://publicdata.au/d/qld-pool-safety-certificates/explore/. A dashboard can be shared as a link or embedded. ## Fields | field | type | publisher's header | note | |---|---|---|---| | `site_name` | string | Site Name | The lot and plan of the property, as the register gives it. | | `unit_number` | string | Unit Number | | | `street_number` | string | Street Number | | | `street_name` | string | Street Name | | | `street_type` | string | Street Type | | | `suburb` | string | Suburb | As entered. Some rows are in capitals and some are not. | | `post_code` | string | Post Code | Kept as text. Blank on some rows. | | `date_submitted` | date | Date Submitted | | | `number_of_pools` | integer | Number of Pools | | | `local_government_authority_area` | string | Local Government Authority Area C | As entered. The same council can appear in capitals and in mixed case. | | `shared_pool_property` | string | Shared Pool Property C | Yes or No. | ## Versions - 2024-09-02: 113800 rows, 11 fields, sha256 454c50cc442a. https://publicdata.au/d/qld-pool-safety-certificates/v/2024-09-02/ Machine-readable: https://publicdata.au/d/qld-pool-safety-certificates/versions.json, https://publicdata.au/d/qld-pool-safety-certificates/changes.json, https://publicdata.au/d/qld-pool-safety-certificates/datapackage.json, https://publicdata.au/d/qld-pool-safety-certificates/schema.json, https://publicdata.au/d/qld-pool-safety-certificates/history.tar.zst ## Part of Pool safety register, Queensland - [Register of regulated pools, Queensland](https://publicdata.au/d/qld-pool-safety-register-pools/) - [Licensed pool safety inspectors, Queensland](https://publicdata.au/d/qld-pool-safety-inspectors/) ## Attribution and citation 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. The licence requires the publisher's attribution. We ask that you also name publicdata.au and link to the version you used. Plain text: 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. Serialised and versioned by National Digital at publicdata.au, https://publicdata.au/d/qld-pool-safety-certificates/v/2024-09-02/ Harvard: Queensland Building and Construction Commission (2024) Properties with pool safety certificates, Queensland, version 2024-09-02 [data set], CC BY 4.0, sourced 3 October 2026. Serialised and versioned by National Digital at publicdata.au. Available at: https://publicdata.au/d/qld-pool-safety-certificates/v/2024-09-02/ Markdown: Data: [Pool safety register, Queensland](https://www.data.qld.gov.au/dataset/poolsafetyregister), Queensland Building and Construction Commission, [CC BY 4.0](https://creativecommons.org/licenses/by/4.0/), sourced 3 October 2026. Files: [publicdata.au](https://publicdata.au/d/qld-pool-safety-certificates/v/2024-09-02/) by [National Digital](https://nationaldigital.com.au/). ## Questions ### How do I download Properties with pool safety certificates as a CSV file? Open https://publicdata.au/d/qld-pool-safety-certificates/latest/data.csv. It redirects to the newest dated version, which is https://publicdata.au/d/qld-pool-safety-certificates/v/2024-09-02/data.csv today. The same path serves Excel, JSON, Parquet, SQLite, DuckDB, NDJSON, Arrow. A dated URL never changes, so use it when the file must stay the same. ### Can I open Properties with pool safety certificates in Excel? Yes. https://publicdata.au/d/qld-pool-safety-certificates/v/2024-09-02/data.xlsx is a workbook with the 113,800 rows on a records sheet, the field list on a second sheet and the provenance on a third. The CSV also opens in Excel. https://publicdata.au/d/qld-pool-safety-certificates/v/2024-09-02/data.csv.gz is the CSV at about a tenth of the size. ### What years does Properties with pool safety certificates cover? The current version covers 2011 to 2023. Each release from QBCC becomes a new dated version here, and earlier versions stay online. ### How often is Properties with pool safety certificates updated? QBCC releases it irregularly. This site checks the portal every week and adds a dated version when the file changes. ### Can I use Properties with pool safety certificates commercially? Yes. CC BY 4.0 allows commercial use, redistribution and derived works as long as the attribution is kept. The attribution string is in this page's side column and inside every file. ### Is this the official source for Properties with pool safety certificates? No. The publisher is Queensland Building and Construction Commission, and its page is https://www.data.qld.gov.au/dataset/poolsafetyregister. This site republishes the publisher's file without changing its content. The original sits beside every version as source.csv with its SHA-256, so the two can be compared. ### What is in each row? Each row is one property for which a pool safety certificate was lodged, with its lot and plan, street address, the date the certificate was submitted, the number of pools, the local government area and whether the pool is shared. ### Does a row mean the certificate is still valid? No. The row records that a certificate was submitted on the date shown. A certificate for a non-shared pool lasts one year and for a shared pool two years, so an old date may have lapsed. ## What this site did to the data Cells were typed, headers were renamed to snake_case and the encoding was made UTF-8. Rows were left alone. Nothing is derived. The publisher's file is beside every version as `source.csv`. ## Improve this dataset This page is built from [register/qld-pool-safety-certificates.yaml](https://github.com/National-Digital/publicdata.au/blob/main/register/qld-pool-safety-certificates.yaml) on GitHub, and a fix to it is welcome as a pull request. https://publicdata.au/contribute/ explains how.