Citywide Mobility Survey - Trip 2018 by US Government | Demographics and Population Studies

About this Dataset

Citywide Mobility Survey - Trip 2018

The Citywide Mobility Survey (CMS) is a mixed-methodology survey of New York City residents' travel choices, behaviors, and perceptions. The Trip Diary dataset provides trip-level data.
Organization: City of New York
Last updated: 2020-11-10T17:03:53.593890
Tags: 2018, city, citywidemobilitysurvey, mobility, new-york, survey, travel, zones

Tables

Table 1

@usgov.city_of_new_york_citywide_mobility_survey_trip_diary_2018.table_1

379.62 KB
7977 rows
118 columns


CREATE TABLE table_1 (
  "job" VARCHAR,
  "trip_id" BIGINT,
  "uniqueid" BIGINT,
  "qday" VARCHAR,
  "qday1typical" VARCHAR,
  "qborough_home" VARCHAR,
  "ntacode_home" VARCHAR,
  "qsurveyzone_home" VARCHAR,
  "qtripdaytime" VARCHAR,
  "qday1tripstartcode" VARCHAR,
  "qday1tripstartam" VARCHAR,
  "qday1tripstartnoon" VARCHAR,
  "qday1tripstartpm" VARCHAR,
  "qday1trip_outsidenyc_start" VARCHAR,
  "qborough_start" VARCHAR,
  "qntacode_start" VARCHAR,
  "surveyzone_start" VARCHAR,
  "qday1tripend" VARCHAR,
  "qday1trip_outsidenyc_end" VARCHAR,
  "qborough_end" VARCHAR,
  "qntacode_end" VARCHAR,
  "surveyzone_end" VARCHAR,
  "qday1tripendcode" VARCHAR,
  "qday1triptransitto1" VARCHAR,
  "qday1triptransitto2" VARCHAR,
  "qday1triptransitto3" VARCHAR,
  "qday1triptransitto4" VARCHAR,
  "qday1triptransitto5" VARCHAR,
  "qday1triptransitto6" VARCHAR,
  "qday1triptransitto7" VARCHAR,
  "qday1triptransitfrom1" VARCHAR,
  "qday1triptransitfrom2" VARCHAR,
  "qday1triptransitfrom3" VARCHAR,
  "qday1triptransitfrom4" VARCHAR,
  "qday1triptransitfrom5" VARCHAR,
  "qday1triptransitfrom6" VARCHAR,
  "qday1triptransitfrom7" VARCHAR,
  "qday1triptravelcode01" VARCHAR,
  "qday1triptravelcode02" VARCHAR,
  "qday1triptravelcode03" VARCHAR,
  "qday1triptravelcode04" VARCHAR,
  "qday1triptravelcode05" VARCHAR,
  "qday1triptravelcode06" VARCHAR,
  "qday1triptravelcode07" VARCHAR,
  "qday1triptravelcode08" VARCHAR,
  "qday1triptravelcode09" VARCHAR,
  "qday1triptravelcode10" VARCHAR,
  "qday1triptravelcode11" VARCHAR,
  "qday1triptravelcode12" VARCHAR,
  "qday1triptravelcode13" VARCHAR,
  "qday1triptravelcode14" VARCHAR,
  "qday1triptravelcode15" VARCHAR,
  "qday1triptravelcode16" VARCHAR,
  "qday1triptravelcode17" VARCHAR,
  "qday1triptravelcode18" VARCHAR,
  "qday1triptravelcode19" VARCHAR,
  "qday1triptravelcode20" VARCHAR,
  "qday1triptravelcode21" VARCHAR,
  "qday1triptravelcode22" VARCHAR,
  "qday1triptravelcode23" VARCHAR,
  "qday1triptravelcode24" VARCHAR,
  "qday1triptravelcode25" VARCHAR,
  "qday1triptravelcode26" VARCHAR,
  "qday1triptravelcode27" VARCHAR,
  "qday1trippurpose" VARCHAR,
  "qday1triplength" BIGINT,
  "qday1triplength_flt" VARCHAR,
  "qday1triplength_cat" VARCHAR,
  "qday1trippark" VARCHAR,
  "qday1tripparkpay" VARCHAR,
  "qday1tripparkpay_amount" VARCHAR,
  "qday1tripbikestore" VARCHAR,
  "number_of_trips_taken" VARCHAR,
  "qgender" VARCHAR,
  "qincome" VARCHAR,
  "qdisability1" VARCHAR,
  "qdisability2" VARCHAR,
  "qdisability3" VARCHAR,
  "qdisability4" VARCHAR,
  "qdisability5" VARCHAR,
  "qdisability6" VARCHAR,
  "qdisability7" VARCHAR,
  "qdisability8" VARCHAR,
  "qdisability9" VARCHAR,
  "qage" BIGINT,
  "qagecode" VARCHAR,
  "qrace" VARCHAR,
  "qracecode" VARCHAR,
  "qhispanic" VARCHAR,
  "qeducation" VARCHAR,
  "qlicense" VARCHAR,
  "qcaraccess" VARCHAR,
  "qcarchange" VARCHAR,
  "qwelfare1" VARCHAR,
  "qwelfare2" VARCHAR,
  "qwelfare3" VARCHAR,
  "qwelfare4" VARCHAR,
  "qwelfare5" VARCHAR,
  "qsmartphone" VARCHAR,
  "qshare1" VARCHAR
);