outages

422 rows where regionName = 34 sorted by latitude

✎ View and edit SQL

This data as json, atom, CSV (advanced)

id outageStartTime latitude ▼ longitude regionName outageDevices
655894 October 14, 2019 - 15:46:04 UTC 38.56761 -121.84027 Woodland 34 []
697376 November 01, 2019 - 16:59:23 UTC 38.56872 -121.83888 Woodland 34 []
668936 October 18, 2019 - 17:51:58 UTC 38.57525 -121.8332 Woodland 34 []
697297 November 01, 2019 - 15:50:21 UTC 38.57566 -121.83185 Woodland 34 []
732961 December 07, 2019 - 22:31:59 UTC 38.58426 -121.93538 Woodland 34 []
675155 October 21, 2019 - 14:48:44 UTC 38.58794 -121.63567 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 []
692732 October 29, 2019 - 03:20:01 UTC 38.59066 -121.86508 Woodland 34 []
696462 October 31, 2019 - 15:44:10 UTC 38.59066 -121.86508 Woodland 34 []
690029 October 27, 2019 - 22:43:48 UTC 38.5907 -121.7693 Woodland 34 []
704872 November 12, 2019 - 17:38:23 UTC 38.5907 -121.85306 Woodland 34 []
736248 December 11, 2019 - 16:57:00 UTC 38.59107 -121.66921 Woodland 34 []
694053 October 29, 2019 - 20:02:25 UTC 38.5916 -121.84836 Woodland 34 []
732986 December 07, 2019 - 22:42:35 UTC 38.5947 -121.94239 Woodland 34 []
717136 November 27, 2019 - 02:09:28 UTC 38.60104 -121.7526 Woodland 34 []
717101 November 27, 2019 - 02:08:47 UTC 38.6023 -121.76396 Woodland 34 []
717106 November 27, 2019 - 02:09:15 UTC 38.60252 -121.76638 Woodland 34 []
710200 November 19, 2019 - 20:19:58 UTC 38.60306 -121.70813 Woodland 34 []
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 []
732623 December 07, 2019 - 19:30:28 UTC 38.60561 -121.82233 Woodland 34 []
712868 November 22, 2019 - 18:00:22 UTC 38.607 -121.84027 Woodland 34 []
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 []
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 []
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"}]
686264 October 27, 2019 - 09:01:36 UTC 38.61752 -121.73816 Woodland 34 []
733395 December 08, 2019 - 03:22:27 UTC 38.61817 -121.87677 Woodland 34 []
733490 December 08, 2019 - 07:21:00 UTC 38.61817 -121.87677 Woodland 34 []
780921 February 09, 2020 - 13:10:00 UTC 38.61865 -121.85838 Woodland 34 [{"latitude": "38.59614", "longitude": "-121.85157"}, {"latitude": "38.61437", "longitude": "-121.86016"}, {"latitude": "38.59916", "longitude": "-121.86591"}]
780923 February 09, 2020 - 13:10:50 UTC 38.6191 -121.87676 Woodland 34 [{"latitude": "38.56377", "longitude": "-121.85718"}, {"latitude": "38.57998", "longitude": "-121.85855"}, {"latitude": "38.59063", "longitude": "-121.85951"}, {"latitude": "38.61817", "longitude": "-121.87677"}, {"latitude": "38.59048", "longitude": "-121.89535"}, {"latitude": "38.57357", "longitude": "-121.87324"}, {"latitude": "38.57143", "longitude": "-121.86983"}]
687340 October 27, 2019 - 15:59:00 UTC 38.61969 -121.80409 Woodland 34 [{"latitude": "38.56377", "longitude": "-121.85718"}, {"latitude": "38.61969", "longitude": "-121.80594"}, {"latitude": "38.63864", "longitude": "-121.82143"}, {"latitude": "38.63614", "longitude": "-121.86094"}, {"latitude": "38.63433", "longitude": "-121.87647"}, {"latitude": "38.62723", "longitude": "-121.88605"}, {"latitude": "38.59048", "longitude": "-121.89535"}, {"latitude": "38.57357", "longitude": "-121.87324"}, {"latitude": "38.57143", "longitude": "-121.86983"}]
692408 October 29, 2019 - 00:27:47 UTC 38.61978 -121.88661 Woodland 34 []
695124 October 30, 2019 - 18:07:00 UTC 38.61978 -121.88661 Woodland 34 []
696285 October 31, 2019 - 05:29:15 UTC 38.61978 -121.88661 Woodland 34 []
720702 November 27, 2019 - 16:54:10 UTC 38.61978 -121.88661 Woodland 34 []
695372 October 30, 2019 - 20:31:00 UTC 38.61979 -121.88664 Woodland 34 []
694008 October 29, 2019 - 19:35:26 UTC 38.61998 -121.89512 Woodland 34 []
674890 October 20, 2019 - 21:46:04 UTC 38.62035 -121.91558 Woodland 34 []
780924 February 09, 2020 - 13:11:10 UTC 38.62113 -121.82513 Woodland 34 [{"latitude": "38.62373", "longitude": "-121.82505"}, {"latitude": "38.62676", "longitude": "-121.82095"}, {"latitude": "38.63864", "longitude": "-121.82143"}, {"latitude": "38.62678", "longitude": "-121.82665"}]
738520 December 13, 2019 - 19:25:00 UTC 38.62188 -121.80274 Woodland 34 [{"latitude": "38.62579", "longitude": "-121.80564"}, {"latitude": "38.62691", "longitude": "-121.8037"}, {"latitude": "38.63552", "longitude": "-121.794"}, {"latitude": "38.63986", "longitude": "-121.79209"}, {"latitude": "38.64044", "longitude": "-121.79207"}, {"latitude": "38.66021", "longitude": "-121.79362"}, {"latitude": "38.66644", "longitude": "-121.79751"}, {"latitude": "38.66815", "longitude": "-121.79908"}, {"latitude": "38.66942", "longitude": "-121.80033"}, {"latitude": "38.6694", "longitude": "-121.80128"}, {"latitude": "38.66821", "longitude": "-121.80205"}, {"latitude": "38.66307", "longitude": "-121.80405"}, {"latitude": "38.63258", "longitude": "-121.81506"}]
739233 December 14, 2019 - 16:27:08 UTC 38.62509 -121.76836 Woodland 34 []
674887 October 20, 2019 - 21:36:19 UTC 38.6303 -121.89426 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 []
686112 October 27, 2019 - 08:26:44 UTC 38.64088 -121.80269 Woodland 34 []
688135 October 27, 2019 - 18:38:01 UTC 38.64111 -121.76612 Woodland 34 [{"latitude": "38.63495", "longitude": "-121.74735"}, {"latitude": "38.64003", "longitude": "-121.74742"}, {"latitude": "38.64086", "longitude": "-121.74747"}, {"latitude": "38.64546", "longitude": "-121.75013"}, {"latitude": "38.6437", "longitude": "-121.75786"}, {"latitude": "38.64088", "longitude": "-121.76445"}, {"latitude": "38.64033", "longitude": "-121.76444"}]
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 []
688403 October 27, 2019 - 19:25:00 UTC 38.64929 -121.94037 Woodland 34 []
712381 November 21, 2019 - 21:38:47 UTC 38.64946 -121.93389 Woodland 34 []
651067 October 09, 2019 - 20:36:11 UTC 38.65211 -121.73257 Woodland 34 []
702110 November 07, 2019 - 22:41:04 UTC 38.65256 -121.73145 Woodland 34 []
688406 October 27, 2019 - 19:25:31 UTC 38.65559 -121.76901 Woodland 34 []
692215 October 28, 2019 - 23:02:00 UTC 38.65559 -121.76901 Woodland 34 []
688395 October 27, 2019 - 19:22:00 UTC 38.65566 -121.76901 Woodland 34 [{"latitude": "38.65643", "longitude": "-121.77178"}, {"latitude": "38.65653", "longitude": "-121.76888"}, {"latitude": "38.65664", "longitude": "-121.76736"}, {"latitude": "38.65731", "longitude": "-121.7675"}, {"latitude": "38.65778", "longitude": "-121.76777"}, {"latitude": "38.66001", "longitude": "-121.77195"}, {"latitude": "38.65858", "longitude": "-121.77264"}]
737152 December 12, 2019 - 15:47:21 UTC 38.65594 -121.77586 Woodland 34 []
738890 December 14, 2019 - 15:09:50 UTC 38.65594 -121.77586 Woodland 34 []
709423 November 18, 2019 - 21:26:00 UTC 38.65603 -121.7831 Woodland 34 []
676973 October 22, 2019 - 20:21:37 UTC 38.65693 -121.76621 Woodland 34 []
687322 October 27, 2019 - 16:02:00 UTC 38.65703 -121.94728 Woodland 34 []
651068 October 09, 2019 - 20:36:00 UTC 38.65711 -121.76989 Woodland 34 []
651077 October 09, 2019 - 20:41:00 UTC 38.65717 -121.77266 Woodland 34 []
737504 December 12, 2019 - 18:38:00 UTC 38.65734 -121.79009 Woodland 34 []
633433 October 01, 2019 - 01:41:00 UTC 38.65738 -121.77805 Woodland 34 []
645864 October 07, 2019 - 15:39:19 UTC 38.65738 -121.77805 Woodland 34 []
655924 October 14, 2019 - 16:07:29 UTC 38.65738 -121.77805 Woodland 34 []
686338 October 27, 2019 - 09:23:04 UTC 38.6578 -121.77075 Woodland 34 []
732576 December 07, 2019 - 19:08:00 UTC 38.65813 -121.78259 Woodland 34 []
686265 October 27, 2019 - 09:01:51 UTC 38.65826 -121.79255 Woodland 34 []
729715 December 04, 2019 - 19:05:30 UTC 38.65861 -121.78433 Woodland 34 [{"latitude": "38.65608", "longitude": "-121.78994"}, {"latitude": "38.65825", "longitude": "-121.78509"}, {"latitude": "38.65916", "longitude": "-121.78827"}, {"latitude": "38.65891", "longitude": "-121.79035"}, {"latitude": "38.65801", "longitude": "-121.79182"}, {"latitude": "38.65628", "longitude": "-121.79146"}]
704253 November 11, 2019 - 16:06:00 UTC 38.65891 -121.79035 Woodland 34 []
744764 December 17, 2019 - 22:20:10 UTC 38.65891 -121.79035 Woodland 34 []
651066 October 09, 2019 - 20:36:09 UTC 38.659 -121.77595 Woodland 34 []
705036 November 12, 2019 - 19:16:45 UTC 38.66028 -121.76347 Woodland 34 []
686435 October 27, 2019 - 09:46:04 UTC 38.66048 -121.77027 Woodland 34 []
687114 October 27, 2019 - 14:47:41 UTC 38.66064 -121.77831 Woodland 34 []
650846 October 09, 2019 - 17:19:11 UTC 38.66106 -121.7668 Woodland 34 []
652020 October 10, 2019 - 04:08:59 UTC 38.66106 -121.7668 Woodland 34 []
706240 November 13, 2019 - 21:19:19 UTC 38.66122 -121.78292 Woodland 34 []
732601 December 07, 2019 - 19:19:22 UTC 38.66187 -121.75441 Woodland 34 []
647539 October 08, 2019 - 21:02:20 UTC 38.66218 -121.79724 Woodland 34 []
667873 October 18, 2019 - 15:43:15 UTC 38.66256 -121.77944 Woodland 34 []
690542 October 28, 2019 - 01:21:54 UTC 38.66258 -121.78274 Woodland 34 []
691807 October 28, 2019 - 19:25:28 UTC 38.66258 -121.78274 Woodland 34 []
695047 October 30, 2019 - 17:25:00 UTC 38.66275 -121.78096 Woodland 34 [{"latitude": "38.66036", "longitude": "-121.78113"}, {"latitude": "38.66182", "longitude": "-121.77924"}, {"latitude": "38.66256", "longitude": "-121.77944"}, {"latitude": "38.66257", "longitude": "-121.78042"}, {"latitude": "38.66259", "longitude": "-121.78363"}, {"latitude": "38.66079", "longitude": "-121.78369"}, {"latitude": "38.66038", "longitude": "-121.78328"}]
702872 November 08, 2019 - 21:16:16 UTC 38.66307 -121.78508 Woodland 34 []
706838 November 14, 2019 - 18:53:07 UTC 38.66307 -121.78508 Woodland 34 []
729615 December 04, 2019 - 17:51:57 UTC 38.66308 -121.76003 Woodland 34 []
686949 October 27, 2019 - 13:49:59 UTC 38.6632 -121.83038 Woodland 34 []
686515 October 27, 2019 - 10:14:09 UTC 38.66328 -121.79776 Woodland 34 [{"latitude": "38.66218", "longitude": "-121.79724"}, {"latitude": "38.66325", "longitude": "-121.79637"}, {"latitude": "38.66327", "longitude": "-121.79751"}]
686271 October 27, 2019 - 09:04:30 UTC 38.66336 -121.76769 Woodland 34 []
691336 October 28, 2019 - 14:55:01 UTC 38.66338 -121.94915 Woodland 34 []
706369 November 13, 2019 - 23:58:49 UTC 38.66341 -121.77963 Woodland 34 []
687241 October 27, 2019 - 15:31:48 UTC 38.66343 -121.78889 Woodland 34 []
687240 October 27, 2019 - 15:30:00 UTC 38.66347 -121.79104 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 1114.348ms · About: About this site