publicdata.au publicdata.au on GitHub

Unclaimed money register, Queensland Public Trustee, version 2026-10-26

latest
Rows 2,560,961Fields 6Fetched 26 October 2026Source SHA-256 38892fb382400051…

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.csv220 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.json2.1 KB
  • data.csv.gz42 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.ndjson429 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.parquet34 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.sqlite229 MB SQLite: One database with a records table, a fields table and a publicdata metadata table. Open it with any SQLite client.
  • manifest.json2.0 KB
  • schema.json756 B
  • schema.sql746 B
  • source.csv256 MB

Excel is not offered because the table is over 1,048,575 rows, which is as many as a worksheet holds below its header row. JSON is not offered because the table is 429.1 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.

Change from 2026-10-19

2,553,652 rows in 2026-10-19 and 2,560,961 in this version. No key is declared, so rows are compared by count only. The comparison is in diff/2026-10-19..2026-10-26.json.

Attribution the licence asks for

The Public Trustee of Queensland, Queensland Government, Unclaimed monies, sourced 26 October 2026, https://www.data.qld.gov.au/dataset/unclaimed-monies, licensed under CC BY 4.0.

Provenance

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

0100k200k300k1917: 761918: 1091919: 781920: 881922: 911923: 101930: 511931: 571932: 461933: 851934: 6819341935: 661936: 941937: 731938: 611939: 711940: 721941: 621942: 481943: 461944: 881945: 831946: 1171947: 13419471948: 1301949: 1251950: 1631951: 2011952: 2811953: 3281954: 3051955: 2811956: 2941957: 2831958: 3181959: 3181960: 27819601961: 2461962: 3531963: 2511964: 2441965: 2481966: 2781967: 2641968: 2941969: 2751970: 2521971: 2811972: 2841973: 24419731974: 2381975: 3271976: 2671977: 2531978: 2131979: 2431980: 1571981: 3851982: 4091983: 3911984: 4001985: 2181986: 49419861987: 3951988: 8501989: 4251990: 3731991: 7561992: 7251993: 5011994: 5571995: 2761996: 3,3661997: 14,0301998: 10,6751999: 38,26319992000: 14,7052001: 16,0512002: 34,3562003: 114,0572004: 21,1822005: 75,0782006: 67,3682007: 67,6982008: 29,9252009: 43,7862010: 34,2372011: 27,6312012: 36,72220122013: 44,9322014: 123,9632015: 143,7492016: 111,6672017: 74,4382018: 111,9342019: 156,7182020: 127,6742021: 94,3672022: 92,9552023: 128,3522024: 264,3742025: 164,5402025
Amounts of unclaimed money received per year, 1917 to 2025. 1916 is not drawn because the rows begin on 1 February 1916. 2026 is not drawn because the rows run to 23 October 2026. A count of rows in this version, worked out in the build.
Change from the version before

2,553,652 rows before, 2,560,961 now

Against 2026-10-19. No key is declared, so rows are compared by count only. The comparison is in diff/2026-10-19..2026-10-26.json.

Other versions: 2026-09-28, 2026-10-19.