outages

1,578 rows where regionName = 2 sorted by latitude

View and edit SQL

id outageStartTime latitude ▼ longitude regionName outageDevices
710844 November 20, 2019 - 15:38:20 UTC 34.97524 -118.95184 Bakersfield 2 []
730701 December 05, 2019 - 21:37:23 UTC 35.00386 -118.94746 Bakersfield 2 []
737689 December 12, 2019 - 21:30:03 UTC 35.01001 -119.01595 Bakersfield 2 []
695151 October 30, 2019 - 18:19:04 UTC 35.01179 -118.9641 Bakersfield 2 []
695507 October 30, 2019 - 21:45:45 UTC 35.01665 -119.01783 Bakersfield 2 []
744621 December 17, 2019 - 20:44:24 UTC 35.01665 -119.01783 Bakersfield 2 []
694952 October 30, 2019 - 16:41:10 UTC 35.02621 -118.96283 Bakersfield 2 []
694957 October 30, 2019 - 16:41:48 UTC 35.02696 -118.99581 Bakersfield 2 [{"latitude": "35.0035", "longitude": "-119.0308"}, {"latitude": "35.00993", "longitude": "-119.00777"}, {"latitude": "35.02632", "longitude": "-119.00039"}, {"latitude": "35.01631", "longitude": "-119.02971"}, {"latitude": "35.0074", "longitude": "-119.03496"}]
744475 December 17, 2019 - 18:42:07 UTC 35.02734 -118.9937 Bakersfield 2 []
695508 October 30, 2019 - 21:45:45 UTC 35.0384 -118.97549 Bakersfield 2 []
695153 October 30, 2019 - 18:19:09 UTC 35.04152 -118.96243 Bakersfield 2 [{"latitude": "35.03757", "longitude": "-118.97543"}, {"latitude": "35.04131", "longitude": "-118.96316"}, {"latitude": "35.04847", "longitude": "-118.97191"}, {"latitude": "35.04843", "longitude": "-118.9759"}, {"latitude": "35.0482", "longitude": "-118.98786"}, {"latitude": "35.04421", "longitude": "-118.9861"}]
744023 December 17, 2019 - 15:09:25 UTC 35.04763 -119.02958 Bakersfield 2 [{"latitude": "35.03423", "longitude": "-119.04027"}, {"latitude": "35.03437", "longitude": "-119.03834"}, {"latitude": "35.04478", "longitude": "-119.02954"}, {"latitude": "35.04849", "longitude": "-119.03829"}]
744876 December 18, 2019 - 00:02:36 UTC 35.04763 -119.02958 Bakersfield 2 [{"latitude": "35.03423", "longitude": "-119.04027"}, {"latitude": "35.03437", "longitude": "-119.03834"}, {"latitude": "35.04478", "longitude": "-119.02954"}, {"latitude": "35.04849", "longitude": "-119.03829"}]
695149 October 30, 2019 - 18:19:01 UTC 35.05187 -118.9582 Bakersfield 2 []
695503 October 30, 2019 - 21:45:02 UTC 35.05187 -118.9582 Bakersfield 2 []
696308 October 31, 2019 - 09:18:26 UTC 35.05446 -118.94848 Bakersfield 2 []
744716 December 17, 2019 - 21:54:52 UTC 35.05446 -118.94848 Bakersfield 2 []
643683 October 04, 2019 - 20:22:33 UTC 35.055 -119.02927 Bakersfield 2 []
744623 December 17, 2019 - 20:44:36 UTC 35.05564 -119.03375 Bakersfield 2 []
695155 October 30, 2019 - 18:19:15 UTC 35.05878 -118.96726 Bakersfield 2 []
744664 December 17, 2019 - 21:18:17 UTC 35.05901 -118.96737 Bakersfield 2 []
744588 December 17, 2019 - 20:10:00 UTC 35.05949 -118.97798 Bakersfield 2 [{"latitude": "34.98089", "longitude": "-118.96716"}, {"latitude": "35.00813", "longitude": "-118.95667"}, {"latitude": "35.0268", "longitude": "-118.95898"}, {"latitude": "35.06225", "longitude": "-118.98666"}, {"latitude": "35.06892", "longitude": "-118.99681"}, {"latitude": "35.06892", "longitude": "-118.99708"}, {"latitude": "35.06157", "longitude": "-119.04965"}, {"latitude": "35.05916", "longitude": "-119.06018"}, {"latitude": "35.0074", "longitude": "-119.03496"}, {"latitude": "35.0035", "longitude": "-119.0308"}, {"latitude": "34.98686", "longitude": "-119.00232"}]
744647 December 17, 2019 - 20:39:00 UTC 35.05949 -118.97798 Bakersfield 2 [{"latitude": "34.98089", "longitude": "-118.96716"}, {"latitude": "35.00813", "longitude": "-118.95667"}, {"latitude": "35.0268", "longitude": "-118.95898"}, {"latitude": "35.06225", "longitude": "-118.98666"}, {"latitude": "35.06892", "longitude": "-118.99681"}, {"latitude": "35.06892", "longitude": "-118.99708"}, {"latitude": "35.06157", "longitude": "-119.04965"}, {"latitude": "35.05916", "longitude": "-119.06018"}, {"latitude": "35.0074", "longitude": "-119.03496"}, {"latitude": "35.0035", "longitude": "-119.0308"}, {"latitude": "34.98686", "longitude": "-119.00232"}]
744699 December 17, 2019 - 21:41:00 UTC 35.05949 -118.97798 Bakersfield 2 [{"latitude": "34.98089", "longitude": "-118.96716"}, {"latitude": "35.00813", "longitude": "-118.95667"}, {"latitude": "35.0268", "longitude": "-118.95898"}, {"latitude": "35.06225", "longitude": "-118.98666"}, {"latitude": "35.06892", "longitude": "-118.99681"}, {"latitude": "35.06892", "longitude": "-118.99708"}, {"latitude": "35.06157", "longitude": "-119.04965"}, {"latitude": "35.05916", "longitude": "-119.06018"}, {"latitude": "35.0074", "longitude": "-119.03496"}, {"latitude": "35.0035", "longitude": "-119.0308"}, {"latitude": "34.98686", "longitude": "-119.00232"}]
744740 December 17, 2019 - 21:48:00 UTC 35.05949 -118.97798 Bakersfield 2 [{"latitude": "34.98089", "longitude": "-118.96716"}, {"latitude": "35.00813", "longitude": "-118.95667"}, {"latitude": "35.0268", "longitude": "-118.95898"}, {"latitude": "35.06225", "longitude": "-118.98666"}, {"latitude": "35.06892", "longitude": "-118.99681"}, {"latitude": "35.06892", "longitude": "-118.99708"}, {"latitude": "35.06157", "longitude": "-119.04965"}, {"latitude": "35.05916", "longitude": "-119.06018"}, {"latitude": "35.0074", "longitude": "-119.03496"}, {"latitude": "35.0035", "longitude": "-119.0308"}, {"latitude": "34.98686", "longitude": "-119.00232"}]
695517 October 30, 2019 - 21:49:05 UTC 35.05964 -119.00585 Bakersfield 2 []
790527 February 13, 2020 - 21:50:12 UTC 35.05995 -118.92733 Bakersfield 2 []
694966 October 30, 2019 - 16:44:38 UTC 35.06019 -119.00561 Bakersfield 2 []
695161 October 30, 2019 - 18:21:44 UTC 35.06134 -118.94959 Bakersfield 2 []
744622 December 17, 2019 - 20:44:34 UTC 35.06216 -119.00258 Bakersfield 2 []
696045 October 31, 2019 - 01:25:09 UTC 35.06237 -118.95687 Bakersfield 2 []
650772 October 09, 2019 - 15:50:24 UTC 35.06962 -119.10893 Bakersfield 2 []
695571 October 30, 2019 - 22:10:42 UTC 35.07533 -118.93226 Bakersfield 2 []
744717 December 17, 2019 - 21:55:03 UTC 35.07617 -118.97551 Bakersfield 2 []
790663 February 14, 2020 - 02:07:23 UTC 35.07626 -118.98411 Bakersfield 2 []
744714 December 17, 2019 - 21:54:47 UTC 35.07687 -118.97569 Bakersfield 2 [{"latitude": "35.07733", "longitude": "-118.9756"}, {"latitude": "35.0774", "longitude": "-118.97506"}, {"latitude": "35.07998", "longitude": "-118.97691"}]
738441 December 13, 2019 - 18:21:00 UTC 35.07733 -118.9756 Bakersfield 2 []
695152 October 30, 2019 - 18:19:09 UTC 35.0774 -118.97506 Bakersfield 2 []
738821 December 14, 2019 - 03:05:00 UTC 35.0774 -118.97506 Bakersfield 2 []
738571 December 13, 2019 - 20:43:11 UTC 35.07879 -118.97417 Bakersfield 2 [{"latitude": "35.07889", "longitude": "-118.97391"}, {"latitude": "35.07914", "longitude": "-118.97269"}, {"latitude": "35.07912", "longitude": "-118.97343"}]
694955 October 30, 2019 - 16:41:48 UTC 35.08022 -118.96814 Bakersfield 2 []
778694 February 05, 2020 - 22:43:59 UTC 35.08401 -119.00303 Bakersfield 2 []
652879 October 10, 2019 - 17:33:00 UTC 35.08906 -118.97666 Bakersfield 2 [{"latitude": "34.98089", "longitude": "-118.96716"}, {"latitude": "35.0325", "longitude": "-118.94709"}, {"latitude": "35.06081", "longitude": "-118.9441"}, {"latitude": "35.08263", "longitude": "-118.95805"}, {"latitude": "35.08628", "longitude": "-118.96808"}, {"latitude": "35.08973", "longitude": "-119.00367"}, {"latitude": "35.08979", "longitude": "-119.01173"}, {"latitude": "35.08979", "longitude": "-119.01236"}, {"latitude": "35.08346", "longitude": "-119.02903"}, {"latitude": "35.05916", "longitude": "-119.06018"}, {"latitude": "35.0074", "longitude": "-119.03496"}, {"latitude": "35.0035", "longitude": "-119.0308"}, {"latitude": "34.98686", "longitude": "-119.00232"}]
744061 December 17, 2019 - 15:31:00 UTC 35.08906 -118.97666 Bakersfield 2 [{"latitude": "34.98089", "longitude": "-118.96716"}, {"latitude": "35.0325", "longitude": "-118.94709"}, {"latitude": "35.06081", "longitude": "-118.9441"}, {"latitude": "35.08263", "longitude": "-118.95805"}, {"latitude": "35.08628", "longitude": "-118.96808"}, {"latitude": "35.08973", "longitude": "-119.00367"}, {"latitude": "35.08979", "longitude": "-119.01173"}, {"latitude": "35.08979", "longitude": "-119.01236"}, {"latitude": "35.08346", "longitude": "-119.02903"}, {"latitude": "35.05916", "longitude": "-119.06018"}, {"latitude": "35.0074", "longitude": "-119.03496"}, {"latitude": "35.0035", "longitude": "-119.0308"}, {"latitude": "34.98686", "longitude": "-119.00232"}]
744402 December 17, 2019 - 18:03:00 UTC 35.08906 -118.97666 Bakersfield 2 [{"latitude": "34.98089", "longitude": "-118.96716"}, {"latitude": "35.0325", "longitude": "-118.94709"}, {"latitude": "35.06081", "longitude": "-118.9441"}, {"latitude": "35.08263", "longitude": "-118.95805"}, {"latitude": "35.08628", "longitude": "-118.96808"}, {"latitude": "35.08973", "longitude": "-119.00367"}, {"latitude": "35.08979", "longitude": "-119.01173"}, {"latitude": "35.08979", "longitude": "-119.01236"}, {"latitude": "35.08346", "longitude": "-119.02903"}, {"latitude": "35.05916", "longitude": "-119.06018"}, {"latitude": "35.0074", "longitude": "-119.03496"}, {"latitude": "35.0035", "longitude": "-119.0308"}, {"latitude": "34.98686", "longitude": "-119.00232"}]
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 []
652845 October 10, 2019 - 17:13:00 UTC 35.09349 -119.10118 Bakersfield 2 [{"latitude": "34.99612", "longitude": "-119.08841"}, {"latitude": "35.00136", "longitude": "-119.06026"}, {"latitude": "35.07272", "longitude": "-119.03824"}, {"latitude": "35.07653", "longitude": "-119.03751"}, {"latitude": "35.08366", "longitude": "-119.03825"}, {"latitude": "35.11534", "longitude": "-119.0744"}, {"latitude": "35.11059", "longitude": "-119.09205"}, {"latitude": "35.06941", "longitude": "-119.11395"}, {"latitude": "35.0369", "longitude": "-119.1178"}, {"latitude": "35.03391", "longitude": "-119.11786"}]
790232 February 13, 2020 - 17:07:14 UTC 35.09437 -119.23526 Bakersfield 2 []
705771 November 13, 2019 - 15:27:41 UTC 35.09553 -118.9869 Bakersfield 2 []
705769 November 13, 2019 - 15:25:39 UTC 35.09637 -118.98541 Bakersfield 2 [{"latitude": "35.10071", "longitude": "-118.98728"}, {"latitude": "35.10071", "longitude": "-118.98678"}, {"latitude": "35.10124", "longitude": "-118.98544"}, {"latitude": "35.10188", "longitude": "-118.98544"}, {"latitude": "35.10253", "longitude": "-118.98673"}]
744186 December 17, 2019 - 16:23:57 UTC 35.12002 -119.01234 Bakersfield 2 []
695501 October 30, 2019 - 21:45:02 UTC 35.1221 -118.96959 Bakersfield 2 []
693528 October 29, 2019 - 17:01:30 UTC 35.12227 -119.0123 Bakersfield 2 []
695360 October 30, 2019 - 20:31:20 UTC 35.12908 -118.99593 Bakersfield 2 []
699314 November 04, 2019 - 19:44:18 UTC 35.12934 -119.10061 Bakersfield 2 []
789663 February 12, 2020 - 21:27:49 UTC 35.1316 -118.94122 Bakersfield 2 []
744688 December 17, 2019 - 21:31:14 UTC 35.13297 -118.9769 Bakersfield 2 []
694953 October 30, 2019 - 16:41:10 UTC 35.1366 -118.9588 Bakersfield 2 []
652962 October 10, 2019 - 18:13:47 UTC 35.13748 -119.20782 Bakersfield 2 []
699313 November 04, 2019 - 19:44:12 UTC 35.1389 -119.07524 Bakersfield 2 []
697278 November 01, 2019 - 15:10:22 UTC 35.13965 -119.19891 Bakersfield 2 []
694961 October 30, 2019 - 16:43:11 UTC 35.14328 -118.96823 Bakersfield 2 []
695499 October 30, 2019 - 21:45:02 UTC 35.14328 -118.96823 Bakersfield 2 []
700982 November 06, 2019 - 20:22:14 UTC 35.1464 -118.99643 Bakersfield 2 [{"latitude": "35.14533", "longitude": "-118.99726"}, {"latitude": "35.14652", "longitude": "-118.99794"}, {"latitude": "35.14652", "longitude": "-118.9984"}, {"latitude": "35.1465", "longitude": "-119.00009"}, {"latitude": "35.14567", "longitude": "-119.00023"}]
710076 November 19, 2019 - 18:31:22 UTC 35.15083 -119.23476 Bakersfield 2 []
675195 October 21, 2019 - 14:50:35 UTC 35.1515 -119.02165 Bakersfield 2 []
696500 October 31, 2019 - 16:16:18 UTC 35.1515 -119.02165 Bakersfield 2 []
696981 October 31, 2019 - 22:49:43 UTC 35.1515 -119.02165 Bakersfield 2 []
697265 November 01, 2019 - 14:46:36 UTC 35.1519 -119.20644 Bakersfield 2 []
703775 November 10, 2019 - 05:45:54 UTC 35.15804 -118.9718 Bakersfield 2 []
703774 November 10, 2019 - 05:37:17 UTC 35.15805 -118.97048 Bakersfield 2 []
729618 December 04, 2019 - 17:52:30 UTC 35.15852 -119.03941 Bakersfield 2 []
710830 November 20, 2019 - 15:29:00 UTC 35.17725 -119.02374 Bakersfield 2 []
655584 October 13, 2019 - 18:43:20 UTC 35.17925 -118.96843 Bakersfield 2 []
713803 November 24, 2019 - 17:58:33 UTC 35.18043 -119.18161 Bakersfield 2 [{"latitude": "35.18962", "longitude": "-119.18184"}, {"latitude": "35.18973", "longitude": "-119.18125"}, {"latitude": "35.20098", "longitude": "-119.17912"}, {"latitude": "35.20157", "longitude": "-119.18142"}, {"latitude": "35.20166", "longitude": "-119.18915"}]
642713 October 04, 2019 - 15:24:00 UTC 35.18337 -119.10982 Bakersfield 2 []
642387 October 04, 2019 - 15:32:16 UTC 35.19398 -119.02149 Bakersfield 2 []
710643 November 20, 2019 - 14:03:02 UTC 35.19398 -119.01998 Bakersfield 2 []
710644 November 20, 2019 - 14:03:02 UTC 35.19398 -119.02149 Bakersfield 2 []
726250 December 01, 2019 - 23:14:50 UTC 35.19691 -119.00589 Bakersfield 2 []
642275 October 04, 2019 - 15:08:11 UTC 35.19793 -119.02043 Bakersfield 2 []
714775 November 26, 2019 - 00:07:48 UTC 35.20136 -119.10169 Bakersfield 2 []
680132 October 25, 2019 - 00:51:40 UTC 35.20155 -119.09214 Bakersfield 2 []
642633 October 04, 2019 - 15:48:37 UTC 35.20178 -119.02098 Bakersfield 2 []
680131 October 25, 2019 - 00:52:20 UTC 35.20333 -119.08606 Bakersfield 2 []
713766 November 24, 2019 - 16:43:24 UTC 35.20545 -119.17106 Bakersfield 2 []
680129 October 25, 2019 - 00:52:17 UTC 35.20779 -119.0857 Bakersfield 2 []
680130 October 25, 2019 - 00:52:18 UTC 35.20779 -119.08641 Bakersfield 2 []
711705 November 20, 2019 - 22:23:56 UTC 35.20842 -119.14175 Bakersfield 2 []
713304 November 23, 2019 - 15:19:32 UTC 35.20842 -119.14175 Bakersfield 2 []
643917 October 05, 2019 - 13:21:36 UTC 35.20849 -119.04166 Bakersfield 2 [{"latitude": "35.16883", "longitude": "-119.03055"}, {"latitude": "35.17362", "longitude": "-119.02049"}, {"latitude": "35.19409", "longitude": "-118.98562"}, {"latitude": "35.2085", "longitude": "-118.98444"}, {"latitude": "35.23723", "longitude": "-118.98552"}, {"latitude": "35.23771", "longitude": "-118.98568"}, {"latitude": "35.24104", "longitude": "-118.98782"}, {"latitude": "35.24443", "longitude": "-119.00008"}, {"latitude": "35.24424", "longitude": "-119.00282"}, {"latitude": "35.23788", "longitude": "-119.01497"}, {"latitude": "35.23303", "longitude": "-119.02059"}, {"latitude": "35.23234", "longitude": "-119.02135"}, {"latitude": "35.20812", "longitude": "-119.03906"}, {"latitude": "35.20538", "longitude": "-119.04055"}, {"latitude": "35.18708", "longitude": "-119.04783"}, {"latitude": "35.18354", "longitude": "-119.04814"}, {"latitude": "35.17957", "longitude": "-119.04681"}, {"latitude": "35.17213", "longitude": "-119.04068"}]
735117 December 10, 2019 - 14:59:48 UTC 35.20898 -119.14161 Bakersfield 2 [{"latitude": "35.20203", "longitude": "-119.14129"}, {"latitude": "35.20325", "longitude": "-119.13728"}, {"latitude": "35.20842", "longitude": "-119.14175"}, {"latitude": "35.2024", "longitude": "-119.14155"}]
737528 December 12, 2019 - 19:04:01 UTC 35.21006 -118.87819 Bakersfield 2 []
676446 October 21, 2019 - 22:02:00 UTC 35.21008 -119.21676 Bakersfield 2 []
721365 November 27, 2019 - 19:29:07 UTC 35.21265 -119.19897 Bakersfield 2 []
659433 October 15, 2019 - 18:41:35 UTC 35.21986 -118.95633 Bakersfield 2 []
711860 November 21, 2019 - 02:27:15 UTC 35.22122 -119.01832 Bakersfield 2 []
710879 November 20, 2019 - 15:52:58 UTC 35.22312 -119.00349 Bakersfield 2 [{"latitude": "35.2099", "longitude": "-119.02144"}, {"latitude": "35.22312", "longitude": "-119.00355"}, {"latitude": "35.22994", "longitude": "-119.01478"}, {"latitude": "35.23303", "longitude": "-119.02059"}, {"latitude": "35.23234", "longitude": "-119.02135"}, {"latitude": "35.22255", "longitude": "-119.02219"}]
654659 October 11, 2019 - 22:40:20 UTC 35.22321 -119.00928 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 472.714ms · About: About this site