146,341 rows sorted by outageStartTime descending

View and edit SQL

id outageStartTime ▲ latitude longitude regionName outageDevices
1212795 January 18, 2021 - 23:58:29 UTC 38.27146 -122.0448 Fairfield 169 []
1212794 January 18, 2021 - 23:58:17 UTC 38.61206 -122.61261 Calistoga 108 []
1212793 January 18, 2021 - 23:57:49 UTC 37.30907 -121.9788 San Jose 26 []
1212792 January 18, 2021 - 23:51:16 UTC 38.55589 -122.52337 Calistoga 108 []
1212791 January 18, 2021 - 23:49:24 UTC 37.13254 -121.96701 Los Gatos 121 []
1212789 January 18, 2021 - 23:44:55 UTC 37.90165 -122.64847 Stinson Beach 665 []
1212790 January 18, 2021 - 23:43:00 UTC 36.967 -120.54448 Dos Palos 394 [{"latitude": "36.95642", "longitude": "-120.52367"}, {"latitude": "36.96703", "longitude": "-120.52081"}, {"latitude": "36.967", "longitude": "-120.54384"}]
1212786 January 18, 2021 - 23:41:19 UTC 38.2801 -122.47575 Sonoma 324 []
1212785 January 18, 2021 - 23:39:23 UTC 38.35996 -122.00015 Vacaville 367 []
1212784 January 18, 2021 - 23:34:00 UTC 37.69273 -122.49274 Daly City 124 []
1212783 January 18, 2021 - 23:33:38 UTC 36.68793 -121.61221 Salinas 23 []
1212782 January 18, 2021 - 23:30:15 UTC 39.13366 -123.50121 Philo 122 []
1212781 January 18, 2021 - 23:29:52 UTC 37.92578 -122.33615 Richmond 220 []
1212780 January 18, 2021 - 23:26:33 UTC 37.8354 -121.95607 Diablo 707 []
1212779 January 18, 2021 - 23:26:18 UTC 38.26577 -122.04674 Fairfield 169 []
1212778 January 18, 2021 - 23:23:16 UTC 36.96269 -121.96949 Pleasure Point 229 []
1212776 January 18, 2021 - 23:21:42 UTC 37.92636 -121.28965 Stockton 78 []
1212775 January 18, 2021 - 23:17:20 UTC 37.9773 -122.02644 Concord 46 []
1212774 January 18, 2021 - 23:15:39 UTC 37.97079 -121.98677 Concord 46 []
1212773 January 18, 2021 - 23:15:38 UTC 37.16303 -121.98183 Lexington Hills 674 []
1212772 January 18, 2021 - 23:10:41 UTC 37.63251 -122.42982 San Bruno 55 []
1212769 January 18, 2021 - 23:10:26 UTC 37.87734 -122.06061 Castle Hill 790 []
1212760 January 18, 2021 - 23:04:08 UTC 38.55708 -121.79106 Davis 120 []
1212761 January 18, 2021 - 23:04:06 UTC 36.79604 -119.83654 Fresno 35 []
1212759 January 18, 2021 - 23:02:32 UTC 36.23308 -119.79819 Lemoore 11 []
1212765 January 18, 2021 - 22:59:00 UTC 37.56028 -121.17852 Grayson 834 [{"latitude": "37.46823", "longitude": "-121.29987"}, {"latitude": "37.49844", "longitude": "-121.19545"}, {"latitude": "37.5007", "longitude": "-121.19059"}, {"latitude": "37.55951", "longitude": "-121.17951"}, {"latitude": "37.56042", "longitude": "-121.17956"}, {"latitude": "37.56126", "longitude": "-121.26018"}, {"latitude": "37.56119", "longitude": "-121.26145"}, {"latitude": "37.514", "longitude": "-121.37376"}, {"latitude": "37.50829", "longitude": "-121.37503"}, {"latitude": "37.50814", "longitude": "-121.37502"}, {"latitude": "37.50203", "longitude": "-121.37376"}, {"latitude": "37.47939", "longitude": "-121.35228"}, {"latitude": "37.47934", "longitude": "-121.35222"}, {"latitude": "37.47928", "longitude": "-121.35214"}]
1212757 January 18, 2021 - 22:58:16 UTC 37.53176 -122.03669 Newark 225 []
1212756 January 18, 2021 - 22:54:53 UTC 36.31965 -121.2456 Greenfield 767 []
1212755 January 18, 2021 - 22:53:57 UTC 36.7966 -119.88872 Fresno 35 []
1212752 January 18, 2021 - 22:50:51 UTC 37.93556 -122.03648 Walnut Creek 33 []
1212754 January 18, 2021 - 22:50:41 UTC 36.80791 -119.8443 Fresno 35 [{"latitude": "36.80688", "longitude": "-119.845"}, {"latitude": "36.80796", "longitude": "-119.84459"}, {"latitude": "36.80803", "longitude": "-119.84647"}, {"latitude": "36.80805", "longitude": "-119.84806"}, {"latitude": "36.80692", "longitude": "-119.84812"}, {"latitude": "36.80688", "longitude": "-119.84518"}]
1212750 January 18, 2021 - 22:50:30 UTC 37.43496 -121.87796 Milpitas 142 []
1212751 January 18, 2021 - 22:50:30 UTC 37.43073 -121.87742 Milpitas 142 []
1212753 January 18, 2021 - 22:49:52 UTC 37.30907 -121.9788 San Jose 26 []
1212749 January 18, 2021 - 22:44:19 UTC 37.65906 -122.10136 Hayward 170 []
1212748 January 18, 2021 - 22:42:07 UTC 35.36153 -120.84106 Morro Bay 412 []
1212742 January 18, 2021 - 22:40:02 UTC 37.31619 -121.93342 Fruitdale 849 []
1212729 January 18, 2021 - 22:38:12 UTC 36.58116 -121.52611 Salinas 23 []
1212725 January 18, 2021 - 22:35:23 UTC 37.52376 -122.51078 Moss Beach 263 []
1212718 January 18, 2021 - 22:31:54 UTC 39.73961 -121.6955 Butte Creek Canyon 479 []
1212717 January 18, 2021 - 22:30:56 UTC 37.23348 -121.9046 San Jose 26 []
1212730 January 18, 2021 - 22:30:00 UTC 38.33722 -121.90363 Vacaville 367 [{"latitude": "38.30025", "longitude": "-121.89671"}, {"latitude": "38.30407", "longitude": "-121.88286"}, {"latitude": "38.30886", "longitude": "-121.8675"}, {"latitude": "38.3461", "longitude": "-121.76297"}, {"latitude": "38.35811", "longitude": "-121.75275"}, {"latitude": "38.37025", "longitude": "-121.75841"}, {"latitude": "38.38279", "longitude": "-121.78504"}, {"latitude": "38.38291", "longitude": "-121.78599"}, {"latitude": "38.38437", "longitude": "-121.80443"}, {"latitude": "38.35152", "longitude": "-121.89696"}, {"latitude": "38.31946", "longitude": "-121.90762"}, {"latitude": "38.31833", "longitude": "-121.90761"}, {"latitude": "38.30049", "longitude": "-121.89777"}]
1212715 January 18, 2021 - 22:29:38 UTC 37.62802 -122.04362 Hayward 170 []
1212714 January 18, 2021 - 22:27:36 UTC 37.29273 -121.87949 San Jose 26 []
1212712 January 18, 2021 - 22:23:00 UTC 37.11578 -122.11845 Boulder Creek 241 []
1212707 January 18, 2021 - 22:13:00 UTC 37.06653 -122.0797 Ben Lomond 231 [{"latitude": "37.0671", "longitude": "-122.07953"}, {"latitude": "37.06766", "longitude": "-122.07704"}, {"latitude": "37.07428", "longitude": "-122.08316"}, {"latitude": "37.07433", "longitude": "-122.09015"}, {"latitude": "37.07259", "longitude": "-122.08856"}, {"latitude": "37.0678", "longitude": "-122.08212"}, {"latitude": "37.06747", "longitude": "-122.08118"}, {"latitude": "37.06719", "longitude": "-122.08024"}]
1212704 January 18, 2021 - 22:11:33 UTC 37.44141 -122.22291 Atherton 523 []
1212702 January 18, 2021 - 22:08:51 UTC 37.29646 -122.01642 San Jose 26 []
1212701 January 18, 2021 - 22:08:19 UTC 38.39184 -122.92203 Occidental 148 [{"latitude": "38.39112", "longitude": "-122.91968"}, {"latitude": "38.39166", "longitude": "-122.92016"}, {"latitude": "38.39173", "longitude": "-122.92093"}]
1212703 January 18, 2021 - 22:07:30 UTC 39.27268 -122.19075 Maxwell 773 []
1212700 January 18, 2021 - 22:04:19 UTC 35.123 -120.62832 Grover Beach 83 []
1212699 January 18, 2021 - 22:03:37 UTC 38.82043 -122.55881 Hidden Valley Lake 592 []
1212698 January 18, 2021 - 22:01:28 UTC 39.73413 -121.84647 Chico 41 []
1212694 January 18, 2021 - 21:59:54 UTC 38.20848 -121.07978 Acampo 576 []
1212693 January 18, 2021 - 21:54:54 UTC 37.90935 -121.07399 Stockton 78 [{"latitude": "37.90318", "longitude": "-121.09029"}, {"latitude": "37.91111", "longitude": "-121.07406"}, {"latitude": "37.91986", "longitude": "-121.07443"}, {"latitude": "37.90644", "longitude": "-121.09496"}]
1212692 January 18, 2021 - 21:51:32 UTC 38.85401 -121.17365 Penryn 352 []
1212683 January 18, 2021 - 21:47:36 UTC 37.98186 -121.82152 Antioch 42 []
1212680 January 18, 2021 - 21:47:22 UTC 38.5539 -121.73879 Davis 120 []
1212679 January 18, 2021 - 21:47:03 UTC 38.80187 -120.7273 Placerville 19 []
1212681 January 18, 2021 - 21:47:00 UTC 37.71712 -122.39199 San Francisco 25 []
1212689 January 18, 2021 - 21:46:28 UTC 37.62883 -122.07553 Hayward 170 []
1212677 January 18, 2021 - 21:45:25 UTC 37.82217 -122.2881 Oakland 16 []
1212676 January 18, 2021 - 21:45:19 UTC 37.38243 -122.23891 Portola Valley 702 []
1212674 January 18, 2021 - 21:42:16 UTC 38.5122 -122.47583 Saint Helena 296 []
1212673 January 18, 2021 - 21:40:40 UTC 37.85168 -122.00906 Alamo 251 [{"latitude": "37.85494", "longitude": "-122.00041"}, {"latitude": "37.85979", "longitude": "-121.98954"}, {"latitude": "37.86094", "longitude": "-121.98941"}, {"latitude": "37.86499", "longitude": "-121.99251"}, {"latitude": "37.86536", "longitude": "-121.9955"}, {"latitude": "37.86519", "longitude": "-122.00245"}, {"latitude": "37.86503", "longitude": "-122.00491"}, {"latitude": "37.85562", "longitude": "-122.0012"}]
1212671 January 18, 2021 - 21:39:07 UTC 40.75919 -124.15803 Eureka 6 []
1212670 January 18, 2021 - 21:37:03 UTC 36.73182 -119.75825 Fresno 35 []
1212669 January 18, 2021 - 21:34:46 UTC 40.46293 -122.31048 Anderson 106 []
1212667 January 18, 2021 - 21:33:42 UTC 37.09441 -122.00479 Scotts Valley 184 []
1212666 January 18, 2021 - 21:33:16 UTC 38.36805 -121.97941 Vacaville 367 []
1212668 January 18, 2021 - 21:32:46 UTC 34.63567 -120.11136 Ballard 843 []
1212665 January 18, 2021 - 21:32:40 UTC 38.44798 -121.83104 Dixon 45 []
1212664 January 18, 2021 - 21:30:13 UTC 37.23741 -121.87457 San Jose 26 []
1212663 January 18, 2021 - 21:29:34 UTC 34.95507 -120.40869 Santa Maria 52 []
1212662 January 18, 2021 - 21:29:09 UTC 37.54401 -122.50208 Montara 557 []
1212661 January 18, 2021 - 21:28:59 UTC 37.3007 -121.96802 San Jose 26 []
1212660 January 18, 2021 - 21:28:12 UTC 34.61904 -120.07995 Santa Ynez 68 []
1212659 January 18, 2021 - 21:27:31 UTC 37.92627 -122.29606 El Cerrito 427 []
1212658 January 18, 2021 - 21:26:51 UTC 38.41956 -122.9434 Sebastopol 99 []
1212657 January 18, 2021 - 21:22:59 UTC 38.77306 -120.296 Kyburz 574 []
1212656 January 18, 2021 - 21:21:47 UTC 37.83486 -122.25872 Oakland 16 []
1212655 January 18, 2021 - 21:21:25 UTC 37.96573 -121.30662 Stockton 78 []
1212654 January 18, 2021 - 21:18:46 UTC 36.94551 -121.8542 La Selva Beach 421 []
1212653 January 18, 2021 - 21:18:21 UTC 37.43727 -122.20545 West Menlo Park 745 []
1212652 January 18, 2021 - 21:11:43 UTC 37.35828 -122.0582 Sunnyvale 129 []
1212651 January 18, 2021 - 21:09:49 UTC 38.27793 -122.49979 Sonoma 324 []
1212649 January 18, 2021 - 21:09:42 UTC 38.70648 -120.71393 Placerville 19 []
1212650 January 18, 2021 - 21:09:42 UTC 38.39125 -122.92207 Occidental 148 []
1212648 January 18, 2021 - 21:08:03 UTC 37.73966 -122.15285 San Leandro 27 []
1212647 January 18, 2021 - 21:06:12 UTC 37.74273 -122.49169 San Francisco 25 []
1212646 January 18, 2021 - 21:05:53 UTC 37.64489 -122.09849 Hayward 170 []
1212645 January 18, 2021 - 21:05:42 UTC 37.50161 -121.94277 Fremont 140 []
1212644 January 18, 2021 - 21:04:27 UTC 36.34268 -120.17282 Huron 51 []
1212643 January 18, 2021 - 21:01:58 UTC 37.91572 -122.08136 Walnut Creek 33 []
1212642 January 18, 2021 - 21:01:28 UTC 37.5522 -122.02106 Fremont 140 []
1212641 January 18, 2021 - 20:59:31 UTC 38.00686 -121.31566 Stockton 78 []
1212640 January 18, 2021 - 20:58:28 UTC 37.9783 -121.32635 Stockton 78 []
1212639 January 18, 2021 - 20:58:13 UTC 38.33429 -122.5137 Sonoma 324 []
1212638 January 18, 2021 - 20:56:25 UTC 37.95932 -122.36686 North Richmond 737 []
1212637 January 18, 2021 - 20:56:13 UTC 36.7863 -119.79814 Fresno 35 []

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