From a 500-row sample across 110 columns.
person_idd_cms_zonescooter_park_location+76person_idperson_numhh_id| hh_id | person_id | person_num | day_id | day_num | travel_date | travel_dow | hh_day_complete | trip_id | trip_num | trip_survey_complete | day_is_complete |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 24000079 | 2400007901 | 1 | 240000790101 | 1 | 2024-05-31T00:00:00.000 | 5 | 1 | 2400007901033 | 1 | 995 | 1 |
| 24000079 | 2400007901 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
hh_id | integer | — | 0% | 241525672413989624058123 |
person_id | integer | — | 0% | 241525670124139896012405812301 |
person_num | integer | — | 0% | 1of 1 |
day_id | integer | — | 0% | 240581230105241525670107240438560101 |
day_num | categorical | — |
GET /api/datasets/wgnh-qwsg GET /api/datasets/wgnh-qwsg/quality GET /api/datasets/wgnh-qwsg/related GET /api/columns?dataset=wgnh-qwsg
person_idd_cms_zonescooter_park_locationhh_idperson_idperson_numhh_idhh_idhh_id| 1 |
| 240000790101 |
| 1 |
| 2024-05-31T00:00:00.000 |
| 5 |
| 1 |
| 2400007901001 |
| 2 |
| 1 |
| 1 |
| 24000079 | 2400007901 | 1 | 240000790101 | 1 | 2024-05-31T00:00:00.000 | 5 | 1 | 2400007901002 | 3 | 1 | 1 |
| 24000079 | 2400007901 | 1 | 240000790101 | 1 | 2024-05-31T00:00:00.000 | 5 | 1 | 2400007901003 | 4 | 1 | 1 |
| 24000079 | 2400007901 | 1 | 240000790101 | 1 | 2024-05-31T00:00:00.000 | 5 | 1 | 2400007901004 | 5 | 1 | 1 |
| 24000079 | 2400007901 | 1 | 240000790101 | 1 | 2024-05-31T00:00:00.000 | 5 | 1 | 2400007901005 | 6 | 1 | 1 |
| 24000079 | 2400007901 | 1 | 240000790101 | 1 | 2024-05-31T00:00:00.000 | 5 | 1 | 2400007901006 | 7 | 1 | 1 |
| 24000079 | 2400007901 | 1 | 240000790101 | 1 | 2024-05-31T00:00:00.000 | 5 | 1 | 2400007901007 | 8 | 1 | 1 |
| 24000079 | 2400007901 | 1 | 240000790101 | 1 | 2024-05-31T00:00:00.000 | 5 | 1 | 2400007901037 | 9 | 995 | 1 |
| 24000079 | 2400007901 | 1 | 240000790102 | 2 | 2024-06-01T00:00:00.000 | 6 | 1 | 2400007901008 | 10 | 1 | 1 |
Showing 12 of 108 columns. All of them are listed below.
| 0% |
124of 7 |
travel_date | datetime | — | 0% | 2024-06-03T00:00:00.0002024-05-31T00:00:00.0002024-06-01T00:00:00.000 |
travel_dow | categorical | — | 0% | 532of 7 |
hh_day_complete | categorical | — | 0% | 10of 2 |
trip_id | integer | — | 0% | 241101750101424059369010272415263601021 |
trip_num | integer | — | 0% | 123 |
trip_survey_complete | categorical | — | 0% | 19950of 3 |
day_is_complete | categorical | — | 0% | 10of 2 |
depart_date | datetime | — | 0% | 2024-06-03T00:00:00.0002024-05-31T00:00:00.0002024-06-01T00:00:00.000 |
depart_dow | categorical | — | 0% | 532of 7 |
depart_hour | integer | — | 0% | 171618 |
depart_minute | integer | — | 0% | 03015 |
depart_seconds | integer | — | 0% | 012 |
arrive_date | datetime | — | 0% | 2024-06-03T00:00:00.0002024-05-31T00:00:00.0002024-06-01T00:00:00.000 |
arrive_dow | categorical | — | 0% | 532of 7 |
arrive_hour | integer | — | 0% | 171816 |
arrive_minute | integer | — | 0% | 03015 |
arrive_second | integer | — | 0% | 012 |
distance_miles | float | — | 9% | 08.189484407844350.000691708966021788 |
flag_distance | categorical | — | 0% | 01of 2 |
duration_seconds | integer | — | 9% | 1300900 |
duration_minutes | integer | — | 9% | 564 |
flag_duration | categorical | — | 0% | 01of 2 |
dwell_mins | float | — | 0% | 00.01666666666666675 |
flag_speed | categorical | — | 0% | 01of 2 |
o_in_region | categorical | — | 0% | 10of 2 |
o_county | categorical | — | 7% | 360613608136047of 5 |
o_cms_zone | categorical | — | 0% | 839of 13 |
d_in_region | categorical | — | 0% | 10of 2 |
d_county | categorical | — | 7% | 360613608136047of 5 |
d_cms_zone | categorical | — | 0% | 839of 13 |
mode_1_app | integer | — | 0% | 199530 |
mode_2_app | integer | — | 0% | 995130 |
mode_3_app | integer | — | 0% | 995158 |
mode_4_app | categorical | — | 0% | 9951175of 17 |
mode_5_app | categorical | — | 0% | 9951751of 8 |
mode_6_app | categorical | — | 0% | 9951855of 3 |
mode_7_app | categorical | — | 0% | 99516of 2 |
mode_8_app | categorical | — | 0% | 99563of 2 |
mode_9_app | categorical | — | 0% | 9951of 2 |
mode_1 | integer | — | 0% | 19956 |
mode_2 | integer | — | 0% | 995130 |
mode_3 | integer | — | 0% | 995158 |
mode_4 | categorical | — | 0% | 9951175of 16 |
mode_5 | categorical | — | 0% | 9951751of 8 |
mode_6 | categorical | — | 0% | 9951855of 3 |
mode_7 | categorical | — | 0% | 99516of 2 |
mode_8 | categorical | — | 0% | 99563of 2 |
mode_9 | categorical | — | 0% | 9951of 2 |
mode_priority | integer | — | 0% | 130995 |
mode_type | categorical | — | 0% | 1138of 13 |
transit_access | categorical | — | 0% | 995111of 13 |
transit_egress | categorical | — | 0% | 995111of 13 |
park_location | categorical | — | 0% | 99543of 7 |
park_type | categorical | — | 0% | 99513of 6 |
park_pay | categorical | — | 0% | 99512of 4 |
park_cost | coordinate | — | 99% | 0.010.050.02 |
ev_charge_station | categorical | — | 0% | 99534of 5 |
ev_charge_station_level_1 | categorical | — | 0% | 99501of 3 |
ev_charge_station_level_2 | categorical | — | 0% | 99501of 3 |
ev_charge_station_level_3 | categorical | — | 0% | 99501of 3 |
ev_charge_station_level_4 | categorical | — | 0% | 99501of 3 |
ev_charge_station_level_5 | categorical | — | 0% | 99501of 3 |
ev_charge_station_level_997 | categorical | — | 0% | 99501of 3 |
ev_charge_station_level_998 | categorical | — | 0% | 99501of 3 |
tnc_type | categorical | — | 0% | 99521of 5 |
taxi_pay | categorical | — | 0% | 99512of 3 |
taxi_cost | text | — | 99% | 152010 |
transit_type | categorical | — | 0% | 9951110of 8 |
bike_park_loc | categorical | — | 0% | 99571of 11 |
citi_bike_alt_mode | categorical | — | 0% | 99515of 10 |
scooter_park_location | categorical | — | 0% | 99519of 11 |
hh_member_1 | integer | — | 0% | 1of 1 |
hh_member_2 | categorical | — | 0% | 09951of 3 |
hh_member_3 | categorical | — | 0% | 99501of 3 |
hh_member_4 | categorical | — | 0% | 99501of 3 |
hh_member_5 | categorical | — | 0% | 99501of 3 |
hh_member_6 | categorical | — | 0% | 99501of 3 |
hh_member_7 | categorical | — | 0% | 99501of 3 |
hh_member_8 | categorical | — | 0% | 99501of 3 |
hh_member_9 | categorical | — | 0% | 99501of 3 |
hh_member_10 | categorical | — | 0% | 99501of 3 |
hh_member_11 | categorical | — | 0% | 99501of 3 |
hh_member_12 | categorical | — | 0% | 9951of 2 |
hh_member_13 | categorical | — | 0% | 9951of 2 |
num_travelers | categorical | — | 0% | 123of 6 |
num_hh_travelers | categorical | — | 0% | 123of 7 |
num_non_hh_travelers | categorical | — | 0% | 01995of 7 |
driver | categorical | — | 0% | 99512of 4 |
purpose_app | integer | — | 0% | 11050 |
o_purpose | integer | — | 0% | 60150 |
o_purpose_category | categorical | — | 0% | 1119of 15 |
d_purpose | integer | — | 0% | 60150 |
d_purpose_category | categorical | — | 0% | 1119of 14 |
added_trip | categorical | — | 0% | 01of 2 |
added_type | categorical | — | 0% | 012of 4 |
unlinked_trip | categorical | — | 0% | 01of 2 |
transit_quality_flag | categorical | — | 0% | 99501of 6 |
linked_trip_id | integer | — | 0% | 241402830101524120968010332413908901057 |
linked_trip_num | integer | — | 0% | 123 |
n_legs | categorical | — | 0% | 134of 13 |
leg_num | categorical | — | 0% | 123of 15 |
trip_weight_zonal | float | — | 0% | 0341.73629523429716.7618783240366 |
flag_mode | categorical | — | 0% | 01of 2 |
num_flags | categorical | — | 0% | 012of 5 |
trip_weight_citywide | float | — | 0% | 0127.30183043555443.1281878301818 |