Participatory Budgeting Ideas Submitted by Community Members

This dataset contains all of the ideas (projects) proposed by community members about how they think the City should spend a given year’s Participatory Budgeting funds. Each summer, community members submit ideas. Each fall, volunteer Budget Delegates research the ideas, evaluating each one based on feasibility, need, and impact. The Delegates ultimately develop about 20 final projects for the public to vote on in December of each year.

To learn more, please visit http://pb.cambridgema.gov/

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 \"cambridgema-gov/participatory-budgeting-ideas-submitted-by-54vd-wdqj\".\"participatory_budgeting_ideas_submitted_by\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.