outages

460 rows where regionName = 34 sorted by longitude

View and edit SQL

id outageStartTime latitude longitude ▼ regionName outageDevices
694206 October 29, 2019 - 21:46:43 UTC 38.68863 -121.76491 Woodland 34 []
686095 October 27, 2019 - 08:25:46 UTC 38.68216 -121.76517 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"}]
709898 November 19, 2019 - 16:40:42 UTC 38.67381 -121.76517 Woodland 34 []
784860 February 09, 2020 - 22:15:26 UTC 38.73426 -121.76529 Woodland 34 []
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 []
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"}]
676973 October 22, 2019 - 20:21:37 UTC 38.65693 -121.76621 Woodland 34 []
717106 November 27, 2019 - 02:09:15 UTC 38.60252 -121.76638 Woodland 34 []
788399 February 11, 2020 - 16:47:26 UTC 38.67984 -121.76654 Woodland 34 []
1065322 September 12, 2020 - 01:06:30 UTC 38.6811 -121.76669 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 []
687781 October 27, 2019 - 17:45:58 UTC 38.68411 -121.7675 Woodland 34 []
1071754 September 15, 2020 - 17:25:25 UTC 38.66527 -121.76766 Woodland 34 []
686271 October 27, 2019 - 09:04:30 UTC 38.66336 -121.76769 Woodland 34 []
690225 October 27, 2019 - 23:27:50 UTC 38.68587 -121.76773 Woodland 34 []
693265 October 29, 2019 - 15:41:43 UTC 38.68587 -121.76773 Woodland 34 []
697272 November 01, 2019 - 15:02:29 UTC 38.68587 -121.76773 Woodland 34 []
686244 October 27, 2019 - 08:50:00 UTC 38.72903 -121.76798 Woodland 34 []
716935 November 27, 2019 - 01:56:00 UTC 38.66494 -121.7682 Woodland 34 [{"latitude": "38.66314", "longitude": "-121.76873"}, {"latitude": "38.66388", "longitude": "-121.76871"}, {"latitude": "38.66449", "longitude": "-121.76871"}, {"latitude": "38.66493", "longitude": "-121.76913"}, {"latitude": "38.66491", "longitude": "-121.77004"}]
1076313 September 16, 2020 - 22:10:28 UTC 38.66964 -121.76835 Woodland 34 []
739233 December 14, 2019 - 16:27:08 UTC 38.62509 -121.76836 Woodland 34 []
691438 October 28, 2019 - 16:04:05 UTC 38.68827 -121.76838 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"}]
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 []
714954 November 26, 2019 - 05:39:42 UTC 38.6831 -121.76924 Woodland 34 []
690029 October 27, 2019 - 22:43:48 UTC 38.5907 -121.7693 Woodland 34 []
654103 October 11, 2019 - 14:30:04 UTC 38.68197 -121.76937 Woodland 34 []
691678 October 28, 2019 - 18:04:16 UTC 38.66414 -121.76938 Woodland 34 []
696851 October 31, 2019 - 20:31:30 UTC 38.66414 -121.76938 Woodland 34 []
697342 November 01, 2019 - 16:30:22 UTC 38.66414 -121.76938 Woodland 34 []
647675 October 09, 2019 - 00:37:15 UTC 38.68032 -121.76939 Woodland 34 []
686296 October 27, 2019 - 09:11:01 UTC 38.66987 -121.76949 Woodland 34 []
650871 October 09, 2019 - 17:50:26 UTC 38.66675 -121.76953 Woodland 34 []
652631 October 10, 2019 - 14:32:06 UTC 38.66675 -121.76953 Woodland 34 []
688266 October 27, 2019 - 18:56:02 UTC 38.67498 -121.76955 Woodland 34 []
689964 October 27, 2019 - 22:31:11 UTC 38.67498 -121.76955 Woodland 34 []
694553 October 30, 2019 - 02:12:32 UTC 38.67498 -121.76955 Woodland 34 []
695752 October 30, 2019 - 23:19:26 UTC 38.67498 -121.76955 Woodland 34 []
697362 November 01, 2019 - 16:49:50 UTC 38.67498 -121.76955 Woodland 34 []
651068 October 09, 2019 - 20:36:00 UTC 38.65711 -121.76989 Woodland 34 []
1072714 September 15, 2020 - 20:49:09 UTC 38.67202 -121.76989 Woodland 34 []
650854 October 09, 2019 - 17:32:01 UTC 38.67879 -121.77027 Woodland 34 []
686435 October 27, 2019 - 09:46:04 UTC 38.66048 -121.77027 Woodland 34 []
664693 October 17, 2019 - 17:33:57 UTC 38.67453 -121.77072 Woodland 34 []
686338 October 27, 2019 - 09:23:04 UTC 38.6578 -121.77075 Woodland 34 []
1065283 September 11, 2020 - 23:38:55 UTC 38.66447 -121.7711 Woodland 34 []
679605 October 24, 2019 - 18:08:53 UTC 38.68623 -121.77119 Woodland 34 []
693389 October 29, 2019 - 16:05:13 UTC 38.68623 -121.77119 Woodland 34 []
689355 October 27, 2019 - 21:17:06 UTC 38.67309 -121.77123 Woodland 34 []
1064090 September 11, 2020 - 14:57:59 UTC 38.66857 -121.77135 Woodland 34 []
789437 February 12, 2020 - 17:48:55 UTC 38.6654 -121.7718 Woodland 34 []
687627 October 27, 2019 - 17:09:07 UTC 38.67509 -121.77186 Woodland 34 []
655692 October 14, 2019 - 01:57:50 UTC 38.66639 -121.77195 Woodland 34 []
686191 October 27, 2019 - 08:38:27 UTC 38.7267 -121.77217 Woodland 34 []
697112 November 01, 2019 - 01:27:31 UTC 38.66495 -121.77224 Woodland 34 []
651077 October 09, 2019 - 20:41:00 UTC 38.65717 -121.77266 Woodland 34 []
688004 October 27, 2019 - 18:14:55 UTC 38.68749 -121.77292 Woodland 34 []
737055 December 12, 2019 - 08:48:46 UTC 38.69153 -121.77294 Woodland 34 []
686557 October 27, 2019 - 10:38:13 UTC 38.68396 -121.773 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 []
652677 October 10, 2019 - 15:38:00 UTC 38.67208 -121.77378 Woodland 34 [{"latitude": "38.66341", "longitude": "-121.77963"}, {"latitude": "38.66426", "longitude": "-121.77663"}, {"latitude": "38.67208", "longitude": "-121.77397"}, {"latitude": "38.67381", "longitude": "-121.77592"}, {"latitude": "38.67413", "longitude": "-121.77819"}, {"latitude": "38.6691", "longitude": "-121.79763"}, {"latitude": "38.66486", "longitude": "-121.79701"}, {"latitude": "38.66347", "longitude": "-121.79104"}, {"latitude": "38.66343", "longitude": "-121.78889"}]
717187 November 27, 2019 - 02:10:00 UTC 38.67208 -121.77378 Woodland 34 [{"latitude": "38.66341", "longitude": "-121.77963"}, {"latitude": "38.66426", "longitude": "-121.77663"}, {"latitude": "38.67208", "longitude": "-121.77397"}, {"latitude": "38.67381", "longitude": "-121.77592"}, {"latitude": "38.67413", "longitude": "-121.77819"}, {"latitude": "38.6691", "longitude": "-121.79763"}, {"latitude": "38.66486", "longitude": "-121.79701"}, {"latitude": "38.66347", "longitude": "-121.79104"}, {"latitude": "38.66343", "longitude": "-121.78889"}]
687217 October 27, 2019 - 15:22:06 UTC 38.68206 -121.77387 Woodland 34 []
1061379 September 08, 2020 - 23:20:36 UTC 38.68173 -121.77388 Woodland 34 []
688250 October 27, 2019 - 18:55:32 UTC 38.68644 -121.77391 Woodland 34 []
686189 October 27, 2019 - 08:38:27 UTC 38.78615 -121.77404 Woodland 34 []
706321 November 13, 2019 - 23:18:17 UTC 38.66797 -121.77426 Woodland 34 []
690788 October 28, 2019 - 02:42:37 UTC 38.66447 -121.7743 Woodland 34 []
686184 October 27, 2019 - 08:37:00 UTC 38.69166 -121.77444 Woodland 34 [{"latitude": "38.68904", "longitude": "-121.77447"}, {"latitude": "38.69062", "longitude": "-121.77296"}, {"latitude": "38.69112", "longitude": "-121.7732"}, {"latitude": "38.69134", "longitude": "-121.77444"}, {"latitude": "38.69073", "longitude": "-121.77598"}, {"latitude": "38.69052", "longitude": "-121.77599"}]
700084 November 05, 2019 - 19:45:32 UTC 38.68904 -121.77447 Woodland 34 []
686190 October 27, 2019 - 08:38:27 UTC 38.75314 -121.7745 Woodland 34 []
718300 November 27, 2019 - 04:07:00 UTC 38.75449 -121.77459 Woodland 34 []
652070 October 10, 2019 - 05:37:58 UTC 38.68429 -121.77468 Woodland 34 []
686393 October 27, 2019 - 09:32:00 UTC 38.68429 -121.77468 Woodland 34 []
688134 October 27, 2019 - 18:37:55 UTC 38.68429 -121.77468 Woodland 34 []
686735 October 27, 2019 - 12:27:06 UTC 38.68289 -121.77471 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"}]
688013 October 27, 2019 - 18:16:03 UTC 38.69011 -121.77557 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 []
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 []
651066 October 09, 2019 - 20:36:09 UTC 38.659 -121.77595 Woodland 34 []
691824 October 28, 2019 - 19:36:49 UTC 38.69073 -121.77598 Woodland 34 []
691293 October 28, 2019 - 13:54:26 UTC 38.67693 -121.77623 Woodland 34 []
693666 October 29, 2019 - 17:17:58 UTC 38.67693 -121.77623 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 []
664040 October 17, 2019 - 16:02:19 UTC 38.66426 -121.77663 Woodland 34 []
654107 October 11, 2019 - 14:39:13 UTC 38.67057 -121.77705 Woodland 34 []
687904 October 27, 2019 - 18:01:20 UTC 38.68748 -121.77782 Woodland 34 []
651443 October 09, 2019 - 22:51:54 UTC 38.67057 -121.77793 Woodland 34 []
692318 October 28, 2019 - 23:50:18 UTC 38.66816 -121.77796 Woodland 34 []
686172 October 27, 2019 - 08:35:00 UTC 38.69101 -121.77797 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 33.131ms · About: About this site