5,011 rows where regionName = 2 sorted by longitude

View and edit SQL

id outageStartTime latitude longitude ▼ regionName outageDevices
1161632 December 04, 2020 - 00:30:00 UTC 35.26657 -118.75275 Bakersfield 2 [{"latitude": "35.25747", "longitude": "-118.75273"}, {"latitude": "35.26029", "longitude": "-118.75274"}, {"latitude": "35.25838", "longitude": "-118.75274"}]
743992 December 17, 2019 - 13:19:00 UTC 35.29384 -118.75692 Bakersfield 2 [{"latitude": "35.29449", "longitude": "-118.75343"}, {"latitude": "35.29733", "longitude": "-118.75273"}, {"latitude": "35.29533", "longitude": "-118.75388"}]
658887 October 15, 2019 - 15:55:50 UTC 35.28947 -118.75767 Bakersfield 2 []
1164209 December 05, 2020 - 16:03:00 UTC 35.32044 -118.77786 Bakersfield 2 []
1305026 April 01, 2021 - 17:20:35 UTC 35.31841 -118.79514 Bakersfield 2 []
1215166 January 19, 2021 - 14:47:39 UTC 35.43912 -118.79707 Bakersfield 2 [{"latitude": "35.43005", "longitude": "-118.74933"}, {"latitude": "35.43792", "longitude": "-118.74051"}, {"latitude": "35.43838", "longitude": "-118.74011"}, {"latitude": "35.43904", "longitude": "-118.7969"}, {"latitude": "35.43628", "longitude": "-118.79707"}]
653423 October 10, 2019 - 16:52:00 UTC 35.43913 -118.7971 Bakersfield 2 [{"latitude": "35.42852", "longitude": "-118.75007"}, {"latitude": "35.43631", "longitude": "-118.74107"}, {"latitude": "35.43682", "longitude": "-118.74052"}, {"latitude": "35.43904", "longitude": "-118.7969"}, {"latitude": "35.43525", "longitude": "-118.79631"}]
712001 November 21, 2019 - 16:14:00 UTC 35.43916 -118.79715 Bakersfield 2 [{"latitude": "35.42852", "longitude": "-118.75007"}, {"latitude": "35.43631", "longitude": "-118.74107"}, {"latitude": "35.43682", "longitude": "-118.74052"}, {"latitude": "35.43904", "longitude": "-118.7969"}, {"latitude": "35.43525", "longitude": "-118.79631"}]
704578 November 12, 2019 - 00:36:38 UTC 35.31114 -118.79838 Bakersfield 2 []
716556 November 27, 2019 - 01:02:17 UTC 35.31114 -118.79838 Bakersfield 2 []
723475 November 29, 2019 - 17:54:52 UTC 35.3183 -118.79852 Bakersfield 2 []
1139136 November 08, 2020 - 16:06:08 UTC 35.34746 -118.80523 Bakersfield 2 []
727363 December 02, 2019 - 18:11:55 UTC 35.62995 -118.80719 Bakersfield 2 []
1260505 February 23, 2021 - 22:40:00 UTC 35.29739 -118.80719 Bakersfield 2 [{"latitude": "35.30371", "longitude": "-118.80724"}, {"latitude": "35.31889", "longitude": "-118.75289"}, {"latitude": "35.32643", "longitude": "-118.7383"}, {"latitude": "35.3339", "longitude": "-118.73151"}, {"latitude": "35.36763", "longitude": "-118.72555"}, {"latitude": "35.34657", "longitude": "-118.8167"}, {"latitude": "35.32569", "longitude": "-118.81822"}]
1304326 March 31, 2021 - 18:11:44 UTC 35.62995 -118.80719 Bakersfield 2 []
1092574 September 25, 2020 - 17:57:08 UTC 35.30371 -118.80724 Bakersfield 2 []
642797 October 04, 2019 - 16:11:46 UTC 35.64541 -118.81025 Bakersfield 2 []
1154430 November 25, 2020 - 17:52:36 UTC 35.31078 -118.81154 Bakersfield 2 []
725032 December 01, 2019 - 02:28:16 UTC 35.63629 -118.81187 Bakersfield 2 []
736876 December 12, 2019 - 03:25:02 UTC 35.63629 -118.81187 Bakersfield 2 []
1283898 March 16, 2021 - 02:02:38 UTC 35.5575 -118.81194 Bakersfield 2 []
634853 October 01, 2019 - 21:31:59 UTC 35.64895 -118.81466 Bakersfield 2 []
1274408 March 08, 2021 - 23:22:33 UTC 35.34657 -118.8167 Bakersfield 2 []
1216957 January 19, 2021 - 20:16:37 UTC 35.4249 -118.81816 Bakersfield 2 []
635801 October 02, 2019 - 15:38:00 UTC 35.31101 -118.82232 Bakersfield 2 [{"latitude": "35.25747", "longitude": "-118.75273"}, {"latitude": "35.26057", "longitude": "-118.74457"}, {"latitude": "35.26767", "longitude": "-118.74427"}, {"latitude": "35.27558", "longitude": "-118.74401"}, {"latitude": "35.28066", "longitude": "-118.74397"}, {"latitude": "35.29733", "longitude": "-118.75273"}, {"latitude": "35.31446", "longitude": "-118.77062"}, {"latitude": "35.31791", "longitude": "-118.77753"}, {"latitude": "35.31771", "longitude": "-118.77898"}, {"latitude": "35.31085", "longitude": "-118.82043"}, {"latitude": "35.30375", "longitude": "-118.81621"}]
694634 October 30, 2019 - 04:11:04 UTC 35.59765 -118.8238 Bakersfield 2 []
1215726 January 19, 2021 - 16:18:00 UTC 35.31157 -118.82515 Bakersfield 2 [{"latitude": "35.31696", "longitude": "-118.82517"}, {"latitude": "35.31835", "longitude": "-118.81824"}, {"latitude": "35.31921", "longitude": "-118.81817"}, {"latitude": "35.33441", "longitude": "-118.82964"}, {"latitude": "35.32267", "longitude": "-118.83798"}]
1283692 March 15, 2021 - 22:51:30 UTC 35.31157 -118.82515 Bakersfield 2 [{"latitude": "35.31696", "longitude": "-118.82517"}, {"latitude": "35.31835", "longitude": "-118.81824"}, {"latitude": "35.31921", "longitude": "-118.81817"}, {"latitude": "35.33441", "longitude": "-118.82964"}, {"latitude": "35.32267", "longitude": "-118.83798"}]
1241664 January 29, 2021 - 19:39:41 UTC 35.42839 -118.82686 Bakersfield 2 []
1283892 March 16, 2021 - 01:46:00 UTC 35.59774 -118.82689 Bakersfield 2 []
634816 October 01, 2019 - 20:30:25 UTC 35.64845 -118.82716 Bakersfield 2 []
644433 October 05, 2019 - 16:56:53 UTC 35.41741 -118.82849 Bakersfield 2 []
1307502 April 06, 2021 - 15:03:18 UTC 35.32151 -118.82944 Bakersfield 2 []
1254627 February 14, 2021 - 04:32:44 UTC 35.4016 -118.83144 Bakersfield 2 []
1175274 December 10, 2020 - 16:06:11 UTC 35.27413 -118.83207 Bakersfield 2 []
1243329 January 30, 2021 - 23:20:14 UTC 35.27413 -118.83207 Bakersfield 2 []
1138535 November 07, 2020 - 18:11:48 UTC 35.42165 -118.83255 Bakersfield 2 [{"latitude": "35.41741", "longitude": "-118.82849"}, {"latitude": "35.42852", "longitude": "-118.75007"}, {"latitude": "35.43631", "longitude": "-118.74107"}, {"latitude": "35.43682", "longitude": "-118.74052"}, {"latitude": "35.44134", "longitude": "-118.79662"}, {"latitude": "35.44127", "longitude": "-118.79762"}, {"latitude": "35.43453", "longitude": "-118.82594"}, {"latitude": "35.42186", "longitude": "-118.83188"}]
1138800 November 07, 2020 - 22:21:05 UTC 35.29566 -118.83401 Bakersfield 2 []
1150547 November 21, 2020 - 15:21:54 UTC 35.28185 -118.83531 Bakersfield 2 []
789816 February 12, 2020 - 23:50:53 UTC 35.32316 -118.83685 Bakersfield 2 []
1312204 April 09, 2021 - 21:14:47 UTC 35.26739 -118.83747 Bakersfield 2 []
659753 October 15, 2019 - 20:05:52 UTC 35.27965 -118.83755 Bakersfield 2 []
1131316 October 29, 2020 - 15:48:32 UTC 35.27965 -118.83755 Bakersfield 2 []
1155180 November 27, 2020 - 18:18:43 UTC 35.27965 -118.83755 Bakersfield 2 []
1158014 December 02, 2020 - 18:25:43 UTC 35.35221 -118.83801 Bakersfield 2 []
1310303 April 08, 2021 - 12:40:00 UTC 35.40995 -118.83818 Bakersfield 2 []
1343352 May 07, 2021 - 18:52:52 UTC 35.40995 -118.83818 Bakersfield 2 []
1128732 October 26, 2020 - 16:21:04 UTC 35.4213 -118.83865 Bakersfield 2 []
1333879 April 26, 2021 - 13:56:00 UTC 35.37322 -118.84077 Bakersfield 2 []
633899 October 01, 2019 - 17:08:36 UTC 35.64876 -118.84143 Bakersfield 2 []
1220535 January 22, 2021 - 16:30:00 UTC 35.34085 -118.84218 Bakersfield 2 []
1306432 April 03, 2021 - 20:36:58 UTC 35.41228 -118.84297 Bakersfield 2 []
1128873 October 26, 2020 - 17:19:54 UTC 35.42543 -118.8474 Bakersfield 2 [{"latitude": "35.42616", "longitude": "-118.84426"}, {"latitude": "35.43038", "longitude": "-118.84042"}, {"latitude": "35.43872", "longitude": "-118.84918"}, {"latitude": "35.4298", "longitude": "-118.85148"}]
653544 October 10, 2019 - 17:29:00 UTC 35.62055 -118.84755 Bakersfield 2 [{"latitude": "35.61404", "longitude": "-118.8349"}, {"latitude": "35.6224", "longitude": "-118.81923"}, {"latitude": "35.62519", "longitude": "-118.81959"}, {"latitude": "35.6267", "longitude": "-118.8302"}, {"latitude": "35.62314", "longitude": "-118.83557"}]
653542 October 10, 2019 - 17:29:00 UTC 35.62109 -118.84832 Bakersfield 2 [{"latitude": "35.62928", "longitude": "-118.85458"}, {"latitude": "35.62995", "longitude": "-118.80719"}, {"latitude": "35.64388", "longitude": "-118.80672"}, {"latitude": "35.64443", "longitude": "-118.80683"}, {"latitude": "35.64895", "longitude": "-118.81466"}, {"latitude": "35.65649", "longitude": "-118.84323"}, {"latitude": "35.65628", "longitude": "-118.84556"}, {"latitude": "35.65443", "longitude": "-118.84831"}, {"latitude": "35.63288", "longitude": "-118.87435"}]
702220 November 08, 2019 - 01:48:41 UTC 35.62109 -118.84832 Bakersfield 2 [{"latitude": "35.62928", "longitude": "-118.85458"}, {"latitude": "35.62995", "longitude": "-118.80719"}, {"latitude": "35.64388", "longitude": "-118.80672"}, {"latitude": "35.64443", "longitude": "-118.80683"}, {"latitude": "35.64895", "longitude": "-118.81466"}, {"latitude": "35.65649", "longitude": "-118.84323"}, {"latitude": "35.65628", "longitude": "-118.84556"}, {"latitude": "35.65443", "longitude": "-118.84831"}, {"latitude": "35.63288", "longitude": "-118.87435"}]
1303203 March 30, 2021 - 15:32:00 UTC 35.40716 -118.84987 Bakersfield 2 [{"latitude": "35.40676", "longitude": "-118.85173"}, {"latitude": "35.40713", "longitude": "-118.85084"}, {"latitude": "35.40789", "longitude": "-118.85026"}, {"latitude": "35.4076", "longitude": "-118.8517"}]
1303510 March 30, 2021 - 19:10:00 UTC 35.40716 -118.84987 Bakersfield 2 [{"latitude": "35.40676", "longitude": "-118.85173"}, {"latitude": "35.40713", "longitude": "-118.85084"}, {"latitude": "35.4076", "longitude": "-118.8517"}]
1129125 October 26, 2020 - 20:43:26 UTC 35.4298 -118.85148 Bakersfield 2 []
1134901 November 03, 2020 - 14:37:00 UTC 35.29613 -118.85181 Bakersfield 2 [{"latitude": "35.28633", "longitude": "-118.85174"}, {"latitude": "35.29118", "longitude": "-118.85177"}, {"latitude": "35.29209", "longitude": "-118.85178"}, {"latitude": "35.29257", "longitude": "-118.85179"}]
1348265 May 13, 2021 - 19:45:23 UTC 35.31071 -118.85318 Bakersfield 2 []
1161568 December 04, 2020 - 00:03:28 UTC 35.36582 -118.85389 Bakersfield 2 []
1193766 December 18, 2020 - 19:03:03 UTC 35.36582 -118.85389 Bakersfield 2 []
1137736 November 06, 2020 - 22:04:29 UTC 35.36649 -118.85432 Bakersfield 2 []
1283885 March 16, 2021 - 01:40:15 UTC 35.55843 -118.85476 Bakersfield 2 []
1118840 October 16, 2020 - 00:49:50 UTC 35.28909 -118.85605 Bakersfield 2 []
1194414 December 19, 2020 - 15:32:00 UTC 35.41298 -118.85657 Bakersfield 2 []
1283886 March 16, 2021 - 01:40:15 UTC 35.55597 -118.85932 Bakersfield 2 []
1234174 January 27, 2021 - 16:57:21 UTC 35.35297 -118.85949 Bakersfield 2 []
1242180 January 29, 2021 - 23:39:33 UTC 35.35297 -118.85949 Bakersfield 2 []
1252302 February 10, 2021 - 18:26:24 UTC 35.35297 -118.85949 Bakersfield 2 []
1241188 January 29, 2021 - 16:22:20 UTC 35.41276 -118.85977 Bakersfield 2 []
1289579 March 20, 2021 - 13:58:53 UTC 35.2162 -118.8604 Bakersfield 2 [{"latitude": "35.21615", "longitude": "-118.86833"}, {"latitude": "35.21619", "longitude": "-118.86104"}, {"latitude": "35.21616", "longitude": "-118.86758"}]
1327935 April 22, 2021 - 15:09:00 UTC 35.34646 -118.86103 Bakersfield 2 []
698223 November 02, 2019 - 18:12:00 UTC 35.29709 -118.86191 Bakersfield 2 [{"latitude": "35.23791", "longitude": "-118.87897"}, {"latitude": "35.25294", "longitude": "-118.79147"}, {"latitude": "35.3339", "longitude": "-118.73151"}, {"latitude": "35.36763", "longitude": "-118.72555"}, {"latitude": "35.34657", "longitude": "-118.8167"}, {"latitude": "35.28143", "longitude": "-118.95833"}, {"latitude": "35.27145", "longitude": "-118.97536"}, {"latitude": "35.26745", "longitude": "-118.97536"}, {"latitude": "35.25963", "longitude": "-118.96139"}, {"latitude": "35.23804", "longitude": "-118.88172"}]
1348456 May 13, 2021 - 23:05:00 UTC 35.29709 -118.86191 Bakersfield 2 [{"latitude": "35.23791", "longitude": "-118.87897"}, {"latitude": "35.25294", "longitude": "-118.79147"}, {"latitude": "35.3339", "longitude": "-118.73151"}, {"latitude": "35.36763", "longitude": "-118.72555"}, {"latitude": "35.34657", "longitude": "-118.8167"}, {"latitude": "35.28143", "longitude": "-118.95833"}, {"latitude": "35.27145", "longitude": "-118.97536"}, {"latitude": "35.26745", "longitude": "-118.97536"}, {"latitude": "35.25963", "longitude": "-118.96139"}, {"latitude": "35.23804", "longitude": "-118.88172"}]
1118859 October 16, 2020 - 01:42:34 UTC 35.27437 -118.86293 Bakersfield 2 []
1230928 January 27, 2021 - 07:52:42 UTC 35.40828 -118.8634 Bakersfield 2 []
647467 October 08, 2019 - 19:14:28 UTC 35.40339 -118.8642 Bakersfield 2 []
654655 October 11, 2019 - 22:38:13 UTC 35.43132 -118.86533 Bakersfield 2 []
1162407 December 04, 2020 - 17:39:23 UTC 35.3476 -118.86622 Bakersfield 2 []
1111366 October 05, 2020 - 17:35:51 UTC 35.3986 -118.8675 Bakersfield 2 []
1333851 April 26, 2021 - 12:31:47 UTC 35.21616 -118.86758 Bakersfield 2 []
1080334 September 18, 2020 - 16:29:44 UTC 35.34597 -118.86816 Bakersfield 2 []
1304218 March 31, 2021 - 16:27:27 UTC 35.21251 -118.86919 Bakersfield 2 []
695485 October 30, 2019 - 21:38:48 UTC 35.3462 -118.86931 Bakersfield 2 []
1218057 January 20, 2021 - 04:31:00 UTC 35.23909 -118.86944 Bakersfield 2 [{"latitude": "35.2407", "longitude": "-118.86945"}, {"latitude": "35.24643", "longitude": "-118.8695"}, {"latitude": "35.24498", "longitude": "-118.87036"}]
1089339 September 23, 2020 - 17:24:46 UTC 35.30003 -118.86946 Bakersfield 2 []
1298540 March 26, 2021 - 14:49:08 UTC 35.30003 -118.86946 Bakersfield 2 []
653011 October 10, 2019 - 18:34:43 UTC 35.33267 -118.86955 Bakersfield 2 []
1174713 December 10, 2020 - 00:30:00 UTC 35.34603 -118.87141 Bakersfield 2 []
1283935 March 16, 2021 - 03:11:08 UTC 35.31607 -118.87155 Bakersfield 2 []
1116935 October 14, 2020 - 04:06:58 UTC 35.25577 -118.87156 Bakersfield 2 []
1093603 September 26, 2020 - 00:13:29 UTC 35.43097 -118.87249 Bakersfield 2 []
637113 October 02, 2019 - 19:07:05 UTC 35.45598 -118.8725 Bakersfield 2 []
653246 October 10, 2019 - 20:02:29 UTC 35.45598 -118.8725 Bakersfield 2 []
1217210 January 19, 2021 - 21:33:00 UTC 35.44281 -118.87252 Bakersfield 2 []
706598 November 14, 2019 - 16:22:01 UTC 35.34685 -118.87256 Bakersfield 2 []
1155132 November 27, 2020 - 16:37:32 UTC 35.27463 -118.87266 Bakersfield 2 []
1111456 October 05, 2020 - 19:07:23 UTC 35.45452 -118.87299 Bakersfield 2 []

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
);