California Residents' ZEV Attitudes
Drivers' Preferences, Experiences, and Environmental Concerns
@kaggle.thedevastator_california_residents_zev_attitudes
Drivers' Preferences, Experiences, and Environmental Concerns
@kaggle.thedevastator_california_residents_zev_attitudes
CREATE TABLE ca_zev_survey_12_07_20 (
"response_id" BIGINT,
"no_trucks_plus_incentives_drivetrain_design_1" VARCHAR,
"no_trucks_plus_incentives_drivetrain_design_2" VARCHAR,
"no_trucks_plus_incentives_drivetrain_design_3" VARCHAR,
"no_trucks_plus_incentives_drivetrain_design_4" VARCHAR,
"no_trucks_plus_incentives_drivetrain_design" VARCHAR,
"respondent_education" VARCHAR,
"rrespondent_education" VARCHAR,
"respondent_gender" VARCHAR,
"respondent_sex" VARCHAR,
"gender_2" VARCHAR,
"income_2" VARCHAR,
"rincome" VARCHAR,
"veh_1_total_price" DOUBLE,
"veh_1_total_price_don_t_know" DOUBLE,
"fuel_economy_gasoline_diesel_ethanol" DOUBLE,
"fuel_economy_gasoline_diesel_ethanol_truncated" DOUBLE,
"fuel_economy_gasoline_diesel_ethanol_no_idea" DOUBLE,
"distance" DOUBLE,
"distance_week_month" VARCHAR,
"respondent_s_vehicle_s_monthly_miles" DOUBLE,
"respondent_s_vehicle_s_monthly_miles_truncated" DOUBLE,
"fuel_spending" DOUBLE,
"fuel_spending_week_month" VARCHAR,
"respondent_s_car_fuel_spending_per_month" DOUBLE,
"respondent_s_car_fuel_spending_per_month_trunc" DOUBLE,
"daily_flexibility" VARCHAR,
"commute" VARCHAR,
"home_park_own_car" VARCHAR,
"home_park_other_car" VARCHAR,
"garage_or_carport" VARCHAR,
"home_park_110" VARCHAR,
"home_park_220" VARCHAR,
"home_park_evse" VARCHAR,
"home_park_none" VARCHAR,
"home_park_don_t_know" VARCHAR,
"highest_home_pev_charging_access" VARCHAR,
"electricy_install_authority" VARCHAR,
"home_natural_gas" VARCHAR,
"should_government_offer_incentives" VARCHAR,
"replacement_electricity" VARCHAR,
"replacement_hydrogen" VARCHAR,
"seen_public_evses" VARCHAR,
"seen_public_evses_yes_no" VARCHAR,
"personal_interest_in_zev_tech" VARCHAR,
"consider_an_ev" VARCHAR,
"rconsiderev" VARCHAR,
"consider_an_fcv" VARCHAR,
"rconsiderfcv" VARCHAR,
"incentives_federal" VARCHAR,
"base_body_size" VARCHAR,
"base_body_size_2" VARCHAR,
"familiarity_gasoline_vehicles" DOUBLE,
"familiarity_evs" DOUBLE,
"familiarity_hevs" DOUBLE,
"familiarity_phevs" DOUBLE,
"familiarity_fcvs" DOUBLE,
"familiarity_gasoline_vehicles_trunc" DOUBLE,
"familiarity_evs_trunc" DOUBLE,
"familiarity_hevs_trunc" DOUBLE,
"familiarity_phevs_trunc" DOUBLE,
"familiarity_fcvs_trunc" DOUBLE,
"driving_exp_ev" DOUBLE,
"driving_exp_hev" DOUBLE,
"driving_exp_phev" DOUBLE,
"driving_exp_fcv" DOUBLE,
"driving_exp_ev_trunc" DOUBLE,
"driving_exp_hev_trunc" DOUBLE,
"driving_exp_phev_trunc" DOUBLE,
"driving_exp_fcv_trunc" DOUBLE,
"ev_home_charge" DOUBLE,
"ev_public_charging" DOUBLE,
"ev_charge_time" DOUBLE,
"ev_range" DOUBLE,
"ev_purchase_price" DOUBLE,
"ev_safety" DOUBLE,
"ev_reliability" DOUBLE,
"ev_home_charge_trunc" DOUBLE,
"ev_public_charging_trunc" DOUBLE,
"ev_charge_time_trunc" DOUBLE,
"ev_range_trunc" DOUBLE,
"ev_purchase_price_trunc" DOUBLE,
"ev_safety_trunc" DOUBLE,
"ev_reliability_trunc" DOUBLE,
"fcv_public_refueling" DOUBLE,
"fcv_fueling_time" DOUBLE,
"fcv_range" DOUBLE,
"fcv_purchase_price" DOUBLE,
"fcv_safety" DOUBLE,
"fcv_reliability" DOUBLE,
"fcv_public_refueling_trunc" DOUBLE,
"fcv_fueling_time_trunc" DOUBLE,
"fcv_range_trunc" DOUBLE,
"fcv_purchase_price_trunc" DOUBLE,
"fcv_safety_trunc" DOUBLE,
"fcv_reliabilty_trunc" DOUBLE,
"environmental_risk" DOUBLE,
"environmental_risk_trunc" DOUBLE,
"health_risk" DOUBLE,
"health_risk_trunc" DOUBLE
);
CREATE TABLE de_zev_survey_12_07_20 (
"response_id" BIGINT,
"no_trucks_plus_incentives_drivetrain_design_1" VARCHAR,
"no_trucks_plus_incentives_drivetrain_design_2" VARCHAR,
"no_trucks_plus_incentives_drivetrain_design_3" VARCHAR,
"no_trucks_plus_incentives_drivetrain_design_4" VARCHAR,
"no_trucks_plus_incentives_drivetrain_design" VARCHAR,
"respondent_education" VARCHAR,
"respondent_gender" VARCHAR,
"respondent_sex" VARCHAR,
"income_2" VARCHAR,
"veh_1_total_price" DOUBLE,
"veh_1_total_price_don_t_know" BIGINT,
"fuel_economy_gasoline_diesel_ethanol" DOUBLE,
"fuel_economy_gasoline_diesel_ethanol_truncated" DOUBLE,
"fuel_economy_gasoline_diesel_ethanol_no_idea" DOUBLE,
"distance" DOUBLE,
"distance_week_month" VARCHAR,
"respondent_s_vehicle_s_monthly_miles" DOUBLE,
"respondent_s_vehicle_s_monthly_miles_truncated" DOUBLE,
"fuel_spending" DOUBLE,
"fuel_spending_week_month" VARCHAR,
"respondent_s_car_fuel_spending_per_month" DOUBLE,
"respondent_s_car_fuel_spending_per_month_trunc" DOUBLE,
"daily_flexibility" VARCHAR,
"commute" VARCHAR,
"home_park_own_car" VARCHAR,
"home_park_other_car" VARCHAR,
"garage_or_carport" VARCHAR,
"home_park_110" VARCHAR,
"home_park_220" VARCHAR,
"home_park_evse" VARCHAR,
"home_park_none" VARCHAR,
"home_park_don_t_know" VARCHAR,
"highest_home_pev_charging_access" VARCHAR,
"electric_parking" VARCHAR,
"electricy_install_authority" VARCHAR,
"home_natural_gas" VARCHAR,
"should_government_offer_incentives" VARCHAR,
"should_government_offer_incentives_y_n" VARCHAR,
"replacement_electricity" VARCHAR,
"replacement_hydrogen" VARCHAR,
"seen_public_evses" VARCHAR,
"seen_public_evses_yes_no" VARCHAR,
"personal_interest_in_zev_tech" VARCHAR,
"consider_an_ev" VARCHAR,
"consider_an_ev_y_n" VARCHAR,
"consider_an_fcv" VARCHAR,
"rconsiderfcv" VARCHAR,
"incentives_federal" VARCHAR,
"base_body_size" VARCHAR,
"base_body_size_2" VARCHAR,
"familiarity_gasoline_vehicles" DOUBLE,
"familiarity_evs" DOUBLE,
"familiarity_hevs" DOUBLE,
"familiarity_phevs" DOUBLE,
"familiarity_fcvs" DOUBLE,
"familiarity_gasoline_vehicles_trunc" DOUBLE,
"familiarity_evs_trunc" DOUBLE,
"familiarity_hevs_trunc" DOUBLE,
"familiarity_phevs_trunc" DOUBLE,
"familiarity_fcvs_trunc" DOUBLE,
"driving_exp_ev" DOUBLE,
"driving_exp_hev" DOUBLE,
"driving_exp_phev" DOUBLE,
"driving_exp_fcv" DOUBLE,
"driving_exp_ev_trunc" DOUBLE,
"driving_exp_hev_trunc" DOUBLE,
"driving_exp_phev_trunc" DOUBLE,
"driving_exp_fcv_trunc" DOUBLE,
"ev_home_charge" DOUBLE,
"ev_public_charging" DOUBLE,
"ev_charge_time" DOUBLE,
"ev_range" DOUBLE,
"ev_purchase_price" DOUBLE,
"ev_safety" DOUBLE,
"ev_reliability" DOUBLE,
"ev_home_charge_trunc" DOUBLE,
"ev_public_charging_trunc" DOUBLE,
"ev_charge_time_trunc" DOUBLE,
"ev_range_trunc" DOUBLE,
"ev_purchase_price_trunc" DOUBLE,
"ev_safety_trunc" DOUBLE,
"ev_reliability_trunc" DOUBLE,
"fcv_public_refueling" DOUBLE,
"fcv_fueling_time" DOUBLE,
"fcv_range" DOUBLE,
"fcv_purchase_price" DOUBLE,
"fcv_safety" DOUBLE,
"fcv_reliability" DOUBLE,
"fcv_public_refueling_trunc" DOUBLE,
"fcv_fueling_time_trunc" DOUBLE,
"fcv_range_trunc" DOUBLE,
"fcv_purchase_price_trunc" DOUBLE,
"fcv_safety_trunc" DOUBLE,
"fcv_reliabilty_trunc" DOUBLE,
"environmental_risk" DOUBLE,
"environmental_risk_trunc" DOUBLE,
"health_risk" DOUBLE,
"health_risk_trunc" DOUBLE,
"urgent_national_need" DOUBLE
);
CREATE TABLE ma_zev_survey_12_07_20 (
"response_id" BIGINT,
"no_trucks_plus_incentives_drivetrain_design_1" VARCHAR,
"no_trucks_plus_incentives_drivetrain_design_2" VARCHAR,
"no_trucks_plus_incentives_drivetrain_design_3" VARCHAR,
"no_trucks_plus_incentives_drivetrain_design_4" VARCHAR,
"no_trucks_plus_incentives_drivetrain_design" VARCHAR,
"respondent_education" VARCHAR,
"rrespondent_education" VARCHAR,
"respondent_gender" VARCHAR,
"respondent_sex" VARCHAR,
"income_2" VARCHAR,
"veh_1_total_price" DOUBLE,
"veh_1_total_price_don_t_know" DOUBLE,
"fuel_economy_gasoline_diesel_ethanol" DOUBLE,
"fuel_economy_gasoline_diesel_ethanol_truncated" DOUBLE,
"fuel_economy_gasoline_diesel_ethanol_no_idea" DOUBLE,
"distance" DOUBLE,
"distance_week_month" VARCHAR,
"respondent_s_vehicle_s_monthly_miles" DOUBLE,
"respondent_s_vehicle_s_monthly_miles_truncated" DOUBLE,
"fuel_spending" DOUBLE,
"fuel_spending_week_month" VARCHAR,
"respondent_s_car_fuel_spending_per_month" DOUBLE,
"respondent_s_car_fuel_spending_per_month_trunc" DOUBLE,
"daily_flexibility" VARCHAR,
"commute" VARCHAR,
"home_park_own_car" VARCHAR,
"home_park_other_car" VARCHAR,
"garage_or_carport" VARCHAR,
"home_park_110" VARCHAR,
"home_park_220" VARCHAR,
"home_park_evse" VARCHAR,
"home_park_none" VARCHAR,
"home_park_don_t_know" VARCHAR,
"highest_home_pev_charging_access" VARCHAR,
"electricy_install_authority" VARCHAR,
"home_natural_gas" VARCHAR,
"should_government_offer_incentives" VARCHAR,
"replacement_electricity" VARCHAR,
"replacement_hydrogen" VARCHAR,
"seen_public_evses" VARCHAR,
"seen_public_evses_yes_no" VARCHAR,
"personal_interest_in_zev_tech" VARCHAR,
"consider_an_ev" VARCHAR,
"rconsider_pev" VARCHAR,
"consider_an_fcv" VARCHAR,
"rconsider_fcv" VARCHAR,
"incentives_federal" VARCHAR,
"base_body_size" VARCHAR,
"base_body_size_2" VARCHAR,
"familiarity_gasoline_vehicles" DOUBLE,
"familiarity_evs" DOUBLE,
"familiarity_hevs" DOUBLE,
"familiarity_phevs" DOUBLE,
"familiarity_fcvs" DOUBLE,
"familiarity_gasoline_vehicles_trunc" DOUBLE,
"familiarity_evs_trunc" DOUBLE,
"familiarity_hevs_trunc" DOUBLE,
"familiarity_phevs_trunc" DOUBLE,
"familiarity_fcvs_trunc" DOUBLE,
"driving_exp_ev" DOUBLE,
"driving_exp_hev" DOUBLE,
"driving_exp_phev" DOUBLE,
"driving_exp_fcv" DOUBLE,
"driving_exp_ev_trunc" DOUBLE,
"driving_exp_hev_trunc" DOUBLE,
"driving_exp_phev_trunc" DOUBLE,
"driving_exp_fcv_trunc" DOUBLE,
"ev_home_charge" DOUBLE,
"ev_public_charging" DOUBLE,
"ev_charge_time" DOUBLE,
"ev_range" DOUBLE,
"ev_purchase_price" DOUBLE,
"ev_safety" DOUBLE,
"ev_reliability" DOUBLE,
"ev_home_charge_trunc" DOUBLE,
"ev_public_charging_trunc" DOUBLE,
"ev_charge_time_trunc" DOUBLE,
"ev_range_trunc" DOUBLE,
"ev_purchase_price_trunc" DOUBLE,
"ev_safety_trunc" DOUBLE,
"ev_reliability_trunc" DOUBLE,
"fcv_public_refueling" DOUBLE,
"fcv_fueling_time" DOUBLE,
"fcv_range" DOUBLE,
"fcv_purchase_price" DOUBLE,
"fcv_safety" DOUBLE,
"fcv_reliability" DOUBLE,
"fcv_public_refueling_trunc" DOUBLE,
"fcv_fueling_time_trunc" DOUBLE,
"fcv_range_trunc" DOUBLE,
"fcv_purchase_price_trunc" DOUBLE,
"fcv_safety_trunc" DOUBLE,
"fcv_reliabilty_trunc" DOUBLE,
"environmental_risk" DOUBLE,
"environmental_risk_trunc" DOUBLE,
"health_risk" DOUBLE,
"health_risk_trunc" DOUBLE,
"urgent_national_need" DOUBLE,
"urgent_national_need_trunc" DOUBLE
);
CREATE TABLE md_zev_survey_12_07_20 (
"response_id" BIGINT,
"no_trucks_plus_incentives_drivetrain_design_1" VARCHAR,
"no_trucks_plus_incentives_drivetrain_design_2" VARCHAR,
"no_trucks_plus_incentives_drivetrain_design_3" VARCHAR,
"no_trucks_plus_incentives_drivetrain_design_4" VARCHAR,
"no_trucks_plus_incentives_drivetrain_design" VARCHAR,
"respondent_education" VARCHAR,
"respondent_education_2" VARCHAR,
"respondent_gender" VARCHAR,
"respondent_sex" VARCHAR,
"income_2" VARCHAR,
"veh_1_total_price" DOUBLE,
"veh_1_total_price_don_t_know" BIGINT,
"fuel_economy_gasoline_diesel_ethanol" DOUBLE,
"fuel_economy_gasoline_diesel_ethanol_truncated" DOUBLE,
"fuel_economy_gasoline_diesel_ethanol_no_idea" DOUBLE,
"distance" DOUBLE,
"distance_week_month" VARCHAR,
"respondent_s_vehicle_s_monthly_miles" DOUBLE,
"respondent_s_vehicle_s_monthly_miles_truncated" DOUBLE,
"fuel_spending" DOUBLE,
"fuel_spending_week_month" VARCHAR,
"respondent_s_car_fuel_spending_per_month" DOUBLE,
"respondent_s_car_fuel_spending_per_month_trunc" DOUBLE,
"daily_flexibility" VARCHAR,
"commute" VARCHAR,
"home_park_own_car" VARCHAR,
"home_park_other_car" VARCHAR,
"garage_or_carport" VARCHAR,
"home_park_110" VARCHAR,
"home_park_220" VARCHAR,
"home_park_evse" VARCHAR,
"home_park_none" VARCHAR,
"home_park_don_t_know" VARCHAR,
"highest_home_pev_charging_access" VARCHAR,
"electricy_install_authority" VARCHAR,
"home_natural_gas" VARCHAR,
"should_government_offer_incentives" VARCHAR,
"replacement_electricity" VARCHAR,
"replacement_hydrogen" VARCHAR,
"seen_public_evses" VARCHAR,
"seen_public_evses_yes_no" VARCHAR,
"personal_interest_in_zev_tech" VARCHAR,
"consider_an_ev" VARCHAR,
"consider_an_fcv" VARCHAR,
"consider_an_ev_2" VARCHAR,
"consider_an_fcv_2" VARCHAR,
"incentives_federal" VARCHAR,
"base_body_size" VARCHAR,
"base_body_size_2" VARCHAR,
"familiarity_gasoline_vehicles" DOUBLE,
"familiarity_evs" DOUBLE,
"familiarity_hevs" DOUBLE,
"familiarity_phevs" DOUBLE,
"familiarity_fcvs" DOUBLE,
"familiarity_gasoline_vehicles_trunc" DOUBLE,
"familiarity_evs_trunc" DOUBLE,
"familiarity_hevs_trunc" DOUBLE,
"familiarity_phevs_trunc" DOUBLE,
"familiarity_fcvs_trunc" DOUBLE,
"driving_exp_ev" DOUBLE,
"driving_exp_hev" DOUBLE,
"driving_exp_phev" DOUBLE,
"driving_exp_fcv" DOUBLE,
"driving_exp_ev_trunc" DOUBLE,
"driving_exp_hev_trunc" DOUBLE,
"driving_exp_phev_trunc" DOUBLE,
"driving_exp_fcv_trunc" DOUBLE,
"ev_home_charge" DOUBLE,
"ev_public_charging" DOUBLE,
"ev_charge_time" DOUBLE,
"ev_range" DOUBLE,
"ev_purchase_price" DOUBLE,
"ev_safety" DOUBLE,
"ev_reliability" DOUBLE,
"ev_home_charge_trunc" DOUBLE,
"ev_public_charging_trunc" DOUBLE,
"ev_charge_time_trunc" DOUBLE,
"ev_range_trunc" DOUBLE,
"ev_purchase_price_trunc" DOUBLE,
"ev_safety_trunc" DOUBLE,
"ev_reliability_trunc" DOUBLE,
"fcv_public_refueling" DOUBLE,
"fcv_fueling_time" DOUBLE,
"fcv_range" DOUBLE,
"fcv_purchase_price" DOUBLE,
"fcv_safety" DOUBLE,
"fcv_reliability" DOUBLE,
"fcv_public_refueling_trunc" DOUBLE,
"fcv_fueling_time_trunc" DOUBLE,
"fcv_range_trunc" DOUBLE,
"fcv_purchase_price_trunc" DOUBLE,
"fcv_safety_trunc" DOUBLE,
"fcv_reliabilty_trunc" DOUBLE,
"environmental_risk" DOUBLE,
"environmental_risk_trunc" DOUBLE,
"health_risk" DOUBLE,
"health_risk_trunc" DOUBLE,
"urgent_national_need" DOUBLE,
"urgent_national_need_trunc" DOUBLE
);
CREATE TABLE nescaum_zev_survey_12_07_20 (
"response_id" BIGINT,
"no_trucks_plus_incentives_drivetrain_design_1" VARCHAR,
"no_trucks_plus_incentives_drivetrain_design_2" VARCHAR,
"no_trucks_plus_incentives_drivetrain_design_3" VARCHAR,
"no_trucks_plus_incentives_drivetrain_design_4" VARCHAR,
"no_trucks_plus_incentives_drivetrain_design" VARCHAR,
"respondent_education" VARCHAR,
"rrespondent_education" VARCHAR,
"respondent_gender" VARCHAR,
"respondent_sex" VARCHAR,
"income_2" VARCHAR,
"veh_1_total_price" DOUBLE,
"veh_1_total_price_don_t_know" DOUBLE,
"fuel_economy_gasoline_diesel_ethanol" DOUBLE,
"fuel_economy_gasoline_diesel_ethanol_truncated" DOUBLE,
"fuel_economy_gasoline_diesel_ethanol_no_idea" DOUBLE,
"distance" DOUBLE,
"distance_week_month" VARCHAR,
"respondent_s_vehicle_s_monthly_miles" DOUBLE,
"respondent_s_vehicle_s_monthly_miles_truncated" DOUBLE,
"fuel_spending" DOUBLE,
"fuel_spending_week_month" VARCHAR,
"respondent_s_car_fuel_spending_per_month" DOUBLE,
"respondent_s_car_fuel_spending_per_month_trunc" DOUBLE,
"daily_flexibility" VARCHAR,
"commute" VARCHAR,
"home_park_own_car" VARCHAR,
"home_park_other_car" VARCHAR,
"garage_or_carport" VARCHAR,
"home_park_110" VARCHAR,
"home_park_220" VARCHAR,
"home_park_evse" VARCHAR,
"home_park_none" VARCHAR,
"home_park_don_t_know" VARCHAR,
"highest_home_pev_charging_access" VARCHAR,
"electricy_install_authority" VARCHAR,
"home_natural_gas" VARCHAR,
"should_government_offer_incentives" VARCHAR,
"replacement_electricity" VARCHAR,
"replacement_hydrogen" VARCHAR,
"seen_public_evses" VARCHAR,
"seen_public_evses_yes_no" VARCHAR,
"personal_interest_in_zev_tech" VARCHAR,
"personal_interest_in_zev_tech_trunc" VARCHAR,
"consider_an_ev" VARCHAR,
"consider_an_ev_2" VARCHAR,
"consider_an_fcv" VARCHAR,
"consider_an_fcv_2" VARCHAR,
"incentives_federal" VARCHAR,
"base_body_size" VARCHAR,
"base_body_size_2" VARCHAR,
"familiarity_gasoline_vehicles" DOUBLE,
"familiarity_evs" DOUBLE,
"familiarity_hevs" DOUBLE,
"familiarity_phevs" DOUBLE,
"familiarity_fcvs" DOUBLE,
"familiarity_gasoline_vehicles_trunc" DOUBLE,
"familiarity_evs_trunc" DOUBLE,
"familiarity_hevs_trunc" DOUBLE,
"familiarity_phevs_trunc" DOUBLE,
"familiarity_fcvs_trunc" DOUBLE,
"driving_exp_ev" DOUBLE,
"driving_exp_hev" DOUBLE,
"driving_exp_phev" DOUBLE,
"driving_exp_fcv" DOUBLE,
"driving_exp_ev_trunc" DOUBLE,
"driving_exp_hev_trunc" DOUBLE,
"driving_exp_phev_trunc" DOUBLE,
"driving_exp_fcv_trunc" DOUBLE,
"ev_home_charge" DOUBLE,
"ev_public_charging" DOUBLE,
"ev_charge_time" DOUBLE,
"ev_range" DOUBLE,
"ev_purchase_price" DOUBLE,
"ev_safety" DOUBLE,
"ev_reliability" DOUBLE,
"ev_home_charge_trunc" DOUBLE,
"ev_public_charging_trunc" DOUBLE,
"ev_charge_time_trunc" DOUBLE,
"ev_range_trunc" DOUBLE,
"ev_purchase_price_trunc" DOUBLE,
"ev_safety_trunc" DOUBLE,
"ev_reliability_trunc" DOUBLE,
"inverse_ev_home_charge_trunc" DOUBLE,
"inverse_ev_public_charging_trunc" DOUBLE,
"fcv_public_refueling" DOUBLE,
"fcv_fueling_time" DOUBLE,
"fcv_range" DOUBLE,
"fcv_purchase_price" DOUBLE,
"fcv_safety" DOUBLE,
"fcv_reliability" DOUBLE,
"fcv_public_refueling_trunc" DOUBLE,
"fcv_fueling_time_trunc" DOUBLE,
"fcv_range_trunc" DOUBLE,
"fcv_purchase_price_trunc" DOUBLE,
"fcv_safety_trunc" DOUBLE,
"fcv_reliabilty_trunc" DOUBLE,
"inverse_fcv_public_refueling_trunc" DOUBLE,
"environmental_risk" DOUBLE,
"environmental_risk_trunc" DOUBLE
);
CREATE TABLE nj_zev_survey_12_07_20 (
"response_id" BIGINT,
"no_trucks_plus_incentives_drivetrain_design_1" VARCHAR,
"no_trucks_plus_incentives_drivetrain_design_2" VARCHAR,
"no_trucks_plus_incentives_drivetrain_design_3" VARCHAR,
"no_trucks_plus_incentives_drivetrain_design_4" VARCHAR,
"no_trucks_plus_incentives_drivetrain_design" VARCHAR,
"respondent_education" VARCHAR,
"respondent_gender" VARCHAR,
"respondent_sex" VARCHAR,
"gender_2" VARCHAR,
"income_2" VARCHAR,
"veh_1_total_price" DOUBLE,
"veh_1_total_price_don_t_know" BIGINT,
"fuel_economy_gasoline_diesel_ethanol_no_idea" DOUBLE,
"distance" DOUBLE,
"distance_week_month" VARCHAR,
"respondent_s_vehicle_s_monthly_miles" DOUBLE,
"respondent_s_vehicle_s_monthly_miles_truncated" DOUBLE,
"fuel_spending" DOUBLE,
"fuel_spending_week_month" VARCHAR,
"respondent_s_car_fuel_spending_per_month" DOUBLE,
"respondent_s_car_fuel_spending_per_month_trunc" DOUBLE,
"daily_flexibility" VARCHAR,
"commute" VARCHAR,
"home_park_own_car" VARCHAR,
"home_park_other_car" VARCHAR,
"garage_or_carport" VARCHAR,
"home_park_110" VARCHAR,
"home_park_220" VARCHAR,
"home_park_evse" VARCHAR,
"home_park_none" VARCHAR,
"home_park_don_t_know" VARCHAR,
"highest_home_pev_charging_access" VARCHAR,
"electricy_install_authority" VARCHAR,
"home_natural_gas" VARCHAR,
"should_government_offer_incentives" VARCHAR,
"replacement_electricity" VARCHAR,
"replacement_hydrogen" VARCHAR,
"seen_public_evses" VARCHAR,
"seen_public_evses_yes_no" VARCHAR,
"personal_interest_in_zev_tech" VARCHAR,
"consider_an_ev" VARCHAR,
"rconsiderev" VARCHAR,
"consider_an_fcv" VARCHAR,
"rconsiderfcv" VARCHAR,
"incentives_federal" VARCHAR,
"base_body_size" VARCHAR,
"base_body_size_2" VARCHAR,
"familiarity_gasoline_vehicles" DOUBLE,
"familiarity_evs" DOUBLE,
"familiarity_hevs" DOUBLE,
"familiarity_phevs" DOUBLE,
"familiarity_fcvs" DOUBLE,
"familiarity_gasoline_vehicles_trunc" DOUBLE,
"familiarity_evs_trunc" DOUBLE,
"familiarity_hevs_trunc" DOUBLE,
"familiarity_phevs_trunc" DOUBLE,
"familiarity_fcvs_trunc" DOUBLE,
"driving_exp_ev" DOUBLE,
"driving_exp_hev" DOUBLE,
"driving_exp_phev" DOUBLE,
"driving_exp_fcv" DOUBLE,
"driving_exp_ev_trunc" DOUBLE,
"driving_exp_hev_trunc" DOUBLE,
"driving_exp_phev_trunc" DOUBLE,
"driving_exp_fcv_trunc" DOUBLE,
"ev_home_charge" DOUBLE,
"ev_public_charging" DOUBLE,
"ev_charge_time" DOUBLE,
"ev_range" DOUBLE,
"ev_purchase_price" DOUBLE,
"ev_safety" DOUBLE,
"ev_reliability" DOUBLE,
"ev_home_charge_trunc" DOUBLE,
"ev_public_charging_trunc" DOUBLE,
"ev_charge_time_trunc" DOUBLE,
"ev_range_trunc" DOUBLE,
"ev_purchase_price_trunc" DOUBLE,
"ev_safety_trunc" DOUBLE,
"ev_reliability_trunc" DOUBLE,
"fcv_public_refueling" DOUBLE,
"fcv_fueling_time" DOUBLE,
"fcv_range" DOUBLE,
"fcv_purchase_price" DOUBLE,
"fcv_safety" DOUBLE,
"fcv_reliability" DOUBLE,
"fcv_public_refueling_trunc" DOUBLE,
"fcv_fueling_time_trunc" DOUBLE,
"fcv_range_trunc" DOUBLE,
"fcv_purchase_price_trunc" DOUBLE,
"fcv_safety_trunc" DOUBLE,
"fcv_reliabilty_trunc" DOUBLE,
"environmental_risk" DOUBLE,
"environmental_risk_trunc" DOUBLE,
"health_risk" DOUBLE,
"health_risk_trunc" DOUBLE,
"urgent_national_need" DOUBLE,
"urgent_national_need_trunc" DOUBLE,
"market_provides_incentives" DOUBLE,
"market_incentives_trunc" DOUBLE
);
CREATE TABLE ny_zev_survey_12_07_20 (
"response_id" BIGINT,
"no_trucks_plus_incentives_drivetrain_design_1" VARCHAR,
"no_trucks_plus_incentives_drivetrain_design_2" VARCHAR,
"no_trucks_plus_incentives_drivetrain_design_3" VARCHAR,
"no_trucks_plus_incentives_drivetrain_design_4" VARCHAR,
"no_trucks_plus_incentives_drivetrain_design" VARCHAR,
"respondent_education" VARCHAR,
"rr_education" VARCHAR,
"rrespondent_education" VARCHAR,
"respondent_gender" VARCHAR,
"gender_2" VARCHAR,
"income_2" VARCHAR,
"rhhld_income" VARCHAR,
"veh_1_total_price" DOUBLE,
"veh_1_total_price_don_t_know" BIGINT,
"fuel_economy_gasoline_diesel_ethanol" DOUBLE,
"fuel_economy_gasoline_diesel_ethanol_truncated" DOUBLE,
"fuel_economy_gasoline_diesel_ethanol_no_idea" DOUBLE,
"distance" DOUBLE,
"distance_week_month" VARCHAR,
"respondent_s_vehicle_s_monthly_miles" DOUBLE,
"respondent_s_vehicle_s_monthly_miles_truncated" DOUBLE,
"fuel_spending" DOUBLE,
"fuel_spending_week_month" VARCHAR,
"respondent_s_car_fuel_spending_per_month" DOUBLE,
"respondent_s_car_fuel_spending_per_month_trunc" DOUBLE,
"daily_flexibility" VARCHAR,
"daily_flexibility_2" VARCHAR,
"commute" VARCHAR,
"home_park_own_car" VARCHAR,
"home_park_other_car" VARCHAR,
"garage_or_carport" VARCHAR,
"home_park_110" VARCHAR,
"home_park_220" VARCHAR,
"home_park_evse" VARCHAR,
"home_park_none" VARCHAR,
"home_park_don_t_know" VARCHAR,
"highest_home_pev_charging_access" VARCHAR,
"electricy_install_authority" VARCHAR,
"electricy_install_authority_2" VARCHAR,
"home_natural_gas" VARCHAR,
"should_government_offer_incentives" VARCHAR,
"replacement_electricity" VARCHAR,
"replacement_hydrogen" VARCHAR,
"seen_public_evses" VARCHAR,
"seen_public_evses_yes_no" VARCHAR,
"personal_interest_in_zev_tech" VARCHAR,
"personal_interest_in_zev_tech_2" VARCHAR,
"rpersonal_interest_in_zev_tech" VARCHAR,
"consider_an_ev" VARCHAR,
"rconsiderev" VARCHAR,
"rrconsiderev" VARCHAR,
"consider_an_fcv" VARCHAR,
"rconsider_fcv" VARCHAR,
"rrconsiderfcv" VARCHAR,
"incentives_federal" VARCHAR,
"base_body_size" VARCHAR,
"base_body_size_2" VARCHAR,
"rbase_body_size" VARCHAR,
"familiarity_gasoline_vehicles" DOUBLE,
"familiarity_evs" DOUBLE,
"familiarity_hevs" DOUBLE,
"familiarity_phevs" DOUBLE,
"familiarity_fcvs" DOUBLE,
"familiarity_gasoline_vehicles_trunc" DOUBLE,
"familiarity_evs_trunc" DOUBLE,
"familiarity_hevs_trunc" DOUBLE,
"familiarity_phevs_trunc" DOUBLE,
"familiarity_fcvs_trunc" DOUBLE,
"driving_exp_ev" DOUBLE,
"driving_exp_hev" DOUBLE,
"driving_exp_phev" DOUBLE,
"driving_exp_fcv" DOUBLE,
"driving_exp_ev_trunc" DOUBLE,
"driving_exp_hev_trunc" DOUBLE,
"driving_exp_phev_trunc" DOUBLE,
"driving_exp_fcv_trunc" DOUBLE,
"ev_home_charge" DOUBLE,
"ev_public_charging" DOUBLE,
"ev_charge_time" DOUBLE,
"ev_range" DOUBLE,
"ev_purchase_price" DOUBLE,
"ev_safety" DOUBLE,
"ev_reliability" DOUBLE,
"ev_home_charge_trunc" DOUBLE,
"ev_public_charging_trunc" DOUBLE,
"ev_charge_time_trunc" DOUBLE,
"ev_range_trunc" DOUBLE,
"ev_purchase_price_trunc" DOUBLE,
"ev_safety_trunc" DOUBLE,
"ev_reliability_trunc" DOUBLE,
"fcv_public_refueling" DOUBLE,
"fcv_fueling_time" DOUBLE,
"fcv_range" DOUBLE,
"fcv_purchase_price" DOUBLE,
"fcv_safety" DOUBLE,
"fcv_reliability" DOUBLE,
"fcv_public_refueling_trunc" DOUBLE,
"fcv_fueling_time_trunc" DOUBLE,
"fcv_range_trunc" DOUBLE
);
CREATE TABLE or_zev_survey_12_07_20 (
"response_id" BIGINT,
"no_trucks_plus_incentives_drivetrain_design_1" VARCHAR,
"no_trucks_plus_incentives_drivetrain_design_2" VARCHAR,
"no_trucks_plus_incentives_drivetrain_design_3" VARCHAR,
"no_trucks_plus_incentives_drivetrain_design_4" VARCHAR,
"no_trucks_plus_incentives_drivetrain_design" VARCHAR,
"respondent_education" VARCHAR,
"rrespondent_education" VARCHAR,
"respondent_gender" VARCHAR,
"respondent_sex" VARCHAR,
"income_2" VARCHAR,
"veh_1_total_price" DOUBLE,
"veh_1_total_price_don_t_know" BIGINT,
"fuel_economy_gasoline_diesel_ethanol" DOUBLE,
"fuel_economy_gasoline_diesel_ethanol_truncated" DOUBLE,
"fuel_economy_gasoline_diesel_ethanol_no_idea" DOUBLE,
"distance" DOUBLE,
"distance_week_month" VARCHAR,
"respondent_s_vehicle_s_monthly_miles" DOUBLE,
"respondent_s_vehicle_s_monthly_miles_truncated" DOUBLE,
"fuel_spending" DOUBLE,
"fuel_spending_week_month" VARCHAR,
"respondent_s_car_fuel_spending_per_month" DOUBLE,
"respondent_s_car_fuel_spending_per_month_trunc" DOUBLE,
"daily_flexibility" VARCHAR,
"rdaily_flexibility" BIGINT,
"commute" VARCHAR,
"home_park_own_car" VARCHAR,
"home_park_other_car" VARCHAR,
"garage_or_carport" VARCHAR,
"home_park_110" VARCHAR,
"home_park_220" VARCHAR,
"home_park_evse" VARCHAR,
"home_park_none" VARCHAR,
"home_park_don_t_know" VARCHAR,
"highest_home_pev_charging_access" VARCHAR,
"electricy_install_authority" VARCHAR,
"home_natural_gas" VARCHAR,
"should_government_offer_incentives" VARCHAR,
"replacement_electricity" VARCHAR,
"replacement_hydrogen" VARCHAR,
"seen_public_evses" VARCHAR,
"seen_public_evses_yes_no" VARCHAR,
"personal_interest_in_zev_tech" VARCHAR,
"rpersonal_interest_in_zev_tech" VARCHAR,
"consider_an_ev" VARCHAR,
"rconsider_an_ev" VARCHAR,
"consider_an_fcv" VARCHAR,
"rconsider_fcv" VARCHAR,
"incentives_federal" VARCHAR,
"base_body_size" VARCHAR,
"base_body_size_2" VARCHAR,
"familiarity_gasoline_vehicles" DOUBLE,
"familiarity_evs" DOUBLE,
"familiarity_hevs" DOUBLE,
"familiarity_phevs" DOUBLE,
"familiarity_fcvs" DOUBLE,
"familiarity_gasoline_vehicles_trunc" DOUBLE,
"familiarity_evs_trunc" DOUBLE,
"familiarity_hevs_trunc" DOUBLE,
"familiarity_phevs_trunc" DOUBLE,
"familiarity_fcvs_trunc" DOUBLE,
"driving_exp_ev" DOUBLE,
"driving_exp_hev" DOUBLE,
"driving_exp_phev" DOUBLE,
"driving_exp_fcv" DOUBLE,
"driving_exp_ev_trunc" DOUBLE,
"driving_exp_hev_trunc" DOUBLE,
"driving_exp_phev_trunc" DOUBLE,
"driving_exp_fcv_trunc" DOUBLE,
"ev_home_charge" DOUBLE,
"ev_public_charging" DOUBLE,
"ev_charge_time" DOUBLE,
"ev_range" DOUBLE,
"ev_purchase_price" DOUBLE,
"ev_safety" DOUBLE,
"ev_reliability" DOUBLE,
"ev_home_charge_trunc" DOUBLE,
"ev_public_charging_trunc" DOUBLE,
"ev_charge_time_trunc" DOUBLE,
"ev_range_trunc" DOUBLE,
"ev_purchase_price_trunc" DOUBLE,
"ev_safety_trunc" DOUBLE,
"ev_reliability_trunc" DOUBLE,
"fcv_public_refueling" DOUBLE,
"fcv_fueling_time" DOUBLE,
"fcv_range" DOUBLE,
"fcv_purchase_price" DOUBLE,
"fcv_safety" DOUBLE,
"fcv_reliability" DOUBLE,
"fcv_public_refueling_trunc" DOUBLE,
"fcv_fueling_time_trunc" DOUBLE,
"fcv_range_trunc" DOUBLE,
"fcv_purchase_price_trunc" DOUBLE,
"fcv_safety_trunc" DOUBLE,
"fcv_reliabilty_trunc" DOUBLE,
"environmental_risk" DOUBLE,
"environmental_risk_trunc" DOUBLE,
"health_risk" DOUBLE,
"health_risk_trunc" DOUBLE
);
CREATE TABLE wa_zev_survey_12_07_20 (
"response_id" BIGINT,
"no_trucks_plus_incentives_drivetrain_design_1" VARCHAR,
"no_trucks_plus_incentives_drivetrain_design_2" VARCHAR,
"no_trucks_plus_incentives_drivetrain_design_3" VARCHAR,
"no_trucks_plus_incentives_drivetrain_design_4" VARCHAR,
"no_trucks_plus_incentives_drivetrain_design" VARCHAR,
"respondent_education" VARCHAR,
"rrespondent_education" VARCHAR,
"respondent_gender" VARCHAR,
"respondent_sex" VARCHAR,
"income_2" VARCHAR,
"veh_1_total_price" DOUBLE,
"veh_1_total_price_don_t_know" BIGINT,
"fuel_economy_gasoline_diesel_ethanol" DOUBLE,
"fuel_economy_gasoline_diesel_ethanol_truncated" DOUBLE,
"fuel_economy_gasoline_diesel_ethanol_no_idea" DOUBLE,
"distance" DOUBLE,
"distance_week_month" VARCHAR,
"respondent_s_vehicle_s_monthly_miles" DOUBLE,
"respondent_s_vehicle_s_monthly_miles_truncated" DOUBLE,
"fuel_spending" DOUBLE,
"fuel_spending_week_month" VARCHAR,
"respondent_s_car_fuel_spending_per_month" DOUBLE,
"respondent_s_car_fuel_spending_per_month_trunc" DOUBLE,
"daily_flexibility" VARCHAR,
"commute" VARCHAR,
"home_park_own_car" VARCHAR,
"home_park_other_car" VARCHAR,
"garage_or_carport" VARCHAR,
"home_park_110" VARCHAR,
"home_park_220" VARCHAR,
"home_park_evse" VARCHAR,
"home_park_none" VARCHAR,
"home_park_don_t_know" VARCHAR,
"highest_home_pev_charging_access" VARCHAR,
"electricy_install_authority" VARCHAR,
"home_natural_gas" VARCHAR,
"should_government_offer_incentives" VARCHAR,
"replacement_electricity" VARCHAR,
"replacement_hydrogen" VARCHAR,
"seen_public_evses" VARCHAR,
"seen_public_evses_yes_no" VARCHAR,
"personal_interest_in_zev_tech" VARCHAR,
"rpersonal_interest_in_zev_tech" VARCHAR,
"consider_an_ev" VARCHAR,
"consider_an_fcv" VARCHAR,
"rconsider_an_fcv" VARCHAR,
"incentives_federal" VARCHAR,
"base_body_size" VARCHAR,
"base_body_size_2" VARCHAR,
"base_body_size_3" VARCHAR,
"familiarity_gasoline_vehicles" DOUBLE,
"familiarity_evs" DOUBLE,
"familiarity_hevs" DOUBLE,
"familiarity_phevs" DOUBLE,
"familiarity_fcvs" DOUBLE,
"familiarity_gasoline_vehicles_trunc" DOUBLE,
"familiarity_evs_trunc" DOUBLE,
"familiarity_hevs_trunc" DOUBLE,
"familiarity_phevs_trunc" DOUBLE,
"familiarity_fcvs_trunc" DOUBLE,
"driving_exp_ev" DOUBLE,
"driving_exp_hev" DOUBLE,
"driving_exp_phev" DOUBLE,
"driving_exp_fcv" DOUBLE,
"driving_exp_bev_trunc" DOUBLE,
"driving_exp_hev_trunc" DOUBLE,
"driving_exp_phev_trunc" DOUBLE,
"driving_exp_fcev_trunc" DOUBLE,
"ev_home_charge" DOUBLE,
"ev_public_charging" DOUBLE,
"ev_charge_time" DOUBLE,
"ev_range" DOUBLE,
"ev_purchase_price" DOUBLE,
"ev_safety" DOUBLE,
"ev_reliability" DOUBLE,
"ev_home_charge_trunc" DOUBLE,
"ev_public_charging_trunc" DOUBLE,
"ev_charge_time_trunc" DOUBLE,
"ev_range_trunc" DOUBLE,
"ev_purchase_price_trunc" DOUBLE,
"ev_safety_trunc" DOUBLE,
"ev_reliability_trunc" DOUBLE,
"fcv_public_refueling" DOUBLE,
"fcv_fueling_time" DOUBLE,
"fcv_range" DOUBLE,
"fcv_purchase_price" DOUBLE,
"fcv_safety" DOUBLE,
"fcv_reliability" DOUBLE,
"fcv_public_refueling_trunc" DOUBLE,
"fcv_fueling_time_trunc" DOUBLE,
"fcv_range_trunc" DOUBLE,
"fcv_purchase_price_trunc" DOUBLE,
"fcv_safety_trunc" DOUBLE,
"fcv_reliabilty_trunc" DOUBLE,
"environmental_risk" DOUBLE,
"environmental_risk_trunc" DOUBLE,
"health_risk" DOUBLE,
"health_risk_trunc" DOUBLE,
"urgent_national_need" DOUBLE
);
Anyone who has the link will be able to view this.