489 rows where regionName = 42 sorted by latitude

View and edit SQL

id outageStartTime latitude ▼ longitude regionName outageDevices
737822 December 12, 2019 - 23:19:45 UTC 37.92349 -121.78639 Antioch 42 []
1090622 September 23, 2020 - 22:19:09 UTC 37.92349 -121.78639 Antioch 42 []
1096879 September 28, 2020 - 21:46:47 UTC 37.92349 -121.78639 Antioch 42 []
1101249 September 30, 2020 - 15:56:34 UTC 37.92349 -121.78639 Antioch 42 []
1108181 October 02, 2020 - 23:50:22 UTC 37.92349 -121.78639 Antioch 42 []
735096 December 10, 2019 - 11:37:00 UTC 37.9313 -121.79382 Antioch 42 []
1127536 October 26, 2020 - 04:00:00 UTC 37.93337 -121.79355 Antioch 42 []
1146871 November 17, 2020 - 16:31:00 UTC 37.93339 -121.79322 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"}]
1140730 November 10, 2020 - 05:22:19 UTC 37.95461 -121.77534 Antioch 42 []
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 []
1133327 November 01, 2020 - 15:09:23 UTC 37.95583 -121.76286 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 []
1120002 October 17, 2020 - 23:03:16 UTC 37.95713 -121.7833 Antioch 42 []
1155026 November 27, 2020 - 03:02:29 UTC 37.95836 -121.76276 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 []
1140723 November 10, 2020 - 05:00:31 UTC 37.95887 -121.79858 Antioch 42 []
1129576 October 27, 2020 - 03:26:15 UTC 37.95922 -121.79979 Antioch 42 []
702803 November 08, 2019 - 19:42:51 UTC 37.95964 -121.75371 Antioch 42 []
1200867 December 29, 2020 - 21:37:44 UTC 37.95979 -121.80204 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"}]
1197725 December 23, 2020 - 18:23:48 UTC 37.96066 -121.81111 Antioch 42 []
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"}]
1067244 September 13, 2020 - 15:50:43 UTC 37.96208 -121.77127 Antioch 42 []
1195613 December 19, 2020 - 22:44:03 UTC 37.96209 -121.79262 Antioch 42 []
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"}]
1116697 October 13, 2020 - 20:41:43 UTC 37.9632 -121.79152 Antioch 42 []
1081233 September 18, 2020 - 20:51:05 UTC 37.96341 -121.80222 Antioch 42 []
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"}]
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"}]
1131194 October 29, 2020 - 10:21:00 UTC 37.96395 -121.76602 Antioch 42 []
679572 October 24, 2019 - 17:23:51 UTC 37.96419 -121.8149 Antioch 42 []
1093735 September 26, 2020 - 15:03:51 UTC 37.96477 -121.81282 Antioch 42 [{"latitude": "37.96419", "longitude": "-121.8149"}, {"latitude": "37.96508", "longitude": "-121.81239"}, {"latitude": "37.96425", "longitude": "-121.81718"}]
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 []
1112408 October 07, 2020 - 01:50:38 UTC 37.96656 -121.75757 Antioch 42 []
661881 October 16, 2019 - 20:25:00 UTC 37.96688 -121.76465 Antioch 42 []
1146030 November 16, 2020 - 17:10:44 UTC 37.96738 -121.78489 Antioch 42 []
1147699 November 17, 2020 - 23:41:23 UTC 37.96738 -121.78489 Antioch 42 []
1148804 November 18, 2020 - 21:31:27 UTC 37.96738 -121.78489 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 []
1096957 September 28, 2020 - 23:07:32 UTC 37.96997 -121.73249 Antioch 42 []
1150062 November 20, 2020 - 17:11:57 UTC 37.97065 -121.77993 Antioch 42 []
1147917 November 18, 2020 - 02:29:13 UTC 37.97079 -121.75285 Antioch 42 []
708362 November 16, 2019 - 20:48:19 UTC 37.97088 -121.75388 Antioch 42 []
1208524 January 11, 2021 - 23:51:35 UTC 37.9714 -121.76288 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 []
1124026 October 23, 2020 - 16:54:50 UTC 37.97191 -121.83058 Antioch 42 []
713787 November 24, 2019 - 17:24:57 UTC 37.97251 -121.7847 Antioch 42 []
1154409 November 25, 2020 - 17:12:31 UTC 37.97281 -121.76699 Antioch 42 []
658394 October 14, 2019 - 21:44:04 UTC 37.97298 -121.7636 Antioch 42 []
1132537 October 31, 2020 - 09:04:54 UTC 37.973 -121.79696 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"}]
1154113 November 24, 2020 - 22:10:40 UTC 37.97407 -121.77965 Antioch 42 []
1132459 October 30, 2020 - 23:56:26 UTC 37.9741 -121.75299 Antioch 42 []
1168628 December 07, 2020 - 19:34:00 UTC 37.9741 -121.75299 Antioch 42 []
1169837 December 08, 2020 - 02:27:00 UTC 37.9741 -121.75299 Antioch 42 []
1172187 December 08, 2020 - 20:49:00 UTC 37.9741 -121.75299 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"}]
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 []
1087815 September 22, 2020 - 19:15:06 UTC 37.97842 -121.79148 Antioch 42 []
1129285 October 26, 2020 - 23:05:32 UTC 37.97858 -121.78948 Antioch 42 []
1211091 January 15, 2021 - 19:27:30 UTC 37.97887 -121.75358 Antioch 42 []
670313 October 18, 2019 - 21:27:38 UTC 37.9792 -121.82907 Antioch 42 []
1121867 October 21, 2020 - 00:00:15 UTC 37.97939 -121.78499 Antioch 42 []
1122284 October 21, 2020 - 18:12:30 UTC 37.97939 -121.78499 Antioch 42 []
1182427 December 13, 2020 - 17:15:19 UTC 37.97946 -121.8455 Antioch 42 []
1086201 September 22, 2020 - 03:50:39 UTC 37.97984 -121.80252 Antioch 42 []
1206107 January 07, 2021 - 18:18:11 UTC 37.98017 -121.75555 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 []
1120118 October 18, 2020 - 06:33:00 UTC 37.98037 -121.81081 Antioch 42 []
1093670 September 26, 2020 - 04:02:04 UTC 37.98041 -121.78976 Antioch 42 []
744947 December 18, 2019 - 01:25:16 UTC 37.98091 -121.82784 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
);