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
"}
EOFSee the Splitgraph documentation
for more information.