Food Establishment Inspections

Public Health Inspectors operate under the Alberta Public Health Act to ensure compliance with the province's Food Regulation. Under the Food Regulation, restaurant inspections occur prior to the opening of a new facility, every four to six months thereafter or more often if non-compliance with the regulation has been identified. Consumer complaints are also investigated, and an inspection may be conducted under special circumstances, such as a food recall.

https://ephisahs.microsoftcrmportals.com/disclaimer/restaurantinspections/

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 \"edmonton-ca/food-establishment-inspections-45hm-rte9\".\"food_establishment_inspections\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.