2020 Act 100 Pie Charts | STATIC

Static dataset that is used to build visualizations for the 2020 Act 100. The visualizations were built to show the percentage of projects assigned to a certain goal (i.e. Safety, System Efficiency, etc.) compared to the full number of projects for that fiscal year.

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 \"highways-hidot-hawaii-gov/2020-act-100-pie-charts-static-9cm4-tdmd\".\"2020_act_100_pie_charts_static\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.