House Hold Energy Data - Time Series

For experiments in Time Series Predictive Models

@kaggle.jaganadhg_house_hold_energy_data

Table List

1 table(65.96 KB)

D202

@kaggle.jaganadhg_house_hold_energy_data.d202

65.96 KB
70368 rows
8 columns

type TYPE	date DATE	start_time START TIME	end_time END TIME	usage USAGE	units UNITS	cost COST
Electric usage	Sat Oct 22 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	0:00	0:14	0.01	kWh	$0.00
Electric usage	Sat Oct 22 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	0:15	0:29	0.01	kWh	$0.00
Electric usage	Sat Oct 22 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	0:30	0:44	0.01	kWh	$0.00
Electric usage	Sat Oct 22 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	0:45	0:59	0.01	kWh	$0.00
Electric usage	Sat Oct 22 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	1:00	1:14	0.01	kWh	$0.00
Electric usage	Sat Oct 22 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	1:15	1:29	0.01	kWh	$0.00
Electric usage	Sat Oct 22 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	1:30	1:44	0.01	kWh	$0.00
Electric usage	Sat Oct 22 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	1:45	1:59	0.01	kWh	$0.00
Electric usage	Sat Oct 22 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	2:00	2:14	0.02	kWh	$0.00
Electric usage	Sat Oct 22 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	2:15	2:29	0.02	kWh	$0.00


CREATE TABLE d202 (
  "type" VARCHAR,
  "date" TIMESTAMP,
  "start_time" VARCHAR,
  "end_time" VARCHAR,
  "usage" DOUBLE,
  "units" VARCHAR,
  "cost" VARCHAR,
  "notes" VARCHAR
);