Pool Inspections

This is a dataset of information from the results of inspections and /or enforcement of violations related to commercial pool and spa for public health and safety by Austin Public Health - Environmental Health Services Division. Data is updated weekly. Data file includes three years of data.

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 \"datahub-austintexas-gov/pool-inspections-peux-uuwu\".\"pool_inspections\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.