About this Dataset

Citywide Mobility Survey - Trip 2019

The Citywide Mobility Survey (CMS) is NYC DOT's annual travel survey to assess the travel behavior, preferences, and attitudes of NYC residents. It is composed of 5 linked data tables - this one is the 2019 CMS Trip Survey.
Organization: City of New York
Last updated: 2020-11-10T17:05:54.025135
Tags: 2019, city, citywidemobilitysurvey, mobility, new-york, survey, travel, zones

Tables

Table 1

@usgov.city_of_new_york_citywide_mobility_survey_trip_survey_2019.table_1

2.95 MB
85,459 rows
77 columns

CREATE TABLE table_1 (
  "hh_id" BIGINT,
  "trip_weight" DOUBLE,
  "home_cms_zone" VARCHAR,
  "survey_mode" BIGINT,
  "person_id" BIGINT,
  "person_num" BIGINT,
  "day_num" BIGINT,
  "travel_date" TIMESTAMP,
  "travel_date_dow" BIGINT,
  "trip_id" BIGINT,
  "trip_num" BIGINT,
  "leg_num" BIGINT,
  "unlinked_trip" BIGINT,
  "linked_trip_num" BIGINT,
  "survey_complete" BIGINT,
  "depart_time" TIMESTAMP,
  "arrive_time" TIMESTAMP,
  "o_cms_zone" VARCHAR,
  "d_cms_zone" VARCHAR,
  "trip_duration" DOUBLE,
  "trip_distance" DOUBLE,
  "o_purpose" BIGINT,
  "o_purpose_category" BIGINT,
  "d_purpose" BIGINT,
  "d_purpose_category" BIGINT,
  "num_non_hh_travelers" BIGINT,
  "num_hh_travelers" BIGINT,
  "num_travelers" BIGINT,
  "hh_member_1" BIGINT,
  "hh_member_2" BIGINT,
  "hh_member_3" BIGINT,
  "hh_member_4" BIGINT,
  "hh_member_5" BIGINT,
  "hh_member_6" BIGINT,
  "hh_member_7" BIGINT,
  "hh_member_8" BIGINT,
  "hh_member_9" BIGINT,
  "hh_member_10" BIGINT,
  "hh_member_11" BIGINT,
  "mode_type" BIGINT,
  "mode_type_detailed" BIGINT,
  "sustainable_mode" BIGINT,
  "mode_1" BIGINT,
  "mode_2" BIGINT,
  "mode_3" BIGINT,
  "mode_4" BIGINT,
  "driver" BIGINT,
  "park_location" BIGINT,
  "park_pay" BIGINT,
  "park_cost" DOUBLE,
  "used_transit" BIGINT,
  "transit_access" BIGINT,
  "transit_egress" BIGINT,
  "taxi_cost" BIGINT,
  "taxi_cost_amount" DOUBLE,
  "bike_park_location" BIGINT,
  "scooter_park_location" BIGINT,
  "analyst_split" BIGINT,
  "analyst_merge" BIGINT,
  "analyst_split_loop" BIGINT,
  "user_merged" BIGINT,
  "user_split" BIGINT,
  "added_trip" BIGINT,
  "high_speed_flag" BIGINT,
  "long_distance_flag" BIGINT,
  "invalid_purpose_flag" BIGINT,
  "o_purpose_imputed" BIGINT,
  "d_purpose_imputed" BIGINT,
  "o_purpose_category_imputed" BIGINT,
  "d_purpose_category_imputed" BIGINT,
  "d_distance_home" DOUBLE,
  "d_distance_work" DOUBLE,
  "d_distance_school" DOUBLE,
  "o_location_type" BIGINT,
  "d_location_type" BIGINT,
  "o_congestion" BIGINT,
  "d_congestion" BIGINT
);