Ask the Grid
Open live grid

Substations

A point-level inventory of electric substations across the United States, drawn from the Homeland Infrastructure Foundation-Level Data (HIFLD) program.

HIFLDInfrastructure dataERCOT marketCAISO marketNYISO marketPJM marketSPP marketMISO marketISO-NE market
Query with the agentOpen on map
Native record
substation x source snapshot
snapshot publication cadence
Evidence
Reference data
Stable context used to interpret other datasets
In Ask the Grid
Substations on the ERCOT map
Geometry for the live grid surface

Overview

Each record locates a substation and describes its name, city and county, voltage class (minimum and maximum kV), the number of transmission lines connecting to it, its type, and its operating status. Substations are the nodes where voltage is stepped up or down and where transmission and distribution meet, so this dataset lets operators, planners, traders, and researchers see where the grid's switching and transformation points sit, gauge the relative importance of a node by its voltage and line count, and tie generation and load to the network that connects them.

Query contract

For the current inventory, select the maximum event_time first, then preserve one row per hifld_id. Keep older snapshots only for explicit inventory-history analysis.

Analysis rules

  • Never count or aggregate substations across multiple source snapshots.
  • Keep latitude and longitude bounds inside the connected market boundary.

Interpretation

  • HIFLD is infrastructure inventory evidence, not an electrical connectivity or power-flow model.
  • A visible substation does not establish spare capacity, deliverability, ownership approval, or interconnection feasibility.

Access

Query from your own tools

Use the guarded HTTP endpoint directly, or connect an MCP client and load the dataset contract with describe_data before calling query_data.

ERCOT MCP CAISO MCP NYISO MCP PJM MCP SPP MCP MISO MCP ISO-NE MCP BPA MCP API reference
HTTP endpoint
POST /api/v1/datasets/hifld_substations/query

Schema26

Column
Type
event_timeDateTime64(6, 'UTC')
hifld_idLowCardinality(String)
nameNullable(String)
typeNullable(String)
statusNullable(String)
cityNullable(String)
stateNullable(String)
zip_codeNullable(String)
countyNullable(String)
county_fipsNullable(String)
countryNullable(String)
latitudeNullable(Float64)
longitudeNullable(Float64)
max_voltNullable(Float64)
min_voltNullable(Float64)
max_inferNullable(String)
min_inferNullable(String)
linesNullable(Float64)
naics_codeNullable(String)
naics_descNullable(String)
sourceNullable(String)
source_dateNullable(String)
val_methodNullable(String)
val_dateNullable(String)
source_timeDateTime64(6, 'UTC')
ingested_atDateTime64(6, 'UTC')

Sample data

