Loading dataset
Data viewTableSummary
Data viewTableSummary
Updated

79.7 MB across 137 parts, newest sealed 21 November 2026 at 18:34 UTC. The first build wrote 137 parts and 6.3M rows.

The check passed.
  • One row per operator hour passed.

balancing_authority

string

EIA code of the balancing authority (grid operator), e.g. PJM, ERCO, CISO.

  • AECI2%
  • AVA2%
  • BANC2%
  • Other (60)
Valid
6,342,773 · 100%
Missing
0 · 0%
Distinct
72 · 0% of valid

region

string

EIA region the balancing authority belongs to, e.g. MIDA, TEX, CAL.

  • NW33%
  • FLA15%
  • SW14%
  • Other (1)
Valid
6,342,773 · 100%
Missing
0 · 0%
Distinct
13 · 0% of valid

hour_utc

timestamp_utc

Start of the hour, UTC.

Timeline per year: 2015-01-01, 293,290; 2016-01-01, 579,744; 2017-01-01, 578,160; 2018-01-01, 575,285; 2019-01-01, 569,400; 2020-01-01, 562,349; 2021-01-01, 557,717; 2022-01-01, 548,957; 2023-01-01, 541,663; 2024-01-01, 535,824; 2025-01-01, 532,160; 2026-01-01, 468,224
2015-01-012026-01-01

per year

Valid
6,342,773 · 100%
Missing
0 · 0%
Distinct
99,892 · 1.6% of valid

row_kind

string

measured: EIA published demand for the hour. predicted: not published yet, so the model predicted it. not_reported: no demand and no prediction.

  • measured84%
  • not_reported16%
  • predicted0%
Valid
6,342,773 · 100%
Missing
0 · 0%
Distinct
3 · 0% of valid

is_prediction

boolean

True only on rows whose demand figure is a model prediction, not a measurement.

  • false100%
  • true0%
Valid
6,342,773 · 100%
Missing
0 · 0%
Distinct
2 · 0% of valid

demand_mw

number

Hourly demand the balancing authority reported to EIA. Empty on predicted rows.

Histogram: -429490415 to -107369113.125, 1; -107369113.125 to 214752188.75, 5,354,430; 214752188.75 to 536873490.625, 1; 536873490.625 to 858994792.5, 0; 858994792.5 to 1181116094.375, 0; 1181116094.375 to 1503237396.25, 0; 1503237396.25 to 1825358698.125, 1; 1825358698.125 to 2147480000, 1
-4294904152147480000
Valid
5,354,434 · 84.4%
Missing
988,339 · 15.6%
Missing over timeMissing share of demand_mw over time, 12% to 24%.
Distinct
118,643 · 2.2% of valid
Min
-429490415
25%
704
Median
2341
75%
6071
Max
2147480000

operator_forecast_mw

number

The balancing authority's own day-ahead demand forecast. Empty where EIA has none, including hours it shows as 0 because the forecast has not been filled in yet.

Histogram: -992136 to -809801.25, 2; -809801.25 to -627466.5, 0; -627466.5 to -445131.75, 0; -445131.75 to -262797, 0; -262797 to -80462.25, 17; -80462.25 to 101872.5, 5,323,256; 101872.5 to 284207.25, 26,194; 284207.25 to 466542, 3
-992136466542
Valid
5,349,472 · 84.3%
Missing
993,301 · 15.7%
Missing over timeMissing share of operator_forecast_mw over time, 12% to 25%.
Distinct
117,281 · 2.2% of valid
Min
-992136
25%
745
Median
2267
75%
5955
Max
466542

predicted_demand_mw

number

Model median of demand for an hour EIA has not published: the operator's forecast corrected by TabICLv2.

Histogram: 14.50329065322876 to 11244.23730558157, 998; 11244.23730558157 to 22473.971320509911, 93; 22473.971320509911 to 33703.705335438251, 58; 33703.705335438251 to 44933.439350366592, 4; 44933.439350366592 to 56163.173365294933, 20; 56163.173365294933 to 67392.907380223274, 13; 67392.907380223274 to 78622.641395151615, 11; 78622.641395151615 to 89852.375410079956, 24
14.5032906532287689852.375410079956
Valid
1,221 · 0%
Missing
6,341,552 · 100%
Missing over timeMissing share of predicted_demand_mw over time, 96% to 100%.
Distinct
1,221 · 100% of valid
Min
14.50329065322876
25%
870.50907254219055
Median
2343.2092804908752
75%
6151.3334999084473
Max
89852.375410079956

