Citywide Mobility Survey - Household 2019

CREATE TABLE table_1 (
  "hh_id" BIGINT,
  "weight" DOUBLE,
  "survey_mode" BIGINT,
  "survey_language" VARCHAR,
  "survey_complete_date" TIMESTAMP,
  "is_complete" BIGINT,
  "num_days_complete" BIGINT,
  "reported_home_cms_zone" VARCHAR,
  "missing_home_location" DOUBLE,
  "first_travel_date" TIMESTAMP,
  "last_travel_date" TIMESTAMP,
  "num_bicycles" BIGINT,
  "bicycle_type_standard" BIGINT,
  "bicycle_type_electric" BIGINT,
  "bicycle_type_other" BIGINT,
  "bicycle_store_house" BIGINT,
  "bicycle_store_rack" BIGINT,
  "bicycle_store_locker" BIGINT,
  "bicycle_store_secured_bike_room" BIGINT,
  "bicycle_store_object" BIGINT,
  "bicycle_store_docking_station" BIGINT,
  "bicycle_store_street" BIGINT,
  "bicycle_store_garage" BIGINT,
  "bicycle_store_other" BIGINT,
  "num_vehicles" BIGINT,
  "vehicle_change" BIGINT,
  "reduced_vehicle_cost" BIGINT,
  "reduced_vehicle_parking" BIGINT,
  "reduced_vehicle_no_need" BIGINT,
  "reduced_vehicle_ridehailing" BIGINT,
  "reduced_vehicle_carshare" BIGINT,
  "reduced_vehicle_transit" BIGINT,
  "reduced_vehicle_nyc_driving" BIGINT,
  "reduced_vehicle_other" BIGINT,
  "increased_vehicle_new_driver" BIGINT,
  "increased_vehicle_transport_hh_member" BIGINT,
  "increased_vehicle_moved" BIGINT,
  "increased_vehicle_job" BIGINT,
  "increased_vehicle_unreliable" BIGINT,
  "increased_vehicle_flexibility" BIGINT,
  "increased_vehicle_other" BIGINT,
  "res_type" BIGINT,
  "rent_own" BIGINT,
  "income_detailed" BIGINT,
  "income_aggregate" BIGINT,
  "num_participants" BIGINT,
  "num_people" BIGINT,
  "num_adults" BIGINT,
  "num_kids" BIGINT,
  "num_workers" BIGINT,
  "num_students" BIGINT,
  "num_trips" BIGINT
);