Citywide Mobility Survey - Household 2022
City of New York
@usgov.city_of_new_york_citywide_mobility_survey_household_2022
City of New York
@usgov.city_of_new_york_citywide_mobility_survey_household_2022
Citywide Mobility Survey (CMS) Household table contains data about the characteristics of the participant’s household, including household size, income, type of residence, number of vehicles, bicycles, and micromobility devices, package delivery location, and other demographic and transportation-related information.
Organization: City of New York
Last updated: 2024-05-03T18:40:49.731426
Tags: 2022, city, citywidemobilitysurvey, mobility, new-york, survey, travel, zones
CREATE TABLE table_1 (
"hh_id" BIGINT,
"hh_cms_zone_gp" BIGINT,
"participation_group" BIGINT,
"signup_platform" VARCHAR,
"diary_platform" VARCHAR,
"num_days_complete" BIGINT,
"num_days_complete_weekday" BIGINT,
"num_days_complete_weekend" BIGINT,
"num_complete_mon" BIGINT,
"num_complete_tue" BIGINT,
"num_complete_wed" BIGINT,
"num_complete_thu" BIGINT,
"num_complete_fri" BIGINT,
"num_complete_sat" BIGINT,
"num_complete_sun" BIGINT,
"num_people" BIGINT,
"r_num_people" BIGINT,
"num_adults" BIGINT,
"num_kids" BIGINT,
"num_students" BIGINT,
"num_workers" BIGINT,
"num_vehicles" BIGINT,
"r_num_vehicles" BIGINT,
"num_trips" BIGINT,
"income_broad" BIGINT,
"primary_language" BIGINT,
"residence_type" BIGINT,
"residence_rent_own" BIGINT,
"home_county" BIGINT,
"vehicle_change" BIGINT,
"reduced_veh_1" BIGINT,
"reduced_veh_2" BIGINT,
"reduced_veh_3" BIGINT,
"reduced_veh_4" BIGINT,
"reduced_veh_5" BIGINT,
"reduced_veh_6" BIGINT,
"reduced_veh_7" BIGINT,
"reduced_veh_8" BIGINT,
"reduced_veh_997" BIGINT,
"increased_veh_1" BIGINT,
"increased_veh_2" BIGINT,
"increased_veh_3" BIGINT,
"increased_veh_4" BIGINT,
"increased_veh_5" BIGINT,
"increased_veh_6" BIGINT,
"increased_veh_7" BIGINT,
"increased_veh_8" BIGINT,
"increased_veh_997" BIGINT,
"ev_typical_charge_1" BIGINT,
"ev_typical_charge_2" BIGINT,
"ev_typical_charge_3" BIGINT,
"ev_typical_charge_4" BIGINT,
"ev_typical_charge_5" BIGINT,
"ev_typical_charge_6" BIGINT,
"ev_typical_charge_7" BIGINT,
"ev_typical_charge_997" BIGINT,
"ev_purchase" BIGINT,
"ev_purchase_barriers_1" BIGINT,
"ev_purchase_barriers_2" BIGINT,
"ev_purchase_barriers_3" BIGINT,
"ev_purchase_barriers_4" BIGINT,
"ev_purchase_barriers_5" BIGINT,
"num_bicycles" BIGINT,
"bicycle_type_1" BIGINT,
"bicycle_type_2" BIGINT,
"bicycle_type_997" BIGINT,
"bike_change" BIGINT,
"reduced_bike_1" BIGINT,
"reduced_bike_2" BIGINT,
"reduced_bike_3" BIGINT,
"reduced_bike_4" BIGINT,
"reduced_bike_5" BIGINT,
"reduced_bike_6" BIGINT,
"reduced_bike_7" BIGINT,
"reduced_bike_8" BIGINT,
"reduced_bike_997" BIGINT,
"increased_bike_1" BIGINT,
"increased_bike_2" BIGINT,
"increased_bike_3" BIGINT,
"increased_bike_4" BIGINT,
"increased_bike_5" BIGINT,
"increased_bike_6" BIGINT,
"increased_bike_7" BIGINT,
"increased_bike_8" BIGINT,
"increased_bike_9" BIGINT,
"increased_bike_997" BIGINT,
"bike_store_1" BIGINT,
"bike_store_2" BIGINT,
"bike_store_3" BIGINT,
"bike_store_4" BIGINT,
"bike_store_5" BIGINT,
"bike_store_6" BIGINT,
"bike_store_8" BIGINT,
"bike_store_9" BIGINT,
"bike_store_997" BIGINT,
"num_scooters" BIGINT,
"scooter_typical_charge_1" BIGINT,
"scooter_typical_charge_2" BIGINT,
"scooter_typical_charge_4" BIGINT,
"scooter_typical_charge_5" BIGINT
);Anyone who has the link will be able to view this.