From a 500-row sample across 77 columns.
person_numsurvey_modehh_id+1survey_modehh_idtravel_dateperson_numsurvey_mode+4survey_modehh_id| hh_id | trip_weight | home_cms_zone | survey_mode | person_id | person_num | day_num | travel_date | travel_date_dow | trip_id | trip_num | leg_num |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 19000235 | 0.0 | Northern Bronx | 1 | 1900023501 | 1 | 1 | 2019-05-30T00:00:00.000 | 4 | 1900023501001 | 1 | 1 |
| 19000235 | 0.0 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
hh_id | integer | — | 0% | 197113321909204119278932 |
trip_weight | float | — | 0% | 0.016.610.4 |
home_cms_zone | categorical | — | 0% | Northern BronxStaten IslandInner Brooklynof 10 |
survey_mode | categorical | — | 0% | 123of 3 |
person_id | integer |
GET /api/datasets/w9dc-u4ik GET /api/datasets/w9dc-u4ik/quality GET /api/datasets/w9dc-u4ik/related GET /api/columns?dataset=w9dc-u4ik
trip_distance| Northern Bronx |
| 1 |
| 1900023501 |
| 1 |
| 2 |
| 2019-05-31T00:00:00.000 |
| 5 |
| 1900023501002 |
| 2 |
| 1 |
| 19000235 | 0.0 | Northern Bronx | 1 | 1900023501 | 1 | 2 | 2019-05-31T00:00:00.000 | 5 | 1900023501003 | 3 | 1 |
| 19000235 | 0.0 | Northern Bronx | 1 | 1900023501 | 1 | 3 | 2019-06-01T00:00:00.000 | 6 | 1900023501004 | 4 | 1 |
| 19000235 | 0.0 | Northern Bronx | 1 | 1900023501 | 1 | 3 | 2019-06-01T00:00:00.000 | 6 | 1900023501005 | 5 | 1 |
| 19000235 | 0.0 | Northern Bronx | 1 | 1900023501 | 1 | 3 | 2019-06-01T00:00:00.000 | 6 | 1900023501006 | 6 | 1 |
| 19000235 | 0.0 | Northern Bronx | 1 | 1900023501 | 1 | 3 | 2019-06-01T00:00:00.000 | 6 | 1900023501007 | 7 | 1 |
| 19000235 | 0.0 | Northern Bronx | 1 | 1900023501 | 1 | 3 | 2019-06-01T00:00:00.000 | 6 | 1900023501008 | 8 | 1 |
| 19000235 | 0.0 | Northern Bronx | 1 | 1900023501 | 1 | 3 | 2019-06-01T00:00:00.000 | 6 | 1900023501009 | 9 | 1 |
| 19000235 | 0.0 | Northern Bronx | 1 | 1900023501 | 1 | 3 | 2019-06-01T00:00:00.000 | 6 | 1900023501010 | 10 | 1 |
Showing 12 of 74 columns. All of them are listed below.
| — |
| 0% |
197113320119092041011927893201 |
person_num | integer | — | 0% | 1of 1 |
day_num | categorical | — | 0% | 123of 7 |
travel_date | datetime | — | 0% | 2019-06-07T00:00:00.0002019-06-08T00:00:00.0002019-06-11T00:00:00.000 |
travel_date_dow | categorical | — | 0% | 534of 7 |
trip_id | integer | — | 0% | 1928632260100519755534010141966435701032 |
trip_num | integer | — | 0% | 123 |
leg_num | categorical | — | 0% | 123of 9 |
unlinked_trip | categorical | — | 0% | 01995of 3 |
linked_trip_num | integer | — | 0% | 123 |
survey_complete | categorical | — | 0% | 10of 2 |
depart_time | datetime | — | 0% | 2019-06-05T07:00:00.0002019-06-10T08:00:00.0002019-06-04T08:00:00.000 |
arrive_time | datetime | — | 0% | 2019-06-05T17:45:00.0002019-06-05T08:00:00.0002019-06-06T08:00:00.000 |
o_cms_zone | categorical | — | 7% | Manhattan CoreInner BrooklynNorthern Bronxof 12 |
d_cms_zone | categorical | — | 7% | Manhattan CoreInner BrooklynNorthern Bronxof 12 |
trip_duration | float | — | 0% | 3.03.10.0 |
trip_distance | float | — | 0% | 0.20.10.3 |
o_purpose | integer | — | 0% | 13360 |
o_purpose_category | categorical | — | 0% | 1610of 11 |
d_purpose | integer | — | 0% | 13360 |
d_purpose_category | categorical | — | 0% | 1610of 11 |
num_non_hh_travelers | categorical | — | 0% | 01-9998of 7 |
num_hh_travelers | categorical | — | 0% | 12-9998of 8 |
num_travelers | categorical | — | 0% | 12-9998of 12 |
hh_member_1 | integer | — | 0% | 197113320119092041011927893201 |
hh_member_2 | integer | — | 0% | 09951951389102 |
hh_member_3 | integer | — | 0% | 99501904819703 |
hh_member_4 | integer | — | 0% | 99501939943804 |
hh_member_5 | integer | — | 0% | 99501951389105 |
hh_member_6 | integer | — | 0% | 99501912335706 |
hh_member_7 | integer | — | 0% | 99501985482607 |
hh_member_8 | categorical | — | 0% | 99501985482608of 4 |
hh_member_9 | categorical | — | 0% | 99501901681409of 3 |
hh_member_10 | categorical | — | 0% | 99501964486110of 3 |
hh_member_11 | categorical | — | 0% | 99501964486111of 3 |
mode_type | categorical | — | 0% | 976of 11 |
mode_type_detailed | integer | — | 0% | 482511 |
sustainable_mode | categorical | — | 0% | 10995of 3 |
mode_1 | integer | — | 0% | 1630 |
mode_2 | integer | — | 0% | 9953023 |
mode_3 | integer | — | 0% | 9953023 |
mode_4 | categorical | — | 0% | 9953023of 14 |
driver | categorical | — | 0% | 19952of 3 |
park_location | categorical | — | 0% | 99543of 9 |
park_pay | categorical | — | 0% | 99512of 6 |
park_cost | text | — | 99% | 0.510.3 |
used_transit | categorical | — | 0% | 01of 2 |
transit_access | categorical | — | 0% | 9951-9998of 11 |
transit_egress | categorical | — | 0% | 9951-9998of 11 |
taxi_cost | categorical | — | 0% | 99512of 3 |
taxi_cost_amount | integer | — | 98% | 10150 |
bike_park_location | categorical | — | 0% | 9952997of 10 |
scooter_park_location | categorical | — | 0% | 9959977of 9 |
analyst_split | categorical | — | 0% | 01995of 3 |
analyst_merge | categorical | — | 0% | 09951of 3 |
analyst_split_loop | categorical | — | 0% | 01995of 3 |
user_merged | categorical | — | 0% | 01995of 3 |
user_split | categorical | — | 0% | 09951of 3 |
added_trip | categorical | — | 0% | 01995of 3 |
high_speed_flag | categorical | — | 0% | 01of 2 |
long_distance_flag | categorical | — | 0% | 01of 2 |
invalid_purpose_flag | categorical | — | 0% | 01of 2 |
o_purpose_imputed | integer | — | 0% | 13360 |
d_purpose_imputed | integer | — | 0% | 13360 |
o_purpose_category_imputed | categorical | — | 0% | 1610of 12 |
d_purpose_category_imputed | categorical | — | 0% | 1610of 12 |
d_distance_home | float | — | 0% | 0.20.30 |
d_distance_work | float | — | 35% | 01.42.8 |
d_distance_school | float | — | 97% | 09799.719489.7 |
o_location_type | categorical | — | 0% | 412of 4 |
d_location_type | categorical | — | 0% | 412of 4 |
o_congestion | categorical | — | 0% | 01of 2 |
d_congestion | categorical | — | 0% | 01of 2 |