This is a README file for the arizona-electricity dataset.
Used in case study 12B Electricity consumption and temperature

## Data source

[Arizona residential electricity consumption data] collected by the US Energy Information Administration (EIA).

[Temperature data] collected by the US National Oceanic and Atmospheric Administration (NOAA).

You can use this publicly available data for educational purposes.

1. The Arizona residential electricity consumption data can be obtained by clicking through the EIA Data Sets API Query Browser EIA Data Sets > Electricity > Retail sales of electricity > Residential > Retail sales of electricity : Arizona : residential : monthly.

4. The temperature data can be obtained by clicking through the Climate Data Online Search page
5. Select “Global Summary of the Month”, date range from Jan 1 2001, Search for “Stations” and Enter a Search Term “Phoenix”.
6. Then from the several items there select “PHOENIX AIRPORT, AZ US, station ID: GHCND:USW00023183”.
7. Go to your cart, select that you want csv.
8. Select the date range Jan 2001 to March 2018.
9. Select the variables “Station Name” and “Air Temperature”.

** !!!! WARNING: NEW VERSION IS DIFFERENT !!!! ** In the new version of the data (at least since Oct 2020) cooling and heating degree days are given as cumulative since January of the year.
So, for example, the CDSD entry is 355 in 4/2001, which is Apr CDSD = Jan CDD + Feb CDD + Mar CDD + Apr CDD (= 355).
From this you need to calculate the Apr CDD (one way is to subtract the previous month CDSD value) so that 2001 Apr CDD = 355-108=247 and the same for HDD (from HDSD).

### Raw data tables

electricity_resid_AZ.csv

• monthly time series of AZ residential electricity consumption
• Sep 1990 - April 2018 (T=332)
• ID variable: MY (month-year, first day of the month in date format)

Important variable

 variable name info type Q residential electricity consumption in AZ, million KWh numeric

climate_Phoenix_AZ.csv

• Jan 2001 - March 2018 (T=207)
• monthly time series of temperature data in Phoenix, AZ
• ID variable: DATE (year-month, in string format)

Important variables

 variable name info type CLDD cooling degree days, Fahrenheit numeric HTDD heating degree days, Fahrenheit numeric

### Tidy data tables

There are no tidy data files in this directory because all data is tidy already.

Note: if you are using the new climate data from NOAA, you need to redefine the cooling and heating degree days variables (see warning note above).

In the workfiles, the cooling and heating degree variables are used as daily average in the month as opposed to the monthly total that’s in the data (by dividing by 28, 30, or 31, depending on the month).