predicted_p10_mw

number

10th percentile of the model's prediction.

Histogram: 9.0610054135322571 to 10990.014670602977, 997; 10990.014670602977 to 21970.968335792422, 94; 21970.968335792422 to 32951.922000981867, 58; 32951.922000981867 to 43932.875666171312, 4; 43932.875666171312 to 54913.829331360757, 20; 54913.829331360757 to 65894.782996550202, 11; 65894.782996550202 to 76875.736661739647, 13; 76875.736661739647 to 87856.690326929092, 24
9.061005413532257187856.690326929092
Valid
1,221 · 0%
Missing
6,341,552 · 100%
Missing over timeMissing share of predicted_p10_mw over time, 96% to 100%.
Distinct
1,221 · 100% of valid
Min
9.0610054135322571
25%
842.43929868936539
Median
2036.2129938006401
75%
5887.1769979596138
Max
87856.690326929092

predicted_p90_mw

number

90th percentile of the model's prediction.

Histogram: 20.339680910110474 to 11459.469448238611, 997; 11459.469448238611 to 22898.599215567112, 94; 22898.599215567112 to 34337.728982895613, 58; 34337.728982895613 to 45776.858750224113, 6; 45776.858750224113 to 57215.988517552614, 18; 57215.988517552614 to 68655.118284881115, 13; 68655.118284881115 to 80094.248052209616, 11; 80094.248052209616 to 91533.377819538116, 24
20.33968091011047491533.377819538116
Valid
1,221 · 0%
Missing
6,341,552 · 100%
Missing over timeMissing share of predicted_p90_mw over time, 96% to 100%.
Distinct
1,221 · 100% of valid
Min
20.339680910110474
25%
940.61574053764343
Median
2458.1367588043213
75%
6357.6253867149353
Max
91533.377819538116

net_generation_mw

number

Net generation inside the balancing authority, EIA-adjusted.

Histogram: -398 to 20202.125, 5,707,650; 20202.125 to 40802.25, 297,337; 40802.25 to 61402.375, 85,985; 61402.375 to 82002.5, 94,724; 82002.5 to 102602.625, 68,160; 102602.625 to 123202.75, 22,045; 123202.75 to 143802.875, 6,150; 143802.875 to 164403, 746
-398164403
Valid
6,282,797 · 99.1%
Missing
59,976 · 0.9%
Missing over timeMissing share of net_generation_mw over time, 0% to 8%.
Distinct
119,877 · 1.9% of valid
Min
-398
25%
483
Median
1484
75%
5155
Max
164403

interchange_mw

number

Total interchange with neighbours, EIA-adjusted; positive is net export.

Histogram: -17149 to -13132.25, 6; -13132.25 to -9115.5, 8,434; -9115.5 to -5098.75, 92,323; -5098.75 to -1082, 707,142; -1082 to 2934.75, 5,258,876; 2934.75 to 6951.5, 141,810; 6951.5 to 10968.25, 51,703; 10968.25 to 14985, 7,025
-1714914985
Valid
6,267,319 · 98.8%
Missing
75,454 · 1.2%
Missing over timeMissing share of interchange_mw over time, 0% to 9%.
Distinct
24,131 · 0.4% of valid
Min
-17149
25%
-469
Median
-3
75%
380
Max
14985

gen_coal_mw

number

Net generation from coal, EIA-adjusted. Empty before July 2018.

Histogram: -73 to 5964.125, 2,332,136; 5964.125 to 12001.25, 130,330; 12001.25 to 18038.375, 68,462; 18038.375 to 24075.5, 41,405; 24075.5 to 30112.625, 25,963; 30112.625 to 36149.75, 12,694; 36149.75 to 42186.875, 5,230; 42186.875 to 48224, 787
-7348224
Valid
2,617,007 · 41.3%
Missing
3,725,766 · 58.7%
Missing over timeMissing share of gen_coal_mw over time, 41% to 100%.
Distinct
39,285 · 1.5% of valid
Min
-73
25%
150
Median
647
75%
2244
Max
48224

