From a 500-row sample across 212 columns.
| person_id | hh_id | bike_num_days | bike_purpose_recreation | bike_purpose_grocery | bike_purpose_shopping | bike_purpose_medical | bike_purpose_visit_friend | bike_purpose_work | bike_purpose_work_related | bike_purpose_restaurant | bike_purpose_other |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1900158301 | 19001583 | 0 | 995 | 995 | 995 | 995 | 995 | 995 | 995 | 995 | 995 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
person_id | integer | — | 0% | 190416700119138629011910999101 |
hh_id | integer | — | 0% | 192955851973746419915209 |
bike_num_days | categorical | — | 0% | 013of 8 |
bike_purpose_recreation | categorical | — | 0% | 99510of 3 |
bike_purpose_grocery |
GET /api/datasets/3mpc-kqwk GET /api/datasets/3mpc-kqwk/quality GET /api/datasets/3mpc-kqwk/related GET /api/columns?dataset=3mpc-kqwk
| 1900169401 |
| 19001694 |
| 0 |
| 995 |
| 995 |
| 995 |
| 995 |
| 995 |
| 995 |
| 995 |
| 995 |
| 995 |
| 1900230101 | 19002301 | 4 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 |
| 1900330701 | 19003307 | 0 | 995 | 995 | 995 | 995 | 995 | 995 | 995 | 995 | 995 |
| 1900422601 | 19004226 | 0 | 995 | 995 | 995 | 995 | 995 | 995 | 995 | 995 | 995 |
| 1900438701 | 19004387 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 1900444201 | 19004442 | 0 | 995 | 995 | 995 | 995 | 995 | 995 | 995 | 995 | 995 |
| 1900526701 | 19005267 | 0 | 995 | 995 | 995 | 995 | 995 | 995 | 995 | 995 | 995 |
| 1900610701 | 19006107 | 0 | 995 | 995 | 995 | 995 | 995 | 995 | 995 | 995 | 995 |
| 1900767401 | 19007674 | 0 | 995 | 995 | 995 | 995 | 995 | 995 | 995 | 995 | 995 |
Showing 12 of 212 columns. All of them are listed below.
| categorical |
| — |
| 0% |
99501of 3 |
bike_purpose_shopping | categorical | — | 0% | 99501of 3 |
bike_purpose_medical | categorical | — | 0% | 99501of 3 |
bike_purpose_visit_friend | categorical | — | 0% | 99501of 3 |
bike_purpose_work | categorical | — | 0% | 99501of 3 |
bike_purpose_work_related | categorical | — | 0% | 99501of 3 |
bike_purpose_restaurant | categorical | — | 0% | 99501of 3 |
bike_purpose_other | categorical | — | 0% | 99501of 3 |
bike_type_owned | categorical | — | 0% | 99510of 3 |
bike_type_borrowed | categorical | — | 0% | 99501of 3 |
bike_type_bike_share | categorical | — | 0% | 99501of 3 |
bike_type_other | categorical | — | 0% | 9950of 2 |
shopping_food_in_store | categorical | — | 0% | 123of 8 |
shopping_food_grocery_pick | categorical | — | 0% | 012of 7 |
shopping_food_grocery_delivery | categorical | — | 0% | 012of 6 |
shopping_food_restaurant | categorical | — | 0% | 012of 8 |
shopping_food_restaurant_1 | categorical | — | 0% | 012of 8 |
shopping_food_restaurant_2 | categorical | — | 0% | 012of 8 |
delivery_major_retailer | categorical | — | 0% | 120of 8 |
delivery_small_retailer | categorical | — | 0% | 012of 8 |
delivery_home | categorical | — | 0% | 123of 8 |
delivery_work | categorical | — | 0% | 012of 8 |
delivery_other_location | categorical | — | 0% | 012of 4 |
delivery_service | categorical | — | 0% | 012of 7 |
modes_used_household_vehicle | categorical | — | 0% | 017of 8 |
modes_used_other_vehicle | categorical | — | 0% | 012of 8 |
modes_used_tnc | categorical | — | 0% | 012of 8 |
modes_used_bus | categorical | — | 0% | 012of 8 |
modes_used_subway | categorical | — | 0% | 012of 8 |
modes_used_rail | categorical | — | 0% | 012of 6 |
modes_used_ferry | categorical | — | 0% | 012of 5 |
modes_used_walk | categorical | — | 0% | 072of 8 |
modes_used_scooter | categorical | — | 0% | 013of 3 |
trip_purpose_work | categorical | — | 0% | 051of 8 |
trip_purpose_food | categorical | — | 0% | 012of 8 |
trip_purpose_restaurant | categorical | — | 0% | 012of 7 |
trip_purpose_shopping | categorical | — | 0% | 123of 8 |
trip_purpose_social | categorical | — | 0% | 012of 8 |
trip_purpose_exercise | categorical | — | 0% | 071of 8 |
trip_purpose_school | categorical | — | 0% | 051of 7 |
trip_purpose_drop_off | categorical | — | 0% | 012of 8 |
trip_purpose_other | categorical | — | 0% | 013of 7 |
food_mode | categorical | — | 0% | 921of 10 |
errand_mode | categorical | — | 0% | 921of 10 |
dine_location_outdoor_seating | categorical | — | 0% | 01of 2 |
dine_location_sidewalk | categorical | — | 0% | 01of 2 |
dine_location_indoor | categorical | — | 0% | 01of 2 |
dine_location_none | categorical | — | 0% | 01of 2 |
medical_appointment | categorical | — | 0% | 10of 2 |
medical_telehealth | categorical | — | 0% | 01of 2 |
medical_other_virtual | categorical | — | 0% | 01of 2 |
medical_postponed | categorical | — | 0% | 01of 2 |
medical_none | categorical | — | 0% | 01of 2 |
medical_mode | categorical | — | 0% | 99529of 13 |
modes_used_july_household | categorical | — | 0% | 01of 2 |
modes_used_july_other_vehicle | categorical | — | 0% | 01of 2 |
modes_used_july_tnc | categorical | — | 0% | 01of 2 |
modes_used_july_bus | categorical | — | 0% | 01of 2 |
modes_used_july_subway | categorical | — | 0% | 01of 2 |
modes_used_july_rail | categorical | — | 0% | 01of 2 |
modes_used_july_ferry | categorical | — | 0% | 01of 2 |
modes_used_july_walk | categorical | — | 0% | 10of 2 |
modes_used_july_bike | categorical | — | 0% | 01of 2 |
modes_used_july_scooter | categorical | — | 0% | 01of 2 |
modes_used_july_moped | categorical | — | 0% | 01of 2 |
car_use | categorical | — | 0% | 99512of 3 |
bike_freq | categorical | — | 0% | 541of 6 |
vehicle_change | categorical | — | 0% | 312of 3 |
reduced_vehicle_cost | categorical | — | 0% | 99501of 3 |
reduced_vehicle_parking | categorical | — | 0% | 99501of 3 |
reduced_vehicle_no_need | categorical | — | 0% | 99501of 3 |
reduced_vehicle_ridehailing | categorical | — | 0% | 99501of 3 |
reduced_vehicle_carshare | categorical | — | 0% | 9950of 2 |
reduced_vehicle_transit | categorical | — | 0% | 99501of 3 |
reduced_vehicle_nyc_driving | categorical | — | 0% | 99501of 3 |
reduced_vehicle_other | categorical | — | 0% | 99501of 3 |
increased_vehicle_covid_modes | categorical | — | 0% | 99510of 3 |
increased_vehicle_covid_needs | categorical | — | 0% | 99501of 3 |
increased_vehicle_area | categorical | — | 0% | 99501of 3 |
increased_vehicle_moved | categorical | — | 0% | 99501of 3 |
increased_vehicle_job | categorical | — | 0% | 9950of 2 |
increased_vehicle_unreliable | categorical | — | 0% | 99501of 3 |
increased_vehicle_flexibility | categorical | — | 0% | 99501of 3 |
increased_vehicle_new_driver | categorical | — | 0% | 99501of 3 |
increased_vehicle_transport | categorical | — | 0% | 99501of 3 |
increased_vehicle_other | categorical | — | 0% | 99501of 3 |
vehicle_no_change | categorical | — | 0% | 32995of 5 |
employment_before | categorical | — | 0% | 162of 6 |
industry_before | integer | — | 0% | 99587 |
telework_before | categorical | — | 0% | 89957of 9 |
employment_status_change | categorical | — | 0% | 213of 3 |
employment | categorical | — | 0% | 165of 7 |
employment_change_new_job | categorical | — | 0% | 99501of 3 |
employment_change_laid_off | categorical | — | 0% | 99501of 3 |
employment_change_left_job | categorical | — | 0% | 99501of 3 |
employment_change_furloughed | categorical | — | 0% | 99501of 3 |
employment_change_furloughed_1 | categorical | — | 0% | 99501of 3 |
employment_change_reduced | categorical | — | 0% | 99501of 3 |
employment_change_increased | categorical | — | 0% | 99501of 3 |
employment_change_pay_cut | categorical | — | 0% | 99501of 3 |
employment_change_pay | categorical | — | 0% | 99501of 3 |
employment_change_pay_1 | categorical | — | 0% | 99501of 3 |
employment_change_none | categorical | — | 0% | 99501of 3 |
industry | categorical | — | 0% | 99587of 19 |
job_type | categorical | — | 0% | 99513of 6 |
work_return | categorical | — | 0% | 99565of 7 |
work_return_barriers_child | categorical | — | 0% | 99501of 3 |
work_return_barriers_vaccine | categorical | — | 0% | 99510of 3 |
work_return_barriers_family | categorical | — | 0% | 99501of 3 |
work_return_barriers_other | categorical | — | 0% | 99501of 3 |
work_return_barriers_none | categorical | — | 0% | 99501of 3 |
work_mode | categorical | — | 0% | 99515of 12 |
commute_subsidy | categorical | — | 0% | 99521of 3 |
work_covid_protocols_hours | categorical | — | 0% | 99501of 3 |
work_covid_protocols_telework | categorical | — | 0% | 99501of 3 |
work_covid_protocols_health | categorical | — | 0% | 99510of 3 |
work_covid_protocols_common | categorical | — | 0% | 99501of 3 |
work_covid_protocols_mask | categorical | — | 0% | 99510of 3 |
work_covid_protocols_other | categorical | — | 0% | 99501of 3 |
work_covid_protocols_dont | categorical | — | 0% | 99501of 3 |
work_covid_protocols_none | categorical | — | 0% | 99501of 3 |
telework_future | categorical | — | 0% | 99564of 9 |
attitude_transit_bus | categorical | — | 0% | 99553of 6 |
attitude_transit_subway | categorical | — | 0% | 99552of 6 |
attitude_transit_future | categorical | — | 0% | 99541of 5 |
attitude_tnc | categorical | — | 0% | 125of 5 |
attitude_shared_tnc | categorical | — | 0% | 543of 5 |
attitude_street_dining | categorical | — | 0% | 123of 5 |
attitude_street_classroom | categorical | — | 0% | 213of 5 |
attitude_street_bike_lanes | categorical | — | 0% | 123of 5 |
attitude_street_bike_parking | categorical | — | 0% | 312of 5 |
attitude_street_bus_lanes | categorical | — | 0% | 123of 5 |
attitude_street_containers | categorical | — | 0% | 132of 5 |
attitude_telework | categorical | — | 0% | 99512of 6 |
attitude_walk | categorical | — | 0% | 123of 5 |
attitude_bike | categorical | — | 0% | 534of 5 |
attitude_drive | categorical | — | 0% | 123of 5 |
attitude_bus | categorical | — | 0% | 354of 5 |
attitude_stay_home | categorical | — | 0% | 123of 5 |
attitude_nyc_surge | categorical | — | 0% | 534of 5 |
attitude_nyc_employment | categorical | — | 0% | 534of 5 |
attitude_nyc_activities | categorical | — | 0% | 543of 5 |
attitude_order | categorical | — | 0% | 123of 5 |
attitude_mask_indoor | categorical | — | 0% | 123of 5 |
attitude_mask_outdoor | categorical | — | 0% | 123of 5 |
changed_home | categorical | — | 0% | 01of 2 |
changed_num_adults | categorical | — | 0% | 01of 2 |
changed_num_children | categorical | — | 0% | 01of 2 |
changed_vehicles | categorical | — | 0% | 01of 2 |
changed_other | categorical | — | 0% | 01of 2 |
changed_none | categorical | — | 0% | 10of 2 |
home_cms_zone | categorical | — | 0% | Northern BronxInner BrooklynStaten Islandof 11 |
residence_type | categorical | — | 0% | 19953of 9 |
move_nyc | categorical | — | 0% | 19982of 4 |
move_elsewhere | categorical | — | 0% | 99512of 3 |
num_people | categorical | — | 0% | 213of 10 |
age_5_under | categorical | — | 0% | 012of 4 |
age_5_12 | categorical | — | 0% | 012of 5 |
age_13_17 | categorical | — | 0% | 012of 4 |
age_18_64 | categorical | — | 0% | 210of 8 |
age_65_over | categorical | — | 0% | 012of 5 |
student | categorical | — | 0% | 897of 4 |
student_location | categorical | — | 0% | 99565of 5 |
school_mode | categorical | — | 0% | 99519of 6 |
school_mode_before | categorical | — | 0% | 995521of 9 |
school_type_cared_at_home | categorical | — | 0% | 99501of 3 |
school_type_daycare | categorical | — | 0% | 99501of 3 |
school_type_preschool | categorical | — | 0% | 99501of 3 |
school_type_elementary | categorical | — | 0% | 99501of 3 |
school_type_middle | categorical | — | 0% | 99501of 3 |
school_type_high | categorical | — | 0% | 99501of 3 |
school_type_home | categorical | — | 0% | 99501of 3 |
school_type_other | categorical | — | 0% | 99501of 3 |
class_structure_elementary | categorical | — | 0% | 99543of 5 |
school_mode_elementary | categorical | — | 0% | 99581of 6 |
class_structure_middle | categorical | — | 0% | 99543of 5 |
school_mode_middle | categorical | — | 0% | 99548of 5 |
class_structure_high | categorical | — | 0% | 99543of 4 |
school_mode_high | categorical | — | 0% | 99514of 5 |
num_vehicles | categorical | — | 0% | 012of 5 |
income | categorical | — | 0% | 524of 7 |
race_american_indian_cms | categorical | — | 0% | 09991of 3 |
race_asian_cms | categorical | — | 0% | 01999of 3 |
race_black_cms | categorical | — | 0% | 01999of 3 |
race_native_hawaiian_cms | categorical | — | 0% | 09991of 3 |
race_white_cms | categorical | — | 0% | 10999of 3 |
race_other_cms | categorical | — | 0% | 09991of 3 |
ethnicity_cms | categorical | — | 0% | 19973of 6 |
age_cms | categorical | — | 0% | 567of 8 |
education_cms | categorical | — | 0% | 673of 9 |
disability_concentrating | categorical | — | 0% | 09991of 3 |
disability_dressing_cms | categorical | — | 0% | 09991of 3 |
disability_hearing_cms | categorical | — | 0% | 09991of 3 |
disability_mobility_cms | categorical | — | 0% | 09991of 3 |
disability_seeing_cms | categorical | — | 0% | 09991of 3 |
disability_walking_cms | categorical | — | 0% | 01999of 3 |
disability_none_cms | categorical | — | 0% | 10999of 3 |
bike_freq_cms | categorical | — | 0% | 541of 7 |
bike_num_days_cms | categorical | — | 0% | 99501of 9 |
bike_purpose_appointment | categorical | — | 0% | 99501of 4 |
bike_purpose_commute_cms | categorical | — | 0% | 99501of 4 |
bike_purpose_errands_cms | categorical | — | 0% | 99501of 4 |
bike_purpose_recreation_cms | categorical | — | 0% | 99510of 4 |
bike_purpose_transit_cms | categorical | — | 0% | 99501of 4 |
bike_purpose_other_cms | categorical | — | 0% | 9950-9998of 4 |
work_mode_cms | categorical | — | 0% | 105995100of 10 |
gender_cms | categorical | — | 0% | 12999of 4 |
weight | float | — | 0% | 586.1099397991911574.504261938982449.84616446606 |