Data·Citizenan agentic layer over NYC Open Data
CatalogExploreAnalyticsMapAsk the agentFindingsGuideStatus
Data from NYC Open Data via the Socrata Discovery API. Quality scores are computed from a sample and are indicative, not authoritative.
← Catalog

Citywide Mobility Survey - Trip 2022

x5mc-2gmiTransportation98 columns
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.
View on NYC Open Data↗

Quality

B84.1 / 100

From a 500-row sample across 98 columns.

completeness98/ 25% weight
consistency52/ 20% weight
accuracy98/ 20% weight
timeliness85/ 15% weight
usability85/ 20% weight
  • · Very wide (98 columns) — hard to consume directly

Related datasets

  • Citywide Mobility Survey - Trip 20240.68
    joins ondwell_minsev_charge_station_level_5added_trip+76
  • Citywide Mobility Survey - Trip Survey 20190.58
    joins onlong_distance_flagadded_tripperson_id+43

Sample rows

hh_idperson_idperson_numday_idtravel_dowday_numis_completetravel_datelinked_trip_idlinked_leg_numtrip_idtrip_num
22000050220000500112200005001025212022-10-14T00:00:00.0002200005001001122000050010011
220000502200005001

Columns

98 queryable · 98 profiled

The machine field names SoQL needs, with the publisher's own description of each.

FieldTypeDescriptionNullValues
hh_idtext—0%221228952200564822008778
person_idtext—0%221228950122005648012200877801
person_numtext—0%1of 1
day_idtext—0%220032960107221228950106221092690101
travel_dowcategorical—

Query this from your own app

