Paying Skaters - Ice Rink at City Plaza

Aggregated daily counts of number of paid skaters at City of Mesa’s plaza ice rink, part of the seasonal Merry Main Street events during 2015 - 2017. This dataset has been superseded by the Ticket Sales Ice Rink at City Plaza dataset that includes detailed information about each transaction beginning in 2017. https://data.mesaaz.gov/Recreation-Culture/Ticket-Sales-Ice-Rink-at-City-Plaza/bca4-y9b7

Typical hours of operation are M-F 5-10pm, Sa-Su 12-10pm. Hours of operation may vary depending on weather and attendance patterns (i.e. early close, ice conditions, maintenance issues, etc.).

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 \"citydata-mesaaz-gov/paying-skaters-ice-rink-at-city-plaza-gd7v-yqei\".\"paying_skaters_ice_rink_at_city_plaza\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.