outages_expanded

7,041 rows

View and edit SQL

outage earliest latest num_snapshots possible_duration_hours probably_ended min_estCustAffected max_estCustAffected latitude longitude
19151729 1575922559 1575925276 {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19151729","label":4} 0.75 1 4 4 38.03377 -84.54271
19151734 1575923456 1575924366 {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19151734","label":2} 0.25 1 7 7 37.55081 -86.19302
19151739 1575923456 1575927967 {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19151739","label":6} 1.25 1 4 4 38.12148 -84.60402
19151740 1575924366 1575926161 {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19151740","label":3} 0.5 1 4 4 37.70041 -85.86812
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
19151745 1575925276 1575930655 {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19151745","label":7} 1.49 1 8 8 37.53712 -85.73059
19151749 1575925276 1575933346 {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19151749","label":10} 2.24 1 4 4 37.99825 -84.50937
19151752 1575926161 1575929741 {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19151752","label":5} 0.99 1 4 4 38.13004 -83.5873
19151753 1575926161 1575933346 {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19151753","label":9} 2.0 1 4 4 37.99769 -84.50977
19151760 1575927074 1575937863 {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19151760","label":13} 3.0 1 4 4 38.25661 -85.73756
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
19151764 1575927967 1575933346 {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19151764","label":7} 1.49 1 4 4 37.30651 -84.23924
19151766 1575928851 1575930655 {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19151766","label":3} 0.5 1 4 4 37.05165 -88.06241
19151769 1575928851 1575935165 {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19151769","label":8} 1.75 1 49 49 37.50913 -85.8819
19151775 1575931540 1575934262 {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19151775","label":4} 0.76 1 69 69 36.60368 -83.71227
19151781 1575933346 1575940540 {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19151781","label":9} 2.0 1 4 7 36.73321 -83.42233
19151782 1575933346 1575939658 {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19151782","label":8} 1.75 1 4 4 36.73239 -83.4228
19151783 1575935165 1575937863 {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19151783","label":4} 0.75 1 4 6 37.99556 -84.51184
19151787 1575937863 1575938744 {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19151787","label":2} 0.24 1 727 727 37.55338 -88.00255
19151789 1575937863 1575938744 {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19151789","label":2} 0.24 1 981 981 37.52352 -87.95429
19151790 1575937863 1575938744 {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19151790","label":2} 0.24 1 250 250 37.64038 -87.99231
19151800 1575946854 1575947743 {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19151800","label":2} 0.25 1 10 10 38.21203 -85.67963
19151804 1575942336 1575947743 {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19151804","label":7} 1.5 1 4 4 38.2933 -85.59356
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
19151815 1575946854 1575953145 {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19151815","label":8} 1.75 1 4 4 38.06184 -85.66751
19151823 1575956739 1575966647 {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19151823","label":12} 2.75 1 5 5 36.96383 -82.53261
19151825 1575971150 1575988268 {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19151825","label":20} 4.75 1 13 13 38.05254 -84.72727
19151827 1575970254 1575972950 {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19151827","label":4} 0.75 1 4 4 37.97215 -84.48237
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
19151831 1575980152 1575988268 {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19151831","label":10} 2.25 1 139 139 38.65959 -83.78667
19151835 1575981062 1575988268 {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19151835","label":9} 2.0 1 4 4 38.19663 -85.56443
19151836 1575981062 1575984667 {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19151836","label":5} 1.0 1 4 4 38.19683 -85.56472
19151856 1575985555 1576012552 {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19151856","label":20} 7.5 1 4 4 38.0743 -84.50526
19151857 1575985555 1575988268 {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19151857","label":4} 0.75 1 9 9 37.67977 -85.90374
19151859 1575986466 1575988268 {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19151859","label":3} 0.5 1 7 7 38.23771 -85.70971
19151860 1575986466 1575988268 {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19151860","label":3} 0.5 1 10 10 38.23201 -85.62276
19151863 1575987370 1575988268 {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19151863","label":2} 0.25 1 4 4 38.00995 -84.92979
19151866 1575987370 1575988268 {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19151866","label":2} 0.25 1 8 8 37.62194 -84.77663
19151869 1575987370 1575988268 {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19151869","label":2} 0.25 1 4 4 38.14866 -85.79999
19151871 1575987370 1575999047 {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19151871","label":3} 3.24 1 4 4 36.84728 -83.31357
19151872 1575987370 1576001749 {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19151872","label":6} 3.99 1 4 4 38.42816 -83.87117
19151874 1575987370 1575988268 {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19151874","label":2} 0.25 1 4 4 38.73423 -85.06324
19151875 1575987370 1575988268 {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19151875","label":2} 0.25 1 5 5 37.04875 -84.62452
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
19151973 1575999047 1576013441 {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19151973","label":17} 4.0 1 4 4 38.24802 -85.66797
19152024 1576002653 1576024236 {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19152024","label":25} 6.0 1 4 4 38.19304 -85.11
19152026 1575999047 1576003542 {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19152026","label":6} 1.25 1 17 17 38.18773 -85.84787
19152032 1575999047 1576001749 {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19152032","label":4} 0.75 1 9 9 38.16782 -85.57818
19152034 1575999047 1576005356 {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19152034","label":8} 1.75 1 10 10 38.19945 -85.77875
19152036 1575999047 1576001749 {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19152036","label":4} 0.75 1 5 5 38.16723 -85.57936
19152040 1575999047 1576004440 {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19152040","label":7} 1.5 1 12 12 38.1882 -85.84397
19152042 1575999047 1576001749 {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19152042","label":4} 0.75 1 12 12 38.24745 -85.72699
19152043 1575999047 1576001749 {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19152043","label":4} 0.75 1 17 17 38.24777 -85.72637
19152049 1575999047 1576000865 {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19152049","label":3} 0.51 1 9 9 38.05843 -85.88084
19152052 1575999047 1576006238 {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19152052","label":9} 2.0 1 14 14 38.22367 -85.80697
19152060 1575999047 1576000865 {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19152060","label":3} 0.51 1 4 4 36.84648 -83.31461
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
19152063 1575999047 1576003542 {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19152063","label":6} 1.25 1 18 18 38.30612 -85.62282
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
19152075 1575999047 1575999943 {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19152075","label":2} 0.25 1 7 7 38.22313 -85.62255
19152081 1575999047 1576003542 {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19152081","label":6} 1.25 1 4 4 38.10871 -84.45597
19152082 1575999047 1576008074 {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19152082","label":11} 2.51 1 9 9 38.09264 -85.88167
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
19152088 1575999047 1575999943 {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19152088","label":2} 0.25 1 4 4 38.73486 -85.0643
19152093 1576000865 1576003542 {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19152093","label":4} 0.74 1 4 4 38.4784 -85.47555
19152094 1576001749 1576013441 {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19152094","label":14} 3.25 1 4 4 37.67884 -85.90257
19152097 1576002653 1576004440 {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19152097","label":3} 0.5 1 7 7 38.18852 -85.77624
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
19152101 1576002653 1576009849 {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19152101","label":9} 2.0 1 4 4 38.42816 -83.87117
19152102 1576003542 1576014337 {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19152102","label":13} 3.0 1 34 34 37.87139 -84.32685
19152104 1576003542 1576009849 {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19152104","label":8} 1.75 1 4 4 38.08646 -84.51
19152105 1576004440 1576008946 {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19152105","label":6} 1.25 1 4 4 37.30186 -84.2222
19152110 1576005356 1576008074 {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19152110","label":4} 0.76 1 4 4 38.13966 -85.64297
19152111 1576005356 1576008946 {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19152111","label":5} 1.0 1 4 4 38.15235 -85.56609
19152112 1576005356 1576013441 {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19152112","label":10} 2.25 1 4 4 37.91106 -85.31952
19152113 1576005356 1576007136 {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19152113","label":3} 0.49 1 6 6 38.23528 -85.62169
19152119 1576007136 1576008074 {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19152119","label":2} 0.26 1 4 4 37.77034 -84.31497
19152123 1576008074 1576016133 {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19152123","label":10} 2.24 1 4 4 38.21673 -85.64332
19152124 1576008074 1576013441 {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19152124","label":7} 1.49 1 10 10 38.14027 -85.66152
19152126 1576008074 1576015242 {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19152126","label":9} 1.99 1 4 4 38.19548 -85.75516
19152128 1576008074 1576010745 {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19152128","label":4} 0.74 1 4 4 36.9595 -82.46668
19152129 1576008074 1576014337 {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19152129","label":8} 1.74 1 4 4 38.25822 -85.6123
19152139 1576008946 1576011659 {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19152139","label":4} 0.75 1 4 4 37.86856 -84.32699
19152140 1576008946 1576015242 {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19152140","label":8} 1.75 1 5 5 38.23012 -85.62384
19152143 1576009849 1576012552 {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19152143","label":4} 0.75 1 11 11 38.2311 -85.62843
19152146 1576009849 1576014337 {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19152146","label":6} 1.25 1 4 4 38.26535 -85.82159
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
19152149 1576010745 1576011659 {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19152149","label":2} 0.25 1 4 4 38.25787 -85.43717
19152154 1576012552 1576018872 {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19152154","label":8} 1.76 1 4 4 38.01417 -84.45006
19152155 1576012552 1576015242 {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19152155","label":4} 0.75 1 4 4 36.61067 -83.72521
19152159 1576013441 1576014337 {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19152159","label":2} 0.25 1 6 6 37.99556 -84.51184
19152163 1576013441 1576032347 {"href":"https://lgeku-outages.herokuapp.com/outages/outage_snapshots?outage=19152163","label":22} 5.25 1 4 10 38.07412 -84.52471

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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
);
Powered by Datasette · Query took 6.733ms