publicdata.au publicdata.au on GitHub

Saleable coal production by year and coal type, Queensland, version 2026-06-10

latest
Rows 36Fields 3Fetched 3 October 2026Source SHA-256 b8f1d8de6ef1149e…

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.xlsx, byte for byte.

Files

  • data.arrow5.4 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.csv904 B 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.json1.8 KB
  • data.csv.gz384 B 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.json4.9 KB JSON: One object with a publicdata header (publisher, licence, attribution, version, source hash), a fields list and a records array of 36 objects with typed values. Blank cells are null.
  • data.ndjson4.6 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.parquet6.2 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.sqlite29 KB SQLite: One database with a records table, a fields table and a publicdata metadata table. Open it with any SQLite client.
  • data.xlsx8.7 KB Excel: One workbook with a records sheet of 36 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.json399 B
  • schema.sql678 B
  • source.xlsx104 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 Natural Resources and Mines, Manufacturing and Regional and Rural Development, Queensland Government, Annual coal statistics, sourced 3 October 2026, https://www.data.qld.gov.au/dataset/annual-coal-statistics, 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.

050M100M150M200M250M2010 Coking: 125,131,0612010 Thermal: 76,970,0792011 Coking: 108,866,6682011 Thermal: 68,419,24020112012 Coking: 120,218,3612012 Thermal: 70,999,8022013 Coking: 142,342,0902013 Thermal: 72,279,31520132014 Coking: 159,692,2752014 Thermal: 75,739,9232015 Coking: 161,636,8012015 Thermal: 79,729,52420152016 Coking: 160,087,4412016 Thermal: 83,572,3322017 Coking: 152,295,8992017 Thermal: 84,480,82220172018 Coking: 156,510,4962018 Thermal: 92,441,2802019 Coking: 160,197,3582019 Thermal: 88,617,30120192020 Coking: 145,652,3042020 Thermal: 78,921,1832021 Coking: 142,765,7322021 Thermal: 78,041,21520212022 Coking: 106,034,4212022 PCI: 32,547,0042022 Thermal: 82,768,4182023 Coking: 102,025,2722023 PCI: 33,270,4432023 Thermal: 88,111,82220232024 Coking: 103,365,5562024 PCI: 33,673,7612024 Thermal: 89,139,4482025 Coking: 98,682,5602025 PCI: 37,379,2752025 Thermal: 91,741,1692025
CokingPCIThermal
Saleable tonnes per year by coal type, 2010 to 2025. A sum of the net output (t) column 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 year, coal_type, with a link to the diff file.