Citywide Mobility Survey - Person 2019 by US Government | Demographics and Population Studies

About this Dataset

Citywide Mobility Survey - Person 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 Person Survey.
Organization: City of New York
Last updated: 2020-11-10T17:00:58.503165
Tags: 2019, city, citywidemobilitysurvey, mobility, new-york, survey, travel, zones

Tables

Table 1

@usgov.city_of_new_york_citywide_mobility_survey_person_survey_2019.table_1

519.77 KB
8286 rows
165 columns


CREATE TABLE table_1 (
  "hh_id" BIGINT,
  "weight" DOUBLE,
  "cms_zone" VARCHAR,
  "survey_mode" BIGINT,
  "person_id" BIGINT,
  "person_num" BIGINT,
  "is_participant" BIGINT,
  "num_days" DOUBLE,
  "num_days_complete" DOUBLE,
  "num_trips" DOUBLE,
  "num_walk_trips" DOUBLE,
  "num_transit_trips" DOUBLE,
  "num_bike_trips" DOUBLE,
  "num_taxi_trips" DOUBLE,
  "num_tnc_trips" DOUBLE,
  "num_complete_weekend_days" DOUBLE,
  "num_complete_weekdays" DOUBLE,
  "first_travel_date" TIMESTAMP,
  "last_travel_date" TIMESTAMP,
  "made_trips" DOUBLE,
  "smartphone_type" BIGINT,
  "relationship" BIGINT,
  "age" BIGINT,
  "employment" BIGINT,
  "worker" BIGINT,
  "student" BIGINT,
  "license" BIGINT,
  "vehicle" BIGINT,
  "congestion" BIGINT,
  "drive_cbd_freq" BIGINT,
  "planning_apps" BIGINT,
  "job_type" BIGINT,
  "jobs_count" BIGINT,
  "industry" BIGINT,
  "telework_freq" BIGINT,
  "work_cms_zone" VARCHAR,
  "missing_work_location" BIGINT,
  "work_mode" BIGINT,
  "work_mode_own" BIGINT,
  "work_park_location" BIGINT,
  "work_park_pay" BIGINT,
  "work_vehicle_pass_period" BIGINT,
  "work_park_amount_day" DOUBLE,
  "work_park_amount_week" DOUBLE,
  "work_park_amount_month" DOUBLE,
  "work_park_amount_year" DOUBLE,
  "work_mode_auto" BIGINT,
  "work_mode_bus" BIGINT,
  "work_mode_rail" BIGINT,
  "work_mode_ferry" BIGINT,
  "work_mode_taxi" BIGINT,
  "work_mode_bike" BIGINT,
  "work_bike_park" BIGINT,
  "work_mode_scooter" BIGINT,
  "work_scooter_park" BIGINT,
  "school_type" BIGINT,
  "school_cms_zone" VARCHAR,
  "missing_school_location" BIGINT,
  "kid_accompany" BIGINT,
  "school_mode" BIGINT,
  "school_mode_own" BIGINT,
  "school_park_location" BIGINT,
  "school_vehicle_pass_period" BIGINT,
  "school_park_amount_day" DOUBLE,
  "school_park_amount_month" DOUBLE,
  "school_park_amount_week" DOUBLE,
  "school_park_amount_year" DOUBLE,
  "school_mode_auto" BIGINT,
  "school_mode_bus" BIGINT,
  "school_mode_rail" BIGINT,
  "school_mode_ferry" BIGINT,
  "school_access" BIGINT,
  "school_egress" BIGINT,
  "school_mode_taxi" BIGINT,
  "school_mode_bike" BIGINT,
  "school_bike_park" BIGINT,
  "school_mode_scooter" BIGINT,
  "school_scooter_park" BIGINT,
  "bike_freq" BIGINT,
  "bike_num_days" BIGINT,
  "bike_stolen" BIGINT,
  "bike_purpose_errands" BIGINT,
  "bike_purpose_transit" BIGINT,
  "bike_purpose_recreation" BIGINT,
  "bike_purpose_commute" BIGINT,
  "bike_purpose_appointment" BIGINT,
  "bike_purpose_other" BIGINT,
  "no_bike_nyc_bike_lanes" BIGINT,
  "no_bike_nyc_paving" BIGINT,
  "no_bike_nyc_storage" BIGINT,
  "no_bike_nyc_long_trips" BIGINT,
  "no_bike_nyc_showers" BIGINT,
  "no_bike_nyc_modes" BIGINT,
  "no_bike_nyc_unable" BIGINT,
  "no_bike_nyc_other" BIGINT,
  "bike_share_citi_bike" BIGINT,
  "bike_share_jump" BIGINT,
  "bike_share_lime" BIGINT,
  "bike_share_none" BIGINT,
  "bike_share_user" BIGINT
);