Ask the Grid
Open live grid

Overview

A point-level inventory of electric substations across the United States, drawn from the Homeland Infrastructure Foundation-Level Data (HIFLD) program. 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.

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 rows

event_timehifld_idnametypestatuscitystatezip_codecountycounty_fipscountrylatitudelongitudemax_voltmin_voltmax_infermin_inferlinesnaics_codenaics_descsourcesource_dateval_methodval_datesource_timeingested_at
2026-08-04 06:00:09.326030311000TAP311000TAPNOT AVAILABLELITCHFIELD PARKAZ85354MARICOPA04013USA33.46481345900003-112.46172710199994132132YY3221121ELECTRIC BULK POWER TRANSMISSION AND CONTROLIMAGERY2018-11-02IMAGERY2020-03-302026-08-04 06:00:09.3260302026-08-04 06:00:26.378800
2026-08-04 06:00:09.326030310999UNKNOWN310999SUBSTATIONNOT AVAILABLEGOLDEN VALLEYAZ85354MARICOPA04013USA35.35515962100004-114.17308716699995-999999-999999YY-999999221121ELECTRIC BULK POWER TRANSMISSION AND CONTROLIMAGERY2018-04-13IMAGERY2018-03-302026-08-04 06:00:09.3260302026-08-04 06:00:26.378800
2026-08-04 06:00:09.326030310997TAP310997TAPNOT AVAILABLESALT FLATTX79847CULBERSON48109USA31.353615000000048-104.39398199999994-999999-999999NN-999999221121ELECTRIC BULK POWER TRANSMISSION AND CONTROLIMAGERY2019-12-16IMAGERY2020-04-212026-08-04 06:00:09.3260302026-08-04 06:00:26.378800
2026-08-04 06:00:09.326030310996TAP310996TAPNOT AVAILABLECHILDRESSTX79201CHILDRESS48075USA34.66704793500003-100.20360609599999-999999-999999NN-999999221121ELECTRIC BULK POWER TRANSMISSION AND CONTROLIMAGERY2019-02-20IMAGERY2020-04-212026-08-04 06:00:09.3260302026-08-04 06:00:26.378800
2026-08-04 06:00:09.326030310995UNISOURCE 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-08-04 06:00:09.3260302026-08-04 06:00:26.378800
2026-08-04 06:00:09.326030310994HARRISSUBSTATIONIN 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-08-04 06:00:09.3260302026-08-04 06:00:26.378800
2026-08-04 06:00:09.326030310993TAP310993TAPNOT AVAILABLEKINGMANAZ86401MOHAVE04015USA35.20577078500003-114.09575804199994138138YY3221121ELECTRIC BULK POWER TRANSMISSION AND CONTROLIMAGERY2018-04-13IMAGERY2020-03-302026-08-04 06:00:09.3260302026-08-04 06:00:26.378800
2026-08-04 06:00:09.326030310992TAP310992TAPNOT AVAILABLEKINGMANAZ86401MOHAVE04015USA35.20571653700006-114.08341176099998138138YY3221121ELECTRIC BULK POWER TRANSMISSION AND CONTROLIMAGERY2018-04-13IMAGERY2020-03-302026-08-04 06:00:09.3260302026-08-04 06:00:26.378800
2026-08-04 06:00:09.326030310991TAP310991TAPNOT AVAILABLEGOLDEN VALLEYAZ86401MOHAVE04015USA35.21987067400005-114.13166559099994138138YY3221121ELECTRIC BULK POWER TRANSMISSION AND CONTROLIMAGERY2018-04-13IMAGERY2018-03-202026-08-04 06:00:09.3260302026-08-04 06:00:26.378800
2026-08-04 06:00:09.326030310990TAP310990TAPIN SERVICEKINGMANAZ86401MOHAVE04015USA35.20141943400006-114.08494847299994-999999-999999NOT AVAILABLENOT AVAILABLE0221121ELECTRIC BULK POWER TRANSMISSION AND CONTROLIMAGERY2020-05-15IMAGERY2020-05-152026-08-04 06:00:09.3260302026-08-04 06:00:26.378800
2026-08-04 06:00:09.326030310989TAP310989TAPNOT AVAILABLEKINGMANAZ86401MOHAVE04015USA35.158665607000046-114.07514518399995-999999-999999YY-999999221121ELECTRIC BULK POWER TRANSMISSION AND CONTROLIMAGERY2018-04-13IMAGERY2020-03-302026-08-04 06:00:09.3260302026-08-04 06:00:26.378800
2026-08-04 06:00:09.326030310988UNKNOWN310988SUBSTATIONNOT AVAILABLEKINGMANAZ86401MOHAVE04015USA35.21822003300008-114.05359201799996230-999999YY-999999221121ELECTRIC BULK POWER TRANSMISSION AND CONTROLIMAGERY2018-04-03IMAGERY2020-03-182026-08-04 06:00:09.3260302026-08-04 06:00:26.378800
2026-08-04 06:00:09.326030310987TAP310987TAPNOT AVAILABLEGOLDSMITHTX79741ECTOR48135USA32.01178477700006-102.61290345999998-999999-999999NN-999999221121ELECTRIC BULK POWER TRANSMISSION AND CONTROLIMAGERY2019-02-20IMAGERY2020-04-212026-08-04 06:00:09.3260302026-08-04 06:00:26.378800
2026-08-04 06:00:09.326030310986TAP310986TAPNOT AVAILABLEMONAHANSTX79756WARD48475USA31.71292814000003-102.90366486999994-999999-999999NN-999999221121ELECTRIC BULK POWER TRANSMISSION AND CONTROLIMAGERY2019-02-20IMAGERY2020-04-212026-08-04 06:00:09.3260302026-08-04 06:00:26.378800
2026-08-04 06:00:09.326030310985UNKNOWN310985SUBSTATIONIN SERVICESNYDERTX79549SCURRY48415USA32.87133768600006-100.97480829699998-999999-999999NOT AVAILABLENOT AVAILABLE0221121ELECTRIC BULK POWER TRANSMISSION AND CONTROLIMAGERY2020-05-15IMAGERY2020-05-152026-08-04 06:00:09.3260302026-08-04 06:00:26.378800
2026-08-04 06:00:09.326030310984TAP310984TAPNOT AVAILABLELAKEVIEWCA92567RIVERSIDE06065USA33.83474208900003-117.12283651599995-999999-999999NN-999999221121ELECTRIC BULK POWER TRANSMISSION AND CONTROLIMAGERY2018-12-02IMAGERY2020-04-212026-08-04 06:00:09.3260302026-08-04 06:00:26.378800
2026-08-04 06:00:09.326030310983TAP310983TAPNOT AVAILABLELAKEVIEWCA92567RIVERSIDE06065USA33.844389000000035-117.01628599999998-999999-999999NN-999999221121ELECTRIC BULK POWER TRANSMISSION AND CONTROLIMAGERY2018-12-02IMAGERY2020-04-212026-08-04 06:00:09.3260302026-08-04 06:00:26.378800
2026-08-04 06:00:09.326030310982TAP310982TAPNOT AVAILABLEPITTSBURGCA94565CONTRA COSTA06013USA37.987350769000045-121.87283067699997-999999-999999NN-999999221121ELECTRIC BULK POWER TRANSMISSION AND CONTROLIMAGERY2018-04-02IMAGERY2020-04-222026-08-04 06:00:09.3260302026-08-04 06:00:26.378800
2026-08-04 06:00:09.326030310981UNKOWNTAPNOT AVAILABLEPITTSBURGCA94565CONTRA COSTA06013USA37.999568768000074-121.78785687499999-999999-999999NN-999999221121ELECTRIC BULK POWER TRANSMISSION AND CONTROLIMAGERY2018-04-02IMAGERY2020-04-222026-08-04 06:00:09.3260302026-08-04 06:00:26.378800
2026-08-04 06:00:09.326030310980TAP310980TAPNOT AVAILABLEGOOD YEARAZ85326MARICOPA04013USA33.21798246800006-112.55008068799998-999999-999999YY-999999221121ELECTRIC BULK POWER TRANSMISSION AND CONTROLIMAGERY2018-11-02IMAGERY2020-03-212026-08-04 06:00:09.3260302026-08-04 06:00:26.378800
2026-08-04 06:00:09.326030310979TAP310979TAPNOT AVAILABLEMARICOPAAZ85139PINAL04021USA32.96240327100003-112.065162039999966969YY6221121ELECTRIC BULK POWER TRANSMISSION AND CONTROLIMAGERY2011-06-01IMAGERY2020-03-022026-08-04 06:00:09.3260302026-08-04 06:00:26.378800
2026-08-04 06:00:09.326030310978TAP310978TAPNOT AVAILABLESAN DIEGOCA92114SAN DIEGO06073USA32.69613344000004-117.04969973299995-999999-999999NN-999999221121ELECTRIC BULK POWER TRANSMISSION AND CONTROLIMAGERY2018-11-17IMAGERY2020-04-212026-08-04 06:00:09.3260302026-08-04 06:00:26.378800
2026-08-04 06:00:09.326030310975TAP310975TAPNOT AVAILABLECOVINACA91722LOS ANGELES06037USA34.09598120000004-117.925235499999996666YY3221121ELECTRIC BULK POWER TRANSMISSION AND CONTROLIMAGERY2019-03-01IMAGERY2020-04-212026-08-04 06:00:09.3260302026-08-04 06:00:26.378800
2026-08-04 06:00:09.326030310974TAP310974TAPNOT AVAILABLECOVINACA91722LOS ANGELES06037USA34.00924875000004-117.925358459999986666YY3221121ELECTRIC BULK POWER TRANSMISSION AND CONTROLIMAGERY2019-03-01IMAGERY2020-04-222026-08-04 06:00:09.3260302026-08-04 06:00:26.378800
2026-08-04 06:00:09.326030310973TAP310973TAPNOT AVAILABLEEASTVALECA91761SAN BERNADINO06071USA33.95910737000003-117.558127849999956666YY3221121ELECTRIC BULK POWER TRANSMISSION AND CONTROLIMAGERY2018-08-24IMAGERY2020-04-222026-08-04 06:00:09.3260302026-08-04 06:00:26.378800

Coverage

15.0% complete34 gap days6 days with data
Show coverage history ▾
Coverage: 15.0%Days with data: 6Gaps: 34
2026
gaplessmore