Bars and pubs, with patron capacity

Name: Bars and pubs, with patron capacity
Creator: City of Melbourne
Published: 2016-01-20T01:07:47

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 http://www.melbourne.vic.gov.au/clue

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 https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"melbourne-vic-gov-au/bars-and-pubs-with-patron-capacity-mffi-m9yn\".\"bars_and_pubs_with_patron_capacity\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

Preview

bars_and_pubs_with_patron_capacity

Left sidebar is currently unimplemented

Right sidebar is currently unimplemented

Upstream Metadata

QualityWhat's includedFull dataset has been included.Update frequencyAnnuallyData quality statement A team of census officers conduct field interviews which involves visiting every establishment in every building in the Census area (City of Melbourne municipality). Every commercial property is surveyed at least once every two years.

How to useFurther informationhttp://www.melbourne.vic.gov.au/clue

Data managementSource data update frequencyAnnually

About

Bars and pubs, with patron capacity

3 months ago (updated)

1 hour ago (indexed)

Topics