Citywide Mobility Survey - October 2020
City of New York
@usgov.city_of_new_york_citywide_mobility_survey_october_2020
City of New York
@usgov.city_of_new_york_citywide_mobility_survey_october_2020
In 2020, NYC DOT conducted a panel survey of respondents who completed the 2019 CMS. The three surveys allowed the agency to better understand how residents traveled and used public spaces during the stay-at-home period and reopening phases of the pandemic. This is the third panel survey that was fielded from October 19 – November 2, 2020.
Organization: City of New York
Last updated: 2021-08-07T16:19:35.145816
Tags: city, citywidemobilitysurvey, mobility, new-york, survey, travel, zones
CREATE TABLE table_1 (
"person_id" BIGINT,
"hh_id" BIGINT,
"bike_num_days" BIGINT,
"bike_purpose_recreation" BIGINT,
"bike_purpose_grocery" BIGINT,
"bike_purpose_shopping" BIGINT,
"bike_purpose_medical" BIGINT,
"bike_purpose_visit_friend" BIGINT,
"bike_purpose_work" BIGINT,
"bike_purpose_work_related" BIGINT,
"bike_purpose_restaurant" BIGINT,
"bike_purpose_other" BIGINT,
"bike_type_owned" BIGINT,
"bike_type_borrowed" BIGINT,
"bike_type_bike_share" BIGINT,
"bike_type_other" BIGINT,
"shopping_food_in_store" BIGINT,
"shopping_food_grocery_pick_up" BIGINT,
"shopping_food_grocery_delivery" BIGINT,
"shopping_food_restaurant_pick_up" BIGINT,
"shopping_food_restaurant_delivery" BIGINT,
"shopping_food_restaurant_dine" BIGINT,
"delivery_major_retailer" BIGINT,
"delivery_small_retailer" BIGINT,
"delivery_home" BIGINT,
"delivery_work" BIGINT,
"delivery_other_location" BIGINT,
"delivery_service" BIGINT,
"modes_used_household_vehicle" BIGINT,
"modes_used_other_vehicle" BIGINT,
"modes_used_tnc" BIGINT,
"modes_used_bus" BIGINT,
"modes_used_subway" BIGINT,
"modes_used_rail" BIGINT,
"modes_used_ferry" BIGINT,
"modes_used_walk" BIGINT,
"modes_used_scooter" BIGINT,
"trip_purpose_work" BIGINT,
"trip_purpose_food" BIGINT,
"trip_purpose_restaurant" BIGINT,
"trip_purpose_shopping" BIGINT,
"trip_purpose_social" BIGINT,
"trip_purpose_exercise" BIGINT,
"trip_purpose_school" BIGINT,
"trip_purpose_drop_off" BIGINT,
"trip_purpose_other" BIGINT,
"food_mode" BIGINT,
"errand_mode" BIGINT,
"dine_location_outdoor_seating" BIGINT,
"dine_location_sidewalk" BIGINT,
"dine_location_indoor" BIGINT,
"dine_location_none" BIGINT,
"medical_appointment" BIGINT,
"medical_telehealth" BIGINT,
"medical_other_virtual" BIGINT,
"medical_postponed" BIGINT,
"medical_none" BIGINT,
"medical_mode" BIGINT,
"modes_used_july_household_vehicle" BIGINT,
"modes_used_july_other_vehicle" BIGINT,
"modes_used_july_tnc" BIGINT,
"modes_used_july_bus" BIGINT,
"modes_used_july_subway" BIGINT,
"modes_used_july_rail" BIGINT,
"modes_used_july_ferry" BIGINT,
"modes_used_july_walk" BIGINT,
"modes_used_july_bike" BIGINT,
"modes_used_july_scooter" BIGINT,
"modes_used_july_moped" BIGINT,
"car_use" BIGINT,
"bike_freq" BIGINT,
"vehicle_change" BIGINT,
"reduced_vehicle_cost" BIGINT,
"reduced_vehicle_parking" BIGINT,
"reduced_vehicle_no_need" BIGINT,
"reduced_vehicle_ridehailing" BIGINT,
"reduced_vehicle_carshare" BIGINT,
"reduced_vehicle_transit" BIGINT,
"reduced_vehicle_nyc_driving" BIGINT,
"reduced_vehicle_other" BIGINT,
"increased_vehicle_covid_modes" BIGINT,
"increased_vehicle_covid_needs" BIGINT,
"increased_vehicle_area" BIGINT,
"increased_vehicle_moved" BIGINT,
"increased_vehicle_job" BIGINT,
"increased_vehicle_unreliable" BIGINT,
"increased_vehicle_flexibility" BIGINT,
"increased_vehicle_new_driver" BIGINT,
"increased_vehicle_transport_hh_member" BIGINT,
"increased_vehicle_other" BIGINT,
"vehicle_no_change" BIGINT,
"employment_before" BIGINT,
"industry_before" BIGINT,
"telework_before" BIGINT,
"employment_status_change" BIGINT,
"employment" BIGINT,
"employment_change_new_job" BIGINT,
"employment_change_laid_off" BIGINT,
"employment_change_left_job" BIGINT,
"employment_change_furloughed_with_pay" BIGINT
);Anyone who has the link will be able to view this.