outages

67,302 rows sorted by outageStartTime descending

View and edit SQL

id outageStartTime ▲ latitude longitude regionName outageDevices
745099 December 18, 2019 - 11:21:00 UTC 39.15762 -123.70408 Elk 814 []
745097 December 18, 2019 - 10:46:28 UTC 37.05114 -122.07404 Felton 7 []
745096 December 18, 2019 - 10:44:45 UTC 40.22597 -123.79081 Myers Flat 257 [{"latitude": "40.22644", "longitude": "-123.80335"}, {"latitude": "40.22812", "longitude": "-123.79801"}, {"latitude": "40.23139", "longitude": "-123.79352"}, {"latitude": "40.24019", "longitude": "-123.80571"}, {"latitude": "40.23068", "longitude": "-123.80856"}]
745095 December 18, 2019 - 10:35:00 UTC 38.07576 -122.23056 Vallejo 154 [{"latitude": "38.07551", "longitude": "-122.22717"}, {"latitude": "38.08992", "longitude": "-122.22908"}, {"latitude": "38.08986", "longitude": "-122.23018"}, {"latitude": "38.0884", "longitude": "-122.23443"}, {"latitude": "38.08649", "longitude": "-122.23574"}, {"latitude": "38.08394", "longitude": "-122.2358"}, {"latitude": "38.08289", "longitude": "-122.23517"}, {"latitude": "38.07637", "longitude": "-122.231"}]
745094 December 18, 2019 - 10:19:34 UTC 37.33175 -121.79706 San Jose 26 []
745093 December 18, 2019 - 10:17:04 UTC 37.7303 -122.17382 Oakland 16 []
745092 December 18, 2019 - 10:03:00 UTC 37.38605 -120.61356 Winton 534 [{"latitude": "37.3839", "longitude": "-120.61026"}, {"latitude": "37.3906", "longitude": "-120.61147"}, {"latitude": "37.39429", "longitude": "-120.61378"}, {"latitude": "37.39479", "longitude": "-120.61427"}, {"latitude": "37.39479", "longitude": "-120.61485"}, {"latitude": "37.38675", "longitude": "-120.61358"}, {"latitude": "37.3857", "longitude": "-120.61283"}, {"latitude": "37.38514", "longitude": "-120.61232"}, {"latitude": "37.38435", "longitude": "-120.61105"}]
745091 December 18, 2019 - 10:02:53 UTC 37.76381 -120.97929 Escalon 423 []
745090 December 18, 2019 - 10:02:04 UTC 35.55058 -121.07596 Cambria 3 []
745088 December 18, 2019 - 10:01:33 UTC 38.50269 -123.00035 Guerneville 299 []
745087 December 18, 2019 - 09:54:00 UTC 37.76215 -120.99583 Escalon 423 [{"latitude": "37.76353", "longitude": "-120.99681"}, {"latitude": "37.77299", "longitude": "-120.97692"}, {"latitude": "37.77407", "longitude": "-120.97636"}, {"latitude": "37.77836", "longitude": "-120.97414"}, {"latitude": "37.78067", "longitude": "-120.97345"}, {"latitude": "37.7893", "longitude": "-120.97252"}, {"latitude": "37.79228", "longitude": "-120.98636"}, {"latitude": "37.79558", "longitude": "-121.01472"}, {"latitude": "37.79157", "longitude": "-121.01986"}, {"latitude": "37.78763", "longitude": "-121.01947"}, {"latitude": "37.77483", "longitude": "-121.00984"}]
745084 December 18, 2019 - 09:51:42 UTC 39.66421 -123.47713 Laytonville 717 [{"latitude": "39.66408", "longitude": "-123.48262"}, {"latitude": "39.66442", "longitude": "-123.48095"}, {"latitude": "39.66474", "longitude": "-123.48025"}]
745083 December 18, 2019 - 09:49:28 UTC 37.74585 -122.42979 San Francisco 25 []
745082 December 18, 2019 - 09:42:40 UTC 37.99908 -122.57322 San Anselmo 183 []
745078 December 18, 2019 - 09:25:36 UTC 37.77539 -122.2208 Oakland 16 []
745077 December 18, 2019 - 09:13:26 UTC 40.4551 -124.06042 Scotia 625 [{"latitude": "40.45562", "longitude": "-124.05919"}, {"latitude": "40.45613", "longitude": "-124.05758"}, {"latitude": "40.45647", "longitude": "-124.05663"}, {"latitude": "40.4571", "longitude": "-124.05698"}, {"latitude": "40.45666", "longitude": "-124.05851"}, {"latitude": "40.45599", "longitude": "-124.06042"}]
745076 December 18, 2019 - 09:07:00 UTC 35.61735 -119.69075 Lost Hills 126 []
745080 December 18, 2019 - 09:05:00 UTC 37.68964 -121.87861 Pleasanton 36 [{"latitude": "37.6894", "longitude": "-121.87897"}, {"latitude": "37.68958", "longitude": "-121.87872"}, {"latitude": "37.68977", "longitude": "-121.87947"}]
745075 December 18, 2019 - 08:58:05 UTC 37.84928 -122.2336 Oakland 16 [{"latitude": "37.84912", "longitude": "-122.23376"}, {"latitude": "37.84926", "longitude": "-122.23383"}, {"latitude": "37.8517", "longitude": "-122.23578"}, {"latitude": "37.85214", "longitude": "-122.23629"}, {"latitude": "37.85102", "longitude": "-122.23977"}, {"latitude": "37.84952", "longitude": "-122.23549"}]
745072 December 18, 2019 - 08:03:08 UTC 39.85174 -121.60838 Magalia 481 []
745069 December 18, 2019 - 07:18:22 UTC 37.81214 -122.29243 Oakland 16 []
745070 December 18, 2019 - 07:16:00 UTC 37.85391 -122.47885 Sausalito 561 []
745067 December 18, 2019 - 07:08:19 UTC 37.22621 -121.98266 Los Gatos 121 []
745066 December 18, 2019 - 06:58:36 UTC 37.05114 -122.07404 Felton 7 []
745064 December 18, 2019 - 06:45:00 UTC 40.18121 -122.33229 Red Bluff 20 [{"latitude": "40.17329", "longitude": "-122.33392"}, {"latitude": "40.17362", "longitude": "-122.33078"}, {"latitude": "40.17542", "longitude": "-122.33053"}, {"latitude": "40.18175", "longitude": "-122.33243"}, {"latitude": "40.1877", "longitude": "-122.34133"}, {"latitude": "40.18928", "longitude": "-122.35385"}, {"latitude": "40.17786", "longitude": "-122.34852"}, {"latitude": "40.17589", "longitude": "-122.34562"}, {"latitude": "40.17521", "longitude": "-122.34307"}]
745063 December 18, 2019 - 06:32:38 UTC 40.49751 -123.60802 Bridgeville 620 []
745062 December 18, 2019 - 06:23:20 UTC 37.29963 -121.87868 San Jose 26 []
745061 December 18, 2019 - 06:14:33 UTC 35.73173 -120.87963 Lake Nacimiento 273 []
745065 December 18, 2019 - 06:09:00 UTC 37.33727 -121.89468 San Jose 26 []
745060 December 18, 2019 - 05:56:36 UTC 37.90569 -122.31781 Richmond 220 []
745058 December 18, 2019 - 05:24:41 UTC 38.41385 -122.77506 Santa Rosa 30 []
745057 December 18, 2019 - 05:14:11 UTC 37.68312 -122.401 Brisbane 729 []
745056 December 18, 2019 - 05:10:26 UTC 35.10166 -120.61495 Oceano 512 []
745055 December 18, 2019 - 05:02:08 UTC 37.72788 -122.17417 Oakland 16 []
745054 December 18, 2019 - 04:47:00 UTC 37.80476 -121.1983 Manteca 210 [{"latitude": "37.80205", "longitude": "-121.19721"}, {"latitude": "37.80206", "longitude": "-121.19487"}, {"latitude": "37.80262", "longitude": "-121.19376"}, {"latitude": "37.80349", "longitude": "-121.19454"}, {"latitude": "37.8042", "longitude": "-121.19541"}, {"latitude": "37.80477", "longitude": "-121.19667"}, {"latitude": "37.80453", "longitude": "-121.198"}, {"latitude": "37.80377", "longitude": "-121.19797"}, {"latitude": "37.8024", "longitude": "-121.19791"}]
745052 December 18, 2019 - 04:43:25 UTC 36.072 -120.08835 Avenal 339 []
745051 December 18, 2019 - 04:36:21 UTC 35.44578 -119.48416 Buttonwillow 162 []
745050 December 18, 2019 - 04:35:53 UTC 38.7318 -120.67214 Camino 146 []
745049 December 18, 2019 - 04:35:36 UTC 37.7818 -122.46121 San Francisco 25 []
745048 December 18, 2019 - 04:25:01 UTC 37.80118 -122.2437 Oakland 16 []
745039 December 18, 2019 - 04:16:32 UTC 37.70381 -122.06146 Castro Valley 4 []
745038 December 18, 2019 - 04:14:00 UTC 36.69397 -121.64122 Salinas 23 []
745037 December 18, 2019 - 04:11:09 UTC 38.01519 -121.35498 Stockton 78 []
745035 December 18, 2019 - 04:07:33 UTC 38.0122 -121.35619 Stockton 78 []
745034 December 18, 2019 - 04:06:00 UTC 38.02339 -121.35463 Stockton 78 []
745032 December 18, 2019 - 04:05:18 UTC 38.03 -121.3618 Stockton 78 []
745031 December 18, 2019 - 04:05:11 UTC 37.29702 -121.95595 San Jose 26 []
745033 December 18, 2019 - 04:05:00 UTC 38.02916 -121.33787 Stockton 78 []
745030 December 18, 2019 - 04:04:38 UTC 38.02502 -121.36349 Stockton 78 []
745027 December 18, 2019 - 04:00:00 UTC 38.02459 -121.35529 Stockton 78 []
745028 December 18, 2019 - 04:00:00 UTC 38.02784 -121.35383 Stockton 78 []
745026 December 18, 2019 - 03:57:23 UTC 37.00457 -121.59137 Gilroy 223 []
745025 December 18, 2019 - 03:55:40 UTC 37.20959 -121.85318 San Jose 26 []
745024 December 18, 2019 - 03:44:03 UTC 37.10466 -120.28044 Chowchilla 222 []
745023 December 18, 2019 - 03:43:53 UTC 36.67316 -119.08469 Miramonte 749 []
745022 December 18, 2019 - 03:39:40 UTC 37.94338 -122.36351 Richmond 220 []
745021 December 18, 2019 - 03:38:36 UTC 38.0644 -122.55306 Novato 93 []
745020 December 18, 2019 - 03:37:48 UTC 37.9534 -122.36727 Richmond 220 [{"latitude": "37.95339", "longitude": "-122.36948"}, {"latitude": "37.9534", "longitude": "-122.36764"}, {"latitude": "37.9534", "longitude": "-122.36815"}]
745019 December 18, 2019 - 03:34:50 UTC 35.37784 -118.93856 Bakersfield 2 []
745017 December 18, 2019 - 03:34:31 UTC 37.21159 -120.46989 Merced 13 []
745016 December 18, 2019 - 03:33:36 UTC 36.31758 -121.25378 Greenfield 767 []
745013 December 18, 2019 - 03:23:08 UTC 36.48821 -119.25958 Cutler 669 [{"latitude": "36.48982", "longitude": "-119.25958"}, {"latitude": "36.4917", "longitude": "-119.25816"}, {"latitude": "36.49714", "longitude": "-119.25876"}, {"latitude": "36.5007", "longitude": "-119.25962"}, {"latitude": "36.49615", "longitude": "-119.26407"}, {"latitude": "36.4918", "longitude": "-119.26532"}]
745012 December 18, 2019 - 03:19:56 UTC 37.32736 -121.92885 San Jose 26 []
745011 December 18, 2019 - 03:19:26 UTC 38.02669 -121.32231 Stockton 78 []
745009 December 18, 2019 - 03:04:36 UTC 37.82306 -122.27267 Oakland 16 []
745008 December 18, 2019 - 03:04:23 UTC 37.95271 -122.36875 Richmond 220 []
745007 December 18, 2019 - 03:00:00 UTC 37.91466 -122.5517 Mill Valley 239 []
745006 December 18, 2019 - 02:56:25 UTC 37.91406 -122.55115 Mill Valley 239 []
745005 December 18, 2019 - 02:53:12 UTC 38.03558 -121.28512 Stockton 78 []
745004 December 18, 2019 - 02:53:09 UTC 38.03289 -121.28526 Stockton 78 []
744997 December 18, 2019 - 02:52:05 UTC 38.02943 -121.28266 Stockton 78 []
745001 December 18, 2019 - 02:52:04 UTC 38.0358 -121.28561 Stockton 78 []
745002 December 18, 2019 - 02:52:04 UTC 38.02955 -121.2856 Stockton 78 []
745003 December 18, 2019 - 02:52:04 UTC 38.03266 -121.2856 Stockton 78 []
745044 December 18, 2019 - 02:52:00 UTC 38.03697 -121.28601 Stockton 78 [{"latitude": "38.02892", "longitude": "-121.28289"}, {"latitude": "38.02903", "longitude": "-121.28215"}, {"latitude": "38.02929", "longitude": "-121.28148"}, {"latitude": "38.02955", "longitude": "-121.28093"}, {"latitude": "38.03107", "longitude": "-121.281"}, {"latitude": "38.03601", "longitude": "-121.28318"}, {"latitude": "38.03657", "longitude": "-121.28531"}, {"latitude": "38.03482", "longitude": "-121.2863"}, {"latitude": "38.02955", "longitude": "-121.2856"}]
744996 December 18, 2019 - 02:48:44 UTC 35.41284 -119.03581 Oildale 246 []
744995 December 18, 2019 - 02:45:45 UTC 40.9399 -124.02212 McKinleyville 333 []
744994 December 18, 2019 - 02:44:23 UTC 37.76703 -122.45129 San Francisco 25 []
744993 December 18, 2019 - 02:43:06 UTC 35.12527 -120.62684 Grover Beach 83 []
744992 December 18, 2019 - 02:37:49 UTC 37.99908 -122.57322 San Anselmo 183 []
744990 December 18, 2019 - 02:36:11 UTC 36.60988 -121.91678 Monterey 163 []
744991 December 18, 2019 - 02:35:00 UTC 35.44069 -119.02038 Oildale 246 [{"latitude": "35.42291", "longitude": "-118.97961"}, {"latitude": "35.43281", "longitude": "-118.8865"}, {"latitude": "35.43938", "longitude": "-118.87395"}, {"latitude": "35.44067", "longitude": "-118.87178"}, {"latitude": "35.45993", "longitude": "-118.87149"}, {"latitude": "35.48543", "longitude": "-118.88696"}, {"latitude": "35.49509", "longitude": "-118.93564"}, {"latitude": "35.49177", "longitude": "-118.94625"}, {"latitude": "35.44856", "longitude": "-119.01671"}, {"latitude": "35.44138", "longitude": "-119.01859"}, {"latitude": "35.4299", "longitude": "-119.00445"}]
744987 December 18, 2019 - 02:32:38 UTC 37.53557 -121.92452 Fremont 140 []
744988 December 18, 2019 - 02:32:00 UTC 37.78565 -120.77051 East Oakdale 869 []
745018 December 18, 2019 - 02:30:00 UTC 37.06502 -122.00005 Scotts Valley 184 []
744986 December 18, 2019 - 02:27:35 UTC 36.60086 -121.85849 Monterey 163 []
744985 December 18, 2019 - 02:22:20 UTC 40.87733 -121.66684 Burney 50 []
744983 December 18, 2019 - 02:17:34 UTC 38.3919 -122.81711 Sebastopol 99 []
744982 December 18, 2019 - 02:17:22 UTC 37.40393 -122.1956 Ladera 303 []
744980 December 18, 2019 - 02:17:07 UTC 37.98673 -122.2995 Pinole 329 []
744979 December 18, 2019 - 02:12:12 UTC 37.75971 -122.16268 Oakland 16 []
744978 December 18, 2019 - 02:11:00 UTC 37.60793 -122.40307 Millbrae 173 []
744977 December 18, 2019 - 02:10:00 UTC 37.98673 -122.2995 Pinole 329 []
744976 December 18, 2019 - 02:07:47 UTC 36.99658 -120.66282 Dos Palos 394 []
744974 December 18, 2019 - 02:07:13 UTC 37.26905 -121.80564 San Jose 26 []
744973 December 18, 2019 - 02:07:12 UTC 37.26904 -121.80782 San Jose 26 []
744975 December 18, 2019 - 02:07:12 UTC 37.26658 -121.80403 San Jose 26 []
744962 December 18, 2019 - 01:59:21 UTC 38.00149 -122.28321 Pinole 329 []
744961 December 18, 2019 - 01:54:55 UTC 37.67718 -121.86243 Pleasanton 36 []
744958 December 18, 2019 - 01:50:18 UTC 37.60355 -122.41864 Millbrae 173 []

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