About this Dataset

Somerville Public School Staff MBTA Pass Pilot - Travel & Survey Data

Somerville Public Schools partnered with the City’s Office of Strategic Planning and Community Development to launch the Somerville Public Schools Workforce Transit Pass Pilot Program for Spring 2023. This program was funded thanks to the American Rescue Plan Act. The pilot program provided free MBTA LinkPasses to all SPS staff who signed up. Passes were good 7 days a week for unlimited travel on all MBTA subway lines, local bus lines, and the Silver Line. The goal of the pilot was to support staff, promote sustainable transit, ease parking pressure around schools, and evaluate use and interest in transit passes. This dataset includes anonymized travel data provided by the MBTA combined with select survey responses from the pilot intake survey.
Organization: City of Somerville
Last updated: 2023-11-11T05:43:13.083683
Tags: mbta, mobility, schools, survey, transportation

Tables

Table 1

@usgov.city_of_somerville_somerville_public_school_staff_mbta_99691dcb.table_1

22.31 KB
16 rows
26 columns


CREATE TABLE table_1 (
  "group_no" BIGINT,
  "unique_cards_tapped_this_month" BIGINT,
  "total_fares" DOUBLE,
  "total_trips" BIGINT,
  "validations" BIGINT,
  "bus_validations" BIGINT,
  "redline_validations" BIGINT,
  "orangeline_validation" BIGINT,
  "greenline_validations" BIGINT,
  "blueline_validations" BIGINT,
  "sunrise_validations" BIGINT,
  "early_am_validations" BIGINT,
  "am_peak_validations" BIGINT,
  "midday_base_validations" BIGINT,
  "midday_school_validations" BIGINT,
  "pm_peak_validations" BIGINT,
  "evening_validations" BIGINT,
  "late_evening_validations" BIGINT,
  "night_validations" BIGINT,
  "transit_frequency_reported" VARCHAR,
  "school_group" VARCHAR,
  "intake_survey_responses" BIGINT,
  "intake_survey_commute_by_bus" BIGINT,
  "intake_survey_commute_by_subway" BIGINT,
  "intake_survey_commute_by_driving" BIGINT,
  "intake_survey_commute_by_activemodes" BIGINT
);