outages

422 rows where regionName = 34

View and edit SQL

id outageStartTime latitude longitude regionName outageDevices
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"}]
686206 October 27, 2019 - 08:39:24 UTC 38.7351 -121.78135 Woodland 34 []
686214 October 27, 2019 - 08:41:19 UTC 38.73669 -121.77579 Woodland 34 []
686224 October 27, 2019 - 08:44:02 UTC 38.66371 -121.7836 Woodland 34 []
686235 October 27, 2019 - 08:47:38 UTC 38.66842 -121.78474 Woodland 34 [{"latitude": "38.66719", "longitude": "-121.78638"}, {"latitude": "38.66731", "longitude": "-121.78474"}, {"latitude": "38.66842", "longitude": "-121.78516"}, {"latitude": "38.66843", "longitude": "-121.78596"}, {"latitude": "38.66797", "longitude": "-121.78637"}]
686244 October 27, 2019 - 08:50:00 UTC 38.72903 -121.76798 Woodland 34 []
686258 October 27, 2019 - 08:58:25 UTC 38.60494 -121.71465 Woodland 34 []
686262 October 27, 2019 - 09:01:15 UTC 38.60794 -121.72967 Woodland 34 []
686263 October 27, 2019 - 09:01:15 UTC 38.60798 -121.72812 Woodland 34 []
686264 October 27, 2019 - 09:01:36 UTC 38.61752 -121.73816 Woodland 34 []
686265 October 27, 2019 - 09:01:51 UTC 38.65826 -121.79255 Woodland 34 []
686271 October 27, 2019 - 09:04:30 UTC 38.66336 -121.76769 Woodland 34 []
686283 October 27, 2019 - 09:06:42 UTC 38.66436 -121.78239 Woodland 34 []
686296 October 27, 2019 - 09:11:01 UTC 38.66987 -121.76949 Woodland 34 []
686338 October 27, 2019 - 09:23:04 UTC 38.6578 -121.77075 Woodland 34 []
686393 October 27, 2019 - 09:32:00 UTC 38.68429 -121.77468 Woodland 34 []
686425 October 27, 2019 - 09:41:27 UTC 38.70339 -121.90075 Woodland 34 []
686435 October 27, 2019 - 09:46:04 UTC 38.66048 -121.77027 Woodland 34 []
686466 October 27, 2019 - 09:57:06 UTC 38.69233 -121.76158 Woodland 34 []
686467 October 27, 2019 - 09:57:06 UTC 38.69381 -121.75929 Woodland 34 []
686472 October 27, 2019 - 09:57:32 UTC 38.69196 -121.76054 Woodland 34 []
686473 October 27, 2019 - 09:57:32 UTC 38.69175 -121.76225 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"}]
686521 October 27, 2019 - 10:18:07 UTC 38.66745 -121.78191 Woodland 34 []
686522 October 27, 2019 - 10:18:00 UTC 38.73631 -121.82623 Woodland 34 []
686557 October 27, 2019 - 10:38:13 UTC 38.68396 -121.773 Woodland 34 []
686565 October 27, 2019 - 10:42:42 UTC 38.67629 -121.77816 Woodland 34 []
686628 October 27, 2019 - 08:58:25 UTC 38.60494 -121.71465 Woodland 34 []
686708 October 27, 2019 - 12:15:00 UTC 38.76442 -121.81978 Woodland 34 []
686735 October 27, 2019 - 12:27:06 UTC 38.68289 -121.77471 Woodland 34 []
686740 October 27, 2019 - 12:31:29 UTC 38.66748 -121.78 Woodland 34 []
686788 October 27, 2019 - 13:14:07 UTC 38.67211 -121.77805 Woodland 34 []
686949 October 27, 2019 - 13:49:59 UTC 38.6632 -121.83038 Woodland 34 []
686996 October 27, 2019 - 14:00:00 UTC 38.72831 -121.85011 Woodland 34 []
687043 October 27, 2019 - 13:58:15 UTC 38.76854 -121.88943 Woodland 34 []
687095 October 27, 2019 - 14:42:42 UTC 38.66602 -121.79621 Woodland 34 []
687114 October 27, 2019 - 14:47:41 UTC 38.66064 -121.77831 Woodland 34 []
687217 October 27, 2019 - 15:22:06 UTC 38.68206 -121.77387 Woodland 34 []
687240 October 27, 2019 - 15:30:00 UTC 38.66347 -121.79104 Woodland 34 []
687241 October 27, 2019 - 15:31:48 UTC 38.66343 -121.78889 Woodland 34 []
687261 October 27, 2019 - 15:41:45 UTC 38.67398 -121.79327 Woodland 34 []
687276 October 27, 2019 - 15:46:48 UTC 38.68045 -121.7626 Woodland 34 []
687307 October 27, 2019 - 16:00:16 UTC 38.60798 -121.72812 Woodland 34 []
687312 October 27, 2019 - 16:01:24 UTC 38.60794 -121.72967 Woodland 34 []
687322 October 27, 2019 - 16:02:00 UTC 38.65703 -121.94728 Woodland 34 []
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"}]
687354 October 27, 2019 - 16:10:04 UTC 38.66876 -121.76132 Woodland 34 []
687389 October 27, 2019 - 16:13:30 UTC 38.74242 -121.78733 Woodland 34 []
687584 October 27, 2019 - 16:59:52 UTC 38.68242 -121.79557 Woodland 34 []
687627 October 27, 2019 - 17:09:07 UTC 38.67509 -121.77186 Woodland 34 []
687781 October 27, 2019 - 17:45:58 UTC 38.68411 -121.7675 Woodland 34 []
687895 October 27, 2019 - 18:00:01 UTC 38.6915 -121.75992 Woodland 34 []
687904 October 27, 2019 - 18:01:20 UTC 38.68748 -121.77782 Woodland 34 []
687954 October 27, 2019 - 18:07:48 UTC 38.68814 -121.79088 Woodland 34 []
687963 October 27, 2019 - 18:08:44 UTC 38.75497 -121.66475 Woodland 34 []
688004 October 27, 2019 - 18:14:55 UTC 38.68749 -121.77292 Woodland 34 []
688012 October 27, 2019 - 18:16:02 UTC 38.68777 -121.77954 Woodland 34 []
688013 October 27, 2019 - 18:16:03 UTC 38.69011 -121.77557 Woodland 34 []
688134 October 27, 2019 - 18:37:55 UTC 38.68429 -121.77468 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"}]
688190 October 27, 2019 - 18:46:30 UTC 38.69288 -121.78437 Woodland 34 []
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"}]
688250 October 27, 2019 - 18:55:32 UTC 38.68644 -121.77391 Woodland 34 []
688266 October 27, 2019 - 18:56:02 UTC 38.67498 -121.76955 Woodland 34 []
688300 October 27, 2019 - 19:02:11 UTC 38.67422 -121.78168 Woodland 34 []
688317 October 27, 2019 - 19:06:12 UTC 38.68328 -121.78388 Woodland 34 []
688336 October 27, 2019 - 19:10:50 UTC 38.67312 -121.77821 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"}]
688403 October 27, 2019 - 19:25:00 UTC 38.64929 -121.94037 Woodland 34 []
688406 October 27, 2019 - 19:25:31 UTC 38.65559 -121.76901 Woodland 34 []
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"}]
688753 October 27, 2019 - 20:11:31 UTC 38.67276 -121.75514 Woodland 34 []
689355 October 27, 2019 - 21:17:06 UTC 38.67309 -121.77123 Woodland 34 []
689460 October 27, 2019 - 21:28:46 UTC 38.77649 -121.68919 Woodland 34 []
689736 October 27, 2019 - 21:57:58 UTC 38.78156 -121.69252 Woodland 34 []
689964 October 27, 2019 - 22:31:11 UTC 38.67498 -121.76955 Woodland 34 []
690029 October 27, 2019 - 22:43:48 UTC 38.5907 -121.7693 Woodland 34 []
690038 October 27, 2019 - 22:45:14 UTC 38.67215 -121.78328 Woodland 34 []
690192 October 27, 2019 - 23:21:12 UTC 38.71674 -121.81522 Woodland 34 []
690225 October 27, 2019 - 23:27:50 UTC 38.68587 -121.76773 Woodland 34 []
690525 October 28, 2019 - 01:14:35 UTC 38.66941 -121.75927 Woodland 34 []
690542 October 28, 2019 - 01:21:54 UTC 38.66258 -121.78274 Woodland 34 []
690723 October 28, 2019 - 02:14:04 UTC 38.69381 -121.75929 Woodland 34 []
690788 October 28, 2019 - 02:42:37 UTC 38.66447 -121.7743 Woodland 34 []
690834 October 28, 2019 - 03:13:39 UTC 38.66765 -121.78169 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"}]
691017 October 28, 2019 - 05:33:09 UTC 38.74481 -121.76364 Woodland 34 []
691220 October 28, 2019 - 10:14:56 UTC 38.68409 -121.75921 Woodland 34 []
691235 October 28, 2019 - 12:14:00 UTC 38.69133 -121.7576 Woodland 34 []
691240 October 28, 2019 - 12:39:00 UTC 38.6917 -121.74789 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 []
691263 October 28, 2019 - 13:13:54 UTC 38.76202 -121.78311 Woodland 34 []
691290 October 28, 2019 - 13:51:00 UTC 38.69349 -121.7604 Woodland 34 []
691293 October 28, 2019 - 13:54:26 UTC 38.67693 -121.77623 Woodland 34 []
691304 October 28, 2019 - 14:09:50 UTC 38.69141 -121.75943 Woodland 34 []
691320 October 28, 2019 - 14:28:00 UTC 38.69233 -121.76158 Woodland 34 []
691336 October 28, 2019 - 14:55:01 UTC 38.66338 -121.94915 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"}]

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