About this Dataset

Participatory Budgeting Submissions

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.

This dataset describes all the ideas that were submitted. Residents could submit ideas through the Participatory Budgeting website. Ideas were public to other users, who could comment or indicate support with a click. Ideas were then reviewed, combined, and scored for eligibility, need, and impact to determine which would appear on the ballot. This dataset includes the ideas that were submitted in this initial submission phase.
Organization: City of Somerville
Last updated: 2023-12-09T05:16:28.393540
Tags: participatory-budgeting

Tables

Table 1

@usgov.city_of_somerville_participatory_budgeting_submissions.table_1

220.01 KB
966 rows
11 columns


CREATE TABLE table_1 (
  "year" BIGINT,
  "category" VARCHAR,
  "theme" VARCHAR,
  "idea" VARCHAR,
  "description" VARCHAR,
  "citywide" BIGINT,
  "near_address" VARCHAR,
  "longitude" DOUBLE,
  "latitude" DOUBLE,
  "comment_count" DOUBLE,
  "support_count" DOUBLE
);