Pet License History by Neighbourhood
Pet license (cats, dogs, pigeons) transaction history by neighbourhood; details initial license issuance, periodic renewals, and the current (as of the dataset refresh date) status of the license (still an "issued" status, has expired, etc.).
Explanation of pet license statuses:
Issued: Up-to-date license
Delinquent: More than one month overdue
Renewed: License is in the last month before it expires, and the renewal notice has been sent
NSF: A cheque was received as payment, but was returned as NSF (not sufficient funds) by the bank
Expired: Less than one month overdue
Accepted: Pet licence account has been created but payment has not yet been applied to the account (used for brand new accounts)
NB: For FOIP reasons, pets are excluded from this dataset if there are fewer than five of the relevant animal type in the pet's neighbourhood. For example, if there are only four dogs in a particular neighbourhood, none of those dogs will be featured in 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-license-history-by-neighbourhood-7hy9-wuyj\".\"pet_license_history_by_neighbourhood\" LIMIT 100 "} EOF
See the Splitgraph documentation for more information.