outages

379 rows where regionName = 12

View and edit SQL

id outageStartTime latitude longitude regionName outageDevices
633451 October 01, 2019 - 03:03:00 UTC 37.66234 -121.69662 Livermore 12 [{"latitude": "37.64079", "longitude": "-121.68429"}, {"latitude": "37.64401", "longitude": "-121.68098"}, {"latitude": "37.65167", "longitude": "-121.68383"}, {"latitude": "37.65706", "longitude": "-121.68631"}, {"latitude": "37.66006", "longitude": "-121.6951"}, {"latitude": "37.6533", "longitude": "-121.70628"}, {"latitude": "37.65214", "longitude": "-121.70597"}, {"latitude": "37.64835", "longitude": "-121.69933"}, {"latitude": "37.64327", "longitude": "-121.69007"}]
634893 October 01, 2019 - 22:18:57 UTC 37.66824 -121.77716 Livermore 12 []
636233 October 02, 2019 - 16:58:11 UTC 37.76459 -121.86431 Livermore 12 []
638807 October 03, 2019 - 00:18:17 UTC 37.71321 -121.74511 Livermore 12 []
639109 October 03, 2019 - 15:58:52 UTC 37.61661 -121.75261 Livermore 12 [{"latitude": "37.60105", "longitude": "-121.74898"}, {"latitude": "37.60564", "longitude": "-121.74973"}, {"latitude": "37.61121", "longitude": "-121.75165"}, {"latitude": "37.60158", "longitude": "-121.75127"}]
642767 October 04, 2019 - 16:04:00 UTC 37.71372 -121.71776 Livermore 12 [{"latitude": "37.71266", "longitude": "-121.71877"}, {"latitude": "37.71318", "longitude": "-121.71787"}, {"latitude": "37.71425", "longitude": "-121.72033"}, {"latitude": "37.71301", "longitude": "-121.71964"}]
643874 October 05, 2019 - 04:11:48 UTC 37.65459 -121.77473 Livermore 12 []
645562 October 06, 2019 - 16:02:39 UTC 37.6921 -121.80381 Livermore 12 []
645614 October 06, 2019 - 18:55:01 UTC 37.69186 -121.80208 Livermore 12 [{"latitude": "37.69187", "longitude": "-121.80277"}, {"latitude": "37.69209", "longitude": "-121.80262"}, {"latitude": "37.69209", "longitude": "-121.80316"}]
645931 October 07, 2019 - 16:18:48 UTC 37.68575 -121.78044 Livermore 12 []
645998 October 07, 2019 - 17:07:00 UTC 37.38833 -121.46561 Livermore 12 [{"latitude": "37.3893", "longitude": "-121.44849"}, {"latitude": "37.3917", "longitude": "-121.45097"}, {"latitude": "37.39584", "longitude": "-121.45739"}, {"latitude": "37.39182", "longitude": "-121.45562"}]
646120 October 07, 2019 - 18:28:00 UTC 37.35587 -121.45856 Livermore 12 []
646943 October 08, 2019 - 00:09:05 UTC 37.65044 -121.6626 Livermore 12 []
646952 October 08, 2019 - 00:28:05 UTC 37.64806 -121.66386 Livermore 12 []
647117 October 08, 2019 - 15:27:00 UTC 37.34914 -121.53992 Livermore 12 [{"latitude": "37.31104", "longitude": "-121.5328"}, {"latitude": "37.33223", "longitude": "-121.50151"}, {"latitude": "37.33514", "longitude": "-121.49879"}, {"latitude": "37.3378", "longitude": "-121.50402"}, {"latitude": "37.34634", "longitude": "-121.5281"}, {"latitude": "37.3452", "longitude": "-121.54208"}, {"latitude": "37.31562", "longitude": "-121.53625"}, {"latitude": "37.31405", "longitude": "-121.53564"}]
647443 October 08, 2019 - 18:38:00 UTC 37.35379 -121.59199 Livermore 12 []
647464 October 08, 2019 - 19:04:36 UTC 37.36056 -121.57827 Livermore 12 []
647476 October 08, 2019 - 19:25:14 UTC 37.68549 -121.77418 Livermore 12 []
647486 October 08, 2019 - 19:48:25 UTC 37.6795 -121.73412 Livermore 12 []
651241 October 09, 2019 - 22:22:00 UTC 37.68085 -121.73764 Livermore 12 []
652195 October 10, 2019 - 06:09:12 UTC 37.64448 -121.76792 Livermore 12 [{"latitude": "37.60105", "longitude": "-121.74898"}, {"latitude": "37.62889", "longitude": "-121.73129"}, {"latitude": "37.64192", "longitude": "-121.7666"}, {"latitude": "37.6338", "longitude": "-121.77043"}, {"latitude": "37.62241", "longitude": "-121.76809"}, {"latitude": "37.60158", "longitude": "-121.75127"}]
652425 October 10, 2019 - 06:52:00 UTC 37.64738 -121.75692 Livermore 12 []
652482 October 10, 2019 - 07:15:00 UTC 37.64512 -121.78301 Livermore 12 [{"latitude": "37.63688", "longitude": "-121.77946"}, {"latitude": "37.64017", "longitude": "-121.78403"}, {"latitude": "37.64119", "longitude": "-121.78581"}, {"latitude": "37.64208", "longitude": "-121.78836"}, {"latitude": "37.64136", "longitude": "-121.78889"}]
652544 October 10, 2019 - 09:07:36 UTC 37.75264 -121.77908 Livermore 12 [{"latitude": "37.75698", "longitude": "-121.7791"}, {"latitude": "37.76464", "longitude": "-121.7734"}, {"latitude": "37.80651", "longitude": "-121.74456"}, {"latitude": "37.80884", "longitude": "-121.74581"}, {"latitude": "37.82269", "longitude": "-121.78259"}, {"latitude": "37.81498", "longitude": "-121.80951"}, {"latitude": "37.76752", "longitude": "-121.78595"}]
653077 October 10, 2019 - 06:09:12 UTC 37.63853 -121.76454 Livermore 12 []
653079 October 10, 2019 - 06:09:12 UTC 37.62947 -121.75589 Livermore 12 [{"latitude": "37.62947", "longitude": "-121.75611"}, {"latitude": "37.63131", "longitude": "-121.76298"}, {"latitude": "37.62996", "longitude": "-121.7664"}]
653084 October 10, 2019 - 06:09:12 UTC 37.62675 -121.75641 Livermore 12 []
653087 October 10, 2019 - 06:09:12 UTC 37.62708 -121.7495 Livermore 12 []
653088 October 10, 2019 - 06:09:12 UTC 37.62236 -121.75916 Livermore 12 []
653100 October 10, 2019 - 06:09:12 UTC 37.61661 -121.75261 Livermore 12 [{"latitude": "37.60105", "longitude": "-121.74898"}, {"latitude": "37.60564", "longitude": "-121.74973"}, {"latitude": "37.61121", "longitude": "-121.75165"}, {"latitude": "37.60158", "longitude": "-121.75127"}]
653110 October 10, 2019 - 07:05:37 UTC 37.34879 -121.6156 Livermore 12 [{"latitude": "37.31104", "longitude": "-121.5328"}, {"latitude": "37.34115", "longitude": "-121.42967"}, {"latitude": "37.38694", "longitude": "-121.41139"}, {"latitude": "37.41255", "longitude": "-121.48871"}, {"latitude": "37.41183", "longitude": "-121.49158"}, {"latitude": "37.38289", "longitude": "-121.58087"}, {"latitude": "37.34903", "longitude": "-121.61374"}]
653433 October 10, 2019 - 21:36:21 UTC 37.69155 -121.79411 Livermore 12 []
653489 October 10, 2019 - 21:56:00 UTC 37.67601 -121.72345 Livermore 12 []
654238 October 11, 2019 - 16:17:46 UTC 37.73702 -121.58848 Livermore 12 []
655023 October 12, 2019 - 13:12:54 UTC 37.62682 -121.75711 Livermore 12 []
655278 October 12, 2019 - 20:59:59 UTC 37.62682 -121.75711 Livermore 12 []
659536 October 15, 2019 - 16:42:00 UTC 37.68021 -121.77639 Livermore 12 [{"latitude": "37.67912", "longitude": "-121.77794"}, {"latitude": "37.68017", "longitude": "-121.77565"}, {"latitude": "37.68093", "longitude": "-121.7772"}, {"latitude": "37.68033", "longitude": "-121.77979"}, {"latitude": "37.6793", "longitude": "-121.77945"}]
659957 October 16, 2019 - 02:12:47 UTC 37.68029 -121.77995 Livermore 12 []
659958 October 16, 2019 - 02:13:42 UTC 37.68021 -121.77639 Livermore 12 [{"latitude": "37.67912", "longitude": "-121.77794"}, {"latitude": "37.68017", "longitude": "-121.77565"}, {"latitude": "37.68093", "longitude": "-121.7772"}, {"latitude": "37.68036", "longitude": "-121.77903"}, {"latitude": "37.6793", "longitude": "-121.77945"}]
659972 October 16, 2019 - 03:31:24 UTC 37.69844 -121.67186 Livermore 12 []
664493 October 17, 2019 - 17:09:00 UTC 37.68591 -121.74269 Livermore 12 [{"latitude": "37.66277", "longitude": "-121.75847"}, {"latitude": "37.66313", "longitude": "-121.75411"}, {"latitude": "37.66349", "longitude": "-121.75275"}, {"latitude": "37.66439", "longitude": "-121.75119"}, {"latitude": "37.66553", "longitude": "-121.74995"}, {"latitude": "37.67497", "longitude": "-121.74078"}, {"latitude": "37.68466", "longitude": "-121.74222"}, {"latitude": "37.68655", "longitude": "-121.74346"}, {"latitude": "37.68985", "longitude": "-121.75177"}, {"latitude": "37.68426", "longitude": "-121.76325"}, {"latitude": "37.68348", "longitude": "-121.76424"}, {"latitude": "37.68251", "longitude": "-121.76511"}, {"latitude": "37.67981", "longitude": "-121.76689"}, {"latitude": "37.67694", "longitude": "-121.76785"}, {"latitude": "37.67447", "longitude": "-121.76804"}, {"latitude": "37.67282", "longitude": "-121.76673"}]
664713 October 17, 2019 - 17:38:08 UTC 37.68017 -121.76688 Livermore 12 []
666853 October 17, 2019 - 22:46:28 UTC 37.7129 -121.74983 Livermore 12 []
668336 October 18, 2019 - 16:31:43 UTC 37.66435 -121.79846 Livermore 12 [{"latitude": "37.66451", "longitude": "-121.80021"}, {"latitude": "37.66647", "longitude": "-121.80148"}, {"latitude": "37.66746", "longitude": "-121.80284"}, {"latitude": "37.66689", "longitude": "-121.80424"}, {"latitude": "37.66535", "longitude": "-121.80311"}, {"latitude": "37.66452", "longitude": "-121.8018"}]
669573 October 18, 2019 - 19:41:00 UTC 37.65085 -121.78058 Livermore 12 []
670697 October 18, 2019 - 22:58:00 UTC 37.67195 -121.79681 Livermore 12 []
676083 October 21, 2019 - 17:41:26 UTC 37.68066 -121.7651 Livermore 12 []
676445 October 21, 2019 - 23:34:36 UTC 37.62682 -121.75711 Livermore 12 []
676469 October 21, 2019 - 22:43:43 UTC 37.64453 -121.78949 Livermore 12 [{"latitude": "37.62498", "longitude": "-121.80902"}, {"latitude": "37.62649", "longitude": "-121.79117"}, {"latitude": "37.6317", "longitude": "-121.78475"}, {"latitude": "37.63203", "longitude": "-121.78488"}, {"latitude": "37.64015", "longitude": "-121.78967"}, {"latitude": "37.65499", "longitude": "-121.81275"}, {"latitude": "37.64822", "longitude": "-121.82129"}, {"latitude": "37.6459", "longitude": "-121.82268"}, {"latitude": "37.6431", "longitude": "-121.82293"}]
676525 October 22, 2019 - 03:02:39 UTC 37.70734 -121.56904 Livermore 12 []
676531 October 22, 2019 - 03:25:02 UTC 37.70613 -121.57052 Livermore 12 []
676738 October 22, 2019 - 16:15:00 UTC 37.64307 -121.64478 Livermore 12 []
677156 October 23, 2019 - 00:44:15 UTC 37.68149 -121.75031 Livermore 12 []
677393 October 23, 2019 - 15:44:59 UTC 37.67686 -121.74382 Livermore 12 []
678297 October 23, 2019 - 22:07:00 UTC 37.65195 -121.78777 Livermore 12 [{"latitude": "37.65038", "longitude": "-121.78723"}, {"latitude": "37.65117", "longitude": "-121.78741"}, {"latitude": "37.65117", "longitude": "-121.78881"}, {"latitude": "37.65045", "longitude": "-121.78925"}]
679102 October 24, 2019 - 01:35:43 UTC 37.69219 -121.79292 Livermore 12 []
679177 October 24, 2019 - 04:03:57 UTC 37.70147 -121.74741 Livermore 12 []
679672 October 24, 2019 - 19:33:05 UTC 37.69389 -121.78862 Livermore 12 []
680049 October 25, 2019 - 01:58:12 UTC 37.6853 -121.78754 Livermore 12 []
680495 October 25, 2019 - 20:26:18 UTC 37.61156 -121.68305 Livermore 12 []
680496 October 25, 2019 - 20:26:18 UTC 37.65238 -121.72317 Livermore 12 []
680497 October 25, 2019 - 20:26:18 UTC 37.58402 -121.59914 Livermore 12 []
680498 October 25, 2019 - 20:26:18 UTC 37.59841 -121.64337 Livermore 12 []
680499 October 25, 2019 - 20:26:18 UTC 37.58275 -121.69709 Livermore 12 []
680501 October 25, 2019 - 20:32:17 UTC 37.57795 -121.58827 Livermore 12 []
680874 October 26, 2019 - 19:33:02 UTC 37.74699 -121.76813 Livermore 12 []
680898 October 26, 2019 - 20:50:56 UTC 37.63923 -121.76491 Livermore 12 []
683330 October 27, 2019 - 03:13:49 UTC 37.64448 -121.76792 Livermore 12 [{"latitude": "37.60105", "longitude": "-121.74898"}, {"latitude": "37.62889", "longitude": "-121.73129"}, {"latitude": "37.64192", "longitude": "-121.7666"}, {"latitude": "37.6338", "longitude": "-121.77043"}, {"latitude": "37.62241", "longitude": "-121.76809"}, {"latitude": "37.60158", "longitude": "-121.75127"}]
683480 October 27, 2019 - 03:23:00 UTC 37.74477 -121.85755 Livermore 12 [{"latitude": "37.73316", "longitude": "-121.87441"}, {"latitude": "37.73616", "longitude": "-121.86796"}, {"latitude": "37.77603", "longitude": "-121.86141"}, {"latitude": "37.75609", "longitude": "-121.897"}, {"latitude": "37.75466", "longitude": "-121.89872"}, {"latitude": "37.75378", "longitude": "-121.89957"}, {"latitude": "37.74978", "longitude": "-121.90086"}, {"latitude": "37.74881", "longitude": "-121.90063"}, {"latitude": "37.74828", "longitude": "-121.90005"}, {"latitude": "37.73436", "longitude": "-121.87731"}]
683547 October 27, 2019 - 03:28:27 UTC 37.64512 -121.78301 Livermore 12 [{"latitude": "37.63688", "longitude": "-121.77946"}, {"latitude": "37.64017", "longitude": "-121.78403"}, {"latitude": "37.64119", "longitude": "-121.78581"}, {"latitude": "37.64208", "longitude": "-121.78836"}, {"latitude": "37.64136", "longitude": "-121.78889"}]
683569 October 27, 2019 - 03:29:32 UTC 37.74477 -121.85763 Livermore 12 [{"latitude": "37.6911", "longitude": "-121.87532"}, {"latitude": "37.69125", "longitude": "-121.87332"}, {"latitude": "37.6923", "longitude": "-121.86716"}, {"latitude": "37.69454", "longitude": "-121.85686"}, {"latitude": "37.69529", "longitude": "-121.85621"}, {"latitude": "37.78379", "longitude": "-121.80934"}, {"latitude": "37.78976", "longitude": "-121.81189"}, {"latitude": "37.79808", "longitude": "-121.82596"}, {"latitude": "37.80234", "longitude": "-121.83326"}, {"latitude": "37.78997", "longitude": "-121.86407"}, {"latitude": "37.7326", "longitude": "-121.87986"}, {"latitude": "37.69347", "longitude": "-121.88024"}, {"latitude": "37.69184", "longitude": "-121.87792"}, {"latitude": "37.69173", "longitude": "-121.87776"}]
683636 October 27, 2019 - 03:32:54 UTC 37.70468 -121.82335 Livermore 12 [{"latitude": "37.70909", "longitude": "-121.82317"}, {"latitude": "37.71061", "longitude": "-121.81885"}, {"latitude": "37.72605", "longitude": "-121.82051"}, {"latitude": "37.73206", "longitude": "-121.83677"}]
683728 October 27, 2019 - 03:36:00 UTC 37.66415 -121.73291 Livermore 12 [{"latitude": "37.52327", "longitude": "-121.55663"}, {"latitude": "37.53407", "longitude": "-121.55969"}, {"latitude": "37.58289", "longitude": "-121.58051"}, {"latitude": "37.62498", "longitude": "-121.61619"}, {"latitude": "37.65776", "longitude": "-121.70682"}, {"latitude": "37.66179", "longitude": "-121.73632"}, {"latitude": "37.58378", "longitude": "-121.70627"}, {"latitude": "37.54849", "longitude": "-121.67224"}]
684061 October 27, 2019 - 03:50:00 UTC 37.64738 -121.75692 Livermore 12 []
684183 October 27, 2019 - 04:09:34 UTC 37.73996 -121.7468 Livermore 12 [{"latitude": "37.74161", "longitude": "-121.73166"}, {"latitude": "37.74613", "longitude": "-121.72009"}, {"latitude": "37.76796", "longitude": "-121.70981"}, {"latitude": "37.79007", "longitude": "-121.73279"}, {"latitude": "37.76459", "longitude": "-121.74897"}, {"latitude": "37.75594", "longitude": "-121.75257"}, {"latitude": "37.74596", "longitude": "-121.74934"}, {"latitude": "37.74281", "longitude": "-121.74681"}]
684221 October 27, 2019 - 04:14:31 UTC 37.73238 -121.71233 Livermore 12 [{"latitude": "37.73333", "longitude": "-121.71284"}, {"latitude": "37.74721", "longitude": "-121.70796"}, {"latitude": "37.7438", "longitude": "-121.72516"}, {"latitude": "37.74207", "longitude": "-121.72771"}, {"latitude": "37.73351", "longitude": "-121.71381"}]
684250 October 27, 2019 - 04:17:28 UTC 37.75191 -121.76995 Livermore 12 [{"latitude": "37.74782", "longitude": "-121.81916"}, {"latitude": "37.75238", "longitude": "-121.76766"}, {"latitude": "37.80651", "longitude": "-121.74456"}, {"latitude": "37.80884", "longitude": "-121.74581"}, {"latitude": "37.82269", "longitude": "-121.78259"}, {"latitude": "37.81498", "longitude": "-121.80951"}, {"latitude": "37.75022", "longitude": "-121.82124"}]
684802 October 27, 2019 - 05:02:00 UTC 37.73793 -121.74655 Livermore 12 [{"latitude": "37.73631", "longitude": "-121.74228"}, {"latitude": "37.73646", "longitude": "-121.73893"}, {"latitude": "37.73784", "longitude": "-121.73915"}, {"latitude": "37.73792", "longitude": "-121.7465"}]
684850 October 27, 2019 - 04:36:00 UTC 37.71118 -121.80569 Livermore 12 [{"latitude": "37.71669", "longitude": "-121.80751"}, {"latitude": "37.74097", "longitude": "-121.8062"}, {"latitude": "37.74357", "longitude": "-121.80955"}, {"latitude": "37.7451", "longitude": "-121.81384"}, {"latitude": "37.71914", "longitude": "-121.80855"}, {"latitude": "37.71759", "longitude": "-121.80792"}]
684857 October 27, 2019 - 04:20:00 UTC 37.7222 -121.77013 Livermore 12 [{"latitude": "37.71938", "longitude": "-121.79627"}, {"latitude": "37.72221", "longitude": "-121.77445"}, {"latitude": "37.72793", "longitude": "-121.79067"}]
685185 October 27, 2019 - 05:38:00 UTC 37.6634 -121.68025 Livermore 12 []
685423 October 27, 2019 - 05:55:00 UTC 37.66191 -121.69663 Livermore 12 [{"latitude": "37.64079", "longitude": "-121.68429"}, {"latitude": "37.64401", "longitude": "-121.68098"}, {"latitude": "37.65167", "longitude": "-121.68383"}, {"latitude": "37.65706", "longitude": "-121.68631"}, {"latitude": "37.66006", "longitude": "-121.6951"}, {"latitude": "37.6533", "longitude": "-121.70628"}, {"latitude": "37.65214", "longitude": "-121.70597"}, {"latitude": "37.64835", "longitude": "-121.69933"}, {"latitude": "37.64327", "longitude": "-121.69007"}]
687070 October 27, 2019 - 14:33:00 UTC 37.63878 -121.79131 Livermore 12 []
687072 October 27, 2019 - 14:35:15 UTC 37.63273 -121.79935 Livermore 12 []
687087 October 27, 2019 - 14:38:49 UTC 37.73991 -121.76253 Livermore 12 []
687290 October 27, 2019 - 15:51:35 UTC 37.68273 -121.74727 Livermore 12 []
687321 October 27, 2019 - 16:02:27 UTC 37.68273 -121.74727 Livermore 12 []
688696 October 27, 2019 - 20:03:26 UTC 37.68292 -121.78039 Livermore 12 []
688774 October 27, 2019 - 20:15:15 UTC 37.71288 -121.73392 Livermore 12 []
689222 October 27, 2019 - 21:00:03 UTC 37.62932 -121.79037 Livermore 12 []
689688 October 27, 2019 - 21:51:43 UTC 37.68051 -121.7885 Livermore 12 []
689892 October 27, 2019 - 22:23:14 UTC 37.6919 -121.74986 Livermore 12 []
689932 October 27, 2019 - 22:23:14 UTC 37.69129 -121.74661 Livermore 12 [{"latitude": "37.69067", "longitude": "-121.74896"}, {"latitude": "37.69086", "longitude": "-121.74746"}, {"latitude": "37.6919", "longitude": "-121.74986"}, {"latitude": "37.6913", "longitude": "-121.74977"}]
691635 October 28, 2019 - 17:44:08 UTC 37.67537 -121.76451 Livermore 12 []
691696 October 27, 2019 - 03:29:32 UTC 37.79026 -121.84286 Livermore 12 [{"latitude": "37.78898", "longitude": "-121.83989"}, {"latitude": "37.79004", "longitude": "-121.82814"}, {"latitude": "37.79069", "longitude": "-121.82334"}, {"latitude": "37.79551", "longitude": "-121.82456"}, {"latitude": "37.79808", "longitude": "-121.82596"}, {"latitude": "37.80234", "longitude": "-121.83326"}, {"latitude": "37.79225", "longitude": "-121.84058"}, {"latitude": "37.79063", "longitude": "-121.84115"}, {"latitude": "37.78914", "longitude": "-121.84097"}]
691839 October 27, 2019 - 03:28:17 UTC 37.34879 -121.6156 Livermore 12 [{"latitude": "37.31104", "longitude": "-121.5328"}, {"latitude": "37.34115", "longitude": "-121.42967"}, {"latitude": "37.38694", "longitude": "-121.41139"}, {"latitude": "37.41255", "longitude": "-121.48871"}, {"latitude": "37.41183", "longitude": "-121.49158"}, {"latitude": "37.38289", "longitude": "-121.58087"}, {"latitude": "37.34903", "longitude": "-121.61374"}]
692088 October 28, 2019 - 21:57:00 UTC 37.78858 -121.84613 Livermore 12 []
692134 October 28, 2019 - 22:14:53 UTC 37.68251 -121.76511 Livermore 12 []
692337 October 28, 2019 - 23:59:05 UTC 37.68251 -121.76511 Livermore 12 []
692727 October 29, 2019 - 03:13:16 UTC 37.78858 -121.84613 Livermore 12 []

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 367.838ms · About: About this site