edmonton-ca/pet-license-history-by-neighbourhood-7hy9-wuyj
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated 1 month ago
Indexed 1 month ago

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.

 
Preview
  • pet_license_history_by_neighbourhood
     
     
     
     
     
Upstream Metadata