Rooming House Enforcement Activity

This dataset comprises of illegal rooming house enforcement incident counts and the status of investigation counts collected by the City of Winnipeg. The neigbourhoods will only be listed if an investigation was opened. Multiple complaints on one property within a short period of time are investigated as one incident.

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 \"winnipeg-ca/rooming-house-enforcement-activity-vk2f-xwp7\".\"rooming_house_enforcement_activity\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.