Every Animal Counts

City Controller Ron Galperin released an audit that indicated the Los Angeles’ Department of Animal Services is making progress toward its goal of making Los Angeles a “No Kill” City. Still, last year about one of every four lost or abandoned animals that entered the City’s shelters were euthanized. View the department's raw data on each of the City's six animal shelters below.

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 \"controllerdata-lacity/every-animal-counts-ua8f-ms7p\".\"every_animal_counts\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.