Citywide Mobility Survey - Trip 2018
City of New York
@usgov.city_of_new_york_citywide_mobility_survey_trip_diary_2018
City of New York
@usgov.city_of_new_york_citywide_mobility_survey_trip_diary_2018
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
);
Anyone who has the link will be able to view this.