Somerville Happiness Survey Responses

City of Somerville

@usgov.city_of_somerville_somerville_happiness_survey_responses_4fe50

Table List

1 table(321.26 KB)

Table 1

@usgov.city_of_somerville_somerville_happiness_survey_responses_4fe50.table_1

321.26 KB
11191 rows
129 columns
Only the first 100 columns are shown

id ID	year Year	survey_method Survey.Method	gender Gender	age Age	age_mid Age.mid	race_ethnicity Race.Ethnicity	household_income Household.Income	household_income_mid Household.Income.mid	happiness_5pt_num Happiness.5pt.num	happiness_5pt_label Happiness.5pt.label	life_satisfaction_5pt_num Life.Satisfaction.5pt.num	life_satisfaction_5pt_label Life.Satisfaction.5pt.label	somerville_satisfaction_5pt_num Somerville.Satisfaction.5pt.num	somerville_satisfaction_5pt_label Somerville.Satisfaction.5pt.label	public_school_satisfaction_5pt_num Public.School.Satisfaction.5pt.num	public_school_satisfaction_5pt_label Public.School.Satisfaction.5pt.label
560	2011	Paper	Man	61 or older	61	White	Less than $10,000	9999	5	Very Happy	5	Very Satisfied	5	Very Satisfied	5	Very Satisfied
561	2011	Paper	Woman	26-30	28	White	$60,000 to $79,999	69999.5	4	Happy	5	Very Satisfied	5	Very Satisfied
562	2011	Paper	Man	61 or older	61	White	$10,000 to $19,999	14999.5	4	Happy	4	Satisfied	4	Satisfied	3	Neutral
563	2011	Paper	Woman	61 or older	61	White	$40,000 to $59,999	49999.5	5	Very Happy	4	Satisfied	5	Very Satisfied
564	2011	Paper	Man	26-30	28	White	$20,000 to $39,999	29999.5	3	Neutral	3	Neutral	3	Neutral	3	Neutral
565	2011	Paper	Man	26-30	28	White	$40,000 to $59,999	49999.5	4	Happy	4	Satisfied	5	Very Satisfied	3	Neutral
566	2011	Paper	Woman	61 or older	61	White	$20,000 to $39,999	29999.5	2	Unhappy	3	Neutral	4	Satisfied	4	Satisfied
567	2011	Paper	Man	26-30	28	White	$60,000 to $79,999	69999.5	3	Neutral	4	Satisfied	4	Satisfied
568	2011	Paper	Woman	22-25	23.5	White	$80,000 to $99,999	89999.5	4	Happy	4	Satisfied	3	Neutral
569	2011	Paper	Woman	41-50	45.5	White	$100,000 or more	100000	3	Neutral	3	Neutral	4	Satisfied	4	Satisfied


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
);