Baselight
Sign In

California Residents' ZEV Attitudes

Drivers' Preferences, Experiences, and Environmental Concerns

@kaggle.thedevastator_california_residents_zev_attitudes

Loading...
Loading...

About this Dataset

California Residents' ZEV Attitudes

California Residents' ZEV Attitudes

Drivers' Preferences, Experiences, and Environmental Concerns

By [source]

About this dataset

This comprehensive survey of California residents’ attitudes toward zero-emission vehicles (ZEVs) reveals crucial insight into the factors that are driving consumer adoption of this technology, including purchase costs, environmental impacts, and energy-related considerations.
The dataset contains a series of questions concerning respondents' demographical information as well as their views on ZEVs. It also includes data specifically targeted toward parties involved with associated retailers and workshops. This means you can angle your analysis to focus on any area within the scope of the survey such as:

• The overall view Californians have towards ZEVs
• Attitudes relating to cost or availability of charging points
• Perceptions about environmental impacts
• Differences between responses from urban/rural residents

As well as many other areas you wish to research further! By diving into this detailed dataset, you’ll be able to unlock unprecedented insight into how Californians view ZEVs and get an upclose look at their thoughts and opinions on the burgeoning technology

More Datasets

For more datasets, click here.

Featured Notebooks

  • 🚨 Your notebook can be here! 🚨!

How to use the dataset

How to use this dataset

This dataset of California residents’ attitudes toward zero-emission vehicles (ZEVs) can provide invaluable insights into how they view the adoption rates, cost and environmental impacts of these vehicles. By understanding the attitudes towards ZEVs, policymakers, businesses and citizens alike can be better informed in their decisions.

In this dataset, you will find responses from 693 respondents who had various opinions on topics related to ZEV adoption rates, cost and environmental impacts. Each respondent provided their answers by assigning a value between 1 and 5 in each category for each aspect of ZEVs (e.g., 5 was 'Strongly Agree' for statements like “I would buy a ZEV if I could afford it”).

The questions that were asked include:

  • Do you agree that governments should enact incentives/discounts to encourage more people to purchase/lease a zero-emission vehicle?
  • Do you feel having more electric cars on the street helps reduce air pollution?
  • Would you prefer an electric car over an internal combustion engine vehicle?
  • What is your opinion about tax credits offered by governments for the purchase or lease of zero-emission vehicles?

You can use this dataset to process how Californian residents felt about ZEVs when given these questions. By analyzing these responses using tools such as Microsoft Excel or Tableau software, one can gain valuable insights into identifying areas that need improvement when it comes to policies surrounding the adoption rates and costs associated with buying/leasing a zero emission vehicle. Additionally, one might determine correlations between responses on particular topics such as what government incentives should be enacted or whether there is general agreement that electric cars help reduce air pollution

Research Ideas

  • Examine the relationship between hometown and attitudes toward ZEVs – Analyzing which cities have the highest adoption rates or most positive opinions on ZEVs can be helpful in informing targeted marketing strategies or community investments.
  • Evaluate awareness of environmental benefits of ZEVs – Comparing survey responses about environmental topics to actual scientific facts about emissions and pollution from vehicles can help paint a better picture for how aware people currently are on the subject, and identify educational opportunities in communities with lower levels of knowledge on these matters.
  • Analyze demographic influences on perceptions of ZEVs - Examining how age, gender, income level, education background, etc., affect attitudes towards ZEVs can give business professionals useful insights when launching campaigns targeting different audiences in California

Acknowledgements

If you use this dataset in your research, please credit the original authors.
Data Source

License

License: CC0 1.0 Universal (CC0 1.0) - Public Domain Dedication
No Copyright - You can copy, modify, distribute and perform the work, even for commercial purposes, all without asking permission. See Other Information.

Columns

Acknowledgements

If you use this dataset in your research, please credit the original authors.
If you use this dataset in your research, please credit .

Tables

Ca Zev Survey 12–07–20

@kaggle.thedevastator_california_residents_zev_attitudes.ca_zev_survey_12_07_20
  • 644.79 kB
  • 1,671 rows
  • 197 columns
Loading... 
CREATE TABLE ca_zev_survey_12_07_20 (
  "response_id" BIGINT  -- Response ID..,
  "no_trucks_plus_incentives_drivetrain_design_1" VARCHAR  -- No Trucks, Plus Incentives: Drivetrain Design 1,
  "no_trucks_plus_incentives_drivetrain_design_2" VARCHAR  -- No Trucks, Plus Incentives: Drivetrain Design 2,
  "no_trucks_plus_incentives_drivetrain_design_3" VARCHAR  -- No Trucks, Plus Incentives: Drivetrain Design 3,
  "no_trucks_plus_incentives_drivetrain_design_4" VARCHAR  -- No Trucks, Plus Incentives: Drivetrain Design 4,
  "no_trucks_plus_incentives_drivetrain_design" VARCHAR  -- No Trucks, Plus Incentives: Drivetrain Design,
  "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  -- Veh 1 Total Price, Don\u0027t Know,
  "fuel_economy_gasoline_diesel_ethanol" DOUBLE  -- Fuel Economy, Gasoline / Diesel / Ethanol,
  "fuel_economy_gasoline_diesel_ethanol_truncated" DOUBLE  -- Fuel Economy, Gasoline / Diesel / Ethanol Truncated,
  "fuel_economy_gasoline_diesel_ethanol_no_idea" DOUBLE  -- Fuel Economy, Gasoline / Diesel / Ethanol, No Idea,
  "distance" DOUBLE,
  "distance_week_month" VARCHAR,
  "respondent_s_vehicle_s_monthly_miles" DOUBLE  -- Respondent\u0027s Vehicle\u0027s Monthly Miles,
  "respondent_s_vehicle_s_monthly_miles_truncated" DOUBLE  -- Respondent\u0027s Vehicle\u0027s Monthly Miles Truncated,
  "fuel_spending" DOUBLE,
  "fuel_spending_week_month" VARCHAR,
  "respondent_s_car_fuel_spending_per_month" DOUBLE  -- Respondent\u0027s Car Fuel Spending Per Month,
  "respondent_s_car_fuel_spending_per_month_trunc" DOUBLE  -- Respondent\u0027s Car Fuel Spending Per Month (trunc),
  "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: 110,
  "home_park_220" VARCHAR  -- Home Park: 220,
  "home_park_evse" VARCHAR  -- Home Park: EVSE,
  "home_park_none" VARCHAR  -- Home Park: None,
  "home_park_don_t_know" VARCHAR  -- Home Park: Don\u0027t Know,
  "highest_home_pev_charging_access" VARCHAR,
  "electricy_install_authority" VARCHAR,
  "home_natural_gas" VARCHAR,
  "should_government_offer_incentives" VARCHAR,
  "replacement_electricity" VARCHAR  -- Replacement: Electricity,
  "replacement_hydrogen" VARCHAR  -- Replacement: Hydrogen,
  "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  -- Incentives: Federal,
  "base_body_size" VARCHAR,
  "base_body_size_2" VARCHAR,
  "familiarity_gasoline_vehicles" DOUBLE  -- Familiarity: Gasoline Vehicles,
  "familiarity_evs" DOUBLE  -- Familiarity: EVs,
  "familiarity_hevs" DOUBLE  -- Familiarity: HEVs,
  "familiarity_phevs" DOUBLE  -- Familiarity: PHEVs,
  "familiarity_fcvs" DOUBLE  -- Familiarity: FCVs,
  "familiarity_gasoline_vehicles_trunc" DOUBLE  -- Familiarity Gasoline Vehicles (trunc),
  "familiarity_evs_trunc" DOUBLE  -- Familiarity EVs (trunc),
  "familiarity_hevs_trunc" DOUBLE  -- Familiarity HEVs (trunc),
  "familiarity_phevs_trunc" DOUBLE  -- Familiarity PHEVs (trunc),
  "familiarity_fcvs_trunc" DOUBLE  -- Familiarity FCVs (trunc),
  "driving_exp_ev" DOUBLE  -- Driving Exp: EV,
  "driving_exp_hev" DOUBLE  -- Driving Exp: HEV,
  "driving_exp_phev" DOUBLE  -- Driving Exp: PHEV,
  "driving_exp_fcv" DOUBLE  -- Driving Exp: FCV,
  "driving_exp_ev_trunc" DOUBLE  -- Driving Exp: EV (trunc),
  "driving_exp_hev_trunc" DOUBLE  -- Driving Exp: HEV (trunc),
  "driving_exp_phev_trunc" DOUBLE  -- Driving Exp: PHEV (trunc),
  "driving_exp_fcv_trunc" DOUBLE  -- Driving Exp: FCV (trunc),
  "ev_home_charge" DOUBLE  -- EV: Home Charge,
  "ev_public_charging" DOUBLE  -- EV: Public Charging,
  "ev_charge_time" DOUBLE  -- EV: Charge Time,
  "ev_range" DOUBLE  -- EV: Range,
  "ev_purchase_price" DOUBLE  -- EV: Purchase Price,
  "ev_safety" DOUBLE  -- EV: Safety,
  "ev_reliability" DOUBLE  -- EV: Reliability,
  "ev_home_charge_trunc" DOUBLE  -- EV: Home Charge (trunc),
  "ev_public_charging_trunc" DOUBLE  -- EV: Public Charging (trunc),
  "ev_charge_time_trunc" DOUBLE  -- EV: Charge Time (trunc),
  "ev_range_trunc" DOUBLE  -- EV: Range (trunc),
  "ev_purchase_price_trunc" DOUBLE  -- EV: Purchase Price (trunc),
  "ev_safety_trunc" DOUBLE  -- EV: Safety (trunc),
  "ev_reliability_trunc" DOUBLE  -- EV: Reliability (trunc),
  "fcv_public_refueling" DOUBLE  -- FCV: Public Refueling,
  "fcv_fueling_time" DOUBLE  -- FCV: Fueling Time,
  "fcv_range" DOUBLE  -- FCV: Range,
  "fcv_purchase_price" DOUBLE  -- FCV: Purchase Price,
  "fcv_safety" DOUBLE  -- FCV: Safety,
  "fcv_reliability" DOUBLE  -- FCV: Reliability,
  "fcv_public_refueling_trunc" DOUBLE  -- FCV: Public Refueling (trunc),
  "fcv_fueling_time_trunc" DOUBLE  -- FCV: Fueling Time (trunc),
  "fcv_range_trunc" DOUBLE  -- FCV: Range (trunc),
  "fcv_purchase_price_trunc" DOUBLE  -- FCV: Purchase Price (trunc),
  "fcv_safety_trunc" DOUBLE  -- FCV: Safety (trunc),
  "fcv_reliabilty_trunc" DOUBLE  -- FCV: Reliabilty (trunc),
  "environmental_risk" DOUBLE,
  "environmental_risk_trunc" DOUBLE  -- Environmental Risk (trunc),
  "health_risk" DOUBLE,
  "health_risk_trunc" DOUBLE  -- Health Risk (trunc)
);