gen_gas_mw

number

Net generation from natural gas, EIA-adjusted. Empty before July 2018.

Histogram: -10 to 9482, 3,338,485; 9482 to 18974, 210,957; 18974 to 28466, 84,347; 28466 to 37958, 56,142; 37958 to 47450, 29,213; 47450 to 56942, 8,780; 56942 to 66434, 3,358; 66434 to 75926, 573
-1075926
Valid
3,731,855 · 58.8%
Missing
2,610,918 · 41.2%
Missing over timeMissing share of gen_gas_mw over time, 17% to 100%.
Distinct
55,714 · 1.5% of valid
Min
-10
25%
315
Median
787
75%
2509
Max
75926

gen_nuclear_mw

number

Net generation from nuclear, EIA-adjusted. Empty before July 2018.

Histogram: -10 to 5741.75, 971,370; 5741.75 to 11493.5, 242,615; 11493.5 to 17245.25, 25,090; 17245.25 to 22997, 0; 22997 to 28748.75, 11,886; 28748.75 to 34500.5, 58,958; 34500.5 to 40252.25, 999; 40252.25 to 46004, 24
-1046004
Valid
1,310,942 · 20.7%
Missing
5,031,831 · 79.3%
Missing over timeMissing share of gen_nuclear_mw over time, 68% to 100%.
Distinct
22,312 · 1.7% of valid
Min
-10
25%
1144
Median
3343
75%
5867
Max
46004

gen_oil_mw

number

Net generation from petroleum products, EIA-adjusted. Empty before July 2018.

Histogram: -10 to 1471.375, 1,536,805; 1471.375 to 2952.75, 3,070; 2952.75 to 4434.125, 736; 4434.125 to 5915.5, 361; 5915.5 to 7396.875, 93; 7396.875 to 8878.25, 15; 8878.25 to 10359.625, 6; 10359.625 to 11841, 15
-1011841
Valid
1,541,101 · 24.3%
Missing
4,801,672 · 75.7%
Missing over timeMissing share of gen_oil_mw over time, 61% to 100%.
Distinct
3,659 · 0.2% of valid
Min
-10
25%
0
Median
0
75%
0
Max
11841

gen_hydro_mw

number

Net generation from hydropower including pumped storage, EIA-adjusted. Empty before July 2018.

Histogram: -5798 to -3208.375, 4; -3208.375 to -618.75, 23,186; -618.75 to 1970.875, 3,045,184; 1970.875 to 4560.5, 198,585; 4560.5 to 7150.125, 39,723; 7150.125 to 9739.75, 24,237; 9739.75 to 12329.375, 9,568; 12329.375 to 14919, 2,125
-579814919
Valid
3,342,612 · 52.7%
Missing
3,000,161 · 47.3%
Missing over timeMissing share of gen_hydro_mw over time, 23% to 100%.
Distinct
15,705 · 0.5% of valid
Min
-5798
25%
22
Median
188
75%
724
Max
14919

gen_pumped_storage_mw

number

Net generation from pumped storage alone (from July 2024), EIA-adjusted. Empty before July 2018.

Histogram: -2342 to -1745.375, 1,063; -1745.375 to -1148.75, 5,447; -1148.75 to -552.125, 6,405; -552.125 to 44.5, 33,324; 44.5 to 641.125, 21,636; 641.125 to 1237.75, 8,075; 1237.75 to 1834.375, 3,154; 1834.375 to 2431, 643
-23422431
Valid
79,747 · 1.3%
Missing
6,263,026 · 98.7%
Missing over timeMissing share of gen_pumped_storage_mw over time, 92% to 100%.
Distinct
4,210 · 5.3% of valid
Min
-2342
25%
-68
Median
0
75%
299
Max
2431

gen_solar_mw

number

Net generation from solar, with and without integrated batteries, EIA-adjusted. Empty before July 2018.