GET /api/datasets/x5mc-2gmi
GET /api/datasets/x5mc-2gmi/quality
GET /api/datasets/x5mc-2gmi/related
GET /api/columns?dataset=x5mc-2gmi
  • Citywide Mobility Survey - Household 20220.52
    joins onhh_id
  • Citywide Mobility Survey - Person Survey 20190.49
    joins onperson_idperson_numhh_id
  • Citywide Mobility Survey - Trip Diary 20170.49
  • Citywide Mobility Survey - Trip Diary 20180.47
    joins ontrip_id
  • Citywide Mobility Survey - Person 20220.47
    joins onperson_idperson_numhh_id
  • Citywide Mobility Survey - Household 20240.46
    joins onhh_idis_complete
    • 1
    220000500102
    5
    2
    1
    2022-10-14T00:00:00.000
    2200005001002
    1
    2200005001002
    2
    22000050220000500112200005001062612022-10-18T00:00:00.0002200005001003122000050010033
    22000050220000500112200005001062612022-10-18T00:00:00.0002200005001004122000050010044
    22000105220001050112200010501011112022-10-17T00:00:00.0002200010501001122000105010011
    22000105220001050112200010501011112022-10-17T00:00:00.0002200010501002122000105010022
    22000105220001050112200010501011112022-10-17T00:00:00.0002200010501003122000105010033
    22000105220001050112200010501011112022-10-17T00:00:00.0002200010501004122000105010044
    22000105220001050112200010501011112022-10-17T00:00:00.0002200010501004222000105010055
    22000105220001050112200010501011112022-10-17T00:00:00.0002200010501004322000105010066

    Showing 12 of 97 columns. All of them are listed below.

    0%
    432of 7
    day_numcategorical—0%123of 7
    is_completecategorical—0%19950of 3
    travel_datedatetime—0%2022-10-18T00:00:00.0002022-10-14T00:00:00.0002022-10-12T00:00:00.000
    linked_trip_idtext—0%220644850100222053619010442208334501007
    linked_leg_numcategorical—0%123of 13
    trip_idtext—0%221306470109422145485010062204928801019
    trip_numtext—0%123
    day_is_completecategorical—0%10of 2
    arrive_dowcategorical—0%432of 7
    depart_dowcategorical—0%432of 7
    o_in_regioncategorical—0%10of 2
    o_countytext—0%360613608136047
    d_in_regioncategorical—0%10of 2
    d_countytext—0%360613608136047
    mode_type_nyccategorical—0%976of 12
    r_mode_type_nyccategorical—0%413of 7
    mode_1text—0%19956
    mode_2text—0%995130
    mode_3text—0%995178
    mode_priority_nyctext—0%1306
    transit_accesscategorical—0%99513of 12
    r_transit_accesscategorical—0%99510of 7
    transit_egresscategorical—0%99513of 12
    r_transit_egresscategorical—0%99510of 7
    park_locationcategorical—0%99543of 7
    park_typecategorical—0%99513of 6
    park_paycategorical—0%99512of 4
    park_costcoordinate—0%NA0.010.04
    ev_charge_stationcategorical—0%99514of 5
    ev_charge_station_level_1categorical—0%99501of 3
    ev_charge_station_level_2categorical—0%99501of 3
    ev_charge_station_level_3categorical—0%9950of 2
    ev_charge_station_level_4categorical—0%99501of 3
    ev_charge_station_level_5categorical—0%99501of 3
    ev_charge_station_level_997categorical—0%99501of 3
    ev_charge_station_level_998categorical—0%99501of 3
    tnc_typecategorical—0%9952998of 5
    taxi_typecategorical—0%99514of 6
    taxi_paycategorical—0%99512of 3
    taxi_costinteger—99%152012
    transit_typecategorical—0%9951011of 8
    bike_park_loccategorical—0%99571of 12
    scooter_park_locationcategorical—0%995110of 12
    num_travelerscategorical—0%123of 6
    num_hh_travelerscategorical—0%123of 9
    num_non_hh_travelerscategorical—0%01995of 7
    hh_member_1text—0%1of 1
    hh_member_2categorical—0%09951of 3
    hh_member_3categorical—0%99501of 3
    hh_member_4categorical—0%99501of 3
    hh_member_5categorical—0%99501of 3
    hh_member_6categorical—0%99501of 3
    hh_member_7categorical—0%99501of 3
    hh_member_8categorical—0%99501of 3
    hh_member_9categorical—0%99501of 3
    hh_member_10categorical—0%99501of 3
    hh_member_11categorical—0%99510of 3
    hh_member_12categorical—0%99501of 3
    drivercategorical—0%99512of 4
    o_purposetext—0%60150
    o_purpose_categorycategorical—0%1119of 15
    d_purposetext—0%60150
    d_purpose_categorycategorical—0%1119of 14
    d_purpose_category_linkedcategorical—0%198of 14
    r_d_purpose_category_linkedcategorical—0%179of 11
    work_tripcategorical—0%01-1of 3
    depart_datedatetime—0%2022-10-18T00:00:00.0002022-10-14T00:00:00.0002022-10-12T00:00:00.000
    depart_hourinteger—0%171816
    depart_minuteinteger—0%03045
    depart_secondsinteger—0%012
    r_timeofdaycategorical—0%231of 5
    arrive_datedatetime—0%2022-10-18T00:00:00.0002022-10-14T00:00:00.0002022-10-12T00:00:00.000
    arrive_hourinteger—0%171816
    arrive_minuteinteger—0%03045
    arrive_secondinteger—0%012
    duration_minutesinteger—0%054
    r_duration_minutescategorical—0%123of 5
    duration_secondstext—0%01900
    distance_milesfloat—8%00.006917090.020751269
    r_distance_milescategorical—0%132of 6
    dwell_minstext—0%00.01666666710
    high_speed_flagcategorical—0%01of 2
    long_distance_flagcategorical—0%01of 2
    o_cms_zonecategorical—8%Manhattan CoreInner BrooklynUpper Manhattanof 12
    d_cms_zonecategorical—8%Manhattan CoreInner BrooklynUpper Manhattanof 12
    unlinked_tripcategorical—0%01of 2
    o_location_typecategorical—0%412of 6
    d_location_typecategorical—0%412of 5
    transit_quality_flagcategorical—90%SASEMODEof 5
    mode_typecategorical—0%976of 12
    trip_weightcoordinate—0%055.22960159108.0346479
    trip_weight_citywidecoordinate—0%0121.5305307112.5177103
    added_tripcategorical—0%01of 2