Current liquor licences by location, Victoria
liveCurrent Victorian liquor licences by location from Liquor Control Victoria. Each row is one active licence at the end of the month, with the licence number, licensee, trading name, licence category, trading hours, patron capacity, premises street address, suburb, postcode, council, region, metropolitan or regional class, latitude and longitude, and postal address. The publisher states the addresses are as supplied on the application and may be inaccurate.
Also called: Victorian liquor licences by location, Liquor licence lookup Victoria, List of licensed venues in Victoria, Liquor Control Victoria licence list.
- What does each row hold?
- One liquor licence active at the end of the month the release names, with its number, the licensee and trading name, the licence category, trading hours, patron capacity where one applies, the premises address, council area, region and coordinates, and the licensee's postal address.
- How accurate are the addresses and coordinates?
- The publisher states that addresses are as given on the licence application, need not follow the Australian address standard and may be outdated or inaccurate. About one licence in twenty has no coordinates, and some licences, such as remote sellers, have no premises the public can visit.
- How often does it change?
- Liquor Control Victoria publishes a new stocktake of every active licence each month. Each version here is one month's stocktake, so a licence that has lapsed is absent from later versions.
Made for agents
Connect your AI agent
Any agent that connects to publicdata.au/mcp can find this dataset, read its 17 fields, count and filter across all 23,036 rows and diff its versions. Every answer names the version and carries Liquor Control Victoria's attribution. No key.
Then ask it: What does Current liquor licences by location, Victoria hold, and what changed in the newest version?
claude mcp add --transport http publicdata https://publicdata.au/mcpOne command. No key, no account, no sign-up.
Settings, then Connectors, then Add custom connector, and paste https://publicdata.au/mcp.
On the web and in the desktop app.
https://publicdata.au/mcpStreamable HTTP. Cursor, VS Code or any client that connects to a remote MCP server.
Using https://publicdata.au/llms.txt, how many people died on Queensland roads in 2025, by month?For an assistant that reads the web and has no connector.
A dashboard over every row. Click to filter, add panels, share a link or embed a frame.
Query APIFilter and count from a URLaggregate?group=licence_category&metric=count
Licences by licence category: 6,509 Restaurant and cafe Licence, 3,970 Limited Licence, 2,315 Packaged Liquor Licence, 2,076 General Licence.
Download it as Excel, CSV, JSON and 9 more formats
Pick a format and a version. Excel is picked first because it opens in the tools most offices have. The URL is yours to keep. A dated version never changes.
In your own tools
Use it in Excel, R, Python and more
Excel and Power BI read the CSV from its address and refresh from it. The R and Python packages take any dataset on this site by its slug, so a new dataset needs no new release. The DuckDB file attaches read-only over HTTPS, and a query reads only the blocks it touches.
The dated URL in the code never changes. https://publicdata.au/d/vic-liquor-licences/latest/ redirects to the newest version.
https://publicdata.au/d/vic-liquor-licences/latest/data.csvIn Excel choose Data, then From Web, and paste this address. Excel keeps it, so Refresh All reads the newest version. A sheet holds about a million rows; past that, load the query to the Data Model.
https://publicdata.au/d/vic-liquor-licences/latest/data.csvIn Power BI Desktop choose Get data, then Web, paste this address and choose Anonymous when asked how to sign in. A scheduled refresh reads the same address, so the report follows each new version.
library(publicdataau)
df <- pd_read("vic-liquor-licences")
pd_attribution(df)install.packages("publicdataau"). pd_read() fetches the version's Parquet file; pd_rows() and pd_aggregate() ask the query API instead, and pd_connect() attaches the DuckDB file.
import publicdata_au as pd_au
df = pd_au.read("vic-liquor-licences")
df.attrs["publicdata"]["attribution"]pip install "publicdata-au[pandas]". read() fetches the version's Parquet file; rows() and aggregate() ask the query API, and connect() attaches the DuckDB file.
INSTALL httpfs; LOAD httpfs;
ATTACH 'https://publicdata.au/d/vic-liquor-licences/v/2026-10-01/data.duckdb' AS vic_liquor_licences (READ_ONLY);
SELECT council, count(*) FROM vic_liquor_licences.records GROUP BY 1 ORDER BY 2 DESC;The DuckDB file attaches read-only over HTTPS and only the blocks a query touches are read. Parquet works the same way: FROM read_parquet(url).
const res = await fetch("https://publicdata.au/api/v1/datasets/vic-liquor-licences/aggregate?group=licence_category&metric=count");
const { rows, publicdata } = await res.json();
console.log(rows, publicdata.attribution);The query API answers a page on any site as well as Node, with no key. It returns the rows and the attribution the licence asks for.
What is in it
Column names are made snake_case and the publisher's original header is kept beside each one. Blank cells are null. Nothing is added, removed, ranked or summarised.
| Field | Type | Publisher's header | Note |
|---|---|---|---|
| licence_number | string | Licence Number | |
| licensee | string | Licensee | |
| trading_as | string | Trading As | |
| licence_category | string | Licence Category | |
| trading_hours | string | Trading Hours | |
| patron_capacity | integer | Patron Capacity (if applicable) | Blank where the licence sets no capacity. |
| street_address | string | Street Address | |
| suburb | string | Suburb | |
| postcode | string | Postcode | |
| council | string | Council | |
| region | string | Region | |
| metro_regional | string | Metro/Regional | |
| latitude | number | Latitude | |
| longitude | number | Longitude | |
| postal_address | string | Postal Address | |
| postal_suburb | string | Postal Suburb | |
| postal_postcode | string | Postal Postcode |
Download this table as a data dictionary (Excel), or read it as a Frictionless Table Schema at schema.json. The key is licence_number.
A sample of 10 rows
From the latest version, each licence category in turn, then in the publisher's order, with every field. A blank cell is shown as null.
| licence_number | licensee | trading_as | licence_category | trading_hours | patron_capacity | street_address | suburb | postcode | council | region | metro_regional | latitude | longitude | postal_address | postal_suburb | postal_postcode |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 31100099 | ARNOLD BRUCE | UNIVERSITY SKI CLUB | BYO Permit | BYO Permit | null | U S C LODGE ALLOTMENTS 15 & 16 ALPINE VILL | MT BULLER | 3723 | MANSFIELD SHIRE COUNCIL | Hume | Regional | -37.146305 | 146.452276 | PO BOX 93 | SANDOWN VILLAGE | 3171 |
| 31291468 | LIPKIN IVETTA | ADDI'S GRILL | General Licence | Trading to 1am | null | 365 NORTH RD | CAULFIELD SOUTH | 3162 | GLEN EIRA CITY COUNCIL | Metro South | Metro | -37.90227 | 145.028741 | UNIT 7 800 WARRIGAL ROAD | MALVERN EAST | 3145 |
| 31400025 | BENNETTSWOOD BOWLING CLUB | BENNETTSWOOD BOWLING CLUB | Restricted Club Licence | Restricted Club Licence | 200 | 179 STATION ST | BOX HILL | 3128 | WHITEHORSE CITY COUNCIL | Metro East | Metro | -37.8422394 | 145.1210569 | 179 STATION ST | BURWOOD | 3125 |
| 31820039 | FRESHFIELDS NOMINEES PTY LTD | THE ELEPHANT AND WHEELBARROW | Late night (on-premises) Licence | Trading to 5am | 450 | 94-96 BOURKE STREET | MELBOURNE | 3000 | MELBOURNE CITY COUNCIL | Metro North | Metro | -37.81197073 | 144.9702716 | LEVEL 3, 410 LONSDALE STREET | MELBOURNE | 3000 |
| 31820097 | RAINBOW INTERNATIONAL HOUSE CLUB CO PTY LTD | RAINBOW INTERNATIONAL HOUSE CLUB | On-Premises Licence | Trading to 1am | 120 | 125 SMITH STREET | FITZROY | 3065 | YARRA CITY COUNCIL | Metro North | Metro | -37.805232 | 144.982984 | 125 SMITH STREET | FITZROY | 3065 |
| 31900025 | ALBERT HOTEL BENDIGO PTY LTD | ALBERT HOTEL | Late night (general) Licence | Trading to 5am | 500 | 131 MCCRAE STREET | BENDIGO | 3550 | GREATER BENDIGO CITY COUNCIL | Loddon Mallee | Regional | -36.7564144 | 144.282619 | 131 MCCRAE STREET | BENDIGO | 3550 |
| 31821548 | ITAL BACI PTY LTD | CAFE BACIS | Restaurant and cafe Licence | Trading 24 Hours | 400 | SHOP 21, 8 WHITEMAN STREET CROWN ENTERTAINMENT COMPLEX | SOUTHBANK | 3006 | MELBOURNE CITY COUNCIL | Metro North | Metro | -37.82431389 | 144.9568517 | PO BOX 709 | BALWYN | 3103 |
| 32000014 | LIQUORLAND (AUSTRALIA) PTY LTD | LIQUORLAND | Packaged Liquor Licence | Ordinary | null | UNION SQUARE SHOPPING CENTRE CNR UNION & GRANTHAM STREETS | BRUNSWICK | 3055 | MERRI-BEK CITY COUNCIL | NORTH WEST | Regional | -37.7722852 | 144.9487865 | PO BOX 2000 | GLEN IRIS | 3146 |
| 32024408 | LOTTE TRAVEL RETAIL AUSTRALIA PTY LTD | LOTTE DUTY FREE MELBOURNE AIRPORT | Late night (packaged liquor) Licence | Trading 24 Hours | null | SHOP NOS. 65610 TO 65613 AIRPORT DRIVE | MELBOURNE AIRPORT | 3045 | HUME CITY COUNCIL | Metro North | Metro | -37.6694979 | 144.8486551 | LOTTE DUTY FREE LEVEL 3, 250 COLLINS STREET | MELBOURNE | 3000 |
| 32100026 | CARLTON FOOTBALL CLUB LIMITED | CARLTON FOOTBALL CLUB | Full Club Licence | Full Club Licence | 2518 | PRINCES PARK | CARLTON NORTH | 3054 | MELBOURNE CITY COUNCIL | Metro North | Metro | -37.78361 | 144.96199 | PO BOX 83 | CARLTON NORTH | 3054 |
The first row as JSON
As it appears in data.json.
GET https://publicdata.au/d/vic-liquor-licences/latest/data.json
{
"licence_number": "31100099",
"licensee": "ARNOLD BRUCE",
"trading_as": "UNIVERSITY SKI CLUB",
"licence_category": "BYO Permit",
"trading_hours": "BYO Permit",
"patron_capacity": null,
"street_address": "U S C LODGE ALLOTMENTS 15 & 16 ALPINE VILL",
"suburb": "MT BULLER",
"postcode": "3723",
"council": "MANSFIELD SHIRE COUNCIL",
"region": "Hume",
"metro_regional": "Regional",
"latitude": -37.146305,
"longitude": 146.452276,
"postal_address": "PO BOX 93",
"postal_suburb": "SANDOWN VILLAGE",
"postal_postcode": "3171"
}
Query it without downloading
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. Build a query here and run it, then copy the URL or the code into your own work.
How filters work
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.
| Operator | What it matches |
|---|---|
| eq.value | Equal to the value. |
| neq.value | Not equal to the value. A blank cell does not match. |
| gt.value | Greater than the value. |
| gte.value | Greater than or equal to the value. |
| lt.value | Less than the value. |
| lte.value | Less than or equal to the value. |
| like.*text* | Matches a pattern where * stands for any run of characters. Case-sensitive. |
| ilike.*text* | The same as like, ignoring case. |
| in.(a,b,c) | Equal to any value in the list. A value cannot contain a comma. |
| is.null | Blank in the source, or suppressed by the publisher. |
| Parameter | What it does |
|---|---|
| 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/<date>/ before rows or aggregate for an answer that never changes. /api/v1/datasets/<slug>/versions lists the loaded versions. The 1 newest version is loaded; versions lists them.
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.json describes this dataset's query paths for client generators and agents.
https://publicdata.au/mcp is a remote MCP server over Streamable HTTP with the same tools, defined in the same place, so a tool added to the pages is added here too. It needs no key and no account. The row tools are held to the query API's limit of 60 queries in 10 seconds from one address, and each call is two queries because it also counts the matching rows. Add it to Claude Code with claude mcp add --transport http publicdata https://publicdata.au/mcp, add the URL in Claude as a custom connector, or give it to any client that connects to remote MCP servers. Each queryable dataset is also a resource at https://publicdata.au/d/<slug>/fields.json, which lists its fields with their types, the publisher's descriptions, their ranges and the values they hold, so an agent can read a dataset's shape before it writes a query.
By council
One page for each council, with its own count, chart and files. The rows are the same rows as this table.
- ALPINE SHIRE COUNCIL223
- ARARAT RURAL CITY COUNCIL76
- BALLARAT CITY COUNCIL360
- BANYULE CITY COUNCIL273
- BASS COAST SHIRE COUNCIL213
- BAW BAW SHIRE COUNCIL186
- BAYSIDE CITY COUNCIL385
- BENALLA RURAL CITY COUNCIL58
- BOROONDARA CITY COUNCIL612
- BRIMBANK CITY COUNCIL319
- BULOKE SHIRE COUNCIL52
- CAMPASPE SHIRE COUNCIL190
- CARDINIA SHIRE COUNCIL220
- CASEY CITY COUNCIL375
- CENTRAL GOLDFIELDS SHIRE COUNCIL52
- COLAC-OTWAY SHIRE COUNCIL136
- CORANGAMITE SHIRE COUNCIL98
- DAREBIN CITY COUNCIL543
- EAST GIPPSLAND SHIRE COUNCIL237
- FRANKSTON CITY COUNCIL272
- GANNAWARRA SHIRE COUNCIL49
- GLEN EIRA CITY COUNCIL419
- GLENELG SHIRE COUNCIL82
- GOLDEN PLAINS SHIRE COUNCIL62
- GREATER BENDIGO CITY COUNCIL410
- GREATER DANDENONG CITY COUNCIL305
- GREATER GEELONG CITY COUNCIL907
- GREATER SHEPPARTON CITY COUNCIL225
- HEPBURN SHIRE COUNCIL155
- HINDMARSH SHIRE COUNCIL38
- HOBSONS BAY CITY COUNCIL268
- HORSHAM RURAL CITY COUNCIL90
- HUME CITY COUNCIL361
- INDIGO SHIRE COUNCIL162
- INTERSTATE1
- KINGSTON CITY COUNCIL488
- KNOX CITY COUNCIL360
- LATROBE CITY COUNCIL220
- LODDON SHIRE COUNCIL58
- MACEDON RANGES SHIRE COUNCIL248
- MANNINGHAM CITY COUNCIL268
- MANSFIELD SHIRE COUNCIL122
- MARIBYRNONG CITY COUNCIL345
- MAROONDAH CITY COUNCIL263
- MELBOURNE CITY COUNCIL2,126
- MELTON CITY COUNCIL217
- MERRI-BEK CITY COUNCIL538
- MILDURA RURAL CITY COUNCIL223
- MITCHELL SHIRE COUNCIL133
- MOIRA SHIRE COUNCIL138
- MONASH CITY COUNCIL490
- MOONEE VALLEY CITY COUNCIL395
- MOORABOOL SHIRE COUNCIL90
- MORNINGTON PENINSULA SHIRE COUNCIL780
- MOUNT ALEXANDER SHIRE COUNCIL137
- MOYNE SHIRE COUNCIL105
- MURRINDINDI SHIRE COUNCIL111
- NILLUMBIK SHIRE COUNCIL154
- NORTHERN GRAMPIANS SHIRE COUNCIL78
- NOT APPLICABLE250
- PORT PHILLIP CITY COUNCIL722
- PYRENEES SHIRE COUNCIL66
- QUEENSCLIFFE BOROUGH COUNCIL50
- SOUTH GIPPSLAND SHIRE COUNCIL157
- SOUTHERN GRAMPIANS SHIRE COUNCIL102
- STONNINGTON CITY COUNCIL724
- STRATHBOGIE SHIRE COUNCIL95
- SURF COAST SHIRE COUNCIL209
- SWAN HILL RURAL CITY COUNCIL97
- TOWONG SHIRE COUNCIL44
- WANGARATTA RURAL CITY COUNCIL159
- WARRNAMBOOL CITY COUNCIL130
- WELLINGTON SHIRE COUNCIL190
- WEST WIMMERA SHIRE COUNCIL30
- WHITEHORSE CITY COUNCIL398
- WHITTLESEA CITY COUNCIL313
- WODONGA CITY COUNCIL94
- WYNDHAM CITY COUNCIL337
- YARRA CITY COUNCIL911
- YARRA RANGES SHIRE COUNCIL615
- YARRIAMBIACK SHIRE COUNCIL44
What changed
One version for every release the publisher has made since this site started following the dataset. The date is the day the file changed on the portal.
- 2026-10-01 23,036 rows17 fieldsxlsxb0a00e0846f4
versions.json · changes.json · history.tar.zst (1.6 MB, every version's Parquet and manifest)
Questions
How do I download Current liquor licences by location as a CSV file?
Open https://publicdata.au/d/vic-liquor-licences/latest/data.csv. It redirects to the newest dated version, which is https://publicdata.au/d/vic-liquor-licences/v/2026-10-01/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 Current liquor licences by location in Excel?
Yes. https://publicdata.au/d/vic-liquor-licences/v/2026-10-01/data.xlsx is a workbook with the 23,036 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/vic-liquor-licences/v/2026-10-01/data.csv.gz is the CSV at about a tenth of the size.
How often is Current liquor licences by location updated?
Liquor Control Victoria releases it monthly. This site checks the portal every week and adds a dated version when the file changes.
Can I use Current liquor licences by location 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 Current liquor licences by location?
No. The publisher is Liquor Control Victoria, and its page is https://discover.data.vic.gov.au/dataset/victorian-liquor-licences-by-location. 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 council?
Every version has one JSON file per value of council, 82 files in the current version, listed with row counts at https://publicdata.au/d/vic-liquor-licences/v/2026-10-01/by/council/index.json. For example https://publicdata.au/d/vic-liquor-licences/v/2026-10-01/by/council/melbourne-city-council.json holds the 2,126 rows where council is MELBOURNE CITY COUNCIL. A GeoJSON file sits beside each one.
What coordinate system does Current liquor licences by location use?
The publisher states no datum for its latitude and longitude, so they are read as WGS84 (EPSG:4326), which differs from GDA2020 by under two metres. The GeoJSON file uses the same coordinates, which is what GeoJSON expects.
What this site did to the data. Cells were typed, headers were renamed and the encoding was made UTF-8. Rows were left alone. The publisher's file sits beside every version as source.xlsx so the change can be checked.