Liquor licence premises list - Premises list as of 6 January 2021

Premises list as of 6 January 2021

Back to dataset

Download URL: https://uatweb.datansw.links.com.au/data/dataset/297dfb0e-3b94-433b-be64-3bb0905e28a4/resource/62c1c34f-a9c6-44ea-a28c-59594c703139/download/premises-list-as-of-6-january-2021.csv

Data is subject to Change - The data contained in these reports is current at the time of publication.

Conditions of use of information - A Creative Commons Attributions licence applies to Liquor & Gaming NSW data reports (unless otherwise specified). This work is licenced under the Creative Commons Attribution 4.0 Licence. This licence permits the public distribution, reuse, remix and enhancement of data in reports, as long as the original source of the data is acknowledged. Terms and conditions of the licence can be viewed at creativecommons.org/licenses/by/4.0/. We request attribution as: ‘© State of New South Wales (Department of Customer Service) [YEAR].’

There are no views created for this resource yet.

Additional Information

Field	Value
Title	Premises list as of 6 January 2021
Data last updated	14/01/2021
Metadata last updated	14/01/2021
Format	CSV
License	Creative Commons Attribution
Size	5.23 MB

Data Dictionary

Label	Type	Description
Licence number	text
Licence type	text
Status	text
Start date	text
Trading Status	text
Licence name	text
Address	text
Suburb	text
Postcode	text
Latitude	text
Longitude	text
LGA	text
Precinct	text
Licensee	text
Business type	text
Authorisation restriction name	text
Extended trading	text
Reduced trading	text
Primary service	text
Right to keep gaming	text
Unrestricted	text
After12am	text
After3am	text
After5am	text
SA2	text
Band	text
GMEs	text
PMPs	text
Auth limit	text
Unfulfilled Quota	text
GMT	text
EGMs	text

download Download CSV

Updates
Last updated	14/01/2021
Date Created	14/01/2021
File format	CSV

Licence
Creative Commons Attribution

CKAN Data API

Access resource data via a web API with powerful query support. Further information in the main CKAN Data API and DataStore documentation.

Code examples:

curl JavaScript PowerShell Python R

Querying

Get 5 results containing "jones" in any field:

curl https://uatweb.datansw.links.com.au/data/api/action/datastore_search \
  -H"Authorization:$API_TOKEN" -d '
{
  "resource_id": "62c1c34f-a9c6-44ea-a28c-59594c703139",
  "limit": 5,
  "q": "jones"
}'

const resp = await fetch(`https://uatweb.datansw.links.com.au/data/api/action/datastore_search`, {
    method: 'POST',
    headers: {
        'content-type': 'application/json',
        authorization: API_TOKEN
    },
    body: JSON.stringify({
        resource_id: '62c1c34f-a9c6-44ea-a28c-59594c703139',
        limit: 5,
        q: 'jones'
    })
})
await resp.json()

$json = @'
{
  "resource_id": "62c1c34f-a9c6-44ea-a28c-59594c703139",
  "limit": 5,
  "q": "jones"
}
'@
$response = Invoke-RestMethod https://uatweb.datansw.links.com.au/data/api/action/datastore_search`
  -Method Post -Body $json -Headers @{"Authorization"="$API_TOKEN"}
$response.result.records

(using the ckanapi client library)

from ckanapi import RemoteCKAN

rc = RemoteCKAN('https://uatweb.datansw.links.com.au/data/', apikey=API_TOKEN)
result = rc.action.datastore_search(
    resource_id="62c1c34f-a9c6-44ea-a28c-59594c703139",
    limit=5,
    q="jones",
)
print(result['records'])

library(httr2)

req <- request("https://uatweb.datansw.links.com.au/data/api/action/datastore_search")
result <- req %>% 
    req_headers(Authorization = API_TOKEN) %>% 
    req_body_json(list(
        resource_id = '62c1c34f-a9c6-44ea-a28c-59594c703139',
        limit = 5,
        q = 'jones'))
    req_perform %>% 
    resp_body_json

Get results with either "watershed" or "survey" as subject and "active" as its stage:

curl https://uatweb.datansw.links.com.au/data/api/action/datastore_search \
-H"Authorization:$API_TOKEN" -d '
{
"resource_id": "62c1c34f-a9c6-44ea-a28c-59594c703139",
  "filters": {
    "subject": ["watershed", "survey"],
    "stage": "active"
  }
}'

const resp = await fetch(`https://uatweb.datansw.links.com.au/data/api/action/datastore_search`, {
    method: 'POST',
    headers: {
        'content-type': 'application/json',
        authorization: API_TOKEN
    },
    body: JSON.stringify({resource_id: '62c1c34f-a9c6-44ea-a28c-59594c703139', filters: {
        subject: ['watershed', 'survey'],
        stage: 'active'
    }})})
await resp.json()

$json = @'
{
  "resource_id": "62c1c34f-a9c6-44ea-a28c-59594c703139",
  "filters": {
    "subject": ["watershed", "survey"],
    "stage": "active"
  }
}
'@
$response = Invoke-RestMethod https://uatweb.datansw.links.com.au/data/api/action/datastore_search`
  -Method Post -Body $json -Headers @{"Authorization"="$API_TOKEN"}
$response.result.records

from ckanapi import RemoteCKAN

rc = RemoteCKAN('https://uatweb.datansw.links.com.au/data/', apikey=API_TOKEN)
result = rc.action.datastore_search(
    resource_id="62c1c34f-a9c6-44ea-a28c-59594c703139",
    filters={
      "subject": ["watershed", "survey"],
      "stage": "active",
    },
)
print(result['records'])

library(httr2)

req <- request("https://uatweb.datansw.links.com.au/data/api/action/datastore_search")
result <- req %>% 
    req_headers(Authorization = API_TOKEN) %>% 
    req_body_json(list(
        resource_id='62c1c34f-a9c6-44ea-a28c-59594c703139', 
        filters = list(
            subject = list("watershed", "survey"), 
            stage = "active")))
    req_perform %>% 
    resp_body_json

Using the API with this Web Browser

Some API endpoints may be accessed using a GET query string.

Query example (first 5 results)

https://uatweb.datansw.links.com.au/data/api/action/datastore_search?resource_id=62c1c34f-a9c6-44ea-a28c-59594c703139&limit=5

Query example (results containing 'jones')

https://uatweb.datansw.links.com.au/data/api/action/datastore_search?resource_id=62c1c34f-a9c6-44ea-a28c-59594c703139&q=jones