208,627 rows sorted by outageStartTime descending

View and edit SQL

id outageStartTime ▲ latitude longitude regionName outageDevices
1321611 April 18, 2021 - 04:11:57 UTC 37.96169 -121.32625 Stockton 78 []
1321610 April 18, 2021 - 04:05:00 UTC 37.70207 -121.90291 Dublin 290 [{"latitude": "37.68881", "longitude": "-121.89697"}, {"latitude": "37.69007", "longitude": "-121.89674"}, {"latitude": "37.70106", "longitude": "-121.90234"}, {"latitude": "37.69182", "longitude": "-121.90445"}, {"latitude": "37.68946", "longitude": "-121.90189"}]
1321609 April 18, 2021 - 04:01:01 UTC 38.50749 -123.13184 Cazadero 262 []
1321608 April 18, 2021 - 04:00:04 UTC 38.01479 -121.82694 Antioch 42 []
1321607 April 18, 2021 - 03:59:05 UTC 37.70431 -122.44093 Daly City 124 []
1321606 April 18, 2021 - 03:52:40 UTC 37.67155 -122.48187 Daly City 124 []
1321605 April 18, 2021 - 03:52:00 UTC 38.50501 -123.13774 Cazadero 262 [{"latitude": "38.50538", "longitude": "-123.13967"}, {"latitude": "38.51032", "longitude": "-123.14074"}, {"latitude": "38.50895", "longitude": "-123.14621"}, {"latitude": "38.50543", "longitude": "-123.14017"}]
1321604 April 18, 2021 - 03:50:00 UTC 35.15391 -120.67143 Pismo Beach 18 []
1321603 April 18, 2021 - 03:42:00 UTC 38.49665 -123.13654 Cazadero 262 []
1321602 April 18, 2021 - 03:37:02 UTC 38.4939 -123.13874 Cazadero 262 []
1321598 April 18, 2021 - 03:26:51 UTC 38.29781 -122.66935 Penngrove 371 []
1321596 April 18, 2021 - 03:24:59 UTC 37.95747 -121.27674 Stockton 78 []
1321595 April 18, 2021 - 03:23:29 UTC 37.6974 -122.4928 Daly City 124 []
1321594 April 18, 2021 - 03:22:49 UTC 37.85611 -122.07114 Walnut Creek 33 []
1321593 April 18, 2021 - 03:21:43 UTC 36.6615 -121.66417 Salinas 23 []
1321592 April 18, 2021 - 03:19:00 UTC 37.75261 -122.44292 San Francisco 25 []
1321591 April 18, 2021 - 03:18:00 UTC 38.41628 -122.89357 Sebastopol 99 []
1321589 April 18, 2021 - 03:14:16 UTC 37.9646 -122.32829 Rollingwood 529 []
1321590 April 18, 2021 - 03:14:00 UTC 38.41736 -122.89602 Sebastopol 99 []
1321588 April 18, 2021 - 03:10:00 UTC 38.41553 -122.89536 Sebastopol 99 []
1321587 April 18, 2021 - 03:05:25 UTC 37.70887 -122.40815 San Francisco 25 []
1321586 April 18, 2021 - 03:04:15 UTC 37.96169 -121.32625 Stockton 78 []
1321585 April 18, 2021 - 03:02:51 UTC 37.73695 -122.19635 Oakland 16 [{"latitude": "37.73405", "longitude": "-122.1973"}, {"latitude": "37.73602", "longitude": "-122.19364"}, {"latitude": "37.73638", "longitude": "-122.19406"}, {"latitude": "37.7369", "longitude": "-122.19602"}]
1321583 April 18, 2021 - 03:02:23 UTC 37.61923 -122.40595 San Bruno 55 []
1321584 April 18, 2021 - 03:02:00 UTC 38.69027 -120.92926 Shingle Springs 270 [{"latitude": "38.68849", "longitude": "-120.9354"}, {"latitude": "38.68854", "longitude": "-120.93398"}, {"latitude": "38.68925", "longitude": "-120.93176"}, {"latitude": "38.68986", "longitude": "-120.93162"}, {"latitude": "38.69067", "longitude": "-120.93587"}, {"latitude": "38.69004", "longitude": "-120.93794"}, {"latitude": "38.6889", "longitude": "-120.93783"}, {"latitude": "38.68865", "longitude": "-120.93669"}]
1321582 April 18, 2021 - 02:59:23 UTC 37.61915 -122.407 San Bruno 55 []
1321581 April 18, 2021 - 02:59:00 UTC 38.41118 -122.72752 Santa Rosa 30 []
1321580 April 18, 2021 - 02:58:20 UTC 36.76142 -119.79953 Fresno 35 []
1321579 April 18, 2021 - 02:55:29 UTC 37.6183 -122.40754 San Bruno 55 []
1321577 April 18, 2021 - 02:51:09 UTC 37.99647 -121.30178 Stockton 78 []
1321575 April 18, 2021 - 02:37:00 UTC 36.68266 -121.80041 Marina 328 []
1321574 April 18, 2021 - 02:28:20 UTC 40.49314 -124.10712 Rio Dell 353 []
1321573 April 18, 2021 - 02:23:00 UTC 37.92461 -122.34509 Richmond 220 []
1321571 April 18, 2021 - 02:22:00 UTC 39.05898 -121.48706 Wheatland 526 []
1321570 April 18, 2021 - 02:17:10 UTC 37.87361 -122.0958 Lafayette 155 []
1321569 April 18, 2021 - 02:16:46 UTC 37.31332 -122.03437 Cupertino 123 []
1321568 April 18, 2021 - 02:16:34 UTC 38.10127 -121.2441 Lodi 364 []
1321567 April 18, 2021 - 02:16:07 UTC 37.34855 -120.60506 Atwater 87 []
1321566 April 18, 2021 - 02:08:00 UTC 37.13913 -121.60044 Morgan Hill 319 []
1321565 April 18, 2021 - 02:06:00 UTC 38.02608 -121.34207 Stockton 78 []
1321563 April 18, 2021 - 01:52:33 UTC 36.74197 -119.75196 Fresno 35 []
1321562 April 18, 2021 - 01:41:08 UTC 39.74513 -121.84374 Chico 41 []
1321561 April 18, 2021 - 01:29:09 UTC 38.64676 -120.83903 El Dorado 444 []
1321560 April 18, 2021 - 01:27:00 UTC 38.67799 -121.03121 El Dorado Hills 298 []
1321559 April 18, 2021 - 01:26:26 UTC 34.88651 -120.42308 Orcutt 249 []
1321557 April 18, 2021 - 01:15:00 UTC 39.08994 -122.9053 North Lakeport 610 []
1321556 April 18, 2021 - 01:09:28 UTC 36.77819 -119.79351 Fresno 35 []
1321555 April 18, 2021 - 01:03:26 UTC 37.06644 -121.5553 Gilroy 223 []
1321552 April 18, 2021 - 00:57:40 UTC 36.6615 -121.66417 Salinas 23 []
1321551 April 18, 2021 - 00:56:47 UTC 37.25434 -121.90129 San Jose 26 []
1321549 April 18, 2021 - 00:54:25 UTC 37.90758 -122.31254 Richmond 220 []
1321548 April 18, 2021 - 00:54:23 UTC 39.70788 -121.8176 Chico 41 []
1321547 April 18, 2021 - 00:53:46 UTC 38.16686 -122.25778 American Canyon 485 []
1321546 April 18, 2021 - 00:52:45 UTC 37.97641 -121.29191 Stockton 78 []
1321545 April 18, 2021 - 00:47:30 UTC 37.30183 -120.50736 Merced 13 []
1321543 April 18, 2021 - 00:40:53 UTC 39.49328 -123.78441 Cleone 735 []
1321542 April 18, 2021 - 00:40:00 UTC 39.49247 -123.78338 Cleone 735 []
1321540 April 18, 2021 - 00:39:00 UTC 39.49565 -123.78655 Cleone 735 []
1321541 April 18, 2021 - 00:39:00 UTC 39.50068 -123.78495 Cleone 735 []
1321539 April 18, 2021 - 00:38:00 UTC 39.4948 -123.78334 Cleone 735 []
1321538 April 18, 2021 - 00:37:00 UTC 39.4956 -123.78337 Cleone 735 []
1321537 April 18, 2021 - 00:35:00 UTC 37.98736 -121.29096 Stockton 78 [{"latitude": "37.98615", "longitude": "-121.2901"}, {"latitude": "37.98624", "longitude": "-121.28948"}, {"latitude": "37.98713", "longitude": "-121.28976"}, {"latitude": "37.98749", "longitude": "-121.28989"}, {"latitude": "37.98735", "longitude": "-121.29062"}]
1321536 April 18, 2021 - 00:33:27 UTC 37.70583 -122.41006 Daly City 124 []
1321533 April 18, 2021 - 00:32:21 UTC 37.97031 -121.27485 Stockton 78 []
1321534 April 18, 2021 - 00:32:00 UTC 39.50133 -123.78584 Cleone 735 [{"latitude": "39.49689", "longitude": "-123.78675"}, {"latitude": "39.49814", "longitude": "-123.78593"}, {"latitude": "39.5016", "longitude": "-123.78706"}, {"latitude": "39.49828", "longitude": "-123.78941"}, {"latitude": "39.49691", "longitude": "-123.78823"}]
1321535 April 18, 2021 - 00:32:00 UTC 37.87825 -122.29864 Berkeley 47 []
1321531 April 18, 2021 - 00:27:51 UTC 38.24397 -122.05086 Fairfield 169 []
1321530 April 18, 2021 - 00:25:08 UTC 37.42985 -122.19047 Menlo Park 141 []
1321529 April 18, 2021 - 00:24:00 UTC 39.4578 -121.28504 Challenge-Brownsville 635 []
1321528 April 18, 2021 - 00:17:19 UTC 38.56776 -121.53541 West Sacramento 118 []
1321527 April 18, 2021 - 00:15:36 UTC 38.05867 -120.22317 Twain Harte 145 []
1321526 April 18, 2021 - 00:09:05 UTC 38.58155 -121.5456 West Sacramento 118 []
1321525 April 18, 2021 - 00:08:08 UTC 37.96269 -122.32001 San Pablo 98 []
1321524 April 18, 2021 - 00:01:53 UTC 38.50884 -122.69125 Santa Rosa 30 []
1321523 April 17, 2021 - 23:56:34 UTC 38.23222 -121.1622 Dogtown 762 []
1321522 April 17, 2021 - 23:55:00 UTC 38.07943 -122.22729 Vallejo 154 [{"latitude": "38.07908", "longitude": "-122.22262"}, {"latitude": "38.08095", "longitude": "-122.22302"}, {"latitude": "38.08191", "longitude": "-122.2235"}, {"latitude": "38.08278", "longitude": "-122.22434"}, {"latitude": "38.08082", "longitude": "-122.22641"}, {"latitude": "38.08018", "longitude": "-122.22702"}, {"latitude": "38.07941", "longitude": "-122.22679"}, {"latitude": "38.07932", "longitude": "-122.22586"}, {"latitude": "38.07913", "longitude": "-122.22356"}]
1321521 April 17, 2021 - 23:53:55 UTC 39.12797 -121.60883 Yuba City 344 []
1321520 April 17, 2021 - 23:48:45 UTC 37.54911 -122.32656 San Mateo 29 []
1321519 April 17, 2021 - 23:46:58 UTC 36.80386 -119.731 Clovis 57 []
1321518 April 17, 2021 - 23:39:00 UTC 38.91727 -121.06759 Auburn 181 []
1321517 April 17, 2021 - 23:36:31 UTC 37.23973 -122.00446 Monte Sereno 365 []
1321516 April 17, 2021 - 23:32:14 UTC 38.52308 -121.5655 West Sacramento 118 []
1321515 April 17, 2021 - 23:27:00 UTC 40.90401 -123.98663 McKinleyville 333 []
1321503 April 17, 2021 - 23:18:00 UTC 37.9464 -121.73691 Brentwood 95 []
1321501 April 17, 2021 - 23:14:00 UTC 37.95495 -121.2734 Stockton 78 []
1321500 April 17, 2021 - 23:11:00 UTC 37.92272 -122.34613 Richmond 220 [{"latitude": "37.92242", "longitude": "-122.34395"}, {"latitude": "37.92243", "longitude": "-122.34312"}, {"latitude": "37.92294", "longitude": "-122.34302"}, {"latitude": "37.92368", "longitude": "-122.34317"}, {"latitude": "37.92404", "longitude": "-122.3443"}, {"latitude": "37.92358", "longitude": "-122.34541"}, {"latitude": "37.92315", "longitude": "-122.34583"}, {"latitude": "37.92291", "longitude": "-122.34541"}, {"latitude": "37.92244", "longitude": "-122.34446"}]
1321498 April 17, 2021 - 23:04:22 UTC 35.49761 -120.66231 Atascadero 40 []
1321497 April 17, 2021 - 22:53:04 UTC 36.77008 -119.84292 Fresno 35 []
1321496 April 17, 2021 - 22:52:00 UTC 37.73147 -122.16532 San Leandro 27 []
1321495 April 17, 2021 - 22:49:32 UTC 37.69863 -122.13912 San Leandro 27 []
1321455 April 17, 2021 - 22:40:56 UTC 37.70443 -122.1899 San Leandro 27 []
1321446 April 17, 2021 - 22:31:18 UTC 37.81869 -122.25709 Oakland 16 []
1321444 April 17, 2021 - 22:30:31 UTC 40.09286 -120.83816 Greenville 177 []
1321445 April 17, 2021 - 22:30:00 UTC 37.74676 -121.95397 San Ramon 315 []
1321440 April 17, 2021 - 22:25:43 UTC 37.68079 -121.76909 Livermore 12 []
1321439 April 17, 2021 - 22:25:22 UTC 38.00506 -121.11932 Linden 540 []
1321435 April 17, 2021 - 22:22:01 UTC 38.85789 -121.72781 Knights Landing 306 []
1321442 April 17, 2021 - 22:22:00 UTC 39.14509 -122.15244 Williams 255 [{"latitude": "39.12772", "longitude": "-122.17992"}, {"latitude": "39.12948", "longitude": "-122.17567"}, {"latitude": "39.13802", "longitude": "-122.15643"}, {"latitude": "39.13869", "longitude": "-122.15642"}, {"latitude": "39.14509", "longitude": "-122.15639"}, {"latitude": "39.14582", "longitude": "-122.15639"}, {"latitude": "39.14923", "longitude": "-122.16565"}, {"latitude": "39.14504", "longitude": "-122.17523"}, {"latitude": "39.14363", "longitude": "-122.1777"}, {"latitude": "39.1335", "longitude": "-122.18602"}]
1321415 April 17, 2021 - 22:19:08 UTC 38.36281 -121.9968 Vacaville 367 []
1321396 April 17, 2021 - 22:12:46 UTC 36.97088 -121.43838 Hollister 201 []

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
);