About this Dataset

Participatory Budgeting Voting Results

The City of Somerville completed the first-ever Participatory Budgeting cycle in 2023. In Participatory Budgeting, residents submit ideas for how to improve Somerville with one million dollars; volunteers score and select the 20 best ideas; and residents vote on the final ideas.

Voters could choose and rank up to 5 ideas out of the 20 selected final ideas. This dataset provides the number of votes in each rank slot for each of the final ideas.
Organization: City of Somerville
Last updated: 2023-12-09T05:15:58.253630
Tags: participatory-budgeting, voting

Tables

Table 1

@usgov.city_of_somerville_participatory_budgeting_voting_results.table_1

12.96 kB
20 rows
10 columns

CREATE TABLE table_1 (
  "year" BIGINT,
  "project" VARCHAR,
  "description" VARCHAR,
  "cost" BIGINT,
  "rank1" BIGINT,
  "rank2" BIGINT,
  "rank3" BIGINT,
  "rank4" BIGINT,
  "rank5" BIGINT,
  "total_score" BIGINT
);