outages

89,825 rows sorted by outageStartTime descending

View and edit SQL

id outageStartTime ▲ latitude longitude regionName outageDevices
1102893 October 01, 2020 - 06:33:27 UTC 39.2523 -123.17596 Redwood Valley 103 []
1102880 October 01, 2020 - 05:50:00 UTC 38.94786 -121.19704 Lincoln 245 [{"latitude": "38.94945", "longitude": "-121.19594"}, {"latitude": "38.95252", "longitude": "-121.18792"}, {"latitude": "38.95561", "longitude": "-121.18699"}, {"latitude": "38.95705", "longitude": "-121.18764"}, {"latitude": "38.96891", "longitude": "-121.19899"}, {"latitude": "38.95134", "longitude": "-121.199"}]
1102876 October 01, 2020 - 05:38:00 UTC 37.7523 -122.1746 Oakland 16 []
1102878 October 01, 2020 - 05:38:00 UTC 37.75268 -122.17378 Oakland 16 [{"latitude": "37.75284", "longitude": "-122.17345"}, {"latitude": "37.75303", "longitude": "-122.17303"}, {"latitude": "37.75377", "longitude": "-122.17145"}]
1102863 October 01, 2020 - 05:30:40 UTC 38.80772 -121.29448 Rocklin 252 []
1102862 October 01, 2020 - 05:17:51 UTC 35.44869 -119.62488 Buttonwillow 162 []
1102861 October 01, 2020 - 05:16:45 UTC 37.98747 -122.52536 San Rafael 144 []
1102860 October 01, 2020 - 05:13:57 UTC 37.38842 -120.61469 Winton 534 []
1102859 October 01, 2020 - 05:05:51 UTC 36.90893 -121.76949 Watsonville 49 [{"latitude": "36.90945", "longitude": "-121.77156"}, {"latitude": "36.90952", "longitude": "-121.77283"}, {"latitude": "36.90949", "longitude": "-121.77236"}]
1102858 October 01, 2020 - 04:59:00 UTC 39.32927 -121.40695 Loma Rica 641 []
1102857 October 01, 2020 - 04:58:27 UTC 37.66013 -122.42344 South San Francisco 156 []
1102856 October 01, 2020 - 04:48:21 UTC 37.7839 -122.44355 San Francisco 25 []
1102854 October 01, 2020 - 04:15:00 UTC 38.0946 -122.93788 Inverness 402 [{"latitude": "37.99454", "longitude": "-122.97464"}, {"latitude": "38.02878", "longitude": "-122.96028"}, {"latitude": "38.09579", "longitude": "-122.94753"}, {"latitude": "38.07505", "longitude": "-122.96499"}, {"latitude": "38.03656", "longitude": "-122.9929"}, {"latitude": "37.99733", "longitude": "-123.0193"}]
1102852 October 01, 2020 - 04:09:34 UTC 37.74546 -122.42297 San Francisco 25 []
1102851 October 01, 2020 - 03:59:45 UTC 37.07515 -120.83837 Los Banos 197 []
1102850 October 01, 2020 - 03:40:05 UTC 39.435 -121.07677 Camptonville 513 []
1102846 October 01, 2020 - 03:20:45 UTC 36.73273 -119.73779 Fresno 35 []
1102845 October 01, 2020 - 03:11:05 UTC 35.40411 -119.60739 Mc Kittrick 495 []
1102844 October 01, 2020 - 03:05:42 UTC 38.02629 -121.33298 Stockton 78 []
1102843 October 01, 2020 - 03:05:03 UTC 37.48661 -122.26552 San Carlos 24 []
1102841 October 01, 2020 - 02:55:06 UTC 37.99721 -122.30659 Pinole 329 []
1102839 October 01, 2020 - 02:50:24 UTC 37.45174 -119.94205 Mariposa 284 []
1102838 October 01, 2020 - 02:46:00 UTC 39.2523 -123.17597 Redwood Valley 103 []
1102837 October 01, 2020 - 02:40:00 UTC 37.76525 -122.19243 Oakland 16 []
1102836 October 01, 2020 - 02:39:09 UTC 37.33255 -121.87794 San Jose 26 []
1102835 October 01, 2020 - 02:33:24 UTC 36.81209 -119.78192 Fresno 35 []
1102833 October 01, 2020 - 02:29:32 UTC 36.35015 -119.80769 Lemoore 11 [{"latitude": "36.34975", "longitude": "-119.7992"}, {"latitude": "36.35008", "longitude": "-119.80166"}, {"latitude": "36.35015", "longitude": "-119.80743"}, {"latitude": "36.35015", "longitude": "-119.8076"}]
1102832 October 01, 2020 - 02:27:16 UTC 37.09671 -121.6528 Morgan Hill 319 []
1102831 October 01, 2020 - 02:18:06 UTC 35.39784 -119.61032 Mc Kittrick 495 []
1102830 October 01, 2020 - 02:14:07 UTC 36.66139 -121.65257 Salinas 23 []
1102829 October 01, 2020 - 02:07:44 UTC 36.81776 -119.77251 Fresno 35 [{"latitude": "36.81775", "longitude": "-119.77463"}, {"latitude": "36.81776", "longitude": "-119.77282"}, {"latitude": "36.81776", "longitude": "-119.77372"}, {"latitude": "36.81775", "longitude": "-119.77558"}]
1102828 October 01, 2020 - 02:06:31 UTC 35.32279 -118.99038 Bakersfield 2 []
1102826 October 01, 2020 - 01:59:51 UTC 37.53273 -121.92931 Fremont 140 []
1102825 October 01, 2020 - 01:58:19 UTC 38.35703 -122.013 Vacaville 367 []
1102824 October 01, 2020 - 01:54:00 UTC 38.03274 -121.29368 Stockton 78 []
1102822 October 01, 2020 - 01:51:20 UTC 35.3961 -119.01655 Bakersfield 2 []
1102819 October 01, 2020 - 01:49:50 UTC 37.7888 -122.18008 Oakland 16 []
1102815 October 01, 2020 - 01:41:57 UTC 36.99768 -119.98296 Madera 76 [{"latitude": "36.99812", "longitude": "-119.98313"}, {"latitude": "36.9999", "longitude": "-119.97714"}, {"latitude": "37.00102", "longitude": "-119.97633"}, {"latitude": "37.00248", "longitude": "-119.9755"}, {"latitude": "37.00349", "longitude": "-119.97497"}, {"latitude": "37.0042", "longitude": "-119.97574"}, {"latitude": "37.00505", "longitude": "-119.97865"}, {"latitude": "36.99861", "longitude": "-119.98494"}]
1102813 October 01, 2020 - 01:40:36 UTC 38.12124 -122.23776 Vallejo 154 []
1102803 October 01, 2020 - 01:38:07 UTC 35.52851 -121.06142 Cambria 3 []
1102800 October 01, 2020 - 01:34:00 UTC 37.75794 -122.4086 San Francisco 25 []
1102797 October 01, 2020 - 01:27:33 UTC 40.8564 -124.07024 Arcata 230 []
1102795 October 01, 2020 - 01:25:09 UTC 37.5625 -121.17834 Grayson 834 []
1102794 October 01, 2020 - 01:23:13 UTC 40.02987 -122.11748 Los Molinos 506 []
1102798 October 01, 2020 - 01:21:00 UTC 36.11237 -121.03796 Lockwood 114 [{"latitude": "36.08632", "longitude": "-121.0713"}, {"latitude": "36.12075", "longitude": "-121.06091"}, {"latitude": "36.13003", "longitude": "-121.06742"}, {"latitude": "36.14214", "longitude": "-121.0797"}, {"latitude": "36.14969", "longitude": "-121.09304"}, {"latitude": "36.1472", "longitude": "-121.10041"}, {"latitude": "36.14196", "longitude": "-121.10422"}, {"latitude": "36.1127", "longitude": "-121.10327"}, {"latitude": "36.09184", "longitude": "-121.08183"}]
1102793 October 01, 2020 - 01:15:26 UTC 39.37614 -121.59534 Oroville 166 []
1102773 October 01, 2020 - 01:02:02 UTC 37.31294 -121.91036 San Jose 26 []
1102754 October 01, 2020 - 00:56:23 UTC 36.9459 -119.37051 Tollhouse 79 []
1102753 October 01, 2020 - 00:56:02 UTC 39.21857 -123.20153 Ukiah 377 []
1102750 October 01, 2020 - 00:54:53 UTC 36.6809 -119.73821 Fresno 35 []
1102748 October 01, 2020 - 00:50:32 UTC 36.68996 -119.64744 Fresno 35 []
1102747 October 01, 2020 - 00:49:02 UTC 35.38288 -118.97781 Bakersfield 2 []
1102746 October 01, 2020 - 00:41:52 UTC 37.74468 -122.18644 Oakland 16 []
1102745 October 01, 2020 - 00:41:49 UTC 36.62133 -121.92538 Pacific Grove 247 []
1102744 October 01, 2020 - 00:35:48 UTC 38.45525 -122.64565 Santa Rosa 30 []
1102743 October 01, 2020 - 00:34:00 UTC 38.88579 -121.28134 Lincoln 245 []
1102739 October 01, 2020 - 00:22:00 UTC 37.75738 -122.17091 Oakland 16 []
1102734 October 01, 2020 - 00:08:10 UTC 37.78788 -122.23194 Oakland 16 []
1102732 October 01, 2020 - 00:07:13 UTC 37.78807 -122.23078 Oakland 16 []
1102730 September 30, 2020 - 23:56:18 UTC 37.64697 -122.46429 South San Francisco 156 []
1102729 September 30, 2020 - 23:55:40 UTC 38.65751 -121.76022 Woodland 34 []
1102728 September 30, 2020 - 23:49:49 UTC 36.52271 -121.43659 Gonzales 406 []
1102727 September 30, 2020 - 23:45:00 UTC 35.45108 -120.90685 Cayucos 370 [{"latitude": "35.44888", "longitude": "-120.9104"}, {"latitude": "35.44964", "longitude": "-120.90898"}, {"latitude": "35.45401", "longitude": "-120.90709"}, {"latitude": "35.49086", "longitude": "-120.90759"}, {"latitude": "35.51678", "longitude": "-120.92718"}, {"latitude": "35.5369", "longitude": "-120.9514"}, {"latitude": "35.52851", "longitude": "-121.06142"}, {"latitude": "35.52215", "longitude": "-121.06328"}, {"latitude": "35.51008", "longitude": "-121.05596"}, {"latitude": "35.49557", "longitude": "-121.04006"}, {"latitude": "35.46035", "longitude": "-120.98197"}, {"latitude": "35.45963", "longitude": "-120.97818"}, {"latitude": "35.4495", "longitude": "-120.91666"}, {"latitude": "35.44896", "longitude": "-120.91228"}, {"latitude": "35.44888", "longitude": "-120.91122"}]
1102726 September 30, 2020 - 23:44:19 UTC 37.42437 -122.07572 Mountain View 242 []
1102725 September 30, 2020 - 23:43:01 UTC 37.91254 -122.02584 Walnut Creek 33 []
1102718 September 30, 2020 - 23:39:00 UTC 36.54001 -121.9169 Carmel 378 []
1102724 September 30, 2020 - 23:37:00 UTC 37.09291 -121.64723 Morgan Hill 319 [{"latitude": "37.01952", "longitude": "-121.6529"}, {"latitude": "37.0376", "longitude": "-121.5978"}, {"latitude": "37.03788", "longitude": "-121.59724"}, {"latitude": "37.04073", "longitude": "-121.59534"}, {"latitude": "37.05601", "longitude": "-121.60153"}, {"latitude": "37.08359", "longitude": "-121.6271"}, {"latitude": "37.08548", "longitude": "-121.62955"}, {"latitude": "37.09628", "longitude": "-121.64952"}, {"latitude": "37.09728", "longitude": "-121.65204"}, {"latitude": "37.09753", "longitude": "-121.65585"}, {"latitude": "37.0739", "longitude": "-121.72632"}, {"latitude": "37.04262", "longitude": "-121.74157"}, {"latitude": "37.02832", "longitude": "-121.71337"}]
1102717 September 30, 2020 - 23:36:40 UTC 36.77212 -119.77192 Fresno 35 []
1102716 September 30, 2020 - 23:36:24 UTC 37.96327 -122.03977 Concord 46 []
1102714 September 30, 2020 - 23:34:50 UTC 37.93312 -122.3701 Richmond 220 []
1102713 September 30, 2020 - 23:34:35 UTC 37.60556 -122.3883 Millbrae 173 []
1102712 September 30, 2020 - 23:34:31 UTC 37.75815 -122.44959 San Francisco 25 []
1102711 September 30, 2020 - 23:33:49 UTC 35.49456 -119.28267 Shafter 448 []
1102709 September 30, 2020 - 23:31:39 UTC 39.85559 -121.58334 Magalia 481 []
1102708 September 30, 2020 - 23:29:16 UTC 37.45449 -122.18258 Menlo Park 141 []
1102707 September 30, 2020 - 23:28:09 UTC 39.41189 -123.3551 Willits 327 []
1102706 September 30, 2020 - 23:27:35 UTC 37.65745 -122.38289 South San Francisco 156 []
1102705 September 30, 2020 - 23:27:12 UTC 39.76225 -121.86624 Chico 41 []
1102704 September 30, 2020 - 23:27:03 UTC 37.6564 -122.47592 Pacifica 174 []
1102703 September 30, 2020 - 23:26:56 UTC 39.76635 -121.84267 Chico 41 []
1102701 September 30, 2020 - 23:25:52 UTC 37.86237 -122.29573 Berkeley 47 []
1102702 September 30, 2020 - 23:25:47 UTC 37.86025 -122.29505 Berkeley 47 []
1102700 September 30, 2020 - 23:25:19 UTC 39.21857 -123.20153 Ukiah 377 []
1102699 September 30, 2020 - 23:24:58 UTC 38.19535 -120.82986 Valley Springs 32 []
1102698 September 30, 2020 - 23:24:03 UTC 39.15989 -121.56711 Marysville 198 []
1102697 September 30, 2020 - 23:23:45 UTC 38.02174 -121.30139 Stockton 78 []
1102696 September 30, 2020 - 23:22:56 UTC 38.58333 -122.83099 Healdsburg 188 []
1102695 September 30, 2020 - 23:22:39 UTC 37.30806 -121.89941 San Jose 26 []
1102694 September 30, 2020 - 23:21:34 UTC 37.84104 -122.03279 Alamo 251 []
1102683 September 30, 2020 - 23:20:09 UTC 36.87466 -121.35303 Hollister 201 []
1102681 September 30, 2020 - 23:19:07 UTC 39.00581 -121.44546 Wheatland 526 []
1102693 September 30, 2020 - 23:19:00 UTC 38.61823 -121.79363 Woodland 34 [{"latitude": "38.56478", "longitude": "-121.78528"}, {"latitude": "38.56707", "longitude": "-121.78123"}, {"latitude": "38.64719", "longitude": "-121.66554"}, {"latitude": "38.65799", "longitude": "-121.66763"}, {"latitude": "38.6653", "longitude": "-121.66921"}, {"latitude": "38.66202", "longitude": "-121.77574"}, {"latitude": "38.65996", "longitude": "-121.78607"}, {"latitude": "38.65891", "longitude": "-121.79035"}, {"latitude": "38.65801", "longitude": "-121.79182"}, {"latitude": "38.59162", "longitude": "-121.79934"}, {"latitude": "38.57008", "longitude": "-121.79249"}]
1102680 September 30, 2020 - 23:16:50 UTC 36.77198 -119.84994 Fresno 35 []
1102679 September 30, 2020 - 23:16:45 UTC 35.48192 -119.14622 Shafter 448 [{"latitude": "35.47637", "longitude": "-119.14637"}, {"latitude": "35.47714", "longitude": "-119.14634"}, {"latitude": "35.47749", "longitude": "-119.14634"}]
1102678 September 30, 2020 - 23:15:55 UTC 37.6869 -121.75291 Livermore 12 []
1102677 September 30, 2020 - 23:15:36 UTC 37.55461 -122.03196 Newark 225 []
1102676 September 30, 2020 - 23:14:00 UTC 38.01378 -121.32241 Stockton 78 [{"latitude": "38.00769", "longitude": "-121.32967"}, {"latitude": "38.01041", "longitude": "-121.32448"}, {"latitude": "38.01362", "longitude": "-121.32262"}, {"latitude": "38.01431", "longitude": "-121.32293"}, {"latitude": "38.01818", "longitude": "-121.33056"}, {"latitude": "38.01265", "longitude": "-121.33556"}, {"latitude": "38.01156", "longitude": "-121.3364"}]
1102675 September 30, 2020 - 23:10:41 UTC 37.89157 -122.26167 Berkeley 47 []
1102674 September 30, 2020 - 23:09:58 UTC 38.44407 -121.83656 Dixon 45 []
1102657 September 30, 2020 - 23:02:13 UTC 37.70004 -122.485 Daly City 124 []

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