De Zev Survey 12–07–20

@kaggle.thedevastator_california_residents_zev_attitudes.de_zev_survey_12_07_20
  • 219.11 kB
  • 200 rows
  • 190 columns
Loading... 
CREATE TABLE de_zev_survey_12_07_20 (
  "response_id" BIGINT  -- Response ID..,
  "no_trucks_plus_incentives_drivetrain_design_1" VARCHAR  -- No Trucks, Plus Incentives: Drivetrain Design 1,
  "no_trucks_plus_incentives_drivetrain_design_2" VARCHAR  -- No Trucks, Plus Incentives: Drivetrain Design 2,
  "no_trucks_plus_incentives_drivetrain_design_3" VARCHAR  -- No Trucks, Plus Incentives: Drivetrain Design 3,
  "no_trucks_plus_incentives_drivetrain_design_4" VARCHAR  -- No Trucks, Plus Incentives: Drivetrain Design 4,
  "no_trucks_plus_incentives_drivetrain_design" VARCHAR  -- No Trucks, Plus Incentives: Drivetrain Design,
  "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  -- Veh 1 Total Price, Don\u0027t Know,
  "fuel_economy_gasoline_diesel_ethanol" DOUBLE  -- Fuel Economy, Gasoline / Diesel / Ethanol,
  "fuel_economy_gasoline_diesel_ethanol_truncated" DOUBLE  -- Fuel Economy, Gasoline / Diesel / Ethanol Truncated,
  "fuel_economy_gasoline_diesel_ethanol_no_idea" DOUBLE  -- Fuel Economy, Gasoline / Diesel / Ethanol, No Idea,
  "distance" DOUBLE,
  "distance_week_month" VARCHAR,
  "respondent_s_vehicle_s_monthly_miles" DOUBLE  -- Respondent\u0027s Vehicle\u0027s Monthly Miles,
  "respondent_s_vehicle_s_monthly_miles_truncated" DOUBLE  -- Respondent\u0027s Vehicle\u0027s Monthly Miles Truncated,
  "fuel_spending" DOUBLE,
  "fuel_spending_week_month" VARCHAR,
  "respondent_s_car_fuel_spending_per_month" DOUBLE  -- Respondent\u0027s Car Fuel Spending Per Month,
  "respondent_s_car_fuel_spending_per_month_trunc" DOUBLE  -- Respondent\u0027s Car Fuel Spending Per Month (trunc),
  "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: 110,
  "home_park_220" VARCHAR  -- Home Park: 220,
  "home_park_evse" VARCHAR  -- Home Park: EVSE,
  "home_park_none" VARCHAR  -- Home Park: None,
  "home_park_don_t_know" VARCHAR  -- Home Park: Don\u0027t Know,
  "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: Electricity,
  "replacement_hydrogen" VARCHAR  -- Replacement: Hydrogen,
  "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  -- Incentives: Federal,
  "base_body_size" VARCHAR,
  "base_body_size_2" VARCHAR,
  "familiarity_gasoline_vehicles" DOUBLE  -- Familiarity: Gasoline Vehicles,
  "familiarity_evs" DOUBLE  -- Familiarity: EVs,
  "familiarity_hevs" DOUBLE  -- Familiarity: HEVs,
  "familiarity_phevs" DOUBLE  -- Familiarity: PHEVs,
  "familiarity_fcvs" DOUBLE  -- Familiarity: FCVs,
  "familiarity_gasoline_vehicles_trunc" DOUBLE  -- Familiarity Gasoline Vehicles (trunc),
  "familiarity_evs_trunc" DOUBLE  -- Familiarity EVs (trunc),
  "familiarity_hevs_trunc" DOUBLE  -- Familiarity HEVs (trunc),
  "familiarity_phevs_trunc" DOUBLE  -- Familiarity PHEVs (trunc),
  "familiarity_fcvs_trunc" DOUBLE  -- Familiarity FCVs (trunc),
  "driving_exp_ev" DOUBLE  -- Driving Exp: EV,
  "driving_exp_hev" DOUBLE  -- Driving Exp: HEV,
  "driving_exp_phev" DOUBLE  -- Driving Exp: PHEV,
  "driving_exp_fcv" DOUBLE  -- Driving Exp: FCV,
  "driving_exp_ev_trunc" DOUBLE  -- Driving Exp: EV (trunc),
  "driving_exp_hev_trunc" DOUBLE  -- Driving Exp: HEV (trunc),
  "driving_exp_phev_trunc" DOUBLE  -- Driving Exp: PHEV (trunc),
  "driving_exp_fcv_trunc" DOUBLE  -- Driving Exp: FCV (trunc),
  "ev_home_charge" DOUBLE  -- EV: Home Charge,
  "ev_public_charging" DOUBLE  -- EV: Public Charging,
  "ev_charge_time" DOUBLE  -- EV: Charge Time,
  "ev_range" DOUBLE  -- EV: Range,
  "ev_purchase_price" DOUBLE  -- EV: Purchase Price,
  "ev_safety" DOUBLE  -- EV: Safety,
  "ev_reliability" DOUBLE  -- EV: Reliability,
  "ev_home_charge_trunc" DOUBLE  -- EV: Home Charge (trunc),
  "ev_public_charging_trunc" DOUBLE  -- EV: Public Charging (trunc),
  "ev_charge_time_trunc" DOUBLE  -- EV: Charge Time (trunc),
  "ev_range_trunc" DOUBLE  -- EV: Range (trunc),
  "ev_purchase_price_trunc" DOUBLE  -- EV: Purchase Price (trunc),
  "ev_safety_trunc" DOUBLE  -- EV: Safety (trunc),
  "ev_reliability_trunc" DOUBLE  -- EV: Reliability (trunc),
  "fcv_public_refueling" DOUBLE  -- FCV: Public Refueling,
  "fcv_fueling_time" DOUBLE  -- FCV: Fueling Time,
  "fcv_range" DOUBLE  -- FCV: Range,
  "fcv_purchase_price" DOUBLE  -- FCV: Purchase Price,
  "fcv_safety" DOUBLE  -- FCV: Safety,
  "fcv_reliability" DOUBLE  -- FCV: Reliability,
  "fcv_public_refueling_trunc" DOUBLE  -- FCV: Public Refueling (trunc),
  "fcv_fueling_time_trunc" DOUBLE  -- FCV: Fueling Time (trunc),
  "fcv_range_trunc" DOUBLE  -- FCV: Range (trunc),
  "fcv_purchase_price_trunc" DOUBLE  -- FCV: Purchase Price (trunc),
  "fcv_safety_trunc" DOUBLE  -- FCV: Safety (trunc),
  "fcv_reliabilty_trunc" DOUBLE  -- FCV: Reliabilty (trunc),
  "environmental_risk" DOUBLE,
  "environmental_risk_trunc" DOUBLE  -- Environmental Risk (trunc),
  "health_risk" DOUBLE,
  "health_risk_trunc" DOUBLE  -- Health Risk (trunc),
  "urgent_national_need" DOUBLE
);

