Skip to content

Instantly share code, notes, and snippets.

@pcordone

pcordone/README.md

Last active September 27, 2021 21:56
Show Gist options
  • Save pcordone/93039d5d909fbf42838c5167219d6ed4 to your computer and use it in GitHub Desktop.
Save pcordone/93039d5d909fbf42838c5167219d6ed4 to your computer and use it in GitHub Desktop.
Download ZIP
Electric Accounts Data
Raw
README.md

This data is my home electric energy consumption from the Natinoal Grid web site. If you have National Grid as your provider, you can download the data from their website It represent my electricity usage for three personal accounts at my residence. I live in a three family and occupy two of the floors. There is also a common meter that supplies electricity for the front and back hall lights and exterrior and basement outlets.

The data set shows electricy consumption for the past two years in both usage and cost. I have augmented the National Grid data with power that is generated by a community solar project that I am a member of. Power generated by solar a solar provider is applied to as "net metering credits" and shows up on the bill from National Grid as a credit dollar amount.

Arributes are:

  • accountNumber - is the electric account number for the row
  • readDate - is the date of the reading
  • readDays - is the number of days since the last reading for the row
  • readType - is it an estimated or actual reading
  • totalKwh - is the electricity consumed for the read days
  • utilityCharges - is the bill amount in USD for the totalKwh consumed
  • supplierCharges - the supplier charge
  • totalCharges - the utilityCharges + supplierCharges
  • avgDailyUsage - the daily average kWH consumed for the readDays
  • readFromDate - the start date of the reading
  • readToDate - the end date of the reading
  • relativemonthBillDate - the first of the month date for the bill
  • netMeterCredits - the USD credit amount from solar generated electricity by the solar provider
