outages

1,386 rows where regionName = 78

View and edit SQL

id outageStartTime latitude longitude regionName outageDevices
633601 October 01, 2019 - 15:05:15 UTC 37.91753 -121.26085 Stockton 78 [{"latitude": "37.91776", "longitude": "-121.26004"}, {"latitude": "37.91849", "longitude": "-121.25581"}, {"latitude": "37.91956", "longitude": "-121.25738"}, {"latitude": "37.91899", "longitude": "-121.25974"}, {"latitude": "37.91816", "longitude": "-121.26072"}]
633818 October 01, 2019 - 16:13:21 UTC 37.93194 -121.26511 Stockton 78 []
633836 October 01, 2019 - 16:21:56 UTC 37.9565 -121.31958 Stockton 78 []
633876 October 01, 2019 - 16:37:11 UTC 37.97488 -121.29575 Stockton 78 []
633946 October 01, 2019 - 17:37:26 UTC 38.03746 -121.3368 Stockton 78 []
635093 October 01, 2019 - 22:41:03 UTC 37.95217 -121.29154 Stockton 78 []
635133 October 01, 2019 - 22:51:36 UTC 37.97524 -121.31085 Stockton 78 []
635403 October 02, 2019 - 00:20:41 UTC 37.98362 -121.28761 Stockton 78 []
635725 October 02, 2019 - 12:26:00 UTC 37.95502 -121.31767 Stockton 78 []
635894 October 02, 2019 - 16:30:44 UTC 37.95542 -121.27343 Stockton 78 []
636134 October 02, 2019 - 16:51:43 UTC 37.9226 -121.26327 Stockton 78 [{"latitude": "37.92197", "longitude": "-121.26115"}, {"latitude": "37.92236", "longitude": "-121.25734"}, {"latitude": "37.9238", "longitude": "-121.25745"}, {"latitude": "37.92457", "longitude": "-121.25839"}, {"latitude": "37.92524", "longitude": "-121.25949"}, {"latitude": "37.92385", "longitude": "-121.26204"}, {"latitude": "37.92273", "longitude": "-121.26273"}]
637353 October 02, 2019 - 19:36:52 UTC 38.0541 -121.38406 Stockton 78 []
638095 October 02, 2019 - 21:19:15 UTC 37.95834 -121.28262 Stockton 78 []
638254 October 02, 2019 - 21:49:54 UTC 37.96099 -121.30497 Stockton 78 []
638831 October 03, 2019 - 01:01:56 UTC 37.98773 -121.30622 Stockton 78 []
638887 October 03, 2019 - 03:58:50 UTC 37.84215 -121.53714 Stockton 78 [{"latitude": "37.83374", "longitude": "-121.54972"}, {"latitude": "37.84361", "longitude": "-121.53866"}, {"latitude": "37.84555", "longitude": "-121.53822"}, {"latitude": "37.84901", "longitude": "-121.54272"}, {"latitude": "37.85758", "longitude": "-121.55569"}]
638954 October 03, 2019 - 13:21:57 UTC 37.93067 -121.26181 Stockton 78 [{"latitude": "37.92667", "longitude": "-121.26328"}, {"latitude": "37.92718", "longitude": "-121.25899"}, {"latitude": "37.92831", "longitude": "-121.25749"}, {"latitude": "37.93091", "longitude": "-121.25993"}, {"latitude": "37.93057", "longitude": "-121.26144"}, {"latitude": "37.92963", "longitude": "-121.26386"}, {"latitude": "37.92919", "longitude": "-121.26379"}]
638957 October 03, 2019 - 13:21:58 UTC 37.92718 -121.25899 Stockton 78 []
638958 October 03, 2019 - 13:22:55 UTC 37.92812 -121.25888 Stockton 78 []
638960 October 03, 2019 - 13:21:57 UTC 37.92793 -121.26249 Stockton 78 []
638964 October 03, 2019 - 13:21:57 UTC 37.93067 -121.26181 Stockton 78 [{"latitude": "37.92667", "longitude": "-121.26328"}, {"latitude": "37.92718", "longitude": "-121.25899"}, {"latitude": "37.92831", "longitude": "-121.25749"}, {"latitude": "37.93091", "longitude": "-121.25993"}, {"latitude": "37.93057", "longitude": "-121.26144"}, {"latitude": "37.92963", "longitude": "-121.26386"}, {"latitude": "37.92919", "longitude": "-121.26379"}]
639018 October 03, 2019 - 15:10:00 UTC 37.93293 -121.2668 Stockton 78 [{"latitude": "37.93184", "longitude": "-121.26633"}, {"latitude": "37.93221", "longitude": "-121.26648"}, {"latitude": "37.93261", "longitude": "-121.26668"}]
639030 October 03, 2019 - 15:16:38 UTC 37.93297 -121.26681 Stockton 78 []
639035 October 03, 2019 - 15:21:22 UTC 37.92696 -121.26164 Stockton 78 []
639070 October 03, 2019 - 15:42:37 UTC 37.95632 -121.26971 Stockton 78 []
639172 October 03, 2019 - 16:13:25 UTC 37.93032 -121.27458 Stockton 78 [{"latitude": "37.92403", "longitude": "-121.27628"}, {"latitude": "37.92632", "longitude": "-121.27488"}, {"latitude": "37.9296", "longitude": "-121.27486"}, {"latitude": "37.93056", "longitude": "-121.27526"}, {"latitude": "37.93096", "longitude": "-121.27544"}, {"latitude": "37.93222", "longitude": "-121.28217"}, {"latitude": "37.93019", "longitude": "-121.28221"}, {"latitude": "37.92952", "longitude": "-121.28204"}, {"latitude": "37.92803", "longitude": "-121.28154"}, {"latitude": "37.92406", "longitude": "-121.27741"}]
639192 October 03, 2019 - 16:21:31 UTC 37.93297 -121.26681 Stockton 78 []
639200 October 03, 2019 - 16:23:36 UTC 37.9772 -121.47311 Stockton 78 []
639210 October 03, 2019 - 16:13:25 UTC 37.92583 -121.27603 Stockton 78 [{"latitude": "37.92591", "longitude": "-121.27518"}, {"latitude": "37.92632", "longitude": "-121.27488"}, {"latitude": "37.92621", "longitude": "-121.27516"}]
639237 October 03, 2019 - 16:42:34 UTC 37.97119 -121.29531 Stockton 78 []
639657 October 03, 2019 - 18:01:16 UTC 37.95421 -121.2524 Stockton 78 []
640274 October 03, 2019 - 16:21:31 UTC 37.93297 -121.26681 Stockton 78 []
641373 October 03, 2019 - 22:07:47 UTC 37.9217 -121.28979 Stockton 78 []
641953 October 04, 2019 - 00:30:33 UTC 37.95896 -121.29894 Stockton 78 []
642373 October 04, 2019 - 15:22:47 UTC 37.91022 -121.2163 Stockton 78 []
642374 October 04, 2019 - 15:27:00 UTC 37.93022 -121.27705 Stockton 78 []
642746 October 04, 2019 - 16:01:30 UTC 37.82071 -121.44754 Stockton 78 [{"latitude": "37.8203", "longitude": "-121.44983"}, {"latitude": "37.82072", "longitude": "-121.4459"}, {"latitude": "37.82187", "longitude": "-121.44787"}, {"latitude": "37.82232", "longitude": "-121.44965"}]
643319 October 04, 2019 - 17:12:00 UTC 37.93977 -121.28615 Stockton 78 []
643653 October 04, 2019 - 19:42:28 UTC 37.92924 -121.27758 Stockton 78 []
643687 October 04, 2019 - 20:25:24 UTC 38.02187 -121.31079 Stockton 78 []
643722 October 04, 2019 - 21:31:50 UTC 37.97032 -121.29878 Stockton 78 []
643723 October 04, 2019 - 21:35:34 UTC 37.94511 -121.31523 Stockton 78 []
643733 October 04, 2019 - 21:52:45 UTC 37.82076 -121.44663 Stockton 78 []
643766 October 04, 2019 - 23:04:00 UTC 37.95828 -121.30015 Stockton 78 []
643778 October 04, 2019 - 23:20:11 UTC 37.95345 -121.27625 Stockton 78 []
643787 October 05, 2019 - 00:00:14 UTC 37.95429 -121.27531 Stockton 78 []
643793 October 05, 2019 - 00:18:06 UTC 38.01101 -121.33121 Stockton 78 []
644235 October 05, 2019 - 16:29:18 UTC 37.99686 -121.30373 Stockton 78 []
644675 October 05, 2019 - 17:43:48 UTC 38.00805 -121.35033 Stockton 78 []
645087 October 06, 2019 - 00:44:52 UTC 37.9866 -121.36124 Stockton 78 []
645105 October 06, 2019 - 01:22:40 UTC 37.95615 -121.24401 Stockton 78 []
645115 October 06, 2019 - 01:27:08 UTC 37.94599 -121.27717 Stockton 78 []
645137 October 06, 2019 - 02:37:27 UTC 37.97741 -121.30503 Stockton 78 []
645165 October 06, 2019 - 05:03:20 UTC 37.9866 -121.36124 Stockton 78 []
645671 October 06, 2019 - 22:21:30 UTC 37.99568 -121.30503 Stockton 78 []
645697 October 06, 2019 - 23:54:52 UTC 38.05417 -121.38206 Stockton 78 []
645727 October 07, 2019 - 01:56:33 UTC 37.99568 -121.30503 Stockton 78 []
645819 October 07, 2019 - 15:01:32 UTC 38.01791 -121.31855 Stockton 78 []
645922 October 07, 2019 - 16:08:47 UTC 37.97413 -121.30541 Stockton 78 []
645960 October 07, 2019 - 16:35:03 UTC 37.97026 -121.27995 Stockton 78 []
646123 October 07, 2019 - 18:28:00 UTC 38.01967 -121.23072 Stockton 78 []
646129 October 07, 2019 - 18:33:30 UTC 38.02722 -121.33249 Stockton 78 []
646693 October 07, 2019 - 21:11:45 UTC 37.94523 -121.30331 Stockton 78 []
646776 October 07, 2019 - 21:25:33 UTC 37.99292 -121.18468 Stockton 78 []
646887 October 07, 2019 - 22:52:00 UTC 37.96429 -121.33399 Stockton 78 []
646891 October 07, 2019 - 22:52:00 UTC 37.96429 -121.33399 Stockton 78 []
646893 October 07, 2019 - 23:00:06 UTC 37.94266 -121.30742 Stockton 78 []
646923 October 07, 2019 - 23:41:53 UTC 38.02247 -121.3291 Stockton 78 []
646956 October 08, 2019 - 00:30:16 UTC 38.01967 -121.23072 Stockton 78 []
646973 October 08, 2019 - 01:16:37 UTC 37.97188 -121.30558 Stockton 78 []
647049 October 08, 2019 - 12:46:09 UTC 37.94426 -121.30363 Stockton 78 []
647050 October 08, 2019 - 12:59:43 UTC 37.94426 -121.30363 Stockton 78 []
647065 October 08, 2019 - 14:01:07 UTC 37.9132 -121.41062 Stockton 78 []
647089 October 08, 2019 - 15:02:00 UTC 37.89135 -121.25947 Stockton 78 []
647106 October 08, 2019 - 15:17:00 UTC 37.90758 -121.0466 Stockton 78 [{"latitude": "37.91036", "longitude": "-121.04669"}, {"latitude": "37.91817", "longitude": "-121.03791"}, {"latitude": "37.91952", "longitude": "-121.03772"}, {"latitude": "37.92134", "longitude": "-121.0399"}, {"latitude": "37.91851", "longitude": "-121.04698"}]
647259 October 08, 2019 - 16:00:00 UTC 37.92759 -121.14777 Stockton 78 [{"latitude": "37.92759", "longitude": "-121.14746"}, {"latitude": "37.92763", "longitude": "-121.14469"}, {"latitude": "37.92775", "longitude": "-121.13662"}]
647275 October 08, 2019 - 16:02:00 UTC 37.96889 -121.25595 Stockton 78 []
647283 October 08, 2019 - 16:06:00 UTC 37.96034 -121.30015 Stockton 78 []
647290 October 08, 2019 - 16:10:00 UTC 37.92894 -121.27522 Stockton 78 []
647323 October 08, 2019 - 16:27:34 UTC 37.97465 -121.3067 Stockton 78 []
647454 October 08, 2019 - 18:55:54 UTC 37.9719 -121.2806 Stockton 78 []
647529 October 08, 2019 - 20:39:11 UTC 37.88629 -121.06718 Stockton 78 []
647551 October 08, 2019 - 21:20:54 UTC 38.00501 -121.32183 Stockton 78 []
647644 October 09, 2019 - 00:01:20 UTC 37.9579 -121.33722 Stockton 78 []
647703 October 09, 2019 - 02:14:56 UTC 38.0064 -121.36255 Stockton 78 []
647734 October 09, 2019 - 02:56:00 UTC 37.94252 -121.28577 Stockton 78 []
647749 October 09, 2019 - 03:53:14 UTC 37.85205 -121.37648 Stockton 78 []
649334 October 09, 2019 - 09:50:00 UTC 37.95611 -121.33784 Stockton 78 []
650721 October 09, 2019 - 15:04:50 UTC 37.9519 -121.24673 Stockton 78 []
650916 October 09, 2019 - 18:36:22 UTC 37.94508 -121.30424 Stockton 78 []
651097 October 09, 2019 - 20:52:03 UTC 37.94538 -121.29708 Stockton 78 []
651601 October 10, 2019 - 00:06:00 UTC 38.00679 -121.3603 Stockton 78 []
652608 October 10, 2019 - 13:48:29 UTC 37.92695 -121.43127 Stockton 78 []
652609 October 10, 2019 - 13:48:28 UTC 37.9269 -121.43227 Stockton 78 [{"latitude": "37.92062", "longitude": "-121.42991"}, {"latitude": "37.92618", "longitude": "-121.4322"}, {"latitude": "37.9223", "longitude": "-121.43557"}]
652682 October 10, 2019 - 15:41:00 UTC 37.96733 -121.3047 Stockton 78 []
652685 October 10, 2019 - 15:44:20 UTC 37.99568 -121.30503 Stockton 78 []
653250 October 10, 2019 - 20:02:00 UTC 37.94366 -121.30912 Stockton 78 []
653533 October 10, 2019 - 22:35:00 UTC 37.96262 -121.31388 Stockton 78 []
653584 October 10, 2019 - 23:00:41 UTC 37.95932 -121.32525 Stockton 78 []
653634 October 10, 2019 - 23:32:56 UTC 37.94538 -121.23072 Stockton 78 []

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