Histogram: -391 to 4753.75, 3,034,214; 4753.75 to 9898.5, 35,695; 9898.5 to 15043.25, 19,468; 15043.25 to 20188, 7,320; 20188 to 25332.75, 2,022; 25332.75 to 30477.5, 1,194; 30477.5 to 35622.25, 450; 35622.25 to 40767, 2
-39140767
Valid
3,100,365 · 48.9%
Missing
3,242,408 · 51.1%
Missing over timeMissing share of gen_solar_mw over time, 27% to 100%.
Distinct
22,012 · 0.7% of valid
Min
-391
25%
0
Median
2
75%
151
Max
40767

gen_wind_mw

number

Net generation from wind, with and without integrated batteries, EIA-adjusted. Empty before July 2018.

Histogram: -25 to 3580.5, 2,048,676; 3580.5 to 7186, 84,795; 7186 to 10791.5, 48,850; 10791.5 to 14397, 40,163; 14397 to 18002.5, 34,271; 18002.5 to 21608, 21,501; 21608 to 25213.5, 6,386; 25213.5 to 28819, 871
-2528819
Valid
2,285,513 · 36%
Missing
4,057,260 · 64%
Missing over timeMissing share of gen_wind_mw over time, 47% to 100%.
Distinct
25,156 · 1.1% of valid
Min
-25
25%
15
Median
163
75%
724
Max
28819

gen_battery_mw

number

Net generation from standalone battery storage (from July 2024), EIA-adjusted. Empty before July 2018.

Histogram: -11553 to -8617.875, 48; -8617.875 to -5682.75, 207; -5682.75 to -2747.625, 801; -2747.625 to 187.5, 249,025; 187.5 to 3122.625, 33,585; 3122.625 to 6057.75, 962; 6057.75 to 8992.875, 253; 8992.875 to 11928, 66
-1155311928
Valid
284,947 · 4.5%
Missing
6,057,826 · 95.5%
Missing over timeMissing share of gen_battery_mw over time, 63% to 100%.
Distinct
6,637 · 2.3% of valid
Min
-11553
25%
-3
Median
0
75%
36
Max
11928

gen_other_mw

number

Net generation from other sources, geothermal and other storage, EIA-adjusted. Empty before July 2018.

Histogram: -10195 to -5528.5, 1,981; -5528.5 to -862, 14,813; -862 to 3804.5, 2,566,651; 3804.5 to 8471, 4,878; 8471 to 13137.5, 495; 13137.5 to 17804, 40; 17804 to 22470.5, 41; 22470.5 to 27137, 17
-1019527137
Valid
2,588,916 · 40.8%
Missing
3,753,857 · 59.2%
Missing over timeMissing share of gen_other_mw over time, 39% to 100%.
Distinct
13,138 · 0.5% of valid
Min
-10195
25%
14
Median
61
75%
246
Max
27137

gen_unknown_mw

number

Net generation from unknown fuel, EIA-adjusted. Empty before July 2018.

Histogram: 0, 14,905
00
Valid
14,905 · 0.2%
Missing
6,327,868 · 99.8%
Missing over timeMissing share of gen_unknown_mw over time, 98% to 100%.
Distinct
1 · 0% of valid
Min
0
25%
0
Median
0
75%
0
Max
0

temperature_c

number

Air temperature at one representative point for the balancing authority (Open-Meteo), 2026 onwards.

Histogram: -23.699999999999999 to -14.637500000000001, 528; -14.637500000000001 to -5.5749999999999993, 3,499; -5.5749999999999993 to 3.4874999999999972, 24,360; 3.4874999999999972 to 12.549999999999999, 83,013; 12.549999999999999 to 21.612500000000001, 125,355; 21.612500000000001 to 30.674999999999994, 126,482; 30.674999999999994 to 39.737499999999997, 37,571; 39.737499999999997 to 48.799999999999997, 2,963
-23.69999999999999948.799999999999997
Valid
403,771 · 6.4%
Missing
5,939,002 · 93.6%
Missing over timeMissing share of temperature_c over time, 13% to 100%.
Distinct
708 · 0.2% of valid
Min
-23.699999999999999
25%
11.699999999999999
Median
19.300000000000001
75%
25.699999999999999
Max
48.799999999999997

prediction_model

string

Pinned model that made the prediction.

  • jingang/tabicl-v2-90c3c47f100%
