--- title: Gambling expenditure by stream, Queensland resource: https://publicdata.au/d/qld-gambling-expenditure/ publisher: Office of Liquor and Gaming Regulation licence: CC BY 4.0 licence_url: https://creativecommons.org/licenses/by/4.0/ version: 2026-09-16 rows: 1324 fields: 3 source: https://www.data.qld.gov.au/dataset/143e6a32-b767-46ba-9191-0e210720fe2e/resource/25eacd43-e0ce-431e-8314-ab37d57ef645/download/monthly-player-expenditure-data-for-all-gaming-streams-in-queensland.csv source_sha256: e615bc52290e1151eae580adba5e489812fec58e949c5c84a85d2b55c26887ec language: en-AU operator: National Digital not_endorsed: true --- # Gambling expenditure by stream, Queensland The amount players lost each month in Queensland on casinos, gaming machines, keno, lotteries and wagering, since July 2004. Published by Office of Liquor and Gaming Regulation under CC BY 4.0 and republished here in other formats, with cells typed and suppressed values made null. Office of Liquor and Gaming Regulation has not endorsed this site. Also called: All Gambling Data Queensland, Queensland gambling losses by type, Queensland casino, lottery, keno and wagering expenditure. ## Download Latest version, redirects to `https://publicdata.au/d/qld-gambling-expenditure/v/2026-09-16/`: - csv: https://publicdata.au/d/qld-gambling-expenditure/latest/data.csv (41 KB) - xlsx: https://publicdata.au/d/qld-gambling-expenditure/latest/data.xlsx (35 KB) - json: https://publicdata.au/d/qld-gambling-expenditure/latest/data.json (107 KB) - parquet: https://publicdata.au/d/qld-gambling-expenditure/latest/data.parquet (18 KB) - sqlite: https://publicdata.au/d/qld-gambling-expenditure/latest/data.sqlite (106 KB) - duckdb: https://publicdata.au/d/qld-gambling-expenditure/latest/data.duckdb (100 KB) - ndjson: https://publicdata.au/d/qld-gambling-expenditure/latest/data.ndjson (106 KB) - arrow: https://publicdata.au/d/qld-gambling-expenditure/latest/data.arrow (17 KB) - csv.gz: https://publicdata.au/d/qld-gambling-expenditure/latest/data.csv.gz (12 KB) Pinned version 2026-09-16: `https://publicdata.au/d/qld-gambling-expenditure/v/2026-09-16/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-gambling-expenditure/rows. Counts and sums: https://publicdata.au/api/v1/datasets/qld-gambling-expenditure/aggregate. - Rows: https://publicdata.au/api/v1/datasets/qld-gambling-expenditure/rows?month=eq.2026-07-01&limit=5 - Aggregate: https://publicdata.au/api/v1/datasets/qld-gambling-expenditure/aggregate?group=game_stream&metric=sum.player_expenditure&month=eq.2026-07-01 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-gambling-expenditure/openapi.json ## Explore Charts and dashboards in the browser: https://publicdata.au/d/qld-gambling-expenditure/explore/. A dashboard can be shared as a link or embedded. ## Smaller files - by `game_stream`: https://publicdata.au/d/qld-gambling-expenditure/v/2026-09-16/by/game_stream/index.json lists 6 files ## Fields | field | type | publisher's header | note | |---|---|---|---| | `month` | date | Month Year | First day of the month the figure is for. | | `game_stream` | string | Game Stream | Casino, EGM, Keno, Lottery or Wagering. | | `player_expenditure` | number | Player Expenditure $ | The amount players lost in the month, in dollars. | Key: `month, game_stream`. ## Versions - 2026-09-16: 1324 rows, 3 fields, sha256 e615bc52290e. https://publicdata.au/d/qld-gambling-expenditure/v/2026-09-16/ Machine-readable: https://publicdata.au/d/qld-gambling-expenditure/versions.json, https://publicdata.au/d/qld-gambling-expenditure/changes.json, https://publicdata.au/d/qld-gambling-expenditure/datapackage.json, https://publicdata.au/d/qld-gambling-expenditure/schema.json, https://publicdata.au/d/qld-gambling-expenditure/history.tar.zst ## Part of Gaming machine and gambling data from Queensland - [Gaming machine data by SA2, Queensland](https://publicdata.au/d/qld-gaming-machines-by-sa2/) - [Gaming machine data by SA4, Queensland](https://publicdata.au/d/qld-gaming-machines-by-sa4/) - [Gaming machine data for clubs, Queensland](https://publicdata.au/d/qld-gaming-machines-clubs/) - [Gaming machine data for hotels, Queensland](https://publicdata.au/d/qld-gaming-machines-hotels/) - [Gaming machine data, Queensland totals](https://publicdata.au/d/qld-gaming-machines-total/) - [Gaming venues by number of machines, Queensland](https://publicdata.au/d/qld-gaming-machine-ranges/) ## Same subject, other publishers - [Poker machine expenditure by venue, Victoria, 2008-09 to 2021-22](https://publicdata.au/d/vic-gaming-expenditure-by-venue-history/) (Vic) - [Poker machine expenditure by venue, Victoria, last three years](https://publicdata.au/d/vic-gaming-expenditure-by-venue/) (Vic) - [Vehicles registered by body type and fuel, ACT](https://publicdata.au/d/act-vehicles-registered/) (ACT) - [Liquor licensed premises, New South Wales](https://publicdata.au/d/nsw-liquor-licence-premises/) (NSW) - [Saleable coal production by year and coal type, Queensland](https://publicdata.au/d/qld-coal-saleable-production/) (Qld) - [Occupational licences held by type and region, Queensland, latest count](https://publicdata.au/d/qld-fair-trading-licences-by-region/) (Qld) - [Liquor and gaming licences, South Australia, September 2018](https://publicdata.au/d/sa-liquor-gaming-licences-2018/) (SA) ## Attribution and citation Office of Liquor and Gaming Regulation, Queensland Government, All Gambling Data Queensland, sourced 3 October 2026, https://www.data.qld.gov.au/dataset/all-gambling-data-queensland, 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: Office of Liquor and Gaming Regulation, Queensland Government, All Gambling Data Queensland, sourced 3 October 2026, https://www.data.qld.gov.au/dataset/all-gambling-data-queensland, licensed under CC BY 4.0. Serialised and versioned by National Digital at publicdata.au, https://publicdata.au/d/qld-gambling-expenditure/v/2026-09-16/ Harvard: Office of Liquor and Gaming Regulation (2026) Gambling expenditure by stream, Queensland, version 2026-09-16 [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-gambling-expenditure/v/2026-09-16/ Markdown: Data: [Gaming machine and gambling data from Queensland](https://www.data.qld.gov.au/dataset/all-gambling-data-queensland), Office of Liquor and Gaming Regulation, [CC BY 4.0](https://creativecommons.org/licenses/by/4.0/), sourced 3 October 2026. Files: [publicdata.au](https://publicdata.au/d/qld-gambling-expenditure/v/2026-09-16/) by [National Digital](https://nationaldigital.com.au/). ## Questions ### How do I download Gambling expenditure by stream as a CSV file? Open https://publicdata.au/d/qld-gambling-expenditure/latest/data.csv. It redirects to the newest dated version, which is https://publicdata.au/d/qld-gambling-expenditure/v/2026-09-16/data.csv today. The same path serves Excel, JSON, Parquet, SQLite, DuckDB, NDJSON, Arrow. A dated URL never changes, so use it when the file must stay the same. ### Can I open Gambling expenditure by stream in Excel? Yes. https://publicdata.au/d/qld-gambling-expenditure/v/2026-09-16/data.xlsx is a workbook with the 1,324 rows on a records sheet, the field list on a second sheet and the provenance on a third. The CSV also opens in Excel. https://publicdata.au/d/qld-gambling-expenditure/v/2026-09-16/data.csv.gz is the CSV at about a tenth of the size. ### What years does Gambling expenditure by stream cover? The current version covers 2004 to 2025. Each release from OLGR becomes a new dated version here, and earlier versions stay online. ### How often is Gambling expenditure by stream updated? OLGR releases it monthly. This site checks the portal every week and adds a dated version when the file changes. ### Can I use Gambling expenditure by stream 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 Gambling expenditure by stream? No. The publisher is Office of Liquor and Gaming Regulation, and its page is https://www.data.qld.gov.au/dataset/all-gambling-data-queensland. This site republishes the publisher's file without changing its content. The original sits beside every version as source.csv with its SHA-256, so the two can be compared. ### How do I get only the rows for one game stream? Every version has one JSON file per value of game_stream, 6 files in the current version, listed with row counts at https://publicdata.au/d/qld-gambling-expenditure/v/2026-09-16/by/game_stream/index.json. For example https://publicdata.au/d/qld-gambling-expenditure/v/2026-09-16/by/game_stream/casino.json holds the 265 rows where game_stream is Casino. ### What is in each row? One gambling stream in one month, with the player expenditure in dollars. Player expenditure is the amount players lost, which is what they bet less what they won. The streams are Casino, EGM (gaming machines in hotels and clubs), Keno, Lottery and Wagering. ### What is the CNP row? The file holds one row for November 2013 with the stream CNP and no amount. The publisher does not define it, and the row is kept as published. ## 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.csv`. ## Improve this dataset This page is built from [register/qld-gambling-expenditure.yaml](https://github.com/National-Digital/publicdata.au/blob/main/register/qld-gambling-expenditure.yaml) on GitHub, and a fix to it is welcome as a pull request. https://publicdata.au/contribute/ explains how.