Liquor licence premises list - Premises list (as at August 2020).csv

Premises list (as at August 2020).csv

Download URL: https://uatweb.datansw.links.com.au/data/dataset/297dfb0e-3b94-433b-be64-3bb0905e28a4/resource/4c317574-04c4-4ad1-b266-a0cbfffa378a/download/premises-list-as-at-aug-2020.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].’

Details
Last updated	04/08/2020
Date Created	04/08/2020
File format	CSV
Licence	Creative Commons Attribution

There are no views created for this resource yet.

Additional Information

Field	Value
Title	Premises list (as at August 2020).csv
Data last updated	04/08/2020
Metadata last updated	09/11/2020
Format	CSV
License	Creative Commons Attribution
Size	4.95 MB

Data Dictionary

Label	Type	Description
Licence No.	text
Licence Type	text
Status	text
Start Date	timestamp
Trading Status	text
Licence Name	text
Address	text
Suburb	text
Postcode	numeric
Latitude	numeric
Longitude	numeric
LGA	text
Precinct	text
Licensee Name	text
Business Type Name	text
Authorisation/Restriction Name	text
Extended Trading	text
Reduced Trading	text
Primary Service	text
Right to Keep Gaming	text
Unrestricted	text
After 12am	text
After 3am	text
After 5am	text
SA2	text
Band	numeric
GMEs	numeric
PMPs	numeric
Auth Limit	numeric
Unfld Quota	numeric
GMT	numeric
EGMs	numeric

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": "4c317574-04c4-4ad1-b266-a0cbfffa378a",
  "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: '4c317574-04c4-4ad1-b266-a0cbfffa378a',
        limit: 5,
        q: 'jones'
    })
})
await resp.json()

$json = @'
{
  "resource_id": "4c317574-04c4-4ad1-b266-a0cbfffa378a",
  "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="4c317574-04c4-4ad1-b266-a0cbfffa378a",
    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 = '4c317574-04c4-4ad1-b266-a0cbfffa378a',
        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": "4c317574-04c4-4ad1-b266-a0cbfffa378a",
  "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: '4c317574-04c4-4ad1-b266-a0cbfffa378a', filters: {
        subject: ['watershed', 'survey'],
        stage: 'active'
    }})})
await resp.json()

$json = @'
{
  "resource_id": "4c317574-04c4-4ad1-b266-a0cbfffa378a",
  "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="4c317574-04c4-4ad1-b266-a0cbfffa378a",
    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='4c317574-04c4-4ad1-b266-a0cbfffa378a', 
        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=4c317574-04c4-4ad1-b266-a0cbfffa378a&limit=5

Query example (results containing 'jones')

https://uatweb.datansw.links.com.au/data/api/action/datastore_search?resource_id=4c317574-04c4-4ad1-b266-a0cbfffa378a&q=jones