225,105 rows sorted by id descending

View and edit SQL

id ▲ outageStartTime latitude longitude regionName outageDevices
1351908 May 18, 2021 - 06:30:00 UTC 37.65225 -122.43304 South San Francisco 156 [{"latitude": "37.64839", "longitude": "-122.43246"}, {"latitude": "37.64998", "longitude": "-122.43105"}, {"latitude": "37.65019", "longitude": "-122.43104"}, {"latitude": "37.65257", "longitude": "-122.43231"}, {"latitude": "37.65198", "longitude": "-122.43657"}, {"latitude": "37.64979", "longitude": "-122.43771"}, {"latitude": "37.64965", "longitude": "-122.43747"}, {"latitude": "37.64933", "longitude": "-122.43657"}, {"latitude": "37.64853", "longitude": "-122.43336"}]
1351907 May 18, 2021 - 06:31:44 UTC 37.84414 -122.25641 Oakland 16 [{"latitude": "37.84437", "longitude": "-122.25624"}, {"latitude": "37.84445", "longitude": "-122.25558"}, {"latitude": "37.84501", "longitude": "-122.25574"}, {"latitude": "37.8454", "longitude": "-122.25612"}]
1351905 May 18, 2021 - 06:04:43 UTC 36.80194 -119.7637 Fresno 35 []
1351902 May 18, 2021 - 04:45:00 UTC 38.00206 -121.32019 Stockton 78 []
1351901 May 18, 2021 - 04:44:00 UTC 37.03755 -121.79266 Watsonville 49 []
1351899 May 18, 2021 - 04:30:00 UTC 36.65699 -121.64087 Salinas 23 []
1351898 May 18, 2021 - 04:05:21 UTC 38.04534 -122.19022 Port Costa 857 [{"latitude": "38.04303", "longitude": "-122.18903"}, {"latitude": "38.0458", "longitude": "-122.1837"}, {"latitude": "38.04611", "longitude": "-122.18329"}, {"latitude": "38.04731", "longitude": "-122.18403"}, {"latitude": "38.04723", "longitude": "-122.18494"}, {"latitude": "38.04561", "longitude": "-122.19045"}]
1351897 May 18, 2021 - 04:00:58 UTC 37.64169 -122.08933 Hayward 170 []
1351896 May 18, 2021 - 03:56:24 UTC 36.7402 -119.69433 Fresno 35 []
1351895 May 18, 2021 - 03:46:48 UTC 37.28074 -120.33085 Le Grand 682 []
1351893 May 18, 2021 - 03:39:20 UTC 36.73866 -119.73716 Fresno 35 []
1351892 May 18, 2021 - 03:34:15 UTC 37.43397 -121.91114 Milpitas 142 []
1351891 May 18, 2021 - 03:33:01 UTC 37.59681 -122.48232 Pacifica 174 []
1351890 May 18, 2021 - 03:32:00 UTC 37.43381 -121.91221 Milpitas 142 []
1351889 May 18, 2021 - 03:00:00 UTC 38.64998 -121.06695 El Dorado Hills 298 [{"latitude": "38.64795", "longitude": "-121.07158"}, {"latitude": "38.6504", "longitude": "-121.06791"}, {"latitude": "38.65296", "longitude": "-121.0676"}, {"latitude": "38.65071", "longitude": "-121.07398"}, {"latitude": "38.65008", "longitude": "-121.07348"}]
1351888 May 18, 2021 - 03:30:25 UTC 40.94121 -123.61397 Willow Creek 268 [{"latitude": "40.92649", "longitude": "-123.61807"}, {"latitude": "40.92995", "longitude": "-123.61612"}, {"latitude": "40.94063", "longitude": "-123.61426"}, {"latitude": "40.93916", "longitude": "-123.6167"}, {"latitude": "40.93185", "longitude": "-123.6213"}, {"latitude": "40.9309", "longitude": "-123.62157"}, {"latitude": "40.92935", "longitude": "-123.62152"}]
1351887 May 18, 2021 - 03:21:46 UTC 38.05785 -122.14473 Benicia 748 []
1351886 May 18, 2021 - 03:19:06 UTC 37.99846 -122.11246 Martinez 37 []
1351885 May 18, 2021 - 03:18:43 UTC 38.02531 -121.95889 Bay Point 415 []
1351884 May 18, 2021 - 03:05:00 UTC 36.81737 -119.90971 Fresno 35 []
1351883 May 18, 2021 - 03:04:24 UTC 37.97972 -121.80066 Antioch 42 [{"latitude": "37.97694", "longitude": "-121.80046"}, {"latitude": "37.97939", "longitude": "-121.7921"}, {"latitude": "37.98023", "longitude": "-121.79092"}, {"latitude": "37.98255", "longitude": "-121.79099"}, {"latitude": "37.98225", "longitude": "-121.79249"}, {"latitude": "37.98012", "longitude": "-121.79923"}, {"latitude": "37.97959", "longitude": "-121.80043"}, {"latitude": "37.97793", "longitude": "-121.80088"}]
1351882 May 18, 2021 - 02:58:00 UTC 37.90864 -122.18017 Orinda 217 []
1351881 May 18, 2021 - 02:49:00 UTC 38.11692 -122.2511 Vallejo 154 []
1351880 May 18, 2021 - 02:52:25 UTC 37.95991 -122.3618 North Richmond 737 []
1351879 May 18, 2021 - 02:40:04 UTC 38.96323 -122.64618 Clearlake 266 []
1351878 May 18, 2021 - 02:32:04 UTC 38.47506 -123.01799 Monte Rio 746 []
1351877 May 18, 2021 - 02:30:56 UTC 37.86118 -122.26947 Berkeley 47 []
1351876 May 18, 2021 - 02:28:36 UTC 40.43337 -121.86787 Manton 622 []
1351875 May 18, 2021 - 01:20:00 UTC 37.28482 -121.96615 San Jose 26 []
1351874 May 18, 2021 - 02:23:33 UTC 37.31349 -122.01485 Cupertino 123 []
1351873 May 18, 2021 - 02:23:18 UTC 37.64949 -119.72145 Yosemite National Park 920 []
1351872 May 18, 2021 - 02:20:49 UTC 39.64929 -121.79783 Durham 431 []
1351871 May 18, 2021 - 02:20:19 UTC 37.20992 -121.84152 San Jose 26 []
1351870 May 18, 2021 - 02:13:11 UTC 35.36129 -119.0272 Bakersfield 2 []
1351869 May 18, 2021 - 02:10:04 UTC 38.46663 -120.54936 Buckhorn 447 []
1351868 May 18, 2021 - 02:05:32 UTC 38.16115 -121.151 Lockeford 750 []
1351867 May 18, 2021 - 01:59:35 UTC 38.10655 -122.26049 Vallejo 154 []
1351866 May 18, 2021 - 01:59:25 UTC 37.32947 -121.90828 San Jose 26 []
1351865 May 18, 2021 - 01:56:57 UTC 38.01988 -121.93522 Bay Point 415 []
1351863 May 18, 2021 - 01:51:30 UTC 36.79255 -118.66146 Kings Canyon National Pk 769 []
1351862 May 18, 2021 - 01:50:10 UTC 37.70422 -122.09664 Castro Valley 4 []
1351861 May 18, 2021 - 01:46:11 UTC 36.55904 -121.56511 Salinas 23 []
1351859 May 18, 2021 - 01:39:34 UTC 36.74901 -118.75129 Kings Canyon National Pk 769 []
1351858 May 18, 2021 - 01:37:06 UTC 35.26058 -120.70111 San Luis Obispo 28 []
1351857 May 18, 2021 - 01:33:36 UTC 37.94318 -122.33205 Richmond 220 []
1351856 May 18, 2021 - 01:33:24 UTC 36.72797 -119.81434 Fresno 35 []
1351855 May 18, 2021 - 01:29:00 UTC 39.0212 -122.69116 Clearlake Oaks 168 []
1351854 May 18, 2021 - 01:26:02 UTC 37.22651 -121.98513 Los Gatos 121 []
1351851 May 18, 2021 - 01:01:00 UTC 38.02314 -121.93253 Bay Point 415 []
1351850 May 18, 2021 - 00:59:04 UTC 36.79291 -118.66426 Kings Canyon National Pk 769 []
1351849 May 18, 2021 - 00:57:53 UTC 37.79352 -120.9508 Escalon 423 []
1351846 May 18, 2021 - 00:56:52 UTC 40.5793 -124.26126 Ferndale 112 []
1351845 May 18, 2021 - 00:56:22 UTC 37.31349 -122.01485 Cupertino 123 []
1351844 May 18, 2021 - 00:54:42 UTC 36.5908 -121.94759 Del Monte Forest 187 []
1351842 May 18, 2021 - 00:52:43 UTC 38.22187 -121.2753 Collierville 825 []
1351841 May 18, 2021 - 00:52:39 UTC 36.58666 -121.9062 Monterey 163 []
1351839 May 18, 2021 - 00:49:03 UTC 39.15365 -122.91628 Upper Lake 580 []
1351837 May 18, 2021 - 00:41:03 UTC 37.73557 -122.14148 San Leandro 27 []
1351836 May 18, 2021 - 00:38:42 UTC 36.79152 -119.77169 Fresno 35 []
1351835 May 18, 2021 - 00:37:24 UTC 40.78681 -124.13391 Myrtletown 164 []
1351832 May 18, 2021 - 00:32:22 UTC 36.82191 -119.82595 Fresno 35 []
1351830 May 18, 2021 - 00:30:45 UTC 37.76558 -122.19155 Oakland 16 []
1351829 May 18, 2021 - 00:25:38 UTC 38.32171 -122.45776 Sonoma 324 []
1351827 May 18, 2021 - 00:19:19 UTC 35.37968 -118.92947 Bakersfield 2 []
1351826 May 18, 2021 - 00:16:15 UTC 38.39276 -120.44322 Wilseyville 632 []
1351825 May 18, 2021 - 00:15:15 UTC 37.94067 -122.36758 Richmond 220 []
1351822 May 18, 2021 - 00:07:47 UTC 36.82924 -119.79693 Fresno 35 []
1351821 May 18, 2021 - 00:05:03 UTC 37.20007 -119.7612 Yosemite Lakes 462 []
1351820 May 18, 2021 - 00:03:24 UTC 35.01626 -120.49602 Nipomo 413 []
1351819 May 18, 2021 - 00:00:47 UTC 37.5301 -122.3146 San Mateo 29 []
1351818 May 17, 2021 - 23:57:58 UTC 37.92401 -122.35237 Richmond 220 []
1351817 May 17, 2021 - 23:54:35 UTC 37.96053 -122.54423 Kentfield 153 []
1351816 May 17, 2021 - 23:48:11 UTC 37.75218 -122.40536 San Francisco 25 []
1351815 May 17, 2021 - 23:47:59 UTC 39.16763 -121.62856 Yuba City 344 []
1351813 May 17, 2021 - 23:46:00 UTC 37.72848 -122.17272 Oakland 16 []
1351812 May 17, 2021 - 23:43:24 UTC 37.32624 -121.8704 San Jose 26 []
1351811 May 17, 2021 - 23:41:09 UTC 34.96972 -120.44715 Santa Maria 52 []
1351809 May 17, 2021 - 23:39:35 UTC 39.37038 -123.25493 Willits 327 []
1351808 May 17, 2021 - 23:39:29 UTC 39.23999 -121.20179 Lake Wildwood 636 []
1351807 May 17, 2021 - 23:39:14 UTC 36.77094 -119.79104 Fresno 35 []
1351806 May 17, 2021 - 23:38:24 UTC 39.15053 -121.57971 Marysville 198 []
1351805 May 17, 2021 - 23:38:16 UTC 37.78638 -122.38922 San Francisco 25 []
1351804 May 17, 2021 - 23:38:11 UTC 38.08198 -122.19038 Benicia 748 []
1351803 May 17, 2021 - 23:36:48 UTC 38.52057 -121.97382 Winters 192 []
1351802 May 17, 2021 - 23:35:48 UTC 37.30105 -121.93478 San Jose 26 []
1351800 May 17, 2021 - 23:33:31 UTC 38.59398 -121.54071 West Sacramento 118 []
1351799 May 17, 2021 - 23:32:58 UTC 41.09333 -124.15134 Trinidad 607 []
1351798 May 17, 2021 - 23:30:32 UTC 37.9288 -122.09147 Reliez Valley 380 []
1351794 May 17, 2021 - 23:27:07 UTC 37.9062 -121.24816 Stockton 78 []
1351791 May 17, 2021 - 23:17:51 UTC 37.68288 -122.08951 Hayward 170 []
1351790 May 17, 2021 - 23:17:46 UTC 36.68551 -120.15122 Kerman 61 []
1351789 May 17, 2021 - 23:15:00 UTC 38.03521 -122.64219 Nicasio 316 []
1351787 May 17, 2021 - 23:12:00 UTC 37.65636 -122.42005 South San Francisco 156 [{"latitude": "37.63443", "longitude": "-122.43303"}, {"latitude": "37.63858", "longitude": "-122.42203"}, {"latitude": "37.6391", "longitude": "-122.42156"}, {"latitude": "37.64214", "longitude": "-122.41992"}, {"latitude": "37.65678", "longitude": "-122.42012"}, {"latitude": "37.66344", "longitude": "-122.43987"}, {"latitude": "37.66265", "longitude": "-122.44012"}, {"latitude": "37.65974", "longitude": "-122.4399"}, {"latitude": "37.64979", "longitude": "-122.43771"}, {"latitude": "37.63478", "longitude": "-122.43342"}]
1351785 May 17, 2021 - 23:14:25 UTC 38.9226 -122.59588 Clearlake 266 []
1351783 May 17, 2021 - 23:04:13 UTC 36.66216 -119.75702 Fresno 35 []
1351782 May 17, 2021 - 23:02:33 UTC 37.92289 -122.05815 Contra Costa Centre 703 [{"latitude": "37.9226", "longitude": "-122.05918"}, {"latitude": "37.92273", "longitude": "-122.05876"}, {"latitude": "37.9226", "longitude": "-122.05944"}]
1351781 May 17, 2021 - 22:59:19 UTC 37.6525 -122.10745 Hayward 170 []
1351780 May 17, 2021 - 22:59:01 UTC 38.3964 -121.97523 Vacaville 367 []
1351779 May 17, 2021 - 22:57:44 UTC 38.63189 -122.76608 Healdsburg 188 []
1351778 May 17, 2021 - 22:56:34 UTC 37.41613 -122.10203 Palo Alto 398 []

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