Arts and Culture Downtown Visitation

Number of visits to the Mesa Arts Center, Arizona Museum of Natural History, and i.d.e.a. Museum. The term visits refers to the number of distinct admissions to a program or facility. For example, if an individual were to attend a particular program on ten separate occasions this would be counted as ten visits. This is an industry term and is used for reporting internally to the City of Mesa as well as external agencies that Arts and Culture is affiliated with.The three facilities represented by the dataset are the i.d.e.a. Museum, AzMNH (Arizona Museum of Natural History) and the MAC (Mesa Arts Center) Fiscal year specifies fiscal year by the two year designation e.g. 2009/2010. The City of Mesa fiscal year for all departments is from July 1 - June 30.

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/arts-and-culture-downtown-visitation-ipea-qa5w\".\"arts_and_culture_downtown_visitation\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.