Seasonal and Holiday Load Pattern Recognition
This dataset provides detailed records of electrical load measurements across locations, annotated with seasonal, holiday, and special event context. It enables in-depth analysis of how weather, holidays, and extraordinary events impact energy consumption patterns, supporting grid management, forecasting, and anomaly detection.
Sample rows
preview · 8 of 100 rows · all 15 columns| record_idstring | seasonstring | temperature_cfloat | is_holidayboolean | special_event_typestring | timestampdatetime | location_idstring | location_namestring | load_mwfloat | holiday_namestring | weekdaystring | is_special_eventboolean | special_event_namestring | humidity_percentfloat | notesstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| REC-0001 | summer | 34.7 | false | heat_wave | 2023-06-15T14:00:00 | ZONE-NE01 | Northeast Urban | 482.3 | blank | Thursday | true | June Heat Wave | 62.1 | Peak AC usage due to heat wave |
| REC-0002 | winter | -2.1 | true | blank | 2023-12-25T10:00:00 | ZONE-NW02 | Northwest Suburban | 315.5 | Christmas Day | Monday | false | blank | 74.3 | Reduced weekday load on holiday |
| REC-0003 | winter | 1.8 | false | blank | 2023-02-18T19:00:00 | ZONE-SE03 | Southeast Residential | 368.9 | blank | Saturday | false | blank | 56.9 | Normal winter weekend pattern |
| REC-0004 | autumn | 9.5 | true | blank | 2023-11-23T16:00:00 | ZONE-SW04 | Southwest Commercial | 302.7 | Thanksgiving | Thursday | false | blank | 68.2 | Reduced commercial activity |
| REC-0005 | summer | 32.6 | true | sporting_event | 2023-07-04T17:00:00 | ZONE-MW05 | Midwest Downtown | 390.8 | Independence Day | Tuesday | true | City Fireworks | 53.8 | Evening spike due to event crowds |
| REC-0006 | spring | 16.4 | false | blank | 2023-03-21T13:00:00 | ZONE-SE03 | Southeast Residential | 255.4 | blank | Tuesday | false | blank | 44.7 | Mild spring weekday |
| REC-0007 | autumn | 12.2 | true | other | 2023-10-31T18:00:00 | ZONE-NW02 | Northwest Suburban | 312.8 | Halloween | Tuesday | true | Neighborhood Trick-or-Treat | 70.1 | Evening spike from outdoor activities |
| REC-0008 | summer | 37.1 | false | heat_wave | 2023-08-08T15:00:00 | ZONE-NE01 | Northeast Urban | 499.5 | blank | Tuesday | true | August Heat Surge | 58.2 | Sustained peak from heat wave |
| REC-0009 | spring | 21.5 | false | sporting_event | 2023-04-15T12:00:00 | ZONE-SW04 | Southwest Commercial | 270.3 | blank | Saturday | true | Local Baseball Game | 49.6 | Spike from daytime event |
| REC-0010 | winter | -6.3 | false | blank | 2023-01-02T09:00:00 | ZONE-MW05 | Midwest Downtown | 328.9 | blank | Monday | false | blank | 83.1 | Post-holiday weekday load |
| REC-0011 | spring | 24.7 | true | blank | 2023-05-29T14:00:00 | ZONE-SE03 | Southeast Residential | 261.8 | Memorial Day | Monday | false | blank | 50.3 | Holiday load reduction |
| REC-0012 | summer | 28.8 | false | blank | 2023-09-03T16:00:00 | ZONE-SW04 | Southwest Commercial | 298.4 | blank | Sunday | false | blank | 63.2 | Weekend summer pattern |
| REC-0013 | spring | 12.8 | true | sporting_event | 2023-03-17T15:00:00 | ZONE-NE01 | Northeast Urban | 275 | St. Patrick's Day | Friday | true | City Parade | 47.9 | Afternoon event spike |
| REC-0014 | winter | -3.8 | true | other | 2023-12-31T23:00:00 | ZONE-NW02 | Northwest Suburban | 326.7 | New Year's Eve | Sunday | true | Countdown Celebration | 78.5 | Late night event increase |
| REC-0015 | spring | 18.6 | false | other | 2023-05-05T18:00:00 | ZONE-MW05 | Midwest Downtown | 277.1 | blank | Friday | true | Cinco de Mayo Festival | 41.2 | Evening event load |
| REC-0016 | autumn | 16.1 | true | blank | 2023-10-09T13:00:00 | ZONE-SE03 | Southeast Residential | 263.2 | Columbus Day | Monday | false | blank | 52.7 | Holiday load decrease |
| REC-0017 | summer | 36.3 | false | heat_wave | 2023-07-17T17:00:00 | ZONE-NE01 | Northeast Urban | 474.6 | blank | Monday | true | July Heat Wave | 60.2 | High demand from persistent heat |
| REC-0018 | winter | 0.5 | true | blank | 2023-02-14T18:00:00 | ZONE-NW02 | Northwest Suburban | 343.7 | Valentine's Day | Tuesday | false | blank | 76.4 | Evening winter load |
| REC-0019 | spring | 15 | false | blank | 2023-03-12T11:00:00 | ZONE-SW04 | Southwest Commercial | 248.3 | blank | Sunday | false | blank | 40.5 | Spring weekend drop |
| REC-0020 | winter | -11.6 | false | cold_snap | 2023-01-20T08:00:00 | ZONE-MW05 | Midwest Downtown | 352.4 | blank | Friday | true | January Freeze | 75.9 | Morning peak from cold snap |
What the 100 rows show
from the 100-row sampleWinter season stands out: mean temperature_
- 30%is_
holiday = true - 15.4median temperature_
c - 7weekdays
- 219.1median load_
mw - 57.5median humidity_
percent
Median 15.4, from -11.6 to 39.2.
- string 9
- float 3
- datetime 1
- boolean 2
Columns
15 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 9 columns | |||
record_id | string | Unique identifier for each load pattern recordunique | REC-0001 |
location_id | string | Unique identifier for the location or grid zone where the load is measured | ZONE-NE01 |
location_name | string | Human-readable name of the location or grid zoneoptional | Northeast Urban |
season | string | Season during which the measurement was taken (e.g., winter, spring, summer, autumn)winter · spring · summer · autumn | summer |
holiday_name | string | Name of the holiday if applicableoptional | Christmas Day |
weekday | string | Day of the week (e.g., Monday, Tuesday)7 values | Thursday |
special_event_type | string | Type of special event impacting the load (e.g., heat wave, cold snap, sporting event)heat_wave · cold_snap · sporting_event · other · optional | heat_wave |
special_event_name | string | Name or description of the specific special eventoptional | June Heat Wave |
notes | string | Additional notes or comments about the load pattern or measurementoptional | Mild spring weekday |
| Numbers 3 columns | |||
load_mw | float | Measured electrical load in megawatts (MW)0 or more | 482.3 |
temperature_c | float | Ambient temperature at the time of measurement in degrees Celsiusoptional | 34.7 |
humidity_percent | float | Relative humidity at the time of measurement (percentage)0 to 100 · optional | 62.1 |
| Dates and times 1 column | |||
timestamp | datetime | Date and time of the load measurement | 2023-06-15T14:00:00 |
| True or false 2 columns | |||
is_holiday | boolean | Indicates if the measurement date is a public holiday | false |
is_special_event | boolean | Indicates if a special event occurred during this time (e.g., heat wave, sporting event) | true |
Use it for
An energy dashboard
The is_
holiday rate, temperature_ c by season and a breakdown of special_ event_ type. Excel, Power BI or Tableau. Why do the 22 winter rows have a mean temperature_
c of -2.5? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Records100REC-000134.7summerREC-0002-2.1winterREC-00049.5autumn
A software demo
Believable records with timestamp, location_
id and location_ name to fill a screen in front of a buyer.
This dataset100 rows15 columns
Yours1,000 rows15 columnslocation_id: UK only
blueprint · seasonal-and-holiday-load-pattern-recognition
Behind this dataset
Same schema. As many rows as you need.
These 100 rows came out of a blueprint — 15 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.
Rules it was built with
- Date and day of week (weekday, weekend, holiday)
- Holiday flag: New Year's, Memorial Day, July 4th, Labor Day, Thanksgiving, Christmas
- Seasonal period: winter (heating), spring/fall (mild), summer (cooling)
- Weather event flag: heat wave (>95°F for 3+ days), cold snap (<20°F)
- Special event: Super Bowl, major sports championship, concerts
- Load pattern deviation from typical day (percentage)
- Economic indicators: recession impacts on industrial load
- Day-ahead forecast adjustments for known events
Open the blueprint in Data Factory
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
- seasonal-and-holiday-load-pattern-recognition