Skip to content

Data Sources

Power grid data is collected from various Independent System Operators (ISO) and the APIs that they provide. Here are links the avilable data viewers that the ISOs provide, as well as their APIs. Below are descriptions of the APIs that are used for data collection, and the data that is collected.

Midcontinent Independent System Operator

LMP data

MISO has the realtime 5-minute LMPs in the LMP Consolidated Table. This table includes additional data on HourlyIntegratedLMP, DayAheadExanteLMP, and the DayAheadExPostLMP.

{
  "LMPData": {
    "RefId": "28-Dec-2020 - Interval 15:35 EST",
    "FiveMinLMP": {
      "HourAndMin": "15:35",
      "PricingNode": [
          {
          "name": "EAI.ANO1",
          "region": "South",
          "LMP": "20.20",
          "MCC": "0.00",
          "MLC": "-0.94",
        },
        ...
      ]
    },
    "HourlyIntegratedLMP": {
      "HourAndMin": "HE 15",
      "PricingNode": [
          ...
      ]
    },
    "DayAheadExAnteLMP": {
      "HourAndMin": "HE 15",
      "PricingNode": [
          ...
      ]
    },
    "DayAheadExPostLMP": {
      "HourAndMin": "HE 15",
      "PricingNode": [
          ...
      ]
    }
  }
}

The PricingNode key contains the name of the pricing node, the MISO region (North or South), the LMP, and the component values MCC and MLC. See the LMP section on the SQL Storage page for information on how the data is stored.

Production Data

This API reports the amount of power in MW produced by each energy type in the current 5-minute interval. The categories are Coal,Natural Gas,Nuclear,Wind,Solar, and Other.

{
  "RefId": "28-Dec-2020 - Interval 16:25 EST",
  "TotalMW": "69849",
  "Fuel": {
    "Type": [
      {
        "INTERVALEST": "2020-12-28 4:25:00 PM",
        "CATEGORY": "Coal",
        "ACT": "32192",
        "FUEL_CATEGORY": "Coal  (32,192 MW)"
      },
      ...
    ]
  }
}

See the Production section on the SQL Storage page for information on how the data is stored.

Load Forecast

The MISO table Real-Time Total Load provides the ClearedMW load from the market settlement, the Medium Term Forecast (24-hour forecast for each hour of the day), and the real-time FiveMinTotalLoad, with a key for each 5 minute interval of the day so far. The Medium Term Forecast is used to store load forecast data for the MISO grid. See the Load Forecast section on the SQL Storage page for information on how the data is stored.

{
  "LoadInfo": {
    "RefId": "28-Dec-2020 - Interval 16:45 EST",
    "ClearedMW": [
      {
        "ClearedMWHourly": {
          "Hour": "1",
          "Value": "63325"
        }
      },
      ...
    ],
    "MediumTermLoadForecast": [
      {
        "Forecast": {
          "HourEnding": "1",
          "LoadForecast": "66287"
        }
      },
      ...
    ],
    "FiveMinTotalLoad": [
      {
        "Load": {
          "Time": "00:00",
          "Value": "66048"
        }
      },
      ...
    ]
  }
}

Wind Forecast

The MISO wind forecast API returns the hourly integrated forecast wind production for the following day. The snapshot of the forecast is captured at 3:45 p.m. MISO system time the day prior to the displayed day. See the Wind Forecast section on the SQL Storage page for information on how the data is stored.

{
  "MktDay": "12-28-2020",
  "RefId": "28-Dec-2020 - Interval 16:00 EST",
  "Forecast": [
    {
      "DateTimeEST": "2020-12-28 12:00:00 AM",
      "HourEndingEST": "1",
      "Value": "12202.00"
    },
  ]
}

PJM