outages

1,578 rows where regionName = 2 sorted by longitude

View and edit SQL

id outageStartTime latitude longitude ▼ regionName outageDevices
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 []
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 []
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 []
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 []
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 []
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 []
633899 October 01, 2019 - 17:08:36 UTC 35.64876 -118.84143 Bakersfield 2 []
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"}]
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 []
654655 October 11, 2019 - 22:38:13 UTC 35.43132 -118.86533 Bakersfield 2 []
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 []
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 []
706598 November 14, 2019 - 16:22:01 UTC 35.34685 -118.87256 Bakersfield 2 []
732598 December 07, 2019 - 19:18:56 UTC 35.30985 -118.87402 Bakersfield 2 []
705073 November 12, 2019 - 20:07:59 UTC 35.43122 -118.87426 Bakersfield 2 []
710826 November 20, 2019 - 15:26:01 UTC 35.43885 -118.87695 Bakersfield 2 []
712964 November 22, 2019 - 19:47:44 UTC 35.34746 -118.87717 Bakersfield 2 []
698308 November 02, 2019 - 21:30:04 UTC 35.29103 -118.87808 Bakersfield 2 []
737528 December 12, 2019 - 19:04:01 UTC 35.21006 -118.87819 Bakersfield 2 []
700026 November 05, 2019 - 18:45:01 UTC 35.2537 -118.87846 Bakersfield 2 []
731522 December 06, 2019 - 20:06:48 UTC 35.2537 -118.87846 Bakersfield 2 []
696387 October 31, 2019 - 14:39:04 UTC 35.25557 -118.87847 Bakersfield 2 []
680395 October 25, 2019 - 17:52:41 UTC 35.36174 -118.87906 Bakersfield 2 []
696803 October 31, 2019 - 19:52:55 UTC 35.29588 -118.87963 Bakersfield 2 []
700472 November 06, 2019 - 13:27:00 UTC 35.28166 -118.87979 Bakersfield 2 [{"latitude": "35.2561", "longitude": "-118.92487"}, {"latitude": "35.27599", "longitude": "-118.88042"}, {"latitude": "35.28101", "longitude": "-118.88038"}, {"latitude": "35.28161", "longitude": "-118.88038"}, {"latitude": "35.28358", "longitude": "-118.88318"}, {"latitude": "35.28528", "longitude": "-118.88651"}, {"latitude": "35.28568", "longitude": "-118.88752"}, {"latitude": "35.29161", "longitude": "-118.93215"}, {"latitude": "35.28143", "longitude": "-118.95833"}, {"latitude": "35.27145", "longitude": "-118.97536"}, {"latitude": "35.26745", "longitude": "-118.97536"}, {"latitude": "35.25963", "longitude": "-118.96139"}]
694638 October 30, 2019 - 04:00:00 UTC 35.45606 -118.88579 Bakersfield 2 [{"latitude": "35.45452", "longitude": "-118.87299"}, {"latitude": "35.4551", "longitude": "-118.87257"}, {"latitude": "35.45993", "longitude": "-118.87149"}, {"latitude": "35.4607", "longitude": "-118.87514"}]
653511 October 10, 2019 - 20:37:00 UTC 35.45605 -118.88595 Bakersfield 2 [{"latitude": "35.45452", "longitude": "-118.87299"}, {"latitude": "35.4551", "longitude": "-118.87257"}, {"latitude": "35.45993", "longitude": "-118.87149"}, {"latitude": "35.4607", "longitude": "-118.87514"}]
652838 October 10, 2019 - 17:06:00 UTC 35.47706 -118.88704 Bakersfield 2 [{"latitude": "35.48529", "longitude": "-118.88908"}, {"latitude": "35.48543", "longitude": "-118.88696"}, {"latitude": "35.48585", "longitude": "-118.89055"}]
694641 October 30, 2019 - 04:00:00 UTC 35.47706 -118.88704 Bakersfield 2 [{"latitude": "35.48529", "longitude": "-118.88908"}, {"latitude": "35.48543", "longitude": "-118.88696"}, {"latitude": "35.48585", "longitude": "-118.89055"}]
653522 October 10, 2019 - 17:06:00 UTC 35.4825 -118.88719 Bakersfield 2 []
694625 October 30, 2019 - 04:00:00 UTC 35.456 -118.89077 Bakersfield 2 [{"latitude": "35.46337", "longitude": "-118.88683"}, {"latitude": "35.46738", "longitude": "-118.88379"}, {"latitude": "35.48543", "longitude": "-118.88696"}, {"latitude": "35.48585", "longitude": "-118.89055"}]
653926 October 11, 2019 - 03:44:00 UTC 35.4115 -118.89178 Bakersfield 2 []
654481 October 11, 2019 - 20:23:00 UTC 35.4115 -118.89178 Bakersfield 2 []
654687 October 11, 2019 - 23:18:00 UTC 35.411 -118.89349 Bakersfield 2 []
704550 November 12, 2019 - 00:11:38 UTC 35.44171 -118.89631 Bakersfield 2 []
677645 October 23, 2019 - 18:18:00 UTC 35.29738 -118.89645 Bakersfield 2 [{"latitude": "35.2985", "longitude": "-118.89645"}, {"latitude": "35.30354", "longitude": "-118.89195"}, {"latitude": "35.30353", "longitude": "-118.89624"}, {"latitude": "35.30062", "longitude": "-118.89645"}]
642975 October 04, 2019 - 16:33:38 UTC 35.37385 -118.9005 Bakersfield 2 []
677578 October 23, 2019 - 18:18:57 UTC 35.3007 -118.90067 Bakersfield 2 []
652808 October 10, 2019 - 16:52:00 UTC 35.42221 -118.9007 Bakersfield 2 [{"latitude": "35.39619", "longitude": "-118.85642"}, {"latitude": "35.39825", "longitude": "-118.83467"}, {"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.44287", "longitude": "-118.85785"}, {"latitude": "35.43651", "longitude": "-118.87525"}, {"latitude": "35.41984", "longitude": "-118.89982"}, {"latitude": "35.4114", "longitude": "-118.90015"}, {"latitude": "35.41064", "longitude": "-118.90013"}, {"latitude": "35.39688", "longitude": "-118.86511"}]
731040 December 06, 2019 - 12:37:15 UTC 35.36524 -118.90212 Bakersfield 2 []
694777 October 30, 2019 - 14:42:28 UTC 35.33255 -118.90263 Bakersfield 2 []
696478 October 31, 2019 - 16:01:18 UTC 35.33255 -118.90263 Bakersfield 2 []
696736 October 31, 2019 - 19:01:18 UTC 35.32932 -118.90341 Bakersfield 2 []
779888 February 07, 2020 - 16:24:03 UTC 35.31068 -118.90468 Bakersfield 2 []
653529 October 10, 2019 - 17:18:00 UTC 35.49946 -118.90511 Bakersfield 2 [{"latitude": "35.49373", "longitude": "-118.86122"}, {"latitude": "35.51156", "longitude": "-118.88089"}, {"latitude": "35.5053", "longitude": "-118.89122"}, {"latitude": "35.50295", "longitude": "-118.89012"}]
694636 October 30, 2019 - 04:06:00 UTC 35.49946 -118.90511 Bakersfield 2 [{"latitude": "35.49373", "longitude": "-118.86122"}, {"latitude": "35.51156", "longitude": "-118.88089"}, {"latitude": "35.5053", "longitude": "-118.89122"}, {"latitude": "35.50295", "longitude": "-118.89012"}]
705997 November 13, 2019 - 17:43:33 UTC 35.32922 -118.90526 Bakersfield 2 []
733123 December 08, 2019 - 00:12:05 UTC 35.34531 -118.90537 Bakersfield 2 []
711300 November 20, 2019 - 17:25:30 UTC 35.36907 -118.90564 Bakersfield 2 [{"latitude": "35.36817", "longitude": "-118.90864"}, {"latitude": "35.36969", "longitude": "-118.90588"}, {"latitude": "35.37036", "longitude": "-118.90587"}, {"latitude": "35.37171", "longitude": "-118.90587"}, {"latitude": "35.37203", "longitude": "-118.9069"}, {"latitude": "35.37202", "longitude": "-118.90902"}, {"latitude": "35.36844", "longitude": "-118.90932"}]
645761 October 07, 2019 - 08:05:12 UTC 35.50023 -118.90614 Bakersfield 2 []
654997 October 12, 2019 - 09:44:40 UTC 35.50023 -118.90614 Bakersfield 2 []
744744 December 17, 2019 - 22:07:02 UTC 35.3661 -118.90682 Bakersfield 2 []
654266 October 11, 2019 - 16:41:39 UTC 35.40082 -118.90785 Bakersfield 2 []
680563 October 25, 2019 - 22:02:53 UTC 35.40082 -118.90785 Bakersfield 2 []
659293 October 15, 2019 - 18:20:24 UTC 35.34439 -118.90789 Bakersfield 2 []
711628 November 20, 2019 - 21:02:08 UTC 35.37135 -118.90794 Bakersfield 2 []
646137 October 07, 2019 - 18:44:49 UTC 35.37005 -118.90902 Bakersfield 2 []
737704 December 12, 2019 - 21:49:43 UTC 35.37005 -118.90902 Bakersfield 2 []
697858 November 01, 2019 - 22:41:59 UTC 35.34249 -118.90942 Bakersfield 2 []
704609 November 12, 2019 - 01:49:48 UTC 35.29027 -118.90973 Bakersfield 2 []
735733 December 10, 2019 - 21:04:23 UTC 35.37855 -118.91028 Bakersfield 2 []
675905 October 21, 2019 - 16:07:00 UTC 35.29026 -118.91124 Bakersfield 2 []
696390 October 31, 2019 - 14:48:01 UTC 35.3545 -118.9133 Bakersfield 2 []
711472 November 20, 2019 - 18:47:12 UTC 35.35624 -118.91341 Bakersfield 2 []
711704 November 20, 2019 - 22:23:53 UTC 35.37197 -118.91357 Bakersfield 2 []
711556 November 20, 2019 - 19:26:53 UTC 35.35665 -118.91405 Bakersfield 2 [{"latitude": "35.35624", "longitude": "-118.91341"}, {"latitude": "35.35723", "longitude": "-118.9146"}, {"latitude": "35.35722", "longitude": "-118.9147"}]
700482 November 06, 2019 - 14:01:13 UTC 35.28215 -118.91446 Bakersfield 2 []
713129 November 22, 2019 - 23:34:56 UTC 35.3442 -118.91527 Bakersfield 2 []
714041 November 25, 2019 - 09:58:12 UTC 35.38123 -118.91729 Bakersfield 2 []
695255 October 30, 2019 - 19:31:01 UTC 35.37513 -118.91831 Bakersfield 2 []
675983 October 21, 2019 - 16:45:50 UTC 35.39977 -118.91901 Bakersfield 2 []
670993 October 19, 2019 - 01:17:52 UTC 35.36925 -118.91914 Bakersfield 2 []
707908 November 15, 2019 - 23:37:48 UTC 35.36925 -118.91914 Bakersfield 2 []
694960 October 30, 2019 - 16:43:11 UTC 35.09332 -118.91983 Bakersfield 2 []
695148 October 30, 2019 - 18:18:59 UTC 35.09332 -118.91983 Bakersfield 2 []
696707 October 31, 2019 - 18:43:04 UTC 35.36661 -118.92144 Bakersfield 2 []
711462 November 20, 2019 - 18:41:15 UTC 35.36614 -118.92144 Bakersfield 2 []
714972 November 26, 2019 - 09:42:27 UTC 35.36948 -118.92341 Bakersfield 2 []
714976 November 26, 2019 - 11:03:10 UTC 35.36948 -118.92341 Bakersfield 2 []
786963 February 10, 2020 - 15:50:55 UTC 35.36948 -118.92341 Bakersfield 2 []
780285 February 07, 2020 - 23:27:17 UTC 35.3063 -118.9235 Bakersfield 2 []
711568 November 20, 2019 - 15:40:00 UTC 35.36183 -118.92377 Bakersfield 2 [{"latitude": "35.29621", "longitude": "-118.93214"}, {"latitude": "35.2997", "longitude": "-118.92389"}, {"latitude": "35.35352", "longitude": "-118.9156"}, {"latitude": "35.36052", "longitude": "-118.92383"}, {"latitude": "35.36115", "longitude": "-118.92642"}, {"latitude": "35.35918", "longitude": "-118.95817"}, {"latitude": "35.35626", "longitude": "-118.98437"}, {"latitude": "35.34935", "longitude": "-118.99195"}, {"latitude": "35.34787", "longitude": "-118.9935"}, {"latitude": "35.32734", "longitude": "-118.99387"}, {"latitude": "35.32239", "longitude": "-118.99366"}, {"latitude": "35.32156", "longitude": "-118.99258"}]
714971 November 26, 2019 - 09:36:00 UTC 35.36183 -118.92385 Bakersfield 2 [{"latitude": "35.3621", "longitude": "-118.9255"}, {"latitude": "35.37385", "longitude": "-118.9005"}, {"latitude": "35.37489", "longitude": "-118.90038"}, {"latitude": "35.3823", "longitude": "-118.90052"}, {"latitude": "35.3827", "longitude": "-118.90372"}, {"latitude": "35.38285", "longitude": "-118.90669"}, {"latitude": "35.38096", "longitude": "-118.94157"}, {"latitude": "35.37868", "longitude": "-118.9458"}, {"latitude": "35.37769", "longitude": "-118.94694"}, {"latitude": "35.36819", "longitude": "-118.94336"}, {"latitude": "35.36547", "longitude": "-118.94022"}]

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