outages

1,776 rows where regionName = 2 sorted by outageStartTime descending

View and edit SQL

id outageStartTime ▲ latitude longitude regionName outageDevices
1088199 September 22, 2020 - 21:38:48 UTC 35.23709 -119.06436 Bakersfield 2 []
1088196 September 22, 2020 - 21:30:25 UTC 35.36132 -118.95197 Bakersfield 2 []
1088162 September 22, 2020 - 20:47:02 UTC 35.30719 -119.0054 Bakersfield 2 []
1087576 September 22, 2020 - 18:13:42 UTC 35.41189 -118.88937 Bakersfield 2 []
1087518 September 22, 2020 - 17:54:49 UTC 35.38994 -118.99424 Bakersfield 2 []
1087177 September 22, 2020 - 17:21:39 UTC 35.36929 -118.928 Bakersfield 2 []
1087904 September 22, 2020 - 17:21:39 UTC 35.36868 -118.92958 Bakersfield 2 [{"latitude": "35.36718", "longitude": "-118.92882"}, {"latitude": "35.3693", "longitude": "-118.92708"}, {"latitude": "35.36928", "longitude": "-118.92933"}, {"latitude": "35.36784", "longitude": "-118.92984"}, {"latitude": "35.36725", "longitude": "-118.9297"}]
1086873 September 22, 2020 - 16:28:19 UTC 35.40645 -118.96654 Bakersfield 2 []
1086842 September 22, 2020 - 16:09:07 UTC 35.39153 -119.08709 Bakersfield 2 []
1086734 September 22, 2020 - 15:12:54 UTC 35.34822 -119.04022 Bakersfield 2 [{"latitude": "35.34822", "longitude": "-119.04074"}, {"latitude": "35.34822", "longitude": "-119.04031"}, {"latitude": "35.34823", "longitude": "-119.04211"}, {"latitude": "35.34822", "longitude": "-119.04151"}]
1086636 September 22, 2020 - 15:04:05 UTC 35.30605 -119.01826 Bakersfield 2 []
1086376 September 22, 2020 - 14:29:05 UTC 35.33663 -119.02491 Bakersfield 2 []
1086285 September 22, 2020 - 10:31:10 UTC 35.33951 -118.99183 Bakersfield 2 []
1086089 September 21, 2020 - 23:50:52 UTC 35.38081 -119.14981 Bakersfield 2 []
1086030 September 21, 2020 - 22:56:45 UTC 35.39823 -119.0132 Bakersfield 2 []
1086029 September 21, 2020 - 22:55:18 UTC 35.17003 -119.1058 Bakersfield 2 []
1085936 September 21, 2020 - 22:22:51 UTC 35.20827 -119.10091 Bakersfield 2 [{"latitude": "35.12238", "longitude": "-119.14591"}, {"latitude": "35.17271", "longitude": "-119.0663"}, {"latitude": "35.17611", "longitude": "-119.06635"}, {"latitude": "35.20507", "longitude": "-119.10167"}, {"latitude": "35.20873", "longitude": "-119.11003"}, {"latitude": "35.20166", "longitude": "-119.18915"}, {"latitude": "35.18756", "longitude": "-119.23611"}, {"latitude": "35.17337", "longitude": "-119.236"}, {"latitude": "35.1519", "longitude": "-119.20644"}]
1085933 September 21, 2020 - 22:17:33 UTC 35.38018 -119.00757 Bakersfield 2 []
1085733 September 21, 2020 - 21:52:12 UTC 35.40317 -118.9604 Bakersfield 2 []
1085254 September 21, 2020 - 19:46:57 UTC 35.37009 -118.94237 Bakersfield 2 []
1084941 September 21, 2020 - 19:01:58 UTC 35.32615 -119.06222 Bakersfield 2 []
1084534 September 21, 2020 - 17:29:49 UTC 35.33567 -119.0895 Bakersfield 2 []
1084393 September 21, 2020 - 17:01:07 UTC 35.37538 -118.95675 Bakersfield 2 []
1084120 September 21, 2020 - 16:29:35 UTC 35.33176 -119.04877 Bakersfield 2 []
1083851 September 21, 2020 - 15:09:28 UTC 35.29309 -119.05023 Bakersfield 2 []
1083850 September 21, 2020 - 15:09:18 UTC 35.40044 -118.94075 Bakersfield 2 []
1083445 September 21, 2020 - 03:55:59 UTC 35.38272 -118.92578 Bakersfield 2 []
1083444 September 21, 2020 - 03:39:00 UTC 35.38452 -118.95963 Bakersfield 2 []
1083162 September 20, 2020 - 05:33:17 UTC 35.40044 -118.94075 Bakersfield 2 []
1083103 September 20, 2020 - 01:05:38 UTC 35.34148 -119.11017 Bakersfield 2 []
1082935 September 19, 2020 - 21:36:08 UTC 35.32924 -119.09194 Bakersfield 2 []
1082934 September 19, 2020 - 21:35:00 UTC 35.32763 -119.09194 Bakersfield 2 []
1082933 September 19, 2020 - 21:34:00 UTC 35.33022 -119.09098 Bakersfield 2 [{"latitude": "35.32856", "longitude": "-119.08978"}, {"latitude": "35.32942", "longitude": "-119.0877"}, {"latitude": "35.33015", "longitude": "-119.08934"}, {"latitude": "35.32934", "longitude": "-119.09079"}]
1082873 September 19, 2020 - 21:19:50 UTC 35.41315 -119.08044 Bakersfield 2 []
1082421 September 19, 2020 - 18:27:00 UTC 35.34397 -119.00286 Bakersfield 2 [{"latitude": "35.31443", "longitude": "-118.99585"}, {"latitude": "35.31764", "longitude": "-118.98565"}, {"latitude": "35.32726", "longitude": "-118.99861"}, {"latitude": "35.32843", "longitude": "-119.00071"}, {"latitude": "35.32844", "longitude": "-119.00267"}, {"latitude": "35.32778", "longitude": "-119.01276"}, {"latitude": "35.32695", "longitude": "-119.01408"}, {"latitude": "35.31646", "longitude": "-119.00321"}]
1082428 September 19, 2020 - 18:27:00 UTC 35.31738 -118.98966 Bakersfield 2 []
1082274 September 19, 2020 - 17:08:40 UTC 35.26659 -118.94413 Bakersfield 2 []
1082249 September 19, 2020 - 16:53:28 UTC 35.39288 -118.97112 Bakersfield 2 []
1082205 September 19, 2020 - 16:19:27 UTC 35.38754 -118.9737 Bakersfield 2 []
1082197 September 19, 2020 - 16:08:11 UTC 35.40595 -118.98392 Bakersfield 2 []
1082074 September 19, 2020 - 13:35:18 UTC 35.26702 -118.93304 Bakersfield 2 [{"latitude": "35.26497", "longitude": "-118.93708"}, {"latitude": "35.26616", "longitude": "-118.93772"}, {"latitude": "35.26699", "longitude": "-118.93885"}, {"latitude": "35.26699", "longitude": "-118.93989"}, {"latitude": "35.26659", "longitude": "-118.94413"}, {"latitude": "35.26646", "longitude": "-118.94413"}]
1082065 September 19, 2020 - 13:04:39 UTC 35.3485 -119.12566 Bakersfield 2 []
1082052 September 19, 2020 - 11:20:00 UTC 35.33955 -119.096 Bakersfield 2 [{"latitude": "35.32856", "longitude": "-119.08978"}, {"latitude": "35.32942", "longitude": "-119.0877"}, {"latitude": "35.33265", "longitude": "-119.08776"}, {"latitude": "35.33874", "longitude": "-119.08847"}, {"latitude": "35.33912", "longitude": "-119.08944"}, {"latitude": "35.33914", "longitude": "-119.09092"}, {"latitude": "35.33825", "longitude": "-119.09118"}, {"latitude": "35.33155", "longitude": "-119.09251"}, {"latitude": "35.33056", "longitude": "-119.09186"}, {"latitude": "35.32934", "longitude": "-119.09079"}]
1082045 September 19, 2020 - 09:11:00 UTC 35.33955 -119.096 Bakersfield 2 [{"latitude": "35.32763", "longitude": "-119.09194"}, {"latitude": "35.32942", "longitude": "-119.0877"}, {"latitude": "35.33265", "longitude": "-119.08776"}, {"latitude": "35.33874", "longitude": "-119.08847"}, {"latitude": "35.33912", "longitude": "-119.08944"}, {"latitude": "35.33914", "longitude": "-119.09092"}, {"latitude": "35.33825", "longitude": "-119.09118"}, {"latitude": "35.33155", "longitude": "-119.09251"}]
1082022 September 19, 2020 - 04:50:46 UTC 35.41327 -119.08011 Bakersfield 2 [{"latitude": "35.41295", "longitude": "-119.0796"}, {"latitude": "35.41332", "longitude": "-119.07899"}, {"latitude": "35.41546", "longitude": "-119.07899"}, {"latitude": "35.41589", "longitude": "-119.08199"}, {"latitude": "35.4159", "longitude": "-119.08249"}, {"latitude": "35.41516", "longitude": "-119.08243"}, {"latitude": "35.41315", "longitude": "-119.08044"}]
1081975 September 19, 2020 - 01:45:00 UTC 35.36452 -118.95959 Bakersfield 2 []
1081963 September 19, 2020 - 00:59:46 UTC 35.40302 -119.08195 Bakersfield 2 []
1081773 September 18, 2020 - 22:52:39 UTC 35.34914 -118.99481 Bakersfield 2 []
1081474 September 18, 2020 - 21:33:12 UTC 35.35973 -118.99023 Bakersfield 2 []
1081473 September 18, 2020 - 21:33:11 UTC 35.36098 -118.99023 Bakersfield 2 []
1081353 September 18, 2020 - 21:17:31 UTC 35.37676 -119.03332 Bakersfield 2 []
1081098 September 18, 2020 - 20:30:00 UTC 35.37676 -119.03387 Bakersfield 2 []
1080693 September 18, 2020 - 18:12:55 UTC 35.37676 -119.03387 Bakersfield 2 []
1080554 September 18, 2020 - 17:53:54 UTC 35.37676 -119.03332 Bakersfield 2 []
1080493 September 18, 2020 - 17:45:15 UTC 35.39287 -118.95023 Bakersfield 2 []
1080434 September 18, 2020 - 17:22:40 UTC 35.35363 -118.99694 Bakersfield 2 [{"latitude": "35.34893", "longitude": "-118.99481"}, {"latitude": "35.35081", "longitude": "-118.99479"}, {"latitude": "35.35136", "longitude": "-118.99479"}, {"latitude": "35.35348", "longitude": "-118.99694"}, {"latitude": "35.3529", "longitude": "-118.99726"}, {"latitude": "35.35009", "longitude": "-118.99695"}]
1080974 September 18, 2020 - 17:22:40 UTC 35.35042 -118.99488 Bakersfield 2 [{"latitude": "35.34893", "longitude": "-118.99481"}, {"latitude": "35.35081", "longitude": "-118.99479"}, {"latitude": "35.35136", "longitude": "-118.99479"}, {"latitude": "35.34914", "longitude": "-118.99481"}]
1080395 September 18, 2020 - 17:18:34 UTC 35.38989 -119.02697 Bakersfield 2 []
1080371 September 18, 2020 - 17:05:06 UTC 35.37514 -119.04239 Bakersfield 2 []
1080368 September 18, 2020 - 17:01:44 UTC 35.37523 -119.13113 Bakersfield 2 []
1080361 September 18, 2020 - 16:54:04 UTC 35.29656 -119.08467 Bakersfield 2 []
1080349 September 18, 2020 - 16:43:51 UTC 35.37676 -119.03332 Bakersfield 2 []
1080346 September 18, 2020 - 16:40:49 UTC 35.37676 -119.03223 Bakersfield 2 []
1080334 September 18, 2020 - 16:29:44 UTC 35.34597 -118.86816 Bakersfield 2 []
1079695 September 18, 2020 - 14:23:30 UTC 35.36465 -119.01592 Bakersfield 2 [{"latitude": "35.36225", "longitude": "-119.016"}, {"latitude": "35.36313", "longitude": "-119.01589"}, {"latitude": "35.36701", "longitude": "-119.01589"}]
1079627 September 18, 2020 - 03:59:54 UTC 35.40166 -119.13103 Bakersfield 2 []
1079610 September 18, 2020 - 03:12:05 UTC 35.36537 -119.02369 Bakersfield 2 []
1079568 September 18, 2020 - 02:34:02 UTC 35.4196 -119.06771 Bakersfield 2 []
1079541 September 18, 2020 - 01:21:49 UTC 35.39639 -118.96377 Bakersfield 2 []
1079504 September 17, 2020 - 23:46:24 UTC 35.37017 -118.97463 Bakersfield 2 []
1079267 September 17, 2020 - 22:27:00 UTC 35.31507 -119.01941 Bakersfield 2 []
1079266 September 17, 2020 - 22:26:51 UTC 35.35175 -119.03341 Bakersfield 2 []
1079114 September 17, 2020 - 22:00:01 UTC 35.40883 -118.93386 Bakersfield 2 []
1078699 September 17, 2020 - 20:37:33 UTC 35.34816 -118.99368 Bakersfield 2 []
1078557 September 17, 2020 - 20:03:47 UTC 35.31507 -119.01941 Bakersfield 2 []
1078284 September 17, 2020 - 18:11:49 UTC 35.38044 -118.96816 Bakersfield 2 []
1077785 September 17, 2020 - 16:24:38 UTC 35.31634 -119.04309 Bakersfield 2 []
1077033 September 17, 2020 - 14:09:03 UTC 35.38136 -119.0263 Bakersfield 2 []
1077233 September 17, 2020 - 13:20:00 UTC 35.37948 -119.00362 Bakersfield 2 []
1076760 September 17, 2020 - 05:15:07 UTC 35.33056 -118.92868 Bakersfield 2 []
1076753 September 17, 2020 - 04:05:56 UTC 35.40988 -118.94419 Bakersfield 2 []
1076633 September 16, 2020 - 23:17:00 UTC 35.26846 -119.03381 Bakersfield 2 []
1076434 September 16, 2020 - 22:29:38 UTC 35.3692 -119.0443 Bakersfield 2 []
1075917 September 16, 2020 - 20:57:00 UTC 35.35049 -119.01173 Bakersfield 2 [{"latitude": "35.3507", "longitude": "-119.01173"}, {"latitude": "35.35114", "longitude": "-119.01139"}, {"latitude": "35.35176", "longitude": "-119.01126"}]
1075924 September 16, 2020 - 20:55:00 UTC 35.38854 -119.00444 Bakersfield 2 [{"latitude": "35.37832", "longitude": "-119.00894"}, {"latitude": "35.37845", "longitude": "-119.00757"}, {"latitude": "35.37896", "longitude": "-119.00732"}, {"latitude": "35.38576", "longitude": "-119.00692"}, {"latitude": "35.38843", "longitude": "-119.00733"}, {"latitude": "35.38921", "longitude": "-119.00871"}, {"latitude": "35.38844", "longitude": "-119.01284"}, {"latitude": "35.3862", "longitude": "-119.01353"}, {"latitude": "35.37879", "longitude": "-119.01121"}, {"latitude": "35.37864", "longitude": "-119.01114"}]
1075799 September 16, 2020 - 20:33:21 UTC 35.40827 -119.01233 Bakersfield 2 []
1075414 September 16, 2020 - 19:17:43 UTC 35.30492 -119.08867 Bakersfield 2 []
1075096 September 16, 2020 - 18:21:50 UTC 35.33571 -119.0622 Bakersfield 2 [{"latitude": "35.33613", "longitude": "-119.06412"}, {"latitude": "35.33617", "longitude": "-119.06252"}, {"latitude": "35.33732", "longitude": "-119.06264"}, {"latitude": "35.33701", "longitude": "-119.06328"}, {"latitude": "35.3365", "longitude": "-119.06428"}]
1074478 September 16, 2020 - 16:01:00 UTC 35.34556 -119.04815 Bakersfield 2 [{"latitude": "35.34544", "longitude": "-119.04418"}, {"latitude": "35.34555", "longitude": "-119.04672"}, {"latitude": "35.34556", "longitude": "-119.04719"}, {"latitude": "35.34556", "longitude": "-119.04801"}, {"latitude": "35.34546", "longitude": "-119.04541"}, {"latitude": "35.34545", "longitude": "-119.04501"}]
1074435 September 16, 2020 - 15:54:08 UTC 35.32858 -119.04322 Bakersfield 2 [{"latitude": "35.32857", "longitude": "-119.04069"}, {"latitude": "35.32858", "longitude": "-119.04275"}, {"latitude": "35.32857", "longitude": "-119.04193"}]
1074114 September 16, 2020 - 15:01:14 UTC 35.21244 -119.15504 Bakersfield 2 []
1073953 September 16, 2020 - 14:41:50 UTC 35.18708 -119.04783 Bakersfield 2 []
1073934 September 16, 2020 - 14:32:21 UTC 35.33571 -119.0622 Bakersfield 2 [{"latitude": "35.33613", "longitude": "-119.06412"}, {"latitude": "35.33617", "longitude": "-119.06252"}, {"latitude": "35.33766", "longitude": "-119.06171"}, {"latitude": "35.33732", "longitude": "-119.06264"}, {"latitude": "35.33701", "longitude": "-119.06328"}, {"latitude": "35.3365", "longitude": "-119.06428"}]
1073275 September 15, 2020 - 22:35:36 UTC 35.38004 -118.93964 Bakersfield 2 []
1072993 September 15, 2020 - 21:35:55 UTC 35.31196 -118.98537 Bakersfield 2 []
1072556 September 15, 2020 - 20:23:35 UTC 35.3627 -119.03242 Bakersfield 2 []
1072133 September 15, 2020 - 18:48:20 UTC 35.35979 -119.04295 Bakersfield 2 []
1071916 September 15, 2020 - 18:06:04 UTC 35.4352 -119.05053 Bakersfield 2 []
1070662 September 15, 2020 - 09:00:00 UTC 35.0891 -118.97665 Bakersfield 2 [{"latitude": "35.07439", "longitude": "-118.90833"}, {"latitude": "35.15828", "longitude": "-118.94148"}, {"latitude": "35.16505", "longitude": "-118.94996"}, {"latitude": "35.15799", "longitude": "-118.97568"}, {"latitude": "35.15058", "longitude": "-118.99652"}, {"latitude": "35.08332", "longitude": "-118.96236"}, {"latitude": "35.07539", "longitude": "-118.94938"}, {"latitude": "35.07514", "longitude": "-118.94538"}, {"latitude": "35.07448", "longitude": "-118.93031"}]
1070589 September 15, 2020 - 04:11:00 UTC 35.37362 -118.95261 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 2421.522ms · About: About this site