outages

461 rows where regionName = 34 sorted by latitude descending

View and edit SQL

id outageStartTime latitude ▲ longitude regionName outageDevices
679853 October 24, 2019 - 22:51:47 UTC 38.81388 -121.79095 Woodland 34 []
714303 November 25, 2019 - 18:25:39 UTC 38.81388 -121.79095 Woodland 34 []
715080 November 26, 2019 - 16:27:24 UTC 38.80884 -121.79301 Woodland 34 [{"latitude": "38.81295", "longitude": "-121.79105"}, {"latitude": "38.81321", "longitude": "-121.79076"}, {"latitude": "38.81388", "longitude": "-121.79095"}, {"latitude": "38.82336", "longitude": "-121.79728"}, {"latitude": "38.81903", "longitude": "-121.8026"}]
686199 October 27, 2019 - 08:38:55 UTC 38.80847 -121.85134 Woodland 34 []
735893 December 11, 2019 - 00:22:28 UTC 38.79244 -121.72947 Woodland 34 []
686189 October 27, 2019 - 08:38:27 UTC 38.78615 -121.77404 Woodland 34 []
1080365 September 18, 2020 - 16:59:25 UTC 38.78366 -121.77991 Woodland 34 []
715076 November 26, 2019 - 16:17:39 UTC 38.78249 -121.69425 Woodland 34 []
689736 October 27, 2019 - 21:57:58 UTC 38.78156 -121.69252 Woodland 34 []
715020 November 26, 2019 - 14:33:00 UTC 38.77973 -121.82167 Woodland 34 [{"latitude": "38.78391", "longitude": "-121.84953"}, {"latitude": "38.79433", "longitude": "-121.80948"}, {"latitude": "38.81265", "longitude": "-121.8126"}, {"latitude": "38.80853", "longitude": "-121.85579"}]
789633 February 12, 2020 - 20:53:17 UTC 38.77927 -121.84633 Woodland 34 []
686198 October 27, 2019 - 08:38:55 UTC 38.77916 -121.82768 Woodland 34 []
686197 October 27, 2019 - 08:38:55 UTC 38.77877 -121.79437 Woodland 34 []
734356 December 09, 2019 - 17:33:00 UTC 38.77827 -121.75063 Woodland 34 []
1068573 September 14, 2020 - 16:18:00 UTC 38.77806 -121.74691 Woodland 34 []
1064251 September 11, 2020 - 16:02:36 UTC 38.77802 -121.73068 Woodland 34 []
686203 October 27, 2019 - 08:38:55 UTC 38.77797 -121.79371 Woodland 34 [{"latitude": "38.75849", "longitude": "-121.78473"}, {"latitude": "38.76202", "longitude": "-121.78311"}, {"latitude": "38.76418", "longitude": "-121.78385"}, {"latitude": "38.77151", "longitude": "-121.78906"}, {"latitude": "38.77515", "longitude": "-121.79374"}, {"latitude": "38.76628", "longitude": "-121.81027"}, {"latitude": "38.76449", "longitude": "-121.81005"}, {"latitude": "38.75863", "longitude": "-121.79321"}]
689460 October 27, 2019 - 21:28:46 UTC 38.77649 -121.68919 Woodland 34 []
783990 February 09, 2020 - 20:35:00 UTC 38.77462 -121.85812 Woodland 34 [{"latitude": "38.71355", "longitude": "-121.76748"}, {"latitude": "38.72675", "longitude": "-121.74587"}, {"latitude": "38.73486", "longitude": "-121.74452"}, {"latitude": "38.76639", "longitude": "-121.74719"}, {"latitude": "38.78667", "longitude": "-121.77108"}, {"latitude": "38.81265", "longitude": "-121.8126"}, {"latitude": "38.82313", "longitude": "-121.85324"}, {"latitude": "38.80853", "longitude": "-121.85579"}, {"latitude": "38.77767", "longitude": "-121.85894"}, {"latitude": "38.71639", "longitude": "-121.7846"}, {"latitude": "38.71362", "longitude": "-121.77184"}]
686111 October 27, 2019 - 08:26:44 UTC 38.76854 -121.88943 Woodland 34 []
687043 October 27, 2019 - 13:58:15 UTC 38.76854 -121.88943 Woodland 34 []
685994 October 27, 2019 - 08:04:13 UTC 38.76474 -121.84009 Woodland 34 []
686708 October 27, 2019 - 12:15:00 UTC 38.76442 -121.81978 Woodland 34 []
1068393 September 14, 2020 - 15:53:47 UTC 38.76432 -121.80759 Woodland 34 []
1078938 September 17, 2020 - 21:26:12 UTC 38.76431 -121.8067 Woodland 34 []
729483 December 04, 2019 - 16:42:59 UTC 38.76418 -121.78385 Woodland 34 []
686069 October 27, 2019 - 08:18:52 UTC 38.76299 -121.84132 Woodland 34 []
691263 October 28, 2019 - 13:13:54 UTC 38.76202 -121.78311 Woodland 34 []
686192 October 27, 2019 - 08:38:27 UTC 38.75664 -121.77545 Woodland 34 [{"latitude": "38.75661", "longitude": "-121.76704"}, {"latitude": "38.75972", "longitude": "-121.74736"}, {"latitude": "38.76639", "longitude": "-121.74719"}, {"latitude": "38.76526", "longitude": "-121.75971"}, {"latitude": "38.75673", "longitude": "-121.77481"}]
707212 November 15, 2019 - 08:14:34 UTC 38.75664 -121.77545 Woodland 34 [{"latitude": "38.75661", "longitude": "-121.76704"}, {"latitude": "38.75972", "longitude": "-121.74736"}, {"latitude": "38.76639", "longitude": "-121.74719"}, {"latitude": "38.76526", "longitude": "-121.75971"}, {"latitude": "38.75673", "longitude": "-121.77481"}]
687963 October 27, 2019 - 18:08:44 UTC 38.75497 -121.66475 Woodland 34 []
718300 November 27, 2019 - 04:07:00 UTC 38.75449 -121.77459 Woodland 34 []
686193 October 27, 2019 - 08:38:27 UTC 38.75448 -121.77364 Woodland 34 []
719827 November 27, 2019 - 11:38:00 UTC 38.75448 -121.77364 Woodland 34 []
686190 October 27, 2019 - 08:38:27 UTC 38.75314 -121.7745 Woodland 34 []
686202 October 27, 2019 - 08:38:55 UTC 38.74937 -121.77628 Woodland 34 []
703934 November 10, 2019 - 18:31:00 UTC 38.74937 -121.77628 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"}]
652788 October 10, 2019 - 16:53:39 UTC 38.74847 -121.66232 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"}]
698187 November 02, 2019 - 17:06:10 UTC 38.74581 -121.79965 Woodland 34 []
699247 November 04, 2019 - 18:50:09 UTC 38.74581 -121.79965 Woodland 34 []
691017 October 28, 2019 - 05:33:09 UTC 38.74481 -121.76364 Woodland 34 []
687389 October 27, 2019 - 16:13:30 UTC 38.74242 -121.78733 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"}]
1073708 September 16, 2020 - 09:23:48 UTC 38.74038 -121.76562 Woodland 34 []
1078634 September 17, 2020 - 20:23:44 UTC 38.74038 -121.76562 Woodland 34 []
726464 December 02, 2019 - 01:39:14 UTC 38.73766 -121.88316 Woodland 34 []
686214 October 27, 2019 - 08:41:19 UTC 38.73669 -121.77579 Woodland 34 []
697132 November 01, 2019 - 02:10:12 UTC 38.73669 -121.77579 Woodland 34 []
686522 October 27, 2019 - 10:18:00 UTC 38.73631 -121.82623 Woodland 34 []
692493 October 29, 2019 - 00:46:00 UTC 38.73631 -121.82623 Woodland 34 []
691365 October 28, 2019 - 15:16:23 UTC 38.73562 -121.84053 Woodland 34 [{"latitude": "38.72813", "longitude": "-121.84879"}, {"latitude": "38.72883", "longitude": "-121.84748"}, {"latitude": "38.73699", "longitude": "-121.84885"}, {"latitude": "38.73582", "longitude": "-121.85445"}, {"latitude": "38.73501", "longitude": "-121.85445"}]
691380 October 28, 2019 - 15:16:25 UTC 38.73562 -121.84053 Woodland 34 [{"latitude": "38.72813", "longitude": "-121.84879"}, {"latitude": "38.72883", "longitude": "-121.84748"}, {"latitude": "38.73699", "longitude": "-121.84885"}, {"latitude": "38.73582", "longitude": "-121.85445"}, {"latitude": "38.73501", "longitude": "-121.85445"}]
692172 October 28, 2019 - 15:30:00 UTC 38.73562 -121.84053 Woodland 34 [{"latitude": "38.72813", "longitude": "-121.84879"}, {"latitude": "38.72883", "longitude": "-121.84748"}, {"latitude": "38.73699", "longitude": "-121.84885"}, {"latitude": "38.73582", "longitude": "-121.85445"}, {"latitude": "38.73501", "longitude": "-121.85445"}]
688537 October 27, 2019 - 16:13:30 UTC 38.73561 -121.83559 Woodland 34 [{"latitude": "38.71056", "longitude": "-121.80201"}, {"latitude": "38.74231", "longitude": "-121.77794"}, {"latitude": "38.74551", "longitude": "-121.78025"}, {"latitude": "38.75757", "longitude": "-121.79636"}, {"latitude": "38.7575", "longitude": "-121.80336"}, {"latitude": "38.75369", "longitude": "-121.83058"}, {"latitude": "38.73215", "longitude": "-121.83363"}, {"latitude": "38.72827", "longitude": "-121.83357"}]
696849 October 31, 2019 - 20:27:00 UTC 38.73561 -121.83559 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"}]
686206 October 27, 2019 - 08:39:24 UTC 38.7351 -121.78135 Woodland 34 []
714473 November 25, 2019 - 20:47:00 UTC 38.73503 -121.6973 Woodland 34 []
707835 November 15, 2019 - 22:10:02 UTC 38.73442 -121.78136 Woodland 34 []
738973 December 14, 2019 - 15:35:34 UTC 38.73442 -121.78136 Woodland 34 []
784860 February 09, 2020 - 22:15:26 UTC 38.73426 -121.76529 Woodland 34 []
738933 December 14, 2019 - 15:28:00 UTC 38.73291 -121.78138 Woodland 34 []
696859 October 31, 2019 - 20:47:06 UTC 38.7312 -121.81618 Woodland 34 []
633574 October 01, 2019 - 14:22:58 UTC 38.72937 -121.782 Woodland 34 []
645785 October 07, 2019 - 13:50:10 UTC 38.72937 -121.782 Woodland 34 []
686244 October 27, 2019 - 08:50:00 UTC 38.72903 -121.76798 Woodland 34 []
686996 October 27, 2019 - 14:00:00 UTC 38.72831 -121.85011 Woodland 34 []
686201 October 27, 2019 - 08:38:55 UTC 38.72789 -121.79186 Woodland 34 []
686200 October 27, 2019 - 08:38:55 UTC 38.72756 -121.78565 Woodland 34 []
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 []
686191 October 27, 2019 - 08:38:27 UTC 38.7267 -121.77217 Woodland 34 []
714408 November 25, 2019 - 20:00:11 UTC 38.72585 -121.69011 Woodland 34 []
695346 October 30, 2019 - 20:21:52 UTC 38.72187 -121.89031 Woodland 34 []
633582 October 01, 2019 - 14:35:07 UTC 38.72181 -121.83119 Woodland 34 []
716876 November 27, 2019 - 01:46:46 UTC 38.72179 -121.83797 Woodland 34 [{"latitude": "38.71767", "longitude": "-121.82654"}, {"latitude": "38.72439", "longitude": "-121.82368"}, {"latitude": "38.72469", "longitude": "-121.82662"}, {"latitude": "38.72243", "longitude": "-121.83712"}, {"latitude": "38.7222", "longitude": "-121.83739"}, {"latitude": "38.71833", "longitude": "-121.83527"}]
648268 October 09, 2019 - 07:48:53 UTC 38.72021 -121.9563 Woodland 34 [{"latitude": "38.72239", "longitude": "-121.95666"}, {"latitude": "38.73668", "longitude": "-121.92676"}, {"latitude": "38.74764", "longitude": "-121.92472"}, {"latitude": "38.75304", "longitude": "-121.94416"}, {"latitude": "38.74371", "longitude": "-121.95047"}, {"latitude": "38.7384", "longitude": "-121.95346"}, {"latitude": "38.73666", "longitude": "-121.95426"}, {"latitude": "38.73424", "longitude": "-121.95502"}, {"latitude": "38.73306", "longitude": "-121.95533"}, {"latitude": "38.73052", "longitude": "-121.95591"}]
1081938 September 18, 2020 - 23:44:13 UTC 38.7189 -121.7855 Woodland 34 []
1081954 September 18, 2020 - 23:38:00 UTC 38.7189 -121.78544 Woodland 34 []
648254 October 09, 2019 - 07:48:53 UTC 38.71882 -121.95259 Woodland 34 [{"latitude": "38.68811", "longitude": "-121.89899"}, {"latitude": "38.69636", "longitude": "-121.88621"}, {"latitude": "38.71879", "longitude": "-121.90514"}, {"latitude": "38.72922", "longitude": "-121.91807"}, {"latitude": "38.73007", "longitude": "-121.92161"}, {"latitude": "38.71981", "longitude": "-121.94926"}, {"latitude": "38.71211", "longitude": "-121.94819"}, {"latitude": "38.70333", "longitude": "-121.93753"}]
664074 October 17, 2019 - 16:12:12 UTC 38.71854 -121.82655 Woodland 34 []
1064238 September 11, 2020 - 15:57:00 UTC 38.71764 -121.94693 Woodland 34 []
690192 October 27, 2019 - 23:21:12 UTC 38.71674 -121.81522 Woodland 34 []
686116 October 27, 2019 - 08:27:34 UTC 38.71546 -121.81194 Woodland 34 []
714412 November 25, 2019 - 20:01:02 UTC 38.71263 -121.67657 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 []
686103 October 27, 2019 - 08:15:00 UTC 38.70515 -121.76517 Woodland 34 [{"latitude": "38.69426", "longitude": "-121.74696"}, {"latitude": "38.69533", "longitude": "-121.74615"}, {"latitude": "38.721", "longitude": "-121.74007"}, {"latitude": "38.72486", "longitude": "-121.74"}, {"latitude": "38.72679", "longitude": "-121.74267"}, {"latitude": "38.72791", "longitude": "-121.76624"}, {"latitude": "38.72792", "longitude": "-121.76701"}, {"latitude": "38.72792", "longitude": "-121.76751"}, {"latitude": "38.71675", "longitude": "-121.79543"}, {"latitude": "38.70545", "longitude": "-121.80117"}, {"latitude": "38.69796", "longitude": "-121.80318"}, {"latitude": "38.69462", "longitude": "-121.80247"}]
686425 October 27, 2019 - 09:41:27 UTC 38.70339 -121.90075 Woodland 34 []
699695 November 05, 2019 - 05:05:44 UTC 38.70256 -121.90207 Woodland 34 []
784804 February 09, 2020 - 21:35:00 UTC 38.70216 -121.81524 Woodland 34 [{"latitude": "38.70219", "longitude": "-121.81243"}, {"latitude": "38.70221", "longitude": "-121.80895"}, {"latitude": "38.7048", "longitude": "-121.80934"}, {"latitude": "38.70309", "longitude": "-121.81189"}]
739598 December 14, 2019 - 19:42:09 UTC 38.69983 -121.82941 Woodland 34 []
676379 October 21, 2019 - 21:46:13 UTC 38.69964 -121.83134 Woodland 34 []
695653 October 30, 2019 - 22:38:00 UTC 38.69956 -121.81678 Woodland 34 [{"latitude": "38.69576", "longitude": "-121.83941"}, {"latitude": "38.69653", "longitude": "-121.83023"}, {"latitude": "38.70129", "longitude": "-121.82036"}, {"latitude": "38.70149", "longitude": "-121.82086"}, {"latitude": "38.70306", "longitude": "-121.82901"}, {"latitude": "38.70203", "longitude": "-121.83472"}, {"latitude": "38.69825", "longitude": "-121.83938"}, {"latitude": "38.6976", "longitude": "-121.83939"}]
728139 December 03, 2019 - 08:33:08 UTC 38.6977 -121.78385 Woodland 34 []
634814 October 01, 2019 - 20:33:01 UTC 38.69436 -121.93466 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 327.52ms · About: About this site