Electric Vehicle Charging Dataset

Data from 85 EV drivers with repeat usage at 105 stations across 25 sites

@kaggle.michaelbryantds_electric_vehicle_charging_dataset

Table List

1 table(150.85 KB)

Station Data Dataverse

@kaggle.michaelbryantds_electric_vehicle_charging_dataset.station_data_dataverse

150.85 KB
3395 rows
24 columns

sessionid SessionId	kwhtotal KwhTotal	dollars Dollars	created Created	ended Ended	starttime StartTime	endtime EndTime	chargetimehrs ChargeTimeHrs	weekday Weekday	platform Platform	userid UserId	stationid StationId	locationid LocationId	facilitytype FacilityType	tues Tues	wed Wed	thurs Thurs	fri Fri
1366563	7.78		0014-11-18 15:40:26	0014-11-18 17:11:04	15	17	1.510555556	Tue	android	35897499	582873	461655	3	1
3075723	9.74		0014-11-19 17:40:26	0014-11-19 19:51:04	17	19	2.177222222	Wed	android	35897499	549414	461655	3		1
4228788	6.76	0.58	0014-11-21 12:05:46	0014-11-21 16:46:04	12	16	4.671666667	Fri	android	35897499	129465	461655	3				1
3173284	6.17		0014-12-03 19:16:12	0014-12-03 21:02:18	19	21	1.768333333	Wed	android	35897499	569889	461655	3		1
3266500	0.93		0014-12-11 20:56:11	0014-12-11 21:14:06	20	21	0.298611111	Thu	android	35897499	414088	566549	3			1
4099366	2.14		0014-12-12 14:38:44	0014-12-12 15:04:04	14	15	0.422222222	Fri	android	35897499	911231	202527	3				1
5084244	0.3		0014-12-12 15:08:40	0014-12-12 15:47:04	15	15	0.64	Fri	android	35897499	920264	461655	3				1
2948436	1.82		0014-12-17 20:30:25	0014-12-17 21:31:04	20	21	1.010833333	Wed	android	35897499	431796	461655	3		1
3515913	0.81		0014-12-18 17:53:19	0014-12-18 18:04:04	17	18	0.179166667	Thu	android	35897499	134427	620906	3			1
8490014	1.98		0014-12-18 18:06:49	0014-12-18 18:30:05	18	18	0.387777778	Thu	android	35897499	207262	928191	3			1


CREATE TABLE station_data_dataverse (
  "sessionid" BIGINT,
  "kwhtotal" DOUBLE,
  "dollars" DOUBLE,
  "created" VARCHAR,
  "ended" VARCHAR,
  "starttime" BIGINT,
  "endtime" BIGINT,
  "chargetimehrs" DOUBLE,
  "weekday" VARCHAR,
  "platform" VARCHAR,
  "distance" DOUBLE,
  "userid" BIGINT,
  "stationid" BIGINT,
  "locationid" BIGINT,
  "managervehicle" BIGINT,
  "facilitytype" BIGINT,
  "mon" BIGINT,
  "tues" BIGINT,
  "wed" BIGINT,
  "thurs" BIGINT,
  "fri" BIGINT,
  "sat" BIGINT,
  "sun" BIGINT,
  "reportedzip" BIGINT
);