outages

276 rows where regionName = 42 sorted by regionName

View and edit SQL

id outageStartTime latitude longitude regionName ▼ outageDevices
699361 November 04, 2019 - 20:34:58 UTC 38.00554 -121.85062 Antioch 42 []
699554 November 05, 2019 - 00:29:45 UTC 37.99873 -121.81262 Antioch 42 []
699885 November 05, 2019 - 17:02:00 UTC 37.95662 -121.79695 Antioch 42 [{"latitude": "37.95436", "longitude": "-121.80095"}, {"latitude": "37.95452", "longitude": "-121.79766"}, {"latitude": "37.95502", "longitude": "-121.79923"}, {"latitude": "37.9551", "longitude": "-121.80035"}, {"latitude": "37.95499", "longitude": "-121.80169"}, {"latitude": "37.95438", "longitude": "-121.80179"}]
699887 November 05, 2019 - 17:03:00 UTC 37.95675 -121.80062 Antioch 42 []
699891 November 05, 2019 - 17:05:00 UTC 37.95439 -121.79115 Antioch 42 []
699895 November 05, 2019 - 17:07:00 UTC 37.95451 -121.78822 Antioch 42 [{"latitude": "37.95444", "longitude": "-121.78994"}, {"latitude": "37.95782", "longitude": "-121.79136"}, {"latitude": "37.9576", "longitude": "-121.79514"}, {"latitude": "37.95703", "longitude": "-121.79558"}]
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 []
699918 November 05, 2019 - 17:13:00 UTC 37.95983 -121.79724 Antioch 42 [{"latitude": "37.95823", "longitude": "-121.79959"}, {"latitude": "37.96048", "longitude": "-121.79754"}, {"latitude": "37.96087", "longitude": "-121.7995"}, {"latitude": "37.95922", "longitude": "-121.79979"}]
699926 November 05, 2019 - 17:11:00 UTC 37.96279 -121.79758 Antioch 42 [{"latitude": "37.95608", "longitude": "-121.80478"}, {"latitude": "37.9581", "longitude": "-121.79806"}, {"latitude": "37.95923", "longitude": "-121.79771"}, {"latitude": "37.96048", "longitude": "-121.79754"}, {"latitude": "37.96374", "longitude": "-121.79804"}, {"latitude": "37.96431", "longitude": "-121.79916"}, {"latitude": "37.96381", "longitude": "-121.80061"}, {"latitude": "37.95769", "longitude": "-121.80645"}, {"latitude": "37.95685", "longitude": "-121.80573"}]
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 []
703153 November 09, 2019 - 11:45:56 UTC 37.99242 -121.84017 Antioch 42 [{"latitude": "37.99177", "longitude": "-121.83939"}, {"latitude": "37.99178", "longitude": "-121.83806"}, {"latitude": "37.9922", "longitude": "-121.83736"}, {"latitude": "37.9932", "longitude": "-121.83816"}, {"latitude": "37.99225", "longitude": "-121.83935"}]
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 []
706614 November 14, 2019 - 16:32:00 UTC 37.9847 -121.78799 Antioch 42 [{"latitude": "37.98515", "longitude": "-121.78791"}, {"latitude": "37.98782", "longitude": "-121.78794"}, {"latitude": "37.98964", "longitude": "-121.78882"}, {"latitude": "37.98904", "longitude": "-121.7887"}]
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 []
706762 November 14, 2019 - 18:00:00 UTC 37.96009 -121.75487 Antioch 42 [{"latitude": "37.95709", "longitude": "-121.75902"}, {"latitude": "37.95754", "longitude": "-121.75768"}, {"latitude": "37.95826", "longitude": "-121.75623"}, {"latitude": "37.95912", "longitude": "-121.75744"}, {"latitude": "37.95985", "longitude": "-121.75891"}]
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 []
709135 November 18, 2019 - 17:14:00 UTC 37.97344 -121.78399 Antioch 42 [{"latitude": "37.97241", "longitude": "-121.78139"}, {"latitude": "37.97381", "longitude": "-121.78106"}, {"latitude": "37.97421", "longitude": "-121.78111"}, {"latitude": "37.97554", "longitude": "-121.78244"}, {"latitude": "37.97558", "longitude": "-121.78368"}, {"latitude": "37.97525", "longitude": "-121.78486"}, {"latitude": "37.97394", "longitude": "-121.78651"}, {"latitude": "37.97354", "longitude": "-121.78663"}]
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 []
734396 December 09, 2019 - 17:57:00 UTC 37.99014 -121.78882 Antioch 42 [{"latitude": "37.98515", "longitude": "-121.78791"}, {"latitude": "37.98782", "longitude": "-121.78794"}, {"latitude": "37.98964", "longitude": "-121.78882"}, {"latitude": "37.98904", "longitude": "-121.7887"}]
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 []
737952 December 13, 2019 - 04:21:13 UTC 37.9848 -121.75401 Antioch 42 [{"latitude": "37.98416", "longitude": "-121.75569"}, {"latitude": "37.98437", "longitude": "-121.75478"}, {"latitude": "37.987", "longitude": "-121.75791"}, {"latitude": "37.9857", "longitude": "-121.758"}, {"latitude": "37.98442", "longitude": "-121.75744"}]
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 []

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