outages_expanded
182,367 rows sorted by latitude
This data as json, CSV (advanced)
outage | earliest | latest | num_snapshots | possible_duration_hours | probably_ended | min_estCustAffected | max_estCustAffected | latitude ▼ | longitude |
---|---|---|---|---|---|---|---|---|---|
20103141 | 1602996362 | 1602996362 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=20103141","label":1} | 0.0 | 1 | 4 | 4 | 36.57616 | -88.94327 |
21131566 | 1639335141 | 1639336188 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=21131566","label":2} | 0.29 | 1 | 4 | 4 | 36.57616 | -88.94327 |
20118618 | 1607800663 | 1607804434 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=20118618","label":4} | 1.05 | 1 | 4 | 4 | 36.57652 | -88.94322 |
20093908 | 1600027349 | 1600033549 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=20093908","label":8} | 1.72 | 1 | 4 | 4 | 36.5766 | -88.93567 |
22082956 | 1656532138 | 1656542147 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=22082956","label":12} | 2.78 | 1 | 4 | 7 | 36.5766 | -88.93567 |
24020799 | 1709673596 | 1709674483 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=24020799","label":2} | 0.25 | 1 | 4 | 4 | 36.57706 | -88.94005 |
20117390 | 1607276959 | 1607283384 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=20117390","label":5} | 1.78 | 1 | 15 | 41 | 36.57708 | -88.93861 |
23167064 | 1701826187 | 1701833662 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=23167064","label":7} | 2.08 | 1 | 15 | 15 | 36.57708 | -88.94076 |
21137780 | 1641029006 | 1641029725 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=21137780","label":2} | 0.2 | 1 | 4 | 33 | 36.57739 | -88.93555 |
22035606 | 1649243415 | 1649251735 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=22035606","label":8} | 2.31 | 1 | 4 | 42 | 36.57739 | -88.93555 |
23161125 | 1699892718 | 1699901368 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=23161125","label":9} | 2.4 | 1 | 33 | 33 | 36.57739 | -88.93879 |
21137796 | 1641035244 | 1641036087 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=21137796","label":2} | 0.23 | 1 | 4 | 42 | 36.57742 | -88.93555 |
23015704 | 1677392670 | 1677396065 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=23015704","label":4} | 0.94 | 1 | 4 | 4 | 36.57742 | -88.93555 |
20103140 | 1602996362 | 1603013244 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=20103140","label":18} | 4.69 | 1 | 4 | 41 | 36.57771 | -88.9356 |
21000996 | 1609941677 | 1609941677 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=21000996","label":1} | 0.0 | 1 | 41 | 41 | 36.57771 | -88.93861 |
21001407 | 1610074922 | 1610091614 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=21001407","label":7} | 4.64 | 1 | 41 | 41 | 36.57771 | -88.93861 |
21002505 | 1610601794 | 1610616134 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=21002505","label":5} | 3.98 | 1 | 41 | 41 | 36.57771 | -88.93861 |
23159714 | 1699460729 | 1699472086 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=23159714","label":13} | 3.15 | 1 | 42 | 42 | 36.57771 | -88.93861 |
20118584 | 1607784031 | 1607790863 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=20118584","label":5} | 1.9 | 1 | 4 | 4 | 36.57774 | -88.9399 |
21130112 | 1639238176 | 1639247372 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=21130112","label":11} | 2.55 | 1 | 4 | 4 | 36.57888 | -88.93751 |
21131826 | 1639403667 | 1639432145 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=21131826","label":31} | 7.91 | 1 | 4 | 4 | 36.57888 | -88.93751 |
23114878 | 1689488674 | 1689499269 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=23114878","label":10} | 2.94 | 1 | 4 | 218 | 36.58044 | -83.60616 |
20068250 | 1594323998 | 1594345551 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=20068250","label":22} | 5.99 | 1 | 4 | 4 | 36.58733 | -83.89683 |
23128868 | 1691877013 | 1691901259 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=23128868","label":20} | 6.74 | 1 | 4 | 4 | 36.58733 | -83.89683 |
23134922 | 1693015860 | 1693020270 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=23134922","label":5} | 1.23 | 1 | 4 | 4 | 36.58733 | -83.89683 |
20046659 | 1590443196 | 1590449517 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=20046659","label":6} | 1.76 | 1 | 4 | 4 | 36.5876 | -83.90748 |
23054609 | 1679740463 | 1679747177 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=23054609","label":7} | 1.87 | 1 | 4 | 4 | 36.5876 | -83.90748 |
23112117 | 1688898941 | 1688914225 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=23112117","label":15} | 4.25 | 1 | 4 | 10 | 36.5876 | -83.89921 |
23113273 | 1689109565 | 1689128314 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=23113273","label":13} | 5.21 | 1 | 4 | 28 | 36.5876 | -83.88691 |
21129462 | 1639226606 | 1639242240 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=21129462","label":16} | 4.34 | 1 | 4 | 7 | 36.58769 | -83.89641 |
22094932 | 1658385712 | 1658424285 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=22094932","label":41} | 10.71 | 1 | 4 | 7 | 36.58769 | -83.89641 |
23099069 | 1687767324 | 1687769846 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=23099069","label":3} | 0.7 | 1 | 4 | 4 | 36.58769 | -83.89641 |
20005670 | 1579077963 | 1579112195 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=20005670","label":39} | 9.51 | 1 | 4 | 52 | 36.58795 | -83.8607 |
20042833 | 1589636801 | 1589640414 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=20042833","label":4} | 1.0 | 1 | 4 | 4 | 36.58795 | -83.90097 |
21077182 | 1626660889 | 1626665811 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=21077182","label":6} | 1.37 | 1 | 4 | 4 | 36.58795 | -83.90097 |
21111762 | 1634677490 | 1634680128 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=21111762","label":4} | 0.73 | 1 | 4 | 4 | 36.58795 | -83.90097 |
22060657 | 1653679320 | 1653686595 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=22060657","label":9} | 2.02 | 1 | 4 | 4 | 36.58795 | -83.90097 |
22152043 | 1671852694 | 1671895400 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=22152043","label":43} | 11.86 | 1 | 4 | 4 | 36.58795 | -83.90097 |
20091283 | 1599200719 | 1599200719 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=20091283","label":1} | 0.0 | 1 | 7 | 7 | 36.58806 | -83.90116 |
21087040 | 1628791787 | 1628797913 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=21087040","label":8} | 1.7 | 1 | 10 | 29 | 36.58847 | -83.88691 |
21133051 | 1639581911 | 1639588616 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=21133051","label":7} | 1.86 | 1 | 10 | 10 | 36.58847 | -83.89921 |
22006371 | 1643211663 | 1643217857 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=22006371","label":7} | 1.72 | 1 | 10 | 10 | 36.58847 | -83.89921 |
20031973 | 1586779445 | 1586791110 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=20031973","label":14} | 3.24 | 1 | 4 | 4 | 36.58914 | -83.90179 |
21129862 | 1639235196 | 1639235196 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=21129862","label":1} | 0.0 | 1 | 4 | 4 | 36.58914 | -83.90179 |
24032727 | 1712496837 | 1712507664 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=24032727","label":13} | 3.01 | 1 | 10 | 28 | 36.58926 | -83.88691 |
20005672 | 1579079771 | 1579079771 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=20005672","label":1} | 0.0 | 1 | 4 | 4 | 36.58947 | -83.89328 |
23007583 | 1675247025 | 1675247025 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=23007583","label":1} | 0.0 | 1 | 4 | 4 | 36.59001 | -83.89208 |
23113276 | 1689110460 | 1689110460 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=23113276","label":1} | 0.0 | 1 | 4 | 4 | 36.59001 | -83.89208 |
21072464 | 1625860146 | 1625864685 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=21072464","label":5} | 1.26 | 1 | 4 | 4 | 36.5901 | -83.77724 |
24000807 | 1704742470 | 1704753263 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=24000807","label":13} | 3.0 | 1 | 4 | 4 | 36.59012 | -83.77727 |
21026580 | 1615486684 | 1615491331 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=21026580","label":5} | 1.29 | 1 | 4 | 4 | 36.59039 | -83.76949 |
22066685 | 1654773741 | 1654776445 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=22066685","label":4} | 0.75 | 1 | 4 | 4 | 36.59141 | -83.76861 |
24017175 | 1708788854 | 1708789747 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=24017175","label":2} | 0.25 | 1 | 4 | 4 | 36.59141 | -83.76861 |
20005669 | 1579077963 | 1579080670 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=20005669","label":4} | 0.75 | 1 | 4 | 4 | 36.59142 | -83.88653 |
20077939 | 1595897030 | 1595906246 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=20077939","label":11} | 2.56 | 1 | 4 | 4 | 36.59142 | -83.88208 |
21137235 | 1640852661 | 1640852661 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=21137235","label":1} | 0.0 | 1 | 4 | 4 | 36.59142 | -83.88653 |
22015385 | 1645145735 | 1645156233 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=22015385","label":10} | 2.92 | 1 | 4 | 4 | 36.59142 | -83.88653 |
22094919 | 1658383570 | 1658383570 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=22094919","label":1} | 0.0 | 1 | 4 | 4 | 36.59142 | -83.88653 |
22126746 | 1666060779 | 1666069783 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=22126746","label":4} | 2.5 | 1 | 4 | 17 | 36.59142 | -83.8824 |
23098862 | 1687759980 | 1687772492 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=23098862","label":12} | 3.48 | 1 | 4 | 27 | 36.59142 | -83.88653 |
20041084 | 1589171474 | 1589195769 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=20041084","label":27} | 6.75 | 1 | 4 | 4 | 36.59145 | -83.70145 |
20048431 | 1590720353 | 1590736547 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=20048431","label":16} | 4.5 | 1 | 4 | 4 | 36.59145 | -83.70145 |
23103778 | 1688128029 | 1688134020 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=23103778","label":7} | 1.66 | 1 | 4 | 21 | 36.59145 | -83.70145 |
23130444 | 1692279274 | 1692291944 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=23130444","label":11} | 3.52 | 1 | 4 | 4 | 36.59145 | -83.70145 |
23127191 | 1691591743 | 1691600762 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=23127191","label":9} | 2.51 | 1 | 4 | 5 | 36.59181 | -83.70603 |
20072564 | 1594816292 | 1594854099 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=20072564","label":42} | 10.5 | 1 | 4 | 7 | 36.59194 | -83.78292 |
21024182 | 1614734527 | 1614742171 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=21024182","label":6} | 2.12 | 1 | 4 | 7 | 36.59194 | -83.78292 |
22073484 | 1655493124 | 1655498340 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=22073484","label":7} | 1.45 | 1 | 4 | 4 | 36.59205 | -83.72809 |
23069954 | 1681858149 | 1681861739 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=23069954","label":5} | 1.0 | 1 | 4 | 4 | 36.59205 | -83.72809 |
23158257 | 1699021345 | 1699022085 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=23158257","label":2} | 0.21 | 1 | 4 | 4 | 36.59205 | -83.72809 |
20012043 | 1581172281 | 1581190256 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=20012043","label":21} | 4.99 | 1 | 28 | 30 | 36.5925 | -83.88691 |
20031192 | 1586739700 | 1586772227 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=20031192","label":37} | 9.04 | 1 | 28 | 28 | 36.5925 | -83.8907 |
20031954 | 1586778516 | 1586873860 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=20031954","label":98} | 26.48 | 1 | 4 | 28 | 36.5925 | -83.8824 |
20091273 | 1599193387 | 1599200719 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=20091273","label":9} | 2.04 | 1 | 4 | 49 | 36.5925 | -83.82448 |
21060281 | 1623713085 | 1623716828 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=21060281","label":4} | 1.04 | 1 | 27 | 27 | 36.5925 | -83.8907 |
21077491 | 1626720020 | 1626721537 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=21077491","label":3} | 0.42 | 1 | 27 | 27 | 36.5925 | -83.8907 |
22126262 | 1665981519 | 1665986489 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=22126262","label":3} | 1.38 | 1 | 27 | 27 | 36.5925 | -83.8907 |
24032724 | 1712496242 | 1712496837 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=24032724","label":2} | 0.17 | 1 | 4 | 27 | 36.5925 | -83.88265 |
21052198 | 1622228364 | 1622230350 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=21052198","label":2} | 0.55 | 1 | 5 | 11 | 36.59258 | -83.72752 |
23090710 | 1686571673 | 1686579741 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=23090710","label":9} | 2.24 | 1 | 4 | 5 | 36.59258 | -83.72791 |
20021977 | 1584400565 | 1584407776 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=20021977","label":8} | 2.0 | 1 | 4 | 4 | 36.59265 | -83.88151 |
21026590 | 1615488238 | 1615491331 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=21026590","label":4} | 0.86 | 1 | 6 | 6 | 36.59294 | -83.79009 |
22073706 | 1655495117 | 1655498340 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=22073706","label":5} | 0.9 | 1 | 4 | 4 | 36.59294 | -83.7278 |
22091790 | 1657682729 | 1657699666 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=22091790","label":17} | 4.7 | 1 | 4 | 4 | 36.59294 | -83.7278 |
23014499 | 1677005410 | 1677018194 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=23014499","label":14} | 3.55 | 1 | 6 | 6 | 36.59295 | -83.7901 |
20063607 | 1593571589 | 1593590537 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=20063607","label":22} | 5.26 | 1 | 4 | 11 | 36.59315 | -83.72652 |
22091741 | 1657668934 | 1657708765 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=22091741","label":33} | 11.06 | 1 | 4 | 11 | 36.59315 | -83.72652 |
23090439 | 1686538204 | 1686540907 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=23090439","label":4} | 0.75 | 1 | 11 | 11 | 36.59315 | -83.72752 |
23061142 | 1680406798 | 1680478530 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=23061142","label":79} | 19.93 | 1 | 10 | 10 | 36.59319 | -83.70694 |
20009725 | 1580315473 | 1580320911 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=20009725","label":7} | 1.51 | 1 | 4 | 4 | 36.59325 | -83.70949 |
23058354 | 1680343624 | 1680346225 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=23058354","label":4} | 0.72 | 1 | 4 | 4 | 36.59325 | -83.70949 |
23059782 | 1680371656 | 1680372619 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=23059782","label":2} | 0.27 | 1 | 4 | 4 | 36.59325 | -83.70949 |
21074327 | 1626142460 | 1626144659 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=21074327","label":4} | 0.61 | 1 | 4 | 4 | 36.59348 | -83.72652 |
22090623 | 1657462953 | 1657465540 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=22090623","label":4} | 0.72 | 1 | 4 | 4 | 36.59348 | -83.72652 |
22091757 | 1657671697 | 1657700691 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=22091757","label":22} | 8.05 | 1 | 4 | 4 | 36.59348 | -83.72885 |
23092865 | 1687092813 | 1687096163 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=23092865","label":4} | 0.93 | 1 | 4 | 4 | 36.59348 | -83.72652 |
23093909 | 1687298783 | 1687308693 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=23093909","label":8} | 2.75 | 1 | 4 | 4 | 36.59348 | -83.72885 |
24020607 | 1709645648 | 1709653763 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=24020607","label":10} | 2.25 | 1 | 4 | 4 | 36.59348 | -83.72652 |
24045298 | 1715600933 | 1715608172 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=24045298","label":8} | 2.01 | 1 | 4 | 4 | 36.59348 | -83.72652 |
20080290 | 1596368813 | 1596398571 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=20080290","label":33} | 8.27 | 1 | 4 | 4 | 36.59352 | -83.73646 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE outages_expanded ( outage STR PRIMARY KEY, earliest INT, latest INT, num_snapshots TEXT, possible_duration_hours FLOAT, probably_ended TEXT, min_estCustAffected INT, max_estCustAffected INT, latitude TEXT, longitude TEXT );