About this Dataset

Participatory Budgeting Voter Demographics

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 the demographics and satisfaction of residents who voted on the best ideas. After voting for the final Participatory Budgeting ideas, voters were invited to an optional survey to voluntarily submit their demographic information and indicate their satisfaction with the Participatory Budgeting process. Demographics were not connected to votes to preserve anonymity. Open text comments have also been removed from the open dataset for privacy.
Organization: City of Somerville
Last updated: 2023-12-09T05:16:31.694162
Tags: demographics, participatory-budgeting

Tables

Table 1

@usgov.city_of_somerville_participatory_budgeting_voter_demographics.table_1

27.31 KB
2987 rows
16 columns


CREATE TABLE table_1 (
  "year" BIGINT,
  "survey_language" VARCHAR,
  "ward" VARCHAR,
  "gender" VARCHAR,
  "age" VARCHAR,
  "race_or_ethnicity" VARCHAR,
  "housing_status" VARCHAR,
  "cultural_or_religion_minority" DOUBLE,
  "immigrant" DOUBLE,
  "lgbtqia" DOUBLE,
  "parent_guardian_of_children_under_18" DOUBLE,
  "person_with_disabilities" DOUBLE,
  "veteran" DOUBLE,
  "student" DOUBLE,
  "household_income" VARCHAR,
  "how_satisfied_are_you_with_participatory_budgeting" DOUBLE
);