5,012 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 []
1198025 December 24, 2020 - 06:28:41 UTC 34.97524 -118.95184 Bakersfield 2 []
1255824 February 16, 2021 - 18:48:01 UTC 34.97524 -118.95184 Bakersfield 2 []
1247449 February 04, 2021 - 02:15:47 UTC 34.9929 -118.95001 Bakersfield 2 []
1257904 February 19, 2021 - 19:04:20 UTC 34.99388 -118.96674 Bakersfield 2 [{"latitude": "34.98686", "longitude": "-119.00232"}, {"latitude": "34.98781", "longitude": "-118.99257"}, {"latitude": "34.99432", "longitude": "-118.9694"}, {"latitude": "35.00422", "longitude": "-118.98748"}, {"latitude": "34.99843", "longitude": "-118.994"}]
1122124 October 21, 2020 - 16:02:00 UTC 34.99448 -118.94836 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 []
1095085 September 27, 2020 - 15:56:29 UTC 35.01566 -118.93739 Bakersfield 2 []
1241357 January 29, 2021 - 17:30:00 UTC 35.01627 -119.02959 Bakersfield 2 []
1238908 January 28, 2021 - 07:44:00 UTC 35.01653 -119.01802 Bakersfield 2 [{"latitude": "35.0035", "longitude": "-119.0308"}, {"latitude": "35.01522", "longitude": "-119.01981"}, {"latitude": "35.01631", "longitude": "-119.02971"}, {"latitude": "35.0074", "longitude": "-119.03496"}]
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 []
1094955 September 27, 2020 - 11:50:39 UTC 35.01824 -118.98092 Bakersfield 2 []
1217889 January 20, 2021 - 02:17:10 UTC 35.01824 -118.98092 Bakersfield 2 []
1221541 January 23, 2021 - 08:18:00 UTC 35.01979 -118.9547 Bakersfield 2 [{"latitude": "35.02489", "longitude": "-118.94887"}, {"latitude": "35.03128", "longitude": "-118.88137"}, {"latitude": "35.04748", "longitude": "-118.85551"}, {"latitude": "35.06369", "longitude": "-118.87761"}, {"latitude": "35.06685", "longitude": "-118.89073"}, {"latitude": "35.06798", "longitude": "-118.94406"}, {"latitude": "35.04727", "longitude": "-118.9485"}, {"latitude": "35.025", "longitude": "-118.94976"}]
1094806 September 27, 2020 - 10:20:00 UTC 35.0198 -118.95475 Bakersfield 2 [{"latitude": "34.99284", "longitude": "-118.83383"}, {"latitude": "35.02193", "longitude": "-118.74101"}, {"latitude": "35.02609", "longitude": "-118.73318"}, {"latitude": "35.04987", "longitude": "-118.76881"}, {"latitude": "35.02665", "longitude": "-118.95505"}, {"latitude": "35.01904", "longitude": "-118.95349"}, {"latitude": "35.01267", "longitude": "-118.93946"}, {"latitude": "34.99287", "longitude": "-118.85525"}]
1247327 February 03, 2021 - 23:25:00 UTC 35.0198 -118.95482 Bakersfield 2 [{"latitude": "34.82448", "longitude": "-118.85467"}, {"latitude": "34.94655", "longitude": "-118.82741"}, {"latitude": "35.01918", "longitude": "-118.95485"}, {"latitude": "35.01921", "longitude": "-118.95506"}, {"latitude": "34.96251", "longitude": "-118.97213"}, {"latitude": "34.94926", "longitude": "-118.97088"}, {"latitude": "34.88866", "longitude": "-118.94907"}, {"latitude": "34.84129", "longitude": "-118.91143"}, {"latitude": "34.82682", "longitude": "-118.88576"}, {"latitude": "34.82645", "longitude": "-118.88457"}, {"latitude": "34.82531", "longitude": "-118.87887"}]
1097938 September 29, 2020 - 15:54:57 UTC 35.02142 -118.94374 Bakersfield 2 []
1247302 February 03, 2021 - 23:25:26 UTC 35.02142 -118.94374 Bakersfield 2 []
1198228 December 24, 2020 - 19:54:11 UTC 35.02615 -118.99452 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"}]
1238115 January 28, 2021 - 07:44:49 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"}]
1115592 October 12, 2020 - 14:33:28 UTC 35.02732 -118.98458 Bakersfield 2 []
1256680 February 17, 2021 - 21:03:31 UTC 35.02732 -118.98458 Bakersfield 2 []
744475 December 17, 2019 - 18:42:07 UTC 35.02734 -118.9937 Bakersfield 2 []
1267986 March 04, 2021 - 21:09:39 UTC 35.02734 -118.9937 Bakersfield 2 []
1146525 November 17, 2020 - 00:18:02 UTC 35.0325 -118.94709 Bakersfield 2 []
1216414 January 19, 2021 - 18:23:54 UTC 35.03315 -118.94787 Bakersfield 2 []
1264257 February 28, 2021 - 22:17:03 UTC 35.03315 -118.94787 Bakersfield 2 []
1198227 December 24, 2020 - 19:50:29 UTC 35.03423 -119.04027 Bakersfield 2 []
695508 October 30, 2019 - 21:45:45 UTC 35.0384 -118.97549 Bakersfield 2 []
1264255 February 28, 2021 - 22:16:56 UTC 35.0384 -118.97549 Bakersfield 2 []
1321718 April 18, 2021 - 15:34:22 UTC 35.0384 -118.97549 Bakersfield 2 []
1238779 January 28, 2021 - 15:49:35 UTC 35.04126 -118.96405 Bakersfield 2 []
1336088 April 28, 2021 - 17:14:01 UTC 35.04137 -118.98967 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"}]
1132264 October 30, 2020 - 18:49:59 UTC 35.04727 -118.9485 Bakersfield 2 []
1293793 March 23, 2021 - 18:09:26 UTC 35.04727 -118.9485 Bakersfield 2 []
1305626 April 02, 2021 - 15:47:15 UTC 35.04727 -118.9485 Bakersfield 2 []
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 []
1257022 February 18, 2021 - 15:07:47 UTC 35.05272 -118.91804 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 []
1216413 January 19, 2021 - 18:23:54 UTC 35.05446 -118.94848 Bakersfield 2 []
1264256 February 28, 2021 - 22:17:01 UTC 35.05446 -118.94848 Bakersfield 2 []
643683 October 04, 2019 - 20:22:33 UTC 35.055 -119.02927 Bakersfield 2 []
1320432 April 17, 2021 - 01:45:08 UTC 35.05504 -119.02927 Bakersfield 2 []
1264260 February 28, 2021 - 22:17:11 UTC 35.05539 -119.03867 Bakersfield 2 []
744623 December 17, 2019 - 20:44:36 UTC 35.05564 -119.03375 Bakersfield 2 []
1264259 February 28, 2021 - 22:17:15 UTC 35.05564 -119.03375 Bakersfield 2 []
1296004 March 24, 2021 - 20:16:55 UTC 35.0587 -119.1396 Bakersfield 2 []
1298608 March 26, 2021 - 15:11:31 UTC 35.0587 -119.1396 Bakersfield 2 []
695155 October 30, 2019 - 18:19:15 UTC 35.05878 -118.96726 Bakersfield 2 []
1216415 January 19, 2021 - 18:23:54 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 []
1204350 January 05, 2021 - 16:05:52 UTC 35.06839 -119.12967 Bakersfield 2 []
1242304 January 30, 2021 - 00:54:10 UTC 35.06908 -118.95746 Bakersfield 2 []
1090702 September 24, 2020 - 00:46:52 UTC 35.06958 -119.2325 Bakersfield 2 []
650772 October 09, 2019 - 15:50:24 UTC 35.06962 -119.10893 Bakersfield 2 []
1238368 January 28, 2021 - 11:16:35 UTC 35.06968 -119.01119 Bakersfield 2 []
1219048 January 20, 2021 - 22:22:00 UTC 35.07061 -118.97405 Bakersfield 2 [{"latitude": "35.05308", "longitude": "-118.94851"}, {"latitude": "35.06081", "longitude": "-118.9441"}, {"latitude": "35.07998", "longitude": "-118.97691"}, {"latitude": "35.06954", "longitude": "-118.97585"}, {"latitude": "35.06231", "longitude": "-118.96868"}]
1112031 October 06, 2020 - 17:48:13 UTC 35.07485 -119.18053 Bakersfield 2 []
695571 October 30, 2019 - 22:10:42 UTC 35.07533 -118.93226 Bakersfield 2 []
1280280 March 12, 2021 - 19:16:07 UTC 35.07571 -118.95432 Bakersfield 2 [{"latitude": "35.07439", "longitude": "-118.90833"}, {"latitude": "35.08468", "longitude": "-118.92628"}, {"latitude": "35.0852", "longitude": "-118.93516"}, {"latitude": "35.08453", "longitude": "-118.93655"}, {"latitude": "35.07539", "longitude": "-118.94938"}, {"latitude": "35.07514", "longitude": "-118.94538"}, {"latitude": "35.07448", "longitude": "-118.93031"}]
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 []
1264258 February 28, 2021 - 22:16:59 UTC 35.07647 -119.02939 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 []
1061766 September 09, 2020 - 13:40:43 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"}]
1289036 March 19, 2021 - 18:49:00 UTC 35.0801 -118.92176 Bakersfield 2 []
694955 October 30, 2019 - 16:41:48 UTC 35.08022 -118.96814 Bakersfield 2 []
1216411 January 19, 2021 - 18:23:54 UTC 35.08022 -118.96814 Bakersfield 2 []
1233705 January 27, 2021 - 15:50:07 UTC 35.08324 -118.98444 Bakersfield 2 []
1241228 January 29, 2021 - 16:40:43 UTC 35.08327 -118.99456 Bakersfield 2 []
1252767 February 11, 2021 - 15:24:02 UTC 35.08327 -118.99456 Bakersfield 2 []
1333915 April 26, 2021 - 14:39:36 UTC 35.08342 -118.94808 Bakersfield 2 []
1333829 April 26, 2021 - 11:17:38 UTC 35.08367 -119.20813 Bakersfield 2 []
778694 February 05, 2020 - 22:43:59 UTC 35.08401 -119.00303 Bakersfield 2 []
1141727 November 11, 2020 - 15:53:01 UTC 35.08446 -119.10948 Bakersfield 2 []
1236059 January 27, 2021 - 22:23:00 UTC 35.08905 -118.97666 Bakersfield 2 [{"latitude": "35.09118", "longitude": "-119.03186"}, {"latitude": "35.09174", "longitude": "-118.97814"}, {"latitude": "35.09342", "longitude": "-118.97723"}, {"latitude": "35.10833", "longitude": "-118.97659"}, {"latitude": "35.13644", "longitude": "-118.97663"}, {"latitude": "35.13951", "longitude": "-118.97664"}, {"latitude": "35.17949", "longitude": "-118.99445"}, {"latitude": "35.20119", "longitude": "-119.00415"}, {"latitude": "35.2018", "longitude": "-119.00443"}, {"latitude": "35.20299", "longitude": "-119.00624"}, {"latitude": "35.2027", "longitude": "-119.00752"}, {"latitude": "35.15852", "longitude": "-119.03941"}, {"latitude": "35.12362", "longitude": "-119.05619"}, {"latitude": "35.095", "longitude": "-119.05502"}, {"latitude": "35.09189", "longitude": "-119.04668"}, {"latitude": "35.09118", "longitude": "-119.03261"}]

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