Ma Zev Survey 12–07–20

@kaggle.thedevastator_california_residents_zev_attitudes.ma_zev_survey_12_07_20
  • 308.92 kB
  • 498 rows
  • 192 columns
Loading... 
CREATE TABLE ma_zev_survey_12_07_20 (
  "response_id" BIGINT  -- Response ID..,
  "no_trucks_plus_incentives_drivetrain_design_1" VARCHAR  -- No Trucks, Plus Incentives: Drivetrain Design 1,
  "no_trucks_plus_incentives_drivetrain_design_2" VARCHAR  -- No Trucks, Plus Incentives: Drivetrain Design 2,
  "no_trucks_plus_incentives_drivetrain_design_3" VARCHAR  -- No Trucks, Plus Incentives: Drivetrain Design 3,
  "no_trucks_plus_incentives_drivetrain_design_4" VARCHAR  -- No Trucks, Plus Incentives: Drivetrain Design 4,
  "no_trucks_plus_incentives_drivetrain_design" VARCHAR  -- No Trucks, Plus Incentives: Drivetrain Design,
  "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  -- Veh 1 Total Price, Don\u0027t Know,
  "fuel_economy_gasoline_diesel_ethanol" DOUBLE  -- Fuel Economy, Gasoline / Diesel / Ethanol,
  "fuel_economy_gasoline_diesel_ethanol_truncated" DOUBLE  -- Fuel Economy, Gasoline / Diesel / Ethanol Truncated,
  "fuel_economy_gasoline_diesel_ethanol_no_idea" DOUBLE  -- Fuel Economy, Gasoline / Diesel / Ethanol, No Idea,
  "distance" DOUBLE,
  "distance_week_month" VARCHAR,
  "respondent_s_vehicle_s_monthly_miles" DOUBLE  -- Respondent\u0027s Vehicle\u0027s Monthly Miles,
  "respondent_s_vehicle_s_monthly_miles_truncated" DOUBLE  -- Respondent\u0027s Vehicle\u0027s Monthly Miles Truncated,
  "fuel_spending" DOUBLE,
  "fuel_spending_week_month" VARCHAR,
  "respondent_s_car_fuel_spending_per_month" DOUBLE  -- Respondent\u0027s Car Fuel Spending Per Month,
  "respondent_s_car_fuel_spending_per_month_trunc" DOUBLE  -- Respondent\u0027s Car Fuel Spending Per Month (trunc),
  "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: 110,
  "home_park_220" VARCHAR  -- Home Park: 220,
  "home_park_evse" VARCHAR  -- Home Park: EVSE,
  "home_park_none" VARCHAR  -- Home Park: None,
  "home_park_don_t_know" VARCHAR  -- Home Park: Don\u0027t Know,
  "highest_home_pev_charging_access" VARCHAR,
  "electricy_install_authority" VARCHAR,
  "home_natural_gas" VARCHAR,
  "should_government_offer_incentives" VARCHAR,
  "replacement_electricity" VARCHAR  -- Replacement: Electricity,
  "replacement_hydrogen" VARCHAR  -- Replacement: Hydrogen,
  "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  -- Incentives: Federal,
  "base_body_size" VARCHAR,
  "base_body_size_2" VARCHAR,
  "familiarity_gasoline_vehicles" DOUBLE  -- Familiarity: Gasoline Vehicles,
  "familiarity_evs" DOUBLE  -- Familiarity: EVs,
  "familiarity_hevs" DOUBLE  -- Familiarity: HEVs,
  "familiarity_phevs" DOUBLE  -- Familiarity: PHEVs,
  "familiarity_fcvs" DOUBLE  -- Familiarity: FCVs,
  "familiarity_gasoline_vehicles_trunc" DOUBLE  -- Familiarity Gasoline Vehicles (trunc),
  "familiarity_evs_trunc" DOUBLE  -- Familiarity EVs (trunc),
  "familiarity_hevs_trunc" DOUBLE  -- Familiarity HEVs (trunc),
  "familiarity_phevs_trunc" DOUBLE  -- Familiarity PHEVs (trunc),
  "familiarity_fcvs_trunc" DOUBLE  -- Familiarity FCVs (trunc),
  "driving_exp_ev" DOUBLE  -- Driving Exp: EV,
  "driving_exp_hev" DOUBLE  -- Driving Exp: HEV,
  "driving_exp_phev" DOUBLE  -- Driving Exp: PHEV,
  "driving_exp_fcv" DOUBLE  -- Driving Exp: FCV,
  "driving_exp_ev_trunc" DOUBLE  -- Driving Exp: EV (trunc),
  "driving_exp_hev_trunc" DOUBLE  -- Driving Exp: HEV (trunc),
  "driving_exp_phev_trunc" DOUBLE  -- Driving Exp: PHEV (trunc),
  "driving_exp_fcv_trunc" DOUBLE  -- Driving Exp: FCV (trunc),
  "ev_home_charge" DOUBLE  -- EV: Home Charge,
  "ev_public_charging" DOUBLE  -- EV: Public Charging,
  "ev_charge_time" DOUBLE  -- EV: Charge Time,
  "ev_range" DOUBLE  -- EV: Range,
  "ev_purchase_price" DOUBLE  -- EV: Purchase Price,
  "ev_safety" DOUBLE  -- EV: Safety,
  "ev_reliability" DOUBLE  -- EV: Reliability,
  "ev_home_charge_trunc" DOUBLE  -- EV: Home Charge (trunc),
  "ev_public_charging_trunc" DOUBLE  -- EV: Public Charging (trunc),
  "ev_charge_time_trunc" DOUBLE  -- EV: Charge Time (trunc),
  "ev_range_trunc" DOUBLE  -- EV: Range (trunc),
  "ev_purchase_price_trunc" DOUBLE  -- EV: Purchase Price (trunc),
  "ev_safety_trunc" DOUBLE  -- EV: Safety (trunc),
  "ev_reliability_trunc" DOUBLE  -- EV: Reliability (trunc),
  "fcv_public_refueling" DOUBLE  -- FCV: Public Refueling,
  "fcv_fueling_time" DOUBLE  -- FCV: Fueling Time,
  "fcv_range" DOUBLE  -- FCV: Range,
  "fcv_purchase_price" DOUBLE  -- FCV: Purchase Price,
  "fcv_safety" DOUBLE  -- FCV: Safety,
  "fcv_reliability" DOUBLE  -- FCV: Reliability,
  "fcv_public_refueling_trunc" DOUBLE  -- FCV: Public Refueling (trunc),
  "fcv_fueling_time_trunc" DOUBLE  -- FCV: Fueling Time (trunc),
  "fcv_range_trunc" DOUBLE  -- FCV: Range (trunc),
  "fcv_purchase_price_trunc" DOUBLE  -- FCV: Purchase Price (trunc),
  "fcv_safety_trunc" DOUBLE  -- FCV: Safety (trunc),
  "fcv_reliabilty_trunc" DOUBLE  -- FCV: Reliabilty (trunc),
  "environmental_risk" DOUBLE,
  "environmental_risk_trunc" DOUBLE  -- Environmental Risk (trunc),
  "health_risk" DOUBLE,
  "health_risk_trunc" DOUBLE  -- Health Risk (trunc),
  "urgent_national_need" DOUBLE,
  "urgent_national_need_trunc" DOUBLE  -- Urgent National Need (trunc)
);

Md Zev Survey 12–07–20

@kaggle.thedevastator_california_residents_zev_attitudes.md_zev_survey_12_07_20
  • 286.66 kB
  • 396 rows
  • 194 columns
