outages

41,395 rows sorted by outageStartTime descending

View and edit SQL

id outageStartTime ▲ latitude longitude regionName outageDevices
707427 November 15, 2019 - 17:16:08 UTC 36.99381 -121.93916 Soquel 254 []
707424 November 15, 2019 - 17:14:16 UTC 37.98476 -120.38707 Sonora 384 []
707426 November 15, 2019 - 17:14:00 UTC 37.74708 -122.4361 San Francisco 25 []
707423 November 15, 2019 - 17:13:55 UTC 38.00368 -121.88961 Pittsburg 204 []
707422 November 15, 2019 - 17:13:18 UTC 36.76826 -119.73676 Fresno 35 []
707421 November 15, 2019 - 17:12:35 UTC 39.49686 -121.54243 South Oroville 320 []
707420 November 15, 2019 - 17:12:09 UTC 37.82879 -122.002 Danville 213 []
707425 November 15, 2019 - 17:09:23 UTC 40.84449 -122.34241 Lakehead 558 [{"latitude": "40.83885", "longitude": "-122.33638"}, {"latitude": "40.84073", "longitude": "-122.33062"}, {"latitude": "40.83919", "longitude": "-122.34368"}]
707417 November 15, 2019 - 17:08:00 UTC 36.76825 -119.73634 Fresno 35 [{"latitude": "36.76756", "longitude": "-119.73283"}, {"latitude": "36.76787", "longitude": "-119.73283"}, {"latitude": "36.76828", "longitude": "-119.73356"}, {"latitude": "36.76829", "longitude": "-119.73483"}, {"latitude": "36.76829", "longitude": "-119.73593"}]
707409 November 15, 2019 - 17:07:11 UTC 36.22823 -121.14129 King City 196 []
707410 November 15, 2019 - 17:07:00 UTC 37.47103 -122.20064 North Fair Oaks 405 []
707414 November 15, 2019 - 17:07:00 UTC 37.22961 -119.50844 North Fork 128 [{"latitude": "37.22997", "longitude": "-119.50913"}, {"latitude": "37.2305", "longitude": "-119.50777"}, {"latitude": "37.23031", "longitude": "-119.5096"}]
707406 November 15, 2019 - 17:06:00 UTC 37.2639 -119.68466 Coarsegold 288 [{"latitude": "37.26293", "longitude": "-119.68489"}, {"latitude": "37.26526", "longitude": "-119.68434"}, {"latitude": "37.26419", "longitude": "-119.6846"}]
707403 November 15, 2019 - 17:05:45 UTC 37.96939 -122.02373 Concord 46 []
707405 November 15, 2019 - 17:05:00 UTC 39.61381 -122.51929 Elk Creek 608 [{"latitude": "39.44145", "longitude": "-122.48672"}, {"latitude": "39.4525", "longitude": "-122.47084"}, {"latitude": "39.46872", "longitude": "-122.44885"}, {"latitude": "39.5558", "longitude": "-122.43783"}, {"latitude": "39.61612", "longitude": "-122.43963"}, {"latitude": "39.59695", "longitude": "-122.48927"}, {"latitude": "39.45259", "longitude": "-122.49447"}, {"latitude": "39.45003", "longitude": "-122.49393"}]
707418 November 15, 2019 - 17:04:45 UTC 37.88395 -122.25992 Berkeley 47 []
707416 November 15, 2019 - 17:03:03 UTC 38.39594 -120.68477 Jackson 360 []
707397 November 15, 2019 - 17:02:24 UTC 36.66306 -119.74709 Fresno 35 []
707413 November 15, 2019 - 17:02:20 UTC 37.4854 -122.24798 Redwood City 256 []
707411 November 15, 2019 - 17:02:17 UTC 37.88465 -122.25899 Berkeley 47 []
707399 November 15, 2019 - 17:02:00 UTC 37.97802 -120.41827 Jamestown 193 []
707408 November 15, 2019 - 17:01:47 UTC 39.62078 -121.78717 Durham 431 [{"latitude": "39.62081", "longitude": "-121.787"}, {"latitude": "39.62155", "longitude": "-121.78691"}, {"latitude": "39.62246", "longitude": "-121.78691"}]
707407 November 15, 2019 - 17:01:43 UTC 38.54437 -120.74138 River Pines 738 []
707396 November 15, 2019 - 17:01:10 UTC 37.69402 -122.4828 Broadmoor 853 []
707395 November 15, 2019 - 17:01:03 UTC 37.29714 -121.89123 San Jose 26 []
707404 November 15, 2019 - 17:00:50 UTC 37.18024 -119.76687 Yosemite Lakes 462 []
707415 November 15, 2019 - 17:00:34 UTC 37.97177 -121.27104 Stockton 78 []
707393 November 15, 2019 - 17:00:10 UTC 37.32011 -122.057 Cupertino 123 []
707275 November 15, 2019 - 17:00:00 UTC 38.72995 -120.92433 Placerville 19 [{"latitude": "38.72222", "longitude": "-120.92751"}, {"latitude": "38.72234", "longitude": "-120.92608"}, {"latitude": "38.72279", "longitude": "-120.9257"}, {"latitude": "38.72645", "longitude": "-120.92386"}, {"latitude": "38.72814", "longitude": "-120.92695"}, {"latitude": "38.72863", "longitude": "-120.92834"}, {"latitude": "38.72962", "longitude": "-120.93192"}, {"latitude": "38.72934", "longitude": "-120.93267"}, {"latitude": "38.72556", "longitude": "-120.93192"}, {"latitude": "38.72439", "longitude": "-120.93159"}]
707332 November 15, 2019 - 17:00:00 UTC 37.76324 -122.48619 San Francisco 25 []
707336 November 15, 2019 - 17:00:00 UTC 40.44786 -124.2684 Ferndale 112 [{"latitude": "40.44448", "longitude": "-124.2391"}, {"latitude": "40.44509", "longitude": "-124.23552"}, {"latitude": "40.44895", "longitude": "-124.25327"}]
707392 November 15, 2019 - 17:00:00 UTC 38.55306 -122.45675 Deer Park 275 [{"latitude": "38.54495", "longitude": "-122.45522"}, {"latitude": "38.54658", "longitude": "-122.4528"}, {"latitude": "38.553", "longitude": "-122.45709"}, {"latitude": "38.55404", "longitude": "-122.46285"}, {"latitude": "38.54577", "longitude": "-122.45651"}]
707401 November 15, 2019 - 16:59:56 UTC 38.70762 -120.59914 Pollock Pines 278 []
707400 November 15, 2019 - 16:59:36 UTC 38.36248 -120.72484 Jackson 360 []
707391 November 15, 2019 - 16:59:17 UTC 36.66752 -121.66254 Salinas 23 []
707390 November 15, 2019 - 16:58:07 UTC 39.51858 -123.38927 Willits 327 []
707398 November 15, 2019 - 16:58:00 UTC 39.09983 -121.55166 Olivehurst 17 [{"latitude": "39.10028", "longitude": "-121.55157"}, {"latitude": "39.10184", "longitude": "-121.55157"}, {"latitude": "39.10172", "longitude": "-121.55237"}, {"latitude": "39.10099", "longitude": "-121.5526"}]
707389 November 15, 2019 - 16:56:12 UTC 36.844 -120.09253 Madera 76 []
707386 November 15, 2019 - 16:55:32 UTC 37.55921 -122.2818 San Mateo 29 []
707402 November 15, 2019 - 16:55:13 UTC 38.50139 -122.99828 Guerneville 299 []
707388 November 15, 2019 - 16:55:00 UTC 39.53952 -123.38048 Willits 327 []
707385 November 15, 2019 - 16:54:41 UTC 39.50835 -123.38263 Willits 327 []
707384 November 15, 2019 - 16:54:37 UTC 39.49908 -123.3726 Willits 327 []
707382 November 15, 2019 - 16:53:15 UTC 36.61163 -119.09983 Orosi 727 []
707381 November 15, 2019 - 16:53:01 UTC 39.10005 -120.94572 Colfax 436 []
707379 November 15, 2019 - 16:50:36 UTC 38.1704 -120.95904 Valley Springs 32 []
707375 November 15, 2019 - 16:49:13 UTC 36.20031 -120.0977 Huron 51 []
707383 November 15, 2019 - 16:49:08 UTC 39.38515 -121.68909 Gridley 472 []
707376 November 15, 2019 - 16:49:00 UTC 38.39206 -122.92203 Occidental 148 [{"latitude": "38.39149", "longitude": "-122.91986"}, {"latitude": "38.39198", "longitude": "-122.92022"}, {"latitude": "38.39202", "longitude": "-122.92119"}]
707373 November 15, 2019 - 16:47:39 UTC 39.19603 -120.79806 Dutch Flat 652 []
707372 November 15, 2019 - 16:47:31 UTC 39.44535 -121.27964 Challenge-Brownsville 635 []
707370 November 15, 2019 - 16:43:00 UTC 36.81377 -119.64038 Clovis 57 []
707369 November 15, 2019 - 16:42:38 UTC 38.37227 -122.0017 Vacaville 367 []
707367 November 15, 2019 - 16:41:11 UTC 38.63361 -120.63414 Somerset 221 []
707371 November 15, 2019 - 16:40:50 UTC 38.35136 -121.98808 Vacaville 367 []
707365 November 15, 2019 - 16:40:38 UTC 37.76119 -122.47364 San Francisco 25 []
707360 November 15, 2019 - 16:38:58 UTC 38.17333 -120.95717 Valley Springs 32 []
707362 November 15, 2019 - 16:38:55 UTC 38.16784 -120.96038 Valley Springs 32 []
707368 November 15, 2019 - 16:37:16 UTC 38.046 -120.39016 Columbia 400 []
707358 November 15, 2019 - 16:37:00 UTC 36.88632 -121.63385 Aromas 486 [{"latitude": "36.88482", "longitude": "-121.63482"}, {"latitude": "36.88616", "longitude": "-121.63379"}, {"latitude": "36.88728", "longitude": "-121.63429"}]
707357 November 15, 2019 - 16:36:36 UTC 36.99084 -120.6284 Dos Palos 394 []
707355 November 15, 2019 - 16:34:00 UTC 39.04888 -121.00325 Colfax 436 []
707354 November 15, 2019 - 16:33:48 UTC 39.17093 -123.56562 Comptche 731 []
707353 November 15, 2019 - 16:33:27 UTC 37.97814 -121.62148 Brentwood 95 []
707356 November 15, 2019 - 16:31:31 UTC 38.91926 -121.08684 North Auburn 345 []
707328 November 15, 2019 - 16:30:00 UTC 38.87803 -123.01527 Hopland 640 []
707351 November 15, 2019 - 16:30:00 UTC 39.05705 -120.9955 Colfax 436 [{"latitude": "39.0576", "longitude": "-120.99567"}, {"latitude": "39.05822", "longitude": "-120.99409"}, {"latitude": "39.05874", "longitude": "-120.99506"}]
707394 November 15, 2019 - 16:30:00 UTC 37.53757 -122.01759 Newark 225 []
707349 November 15, 2019 - 16:29:07 UTC 37.91741 -120.62296 Copperopolis 572 []
707346 November 15, 2019 - 16:28:39 UTC 37.97982 -122.03795 Concord 46 []
707345 November 15, 2019 - 16:26:00 UTC 37.53938 -122.2826 San Mateo 29 []
707350 November 15, 2019 - 16:24:33 UTC 36.98566 -119.71263 Friant 44 []
707347 November 15, 2019 - 16:23:36 UTC 36.95559 -119.46095 Clovis 57 []
707343 November 15, 2019 - 16:21:00 UTC 37.1259 -119.76078 Coarsegold 288 []
707340 November 15, 2019 - 16:20:36 UTC 35.32632 -119.14503 Bakersfield 2 []
707338 November 15, 2019 - 16:19:00 UTC 38.70207 -120.93645 Shingle Springs 270 []
707344 November 15, 2019 - 16:16:00 UTC 39.03638 -120.98748 Colfax 436 [{"latitude": "39.03716", "longitude": "-120.98774"}, {"latitude": "39.03877", "longitude": "-120.98358"}, {"latitude": "39.04026", "longitude": "-120.98286"}, {"latitude": "39.0417", "longitude": "-120.98284"}, {"latitude": "39.04388", "longitude": "-120.98595"}, {"latitude": "39.04021", "longitude": "-120.98849"}]
707341 November 15, 2019 - 16:15:39 UTC 40.51377 -122.07504 Shingletown 70 []
707342 November 15, 2019 - 16:15:00 UTC 35.32576 -119.13148 Bakersfield 2 []
707339 November 15, 2019 - 16:14:50 UTC 38.67339 -120.64728 Placerville 19 []
707333 November 15, 2019 - 16:14:14 UTC 37.49404 -121.91104 Fremont 140 []
707334 November 15, 2019 - 16:14:00 UTC 38.99709 -122.86969 Lakeport 75 []
707331 November 15, 2019 - 16:13:02 UTC 36.98155 -120.56085 Dos Palos 394 []
707337 November 15, 2019 - 16:12:06 UTC 36.56157 -119.5822 Selma 100 []
707335 November 15, 2019 - 16:10:33 UTC 36.93682 -119.46855 Clovis 57 []
707326 November 15, 2019 - 16:10:03 UTC 39.14454 -121.59866 Marysville 198 []
707364 November 15, 2019 - 16:10:00 UTC 38.44124 -122.39484 Napa 15 [{"latitude": "38.44234", "longitude": "-122.3966"}, {"latitude": "38.4451", "longitude": "-122.39467"}, {"latitude": "38.4464", "longitude": "-122.39936"}, {"latitude": "38.44441", "longitude": "-122.39939"}]
707325 November 15, 2019 - 16:09:39 UTC 35.46979 -119.68951 Mc Kittrick 495 [{"latitude": "35.46707", "longitude": "-119.70533"}, {"latitude": "35.46716", "longitude": "-119.70464"}, {"latitude": "35.47717", "longitude": "-119.68956"}, {"latitude": "35.47787", "longitude": "-119.68909"}]
707324 November 15, 2019 - 16:09:36 UTC 38.37483 -122.99292 Occidental 148 []
707330 November 15, 2019 - 16:07:42 UTC 40.54052 -122.14 Millville 369 []
707323 November 15, 2019 - 16:07:08 UTC 37.3901 -121.81414 East Foothills 133 [{"latitude": "37.38829", "longitude": "-121.81208"}, {"latitude": "37.38947", "longitude": "-121.80497"}, {"latitude": "37.39049", "longitude": "-121.80179"}, {"latitude": "37.39566", "longitude": "-121.80241"}, {"latitude": "37.391", "longitude": "-121.81539"}]
707329 November 15, 2019 - 16:06:00 UTC 36.81437 -119.63714 Clovis 57 [{"latitude": "36.81056", "longitude": "-119.63695"}, {"latitude": "36.81159", "longitude": "-119.63608"}, {"latitude": "36.81321", "longitude": "-119.636"}, {"latitude": "36.81291", "longitude": "-119.6398"}, {"latitude": "36.81253", "longitude": "-119.64032"}]
707322 November 15, 2019 - 16:05:39 UTC 35.29628 -119.13918 Bakersfield 2 []
707327 November 15, 2019 - 16:05:04 UTC 36.83681 -119.83776 Fresno 35 []
707315 November 15, 2019 - 16:02:12 UTC 38.50641 -122.9233 Forestville 214 []
707317 November 15, 2019 - 16:02:00 UTC 39.39357 -123.34339 Willits 327 []
707318 November 15, 2019 - 16:02:00 UTC 35.49069 -120.54188 Creston 58 []
707314 November 15, 2019 - 16:01:00 UTC 38.5133 -122.50922 Saint Helena 296 [{"latitude": "38.50703", "longitude": "-122.5134"}, {"latitude": "38.50946", "longitude": "-122.51606"}, {"latitude": "38.50903", "longitude": "-122.51749"}, {"latitude": "38.50735", "longitude": "-122.51943"}]
707240 November 15, 2019 - 16:00:00 UTC 35.61761 -120.84499 Paso Robles 48 []
707259 November 15, 2019 - 16:00:00 UTC 40.74388 -122.01851 Bella Vista 71 []

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