From a 500-row sample across 183 columns.
school_mode_autoharassment_change_996harassment_change_10+150| hh_id | num_trips | num_days_complete | person_id | person_num | is_participant | phone_type | relationship | age | r_age | race_1 | race_2 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 22000050 | 4 | 5 | 2200005001 | 1 | 1 | 995 | 0 | 6 | 3 | 0 | 0 |
| 22000105 | 61 | 7 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
hh_id | text | — | 0% | 220888152207036622145081 |
num_trips | integer | — | 0% | 023 |
num_days_complete | categorical | — | 0% | 99571of 8 |
person_id | text | — | 0% | 221151310422055239022207356505 |
person_num | categorical | — |
GET /api/datasets/7qdz-u9hr GET /api/datasets/7qdz-u9hr/quality GET /api/datasets/7qdz-u9hr/related GET /api/columns?dataset=7qdz-u9hr
hh_idnum_tripsnum_days_completestudentjob_typebike_freq+5studentjob_typebike_freq+6hh_idstudentjob_typebike_freq+5hh_idperson_numnum_trips+1hh_idperson_numperson_id| 2200010501 |
| 1 |
| 1 |
| 995 |
| 0 |
| 8 |
| 3 |
| 0 |
| 0 |
| 22000128 | 53 | 6 | 2200012801 | 1 | 1 | 995 | 0 | 6 | 3 | 0 | 0 |
| 22000430 | 30 | 7 | 2200043001 | 1 | 1 | 995 | 0 | 5 | 2 | 1 | 0 |
| 22000460 | 9 | 5 | 2200046001 | 1 | 1 | 995 | 0 | 6 | 3 | 1 | 0 |
| 22000533 | 41 | 7 | 2200053301 | 1 | 1 | 995 | 0 | 7 | 3 | 1 | 0 |
| 22000607 | 58 | 7 | 2200060701 | 1 | 1 | 2 | 0 | 8 | 3 | 0 | 0 |
| 22000655 | 34 | 7 | 2200065501 | 1 | 1 | 995 | 0 | 5 | 2 | 1 | 0 |
| 22000768 | 73 | 5 | 2200076801 | 1 | 1 | 995 | 0 | 6 | 3 | 0 | 0 |
| 22000889 | 0 | 1 | 2200088901 | 1 | 1 | 2 | 0 | 5 | 2 | 0 | 0 |
Showing 12 of 183 columns. All of them are listed below.
| 0% |
123of 12 |
is_participant | categorical | — | 0% | 01of 2 |
phone_type | categorical | — | 0% | 99521of 5 |
relationship | categorical | — | 0% | 021of 7 |
age | categorical | — | 0% | 567of 11 |
r_age | categorical | — | 0% | 321of 4 |
race_1 | categorical | — | 0% | 99501of 3 |
race_2 | categorical | — | 0% | 99501of 3 |
race_3 | categorical | — | 0% | 99501of 3 |
race_4 | categorical | — | 0% | 99501of 3 |
race_5 | categorical | — | 0% | 99501of 3 |
race_6 | categorical | — | 0% | 99501of 3 |
race_997 | categorical | — | 0% | 99501of 3 |
race_999 | categorical | — | 0% | 99501of 3 |
r_race | categorical | — | 0% | 99552of 9 |
ethnicity_1 | categorical | — | 0% | 99510of 3 |
ethnicity_2 | categorical | — | 0% | 99501of 3 |
ethnicity_3 | categorical | — | 0% | 99501of 3 |
ethnicity_4 | categorical | — | 0% | 99501of 3 |
ethnicity_5 | categorical | — | 0% | 99501of 3 |
ethnicity_997 | categorical | — | 0% | 99501of 3 |
ethnicity_999 | categorical | — | 0% | 99501of 3 |
r_ethnicity | categorical | — | 0% | 9951999of 9 |
gender | categorical | — | 0% | 99512of 7 |
can_drive | categorical | — | 0% | 13995of 3 |
disability | categorical | — | 0% | 99501of 4 |
disability_follow_1 | categorical | — | 0% | 99501of 3 |
disability_follow_2 | categorical | — | 0% | 99501of 3 |
disability_follow_3 | categorical | — | 0% | 99510of 3 |
disability_follow_4 | categorical | — | 0% | 99501of 3 |
disability_follow_5 | categorical | — | 0% | 99501of 3 |
disability_follow_6 | categorical | — | 0% | 99501of 3 |
disability_follow_996 | categorical | — | 0% | 99501of 3 |
disability_follow_999 | categorical | — | 0% | 99501of 3 |
education | categorical | — | 0% | 99567of 9 |
employment | categorical | — | 0% | 15995of 8 |
worker | categorical | — | 0% | 10995of 3 |
num_jobs | categorical | — | 0% | 19952of 7 |
job_type | categorical | — | 0% | 99515of 6 |
industry | categorical | — | 0% | 99587of 19 |
work_in_region | categorical | — | 0% | 99510of 3 |
work_county | categorical | — | 0% | NA3606136047of 15 |
work_cms_zone | categorical | — | 0% | 99548of 12 |
wfh_policy | categorical | — | 0% | 99513of 8 |
commute_freq | categorical | — | 0% | 99513of 8 |
telework_freq | categorical | — | 0% | 9953996of 8 |
r_telework_freq | categorical | — | 0% | 9959961of 8 |
work_mode | categorical | — | 0% | 995105100of 11 |
r_work_mode | categorical | — | 0% | 995105100of 10 |
work_mode_own | categorical | — | 0% | 99567of 7 |
work_mode_auto | categorical | — | 0% | 9953334of 3 |
work_park_loc | categorical | — | 0% | 99534of 6 |
work_park_pay | categorical | — | 0% | 99515of 7 |
work_park_cost | categorical | — | 0% | 99513of 6 |
work_park_amount | coordinate | — | 0% | NA2.210.04 |
work_mode_taxi | categorical | — | 0% | 9954936of 5 |
work_mode_bus | categorical | — | 0% | 9952355of 5 |
work_mode_rail | categorical | — | 0% | 9953058of 5 |
work_mode_ferry | categorical | — | 0% | 995175176of 4 |
work_mode_bike | categorical | — | 0% | 9952201of 5 |
work_bike_park | categorical | — | 0% | 9959976of 6 |
work_mode_scooter | categorical | — | 0% | 995204of 2 |
work_scooter_park | categorical | — | 0% | 9955997of 3 |
student | categorical | — | 0% | 29950of 6 |
r_student | categorical | — | 0% | 39951of 4 |
school_type | categorical | — | 0% | 99557of 13 |
r_school_type | categorical | — | 0% | 99572of 8 |
school_in_region | categorical | — | 0% | 99510of 3 |
school_county | categorical | — | 0% | NA3606136047of 19 |
school_freq | categorical | — | 0% | 99513of 8 |
remote_class_freq | categorical | — | 0% | 9959963of 8 |
school_mode | categorical | — | 0% | 995105102of 11 |
school_mode_own | categorical | — | 0% | 99567of 3 |
school_mode_auto | categorical | — | 0% | 9953422of 3 |
school_park_loc | categorical | — | 0% | 99543of 6 |
school_park_cost | categorical | — | 0% | 9951998of 6 |
school_park_amount | categorical | — | 0% | NA0101of 11 |
school_mode_taxi | categorical | — | 0% | 9954960of 3 |
school_mode_bus | categorical | — | 0% | 9952355of 4 |
school_mode_rail | categorical | — | 0% | 9953058of 4 |
school_mode_ferry | categorical | — | 0% | 995175of 2 |
school_mode_bike | categorical | — | 0% | 9952201of 4 |
school_bike_park | categorical | — | 0% | 99535of 4 |
school_mode_scooter | text | — | 0% | 995of 1 |
school_scooter_park | text | — | 0% | 995of 1 |
home_park_1 | categorical | — | 0% | 99501of 3 |
home_park_2 | categorical | — | 0% | 99501of 3 |
home_park_3 | categorical | — | 0% | 99501of 3 |
home_park_pay | categorical | — | 0% | 99501of 3 |
home_park_cost | categorical | — | 0% | 9953998of 6 |
home_park_amount | text | — | 0% | NA202151.5 |
second_home | categorical | — | 0% | 01995of 3 |
second_home_freq | categorical | — | 0% | 99521of 8 |
second_home_in_region | categorical | — | 0% | 01of 2 |
second_home_county | text | — | 0% | NA3604736061 |
share_1 | categorical | — | 0% | 99510of 3 |
share_2 | categorical | — | 0% | 99501of 3 |
share_3 | categorical | — | 0% | 99501of 3 |
share_4 | categorical | — | 0% | 99501of 3 |
share_5 | categorical | — | 0% | 99501of 3 |
share_6 | categorical | — | 0% | 99501of 3 |
share_996 | categorical | — | 0% | 99501of 3 |
tnc_freq | categorical | — | 0% | 99565of 7 |
tnc_purp | categorical | — | 0% | 99514of 11 |
carshare_freq | categorical | — | 0% | 99565of 7 |
vehicle | categorical | — | 0% | 99567of 9 |
bike_freq | categorical | — | 0% | 9959966of 8 |
bike_purp_1 | categorical | — | 0% | 99501of 3 |
bike_purp_2 | categorical | — | 0% | 99501of 3 |
bike_purp_3 | categorical | — | 0% | 99510of 3 |
bike_purp_4 | categorical | — | 0% | 99501of 3 |
bike_purp_5 | categorical | — | 0% | 99501of 3 |
bike_purp_6 | categorical | — | 0% | 99501of 3 |
bike_purp_997 | categorical | — | 0% | 99501of 3 |
no_bike_nyc_1 | categorical | — | 0% | 99501of 3 |
no_bike_nyc_2 | categorical | — | 0% | 99501of 3 |
no_bike_nyc_3 | categorical | — | 0% | 99501of 3 |
no_bike_nyc_4 | categorical | — | 0% | 99501of 3 |
no_bike_nyc_5 | categorical | — | 0% | 99501of 3 |
no_bike_nyc_6 | categorical | — | 0% | 99501of 3 |
no_bike_nyc_7 | categorical | — | 0% | 99501of 3 |
no_bike_nyc_9 | categorical | — | 0% | 99501of 3 |
no_bike_nyc_997 | categorical | — | 0% | 99501of 3 |
no_freq_bike_nyc_1 | categorical | — | 0% | 99501of 3 |
no_freq_bike_nyc_2 | categorical | — | 0% | 99501of 3 |
no_freq_bike_nyc_3 | categorical | — | 0% | 99501of 3 |
no_freq_bike_nyc_4 | categorical | — | 0% | 99501of 3 |
no_freq_bike_nyc_5 | categorical | — | 0% | 99501of 3 |
no_freq_bike_nyc_6 | categorical | — | 0% | 99501of 3 |
no_freq_bike_nyc_997 | categorical | — | 0% | 99501of 3 |
no_freq_bike_nyc_other | text | — | 0% | 995of 1 |
bike_stolen | categorical | — | 0% | 99501of 3 |
citi_bike_freq | categorical | — | 0% | 99515of 7 |
citi_bike_type | categorical | — | 0% | 99513of 6 |
citi_bike_pay | categorical | — | 0% | 99512of 9 |
citi_bike_alt_mode | categorical | — | 0% | 9951105of 12 |
no_bike_share_1 | categorical | — | 0% | 99501of 3 |
no_bike_share_2 | categorical | — | 0% | 99501of 3 |
no_bike_share_3 | categorical | — | 0% | 99501of 3 |
no_bike_share_4 | categorical | — | 0% | 99501of 3 |
no_bike_share_5 | categorical | — | 0% | 99501of 3 |
no_bike_share_6 | categorical | — | 0% | 99501of 3 |
no_bike_share_7 | categorical | — | 0% | 99501of 3 |
no_bike_share_8 | categorical | — | 0% | 99501of 3 |
no_bike_share_997 | categorical | — | 0% | 99501of 3 |
micromobility_devices_204 | categorical | — | 0% | 99501of 3 |
micromobility_devices_83 | categorical | — | 0% | 99501of 3 |
micromobility_devices_205 | categorical | — | 0% | 99501of 3 |
micromobility_devices_73 | categorical | — | 0% | 99501of 3 |
micromobility_devices_206 | categorical | — | 0% | 99501of 3 |
micromobility_devices_207 | categorical | — | 0% | 99501of 3 |
micromobility_devices_996 | categorical | — | 0% | 99510of 3 |
kid_accompany | categorical | — | 0% | 99510of 3 |
kid_mode | categorical | — | 0% | 9951100of 11 |
r_kid_mode | categorical | — | 0% | 9951100of 10 |
kid_mode_own | categorical | — | 0% | 99567of 4 |
kid_mode_auto | categorical | — | 0% | 9953422of 3 |
kid_mode_taxi | categorical | — | 0% | 99549of 2 |
kid_mode_bus | categorical | — | 0% | 9952361of 7 |
kid_mode_rail | categorical | — | 0% | 99530of 2 |
kid_mode_ferry | text | — | 0% | 995of 1 |
kid_access | categorical | — | 0% | 99513of 7 |
kid_egress | categorical | — | 0% | 99513of 8 |
kid_mode_bike | categorical | — | 0% | 995282of 3 |
kid_mode_scooter | categorical | — | 0% | 995207204of 3 |
harassment | categorical | — | 0% | 99541of 5 |
harassment_change_1 | categorical | — | 0% | 99501of 3 |
harassment_change_2 | categorical | — | 0% | 99501of 3 |
harassment_change_3 | categorical | — | 0% | 99501of 3 |
harassment_change_4 | categorical | — | 0% | 99501of 3 |
harassment_change_5 | categorical | — | 0% | 99501of 3 |
harassment_change_6 | categorical | — | 0% | 99501of 3 |
harassment_change_7 | categorical | — | 0% | 99501of 3 |
harassment_change_8 | categorical | — | 0% | 99501of 3 |
harassment_change_9 | categorical | — | 0% | 99510of 3 |
harassment_change_10 | categorical | — | 0% | 99501of 3 |
harassment_change_996 | categorical | — | 0% | 99501of 3 |
harassment_change_997 | categorical | — | 0% | 99501of 3 |
person_weight | float | — | 57% | 92171209.02003155.0667696 |