outages

248 rows where regionName = 42 sorted by longitude

View and edit SQL

Suggested facets: outageDevices

id outageStartTime latitude longitude ▼ regionName outageDevices
737531 December 12, 2019 - 19:08:45 UTC 37.96225 -121.74446 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 []
714749 November 25, 2019 - 23:38:04 UTC 37.96505 -121.75373 Antioch 42 []
708362 November 16, 2019 - 20:48:19 UTC 37.97088 -121.75388 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"}]
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"}]
721961 November 28, 2019 - 00:20:11 UTC 37.98884 -121.7551 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 []
655650 October 13, 2019 - 23:50:00 UTC 37.96772 -121.75645 Antioch 42 []
706770 November 14, 2019 - 18:03:22 UTC 37.95577 -121.75801 Antioch 42 []
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"}]
686508 October 27, 2019 - 10:11:34 UTC 38.01217 -121.75856 Antioch 42 []
735697 December 10, 2019 - 20:33:59 UTC 38.01217 -121.75856 Antioch 42 []
706765 November 14, 2019 - 18:01:00 UTC 37.96086 -121.75898 Antioch 42 []
688622 October 27, 2019 - 19:53:27 UTC 38.00363 -121.75936 Antioch 42 []
706766 November 14, 2019 - 18:02:05 UTC 37.95503 -121.76003 Antioch 42 []
658394 October 14, 2019 - 21:44:04 UTC 37.97298 -121.7636 Antioch 42 []
735614 December 10, 2019 - 19:07:14 UTC 37.98529 -121.7644 Antioch 42 []
661881 October 16, 2019 - 20:25:00 UTC 37.96688 -121.76465 Antioch 42 []
647777 October 09, 2019 - 04:44:10 UTC 37.98724 -121.76593 Antioch 42 []
687897 October 27, 2019 - 18:00:21 UTC 37.96578 -121.76629 Antioch 42 []
677433 October 23, 2019 - 16:01:00 UTC 38.00534 -121.76687 Antioch 42 [{"latitude": "38.00574", "longitude": "-121.76656"}, {"latitude": "38.00796", "longitude": "-121.76633"}, {"latitude": "38.00632", "longitude": "-121.76656"}]
690138 October 27, 2019 - 23:03:47 UTC 37.99888 -121.76689 Antioch 42 []
690849 October 28, 2019 - 03:24:49 UTC 37.98443 -121.77086 Antioch 42 []
785164 February 09, 2020 - 23:05:27 UTC 38.00065 -121.77123 Antioch 42 []
731355 December 06, 2019 - 17:37:19 UTC 38.00726 -121.77255 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 []
695143 October 30, 2019 - 18:17:05 UTC 37.94141 -121.77353 Antioch 42 []
687281 October 27, 2019 - 15:49:30 UTC 38.01197 -121.77502 Antioch 42 []
645847 October 07, 2019 - 15:32:58 UTC 37.984 -121.77956 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 []
689888 October 27, 2019 - 22:22:25 UTC 37.97521 -121.78079 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 []
780348 February 08, 2020 - 01:09:00 UTC 37.99854 -121.78306 Antioch 42 [{"latitude": "38.00583", "longitude": "-121.81247"}, {"latitude": "38.00596", "longitude": "-121.7521"}, {"latitude": "38.00649", "longitude": "-121.75096"}, {"latitude": "38.00939", "longitude": "-121.74934"}, {"latitude": "38.01644", "longitude": "-121.74685"}, {"latitude": "38.01858", "longitude": "-121.74881"}, {"latitude": "38.0194", "longitude": "-121.7503"}, {"latitude": "38.01962", "longitude": "-121.75361"}, {"latitude": "38.0198", "longitude": "-121.81996"}, {"latitude": "38.01774", "longitude": "-121.82712"}, {"latitude": "38.01357", "longitude": "-121.82804"}, {"latitude": "38.0061", "longitude": "-121.81515"}]
780360 February 08, 2020 - 01:08:00 UTC 37.99854 -121.78309 Antioch 42 [{"latitude": "37.9836", "longitude": "-121.83771"}, {"latitude": "37.98596", "longitude": "-121.82451"}, {"latitude": "37.98617", "longitude": "-121.82334"}, {"latitude": "37.99711", "longitude": "-121.78651"}, {"latitude": "37.99757", "longitude": "-121.78709"}, {"latitude": "38.00267", "longitude": "-121.80998"}, {"latitude": "38.00374", "longitude": "-121.81857"}, {"latitude": "38.00376", "longitude": "-121.81954"}, {"latitude": "38.00335", "longitude": "-121.82232"}, {"latitude": "37.9971", "longitude": "-121.83939"}, {"latitude": "37.99661", "longitude": "-121.84038"}, {"latitude": "37.99653", "longitude": "-121.84042"}, {"latitude": "37.99183", "longitude": "-121.84204"}, {"latitude": "37.99127", "longitude": "-121.84194"}, {"latitude": "37.98703", "longitude": "-121.84022"}, {"latitude": "37.98448", "longitude": "-121.83873"}]
780238 February 07, 2020 - 22:05:37 UTC 37.98163 -121.7832 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"}]
723518 November 29, 2019 - 18:44:09 UTC 37.9843 -121.78405 Antioch 42 []
713787 November 24, 2019 - 17:24:57 UTC 37.97251 -121.7847 Antioch 42 []
780384 February 08, 2020 - 01:14:12 UTC 37.9977 -121.78476 Antioch 42 []
744474 December 17, 2019 - 18:43:25 UTC 37.97525 -121.78486 Antioch 42 []
713786 November 24, 2019 - 17:24:45 UTC 37.97164 -121.7858 Antioch 42 []
724855 December 01, 2019 - 01:41:05 UTC 38.00767 -121.78619 Antioch 42 []
680024 October 25, 2019 - 01:25:37 UTC 37.99331 -121.78633 Antioch 42 []
737822 December 12, 2019 - 23:19:45 UTC 37.92349 -121.78639 Antioch 42 []
713890 November 24, 2019 - 20:41:04 UTC 37.95861 -121.78659 Antioch 42 []
701600 November 07, 2019 - 15:46:49 UTC 37.99757 -121.78709 Antioch 42 []
713784 November 24, 2019 - 17:24:41 UTC 37.97158 -121.78726 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"}]
713789 November 24, 2019 - 17:26:00 UTC 37.97342 -121.78806 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"}]
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"}]
742857 December 16, 2019 - 18:55:31 UTC 38.00529 -121.78885 Antioch 42 []
643884 October 05, 2019 - 05:44:45 UTC 38.00686 -121.78894 Antioch 42 []
723848 November 30, 2019 - 02:22:46 UTC 38.00828 -121.78917 Antioch 42 []
713788 November 24, 2019 - 17:24:57 UTC 37.97326 -121.7896 Antioch 42 []
787965 February 11, 2020 - 01:41:25 UTC 38.00858 -121.79009 Antioch 42 []
696858 October 31, 2019 - 20:47:03 UTC 38.00301 -121.7904 Antioch 42 []
650805 October 09, 2019 - 16:30:37 UTC 38.00964 -121.79079 Antioch 42 []
780385 February 08, 2020 - 01:14:12 UTC 37.99821 -121.79083 Antioch 42 []
699891 November 05, 2019 - 17:05:00 UTC 37.95439 -121.79115 Antioch 42 []
710010 November 19, 2019 - 17:43:20 UTC 37.95695 -121.79127 Antioch 42 []
779296 February 06, 2020 - 19:18:35 UTC 37.99167 -121.79164 Antioch 42 []
642385 October 04, 2019 - 15:31:03 UTC 38.00239 -121.79165 Antioch 42 []
658353 October 14, 2019 - 21:37:58 UTC 38.00184 -121.79165 Antioch 42 []
699902 November 05, 2019 - 17:08:00 UTC 37.95552 -121.79167 Antioch 42 []
687508 October 27, 2019 - 16:41:57 UTC 38.01155 -121.79176 Antioch 42 []
735096 December 10, 2019 - 11:37:00 UTC 37.9313 -121.79382 Antioch 42 []
782394 February 09, 2020 - 18:43:48 UTC 38.00036 -121.79384 Antioch 42 []
786194 February 10, 2020 - 03:35:14 UTC 38.00036 -121.79384 Antioch 42 []
668937 October 18, 2019 - 17:52:24 UTC 38.00383 -121.79437 Antioch 42 []
674936 October 21, 2019 - 00:51:04 UTC 38.00281 -121.79459 Antioch 42 []
790358 February 13, 2020 - 18:52:28 UTC 38.00072 -121.79475 Antioch 42 []
788067 February 11, 2020 - 02:42:35 UTC 38.00496 -121.79545 Antioch 42 []
726691 December 02, 2019 - 03:55:34 UTC 37.95448 -121.79589 Antioch 42 []
788351 February 11, 2020 - 16:14:38 UTC 37.99339 -121.79606 Antioch 42 []
787255 February 10, 2020 - 17:56:27 UTC 37.99428 -121.79652 Antioch 42 []
712955 November 22, 2019 - 19:33:59 UTC 38.00311 -121.7967 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"}]
692245 October 28, 2019 - 23:16:51 UTC 38.01 -121.79714 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"}]
687565 October 27, 2019 - 16:55:00 UTC 38.01034 -121.79939 Antioch 42 []
729768 December 04, 2019 - 19:47:55 UTC 38.01117 -121.79939 Antioch 42 []
660838 October 16, 2019 - 18:25:51 UTC 38.01054 -121.79996 Antioch 42 []
780413 February 08, 2020 - 02:05:00 UTC 38.01054 -121.79996 Antioch 42 []
780896 February 09, 2020 - 11:49:29 UTC 38.01054 -121.79996 Antioch 42 []
699887 November 05, 2019 - 17:03:00 UTC 37.95675 -121.80062 Antioch 42 []
699321 November 04, 2019 - 19:54:21 UTC 38.01169 -121.80064 Antioch 42 []
660818 October 16, 2019 - 18:13:11 UTC 38.00937 -121.80078 Antioch 42 []
687910 October 27, 2019 - 18:01:46 UTC 38.01016 -121.80179 Antioch 42 []
699205 November 04, 2019 - 18:26:49 UTC 38.00377 -121.80201 Antioch 42 []
699915 November 05, 2019 - 17:13:00 UTC 37.95713 -121.80264 Antioch 42 []
695244 October 30, 2019 - 19:14:52 UTC 38.00883 -121.80273 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 941.7ms · About: About this site