Time-of-Use (TOU) Rate Period Load Analysis
This dataset provides detailed, time-windowed electricity consumption and demand metrics for individual customers, segmented by Time-of-Use rate periods. It enables granular analysis of customer behavior, revenue generation, and demand response opportunities across different rate plans and geographic regions. Ideal for utilities and energy analysts seeking to optimize rate design, target demand response programs, and forecast revenue.
Sample rows
preview · 8 of 150 rows · all 11 columns| customer_idstring | customer_segmentstring | peak_demand_kwfloat | rate_periodstring | start_datedate | end_datedate | total_consumption_kwhfloat | average_demand_kwfloat | revenue_usdfloat | rate_plan_idstring | regionstring |
|---|---|---|---|---|---|---|---|---|---|---|
| C102341 | residential | 6.4 | on-peak | 2024-03-01 | 2024-03-31 | 765.2 | 3.1 | 138.55 | TOU-RES-11 | Los Angeles |
| COMM2104 | commercial | 61.2 | shoulder | 2024-04-01 | 2024-04-30 | 7800.7 | 33.4 | 1025.67 | TOU-COMM-17 | Denver |
| IND4302 | industrial | 497.6 | on-peak | 2024-05-01 | 2024-05-31 | 32755.3 | 410.2 | 2412.4 | TOU-IND-06 | Chicago |
| O15004 | other | 2.4 | shoulder | 2024-03-10 | 2024-03-16 | 22.1 | 0.9 | 5.58 | TOU-OTHER-01 | Reno |
| C102353 | residential | 3.1 | off-peak | 2024-04-01 | 2024-04-30 | 495.7 | 2.3 | 62.4 | TOU-RES-13 | Phoenix |
| COMM2127 | commercial | 22.8 | on-peak | 2024-02-01 | 2024-02-28 | 3872.5 | 11.6 | 462.9 | TOU-COMM-22 | Houston |
| IND4308 | industrial | 258.7 | shoulder | 2024-04-01 | 2024-04-30 | 19480.1 | 185.5 | 1397.22 | TOU-IND-21 | Dallas |
| O15019 | other | 2.9 | on-peak | 2024-04-15 | 2024-04-20 | 31.8 | 1.1 | 6.12 | TOU-OTHER-13 | Santa Fe |
| C102366 | residential | 5.7 | shoulder | 2024-05-01 | 2024-05-31 | 883.5 | 2.9 | 113.26 | TOU-RES-32 | Boston |
| COMM2151 | commercial | 17.1 | off-peak | 2024-03-01 | 2024-03-31 | 2633.7 | 8.6 | 264.8 | TOU-COMM-41 | Atlanta |
| IND4311 | industrial | 513.2 | on-peak | 2024-03-01 | 2024-03-31 | 37285.4 | 428.7 | 2560 | TOU-IND-38 | Detroit |
| O15023 | other | 1.8 | shoulder | 2024-02-05 | 2024-02-10 | 16.5 | 0.6 | 2.99 | TOU-OTHER-19 | Boulder |
| C102379 | residential | 1.2 | super off-peak | 2024-04-01 | 2024-04-30 | 210.3 | 0.7 | 21.83 | TOU-RES-42 | Miami |
| COMM2181 | commercial | 72.3 | shoulder | 2024-05-01 | 2024-05-31 | 9502.9 | 41.2 | 1372.93 | TOU-COMM-56 | Las Vegas |
| IND4326 | industrial | 205.7 | super off-peak | 2024-05-01 | 2024-05-31 | 18350.2 | 165.3 | 1125.78 | TOU-IND-54 | Cleveland |
| O15041 | other | 2.2 | shoulder | 2024-03-18 | 2024-03-22 | 27.4 | 0.9 | 4.11 | TOU-OTHER-29 | Ann Arbor |
| C102392 | residential | 4.4 | on-peak | 2024-02-01 | 2024-02-28 | 570.9 | 2.8 | 104.26 | TOU-RES-51 | San Diego |
| COMM2196 | commercial | 49.5 | on-peak | 2024-03-01 | 2024-03-31 | 6325.2 | 26.2 | 915.7 | TOU-COMM-63 | Salt Lake City |
| IND4332 | industrial | 431.5 | shoulder | 2024-02-01 | 2024-02-29 | 29325.8 | 390.3 | 1817.4 | TOU-IND-62 | St. Louis |
| O15057 | other | 2.6 | shoulder | 2024-05-08 | 2024-05-15 | 24.2 | 1.1 | 4.97 | TOU-OTHER-48 | Eugene |
What the 150 rows show
from the 150-row sampleIndustrial (customer segment) stands out: mean peak_
- 6.8median peak_
demand_ kw - 975.1median total_
consumption_ kwh - 3.3median average_
demand_ kw - 190.3median revenue_
usd
Median 6.8, from 0.0 to 519.7.
- string 5
- float 4
- date 2
Columns
11 columns in three groups| column | type | description | example |
|---|---|---|---|
| Text 5 columns | |||
customer_id | string | Unique identifier for the customer (e.g., account number or meter ID) | C102341 |
rate_period | string | Time-of-Use rate period for the consumption record (e.g., on-peak, off-peak, shoulder, super off-peak)on-peak · off-peak · shoulder · super off-peak | on-peak |
rate_plan_id | string | Identifier for the customer's rate plan (e.g., TOU plan code)optional | TOU-RES-11 |
customer_segment | string | Customer segment classification (e.g., residential, commercial, industrial)residential · commercial · industrial · other · optional | residential |
region | string | Geographic region or service area of the customeroptional | Los Angeles |
| Numbers 4 columns | |||
total_consumption_kwh | float | Total electricity consumption in kilowatt-hours during the specified rate period and aggregation window0 or more | 765.2 |
peak_demand_kw | float | Maximum demand (in kilowatts) recorded during the rate period and aggregation window0 or more · optional | 6.4 |
average_demand_kw | float | Average demand (in kilowatts) during the rate period and aggregation window0 or more · optional | 3.1 |
revenue_usd | float | Total revenue generated from the customer's consumption during the rate period and aggregation window (in USD)0 or more · optional | 138.55 |
| Dates and times 2 columns | |||
start_date | date | Start date of the aggregation period (e.g., billing cycle or analysis window) | 2024-03-01 |
end_date | date | End date of the aggregation period | 2024-03-31 |
Use it for
An energy dashboard
Peak_
demand_ kw by customer_ segment and a breakdown of rate_ period. Excel, Power BI or Tableau. Why do the 36 industrial rows have a mean peak_
demand_ kw of 357.2? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Customers150C1023416.4resident…COMM210461.2commerci…IND4302497.6industri…
A software demo
Believable customers with rate_
period, start_ date and end_ date to fill a screen in front of a buyer.
blueprint · time-of-use-tou-rate-period-load-analysis
Behind this dataset
Same schema. As many rows as you need.
These 150 rows came out of a blueprint — 11 columns with generation rules behind each one. Open it in Data Factory to retune a column, add your own, wire in foreign keys, and run it at the size you actually need.
- Rate schedule ID and TOU period definitions
- On-peak hours typically weekday afternoons (2pm-7pm summer)
- Off-peak hours overnight (10pm-6am)
- Shoulder periods transitional hours
- Super off-peak for EV charging or demand response (midnight-6am)
- kWh consumption and kW demand per TOU bucket
- Price elasticity of demand by TOU period
- Revenue impact analysis for TOU vs. flat rate
1 credit per row. Preview 20 rows free. Buy rows for the full run.
- Exports
- CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
- Licence
- yours to use, including commercially
- API slug
- time-of-use-tou-rate-period-load-analysis