YEAR MONTH U.S._STATE POSTAL.CODE NERC.REGION CLIMATE.REGION ANOMALY.LEVEL CLIMATE.CATEGORY OUTAGE.START.DATE OUTAGE.START.TIME OUTAGE.RESTORATION.DATE OUTAGE.RESTORATION.TIME CAUSE.CATEGORY CAUSE.CATEGORY.DETAIL HURRICANE.NAMES OUTAGE.DURATION DEMAND.LOSS.MW CUSTOMERS.AFFECTED RES.PRICE COM.PRICE IND.PRICE TOTAL.PRICE RES.SALES COM.SALES IND.SALES TOTAL.SALES RES.PERCEN COM.PERCEN IND.PERCEN RES.CUSTOMERS COM.CUSTOMERS IND.CUSTOMERS TOTAL.CUSTOMERS RES.CUST.PCT COM.CUST.PCT IND.CUST.PCT PC.REALGSP.STATE PC.REALGSP.USA PC.REALGSP.REL PC.REALGSP.CHANGE UTIL.REALGSP TOTAL.REALGSP UTIL.CONTRI PI.UTIL.OFUSA POPULATION POPPCT_URBAN POPPCT_UC POPDEN_URBAN POPDEN_UC POPDEN_RURAL AREAPCT_URBAN AREAPCT_UC PCT_LAND PCT_WATER_TOT PCT_WATER_INLAND Unnamed: 57
2011.0 7.0 Minnesota MN MRO East North Central -0.3 normal 2011-07-01 00:00:00 17:00:00 2011-07-03 00:00:00 20:00:00 severe weather NaN NaN 3060.0 NaN 70000.0 11.60 9.18 6.81 9.28 2332915.0 2114774.0 2113291.0 6562520.0 35.549073 32.225029 32.202431 2308736.0 276286.0 10673.0 2595696.0 88.944776 10.644005 0.411181 51268.0 47586.0 1.077376 1.6 4.802 274.182 1.751391 2.2 5348119.0 73.27 15.28 2279.0 1700.5 18.2 2.14 0.6 91.592666 8.407334 5.478743 99.999961
2014.0 5.0 Minnesota MN MRO East North Central -0.1 normal 2014-05-11 00:00:00 18:38:00 2014-05-11 00:00:00 18:39:00 intentional attack vandalism NaN 1.0 NaN NaN 12.12 9.71 6.49 9.28 1586986.0 1807756.0 1887927.0 5284231.0 30.032487 34.210389 35.727564 2345860.0 284978.0 9898.0 2640737.0 88.833534 10.791609 0.374820 53499.0 49091.0 1.089792 1.9 5.226 291.955 1.790002 2.2 5457125.0 73.27 15.28 2279.0 1700.5 18.2 2.14 0.6 91.592666 8.407334 5.478743 NaN
2010.0 10.0 Minnesota MN MRO East North Central -1.5 cold 2010-10-26 00:00:00 20:00:00 2010-10-28 00:00:00 22:00:00 severe weather heavy wind NaN 3000.0 NaN 70000.0 10.87 8.19 6.07 8.15 1467293.0 1801683.0 1951295.0 5222116.0 28.097672 34.501015 37.365983 2300291.0 276463.0 10150.0 2586905.0 88.920583 10.687018 0.392361 50447.0 47287.0 1.066826 2.7 4.571 267.895 1.706266 2.1 5310903.0 73.27 15.28 2279.0 1700.5 18.2 2.14 0.6 91.592666 8.407334 5.478743 NaN
2012.0 6.0 Minnesota MN MRO East North Central -0.1 normal 2012-06-19 00:00:00 04:30:00 2012-06-20 00:00:00 23:00:00 severe weather thunderstorm NaN 2550.0 NaN 68200.0 11.79 9.25 6.71 9.19 1851519.0 1941174.0 1993026.0 5787064.0 31.994099 33.543330 34.439329 2317336.0 278466.0 11010.0 2606813.0 88.895368 10.682239 0.422355 51598.0 48156.0 1.071476 0.6 5.364 277.627 1.932089 2.2 5380443.0 73.27 15.28 2279.0 1700.5 18.2 2.14 0.6 91.592666 8.407334 5.478743 NaN
2015.0 7.0 Minnesota MN MRO East North Central 1.2 warm 2015-07-18 00:00:00 02:00:00 2015-07-19 00:00:00 07:00:00 severe weather NaN NaN 1740.0 250.0 250000.0 13.07 10.16 7.74 10.43 2028875.0 2161612.0 1777937.0 5970339.0 33.982576 36.205850 29.779498 2374674.0 289044.0 9812.0 2673531.0 88.821637 10.811320 0.367005 54431.0 49844.0 1.092027 1.7 4.873 292.023 1.668704 2.2 5489594.0 73.27 15.28 2279.0 1700.5 18.2 2.14 0.6 91.592666 8.407334 5.478743 NaN