outages

280 rows where regionName = 42 sorted by outageStartTime descending

View and edit SQL

Suggested facets: outageDevices

id outageStartTime ▲ latitude longitude regionName outageDevices
1087815 September 22, 2020 - 19:15:06 UTC 37.97842 -121.79148 Antioch 42 []
1086201 September 22, 2020 - 03:50:39 UTC 37.97984 -121.80252 Antioch 42 []
1086185 September 22, 2020 - 02:42:14 UTC 37.98677 -121.79423 Antioch 42 []
1084124 September 21, 2020 - 16:32:37 UTC 37.98352 -121.8312 Antioch 42 []
1083059 September 19, 2020 - 23:23:44 UTC 37.99067 -121.84143 Antioch 42 []
1081555 September 18, 2020 - 22:00:01 UTC 38.00751 -121.76969 Antioch 42 []
1081233 September 18, 2020 - 20:51:05 UTC 37.96341 -121.80222 Antioch 42 []
1080954 September 18, 2020 - 19:10:10 UTC 37.96395 -121.80523 Antioch 42 [{"latitude": "37.96325", "longitude": "-121.80405"}, {"latitude": "37.96391", "longitude": "-121.80322"}, {"latitude": "37.96369", "longitude": "-121.80499"}]
1079716 September 18, 2020 - 14:34:00 UTC 37.96395 -121.80523 Antioch 42 [{"latitude": "37.96202", "longitude": "-121.8015"}, {"latitude": "37.96302", "longitude": "-121.80135"}, {"latitude": "37.9642", "longitude": "-121.80219"}, {"latitude": "37.96369", "longitude": "-121.80499"}]
1078133 September 17, 2020 - 17:28:48 UTC 38.01587 -121.81239 Antioch 42 []
1077978 September 17, 2020 - 17:06:17 UTC 38.00954 -121.84122 Antioch 42 []
1077435 September 17, 2020 - 15:30:45 UTC 37.98274 -121.81783 Antioch 42 []
1074075 September 16, 2020 - 14:57:00 UTC 37.99704 -121.79348 Antioch 42 [{"latitude": "37.99571", "longitude": "-121.79417"}, {"latitude": "37.99661", "longitude": "-121.79349"}, {"latitude": "37.99682", "longitude": "-121.79349"}]
1071456 September 15, 2020 - 16:29:57 UTC 38.01283 -121.81404 Antioch 42 []
1070686 September 15, 2020 - 12:24:35 UTC 38.01283 -121.81404 Antioch 42 []
1070543 September 15, 2020 - 01:39:48 UTC 38.01283 -121.81404 Antioch 42 []
1070413 September 14, 2020 - 23:18:54 UTC 38.01283 -121.81404 Antioch 42 []
1070364 September 14, 2020 - 23:03:46 UTC 37.98095 -121.83581 Antioch 42 []
1069413 September 14, 2020 - 19:05:00 UTC 38.01283 -121.81404 Antioch 42 []
1067404 September 14, 2020 - 01:44:00 UTC 38.01338 -121.81282 Antioch 42 []
1067389 September 14, 2020 - 00:38:00 UTC 38.0121 -121.81247 Antioch 42 []
1067366 September 13, 2020 - 23:09:00 UTC 38.01283 -121.81404 Antioch 42 []
1067365 September 13, 2020 - 23:03:00 UTC 38.01659 -121.81392 Antioch 42 []
1067364 September 13, 2020 - 22:57:01 UTC 38.01266 -121.81437 Antioch 42 []
1067363 September 13, 2020 - 22:56:54 UTC 38.01266 -121.81334 Antioch 42 []
1067330 September 13, 2020 - 20:51:46 UTC 38.01337 -121.8049 Antioch 42 []
1067244 September 13, 2020 - 15:50:43 UTC 37.96208 -121.77127 Antioch 42 []
1067128 September 13, 2020 - 01:11:00 UTC 37.98213 -121.82616 Antioch 42 []
1065862 September 12, 2020 - 15:55:00 UTC 37.98452 -121.80374 Antioch 42 []
1065325 September 12, 2020 - 01:34:23 UTC 37.99301 -121.80961 Antioch 42 []
1064514 September 11, 2020 - 17:30:04 UTC 37.99296 -121.78788 Antioch 42 []
1063499 September 10, 2020 - 20:19:26 UTC 37.99134 -121.8096 Antioch 42 []
790358 February 13, 2020 - 18:52:28 UTC 38.00072 -121.79475 Antioch 42 []
788854 February 11, 2020 - 21:34:03 UTC 37.9946 -121.84243 Antioch 42 []
788522 February 11, 2020 - 17:44:54 UTC 37.9946 -121.84243 Antioch 42 []
788394 February 11, 2020 - 16:45:22 UTC 38.01495 -121.81122 Antioch 42 []
788351 February 11, 2020 - 16:14:38 UTC 37.99339 -121.79606 Antioch 42 []
788191 February 11, 2020 - 05:13:30 UTC 38.01192 -121.80595 Antioch 42 []
788171 February 11, 2020 - 04:53:19 UTC 38.0042 -121.83161 Antioch 42 []
788067 February 11, 2020 - 02:42:35 UTC 38.00496 -121.79545 Antioch 42 []
787965 February 11, 2020 - 01:41:25 UTC 38.00858 -121.79009 Antioch 42 []
787255 February 10, 2020 - 17:56:27 UTC 37.99428 -121.79652 Antioch 42 []
787135 February 10, 2020 - 17:07:07 UTC 38.00279 -121.81743 Antioch 42 []
786194 February 10, 2020 - 03:35:14 UTC 38.00036 -121.79384 Antioch 42 []
785164 February 09, 2020 - 23:05:27 UTC 38.00065 -121.77123 Antioch 42 []
782394 February 09, 2020 - 18:43:48 UTC 38.00036 -121.79384 Antioch 42 []
780896 February 09, 2020 - 11:49:29 UTC 38.01054 -121.79996 Antioch 42 []
780466 February 08, 2020 - 05:41:48 UTC 37.99606 -121.81979 Antioch 42 []
780447 February 08, 2020 - 03:34:51 UTC 37.98562 -121.83511 Antioch 42 []
780417 February 08, 2020 - 02:09:18 UTC 37.99606 -121.81979 Antioch 42 []
780416 February 08, 2020 - 02:08:00 UTC 38.0157 -121.82422 Antioch 42 []
780413 February 08, 2020 - 02:05:00 UTC 38.01054 -121.79996 Antioch 42 []
780409 February 08, 2020 - 01:58:50 UTC 37.98827 -121.83849 Antioch 42 []
780406 February 08, 2020 - 01:55:00 UTC 37.99485 -121.81747 Antioch 42 []
780389 February 08, 2020 - 01:14:46 UTC 37.99068 -121.84234 Antioch 42 []
780384 February 08, 2020 - 01:14:12 UTC 37.9977 -121.78476 Antioch 42 []
780385 February 08, 2020 - 01:14:12 UTC 37.99821 -121.79083 Antioch 42 []
780386 February 08, 2020 - 01:14:12 UTC 38.01302 -121.82348 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 []
779728 February 07, 2020 - 05:07:05 UTC 38.0103 -121.83262 Antioch 42 [{"latitude": "38.01014", "longitude": "-121.83296"}, {"latitude": "38.01014", "longitude": "-121.83134"}, {"latitude": "38.01083", "longitude": "-121.83159"}]
779296 February 06, 2020 - 19:18:35 UTC 37.99167 -121.79164 Antioch 42 []
744947 December 18, 2019 - 01:25:16 UTC 37.98091 -121.82784 Antioch 42 []
744474 December 17, 2019 - 18:43:25 UTC 37.97525 -121.78486 Antioch 42 []
744458 December 17, 2019 - 18:33:04 UTC 38.00077 -121.81302 Antioch 42 []
744380 December 17, 2019 - 18:01:05 UTC 37.99677 -121.80368 Antioch 42 []
744347 December 17, 2019 - 17:36:43 UTC 37.99145 -121.80325 Antioch 42 []
743744 December 16, 2019 - 23:19:53 UTC 37.98256 -121.82153 Antioch 42 []
742857 December 16, 2019 - 18:55:31 UTC 38.00529 -121.78885 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 []
740875 December 16, 2019 - 15:46:54 UTC 37.98276 -121.80353 Antioch 42 []
740495 December 16, 2019 - 12:46:43 UTC 37.98242 -121.80823 Antioch 42 []
740264 December 15, 2019 - 20:50:52 UTC 37.99451 -121.84075 Antioch 42 []
740146 December 15, 2019 - 17:59:41 UTC 37.99451 -121.84075 Antioch 42 []
739982 December 15, 2019 - 13:16:29 UTC 37.99523 -121.84504 Antioch 42 []
739941 December 15, 2019 - 07:43:04 UTC 37.99523 -121.84504 Antioch 42 []
738868 December 14, 2019 - 09:48:05 UTC 38.01124 -121.80713 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"}]
738245 December 13, 2019 - 15:56:07 UTC 37.95994 -121.81093 Antioch 42 []
738061 December 13, 2019 - 13:08:32 UTC 37.95994 -121.81093 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"}]
737822 December 12, 2019 - 23:19:45 UTC 37.92349 -121.78639 Antioch 42 []
737555 December 12, 2019 - 19:41:25 UTC 37.97191 -121.83058 Antioch 42 []
737531 December 12, 2019 - 19:08:45 UTC 37.96225 -121.74446 Antioch 42 []
735918 December 11, 2019 - 01:12:44 UTC 38.01195 -121.81671 Antioch 42 []
735697 December 10, 2019 - 20:33:59 UTC 38.01217 -121.75856 Antioch 42 []
735614 December 10, 2019 - 19:07:14 UTC 37.98529 -121.7644 Antioch 42 []
735096 December 10, 2019 - 11:37:00 UTC 37.9313 -121.79382 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 []
733497 December 08, 2019 - 07:39:04 UTC 38.00676 -121.81408 Antioch 42 []
732115 December 07, 2019 - 10:03:07 UTC 37.99432 -121.83084 Antioch 42 []
731761 December 06, 2019 - 23:29:10 UTC 37.98886 -121.83764 Antioch 42 []
731355 December 06, 2019 - 17:37:19 UTC 38.00726 -121.77255 Antioch 42 []
730633 December 05, 2019 - 20:28:40 UTC 38.01267 -121.80586 Antioch 42 []
730478 December 05, 2019 - 18:10:04 UTC 37.99553 -121.80533 Antioch 42 []
730442 December 05, 2019 - 17:48:55 UTC 37.99553 -121.80533 Antioch 42 []
730218 December 05, 2019 - 13:30:24 UTC 37.99449 -121.80532 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 316.867ms · About: About this site