About this Dataset

Citywide Mobility Survey - Person 2022

Citywide Mobility Survey (CMS) Person table contains characteristics of individual members of the participant’s household, including age, race, gender, disability status, education, employment, remote work, typical commute mode, biking frequency, shared services, and other demographic and transportation-related information.
Organization: City of New York
Last updated: 2024-05-03T18:37:35.721714
Tags: 2022, city, citywidemobilitysurvey, mobility, new-york, survey, travel, zones

Tables

Table 1

@usgov.city_of_new_york_citywide_mobility_survey_person_2022.table_1

372.78 kB
6,886 rows
183 columns

CREATE TABLE table_1 (
  "hh_id" BIGINT,
  "num_trips" BIGINT,
  "num_days_complete" BIGINT,
  "person_id" BIGINT,
  "person_num" BIGINT,
  "is_participant" BIGINT,
  "phone_type" BIGINT,
  "relationship" BIGINT,
  "age" BIGINT,
  "r_age" BIGINT,
  "race_1" BIGINT,
  "race_2" BIGINT,
  "race_3" BIGINT,
  "race_4" BIGINT,
  "race_5" BIGINT,
  "race_6" BIGINT,
  "race_997" BIGINT,
  "race_999" BIGINT,
  "r_race" BIGINT,
  "ethnicity_1" BIGINT,
  "ethnicity_2" BIGINT,
  "ethnicity_3" BIGINT,
  "ethnicity_4" BIGINT,
  "ethnicity_5" BIGINT,
  "ethnicity_997" BIGINT,
  "ethnicity_999" BIGINT,
  "r_ethnicity" BIGINT,
  "gender" BIGINT,
  "can_drive" BIGINT,
  "disability" BIGINT,
  "disability_follow_1" BIGINT,
  "disability_follow_2" BIGINT,
  "disability_follow_3" BIGINT,
  "disability_follow_4" BIGINT,
  "disability_follow_5" BIGINT,
  "disability_follow_6" BIGINT,
  "disability_follow_996" BIGINT,
  "disability_follow_999" BIGINT,
  "education" BIGINT,
  "employment" BIGINT,
  "worker" BIGINT,
  "num_jobs" BIGINT,
  "job_type" BIGINT,
  "industry" BIGINT,
  "work_in_region" BIGINT,
  "work_county" VARCHAR,
  "work_cms_zone" BIGINT,
  "wfh_policy" BIGINT,
  "commute_freq" BIGINT,
  "telework_freq" BIGINT,
  "r_telework_freq" BIGINT,
  "work_mode" BIGINT,
  "r_work_mode" BIGINT,
  "work_mode_own" BIGINT,
  "work_mode_auto" BIGINT,
  "work_park_loc" BIGINT,
  "work_park_pay" BIGINT,
  "work_park_cost" BIGINT,
  "work_park_amount" VARCHAR,
  "work_mode_taxi" BIGINT,
  "work_mode_bus" BIGINT,
  "work_mode_rail" BIGINT,
  "work_mode_ferry" BIGINT,
  "work_mode_bike" BIGINT,
  "work_bike_park" BIGINT,
  "work_mode_scooter" BIGINT,
  "work_scooter_park" BIGINT,
  "student" BIGINT,
  "r_student" BIGINT,
  "school_type" BIGINT,
  "r_school_type" BIGINT,
  "school_in_region" BIGINT,
  "school_county" VARCHAR,
  "school_freq" BIGINT,
  "remote_class_freq" BIGINT,
  "school_mode" BIGINT,
  "school_mode_own" BIGINT,
  "school_mode_auto" BIGINT,
  "school_park_loc" BIGINT,
  "school_park_cost" BIGINT,
  "school_park_amount" VARCHAR,
  "school_mode_taxi" BIGINT,
  "school_mode_bus" BIGINT,
  "school_mode_rail" BIGINT,
  "school_mode_ferry" BIGINT,
  "school_mode_bike" BIGINT,
  "school_bike_park" BIGINT,
  "school_mode_scooter" BIGINT,
  "school_scooter_park" BIGINT,
  "home_park_1" BIGINT,
  "home_park_2" BIGINT,
  "home_park_3" BIGINT,
  "home_park_pay" BIGINT,
  "home_park_cost" BIGINT,
  "home_park_amount" VARCHAR,
  "second_home" BIGINT,
  "second_home_freq" BIGINT,
  "second_home_in_region" BIGINT,
  "second_home_county" VARCHAR,
  "share_1" BIGINT
);