outages

76,672 rows sorted by outageStartTime descending

View and edit SQL

id outageStartTime ▲ latitude longitude regionName outageDevices
790757 February 14, 2020 - 12:05:25 UTC 37.35922 -121.84547 San Jose 26 []
790756 February 14, 2020 - 11:49:36 UTC 37.84847 -122.26193 Oakland 16 []
790755 February 14, 2020 - 11:38:17 UTC 35.73397 -119.73413 Lost Hills 126 []
790754 February 14, 2020 - 11:19:30 UTC 38.85497 -122.53459 Lower Lake 401 []
790752 February 14, 2020 - 10:30:00 UTC 38.0264 -121.30396 Stockton 78 []
790749 February 14, 2020 - 10:25:15 UTC 37.95763 -121.30405 Stockton 78 []
790750 February 14, 2020 - 10:25:15 UTC 37.95775 -121.3033 Stockton 78 []
790751 February 14, 2020 - 10:25:00 UTC 38.02003 -121.28048 Stockton 78 [{"latitude": "38.01312", "longitude": "-121.28462"}, {"latitude": "38.01353", "longitude": "-121.28295"}, {"latitude": "38.01409", "longitude": "-121.28123"}, {"latitude": "38.01653", "longitude": "-121.28101"}, {"latitude": "38.01933", "longitude": "-121.28093"}, {"latitude": "38.02485", "longitude": "-121.28241"}, {"latitude": "38.02566", "longitude": "-121.28335"}, {"latitude": "38.02705", "longitude": "-121.28517"}, {"latitude": "38.02415", "longitude": "-121.29067"}, {"latitude": "38.02309", "longitude": "-121.29055"}, {"latitude": "38.01669", "longitude": "-121.28863"}]
790748 February 14, 2020 - 09:50:08 UTC 38.30352 -120.25571 Arnold 131 []
790747 February 14, 2020 - 09:25:16 UTC 38.04522 -122.14633 Benicia 748 []
790746 February 14, 2020 - 09:13:01 UTC 37.99554 -121.67864 Oakley 165 []
790745 February 14, 2020 - 09:12:00 UTC 37.90831 -122.53611 Mill Valley 239 []
790744 February 14, 2020 - 09:04:39 UTC 40.93954 -124.10393 McKinleyville 333 [{"latitude": "40.9379", "longitude": "-124.10354"}, {"latitude": "40.94015", "longitude": "-124.10118"}, {"latitude": "40.94074", "longitude": "-124.1012"}, {"latitude": "40.94029", "longitude": "-124.10402"}, {"latitude": "40.93969", "longitude": "-124.10528"}, {"latitude": "40.93909", "longitude": "-124.10528"}, {"latitude": "40.93828", "longitude": "-124.10459"}]
790743 February 14, 2020 - 09:01:00 UTC 37.99148 -121.6682 Oakley 165 [{"latitude": "37.99695", "longitude": "-121.66838"}, {"latitude": "37.99865", "longitude": "-121.6599"}, {"latitude": "38.01176", "longitude": "-121.642"}, {"latitude": "38.01184", "longitude": "-121.64355"}, {"latitude": "38.01185", "longitude": "-121.64764"}, {"latitude": "38.01185", "longitude": "-121.64811"}, {"latitude": "38.01169", "longitude": "-121.65808"}, {"latitude": "38.01081", "longitude": "-121.66339"}, {"latitude": "38.00444", "longitude": "-121.66831"}, {"latitude": "38.00181", "longitude": "-121.66881"}]
790742 February 14, 2020 - 08:53:51 UTC 35.1778 -119.54032 Fellows 195 []
790741 February 14, 2020 - 08:51:15 UTC 38.00501 -121.89947 Pittsburg 204 []
790740 February 14, 2020 - 08:41:22 UTC 37.72152 -122.40117 San Francisco 25 []
790739 February 14, 2020 - 08:33:55 UTC 36.50935 -119.37671 Dinuba 194 [{"latitude": "36.50548", "longitude": "-119.38115"}, {"latitude": "36.50937", "longitude": "-119.37885"}, {"latitude": "36.51366", "longitude": "-119.38352"}, {"latitude": "36.51366", "longitude": "-119.38443"}, {"latitude": "36.51285", "longitude": "-119.38557"}, {"latitude": "36.50935", "longitude": "-119.38687"}]
790738 February 14, 2020 - 08:20:44 UTC 37.90359 -122.53656 Mill Valley 239 [{"latitude": "37.90096", "longitude": "-122.53611"}, {"latitude": "37.90144", "longitude": "-122.53544"}, {"latitude": "37.90224", "longitude": "-122.5349"}, {"latitude": "37.90622", "longitude": "-122.53513"}, {"latitude": "37.90686", "longitude": "-122.53711"}, {"latitude": "37.9041", "longitude": "-122.54199"}, {"latitude": "37.90376", "longitude": "-122.54153"}]
790737 February 14, 2020 - 08:07:11 UTC 37.63272 -122.06312 Hayward 170 []
790736 February 14, 2020 - 07:36:15 UTC 37.7559 -122.41339 San Francisco 25 []
790735 February 14, 2020 - 07:34:26 UTC 37.45783 -122.13839 East Palo Alto 291 []
790734 February 14, 2020 - 07:17:49 UTC 37.99638 -121.7301 Oakley 165 []
790733 February 14, 2020 - 07:09:00 UTC 38.92134 -120.8277 Georgetown 161 []
790732 February 14, 2020 - 07:07:54 UTC 37.6531 -122.46897 Daly City 124 []
790731 February 14, 2020 - 06:42:09 UTC 37.75716 -122.19293 Oakland 16 []
790730 February 14, 2020 - 06:39:00 UTC 37.10001 -120.93058 Volta 875 [{"latitude": "37.07681", "longitude": "-120.86853"}, {"latitude": "37.07743", "longitude": "-120.85896"}, {"latitude": "37.0845", "longitude": "-120.85564"}, {"latitude": "37.08452", "longitude": "-120.85564"}, {"latitude": "37.11414", "longitude": "-120.86137"}, {"latitude": "37.12662", "longitude": "-120.86543"}, {"latitude": "37.1364", "longitude": "-120.89711"}, {"latitude": "37.10699", "longitude": "-120.92531"}, {"latitude": "37.10001", "longitude": "-120.92923"}]
790729 February 14, 2020 - 06:37:13 UTC 37.78735 -122.20268 Oakland 16 []
790728 February 14, 2020 - 06:28:32 UTC 37.78993 -122.20506 Oakland 16 []
790727 February 14, 2020 - 06:17:47 UTC 37.9339 -122.36474 Richmond 220 []
790726 February 14, 2020 - 06:17:23 UTC 37.30761 -121.02927 Newman 355 []
790723 February 14, 2020 - 06:13:14 UTC 37.07277 -121.9815 Santa Cruz 104 []
790724 February 14, 2020 - 06:13:14 UTC 37.07129 -121.9807 Santa Cruz 104 []
790725 February 14, 2020 - 06:13:14 UTC 37.0703 -121.98523 Santa Cruz 104 []
790722 February 14, 2020 - 06:12:09 UTC 38.50709 -122.92489 Forestville 214 []
790721 February 14, 2020 - 06:07:29 UTC 35.28174 -120.65683 San Luis Obispo 28 [{"latitude": "35.28151", "longitude": "-120.65805"}, {"latitude": "35.2819", "longitude": "-120.65702"}, {"latitude": "35.28313", "longitude": "-120.65823"}, {"latitude": "35.28407", "longitude": "-120.65922"}, {"latitude": "35.28328", "longitude": "-120.65996"}]
790720 February 14, 2020 - 06:06:42 UTC 35.28237 -120.65767 San Luis Obispo 28 [{"latitude": "35.28144", "longitude": "-120.65864"}, {"latitude": "35.28253", "longitude": "-120.65706"}, {"latitude": "35.28202", "longitude": "-120.658"}]
790719 February 14, 2020 - 05:57:31 UTC 39.23125 -123.20333 Calpella 660 []
790718 February 14, 2020 - 05:49:11 UTC 36.72455 -119.8267 Fresno 35 []
790717 February 14, 2020 - 05:42:00 UTC 38.9026 -122.06173 Dunnigan 442 []
790716 February 14, 2020 - 05:33:00 UTC 40.57803 -124.26206 Ferndale 112 []
790715 February 14, 2020 - 05:21:37 UTC 35.25963 -118.99362 Bakersfield 2 []
790714 February 14, 2020 - 05:20:05 UTC 37.74302 -122.42871 San Francisco 25 []
790713 February 14, 2020 - 05:06:50 UTC 37.73995 -122.48397 San Francisco 25 []
790712 February 14, 2020 - 05:05:00 UTC 37.74113 -122.42981 San Francisco 25 []
790711 February 14, 2020 - 05:01:00 UTC 38.44526 -122.70611 Santa Rosa 30 []
790710 February 14, 2020 - 04:50:34 UTC 37.29939 -121.93051 San Jose 26 []
790709 February 14, 2020 - 04:50:02 UTC 36.75197 -119.78211 Fresno 35 []
790708 February 14, 2020 - 04:40:00 UTC 39.12865 -121.64209 Yuba City 344 []
790706 February 14, 2020 - 04:38:00 UTC 40.1793 -122.24867 Red Bluff 20 []
790707 February 14, 2020 - 04:38:00 UTC 40.17925 -122.24867 Red Bluff 20 []
790705 February 14, 2020 - 04:37:44 UTC 36.87206 -119.73594 Fresno 35 [{"latitude": "36.87238", "longitude": "-119.73702"}, {"latitude": "36.87303", "longitude": "-119.73491"}, {"latitude": "36.87337", "longitude": "-119.73626"}]
790704 February 14, 2020 - 04:28:02 UTC 37.30696 -121.94902 San Jose 26 []
790703 February 14, 2020 - 04:26:46 UTC 37.74045 -122.49041 San Francisco 25 []
790699 February 14, 2020 - 04:21:00 UTC 38.12407 -120.45066 Murphys 676 [{"latitude": "38.10769", "longitude": "-120.45679"}, {"latitude": "38.10994", "longitude": "-120.45113"}, {"latitude": "38.11634", "longitude": "-120.44587"}, {"latitude": "38.12191", "longitude": "-120.44313"}, {"latitude": "38.12279", "longitude": "-120.44813"}, {"latitude": "38.12118", "longitude": "-120.45487"}, {"latitude": "38.10881", "longitude": "-120.46271"}, {"latitude": "38.10859", "longitude": "-120.46231"}]
790697 February 14, 2020 - 04:15:25 UTC 37.72152 -122.40117 San Francisco 25 []
790702 February 14, 2020 - 04:15:00 UTC 36.50944 -119.38564 Dinuba 194 []
790696 February 14, 2020 - 04:12:00 UTC 37.42704 -121.87866 Milpitas 142 []
790694 February 14, 2020 - 04:08:00 UTC 37.91056 -122.31498 Richmond 220 []
790693 February 14, 2020 - 04:04:34 UTC 37.91107 -122.31596 Richmond 220 []
790692 February 14, 2020 - 04:00:28 UTC 37.88777 -122.0864 Saranap 569 []
790691 February 14, 2020 - 03:45:45 UTC 37.72152 -122.40117 San Francisco 25 []
790690 February 14, 2020 - 03:44:02 UTC 37.96429 -121.33399 Stockton 78 []
790689 February 14, 2020 - 03:43:29 UTC 36.90642 -121.77311 Watsonville 49 []
790688 February 14, 2020 - 03:41:43 UTC 37.58044 -122.35129 Burlingame 203 []
790687 February 14, 2020 - 03:37:00 UTC 36.95954 -121.88853 Rio del Mar 490 []
790686 February 14, 2020 - 03:32:53 UTC 37.83483 -121.95913 Diablo 707 []
790685 February 14, 2020 - 03:27:15 UTC 37.50514 -120.0418 Mariposa 284 []
790684 February 14, 2020 - 03:15:25 UTC 37.28981 -120.50374 Merced 13 []
790683 February 14, 2020 - 03:15:14 UTC 37.51762 -122.30626 Belmont 157 []
790682 February 14, 2020 - 03:12:10 UTC 36.9714 -122.02927 Santa Cruz 104 []
790681 February 14, 2020 - 03:07:51 UTC 37.87167 -122.50139 Sausalito 561 []
790679 February 14, 2020 - 02:56:00 UTC 38.24834 -122.05399 Fairfield 169 []
790678 February 14, 2020 - 02:51:01 UTC 37.73319 -122.18825 Oakland 16 []
790676 February 14, 2020 - 02:43:25 UTC 37.38804 -122.01959 Sunnyvale 129 []
790675 February 14, 2020 - 02:41:00 UTC 38.20193 -122.29273 American Canyon 485 []
790674 February 14, 2020 - 02:37:50 UTC 38.03665 -121.28139 Stockton 78 []
790672 February 14, 2020 - 02:28:13 UTC 37.7122 -122.12737 Castro Valley 4 []
790670 February 14, 2020 - 02:20:30 UTC 35.17968 -119.54281 Fellows 195 [{"latitude": "35.17253", "longitude": "-119.54308"}, {"latitude": "35.17511", "longitude": "-119.53997"}, {"latitude": "35.17647", "longitude": "-119.53909"}, {"latitude": "35.17921", "longitude": "-119.54121"}, {"latitude": "35.17964", "longitude": "-119.54281"}, {"latitude": "35.17899", "longitude": "-119.54479"}, {"latitude": "35.1769", "longitude": "-119.54564"}]
790666 February 14, 2020 - 02:16:45 UTC 38.43219 -122.76757 Santa Rosa 30 []
790665 February 14, 2020 - 02:14:05 UTC 38.77431 -123.47818 Cazadero 262 []
790664 February 14, 2020 - 02:11:37 UTC 37.68537 -121.79045 Livermore 12 []
790663 February 14, 2020 - 02:07:23 UTC 35.07626 -118.98411 Bakersfield 2 []
790661 February 14, 2020 - 02:05:21 UTC 37.56963 -122.30687 San Mateo 29 []
790662 February 14, 2020 - 02:03:00 UTC 38.55853 -121.74135 Davis 120 [{"latitude": "38.55856", "longitude": "-121.74104"}, {"latitude": "38.55858", "longitude": "-121.74041"}, {"latitude": "38.55914", "longitude": "-121.73953"}, {"latitude": "38.55983", "longitude": "-121.73894"}]
790660 February 14, 2020 - 02:01:18 UTC 37.66521 -122.4143 South San Francisco 156 []
790659 February 14, 2020 - 02:01:00 UTC 39.33561 -123.80721 Mendocino 379 [{"latitude": "39.33447", "longitude": "-123.8107"}, {"latitude": "39.33536", "longitude": "-123.80818"}, {"latitude": "39.33503", "longitude": "-123.80925"}, {"latitude": "39.33471", "longitude": "-123.81015"}]
790658 February 14, 2020 - 01:59:31 UTC 35.01816 -120.495 Nipomo 413 []
790657 February 14, 2020 - 01:58:24 UTC 36.59095 -119.43617 Reedley 346 []
790656 February 14, 2020 - 01:57:29 UTC 38.1045 -122.25073 Vallejo 154 []
790655 February 14, 2020 - 01:53:21 UTC 38.02171 -121.88523 Pittsburg 204 []
790654 February 14, 2020 - 01:50:36 UTC 37.39028 -122.01256 Sunnyvale 129 []
790653 February 14, 2020 - 01:50:00 UTC 38.20551 -122.2934 Napa 15 []
790651 February 14, 2020 - 01:48:15 UTC 38.81686 -122.7066 Middletown 200 []
790652 February 14, 2020 - 01:46:00 UTC 38.55599 -121.74051 Davis 120 []
790650 February 14, 2020 - 01:45:31 UTC 38.3324 -120.52022 Mokelumne Hill 389 []
790649 February 14, 2020 - 01:42:42 UTC 37.0367 -122.13519 Bonny Doon 551 []
790648 February 14, 2020 - 01:40:52 UTC 38.38116 -120.5234 Mokelumne Hill 389 [{"latitude": "38.36539", "longitude": "-120.50809"}, {"latitude": "38.36985", "longitude": "-120.45232"}, {"latitude": "38.3767", "longitude": "-120.44858"}, {"latitude": "38.39095", "longitude": "-120.44401"}, {"latitude": "38.39292", "longitude": "-120.44412"}, {"latitude": "38.39777", "longitude": "-120.49838"}, {"latitude": "38.39813", "longitude": "-120.50531"}, {"latitude": "38.39781", "longitude": "-120.50858"}, {"latitude": "38.3722", "longitude": "-120.52895"}, {"latitude": "38.36612", "longitude": "-120.51046"}]
790647 February 14, 2020 - 01:38:24 UTC 37.03319 -122.09202 Felton 7 []
790646 February 14, 2020 - 01:37:43 UTC 37.2877 -120.44517 Merced 13 [{"latitude": "37.28594", "longitude": "-120.44624"}, {"latitude": "37.28691", "longitude": "-120.44517"}, {"latitude": "37.28687", "longitude": "-120.44609"}]

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