Loading... 
CREATE TABLE md_zev_survey_12_07_20 (
  "response_id" BIGINT  -- Response ID..,
  "no_trucks_plus_incentives_drivetrain_design_1" VARCHAR  -- No Trucks, Plus Incentives: Drivetrain Design 1,
  "no_trucks_plus_incentives_drivetrain_design_2" VARCHAR  -- No Trucks, Plus Incentives: Drivetrain Design 2,
  "no_trucks_plus_incentives_drivetrain_design_3" VARCHAR  -- No Trucks, Plus Incentives: Drivetrain Design 3,
  "no_trucks_plus_incentives_drivetrain_design_4" VARCHAR  -- No Trucks, Plus Incentives: Drivetrain Design 4,
  "no_trucks_plus_incentives_drivetrain_design" VARCHAR  -- No Trucks, Plus Incentives: Drivetrain Design,
  "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  -- Veh 1 Total Price, Don\u0027t Know,
  "fuel_economy_gasoline_diesel_ethanol" DOUBLE  -- Fuel Economy, Gasoline / Diesel / Ethanol,
  "fuel_economy_gasoline_diesel_ethanol_truncated" DOUBLE  -- Fuel Economy, Gasoline / Diesel / Ethanol Truncated,
  "fuel_economy_gasoline_diesel_ethanol_no_idea" DOUBLE  -- Fuel Economy, Gasoline / Diesel / Ethanol, No Idea,
  "distance" DOUBLE,
  "distance_week_month" VARCHAR,
  "respondent_s_vehicle_s_monthly_miles" DOUBLE  -- Respondent\u0027s Vehicle\u0027s Monthly Miles,
  "respondent_s_vehicle_s_monthly_miles_truncated" DOUBLE  -- Respondent\u0027s Vehicle\u0027s Monthly Miles Truncated,
  "fuel_spending" DOUBLE,
  "fuel_spending_week_month" VARCHAR,
  "respondent_s_car_fuel_spending_per_month" DOUBLE  -- Respondent\u0027s Car Fuel Spending Per Month,
  "respondent_s_car_fuel_spending_per_month_trunc" DOUBLE  -- Respondent\u0027s Car Fuel Spending Per Month (trunc),
  "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: 110,
  "home_park_220" VARCHAR  -- Home Park: 220,
  "home_park_evse" VARCHAR  -- Home Park: EVSE,
  "home_park_none" VARCHAR  -- Home Park: None,
  "home_park_don_t_know" VARCHAR  -- Home Park: Don\u0027t Know,
  "highest_home_pev_charging_access" VARCHAR,
  "electricy_install_authority" VARCHAR,
  "home_natural_gas" VARCHAR,
  "should_government_offer_incentives" VARCHAR,
  "replacement_electricity" VARCHAR  -- Replacement: Electricity,
  "replacement_hydrogen" VARCHAR  -- Replacement: Hydrogen,
  "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  -- Incentives: Federal,
  "base_body_size" VARCHAR,
  "base_body_size_2" VARCHAR,
  "familiarity_gasoline_vehicles" DOUBLE  -- Familiarity: Gasoline Vehicles,
  "familiarity_evs" DOUBLE  -- Familiarity: EVs,
  "familiarity_hevs" DOUBLE  -- Familiarity: HEVs,
  "familiarity_phevs" DOUBLE  -- Familiarity: PHEVs,
  "familiarity_fcvs" DOUBLE  -- Familiarity: FCVs,
  "familiarity_gasoline_vehicles_trunc" DOUBLE  -- Familiarity Gasoline Vehicles (trunc),
  "familiarity_evs_trunc" DOUBLE  -- Familiarity EVs (trunc),
  "familiarity_hevs_trunc" DOUBLE  -- Familiarity HEVs (trunc),
  "familiarity_phevs_trunc" DOUBLE  -- Familiarity PHEVs (trunc),
  "familiarity_fcvs_trunc" DOUBLE  -- Familiarity FCVs (trunc),
  "driving_exp_ev" DOUBLE  -- Driving Exp: EV,
  "driving_exp_hev" DOUBLE  -- Driving Exp: HEV,
  "driving_exp_phev" DOUBLE  -- Driving Exp: PHEV,
  "driving_exp_fcv" DOUBLE  -- Driving Exp: FCV,
  "driving_exp_ev_trunc" DOUBLE  -- Driving Exp: EV (trunc),
  "driving_exp_hev_trunc" DOUBLE  -- Driving Exp: HEV (trunc),
  "driving_exp_phev_trunc" DOUBLE  -- Driving Exp: PHEV (trunc),
  "driving_exp_fcv_trunc" DOUBLE  -- Driving Exp: FCV (trunc),
  "ev_home_charge" DOUBLE  -- EV: Home Charge,
  "ev_public_charging" DOUBLE  -- EV: Public Charging,
  "ev_charge_time" DOUBLE  -- EV: Charge Time,
  "ev_range" DOUBLE  -- EV: Range,
  "ev_purchase_price" DOUBLE  -- EV: Purchase Price,
  "ev_safety" DOUBLE  -- EV: Safety,
  "ev_reliability" DOUBLE  -- EV: Reliability,
  "ev_home_charge_trunc" DOUBLE  -- EV: Home Charge (trunc),
  "ev_public_charging_trunc" DOUBLE  -- EV: Public Charging (trunc),
  "ev_charge_time_trunc" DOUBLE  -- EV: Charge Time (trunc),
  "ev_range_trunc" DOUBLE  -- EV: Range (trunc),
  "ev_purchase_price_trunc" DOUBLE  -- EV: Purchase Price (trunc),
  "ev_safety_trunc" DOUBLE  -- EV: Safety (trunc),
  "ev_reliability_trunc" DOUBLE  -- EV: Reliability (trunc),
  "fcv_public_refueling" DOUBLE  -- FCV: Public Refueling,
  "fcv_fueling_time" DOUBLE  -- FCV: Fueling Time,
  "fcv_range" DOUBLE  -- FCV: Range,
  "fcv_purchase_price" DOUBLE  -- FCV: Purchase Price,
  "fcv_safety" DOUBLE  -- FCV: Safety,
  "fcv_reliability" DOUBLE  -- FCV: Reliability,
  "fcv_public_refueling_trunc" DOUBLE  -- FCV: Public Refueling (trunc),
  "fcv_fueling_time_trunc" DOUBLE  -- FCV: Fueling Time (trunc),
  "fcv_range_trunc" DOUBLE  -- FCV: Range (trunc),
  "fcv_purchase_price_trunc" DOUBLE  -- FCV: Purchase Price (trunc),
  "fcv_safety_trunc" DOUBLE  -- FCV: Safety (trunc),
  "fcv_reliabilty_trunc" DOUBLE  -- FCV: Reliabilty (trunc),
  "environmental_risk" DOUBLE,
  "environmental_risk_trunc" DOUBLE  -- Environmental Risk (trunc),
  "health_risk" DOUBLE,
  "health_risk_trunc" DOUBLE  -- Health Risk (trunc),
  "urgent_national_need" DOUBLE,
  "urgent_national_need_trunc" DOUBLE  -- Urgent National Need (trunc)
);

Nescaum Zev Survey 12–07–20

@kaggle.thedevastator_california_residents_zev_attitudes.nescaum_zev_survey_12_07_20
  • 782.14 kB
  • 2,393 rows
  • 196 columns
