City Health Dashboard All Metrics - Grand Rapids Geocoded

This dataset includes all data metrics downloaded via the City Health dashboard's API. Most metrics are measured down to the census tract level. Those that are tract level are geocoded. The metrics that are not measured by tract are measured citywide. All metrics are measured by year. Some metrics have multiple years of data.

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 \"grandrapidsmi-gov/city-health-dashboard-all-metrics-grand-rapids-g2yn-2pn5\".\"city_health_dashboard_all_metrics_grand_rapids\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.