ECC - Clerk: Board and Commission vs. GR City Census Demographics

This dataset tracks the demographics of City Boards and Commissions. It also includes the 2010 Census demographic data for the Grand Rapids city population. We also calculate the percent variance between the the percent of residents of a particular race represented on City Boards/Commission in comparison to the percent of that race overall in the City using these 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/ecc-clerk-board-and-commission-vs-gr-city-census-tqc9-27st\".\"ecc_clerk_board_and_commission_vs_gr_city_census\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.