US Power Grid Interconnection Queue Scraper - CAISO, ERCOT, NYISO, SPP

One clean dataset of every solar, wind, battery storage, gas and large-load (data center) interconnection request from four US grid operators' public queue reports - normalised to a single schema: MW, fuel category, state, county, point of interconnection, developer, status, queue date and proposed commercial operation date.

Each ISO publishes its queue in a different spreadsheet layout with different codes. This Actor reads the latest file from each, decodes it, and gives you rows you can filter and join.

What's included

ISO	Source file	What you get
CAISO (California)	Public Queue Report (xlsx)	Active, completed and withdrawn projects; fuel mix, net MW, POI, utility, study process, IA status, current on-line date
ERCOT (Texas)	Latest monthly GIS Report (xlsx)	Large and small generators with developer (interconnecting entity), POI, study phase, projected COD, construction start; inactive projects
NYISO (New York)	Interconnection Queue (xlsx)	Queue, cluster projects, large-load requests (data centers, chip fabs, hydrogen), withdrawn and in-service; status codes decoded to text
SPP (14 central states)	Active queue CSV	Queue number, cluster, state, county, capacity, service type, status, cause of delay

Codes are translated using each ISO's own legend (e.g. NYISO CR = Storage + Solar, status 12 = Under Construction; ERCOT OTH/BA = Battery Storage). Every row also gets a common fuelCategory: Solar, Solar + Storage, Wind, Offshore Wind, Storage, Gas, Nuclear, Hydro, Transmission, Load and so on.

Who uses it?

• EPC contractors, substation and transmission builders, equipment vendors (transformers, switchgear, racking, BESS containers) - find projects heading toward construction, by county.
• Renewable developers and land teams - competitive intelligence and POI congestion.
• Data-center site selectors and utilities - see large-load requests and nearby generation.
• Investors, analysts, consultants - queue statistics by fuel, state, status and year.

Input examples

Default - active projects of 50 MW or more in all four ISOs:

{ "isos": ["CAISO", "ERCOT", "NYISO", "SPP"], "minMw": 50 }

Data-center and industrial large-load requests (NYISO):

{ "isos": ["NYISO"], "fuelCategories": ["Load"] }

Wind and storage in Kansas and Oklahoma (SPP):

{ "isos": ["SPP"], "states": ["KS", "OK"], "fuelCategories": ["Wind", "Storage"] }

Everything including withdrawn and completed history, with every original column:

{ "statusGroups": ["active", "completed", "withdrawn"], "includeRaw": true }

Output example

{
  "iso": "CAISO",
  "queueId": "32",
  "projectName": "TULE WIND",
  "developer": null,
  "fuel": "Wind Turbine + Battery",
  "fuelCategory": "Wind + Storage",
  "capacityMw": 193.8,
  "state": "CA",
  "county": "SAN DIEGO",
  "poi": "Boulevard East Substation 138 kV",
  "utility": "SDGE",
  "status": "ACTIVE",
  "statusGroup": "active",
  "requestType": "generation",
  "studyPhase": "Serial LGIP",
  "iaStatus": "Executed",
  "queueDate": "2004-05-24",
  "proposedCod": "2030-10-31",
  "sourceUrl": "https://www.caiso.com/documents/publicqueuereport.xlsx"
}

A NYISO large-load row looks like: "projectName": "North Country Data Center", "fuel": "Load (DAT-CM)", "capacityMw": 435, "county": "St. Lawrence", "status": "12 - Under Construction".

Field	Meaning
iso, queueId	Grid operator and its queue/INR/GI number
projectName, developer	Where the ISO publishes them (CAISO has no developer column; SPP publishes neither)
fuel, technology, fuelCategory	ISO wording plus a common category
capacityMw	Net MW to grid (CAISO), summer MW (NYISO), capacity (ERCOT/SPP), peak load MW for load requests
state, county, poi, utility, zone	Location and interconnection point
status, statusGroup	ISO status text and active / completed / withdrawn
requestType	generation or load
studyPhase, iaStatus	Study stage and interconnection agreement
queueDate, proposedCod, withdrawnDate, constructionStart	Key dates (ISO-8601 where the ISO gives a full date)
raw	Optional: every original column

Pricing

Pay-per-event:

Event	Price
Actor start	$0.01 per run
queue-project	$3.00 per 1,000 projects

Examples: all NYISO large-load requests (~50 rows) ~ $0.17. All active projects over 50 MW in four ISOs (~2,700 rows) ~ $8. Complete history of all four ISOs (~7,500 rows) ~ $22.

FAQ

Is this legal? Yes. All four files are public reports that CAISO, ERCOT, NYISO and SPP publish on their websites for anyone to download, without login. The Actor downloads each file once per run. It contains company and project data, not personal data. Treat the ISO as the authoritative source for any filing or investment decision.

Why not PJM, MISO and ISO-NE? PJM's queue export requires an authenticated API key and MISO's queue API sits behind a bot challenge; we don't bypass either. ISO-NE is on the roadmap. Tell us in Issues which you need most.

How fresh is it? Every run downloads the current file. CAISO and SPP update frequently, NYISO roughly monthly, ERCOT publishes the GIS Report monthly (the Actor picks the newest).

Why are some NYISO proposed CODs like "06-2028"? NYISO publishes month-year only; we pass it through unchanged rather than invent a day.

An ISO changed its spreadsheet and a column is empty? The Actor finds columns by header name, not position, so most layout changes are absorbed; if a sheet disappears the run logs a warning and still returns the other ISOs. Report it in Issues and we'll patch it.