311 Requests

Listing of all requests raised to 311, details of each call/transaction and update on the status.

This is anonymized data intended for reporting on trends; if you have a specific reference number for which you would like to check the status, please see the "check your status" search box at https://www.edmonton.ca/programs_services/311-city-services.

Due to the volume of data, this dataset contains 311 requests created within the current calendar year and the previous two calendar years. In January of a given year it will contain 2 years and 1 month of requests; in December of that year it will contain 3 years of requests. For historical data please search for "311 Requests (YEAR)" where "YEAR" is a year value, e.g. 2018. These will exist for years that no longer exist in this dataset, i.e. "current year minus three" will be the greatest year value that has its own single-year dataset.

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/311-requests-q7ua-agfg\".\"311_requests\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.