outages

43,117 rows

View and edit SQL

id outageStartTime latitude longitude regionName outageDevices
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 []
633590 October 01, 2019 - 16:00:00 UTC 34.61365 -120.07835 Santa Ynez 68 [{"latitude": "34.61459", "longitude": "-120.07834"}, {"latitude": "34.61499", "longitude": "-120.07675"}, {"latitude": "34.62218", "longitude": "-120.07108"}, {"latitude": "34.62503", "longitude": "-120.07395"}, {"latitude": "34.62648", "longitude": "-120.07599"}, {"latitude": "34.62061", "longitude": "-120.07754"}, {"latitude": "34.61652", "longitude": "-120.07833"}]
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 []
633599 October 01, 2019 - 15:00:00 UTC 35.30304 -119.01307 Bakersfield 2 [{"latitude": "35.30011", "longitude": "-119.01298"}, {"latitude": "35.30087", "longitude": "-119.01288"}, {"latitude": "35.3025", "longitude": "-119.01298"}, {"latitude": "35.30299", "longitude": "-119.01302"}, {"latitude": "35.30167", "longitude": "-119.01377"}, {"latitude": "35.30017", "longitude": "-119.01377"}]
633600 October 01, 2019 - 14:59:57 UTC 36.30899 -119.72845 Lemoore 11 []
633601 October 01, 2019 - 15:05:15 UTC 37.91753 -121.26085 Stockton 78 [{"latitude": "37.91776", "longitude": "-121.26004"}, {"latitude": "37.91849", "longitude": "-121.25581"}, {"latitude": "37.91956", "longitude": "-121.25738"}, {"latitude": "37.91899", "longitude": "-121.25974"}, {"latitude": "37.91816", "longitude": "-121.26072"}]
633602 October 01, 2019 - 15:05:58 UTC 35.15721 -120.66906 Pismo Beach 18 [{"latitude": "35.15481", "longitude": "-120.66104"}, {"latitude": "35.15737", "longitude": "-120.66584"}, {"latitude": "35.15811", "longitude": "-120.66817"}, {"latitude": "35.15631", "longitude": "-120.66574"}]
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 []
633606 October 01, 2019 - 15:06:00 UTC 36.81494 -120.08761 Kerman 61 []
633608 October 01, 2019 - 15:01:55 UTC 36.95979 -119.38687 Tollhouse 79 []
633609 October 01, 2019 - 15:07:08 UTC 37.27466 -121.91877 San Jose 26 []
633610 October 01, 2019 - 15:07:17 UTC 37.60368 -122.02977 Union City 80 []
633611 October 01, 2019 - 15:02:18 UTC 40.49137 -121.87263 Shingletown 70 []
633612 October 01, 2019 - 15:07:26 UTC 38.3758 -122.30724 Napa 15 []
633613 October 01, 2019 - 15:00:00 UTC 40.68132 -122.18516 Bella Vista 71 [{"latitude": "40.6841", "longitude": "-122.17936"}, {"latitude": "40.68414", "longitude": "-122.18324"}, {"latitude": "40.68413", "longitude": "-122.18641"}]
633614 October 01, 2019 - 15:07:00 UTC 36.2548 -119.69212 Hanford 73 [{"latitude": "36.25358", "longitude": "-119.69094"}, {"latitude": "36.25474", "longitude": "-119.68388"}, {"latitude": "36.25476", "longitude": "-119.68508"}, {"latitude": "36.25481", "longitude": "-119.69108"}]
633615 October 01, 2019 - 15:08:03 UTC 37.52943 -122.34497 Highlands-Baywood Park 74 []
633617 October 01, 2019 - 15:03:29 UTC 36.96727 -119.38702 Tollhouse 79 []
633618 October 01, 2019 - 15:12:01 UTC 37.80208 -122.40423 San Francisco 25 []
633619 October 01, 2019 - 15:30:00 UTC 38.81335 -122.99919 Cloverdale 81 []
633620 October 01, 2019 - 15:12:40 UTC 37.7512 -122.4368 San Francisco 25 []
633621 October 01, 2019 - 15:10:00 UTC 40.49104 -122.31006 Redding 85 [{"latitude": "40.4874", "longitude": "-122.30896"}, {"latitude": "40.48804", "longitude": "-122.30915"}, {"latitude": "40.49001", "longitude": "-122.30975"}, {"latitude": "40.49076", "longitude": "-122.30998"}, {"latitude": "40.48865", "longitude": "-122.30934"}]
633622 October 01, 2019 - 15:08:57 UTC 40.48525 -121.89554 Shingletown 70 []
633623 October 01, 2019 - 15:14:22 UTC 40.38485 -122.2631 Cottonwood 56 []
633624 October 01, 2019 - 15:16:00 UTC 34.95908 -120.51911 Santa Maria 52 [{"latitude": "34.96156", "longitude": "-120.51586"}, {"latitude": "34.96191", "longitude": "-120.51298"}, {"latitude": "34.96866", "longitude": "-120.5142"}, {"latitude": "34.97451", "longitude": "-120.52223"}, {"latitude": "34.96967", "longitude": "-120.52893"}, {"latitude": "34.96956", "longitude": "-120.52899"}, {"latitude": "34.96859", "longitude": "-120.52899"}]
633625 October 01, 2019 - 15:11:34 UTC 36.96717 -119.37555 Tollhouse 79 []
633626 October 01, 2019 - 15:16:00 UTC 39.1353 -121.04059 Alta Sierra 62 []
633627 October 01, 2019 - 15:17:29 UTC 38.69358 -122.83281 Geyserville 82 [{"latitude": "38.67513", "longitude": "-122.80874"}, {"latitude": "38.67767", "longitude": "-122.80338"}, {"latitude": "38.69747", "longitude": "-122.77097"}, {"latitude": "38.70577", "longitude": "-122.77254"}, {"latitude": "38.70872", "longitude": "-122.81481"}, {"latitude": "38.70538", "longitude": "-122.8291"}, {"latitude": "38.69728", "longitude": "-122.83186"}, {"latitude": "38.69488", "longitude": "-122.83233"}, {"latitude": "38.69376", "longitude": "-122.83217"}, {"latitude": "38.67589", "longitude": "-122.81135"}]
633628 October 01, 2019 - 15:17:30 UTC 39.51713 -122.23936 Willows 86 []
633629 October 01, 2019 - 15:17:51 UTC 35.11426 -120.61646 Grover Beach 83 []
633630 October 01, 2019 - 15:18:43 UTC 38.95612 -122.89631 Lakeport 75 []
633634 October 01, 2019 - 15:19:23 UTC 36.43936 -119.63487 Laton 84 []
633635 October 01, 2019 - 15:17:24 UTC 37.74341 -122.46635 San Francisco 25 []
633636 October 01, 2019 - 15:17:52 UTC 36.95897 -119.38115 Tollhouse 79 []
633637 October 01, 2019 - 15:09:50 UTC 36.67996 -119.18248 Squaw Valley 94 []
633638 October 01, 2019 - 15:10:55 UTC 40.53641 -121.78374 Shingletown 70 []
633639 October 01, 2019 - 15:23:14 UTC 37.34955 -120.60969 Atwater 87 []
633640 October 01, 2019 - 15:16:01 UTC 36.60836 -119.64649 Fowler 89 []
633641 October 01, 2019 - 15:19:09 UTC 35.49512 -120.67227 Atascadero 40 []
633642 October 01, 2019 - 15:25:00 UTC 40.08286 -122.39925 Red Bluff 20 [{"latitude": "40.05747", "longitude": "-122.40014"}, {"latitude": "40.07184", "longitude": "-122.3905"}, {"latitude": "40.08255", "longitude": "-122.40097"}, {"latitude": "40.07657", "longitude": "-122.40365"}, {"latitude": "40.05866", "longitude": "-122.40253"}, {"latitude": "40.05794", "longitude": "-122.40171"}]
633643 October 01, 2019 - 15:26:07 UTC 38.11171 -122.59581 Novato 93 []
633646 October 01, 2019 - 15:19:40 UTC 36.6889 -119.19134 Squaw Valley 94 []
633647 October 01, 2019 - 15:27:32 UTC 39.02868 -123.68952 Manchester 92 []
633648 October 01, 2019 - 15:22:40 UTC 36.72143 -119.53365 Centerville 88 []
633649 October 01, 2019 - 15:30:02 UTC 38.40317 -122.51142 Glen Ellen 90 []
633650 October 01, 2019 - 15:30:08 UTC 37.99955 -121.34093 Lincoln Village 91 []
633652 October 01, 2019 - 15:32:01 UTC 39.22797 -121.16254 Rough and Ready 97 []
633654 October 01, 2019 - 15:32:30 UTC 38.28927 -122.64573 Petaluma 96 [{"latitude": "38.28375", "longitude": "-122.64961"}, {"latitude": "38.28739", "longitude": "-122.64979"}, {"latitude": "38.28574", "longitude": "-122.65149"}]
633655 October 01, 2019 - 15:30:00 UTC 40.48431 -122.32419 Redding 85 [{"latitude": "40.48393", "longitude": "-122.32631"}, {"latitude": "40.48412", "longitude": "-122.32536"}, {"latitude": "40.48493", "longitude": "-122.32568"}]
633656 October 01, 2019 - 15:35:14 UTC 37.97116 -122.34512 San Pablo 98 []
633657 October 01, 2019 - 15:35:40 UTC 35.54397 -121.08472 Cambria 3 [{"latitude": "35.54357", "longitude": "-121.08571"}, {"latitude": "35.54413", "longitude": "-121.08219"}, {"latitude": "35.54478", "longitude": "-121.08248"}, {"latitude": "35.54475", "longitude": "-121.08549"}]
633673 October 01, 2019 - 15:36:34 UTC 38.34058 -122.75968 Sebastopol 99 []
633693 October 01, 2019 - 15:39:00 UTC 36.5109 -119.70258 Selma 100 [{"latitude": "36.51091", "longitude": "-119.70895"}, {"latitude": "36.51239", "longitude": "-119.70996"}, {"latitude": "36.51269", "longitude": "-119.71423"}, {"latitude": "36.51269", "longitude": "-119.71443"}, {"latitude": "36.51092", "longitude": "-119.71248"}]
633713 October 01, 2019 - 15:40:48 UTC 37.96152 -121.7146 Brentwood 95 []
633733 October 01, 2019 - 15:43:21 UTC 37.74977 -121.46473 Tracy 38 []
633734 October 01, 2019 - 15:43:19 UTC 36.64298 -121.56889 Salinas 23 []
633735 October 01, 2019 - 15:43:36 UTC 37.94995 -121.7083 Brentwood 95 [{"latitude": "37.95474", "longitude": "-121.7151"}, {"latitude": "37.95485", "longitude": "-121.71219"}, {"latitude": "37.95636", "longitude": "-121.71217"}, {"latitude": "37.957", "longitude": "-121.71252"}, {"latitude": "37.95752", "longitude": "-121.71427"}, {"latitude": "37.95488", "longitude": "-121.71588"}]
633753 October 01, 2019 - 15:44:03 UTC 38.21709 -122.63594 Petaluma 96 [{"latitude": "38.2171", "longitude": "-122.64057"}, {"latitude": "38.21763", "longitude": "-122.63682"}, {"latitude": "38.21898", "longitude": "-122.6375"}, {"latitude": "38.22019", "longitude": "-122.63815"}]
633773 October 01, 2019 - 15:45:58 UTC 37.56931 -122.30385 San Mateo 29 []
633774 October 01, 2019 - 15:46:00 UTC 38.64604 -120.97578 Cameron Park 101 []
633775 October 01, 2019 - 15:46:40 UTC 36.77528 -119.8636 Fresno 35 []
633776 October 01, 2019 - 15:44:28 UTC 36.97009 -122.05138 Santa Cruz 104 []
633777 October 01, 2019 - 15:42:32 UTC 38.45195 -121.82699 Dixon 45 []
633778 October 01, 2019 - 16:00:00 UTC 39.26432 -123.23024 Redwood Valley 103 []
633779 October 01, 2019 - 15:53:07 UTC 36.67977 -121.65286 Salinas 23 []
633780 October 01, 2019 - 15:53:00 UTC 37.77511 -120.82238 Oakdale 102 [{"latitude": "37.77385", "longitude": "-120.82186"}, {"latitude": "37.77486", "longitude": "-120.82235"}, {"latitude": "37.7739", "longitude": "-120.82247"}]
633783 October 01, 2019 - 15:57:00 UTC 37.72426 -120.72623 Oakdale 102 []
633784 October 01, 2019 - 15:56:59 UTC 40.84851 -124.16669 Manila 115 []
633785 October 01, 2019 - 15:57:00 UTC 39.21671 -120.79452 Alta 105 [{"latitude": "39.21074", "longitude": "-120.79341"}, {"latitude": "39.21114", "longitude": "-120.79064"}, {"latitude": "39.21202", "longitude": "-120.78824"}, {"latitude": "39.21778", "longitude": "-120.78288"}, {"latitude": "39.22054", "longitude": "-120.78588"}, {"latitude": "39.21905", "longitude": "-120.79202"}, {"latitude": "39.21669", "longitude": "-120.79395"}, {"latitude": "39.21152", "longitude": "-120.79492"}]
633786 October 01, 2019 - 15:58:17 UTC 35.93635 -121.1071 Lockwood 114 []
633787 October 01, 2019 - 15:59:00 UTC 37.83808 -121.60433 Discovery Bay 110 []
633788 October 01, 2019 - 15:59:44 UTC 38.57836 -121.53946 West Sacramento 118 []
633789 October 01, 2019 - 16:01:00 UTC 40.49893 -122.37347 Anderson 106 []
633790 October 01, 2019 - 16:01:00 UTC 39.23456 -121.1069 Nevada City 69 [{"latitude": "39.23409", "longitude": "-121.10574"}, {"latitude": "39.23834", "longitude": "-121.08989"}, {"latitude": "39.24109", "longitude": "-121.08901"}, {"latitude": "39.24143", "longitude": "-121.08901"}, {"latitude": "39.24202", "longitude": "-121.08902"}, {"latitude": "39.23837", "longitude": "-121.10183"}, {"latitude": "39.23731", "longitude": "-121.10526"}, {"latitude": "39.23615", "longitude": "-121.1062"}, {"latitude": "39.23457", "longitude": "-121.10685"}]
633791 October 01, 2019 - 16:01:00 UTC 38.21274 -120.55908 Mountain Ranch 116 [{"latitude": "38.20908", "longitude": "-120.55879"}, {"latitude": "38.21191", "longitude": "-120.559"}, {"latitude": "38.20988", "longitude": "-120.55899"}]
633792 October 01, 2019 - 16:03:00 UTC 37.70582 -120.11491 Coulterville 109 [{"latitude": "37.70544", "longitude": "-120.11396"}, {"latitude": "37.70671", "longitude": "-120.11662"}, {"latitude": "37.706", "longitude": "-120.11674"}]
633793 October 01, 2019 - 16:03:00 UTC 39.07694 -121.10733 Grass Valley 113 []
633794 October 01, 2019 - 16:04:00 UTC 36.39417 -119.53801 Hanford 73 []
633795 October 01, 2019 - 16:00:06 UTC 38.26855 -120.76325 Valley Springs 32 []
633796 October 01, 2019 - 16:00:00 UTC 39.04242 -121.03184 Grass Valley 113 [{"latitude": "39.04293", "longitude": "-121.03188"}, {"latitude": "39.04428", "longitude": "-121.03192"}, {"latitude": "39.04387", "longitude": "-121.03235"}]
633797 October 01, 2019 - 16:00:00 UTC 40.50248 -124.28154 Ferndale 112 [{"latitude": "40.49745", "longitude": "-124.29537"}, {"latitude": "40.4984", "longitude": "-124.29328"}, {"latitude": "40.49914", "longitude": "-124.29167"}, {"latitude": "40.50114", "longitude": "-124.28739"}]
633798 October 01, 2019 - 16:00:25 UTC 38.37566 -122.71296 Santa Rosa 30 [{"latitude": "38.37289", "longitude": "-122.7018"}, {"latitude": "38.37468", "longitude": "-122.69839"}, {"latitude": "38.37572", "longitude": "-122.698"}, {"latitude": "38.37665", "longitude": "-122.70101"}, {"latitude": "38.37567", "longitude": "-122.71147"}]
633799 October 01, 2019 - 16:05:00 UTC 38.57662 -122.60338 Calistoga 108 []
633800 October 01, 2019 - 16:05:29 UTC 38.31537 -123.02276 Bodega Bay 107 [{"latitude": "38.31498", "longitude": "-123.02097"}, {"latitude": "38.31519", "longitude": "-123.02019"}, {"latitude": "38.31526", "longitude": "-123.022"}]
633801 October 01, 2019 - 16:00:28 UTC 37.95149 -122.32156 East Richmond Heights 111 [{"latitude": "37.95033", "longitude": "-122.31304"}, {"latitude": "37.9505", "longitude": "-122.31217"}, {"latitude": "37.95179", "longitude": "-122.31368"}, {"latitude": "37.95149", "longitude": "-122.32152"}]
633802 October 01, 2019 - 16:05:00 UTC 38.85325 -121.15277 Newcastle 117 [{"latitude": "38.84936", "longitude": "-121.15268"}, {"latitude": "38.85033", "longitude": "-121.15207"}, {"latitude": "38.85107", "longitude": "-121.15176"}, {"latitude": "38.85253", "longitude": "-121.15192"}, {"latitude": "38.85282", "longitude": "-121.15282"}, {"latitude": "38.85028", "longitude": "-121.15283"}]

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