Loading... 
CREATE TABLE nescaum_zev_survey_12_07_20 (
  "response_id" BIGINT  -- Response ID..,
  "no_trucks_plus_incentives_drivetrain_design_1" VARCHAR  -- No Trucks, Plus Incentives: Drivetrain Design 1,
  "no_trucks_plus_incentives_drivetrain_design_2" VARCHAR  -- No Trucks, Plus Incentives: Drivetrain Design 2,
  "no_trucks_plus_incentives_drivetrain_design_3" VARCHAR  -- No Trucks, Plus Incentives: Drivetrain Design 3,
  "no_trucks_plus_incentives_drivetrain_design_4" VARCHAR  -- No Trucks, Plus Incentives: Drivetrain Design 4,
  "no_trucks_plus_incentives_drivetrain_design" VARCHAR  -- No Trucks, Plus Incentives: Drivetrain Design,
  "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  -- Veh 1 Total Price, Don\u0027t Know,
  "fuel_economy_gasoline_diesel_ethanol" DOUBLE  -- Fuel Economy, Gasoline / Diesel / Ethanol,
  "fuel_economy_gasoline_diesel_ethanol_truncated" DOUBLE  -- Fuel Economy, Gasoline / Diesel / Ethanol Truncated,
  "fuel_economy_gasoline_diesel_ethanol_no_idea" DOUBLE  -- Fuel Economy, Gasoline / Diesel / Ethanol, No Idea,
  "distance" DOUBLE,
  "distance_week_month" VARCHAR,
  "respondent_s_vehicle_s_monthly_miles" DOUBLE  -- Respondent\u0027s Vehicle\u0027s Monthly Miles,
  "respondent_s_vehicle_s_monthly_miles_truncated" DOUBLE  -- Respondent\u0027s Vehicle\u0027s Monthly Miles Truncated,
  "fuel_spending" DOUBLE,
  "fuel_spending_week_month" VARCHAR,
  "respondent_s_car_fuel_spending_per_month" DOUBLE  -- Respondent\u0027s Car Fuel Spending Per Month,
  "respondent_s_car_fuel_spending_per_month_trunc" DOUBLE  -- Respondent\u0027s Car Fuel Spending Per Month (trunc),
  "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: 110,
  "home_park_220" VARCHAR  -- Home Park: 220,
  "home_park_evse" VARCHAR  -- Home Park: EVSE,
  "home_park_none" VARCHAR  -- Home Park: None,
  "home_park_don_t_know" VARCHAR  -- Home Park: Don\u0027t Know,
  "highest_home_pev_charging_access" VARCHAR,
  "electricy_install_authority" VARCHAR,
  "home_natural_gas" VARCHAR,
  "should_government_offer_incentives" VARCHAR,
  "replacement_electricity" VARCHAR  -- Replacement: Electricity,
  "replacement_hydrogen" VARCHAR  -- Replacement: Hydrogen,
  "seen_public_evses" VARCHAR,
  "seen_public_evses_yes_no" VARCHAR,
  "personal_interest_in_zev_tech" VARCHAR,
  "personal_interest_in_zev_tech_trunc" VARCHAR  -- Personal Interest In ZEV Tech (trunc),
  "consider_an_ev" VARCHAR,
  "consider_an_ev_2" VARCHAR,
  "consider_an_fcv" VARCHAR,
  "consider_an_fcv_2" VARCHAR,
  "incentives_federal" VARCHAR  -- Incentives: Federal,
  "base_body_size" VARCHAR,
  "base_body_size_2" VARCHAR,
  "familiarity_gasoline_vehicles" DOUBLE  -- Familiarity: Gasoline Vehicles,
  "familiarity_evs" DOUBLE  -- Familiarity: EVs,
  "familiarity_hevs" DOUBLE  -- Familiarity: HEVs,
  "familiarity_phevs" DOUBLE  -- Familiarity: PHEVs,
  "familiarity_fcvs" DOUBLE  -- Familiarity: FCVs,
  "familiarity_gasoline_vehicles_trunc" DOUBLE  -- Familiarity Gasoline Vehicles (trunc),
  "familiarity_evs_trunc" DOUBLE  -- Familiarity EVs (trunc),
  "familiarity_hevs_trunc" DOUBLE  -- Familiarity HEVs (trunc),
  "familiarity_phevs_trunc" DOUBLE  -- Familiarity PHEVs (trunc),
  "familiarity_fcvs_trunc" DOUBLE  -- Familiarity FCVs (trunc),
  "driving_exp_ev" DOUBLE  -- Driving Exp: EV,
  "driving_exp_hev" DOUBLE  -- Driving Exp: HEV,
  "driving_exp_phev" DOUBLE  -- Driving Exp: PHEV,
  "driving_exp_fcv" DOUBLE  -- Driving Exp: FCV,
  "driving_exp_ev_trunc" DOUBLE  -- Driving Exp: EV (trunc),
  "driving_exp_hev_trunc" DOUBLE  -- Driving Exp: HEV (trunc),
  "driving_exp_phev_trunc" DOUBLE  -- Driving Exp: PHEV (trunc),
  "driving_exp_fcv_trunc" DOUBLE  -- Driving Exp: FCV (trunc),
  "ev_home_charge" DOUBLE  -- EV: Home Charge,
  "ev_public_charging" DOUBLE  -- EV: Public Charging,
  "ev_charge_time" DOUBLE  -- EV: Charge Time,
  "ev_range" DOUBLE  -- EV: Range,
  "ev_purchase_price" DOUBLE  -- EV: Purchase Price,
  "ev_safety" DOUBLE  -- EV: Safety,
  "ev_reliability" DOUBLE  -- EV: Reliability,
  "ev_home_charge_trunc" DOUBLE  -- EV: Home Charge (trunc),
  "ev_public_charging_trunc" DOUBLE  -- EV: Public Charging (trunc),
  "ev_charge_time_trunc" DOUBLE  -- EV: Charge Time (trunc),
  "ev_range_trunc" DOUBLE  -- EV: Range (trunc),
  "ev_purchase_price_trunc" DOUBLE  -- EV: Purchase Price (trunc),
  "ev_safety_trunc" DOUBLE  -- EV: Safety (trunc),
  "ev_reliability_trunc" DOUBLE  -- EV: Reliability (trunc),
  "inverse_ev_home_charge_trunc" DOUBLE  -- Inverse EV: Home Charge (trunc),
  "inverse_ev_public_charging_trunc" DOUBLE  -- Inverse EV: Public Charging (trunc),
  "fcv_public_refueling" DOUBLE  -- FCV: Public Refueling,
  "fcv_fueling_time" DOUBLE  -- FCV: Fueling Time,
  "fcv_range" DOUBLE  -- FCV: Range,
  "fcv_purchase_price" DOUBLE  -- FCV: Purchase Price,
  "fcv_safety" DOUBLE  -- FCV: Safety,
  "fcv_reliability" DOUBLE  -- FCV: Reliability,
  "fcv_public_refueling_trunc" DOUBLE  -- FCV: Public Refueling (trunc),
  "fcv_fueling_time_trunc" DOUBLE  -- FCV: Fueling Time (trunc),
  "fcv_range_trunc" DOUBLE  -- FCV: Range (trunc),
  "fcv_purchase_price_trunc" DOUBLE  -- FCV: Purchase Price (trunc),
  "fcv_safety_trunc" DOUBLE  -- FCV: Safety (trunc),
  "fcv_reliabilty_trunc" DOUBLE  -- FCV: Reliabilty (trunc),
  "inverse_fcv_public_refueling_trunc" DOUBLE  -- Inverse FCV: Public Refueling (trunc),
  "environmental_risk" DOUBLE,
  "environmental_risk_trunc" DOUBLE  -- Environmental Risk (trunc)
);

Nj Zev Survey 12–07–20

@kaggle.thedevastator_california_residents_zev_attitudes.nj_zev_survey_12_07_20
  • 308.39 kB
  • 495 rows
  • 191 columns
