Datasets / New South Wales / Liquor and Gaming NSW / Liquor licensed premises, New South Wales / Explore

Explore Liquor licensed premises, New South Wales

Charts and tables over the 19,233 rows of the latest version, worked out in your browser from the Parquet file. Nothing you do here leaves the browser until you save a link.

Paste this where the dashboard should appear. The frame shows the attribution and links back here.

Let readers change the charts in the frame. Their changes stay in their browser and never alter the saved dashboard.

The explorer needs JavaScript and a browser from the last few years. The dataset page has every file and the query API.

Data: 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. Licence terms.

How it works

Change a panel

Press Edit at the top right of a panel to open its settings. Drag fields into Group by, Split by, Sort by and Filter, pick a chart type at the top, and choose sum, count or average beside each number. More fields lists everything else in the dataset. The chart types include bars, lines, areas, scatter plots, heatmaps, treemaps and sunbursts, and maps of the coordinates. Add a chart puts a new panel on the dashboard. Drag a panel's title bar to move it, or drag the line between panels to resize.

Filter every panel at once

The chart marked Click to filter the others does just that: click a bar and the other panels show only those rows. Click it again to clear. Any panel can do the same. Open the menu at the left of its title bar and turn on filtering from there.

Share or keep a dashboard

The address bar holds the whole dashboard, so copying it is enough. Save a short link to store the dashboard on this site and get a shorter address. A saved dashboard never changes; saving again after an edit makes a new link. Embed gives a frame you can paste into a web page, with the attribution inside it.

Download what you see

The export button in a panel's settings toolbar downloads the panel as CSV, JSON or Arrow, or a chart as PNG. The copy button beside it puts the same data on the clipboard. The full files are on the dataset page.

What the fields mean

The explorer names each field in words. The files and the query API use the field name beside it.

In the explorer	Field name	Type	Note
Licence number	licence_number	string
Licence type	licence_type	string
Start date	start_date	datetime
Status	status	string
Status date	status_date	datetime
Trading status	trading_status	string
Licence name	licence_name	string
Address	address	string
Suburb	suburb	string
Postcode	postcode	string
Latitude	latitude	number	As published. The publisher does not state the datum.
Longitude	longitude	number	As published. The publisher does not state the datum.
Council area	lga	string
Precinct	precinct	string
Region	region	string
Licensee type	licensee_type	string
Licensee ABN	licensee_abn	string
Licensee ACN	licensee_acn	string
Business type	business_type	string
Authorisation restriction name	authorisation_restriction_name	string
Extended trading	extended_trading	boolean
Reduced trading	reduced_trading	boolean
Primary service	primary_service	boolean
Right to keep gaming	right_to_keep_gaming	boolean
Unrestricted	unrestricted	boolean
Trading to midnight	to_12am	boolean
Trading to 3am	to_3am	boolean
Trading to 5am	to_5am	boolean
SA2	sa2	string
SA2 band	band	integer
Gaming machine entitlements	gmes	integer
Poker machine permits	pmps	integer
Auth limit	auth_limit	integer
Unfulfilled quota	unfulfilled_quota	integer
Gaming machine threshold	gmt	integer
Operating gaming machines	egms	integer

How it runs

The page downloads DuckDB and Perspective once, about 17 MB, then this version's data.parquet (1.2 MB). Every chart is a query DuckDB answers in the browser, so there is no rate limit and the files stay the only source. Dated versions never change, so a saved dashboard over one shows the same numbers for good. A map panel draws its background from OpenStreetMap tiles, so while one is on screen your browser asks OpenStreetMap for them and it sees your IP address. The data itself never leaves the browser.