outages_expanded
182,337 rows sorted by longitude
This data as json, CSV (advanced)
outage | earliest | latest | num_snapshots | possible_duration_hours | probably_ended | min_estCustAffected | max_estCustAffected | latitude | longitude ▼ |
---|---|---|---|---|---|---|---|---|---|
24031261 | 1712149639 | 1712158523 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=24031261","label":9} | 2.47 | 1 | 4 | 4 | 36.8906 | -82.23795 |
22084012 | 1656792304 | 1656804891 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=22084012","label":15} | 3.5 | 1 | 13 | 13 | 36.89096 | -82.24037 |
22156603 | 1672781703 | 1672793395 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=22156603","label":12} | 3.25 | 1 | 13 | 1690 | 36.88428 | -82.24037 |
22134388 | 1668023350 | 1668026219 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=22134388","label":4} | 0.8 | 1 | 4 | 4 | 36.92065 | -82.24365 |
23077556 | 1683582571 | 1683588138 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=23077556","label":7} | 1.55 | 1 | 4 | 4 | 36.92065 | -82.24365 |
23095198 | 1687587891 | 1687595725 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=23095198","label":9} | 2.18 | 1 | 4 | 43 | 36.9177 | -82.24452 |
22069675 | 1655225921 | 1655227445 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=22069675","label":3} | 0.42 | 1 | 4 | 4 | 36.91742 | -82.24492 |
23095197 | 1687587891 | 1687588590 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=23095197","label":2} | 0.19 | 1 | 4 | 4 | 36.91742 | -82.24492 |
23095196 | 1687587891 | 1687588590 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=23095196","label":2} | 0.19 | 1 | 4 | 4 | 36.92085 | -82.24652 |
23019563 | 1677875212 | 1677886707 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=23019563","label":9} | 3.19 | 1 | 4 | 4 | 36.91939 | -82.24661 |
20074644 | 1595277121 | 1595283429 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=20074644","label":8} | 1.75 | 1 | 4 | 4 | 36.94134 | -82.24713 |
20106129 | 1603805300 | 1603805926 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=20106129","label":2} | 0.17 | 1 | 4 | 4 | 36.94423 | -82.24795 |
24026115 | 1711125296 | 1711130776 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=24026115","label":7} | 1.52 | 1 | 4 | 4 | 36.94423 | -82.24795 |
20102947 | 1602882193 | 1602884770 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=20102947","label":4} | 0.72 | 1 | 4 | 4 | 36.9424 | -82.24819 |
21103199 | 1632422265 | 1632426549 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=21103199","label":5} | 1.19 | 1 | 4 | 4 | 36.9424 | -82.24819 |
22036708 | 1649541934 | 1649543710 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=22036708","label":3} | 0.49 | 1 | 4 | 4 | 36.9424 | -82.24819 |
24021986 | 1710124486 | 1710127360 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=24021986","label":4} | 0.8 | 1 | 23 | 23 | 36.94415 | -82.24886 |
22139480 | 1669663259 | 1669671247 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=22139480","label":9} | 2.22 | 1 | 4 | 4 | 36.94491 | -82.24889 |
24039432 | 1714254544 | 1714254544 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=24039432","label":1} | 0.0 | 1 | 4 | 4 | 36.91791 | -82.24889 |
24044622 | 1715350926 | 1715362480 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=24044622","label":13} | 3.21 | 1 | 4 | 4 | 36.92217 | -82.2491 |
22036045 | 1649336779 | 1649345883 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=22036045","label":10} | 2.53 | 1 | 34 | 111 | 36.9246 | -82.24918 |
22061518 | 1653994236 | 1654004828 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=22061518","label":10} | 2.94 | 1 | 4 | 34 | 36.9246 | -82.24918 |
22096054 | 1658615741 | 1658620119 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=22096054","label":6} | 1.22 | 1 | 4 | 65 | 36.94251 | -82.2497 |
22069703 | 1655226617 | 1655237161 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=22069703","label":13} | 2.93 | 1 | 4 | 4 | 36.94658 | -82.24975 |
22082220 | 1656415335 | 1656439520 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=22082220","label":24} | 6.72 | 1 | 4 | 4 | 36.94658 | -82.24975 |
21066832 | 1624826925 | 1624837720 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=21066832","label":10} | 3.0 | 1 | 4 | 24 | 36.94411 | -82.24979 |
23059652 | 1680370736 | 1680371656 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=23059652","label":2} | 0.26 | 1 | 24 | 24 | 36.94411 | -82.24979 |
24004401 | 1705332875 | 1705343072 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=24004401","label":12} | 2.83 | 1 | 24 | 65 | 36.94252 | -82.24979 |
24021947 | 1710106447 | 1710114551 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=24021947","label":10} | 2.25 | 1 | 4 | 24 | 36.94336 | -82.24979 |
20052447 | 1591623975 | 1591626673 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=20052447","label":4} | 0.75 | 1 | 4 | 4 | 36.94691 | -82.24994 |
23095205 | 1687597547 | 1687598514 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=23095205","label":2} | 0.27 | 1 | 4 | 4 | 36.92193 | -82.25005 |
24037091 | 1713535585 | 1713542795 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=24037091","label":9} | 2.0 | 1 | 4 | 4 | 36.92193 | -82.25005 |
24044621 | 1715349961 | 1715362480 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=24044621","label":14} | 3.48 | 1 | 4 | 4 | 36.92193 | -82.25005 |
22085217 | 1657075063 | 1657087608 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=22085217","label":9} | 3.48 | 1 | 4 | 4 | 36.9429 | -82.25078 |
23121518 | 1690617957 | 1690619659 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=23121518","label":3} | 0.47 | 1 | 4 | 4 | 36.91652 | -82.25107 |
21000110 | 1609540310 | 1609544957 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=21000110","label":3} | 1.29 | 1 | 4 | 4 | 36.94246 | -82.25166 |
23010975 | 1675979499 | 1675990297 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=23010975","label":9} | 3.0 | 1 | 4 | 4 | 36.88629 | -82.25181 |
22073665 | 1655495117 | 1655617008 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=22073665","label":113} | 33.86 | 1 | 43 | 43 | 36.92669 | -82.252 |
23059651 | 1680370736 | 1680371656 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=23059651","label":2} | 0.26 | 1 | 43 | 43 | 36.92669 | -82.252 |
23121484 | 1690597545 | 1690610746 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=23121484","label":12} | 3.67 | 1 | 43 | 43 | 36.92669 | -82.252 |
20091250 | 1599182098 | 1599186228 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=20091250","label":6} | 1.15 | 1 | 4 | 4 | 36.94125 | -82.25213 |
24038596 | 1713972209 | 1713979369 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=24038596","label":9} | 1.99 | 1 | 4 | 4 | 36.94125 | -82.25213 |
24021971 | 1710116434 | 1710127360 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=24021971","label":10} | 3.04 | 1 | 4 | 4 | 36.94336 | -82.25261 |
20043956 | 1589875276 | 1589888784 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=20043956","label":15} | 3.75 | 1 | 37 | 151 | 36.88351 | -82.25294 |
24004417 | 1705334763 | 1705336651 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=24004417","label":3} | 0.52 | 1 | 4 | 4 | 36.94179 | -82.25295 |
22036136 | 1649346846 | 1649351362 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=22036136","label":6} | 1.25 | 1 | 4 | 4 | 36.93112 | -82.25336 |
22061648 | 1654005970 | 1654012354 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=22061648","label":8} | 1.77 | 1 | 4 | 4 | 36.93112 | -82.25336 |
22102842 | 1659822583 | 1659828247 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=22102842","label":7} | 1.57 | 1 | 99 | 114 | 36.93283 | -82.2534 |
20103804 | 1603198973 | 1603207778 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=20103804","label":10} | 2.45 | 1 | 4 | 4 | 36.93107 | -82.25341 |
22105711 | 1660420122 | 1660425738 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=22105711","label":7} | 1.56 | 1 | 4 | 4 | 36.93107 | -82.25341 |
23059648 | 1680370736 | 1680413160 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=23059648","label":43} | 11.78 | 1 | 4 | 195 | 36.93027 | -82.25367 |
22096087 | 1658622176 | 1658633086 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=22096087","label":4} | 3.03 | 1 | 65 | 65 | 36.94251 | -82.2538 |
23019431 | 1677873098 | 1677886707 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=23019431","label":11} | 3.78 | 1 | 36 | 60 | 36.91253 | -82.25389 |
23169913 | 1702657492 | 1702661672 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=23169913","label":5} | 1.16 | 1 | 37 | 37 | 36.91352 | -82.25417 |
20034187 | 1587216681 | 1587220265 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=20034187","label":5} | 1.0 | 1 | 4 | 4 | 36.91267 | -82.25422 |
23127554 | 1691669319 | 1691672283 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=23127554","label":4} | 0.82 | 1 | 4 | 105 | 36.8868 | -82.25423 |
22016093 | 1645207495 | 1645208642 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=22016093","label":2} | 0.32 | 1 | 4 | 4 | 36.93934 | -82.25432 |
23143188 | 1694711175 | 1694718322 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=23143188","label":7} | 1.99 | 1 | 4 | 4 | 36.88488 | -82.25444 |
23095298 | 1687626323 | 1687631068 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=23095298","label":6} | 1.32 | 1 | 4 | 4 | 36.92795 | -82.25474 |
20093639 | 1599918395 | 1599921077 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=20093639","label":4} | 0.75 | 1 | 4 | 4 | 36.91343 | -82.25506 |
21082742 | 1627918987 | 1627923657 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=21082742","label":6} | 1.3 | 1 | 4 | 4 | 36.91343 | -82.25506 |
24027586 | 1711549368 | 1711551989 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=24027586","label":4} | 0.73 | 1 | 4 | 4 | 36.93956 | -82.25507 |
21067424 | 1624948805 | 1624952932 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=21067424","label":4} | 1.15 | 1 | 4 | 4 | 36.91249 | -82.25536 |
23171945 | 1703467769 | 1703473537 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=23171945","label":6} | 1.6 | 1 | 4 | 4 | 36.91249 | -82.25536 |
20044385 | 1589917585 | 1589918549 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=20044385","label":2} | 0.27 | 1 | 153 | 153 | 36.93314 | -82.25559 |
22102505 | 1659800986 | 1659824643 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=22102505","label":27} | 6.57 | 1 | 4 | 15 | 36.94334 | -82.25575 |
22091848 | 1657715196 | 1657724052 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=22091848","label":7} | 2.46 | 1 | 15 | 15 | 36.94334 | -82.25597 |
23061166 | 1680411160 | 1680453529 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=23061166","label":46} | 11.77 | 1 | 15 | 15 | 36.94334 | -82.25597 |
23156852 | 1698674762 | 1698694474 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=23156852","label":22} | 5.48 | 1 | 4 | 15 | 36.94062 | -82.25597 |
20044286 | 1589906794 | 1589917585 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=20044286","label":13} | 3.0 | 1 | 6 | 159 | 36.93172 | -82.25605 |
20050853 | 1591313475 | 1591315454 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=20050853","label":3} | 0.55 | 1 | 41 | 151 | 36.88011 | -82.25647 |
22123867 | 1665327936 | 1665332720 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=22123867","label":5} | 1.33 | 1 | 4 | 151 | 36.88428 | -82.25647 |
23127545 | 1691666395 | 1691672283 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=23127545","label":6} | 1.64 | 1 | 4 | 151 | 36.88118 | -82.25647 |
22114501 | 1662492846 | 1662498306 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=22114501","label":7} | 1.52 | 1 | 4 | 4 | 36.94443 | -82.25649 |
20050470 | 1591272070 | 1591274775 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=20050470","label":4} | 0.75 | 1 | 4 | 4 | 36.93867 | -82.25653 |
20050798 | 1591311699 | 1591315454 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=20050798","label":5} | 1.04 | 1 | 4 | 4 | 36.93867 | -82.25653 |
21004096 | 1611340478 | 1611344360 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=21004096","label":2} | 1.08 | 1 | 4 | 4 | 36.94062 | -82.25655 |
21120055 | 1636861708 | 1636861708 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=21120055","label":1} | 0.0 | 1 | 4 | 4 | 36.94062 | -82.25655 |
20043465 | 1589813206 | 1589813206 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=20043465","label":1} | 0.0 | 1 | 4 | 4 | 36.91153 | -82.25739 |
21054067 | 1622731572 | 1622736235 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=21054067","label":4} | 1.3 | 1 | 4 | 4 | 36.91153 | -82.25739 |
23121417 | 1690582933 | 1690612471 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=23121417","label":23} | 8.21 | 1 | 4 | 61 | 36.91153 | -82.25739 |
22068516 | 1654997735 | 1655003785 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=22068516","label":3} | 1.68 | 1 | 4 | 4 | 36.88768 | -82.25792 |
22100012 | 1659371129 | 1659371129 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=22100012","label":1} | 0.0 | 1 | 4 | 4 | 36.88768 | -82.25792 |
22073720 | 1655495535 | 1655500372 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=22073720","label":6} | 1.34 | 1 | 4 | 4 | 36.88362 | -82.25828 |
22073661 | 1655495117 | 1655509870 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=22073661","label":18} | 4.1 | 1 | 4 | 26 | 36.88483 | -82.25839 |
23080620 | 1684275793 | 1684279327 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=23080620","label":5} | 0.98 | 1 | 26 | 26 | 36.88527 | -82.25839 |
20065556 | 1594043209 | 1594048606 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=20065556","label":7} | 1.5 | 1 | 4 | 4 | 36.92384 | -82.25846 |
23121528 | 1690624147 | 1690648505 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=23121528","label":25} | 6.77 | 1 | 4 | 4 | 36.92311 | -82.25846 |
24034242 | 1712931731 | 1712941560 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=24034242","label":12} | 2.73 | 1 | 4 | 4 | 36.91139 | -82.25856 |
22134555 | 1668092768 | 1668110755 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=22134555","label":18} | 5.0 | 1 | 4 | 4 | 36.88586 | -82.25865 |
20041360 | 1589220127 | 1589222779 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=20041360","label":3} | 0.74 | 1 | 4 | 4 | 36.88691 | -82.25921 |
23070406 | 1682000515 | 1682014004 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=23070406","label":16} | 3.75 | 1 | 4 | 4 | 36.88691 | -82.25921 |
24038508 | 1713960536 | 1713968611 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=24038508","label":10} | 2.24 | 1 | 4 | 4 | 36.88694 | -82.25924 |
21115761 | 1635779410 | 1635783018 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=21115761","label":5} | 1.0 | 1 | 4 | 4 | 36.93776 | -82.25964 |
22073779 | 1655496708 | 1655500372 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=22073779","label":5} | 1.02 | 1 | 4 | 4 | 36.88447 | -82.25971 |
22121431 | 1664490267 | 1664490267 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=22121431","label":1} | 0.0 | 1 | 4 | 4 | 36.91096 | -82.26079 |
22063319 | 1654264212 | 1654268715 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=22063319","label":6} | 1.25 | 1 | 4 | 4 | 36.88682 | -82.26091 |
22067362 | 1654830631 | 1654837506 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=22067362","label":8} | 1.91 | 1 | 4 | 4 | 36.88682 | -82.26091 |
22073842 | 1655497628 | 1655500372 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=22073842","label":4} | 0.76 | 1 | 4 | 4 | 36.88514 | -82.26091 |
23173127 | 1703950460 | 1703953450 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=23173127","label":4} | 0.83 | 1 | 4 | 4 | 36.88682 | -82.26091 |
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 );