SQL Playground

One power-grid region or neighbouring country.

• region_codeTEXTPK

  Region code (CAN and MEX for neighbouring countries)

• region_nameTEXT

  Region name

• countryTEXT

  ISO country code: US, CA or MX

• interconnectionTEXT · nullable

  U.S. interconnection: Eastern, Western or ERCOT; NULL outside the U.S.

One grid operator (balancing authority). Twelve have hourly detail; the rest appear only as interchange partners.

• ba_codeTEXTPK

  Grid operator code

• ba_nameTEXT

  Balancing authority name

• time_zoneTEXT

  Reporting time zone (Eastern, Central, Mountain, Arizona, Pacific)

• region_codeTEXT→ regions

  Region

• generation_onlyINTEGER

  1 for generation-only BAs with no load

• hourly_detailINTEGER

  1 for the twelve BAs whose hourly demand and generation are included

One energy source used for generation (for example coal, natural gas, or wind).

• fuel_codeTEXTPK

  Fuel code

• fuel_nameTEXT

  Fuel name

• is_renewableINTEGER

  1 for hydro, solar and wind

• is_fossilINTEGER

  1 for coal, natural gas and petroleum

• is_variableINTEGER

  1 for weather-dependent sources (solar, wind)

One calendar date, January–June 2024.

• dateTEXTPK

  Calendar date (YYYY-MM-DD)

• monthINTEGER

  Month number

• day_of_weekINTEGER

  0 = Sunday … 6 = Saturday

• is_weekendINTEGER

  1 on Saturday and Sunday

• holiday_nameTEXT · nullable

  U.S. federal holiday, NULL otherwise

• day_of_monthINTEGER

  Day of the month, 1–31

• day_nameTEXT

  Sunday … Saturday

One hour for one grid operator: electricity demand and the day-ahead forecast.

• ba_codeTEXTPK→ balancing_authorities

  Balancing authority

• hour_ending_utcTEXTPK

  End of the hour in UTC (YYYY-MM-DD HH:MM)

• hour_ending_localTEXT

  End of the hour in the BA’s local time; repeats or skips at daylight-saving changes

• demand_mwINTEGER · nullable

  Reported demand in MW (= MWh over the hour); NULL when not reported

• forecast_mwINTEGER · nullable

  Day-ahead demand forecast in MW; NULL when not reported

• local_dateTEXT→ calendar

  The BA’s local operating date the hour belongs to (YYYY-MM-DD)

• hour_numberINTEGER

  Hour of the local operating day, 1–24 (23 or 25 hours on daylight-saving change days)

• adjusted_demand_mwINTEGER · nullable

  Cleaned demand with anomalies replaced; NULL when unavailable

• demand_imputedINTEGER

  1 if this hour’s demand was filled in

One hour for one grid operator: power generated, power traded with neighbours, and generation by fuel.

• ba_codeTEXTPK→ balancing_authorities

  Balancing authority

• hour_ending_utcTEXTPK

  End of the hour in UTC

• net_generation_mwINTEGER · nullable

  Net generation in MW; NULL when not reported

• total_interchange_mwINTEGER · nullable

  Net flow out of the BA in MW (positive = exporting); NULL when not reported

• adjusted_net_generation_mwINTEGER · nullable

  Cleaned net generation; NULL when unavailable

• adjusted_total_interchange_mwINTEGER · nullable

  Cleaned total interchange; NULL when unavailable

• coal_mwINTEGER · nullable

  Net generation from coal; NULL when not reported

• natural_gas_mwINTEGER · nullable

  Net generation from natural gas; NULL when not reported

• nuclear_mwINTEGER · nullable

  Net generation from nuclear; NULL when not reported

• petroleum_mwINTEGER · nullable

  Net generation from petroleum products; NULL when not reported

• hydro_mwINTEGER · nullable

  Net generation from hydropower and pumped storage (negative while pumping); NULL when not reported

• solar_mwINTEGER · nullable

  Net generation from solar; NULL when not reported

• wind_mwINTEGER · nullable

  Net generation from wind; NULL when not reported

• other_mwINTEGER · nullable

  Net generation from other sources; NULL when not reported

• unknown_mwINTEGER · nullable

  Net generation from unknown sources; NULL when not reported

One day for one grid operator and one fuel: total generation that day.

• ba_codeTEXTPK→ balancing_authorities

  Balancing authority

• dateTEXTPK→ calendar

  Local calendar date of the BA

• fuel_codeTEXTPK→ fuel_types

  Energy source

• generation_mwhINTEGER

  Sum of reported hourly MW, i.e. MWh; can be negative (pumping, station use)

• hours_reportedINTEGER

  Hours with a reported value (23 or 25 on daylight-saving days)

One day of scheduled power flow from one grid operator to another.

• from_baTEXTPK→ balancing_authorities

  Reporting balancing authority

• to_baTEXTPK→ balancing_authorities

  Directly interconnected balancing authority

• dateTEXTPK→ calendar

  Local calendar date of from_ba

• interchange_mwhINTEGER · nullable

  Positive = flow from from_ba to to_ba; NULL when no hour was reported

• hours_reportedINTEGER

  Hours with a reported value