Citywide Mobility Survey - Day 2022
City of New York
@usgov.city_of_new_york_citywide_mobility_survey_day_2022
City of New York
@usgov.city_of_new_york_citywide_mobility_survey_day_2022
Citywide Mobility Survey (CMS) Day table contains information on each day of the participant’s assigned travel period, including deliveries, remote work duration, online shopping, reasons for no travel if applicable, and start/end location of the day, with between one and seven travel days recorded for each participant.
Organization: City of New York
Last updated: 2024-05-03T18:36:35.169538
Tags: 2022, city, citywidemobilitysurvey, mobility, new-york, survey, travel, zones
CREATE TABLE table_1 (
"hh_id" BIGINT,
"num_trips" BIGINT,
"person_id" BIGINT,
"person_num" BIGINT,
"day_id" BIGINT,
"travel_dow" BIGINT,
"day_num" BIGINT,
"is_complete" BIGINT,
"travel_date" TIMESTAMP,
"summary_complete" BIGINT,
"num_complete_trip_surveys" DOUBLE,
"begin_day" BIGINT,
"end_day" BIGINT,
"telecommute_time" BIGINT,
"delivery_2" BIGINT,
"delivery_3" BIGINT,
"delivery_4" BIGINT,
"delivery_5" BIGINT,
"delivery_6" BIGINT,
"delivery_7" BIGINT,
"delivery_8" BIGINT,
"delivery_9" BIGINT,
"delivery_996" BIGINT,
"shop_online" BIGINT,
"no_travel_1" BIGINT,
"no_travel_2" BIGINT,
"no_travel_3" BIGINT,
"no_travel_4" BIGINT,
"no_travel_5" BIGINT,
"no_travel_6" BIGINT,
"no_travel_7" BIGINT,
"no_travel_8" BIGINT,
"no_travel_9" BIGINT,
"no_travel_11" BIGINT,
"no_travel_12" BIGINT,
"no_travel_13" BIGINT,
"no_travel_99" BIGINT,
"wkday_weight" DOUBLE,
"svnday_weight" DOUBLE
);Anyone who has the link will be able to view this.