outages

76,672 rows sorted by longitude

View and edit SQL

id outageStartTime latitude longitude ▼ regionName outageDevices
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 []
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 []
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 []
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 []
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 []
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 []
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"}]
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 []
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"}]
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 []
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 []
727363 December 02, 2019 - 18:11:55 UTC 35.62995 -118.80719 Bakersfield 2 []
642797 October 04, 2019 - 16:11:46 UTC 35.64541 -118.81025 Bakersfield 2 []
653659 October 10, 2019 - 17:44:00 UTC 35.04593 -118.8113 Arvin 338 [{"latitude": "35.04901", "longitude": "-118.81129"}, {"latitude": "35.05955", "longitude": "-118.81126"}, {"latitude": "35.05638", "longitude": "-118.81127"}, {"latitude": "35.04978", "longitude": "-118.81129"}]
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 []
634853 October 01, 2019 - 21:31:59 UTC 35.64895 -118.81466 Bakersfield 2 []
790106 February 13, 2020 - 16:02:39 UTC 35.24531 -118.81576 Arvin 338 []
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"}]
654313 October 10, 2019 - 16:47:00 UTC 35.15003 -118.82343 Arvin 338 [{"latitude": "35.14043", "longitude": "-118.81412"}, {"latitude": "35.14498", "longitude": "-118.82332"}, {"latitude": "35.14068", "longitude": "-118.82774"}]
694634 October 30, 2019 - 04:11:04 UTC 35.59765 -118.8238 Bakersfield 2 []
695279 October 30, 2019 - 19:44:59 UTC 35.20277 -118.82409 Arvin 338 []
704062 November 10, 2019 - 23:27:29 UTC 35.20868 -118.82418 Arvin 338 [{"latitude": "35.20863", "longitude": "-118.8302"}, {"latitude": "35.20863", "longitude": "-118.82951"}, {"latitude": "35.20868", "longitude": "-118.82466"}, {"latitude": "35.20868", "longitude": "-118.82537"}, {"latitude": "35.20867", "longitude": "-118.82743"}]
778471 February 05, 2020 - 18:33:55 UTC 35.1948 -118.8243 Arvin 338 []
638655 October 02, 2019 - 23:11:14 UTC 35.20868 -118.82466 Arvin 338 []
790118 February 13, 2020 - 15:56:00 UTC 35.26944 -118.82486 Arvin 338 [{"latitude": "35.22547", "longitude": "-118.82277"}, {"latitude": "35.25289", "longitude": "-118.80746"}, {"latitude": "35.26042", "longitude": "-118.82476"}, {"latitude": "35.26372", "longitude": "-118.8339"}, {"latitude": "35.24643", "longitude": "-118.8695"}, {"latitude": "35.24516", "longitude": "-118.86982"}, {"latitude": "35.23752", "longitude": "-118.86973"}, {"latitude": "35.22555", "longitude": "-118.8241"}]
714744 November 25, 2019 - 23:34:43 UTC 35.20868 -118.82501 Arvin 338 []
787677 February 10, 2020 - 22:03:01 UTC 35.1971 -118.82575 Arvin 338 []
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 []
788577 February 11, 2020 - 18:20:00 UTC 35.18975 -118.82931 Arvin 338 []
704061 November 10, 2019 - 23:27:29 UTC 35.20795 -118.83048 Arvin 338 []
729372 December 04, 2019 - 15:30:15 UTC 35.22404 -118.8315 Arvin 338 []
695002 October 30, 2019 - 17:06:54 UTC 35.19069 -118.83209 Arvin 338 []
710651 November 20, 2019 - 14:28:16 UTC 35.21198 -118.83266 Arvin 338 []
788542 February 11, 2020 - 17:40:00 UTC 35.19158 -118.83295 Arvin 338 [{"latitude": "35.18752", "longitude": "-118.83275"}, {"latitude": "35.18853", "longitude": "-118.83205"}, {"latitude": "35.18924", "longitude": "-118.83205"}, {"latitude": "35.18996", "longitude": "-118.8321"}]
789816 February 12, 2020 - 23:50:53 UTC 35.32316 -118.83685 Bakersfield 2 []
659753 October 15, 2019 - 20:05:52 UTC 35.27965 -118.83755 Bakersfield 2 []
727729 December 02, 2019 - 22:07:39 UTC 35.04533 -118.83834 Arvin 338 []
653783 October 10, 2019 - 17:44:00 UTC 35.09267 -118.83878 Arvin 338 [{"latitude": "35.05673", "longitude": "-118.82039"}, {"latitude": "35.08721", "longitude": "-118.80992"}, {"latitude": "35.10713", "longitude": "-118.83678"}, {"latitude": "35.10118", "longitude": "-118.84143"}, {"latitude": "35.08521", "longitude": "-118.8378"}]
706078 November 13, 2019 - 18:35:53 UTC 35.19723 -118.83961 Arvin 338 []
639256 October 03, 2019 - 17:11:00 UTC 35.20087 -118.83973 Arvin 338 []
660699 October 16, 2019 - 16:52:00 UTC 35.20474 -118.83998 Arvin 338 []
705146 November 12, 2019 - 21:19:36 UTC 35.21148 -118.84112 Arvin 338 []
715194 November 26, 2019 - 18:25:50 UTC 35.20424 -118.84119 Arvin 338 []
734194 December 09, 2019 - 16:29:22 UTC 35.20469 -118.84124 Arvin 338 []
633899 October 01, 2019 - 17:08:36 UTC 35.64876 -118.84143 Bakersfield 2 []
708947 November 18, 2019 - 15:27:19 UTC 35.20202 -118.84154 Arvin 338 []
639353 October 03, 2019 - 17:25:57 UTC 35.20086 -118.8421 Arvin 338 []
708946 November 18, 2019 - 15:26:36 UTC 35.20606 -118.8422 Arvin 338 []
652053 October 10, 2019 - 05:06:48 UTC 35.22414 -118.84227 Arvin 338 [{"latitude": "35.2245", "longitude": "-118.84248"}, {"latitude": "35.23054", "longitude": "-118.83795"}, {"latitude": "35.23079", "longitude": "-118.84237"}, {"latitude": "35.22623", "longitude": "-118.8428"}]
677739 October 23, 2019 - 21:17:46 UTC 35.21998 -118.84258 Arvin 338 []
790105 February 13, 2020 - 16:01:51 UTC 35.24884 -118.84276 Arvin 338 [{"latitude": "35.24872", "longitude": "-118.84381"}, {"latitude": "35.24906", "longitude": "-118.84283"}, {"latitude": "35.25185", "longitude": "-118.84395"}]
704058 November 10, 2019 - 23:22:00 UTC 35.2089 -118.84473 Arvin 338 [{"latitude": "35.20621", "longitude": "-118.82316"}, {"latitude": "35.20773", "longitude": "-118.8219"}, {"latitude": "35.20917", "longitude": "-118.82189"}, {"latitude": "35.21425", "longitude": "-118.82995"}, {"latitude": "35.21503", "longitude": "-118.83161"}, {"latitude": "35.21453", "longitude": "-118.84175"}, {"latitude": "35.20891", "longitude": "-118.84354"}, {"latitude": "35.2078", "longitude": "-118.84222"}, {"latitude": "35.20758", "longitude": "-118.84141"}]
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"}]
658540 October 14, 2019 - 22:22:09 UTC 35.07097 -118.85547 Arvin 338 []
779160 February 06, 2020 - 17:29:27 UTC 35.07097 -118.85547 Arvin 338 []
735477 December 10, 2019 - 17:54:12 UTC 35.25262 -118.85828 Arvin 338 [{"latitude": "35.25076", "longitude": "-118.85283"}, {"latitude": "35.25263", "longitude": "-118.85113"}, {"latitude": "35.25262", "longitude": "-118.85612"}, {"latitude": "35.2524", "longitude": "-118.85696"}]
735320 December 10, 2019 - 16:52:52 UTC 35.25199 -118.85884 Arvin 338 []
787928 February 11, 2020 - 01:00:00 UTC 35.19415 -118.86011 Arvin 338 []
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"}]
647467 October 08, 2019 - 19:14:28 UTC 35.40339 -118.8642 Bakersfield 2 []
722882 November 28, 2019 - 19:14:48 UTC 34.83694 -118.86436 Lebec 454 []
654655 October 11, 2019 - 22:38:13 UTC 35.43132 -118.86533 Bakersfield 2 []
653776 October 10, 2019 - 17:59:00 UTC 34.83751 -118.86608 Lebec 454 [{"latitude": "34.82559", "longitude": "-118.85502"}, {"latitude": "34.82678", "longitude": "-118.85493"}, {"latitude": "34.83326", "longitude": "-118.85601"}, {"latitude": "34.84047", "longitude": "-118.86221"}, {"latitude": "34.83676", "longitude": "-118.86452"}, {"latitude": "34.83325", "longitude": "-118.86524"}, {"latitude": "34.83218", "longitude": "-118.86487"}, {"latitude": "34.83051", "longitude": "-118.86324"}]
722699 November 28, 2019 - 16:29:21 UTC 34.84154 -118.86658 Lebec 454 []
647258 October 08, 2019 - 15:49:51 UTC 34.84192 -118.86779 Lebec 454 []
653777 October 10, 2019 - 17:59:00 UTC 34.83235 -118.86841 Lebec 454 [{"latitude": "34.82745", "longitude": "-118.8674"}, {"latitude": "34.8303", "longitude": "-118.86725"}, {"latitude": "34.82899", "longitude": "-118.86732"}, {"latitude": "34.82824", "longitude": "-118.86736"}]
653779 October 10, 2019 - 17:59:00 UTC 34.83269 -118.86873 Lebec 454 [{"latitude": "34.83271", "longitude": "-118.86975"}, {"latitude": "34.83712", "longitude": "-118.87111"}, {"latitude": "34.83409", "longitude": "-118.87826"}, {"latitude": "34.83281", "longitude": "-118.87121"}]
722788 November 28, 2019 - 17:45:00 UTC 34.84196 -118.86888 Lebec 454 []
732851 December 07, 2019 - 21:36:22 UTC 35.14741 -118.86891 Arvin 338 []
646147 October 07, 2019 - 18:50:09 UTC 34.84317 -118.86894 Lebec 454 []
695485 October 30, 2019 - 21:38:48 UTC 35.3462 -118.86931 Bakersfield 2 []
653011 October 10, 2019 - 18:34:43 UTC 35.33267 -118.86955 Bakersfield 2 []
645959 October 07, 2019 - 16:33:48 UTC 34.84573 -118.87124 Lebec 454 []
785344 February 09, 2020 - 23:44:03 UTC 34.83602 -118.87215 Lebec 454 []
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 []

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 857.916ms · About: About this site