outages_expanded
182,337 rows sorted by possible_duration_hours
This data as json, CSV (advanced)
outage | earliest | latest | num_snapshots | possible_duration_hours ▼ | probably_ended | min_estCustAffected | max_estCustAffected | latitude | longitude |
---|---|---|---|---|---|---|---|---|---|
19151408 | 1575775866 | 1575775866 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19151408","label":1} | 0.0 | 1 | 7 | 7 | 38.0736 | -83.84597 |
19151412 | 1575783971 | 1575783971 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19151412","label":1} | 0.0 | 1 | 4 | 4 | 38.15417 | -85.81856 |
19151415 | 1575801036 | 1575801036 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19151415","label":1} | 0.0 | 1 | 4 | 4 | 38.22467 | -85.69175 |
19151448 | 1575824574 | 1575824574 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19151448","label":1} | 0.0 | 1 | 4 | 4 | 37.33254 | -87.0349 |
19151461 | 1575826224 | 1575826224 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19151461","label":1} | 0.0 | 1 | 4 | 4 | 38.04185 | -84.74276 |
19151470 | 1575830735 | 1575830735 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19151470","label":1} | 0.0 | 1 | 4 | 4 | 38.03929 | -84.74123 |
19151520 | 1575865844 | 1575865844 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19151520","label":1} | 0.0 | 1 | 4 | 4 | 37.2422 | -87.43287 |
19151521 | 1575865844 | 1575865844 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19151521","label":1} | 0.0 | 1 | 4 | 4 | 37.24478 | -87.44384 |
19151522 | 1575865844 | 1575865844 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19151522","label":1} | 0.0 | 1 | 4 | 4 | 37.24124 | -87.43541 |
19151523 | 1575865844 | 1575865844 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19151523","label":1} | 0.0 | 1 | 4 | 4 | 37.24402 | -87.43801 |
19151529 | 1575884749 | 1575884749 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19151529","label":1} | 0.0 | 1 | 74 | 74 | 36.89354 | -82.54923 |
19151530 | 1575884749 | 1575884749 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19151530","label":1} | 0.0 | 1 | 4 | 4 | 36.89166 | -82.52914 |
19151632 | 1575910871 | 1575910871 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19151632","label":1} | 0.0 | 1 | 4 | 4 | 38.16788 | -85.60258 |
19151647 | 1575913566 | 1575913566 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19151647","label":1} | 0.0 | 1 | 4 | 4 | 36.99018 | -82.64845 |
19151689 | 1575919871 | 1575919871 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19151689","label":1} | 0.0 | 1 | 4 | 4 | 37.70212 | -87.64504 |
19151714 | 1575921681 | 1575921681 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19151714","label":1} | 0.0 | 1 | 14 | 14 | 38.22304 | -85.61564 |
19151723 | 1575921681 | 1575921681 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19151723","label":1} | 0.0 | 1 | 5 | 5 | 36.74387 | -83.65574 |
19151744 | 1575924366 | 1575924366 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19151744","label":1} | 0.0 | 1 | 451 | 451 | 38.09975 | -85.65764 |
19151762 | 1575927967 | 1575927967 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19151762","label":1} | 0.0 | 1 | 4 | 4 | 38.03882 | -84.28218 |
19151808 | 1575943244 | 1575943244 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19151808","label":1} | 0.0 | 1 | 4 | 4 | 38.11196 | -85.89538 |
19151830 | 1575975660 | 1575975660 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19151830","label":1} | 0.0 | 1 | 4 | 4 | 37.73157 | -84.31428 |
19151876 | 1575988268 | 1575988268 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19151876","label":1} | 0.0 | 1 | 4 | 4 | 37.04904 | -84.62664 |
19151877 | 1575988268 | 1575988268 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19151877","label":1} | 0.0 | 1 | 4 | 4 | 38.03877 | -85.68304 |
19151880 | 1575988268 | 1575988268 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19151880","label":1} | 0.0 | 1 | 3185 | 3185 | 38.00717 | -84.46155 |
19151898 | 1575988268 | 1575988268 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19151898","label":1} | 0.0 | 1 | 153 | 153 | 38.02572 | -84.46726 |
19151902 | 1575988268 | 1575988268 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19151902","label":1} | 0.0 | 1 | 698 | 698 | 38.02146 | -84.47446 |
19151913 | 1575988268 | 1575988268 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19151913","label":1} | 0.0 | 1 | 4 | 4 | 38.30585 | -85.62279 |
19151932 | 1575988268 | 1575988268 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19151932","label":1} | 0.0 | 1 | 4 | 4 | 38.22904 | -85.73377 |
19151966 | 1575988268 | 1575988268 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19151966","label":1} | 0.0 | 1 | 4 | 4 | 38.0197 | -84.48075 |
19151968 | 1575988268 | 1575988268 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19151968","label":1} | 0.0 | 1 | 4 | 4 | 38.01291 | -84.4254 |
19152062 | 1575999047 | 1575999047 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19152062","label":1} | 0.0 | 1 | 4 | 4 | 37.34324 | -84.82615 |
19152073 | 1575999047 | 1575999047 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19152073","label":1} | 0.0 | 1 | 4 | 4 | 38.2488 | -85.81778 |
19152086 | 1575999047 | 1575999047 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19152086","label":1} | 0.0 | 1 | 4 | 4 | 38.00884 | -84.47804 |
19152098 | 1576002653 | 1576002653 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19152098","label":1} | 0.0 | 1 | 4 | 4 | 38.20684 | -85.3821 |
19152147 | 1576009849 | 1576009849 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19152147","label":1} | 0.0 | 1 | 4 | 4 | 38.00884 | -84.47804 |
19152171 | 1576015242 | 1576015242 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19152171","label":1} | 0.0 | 1 | 4 | 4 | 38.02537 | -84.80237 |
19152174 | 1576015242 | 1576015242 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19152174","label":1} | 0.0 | 1 | 4 | 4 | 38.0394 | -84.8378 |
19152189 | 1576019755 | 1576019755 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19152189","label":1} | 0.0 | 1 | 4 | 4 | 37.96773 | -84.24493 |
19152204 | 1576025146 | 1576025146 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19152204","label":1} | 0.0 | 1 | 4 | 4 | 38.15273 | -85.82041 |
19152211 | 1576027855 | 1576027855 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19152211","label":1} | 0.0 | 1 | 4 | 4 | 36.88637 | -83.02164 |
19152221 | 1576044949 | 1576044949 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19152221","label":1} | 0.0 | 1 | 4 | 4 | 38.19034 | -85.79892 |
19152326 | 1576078285 | 1576078285 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19152326","label":1} | 0.0 | 1 | 4 | 4 | 37.91157 | -85.31873 |
19152351 | 1576080068 | 1576080068 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19152351","label":1} | 0.0 | 1 | 4 | 4 | 38.19547 | -85.79673 |
19152365 | 1576080068 | 1576080068 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19152365","label":1} | 0.0 | 1 | 4 | 4 | 38.23508 | -85.78381 |
19152368 | 1576080068 | 1576080068 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19152368","label":1} | 0.0 | 1 | 506 | 506 | 38.23194 | -85.77865 |
19152420 | 1576088178 | 1576088178 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19152420","label":1} | 0.0 | 1 | 4 | 4 | 38.21014 | -85.72261 |
19152421 | 1576089085 | 1576089085 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19152421","label":1} | 0.0 | 1 | 4 | 4 | 38.17325 | -84.42975 |
19152426 | 1576089969 | 1576089969 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19152426","label":1} | 0.0 | 1 | 4 | 4 | 36.93592 | -82.60719 |
19152427 | 1576089969 | 1576089969 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19152427","label":1} | 0.0 | 1 | 4 | 4 | 37.91157 | -85.31873 |
19152478 | 1576098054 | 1576098054 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19152478","label":1} | 0.0 | 1 | 4 | 4 | 37.55168 | -87.98987 |
19152484 | 1576097147 | 1576097147 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19152484","label":1} | 0.0 | 1 | 4 | 4 | 38.18636 | -85.76013 |
19152520 | 1576106152 | 1576106152 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19152520","label":1} | 0.0 | 1 | 4 | 4 | 38.19381 | -85.67836 |
19152529 | 1576109737 | 1576109737 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19152529","label":1} | 0.0 | 1 | 9 | 9 | 38.22395 | -85.72932 |
19152531 | 1576110667 | 1576110667 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19152531","label":1} | 0.0 | 1 | 4 | 4 | 38.00562 | -85.71129 |
19152535 | 1576111588 | 1576111588 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19152535","label":1} | 0.0 | 1 | 4 | 4 | 38.06886 | -85.69077 |
19152540 | 1576114241 | 1576114241 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19152540","label":1} | 0.0 | 1 | 4 | 4 | 38.1503 | -85.65575 |
19152548 | 1576125038 | 1576125038 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19152548","label":1} | 0.0 | 1 | 4 | 4 | 38.17626 | -85.6252 |
19152581 | 1576158351 | 1576158351 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19152581","label":1} | 0.0 | 1 | 4 | 4 | 37.58674 | -84.60477 |
19152596 | 1576160142 | 1576160142 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19152596","label":1} | 0.0 | 1 | 852 | 852 | 38.13112 | -85.86254 |
19152597 | 1576160142 | 1576160142 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19152597","label":1} | 0.0 | 1 | 1738 | 1738 | 38.1442 | -85.87626 |
19152598 | 1576160142 | 1576160142 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19152598","label":1} | 0.0 | 1 | 1746 | 1746 | 38.12099 | -85.8724 |
19152599 | 1576160142 | 1576160142 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19152599","label":1} | 0.0 | 1 | 2333 | 2333 | 38.14326 | -85.8626 |
19152600 | 1576160142 | 1576160142 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19152600","label":1} | 0.0 | 1 | 26 | 26 | 38.12664 | -85.88525 |
19152601 | 1576160142 | 1576160142 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19152601","label":1} | 0.0 | 1 | 360 | 360 | 38.12603 | -85.89621 |
19152602 | 1576160142 | 1576160142 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19152602","label":1} | 0.0 | 1 | 599 | 599 | 38.14318 | -85.89206 |
19152620 | 1576161943 | 1576161943 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19152620","label":1} | 0.0 | 1 | 4 | 4 | 38.21316 | -85.57426 |
19152622 | 1576161943 | 1576161943 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19152622","label":1} | 0.0 | 1 | 169 | 169 | 38.22165 | -85.63169 |
19152623 | 1576161943 | 1576161943 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19152623","label":1} | 0.0 | 1 | 4 | 4 | 38.22127 | -85.63071 |
19152625 | 1576161943 | 1576161943 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19152625","label":1} | 0.0 | 1 | 4 | 4 | 38.22615 | -85.63925 |
19152627 | 1576161943 | 1576161943 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19152627","label":1} | 0.0 | 1 | 1939 | 1939 | 38.21727 | -85.6375 |
19152659 | 1576162850 | 1576162850 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19152659","label":1} | 0.0 | 1 | 27 | 27 | 36.6954 | -83.69574 |
19152687 | 1576164641 | 1576164641 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19152687","label":1} | 0.0 | 1 | 4 | 4 | 38.25055 | -85.52411 |
19152695 | 1576165532 | 1576165532 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19152695","label":1} | 0.0 | 1 | 4 | 4 | 38.24493 | -85.5676 |
19152717 | 1576168238 | 1576168238 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19152717","label":1} | 0.0 | 1 | 4 | 4 | 38.21665 | -85.60225 |
19152728 | 1576169142 | 1576169142 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19152728","label":1} | 0.0 | 1 | 4 | 4 | 36.88218 | -82.72647 |
19152733 | 1576171839 | 1576171839 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19152733","label":1} | 0.0 | 1 | 4 | 4 | 38.22944 | -85.75637 |
19152735 | 1576170069 | 1576170069 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19152735","label":1} | 0.0 | 1 | 4 | 4 | 37.12867 | -84.10605 |
19152736 | 1576170069 | 1576170069 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19152736","label":1} | 0.0 | 1 | 4 | 4 | 38.41765 | -85.55628 |
19152737 | 1576170069 | 1576170069 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19152737","label":1} | 0.0 | 1 | 4 | 4 | 38.41806 | -85.55632 |
19152751 | 1576174545 | 1576174545 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19152751","label":1} | 0.0 | 1 | 1548 | 1548 | 36.64315 | -83.45104 |
19152775 | 1576174545 | 1576174545 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19152775","label":1} | 0.0 | 1 | 356 | 356 | 36.75426 | -83.46699 |
19152868 | 1576174545 | 1576174545 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19152868","label":1} | 0.0 | 1 | 4 | 4 | 36.73425 | -83.38345 |
19152877 | 1576175459 | 1576175459 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19152877","label":1} | 0.0 | 1 | 4 | 4 | 36.62785 | -83.53003 |
19152880 | 1576175459 | 1576175459 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19152880","label":1} | 0.0 | 1 | 4 | 4 | 36.69209 | -83.34822 |
19152881 | 1576175459 | 1576175459 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19152881","label":1} | 0.0 | 1 | 4 | 4 | 36.67638 | -83.36098 |
19152882 | 1576175459 | 1576175459 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19152882","label":1} | 0.0 | 1 | 4 | 4 | 36.62268 | -83.48064 |
19152883 | 1576175459 | 1576175459 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19152883","label":1} | 0.0 | 1 | 4 | 4 | 36.62891 | -83.5217 |
19152884 | 1576175459 | 1576175459 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19152884","label":1} | 0.0 | 1 | 4 | 4 | 36.67122 | -83.36767 |
19152885 | 1576175459 | 1576175459 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19152885","label":1} | 0.0 | 1 | 4 | 4 | 36.67657 | -83.3569 |
19152887 | 1576175459 | 1576175459 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19152887","label":1} | 0.0 | 1 | 4 | 4 | 36.6334 | -83.44622 |
19152888 | 1576175459 | 1576175459 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19152888","label":1} | 0.0 | 1 | 4 | 4 | 36.63722 | -83.42811 |
19152889 | 1576175459 | 1576175459 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19152889","label":1} | 0.0 | 1 | 4 | 4 | 36.7366 | -83.24846 |
19152891 | 1576175459 | 1576175459 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19152891","label":1} | 0.0 | 1 | 4 | 4 | 36.61582 | -83.44318 |
19152892 | 1576175459 | 1576175459 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19152892","label":1} | 0.0 | 1 | 4 | 4 | 36.66017 | -83.38555 |
19152893 | 1576175459 | 1576175459 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19152893","label":1} | 0.0 | 1 | 4 | 4 | 36.67483 | -83.36931 |
19152905 | 1576177268 | 1576177268 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19152905","label":1} | 0.0 | 1 | 4 | 4 | 36.75533 | -83.02788 |
19152998 | 1576196153 | 1576196153 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19152998","label":1} | 0.0 | 1 | 4 | 4 | 38.14778 | -85.83793 |
19153003 | 1576197052 | 1576197052 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19153003","label":1} | 0.0 | 1 | 4 | 4 | 38.2098 | -85.80045 |
19153012 | 1576213276 | 1576213276 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19153012","label":1} | 0.0 | 1 | 4 | 4 | 38.14834 | -85.8677 |
19153080 | 1576250147 | 1576250147 | {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19153080","label":1} | 0.0 | 1 | 4 | 4 | 36.93094 | -82.62643 |
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 );