outages

498 rows where regionName = 20

View and edit SQL

id outageStartTime latitude longitude regionName outageDevices
632634 September 30, 2019 - 21:20:02 UTC 40.18335 -122.2206 Red Bluff 20 []
633642 October 01, 2019 - 15:25:00 UTC 40.08286 -122.39925 Red Bluff 20 [{"latitude": "40.05747", "longitude": "-122.40014"}, {"latitude": "40.07184", "longitude": "-122.3905"}, {"latitude": "40.08255", "longitude": "-122.40097"}, {"latitude": "40.07657", "longitude": "-122.40365"}, {"latitude": "40.05866", "longitude": "-122.40253"}, {"latitude": "40.05794", "longitude": "-122.40171"}]
633979 October 01, 2019 - 18:08:00 UTC 40.38704 -122.17653 Red Bluff 20 []
635859 October 02, 2019 - 16:03:50 UTC 40.12695 -122.20262 Red Bluff 20 []
635973 October 02, 2019 - 16:37:00 UTC 40.15602 -122.15502 Red Bluff 20 []
639059 October 03, 2019 - 16:00:00 UTC 40.128 -122.11666 Red Bluff 20 []
644006 October 05, 2019 - 15:19:28 UTC 40.27501 -122.25729 Red Bluff 20 []
646010 October 07, 2019 - 17:13:00 UTC 40.13718 -122.12657 Red Bluff 20 []
646117 October 07, 2019 - 18:24:32 UTC 40.17884 -122.24866 Red Bluff 20 []
647086 October 08, 2019 - 15:30:00 UTC 40.11949 -122.19725 Red Bluff 20 [{"latitude": "40.11736", "longitude": "-122.19689"}, {"latitude": "40.11889", "longitude": "-122.19706"}, {"latitude": "40.1206", "longitude": "-122.20299"}, {"latitude": "40.1188", "longitude": "-122.20165"}]
647864 October 09, 2019 - 07:34:00 UTC 40.15974 -122.24017 Red Bluff 20 []
647872 October 09, 2019 - 07:36:00 UTC 40.19228 -122.21227 Red Bluff 20 []
647874 October 09, 2019 - 07:37:14 UTC 40.16866 -122.21018 Red Bluff 20 []
647910 October 09, 2019 - 07:41:35 UTC 40.18072 -122.25564 Red Bluff 20 []
647914 October 09, 2019 - 07:42:00 UTC 40.15927 -122.23633 Red Bluff 20 []
647921 October 09, 2019 - 07:43:30 UTC 40.08957 -122.43051 Red Bluff 20 []
647923 October 09, 2019 - 07:43:00 UTC 40.15688 -122.2359 Red Bluff 20 []
647924 October 09, 2019 - 07:43:00 UTC 40.14777 -122.39781 Red Bluff 20 []
647934 October 09, 2019 - 07:45:45 UTC 40.14322 -122.31592 Red Bluff 20 []
647955 October 09, 2019 - 07:48:00 UTC 40.18149 -122.21504 Red Bluff 20 []
647956 October 09, 2019 - 07:48:00 UTC 40.16291 -122.23999 Red Bluff 20 []
647961 October 09, 2019 - 07:49:00 UTC 40.16712 -122.24256 Red Bluff 20 []
647966 October 09, 2019 - 07:10:00 UTC 39.89041 -122.53694 Red Bluff 20 [{"latitude": "39.88836", "longitude": "-122.62646"}, {"latitude": "39.89093", "longitude": "-122.53734"}, {"latitude": "40.01902", "longitude": "-122.52823"}, {"latitude": "40.04902", "longitude": "-122.57392"}, {"latitude": "40.04428", "longitude": "-122.58051"}, {"latitude": "39.90842", "longitude": "-122.67944"}, {"latitude": "39.90759", "longitude": "-122.67961"}]
647970 October 09, 2019 - 07:50:34 UTC 40.0946 -122.15854 Red Bluff 20 []
647972 October 09, 2019 - 07:50:00 UTC 40.20562 -122.30964 Red Bluff 20 []
647976 October 09, 2019 - 07:51:00 UTC 40.19311 -122.24554 Red Bluff 20 []
647977 October 09, 2019 - 07:51:00 UTC 40.16824 -122.23454 Red Bluff 20 []
647984 October 09, 2019 - 07:51:57 UTC 40.1836 -122.24599 Red Bluff 20 []
648007 October 09, 2019 - 07:55:05 UTC 40.21507 -122.19238 Red Bluff 20 []
648022 October 09, 2019 - 07:56:00 UTC 40.23928 -122.2689 Red Bluff 20 []
648024 October 09, 2019 - 07:56:57 UTC 40.15732 -122.22646 Red Bluff 20 []
648031 October 09, 2019 - 07:59:06 UTC 40.1032 -122.23187 Red Bluff 20 []
648119 October 09, 2019 - 08:07:59 UTC 40.17515 -122.22335 Red Bluff 20 []
648120 October 09, 2019 - 08:07:59 UTC 40.17672 -122.22333 Red Bluff 20 []
648121 October 09, 2019 - 08:07:59 UTC 40.16218 -122.22676 Red Bluff 20 [{"latitude": "40.16328", "longitude": "-122.22308"}, {"latitude": "40.16456", "longitude": "-122.223"}, {"latitude": "40.1657", "longitude": "-122.22319"}, {"latitude": "40.17578", "longitude": "-122.23068"}, {"latitude": "40.17692", "longitude": "-122.23226"}, {"latitude": "40.17666", "longitude": "-122.23347"}, {"latitude": "40.16632", "longitude": "-122.22753"}]
648122 October 09, 2019 - 08:07:59 UTC 40.1757 -122.21675 Red Bluff 20 []
648123 October 09, 2019 - 08:07:59 UTC 40.17798 -122.21935 Red Bluff 20 []
648124 October 09, 2019 - 08:07:59 UTC 40.1848 -122.21763 Red Bluff 20 []
648125 October 09, 2019 - 08:07:59 UTC 40.18409 -122.2161 Red Bluff 20 []
648126 October 09, 2019 - 08:07:59 UTC 40.18631 -122.21128 Red Bluff 20 []
648127 October 09, 2019 - 08:07:59 UTC 40.19966 -122.21393 Red Bluff 20 []
648128 October 09, 2019 - 08:07:59 UTC 40.19523 -122.21581 Red Bluff 20 []
648129 October 09, 2019 - 08:07:59 UTC 40.18682 -122.2177 Red Bluff 20 []
648130 October 09, 2019 - 08:07:59 UTC 40.18654 -122.21694 Red Bluff 20 []
648154 October 09, 2019 - 08:07:59 UTC 40.16478 -122.24168 Red Bluff 20 []
648155 October 09, 2019 - 07:59:55 UTC 40.10397 -122.23254 Red Bluff 20 []
648156 October 09, 2019 - 08:07:59 UTC 40.12545 -122.18562 Red Bluff 20 []
648157 October 09, 2019 - 08:07:59 UTC 40.12366 -122.31411 Red Bluff 20 []
648158 October 09, 2019 - 08:07:59 UTC 40.15926 -122.32854 Red Bluff 20 []
648159 October 09, 2019 - 08:07:59 UTC 40.15192 -122.29093 Red Bluff 20 []
648160 October 09, 2019 - 08:07:59 UTC 40.15276 -122.28966 Red Bluff 20 []
648161 October 09, 2019 - 08:07:59 UTC 40.1444 -122.34476 Red Bluff 20 []
648162 October 09, 2019 - 07:45:55 UTC 40.14109 -122.33246 Red Bluff 20 []
648200 October 09, 2019 - 08:07:59 UTC 40.09546 -122.14933 Red Bluff 20 []
648245 October 09, 2019 - 08:09:00 UTC 40.18758 -122.21869 Red Bluff 20 []
648257 October 09, 2019 - 08:12:00 UTC 40.17268 -122.23821 Red Bluff 20 []
648342 October 09, 2019 - 08:37:39 UTC 40.20331 -122.22713 Red Bluff 20 []
648556 October 09, 2019 - 08:55:57 UTC 40.18335 -122.2206 Red Bluff 20 []
648557 October 09, 2019 - 08:55:57 UTC 40.18826 -122.21584 Red Bluff 20 []
648637 October 09, 2019 - 08:55:57 UTC 40.31199 -122.0201 Red Bluff 20 []
648638 October 09, 2019 - 08:55:57 UTC 40.32258 -122.04093 Red Bluff 20 []
648680 October 09, 2019 - 08:55:57 UTC 40.16037 -122.2472 Red Bluff 20 []
648681 October 09, 2019 - 08:55:57 UTC 40.16328 -122.24689 Red Bluff 20 []
648682 October 09, 2019 - 08:55:57 UTC 40.16109 -122.24984 Red Bluff 20 [{"latitude": "40.16143", "longitude": "-122.25013"}, {"latitude": "40.16187", "longitude": "-122.24768"}, {"latitude": "40.1635", "longitude": "-122.24766"}, {"latitude": "40.16293", "longitude": "-122.24943"}]
648683 October 09, 2019 - 08:55:57 UTC 40.1536 -122.2476 Red Bluff 20 []
648688 October 09, 2019 - 08:10:22 UTC 40.28935 -122.27378 Red Bluff 20 []
648689 October 09, 2019 - 08:55:57 UTC 40.20729 -122.21053 Red Bluff 20 []
648690 October 09, 2019 - 08:55:57 UTC 40.20435 -122.19328 Red Bluff 20 []
648750 October 09, 2019 - 08:55:57 UTC 40.10363 -122.04496 Red Bluff 20 []
648796 October 09, 2019 - 09:01:24 UTC 40.159 -122.22797 Red Bluff 20 []
648841 October 09, 2019 - 09:10:01 UTC 40.21601 -122.20319 Red Bluff 20 []
648844 October 09, 2019 - 09:10:00 UTC 40.17487 -122.24592 Red Bluff 20 []
648853 October 09, 2019 - 09:11:56 UTC 40.17295 -122.33097 Red Bluff 20 []
648870 October 09, 2019 - 09:14:00 UTC 40.1812 -122.2465 Red Bluff 20 []
648887 October 09, 2019 - 09:16:00 UTC 40.22129 -122.36201 Red Bluff 20 []
648894 October 09, 2019 - 09:17:00 UTC 40.16511 -122.25811 Red Bluff 20 []
649053 October 09, 2019 - 09:24:00 UTC 40.19992 -122.21333 Red Bluff 20 []
649234 October 09, 2019 - 09:37:00 UTC 40.13559 -122.13816 Red Bluff 20 []
649250 October 09, 2019 - 09:38:00 UTC 40.17762 -122.24176 Red Bluff 20 []
649338 October 09, 2019 - 09:51:15 UTC 40.16753 -122.25157 Red Bluff 20 []
649538 October 09, 2019 - 10:25:00 UTC 40.06393 -122.31482 Red Bluff 20 []
649547 October 09, 2019 - 07:38:00 UTC 40.18279 -122.24484 Red Bluff 20 [{"latitude": "40.17421", "longitude": "-122.26103"}, {"latitude": "40.17667", "longitude": "-122.24259"}, {"latitude": "40.18036", "longitude": "-122.2425"}, {"latitude": "40.20954", "longitude": "-122.2579"}, {"latitude": "40.22394", "longitude": "-122.26557"}, {"latitude": "40.23022", "longitude": "-122.27011"}, {"latitude": "40.23537", "longitude": "-122.27521"}, {"latitude": "40.26185", "longitude": "-122.31111"}, {"latitude": "40.26097", "longitude": "-122.31535"}, {"latitude": "40.22707", "longitude": "-122.43151"}, {"latitude": "40.22512", "longitude": "-122.43474"}, {"latitude": "40.18433", "longitude": "-122.2998"}, {"latitude": "40.17432", "longitude": "-122.26216"}]
649671 October 09, 2019 - 07:38:00 UTC 40.17924 -122.26006 Red Bluff 20 [{"latitude": "40.17421", "longitude": "-122.26103"}, {"latitude": "40.18398", "longitude": "-122.25685"}, {"latitude": "40.20735", "longitude": "-122.26022"}, {"latitude": "40.20773", "longitude": "-122.26625"}, {"latitude": "40.2078", "longitude": "-122.26937"}, {"latitude": "40.20779", "longitude": "-122.27353"}, {"latitude": "40.20593", "longitude": "-122.30095"}, {"latitude": "40.19958", "longitude": "-122.31183"}, {"latitude": "40.1952", "longitude": "-122.31018"}, {"latitude": "40.18433", "longitude": "-122.2998"}, {"latitude": "40.17432", "longitude": "-122.26216"}]
649674 October 09, 2019 - 10:37:00 UTC 40.16182 -122.24154 Red Bluff 20 []
649749 October 09, 2019 - 07:38:00 UTC 40.21028 -122.27055 Red Bluff 20 [{"latitude": "40.20954", "longitude": "-122.2579"}, {"latitude": "40.22394", "longitude": "-122.26557"}, {"latitude": "40.23022", "longitude": "-122.27011"}, {"latitude": "40.23537", "longitude": "-122.27521"}, {"latitude": "40.26185", "longitude": "-122.31111"}, {"latitude": "40.26097", "longitude": "-122.31535"}, {"latitude": "40.22892", "longitude": "-122.30948"}, {"latitude": "40.2105", "longitude": "-122.27023"}, {"latitude": "40.21022", "longitude": "-122.26908"}, {"latitude": "40.2096", "longitude": "-122.25983"}]
649758 October 09, 2019 - 10:41:00 UTC 40.13643 -122.21725 Red Bluff 20 []
649764 October 09, 2019 - 07:38:00 UTC 40.21101 -122.2727 Red Bluff 20 [{"latitude": "40.2021", "longitude": "-122.31121"}, {"latitude": "40.21243", "longitude": "-122.27386"}, {"latitude": "40.21822", "longitude": "-122.2777"}, {"latitude": "40.21933", "longitude": "-122.27962"}, {"latitude": "40.22054", "longitude": "-122.28178"}, {"latitude": "40.24584", "longitude": "-122.35914"}, {"latitude": "40.24551", "longitude": "-122.36138"}, {"latitude": "40.22707", "longitude": "-122.43151"}, {"latitude": "40.22512", "longitude": "-122.43474"}, {"latitude": "40.2133", "longitude": "-122.37594"}]
649786 October 09, 2019 - 07:38:00 UTC 40.18279 -122.24478 Red Bluff 20 [{"latitude": "40.1797", "longitude": "-122.25712"}, {"latitude": "40.1836", "longitude": "-122.24599"}, {"latitude": "40.18456", "longitude": "-122.24491"}, {"latitude": "40.18693", "longitude": "-122.24235"}, {"latitude": "40.18861", "longitude": "-122.24064"}, {"latitude": "40.19183", "longitude": "-122.23896"}, {"latitude": "40.19443", "longitude": "-122.23787"}, {"latitude": "40.20552", "longitude": "-122.23835"}, {"latitude": "40.20603", "longitude": "-122.23841"}, {"latitude": "40.20662", "longitude": "-122.23944"}, {"latitude": "40.2077", "longitude": "-122.24159"}, {"latitude": "40.2093", "longitude": "-122.24807"}, {"latitude": "40.20682", "longitude": "-122.25888"}, {"latitude": "40.19013", "longitude": "-122.26098"}, {"latitude": "40.18235", "longitude": "-122.25971"}, {"latitude": "40.18007", "longitude": "-122.25754"}]
649793 October 09, 2019 - 07:38:00 UTC 40.2058 -122.25326 Red Bluff 20 [{"latitude": "40.20616", "longitude": "-122.25038"}, {"latitude": "40.23827", "longitude": "-122.20894"}, {"latitude": "40.23859", "longitude": "-122.20854"}, {"latitude": "40.23901", "longitude": "-122.20819"}, {"latitude": "40.25938", "longitude": "-122.19201"}, {"latitude": "40.28899", "longitude": "-122.18434"}, {"latitude": "40.3139", "longitude": "-122.17949"}, {"latitude": "40.32862", "longitude": "-122.18871"}, {"latitude": "40.33851", "longitude": "-122.20433"}, {"latitude": "40.31229", "longitude": "-122.28953"}, {"latitude": "40.26366", "longitude": "-122.29733"}, {"latitude": "40.24111", "longitude": "-122.28252"}, {"latitude": "40.20796", "longitude": "-122.2525"}, {"latitude": "40.20619", "longitude": "-122.25046"}]
649804 October 09, 2019 - 07:38:00 UTC 40.23848 -122.25972 Red Bluff 20 []
649852 October 09, 2019 - 10:48:00 UTC 40.13886 -122.1234 Red Bluff 20 []
649916 October 09, 2019 - 07:38:00 UTC 40.26452 -122.22551 Red Bluff 20 [{"latitude": "40.23753", "longitude": "-122.21106"}, {"latitude": "40.23827", "longitude": "-122.20894"}, {"latitude": "40.23859", "longitude": "-122.20854"}, {"latitude": "40.23901", "longitude": "-122.20819"}, {"latitude": "40.25938", "longitude": "-122.19201"}, {"latitude": "40.28899", "longitude": "-122.18434"}, {"latitude": "40.26447", "longitude": "-122.22513"}, {"latitude": "40.25148", "longitude": "-122.22288"}, {"latitude": "40.25037", "longitude": "-122.22263"}, {"latitude": "40.23999", "longitude": "-122.218"}]
649925 October 09, 2019 - 07:38:00 UTC 40.26533 -122.22569 Red Bluff 20 [{"latitude": "40.26613", "longitude": "-122.22374"}, {"latitude": "40.27038", "longitude": "-122.21495"}, {"latitude": "40.3139", "longitude": "-122.17949"}, {"latitude": "40.32862", "longitude": "-122.18871"}, {"latitude": "40.33851", "longitude": "-122.20433"}, {"latitude": "40.32428", "longitude": "-122.22661"}, {"latitude": "40.27514", "longitude": "-122.22812"}]
649956 October 09, 2019 - 07:38:00 UTC 40.18279 -122.24482 Red Bluff 20 [{"latitude": "40.16127", "longitude": "-122.27262"}, {"latitude": "40.16191", "longitude": "-122.22882"}, {"latitude": "40.16317", "longitude": "-122.22873"}, {"latitude": "40.17248", "longitude": "-122.23135"}, {"latitude": "40.17398", "longitude": "-122.23246"}, {"latitude": "40.17556", "longitude": "-122.234"}, {"latitude": "40.1794", "longitude": "-122.24237"}, {"latitude": "40.17289", "longitude": "-122.28404"}, {"latitude": "40.16854", "longitude": "-122.28543"}, {"latitude": "40.16128", "longitude": "-122.27849"}]
649971 October 09, 2019 - 07:38:00 UTC 40.16489 -122.28122 Red Bluff 20 [{"latitude": "40.1583", "longitude": "-122.30527"}, {"latitude": "40.16145", "longitude": "-122.29038"}, {"latitude": "40.16491", "longitude": "-122.28306"}, {"latitude": "40.17193", "longitude": "-122.29005"}, {"latitude": "40.17353", "longitude": "-122.29306"}, {"latitude": "40.18383", "longitude": "-122.31447"}, {"latitude": "40.1877", "longitude": "-122.34133"}, {"latitude": "40.18928", "longitude": "-122.35385"}, {"latitude": "40.17786", "longitude": "-122.34852"}, {"latitude": "40.17589", "longitude": "-122.34562"}, {"latitude": "40.16761", "longitude": "-122.33044"}]
649980 October 09, 2019 - 07:38:00 UTC 40.18279 -122.24489 Red Bluff 20 [{"latitude": "40.17466", "longitude": "-122.23922"}, {"latitude": "40.17593", "longitude": "-122.23423"}, {"latitude": "40.17731", "longitude": "-122.23393"}, {"latitude": "40.18187", "longitude": "-122.23763"}, {"latitude": "40.18218", "longitude": "-122.2379"}, {"latitude": "40.18503", "longitude": "-122.24808"}, {"latitude": "40.18529", "longitude": "-122.25028"}, {"latitude": "40.17518", "longitude": "-122.23991"}]
649988 October 09, 2019 - 11:07:10 UTC 40.15948 -122.33797 Red Bluff 20 [{"latitude": "40.15959", "longitude": "-122.33135"}, {"latitude": "40.17156", "longitude": "-122.33521"}, {"latitude": "40.17166", "longitude": "-122.34404"}, {"latitude": "40.17097", "longitude": "-122.34765"}, {"latitude": "40.16857", "longitude": "-122.35171"}, {"latitude": "40.16246", "longitude": "-122.35027"}, {"latitude": "40.16215", "longitude": "-122.34979"}, {"latitude": "40.16179", "longitude": "-122.34795"}]
649992 October 09, 2019 - 07:38:00 UTC 40.1828 -122.24473 Red Bluff 20 [{"latitude": "40.17847", "longitude": "-122.23651"}, {"latitude": "40.18934", "longitude": "-122.23809"}, {"latitude": "40.18941", "longitude": "-122.23932"}, {"latitude": "40.18252", "longitude": "-122.24367"}]
650004 October 09, 2019 - 07:38:00 UTC 40.18268 -122.24154 Red Bluff 20 [{"latitude": "40.17231", "longitude": "-122.22414"}, {"latitude": "40.18416", "longitude": "-122.21881"}, {"latitude": "40.18663", "longitude": "-122.21812"}, {"latitude": "40.18837", "longitude": "-122.21828"}, {"latitude": "40.19689", "longitude": "-122.22069"}, {"latitude": "40.19729", "longitude": "-122.22159"}, {"latitude": "40.18252", "longitude": "-122.24141"}, {"latitude": "40.18102", "longitude": "-122.24153"}, {"latitude": "40.17929", "longitude": "-122.24116"}, {"latitude": "40.17758", "longitude": "-122.23998"}]
650014 October 09, 2019 - 07:38:00 UTC 40.19 -122.2383 Red Bluff 20 [{"latitude": "40.1899", "longitude": "-122.23358"}, {"latitude": "40.19386", "longitude": "-122.22723"}, {"latitude": "40.20606", "longitude": "-122.20881"}, {"latitude": "40.22123", "longitude": "-122.19594"}, {"latitude": "40.22237", "longitude": "-122.1951"}, {"latitude": "40.22716", "longitude": "-122.19292"}, {"latitude": "40.22171", "longitude": "-122.24016"}, {"latitude": "40.22066", "longitude": "-122.24491"}, {"latitude": "40.2205", "longitude": "-122.24562"}, {"latitude": "40.21833", "longitude": "-122.24848"}, {"latitude": "40.21462", "longitude": "-122.24754"}, {"latitude": "40.1905", "longitude": "-122.23906"}]

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