Pet Licenses by Neighbourhood

Distribution of various currently-licensed pets (cats, dogs, pigeons) by neighbourhood.

Note that this is a snapshot of pets that were licensed as of the last update date of this dataset; if a pet was licensed a number of years ago but that license has since expired and not been renewed, the details of that pet will not appear in this dataset. It is therefore not possible to use this dataset to see trends in pet licensing over time.

The rows with a year value of '2017' for example do not represent a comprehensive list of all pets that were licensed in 2017, but rather the subset of those pets that are still licensed as of the last update date of this 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/pet-licenses-by-neighbourhood-5squ-mg4w\".\"pet_licenses_by_neighbourhood\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.