Loading... 
CREATE TABLE nj_zev_survey_12_07_20 (
  "response_id" BIGINT  -- Response ID..,
  "no_trucks_plus_incentives_drivetrain_design_1" VARCHAR  -- No Trucks, Plus Incentives: Drivetrain Design 1,
  "no_trucks_plus_incentives_drivetrain_design_2" VARCHAR  -- No Trucks, Plus Incentives: Drivetrain Design 2,
  "no_trucks_plus_incentives_drivetrain_design_3" VARCHAR  -- No Trucks, Plus Incentives: Drivetrain Design 3,
  "no_trucks_plus_incentives_drivetrain_design_4" VARCHAR  -- No Trucks, Plus Incentives: Drivetrain Design 4,
  "no_trucks_plus_incentives_drivetrain_design" VARCHAR  -- No Trucks, Plus Incentives: Drivetrain Design,
  "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  -- Veh 1 Total Price, Don\u0027t Know,
  "fuel_economy_gasoline_diesel_ethanol_no_idea" DOUBLE  -- Fuel Economy, Gasoline / Diesel / Ethanol, No Idea,
  "distance" DOUBLE,
  "distance_week_month" VARCHAR,
  "respondent_s_vehicle_s_monthly_miles" DOUBLE  -- Respondent\u0027s Vehicle\u0027s Monthly Miles,
  "respondent_s_vehicle_s_monthly_miles_truncated" DOUBLE  -- Respondent\u0027s Vehicle\u0027s Monthly Miles Truncated,
  "fuel_spending" DOUBLE,
  "fuel_spending_week_month" VARCHAR,
  "respondent_s_car_fuel_spending_per_month" DOUBLE  -- Respondent\u0027s Car Fuel Spending Per Month,
  "respondent_s_car_fuel_spending_per_month_trunc" DOUBLE  -- Respondent\u0027s Car Fuel Spending Per Month (trunc),
  "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: 110,
  "home_park_220" VARCHAR  -- Home Park: 220,
  "home_park_evse" VARCHAR  -- Home Park: EVSE,
  "home_park_none" VARCHAR  -- Home Park: None,
  "home_park_don_t_know" VARCHAR  -- Home Park: Don\u0027t Know,
  "highest_home_pev_charging_access" VARCHAR,
  "electricy_install_authority" VARCHAR,
  "home_natural_gas" VARCHAR,
  "should_government_offer_incentives" VARCHAR,
  "replacement_electricity" VARCHAR  -- Replacement: Electricity,
  "replacement_hydrogen" VARCHAR  -- Replacement: Hydrogen,
  "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  -- Incentives: Federal,
  "base_body_size" VARCHAR,
  "base_body_size_2" VARCHAR,
  "familiarity_gasoline_vehicles" DOUBLE  -- Familiarity: Gasoline Vehicles,
  "familiarity_evs" DOUBLE  -- Familiarity: EVs,
  "familiarity_hevs" DOUBLE  -- Familiarity: HEVs,
  "familiarity_phevs" DOUBLE  -- Familiarity: PHEVs,
  "familiarity_fcvs" DOUBLE  -- Familiarity: FCVs,
  "familiarity_gasoline_vehicles_trunc" DOUBLE  -- Familiarity Gasoline Vehicles (trunc),
  "familiarity_evs_trunc" DOUBLE  -- Familiarity EVs (trunc),
  "familiarity_hevs_trunc" DOUBLE  -- Familiarity HEVs (trunc),
  "familiarity_phevs_trunc" DOUBLE  -- Familiarity PHEVs (trunc),
  "familiarity_fcvs_trunc" DOUBLE  -- Familiarity FCVs (trunc),
  "driving_exp_ev" DOUBLE  -- Driving Exp: EV,
  "driving_exp_hev" DOUBLE  -- Driving Exp: HEV,
  "driving_exp_phev" DOUBLE  -- Driving Exp: PHEV,
  "driving_exp_fcv" DOUBLE  -- Driving Exp: FCV,
  "driving_exp_ev_trunc" DOUBLE  -- Driving Exp: EV (trunc),
  "driving_exp_hev_trunc" DOUBLE  -- Driving Exp: HEV (trunc),
  "driving_exp_phev_trunc" DOUBLE  -- Driving Exp: PHEV (trunc),
  "driving_exp_fcv_trunc" DOUBLE  -- Driving Exp: FCV (trunc),
  "ev_home_charge" DOUBLE  -- EV: Home Charge,
  "ev_public_charging" DOUBLE  -- EV: Public Charging,
  "ev_charge_time" DOUBLE  -- EV: Charge Time,
  "ev_range" DOUBLE  -- EV: Range,
  "ev_purchase_price" DOUBLE  -- EV: Purchase Price,
  "ev_safety" DOUBLE  -- EV: Safety,
  "ev_reliability" DOUBLE  -- EV: Reliability,
  "ev_home_charge_trunc" DOUBLE  -- EV: Home Charge (trunc),
  "ev_public_charging_trunc" DOUBLE  -- EV: Public Charging (trunc),
  "ev_charge_time_trunc" DOUBLE  -- EV: Charge Time (trunc),
  "ev_range_trunc" DOUBLE  -- EV: Range (trunc),
  "ev_purchase_price_trunc" DOUBLE  -- EV: Purchase Price (trunc),
  "ev_safety_trunc" DOUBLE  -- EV: Safety (trunc),
  "ev_reliability_trunc" DOUBLE  -- EV: Reliability (trunc),
  "fcv_public_refueling" DOUBLE  -- FCV: Public Refueling,
  "fcv_fueling_time" DOUBLE  -- FCV: Fueling Time,
  "fcv_range" DOUBLE  -- FCV: Range,
  "fcv_purchase_price" DOUBLE  -- FCV: Purchase Price,
  "fcv_safety" DOUBLE  -- FCV: Safety,
  "fcv_reliability" DOUBLE  -- FCV: Reliability,
  "fcv_public_refueling_trunc" DOUBLE  -- FCV: Public Refueling (trunc),
  "fcv_fueling_time_trunc" DOUBLE  -- FCV: Fueling Time (trunc),
  "fcv_range_trunc" DOUBLE  -- FCV: Range (trunc),
  "fcv_purchase_price_trunc" DOUBLE  -- FCV: Purchase Price (trunc),
  "fcv_safety_trunc" DOUBLE  -- FCV: Safety (trunc),
  "fcv_reliabilty_trunc" DOUBLE  -- FCV: Reliabilty (trunc),
  "environmental_risk" DOUBLE,
  "environmental_risk_trunc" DOUBLE  -- Environmental Risk (trunc),
  "health_risk" DOUBLE,
  "health_risk_trunc" DOUBLE  -- Health Risk (trunc),
  "urgent_national_need" DOUBLE,
  "urgent_national_need_trunc" DOUBLE  -- Urgent National Need (trunc),
  "market_provides_incentives" DOUBLE,
  "market_incentives_trunc" DOUBLE  -- Market Incentives (trunc)
);

Ny Zev Survey 12–07–20

@kaggle.thedevastator_california_residents_zev_attitudes.ny_zev_survey_12_07_20
  • 441.27 kB
  • 997 rows
  • 200 columns
Loading... 
CREATE TABLE ny_zev_survey_12_07_20 (
  "response_id" BIGINT  -- Response ID..,
  "no_trucks_plus_incentives_drivetrain_design_1" VARCHAR  -- No Trucks, Plus Incentives: Drivetrain Design 1,
  "no_trucks_plus_incentives_drivetrain_design_2" VARCHAR  -- No Trucks, Plus Incentives: Drivetrain Design 2,
  "no_trucks_plus_incentives_drivetrain_design_3" VARCHAR  -- No Trucks, Plus Incentives: Drivetrain Design 3,
  "no_trucks_plus_incentives_drivetrain_design_4" VARCHAR  -- No Trucks, Plus Incentives: Drivetrain Design 4,
  "no_trucks_plus_incentives_drivetrain_design" VARCHAR  -- No Trucks, Plus Incentives: Drivetrain Design,
  "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  -- Veh 1 Total Price, Don\u0027t Know,
  "fuel_economy_gasoline_diesel_ethanol" DOUBLE  -- Fuel Economy, Gasoline / Diesel / Ethanol,
  "fuel_economy_gasoline_diesel_ethanol_truncated" DOUBLE  -- Fuel Economy, Gasoline / Diesel / Ethanol Truncated,
  "fuel_economy_gasoline_diesel_ethanol_no_idea" DOUBLE  -- Fuel Economy, Gasoline / Diesel / Ethanol, No Idea,
  "distance" DOUBLE,
  "distance_week_month" VARCHAR,
  "respondent_s_vehicle_s_monthly_miles" DOUBLE  -- Respondent\u0027s Vehicle\u0027s Monthly Miles,
  "respondent_s_vehicle_s_monthly_miles_truncated" DOUBLE  -- Respondent\u0027s Vehicle\u0027s Monthly Miles Truncated,
  "fuel_spending" DOUBLE,
  "fuel_spending_week_month" VARCHAR,
  "respondent_s_car_fuel_spending_per_month" DOUBLE  -- Respondent\u0027s Car Fuel Spending Per Month,
  "respondent_s_car_fuel_spending_per_month_trunc" DOUBLE  -- Respondent\u0027s Car Fuel Spending Per Month (trunc),
  "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: 110,
  "home_park_220" VARCHAR  -- Home Park: 220,
  "home_park_evse" VARCHAR  -- Home Park: EVSE,
  "home_park_none" VARCHAR  -- Home Park: None,
  "home_park_don_t_know" VARCHAR  -- Home Park: Don\u0027t Know,
  "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: Electricity,
  "replacement_hydrogen" VARCHAR  -- Replacement: Hydrogen,
  "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  -- Incentives: Federal,
  "base_body_size" VARCHAR,
  "base_body_size_2" VARCHAR,
  "rbase_body_size" VARCHAR,
  "familiarity_gasoline_vehicles" DOUBLE  -- Familiarity: Gasoline Vehicles,
  "familiarity_evs" DOUBLE  -- Familiarity: EVs,
  "familiarity_hevs" DOUBLE  -- Familiarity: HEVs,
  "familiarity_phevs" DOUBLE  -- Familiarity: PHEVs,
  "familiarity_fcvs" DOUBLE  -- Familiarity: FCVs,
  "familiarity_gasoline_vehicles_trunc" DOUBLE  -- Familiarity Gasoline Vehicles (trunc),
  "familiarity_evs_trunc" DOUBLE  -- Familiarity EVs (trunc),
  "familiarity_hevs_trunc" DOUBLE  -- Familiarity HEVs (trunc),
  "familiarity_phevs_trunc" DOUBLE  -- Familiarity PHEVs (trunc),
  "familiarity_fcvs_trunc" DOUBLE  -- Familiarity FCVs (trunc),
  "driving_exp_ev" DOUBLE  -- Driving Exp: EV,
  "driving_exp_hev" DOUBLE  -- Driving Exp: HEV,
  "driving_exp_phev" DOUBLE  -- Driving Exp: PHEV,
  "driving_exp_fcv" DOUBLE  -- Driving Exp: FCV,
  "driving_exp_ev_trunc" DOUBLE  -- Driving Exp: EV (trunc),
  "driving_exp_hev_trunc" DOUBLE  -- Driving Exp: HEV (trunc),
  "driving_exp_phev_trunc" DOUBLE  -- Driving Exp: PHEV (trunc),
  "driving_exp_fcv_trunc" DOUBLE  -- Driving Exp: FCV (trunc),
  "ev_home_charge" DOUBLE  -- EV: Home Charge,
  "ev_public_charging" DOUBLE  -- EV: Public Charging,
  "ev_charge_time" DOUBLE  -- EV: Charge Time,
  "ev_range" DOUBLE  -- EV: Range,
  "ev_purchase_price" DOUBLE  -- EV: Purchase Price,
  "ev_safety" DOUBLE  -- EV: Safety,
  "ev_reliability" DOUBLE  -- EV: Reliability,
  "ev_home_charge_trunc" DOUBLE  -- EV: Home Charge (trunc),
  "ev_public_charging_trunc" DOUBLE  -- EV: Public Charging (trunc),
  "ev_charge_time_trunc" DOUBLE  -- EV: Charge Time (trunc),
  "ev_range_trunc" DOUBLE  -- EV: Range (trunc),
  "ev_purchase_price_trunc" DOUBLE  -- EV: Purchase Price (trunc),
  "ev_safety_trunc" DOUBLE  -- EV: Safety (trunc),
  "ev_reliability_trunc" DOUBLE  -- EV: Reliability (trunc),
  "fcv_public_refueling" DOUBLE  -- FCV: Public Refueling,
  "fcv_fueling_time" DOUBLE  -- FCV: Fueling Time,
  "fcv_range" DOUBLE  -- FCV: Range,
  "fcv_purchase_price" DOUBLE  -- FCV: Purchase Price,
  "fcv_safety" DOUBLE  -- FCV: Safety,
  "fcv_reliability" DOUBLE  -- FCV: Reliability,
  "fcv_public_refueling_trunc" DOUBLE  -- FCV: Public Refueling (trunc),
  "fcv_fueling_time_trunc" DOUBLE  -- FCV: Fueling Time (trunc),
  "fcv_range_trunc" DOUBLE  -- FCV: Range (trunc)
);

