Electric Vehicle Charging Stations

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

@kaggle.prasertk_electric_vehicle_charging_stations_in_usa

Table List

1 table(3.28 MB)

Ev Stations V1

@kaggle.prasertk_electric_vehicle_charging_stations_in_usa.ev_stations_v1

3.28 MB
50289 rows
65 columns

fuel_type_code Fuel Type Code	station_name Station Name	street_address Street Address	intersection_directions Intersection Directions	city City	state State	zip ZIP	station_phone Station Phone	status_code Status Code	groups_with_access_code Groups With Access Code	access_days_time Access Days Time	cards_accepted Cards Accepted	ev_level2_evse_num EV Level2 EVSE Num	ev_dc_fast_count EV DC Fast Count	ev_other_info EV Other Info	ev_network EV Network	ev_network_web EV Network Web	geocode_status Geocode Status	latitude Latitude	longitude Longitude	date_last_confirmed Date Last Confirmed	id ID	updated_at Updated At	owner_type_code Owner Type Code	federal_agency_name Federal Agency Name	open_date Open Date	ev_connector_types EV Connector Types	country Country	groups_with_access_code_french Groups With Access Code (French)	access_code Access Code	access_detail_code Access Detail Code	federal_agency_code Federal Agency Code	facility_type Facility Type	ev_pricing EV Pricing	ev_on_site_renewable_source EV On-Site Renewable Source
ELEC	LADWP - Truesdale Center	11797 Truesdale St	nan	Sun Valley	CA	91352	nan	E	Private	Fleet use only	nan	39	3	nan	Non-Networked	nan	GPS	34.2483191527193	-118.3879713743439	Wed Jul 14 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	1517	2021-07-14 18:51:43 UTC	LG	nan	Fri Oct 15 1999 00:00:00 GMT+0000 (Coordinated Universal Time)	CHADEMO J1772 J1772COMBO	US	Privé	private	nan	nan	UTILITY	nan	nan
ELEC	LADWP - West LA District Office	1394 S Sepulveda Blvd	nan	Los Angeles	CA	90024	nan	E	Private	nan	nan	4		nan	Non-Networked	nan	200-8	34.052542	-118.448504	Wed Jul 14 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	1519	2021-07-14 18:51:43 UTC	LG	nan	Fri Feb 28 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	J1772	US	Privé	private	nan	nan	UTILITY	Free	nan
ELEC	Los Angeles Convention Center	1201 S Figueroa St	West hall and South hall	Los Angeles	CA	90015	213-741-1151	E	Public	24 hours daily; pay lot	nan	12		nan	Non-Networked	nan	GPS	34.040539	-118.271387	Mon Nov 09 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	1523	2021-03-11 23:22:17 UTC	P	nan	Wed Aug 30 1995 00:00:00 GMT+0000 (Coordinated Universal Time)	J1772	US	Public	public	nan	nan	PARKING_GARAGE	nan	nan
ELEC	LADWP - John Ferraro Building	111 N Hope St	Across Hope	Los Angeles	CA	90012	nan	E	Private	For fleet and employee use only	nan	311	2	nan	Non-Networked	nan	GPS	34.059133	-118.248589	Wed Jul 14 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	1525	2021-07-14 18:51:43 UTC	LG	nan	Fri Oct 15 1999 00:00:00 GMT+0000 (Coordinated Universal Time)	CHADEMO J1772 J1772COMBO	US	Privé	private	nan	nan	UTILITY	nan	nan
ELEC	LADWP - Haynes Power Plant	6801 E 2nd St	nan	Long Beach	CA	90803	nan	E	Private	Fleet use only	nan	19	1	nan	Non-Networked	nan	GPS	33.759802	-118.096665	Wed Jul 14 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	1531	2021-07-14 18:51:43 UTC	LG	nan	Tue May 01 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	CHADEMO J1772 J1772COMBO	US	Privé	private	nan	nan	UTILITY	nan	nan
ELEC	State Capitol Parking Garage	1303 10th St	At 12th and N St	Sacramento	CA	95814	nan	E	Private - Government only	Permitted state legislators only	Comdata	9		1 LP Inductive 1 SP Inductive 1 Avcon Conductive 1 Other Conductive	Non-Networked	nan	200-8	38.576769	-121.495022	Thu Dec 09 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	1533	2021-12-09 15:02:43 UTC	SG	nan	Tue Oct 15 1996 00:00:00 GMT+0000 (Coordinated Universal Time)	J1772	US	Privé - Réservé au gouvernement	private	GOVERNMENT	nan	PARKING_GARAGE	nan	nan
ELEC	LADWP - Harbor Generating Station	161 N Island Ave	At B St	Wilmington	CA	90744	nan	E	Private	Fleet use only	nan	10		nan	Non-Networked	nan	200-8	33.770508	-118.265628	Wed Jul 14 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	1552	2021-07-14 18:51:43 UTC	LG	nan	Fri Oct 15 1999 00:00:00 GMT+0000 (Coordinated Universal Time)	J1772	US	Privé	private	nan	nan	UTILITY	nan	nan
ELEC	LADWP - Sylmar West	13201 Sepulveda Blvd	nan	Sylmar	CA	91342	nan	E	Private - Government only	Fleet use only	nan	2		nan	Non-Networked	nan	200-8	34.30309	-118.480505	Wed Jul 14 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	1556	2021-07-14 18:51:43 UTC	LG	nan	Fri Jan 01 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	J1772	US	Privé - Réservé au gouvernement	private	GOVERNMENT	nan	UTILITY	nan	nan
ELEC	LADWP - EV Service Center	1630 N Main St	nan	Los Angeles	CA	90012	nan	E	Private	Fleet and employee use only	nan	46	1	nan	Non-Networked	nan	200-8	34.066801	-118.227605	Wed Jul 14 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	1572	2021-07-14 18:51:43 UTC	LG	nan	Fri Oct 15 1999 00:00:00 GMT+0000 (Coordinated Universal Time)	CHADEMO J1772	US	Privé	private	nan	nan	UTILITY	nan	nan
ELEC	LADWP - Fairfax Center	2311 S Fairfax Ave	nan	Los Angeles	CA	90016	nan	E	Private	Fleet use only	nan	13		nan	Non-Networked	nan	200-8	34.036777	-118.368841	Wed Jul 14 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	1573	2021-07-14 18:51:43 UTC	LG	nan	Mon Apr 01 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	J1772	US	Privé	private	nan	nan	UTILITY	nan	nan


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
);