About this Dataset

Somerville Happiness Survey Responses

Every two years, the City of Somerville sends the Somerville Happiness Survey to a random sample of Somerville residents. The survey asks residents to rate their personal happiness, wellbeing, and satisfaction with City services. This combined dataset includes random-sample survey results from 2011 to 2023, including all 2023 questions with applicable responses from previous years. A data dictionary, exploratory visualization, and survey instruments are attached.
Organization: City of Somerville
Last updated: 2024-06-08T08:39:33.859762
Tags: survey

Tables

Table 1

@usgov.city_of_somerville_somerville_happiness_survey_responses_4fe50.table_1

328.97 kB
11,191 rows
129 columns

CREATE TABLE table_1 (
  "id" BIGINT,
  "year" BIGINT,
  "survey_method" VARCHAR,
  "survey_language" VARCHAR,
  "gender" VARCHAR,
  "age" VARCHAR,
  "age_mid" DOUBLE,
  "race_ethnicity" VARCHAR,
  "housing_status" VARCHAR,
  "tenure" VARCHAR,
  "tenure_mid" DOUBLE,
  "tenure_address" VARCHAR,
  "tenure_address_mid" DOUBLE,
  "days_in_person_commute" VARCHAR,
  "transportation_bicycle_yn" DOUBLE,
  "transportation_car_yn" DOUBLE,
  "transportation_public_transit_yn" DOUBLE,
  "transportation_rideshare_yn" DOUBLE,
  "transportation_walk_yn" DOUBLE,
  "children_yn" DOUBLE,
  "cultural_religious_minority_yn" DOUBLE,
  "disability_yn" DOUBLE,
  "immigrant_yn" DOUBLE,
  "lgbtqia_yn" DOUBLE,
  "student_yn" DOUBLE,
  "veteran_yn" DOUBLE,
  "difficulty_paying_yn" DOUBLE,
  "discrimination_yn" DOUBLE,
  "household_size" VARCHAR,
  "household_size_num" DOUBLE,
  "bedrooms" VARCHAR,
  "bedrooms_num" DOUBLE,
  "cars" VARCHAR,
  "cars_num" DOUBLE,
  "household_income" VARCHAR,
  "household_income_mid" DOUBLE,
  "income_per_number_in_household" DOUBLE,
  "likely_low_income" DOUBLE,
  "rent_mortgage" VARCHAR,
  "rent_mortgage_mid" DOUBLE,
  "rent_as_percent_of_income" DOUBLE,
  "rent_mortgage_per_bedroom" DOUBLE,
  "likely_cost_burdened" DOUBLE,
  "language_spoken" VARCHAR,
  "ward" DOUBLE,
  "happiness_5pt_num" DOUBLE,
  "happiness_5pt_label" VARCHAR,
  "life_satisfaction_5pt_num" DOUBLE,
  "life_satisfaction_5pt_label" VARCHAR,
  "neighborhood_satisfaction_5pt_num" DOUBLE,
  "neighborhood_satisfaction_5pt_label" VARCHAR,
  "somerville_satisfaction_5pt_num" DOUBLE,
  "somerville_satisfaction_5pt_label" VARCHAR,
  "beauty_neighborhood_satisfaction_5pt_num" DOUBLE,
  "beauty_neighborhood_satisfaction_5pt_label" VARCHAR,
  "getting_around_convenience_satisfaction_5pt_num" DOUBLE,
  "getting_around_convenience_satisfaction_5pt_label" VARCHAR,
  "transportation_options_satisfaction_5pt_num" DOUBLE,
  "transportation_options_satisfaction_5pt_label" VARCHAR,
  "cleanliness_neighborhood_satisfaction_5pt_num" DOUBLE,
  "cleanliness_neighborhood_satisfaction_5pt_label" VARCHAR,
  "parks_proximity_satisfaction_5pt_num" DOUBLE,
  "parks_proximity_satisfaction_5pt_label" VARCHAR,
  "grocery_proximity_satisfaction_5pt_num" DOUBLE,
  "grocery_proximity_satisfaction_5pt_label" VARCHAR,
  "city_services_quality_satisfaction_5pt_num" DOUBLE,
  "city_services_quality_satisfaction_5pt_label" VARCHAR,
  "housing_cost_satisfaction_5pt_num" DOUBLE,
  "housing_cost_satisfaction_5pt_label" VARCHAR,
  "housing_condition_satisfaction_5pt_num" DOUBLE,
  "housing_condition_satisfaction_5pt_label" VARCHAR,
  "streets_sidewalks_maintenance_satisfaction_5pt_num" DOUBLE,
  "streets_sidewalks_maintenance_satisfaction_5pt_label" VARCHAR,
  "sidewalks_accessibility_satisfaction_5pt_num" DOUBLE,
  "sidewalks_accessibility_satisfaction_5pt_label" VARCHAR,
  "childcare_availability_satisfaction_5pt_num" DOUBLE,
  "childcare_availability_satisfaction_5pt_label" VARCHAR,
  "neighbors_relationship_satisfaction_5pt_num" DOUBLE,
  "neighbors_relationship_satisfaction_5pt_label" VARCHAR,
  "priced_out_concern_3pt_num" DOUBLE,
  "priced_out_concern_3pt_label" VARCHAR,
  "crime_violence_concern_3pt_num" DOUBLE,
  "crime_violence_concern_3pt_label" VARCHAR,
  "rats_mice_concern_3pt_num" DOUBLE,
  "rats_mice_concern_3pt_label" VARCHAR,
  "crossing_street_safety_concern_3pt_num" DOUBLE,
  "crossing_street_safety_concern_3pt_label" VARCHAR,
  "biking_safety_concern_3pt_num" DOUBLE,
  "biking_safety_concern_3pt_label" VARCHAR,
  "walking_safety_concern_3pt_num" DOUBLE,
  "walking_safety_concern_3pt_label" VARCHAR,
  "extreme_weather_safety_concern_3pt_num" DOUBLE,
  "extreme_weather_safety_concern_3pt_label" VARCHAR,
  "public_school_satisfaction_5pt_num" DOUBLE,
  "public_school_satisfaction_5pt_label" VARCHAR,
  "police_department_satisfaction_5pt_num" DOUBLE,
  "police_department_satisfaction_5pt_label" VARCHAR,
  "social_community_events_availability_satisfaction_5pt_num" DOUBLE,
  "social_community_events_availability_satisfaction_5pt_label" VARCHAR,
  "city_services_information_availability_satisfaction_5pt_num" DOUBLE
);