event_timehifld_idnametypestatuscitystatezip_codecountycounty_fipscountrylatitudelongitudemax_voltmin_voltmax_infermin_inferlinesnaics_codenaics_descsourcesource_dateval_methodval_datesource_timeingested_at
2026-09-22 06:00:06.083081311000TAP311000TAPNOT AVAILABLELITCHFIELD PARKAZ85354MARICOPA04013USA33.46481345900003-112.46172710199994132132YY3221121ELECTRIC BULK POWER TRANSMISSION AND CONTROLIMAGERY2018-11-02IMAGERY2020-03-302026-09-22 06:00:06.0830812026-09-22 06:00:19.601647
2026-09-22 06:00:06.083081310999UNKNOWN310999SUBSTATIONNOT AVAILABLEGOLDEN VALLEYAZ85354MARICOPA04013USA35.35515962100004-114.17308716699995-999999-999999YY-999999221121ELECTRIC BULK POWER TRANSMISSION AND CONTROLIMAGERY2018-04-13IMAGERY2018-03-302026-09-22 06:00:06.0830812026-09-22 06:00:19.601647
2026-09-22 06:00:06.083081310997TAP310997TAPNOT AVAILABLESALT FLATTX79847CULBERSON48109USA31.353615000000048-104.39398199999994-999999-999999NN-999999221121ELECTRIC BULK POWER TRANSMISSION AND CONTROLIMAGERY2019-12-16IMAGERY2020-04-212026-09-22 06:00:06.0830812026-09-22 06:00:19.601647
2026-09-22 06:00:06.083081310996TAP310996TAPNOT AVAILABLECHILDRESSTX79201CHILDRESS48075USA34.66704793500003-100.20360609599999-999999-999999NN-999999221121ELECTRIC BULK POWER TRANSMISSION AND CONTROLIMAGERY2019-02-20IMAGERY2020-04-212026-09-22 06:00:06.0830812026-09-22 06:00:19.601647
2026-09-22 06:00:06.083081310995UNISOURCE GOLDEN VALLEYSUBSTATIONNOT AVAILABLEGOLDEN VALLEYAZ86413MOHAVE04015USA35.221084537000024-114.18008639599998230230YY0221121ELECTRIC BULK POWER TRANSMISSION AND CONTROLhttps://www.uesaz.com/wp-content/uploads/2019/07/Alternatives-Examined-Aerial-Golden-Valley-36x48.pdf2019-07-01IMAGERY2020-03-012026-09-22 06:00:06.0830812026-09-22 06:00:19.601647
2026-09-22 06:00:06.083081310994HARRISSUBSTATIONIN SERVICEKINGMANAZ86401MOHAVE04015USA35.14399109400006-114.08667885099999230230YY0221121ELECTRIC BULK POWER TRANSMISSION AND CONTROLhttps://www.uesaz.com/wp-content/uploads/2019/07/Alternatives-Examined-Aerial-Full-Study-Area-24x36.pdf2019-07-01IMAGERY2020-03-012026-09-22 06:00:06.0830812026-09-22 06:00:19.601647
2026-09-22 06:00:06.083081310993TAP310993TAPNOT AVAILABLEKINGMANAZ86401MOHAVE04015USA35.20577078500003-114.09575804199994138138YY3221121ELECTRIC BULK POWER TRANSMISSION AND CONTROLIMAGERY2018-04-13IMAGERY2020-03-302026-09-22 06:00:06.0830812026-09-22 06:00:19.601647
2026-09-22 06:00:06.083081310992TAP310992TAPNOT AVAILABLEKINGMANAZ86401MOHAVE04015USA35.20571653700006-114.08341176099998138138YY3221121ELECTRIC BULK POWER TRANSMISSION AND CONTROLIMAGERY2018-04-13IMAGERY2020-03-302026-09-22 06:00:06.0830812026-09-22 06:00:19.601647
2026-09-22 06:00:06.083081310991TAP310991TAPNOT AVAILABLEGOLDEN VALLEYAZ86401MOHAVE04015USA35.21987067400005-114.13166559099994138138YY3221121ELECTRIC BULK POWER TRANSMISSION AND CONTROLIMAGERY2018-04-13IMAGERY2018-03-202026-09-22 06:00:06.0830812026-09-22 06:00:19.601647
2026-09-22 06:00:06.083081310990TAP310990TAPIN SERVICEKINGMANAZ86401MOHAVE04015USA35.20141943400006-114.08494847299994-999999-999999NOT AVAILABLENOT AVAILABLE0221121ELECTRIC BULK POWER TRANSMISSION AND CONTROLIMAGERY2020-05-15IMAGERY2020-05-152026-09-22 06:00:06.0830812026-09-22 06:00:19.601647
2026-09-22 06:00:06.083081310989TAP310989TAPNOT AVAILABLEKINGMANAZ86401MOHAVE04015USA35.158665607000046-114.07514518399995-999999-999999YY-999999221121ELECTRIC BULK POWER TRANSMISSION AND CONTROLIMAGERY2018-04-13IMAGERY2020-03-302026-09-22 06:00:06.0830812026-09-22 06:00:19.601647
2026-09-22 06:00:06.083081310988UNKNOWN310988SUBSTATIONNOT AVAILABLEKINGMANAZ86401MOHAVE04015USA35.21822003300008-114.05359201799996230-999999YY-999999221121ELECTRIC BULK POWER TRANSMISSION AND CONTROLIMAGERY2018-04-03IMAGERY2020-03-182026-09-22 06:00:06.0830812026-09-22 06:00:19.601647
2026-09-22 06:00:06.083081310987TAP310987TAPNOT AVAILABLEGOLDSMITHTX79741ECTOR48135USA32.01178477700006-102.61290345999998-999999-999999NN-999999221121ELECTRIC BULK POWER TRANSMISSION AND CONTROLIMAGERY2019-02-20IMAGERY2020-04-212026-09-22 06:00:06.0830812026-09-22 06:00:19.601647
2026-09-22 06:00:06.083081310986TAP310986TAPNOT AVAILABLEMONAHANSTX79756WARD48475USA31.71292814000003-102.90366486999994-999999-999999NN-999999221121ELECTRIC BULK POWER TRANSMISSION AND CONTROLIMAGERY2019-02-20IMAGERY2020-04-212026-09-22 06:00:06.0830812026-09-22 06:00:19.601647
2026-09-22 06:00:06.083081310985UNKNOWN310985SUBSTATIONIN SERVICESNYDERTX79549SCURRY48415USA32.87133768600006-100.97480829699998-999999-999999NOT AVAILABLENOT AVAILABLE0221121ELECTRIC BULK POWER TRANSMISSION AND CONTROLIMAGERY2020-05-15IMAGERY2020-05-152026-09-22 06:00:06.0830812026-09-22 06:00:19.601647
2026-09-22 06:00:06.083081310984TAP310984TAPNOT AVAILABLELAKEVIEWCA92567RIVERSIDE06065USA33.83474208900003-117.12283651599995-999999-999999NN-999999221121ELECTRIC BULK POWER TRANSMISSION AND CONTROLIMAGERY2018-12-02IMAGERY2020-04-212026-09-22 06:00:06.0830812026-09-22 06:00:19.601647
2026-09-22 06:00:06.083081310983TAP310983TAPNOT AVAILABLELAKEVIEWCA92567RIVERSIDE06065USA33.844389000000035-117.01628599999998-999999-999999NN-999999221121ELECTRIC BULK POWER TRANSMISSION AND CONTROLIMAGERY2018-12-02IMAGERY2020-04-212026-09-22 06:00:06.0830812026-09-22 06:00:19.601647
2026-09-22 06:00:06.083081310982TAP310982TAPNOT AVAILABLEPITTSBURGCA94565CONTRA COSTA06013USA37.987350769000045-121.87283067699997-999999-999999NN-999999221121ELECTRIC BULK POWER TRANSMISSION AND CONTROLIMAGERY2018-04-02IMAGERY2020-04-222026-09-22 06:00:06.0830812026-09-22 06:00:19.601647
2026-09-22 06:00:06.083081310981UNKOWNTAPNOT AVAILABLEPITTSBURGCA94565CONTRA COSTA06013USA37.999568768000074-121.78785687499999-999999-999999NN-999999221121ELECTRIC BULK POWER TRANSMISSION AND CONTROLIMAGERY2018-04-02IMAGERY2020-04-222026-09-22 06:00:06.0830812026-09-22 06:00:19.601647
2026-09-22 06:00:06.083081310980TAP310980TAPNOT AVAILABLEGOOD YEARAZ85326MARICOPA04013USA33.21798246800006-112.55008068799998-999999-999999YY-999999221121ELECTRIC BULK POWER TRANSMISSION AND CONTROLIMAGERY2018-11-02IMAGERY2020-03-212026-09-22 06:00:06.0830812026-09-22 06:00:19.601647
2026-09-22 06:00:06.083081310979TAP310979TAPNOT AVAILABLEMARICOPAAZ85139PINAL04021USA32.96240327100003-112.065162039999966969YY6221121ELECTRIC BULK POWER TRANSMISSION AND CONTROLIMAGERY2011-06-01IMAGERY2020-03-022026-09-22 06:00:06.0830812026-09-22 06:00:19.601647
2026-09-22 06:00:06.083081310978TAP310978TAPNOT AVAILABLESAN DIEGOCA92114SAN DIEGO06073USA32.69613344000004-117.04969973299995-999999-999999NN-999999221121ELECTRIC BULK POWER TRANSMISSION AND CONTROLIMAGERY2018-11-17IMAGERY2020-04-212026-09-22 06:00:06.0830812026-09-22 06:00:19.601647
2026-09-22 06:00:06.083081310975TAP310975TAPNOT AVAILABLECOVINACA91722LOS ANGELES06037USA34.09598120000004-117.925235499999996666YY3221121ELECTRIC BULK POWER TRANSMISSION AND CONTROLIMAGERY2019-03-01IMAGERY2020-04-212026-09-22 06:00:06.0830812026-09-22 06:00:19.601647
2026-09-22 06:00:06.083081310974TAP310974TAPNOT AVAILABLECOVINACA91722LOS ANGELES06037USA34.00924875000004-117.925358459999986666YY3221121ELECTRIC BULK POWER TRANSMISSION AND CONTROLIMAGERY2019-03-01IMAGERY2020-04-222026-09-22 06:00:06.0830812026-09-22 06:00:19.601647
2026-09-22 06:00:06.083081310973TAP310973TAPNOT AVAILABLEEASTVALECA91761SAN BERNADINO06071USA33.95910737000003-117.558127849999956666YY3221121ELECTRIC BULK POWER TRANSMISSION AND CONTROLIMAGERY2018-08-24IMAGERY2020-04-222026-09-22 06:00:06.0830812026-09-22 06:00:19.601647

Coverage

14.6% complete76 gap days13 days with data
Show coverage history
Coverage: 14.6%Days with data: 13Gaps: 76
2026
gaplessmore