outages

248 rows where regionName = 42 sorted by latitude

View and edit SQL

Suggested facets: outageDevices

id outageStartTime latitude ▼ longitude regionName outageDevices
737822 December 12, 2019 - 23:19:45 UTC 37.92349 -121.78639 Antioch 42 []
735096 December 10, 2019 - 11:37:00 UTC 37.9313 -121.79382 Antioch 42 []
695143 October 30, 2019 - 18:17:05 UTC 37.94141 -121.77353 Antioch 42 []
706760 November 14, 2019 - 17:59:00 UTC 37.95409 -121.75639 Antioch 42 []
699891 November 05, 2019 - 17:05:00 UTC 37.95439 -121.79115 Antioch 42 []
726691 December 02, 2019 - 03:55:34 UTC 37.95448 -121.79589 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"}]
706766 November 14, 2019 - 18:02:05 UTC 37.95503 -121.76003 Antioch 42 []
699902 November 05, 2019 - 17:08:00 UTC 37.95552 -121.79167 Antioch 42 []
677217 October 23, 2019 - 02:25:56 UTC 37.95557 -121.78009 Antioch 42 []
697610 November 01, 2019 - 20:01:00 UTC 37.95557 -121.78009 Antioch 42 []
706770 November 14, 2019 - 18:03:22 UTC 37.95577 -121.75801 Antioch 42 []
706758 November 14, 2019 - 17:58:00 UTC 37.95592 -121.75567 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 []
710010 November 19, 2019 - 17:43:20 UTC 37.95695 -121.79127 Antioch 42 []
699915 November 05, 2019 - 17:13:00 UTC 37.95713 -121.80264 Antioch 42 []
713890 November 24, 2019 - 20:41:04 UTC 37.95861 -121.78659 Antioch 42 []
706772 November 14, 2019 - 18:04:00 UTC 37.95885 -121.7514 Antioch 42 []
702803 November 08, 2019 - 19:42:51 UTC 37.95964 -121.75371 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"}]
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 []
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 []
738370 December 13, 2019 - 17:24:02 UTC 37.96092 -121.8086 Antioch 42 [{"latitude": "37.95863", "longitude": "-121.81759"}, {"latitude": "37.95905", "longitude": "-121.81052"}, {"latitude": "37.96059", "longitude": "-121.80931"}, {"latitude": "37.95948", "longitude": "-121.81866"}]
737531 December 12, 2019 - 19:08:45 UTC 37.96225 -121.74446 Antioch 42 []
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"}]
679572 October 24, 2019 - 17:23:51 UTC 37.96419 -121.8149 Antioch 42 []
714749 November 25, 2019 - 23:38:04 UTC 37.96505 -121.75373 Antioch 42 []
687897 October 27, 2019 - 18:00:21 UTC 37.96578 -121.76629 Antioch 42 []
661881 October 16, 2019 - 20:25:00 UTC 37.96688 -121.76465 Antioch 42 []
655650 October 13, 2019 - 23:50:00 UTC 37.96772 -121.75645 Antioch 42 []
708018 November 16, 2019 - 04:52:33 UTC 37.9686 -121.78089 Antioch 42 []
708416 November 16, 2019 - 22:53:00 UTC 37.9686 -121.78089 Antioch 42 []
708362 November 16, 2019 - 20:48:19 UTC 37.97088 -121.75388 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 []
737555 December 12, 2019 - 19:41:25 UTC 37.97191 -121.83058 Antioch 42 []
713787 November 24, 2019 - 17:24:57 UTC 37.97251 -121.7847 Antioch 42 []
658394 October 14, 2019 - 21:44:04 UTC 37.97298 -121.7636 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 []
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"}]
634830 October 01, 2019 - 20:49:39 UTC 37.97436 -121.75807 Antioch 42 [{"latitude": "37.97389", "longitude": "-121.75999"}, {"latitude": "37.97395", "longitude": "-121.75907"}, {"latitude": "37.97449", "longitude": "-121.75783"}, {"latitude": "37.97547", "longitude": "-121.75771"}, {"latitude": "37.97567", "longitude": "-121.75947"}, {"latitude": "37.97499", "longitude": "-121.76123"}]
689888 October 27, 2019 - 22:22:25 UTC 37.97521 -121.78079 Antioch 42 []
744474 December 17, 2019 - 18:43:25 UTC 37.97525 -121.78486 Antioch 42 []
670313 October 18, 2019 - 21:27:38 UTC 37.9792 -121.82907 Antioch 42 []
670593 October 18, 2019 - 22:13:30 UTC 37.98036 -121.77345 Antioch 42 []
676305 October 21, 2019 - 20:45:29 UTC 37.98036 -121.77345 Antioch 42 []
676400 October 21, 2019 - 22:17:46 UTC 37.98036 -121.77345 Antioch 42 []
744947 December 18, 2019 - 01:25:16 UTC 37.98091 -121.82784 Antioch 42 []
700380 November 06, 2019 - 01:59:13 UTC 37.98147 -121.84354 Antioch 42 []
780238 February 07, 2020 - 22:05:37 UTC 37.98163 -121.7832 Antioch 42 []
638842 October 03, 2019 - 01:19:32 UTC 37.98186 -121.82152 Antioch 42 []
741015 December 16, 2019 - 16:09:21 UTC 37.982 -121.80273 Antioch 42 []
740913 December 16, 2019 - 15:50:16 UTC 37.98206 -121.80342 Antioch 42 []
740495 December 16, 2019 - 12:46:43 UTC 37.98242 -121.80823 Antioch 42 []
743744 December 16, 2019 - 23:19:53 UTC 37.98256 -121.82153 Antioch 42 []
740875 December 16, 2019 - 15:46:54 UTC 37.98276 -121.80353 Antioch 42 []
691558 October 28, 2019 - 16:49:19 UTC 37.98365 -121.80693 Antioch 42 []
645847 October 07, 2019 - 15:32:58 UTC 37.984 -121.77956 Antioch 42 []
723518 November 29, 2019 - 18:44:09 UTC 37.9843 -121.78405 Antioch 42 []
690849 October 28, 2019 - 03:24:49 UTC 37.98443 -121.77086 Antioch 42 []
694033 October 29, 2019 - 19:54:23 UTC 37.98451 -121.83082 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"}]
707951 November 16, 2019 - 00:57:59 UTC 37.98475 -121.82638 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"}]
735614 December 10, 2019 - 19:07:14 UTC 37.98529 -121.7644 Antioch 42 []
780447 February 08, 2020 - 03:34:51 UTC 37.98562 -121.83511 Antioch 42 []
704833 November 12, 2019 - 17:18:11 UTC 37.98583 -121.80903 Antioch 42 []
729045 December 04, 2019 - 00:19:46 UTC 37.98583 -121.80903 Antioch 42 []
696505 October 31, 2019 - 16:20:33 UTC 37.98657 -121.85101 Antioch 42 []
647777 October 09, 2019 - 04:44:10 UTC 37.98724 -121.76593 Antioch 42 []
780409 February 08, 2020 - 01:58:50 UTC 37.98827 -121.83849 Antioch 42 []
721961 November 28, 2019 - 00:20:11 UTC 37.98884 -121.7551 Antioch 42 []
731761 December 06, 2019 - 23:29:10 UTC 37.98886 -121.83764 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"}]
733843 December 08, 2019 - 21:26:04 UTC 37.99032 -121.81965 Antioch 42 []
661573 October 16, 2019 - 19:29:57 UTC 37.99044 -121.80794 Antioch 42 []
780389 February 08, 2020 - 01:14:46 UTC 37.99068 -121.84234 Antioch 42 []
679431 October 24, 2019 - 15:47:15 UTC 37.9912 -121.81611 Antioch 42 []
744347 December 17, 2019 - 17:36:43 UTC 37.99145 -121.80325 Antioch 42 []
779296 February 06, 2020 - 19:18:35 UTC 37.99167 -121.79164 Antioch 42 []
645570 October 06, 2019 - 16:21:38 UTC 37.99225 -121.83935 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"}]
680024 October 25, 2019 - 01:25:37 UTC 37.99331 -121.78633 Antioch 42 []
788351 February 11, 2020 - 16:14:38 UTC 37.99339 -121.79606 Antioch 42 []
655922 October 14, 2019 - 16:00:23 UTC 37.99354 -121.8133 Antioch 42 []
633519 October 01, 2019 - 11:16:20 UTC 37.99355 -121.84289 Antioch 42 []
787255 February 10, 2020 - 17:56:27 UTC 37.99428 -121.79652 Antioch 42 []
732115 December 07, 2019 - 10:03:07 UTC 37.99432 -121.83084 Antioch 42 []
690760 October 28, 2019 - 02:29:13 UTC 37.9944 -121.81462 Antioch 42 []
686791 October 27, 2019 - 13:10:15 UTC 37.99449 -121.80532 Antioch 42 []
688802 October 27, 2019 - 20:17:48 UTC 37.99449 -121.80532 Antioch 42 []
730218 December 05, 2019 - 13:30:24 UTC 37.99449 -121.80532 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 []
788522 February 11, 2020 - 17:44:54 UTC 37.9946 -121.84243 Antioch 42 []
788854 February 11, 2020 - 21:34:03 UTC 37.9946 -121.84243 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 509.119ms · About: About this site