--- title: Unclaimed money register, Queensland Public Trustee resource: https://publicdata.au/d/qld-unclaimed-money/ publisher: The Public Trustee of Queensland licence: CC BY 4.0 licence_url: https://creativecommons.org/licenses/by/4.0/ version: 2026-09-28 rows: 2551529 fields: 6 source: https://www.data.qld.gov.au/dataset/1e0d2147-b526-470a-956c-b85b2963aaa4/resource/872065ae-ddfd-4b5f-ad15-e1935dadd883/download/unclaimedmoneyopen.csv source_sha256: 69ee753de777897e6f548da6e8426ec7395faeed31035993051d9691aeb5b7e7 language: en-AU operator: National Digital not_endorsed: true --- # Unclaimed money register, Queensland Public Trustee Each amount of unclaimed money held by the Public Trustee of Queensland, with the owner's name, amount, sender and date received. Published by The Public Trustee of Queensland under CC BY 4.0 and republished here in other formats, with cells typed and suppressed values made null. The Public Trustee of Queensland has not endorsed this site. Also called: Public Trustee unclaimed monies register, Queensland unclaimed money list, Unclaimed money from deceased estates Queensland. ## Download Latest version, redirects to `https://publicdata.au/d/qld-unclaimed-money/v/2026-09-28/`: - csv: https://publicdata.au/d/qld-unclaimed-money/latest/data.csv (219 MB) - parquet: https://publicdata.au/d/qld-unclaimed-money/latest/data.parquet (42 MB) - sqlite: https://publicdata.au/d/qld-unclaimed-money/latest/data.sqlite (228 MB) - duckdb: https://publicdata.au/d/qld-unclaimed-money/latest/data.duckdb (60 MB) - ndjson: https://publicdata.au/d/qld-unclaimed-money/latest/data.ndjson (428 MB) - arrow: https://publicdata.au/d/qld-unclaimed-money/latest/data.arrow (60 MB) - csv.gz: https://publicdata.au/d/qld-unclaimed-money/latest/data.csv.gz (42 MB) Pinned version 2026-09-28: `https://publicdata.au/d/qld-unclaimed-money/v/2026-09-28/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-unclaimed-money/rows. Counts and sums: https://publicdata.au/api/v1/datasets/qld-unclaimed-money/aggregate. - Rows: https://publicdata.au/api/v1/datasets/qld-unclaimed-money/rows?limit=5 - Aggregate: https://publicdata.au/api/v1/datasets/qld-unclaimed-money/aggregate?group=sender_name&metric=sum.amount 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-unclaimed-money/openapi.json ## Explore Charts and dashboards in the browser: https://publicdata.au/d/qld-unclaimed-money/explore/. A dashboard can be shared as a link or embedded. ## Fields | field | type | publisher's header | note | |---|---|---|---| | `client_id_act_no` | string | ClientId_ActNo | | | `owner` | string | Owner | | | `amount` | number | Amount | | | `sender_name` | string | SenderName | | | `date_received` | date | DateRec | | | `postcode` | string | PCode | The owner's last known postcode, kept as text. The publisher gives 0 or a blank where it has none. | ## Versions - 2026-09-28: 2551529 rows, 6 fields, sha256 69ee753de777. https://publicdata.au/d/qld-unclaimed-money/v/2026-09-28/ Machine-readable: https://publicdata.au/d/qld-unclaimed-money/versions.json, https://publicdata.au/d/qld-unclaimed-money/changes.json, https://publicdata.au/d/qld-unclaimed-money/datapackage.json, https://publicdata.au/d/qld-unclaimed-money/schema.json, https://publicdata.au/d/qld-unclaimed-money/history.tar.zst ## Same subject, other publishers - [Automatic mutual recognition register, ACT](https://publicdata.au/d/act-mutual-recognition-register/) (ACT) - [Professional engineers register, ACT](https://publicdata.au/d/act-engineers-register/) (ACT) - [Public holiday dates by state and territory, Australia, 2021 to 2025](https://publicdata.au/d/au-public-holidays-2021-2025/) (Cth) - [Public holidays, New South Wales, 2019 to 2023](https://publicdata.au/d/nsw-public-holidays/) (NSW) - [Social housing maintenance and modification spending, Queensland](https://publicdata.au/d/qld-social-housing-maintenance/) (Qld) - [Victorian public holidays, school terms and other important dates](https://publicdata.au/d/vic-important-dates/) (Vic) ## Attribution and citation The Public Trustee of Queensland, Queensland Government, Unclaimed monies, sourced 3 October 2026, https://www.data.qld.gov.au/dataset/unclaimed-monies, 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: The Public Trustee of Queensland, Queensland Government, Unclaimed monies, sourced 3 October 2026, https://www.data.qld.gov.au/dataset/unclaimed-monies, licensed under CC BY 4.0. Serialised and versioned by National Digital at publicdata.au, https://publicdata.au/d/qld-unclaimed-money/v/2026-09-28/ Harvard: The Public Trustee of Queensland (2026) Unclaimed money register, Queensland Public Trustee, version 2026-09-28 [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-unclaimed-money/v/2026-09-28/ Markdown: Data: [Unclaimed money register, Queensland Public Trustee](https://www.data.qld.gov.au/dataset/unclaimed-monies), The Public Trustee of Queensland, [CC BY 4.0](https://creativecommons.org/licenses/by/4.0/), sourced 3 October 2026. Files: [publicdata.au](https://publicdata.au/d/qld-unclaimed-money/v/2026-09-28/) by [National Digital](https://nationaldigital.com.au/). ## Questions ### How do I download Unclaimed money register as a CSV file? Open https://publicdata.au/d/qld-unclaimed-money/latest/data.csv. It redirects to the newest dated version, which is https://publicdata.au/d/qld-unclaimed-money/v/2026-09-28/data.csv today. The same path serves Parquet, SQLite, DuckDB, NDJSON, Arrow. A dated URL never changes, so use it when the file must stay the same. ### Can I open Unclaimed money register in Excel? Not as a workbook. Excel stops at 1,048,576 rows and this table has 2,551,529, so there is no data.xlsx. Load the CSV or the Parquet file with Power Query, or take one partition file at a time. https://publicdata.au/d/qld-unclaimed-money/v/2026-09-28/data.csv.gz is the CSV at about a tenth of the size. ### What years does Unclaimed money register cover? The current version covers 1917 to 2025. Each release from Public Trustee becomes a new dated version here, and earlier versions stay online. ### How often is Unclaimed money register updated? Public Trustee releases it weekly. This site checks the portal every week and adds a dated version when the file changes. ### Can I use Unclaimed money register 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 Unclaimed money register? No. The publisher is The Public Trustee of Queensland, and its page is https://www.data.qld.gov.au/dataset/unclaimed-monies. 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 amount of unclaimed money held by the Public Trustee of Queensland, with the account number, the owner's name as recorded, the amount in dollars, who sent the money, the date it was received and the owner's postcode where known. ### How do I claim money listed here? Claims are made to the Public Trustee of Queensland, which checks the claimant's identity and entitlement. This copy of the register cannot be used to make a claim. ### What does a postcode of 0 mean? The publisher gives 0 or leaves the cell blank where it has no postcode for the owner. Both are kept as published. ## 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-unclaimed-money.yaml](https://github.com/National-Digital/publicdata.au/blob/main/register/qld-unclaimed-money.yaml) on GitHub, and a fix to it is welcome as a pull request. https://publicdata.au/contribute/ explains how.