publicdata.au publicdata.au on GitHub

Yearly traffic counts by station, New South Wales, version 2026-10-11

Rows 276,877Fields 22Fetched 12 October 2026Source SHA-256 52016d8b9f1b7ebe…

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.csv43 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.json4.9 KB
  • data.csv.gz3.8 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.ndjson154 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.parquet2.4 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.sqlite40 MB SQLite: One database with a records table, a fields table and a publicdata metadata table. Open it with any SQLite client.
  • data.xlsx21 MB Excel: One workbook with a records sheet of 276,877 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.json2.8 KB
  • schema.json2.6 KB
  • schema.sql1.1 KB
  • source.csv50 MB

JSON is not offered because the table is 153.6 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.

Smaller files by field: by/year/.

Change from 2026-10-04

832 rows added, 832 removed and 0 changed by the key cartodb_id. The full list is in diff/2026-10-04..2026-10-11.json.

Attribution the licence asks for

Transport for NSW, NSW Government, NSW Roads Traffic Volume Counts API, sourced 12 October 2026, https://data.nsw.gov.au/data/dataset/2-nsw-roads-traffic-volume-counts-api, licensed under CC BY 4.0.

Provenance

Fetched from opendata.transport.nsw.gov.au on 12 October 2026. The portal listed the licence as Creative Commons Attribution at that moment. manifest.json has every detail.

010k20k30k40k2006: 10,9192007: 18,34720072008: 22,8722009: 27,8332010: 20,41320102011: 23,1322012: 31,1652013: 37,16320132014: 36,9352015: 30,2252016: 33,35220162017: 28,3352018: 29,3982019: 25,93220192020: 22,8012021: 21,1702022: 23,26120222023: 22,1422024: 21,3062025: 19,4862025
Average daily vehicles, both directions, across the stations counted in the year per year, 2006 to 2025. Rows where period is ALL DAYS and traffic direction seq is 2 and classification seq is at most 1 are drawn. 2026 is not drawn because the year was not over when the publisher released this version on 11 October 2026. An average of the traffic count column in this version, worked out in the build.
Change from the version before

+832 added · −832 removed · 0 changed

Against 2026-10-04, by the key cartodb_id. The full list is in diff/2026-10-04..2026-10-11.json.

Other versions: 2026-09-04, 2026-10-04, 2026-11-04.