outages

495 rows where regionName = 99

View and edit SQL

id outageStartTime latitude longitude regionName outageDevices
633673 October 01, 2019 - 15:36:34 UTC 38.34058 -122.75968 Sebastopol 99 []
634335 October 01, 2019 - 19:32:00 UTC 38.35184 -122.8177 Sebastopol 99 []
638566 October 02, 2019 - 22:51:11 UTC 38.40783 -122.89598 Sebastopol 99 []
638665 October 02, 2019 - 23:17:04 UTC 38.40601 -122.83269 Sebastopol 99 []
639095 October 03, 2019 - 15:59:43 UTC 38.40594 -122.83862 Sebastopol 99 [{"latitude": "38.40574", "longitude": "-122.84197"}, {"latitude": "38.40581", "longitude": "-122.8388"}, {"latitude": "38.4061", "longitude": "-122.83945"}, {"latitude": "38.40642", "longitude": "-122.84088"}, {"latitude": "38.40667", "longitude": "-122.84283"}]
641694 October 03, 2019 - 23:00:00 UTC 38.40704 -122.84327 Sebastopol 99 []
641795 October 03, 2019 - 23:34:54 UTC 38.35398 -122.81833 Sebastopol 99 []
642973 October 04, 2019 - 16:31:00 UTC 38.3496 -122.78377 Sebastopol 99 []
643406 October 04, 2019 - 17:28:37 UTC 38.41258 -122.82967 Sebastopol 99 []
643759 October 04, 2019 - 22:55:15 UTC 38.35168 -122.81849 Sebastopol 99 [{"latitude": "38.3515", "longitude": "-122.81992"}, {"latitude": "38.35285", "longitude": "-122.81999"}, {"latitude": "38.35383", "longitude": "-122.82162"}, {"latitude": "38.35259", "longitude": "-122.82206"}]
645092 October 06, 2019 - 01:00:00 UTC 38.4071 -122.93134 Sebastopol 99 [{"latitude": "38.40089", "longitude": "-122.9324"}, {"latitude": "38.41892", "longitude": "-122.91134"}, {"latitude": "38.42229", "longitude": "-122.90988"}, {"latitude": "38.42681", "longitude": "-122.9123"}, {"latitude": "38.4276", "longitude": "-122.91275"}, {"latitude": "38.44904", "longitude": "-122.95212"}, {"latitude": "38.44905", "longitude": "-122.95675"}, {"latitude": "38.44877", "longitude": "-122.95921"}, {"latitude": "38.41525", "longitude": "-122.94682"}, {"latitude": "38.40645", "longitude": "-122.94102"}, {"latitude": "38.40525", "longitude": "-122.94002"}, {"latitude": "38.40137", "longitude": "-122.93423"}]
645123 October 06, 2019 - 01:54:00 UTC 38.41502 -122.92146 Sebastopol 99 []
645150 October 06, 2019 - 04:01:22 UTC 38.43325 -122.88584 Sebastopol 99 []
646138 October 07, 2019 - 18:45:39 UTC 38.40277 -122.84353 Sebastopol 99 []
646207 October 07, 2019 - 20:12:55 UTC 38.40226 -122.82899 Sebastopol 99 []
647392 October 08, 2019 - 17:33:10 UTC 38.42592 -122.95824 Sebastopol 99 []
647459 October 08, 2019 - 17:27:33 UTC 38.42592 -122.95824 Sebastopol 99 []
647547 October 08, 2019 - 21:11:10 UTC 38.3781 -122.92643 Sebastopol 99 [{"latitude": "38.37675", "longitude": "-122.92232"}, {"latitude": "38.38365", "longitude": "-122.9157"}, {"latitude": "38.38471", "longitude": "-122.91476"}, {"latitude": "38.38629", "longitude": "-122.91364"}, {"latitude": "38.38977", "longitude": "-122.91499"}, {"latitude": "38.38473", "longitude": "-122.92188"}, {"latitude": "38.38277", "longitude": "-122.92317"}, {"latitude": "38.37829", "longitude": "-122.92552"}]
647580 October 08, 2019 - 22:17:31 UTC 38.41595 -122.90147 Sebastopol 99 []
650736 October 09, 2019 - 15:15:34 UTC 38.39273 -122.81212 Sebastopol 99 []
652602 October 10, 2019 - 13:34:00 UTC 38.35102 -122.88179 Sebastopol 99 []
653662 October 10, 2019 - 23:57:41 UTC 38.40128 -122.84578 Sebastopol 99 []
653881 October 11, 2019 - 03:07:00 UTC 38.35102 -122.88179 Sebastopol 99 []
654283 October 11, 2019 - 16:55:17 UTC 38.40488 -122.88428 Sebastopol 99 []
655165 October 12, 2019 - 17:43:08 UTC 38.40507 -122.84511 Sebastopol 99 [{"latitude": "38.40382", "longitude": "-122.84277"}, {"latitude": "38.40417", "longitude": "-122.83977"}, {"latitude": "38.40507", "longitude": "-122.83986"}, {"latitude": "38.40695", "longitude": "-122.8439"}, {"latitude": "38.40498", "longitude": "-122.84379"}]
655166 October 12, 2019 - 17:44:21 UTC 38.40438 -122.84497 Sebastopol 99 []
655193 October 12, 2019 - 18:13:00 UTC 38.40438 -122.84497 Sebastopol 99 []
655242 October 12, 2019 - 19:54:45 UTC 38.40417 -122.83977 Sebastopol 99 []
655527 October 13, 2019 - 15:30:29 UTC 38.4767 -122.85228 Sebastopol 99 []
659278 October 15, 2019 - 18:08:44 UTC 38.3647 -122.78479 Sebastopol 99 []
660454 October 16, 2019 - 15:59:40 UTC 38.34932 -122.82588 Sebastopol 99 [{"latitude": "38.34801", "longitude": "-122.83037"}, {"latitude": "38.34937", "longitude": "-122.82719"}, {"latitude": "38.3498", "longitude": "-122.82789"}]
662533 October 16, 2019 - 21:52:00 UTC 38.40533 -122.87728 Sebastopol 99 []
662534 October 16, 2019 - 21:53:00 UTC 38.40458 -122.88062 Sebastopol 99 []
663224 October 17, 2019 - 02:51:15 UTC 38.40825 -122.90017 Sebastopol 99 []
663395 October 17, 2019 - 14:21:25 UTC 38.39066 -122.88398 Sebastopol 99 []
663396 October 17, 2019 - 14:21:23 UTC 38.39011 -122.88536 Sebastopol 99 [{"latitude": "38.39013", "longitude": "-122.88537"}, {"latitude": "38.39271", "longitude": "-122.88523"}, {"latitude": "38.39464", "longitude": "-122.88526"}, {"latitude": "38.39658", "longitude": "-122.88691"}, {"latitude": "38.39906", "longitude": "-122.89202"}, {"latitude": "38.39755", "longitude": "-122.89935"}, {"latitude": "38.39734", "longitude": "-122.89964"}, {"latitude": "38.396", "longitude": "-122.8988"}, {"latitude": "38.39138", "longitude": "-122.89267"}]
663974 October 17, 2019 - 15:33:00 UTC 38.39449 -122.89456 Sebastopol 99 []
664453 October 17, 2019 - 17:09:24 UTC 38.38119 -122.8551 Sebastopol 99 []
665494 October 17, 2019 - 19:05:05 UTC 38.35963 -122.78161 Sebastopol 99 []
665514 October 17, 2019 - 19:07:48 UTC 38.35824 -122.7789 Sebastopol 99 [{"latitude": "38.35262", "longitude": "-122.78838"}, {"latitude": "38.35824", "longitude": "-122.77918"}, {"latitude": "38.35992", "longitude": "-122.78103"}, {"latitude": "38.36107", "longitude": "-122.78754"}, {"latitude": "38.35635", "longitude": "-122.79298"}, {"latitude": "38.35403", "longitude": "-122.79257"}]
666814 October 17, 2019 - 22:43:20 UTC 38.41035 -122.89189 Sebastopol 99 []
667013 October 17, 2019 - 23:20:14 UTC 38.396 -122.8988 Sebastopol 99 []
674393 October 19, 2019 - 23:46:10 UTC 38.34258 -122.75224 Sebastopol 99 []
674740 October 20, 2019 - 14:53:13 UTC 38.38815 -122.80669 Sebastopol 99 []
674940 October 21, 2019 - 01:09:00 UTC 38.40525 -122.83011 Sebastopol 99 [{"latitude": "38.40568", "longitude": "-122.83013"}, {"latitude": "38.40737", "longitude": "-122.8298"}, {"latitude": "38.40776", "longitude": "-122.82976"}, {"latitude": "38.40857", "longitude": "-122.82977"}, {"latitude": "38.40729", "longitude": "-122.83003"}]
676032 October 21, 2019 - 17:15:00 UTC 38.36443 -122.88298 Sebastopol 99 [{"latitude": "38.3644", "longitude": "-122.88438"}, {"latitude": "38.36442", "longitude": "-122.88383"}, {"latitude": "38.3679", "longitude": "-122.88147"}, {"latitude": "38.37024", "longitude": "-122.88159"}, {"latitude": "38.36904", "longitude": "-122.88333"}]
676116 October 21, 2019 - 18:09:35 UTC 38.41093 -122.85013 Sebastopol 99 []
676706 October 22, 2019 - 15:58:51 UTC 38.40972 -122.80013 Sebastopol 99 []
676949 October 22, 2019 - 19:45:30 UTC 38.35851 -122.80203 Sebastopol 99 []
677023 October 22, 2019 - 21:26:05 UTC 38.36733 -122.89716 Sebastopol 99 []
677181 October 23, 2019 - 01:20:37 UTC 38.39995 -122.83226 Sebastopol 99 []
677516 October 23, 2019 - 17:04:16 UTC 38.39886 -122.88129 Sebastopol 99 []
678420 October 23, 2019 - 22:36:37 UTC 38.37499 -122.81786 Sebastopol 99 []
678753 October 23, 2019 - 23:17:01 UTC 38.45614 -122.88759 Sebastopol 99 []
679142 October 24, 2019 - 02:27:49 UTC 38.38237 -122.87358 Sebastopol 99 []
679265 October 24, 2019 - 06:39:02 UTC 38.39345 -122.83146 Sebastopol 99 []
679267 October 24, 2019 - 07:00:42 UTC 38.39284 -122.83313 Sebastopol 99 []
679538 October 24, 2019 - 16:51:16 UTC 38.34058 -122.75968 Sebastopol 99 []
679594 October 24, 2019 - 17:49:44 UTC 38.35398 -122.81833 Sebastopol 99 []
680965 October 26, 2019 - 23:58:17 UTC 38.40713 -122.82318 Sebastopol 99 []
683121 October 27, 2019 - 03:01:00 UTC 38.37785 -122.89964 Sebastopol 99 [{"latitude": "38.35845", "longitude": "-122.89181"}, {"latitude": "38.35898", "longitude": "-122.88968"}, {"latitude": "38.36059", "longitude": "-122.88569"}, {"latitude": "38.36556", "longitude": "-122.88589"}, {"latitude": "38.36958", "longitude": "-122.88614"}, {"latitude": "38.377", "longitude": "-122.89845"}, {"latitude": "38.37582", "longitude": "-122.90002"}, {"latitude": "38.37116", "longitude": "-122.90586"}, {"latitude": "38.36299", "longitude": "-122.90887"}, {"latitude": "38.3613", "longitude": "-122.90892"}]
683135 October 27, 2019 - 03:02:00 UTC 38.39453 -122.82634 Sebastopol 99 []
683142 October 27, 2019 - 03:03:46 UTC 38.4021 -122.84419 Sebastopol 99 []
683143 October 27, 2019 - 03:03:46 UTC 38.38826 -122.84317 Sebastopol 99 []
683144 October 27, 2019 - 03:03:46 UTC 38.3915 -122.85961 Sebastopol 99 []
683145 October 27, 2019 - 03:03:46 UTC 38.40832 -122.87364 Sebastopol 99 []
683146 October 27, 2019 - 03:03:46 UTC 38.39498 -122.8707 Sebastopol 99 [{"latitude": "38.38315", "longitude": "-122.86315"}, {"latitude": "38.38363", "longitude": "-122.8606"}, {"latitude": "38.38592", "longitude": "-122.85919"}, {"latitude": "38.39012", "longitude": "-122.86402"}, {"latitude": "38.39426", "longitude": "-122.87003"}, {"latitude": "38.38894", "longitude": "-122.86904"}, {"latitude": "38.38334", "longitude": "-122.866"}]
683147 October 27, 2019 - 03:03:46 UTC 38.38469 -122.85575 Sebastopol 99 []
683148 October 27, 2019 - 03:03:46 UTC 38.35098 -122.8679 Sebastopol 99 []
683149 October 27, 2019 - 03:03:46 UTC 38.36034 -122.87114 Sebastopol 99 []
683150 October 27, 2019 - 03:03:46 UTC 38.40382 -122.84277 Sebastopol 99 []
683151 October 27, 2019 - 03:03:46 UTC 38.46949 -122.84903 Sebastopol 99 []
683154 October 27, 2019 - 03:03:46 UTC 38.42572 -122.84779 Sebastopol 99 []
683155 October 27, 2019 - 03:03:46 UTC 38.42563 -122.84682 Sebastopol 99 []
683156 October 27, 2019 - 03:03:46 UTC 38.42352 -122.84741 Sebastopol 99 []
683157 October 27, 2019 - 03:03:46 UTC 38.41267 -122.87779 Sebastopol 99 []
683159 October 27, 2019 - 03:03:46 UTC 38.44213 -122.92636 Sebastopol 99 []
683160 October 27, 2019 - 03:03:46 UTC 38.43544 -122.89668 Sebastopol 99 []
683186 October 27, 2019 - 03:04:00 UTC 38.40501 -122.82562 Sebastopol 99 [{"latitude": "38.40514", "longitude": "-122.82534"}, {"latitude": "38.40524", "longitude": "-122.82356"}, {"latitude": "38.40656", "longitude": "-122.82429"}, {"latitude": "38.40629", "longitude": "-122.82548"}]
683192 October 27, 2019 - 03:04:00 UTC 38.38815 -122.80469 Sebastopol 99 []
683196 October 27, 2019 - 03:05:00 UTC 38.38904 -122.8147 Sebastopol 99 []
683299 October 27, 2019 - 03:12:29 UTC 38.43764 -122.85384 Sebastopol 99 []
683300 October 27, 2019 - 03:12:29 UTC 38.41667 -122.82778 Sebastopol 99 []
683301 October 27, 2019 - 03:12:29 UTC 38.37472 -122.81713 Sebastopol 99 []
683347 October 27, 2019 - 03:15:18 UTC 38.3998 -122.82947 Sebastopol 99 []
683385 October 27, 2019 - 03:03:46 UTC 38.39591 -122.85116 Sebastopol 99 [{"latitude": "38.34994", "longitude": "-122.8729"}, {"latitude": "38.35098", "longitude": "-122.8679"}, {"latitude": "38.38116", "longitude": "-122.84763"}, {"latitude": "38.39017", "longitude": "-122.84828"}, {"latitude": "38.39479", "longitude": "-122.84949"}, {"latitude": "38.39537", "longitude": "-122.85123"}, {"latitude": "38.37962", "longitude": "-122.87107"}, {"latitude": "38.36904", "longitude": "-122.88333"}, {"latitude": "38.3644", "longitude": "-122.88438"}, {"latitude": "38.35463", "longitude": "-122.88592"}, {"latitude": "38.35063", "longitude": "-122.88296"}]
683570 October 27, 2019 - 03:29:39 UTC 38.40642 -122.84088 Sebastopol 99 []
683950 October 27, 2019 - 02:50:00 UTC 38.42567 -122.83301 Sebastopol 99 [{"latitude": "38.34994", "longitude": "-122.8729"}, {"latitude": "38.35098", "longitude": "-122.8679"}, {"latitude": "38.36719", "longitude": "-122.8302"}, {"latitude": "38.379", "longitude": "-122.82232"}, {"latitude": "38.40194", "longitude": "-122.82393"}, {"latitude": "38.42367", "longitude": "-122.8341"}, {"latitude": "38.42407", "longitude": "-122.83625"}, {"latitude": "38.42218", "longitude": "-122.85484"}, {"latitude": "38.4207", "longitude": "-122.86194"}, {"latitude": "38.42027", "longitude": "-122.86329"}, {"latitude": "38.39358", "longitude": "-122.91313"}, {"latitude": "38.38977", "longitude": "-122.91281"}, {"latitude": "38.37333", "longitude": "-122.91096"}, {"latitude": "38.3613", "longitude": "-122.90892"}, {"latitude": "38.35063", "longitude": "-122.88296"}]
683993 October 27, 2019 - 02:57:00 UTC 38.42567 -122.8329 Sebastopol 99 [{"latitude": "38.33508", "longitude": "-122.92136"}, {"latitude": "38.33845", "longitude": "-122.91117"}, {"latitude": "38.41488", "longitude": "-122.84"}, {"latitude": "38.42607", "longitude": "-122.83506"}, {"latitude": "38.43914", "longitude": "-122.85039"}, {"latitude": "38.44028", "longitude": "-122.85212"}, {"latitude": "38.4479", "longitude": "-122.86421"}, {"latitude": "38.45196", "longitude": "-122.87304"}, {"latitude": "38.4694", "longitude": "-122.93148"}, {"latitude": "38.47036", "longitude": "-122.94235"}, {"latitude": "38.4251", "longitude": "-122.99761"}, {"latitude": "38.39827", "longitude": "-123.02304"}, {"latitude": "38.39092", "longitude": "-123.02302"}, {"latitude": "38.36966", "longitude": "-123.02047"}, {"latitude": "38.36204", "longitude": "-123.00387"}]
684023 October 27, 2019 - 02:57:00 UTC 38.42567 -122.83281 Sebastopol 99 [{"latitude": "38.39813", "longitude": "-122.78159"}, {"latitude": "38.39826", "longitude": "-122.77696"}, {"latitude": "38.40204", "longitude": "-122.75757"}, {"latitude": "38.42638", "longitude": "-122.75775"}, {"latitude": "38.43744", "longitude": "-122.75814"}, {"latitude": "38.47578", "longitude": "-122.79762"}, {"latitude": "38.47684", "longitude": "-122.80019"}, {"latitude": "38.47355", "longitude": "-122.84909"}, {"latitude": "38.47172", "longitude": "-122.85757"}, {"latitude": "38.46936", "longitude": "-122.86772"}, {"latitude": "38.45636", "longitude": "-122.86538"}, {"latitude": "38.4428", "longitude": "-122.86262"}, {"latitude": "38.43926", "longitude": "-122.86099"}, {"latitude": "38.4267", "longitude": "-122.83779"}]
684025 October 27, 2019 - 02:50:00 UTC 38.46154 -122.88064 Sebastopol 99 [{"latitude": "38.44746", "longitude": "-122.89653"}, {"latitude": "38.45177", "longitude": "-122.87767"}, {"latitude": "38.45321", "longitude": "-122.87566"}, {"latitude": "38.45719", "longitude": "-122.87573"}, {"latitude": "38.46632", "longitude": "-122.88861"}, {"latitude": "38.46655", "longitude": "-122.8933"}, {"latitude": "38.458", "longitude": "-122.91382"}, {"latitude": "38.4543", "longitude": "-122.91403"}, {"latitude": "38.45011", "longitude": "-122.90854"}, {"latitude": "38.44826", "longitude": "-122.90223"}]
684051 October 27, 2019 - 03:02:00 UTC 38.42567 -122.83287 Sebastopol 99 []
684264 October 27, 2019 - 02:51:44 UTC 38.35872 -122.76928 Sebastopol 99 [{"latitude": "38.35073", "longitude": "-122.77145"}, {"latitude": "38.35173", "longitude": "-122.77098"}, {"latitude": "38.35884", "longitude": "-122.76989"}, {"latitude": "38.38261", "longitude": "-122.77966"}, {"latitude": "38.38393", "longitude": "-122.78284"}, {"latitude": "38.38811", "longitude": "-122.8016"}, {"latitude": "38.38533", "longitude": "-122.80541"}, {"latitude": "38.37001", "longitude": "-122.80362"}, {"latitude": "38.35176", "longitude": "-122.77383"}]
684276 October 27, 2019 - 02:51:44 UTC 38.36522 -122.78165 Sebastopol 99 [{"latitude": "38.35963", "longitude": "-122.78161"}, {"latitude": "38.36518", "longitude": "-122.78239"}, {"latitude": "38.36855", "longitude": "-122.79151"}, {"latitude": "38.36927", "longitude": "-122.79615"}, {"latitude": "38.36955", "longitude": "-122.80031"}, {"latitude": "38.36935", "longitude": "-122.80168"}, {"latitude": "38.36799", "longitude": "-122.80554"}, {"latitude": "38.36392", "longitude": "-122.80313"}, {"latitude": "38.3615", "longitude": "-122.79633"}]
684304 October 27, 2019 - 02:51:44 UTC 38.34571 -122.76055 Sebastopol 99 [{"latitude": "38.33943", "longitude": "-122.76612"}, {"latitude": "38.34394", "longitude": "-122.76119"}, {"latitude": "38.34457", "longitude": "-122.7612"}, {"latitude": "38.34573", "longitude": "-122.76145"}, {"latitude": "38.36178", "longitude": "-122.77827"}, {"latitude": "38.36107", "longitude": "-122.78754"}, {"latitude": "38.34967", "longitude": "-122.80097"}, {"latitude": "38.34695", "longitude": "-122.79617"}, {"latitude": "38.34382", "longitude": "-122.78592"}]
684316 October 27, 2019 - 02:51:44 UTC 38.34565 -122.77841 Sebastopol 99 [{"latitude": "38.32678", "longitude": "-122.77318"}, {"latitude": "38.32759", "longitude": "-122.77046"}, {"latitude": "38.33873", "longitude": "-122.76102"}, {"latitude": "38.34518", "longitude": "-122.77857"}, {"latitude": "38.35335", "longitude": "-122.80742"}, {"latitude": "38.35383", "longitude": "-122.82162"}, {"latitude": "38.34502", "longitude": "-122.82484"}, {"latitude": "38.33256", "longitude": "-122.82398"}]
685850 October 27, 2019 - 02:57:00 UTC 38.44992 -122.84553 Sebastopol 99 [{"latitude": "38.43887", "longitude": "-122.85865"}, {"latitude": "38.44045", "longitude": "-122.8054"}, {"latitude": "38.4452", "longitude": "-122.78168"}, {"latitude": "38.44941", "longitude": "-122.78094"}, {"latitude": "38.45043", "longitude": "-122.78093"}, {"latitude": "38.45116", "longitude": "-122.78093"}, {"latitude": "38.4554", "longitude": "-122.78094"}, {"latitude": "38.46167", "longitude": "-122.78437"}, {"latitude": "38.47578", "longitude": "-122.79762"}, {"latitude": "38.47684", "longitude": "-122.80019"}, {"latitude": "38.47355", "longitude": "-122.84909"}, {"latitude": "38.47172", "longitude": "-122.85757"}, {"latitude": "38.46936", "longitude": "-122.86772"}, {"latitude": "38.45636", "longitude": "-122.86538"}, {"latitude": "38.4428", "longitude": "-122.86262"}, {"latitude": "38.43926", "longitude": "-122.86099"}]
685881 October 27, 2019 - 02:57:00 UTC 38.45088 -122.84632 Sebastopol 99 [{"latitude": "38.43887", "longitude": "-122.85865"}, {"latitude": "38.43934", "longitude": "-122.85754"}, {"latitude": "38.45339", "longitude": "-122.83686"}, {"latitude": "38.4569", "longitude": "-122.83763"}, {"latitude": "38.45775", "longitude": "-122.83793"}, {"latitude": "38.47054", "longitude": "-122.84532"}, {"latitude": "38.47306", "longitude": "-122.84688"}, {"latitude": "38.47355", "longitude": "-122.84909"}, {"latitude": "38.47172", "longitude": "-122.85757"}, {"latitude": "38.46936", "longitude": "-122.86772"}, {"latitude": "38.45636", "longitude": "-122.86538"}, {"latitude": "38.4428", "longitude": "-122.86262"}, {"latitude": "38.43926", "longitude": "-122.86099"}]
686002 October 27, 2019 - 02:57:00 UTC 38.41941 -122.87604 Sebastopol 99 [{"latitude": "38.33508", "longitude": "-122.92136"}, {"latitude": "38.33845", "longitude": "-122.91117"}, {"latitude": "38.33899", "longitude": "-122.91079"}, {"latitude": "38.35369", "longitude": "-122.90133"}, {"latitude": "38.3942", "longitude": "-122.87773"}, {"latitude": "38.39778", "longitude": "-122.87713"}, {"latitude": "38.419", "longitude": "-122.87679"}, {"latitude": "38.42441", "longitude": "-122.8887"}, {"latitude": "38.44904", "longitude": "-122.95212"}, {"latitude": "38.44905", "longitude": "-122.95675"}, {"latitude": "38.44877", "longitude": "-122.95921"}, {"latitude": "38.4251", "longitude": "-122.99761"}, {"latitude": "38.39827", "longitude": "-123.02304"}, {"latitude": "38.39092", "longitude": "-123.02302"}, {"latitude": "38.36966", "longitude": "-123.02047"}, {"latitude": "38.36204", "longitude": "-123.00387"}]
686014 October 27, 2019 - 02:57:00 UTC 38.43115 -122.88091 Sebastopol 99 [{"latitude": "38.41014", "longitude": "-122.89645"}, {"latitude": "38.43104", "longitude": "-122.88152"}, {"latitude": "38.43816", "longitude": "-122.88675"}, {"latitude": "38.42891", "longitude": "-122.90752"}, {"latitude": "38.41649", "longitude": "-122.91017"}, {"latitude": "38.41039", "longitude": "-122.89739"}]

Next page

Advanced export

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

CSV options:

CREATE TABLE [outages] (
   [id] INTEGER PRIMARY KEY,
   [outageStartTime] INTEGER,
   [latitude] TEXT,
   [longitude] TEXT,
   [regionName] INTEGER REFERENCES [regionName]([id]),
   [outageDevices] TEXT
)
Powered by Datasette · Query took 479.055ms · About: About this site