Or Zev Survey 12–07–20

@kaggle.thedevastator_california_residents_zev_attitudes.or_zev_survey_12_07_20
  • 310.24 kB
  • 494 rows
  • 194 columns
Loading... 
CREATE TABLE or_zev_survey_12_07_20 (
  "response_id" BIGINT  -- Response ID..,
  "no_trucks_plus_incentives_drivetrain_design_1" VARCHAR  -- No Trucks, Plus Incentives: Drivetrain Design 1,
  "no_trucks_plus_incentives_drivetrain_design_2" VARCHAR  -- No Trucks, Plus Incentives: Drivetrain Design 2,
  "no_trucks_plus_incentives_drivetrain_design_3" VARCHAR  -- No Trucks, Plus Incentives: Drivetrain Design 3,
  "no_trucks_plus_incentives_drivetrain_design_4" VARCHAR  -- No Trucks, Plus Incentives: Drivetrain Design 4,
  "no_trucks_plus_incentives_drivetrain_design" VARCHAR  -- No Trucks, Plus Incentives: Drivetrain Design,
  "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  -- Veh 1 Total Price, Don\u0027t Know,
  "fuel_economy_gasoline_diesel_ethanol" DOUBLE  -- Fuel Economy, Gasoline / Diesel / Ethanol,
  "fuel_economy_gasoline_diesel_ethanol_truncated" DOUBLE  -- Fuel Economy, Gasoline / Diesel / Ethanol Truncated,
  "fuel_economy_gasoline_diesel_ethanol_no_idea" DOUBLE  -- Fuel Economy, Gasoline / Diesel / Ethanol, No Idea,
  "distance" DOUBLE,
  "distance_week_month" VARCHAR,
  "respondent_s_vehicle_s_monthly_miles" DOUBLE  -- Respondent\u0027s Vehicle\u0027s Monthly Miles,
  "respondent_s_vehicle_s_monthly_miles_truncated" DOUBLE  -- Respondent\u0027s Vehicle\u0027s Monthly Miles Truncated,
  "fuel_spending" DOUBLE,
  "fuel_spending_week_month" VARCHAR,
  "respondent_s_car_fuel_spending_per_month" DOUBLE  -- Respondent\u0027s Car Fuel Spending Per Month,
  "respondent_s_car_fuel_spending_per_month_trunc" DOUBLE  -- Respondent\u0027s Car Fuel Spending Per Month (trunc),
  "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: 110,
  "home_park_220" VARCHAR  -- Home Park: 220,
  "home_park_evse" VARCHAR  -- Home Park: EVSE,
  "home_park_none" VARCHAR  -- Home Park: None,
  "home_park_don_t_know" VARCHAR  -- Home Park: Don\u0027t Know,
  "highest_home_pev_charging_access" VARCHAR,
  "electricy_install_authority" VARCHAR,
  "home_natural_gas" VARCHAR,
  "should_government_offer_incentives" VARCHAR,
  "replacement_electricity" VARCHAR  -- Replacement: Electricity,
  "replacement_hydrogen" VARCHAR  -- Replacement: Hydrogen,
  "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  -- Incentives: Federal,
  "base_body_size" VARCHAR,
  "base_body_size_2" VARCHAR,
  "familiarity_gasoline_vehicles" DOUBLE  -- Familiarity: Gasoline Vehicles,
  "familiarity_evs" DOUBLE  -- Familiarity: EVs,
  "familiarity_hevs" DOUBLE  -- Familiarity: HEVs,
  "familiarity_phevs" DOUBLE  -- Familiarity: PHEVs,
  "familiarity_fcvs" DOUBLE  -- Familiarity: FCVs,
  "familiarity_gasoline_vehicles_trunc" DOUBLE  -- Familiarity Gasoline Vehicles (trunc),
  "familiarity_evs_trunc" DOUBLE  -- Familiarity EVs (trunc),
  "familiarity_hevs_trunc" DOUBLE  -- Familiarity HEVs (trunc),
  "familiarity_phevs_trunc" DOUBLE  -- Familiarity PHEVs (trunc),
  "familiarity_fcvs_trunc" DOUBLE  -- Familiarity FCVs (trunc),
  "driving_exp_ev" DOUBLE  -- Driving Exp: EV,
  "driving_exp_hev" DOUBLE  -- Driving Exp: HEV,
  "driving_exp_phev" DOUBLE  -- Driving Exp: PHEV,
  "driving_exp_fcv" DOUBLE  -- Driving Exp: FCV,
  "driving_exp_ev_trunc" DOUBLE  -- Driving Exp: EV (trunc),
  "driving_exp_hev_trunc" DOUBLE  -- Driving Exp: HEV (trunc),
  "driving_exp_phev_trunc" DOUBLE  -- Driving Exp: PHEV (trunc),
  "driving_exp_fcv_trunc" DOUBLE  -- Driving Exp: FCV (trunc),
  "ev_home_charge" DOUBLE  -- EV: Home Charge,
  "ev_public_charging" DOUBLE  -- EV: Public Charging,
  "ev_charge_time" DOUBLE  -- EV: Charge Time,
  "ev_range" DOUBLE  -- EV: Range,
  "ev_purchase_price" DOUBLE  -- EV: Purchase Price,
  "ev_safety" DOUBLE  -- EV: Safety,
  "ev_reliability" DOUBLE  -- EV: Reliability,
  "ev_home_charge_trunc" DOUBLE  -- EV: Home Charge (trunc),
  "ev_public_charging_trunc" DOUBLE  -- EV: Public Charging (trunc),
  "ev_charge_time_trunc" DOUBLE  -- EV: Charge Time (trunc),
  "ev_range_trunc" DOUBLE  -- EV: Range (trunc),
  "ev_purchase_price_trunc" DOUBLE  -- EV: Purchase Price (trunc),
  "ev_safety_trunc" DOUBLE  -- EV: Safety (trunc),
  "ev_reliability_trunc" DOUBLE  -- EV: Reliability (trunc),
  "fcv_public_refueling" DOUBLE  -- FCV: Public Refueling,
  "fcv_fueling_time" DOUBLE  -- FCV: Fueling Time,
  "fcv_range" DOUBLE  -- FCV: Range,
  "fcv_purchase_price" DOUBLE  -- FCV: Purchase Price,
  "fcv_safety" DOUBLE  -- FCV: Safety,
  "fcv_reliability" DOUBLE  -- FCV: Reliability,
  "fcv_public_refueling_trunc" DOUBLE  -- FCV: Public Refueling (trunc),
  "fcv_fueling_time_trunc" DOUBLE  -- FCV: Fueling Time (trunc),
  "fcv_range_trunc" DOUBLE  -- FCV: Range (trunc),
  "fcv_purchase_price_trunc" DOUBLE  -- FCV: Purchase Price (trunc),
  "fcv_safety_trunc" DOUBLE  -- FCV: Safety (trunc),
  "fcv_reliabilty_trunc" DOUBLE  -- FCV: Reliabilty (trunc),
  "environmental_risk" DOUBLE,
  "environmental_risk_trunc" DOUBLE  -- Environmental Risk (trunc),
  "health_risk" DOUBLE,
  "health_risk_trunc" DOUBLE  -- Health Risk (trunc)
);

