Feeder-Level Load Profiles and Substation Demand
This dataset provides granular 15-minute interval load profiles for distribution feeders and substation transformers, including real and reactive power demand, phase-level loading, voltage drop, and thermal capacity utilization. It enables detailed analysis of grid performance, phase imbalance, and operational risks, supporting utility planning, reliability assessment, and demand forecasting.
Sample rows
preview · 8 of 180 rows · all 14 columns| record_idstring | phase_imbalance_percentfloat | is_peak_periodboolean | substation_idstring | timestampdatetime | feeder_idstring | mw_demandfloat | mvar_demandfloat | phase_a_loadfloat | phase_b_loadfloat | phase_c_loadfloat | voltage_drop_percentfloat | thermal_loading_percentfloat | notesstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| REC-00001 | 12.8 | true | SUB-NW-013 | 2023-11-23T17:00:00Z | FDR-North-01 | 41.5 | 20.8 | 15.7 | 13.8 | 12.1 | 27.2 | 97.3 | Thanksgiving peak, North region, high imbalance, event-driven demand. |
| REC-00002 | 9.2 | true | SUB-NW-013 | 2023-11-23T17:15:00Z | FDR-North-01 | 39.2 | 18.3 | 13 | 14.6 | 11.6 | 24.1 | 92.5 | Thanksgiving, sustained high load, North substation, moderate imbalance. |
| REC-00003 | 0.9 | false | SUB-CT-052 | 2023-06-12T12:00:00Z | FDR-Central-14 | 14.4 | 4.9 | 4.7 | 4.8 | 4.9 | 3.3 | 62.5 | Office district, midday typical, balanced three-phase load. |
| REC-00004 | 1.1 | false | SUB-CT-052 | 2023-06-12T12:15:00Z | FDR-Central-14 | 13.8 | 5.1 | 4.6 | 4.7 | 4.5 | 3.1 | 60.2 | Typical midday office load, balanced phases. |
| REC-00005 | 19.7 | true | SUB-WT-047 | 2023-12-31T19:00:00Z | FDR-West-22 | 47.8 | 27.3 | 15.8 | 19.6 | 12.4 | 41.6 | 99.3 | New Year's Eve, city-wide event, extreme demand and phase imbalance. |
| REC-00006 | 7.9 | true | SUB-ET-021 | 2023-07-04T21:00:00Z | FDR-East-03 | 38.5 | 17.2 | 13.6 | 12.6 | 12.3 | 26.5 | 88.1 | Holiday event in East region, demand near transformer capacity. |
| REC-00007 | 1.4 | false | SUB-ST-033 | 2023-11-23T05:30:00Z | FDR-South-07 | 2.7 | 1.6 | 0.9 | 0.8 | 1 | 1.7 | 26.3 | Early morning residential load, low imbalance, South region. |
| REC-00008 | 1 | false | SUB-ST-033 | 2023-11-23T05:45:00Z | FDR-South-07 | 3.1 | 1.8 | 1 | 1.1 | 1 | 2.1 | 28.5 | Pre-dawn, residential demand, minimal phase imbalance. |
| REC-00009 | 55 | false | SUB-ET-021 | 2023-08-15T02:00:00Z | FDR-East-03 | 0.05 | -1.2 | 0.01 | 0.03 | 0.01 | 0.3 | 0.7 | Edge case: minimum usage, isolated sensor test, negative MVAR. |
| REC-00010 | 70 | false | SUB-WT-047 | 2023-08-15T02:15:00Z | FDR-West-22 | 0.07 | -1.1 | 0.04 | 0.01 | 0.01 | 0.2 | 0.8 | Sensor test, minimal load, West region, high imbalance. |
| REC-00011 | 1.2 | false | SUB-ET-021 | 2023-06-12T01:30:00Z | FDR-East-03 | 4.8 | 2.3 | 1.6 | 1.5 | 1.7 | 2.7 | 38 | Early morning, low demand, balanced phases, East region. |
| REC-00012 | 12.3 | true | SUB-WT-047 | 2023-07-04T22:00:00Z | FDR-West-22 | 44.6 | 25.7 | 15.2 | 16.8 | 12.6 | 39.9 | 98.7 | Fireworks event, West station, load near transformer max. |
| REC-00013 | 0.7 | false | SUB-ST-033 | 2023-10-10T14:30:00Z | FDR-South-07 | 10.3 | 5 | 3.4 | 3.5 | 3.4 | 3.5 | 54.6 | Office district, midday, balanced feeder load. |
| REC-00014 | 13.3 | true | SUB-ST-033 | 2023-12-31T19:15:00Z | FDR-South-07 | 36.7 | 16.7 | 12.4 | 14 | 10.3 | 25.7 | 91.1 | New Year's Eve, South region, elevated demand and phase imbalance. |
| REC-00015 | 0.6 | false | SUB-ST-033 | 2023-10-10T14:45:00Z | FDR-South-07 | 11.7 | 4.8 | 3.9 | 3.8 | 4 | 4.2 | 58.3 | Midday, office park, South feeder, low phase imbalance. |
| REC-00016 | 1 | false | SUB-ET-021 | 2023-06-12T01:45:00Z | FDR-East-03 | 5.3 | 2.6 | 1.8 | 1.7 | 1.8 | 3.1 | 41.2 | Low overnight load, East region, balanced feeder. |
| REC-00017 | 11.1 | true | SUB-NW-013 | 2023-11-23T17:45:00Z | FDR-North-01 | 44.2 | 21.7 | 17 | 13.7 | 13.5 | 29.4 | 98.8 | Thanksgiving, North region, sustained peak, high transformer loading. |
| REC-00018 | 0.8 | false | SUB-CT-052 | 2023-06-12T12:30:00Z | FDR-Central-14 | 15.9 | 6.3 | 5.3 | 5.2 | 5.4 | 3.8 | 69.8 | Midday, central business load, balanced. |
| REC-00019 | 0.5 | false | SUB-CT-052 | 2023-06-12T12:45:00Z | FDR-Central-14 | 16.2 | 6.7 | 5.4 | 5.3 | 5.3 | 4.3 | 71.4 | Central region, midday business, balanced load. |
| REC-00020 | 18.5 | true | SUB-WT-047 | 2023-12-31T19:30:00Z | FDR-West-22 | 46.1 | 29 | 18.6 | 15.9 | 11.6 | 44.1 | 100 | New Year's Eve, city event, transformer at full capacity. |
What the 180 rows show
from the 180-row sample- 37%is_
peak_ period = true - 1.6median phase_
imbalance_ percent - 10feeders
- 13.5median mw_
demand - 4.8median mvar_
demand - 4.5median phase_
a_ load
Median 1.6, from 0.0 to 80.0.
- string 4
- float 8
- datetime 1
- boolean 1
Columns
14 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 4 columns | |||
record_id | string | Unique identifier for each 15-minute load profile recordunique | REC-00001 |
feeder_id | string | Unique identifier for the distribution feeder10 feeders | FDR-North-01 |
substation_id | string | Unique identifier for the substation transformer | SUB-NW-013 |
notes | string | Additional comments or notes about the recordoptional | Thanksgiving peak, North … |
| Numbers 8 columns | |||
mw_demand | float | Measured real power demand in megawatts (MW) at the interval0 or more | 41.5 |
mvar_demand | float | Measured reactive power demand in megavars (MVAR) at the interval | 20.8 |
phase_a_load | float | Load on phase A in megawatts (MW)0 or more | 15.7 |
phase_b_load | float | Load on phase B in megawatts (MW)0 or more | 13.8 |
phase_c_load | float | Load on phase C in megawatts (MW)0 or more | 12.1 |
phase_imbalance_percent | float | Percentage of load imbalance across phases0 to 100 | 12.8 |
voltage_drop_percent | float | Percentage voltage drop from nominal voltage0 to 100 | 27.2 |
thermal_loading_percent | float | Percentage of rated thermal capacity used0 to 100 | 97.3 |
| Dates and times 1 column | |||
timestamp | datetime | Date and time of the measurement (15-minute interval) | 2023-11-23T17:00:00Z |
| True or false 1 column | |||
is_peak_period | boolean | Indicates if the measurement was taken during a peak demand periodoptional | true |
Use it for
An energy dashboard
The is_
peak_ period rate, phase_ imbalance_ percent and a breakdown of substation_ id. Excel, Power BI or Tableau. Why do 67 of 180 rows have is_
peak_ period = true? A class exercise
Hand out the rows and one question. Everyone works from the same 180 rows.
- Records180REC-0000112.8trueREC-000029.2trueREC-000030.9false
A software demo
Believable records with timestamp, feeder_
id and substation_ id to fill a screen in front of a buyer.
This dataset180 rows14 columns
Yours1,000 rows14 columns
blueprint · feeder-level-load-profiles-and-substation-demand
Behind this dataset
Same schema. As many rows as you need.
These 180 rows came out of a blueprint — 14 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
- Feeder ID and substation name
- 15-minute MW demand and MVAR reactive power
- Load imbalance: difference between phases A, B, C
- Voltage drop from substation to feeder endpoint
- Transformer thermal loading as percentage of rated MVA
- Load diversity factor for mixed residential/commercial feeders
- Coincident peak demand for capacity planning
- Overload conditions triggering capacity upgrade projects
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
- feeder-level-load-profiles-and-substation-demand