Grid Energy Source Allocation Data
This dataset provides granular, hourly records of electricity allocation from solar, wind, hydro, and traditional sources across distributed power grids, including region, peak load, and renewable integration metrics. It enables energy managers and analysts to optimize grid sustainability, monitor renewable adoption, and manage peak-load periods for improved resilience and efficiency.
Sample rows
preview · 8 of 150 rows · all 13 columns| allocation_idstring | renewable_percentagefloat | is_peak_hourboolean | grid_idstring | grid_namestring | regionstring | allocation_datetimedatetime | solar_mwhfloat | wind_mwhfloat | hydro_mwhfloat | traditional_mwhfloat | total_allocated_mwhfloat | peak_load_mwhfloat |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| A7d9f1c2-01 | 10.85 | true | GRID001 | Midwest Central | Midwest USA | 2024-06-10T05:00:00Z | 2.1 | 5.2 | 3.6 | 89.7 | 100.6 | 100.6 |
| e9b1f2ac-02 | 7.33 | true | GRID002 | NYC Urban Grid | New York City | 2024-06-10T18:00:00Z | 0 | 2.3 | 5 | 92.2 | 99.5 | 99.5 |
| C3x4k8j7-03 | 0 | true | GRID003 | Illinois Power | Illinois | 2024-06-10T20:00:00Z | 0 | 0 | 0 | 100 | 100 | 100 |
| T8v2d4m5-04 | 100 | false | GRID004 | Oregon Greenflow | Oregon | 2024-06-10T13:00:00Z | 44.1 | 33 | 22 | 0 | 99.1 | 97 |
| G5m8n2l4-05 | 100 | true | GRID005 | Northern Plains Grid | North Dakota | 2024-06-10T12:00:00Z | 32 | 38.5 | 29 | 0 | 99.5 | 98 |
| Z6p3q7r9-06 | 61.66 | false | GRID006 | Rockies Distribution | Colorado | 2024-06-10T14:00:00Z | 24.3 | 17.6 | 15.2 | 36.5 | 93.6 | 92 |
| F2q7b4x3-07 | 68.83 | false | GRID007 | California West Grid | California | 2024-06-10T11:00:00Z | 36.8 | 19.1 | 14.2 | 31.9 | 102 | 101 |
| B6l1m5a2-08 | 0 | false | GRID008 | Alaska Simulation | Alaska | 2024-06-10T03:00:00Z | 0 | 0 | 0 | 612.5 | 612.5 | blank |
| P7r6q1m8-09 | 0 | false | GRID009 | Simulation Testgrid | SimulationRegion | 2024-06-10T06:00:00Z | 0 | 0 | 0 | 0.01 | 0.01 | blank |
| Q4t8h2j1-10 | 4.5 | true | GRID010 | Chicago Loop Grid | Illinois | 2024-06-10T19:00:00Z | 1.5 | 3 | 0 | 95.5 | 100 | 99 |
| R8n3v6k2-11 | 50.04 | false | GRID011 | Florida Sun Grid | Florida | 2024-06-10T15:00:00Z | 38 | 7.2 | 4.5 | 49 | 98.7 | 97.5 |
| S4m7k2p9-12 | 49.75 | true | GRID012 | Texas Metro Grid | Texas | 2024-06-10T16:00:00Z | 18 | 25 | 6 | 51.5 | 100.5 | 99 |
| W2b9q4m1-13 | 74.5 | false | GRID013 | San Francisco Grid | California | 2024-06-10T08:00:00Z | 41.2 | 19.8 | 13.5 | 25.5 | 100 | 98 |
| U6p2n3k1-14 | 82 | false | GRID014 | Seattle Hydro Grid | Washington | 2024-06-10T09:00:00Z | 17.1 | 13.2 | 51.7 | 18 | 100 | 99.8 |
| V3t8h2j9-15 | 36 | true | GRID015 | Boston East Grid | Massachusetts | 2024-06-10T10:00:00Z | 9 | 15 | 12 | 64 | 100 | 99 |
| K9w2c1x6-16 | 61.89 | false | GRID016 | Phoenix Solar Grid | Arizona | 2024-06-10T14:00:00Z | 45 | 11.2 | 3.8 | 38 | 98 | 97.5 |
| J8y4g2v1-17 | 10 | true | GRID017 | Houston Metro Grid | Texas | 2024-06-10T18:00:00Z | 3.5 | 4.7 | 1.8 | 90 | 100 | 100 |
| H5d9n1s3-18 | 49.5 | true | GRID018 | Denver Peaks Grid | Colorado | 2024-06-10T07:00:00Z | 19 | 22 | 8.5 | 50.5 | 100 | 99 |
| M6r8y2k4-19 | 47 | false | GRID019 | Ohio River Grid | Ohio | 2024-06-10T13:00:00Z | 18.2 | 16.5 | 12.3 | 53 | 100 | 99.5 |
| E2p6c9w1-20 | 35 | true | GRID020 | Georgia Power Grid | Georgia | 2024-06-10T17:00:00Z | 21 | 8 | 6 | 65 | 100 | 99 |
What the 150 rows show
from the 150-row sample- 46%is_
peak_ hour = true - 47.0median renewable_
percentage - 15.0median solar_
mwh - 10.0median wind_
mwh - 7.3median hydro_
mwh - 50.0median traditional_
mwh
Median 47.0, from 0.0 to 100.0.
- string 4
- float 7
- datetime 1
- boolean 1
Columns
13 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 4 columns | |||
allocation_id | string | Unique identifier for each hourly grid energy source allocation recordunique | A7d9f1c2-01 |
grid_id | string | Unique identifier for the distributed power grid | GRID001 |
grid_name | string | Name of the distributed power grid | Midwest Central |
region | string | Geographic region or area served by the grid | Midwest USA |
| Numbers 7 columns | |||
solar_mwh | float | Amount of electricity allocated from solar sources (in megawatt-hours)0 or more | 2.1 |
wind_mwh | float | Amount of electricity allocated from wind sources (in megawatt-hours)0 or more | 5.2 |
hydro_mwh | float | Amount of electricity allocated from hydro sources (in megawatt-hours)0 or more | 3.6 |
traditional_mwh | float | Amount of electricity allocated from traditional sources (coal, gas, nuclear) in megawatt-hours0 or more | 89.7 |
total_allocated_mwh | float | Total electricity allocated by the grid for the hour (sum of all sources, in megawatt-hours)0 or more | 100.6 |
peak_load_mwh | float | Peak load demand on the grid during the hour (in megawatt-hours)0 or more · optional | 100.6 |
renewable_percentage | float | Percentage of total allocated electricity from renewable sources (solar, wind, hydro)0 to 100 · optional | 10.85 |
| Dates and times 1 column | |||
allocation_datetime | datetime | Timestamp for the hourly allocation record (start of the hour) | 2024-06-10T05:00:00Z |
| True or false 1 column | |||
is_peak_hour | boolean | Indicates if the allocation hour is a designated peak load hour for the gridoptional | true |
Use it for
An energy dashboard
The is_
peak_ hour rate and renewable_ percentage. Excel, Power BI or Tableau. Why do 69 of 150 rows have is_
peak_ hour = true? A class exercise
Hand out the rows and one question. Everyone works from the same 150 rows.
- Allocations150A7d9f1c2-0110.85truee9b1f2ac-027.33trueT8v2d4m5-04100false
A software demo
Believable allocations with grid_
id, grid_ name and region to fill a screen in front of a buyer.
This dataset150 rows13 columns
Yours1,000 rows13 columnsregion: UK only
blueprint · grid-energy-source-allocation-data
Behind this dataset
Same schema. As many rows as you need.
These 150 rows came out of a blueprint — 13 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
- Each row represents a specific grid substation’s hourly allocation.
- Energy sources are coded and percentage must total 100%.
- Renewable sources (solar, wind, hydro) must account for at least 15% of total on weekdays.
- Peak hours (18:00-22:00) prioritize lowest carbon sources.
- Outages are flagged and allocations default to backup generators.
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
- grid-energy-source-allocation-data