From a 500-row sample across 160 columns.
person_numperson_idhh_id+1last_travel_datefirst_travel_datenum_trips+4cms_zonehh_idweight+1| hh_id | weight | cms_zone | survey_mode | person_id | person_num | is_participant | first_travel_date | last_travel_date | smartphone_type | relationship | age |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 191546322 | 0.00000 | Inner Brooklyn | 1 | 19154632203 | 3 | 0 | 2019-06-24T00:00:00.000 | 2019-06-30T00:00:00.000 | 995 | 5 | 9 |
| 191546322 | 0.00000 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
hh_id | integer | — | 0% | 191757381964486119341750 |
weight | float | — | 0% | 0.00000121.61433222.77000 |
cms_zone | categorical | — | 0% | Northern BronxStaten IslandOuter Queensof 10 |
survey_mode | categorical | — | 0% | 123of 3 |
person_id | integer |
GET /api/datasets/6bqn-qdwq GET /api/datasets/6bqn-qdwq/quality GET /api/datasets/6bqn-qdwq/related GET /api/columns?dataset=6bqn-qdwq
person_numperson_idhh_idperson_numperson_idhh_id| Inner Brooklyn |
| 1 |
| 19154632202 |
| 2 |
| 0 |
| 2019-06-24T00:00:00.000 |
| 2019-06-30T00:00:00.000 |
| 995 |
| 5 |
| 8 |
| 191546322 | 212.12729 | Inner Brooklyn | 1 | 19154632201 | 1 | 1 | 2019-06-24T00:00:00.000 | 2019-06-30T00:00:00.000 | 1 | 0 | 5 |
| 19241657 | 0.00000 | Middle Queens | 1 | 1924165703 | 3 | 0 | 2019-05-29T00:00:00.000 | 2019-06-04T00:00:00.000 | 995 | 3 | 8 |
| 19241657 | 0.00000 | Middle Queens | 1 | 1924165702 | 2 | 0 | 2019-05-29T00:00:00.000 | 2019-06-04T00:00:00.000 | 995 | 3 | 7 |
| 19241657 | 1262.69496 | Middle Queens | 1 | 1924165701 | 1 | 1 | 2019-05-29T00:00:00.000 | 2019-06-04T00:00:00.000 | 2 | 0 | 5 |
| 19933569 | 92.92534 | Middle Queens | 1 | 1993356901 | 1 | 1 | 2019-06-06T00:00:00.000 | 2019-06-12T00:00:00.000 | 2 | 0 | 7 |
| 19817299 | 0.00000 | Middle Queens | 1 | 1981729904 | 4 | 0 | 2019-06-16T00:00:00.000 | 2019-06-22T00:00:00.000 | 995 | 4 | 5 |
| 19817299 | 0.00000 | Middle Queens | 1 | 1981729903 | 3 | 0 | 2019-06-16T00:00:00.000 | 2019-06-22T00:00:00.000 | 995 | 3 | 9 |
| 19817299 | 0.00000 | Middle Queens | 1 | 1981729902 | 2 | 0 | 2019-06-16T00:00:00.000 | 2019-06-22T00:00:00.000 | 995 | 1 | 5 |
Showing 12 of 155 columns. All of them are listed below.
| — |
| 0% |
199502440319115699011913862901 |
person_num | categorical | — | 0% | 123of 11 |
is_participant | categorical | — | 0% | 01of 2 |
num_days | categorical | — | 60% | 71of 2 |
num_days_complete | categorical | — | 60% | 716of 7 |
num_trips | integer | — | 60% | 023 |
num_walk_trips | integer | — | 60% | 021 |
num_transit_trips | integer | — | 60% | 021 |
num_bike_trips | integer | — | 60% | 021 |
num_taxi_trips | categorical | — | 60% | 012of 11 |
num_tnc_trips | categorical | — | 60% | 012of 14 |
num_complete_weekend_days | categorical | — | 60% | 201of 3 |
num_complete_weekdays | categorical | — | 60% | 514of 6 |
first_travel_date | datetime | — | 0% | 2019-06-07T00:00:00.0002019-06-01T00:00:00.0002019-06-08T00:00:00.000 |
last_travel_date | datetime | — | 0% | 2019-06-13T00:00:00.0002019-06-07T00:00:00.0002019-06-14T00:00:00.000 |
made_trips | categorical | — | 60% | 10of 2 |
smartphone_type | categorical | — | 0% | 99521of 5 |
relationship | categorical | — | 0% | 021of 10 |
age | categorical | — | 0% | 567of 11 |
employment | categorical | — | 0% | 16995of 6 |
worker | categorical | — | 0% | 10995of 3 |
student | categorical | — | 0% | 012of 3 |
license | categorical | — | 0% | 99510of 4 |
vehicle | categorical | — | 0% | 9951996of 10 |
congestion | categorical | — | 0% | 99542of 7 |
drive_cbd_freq | categorical | — | 0% | 99578of 10 |
planning_apps | categorical | — | 0% | 99514of 10 |
job_type | categorical | — | 0% | 99512of 6 |
jobs_count | categorical | — | 0% | 99512of 8 |
industry | integer | — | 0% | 99587 |
telework_freq | categorical | — | 0% | 99587of 9 |
work_cms_zone | categorical | — | 80% | Manhattan CoreInner BrooklynSouthern Bronxof 12 |
missing_work_location | categorical | — | 0% | 01of 2 |
work_mode | categorical | — | 0% | 995105100of 10 |
work_mode_own | categorical | — | 0% | 99567of 5 |
work_park_location | categorical | — | 0% | 99534of 6 |
work_park_pay | categorical | — | 0% | 99515of 7 |
work_vehicle_pass_period | categorical | — | 0% | 99513of 6 |
work_park_amount_day | categorical | — | 100% | 8520of 11 |
work_park_amount_week | categorical | — | 100% | 310100of 10 |
work_park_amount_month | categorical | — | 100% | 15063190of 16 |
work_park_amount_year | categorical | — | 100% | 1000130260of 4 |
work_mode_auto | categorical | — | 0% | 9953322of 6 |
work_mode_bus | categorical | — | 0% | 9952355of 8 |
work_mode_rail | categorical | — | 0% | 9953058of 6 |
work_mode_ferry | categorical | — | 0% | 995111112of 3 |
work_mode_taxi | categorical | — | 0% | 9954960of 6 |
work_mode_bike | categorical | — | 0% | 995279of 5 |
work_bike_park | categorical | — | 0% | 99564of 8 |
work_mode_scooter | integer | — | 0% | 995of 1 |
work_scooter_park | integer | — | 0% | 995of 1 |
school_type | categorical | — | 0% | 995-99985of 14 |
school_cms_zone | categorical | — | 99% | Manhattan CoreNorthern BronxInner Queensof 10 |
missing_school_location | categorical | — | 0% | 01of 2 |
kid_accompany | categorical | — | 0% | 99510of 3 |
school_mode | categorical | — | 0% | 995-99981of 12 |
school_mode_own | categorical | — | 0% | 99567of 5 |
school_park_location | categorical | — | 0% | 99546of 4 |
school_vehicle_pass_period | categorical | — | 0% | 99551of 7 |
school_park_amount_day | categorical | — | 100% | 0.251015of 7 |
school_park_amount_month | categorical | — | 100% | 0.251516of 8 |
school_park_amount_week | categorical | — | 100% | 4150.25of 5 |
school_park_amount_year | categorical | — | 100% | 250415of 8 |
school_mode_auto | categorical | — | 0% | 9952234of 7 |
school_mode_bus | categorical | — | 0% | 9952324of 9 |
school_mode_rail | categorical | — | 0% | 9953058of 6 |
school_mode_ferry | categorical | — | 0% | 995111of 2 |
school_access | categorical | — | 0% | 9951997of 8 |
school_egress | categorical | — | 0% | 9951997of 7 |
school_mode_taxi | categorical | — | 0% | 9953749of 5 |
school_mode_bike | categorical | — | 0% | 995279of 3 |
school_bike_park | categorical | — | 0% | 99524of 4 |
school_mode_scooter | integer | — | 0% | 995of 1 |
school_scooter_park | integer | — | 0% | 995of 1 |
bike_freq | categorical | — | 0% | 99554of 8 |
bike_num_days | categorical | — | 0% | 99501of 9 |
bike_stolen | categorical | — | 0% | 9950-9998of 4 |
bike_purpose_errands | categorical | — | 0% | 99501of 4 |
bike_purpose_transit | categorical | — | 0% | 9950-9998of 4 |
bike_purpose_recreation | categorical | — | 0% | 9951-9998of 4 |
bike_purpose_commute | categorical | — | 0% | 99501of 4 |
bike_purpose_appointment | categorical | — | 0% | 9950-9998of 4 |
bike_purpose_other | categorical | — | 0% | 9950-9998of 4 |
no_bike_nyc_bike_lanes | categorical | — | 0% | 99501of 3 |
no_bike_nyc_paving | categorical | — | 0% | 99501of 3 |
no_bike_nyc_storage | categorical | — | 0% | 99501of 3 |
no_bike_nyc_long_trips | categorical | — | 0% | 99501of 3 |
no_bike_nyc_showers | categorical | — | 0% | 99501of 3 |
no_bike_nyc_modes | categorical | — | 0% | 99501of 3 |
no_bike_nyc_unable | categorical | — | 0% | 99501of 3 |
no_bike_nyc_other | categorical | — | 0% | 99501of 3 |
bike_share_citi_bike | categorical | — | 0% | 99501of 4 |
bike_share_jump | categorical | — | 0% | 9950-9998of 4 |
bike_share_lime | categorical | — | 0% | 9950-9998of 4 |
bike_share_none | categorical | — | 0% | 99510of 4 |
bike_share_user | categorical | — | 0% | 99501of 4 |
citi_bike_freq | categorical | — | 0% | 99578of 9 |
jump_freq | categorical | — | 0% | 99574of 7 |
lime_freq | categorical | — | 0% | 99576of 6 |
no_bike_share_unfamiliar | categorical | — | 0% | 9950-9998of 4 |
no_bike_share_expensive | categorical | — | 0% | 9950-9998of 4 |
no_bike_share_neighborhood | categorical | — | 0% | 99501of 4 |
no_bike_share_stations | categorical | — | 0% | 9950-9998of 4 |
no_bike_share_personal_bike | categorical | — | 0% | 9950-9998of 4 |
no_bike_share_docks | categorical | — | 0% | 9950-9998of 4 |
no_bike_share_uncomfortable | categorical | — | 0% | 99501of 4 |
no_bike_share_other | categorical | — | 0% | 9950-9998of 4 |
tnc_use_uber | categorical | — | 0% | 99510of 4 |
tnc_use_lyft | categorical | — | 0% | 99501of 4 |
tnc_use_via | categorical | — | 0% | 99501of 4 |
tnc_use_juno | categorical | — | 0% | 99501of 4 |
tnc_use_none | categorical | — | 0% | 99501of 4 |
tnc_user | categorical | — | 0% | 99510of 4 |
tnc_freq | categorical | — | 0% | 99576of 9 |
tnc_purpose | categorical | — | 0% | 99517of 11 |
tnc_mode | categorical | — | 0% | 995106105of 11 |
tnc_mode_auto | categorical | — | 0% | 9952234of 7 |
tnc_mode_taxi | categorical | — | 0% | 9953660of 4 |
tnc_mode_bus | categorical | — | 0% | 9952355of 7 |
tnc_mode_rail | categorical | — | 0% | 9953058of 6 |
tnc_mode_ferry | categorical | — | 0% | 995111112of 3 |
tnc_mode_bike | categorical | — | 0% | 995283of 4 |
tnc_mode_scooter | categorical | — | 0% | 9957377of 3 |
car_share_zipcar | categorical | — | 0% | 99501of 4 |
car_share_car2go | categorical | — | 0% | 9950-9998of 4 |
car_share_enterprise | categorical | — | 0% | 9950-9998of 4 |
car_share_other | categorical | — | 0% | 99501of 4 |
car_share_none | categorical | — | 0% | 99510of 4 |
car_share_user | categorical | — | 0% | 99501of 4 |
packages | categorical | — | 0% | 99521of 10 |
packages_distance | categorical | — | 0% | 99532of 7 |
harassment | categorical | — | 0% | 99541of 6 |
harassment_trip | categorical | — | 0% | 9950-9998of 4 |
harassment_time | categorical | — | 0% | 9950-9998of 4 |
harassment_route | categorical | — | 0% | 9950-9998of 4 |
harassment_transit | categorical | — | 0% | 9950-9998of 4 |
harassment_mode | categorical | — | 0% | 9950-9998of 4 |
harassment_neighborhood | categorical | — | 0% | 9950-9998of 4 |
harassment_private_car | categorical | — | 0% | 9950-9998of 4 |
harassment_alone | categorical | — | 0% | 9950-9998of 4 |
harassment_attention | categorical | — | 0% | 99510of 4 |
harassment_defense | categorical | — | 0% | 9950-9998of 4 |
harassment_other | categorical | — | 0% | 9950-9998of 4 |
harassment_none | categorical | — | 0% | 9950-9998of 4 |
gender | categorical | — | 0% | 99512of 6 |
education | categorical | — | 0% | 99567of 10 |
english_proficiency | categorical | — | 0% | 99512of 6 |
ethnicity | categorical | — | 0% | 9951997of 7 |
race_american_indian | categorical | — | 0% | 9950999of 4 |
race_asian | categorical | — | 0% | 99501of 4 |
race_black | categorical | — | 0% | 99501of 4 |
race_native_hawaiian | categorical | — | 0% | 9950999of 4 |
race_white | categorical | — | 0% | 99510of 4 |
race_other | categorical | — | 0% | 9950999of 4 |
disability_hearing | categorical | — | 0% | 9950999of 4 |
disability_seeing | categorical | — | 0% | 9950999of 4 |
disability_walking | categorical | — | 0% | 99501of 4 |
disability_mobility | categorical | — | 0% | 9950999of 4 |
disability_dressing | categorical | — | 0% | 9950999of 4 |
disability_concentrating | categorical | — | 0% | 9950999of 4 |
disability_none | categorical | — | 0% | 99510of 4 |