Name: US City-Scale Daily Electricity Consumption And WD
Creator: Kaggle
License: http://opendatacommons.org/licenses/dbcl/1.0/

About this Dataset

US City-Scale Daily Electricity Consumption And WD

There are three United States cities' daily electricity consumption data and weather data. The cities are: New York, Los Angeles and Sacramento
There are total six CSV files to work with. I found it while working on my thesis.

Data was collected from the GitHub repository

If you use this dataset, please cite the paper:

Wang, Z., Hong, T., Li, H. and Piette, M.A., 2021. Predicting City-Scale Daily Electricity Consumption Using Data-Driven Models. Advances in Applied Energy, p.100025. Paper link

Tables

La Load

@kaggle.shemantosharkar_us_city_scale_daily_electricity_consumption.la_load

497.81 KB
45980 rows
2 columns


CREATE TABLE la_load (
  "unnamed_0" TIMESTAMP,
  "load" DOUBLE
);

La Weather

@kaggle.shemantosharkar_us_city_scale_daily_electricity_consumption.la_weather

569.42 KB
50370 rows
3 columns


CREATE TABLE la_weather (
  "datetime" TIMESTAMP,
  "temperature" DOUBLE,
  "humidity" DOUBLE
);

Ny Load

@kaggle.shemantosharkar_us_city_scale_daily_electricity_consumption.ny_load

553.63 KB
45984 rows
2 columns


CREATE TABLE ny_load (
  "unnamed_0" TIMESTAMP,
  "load" DOUBLE
);

Ny Weather

@kaggle.shemantosharkar_us_city_scale_daily_electricity_consumption.ny_weather

580.15 KB
50365 rows
3 columns


CREATE TABLE ny_weather (
  "datetime" TIMESTAMP,
  "temperature" DOUBLE,
  "humidity" DOUBLE
);

Sac Load

@kaggle.shemantosharkar_us_city_scale_daily_electricity_consumption.sac_load

494.36 KB
45980 rows
2 columns


CREATE TABLE sac_load (
  "unnamed_0" TIMESTAMP,
  "load" DOUBLE
);

Sac Weather

@kaggle.shemantosharkar_us_city_scale_daily_electricity_consumption.sac_weather

585.35 KB
50370 rows
3 columns


CREATE TABLE sac_weather (
  "datetime" TIMESTAMP,
  "temperature" DOUBLE,
  "humidity" DOUBLE
);