From a 500-row sample across 97 columns.
hh_idis_completehh_idnum_trips+1increased_veh_1num_peopleev_purchase_barriers_4+77| hh_id | diary_platform | signup_platform | participation_group | sample_home_cms_zone | is_complete | num_days_complete | num_days_complete_weekday | num_complete_mon | num_complete_tue | num_complete_wed | num_complete_thu |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 24000079 | 1 | 1 | 9 | 1 | 1 | 6 | 4 | 1 | 1 | 1 | 0 |
| 24000108 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
hh_id | integer | — | 0% | 240461292410304424021564 |
diary_platform | categorical | — | 0% | 123of 3 |
signup_platform | categorical | — | 0% | 123of 3 |
participation_group | categorical | — | 0% | 913of 8 |
sample_home_cms_zone | categorical |
GET /api/datasets/5mb3-padx GET /api/datasets/5mb3-padx/quality GET /api/datasets/5mb3-padx/related GET /api/columns?dataset=5mb3-padx
num_peopleis_completenum_students+9hh_idhome_cms_zoneis_completehh_idhh_idnum_tripsnum_days_completehh_id| 1 |
| 1 |
| 9 |
| 1 |
| 1 |
| 7 |
| 5 |
| 1 |
| 1 |
| 1 |
| 1 |
| 24000202 | 1 | 1 | 9 | 1 | 1 | 7 | 5 | 1 | 1 | 1 | 1 |
| 24000229 | 1 | 2 | 3 | 1 | 1 | 7 | 5 | 1 | 1 | 1 | 1 |
| 24000305 | 2 | 2 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 1 |
| 24000347 | 2 | 2 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 |
| 24000381 | 1 | 1 | 9 | 1 | 1 | 7 | 5 | 1 | 1 | 1 | 1 |
| 24000467 | 1 | 1 | 9 | 1 | 1 | 7 | 5 | 1 | 1 | 1 | 1 |
| 24000504 | 1 | 1 | 9 | 1 | 1 | 7 | 5 | 1 | 1 | 1 | 1 |
| 24000545 | 1 | 1 | 9 | 1 | 1 | 7 | 5 | 1 | 1 | 1 | 1 |
Showing 12 of 97 columns. All of them are listed below.
| — |
| 0% |
99595of 11 |
is_complete | integer | — | 0% | 1of 1 |
num_days_complete | categorical | — | 0% | 716of 7 |
num_days_complete_weekday | categorical | — | 0% | 514of 6 |
num_complete_mon | categorical | — | 0% | 10of 2 |
num_complete_tue | categorical | — | 0% | 10of 2 |
num_complete_wed | categorical | — | 0% | 10of 2 |
num_complete_thu | categorical | — | 0% | 10of 2 |
num_complete_fri | categorical | — | 0% | 10of 2 |
num_days_complete_weekend | categorical | — | 0% | 201of 3 |
num_complete_sat | categorical | — | 0% | 10of 2 |
num_complete_sun | categorical | — | 0% | 10of 2 |
num_people | categorical | — | 0% | 213of 12 |
num_adults | categorical | — | 0% | 213of 10 |
num_kids | categorical | — | 0% | 012of 10 |
num_workers | categorical | — | 0% | 10of 2 |
num_students | categorical | — | 0% | 012of 5 |
num_trips | integer | — | 0% | 602 |
home_in_region | integer | — | 0% | 1of 1 |
home_county | categorical | — | 0% | 360813606136047of 5 |
home_cms_zone | categorical | — | 0% | 935of 10 |
residence_type | categorical | — | 0% | 451of 10 |
residence_rent_own | categorical | — | 0% | 21999of 7 |
income_broad | categorical | — | 0% | 532of 9 |
num_vehicles | categorical | — | 0% | 012of 8 |
vehicle_change | categorical | — | 0% | 99531of 4 |
increased_veh_1 | categorical | — | 0% | 99501of 3 |
increased_veh_2 | categorical | — | 0% | 99501of 3 |
increased_veh_3 | categorical | — | 0% | 99501of 3 |
increased_veh_4 | categorical | — | 0% | 99501of 3 |
increased_veh_5 | categorical | — | 0% | 99501of 3 |
increased_veh_6 | categorical | — | 0% | 99501of 3 |
increased_veh_7 | categorical | — | 0% | 99501of 3 |
increased_veh_8 | categorical | — | 0% | 99501of 3 |
increased_veh_997 | categorical | — | 0% | 99501of 3 |
reduced_veh_1 | categorical | — | 0% | 99510of 3 |
reduced_veh_2 | categorical | — | 0% | 99501of 3 |
reduced_veh_3 | categorical | — | 0% | 99501of 3 |
reduced_veh_4 | categorical | — | 0% | 99501of 3 |
reduced_veh_5 | categorical | — | 0% | 99501of 3 |
reduced_veh_6 | categorical | — | 0% | 99501of 3 |
reduced_veh_7 | categorical | — | 0% | 99501of 3 |
reduced_veh_8 | categorical | — | 0% | 99501of 3 |
reduced_veh_997 | categorical | — | 0% | 99501of 3 |
ev_typical_charge_1 | categorical | — | 0% | 99510of 3 |
ev_typical_charge_2 | categorical | — | 0% | 99501of 3 |
ev_typical_charge_3 | categorical | — | 0% | 99501of 3 |
ev_typical_charge_4 | categorical | — | 0% | 99501of 3 |
ev_typical_charge_5 | categorical | — | 0% | 99501of 3 |
ev_typical_charge_6 | categorical | — | 0% | 99501of 3 |
ev_typical_charge_7 | categorical | — | 0% | 9950of 2 |
ev_typical_charge_997 | categorical | — | 0% | 99501of 3 |
ev_purchase | categorical | — | 0% | 99532of 5 |
ev_purchase_barriers_1 | categorical | — | 0% | 99501of 3 |
ev_purchase_barriers_2 | categorical | — | 0% | 99510of 3 |
ev_purchase_barriers_3 | categorical | — | 0% | 99501of 3 |
ev_purchase_barriers_4 | categorical | — | 0% | 99501of 3 |
ev_purchase_barriers_5 | categorical | — | 0% | 99501of 3 |
num_bicycles | categorical | — | 0% | 012of 10 |
bicycle_type_1 | categorical | — | 0% | 99510of 3 |
bicycle_type_2 | categorical | — | 0% | 99501of 3 |
bicycle_type_3 | categorical | — | 0% | 99501of 3 |
bicycle_type_4 | categorical | — | 0% | 99501of 3 |
bicycle_type_997 | categorical | — | 0% | 99501of 3 |
ebike_new | categorical | — | 0% | 99501of 3 |
ebike_new_no_1 | categorical | — | 0% | 99510of 3 |
ebike_new_no_2 | categorical | — | 0% | 99501of 3 |
ebike_new_no_3 | categorical | — | 0% | 99501of 3 |
ebike_new_no_4 | categorical | — | 0% | 99501of 3 |
ebike_new_no_5 | categorical | — | 0% | 99501of 3 |
ebike_new_no_6 | categorical | — | 0% | 99501of 3 |
ebike_new_no_997 | categorical | — | 0% | 99501of 3 |
bike_change | categorical | — | 0% | 99532of 4 |
increased_bike_1 | categorical | — | 0% | 99501of 3 |
increased_bike_2 | categorical | — | 0% | 99501of 3 |
increased_bike_3 | categorical | — | 0% | 99501of 3 |
increased_bike_4 | categorical | — | 0% | 99501of 3 |
increased_bike_5 | categorical | — | 0% | 99501of 3 |
increased_bike_6 | categorical | — | 0% | 99501of 3 |
increased_bike_7 | categorical | — | 0% | 99510of 3 |
increased_bike_997 | categorical | — | 0% | 99501of 3 |
reduced_bike_1 | categorical | — | 0% | 99501of 3 |
reduced_bike_2 | categorical | — | 0% | 99501of 3 |
reduced_bike_3 | categorical | — | 0% | 99501of 3 |
reduced_bike_4 | categorical | — | 0% | 99501of 3 |
reduced_bike_5 | categorical | — | 0% | 99501of 3 |
reduced_bike_6 | categorical | — | 0% | 99501of 3 |
reduced_bike_7 | categorical | — | 0% | 99501of 3 |
reduced_bike_997 | categorical | — | 0% | 99501of 3 |
num_scooters | categorical | — | 0% | 99510of 6 |
hh_weight_zonal | float | — | 0% | 365.5662795570.8475911196.077033 |
flag_mm_trips | categorical | — | 0% | 01of 2 |
hh_weight_citywide | float | — | 0% | 445.5564065301.8973148217.6276354 |