outages

76,672 rows sorted by outageDevices

View and edit SQL

id outageStartTime latitude longitude regionName outageDevices ▼
629455 September 30, 2019 - 03:17:55 UTC 40.55785 -124.14553 Fortuna 9 []
629544 September 30, 2019 - 12:09:00 UTC 37.25649 -121.94472 San Jose 26 []
629993 September 30, 2019 - 16:00:00 UTC 38.50277 -122.71038 Santa Rosa 30 []
630055 September 30, 2019 - 15:24:00 UTC 38.12243 -121.83043 Rio Vista 21 []
630855 September 30, 2019 - 16:27:00 UTC 37.73454 -122.13937 Oakland 16 []
631014 September 30, 2019 - 16:49:43 UTC 39.0775 -121.52568 Olivehurst 17 []
631074 September 30, 2019 - 17:03:30 UTC 37.29857 -121.97725 San Jose 26 []
631133 September 30, 2019 - 17:05:00 UTC 38.17765 -121.71222 Rio Vista 21 []
631354 September 30, 2019 - 18:23:18 UTC 35.30441 -120.77233 San Luis Obispo 28 []
631794 September 30, 2019 - 19:30:12 UTC 36.37987 -119.92783 Riverdale 22 []
632115 September 30, 2019 - 20:08:17 UTC 37.56994 -122.31673 San Mateo 29 []
632117 September 30, 2019 - 20:10:00 UTC 35.54847 -121.08542 Cambria 3 []
632153 September 30, 2019 - 20:18:37 UTC 37.89203 -122.03894 Walnut Creek 33 []
632414 September 30, 2019 - 20:38:32 UTC 38.31483 -122.33439 Napa 15 []
632474 September 30, 2019 - 20:52:00 UTC 36.29815 -119.76184 Lemoore 11 []
632633 September 30, 2019 - 21:18:35 UTC 38.37341 -121.54748 Clarksburg 5 []
632634 September 30, 2019 - 21:20:02 UTC 40.18335 -122.2206 Red Bluff 20 []
633157 September 30, 2019 - 22:48:30 UTC 36.61393 -121.56663 Salinas 23 []
633233 September 30, 2019 - 23:02:32 UTC 37.3361 -121.9288 San Jose 26 []
633373 September 30, 2019 - 23:35:00 UTC 38.36723 -121.54198 Clarksburg 5 []
633394 September 30, 2019 - 23:59:30 UTC 36.45004 -121.35438 Soledad 31 []
633433 October 01, 2019 - 01:41:00 UTC 38.65738 -121.77805 Woodland 34 []
633444 October 01, 2019 - 02:37:14 UTC 37.04293 -122.09002 Felton 7 []
633458 October 01, 2019 - 03:18:00 UTC 40.78042 -124.18235 Eureka 6 []
633460 October 01, 2019 - 03:38:35 UTC 38.69685 -120.77764 Placerville 19 []
633461 October 01, 2019 - 03:58:17 UTC 35.15723 -120.672 Pismo Beach 18 []
633467 October 01, 2019 - 04:13:00 UTC 37.76364 -122.38797 San Francisco 25 []
633470 October 01, 2019 - 04:22:00 UTC 37.75354 -122.42749 San Francisco 25 []
633477 October 01, 2019 - 04:57:00 UTC 37.75326 -122.42691 San Francisco 25 []
633478 October 01, 2019 - 04:58:00 UTC 37.25687 -120.43449 Merced 13 []
633479 October 01, 2019 - 04:28:00 UTC 37.75334 -122.42578 San Francisco 25 []
633480 October 01, 2019 - 05:07:09 UTC 37.70999 -122.17583 San Leandro 27 []
633481 October 01, 2019 - 05:08:00 UTC 37.69717 -122.08699 Castro Valley 4 []
633483 October 01, 2019 - 05:42:00 UTC 37.50476 -122.25824 San Carlos 24 []
633484 October 01, 2019 - 05:48:00 UTC 37.75475 -122.42896 San Francisco 25 []
633485 October 01, 2019 - 05:54:46 UTC 38.1891 -120.82691 Valley Springs 32 []
633503 October 01, 2019 - 06:59:16 UTC 36.76072 -119.7904 Fresno 35 []
633504 October 01, 2019 - 07:07:00 UTC 37.25754 -120.4345 Merced 13 []
633505 October 01, 2019 - 07:15:17 UTC 37.66473 -121.92102 Pleasanton 36 []
633506 October 01, 2019 - 07:26:23 UTC 37.95652 -122.11536 Martinez 37 []
633507 October 01, 2019 - 07:29:11 UTC 37.95491 -122.11647 Martinez 37 []
633508 October 01, 2019 - 07:49:16 UTC 37.77156 -121.42335 Tracy 38 []
633509 October 01, 2019 - 07:58:30 UTC 37.95498 -122.11657 Martinez 37 []
633510 October 01, 2019 - 07:38:00 UTC 37.95855 -122.11232 Martinez 37 []
633512 October 01, 2019 - 10:13:25 UTC 36.81268 -119.76425 Fresno 35 []
633518 October 01, 2019 - 11:15:47 UTC 39.73895 -121.85833 Chico 41 []
633519 October 01, 2019 - 11:16:20 UTC 37.99355 -121.84289 Antioch 42 []
633526 October 01, 2019 - 11:28:11 UTC 37.29066 -121.95854 Campbell 43 []
633528 October 01, 2019 - 11:31:53 UTC 37.29 -121.9594 Campbell 43 []
633529 October 01, 2019 - 11:47:34 UTC 37.33543 -121.84029 San Jose 26 []
633530 October 01, 2019 - 11:59:58 UTC 37.10504 -119.59209 Friant 44 []
633531 October 01, 2019 - 12:12:31 UTC 37.77165 -122.1718 Oakland 16 []
633532 October 01, 2019 - 12:23:42 UTC 37.79305 -122.18292 Oakland 16 []
633534 October 01, 2019 - 12:29:42 UTC 37.29078 -121.97536 San Jose 26 []
633535 October 01, 2019 - 12:33:38 UTC 38.4844 -121.78781 Dixon 45 []
633537 October 01, 2019 - 12:44:50 UTC 37.29243 -121.96658 Campbell 43 []
633538 October 01, 2019 - 12:45:51 UTC 37.95276 -121.95995 Concord 46 []
633541 October 01, 2019 - 12:51:17 UTC 37.86079 -122.29415 Berkeley 47 []
633543 October 01, 2019 - 12:57:54 UTC 37.75363 -122.50554 San Francisco 25 []
633544 October 01, 2019 - 12:58:52 UTC 37.36572 -121.83425 San Jose 26 []
633545 October 01, 2019 - 13:02:00 UTC 35.64097 -120.84891 Paso Robles 48 []
633546 October 01, 2019 - 13:07:08 UTC 37.87055 -122.03021 Walnut Creek 33 []
633548 October 01, 2019 - 13:39:35 UTC 34.93489 -120.45556 Santa Maria 52 []
633549 October 01, 2019 - 13:43:00 UTC 37.29066 -121.95854 Campbell 43 []
633550 October 01, 2019 - 13:45:10 UTC 36.13872 -120.12345 Huron 51 []
633551 October 01, 2019 - 13:45:22 UTC 36.13871 -120.12345 Huron 51 []
633552 October 01, 2019 - 13:45:32 UTC 36.13868 -120.12345 Huron 51 []
633558 October 01, 2019 - 13:51:58 UTC 37.92282 -121.91097 Clayton 53 []
633559 October 01, 2019 - 13:54:21 UTC 37.61449 -122.40357 San Bruno 55 []
633560 October 01, 2019 - 14:13:00 UTC 40.38603 -122.26401 Cottonwood 56 []
633561 October 01, 2019 - 14:16:30 UTC 35.49357 -120.52968 Creston 58 []
633568 October 01, 2019 - 14:19:49 UTC 37.74225 -122.16565 Oakland 16 []
633569 October 01, 2019 - 14:20:43 UTC 35.46595 -120.55312 Creston 58 []
633570 October 01, 2019 - 14:21:03 UTC 35.47852 -120.57438 Creston 58 []
633571 October 01, 2019 - 14:21:58 UTC 36.81966 -119.70132 Clovis 57 []
633572 October 01, 2019 - 14:22:27 UTC 37.72031 -122.38494 San Francisco 25 []
633574 October 01, 2019 - 14:22:58 UTC 38.72937 -121.782 Woodland 34 []
633575 October 01, 2019 - 14:16:30 UTC 35.49544 -120.53068 Creston 58 []
633576 October 01, 2019 - 14:16:30 UTC 35.48927 -120.56357 Templeton 60 []
633577 October 01, 2019 - 14:16:29 UTC 35.4698 -120.56969 Creston 58 []
633580 October 01, 2019 - 14:30:07 UTC 36.67409 -120.14191 Kerman 61 []
633581 October 01, 2019 - 14:33:00 UTC 35.51321 -120.70711 Atascadero 40 []
633582 October 01, 2019 - 14:35:07 UTC 38.72181 -121.83119 Woodland 34 []
633583 October 01, 2019 - 14:38:00 UTC 39.11232 -121.06791 Alta Sierra 62 []
633584 October 01, 2019 - 14:39:09 UTC 37.77368 -122.49814 San Francisco 25 []
633585 October 01, 2019 - 14:39:08 UTC 36.81547 -121.70108 Elkhorn 63 []
633586 October 01, 2019 - 14:42:30 UTC 38.03178 -122.2639 Rodeo 65 []
633587 October 01, 2019 - 14:43:34 UTC 39.73326 -122.12754 Orland 64 []
633588 October 01, 2019 - 14:46:51 UTC 38.50659 -122.76356 Larkfield-Wikiup 67 []
633589 October 01, 2019 - 14:46:56 UTC 38.04554 -121.63728 Bethel Island 66 []
633591 October 01, 2019 - 14:49:41 UTC 40.51612 -121.94749 Shingletown 70 []
633593 October 01, 2019 - 14:56:53 UTC 39.28175 -120.92362 Nevada City 69 []
633594 October 01, 2019 - 14:57:11 UTC 37.91565 -122.02158 Walnut Creek 33 []
633595 October 01, 2019 - 15:01:57 UTC 38.92692 -123.72513 Point Arena 77 []
633596 October 01, 2019 - 15:01:57 UTC 37.99376 -122.13382 Martinez 37 []
633597 October 01, 2019 - 15:02:19 UTC 38.95303 -122.90039 Lakeport 75 []
633598 October 01, 2019 - 15:02:00 UTC 36.92033 -119.96411 Madera 76 []
633600 October 01, 2019 - 14:59:57 UTC 36.30899 -119.72845 Lemoore 11 []
633604 October 01, 2019 - 15:06:32 UTC 40.31934 -122.33431 Cottonwood 56 []
633605 October 01, 2019 - 15:06:00 UTC 38.68814 -120.81158 Diamond Springs 72 []

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