Raw
electricAccountsData.csv
accountNumber readDate readDays readType totalKwh utilityCharges supplierCharges totalCharges avgDailyUsage readFromDate readToDate relativeMonthBillDate timestamp netMeterCredits
1111111111 9/27/19 29 Actual 321 42.88 34.65 77.2 11 8/29/19 9/27/19 10/1/19 9/30/19 0
1111111111 10/29/19 32 Actual 433 55.92 46.73 102.29 14 9/27/19 10/29/19 11/1/19 10/30/19 238.19
1111111111 11/26/19 28 Actual 639 82.09 87.74 169.47 23 10/29/19 11/26/19 12/1/19 11/27/19 84.98
1111111111 12/31/19 35 Actual 726 92.51 101.34 193.49 21 11/26/19 12/31/19 1/1/20 1/2/20 67.4
1111111111 1/29/20 29 Actual 802 103.16 111.94 214.74 28 12/31/19 1/29/20 2/1/20 1/30/20 74.87
1111111111 2/28/20 30 Actual 957 121.72 133.57 254.93 32 1/29/20 2/28/20 3/1/20 3/2/20 79.49
1111111111 3/30/20 31 Actual 1121 148.72 156.46 304.82 36 2/28/20 3/30/20 4/1/20 3/31/20 153.97
1111111111 4/29/20 30 Actual 1142 151.65 159.39 310.68 38 3/30/20 4/29/20 5/1/20 4/30/20 120.58
1111111111 5/28/20 29 Actual 900 123.65 90.34 213.63 31 4/29/20 5/28/20 6/1/20 5/29/20 0
1111111111 6/29/20 32 Actual 1042 142.19 103.13 244.96 33 5/28/20 6/29/20 7/1/20 6/30/20 259
1111111111 7/29/20 30 Actual 1002 137.09 99.18 235.91 33 6/29/20 7/29/20 8/1/20 7/31/20 0
1111111111 8/27/20 29 Actual 971 126.55 96.11 222.3 33 7/29/20 8/27/20 9/1/20 8/28/20 243.15
1111111111 9/25/20 29 Actual 474 65.13 46.91 111.68 16 8/27/20 9/25/20 10/1/20 9/29/20 115.5
1111111111 10/27/20 32 Actual 514 69.67 50.88 120.19 16 9/25/20 10/27/20 11/1/20 10/28/20 146.67
1111111111 11/25/20 29 Actual 592 79.21 71.31 150.16 20 10/27/20 11/25/20 12/1/20 11/30/20 0
1111111111 12/31/20 36 Actual 848 110.45 105.04 215.13 24 11/25/20 12/31/20 1/1/21 1/4/21 119.73
1111111111 1/28/21 28 Actual 621 86.99 76.93 163.56 22 12/31/20 1/28/21 2/1/21 1/29/21 201.77
1111111111 3/1/21 32 Actual 444 64.34 55 118.98 14 1/28/21 3/1/21 3/1/21 3/2/21 0
1111111111 3/30/21 29 Actual 400 63.47 49.55 112.66 14 3/1/21 3/30/21 4/1/21 3/31/21 106.44
1111111111 4/29/21 30 Actual 419 66.16 51.91 117.71 14 3/30/21 4/29/21 5/1/21 4/30/21 0
1111111111 5/27/21 28 Actual 440 65.99 43.13 108.76 16 4/29/21 5/27/21 6/1/21 5/28/21 587.89
1111111111 6/29/21 33 Actual 626 93.02 60.77 153.43 19 5/27/21 6/29/21 7/1/21 6/30/21 198.78
1111111111 7/29/21 30 Actual 528 80.05 51.25 130.94 18 6/29/21 7/29/21 8/1/21 7/30/21 175.43
1111111111 8/30/21 32 Actual 582 87.5 56.49 143.63 18 7/29/21 8/30/21 9/1/21 8/31/21 193.57
2222222222 9/27/19 29 Actual 15 11.38 1.53 12.58 1 8/29/19 9/27/19 10/1/19 9/30/19 0
2222222222 10/29/19 32 Actual 25 12.3 2.57 14.51 1 9/27/19 10/29/19 11/1/19 10/30/19 41
2222222222 11/26/19 28 Actual 18 11.72 2.28 13.64 1 10/29/19 11/26/19 12/1/19 11/27/19 14.65
2222222222 12/31/19 35 Actual 38 13.59 4.91 18.14 1 11/26/19 12/31/19 1/1/20 1/2/20 11.62
2222222222 1/29/20 29 Actual 28 12.66 3.62 15.92 1 12/31/19 1/29/20 2/1/20 1/30/20 12.9
2222222222 2/28/20 30 Actual 28 12.66 3.62 15.92 1 1/29/20 2/28/20 3/1/20 3/2/20 13.7
2222222222 3/30/20 31 Actual 6 10.62 0.78 11.04 0 2/28/20 3/30/20 4/1/20 3/31/20 26.54
2222222222 4/29/20 30 Actual 12 11.26 1.55 12.45 0 3/30/20 4/29/20 5/1/20 4/30/20 20.79
2222222222 5/28/20 29 Actual 34 13.57 3.09 16.3 1 4/29/20 5/28/20 6/1/20 5/29/20 0
2222222222 6/29/20 32 Actual 17 11.82 1.53 12.99 1 5/28/20 6/29/20 7/1/20 6/30/20 44.65
2222222222 7/29/20 30 Actual 14 11.49 1.25 12.38 0 6/29/20 7/29/20 8/1/20 7/31/20 0
2222222222 8/27/20 29 Actual 19 11.88 1.7 13.22 1 7/29/20 8/27/20 9/1/20 8/28/20 41.91
2222222222 9/25/20 29 Actual 11 11.12 0.98 11.74 0 8/27/20 9/25/20 10/1/20 9/29/20 19.91
2222222222 10/27/20 32 Actual 33 13.26 2.95 15.85 1 9/25/20 10/27/20 11/1/20 10/28/20 0
2222222222 11/25/20 29 Actual 35 13.45 3.88 16.97 1 10/27/20 11/25/20 12/1/20 11/30/20 0
2222222222 12/31/20 36 Actual 53 15.24 6.07 20.95 1 11/25/20 12/31/20 1/1/21 1/4/21 0
2222222222 1/28/21 28 Actual 28 12.9 3.2 15.74 1 12/31/20 1/28/21 2/1/21 1/29/21 0
2222222222 3/1/21 32 Actual 19 11.99 2.17 13.8 1 1/28/21 3/1/21 3/1/21 3/2/21 0
2222222222 3/30/21 29 Actual 38 14.44 4.35 18.43 1 3/1/21 3/30/21 4/1/21 3/31/21 0
2222222222 4/29/21 30 Actual 10 11.19 1.14 11.97 0 3/30/21 4/29/21 5/1/21 4/30/21 0
2222222222 5/27/21 28 Actual 13 11.46 1.17 12.27 0 4/29/21 5/27/21 6/1/21 5/28/21 0
2222222222 6/29/21 33 Actual 21 12.45 1.88 13.97 1 5/27/21 6/29/21 7/1/21 6/30/21 0
2222222222 7/29/21 30 Actual 113 23.31 10.13 33.08 4 6/29/21 7/29/21 8/1/21 7/30/21 0
2222222222 8/30/21 32 Actual 226 36.63 20.27 56.54 7 7/29/21 8/30/21 9/1/21 8/31/21 0
3333333333 9/27/19 29 Actual 175 25.89 18.88 44.44 6 8/29/19 9/27/19 10/1/19 9/30/19 0
3333333333 10/29/19 32 Actual 233 32.62 25.15 57.41 7 9/27/19 10/29/19 11/1/19 10/30/19 114.81
3333333333 11/26/19 28 Actual 436 58.21 59.88 117.73 16 10/29/19 11/26/19 12/1/19 11/27/19 41.02
3333333333 12/31/19 35 Actual 619 79.89 86.39 165.92 18 11/26/19 12/31/19 1/1/20 1/2/20 32.53
3333333333 1/29/20 29 Actual 608 79.86 84.86 164.36 21 12/31/19 1/29/20 2/1/20 1/30/20 36.14
3333333333 2/28/20 30 Actual 723 93.67 100.91 194.22 24 1/29/20 2/28/20 3/1/20 3/2/20 38.37
3333333333 3/30/20 31 Actual 468 66.18 65.32 131.14 15 2/28/20 3/30/20 4/1/20 3/31/20 74.33
3333333333 4/29/20 30 Actual 521 72.99 72.72 145.35 17 3/30/20 4/29/20 5/1/20 4/30/20 58.21
3333333333 5/28/20 29 Actual 278 43.06 27.91 70.61 10 4/29/20 5/28/20 6/1/20 5/29/20 0
3333333333 6/29/20 32 Actual 455 66.05 45.03 110.72 14 5/28/20 6/29/20 7/1/20 6/30/20 125.03
3333333333 7/29/20 30 Actual 437 63.74 43.26 106.64 15 6/29/20 7/29/20 8/1/20 7/31/20 0
3333333333 8/27/20 29 Actual 430 59.95 42.56 102.15 15 7/29/20 8/27/20 9/1/20 8/28/20 117.37
3333333333 9/25/20 29 Actual 297 43.42 29.39 72.45 10 8/27/20 9/25/20 10/1/20 9/29/20 55.75
3333333333 10/27/20 32 Actual 275 40.54 27.22 67.4 9 9/25/20 10/27/20 11/1/20 10/28/20 88
3333333333 11/25/20 29 Actual 401 55.9 48.29 103.83 14 10/27/20 11/25/20 12/1/20 11/30/20 0
3333333333 12/31/20 36 Actual 616 82.18 76.31 158.13 17 11/25/20 12/31/20 1/1/21 1/4/21 71.84
3333333333 1/28/21 28 Actual 653 91.11 80.89 171.64 23 12/31/20 1/28/21 2/1/21 1/29/21 121.06
3333333333 3/1/21 32 Actual 750 103.89 92.91 196.44 23 1/28/21 3/1/21 3/1/21 3/2/21 0
3333333333 3/30/21 29 Actual 215 37.38 26.63 63.65 7 3/1/21 3/30/21 4/1/21 3/31/21 63.87
3333333333 4/29/21 30 Actual 226 38.9 27.99 66.53 8 3/30/21 4/29/21 5/1/21 4/30/21 0
3333333333 5/27/21 28 Actual 274 43.77 26.86 70.27 10 4/29/21 5/27/21 6/1/21 5/28/21 347.46
3333333333 6/29/21 33 Actual 459 70.08 44.55 114.27 14 5/27/21 6/29/21 7/1/21 6/30/21 114.19
3333333333 7/29/21 30 Actual 397 61.92 38.54 100.1 13 6/29/21 7/29/21 8/1/21 7/30/21 100.78
3333333333 8/30/21 32 Actual 474 72.59 46.01 118.24 15 7/29/21 8/30/21 9/1/21 8/31/21 111.56
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment