--- title: Translink origin-destination trips, Queensland resource: https://publicdata.au/d/qld-translink-origin-destination-trips/ publisher: Department of Transport and Main Roads licence: CC BY 4.0 licence_url: https://creativecommons.org/licenses/by/4.0/ version: 2026-08-20 rows: 1123161 fields: 9 source: https://www.data.qld.gov.au/dataset/aeee186f-da4c-41cd-a6b2-85d11c7bd503/resource/463c42eb-a991-46c2-a8a6-09c56e0bd802/download/202607-jul-tl-org-dest-trips.zip source_sha256: aaf9603c5b806334d73155d1a952ab33399e2c8dfa981376a4f06ad66184ff33 language: en-AU operator: National Digital not_endorsed: true --- # Translink origin-destination trips, Queensland The number of Translink public transport trips between each pair of stops in a month, by operator, route, direction, time of day and ticket type. Published by Department of Transport and Main Roads under CC BY 4.0 and republished here in other formats, with cells typed and suppressed values made null. Department of Transport and Main Roads has not endorsed this site. Also called: Translink OD trips, Translink go card origin destination data, Brisbane public transport trips between stops. ## Download Latest version, redirects to `https://publicdata.au/d/qld-translink-origin-destination-trips/v/2026-08-20/`: - csv: https://publicdata.au/d/qld-translink-origin-destination-trips/latest/data.csv (113 MB) - json: https://publicdata.au/d/qld-translink-origin-destination-trips/latest/data.json (246 MB) - parquet: https://publicdata.au/d/qld-translink-origin-destination-trips/latest/data.parquet (2.8 MB) - sqlite: https://publicdata.au/d/qld-translink-origin-destination-trips/latest/data.sqlite (106 MB) - duckdb: https://publicdata.au/d/qld-translink-origin-destination-trips/latest/data.duckdb (10 MB) - ndjson: https://publicdata.au/d/qld-translink-origin-destination-trips/latest/data.ndjson (245 MB) - arrow: https://publicdata.au/d/qld-translink-origin-destination-trips/latest/data.arrow (25 MB) - csv.gz: https://publicdata.au/d/qld-translink-origin-destination-trips/latest/data.csv.gz (5.7 MB) Pinned version 2026-08-20: `https://publicdata.au/d/qld-translink-origin-destination-trips/v/2026-08-20/data.`. Dated versions never change. ## Query The query API returns only the rows you ask for, as JSON, NDJSON or CSV, from the same typed rows as the files. It needs no key. Rows: https://publicdata.au/api/v1/datasets/qld-translink-origin-destination-trips/rows. Counts and sums: https://publicdata.au/api/v1/datasets/qld-translink-origin-destination-trips/aggregate. - Rows: https://publicdata.au/api/v1/datasets/qld-translink-origin-destination-trips/rows?limit=5 - Aggregate: https://publicdata.au/api/v1/datasets/qld-translink-origin-destination-trips/aggregate?group=operator&metric=sum.quantity Each filter is `field=operator.value` in the query string, and every filter must match. A number or date field compares as a number or date, and a text field compares as text. Values are case-sensitive except with `ilike`. Prefix `not.` to negate a filter, as `not.eq.value`. Operators: `eq.value`, `neq.value`, `gt.value`, `gte.value`, `lt.value`, `lte.value`, `like.*text*`, `ilike.*text*`, `in.(a,b,c)`, `is.null`. - `select`: Fields to return, comma-separated. Every field when absent. - `order`: `field.asc` or `field.desc`, comma-separated. The publisher's row order when absent. - `limit`: Rows per page, 1 to 10,000. 100 when absent. - `offset`: Rows to skip. The `next` URL in each answer sets it for you. - `group`: On `aggregate`, fields to group by, comma-separated. - `metric`: On `aggregate`, `count`, `sum.field`, `avg.field`, `min.field` or `max.field`, comma-separated. `count` when absent. - `format`: `json`, `ndjson` or `csv`. JSON carries the provenance header, and the others carry it in response headers. Without a version the API answers from the newest loaded version, and that answer changes when the publisher releases again. Put `versions//` before `rows` or `aggregate` for an answer that never changes. `/api/v1/datasets//versions` lists the loaded versions. The API allows 60 requests in 10 seconds from one address. Above that it answers 429 for 10 seconds with a `Retry-After` header, a `RateLimit-Policy` header and a JSON body that gives the limit. Every API answer carries the same `RateLimit-Policy`. A client should wait the `Retry-After` seconds, or read the files, which have no limit. OpenAPI for this dataset: https://publicdata.au/d/qld-translink-origin-destination-trips/openapi.json ## Explore Charts and dashboards in the browser: https://publicdata.au/d/qld-translink-origin-destination-trips/explore/. A dashboard can be shared as a link or embedded. ## Smaller files - by `operator`: https://publicdata.au/d/qld-translink-origin-destination-trips/v/2026-08-20/by/operator/index.json lists 26 files ## Fields | field | type | publisher's header | note | |---|---|---|---| | `operator` | string | OPERATOR | | | `month` | date | MONTH | First day of the month. | | `route` | string | ROUTE | | | `direction` | string | DIRECTION | | | `time_grouping` | string | TIME_GROUPING | | | `ticket_type` | string | TICKET_TYPE | | | `origin_stop` | string | ORIGIN_STOP | Stop id. Kept as text because some ids start with letters. | | `destination_stop` | string | DESTINATION_STOP | Stop id. Kept as text because some ids start with letters. | | `quantity` | integer | QUANTITY | | ## Versions - 2026-08-20: 1123161 rows, 9 fields, sha256 aaf9603c5b80. https://publicdata.au/d/qld-translink-origin-destination-trips/v/2026-08-20/ Machine-readable: https://publicdata.au/d/qld-translink-origin-destination-trips/versions.json, https://publicdata.au/d/qld-translink-origin-destination-trips/changes.json, https://publicdata.au/d/qld-translink-origin-destination-trips/datapackage.json, https://publicdata.au/d/qld-translink-origin-destination-trips/schema.json, https://publicdata.au/d/qld-translink-origin-destination-trips/history.tar.zst ## Part of Translink origin-destination trips - [Translink origin-destination stops, Queensland](https://publicdata.au/d/qld-translink-origin-destination-stops/) ## Same subject, other publishers - [Annual patronage by metropolitan train station, Melbourne](https://publicdata.au/d/vic-metro-train-station-patronage/) (Vic) - [Annual patronage by regional train station, Victoria](https://publicdata.au/d/vic-regional-train-station-patronage/) (Vic) - [Yearly traffic counts by station, New South Wales](https://publicdata.au/d/nsw-traffic-volume-yearly/) (NSW) - [Road crashes, New South Wales](https://publicdata.au/d/nsw-road-crashes/) (NSW) - [Traffic count stations, New South Wales](https://publicdata.au/d/nsw-traffic-count-stations/) (NSW) - [Registered vehicles by owner postcode, make and body type, South Australia](https://publicdata.au/d/sa-registered-vehicles-by-postcode/) (SA) - [Registered vehicles by colour, make and body type, South Australia](https://publicdata.au/d/sa-registered-vehicles-by-colour/) (SA) - [Driver's licences by postcode, age and sex, South Australia](https://publicdata.au/d/sa-drivers-licences-by-postcode/) (SA) - [Road crash locations, South Australia](https://publicdata.au/d/sa-road-crash-locations/) (SA) - [Traffic volume estimates on state roads, South Australia](https://publicdata.au/d/sa-traffic-volumes/) (SA) - [Registered recreational boats by hull, engine and postcode, South Australia](https://publicdata.au/d/sa-boat-registrations/) (SA) - [Registered vehicles by body type and vehicle type, South Australia](https://publicdata.au/d/sa-registered-vehicles-by-body-type/) (SA) ## Attribution and citation Department of Transport and Main Roads, Queensland Government, Translink Origin-Destination Trips 2022 Onwards, sourced 3 October 2026, https://www.data.qld.gov.au/dataset/translink-origin-destination-trips-2022-onwards, licensed under CC BY 4.0. The licence requires the publisher's attribution. We ask that you also name publicdata.au and link to the version you used. Plain text: Department of Transport and Main Roads, Queensland Government, Translink Origin-Destination Trips 2022 Onwards, sourced 3 October 2026, https://www.data.qld.gov.au/dataset/translink-origin-destination-trips-2022-onwards, licensed under CC BY 4.0. Serialised and versioned by National Digital at publicdata.au, https://publicdata.au/d/qld-translink-origin-destination-trips/v/2026-08-20/ Harvard: Department of Transport and Main Roads (2026) Translink origin-destination trips, Queensland, version 2026-08-20 [data set], CC BY 4.0, sourced 3 October 2026. Serialised and versioned by National Digital at publicdata.au. Available at: https://publicdata.au/d/qld-translink-origin-destination-trips/v/2026-08-20/ Markdown: Data: [Translink origin-destination trips](https://www.data.qld.gov.au/dataset/translink-origin-destination-trips-2022-onwards), Department of Transport and Main Roads, [CC BY 4.0](https://creativecommons.org/licenses/by/4.0/), sourced 3 October 2026. Files: [publicdata.au](https://publicdata.au/d/qld-translink-origin-destination-trips/v/2026-08-20/) by [National Digital](https://nationaldigital.com.au/). ## Questions ### How do I download Translink origin-destination trips as a CSV file? Open https://publicdata.au/d/qld-translink-origin-destination-trips/latest/data.csv. It redirects to the newest dated version, which is https://publicdata.au/d/qld-translink-origin-destination-trips/v/2026-08-20/data.csv today. The same path serves JSON, Parquet, SQLite, DuckDB, NDJSON, Arrow. A dated URL never changes, so use it when the file must stay the same. ### Can I open Translink origin-destination trips in Excel? Not as a workbook. Excel stops at 1,048,576 rows and this table has 1,123,161, so there is no data.xlsx. Load the CSV or the Parquet file with Power Query, or take one partition file at a time. https://publicdata.au/d/qld-translink-origin-destination-trips/v/2026-08-20/data.csv.gz is the CSV at about a tenth of the size. ### How often is Translink origin-destination trips updated? Transport and Main Roads releases it monthly. This site checks the portal every week and adds a dated version when the file changes. ### Can I use Translink origin-destination trips commercially? Yes. CC BY 4.0 allows commercial use, redistribution and derived works as long as the attribution is kept. The attribution string is in this page's side column and inside every file. ### Is this the official source for Translink origin-destination trips? No. The publisher is Department of Transport and Main Roads, and its page is https://www.data.qld.gov.au/dataset/translink-origin-destination-trips-2022-onwards. This site republishes the publisher's file without changing its content. The original sits beside every version as source.zip with its SHA-256, so the two can be compared. ### How do I get only the rows for one operator? Every version has one JSON file per value of operator, 26 files in the current version, listed with row counts at https://publicdata.au/d/qld-translink-origin-destination-trips/v/2026-08-20/by/operator/index.json. For example https://publicdata.au/d/qld-translink-origin-destination-trips/v/2026-08-20/by/operator/transport-for-brisbane.json holds the 590,593 rows where operator is Transport for Brisbane. ### What is in each row? Each row is the number of trips in one month on one operator's route and direction, in one time band and on one ticket type, that began at one stop and ended at another. The stop numbers match the stop_id column of the origin-destination stops table. ### Why do some trips have no origin or destination stop? About one row in ten has a blank stop, and some stops have codes starting DH. The publisher records what its ticketing system logged, and its readme on the portal page explains these cases. They are kept as published. ### Which month does this cover? The publisher adds one file per month. This entry holds July 2026, the newest month at review. Earlier months from January 2022 are on the same portal page. ## What this site did to the data Cells were typed, headers were renamed to snake_case and the encoding was made UTF-8. Rows were left alone. Nothing is derived. The publisher's file is beside every version as `source.zip`. ## Improve this dataset This page is built from [register/qld-translink-origin-destination-trips.yaml](https://github.com/National-Digital/publicdata.au/blob/main/register/qld-translink-origin-destination-trips.yaml) on GitHub, and a fix to it is welcome as a pull request. https://publicdata.au/contribute/ explains how.