outages

276 rows where regionName = 42 sorted by outageDevices

View and edit SQL

id outageStartTime latitude longitude regionName outageDevices ▼
699902 November 05, 2019 - 17:08:00 UTC 37.95552 -121.79167 Antioch 42 []
699915 November 05, 2019 - 17:13:00 UTC 37.95713 -121.80264 Antioch 42 []
700075 November 05, 2019 - 19:31:58 UTC 38.00461 -121.84913 Antioch 42 []
700159 November 05, 2019 - 21:21:08 UTC 38.00265 -121.84876 Antioch 42 []
700380 November 06, 2019 - 01:59:13 UTC 37.98147 -121.84354 Antioch 42 []
700400 November 06, 2019 - 03:00:21 UTC 37.99593 -121.8233 Antioch 42 []
701196 November 07, 2019 - 00:12:22 UTC 38.01314 -121.81509 Antioch 42 []
701600 November 07, 2019 - 15:46:49 UTC 37.99757 -121.78709 Antioch 42 []
702279 November 08, 2019 - 07:18:42 UTC 38.00434 -121.8058 Antioch 42 []
702803 November 08, 2019 - 19:42:51 UTC 37.95964 -121.75371 Antioch 42 []
703152 November 09, 2019 - 10:58:54 UTC 38.00394 -121.80786 Antioch 42 []
703155 November 09, 2019 - 13:15:00 UTC 38.00394 -121.80786 Antioch 42 []
704163 November 11, 2019 - 06:20:22 UTC 38.00714 -121.8053 Antioch 42 []
704765 November 12, 2019 - 16:41:49 UTC 38.0018 -121.83471 Antioch 42 []
704833 November 12, 2019 - 17:18:11 UTC 37.98583 -121.80903 Antioch 42 []
704855 November 12, 2019 - 17:23:49 UTC 38.01542 -121.81084 Antioch 42 []
704981 November 12, 2019 - 18:25:17 UTC 38.01542 -121.81176 Antioch 42 []
705051 November 12, 2019 - 19:30:14 UTC 38.00174 -121.83505 Antioch 42 []
705804 November 13, 2019 - 16:17:17 UTC 38.00132 -121.83478 Antioch 42 []
705877 November 13, 2019 - 16:34:50 UTC 38.00112 -121.83525 Antioch 42 []
706758 November 14, 2019 - 17:58:00 UTC 37.95592 -121.75567 Antioch 42 []
706760 November 14, 2019 - 17:59:00 UTC 37.95409 -121.75639 Antioch 42 []
706765 November 14, 2019 - 18:01:00 UTC 37.96086 -121.75898 Antioch 42 []
706766 November 14, 2019 - 18:02:05 UTC 37.95503 -121.76003 Antioch 42 []
706770 November 14, 2019 - 18:03:22 UTC 37.95577 -121.75801 Antioch 42 []
706772 November 14, 2019 - 18:04:00 UTC 37.95885 -121.7514 Antioch 42 []
706857 November 14, 2019 - 19:10:52 UTC 37.99909 -121.82702 Antioch 42 []
707059 November 14, 2019 - 23:54:34 UTC 37.99909 -121.82702 Antioch 42 []
707948 November 16, 2019 - 00:52:16 UTC 37.99906 -121.82825 Antioch 42 []
707951 November 16, 2019 - 00:57:59 UTC 37.98475 -121.82638 Antioch 42 []
708018 November 16, 2019 - 04:52:33 UTC 37.9686 -121.78089 Antioch 42 []
708362 November 16, 2019 - 20:48:19 UTC 37.97088 -121.75388 Antioch 42 []
708416 November 16, 2019 - 22:53:00 UTC 37.9686 -121.78089 Antioch 42 []
708542 November 17, 2019 - 08:33:30 UTC 38.01192 -121.80595 Antioch 42 []
709649 November 19, 2019 - 02:06:19 UTC 38.01381 -121.81509 Antioch 42 []
710010 November 19, 2019 - 17:43:20 UTC 37.95695 -121.79127 Antioch 42 []
710122 November 19, 2019 - 19:11:57 UTC 38.00394 -121.80786 Antioch 42 []
711557 November 20, 2019 - 20:08:34 UTC 38.01337 -121.80959 Antioch 42 []
711778 November 20, 2019 - 23:37:51 UTC 38.01023 -121.82811 Antioch 42 []
712397 November 21, 2019 - 21:52:05 UTC 38.00494 -121.81393 Antioch 42 []
712455 November 21, 2019 - 23:02:04 UTC 38.00499 -121.82478 Antioch 42 []
712955 November 22, 2019 - 19:33:59 UTC 38.00311 -121.7967 Antioch 42 []
713145 November 23, 2019 - 00:07:19 UTC 38.01481 -121.82016 Antioch 42 []
713784 November 24, 2019 - 17:24:41 UTC 37.97158 -121.78726 Antioch 42 []
713786 November 24, 2019 - 17:24:45 UTC 37.97164 -121.7858 Antioch 42 []
713787 November 24, 2019 - 17:24:57 UTC 37.97251 -121.7847 Antioch 42 []
713788 November 24, 2019 - 17:24:57 UTC 37.97326 -121.7896 Antioch 42 []
713789 November 24, 2019 - 17:26:00 UTC 37.97342 -121.78806 Antioch 42 []
713811 November 24, 2019 - 18:30:52 UTC 38.00633 -121.80474 Antioch 42 []
713890 November 24, 2019 - 20:41:04 UTC 37.95861 -121.78659 Antioch 42 []
714749 November 25, 2019 - 23:38:04 UTC 37.96505 -121.75373 Antioch 42 []
720760 November 27, 2019 - 17:03:06 UTC 38.00449 -121.85362 Antioch 42 []
721961 November 28, 2019 - 00:20:11 UTC 37.98884 -121.7551 Antioch 42 []
723518 November 29, 2019 - 18:44:09 UTC 37.9843 -121.78405 Antioch 42 []
723848 November 30, 2019 - 02:22:46 UTC 38.00828 -121.78917 Antioch 42 []
723916 November 30, 2019 - 05:37:12 UTC 38.00216 -121.80356 Antioch 42 []
724855 December 01, 2019 - 01:41:05 UTC 38.00767 -121.78619 Antioch 42 []
726074 December 01, 2019 - 20:31:23 UTC 37.99874 -121.81423 Antioch 42 []
726324 December 02, 2019 - 00:09:02 UTC 38.0034 -121.85331 Antioch 42 []
726691 December 02, 2019 - 03:55:34 UTC 37.95448 -121.79589 Antioch 42 []
727614 December 02, 2019 - 20:35:13 UTC 37.99965 -121.85041 Antioch 42 []
727812 December 02, 2019 - 23:12:53 UTC 37.99718 -121.84059 Antioch 42 []
727909 December 03, 2019 - 00:44:00 UTC 37.99965 -121.85041 Antioch 42 []
728771 December 03, 2019 - 19:55:50 UTC 38.00164 -121.80891 Antioch 42 []
729033 December 04, 2019 - 00:00:16 UTC 38.01481 -121.82016 Antioch 42 []
729045 December 04, 2019 - 00:19:46 UTC 37.98583 -121.80903 Antioch 42 []
729768 December 04, 2019 - 19:47:55 UTC 38.01117 -121.79939 Antioch 42 []
729825 December 04, 2019 - 21:15:42 UTC 38.00071 -121.8046 Antioch 42 []
730218 December 05, 2019 - 13:30:24 UTC 37.99449 -121.80532 Antioch 42 []
730442 December 05, 2019 - 17:48:55 UTC 37.99553 -121.80533 Antioch 42 []
730478 December 05, 2019 - 18:10:04 UTC 37.99553 -121.80533 Antioch 42 []
730633 December 05, 2019 - 20:28:40 UTC 38.01267 -121.80586 Antioch 42 []
731355 December 06, 2019 - 17:37:19 UTC 38.00726 -121.77255 Antioch 42 []
731761 December 06, 2019 - 23:29:10 UTC 37.98886 -121.83764 Antioch 42 []
732115 December 07, 2019 - 10:03:07 UTC 37.99432 -121.83084 Antioch 42 []
733497 December 08, 2019 - 07:39:04 UTC 38.00676 -121.81408 Antioch 42 []
733843 December 08, 2019 - 21:26:04 UTC 37.99032 -121.81965 Antioch 42 []
735096 December 10, 2019 - 11:37:00 UTC 37.9313 -121.79382 Antioch 42 []
735614 December 10, 2019 - 19:07:14 UTC 37.98529 -121.7644 Antioch 42 []
735697 December 10, 2019 - 20:33:59 UTC 38.01217 -121.75856 Antioch 42 []
735918 December 11, 2019 - 01:12:44 UTC 38.01195 -121.81671 Antioch 42 []
737531 December 12, 2019 - 19:08:45 UTC 37.96225 -121.74446 Antioch 42 []
737555 December 12, 2019 - 19:41:25 UTC 37.97191 -121.83058 Antioch 42 []
737822 December 12, 2019 - 23:19:45 UTC 37.92349 -121.78639 Antioch 42 []
738061 December 13, 2019 - 13:08:32 UTC 37.95994 -121.81093 Antioch 42 []
738245 December 13, 2019 - 15:56:07 UTC 37.95994 -121.81093 Antioch 42 []
738868 December 14, 2019 - 09:48:05 UTC 38.01124 -121.80713 Antioch 42 []
739941 December 15, 2019 - 07:43:04 UTC 37.99523 -121.84504 Antioch 42 []
739982 December 15, 2019 - 13:16:29 UTC 37.99523 -121.84504 Antioch 42 []
740146 December 15, 2019 - 17:59:41 UTC 37.99451 -121.84075 Antioch 42 []
740264 December 15, 2019 - 20:50:52 UTC 37.99451 -121.84075 Antioch 42 []
740495 December 16, 2019 - 12:46:43 UTC 37.98242 -121.80823 Antioch 42 []
740875 December 16, 2019 - 15:46:54 UTC 37.98276 -121.80353 Antioch 42 []
740913 December 16, 2019 - 15:50:16 UTC 37.98206 -121.80342 Antioch 42 []
741015 December 16, 2019 - 16:09:21 UTC 37.982 -121.80273 Antioch 42 []
742857 December 16, 2019 - 18:55:31 UTC 38.00529 -121.78885 Antioch 42 []
743744 December 16, 2019 - 23:19:53 UTC 37.98256 -121.82153 Antioch 42 []
744347 December 17, 2019 - 17:36:43 UTC 37.99145 -121.80325 Antioch 42 []
744380 December 17, 2019 - 18:01:05 UTC 37.99677 -121.80368 Antioch 42 []
744458 December 17, 2019 - 18:33:04 UTC 38.00077 -121.81302 Antioch 42 []

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