About this Dataset

Citywide Mobility Survey - Trip 2022

Citywide Mobility Survey (CMS) Trip table contains characteristics of each trip made by the participants, including origins and destinations, mode, purpose, transportation related fees such as transit, parking, or taxi pay, parking location for the bikes or micromobility devices, number of travelers, trip duration, and trip distance.
Organization: City of New York
Last updated: 2024-05-03T18:49:30.227798
Tags: 2022, city, citywidemobilitysurvey, mobility, new-york, survey, travel, zones

Tables

Table 1

@usgov.city_of_new_york_citywide_mobility_survey_trip_2022.table_1

4.31 MB
86,339 rows
95 columns

CREATE TABLE table_1 (
  "hh_id" BIGINT,
  "person_id" BIGINT,
  "person_num" BIGINT,
  "day_id" BIGINT,
  "travel_dow" BIGINT,
  "day_num" BIGINT,
  "is_complete" BIGINT,
  "travel_date" TIMESTAMP,
  "linked_trip_id" BIGINT,
  "linked_leg_num" BIGINT,
  "trip_id" BIGINT,
  "trip_num" BIGINT,
  "day_is_complete" BIGINT,
  "arrive_dow" BIGINT,
  "depart_dow" BIGINT,
  "o_in_region" BIGINT,
  "o_county" BIGINT,
  "d_in_region" BIGINT,
  "d_county" BIGINT,
  "mode_type_nyc" BIGINT,
  "r_mode_type_nyc" BIGINT,
  "mode_1" BIGINT,
  "mode_2" BIGINT,
  "mode_3" BIGINT,
  "mode_priority_nyc" BIGINT,
  "transit_access" BIGINT,
  "r_transit_access" BIGINT,
  "transit_egress" BIGINT,
  "r_transit_egress" BIGINT,
  "park_location" BIGINT,
  "park_type" BIGINT,
  "park_pay" BIGINT,
  "park_cost" VARCHAR,
  "ev_charge_station" BIGINT,
  "ev_charge_station_level_1" BIGINT,
  "ev_charge_station_level_2" BIGINT,
  "ev_charge_station_level_3" BIGINT,
  "ev_charge_station_level_4" BIGINT,
  "ev_charge_station_level_5" BIGINT,
  "ev_charge_station_level_997" BIGINT,
  "ev_charge_station_level_998" BIGINT,
  "tnc_type" BIGINT,
  "taxi_type" BIGINT,
  "taxi_pay" BIGINT,
  "taxi_cost" DOUBLE,
  "transit_type" BIGINT,
  "bike_park_loc" BIGINT,
  "scooter_park_location" BIGINT,
  "num_travelers" BIGINT,
  "num_hh_travelers" BIGINT,
  "num_non_hh_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,
  "hh_member_12" BIGINT,
  "driver" BIGINT,
  "o_purpose" BIGINT,
  "o_purpose_category" BIGINT,
  "d_purpose" BIGINT,
  "d_purpose_category" BIGINT,
  "d_purpose_category_linked" BIGINT,
  "r_d_purpose_category_linked" BIGINT,
  "work_trip" BIGINT,
  "depart_date" TIMESTAMP,
  "depart_hour" BIGINT,
  "depart_minute" BIGINT,
  "depart_seconds" BIGINT,
  "r_timeofday" BIGINT,
  "arrive_date" TIMESTAMP,
  "arrive_hour" BIGINT,
  "arrive_minute" BIGINT,
  "arrive_second" BIGINT,
  "duration_minutes" BIGINT,
  "r_duration_minutes" BIGINT,
  "duration_seconds" BIGINT,
  "distance_miles" DOUBLE,
  "r_distance_miles" BIGINT,
  "dwell_mins" DOUBLE,
  "high_speed_flag" BIGINT,
  "long_distance_flag" BIGINT,
  "o_cms_zone" BIGINT,
  "d_cms_zone" BIGINT,
  "unlinked_trip" BIGINT,
  "o_location_type" BIGINT,
  "d_location_type" BIGINT,
  "trip_wkday_weight" DOUBLE,
  "trip_svnday_weight" DOUBLE
);