outages

461 rows where regionName = 34 sorted by outageStartTime descending

View and edit SQL

id outageStartTime ▲ latitude longitude regionName outageDevices
1086059 September 21, 2020 - 23:17:32 UTC 38.6083 -121.78974 Woodland 34 []
1083075 September 20, 2020 - 00:09:33 UTC 38.56858 -121.84026 Woodland 34 []
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 []
1081919 September 18, 2020 - 23:14:00 UTC 38.67231 -121.7358 Woodland 34 []
1081953 September 18, 2020 - 23:14:00 UTC 38.67231 -121.7358 Woodland 34 []
1081914 September 18, 2020 - 22:57:00 UTC 38.6717 -121.73785 Woodland 34 [{"latitude": "38.67285", "longitude": "-121.73725"}, {"latitude": "38.67298", "longitude": "-121.73337"}, {"latitude": "38.67322", "longitude": "-121.73525"}, {"latitude": "38.67325", "longitude": "-121.73679"}]
1080365 September 18, 2020 - 16:59:25 UTC 38.78366 -121.77991 Woodland 34 []
1079623 September 18, 2020 - 03:46:55 UTC 38.68264 -121.78223 Woodland 34 []
1078938 September 17, 2020 - 21:26:12 UTC 38.76431 -121.8067 Woodland 34 []
1078634 September 17, 2020 - 20:23:44 UTC 38.74038 -121.76562 Woodland 34 []
1078513 September 17, 2020 - 19:53:54 UTC 38.64136 -121.88521 Woodland 34 []
1076313 September 16, 2020 - 22:10:28 UTC 38.66964 -121.76835 Woodland 34 []
1073708 September 16, 2020 - 09:23:48 UTC 38.74038 -121.76562 Woodland 34 []
1073707 September 16, 2020 - 09:00:00 UTC 38.67717 -121.75825 Woodland 34 [{"latitude": "38.67587", "longitude": "-121.7584"}, {"latitude": "38.6769", "longitude": "-121.75866"}, {"latitude": "38.67598", "longitude": "-121.75938"}]
1072735 September 15, 2020 - 20:52:12 UTC 38.67381 -121.7794 Woodland 34 []
1072714 September 15, 2020 - 20:49:09 UTC 38.67202 -121.76989 Woodland 34 []
1072753 September 15, 2020 - 20:43:00 UTC 38.66347 -121.79104 Woodland 34 []
1072673 September 15, 2020 - 20:42:08 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"}]
1071873 September 15, 2020 - 17:58:33 UTC 38.65796 -121.71425 Woodland 34 []
1071754 September 15, 2020 - 17:25:25 UTC 38.66527 -121.76766 Woodland 34 []
1068573 September 14, 2020 - 16:18:00 UTC 38.77806 -121.74691 Woodland 34 []
1068393 September 14, 2020 - 15:53:47 UTC 38.76432 -121.80759 Woodland 34 []
1067375 September 14, 2020 - 00:07:45 UTC 38.68174 -121.79557 Woodland 34 []
1065322 September 12, 2020 - 01:06:30 UTC 38.6811 -121.76669 Woodland 34 []
1065283 September 11, 2020 - 23:38:55 UTC 38.66447 -121.7711 Woodland 34 []
1064375 September 11, 2020 - 16:30:17 UTC 38.67157 -121.78285 Woodland 34 []
1064337 September 11, 2020 - 16:21:43 UTC 38.68681 -121.78628 Woodland 34 []
1064251 September 11, 2020 - 16:02:36 UTC 38.77802 -121.73068 Woodland 34 []
1064238 September 11, 2020 - 15:57:00 UTC 38.71764 -121.94693 Woodland 34 []
1064090 September 11, 2020 - 14:57:59 UTC 38.66857 -121.77135 Woodland 34 []
1064016 September 11, 2020 - 06:44:00 UTC 38.68054 -121.78705 Woodland 34 []
1064015 September 11, 2020 - 06:28:00 UTC 38.68064 -121.78373 Woodland 34 []
1062789 September 10, 2020 - 16:16:01 UTC 38.66256 -121.7624 Woodland 34 []
1062529 September 10, 2020 - 05:16:52 UTC 38.66427 -121.77875 Woodland 34 []
1061383 September 08, 2020 - 23:25:00 UTC 38.66484 -121.79614 Woodland 34 []
1061379 September 08, 2020 - 23:20:36 UTC 38.68173 -121.77388 Woodland 34 []
1061236 September 08, 2020 - 21:11:24 UTC 38.66602 -121.79621 Woodland 34 []
1026961 August 22, 2020 - 16:06:27 UTC 38.66872 -121.79664 Woodland 34 []
789633 February 12, 2020 - 20:53:17 UTC 38.77927 -121.84633 Woodland 34 []
789452 February 12, 2020 - 18:00:33 UTC 38.59046 -121.75174 Woodland 34 []
789437 February 12, 2020 - 17:48:55 UTC 38.6654 -121.7718 Woodland 34 []
788957 February 11, 2020 - 23:15:37 UTC 38.67361 -121.91051 Woodland 34 []
788399 February 11, 2020 - 16:47:26 UTC 38.67984 -121.76654 Woodland 34 []
787918 February 11, 2020 - 01:10:55 UTC 38.68109 -121.79282 Woodland 34 []
786593 February 10, 2020 - 06:38:19 UTC 38.63761 -121.7209 Woodland 34 []
786339 February 10, 2020 - 04:08:01 UTC 38.63761 -121.7209 Woodland 34 []
785462 February 10, 2020 - 00:01:49 UTC 38.68562 -121.77804 Woodland 34 []
784860 February 09, 2020 - 22:15:26 UTC 38.73426 -121.76529 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"}]
784100 February 09, 2020 - 20:57:36 UTC 38.69169 -121.78658 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"}]
782615 February 09, 2020 - 18:58:18 UTC 38.66381 -121.78998 Woodland 34 []
781235 February 09, 2020 - 16:24:02 UTC 38.66381 -121.78998 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"}]
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"}]
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"}]
779440 February 06, 2020 - 21:00:13 UTC 38.66381 -121.78998 Woodland 34 []
778570 February 05, 2020 - 20:07:57 UTC 38.67186 -121.79226 Woodland 34 []
778137 February 05, 2020 - 03:53:55 UTC 38.68451 -121.79198 Woodland 34 []
744764 December 17, 2019 - 22:20:10 UTC 38.65891 -121.79035 Woodland 34 []
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"}]
744443 December 17, 2019 - 18:24:15 UTC 38.60794 -121.72967 Woodland 34 []
742474 December 16, 2019 - 18:25:16 UTC 38.671 -121.7935 Woodland 34 []
739598 December 14, 2019 - 19:42:09 UTC 38.69983 -121.82941 Woodland 34 []
739233 December 14, 2019 - 16:27:08 UTC 38.62509 -121.76836 Woodland 34 []
738973 December 14, 2019 - 15:35:34 UTC 38.73442 -121.78136 Woodland 34 []
738933 December 14, 2019 - 15:28:00 UTC 38.73291 -121.78138 Woodland 34 []
738890 December 14, 2019 - 15:09:50 UTC 38.65594 -121.77586 Woodland 34 []
738814 December 14, 2019 - 05:02:53 UTC 38.69095 -121.78508 Woodland 34 []
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"}]
737939 December 13, 2019 - 03:10:57 UTC 38.66503 -121.75905 Woodland 34 []
737514 December 12, 2019 - 18:48:08 UTC 38.66545 -121.794 Woodland 34 []
737504 December 12, 2019 - 18:38:00 UTC 38.65734 -121.79009 Woodland 34 []
737300 December 12, 2019 - 17:07:43 UTC 38.66673 -121.79033 Woodland 34 []
737223 December 12, 2019 - 16:43:27 UTC 38.64919 -121.74199 Woodland 34 []
737152 December 12, 2019 - 15:47:21 UTC 38.65594 -121.77586 Woodland 34 []
737055 December 12, 2019 - 08:48:46 UTC 38.69153 -121.77294 Woodland 34 []
736897 December 12, 2019 - 04:16:24 UTC 38.66673 -121.79033 Woodland 34 []
736248 December 11, 2019 - 16:57:00 UTC 38.59107 -121.66921 Woodland 34 []
736207 December 11, 2019 - 16:35:00 UTC 38.64919 -121.74199 Woodland 34 []
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 []
735893 December 11, 2019 - 00:22:28 UTC 38.79244 -121.72947 Woodland 34 []
734980 December 10, 2019 - 02:32:23 UTC 38.67177 -121.76206 Woodland 34 []
734860 December 09, 2019 - 23:37:53 UTC 38.66876 -121.76132 Woodland 34 []
734668 December 09, 2019 - 20:54:45 UTC 38.66778 -121.74612 Woodland 34 []
734356 December 09, 2019 - 17:33:00 UTC 38.77827 -121.75063 Woodland 34 []
733490 December 08, 2019 - 07:21:00 UTC 38.61817 -121.87677 Woodland 34 []
733428 December 08, 2019 - 04:29:40 UTC 38.68107 -121.78106 Woodland 34 []
733395 December 08, 2019 - 03:22:27 UTC 38.61817 -121.87677 Woodland 34 []
732986 December 07, 2019 - 22:42:35 UTC 38.5947 -121.94239 Woodland 34 []
732961 December 07, 2019 - 22:31:59 UTC 38.58426 -121.93538 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"}]
732725 December 07, 2019 - 20:31:13 UTC 38.67792 -121.84086 Woodland 34 [{"latitude": "38.67781", "longitude": "-121.84185"}, {"latitude": "38.68323", "longitude": "-121.84972"}, {"latitude": "38.68212", "longitude": "-121.84976"}, {"latitude": "38.67796", "longitude": "-121.84645"}, {"latitude": "38.67782", "longitude": "-121.8454"}]
732623 December 07, 2019 - 19:30:28 UTC 38.60561 -121.82233 Woodland 34 []
732601 December 07, 2019 - 19:19:22 UTC 38.66187 -121.75441 Woodland 34 []
732576 December 07, 2019 - 19:08:00 UTC 38.65813 -121.78259 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"}]
730217 December 05, 2019 - 13:20:38 UTC 38.67734 -121.79323 Woodland 34 [{"latitude": "38.678", "longitude": "-121.79375"}, {"latitude": "38.67808", "longitude": "-121.79307"}, {"latitude": "38.6786", "longitude": "-121.79312"}, {"latitude": "38.67879", "longitude": "-121.79342"}]

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