Valid
1,221 · 0%
Missing
6,341,552 · 100%
Missing over timeMissing share of prediction_model over time, 96% to 100%.
Distinct
1 · 0.1% of valid

model_trained_through

timestamp_utc

Newest measured hour the model trained on.

Timeline per hour: 2026-11-21T04:00Z, 384; 2026-11-21T05:00Z, 189; 2026-11-21T06:00Z, 144; 2026-11-21T07:00Z, 504
2026-11-21T04:00Z2026-11-21T07:00Z

per hour

Valid
1,221 · 0%
Missing
6,341,552 · 100%
Missing over timeMissing share of model_trained_through over time, 96% to 100%.
Distinct
4 · 0.3% of valid

lead_hours

integer

How far ahead the prediction is: hours after this operator's newest published demand hour. 1 is the first hour EIA has not published for the operator. Empty on measured and not-reported rows.

Histogram: 1 to 3, 150; 4 to 6, 153; 7 to 9, 153; 10 to 12, 153; 13 to 15, 153; 16 to 18, 153; 19 to 21, 153; 22 to 24, 153
124
Valid
1,221 · 0%
Missing
6,341,552 · 100%
Missing over timeMissing share of lead_hours over time, 96% to 100%.
Distinct
24 · 2% of valid
Min
1
25%
7
Median
13
75%
19
Max
24

Table profile

Profile of the served version, all rows, computed 21 Nov 2026, 18:41 UTC

