225,105 rows sorted by longitude

View and edit SQL

id outageStartTime latitude longitude ▼ regionName outageDevices
1112930 October 07, 2020 - 20:10:20 UTC 36.79255 -118.66146 Kings Canyon National Pk 769 []
1133413 November 01, 2020 - 18:44:15 UTC 36.79255 -118.66146 Kings Canyon National Pk 769 []
1337764 April 30, 2021 - 16:47:06 UTC 36.79255 -118.66146 Kings Canyon National Pk 769 []
1351863 May 18, 2021 - 01:51:30 UTC 36.79255 -118.66146 Kings Canyon National Pk 769 []
1338127 April 30, 2021 - 23:02:03 UTC 36.79291 -118.66426 Kings Canyon National Pk 769 []
1351850 May 18, 2021 - 00:59:04 UTC 36.79291 -118.66426 Kings Canyon National Pk 769 []
1133234 November 01, 2020 - 04:58:02 UTC 36.80161 -118.69404 Kings Canyon National Pk 769 []
1159710 December 03, 2020 - 02:47:00 UTC 35.19756 -118.70075 Bear Valley Springs 918 [{"latitude": "35.19332", "longitude": "-118.72066"}, {"latitude": "35.19375", "longitude": "-118.70854"}, {"latitude": "35.19448", "longitude": "-118.70346"}]
1197767 December 23, 2020 - 17:10:00 UTC 35.19756 -118.70075 Bear Valley Springs 918 [{"latitude": "35.19332", "longitude": "-118.72066"}, {"latitude": "35.19375", "longitude": "-118.70854"}, {"latitude": "35.19448", "longitude": "-118.70346"}]
1159727 December 03, 2020 - 03:24:00 UTC 35.19448 -118.70346 Bear Valley Springs 918 []
1209138 January 12, 2021 - 22:32:00 UTC 35.19448 -118.70346 Bear Valley Springs 918 []
1215289 January 19, 2021 - 15:06:42 UTC 35.19448 -118.70346 Bear Valley Springs 918 []
1067400 September 14, 2020 - 01:36:08 UTC 35.19375 -118.70854 Bear Valley Springs 918 []
1155312 November 28, 2020 - 00:44:00 UTC 35.19375 -118.70854 Bear Valley Springs 918 []
1159726 December 03, 2020 - 02:47:00 UTC 35.19375 -118.70854 Bear Valley Springs 918 []
1169053 December 07, 2020 - 21:25:31 UTC 35.19375 -118.70854 Bear Valley Springs 918 []
1215283 January 19, 2021 - 15:05:52 UTC 35.19375 -118.70854 Bear Valley Springs 918 []
1159725 December 03, 2020 - 03:24:00 UTC 35.19332 -118.72066 Bear Valley Springs 918 []
1215274 January 19, 2021 - 15:04:51 UTC 35.19332 -118.72066 Bear Valley Springs 918 []
694627 October 30, 2019 - 04:08:01 UTC 35.36763 -118.72555 Caliente 708 []
744650 December 17, 2019 - 21:05:41 UTC 35.36241 -118.73109 Caliente 708 []
695006 October 30, 2019 - 17:07:48 UTC 35.3339 -118.73151 Caliente 708 []
652893 October 10, 2019 - 17:39:00 UTC 35.334 -118.73463 Caliente 708 []
679280 October 24, 2019 - 08:12:00 UTC 35.334 -118.73463 Caliente 708 []
1061531 September 09, 2020 - 02:11:00 UTC 35.33418 -118.73464 Caliente 708 []
1159722 December 03, 2020 - 03:14:00 UTC 35.33418 -118.73464 Caliente 708 []
1215121 January 19, 2021 - 14:39:08 UTC 35.33418 -118.73464 Caliente 708 []
1333745 April 26, 2021 - 03:10:11 UTC 35.2241 -118.73467 Arvin 338 []
696574 October 31, 2019 - 17:15:59 UTC 35.33015 -118.73526 Caliente 708 []
696402 October 30, 2019 - 21:46:00 UTC 35.33378 -118.73691 Caliente 708 []
695511 October 30, 2019 - 21:46:18 UTC 35.32643 -118.7383 Caliente 708 []
1202012 January 01, 2021 - 04:02:59 UTC 35.24467 -118.74104 Arvin 338 []
1215529 January 19, 2021 - 15:46:06 UTC 35.24467 -118.74104 Arvin 338 []
679283 October 24, 2019 - 08:15:07 UTC 35.43631 -118.74107 Caliente 708 []
694630 October 30, 2019 - 04:08:36 UTC 35.43631 -118.74107 Caliente 708 []
1061536 September 09, 2020 - 02:20:20 UTC 35.43631 -118.74107 Caliente 708 []
1159719 December 03, 2020 - 03:11:14 UTC 35.43631 -118.74107 Caliente 708 []
1220011 January 21, 2021 - 22:23:45 UTC 35.43764 -118.74139 Caliente 708 []
679281 October 24, 2019 - 08:15:01 UTC 35.43595 -118.74221 Caliente 708 []
694628 October 30, 2019 - 04:08:01 UTC 35.43595 -118.74221 Caliente 708 []
1061537 September 09, 2020 - 02:20:20 UTC 35.43595 -118.74221 Caliente 708 []
679282 October 24, 2019 - 08:15:02 UTC 35.42852 -118.75007 Caliente 708 []
694631 October 30, 2019 - 04:08:36 UTC 35.42852 -118.75007 Caliente 708 []
1061538 September 09, 2020 - 02:20:20 UTC 35.42852 -118.75007 Caliente 708 []
1159718 December 03, 2020 - 03:11:03 UTC 35.42852 -118.75007 Caliente 708 []
1191957 December 17, 2020 - 16:11:43 UTC 35.23128 -118.75099 Arvin 338 [{"latitude": "35.23128", "longitude": "-118.73497"}, {"latitude": "35.23482", "longitude": "-118.73469"}, {"latitude": "35.23129", "longitude": "-118.743"}]
1351859 May 18, 2021 - 01:39:34 UTC 36.74901 -118.75129 Kings Canyon National Pk 769 []
696860 October 31, 2019 - 20:47:56 UTC 35.2386 -118.75183 Arvin 338 [{"latitude": "35.24137", "longitude": "-118.73553"}, {"latitude": "35.24862", "longitude": "-118.73586"}, {"latitude": "35.24491", "longitude": "-118.74407"}, {"latitude": "35.24139", "longitude": "-118.74407"}]
696419 October 31, 2019 - 15:14:11 UTC 35.2386 -118.75189 Arvin 338 []
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"}]
727552 December 02, 2019 - 19:45:11 UTC 35.29449 -118.75343 Caliente 708 []
729595 December 04, 2019 - 17:44:38 UTC 35.29533 -118.75388 Caliente 708 []
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"}]
1344715 May 10, 2021 - 15:21:20 UTC 35.19954 -118.75758 Tehachapi 955 []
658887 October 15, 2019 - 15:55:50 UTC 35.28947 -118.75767 Bakersfield 2 []
653003 October 10, 2019 - 18:32:26 UTC 35.03123 -118.76665 Arvin 338 []
1333743 April 26, 2021 - 03:10:14 UTC 35.20012 -118.76784 Tehachapi 955 []
728347 December 03, 2019 - 16:02:00 UTC 35.02231 -118.77035 Rosamond 714 [{"latitude": "35.03123", "longitude": "-118.76665"}, {"latitude": "35.03879", "longitude": "-118.75697"}, {"latitude": "35.04987", "longitude": "-118.76881"}, {"latitude": "35.04854", "longitude": "-118.77931"}, {"latitude": "35.03963", "longitude": "-118.78284"}, {"latitude": "35.03935", "longitude": "-118.78248"}, {"latitude": "35.03229", "longitude": "-118.77291"}]
1061522 September 09, 2020 - 02:03:00 UTC 35.02235 -118.77035 Rosamond 714 [{"latitude": "35.03123", "longitude": "-118.76665"}, {"latitude": "35.03879", "longitude": "-118.75697"}, {"latitude": "35.04987", "longitude": "-118.76881"}, {"latitude": "35.04854", "longitude": "-118.77931"}, {"latitude": "35.03963", "longitude": "-118.78284"}, {"latitude": "35.03935", "longitude": "-118.78248"}, {"latitude": "35.03229", "longitude": "-118.77291"}]
653402 October 10, 2019 - 18:17:00 UTC 35.02308 -118.77039 Rosamond 714 [{"latitude": "35.03123", "longitude": "-118.76665"}, {"latitude": "35.03879", "longitude": "-118.75697"}, {"latitude": "35.04987", "longitude": "-118.76881"}, {"latitude": "35.04854", "longitude": "-118.77931"}, {"latitude": "35.03963", "longitude": "-118.78284"}, {"latitude": "35.03935", "longitude": "-118.78248"}, {"latitude": "35.03229", "longitude": "-118.77291"}]
679284 October 24, 2019 - 08:12:00 UTC 35.02308 -118.77039 Rosamond 714 [{"latitude": "35.03123", "longitude": "-118.76665"}, {"latitude": "35.03879", "longitude": "-118.75697"}, {"latitude": "35.04987", "longitude": "-118.76881"}, {"latitude": "35.04854", "longitude": "-118.77931"}, {"latitude": "35.03963", "longitude": "-118.78284"}, {"latitude": "35.03935", "longitude": "-118.78248"}, {"latitude": "35.03229", "longitude": "-118.77291"}]
694632 October 30, 2019 - 04:02:00 UTC 35.02308 -118.77039 Rosamond 714 [{"latitude": "35.03123", "longitude": "-118.76665"}, {"latitude": "35.03879", "longitude": "-118.75697"}, {"latitude": "35.04987", "longitude": "-118.76881"}, {"latitude": "35.04854", "longitude": "-118.77931"}, {"latitude": "35.03963", "longitude": "-118.78284"}, {"latitude": "35.03935", "longitude": "-118.78248"}, {"latitude": "35.03229", "longitude": "-118.77291"}]
787935 February 11, 2020 - 01:22:58 UTC 35.26747 -118.77066 Arvin 338 []
1123874 October 23, 2020 - 14:12:34 UTC 35.2748 -118.7708 Arvin 338 []
1159723 December 03, 2020 - 03:11:00 UTC 35.04193 -118.77164 Arvin 338 [{"latitude": "35.048", "longitude": "-118.77521"}, {"latitude": "35.04987", "longitude": "-118.76881"}, {"latitude": "35.04854", "longitude": "-118.77931"}]
1215150 January 19, 2021 - 14:43:54 UTC 35.04193 -118.77164 Arvin 338 [{"latitude": "35.048", "longitude": "-118.77521"}, {"latitude": "35.04987", "longitude": "-118.76881"}, {"latitude": "35.04854", "longitude": "-118.77931"}]
1067530 September 14, 2020 - 12:04:20 UTC 35.23114 -118.7737 Arvin 338 []
1283436 March 15, 2021 - 20:55:29 UTC 35.20816 -118.77714 Arvin 338 []
1164209 December 05, 2020 - 16:03:00 UTC 35.32044 -118.77786 Bakersfield 2 []
1215610 January 19, 2021 - 15:46:06 UTC 35.22493 -118.77843 Arvin 338 [{"latitude": "35.17936", "longitude": "-118.80003"}, {"latitude": "35.19954", "longitude": "-118.75758"}, {"latitude": "35.22078", "longitude": "-118.73474"}, {"latitude": "35.2241", "longitude": "-118.73467"}, {"latitude": "35.23482", "longitude": "-118.73469"}, {"latitude": "35.24862", "longitude": "-118.73586"}, {"latitude": "35.24846", "longitude": "-118.80667"}, {"latitude": "35.23935", "longitude": "-118.81674"}, {"latitude": "35.238", "longitude": "-118.81734"}, {"latitude": "35.22494", "longitude": "-118.82277"}, {"latitude": "35.22436", "longitude": "-118.82277"}, {"latitude": "35.20813", "longitude": "-118.82099"}, {"latitude": "35.18743", "longitude": "-118.80683"}]
1217782 January 20, 2021 - 00:54:00 UTC 35.22493 -118.77843 Arvin 338 [{"latitude": "35.18724", "longitude": "-118.78791"}, {"latitude": "35.19954", "longitude": "-118.75758"}, {"latitude": "35.22078", "longitude": "-118.73474"}, {"latitude": "35.2241", "longitude": "-118.73467"}, {"latitude": "35.23482", "longitude": "-118.73469"}, {"latitude": "35.24627", "longitude": "-118.75302"}, {"latitude": "35.24657", "longitude": "-118.75426"}, {"latitude": "35.24846", "longitude": "-118.80667"}, {"latitude": "35.23935", "longitude": "-118.81674"}, {"latitude": "35.238", "longitude": "-118.81734"}, {"latitude": "35.22494", "longitude": "-118.82277"}, {"latitude": "35.22436", "longitude": "-118.82277"}, {"latitude": "35.20813", "longitude": "-118.82099"}, {"latitude": "35.19452", "longitude": "-118.80378"}, {"latitude": "35.19101", "longitude": "-118.79692"}]
1150297 November 20, 2020 - 21:13:22 UTC 35.01157 -118.78014 Rosamond 714 []
1351310 May 17, 2021 - 16:17:20 UTC 35.33277 -118.78033 Bakersfield 2 []
1340705 May 04, 2021 - 19:00:10 UTC 35.1906 -118.78365 Arvin 338 []
1123878 October 23, 2020 - 14:19:00 UTC 35.23824 -118.78649 Arvin 338 []
1156038 November 30, 2020 - 14:07:26 UTC 35.23824 -118.78649 Arvin 338 []
1283769 March 15, 2021 - 23:28:20 UTC 35.21651 -118.79006 Arvin 338 []
1156037 November 30, 2020 - 14:01:03 UTC 35.23109 -118.79149 Arvin 338 []
1223609 January 25, 2021 - 15:28:00 UTC 35.23109 -118.79149 Arvin 338 []
1339475 May 03, 2021 - 14:10:05 UTC 35.23109 -118.79149 Arvin 338 []
1288436 March 19, 2021 - 14:21:15 UTC 35.231 -118.79451 Arvin 338 []
1339919 May 03, 2021 - 19:09:56 UTC 35.231 -118.79451 Arvin 338 []
1305026 April 01, 2021 - 17:20:35 UTC 35.31841 -118.79514 Bakersfield 2 []
1333750 April 26, 2021 - 03:15:00 UTC 35.19365 -118.79698 Arvin 338 []
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 []
1130985 October 28, 2020 - 22:54:23 UTC 35.25797 -118.80161 Arvin 338 []
1277433 March 10, 2021 - 20:54:15 UTC 35.03283 -118.80244 Arvin 338 []
1137530 November 06, 2020 - 19:06:00 UTC 35.03421 -118.80245 Arvin 338 []
1159800 December 03, 2020 - 11:16:33 UTC 35.20916 -118.80326 Arvin 338 [{"latitude": "35.2015", "longitude": "-118.79693"}, {"latitude": "35.20197", "longitude": "-118.79011"}, {"latitude": "35.20382", "longitude": "-118.77028"}, {"latitude": "35.20969", "longitude": "-118.77026"}, {"latitude": "35.21651", "longitude": "-118.78994"}, {"latitude": "35.21675", "longitude": "-118.79722"}, {"latitude": "35.2092", "longitude": "-118.79857"}]
1139136 November 08, 2020 - 16:06:08 UTC 35.34746 -118.80523 Bakersfield 2 []
1123873 October 23, 2020 - 14:12:36 UTC 35.24574 -118.80663 Arvin 338 []
1333742 April 26, 2021 - 03:10:11 UTC 35.24574 -118.80663 Arvin 338 []
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 []

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