--- title: Liquor and gaming licences, South Australia, September 2018 resource: https://publicdata.au/d/sa-liquor-gaming-licences-2018/ publisher: Attorney-General's Department licence: CC BY 4.0 licence_url: https://creativecommons.org/licenses/by/4.0/ version: 2018-09-04 rows: 6736 fields: 17 source: https://data.sa.gov.au/data/dataset/cf466291-8740-4b54-ae11-8c98c347f201/resource/3ea20b6b-b018-48bc-8d6c-0a43c00369f4/download/lglicences20180827.xlsx source_sha256: 178a279ead4409eb4896a878ba0433fc5041b64bedb2de1e974c7ef67a55a545 language: en-AU operator: National Digital not_endorsed: true --- # Liquor and gaming licences, South Australia, September 2018 Every liquor licence in South Australia in September 2018 with its premises, status and issue date, and the gaming machine licence and number of machines where the premises held one. Closed snapshot. Published by Attorney-General's Department under CC BY 4.0 and republished here in other formats, with cells typed and suppressed values made null. Attorney-General's Department has not endorsed this site. Also called: SA Liquor and Gaming Licences, South Australian liquor licence register 2018, SA hotels with gaming machines. ## Download Latest version, redirects to `https://publicdata.au/d/sa-liquor-gaming-licences-2018/v/2018-09-04/`: - csv: https://publicdata.au/d/sa-liquor-gaming-licences-2018/latest/data.csv (963 KB) - xlsx: https://publicdata.au/d/sa-liquor-gaming-licences-2018/latest/data.xlsx (582 KB) - json: https://publicdata.au/d/sa-liquor-gaming-licences-2018/latest/data.json (2.7 MB) - parquet: https://publicdata.au/d/sa-liquor-gaming-licences-2018/latest/data.parquet (261 KB) - sqlite: https://publicdata.au/d/sa-liquor-gaming-licences-2018/latest/data.sqlite (856 KB) - duckdb: https://publicdata.au/d/sa-liquor-gaming-licences-2018/latest/data.duckdb (500 KB) - ndjson: https://publicdata.au/d/sa-liquor-gaming-licences-2018/latest/data.ndjson (2.7 MB) - arrow: https://publicdata.au/d/sa-liquor-gaming-licences-2018/latest/data.arrow (361 KB) - csv.gz: https://publicdata.au/d/sa-liquor-gaming-licences-2018/latest/data.csv.gz (241 KB) Pinned version 2018-09-04: `https://publicdata.au/d/sa-liquor-gaming-licences-2018/v/2018-09-04/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/sa-liquor-gaming-licences-2018/rows. Counts and sums: https://publicdata.au/api/v1/datasets/sa-liquor-gaming-licences-2018/aggregate. - Rows: https://publicdata.au/api/v1/datasets/sa-liquor-gaming-licences-2018/rows?limit=5 - Aggregate: https://publicdata.au/api/v1/datasets/sa-liquor-gaming-licences-2018/aggregate?group=town&metric=sum.gaming_machines 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/sa-liquor-gaming-licences-2018/openapi.json ## Explore Charts and dashboards in the browser: https://publicdata.au/d/sa-liquor-gaming-licences-2018/explore/. A dashboard can be shared as a link or embedded. ## Smaller files - by `liquor_status`: https://publicdata.au/d/sa-liquor-gaming-licences-2018/v/2018-09-04/by/liquor_status/index.json lists 2 files ## Fields | field | type | publisher's header | note | |---|---|---|---| | `licence_id` | integer | LIC_ID | | | `licence_number` | string | LN_LicenceNumber | | | `premises_name` | string | PN_Name | | | `address_1` | string | LIC_PremisesAddress1 | | | `address_2` | string | LIC_PremisesAddress2 | | | `town` | string | LIC_PremisesTown | | | `postcode` | string | LIC_PremisesPostCode | | | `state` | string | LIC_PremisesState | | | `liquor_status` | string | Liquor_Status | | | `liquor_date_issued` | string | Liquor_DateIssued | As published. Most are a date, such as 1954-12-18, and some carry a time with fractions of a second, which the build cannot type as a date. | | `liquor_en` | boolean | Liq_EN | A yes or no flag the publisher sets on the liquor licence, named EN. | | `liquor_et` | boolean | Liq_ET | A yes or no flag the publisher sets on the liquor licence, named ET. | | `liquor_ex` | boolean | Liq_EX | A yes or no flag the publisher sets on the liquor licence, named EX. | | `liquor_c` | boolean | Liq_C | A yes or no flag the publisher sets on the liquor licence, named C. | | `gaming_status` | string | Gaming_Status | | | `gaming_date_issued` | string | Gaming_DateIssued | As published. Most are a date, such as 1954-12-18, and some carry a time with fractions of a second, which the build cannot type as a date. | | `gaming_machines` | integer | Gaming_Machines | | Key: `licence_id`. ## Versions - 2018-09-04: 6736 rows, 17 fields, sha256 178a279ead44. https://publicdata.au/d/sa-liquor-gaming-licences-2018/v/2018-09-04/ Machine-readable: https://publicdata.au/d/sa-liquor-gaming-licences-2018/versions.json, https://publicdata.au/d/sa-liquor-gaming-licences-2018/changes.json, https://publicdata.au/d/sa-liquor-gaming-licences-2018/datapackage.json, https://publicdata.au/d/sa-liquor-gaming-licences-2018/schema.json, https://publicdata.au/d/sa-liquor-gaming-licences-2018/history.tar.zst ## Same subject, other publishers - [Liquor licensed premises, New South Wales](https://publicdata.au/d/nsw-liquor-licence-premises/) (NSW) - [Gaming venues by number of machines, Queensland](https://publicdata.au/d/qld-gaming-machine-ranges/) (Qld) - [Gaming machine data for hotels, Queensland](https://publicdata.au/d/qld-gaming-machines-hotels/) (Qld) - [Current liquor licences by location, Victoria](https://publicdata.au/d/vic-liquor-licences/) (Vic) - [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) - [Gaming machine data by SA2, Queensland](https://publicdata.au/d/qld-gaming-machines-by-sa2/) (Qld) - [Gaming machine data by SA4, Queensland](https://publicdata.au/d/qld-gaming-machines-by-sa4/) (Qld) - [Gaming machine data for clubs, Queensland](https://publicdata.au/d/qld-gaming-machines-clubs/) (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) ## Attribution and citation Attorney-General's Department, Government of South Australia, Liquor & Gaming Licences, https://data.sa.gov.au/data/dataset/liquor-gaming-licences, accessed 3 October 2026, 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: Attorney-General's Department, Government of South Australia, Liquor & Gaming Licences, https://data.sa.gov.au/data/dataset/liquor-gaming-licences, accessed 3 October 2026, licensed under CC BY 4.0. Serialised and versioned by National Digital at publicdata.au, https://publicdata.au/d/sa-liquor-gaming-licences-2018/v/2018-09-04/ Harvard: Attorney-General's Department (2018) Liquor and gaming licences, South Australia, September 2018, version 2018-09-04 [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/sa-liquor-gaming-licences-2018/v/2018-09-04/ Markdown: Data: [Liquor and gaming licences, South Australia, September 2018](https://data.sa.gov.au/data/dataset/liquor-gaming-licences), Attorney-General's Department, [CC BY 4.0](https://creativecommons.org/licenses/by/4.0/), sourced 3 October 2026. Files: [publicdata.au](https://publicdata.au/d/sa-liquor-gaming-licences-2018/v/2018-09-04/) by [National Digital](https://nationaldigital.com.au/). ## Questions ### How do I download Liquor and gaming licences, South Australia as a CSV file? Open https://publicdata.au/d/sa-liquor-gaming-licences-2018/latest/data.csv. It redirects to the newest dated version, which is https://publicdata.au/d/sa-liquor-gaming-licences-2018/v/2018-09-04/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 Liquor and gaming licences, South Australia in Excel? Yes. https://publicdata.au/d/sa-liquor-gaming-licences-2018/v/2018-09-04/data.xlsx is a workbook with the 6,736 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/sa-liquor-gaming-licences-2018/v/2018-09-04/data.csv.gz is the CSV at about a tenth of the size. ### What years does Liquor and gaming licences, South Australia cover? The current version covers the years since 2018. Each release from Attorney-General's becomes a new dated version here, and earlier versions stay online. ### How often is Liquor and gaming licences, South Australia updated? Attorney-General's no longer updates it. This site checks the portal every week and adds a dated version when the file changes. ### Can I use Liquor and gaming licences, South Australia 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 and gaming licences, South Australia? No. The publisher is Attorney-General's Department, and its page is https://data.sa.gov.au/data/dataset/liquor-gaming-licences. This site republishes the publisher's file without changing its content. The original sits beside every version as source.xlsx with its SHA-256, so the two can be compared. ### How do I get only the rows for one liquor status? Every version has one JSON file per value of liquor_status, 2 files in the current version, listed with row counts at https://publicdata.au/d/sa-liquor-gaming-licences-2018/v/2018-09-04/by/liquor_status/index.json. For example https://publicdata.au/d/sa-liquor-gaming-licences-2018/v/2018-09-04/by/liquor_status/l-current.json holds the 6,601 rows where liquor_status is L Current. ### What is in each row? One liquor licence current or suspended in September 2018, with its licence number, the premises' name and address, the liquor licence status and issue date, four yes or no flags the publisher sets on the licence, and where the premises also holds a gaming machine licence, its status, issue date and number of machines. ### Is this the current list? No. It is the September 2018 snapshot. The portal also holds earlier snapshots from 2013 to 2017 and a later one from August 2019. Venues may have opened, closed or changed since. ### What does NULL mean? The publisher writes NULL where a field is empty, such as the gaming columns for premises without gaming machines. Those cells are null here. ## 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.xlsx`. ## Improve this dataset This page is built from [register/sa-liquor-gaming-licences-2018.yaml](https://github.com/National-Digital/publicdata.au/blob/main/register/sa-liquor-gaming-licences-2018.yaml) on GitHub, and a fix to it is welcome as a pull request. https://publicdata.au/contribute/ explains how.