Icon for Socrata external plugin
Open repository in Console
Updated 3 months ago
Indexed 1 hour ago

Bars and pubs, with patron capacity

Data collected as part of the City of Melbourne's Census of Land Use and Employment (CLUE). The data covers the period 2002-2021. It show business establishments with their business address, bar/tavern/pub patron capacity, location and CLUE block and small area designation.

For more information about CLUE see

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl \
    -H "Content-Type: application/json" \
{"sql": "
    SELECT *
    FROM \"melbourne-vic-gov-au/bars-and-pubs-with-patron-capacity-mffi-m9yn\".\"bars_and_pubs_with_patron_capacity\"
    LIMIT 100 

See the Splitgraph documentation for more information.

  • bars_and_pubs_with_patron_capacity
Upstream Metadata