Wa Zev Survey 12–07–20

@kaggle.thedevastator_california_residents_zev_attitudes.wa_zev_survey_12_07_20
  • 317.33 kB
  • 497 rows
  • 194 columns
Loading... 
CREATE TABLE wa_zev_survey_12_07_20 (
  "response_id" BIGINT  -- Response ID..,
  "no_trucks_plus_incentives_drivetrain_design_1" VARCHAR  -- No Trucks, Plus Incentives: Drivetrain Design 1,
  "no_trucks_plus_incentives_drivetrain_design_2" VARCHAR  -- No Trucks, Plus Incentives: Drivetrain Design 2,
  "no_trucks_plus_incentives_drivetrain_design_3" VARCHAR  -- No Trucks, Plus Incentives: Drivetrain Design 3,
  "no_trucks_plus_incentives_drivetrain_design_4" VARCHAR  -- No Trucks, Plus Incentives: Drivetrain Design 4,
  "no_trucks_plus_incentives_drivetrain_design" VARCHAR  -- No Trucks, Plus Incentives: Drivetrain Design,
  "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  -- Veh 1 Total Price, Don\u0027t Know,
  "fuel_economy_gasoline_diesel_ethanol" DOUBLE  -- Fuel Economy, Gasoline / Diesel / Ethanol,
  "fuel_economy_gasoline_diesel_ethanol_truncated" DOUBLE  -- Fuel Economy, Gasoline / Diesel / Ethanol Truncated,
  "fuel_economy_gasoline_diesel_ethanol_no_idea" DOUBLE  -- Fuel Economy, Gasoline / Diesel / Ethanol, No Idea,
  "distance" DOUBLE,
  "distance_week_month" VARCHAR,
  "respondent_s_vehicle_s_monthly_miles" DOUBLE  -- Respondent\u0027s Vehicle\u0027s Monthly Miles,
  "respondent_s_vehicle_s_monthly_miles_truncated" DOUBLE  -- Respondent\u0027s Vehicle\u0027s Monthly Miles Truncated,
  "fuel_spending" DOUBLE,
  "fuel_spending_week_month" VARCHAR,
  "respondent_s_car_fuel_spending_per_month" DOUBLE  -- Respondent\u0027s Car Fuel Spending Per Month,
  "respondent_s_car_fuel_spending_per_month_trunc" DOUBLE  -- Respondent\u0027s Car Fuel Spending Per Month (trunc),
  "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: 110,
  "home_park_220" VARCHAR  -- Home Park: 220,
  "home_park_evse" VARCHAR  -- Home Park: EVSE,
  "home_park_none" VARCHAR  -- Home Park: None,
  "home_park_don_t_know" VARCHAR  -- Home Park: Don\u0027t Know,
  "highest_home_pev_charging_access" VARCHAR,
  "electricy_install_authority" VARCHAR,
  "home_natural_gas" VARCHAR,
  "should_government_offer_incentives" VARCHAR,
  "replacement_electricity" VARCHAR  -- Replacement: Electricity,
  "replacement_hydrogen" VARCHAR  -- Replacement: Hydrogen,
  "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  -- Incentives: Federal,
  "base_body_size" VARCHAR,
  "base_body_size_2" VARCHAR,
  "base_body_size_3" VARCHAR,
  "familiarity_gasoline_vehicles" DOUBLE  -- Familiarity: Gasoline Vehicles,
  "familiarity_evs" DOUBLE  -- Familiarity: EVs,
  "familiarity_hevs" DOUBLE  -- Familiarity: HEVs,
  "familiarity_phevs" DOUBLE  -- Familiarity: PHEVs,
  "familiarity_fcvs" DOUBLE  -- Familiarity: FCVs,
  "familiarity_gasoline_vehicles_trunc" DOUBLE  -- Familiarity Gasoline Vehicles (trunc),
  "familiarity_evs_trunc" DOUBLE  -- Familiarity EVs (trunc),
  "familiarity_hevs_trunc" DOUBLE  -- Familiarity HEVs (trunc),
  "familiarity_phevs_trunc" DOUBLE  -- Familiarity PHEVs (trunc),
  "familiarity_fcvs_trunc" DOUBLE  -- Familiarity FCVs (trunc),
  "driving_exp_ev" DOUBLE  -- Driving Exp: EV,
  "driving_exp_hev" DOUBLE  -- Driving Exp: HEV,
  "driving_exp_phev" DOUBLE  -- Driving Exp: PHEV,
  "driving_exp_fcv" DOUBLE  -- Driving Exp: FCV,
  "driving_exp_bev_trunc" DOUBLE  -- Driving Exp: BEV (trunc),
  "driving_exp_hev_trunc" DOUBLE  -- Driving Exp: HEV (trunc),
  "driving_exp_phev_trunc" DOUBLE  -- Driving Exp: PHEV (trunc),
  "driving_exp_fcev_trunc" DOUBLE  -- Driving Exp: FCEV (trunc),
  "ev_home_charge" DOUBLE  -- EV: Home Charge,
  "ev_public_charging" DOUBLE  -- EV: Public Charging,
  "ev_charge_time" DOUBLE  -- EV: Charge Time,
  "ev_range" DOUBLE  -- EV: Range,
  "ev_purchase_price" DOUBLE  -- EV: Purchase Price,
  "ev_safety" DOUBLE  -- EV: Safety,
  "ev_reliability" DOUBLE  -- EV: Reliability,
  "ev_home_charge_trunc" DOUBLE  -- EV: Home Charge (trunc),
  "ev_public_charging_trunc" DOUBLE  -- EV: Public Charging (trunc),
  "ev_charge_time_trunc" DOUBLE  -- EV: Charge Time (trunc),
  "ev_range_trunc" DOUBLE  -- EV: Range (trunc),
  "ev_purchase_price_trunc" DOUBLE  -- EV: Purchase Price (trunc),
  "ev_safety_trunc" DOUBLE  -- EV: Safety (trunc),
  "ev_reliability_trunc" DOUBLE  -- EV: Reliability (trunc),
  "fcv_public_refueling" DOUBLE  -- FCV: Public Refueling,
  "fcv_fueling_time" DOUBLE  -- FCV: Fueling Time,
  "fcv_range" DOUBLE  -- FCV: Range,
  "fcv_purchase_price" DOUBLE  -- FCV: Purchase Price,
  "fcv_safety" DOUBLE  -- FCV: Safety,
  "fcv_reliability" DOUBLE  -- FCV: Reliability,
  "fcv_public_refueling_trunc" DOUBLE  -- FCV: Public Refueling (trunc),
  "fcv_fueling_time_trunc" DOUBLE  -- FCV: Fueling Time (trunc),
  "fcv_range_trunc" DOUBLE  -- FCV: Range (trunc),
  "fcv_purchase_price_trunc" DOUBLE  -- FCV: Purchase Price (trunc),
  "fcv_safety_trunc" DOUBLE  -- FCV: Safety (trunc),
  "fcv_reliabilty_trunc" DOUBLE  -- FCV: Reliabilty (trunc),
  "environmental_risk" DOUBLE,
  "environmental_risk_trunc" DOUBLE  -- Environmental Risk (trunc),
  "health_risk" DOUBLE,
  "health_risk_trunc" DOUBLE  -- Health Risk (trunc),
  "urgent_national_need" DOUBLE
);

Share link

Anyone who has the link will be able to view this.