outages

82 rows where regionName = 105

View and edit SQL

Suggested facets: outageDevices

id outageStartTime latitude longitude regionName outageDevices
633785 October 01, 2019 - 15:57:00 UTC 39.21671 -120.79452 Alta 105 [{"latitude": "39.21074", "longitude": "-120.79341"}, {"latitude": "39.21114", "longitude": "-120.79064"}, {"latitude": "39.21202", "longitude": "-120.78824"}, {"latitude": "39.21778", "longitude": "-120.78288"}, {"latitude": "39.22054", "longitude": "-120.78588"}, {"latitude": "39.21905", "longitude": "-120.79202"}, {"latitude": "39.21669", "longitude": "-120.79395"}, {"latitude": "39.21152", "longitude": "-120.79492"}]
635399 October 02, 2019 - 00:17:57 UTC 39.21781 -120.78583 Alta 105 [{"latitude": "39.21074", "longitude": "-120.79341"}, {"latitude": "39.21114", "longitude": "-120.79064"}, {"latitude": "39.21202", "longitude": "-120.78824"}, {"latitude": "39.21778", "longitude": "-120.78288"}, {"latitude": "39.21455", "longitude": "-120.78774"}]
637414 October 02, 2019 - 19:48:10 UTC 39.29018 -120.67995 Alta 105 []
637633 October 02, 2019 - 20:21:49 UTC 39.21744 -120.83338 Alta 105 []
649467 October 09, 2019 - 10:18:02 UTC 39.25805 -120.732 Alta 105 []
649468 October 09, 2019 - 10:18:02 UTC 39.27603 -120.71733 Alta 105 [{"latitude": "39.27753", "longitude": "-120.71945"}, {"latitude": "39.29262", "longitude": "-120.71694"}, {"latitude": "39.29077", "longitude": "-120.72412"}, {"latitude": "39.29046", "longitude": "-120.72531"}, {"latitude": "39.28965", "longitude": "-120.72606"}]
649479 October 09, 2019 - 09:07:00 UTC 39.21414 -120.80969 Alta 105 [{"latitude": "39.149", "longitude": "-120.85587"}, {"latitude": "39.2009", "longitude": "-120.76352"}, {"latitude": "39.24138", "longitude": "-120.76939"}, {"latitude": "39.24296", "longitude": "-120.77057"}, {"latitude": "39.22641", "longitude": "-120.81438"}, {"latitude": "39.21744", "longitude": "-120.83338"}, {"latitude": "39.2166", "longitude": "-120.83428"}, {"latitude": "39.17233", "longitude": "-120.87928"}, {"latitude": "39.16523", "longitude": "-120.87771"}, {"latitude": "39.16389", "longitude": "-120.87733"}]
649492 October 09, 2019 - 09:07:00 UTC 39.214 -120.80977 Alta 105 [{"latitude": "39.149", "longitude": "-120.85587"}, {"latitude": "39.19256", "longitude": "-120.8245"}, {"latitude": "39.21498", "longitude": "-120.80921"}, {"latitude": "39.21526", "longitude": "-120.80936"}, {"latitude": "39.21255", "longitude": "-120.82751"}, {"latitude": "39.20986", "longitude": "-120.83348"}, {"latitude": "39.20609", "longitude": "-120.84123"}, {"latitude": "39.20405", "longitude": "-120.84359"}, {"latitude": "39.17233", "longitude": "-120.87928"}, {"latitude": "39.16523", "longitude": "-120.87771"}, {"latitude": "39.16389", "longitude": "-120.87733"}]
649545 October 09, 2019 - 09:07:00 UTC 39.214 -120.80984 Alta 105 [{"latitude": "39.1656", "longitude": "-120.83431"}, {"latitude": "39.16682", "longitude": "-120.82953"}, {"latitude": "39.2009", "longitude": "-120.76352"}, {"latitude": "39.24138", "longitude": "-120.76939"}, {"latitude": "39.24296", "longitude": "-120.77057"}, {"latitude": "39.22641", "longitude": "-120.81438"}, {"latitude": "39.21744", "longitude": "-120.83338"}, {"latitude": "39.2166", "longitude": "-120.83428"}, {"latitude": "39.17936", "longitude": "-120.83572"}, {"latitude": "39.16788", "longitude": "-120.83523"}]
649546 October 09, 2019 - 10:18:02 UTC 39.25619 -120.76687 Alta 105 [{"latitude": "39.23917", "longitude": "-120.75195"}, {"latitude": "39.24065", "longitude": "-120.73572"}, {"latitude": "39.25472", "longitude": "-120.70976"}, {"latitude": "39.26897", "longitude": "-120.69434"}, {"latitude": "39.29018", "longitude": "-120.67995"}, {"latitude": "39.29098", "longitude": "-120.68053"}, {"latitude": "39.29262", "longitude": "-120.71694"}, {"latitude": "39.29077", "longitude": "-120.72412"}, {"latitude": "39.29046", "longitude": "-120.72531"}, {"latitude": "39.25502", "longitude": "-120.7747"}, {"latitude": "39.25393", "longitude": "-120.77437"}]
654438 October 09, 2019 - 09:07:00 UTC 39.20995 -120.80204 Alta 105 [{"latitude": "39.20395", "longitude": "-120.80495"}, {"latitude": "39.20553", "longitude": "-120.79234"}, {"latitude": "39.21111", "longitude": "-120.77912"}, {"latitude": "39.21368", "longitude": "-120.77542"}, {"latitude": "39.21622", "longitude": "-120.77368"}, {"latitude": "39.21741", "longitude": "-120.7732"}, {"latitude": "39.22061", "longitude": "-120.77637"}, {"latitude": "39.22111", "longitude": "-120.7789"}, {"latitude": "39.22054", "longitude": "-120.78588"}, {"latitude": "39.21923", "longitude": "-120.79433"}, {"latitude": "39.21593", "longitude": "-120.80362"}]
654447 October 09, 2019 - 09:07:00 UTC 39.21596 -120.80584 Alta 105 [{"latitude": "39.21528", "longitude": "-120.81477"}, {"latitude": "39.21644", "longitude": "-120.8068"}, {"latitude": "39.23076", "longitude": "-120.77171"}, {"latitude": "39.24138", "longitude": "-120.76939"}, {"latitude": "39.24296", "longitude": "-120.77057"}, {"latitude": "39.22641", "longitude": "-120.81438"}, {"latitude": "39.21744", "longitude": "-120.83338"}, {"latitude": "39.2166", "longitude": "-120.83428"}]
654504 October 11, 2019 - 20:48:49 UTC 39.214 -120.80977 Alta 105 [{"latitude": "39.20319", "longitude": "-120.82751"}, {"latitude": "39.20473", "longitude": "-120.82253"}, {"latitude": "39.2099", "longitude": "-120.81416"}, {"latitude": "39.21498", "longitude": "-120.80921"}, {"latitude": "39.21526", "longitude": "-120.80936"}, {"latitude": "39.21255", "longitude": "-120.82751"}, {"latitude": "39.20986", "longitude": "-120.83348"}, {"latitude": "39.20427", "longitude": "-120.83245"}]
654521 October 11, 2019 - 21:01:14 UTC 39.20856 -120.81891 Alta 105 []
654771 October 09, 2019 - 10:18:02 UTC 39.25168 -120.74996 Alta 105 [{"latitude": "39.23917", "longitude": "-120.75195"}, {"latitude": "39.24065", "longitude": "-120.73572"}, {"latitude": "39.25472", "longitude": "-120.70976"}, {"latitude": "39.26897", "longitude": "-120.69434"}, {"latitude": "39.29018", "longitude": "-120.67995"}, {"latitude": "39.29098", "longitude": "-120.68053"}, {"latitude": "39.29262", "longitude": "-120.71694"}, {"latitude": "39.29077", "longitude": "-120.72412"}, {"latitude": "39.29046", "longitude": "-120.72531"}, {"latitude": "39.28965", "longitude": "-120.72606"}, {"latitude": "39.24789", "longitude": "-120.74826"}]
654910 October 12, 2019 - 02:42:43 UTC 39.20763 -120.80007 Alta 105 []
655101 October 12, 2019 - 16:03:47 UTC 39.20763 -120.80007 Alta 105 []
678649 October 23, 2019 - 23:03:06 UTC 39.20342 -120.77075 Alta 105 []
678651 October 23, 2019 - 23:03:06 UTC 39.23692 -120.77465 Alta 105 []
678660 October 23, 2019 - 23:03:35 UTC 39.2074 -120.81124 Alta 105 []
678661 October 23, 2019 - 23:03:35 UTC 39.2078 -120.80979 Alta 105 []
678662 October 23, 2019 - 23:03:35 UTC 39.20686 -120.80762 Alta 105 []
678663 October 23, 2019 - 23:03:35 UTC 39.2161 -120.77465 Alta 105 []
678664 October 23, 2019 - 23:03:35 UTC 39.21475 -120.7861 Alta 105 []
678666 October 23, 2019 - 23:03:35 UTC 39.20598 -120.80908 Alta 105 []
678667 October 23, 2019 - 23:03:35 UTC 39.20705 -120.81256 Alta 105 []
678668 October 23, 2019 - 23:03:35 UTC 39.22342 -120.816 Alta 105 []
678696 October 23, 2019 - 22:56:00 UTC 39.214 -120.80977 Alta 105 [{"latitude": "39.18029", "longitude": "-120.85095"}, {"latitude": "39.18415", "longitude": "-120.83235"}, {"latitude": "39.19256", "longitude": "-120.8245"}, {"latitude": "39.21498", "longitude": "-120.80921"}, {"latitude": "39.21526", "longitude": "-120.80936"}, {"latitude": "39.21255", "longitude": "-120.82751"}, {"latitude": "39.20986", "longitude": "-120.83348"}, {"latitude": "39.20609", "longitude": "-120.84123"}, {"latitude": "39.20405", "longitude": "-120.84359"}, {"latitude": "39.18349", "longitude": "-120.86041"}, {"latitude": "39.1813", "longitude": "-120.85957"}]
678735 October 23, 2019 - 22:56:00 UTC 39.214 -120.80984 Alta 105 [{"latitude": "39.1656", "longitude": "-120.83431"}, {"latitude": "39.16682", "longitude": "-120.82953"}, {"latitude": "39.2009", "longitude": "-120.76352"}, {"latitude": "39.24138", "longitude": "-120.76939"}, {"latitude": "39.24296", "longitude": "-120.77057"}, {"latitude": "39.22641", "longitude": "-120.81438"}, {"latitude": "39.21744", "longitude": "-120.83338"}, {"latitude": "39.2166", "longitude": "-120.83428"}, {"latitude": "39.17936", "longitude": "-120.83572"}, {"latitude": "39.16788", "longitude": "-120.83523"}]
679753 October 23, 2019 - 22:56:00 UTC 39.21268 -120.7813 Alta 105 [{"latitude": "39.21111", "longitude": "-120.77912"}, {"latitude": "39.21339", "longitude": "-120.7773"}, {"latitude": "39.21258", "longitude": "-120.77858"}]
682462 October 27, 2019 - 01:56:00 UTC 39.25619 -120.76687 Alta 105 [{"latitude": "39.24982", "longitude": "-120.75154"}, {"latitude": "39.25068", "longitude": "-120.75028"}, {"latitude": "39.25766", "longitude": "-120.76624"}, {"latitude": "39.25502", "longitude": "-120.7747"}, {"latitude": "39.25393", "longitude": "-120.77437"}, {"latitude": "39.24984", "longitude": "-120.75175"}]
682491 October 27, 2019 - 01:56:00 UTC 39.25168 -120.74996 Alta 105 [{"latitude": "39.23917", "longitude": "-120.75195"}, {"latitude": "39.24065", "longitude": "-120.73572"}, {"latitude": "39.25472", "longitude": "-120.70976"}, {"latitude": "39.26897", "longitude": "-120.69434"}, {"latitude": "39.29018", "longitude": "-120.67995"}, {"latitude": "39.29098", "longitude": "-120.68053"}, {"latitude": "39.29262", "longitude": "-120.71694"}, {"latitude": "39.29077", "longitude": "-120.72412"}, {"latitude": "39.29046", "longitude": "-120.72531"}, {"latitude": "39.28965", "longitude": "-120.72606"}, {"latitude": "39.24789", "longitude": "-120.74826"}]
682635 October 27, 2019 - 02:09:47 UTC 39.214 -120.80984 Alta 105 [{"latitude": "39.1656", "longitude": "-120.83431"}, {"latitude": "39.16682", "longitude": "-120.82953"}, {"latitude": "39.2009", "longitude": "-120.76352"}, {"latitude": "39.24138", "longitude": "-120.76939"}, {"latitude": "39.24296", "longitude": "-120.77057"}, {"latitude": "39.22641", "longitude": "-120.81438"}, {"latitude": "39.21744", "longitude": "-120.83338"}, {"latitude": "39.2166", "longitude": "-120.83428"}, {"latitude": "39.17936", "longitude": "-120.83572"}, {"latitude": "39.16788", "longitude": "-120.83523"}]
682759 October 27, 2019 - 02:20:44 UTC 39.30945 -120.67293 Alta 105 []
682767 October 27, 2019 - 02:21:15 UTC 39.29189 -120.67794 Alta 105 []
682768 October 27, 2019 - 02:21:15 UTC 39.29506 -120.6754 Alta 105 []
683854 October 27, 2019 - 02:01:00 UTC 39.214 -120.80984 Alta 105 [{"latitude": "39.1656", "longitude": "-120.83431"}, {"latitude": "39.16682", "longitude": "-120.82953"}, {"latitude": "39.2009", "longitude": "-120.76352"}, {"latitude": "39.24138", "longitude": "-120.76939"}, {"latitude": "39.24296", "longitude": "-120.77057"}, {"latitude": "39.22641", "longitude": "-120.81438"}, {"latitude": "39.21744", "longitude": "-120.83338"}, {"latitude": "39.2166", "longitude": "-120.83428"}, {"latitude": "39.17936", "longitude": "-120.83572"}, {"latitude": "39.16788", "longitude": "-120.83523"}]
683881 October 27, 2019 - 02:01:00 UTC 39.214 -120.80977 Alta 105 [{"latitude": "39.18029", "longitude": "-120.85095"}, {"latitude": "39.18415", "longitude": "-120.83235"}, {"latitude": "39.19256", "longitude": "-120.8245"}, {"latitude": "39.21498", "longitude": "-120.80921"}, {"latitude": "39.21526", "longitude": "-120.80936"}, {"latitude": "39.21255", "longitude": "-120.82751"}, {"latitude": "39.20986", "longitude": "-120.83348"}, {"latitude": "39.20609", "longitude": "-120.84123"}, {"latitude": "39.20405", "longitude": "-120.84359"}, {"latitude": "39.18349", "longitude": "-120.86041"}, {"latitude": "39.1813", "longitude": "-120.85957"}]
690716 October 27, 2019 - 02:01:00 UTC 39.20995 -120.80204 Alta 105 [{"latitude": "39.20395", "longitude": "-120.80495"}, {"latitude": "39.20553", "longitude": "-120.79234"}, {"latitude": "39.21111", "longitude": "-120.77912"}, {"latitude": "39.21368", "longitude": "-120.77542"}, {"latitude": "39.21622", "longitude": "-120.77368"}, {"latitude": "39.21741", "longitude": "-120.7732"}, {"latitude": "39.22061", "longitude": "-120.77637"}, {"latitude": "39.22111", "longitude": "-120.7789"}, {"latitude": "39.22054", "longitude": "-120.78588"}, {"latitude": "39.21923", "longitude": "-120.79433"}, {"latitude": "39.21593", "longitude": "-120.80362"}]
704799 November 12, 2019 - 17:01:50 UTC 39.21708 -120.81341 Alta 105 []
704801 November 12, 2019 - 17:01:50 UTC 39.21707 -120.80953 Alta 105 [{"latitude": "39.21735", "longitude": "-120.80967"}, {"latitude": "39.23076", "longitude": "-120.77171"}, {"latitude": "39.24138", "longitude": "-120.76939"}, {"latitude": "39.24296", "longitude": "-120.77057"}, {"latitude": "39.22403", "longitude": "-120.80261"}, {"latitude": "39.22082", "longitude": "-120.80674"}]
704802 November 12, 2019 - 17:01:51 UTC 39.21824 -120.81469 Alta 105 []
704803 November 12, 2019 - 17:01:51 UTC 39.21797 -120.82538 Alta 105 []
704805 November 12, 2019 - 17:01:51 UTC 39.22405 -120.81418 Alta 105 []
704806 November 12, 2019 - 17:01:50 UTC 39.22403 -120.81252 Alta 105 []
713807 November 24, 2019 - 18:23:00 UTC 39.24703 -120.7341 Alta 105 []
719860 November 27, 2019 - 12:19:08 UTC 39.21708 -120.81341 Alta 105 []
719861 November 27, 2019 - 12:19:08 UTC 39.21707 -120.80953 Alta 105 [{"latitude": "39.21735", "longitude": "-120.80967"}, {"latitude": "39.23076", "longitude": "-120.77171"}, {"latitude": "39.24138", "longitude": "-120.76939"}, {"latitude": "39.24296", "longitude": "-120.77057"}, {"latitude": "39.22403", "longitude": "-120.80261"}, {"latitude": "39.22082", "longitude": "-120.80674"}]
719862 November 27, 2019 - 12:19:08 UTC 39.21824 -120.81469 Alta 105 []
719863 November 27, 2019 - 12:19:09 UTC 39.21797 -120.82538 Alta 105 []
719864 November 27, 2019 - 12:19:08 UTC 39.21644 -120.82543 Alta 105 []
719865 November 27, 2019 - 12:19:08 UTC 39.22342 -120.816 Alta 105 []
719866 November 27, 2019 - 12:19:08 UTC 39.22403 -120.81252 Alta 105 []
719894 November 27, 2019 - 12:19:08 UTC 39.21708 -120.81341 Alta 105 []
719897 November 27, 2019 - 12:19:08 UTC 39.22342 -120.816 Alta 105 []
719899 November 27, 2019 - 12:52:14 UTC 39.21812 -120.822 Alta 105 []
720000 November 27, 2019 - 12:19:08 UTC 39.22434 -120.81277 Alta 105 []
720136 November 27, 2019 - 13:53:02 UTC 39.21812 -120.822 Alta 105 []
720333 November 27, 2019 - 14:53:48 UTC 39.21627 -120.81688 Alta 105 []
720417 November 27, 2019 - 12:19:08 UTC 39.21451 -120.80884 Alta 105 [{"latitude": "39.2144", "longitude": "-120.8041"}, {"latitude": "39.23076", "longitude": "-120.77171"}, {"latitude": "39.24138", "longitude": "-120.76939"}, {"latitude": "39.24296", "longitude": "-120.77057"}, {"latitude": "39.22641", "longitude": "-120.81438"}, {"latitude": "39.21744", "longitude": "-120.83338"}, {"latitude": "39.2166", "longitude": "-120.83428"}]
720836 November 27, 2019 - 17:19:00 UTC 39.21062 -120.82175 Alta 105 []
720962 November 27, 2019 - 17:52:00 UTC 39.21287 -120.81601 Alta 105 []
722002 November 28, 2019 - 00:41:34 UTC 39.21475 -120.7861 Alta 105 []
722074 November 28, 2019 - 01:24:29 UTC 39.21475 -120.7861 Alta 105 []
722652 November 28, 2019 - 15:36:00 UTC 39.2161 -120.77465 Alta 105 []
723114 November 28, 2019 - 22:25:00 UTC 39.21317 -120.78046 Alta 105 [{"latitude": "39.21368", "longitude": "-120.77542"}, {"latitude": "39.21622", "longitude": "-120.77368"}, {"latitude": "39.21741", "longitude": "-120.7732"}, {"latitude": "39.22061", "longitude": "-120.77637"}, {"latitude": "39.22111", "longitude": "-120.7789"}]
731631 December 06, 2019 - 22:07:36 UTC 39.21351 -120.80779 Alta 105 []
732457 December 07, 2019 - 17:58:22 UTC 39.20862 -120.78927 Alta 105 []
734336 December 09, 2019 - 17:26:00 UTC 39.28718 -120.69477 Alta 105 [{"latitude": "39.28186", "longitude": "-120.68985"}, {"latitude": "39.28365", "longitude": "-120.69041"}, {"latitude": "39.28419", "longitude": "-120.69089"}, {"latitude": "39.28659", "longitude": "-120.69437"}, {"latitude": "39.28552", "longitude": "-120.69565"}]
734580 December 09, 2019 - 19:12:16 UTC 39.28715 -120.69502 Alta 105 []
1059797 September 08, 2020 - 06:27:00 UTC 39.214 -120.80977 Alta 105 [{"latitude": "39.18029", "longitude": "-120.85095"}, {"latitude": "39.18415", "longitude": "-120.83235"}, {"latitude": "39.19259", "longitude": "-120.82442"}, {"latitude": "39.21502", "longitude": "-120.80904"}, {"latitude": "39.21525", "longitude": "-120.80931"}, {"latitude": "39.2124", "longitude": "-120.82714"}, {"latitude": "39.20946", "longitude": "-120.83389"}, {"latitude": "39.20611", "longitude": "-120.84126"}, {"latitude": "39.20575", "longitude": "-120.84173"}, {"latitude": "39.20393", "longitude": "-120.84382"}, {"latitude": "39.18327", "longitude": "-120.86156"}, {"latitude": "39.18201", "longitude": "-120.86102"}, {"latitude": "39.18078", "longitude": "-120.86011"}]
1059802 September 08, 2020 - 06:27:00 UTC 39.214 -120.80984 Alta 105 [{"latitude": "39.16482", "longitude": "-120.83624"}, {"latitude": "39.16646", "longitude": "-120.83005"}, {"latitude": "39.2009", "longitude": "-120.76352"}, {"latitude": "39.2415", "longitude": "-120.76957"}, {"latitude": "39.24296", "longitude": "-120.77057"}, {"latitude": "39.22638", "longitude": "-120.81433"}, {"latitude": "39.21841", "longitude": "-120.83501"}, {"latitude": "39.21679", "longitude": "-120.8358"}]
1060494 September 08, 2020 - 08:42:00 UTC 39.29112 -120.67823 Alta 105 [{"latitude": "39.23842", "longitude": "-120.75197"}, {"latitude": "39.24066", "longitude": "-120.7358"}, {"latitude": "39.25485", "longitude": "-120.70917"}, {"latitude": "39.26807", "longitude": "-120.69532"}, {"latitude": "39.29014", "longitude": "-120.6799"}, {"latitude": "39.29103", "longitude": "-120.68052"}, {"latitude": "39.29258", "longitude": "-120.71656"}, {"latitude": "39.29088", "longitude": "-120.72392"}, {"latitude": "39.29055", "longitude": "-120.72511"}, {"latitude": "39.28975", "longitude": "-120.7259"}, {"latitude": "39.24837", "longitude": "-120.7483"}]
1060496 September 08, 2020 - 08:42:00 UTC 39.25197 -120.75005 Alta 105 [{"latitude": "39.24974", "longitude": "-120.75217"}, {"latitude": "39.25067", "longitude": "-120.75086"}, {"latitude": "39.25808", "longitude": "-120.76614"}, {"latitude": "39.25487", "longitude": "-120.77479"}, {"latitude": "39.25387", "longitude": "-120.77491"}, {"latitude": "39.24977", "longitude": "-120.75254"}]
1064003 September 11, 2020 - 04:35:35 UTC 39.24809 -120.73861 Alta 105 []
1064101 September 11, 2020 - 15:10:27 UTC 39.2099 -120.80133 Alta 105 [{"latitude": "39.20395", "longitude": "-120.80495"}, {"latitude": "39.20557", "longitude": "-120.79233"}, {"latitude": "39.21147", "longitude": "-120.7787"}, {"latitude": "39.214", "longitude": "-120.77549"}, {"latitude": "39.21633", "longitude": "-120.77354"}, {"latitude": "39.21737", "longitude": "-120.773"}, {"latitude": "39.22047", "longitude": "-120.77397"}, {"latitude": "39.22074", "longitude": "-120.77594"}, {"latitude": "39.20788", "longitude": "-120.80169"}]
1086116 September 22, 2020 - 00:38:45 UTC 39.20629 -120.80476 Alta 105 []
1095552 September 28, 2020 - 01:19:00 UTC 39.214 -120.80984 Alta 105 [{"latitude": "39.16482", "longitude": "-120.83624"}, {"latitude": "39.16646", "longitude": "-120.83005"}, {"latitude": "39.2009", "longitude": "-120.76352"}, {"latitude": "39.2415", "longitude": "-120.76957"}, {"latitude": "39.24296", "longitude": "-120.77057"}, {"latitude": "39.22638", "longitude": "-120.81433"}, {"latitude": "39.21841", "longitude": "-120.83501"}, {"latitude": "39.21679", "longitude": "-120.8358"}]
1095581 September 28, 2020 - 01:18:00 UTC 39.214 -120.80977 Alta 105 [{"latitude": "39.14974", "longitude": "-120.8551"}, {"latitude": "39.19259", "longitude": "-120.82442"}, {"latitude": "39.21502", "longitude": "-120.80904"}, {"latitude": "39.21525", "longitude": "-120.80931"}, {"latitude": "39.2124", "longitude": "-120.82714"}, {"latitude": "39.20946", "longitude": "-120.83389"}, {"latitude": "39.20611", "longitude": "-120.84126"}, {"latitude": "39.20575", "longitude": "-120.84173"}, {"latitude": "39.17281", "longitude": "-120.88056"}, {"latitude": "39.1646", "longitude": "-120.87742"}, {"latitude": "39.1634", "longitude": "-120.87679"}]
1095639 September 28, 2020 - 01:31:12 UTC 39.30945 -120.67293 Alta 105 []
1095750 September 28, 2020 - 01:50:00 UTC 39.2912 -120.67815 Alta 105 [{"latitude": "39.23842", "longitude": "-120.75197"}, {"latitude": "39.24066", "longitude": "-120.7358"}, {"latitude": "39.25485", "longitude": "-120.70917"}, {"latitude": "39.26658", "longitude": "-120.69688"}, {"latitude": "39.26807", "longitude": "-120.69532"}, {"latitude": "39.29014", "longitude": "-120.6799"}, {"latitude": "39.29103", "longitude": "-120.68052"}, {"latitude": "39.29258", "longitude": "-120.71656"}, {"latitude": "39.29088", "longitude": "-120.72392"}, {"latitude": "39.29055", "longitude": "-120.72511"}, {"latitude": "39.28975", "longitude": "-120.7259"}, {"latitude": "39.24837", "longitude": "-120.7483"}]
1095755 September 28, 2020 - 01:50:00 UTC 39.25197 -120.75005 Alta 105 [{"latitude": "39.24974", "longitude": "-120.75217"}, {"latitude": "39.25067", "longitude": "-120.75086"}, {"latitude": "39.25808", "longitude": "-120.76614"}, {"latitude": "39.25487", "longitude": "-120.77479"}, {"latitude": "39.25387", "longitude": "-120.77491"}, {"latitude": "39.24977", "longitude": "-120.75254"}]

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