PDB Electric Power Load History

There is electric demand data form 2003 to 2014

@kaggle.ashfakyeafi_pbd_load_history

Table List

1 table(379.2 KB)

Pdb Load History

@kaggle.ashfakyeafi_pbd_load_history.pdb_load_history

379.2 KB
103776 rows
8 columns

date Date	year Year	month Month	day Day	weekday Weekday	hour Hour	demand Demand	temperature Temperature
Sat Mar 01 2003 00:00:00 GMT+0000 (Coordinated Universal Time)	2003	3	1	7	1	12863	29
Sat Mar 01 2003 00:00:00 GMT+0000 (Coordinated Universal Time)	2003	3	1	7	2	12389	28
Sat Mar 01 2003 00:00:00 GMT+0000 (Coordinated Universal Time)	2003	3	1	7	3	12155	29
Sat Mar 01 2003 00:00:00 GMT+0000 (Coordinated Universal Time)	2003	3	1	7	4	12072	27
Sat Mar 01 2003 00:00:00 GMT+0000 (Coordinated Universal Time)	2003	3	1	7	5	12160	29
Sat Mar 01 2003 00:00:00 GMT+0000 (Coordinated Universal Time)	2003	3	1	7	6	12568	28
Sat Mar 01 2003 00:00:00 GMT+0000 (Coordinated Universal Time)	2003	3	1	7	7	13236	29
Sat Mar 01 2003 00:00:00 GMT+0000 (Coordinated Universal Time)	2003	3	1	7	8	14190	29
Sat Mar 01 2003 00:00:00 GMT+0000 (Coordinated Universal Time)	2003	3	1	7	9	15213	28
Sat Mar 01 2003 00:00:00 GMT+0000 (Coordinated Universal Time)	2003	3	1	7	10	15647	27


CREATE TABLE pdb_load_history (
  "date" TIMESTAMP,
  "year" BIGINT,
  "month" BIGINT,
  "day" BIGINT,
  "weekday" BIGINT,
  "hour" BIGINT,
  "demand" DOUBLE,
  "temperature" BIGINT
);