Baselight

Electric Vehicle Charging Stations

Find electric vehicle charging stations in the United States and Canada.

@kaggle.prasertk_electric_vehicle_charging_stations_in_usa

Loading...
Loading...

About this Dataset

Electric Vehicle Charging Stations

Context

Find electric vehicle charging stations in the United States and Canada.

Acknowledgements

Data source: https://developer.nrel.gov/docs/transportation/alt-fuel-stations-v1/all/#request-url

Cover image credit: https://www.pexels.com/photo/sea-water-summer-industry-9799997/

Tables

Ev Stations V1

@kaggle.prasertk_electric_vehicle_charging_stations_in_usa.ev_stations_v1
  • 3.28 MB
  • 50289 rows
  • 65 columns
Loading...

CREATE TABLE ev_stations_v1 (
  "fuel_type_code" VARCHAR,
  "station_name" VARCHAR,
  "street_address" VARCHAR,
  "intersection_directions" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip" VARCHAR,
  "plus4" VARCHAR,
  "station_phone" VARCHAR,
  "status_code" VARCHAR,
  "expected_date" TIMESTAMP,
  "groups_with_access_code" VARCHAR,
  "access_days_time" VARCHAR,
  "cards_accepted" VARCHAR,
  "bd_blends" VARCHAR,
  "ng_fill_type_code" VARCHAR,
  "ng_psi" VARCHAR,
  "ev_level1_evse_num" DOUBLE,
  "ev_level2_evse_num" DOUBLE,
  "ev_dc_fast_count" DOUBLE,
  "ev_other_info" VARCHAR,
  "ev_network" VARCHAR,
  "ev_network_web" VARCHAR,
  "geocode_status" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "date_last_confirmed" TIMESTAMP,
  "id" BIGINT,
  "updated_at" VARCHAR,
  "owner_type_code" VARCHAR,
  "federal_agency_id" DOUBLE,
  "federal_agency_name" VARCHAR,
  "open_date" TIMESTAMP,
  "hydrogen_status_link" VARCHAR,
  "ng_vehicle_class" VARCHAR,
  "lpg_primary" VARCHAR,
  "e85_blender_pump" VARCHAR,
  "ev_connector_types" VARCHAR,
  "country" VARCHAR,
  "intersection_directions_french" VARCHAR,
  "access_days_time_french" VARCHAR,
  "bd_blends_french" VARCHAR,
  "groups_with_access_code_french" VARCHAR,
  "hydrogen_is_retail" VARCHAR,
  "access_code" VARCHAR,
  "access_detail_code" VARCHAR,
  "federal_agency_code" VARCHAR,
  "facility_type" VARCHAR,
  "cng_dispenser_num" VARCHAR,
  "cng_on_site_renewable_source" VARCHAR,
  "cng_total_compression_capacity" VARCHAR,
  "cng_storage_capacity" VARCHAR,
  "lng_on_site_renewable_source" VARCHAR,
  "e85_other_ethanol_blends" VARCHAR,
  "ev_pricing" VARCHAR,
  "ev_pricing_french" VARCHAR,
  "lpg_nozzle_types" VARCHAR,
  "hydrogen_pressures" VARCHAR,
  "hydrogen_standards" VARCHAR,
  "cng_fill_type_code" VARCHAR,
  "cng_psi" VARCHAR,
  "cng_vehicle_class" VARCHAR,
  "lng_vehicle_class" VARCHAR,
  "ev_on_site_renewable_source" VARCHAR,
  "restricted_access" VARCHAR
);

Share link

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