outages

455 rows where regionName = 85

View and edit SQL

id outageStartTime latitude longitude regionName outageDevices
633621 October 01, 2019 - 15:10:00 UTC 40.49104 -122.31006 Redding 85 [{"latitude": "40.4874", "longitude": "-122.30896"}, {"latitude": "40.48804", "longitude": "-122.30915"}, {"latitude": "40.49001", "longitude": "-122.30975"}, {"latitude": "40.49076", "longitude": "-122.30998"}, {"latitude": "40.48865", "longitude": "-122.30934"}]
633655 October 01, 2019 - 15:30:00 UTC 40.48431 -122.32419 Redding 85 [{"latitude": "40.48393", "longitude": "-122.32631"}, {"latitude": "40.48412", "longitude": "-122.32536"}, {"latitude": "40.48493", "longitude": "-122.32568"}]
638884 October 03, 2019 - 03:33:59 UTC 40.49093 -122.32075 Redding 85 []
638981 October 03, 2019 - 15:00:00 UTC 40.6871 -122.24921 Redding 85 []
641073 October 03, 2019 - 21:10:56 UTC 40.74774 -122.2328 Redding 85 []
642290 October 04, 2019 - 15:12:00 UTC 40.54653 -122.4365 Redding 85 []
647739 October 09, 2019 - 03:12:23 UTC 40.49941 -122.31263 Redding 85 []
648014 October 09, 2019 - 07:56:01 UTC 40.68326 -122.31354 Redding 85 []
648236 October 09, 2019 - 08:08:18 UTC 40.68129 -122.24507 Redding 85 []
648283 October 09, 2019 - 08:21:09 UTC 40.69021 -122.29659 Redding 85 []
648325 October 09, 2019 - 08:33:00 UTC 40.48817 -122.32781 Redding 85 []
648328 October 09, 2019 - 08:33:40 UTC 40.56488 -122.26066 Redding 85 [{"latitude": "40.55071", "longitude": "-122.25603"}, {"latitude": "40.55565", "longitude": "-122.24082"}, {"latitude": "40.56037", "longitude": "-122.25073"}, {"latitude": "40.56389", "longitude": "-122.26054"}, {"latitude": "40.56279", "longitude": "-122.26117"}, {"latitude": "40.55856", "longitude": "-122.26232"}, {"latitude": "40.55707", "longitude": "-122.26232"}]
648333 October 09, 2019 - 08:35:00 UTC 40.48879 -122.30712 Redding 85 []
648354 October 09, 2019 - 08:40:00 UTC 40.54553 -122.49568 Redding 85 []
648355 October 09, 2019 - 08:40:00 UTC 40.49186 -122.3063 Redding 85 []
648405 October 09, 2019 - 08:50:31 UTC 40.63744 -122.4014 Redding 85 []
648432 October 09, 2019 - 08:53:00 UTC 40.54562 -122.31178 Redding 85 []
648434 October 09, 2019 - 08:54:00 UTC 40.51814 -122.31229 Redding 85 []
648440 October 09, 2019 - 08:54:00 UTC 40.50729 -122.34072 Redding 85 []
648548 October 09, 2019 - 08:55:57 UTC 40.75136 -122.30605 Redding 85 []
648549 October 09, 2019 - 08:55:57 UTC 40.75551 -122.32258 Redding 85 []
648550 October 09, 2019 - 08:55:57 UTC 40.75779 -122.31995 Redding 85 []
648553 October 09, 2019 - 08:55:57 UTC 40.73256 -122.36788 Redding 85 []
648554 October 09, 2019 - 08:56:15 UTC 40.74665 -122.24018 Redding 85 []
648555 October 09, 2019 - 08:55:57 UTC 40.68808 -122.25258 Redding 85 []
648787 October 09, 2019 - 09:00:00 UTC 40.53734 -122.30687 Redding 85 []
648805 October 09, 2019 - 09:02:45 UTC 40.49573 -122.31913 Redding 85 []
648822 October 09, 2019 - 09:05:23 UTC 40.54938 -122.26989 Redding 85 []
648960 October 09, 2019 - 09:23:52 UTC 40.52861 -122.4871 Redding 85 []
648961 October 09, 2019 - 09:23:52 UTC 40.51243 -122.47752 Redding 85 []
648964 October 09, 2019 - 09:23:52 UTC 40.5282 -122.53061 Redding 85 []
648965 October 09, 2019 - 09:23:52 UTC 40.55827 -122.44191 Redding 85 []
648974 October 09, 2019 - 09:23:52 UTC 40.63896 -122.3673 Redding 85 [{"latitude": "40.62513", "longitude": "-122.39254"}, {"latitude": "40.63314", "longitude": "-122.36886"}, {"latitude": "40.63817", "longitude": "-122.36745"}, {"latitude": "40.63986", "longitude": "-122.36783"}, {"latitude": "40.64488", "longitude": "-122.37012"}, {"latitude": "40.64541", "longitude": "-122.37193"}, {"latitude": "40.64536", "longitude": "-122.37434"}, {"latitude": "40.64328", "longitude": "-122.38932"}, {"latitude": "40.63523", "longitude": "-122.39597"}, {"latitude": "40.63201", "longitude": "-122.39645"}, {"latitude": "40.63082", "longitude": "-122.39604"}]
648998 October 09, 2019 - 09:23:53 UTC 40.56931 -122.27367 Redding 85 []
648999 October 09, 2019 - 09:23:53 UTC 40.56656 -122.25863 Redding 85 []
649000 October 09, 2019 - 09:23:53 UTC 40.56549 -122.2658 Redding 85 []
649011 October 09, 2019 - 09:23:53 UTC 40.56675 -122.27691 Redding 85 []
649012 October 09, 2019 - 09:23:53 UTC 40.55844 -122.27246 Redding 85 []
649025 October 09, 2019 - 09:23:52 UTC 40.49139 -122.31664 Redding 85 []
649026 October 09, 2019 - 09:23:52 UTC 40.4801 -122.29575 Redding 85 []
649027 October 09, 2019 - 09:23:52 UTC 40.47988 -122.3094 Redding 85 [{"latitude": "40.47392", "longitude": "-122.30913"}, {"latitude": "40.47402", "longitude": "-122.3081"}, {"latitude": "40.47441", "longitude": "-122.30423"}, {"latitude": "40.4746", "longitude": "-122.30339"}, {"latitude": "40.47893", "longitude": "-122.30931"}, {"latitude": "40.47613", "longitude": "-122.31018"}]
649028 October 09, 2019 - 09:23:52 UTC 40.4883 -122.29318 Redding 85 []
649029 October 09, 2019 - 09:23:52 UTC 40.48435 -122.28928 Redding 85 []
649030 October 09, 2019 - 09:23:52 UTC 40.51154 -122.32615 Redding 85 []
649063 October 09, 2019 - 09:26:00 UTC 40.65466 -122.3209 Redding 85 []
649098 October 09, 2019 - 09:32:00 UTC 40.63618 -122.3995 Redding 85 []
649267 October 09, 2019 - 07:34:00 UTC 40.68081 -122.29855 Redding 85 [{"latitude": "40.65244", "longitude": "-122.30124"}, {"latitude": "40.67253", "longitude": "-122.29048"}, {"latitude": "40.67507", "longitude": "-122.2893"}, {"latitude": "40.67699", "longitude": "-122.28892"}, {"latitude": "40.67992", "longitude": "-122.28977"}, {"latitude": "40.6798", "longitude": "-122.30538"}, {"latitude": "40.67948", "longitude": "-122.31109"}, {"latitude": "40.67643", "longitude": "-122.31587"}, {"latitude": "40.67393", "longitude": "-122.31686"}, {"latitude": "40.66255", "longitude": "-122.32096"}]
649271 October 09, 2019 - 07:34:00 UTC 40.69047 -122.27861 Redding 85 [{"latitude": "40.67013", "longitude": "-122.25751"}, {"latitude": "40.67843", "longitude": "-122.22446"}, {"latitude": "40.69534", "longitude": "-122.20391"}, {"latitude": "40.70375", "longitude": "-122.20462"}, {"latitude": "40.70859", "longitude": "-122.20629"}, {"latitude": "40.74856", "longitude": "-122.23239"}, {"latitude": "40.75586", "longitude": "-122.24159"}, {"latitude": "40.75483", "longitude": "-122.24373"}, {"latitude": "40.7547", "longitude": "-122.24391"}, {"latitude": "40.69809", "longitude": "-122.27885"}, {"latitude": "40.69672", "longitude": "-122.2789"}, {"latitude": "40.69492", "longitude": "-122.27895"}, {"latitude": "40.69422", "longitude": "-122.27894"}, {"latitude": "40.69327", "longitude": "-122.27886"}, {"latitude": "40.69106", "longitude": "-122.27863"}, {"latitude": "40.68146", "longitude": "-122.27696"}]
649280 October 09, 2019 - 09:44:00 UTC 40.54738 -122.31181 Redding 85 []
649292 October 09, 2019 - 07:34:00 UTC 40.69594 -122.34275 Redding 85 [{"latitude": "40.68767", "longitude": "-122.30291"}, {"latitude": "40.69171", "longitude": "-122.29559"}, {"latitude": "40.75136", "longitude": "-122.30605"}, {"latitude": "40.75779", "longitude": "-122.31995"}, {"latitude": "40.75641", "longitude": "-122.32433"}, {"latitude": "40.73256", "longitude": "-122.36788"}, {"latitude": "40.70987", "longitude": "-122.34863"}, {"latitude": "40.70011", "longitude": "-122.34005"}, {"latitude": "40.68925", "longitude": "-122.3209"}, {"latitude": "40.68867", "longitude": "-122.31604"}]
649293 October 09, 2019 - 09:46:00 UTC 40.64375 -122.39632 Redding 85 []
649294 October 09, 2019 - 09:46:00 UTC 40.64326 -122.39697 Redding 85 []
649300 October 09, 2019 - 07:34:00 UTC 40.70385 -122.33639 Redding 85 [{"latitude": "40.68767", "longitude": "-122.30291"}, {"latitude": "40.69171", "longitude": "-122.29559"}, {"latitude": "40.70418", "longitude": "-122.29883"}, {"latitude": "40.70862", "longitude": "-122.31783"}, {"latitude": "40.71064", "longitude": "-122.32822"}, {"latitude": "40.71089", "longitude": "-122.33005"}, {"latitude": "40.70489", "longitude": "-122.33509"}, {"latitude": "40.70313", "longitude": "-122.33619"}, {"latitude": "40.68925", "longitude": "-122.3209"}, {"latitude": "40.68867", "longitude": "-122.31604"}]
649342 October 09, 2019 - 09:51:00 UTC 40.51259 -122.30809 Redding 85 []
649378 October 09, 2019 - 09:59:09 UTC 40.64219 -122.40137 Redding 85 []
649414 October 09, 2019 - 10:02:00 UTC 40.4818 -122.30572 Redding 85 []
649456 October 09, 2019 - 08:36:00 UTC 40.51343 -122.37896 Redding 85 [{"latitude": "40.50722", "longitude": "-122.31579"}, {"latitude": "40.5127", "longitude": "-122.30466"}, {"latitude": "40.53732", "longitude": "-122.29555"}, {"latitude": "40.53926", "longitude": "-122.29561"}, {"latitude": "40.54002", "longitude": "-122.29564"}, {"latitude": "40.5443", "longitude": "-122.29622"}, {"latitude": "40.54684", "longitude": "-122.29724"}, {"latitude": "40.54887", "longitude": "-122.29823"}, {"latitude": "40.54926", "longitude": "-122.29869"}, {"latitude": "40.56962", "longitude": "-122.36697"}, {"latitude": "40.59198", "longitude": "-122.45686"}, {"latitude": "40.59193", "longitude": "-122.4583"}, {"latitude": "40.58564", "longitude": "-122.48426"}, {"latitude": "40.58299", "longitude": "-122.48617"}, {"latitude": "40.57295", "longitude": "-122.4841"}, {"latitude": "40.53567", "longitude": "-122.45692"}, {"latitude": "40.52914", "longitude": "-122.45107"}, {"latitude": "40.51061", "longitude": "-122.35766"}]
649460 October 09, 2019 - 10:15:00 UTC 40.6175 -122.30953 Redding 85 []
649477 October 09, 2019 - 08:36:00 UTC 40.51343 -122.37904 Redding 85 [{"latitude": "40.36733", "longitude": "-122.58173"}, {"latitude": "40.4932", "longitude": "-122.37095"}, {"latitude": "40.49348", "longitude": "-122.37061"}, {"latitude": "40.49588", "longitude": "-122.36873"}, {"latitude": "40.49836", "longitude": "-122.37056"}, {"latitude": "40.51344", "longitude": "-122.38339"}, {"latitude": "40.51418", "longitude": "-122.38446"}, {"latitude": "40.55647", "longitude": "-122.46106"}, {"latitude": "40.55824", "longitude": "-122.46863"}, {"latitude": "40.55044", "longitude": "-122.57219"}, {"latitude": "40.54962", "longitude": "-122.57465"}, {"latitude": "40.49664", "longitude": "-122.69213"}, {"latitude": "40.46914", "longitude": "-122.6907"}, {"latitude": "40.46578", "longitude": "-122.68921"}, {"latitude": "40.38329", "longitude": "-122.61059"}]
649735 October 09, 2019 - 08:36:00 UTC 40.52201 -122.33364 Redding 85 [{"latitude": "40.52226", "longitude": "-122.33804"}, {"latitude": "40.52227", "longitude": "-122.33455"}, {"latitude": "40.53485", "longitude": "-122.29672"}, {"latitude": "40.53732", "longitude": "-122.29555"}, {"latitude": "40.53926", "longitude": "-122.29561"}, {"latitude": "40.54002", "longitude": "-122.29564"}, {"latitude": "40.5443", "longitude": "-122.29622"}, {"latitude": "40.54684", "longitude": "-122.29724"}, {"latitude": "40.54887", "longitude": "-122.29823"}, {"latitude": "40.54926", "longitude": "-122.29869"}, {"latitude": "40.55491", "longitude": "-122.36862"}, {"latitude": "40.55311", "longitude": "-122.37016"}, {"latitude": "40.52423", "longitude": "-122.34216"}, {"latitude": "40.52226", "longitude": "-122.3394"}]
649759 October 09, 2019 - 08:36:00 UTC 40.58048 -122.42822 Redding 85 [{"latitude": "40.56454", "longitude": "-122.47136"}, {"latitude": "40.56874", "longitude": "-122.45889"}, {"latitude": "40.57411", "longitude": "-122.44997"}, {"latitude": "40.58383", "longitude": "-122.44235"}, {"latitude": "40.59198", "longitude": "-122.45686"}, {"latitude": "40.59193", "longitude": "-122.4583"}, {"latitude": "40.58564", "longitude": "-122.48426"}, {"latitude": "40.58299", "longitude": "-122.48617"}, {"latitude": "40.57295", "longitude": "-122.4841"}]
649782 October 09, 2019 - 08:36:00 UTC 40.57092 -122.4263 Redding 85 [{"latitude": "40.52914", "longitude": "-122.45107"}, {"latitude": "40.54779", "longitude": "-122.42713"}, {"latitude": "40.56157", "longitude": "-122.42727"}, {"latitude": "40.57391", "longitude": "-122.44093"}, {"latitude": "40.57223", "longitude": "-122.44803"}, {"latitude": "40.55652", "longitude": "-122.45776"}, {"latitude": "40.55346", "longitude": "-122.45772"}, {"latitude": "40.53567", "longitude": "-122.45692"}]
649842 October 09, 2019 - 10:46:00 UTC 40.49258 -122.30727 Redding 85 []
649859 October 09, 2019 - 10:49:19 UTC 40.5627 -122.29062 Redding 85 []
649949 October 09, 2019 - 08:36:00 UTC 40.51588 -122.38237 Redding 85 [{"latitude": "40.50001", "longitude": "-122.44303"}, {"latitude": "40.50019", "longitude": "-122.43909"}, {"latitude": "40.50735", "longitude": "-122.39095"}, {"latitude": "40.50989", "longitude": "-122.38696"}, {"latitude": "40.51344", "longitude": "-122.38339"}, {"latitude": "40.51418", "longitude": "-122.38446"}, {"latitude": "40.52348", "longitude": "-122.46358"}, {"latitude": "40.5247", "longitude": "-122.50236"}, {"latitude": "40.52392", "longitude": "-122.50284"}, {"latitude": "40.52002", "longitude": "-122.50512"}, {"latitude": "40.5178", "longitude": "-122.5051"}, {"latitude": "40.51711", "longitude": "-122.50402"}, {"latitude": "40.51523", "longitude": "-122.50092"}, {"latitude": "40.50568", "longitude": "-122.47179"}, {"latitude": "40.50013", "longitude": "-122.45074"}]
649969 October 09, 2019 - 08:36:00 UTC 40.52108 -122.47845 Redding 85 [{"latitude": "40.52087", "longitude": "-122.47238"}, {"latitude": "40.52156", "longitude": "-122.46777"}, {"latitude": "40.54163", "longitude": "-122.45679"}, {"latitude": "40.54565", "longitude": "-122.45658"}, {"latitude": "40.54686", "longitude": "-122.45695"}, {"latitude": "40.54957", "longitude": "-122.45796"}, {"latitude": "40.55647", "longitude": "-122.46106"}, {"latitude": "40.55824", "longitude": "-122.46863"}, {"latitude": "40.54555", "longitude": "-122.50486"}, {"latitude": "40.52541", "longitude": "-122.48699"}, {"latitude": "40.52466", "longitude": "-122.48531"}, {"latitude": "40.52146", "longitude": "-122.47812"}]
649977 October 09, 2019 - 08:36:00 UTC 40.51763 -122.50594 Redding 85 [{"latitude": "40.36733", "longitude": "-122.58173"}, {"latitude": "40.50761", "longitude": "-122.50123"}, {"latitude": "40.50926", "longitude": "-122.50076"}, {"latitude": "40.51501", "longitude": "-122.50498"}, {"latitude": "40.52997", "longitude": "-122.51776"}, {"latitude": "40.53877", "longitude": "-122.52642"}, {"latitude": "40.54949", "longitude": "-122.56787"}, {"latitude": "40.55044", "longitude": "-122.57219"}, {"latitude": "40.54962", "longitude": "-122.57465"}, {"latitude": "40.49664", "longitude": "-122.69213"}, {"latitude": "40.46914", "longitude": "-122.6907"}, {"latitude": "40.46578", "longitude": "-122.68921"}, {"latitude": "40.38329", "longitude": "-122.61059"}]
650033 October 09, 2019 - 08:24:00 UTC 40.61904 -122.32266 Redding 85 [{"latitude": "40.5313", "longitude": "-122.27224"}, {"latitude": "40.53281", "longitude": "-122.26826"}, {"latitude": "40.53674", "longitude": "-122.26002"}, {"latitude": "40.5439", "longitude": "-122.25986"}, {"latitude": "40.54763", "longitude": "-122.25989"}, {"latitude": "40.62823", "longitude": "-122.26954"}, {"latitude": "40.62834", "longitude": "-122.27068"}, {"latitude": "40.62833", "longitude": "-122.272"}, {"latitude": "40.62648", "longitude": "-122.28038"}, {"latitude": "40.61763", "longitude": "-122.31733"}, {"latitude": "40.61421", "longitude": "-122.31963"}, {"latitude": "40.57103", "longitude": "-122.32623"}, {"latitude": "40.5313", "longitude": "-122.27418"}]
650040 October 09, 2019 - 08:24:00 UTC 40.58856 -122.29852 Redding 85 [{"latitude": "40.57462", "longitude": "-122.29415"}, {"latitude": "40.57468", "longitude": "-122.29208"}, {"latitude": "40.57717", "longitude": "-122.28787"}, {"latitude": "40.60534", "longitude": "-122.26823"}, {"latitude": "40.62823", "longitude": "-122.26954"}, {"latitude": "40.62834", "longitude": "-122.27068"}, {"latitude": "40.62833", "longitude": "-122.272"}, {"latitude": "40.62648", "longitude": "-122.28038"}, {"latitude": "40.62561", "longitude": "-122.28257"}, {"latitude": "40.59896", "longitude": "-122.29925"}, {"latitude": "40.59839", "longitude": "-122.29955"}, {"latitude": "40.59401", "longitude": "-122.30099"}, {"latitude": "40.58472", "longitude": "-122.29984"}, {"latitude": "40.5818", "longitude": "-122.29945"}, {"latitude": "40.57571", "longitude": "-122.29759"}, {"latitude": "40.57512", "longitude": "-122.29702"}]
650048 October 09, 2019 - 08:24:00 UTC 40.57114 -122.29966 Redding 85 [{"latitude": "40.5313", "longitude": "-122.27418"}, {"latitude": "40.5313", "longitude": "-122.27224"}, {"latitude": "40.53281", "longitude": "-122.26826"}, {"latitude": "40.53674", "longitude": "-122.26002"}, {"latitude": "40.5439", "longitude": "-122.25986"}, {"latitude": "40.54763", "longitude": "-122.25989"}, {"latitude": "40.55994", "longitude": "-122.26529"}, {"latitude": "40.57293", "longitude": "-122.27672"}, {"latitude": "40.57339", "longitude": "-122.29227"}, {"latitude": "40.57342", "longitude": "-122.29642"}, {"latitude": "40.56991", "longitude": "-122.29751"}, {"latitude": "40.56503", "longitude": "-122.29776"}, {"latitude": "40.54927", "longitude": "-122.2967"}]
650053 October 09, 2019 - 08:24:00 UTC 40.57107 -122.31398 Redding 85 [{"latitude": "40.56872", "longitude": "-122.31484"}, {"latitude": "40.57203", "longitude": "-122.31539"}, {"latitude": "40.57821", "longitude": "-122.31758"}, {"latitude": "40.57839", "longitude": "-122.31779"}, {"latitude": "40.57839", "longitude": "-122.31851"}, {"latitude": "40.57829", "longitude": "-122.32013"}, {"latitude": "40.57103", "longitude": "-122.32623"}]
650065 October 09, 2019 - 08:24:00 UTC 40.61904 -122.32271 Redding 85 [{"latitude": "40.61016", "longitude": "-122.30357"}, {"latitude": "40.6115", "longitude": "-122.28583"}, {"latitude": "40.61467", "longitude": "-122.25136"}, {"latitude": "40.61514", "longitude": "-122.24889"}, {"latitude": "40.70345", "longitude": "-122.0909"}, {"latitude": "40.7279", "longitude": "-122.07785"}, {"latitude": "40.74028", "longitude": "-122.08576"}, {"latitude": "40.74588", "longitude": "-122.09062"}, {"latitude": "40.65083", "longitude": "-122.29976"}, {"latitude": "40.62099", "longitude": "-122.33025"}, {"latitude": "40.61882", "longitude": "-122.33027"}, {"latitude": "40.61129", "longitude": "-122.31057"}]
650077 October 09, 2019 - 08:24:00 UTC 40.61706 -122.334 Redding 85 [{"latitude": "40.61158", "longitude": "-122.38365"}, {"latitude": "40.61224", "longitude": "-122.35941"}, {"latitude": "40.61324", "longitude": "-122.35505"}]
650093 October 09, 2019 - 08:24:00 UTC 40.61208 -122.38365 Redding 85 [{"latitude": "40.61091", "longitude": "-122.43068"}, {"latitude": "40.61374", "longitude": "-122.41254"}, {"latitude": "40.64235", "longitude": "-122.39108"}, {"latitude": "40.65121", "longitude": "-122.39361"}, {"latitude": "40.65122", "longitude": "-122.40386"}, {"latitude": "40.65053", "longitude": "-122.40723"}, {"latitude": "40.65", "longitude": "-122.40938"}, {"latitude": "40.64269", "longitude": "-122.42917"}, {"latitude": "40.63562", "longitude": "-122.43873"}, {"latitude": "40.63163", "longitude": "-122.4396"}, {"latitude": "40.61508", "longitude": "-122.4393"}]
650123 October 09, 2019 - 08:19:00 UTC 40.61905 -122.32276 Redding 85 [{"latitude": "40.62149", "longitude": "-122.32347"}, {"latitude": "40.62655", "longitude": "-122.32011"}, {"latitude": "40.63692", "longitude": "-122.32324"}, {"latitude": "40.64815", "longitude": "-122.32942"}, {"latitude": "40.65334", "longitude": "-122.33428"}, {"latitude": "40.65141", "longitude": "-122.33805"}, {"latitude": "40.64452", "longitude": "-122.33974"}, {"latitude": "40.62923", "longitude": "-122.33486"}]
650133 October 09, 2019 - 08:19:00 UTC 40.65388 -122.33336 Redding 85 [{"latitude": "40.6414", "longitude": "-122.3065"}, {"latitude": "40.64269", "longitude": "-122.30594"}, {"latitude": "40.64757", "longitude": "-122.3044"}, {"latitude": "40.64946", "longitude": "-122.30448"}, {"latitude": "40.65101", "longitude": "-122.3048"}, {"latitude": "40.662", "longitude": "-122.30833"}, {"latitude": "40.66451", "longitude": "-122.31621"}, {"latitude": "40.66299", "longitude": "-122.3282"}, {"latitude": "40.66114", "longitude": "-122.32924"}, {"latitude": "40.65588", "longitude": "-122.33045"}, {"latitude": "40.65253", "longitude": "-122.32498"}]
650141 October 09, 2019 - 08:19:00 UTC 40.65889 -122.34098 Redding 85 [{"latitude": "40.61256", "longitude": "-122.37543"}, {"latitude": "40.64192", "longitude": "-122.34324"}, {"latitude": "40.64263", "longitude": "-122.34273"}, {"latitude": "40.66682", "longitude": "-122.33723"}, {"latitude": "40.67123", "longitude": "-122.33666"}, {"latitude": "40.67819", "longitude": "-122.34984"}, {"latitude": "40.67969", "longitude": "-122.4079"}, {"latitude": "40.67972", "longitude": "-122.40964"}, {"latitude": "40.6784", "longitude": "-122.41859"}, {"latitude": "40.66281", "longitude": "-122.43894"}, {"latitude": "40.65816", "longitude": "-122.43498"}, {"latitude": "40.62513", "longitude": "-122.39254"}]
650583 October 09, 2019 - 08:24:00 UTC 40.4831 -122.3225 Redding 85 [{"latitude": "40.47287", "longitude": "-122.31152"}, {"latitude": "40.47441", "longitude": "-122.30423"}, {"latitude": "40.4746", "longitude": "-122.30339"}, {"latitude": "40.47872", "longitude": "-122.29641"}, {"latitude": "40.47955", "longitude": "-122.29574"}, {"latitude": "40.4801", "longitude": "-122.29575"}, {"latitude": "40.4839", "longitude": "-122.29656"}, {"latitude": "40.49225", "longitude": "-122.31461"}, {"latitude": "40.49104", "longitude": "-122.31908"}, {"latitude": "40.48905", "longitude": "-122.32587"}, {"latitude": "40.48802", "longitude": "-122.32515"}, {"latitude": "40.48524", "longitude": "-122.32278"}]
653808 October 09, 2019 - 08:24:00 UTC 40.49838 -122.32483 Redding 85 [{"latitude": "40.48168", "longitude": "-122.29148"}, {"latitude": "40.48839", "longitude": "-122.26806"}, {"latitude": "40.50763", "longitude": "-122.27623"}, {"latitude": "40.50482", "longitude": "-122.31835"}, {"latitude": "40.50357", "longitude": "-122.31916"}, {"latitude": "40.49835", "longitude": "-122.32228"}, {"latitude": "40.49332", "longitude": "-122.32479"}, {"latitude": "40.4818", "longitude": "-122.30572"}, {"latitude": "40.48168", "longitude": "-122.29276"}]
653892 October 11, 2019 - 03:13:00 UTC 40.54442 -122.49764 Redding 85 []
653896 October 11, 2019 - 03:18:04 UTC 40.54666 -122.48024 Redding 85 []
653914 October 11, 2019 - 03:34:37 UTC 40.50565 -122.34844 Redding 85 []
653918 October 11, 2019 - 03:36:37 UTC 40.54163 -122.45679 Redding 85 []
653924 October 11, 2019 - 03:42:00 UTC 40.64177 -122.39505 Redding 85 []
654075 October 11, 2019 - 11:52:00 UTC 40.55462 -122.46889 Redding 85 []
654076 October 11, 2019 - 11:59:00 UTC 40.67885 -122.33595 Redding 85 []
654362 October 11, 2019 - 18:15:30 UTC 40.47897 -122.30125 Redding 85 []
654376 October 11, 2019 - 18:35:00 UTC 40.4839 -122.29656 Redding 85 []
654380 October 11, 2019 - 18:39:48 UTC 40.48745 -122.32322 Redding 85 []
654402 October 11, 2019 - 19:01:53 UTC 40.63978 -122.38351 Redding 85 []
654407 October 09, 2019 - 07:34:00 UTC 40.72137 -122.24156 Redding 85 [{"latitude": "40.72095", "longitude": "-122.23815"}, {"latitude": "40.72202", "longitude": "-122.23534"}, {"latitude": "40.72313", "longitude": "-122.23318"}, {"latitude": "40.73667", "longitude": "-122.22687"}, {"latitude": "40.74769", "longitude": "-122.23194"}, {"latitude": "40.74856", "longitude": "-122.23239"}, {"latitude": "40.75586", "longitude": "-122.24159"}, {"latitude": "40.75483", "longitude": "-122.24373"}, {"latitude": "40.7547", "longitude": "-122.24391"}, {"latitude": "40.74819", "longitude": "-122.24395"}, {"latitude": "40.72158", "longitude": "-122.23839"}]
654453 October 11, 2019 - 19:47:20 UTC 40.7157 -122.238 Redding 85 []
654464 October 11, 2019 - 20:06:00 UTC 40.70373 -122.23353 Redding 85 []
654491 October 11, 2019 - 20:35:00 UTC 40.69669 -122.23914 Redding 85 []
654499 October 11, 2019 - 20:43:00 UTC 40.48168 -122.29276 Redding 85 []
654520 October 11, 2019 - 20:57:06 UTC 40.51882 -122.30862 Redding 85 []
654545 October 11, 2019 - 21:08:28 UTC 40.71356 -122.24135 Redding 85 [{"latitude": "40.71377", "longitude": "-122.23424"}, {"latitude": "40.72008", "longitude": "-122.23098"}, {"latitude": "40.72059", "longitude": "-122.23078"}, {"latitude": "40.72003", "longitude": "-122.23383"}, {"latitude": "40.71956", "longitude": "-122.23617"}, {"latitude": "40.71899", "longitude": "-122.2369"}, {"latitude": "40.71396", "longitude": "-122.24097"}]
654570 October 11, 2019 - 21:26:00 UTC 40.6974 -122.22804 Redding 85 []
654593 October 09, 2019 - 08:19:00 UTC 40.65765 -122.4215 Redding 85 [{"latitude": "40.6544", "longitude": "-122.42159"}, {"latitude": "40.66268", "longitude": "-122.42802"}, {"latitude": "40.66281", "longitude": "-122.43894"}, {"latitude": "40.65816", "longitude": "-122.43498"}]
654651 October 11, 2019 - 22:35:34 UTC 40.71703 -122.23858 Redding 85 []

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