outages

422 rows where regionName = 34 sorted by longitude

View and edit SQL

id outageStartTime latitude longitude ▼ regionName outageDevices
675155 October 21, 2019 - 14:48:44 UTC 38.58794 -121.63567 Woodland 34 []
652788 October 10, 2019 - 16:53:39 UTC 38.74847 -121.66232 Woodland 34 []
687963 October 27, 2019 - 18:08:44 UTC 38.75497 -121.66475 Woodland 34 []
736248 December 11, 2019 - 16:57:00 UTC 38.59107 -121.66921 Woodland 34 []
714412 November 25, 2019 - 20:01:02 UTC 38.71263 -121.67657 Woodland 34 []
732542 December 07, 2019 - 18:44:22 UTC 38.74826 -121.67781 Woodland 34 [{"latitude": "38.74847", "longitude": "-121.66232"}, {"latitude": "38.75497", "longitude": "-121.66475"}, {"latitude": "38.75825", "longitude": "-121.66824"}, {"latitude": "38.75844", "longitude": "-121.66943"}, {"latitude": "38.75896", "longitude": "-121.67511"}]
714409 November 25, 2019 - 20:00:11 UTC 38.72727 -121.67976 Woodland 34 []
722640 November 28, 2019 - 15:24:00 UTC 38.72727 -121.67976 Woodland 34 []
732941 December 07, 2019 - 21:25:00 UTC 38.74854 -121.68158 Woodland 34 [{"latitude": "38.73152", "longitude": "-121.67595"}, {"latitude": "38.73422", "longitude": "-121.66035"}, {"latitude": "38.74317", "longitude": "-121.67063"}, {"latitude": "38.73325", "longitude": "-121.6782"}]
689460 October 27, 2019 - 21:28:46 UTC 38.77649 -121.68919 Woodland 34 []
714408 November 25, 2019 - 20:00:11 UTC 38.72585 -121.69011 Woodland 34 []
689736 October 27, 2019 - 21:57:58 UTC 38.78156 -121.69252 Woodland 34 []
715076 November 26, 2019 - 16:17:39 UTC 38.78249 -121.69425 Woodland 34 []
714473 November 25, 2019 - 20:47:00 UTC 38.73503 -121.6973 Woodland 34 []
710200 November 19, 2019 - 20:19:58 UTC 38.60306 -121.70813 Woodland 34 []
698387 November 03, 2019 - 00:39:05 UTC 38.67773 -121.71008 Woodland 34 []
699730 November 05, 2019 - 12:24:00 UTC 38.67686 -121.71031 Woodland 34 [{"latitude": "38.67647", "longitude": "-121.71038"}, {"latitude": "38.67724", "longitude": "-121.71033"}, {"latitude": "38.67693", "longitude": "-121.7178"}]
686258 October 27, 2019 - 08:58:25 UTC 38.60494 -121.71465 Woodland 34 []
686628 October 27, 2019 - 08:58:25 UTC 38.60494 -121.71465 Woodland 34 []
786339 February 10, 2020 - 04:08:01 UTC 38.63761 -121.7209 Woodland 34 []
786593 February 10, 2020 - 06:38:19 UTC 38.63761 -121.7209 Woodland 34 []
714582 November 25, 2019 - 21:38:00 UTC 38.69173 -121.72773 Woodland 34 [{"latitude": "38.6907", "longitude": "-121.70987"}, {"latitude": "38.69814", "longitude": "-121.72037"}, {"latitude": "38.69159", "longitude": "-121.71696"}]
686263 October 27, 2019 - 09:01:15 UTC 38.60798 -121.72812 Woodland 34 []
687307 October 27, 2019 - 16:00:16 UTC 38.60798 -121.72812 Woodland 34 []
697579 November 01, 2019 - 19:30:47 UTC 38.74135 -121.72925 Woodland 34 [{"latitude": "38.74109", "longitude": "-121.72049"}, {"latitude": "38.74136", "longitude": "-121.72872"}, {"latitude": "38.74125", "longitude": "-121.72841"}]
735893 December 11, 2019 - 00:22:28 UTC 38.79244 -121.72947 Woodland 34 []
690943 October 28, 2019 - 04:30:00 UTC 38.60798 -121.72958 Woodland 34 [{"latitude": "38.60694", "longitude": "-121.72037"}, {"latitude": "38.60799", "longitude": "-121.72697"}, {"latitude": "38.60798", "longitude": "-121.72945"}]
744489 December 17, 2019 - 18:57:10 UTC 38.60798 -121.72958 Woodland 34 [{"latitude": "38.60694", "longitude": "-121.72037"}, {"latitude": "38.60799", "longitude": "-121.72697"}, {"latitude": "38.60798", "longitude": "-121.72945"}]
686262 October 27, 2019 - 09:01:15 UTC 38.60794 -121.72967 Woodland 34 []
687312 October 27, 2019 - 16:01:24 UTC 38.60794 -121.72967 Woodland 34 []
744443 December 17, 2019 - 18:24:15 UTC 38.60794 -121.72967 Woodland 34 []
654356 October 11, 2019 - 18:04:17 UTC 38.67287 -121.73142 Woodland 34 []
702110 November 07, 2019 - 22:41:04 UTC 38.65256 -121.73145 Woodland 34 []
651067 October 09, 2019 - 20:36:11 UTC 38.65211 -121.73257 Woodland 34 []
699287 November 04, 2019 - 19:19:36 UTC 38.68511 -121.73748 Woodland 34 []
728634 December 03, 2019 - 18:28:21 UTC 38.67633 -121.73798 Woodland 34 []
686264 October 27, 2019 - 09:01:36 UTC 38.61752 -121.73816 Woodland 34 []
736207 December 11, 2019 - 16:35:00 UTC 38.64919 -121.74199 Woodland 34 []
737223 December 12, 2019 - 16:43:27 UTC 38.64919 -121.74199 Woodland 34 []
734668 December 09, 2019 - 20:54:45 UTC 38.66778 -121.74612 Woodland 34 []
691240 October 28, 2019 - 12:39:00 UTC 38.6917 -121.74789 Woodland 34 []
641775 October 03, 2019 - 23:32:48 UTC 38.67823 -121.74907 Woodland 34 []
691513 October 28, 2019 - 16:24:57 UTC 38.69047 -121.74964 Woodland 34 []
734356 December 09, 2019 - 17:33:00 UTC 38.77827 -121.75063 Woodland 34 []
718316 November 27, 2019 - 02:08:47 UTC 38.59012 -121.75158 Woodland 34 [{"latitude": "38.59046", "longitude": "-121.75174"}, {"latitude": "38.59919", "longitude": "-121.74926"}, {"latitude": "38.60104", "longitude": "-121.7526"}, {"latitude": "38.6023", "longitude": "-121.76396"}, {"latitude": "38.60252", "longitude": "-121.76638"}, {"latitude": "38.59677", "longitude": "-121.76368"}]
789452 February 12, 2020 - 18:00:33 UTC 38.59046 -121.75174 Woodland 34 []
691241 October 28, 2019 - 12:47:00 UTC 38.69072 -121.752 Woodland 34 []
691248 October 28, 2019 - 12:52:00 UTC 38.69226 -121.75221 Woodland 34 []
717136 November 27, 2019 - 02:09:28 UTC 38.60104 -121.7526 Woodland 34 []
686044 October 27, 2019 - 08:13:39 UTC 38.67475 -121.75413 Woodland 34 []
732601 December 07, 2019 - 19:19:22 UTC 38.66187 -121.75441 Woodland 34 []
688753 October 27, 2019 - 20:11:31 UTC 38.67276 -121.75514 Woodland 34 []
695394 October 30, 2019 - 20:50:38 UTC 38.68093 -121.75626 Woodland 34 []
696156 October 31, 2019 - 02:50:06 UTC 38.68093 -121.75626 Woodland 34 []
696170 October 31, 2019 - 02:50:06 UTC 38.68093 -121.75626 Woodland 34 []
691235 October 28, 2019 - 12:14:00 UTC 38.69133 -121.7576 Woodland 34 []
693601 October 29, 2019 - 17:11:41 UTC 38.68487 -121.75834 Woodland 34 []
710490 November 20, 2019 - 03:03:10 UTC 38.70948 -121.75893 Woodland 34 [{"latitude": "38.70475", "longitude": "-121.759"}, {"latitude": "38.70643", "longitude": "-121.7585"}, {"latitude": "38.70862", "longitude": "-121.75894"}]
704015 November 10, 2019 - 22:01:00 UTC 38.70862 -121.75894 Woodland 34 []
710356 November 19, 2019 - 22:57:02 UTC 38.70862 -121.75894 Woodland 34 []
710386 November 19, 2019 - 23:44:09 UTC 38.70862 -121.75894 Woodland 34 []
737939 December 13, 2019 - 03:10:57 UTC 38.66503 -121.75905 Woodland 34 []
650849 October 09, 2019 - 17:24:00 UTC 38.6783 -121.75917 Woodland 34 [{"latitude": "38.67254", "longitude": "-121.79538"}, {"latitude": "38.67845", "longitude": "-121.76139"}, {"latitude": "38.68339", "longitude": "-121.76635"}, {"latitude": "38.68686", "longitude": "-121.77008"}, {"latitude": "38.69067", "longitude": "-121.79721"}, {"latitude": "38.6909", "longitude": "-121.79906"}, {"latitude": "38.68918", "longitude": "-121.80144"}, {"latitude": "38.68773", "longitude": "-121.80203"}, {"latitude": "38.68074", "longitude": "-121.80206"}, {"latitude": "38.6745", "longitude": "-121.7993"}, {"latitude": "38.67305", "longitude": "-121.79808"}]
694015 October 29, 2019 - 19:20:00 UTC 38.68465 -121.7592 Woodland 34 []
691220 October 28, 2019 - 10:14:56 UTC 38.68409 -121.75921 Woodland 34 []
691646 October 28, 2019 - 17:49:43 UTC 38.68428 -121.75921 Woodland 34 []
690525 October 28, 2019 - 01:14:35 UTC 38.66941 -121.75927 Woodland 34 []
686467 October 27, 2019 - 09:57:06 UTC 38.69381 -121.75929 Woodland 34 []
690723 October 28, 2019 - 02:14:04 UTC 38.69381 -121.75929 Woodland 34 []
686048 October 27, 2019 - 08:07:00 UTC 38.67831 -121.7593 Woodland 34 [{"latitude": "38.68108", "longitude": "-121.76107"}, {"latitude": "38.68487", "longitude": "-121.75834"}, {"latitude": "38.68823", "longitude": "-121.76057"}, {"latitude": "38.70044", "longitude": "-121.78295"}, {"latitude": "38.69911", "longitude": "-121.79798"}, {"latitude": "38.69854", "longitude": "-121.802"}, {"latitude": "38.69348", "longitude": "-121.8036"}, {"latitude": "38.68595", "longitude": "-121.80242"}, {"latitude": "38.68153", "longitude": "-121.80163"}]
727217 December 02, 2019 - 16:55:12 UTC 38.67831 -121.7593 Woodland 34 [{"latitude": "38.68108", "longitude": "-121.76107"}, {"latitude": "38.68487", "longitude": "-121.75834"}, {"latitude": "38.68823", "longitude": "-121.76057"}, {"latitude": "38.70044", "longitude": "-121.78295"}, {"latitude": "38.69911", "longitude": "-121.79798"}, {"latitude": "38.69854", "longitude": "-121.802"}, {"latitude": "38.69348", "longitude": "-121.8036"}, {"latitude": "38.68595", "longitude": "-121.80242"}, {"latitude": "38.68153", "longitude": "-121.80163"}]
685794 October 27, 2019 - 07:30:57 UTC 38.67831 -121.75934 Woodland 34 [{"latitude": "38.67818", "longitude": "-121.71646"}, {"latitude": "38.67843", "longitude": "-121.71498"}, {"latitude": "38.70212", "longitude": "-121.67278"}, {"latitude": "38.70563", "longitude": "-121.66979"}, {"latitude": "38.71649", "longitude": "-121.66372"}, {"latitude": "38.72109", "longitude": "-121.66401"}, {"latitude": "38.73551", "longitude": "-121.684"}, {"latitude": "38.73102", "longitude": "-121.69605"}, {"latitude": "38.70557", "longitude": "-121.74197"}, {"latitude": "38.68165", "longitude": "-121.76037"}, {"latitude": "38.68069", "longitude": "-121.75946"}]
688199 October 27, 2019 - 18:45:00 UTC 38.67831 -121.75934 Woodland 34 [{"latitude": "38.67818", "longitude": "-121.71646"}, {"latitude": "38.67843", "longitude": "-121.71498"}, {"latitude": "38.70212", "longitude": "-121.67278"}, {"latitude": "38.70563", "longitude": "-121.66979"}, {"latitude": "38.71649", "longitude": "-121.66372"}, {"latitude": "38.72109", "longitude": "-121.66401"}, {"latitude": "38.73551", "longitude": "-121.684"}, {"latitude": "38.73102", "longitude": "-121.69605"}, {"latitude": "38.70557", "longitude": "-121.74197"}, {"latitude": "38.68165", "longitude": "-121.76037"}, {"latitude": "38.68069", "longitude": "-121.75946"}]
691304 October 28, 2019 - 14:09:50 UTC 38.69141 -121.75943 Woodland 34 []
633882 October 01, 2019 - 15:45:00 UTC 38.69174 -121.75947 Woodland 34 []
687895 October 27, 2019 - 18:00:01 UTC 38.6915 -121.75992 Woodland 34 []
729615 December 04, 2019 - 17:51:57 UTC 38.66308 -121.76003 Woodland 34 []
691290 October 28, 2019 - 13:51:00 UTC 38.69349 -121.7604 Woodland 34 []
686472 October 27, 2019 - 09:57:32 UTC 38.69196 -121.76054 Woodland 34 []
687354 October 27, 2019 - 16:10:04 UTC 38.66876 -121.76132 Woodland 34 []
734860 December 09, 2019 - 23:37:53 UTC 38.66876 -121.76132 Woodland 34 []
686466 October 27, 2019 - 09:57:06 UTC 38.69233 -121.76158 Woodland 34 []
691320 October 28, 2019 - 14:28:00 UTC 38.69233 -121.76158 Woodland 34 []
734980 December 10, 2019 - 02:32:23 UTC 38.67177 -121.76206 Woodland 34 []
686473 October 27, 2019 - 09:57:32 UTC 38.69175 -121.76225 Woodland 34 []
669753 October 18, 2019 - 19:50:52 UTC 38.68403 -121.76227 Woodland 34 []
655199 October 12, 2019 - 18:24:15 UTC 38.69092 -121.76258 Woodland 34 []
687276 October 27, 2019 - 15:46:48 UTC 38.68045 -121.7626 Woodland 34 []
709109 November 18, 2019 - 17:08:03 UTC 38.67379 -121.7627 Woodland 34 []
658981 October 15, 2019 - 16:34:48 UTC 38.68068 -121.76309 Woodland 34 []
704355 November 11, 2019 - 18:23:07 UTC 38.66976 -121.76317 Woodland 34 []
705036 November 12, 2019 - 19:16:45 UTC 38.66028 -121.76347 Woodland 34 []
680796 October 26, 2019 - 16:16:26 UTC 38.68472 -121.76349 Woodland 34 []
680783 October 26, 2019 - 16:05:00 UTC 38.6847 -121.76353 Woodland 34 []
691017 October 28, 2019 - 05:33:09 UTC 38.74481 -121.76364 Woodland 34 []
717101 November 27, 2019 - 02:08:47 UTC 38.6023 -121.76396 Woodland 34 []
654412 October 11, 2019 - 19:08:09 UTC 38.67519 -121.76441 Woodland 34 []
686194 October 27, 2019 - 08:38:27 UTC 38.73527 -121.76444 Woodland 34 [{"latitude": "38.72675", "longitude": "-121.74587"}, {"latitude": "38.73486", "longitude": "-121.74452"}, {"latitude": "38.74312", "longitude": "-121.7457"}, {"latitude": "38.73825", "longitude": "-121.76005"}, {"latitude": "38.73519", "longitude": "-121.76035"}]
736015 December 11, 2019 - 04:51:34 UTC 38.67734 -121.76452 Woodland 34 []
735922 December 11, 2019 - 01:15:53 UTC 38.6779 -121.76473 Woodland 34 []

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