PassedFreshnessLatest event 12 h after this version
PassedGapsNo empty months
PassedAnomaliesNo spikes or dips
PassedUnique keysEvery balancing_authority · hour_utc is unique
PassedChange since last profile+1,440 rows, 6,341,333 to 6,342,773, 9 columns with a new distinct count
Rows per month
Rows per month, 137 buckets from 1 Jul 2015 to 1 Nov 2026, at most 49,848 rows.60k1 Jul 2015: 49,468 rows1 Aug 2015: 49,848 rows1 Sept 2015: 48,240 rows1 Oct 2015: 49,110 rows1 Nov 2015: 47,520 rows1 Dec 2015: 49,104 rows1 Jan 2016: 49,104 rows1 Feb 2016: 45,936 rows1 Mar 2016: 49,104 rows1 Apr 2016: 47,520 rows1 May 2016: 49,104 rows1 Jun 2016: 47,520 rows1 Jul 2016: 49,104 rows1 Aug 2016: 49,104 rows1 Sept 2016: 47,520 rows1 Oct 2016: 49,104 rows1 Nov 2016: 47,520 rows1 Dec 2016: 49,104 rows1 Jan 2017: 49,104 rows1 Feb 2017: 44,352 rows1 Mar 2017: 49,104 rows1 Apr 2017: 47,520 rows1 May 2017: 49,104 rows1 Jun 2017: 47,520 rows1 Jul 2017: 49,104 rows1 Aug 2017: 49,104 rows1 Sept 2017: 47,520 rows1 Oct 2017: 49,104 rows1 Nov 2017: 47,520 rows1 Dec 2017: 49,104 rows1 Jan 2018: 49,104 rows1 Feb 2018: 44,352 rows1 Mar 2018: 49,104 rows1 Apr 2018: 47,520 rows1 May 2018: 48,415 rows1 Jun 2018: 46,800 rows1 Jul 2018: 48,377 rows1 Aug 2018: 49,104 rows1 Sept 2018: 47,520 rows1 Oct 2018: 49,104 rows1 Nov 2018: 47,520 rows1 Dec 2018: 48,365 rows1 Jan 2019: 48,360 rows1 Feb 2019: 43,680 rows1 Mar 2019: 48,360 rows1 Apr 2019: 46,800 rows1 May 2019: 48,360 rows1 Jun 2019: 46,800 rows1 Jul 2019: 48,360 rows1 Aug 2019: 48,360 rows1 Sept 2019: 46,800 rows1 Oct 2019: 48,360 rows1 Nov 2019: 46,800 rows1 Dec 2019: 48,360 rows1 Jan 2020: 47,789 rows1 Feb 2020: 44,544 rows1 Mar 2020: 47,616 rows1 Apr 2020: 46,080 rows1 May 2020: 47,616 rows1 Jun 2020: 46,080 rows1 Jul 2020: 47,616 rows1 Aug 2020: 47,616 rows1 Sept 2020: 46,080 rows1 Oct 2020: 47,616 rows1 Nov 2020: 46,080 rows1 Dec 2020: 47,616 rows1 Jan 2021: 47,616 rows1 Feb 2021: 43,008 rows1 Mar 2021: 47,616 rows1 Apr 2021: 46,080 rows1 May 2021: 47,616 rows1 Jun 2021: 46,080 rows1 Jul 2021: 47,616 rows1 Aug 2021: 47,616 rows1 Sept 2021: 45,365 rows1 Oct 2021: 46,872 rows1 Nov 2021: 45,360 rows1 Dec 2021: 46,872 rows1 Jan 2022: 46,872 rows1 Feb 2022: 42,336 rows1 Mar 2022: 46,872 rows1 Apr 2022: 45,360 rows1 May 2022: 46,872 rows1 Jun 2022: 45,360 rows1 Jul 2022: 46,872 rows1 Aug 2022: 46,872 rows1 Sept 2022: 44,645 rows1 Oct 2022: 46,128 rows1 Nov 2022: 44,640 rows1 Dec 2022: 46,128 rows1 Jan 2023: 46,128 rows1 Feb 2023: 41,664 rows1 Mar 2023: 46,128 rows1 Apr 2023: 44,640 rows1 May 2023: 46,128 rows1 Jun 2023: 44,640 rows1 Jul 2023: 46,128 rows1 Aug 2023: 46,128 rows1 Sept 2023: 44,640 rows1 Oct 2023: 46,128 rows1 Nov 2023: 43,927 rows1 Dec 2023: 45,384 rows1 Jan 2024: 45,384 rows1 Feb 2024: 42,456 rows1 Mar 2024: 45,384 rows1 Apr 2024: 43,920 rows1 May 2024: 45,384 rows1 Jun 2024: 43,920 rows1 Jul 2024: 45,384 rows1 Aug 2024: 45,384 rows1 Sept 2024: 43,920 rows1 Oct 2024: 45,384 rows1 Nov 2024: 43,920 rows1 Dec 2024: 45,384 rows1 Jan 2025: 45,384 rows1 Feb 2025: 40,992 rows1 Mar 2025: 45,384 rows1 Apr 2025: 43,920 rows1 May 2025: 45,384 rows1 Jun 2025: 43,922 rows1 Jul 2025: 45,384 rows1 Aug 2025: 45,384 rows1 Sept 2025: 43,920 rows1 Oct 2025: 44,646 rows1 Nov 2025: 43,200 rows1 Dec 2025: 44,640 rows1 Jan 2026: 44,640 rows1 Feb 2026: 40,320 rows1 Mar 2026: 44,640 rows1 Apr 2026: 43,202 rows1 May 2026: 44,640 rows1 Jun 2026: 43,200 rows1 Jul 2026: 44,640 rows1 Aug 2026: 44,640 rows1 Sept 2026: 43,200 rows1 Oct 2026: 44,640 rows1 Nov 2026: 30,462 rows
Rows per 3 months by balancing_authority, 10 of 72
Rows per 3 months by balancing_authority, 10 of 72, with the share of months that have rows on the right.AECI100%AVA100%BANC100%BPAT100%CHPD100%CISO100%CPLE100%CPLW100%DOPD100%DUK100%AECI: 99,889 rows, 0 of 137 buckets emptyAVA: 99,889 rows, 0 of 137 buckets emptyBANC: 99,889 rows, 0 of 137 buckets emptyBPAT: 99,889 rows, 0 of 137 buckets emptyCHPD: 99,889 rows, 0 of 137 buckets emptyCISO: 99,889 rows, 0 of 137 buckets emptyCPLE: 99,889 rows, 0 of 137 buckets emptyCPLW: 99,889 rows, 0 of 137 buckets emptyDOPD: 99,889 rows, 0 of 137 buckets emptyDUK: 99,889 rows, 0 of 137 buckets empty20162017201820192020202120222023202420252026

Support

Talk to Mostly Right

Loading chat…