publicdata.au publicdata.au on GitHub

Translink patronage by mode, rest of Queensland, version 2026-10-07

latest
Rows 155Fields 3Fetched 19 October 2026Source SHA-256 83566a7d42799a9d…

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.csv5.4 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.json1.8 KB
  • data.csv.gz1.1 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.json13 KB JSON: One object with a publicdata header (publisher, licence, attribution, version, source hash), a fields list and a records array of 155 objects with typed values. Blank cells are null.
  • data.ndjson13 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.5 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.sqlite45 KB SQLite: One database with a records table, a fields table and a publicdata metadata table. Open it with any SQLite client.
  • data.xlsx11 KB Excel: One workbook with a records sheet of 155 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.9 KB
  • schema.json454 B
  • schema.sql724 B
  • source.csv4.9 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.

Change from 2026-08-11

5 rows added, 0 removed and 0 changed by the key month, mode. The full list is in diff/2026-08-11..2026-10-07.json.

Attribution the licence asks for

Department of Transport and Main Roads, Queensland Government, Translink monthly performance data, sourced 19 October 2026, https://www.data.qld.gov.au/dataset/translink-monthly-performance-data, licensed under CC BY 3.0 AU.

Provenance

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

05M10M15M2024 Long Distance Bus: 79,8572024 Regional Air: 152,6952024 Regional Ferry: 2,337,5292024 Regional Urban Bus: 8,831,9182024 Traveltrain: 302,97520242025 Long Distance Bus: 79,2322025 Regional Air: 151,9332025 Regional Ferry: 2,385,3212025 Regional Urban Bus: 11,347,5612025 Traveltrain: 328,4742025
Long Distance BusRegional AirRegional FerryRegional Urban BusTraveltrain
Passenger trips per year by mode, 2024 to 2025. Rows where month is at least 2024-01-01 are drawn. 2026 is not drawn because the rows run to 1 May 2026. A sum of the passenger trips column in this version, worked out in the build.
Change from the version before

+5 added · −0 removed · 0 changed

Against 2026-08-11, by the key month, mode. The full list is in diff/2026-08-11..2026-10-07.json.

Other versions: 2026-08-11.