Crimes by Type by 1980 Block - 2000 to 2006

tabulation of crimes by type for each 1980 census block

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 \"kcmo/crimes-by-type-by-1980-block-2000-to-2006-4c6g-hqvh\".\"crimes_by_type_by_1980_block_2000_to_2006\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.