--- title: Liquor licensed premises, New South Wales resource: https://publicdata.au/d/nsw-liquor-licence-premises/ publisher: Liquor and Gaming NSW licence: CC BY 4.0 licence_url: https://creativecommons.org/licenses/by/4.0/ version: 2024-06-18 rows: 19233 fields: 36 source: https://data.nsw.gov.au/data/dataset/297dfb0e-3b94-433b-be64-3bb0905e28a4/resource/3d905957-13aa-4fd8-abda-91860169fb5b/download/premises-list-as-at-7-jun-2024.csv source_sha256: 3ced76483494c19200230b8d200d48db0c345ad906537135324e1cc4274347ad language: en-AU operator: National Digital not_endorsed: true --- # Liquor licensed premises, New South Wales Every liquor licence in New South Wales in June 2024 with the venue's address and coordinates, licence type, trading hours and gaming machine numbers, from Liquor and Gaming NSW's monthly premises list. Published by Liquor and Gaming NSW under CC BY 4.0 and republished here in other formats, with cells typed and suppressed values made null. Liquor and Gaming NSW has not endorsed this site. Also called: NSW liquor licence premises list, NSW pubs and clubs list with poker machines, Liquor licences by venue NSW, NSW gaming machine numbers by venue. ## Download Latest version, redirects to `https://publicdata.au/d/nsw-liquor-licence-premises/v/2024-06-18/`: - csv: https://publicdata.au/d/nsw-liquor-licence-premises/latest/data.csv (6.7 MB) - xlsx: https://publicdata.au/d/nsw-liquor-licence-premises/latest/data.xlsx (3.3 MB) - json: https://publicdata.au/d/nsw-liquor-licence-premises/latest/data.json (16 MB) - geojson: https://publicdata.au/d/nsw-liquor-licence-premises/latest/data.geojson (18 MB) - parquet: https://publicdata.au/d/nsw-liquor-licence-premises/latest/data.parquet (1.2 MB) - sqlite: https://publicdata.au/d/nsw-liquor-licence-premises/latest/data.sqlite (5.7 MB) - duckdb: https://publicdata.au/d/nsw-liquor-licence-premises/latest/data.duckdb (2.0 MB) - gpkg: https://publicdata.au/d/nsw-liquor-licence-premises/latest/data.gpkg (7.1 MB) - geo.parquet: https://publicdata.au/d/nsw-liquor-licence-premises/latest/data.geo.parquet (1.1 MB) - ndjson: https://publicdata.au/d/nsw-liquor-licence-premises/latest/data.ndjson (16 MB) - arrow: https://publicdata.au/d/nsw-liquor-licence-premises/latest/data.arrow (1.7 MB) - csv.gz: https://publicdata.au/d/nsw-liquor-licence-premises/latest/data.csv.gz (1.2 MB) Pinned version 2024-06-18: `https://publicdata.au/d/nsw-liquor-licence-premises/v/2024-06-18/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/nsw-liquor-licence-premises/rows. Counts and sums: https://publicdata.au/api/v1/datasets/nsw-liquor-licence-premises/aggregate. - Rows: https://publicdata.au/api/v1/datasets/nsw-liquor-licence-premises/rows?status=eq.Current&limit=5 - Aggregate: https://publicdata.au/api/v1/datasets/nsw-liquor-licence-premises/aggregate?group=licence_type&metric=count&status=eq.Current 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/nsw-liquor-licence-premises/openapi.json ## Explore Charts and dashboards in the browser: https://publicdata.au/d/nsw-liquor-licence-premises/explore/. A dashboard can be shared as a link or embedded. ## Smaller files - by `licence_type`: https://publicdata.au/d/nsw-liquor-licence-premises/v/2024-06-18/by/licence_type/index.json lists 8 files ## Fields | field | type | publisher's header | note | |---|---|---|---| | `licence_number` | string | Licence number | | | `licence_type` | string | Licence type | | | `start_date` | datetime | Start date | | | `status` | string | Status | | | `status_date` | datetime | Status date | | | `trading_status` | string | Trading Status | | | `licence_name` | string | Licence name | | | `address` | string | Address | | | `suburb` | string | Suburb | | | `postcode` | string | Postcode | | | `latitude` | number | Latitude | As published. The publisher does not state the datum. | | `longitude` | number | Longitude | As published. The publisher does not state the datum. | | `lga` | string | LGA | | | `precinct` | string | Precinct | | | `region` | string | Region | | | `licensee_type` | string | Licensee Type | | | `licensee_abn` | string | Licensee ABN | | | `licensee_acn` | string | Licensee ACN | | | `business_type` | string | Business type | | | `authorisation_restriction_name` | string | Authorisation restriction name | | | `extended_trading` | boolean | Extended trading | | | `reduced_trading` | boolean | Reduced trading | | | `primary_service` | boolean | Primary service | | | `right_to_keep_gaming` | boolean | Right to keep gaming | | | `unrestricted` | boolean | Unrestricted | | | `to_12am` | boolean | To 12am | | | `to_3am` | boolean | To 3am | | | `to_5am` | boolean | To 5am | | | `sa2` | string | SA2 | | | `band` | integer | Band | | | `gmes` | integer | GMEs | | | `pmps` | integer | PMPs | | | `auth_limit` | integer | Auth limit | | | `unfulfilled_quota` | integer | Unfulfilled Quota | | | `gmt` | integer | GMT | | | `egms` | integer | EGMs | | ## Versions - 2024-06-18: 19233 rows, 36 fields, sha256 3ced76483494. https://publicdata.au/d/nsw-liquor-licence-premises/v/2024-06-18/ Machine-readable: https://publicdata.au/d/nsw-liquor-licence-premises/versions.json, https://publicdata.au/d/nsw-liquor-licence-premises/changes.json, https://publicdata.au/d/nsw-liquor-licence-premises/datapackage.json, https://publicdata.au/d/nsw-liquor-licence-premises/schema.json, https://publicdata.au/d/nsw-liquor-licence-premises/history.tar.zst ## Same subject, other publishers - [Liquor and gaming licences, South Australia, September 2018](https://publicdata.au/d/sa-liquor-gaming-licences-2018/) (SA) - [Poker machine expenditure by venue, Victoria, last three years](https://publicdata.au/d/vic-gaming-expenditure-by-venue/) (Vic) - [Gaming venues by number of machines, Queensland](https://publicdata.au/d/qld-gaming-machine-ranges/) (Qld) - [Poker machine expenditure by venue, Victoria, 2008-09 to 2021-22](https://publicdata.au/d/vic-gaming-expenditure-by-venue-history/) (Vic) - [Gaming machine data by SA2, Queensland](https://publicdata.au/d/qld-gaming-machines-by-sa2/) (Qld) - [Gaming machine data for clubs, Queensland](https://publicdata.au/d/qld-gaming-machines-clubs/) (Qld) - [Gaming machine data by SA4, Queensland](https://publicdata.au/d/qld-gaming-machines-by-sa4/) (Qld) - [Gaming machine data for hotels, Queensland](https://publicdata.au/d/qld-gaming-machines-hotels/) (Qld) - [Gaming machine data, Queensland totals](https://publicdata.au/d/qld-gaming-machines-total/) (Qld) - [QBCC licensed builders and contractors register, Queensland](https://publicdata.au/d/qld-qbcc-licensed-contractors/) (Qld) - [Occupational licences held by type and region, Queensland, latest count](https://publicdata.au/d/qld-fair-trading-licences-by-region/) (Qld) - [Automatic mutual recognition register, ACT](https://publicdata.au/d/act-mutual-recognition-register/) (ACT) ## Attribution and citation Liquor and Gaming NSW, NSW Government, Liquor licence premises list, sourced 3 October 2026, https://data.nsw.gov.au/data/dataset/liquor-licence-premises-list, 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: Liquor and Gaming NSW, NSW Government, Liquor licence premises list, sourced 3 October 2026, https://data.nsw.gov.au/data/dataset/liquor-licence-premises-list, licensed under CC BY 4.0. Serialised and versioned by National Digital at publicdata.au, https://publicdata.au/d/nsw-liquor-licence-premises/v/2024-06-18/ Harvard: Liquor and Gaming NSW (2024) Liquor licensed premises, New South Wales, version 2024-06-18 [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/nsw-liquor-licence-premises/v/2024-06-18/ Markdown: Data: [Liquor licensed premises, New South Wales](https://data.nsw.gov.au/data/dataset/liquor-licence-premises-list), Liquor and Gaming NSW, [CC BY 4.0](https://creativecommons.org/licenses/by/4.0/), sourced 3 October 2026. Files: [publicdata.au](https://publicdata.au/d/nsw-liquor-licence-premises/v/2024-06-18/) by [National Digital](https://nationaldigital.com.au/). ## Questions ### How do I download Liquor licensed premises as a CSV file? Open https://publicdata.au/d/nsw-liquor-licence-premises/latest/data.csv. It redirects to the newest dated version, which is https://publicdata.au/d/nsw-liquor-licence-premises/v/2024-06-18/data.csv today. The same path serves Excel, JSON, GeoJSON, Parquet, SQLite, DuckDB, GeoPackage, GeoParquet, NDJSON, Arrow. A dated URL never changes, so use it when the file must stay the same. ### Can I open Liquor licensed premises in Excel? Yes. https://publicdata.au/d/nsw-liquor-licence-premises/v/2024-06-18/data.xlsx is a workbook with the 19,233 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/nsw-liquor-licence-premises/v/2024-06-18/data.csv.gz is the CSV at about a tenth of the size. ### What years does Liquor licensed premises cover? The current version covers 1906 to 2023. Each release from Liquor and Gaming NSW becomes a new dated version here, and earlier versions stay online. ### How often is Liquor licensed premises updated? Liquor and Gaming NSW releases it monthly until June 2024. This site checks the portal every week and adds a dated version when the file changes. ### Can I use Liquor licensed premises 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 Liquor licensed premises? No. The publisher is Liquor and Gaming NSW, and its page is https://data.nsw.gov.au/data/dataset/liquor-licence-premises-list. 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 licence type? Every version has one JSON file per value of licence_type, 8 files in the current version, listed with row counts at https://publicdata.au/d/nsw-liquor-licence-premises/v/2024-06-18/by/licence_type/index.json. For example https://publicdata.au/d/nsw-liquor-licence-premises/v/2024-06-18/by/licence_type/liquor-on-premises-licence.json holds the 9,331 rows where licence_type is Liquor - on-premises licence. A GeoJSON file sits beside each one. ### What coordinate system does Liquor licensed premises use? Latitude and longitude in decimal degrees as published. The publisher does not state the datum; GDA94 is the NSW Government's standard and differs from GDA2020 and WGS84 by under 2 metres. The GeoJSON file uses the same coordinates, which is what GeoJSON expects. ### What is in each row? One liquor licence and its premises, with the licence number, type, status and start date, the venue's name, address, council area and coordinates, the licensee type and ABN or ACN, the trading hours it is authorised for, and for venues that keep gaming machines the number of entitlements and of machines operating. ### Why are licensee names not here? The publisher's list names each licensee, many of whom are private people. That column is held back, and the licensee type, ABN and ACN are published. ### How current is it? Liquor and Gaming NSW added a list to the portal each month until June 2024. This entry follows the newest list there, so the latest version is the list as at 7 June 2024. ## 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/nsw-liquor-licence-premises.yaml](https://github.com/National-Digital/publicdata.au/blob/main/register/nsw-liquor-licence-premises.yaml) on GitHub, and a fix to it is welcome as a pull request. https://publicdata.au/contribute/ explains how.