Name: Citywide Mobility Survey - Trip 2017
Creator: US Government
License: https://www.usa.gov/government-works

About this Dataset

Citywide Mobility Survey - Trip 2017

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

Tables

Table 1

@usgov.city_of_new_york_citywide_mobility_survey_trip_diary_2017.table_1

286.16 KB
6986 rows
109 columns


CREATE TABLE table_1 (
  "job" BIGINT,
  "respondent_serial" VARCHAR,
  "cfmc_case_id" VARCHAR,
  "uniqueid" BIGINT,
  "qday1typical" BIGINT,
  "qday1triptravelcode01" BIGINT,
  "qday1triptravelcode02" BIGINT,
  "qday1triptravelcode03" BIGINT,
  "qday1triptravelcode04" BIGINT,
  "qday1triptravelcode05" BIGINT,
  "qday1triptravelcode06" BIGINT,
  "qday1triptravelcode07" BIGINT,
  "qday1triptravelcode08" BIGINT,
  "qday1triptravelcode09" BIGINT,
  "qday1triptravelcode10" BIGINT,
  "qday1triptravelcode11" BIGINT,
  "qday1triptravelcode12" BIGINT,
  "qday1triptravelcode13" BIGINT,
  "qday1triptravelcode14" BIGINT,
  "qday1triptravelcode15" BIGINT,
  "qday1triptravelcode16" BIGINT,
  "qday1triptravelcode17" BIGINT,
  "qday1triptravelcode18" BIGINT,
  "qday1triptravelcode19" BIGINT,
  "qday1triptravelcode20" BIGINT,
  "qday1triptravelcode21" BIGINT,
  "qday1triptravelcode22" BIGINT,
  "qday1triptravelcode23" BIGINT,
  "qday1triptravelcode24" BIGINT,
  "qday1triptravelcode25" BIGINT,
  "qday1triptravelcode26" BIGINT,
  "qday1trippurpose" BIGINT,
  "qday1tripdestination" VARCHAR,
  "qday1triplength" BIGINT,
  "qday1trip1transitto1" VARCHAR,
  "qday1trip1transitto2" VARCHAR,
  "qday1trip1transitto3" VARCHAR,
  "qday1trip1transitto4" VARCHAR,
  "qday1trip1transitto5" VARCHAR,
  "qday1trip1transitto6" VARCHAR,
  "qday1trip1transitto7" VARCHAR,
  "qday1trip1transitfrom1" VARCHAR,
  "qday1trip1transitfrom2" VARCHAR,
  "qday1trip1transitfrom3" VARCHAR,
  "qday1trip1transitfrom4" VARCHAR,
  "qday1trip1transitfrom5" VARCHAR,
  "qday1trip1transitfrom6" VARCHAR,
  "qday1trip1transitfrom7" VARCHAR,
  "qday" BIGINT,
  "qgender" BIGINT,
  "qage" BIGINT,
  "qrace" BIGINT,
  "qhispanic" BIGINT,
  "qeducation" BIGINT,
  "qincome" BIGINT,
  "qborough1" BIGINT,
  "qborough2" BIGINT,
  "qborough3" BIGINT,
  "qborough4" BIGINT,
  "qborough5" BIGINT,
  "qcaraccess" BIGINT,
  "qcarchange" VARCHAR,
  "qdisability1" BIGINT,
  "qdisability2" BIGINT,
  "qdisability3" BIGINT,
  "qdisability4" BIGINT,
  "qdisability5" BIGINT,
  "qdisability6" BIGINT,
  "qdisability7" BIGINT,
  "qdisability8" BIGINT,
  "qsmartphone" BIGINT,
  "qsurveyzone" BIGINT,
  "qagecode_final1" BIGINT,
  "qagecode_final2" BIGINT,
  "qagecode_final3" BIGINT,
  "qagecode_final4" BIGINT,
  "qagecode_final5" BIGINT,
  "qagecode_final6" BIGINT,
  "qagecode_final7" BIGINT,
  "qcitibike" BIGINT,
  "filt_number_of_trips" DOUBLE,
  "qwpsurveyzone01" VARCHAR,
  "qwpsurveyzone02" VARCHAR,
  "qwpsurveyzone03" VARCHAR,
  "qwpsurveyzone04" VARCHAR,
  "qwpsurveyzone05" VARCHAR,
  "qwpsurveyzone06" VARCHAR,
  "qwpsurveyzone07" VARCHAR,
  "qwpsurveyzone08" VARCHAR,
  "qwpsurveyzone09" VARCHAR,
  "qwpsurveyzone10" VARCHAR,
  "qday1trip1start" BIGINT,
  "qday1trip1_outsidenyc_start" VARCHAR,
  "qday1trip1startcode" VARCHAR,
  "qday1trip1end" BIGINT,
  "qday1trip1_outsidenyc_end" VARCHAR,
  "day1tripntanamecmb" VARCHAR,
  "qday1trip1park" VARCHAR,
  "qday1trip1parkpay" VARCHAR,
  "qday1trip1parkpay_amount" VARCHAR
);