801 rows where regionName = 42 sorted by longitude

View and edit SQL

id outageStartTime latitude longitude ▼ regionName outageDevices
1096957 September 28, 2020 - 23:07:32 UTC 37.96997 -121.73249 Antioch 42 []
1256503 February 17, 2021 - 17:23:00 UTC 37.96979 -121.73249 Antioch 42 [{"latitude": "37.96997", "longitude": "-121.73249"}, {"latitude": "37.97077", "longitude": "-121.73214"}, {"latitude": "37.97061", "longitude": "-121.73587"}]
1295094 March 24, 2021 - 15:36:05 UTC 37.96392 -121.74335 Antioch 42 [{"latitude": "37.9673", "longitude": "-121.74383"}, {"latitude": "37.96848", "longitude": "-121.74032"}, {"latitude": "37.9706", "longitude": "-121.74318"}, {"latitude": "37.96744", "longitude": "-121.74595"}]
737531 December 12, 2019 - 19:08:45 UTC 37.96225 -121.74446 Antioch 42 []
1137236 November 06, 2020 - 16:35:43 UTC 37.98113 -121.74985 Antioch 42 []
706772 November 14, 2019 - 18:04:00 UTC 37.95885 -121.7514 Antioch 42 []
1230298 January 27, 2021 - 07:04:06 UTC 38.0169 -121.75176 Antioch 42 [{"latitude": "38.01499", "longitude": "-121.75419"}, {"latitude": "38.01583", "longitude": "-121.75255"}, {"latitude": "38.01691", "longitude": "-121.7519"}, {"latitude": "38.01763", "longitude": "-121.75185"}, {"latitude": "38.01906", "longitude": "-121.752"}, {"latitude": "38.01962", "longitude": "-121.75361"}, {"latitude": "38.0188", "longitude": "-121.75444"}, {"latitude": "38.01739", "longitude": "-121.75447"}]
1245802 February 02, 2021 - 17:07:00 UTC 38.01691 -121.75178 Antioch 42 [{"latitude": "38.01499", "longitude": "-121.75419"}, {"latitude": "38.01583", "longitude": "-121.75255"}, {"latitude": "38.01691", "longitude": "-121.7519"}, {"latitude": "38.01763", "longitude": "-121.75185"}, {"latitude": "38.01906", "longitude": "-121.752"}, {"latitude": "38.01962", "longitude": "-121.75361"}, {"latitude": "38.0188", "longitude": "-121.75444"}, {"latitude": "38.01739", "longitude": "-121.75447"}]
1147917 November 18, 2020 - 02:29:13 UTC 37.97079 -121.75285 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 []
1211091 January 15, 2021 - 19:27:30 UTC 37.97887 -121.75358 Antioch 42 []
1096886 September 28, 2020 - 21:55:25 UTC 38.01766 -121.75366 Antioch 42 []
1136861 November 06, 2020 - 00:05:28 UTC 38.01766 -121.75366 Antioch 42 []
1206228 January 07, 2021 - 20:52:39 UTC 38.01766 -121.75366 Antioch 42 []
702803 November 08, 2019 - 19:42:51 UTC 37.95964 -121.75371 Antioch 42 []
1247117 February 03, 2021 - 20:21:05 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"}]
1195962 December 20, 2020 - 19:58:54 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"}]
1280647 March 13, 2021 - 08:55:24 UTC 37.96007 -121.75487 Antioch 42 [{"latitude": "37.95806", "longitude": "-121.75202"}, {"latitude": "37.95885", "longitude": "-121.7514"}, {"latitude": "37.95964", "longitude": "-121.75198"}, {"latitude": "37.95964", "longitude": "-121.75371"}, {"latitude": "37.95893", "longitude": "-121.75431"}]
1281353 March 13, 2021 - 22:39:00 UTC 37.96007 -121.75487 Antioch 42 [{"latitude": "37.95806", "longitude": "-121.75202"}, {"latitude": "37.95885", "longitude": "-121.7514"}, {"latitude": "37.95964", "longitude": "-121.75198"}, {"latitude": "37.95964", "longitude": "-121.75371"}, {"latitude": "37.95893", "longitude": "-121.75431"}]
721961 November 28, 2019 - 00:20:11 UTC 37.98884 -121.7551 Antioch 42 []
1206107 January 07, 2021 - 18:18:11 UTC 37.98017 -121.75555 Antioch 42 []
1212373 January 18, 2021 - 18:00:56 UTC 38.01217 -121.75566 Antioch 42 []
706758 November 14, 2019 - 17:58:00 UTC 37.95592 -121.75567 Antioch 42 []
1135624 November 04, 2020 - 17:03:00 UTC 38.00496 -121.75638 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 []
1305731 April 02, 2021 - 16:57:59 UTC 38.00494 -121.75688 Antioch 42 []
1218691 January 20, 2021 - 19:32:49 UTC 37.99783 -121.75697 Antioch 42 []
1193159 December 18, 2020 - 09:33:56 UTC 37.98442 -121.75744 Antioch 42 []
1194349 December 19, 2020 - 11:05:47 UTC 37.98442 -121.75744 Antioch 42 []
1195733 December 20, 2020 - 03:24:00 UTC 37.98442 -121.75744 Antioch 42 []
1197930 December 24, 2020 - 00:27:29 UTC 37.98442 -121.75744 Antioch 42 []
1198253 December 24, 2020 - 20:56:04 UTC 37.98442 -121.75744 Antioch 42 []
1198353 December 25, 2020 - 01:45:53 UTC 37.98442 -121.75744 Antioch 42 []
1198559 December 25, 2020 - 20:21:00 UTC 37.98442 -121.75744 Antioch 42 []
1201879 December 31, 2020 - 21:22:37 UTC 37.98442 -121.75744 Antioch 42 []
1207050 January 09, 2021 - 02:01:51 UTC 37.98442 -121.75744 Antioch 42 []
1112408 October 07, 2020 - 01:50:38 UTC 37.96656 -121.75757 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 []
1340253 May 04, 2021 - 02:37:52 UTC 37.99781 -121.75859 Antioch 42 []
1340274 May 04, 2021 - 04:06:06 UTC 37.99781 -121.75859 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 []
1302932 March 30, 2021 - 05:37:00 UTC 37.95115 -121.75954 Antioch 42 []
1304602 April 01, 2021 - 00:39:25 UTC 37.95115 -121.75954 Antioch 42 []
1305866 April 02, 2021 - 19:52:44 UTC 37.95115 -121.75954 Antioch 42 []
1307156 April 05, 2021 - 18:57:49 UTC 37.95115 -121.75954 Antioch 42 []
706766 November 14, 2019 - 18:02:05 UTC 37.95503 -121.76003 Antioch 42 []
1257757 February 19, 2021 - 17:00:00 UTC 38.00325 -121.76022 Antioch 42 [{"latitude": "38.00246", "longitude": "-121.76062"}, {"latitude": "38.00326", "longitude": "-121.76033"}, {"latitude": "38.00327", "longitude": "-121.7612"}]
1219606 January 21, 2021 - 17:00:00 UTC 37.95112 -121.76046 Antioch 42 []
1307173 April 05, 2021 - 19:17:32 UTC 37.95114 -121.76074 Antioch 42 []
1305762 April 02, 2021 - 17:32:40 UTC 37.98399 -121.76094 Antioch 42 []
1312174 April 09, 2021 - 20:31:22 UTC 37.98399 -121.76094 Antioch 42 []
1315683 April 14, 2021 - 02:38:35 UTC 37.98012 -121.76268 Antioch 42 []
1155026 November 27, 2020 - 03:02:29 UTC 37.95836 -121.76276 Antioch 42 []
1133327 November 01, 2020 - 15:09:23 UTC 37.95583 -121.76286 Antioch 42 []
1208524 January 11, 2021 - 23:51:35 UTC 37.9714 -121.76288 Antioch 42 []
1342891 May 07, 2021 - 05:02:17 UTC 38.00486 -121.76299 Antioch 42 []
658394 October 14, 2019 - 21:44:04 UTC 37.97298 -121.7636 Antioch 42 []
1342711 May 06, 2021 - 22:09:35 UTC 38.0048 -121.76381 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 []
1118721 October 15, 2020 - 22:03:51 UTC 37.98724 -121.76593 Antioch 42 []
1344519 May 10, 2021 - 00:59:01 UTC 37.98593 -121.76599 Antioch 42 []
1131194 October 29, 2020 - 10:21:00 UTC 37.96395 -121.76602 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 []
1245260 February 01, 2021 - 23:18:48 UTC 38.00481 -121.76691 Antioch 42 []
1154409 November 25, 2020 - 17:12:31 UTC 37.97281 -121.76699 Antioch 42 []
1140714 November 10, 2020 - 04:53:10 UTC 37.98094 -121.76809 Antioch 42 []
1257910 February 19, 2021 - 19:08:52 UTC 37.98094 -121.76809 Antioch 42 []
1308566 April 07, 2021 - 15:30:00 UTC 37.99757 -121.76906 Antioch 42 []
1308648 April 07, 2021 - 16:00:00 UTC 37.9435 -121.76921 Antioch 42 [{"latitude": "37.93926", "longitude": "-121.77236"}, {"latitude": "37.94371", "longitude": "-121.77045"}, {"latitude": "37.94714", "longitude": "-121.77375"}, {"latitude": "37.94808", "longitude": "-121.77719"}, {"latitude": "37.94937", "longitude": "-121.78431"}, {"latitude": "37.94193", "longitude": "-121.77765"}]
1261901 February 25, 2021 - 15:48:00 UTC 37.95486 -121.76934 Antioch 42 []
1081555 September 18, 2020 - 22:00:01 UTC 38.00751 -121.76969 Antioch 42 []
1257913 February 19, 2021 - 19:10:15 UTC 37.98084 -121.76973 Antioch 42 []
1129389 October 27, 2020 - 00:55:09 UTC 38.00844 -121.77061 Antioch 42 []
1113587 October 08, 2020 - 19:40:42 UTC 37.9812 -121.77067 Antioch 42 []
1117921 October 15, 2020 - 02:22:34 UTC 38.0075 -121.77084 Antioch 42 []
1274575 March 09, 2021 - 03:38:53 UTC 38.0075 -121.77084 Antioch 42 []
690849 October 28, 2019 - 03:24:49 UTC 37.98443 -121.77086 Antioch 42 []
1095098 September 27, 2020 - 16:31:05 UTC 38.00102 -121.77089 Antioch 42 []
785164 February 09, 2020 - 23:05:27 UTC 38.00065 -121.77123 Antioch 42 []
1067244 September 13, 2020 - 15:50:43 UTC 37.96208 -121.77127 Antioch 42 []
1308886 April 07, 2021 - 18:25:30 UTC 38.00174 -121.77227 Antioch 42 []
1151407 November 21, 2020 - 19:53:40 UTC 38.00969 -121.77254 Antioch 42 []
731355 December 06, 2019 - 17:37:19 UTC 38.00726 -121.77255 Antioch 42 []
1153046 November 23, 2020 - 16:32:15 UTC 38.00726 -121.77255 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
);