publicdata.au publicdata.au on GitHub

Coal exports and sales value by country, Queensland, version 2026-06-10

latest
Rows 1,129Fields 6Fetched 3 October 2026Source SHA-256 304e60eb7a291cfe…

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.arrow27 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.csv72 KB 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.3 KB
  • data.csv.gz18 KB 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.json167 KB JSON: One object with a publicdata header (publisher, licence, attribution, version, source hash), a fields list and a records array of 1,129 objects with typed values. Blank cells are null.
  • data.ndjson166 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.parquet23 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.sqlite131 KB SQLite: One database with a records table, a fields table and a publicdata metadata table. Open it with any SQLite client.
  • data.xlsx48 KB Excel: One workbook with a records sheet of 1,129 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.6 KB
  • schema.json736 B
  • schema.sql856 B
  • source.xlsx153 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.

Smaller files by field: by/year/.

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 Hard Coking Coal: 96,073,4322010 Semi-Soft Coking Coal: 34,483,0492010 Thermal Coal: 55,404,0792011 Hard Coking Coal: 81,323,6902011 Semi-Soft Coking Coal: 27,822,7192011 Thermal Coal: 44,015,85220112012 Hard Coking Coal: 81,450,4732012 Semi-Soft Coking Coal: 38,168,9522012 Thermal Coal: 48,200,0922013 Hard Coking Coal: 97,284,9952013 Semi-Soft Coking Coal: 45,023,1262013 Thermal Coal: 53,729,31920132014 Hard Coking Coal: 110,856,5022014 Semi-Soft Coking Coal: 49,528,0262014 Thermal Coal: 54,787,7552015 Hard Coking Coal: 112,467,6202015 Semi-Soft Coking Coal: 47,864,3502015 Thermal Coal: 58,307,94520152016 Hard Coking Coal: 113,476,9322016 Semi-Soft Coking Coal: 46,221,2722016 Thermal Coal: 60,702,5552017 Hard Coking Coal: 106,861,9392017 Semi-Soft Coking Coal: 44,664,1122017 Thermal Coal: 58,654,39220172018 Hard Coking Coal: 113,552,9982018 Semi-Soft Coking Coal: 43,938,3082018 Thermal Coal: 65,812,8482019 Hard Coking Coal: 113,743,7802019 Semi-Soft Coking Coal: 45,271,2132019 Thermal Coal: 61,787,15420192020 Hard Coking Coal: 110,817,9212020 Semi-Soft Coking Coal: 41,094,0602020 Thermal Coal: 52,523,5542021 Hard Coking Coal: 102,176,7822021 Semi-Soft Coking Coal: 41,039,4572021 Thermal Coal: 52,604,14920212022 Hard Coking Coal: 94,183,1452022 PCI: 30,486,2142022 Semi-Soft Coking Coal: 12,460,1962022 Thermal Coal: 56,019,3712023 Hard Coking Coal: 89,498,7862023 PCI: 32,788,8442023 Semi-Soft Coking Coal: 10,921,7772023 Thermal Coal: 66,180,93520232024 Hard Coking Coal: 91,867,0372024 PCI: 34,582,9542024 Semi-Soft Coking Coal: 10,475,1392024 Thermal Coal: 67,479,3982025 Hard Coking Coal: 86,526,7292025 PCI: 35,835,2652025 Semi-Soft Coking Coal: 9,339,0282025 Thermal Coal: 68,444,8472025
Hard Coking CoalPCISemi-Soft Coking CoalThermal Coal
Tonnes exported per year by coal type, 2010 to 2025. A sum of the tonnes exported 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 country, year, coal_type, with a link to the diff file.