outages

1,832 rows where regionName = 35 sorted by longitude

View and edit SQL

id outageStartTime latitude longitude ▼ regionName outageDevices
1066793 September 12, 2020 - 22:20:15 UTC 36.78608 -119.61922 Fresno 35 []
698186 November 02, 2019 - 17:04:45 UTC 36.76742 -119.62345 Fresno 35 []
1074176 September 16, 2020 - 15:11:00 UTC 36.73967 -119.63231 Fresno 35 []
679402 October 24, 2019 - 15:27:34 UTC 36.79342 -119.63364 Fresno 35 []
667674 October 18, 2019 - 15:17:00 UTC 36.78631 -119.63569 Fresno 35 []
1071135 September 15, 2020 - 15:27:00 UTC 36.76645 -119.63679 Fresno 35 []
741193 December 16, 2019 - 16:22:38 UTC 36.78474 -119.63692 Fresno 35 []
655625 October 13, 2019 - 21:34:14 UTC 36.77609 -119.63704 Fresno 35 []
739542 December 14, 2019 - 18:27:10 UTC 36.77431 -119.64392 Fresno 35 []
1075217 September 16, 2020 - 18:41:12 UTC 36.76601 -119.64404 Fresno 35 []
1076073 September 16, 2020 - 21:25:57 UTC 36.76601 -119.64404 Fresno 35 []
727318 December 02, 2019 - 17:43:09 UTC 36.75931 -119.64478 Fresno 35 []
714078 November 25, 2019 - 14:57:44 UTC 36.77879 -119.64594 Fresno 35 [{"latitude": "36.77218", "longitude": "-119.64266"}, {"latitude": "36.77737", "longitude": "-119.64394"}, {"latitude": "36.77828", "longitude": "-119.64594"}, {"latitude": "36.77365", "longitude": "-119.64908"}, {"latitude": "36.77248", "longitude": "-119.64589"}, {"latitude": "36.7722", "longitude": "-119.64462"}]
735355 December 10, 2019 - 17:01:03 UTC 36.74394 -119.64744 Fresno 35 []
676995 October 22, 2019 - 20:42:30 UTC 36.76135 -119.64792 Fresno 35 []
711775 November 20, 2019 - 23:35:15 UTC 36.7839 -119.65442 Fresno 35 []
743353 December 16, 2019 - 19:52:08 UTC 36.7839 -119.65442 Fresno 35 []
647154 October 08, 2019 - 15:35:30 UTC 36.66908 -119.65457 Fresno 35 []
728907 December 03, 2019 - 21:47:15 UTC 36.74152 -119.65494 Fresno 35 []
731203 December 06, 2019 - 16:10:00 UTC 36.78194 -119.65502 Fresno 35 [{"latitude": "36.78203", "longitude": "-119.65566"}, {"latitude": "36.78275", "longitude": "-119.65607"}, {"latitude": "36.78275", "longitude": "-119.65767"}, {"latitude": "36.78244", "longitude": "-119.66155"}]
731213 December 06, 2019 - 16:12:00 UTC 36.78147 -119.65504 Fresno 35 [{"latitude": "36.78143", "longitude": "-119.65574"}, {"latitude": "36.78216", "longitude": "-119.65674"}, {"latitude": "36.78216", "longitude": "-119.65809"}, {"latitude": "36.78145", "longitude": "-119.66154"}, {"latitude": "36.78143", "longitude": "-119.65758"}]
638956 October 03, 2019 - 13:27:36 UTC 36.76762 -119.65902 Fresno 35 []
702544 November 08, 2019 - 16:39:32 UTC 36.76762 -119.65902 Fresno 35 []
739902 December 15, 2019 - 03:13:42 UTC 36.76204 -119.66029 Fresno 35 []
677332 October 23, 2019 - 14:36:09 UTC 36.78442 -119.66081 Fresno 35 []
788447 February 11, 2020 - 17:06:00 UTC 36.75392 -119.66396 Fresno 35 [{"latitude": "36.75391", "longitude": "-119.67071"}, {"latitude": "36.75392", "longitude": "-119.66413"}, {"latitude": "36.75445", "longitude": "-119.6645"}, {"latitude": "36.75391", "longitude": "-119.67166"}]
676807 October 22, 2019 - 16:58:44 UTC 36.76121 -119.664 Fresno 35 [{"latitude": "36.7592", "longitude": "-119.66645"}, {"latitude": "36.76097", "longitude": "-119.66145"}, {"latitude": "36.76321", "longitude": "-119.66959"}, {"latitude": "36.76118", "longitude": "-119.67184"}, {"latitude": "36.75978", "longitude": "-119.67034"}]
699002 November 04, 2019 - 16:04:37 UTC 36.75041 -119.66404 Fresno 35 []
739750 December 14, 2019 - 22:03:35 UTC 36.76343 -119.6649 Fresno 35 []
715586 November 26, 2019 - 21:45:30 UTC 36.73242 -119.66721 Fresno 35 []
655671 October 14, 2019 - 00:53:27 UTC 36.7263 -119.66768 Fresno 35 []
714499 November 25, 2019 - 21:02:10 UTC 36.73687 -119.66863 Fresno 35 [{"latitude": "36.73712", "longitude": "-119.66863"}, {"latitude": "36.73873", "longitude": "-119.6683"}, {"latitude": "36.73873", "longitude": "-119.66862"}]
738615 December 13, 2019 - 21:12:08 UTC 36.76321 -119.66959 Fresno 35 []
731771 December 06, 2019 - 23:33:00 UTC 36.7292 -119.67261 Fresno 35 [{"latitude": "36.72257", "longitude": "-119.67427"}, {"latitude": "36.72481", "longitude": "-119.66893"}, {"latitude": "36.72761", "longitude": "-119.67439"}, {"latitude": "36.72759", "longitude": "-119.67579"}, {"latitude": "36.72683", "longitude": "-119.67746"}, {"latitude": "36.72534", "longitude": "-119.67746"}, {"latitude": "36.72262", "longitude": "-119.67662"}, {"latitude": "36.72257", "longitude": "-119.67551"}]
738913 December 14, 2019 - 15:21:19 UTC 36.79023 -119.67289 Fresno 35 [{"latitude": "36.78938", "longitude": "-119.67383"}, {"latitude": "36.79006", "longitude": "-119.67382"}, {"latitude": "36.79007", "longitude": "-119.6769"}, {"latitude": "36.78939", "longitude": "-119.67674"}, {"latitude": "36.78938", "longitude": "-119.67487"}]
739419 December 14, 2019 - 16:28:00 UTC 36.79023 -119.67289 Fresno 35 []
646188 October 07, 2019 - 19:56:13 UTC 36.78935 -119.6729 Fresno 35 []
731047 December 06, 2019 - 14:11:00 UTC 36.72137 -119.67296 Fresno 35 [{"latitude": "36.72257", "longitude": "-119.67427"}, {"latitude": "36.72481", "longitude": "-119.66893"}, {"latitude": "36.72761", "longitude": "-119.67439"}, {"latitude": "36.72759", "longitude": "-119.67579"}, {"latitude": "36.72683", "longitude": "-119.67746"}, {"latitude": "36.72534", "longitude": "-119.67746"}, {"latitude": "36.72262", "longitude": "-119.67662"}, {"latitude": "36.72257", "longitude": "-119.67551"}]
778960 February 06, 2020 - 16:01:00 UTC 36.77602 -119.67391 Fresno 35 [{"latitude": "36.77214", "longitude": "-119.67188"}, {"latitude": "36.77214", "longitude": "-119.67148"}, {"latitude": "36.77493", "longitude": "-119.6731"}, {"latitude": "36.77215", "longitude": "-119.67331"}, {"latitude": "36.77214", "longitude": "-119.67248"}]
744624 December 17, 2019 - 20:45:46 UTC 36.74344 -119.67627 Fresno 35 []
727178 December 02, 2019 - 16:24:50 UTC 36.77636 -119.67699 Fresno 35 []
738426 December 13, 2019 - 18:01:49 UTC 36.77389 -119.6776 Fresno 35 []
738298 December 13, 2019 - 16:41:12 UTC 36.77165 -119.67769 Fresno 35 []
744659 December 17, 2019 - 21:10:54 UTC 36.75046 -119.67933 Fresno 35 []
663917 October 17, 2019 - 15:27:13 UTC 36.66754 -119.68148 Fresno 35 []
708930 November 18, 2019 - 14:49:58 UTC 36.68304 -119.68179 Fresno 35 []
723053 November 28, 2019 - 21:22:57 UTC 36.70123 -119.68189 Fresno 35 []
723067 November 28, 2019 - 21:22:57 UTC 36.67824 -119.68218 Fresno 35 [{"latitude": "36.63586", "longitude": "-119.68216"}, {"latitude": "36.63638", "longitude": "-119.67848"}, {"latitude": "36.69031", "longitude": "-119.6508"}, {"latitude": "36.69615", "longitude": "-119.65239"}, {"latitude": "36.70237", "longitude": "-119.65765"}, {"latitude": "36.7072", "longitude": "-119.66391"}, {"latitude": "36.70998", "longitude": "-119.67271"}, {"latitude": "36.70462", "longitude": "-119.68192"}, {"latitude": "36.69648", "longitude": "-119.69543"}, {"latitude": "36.69296", "longitude": "-119.69748"}, {"latitude": "36.64665", "longitude": "-119.69688"}, {"latitude": "36.64341", "longitude": "-119.69545"}, {"latitude": "36.64177", "longitude": "-119.69368"}]
1092659 September 25, 2020 - 18:25:57 UTC 36.78791 -119.68275 Fresno 35 []
705532 November 13, 2019 - 00:23:43 UTC 36.74934 -119.68402 Fresno 35 []
704541 November 11, 2019 - 23:25:00 UTC 36.77389 -119.68582 Fresno 35 []
1068303 September 14, 2020 - 15:40:22 UTC 36.77225 -119.68736 Fresno 35 []
694156 October 29, 2019 - 21:12:45 UTC 36.78125 -119.68758 Fresno 35 []
638253 October 02, 2019 - 21:47:53 UTC 36.77995 -119.68884 Fresno 35 []
676144 October 21, 2019 - 18:39:42 UTC 36.77995 -119.68884 Fresno 35 []
743772 December 16, 2019 - 23:41:16 UTC 36.77491 -119.69089 Fresno 35 []
646333 October 07, 2019 - 20:39:17 UTC 36.73449 -119.69222 Fresno 35 []
735289 December 10, 2019 - 16:39:11 UTC 36.68339 -119.69257 Fresno 35 []
1080873 September 18, 2020 - 18:57:01 UTC 36.68339 -119.69257 Fresno 35 []
738620 December 13, 2019 - 21:27:43 UTC 36.78132 -119.69272 Fresno 35 []
643883 October 05, 2019 - 05:27:00 UTC 36.7362 -119.69294 Fresno 35 [{"latitude": "36.73685", "longitude": "-119.69262"}, {"latitude": "36.73853", "longitude": "-119.69238"}, {"latitude": "36.73953", "longitude": "-119.69287"}, {"latitude": "36.73931", "longitude": "-119.69356"}, {"latitude": "36.7376", "longitude": "-119.69329"}]
1076686 September 17, 2020 - 00:50:48 UTC 36.73991 -119.69316 Fresno 35 []
1074480 September 16, 2020 - 16:03:00 UTC 36.74096 -119.69331 Fresno 35 []
1074995 September 16, 2020 - 17:41:00 UTC 36.74171 -119.69351 Fresno 35 []
641116 October 03, 2019 - 21:20:49 UTC 36.77522 -119.69416 Fresno 35 []
732284 December 07, 2019 - 15:36:35 UTC 36.77387 -119.6945 Fresno 35 []
719805 November 27, 2019 - 11:29:00 UTC 36.67103 -119.69467 Fresno 35 []
721247 November 27, 2019 - 18:54:00 UTC 36.67103 -119.69467 Fresno 35 []
702024 November 07, 2019 - 21:26:18 UTC 36.75725 -119.69563 Fresno 35 []
1088493 September 22, 2020 - 23:03:39 UTC 36.73857 -119.69729 Fresno 35 []
734766 December 09, 2019 - 21:49:20 UTC 36.73438 -119.69732 Fresno 35 []
654118 October 11, 2019 - 14:49:02 UTC 36.74049 -119.69772 Fresno 35 []
659849 October 15, 2019 - 21:49:00 UTC 36.74049 -119.69772 Fresno 35 []
1070478 September 14, 2020 - 23:42:24 UTC 36.74049 -119.69772 Fresno 35 []
1063118 September 10, 2020 - 18:11:28 UTC 36.73048 -119.69854 Fresno 35 []
709549 November 18, 2019 - 23:40:49 UTC 36.74928 -119.69906 Fresno 35 []
733996 December 09, 2019 - 01:31:32 UTC 36.75754 -119.69913 Fresno 35 []
739372 December 14, 2019 - 16:53:10 UTC 36.73896 -119.69992 Fresno 35 []
744670 December 17, 2019 - 21:21:00 UTC 36.67711 -119.69994 Fresno 35 [{"latitude": "36.63586", "longitude": "-119.68216"}, {"latitude": "36.63638", "longitude": "-119.67848"}, {"latitude": "36.69031", "longitude": "-119.6508"}, {"latitude": "36.69615", "longitude": "-119.65239"}, {"latitude": "36.70237", "longitude": "-119.65765"}, {"latitude": "36.7072", "longitude": "-119.66391"}, {"latitude": "36.70998", "longitude": "-119.67271"}, {"latitude": "36.70462", "longitude": "-119.68192"}, {"latitude": "36.69648", "longitude": "-119.69543"}, {"latitude": "36.66371", "longitude": "-119.71609"}, {"latitude": "36.64341", "longitude": "-119.69545"}, {"latitude": "36.64177", "longitude": "-119.69368"}]
733798 December 08, 2019 - 20:40:37 UTC 36.75687 -119.70056 Fresno 35 []
667396 October 18, 2019 - 14:11:50 UTC 36.7428 -119.70143 Fresno 35 []
704370 November 11, 2019 - 18:51:42 UTC 36.7428 -119.70143 Fresno 35 []
733894 December 08, 2019 - 23:12:50 UTC 36.78344 -119.70153 Fresno 35 []
698781 November 04, 2019 - 00:45:00 UTC 36.74086 -119.70186 Fresno 35 []
687296 October 27, 2019 - 15:54:16 UTC 36.71758 -119.70193 Fresno 35 []
733859 December 08, 2019 - 21:56:45 UTC 36.74336 -119.70285 Fresno 35 []
734012 December 09, 2019 - 02:14:18 UTC 36.74336 -119.70285 Fresno 35 []
778323 February 05, 2020 - 17:00:01 UTC 36.74818 -119.7047 Fresno 35 [{"latitude": "36.74765", "longitude": "-119.70332"}, {"latitude": "36.74765", "longitude": "-119.70174"}, {"latitude": "36.74819", "longitude": "-119.70125"}, {"latitude": "36.74907", "longitude": "-119.70118"}, {"latitude": "36.74998", "longitude": "-119.70156"}, {"latitude": "36.74998", "longitude": "-119.70234"}, {"latitude": "36.74998", "longitude": "-119.70361"}, {"latitude": "36.74818", "longitude": "-119.70426"}, {"latitude": "36.74765", "longitude": "-119.70414"}]
703460 November 09, 2019 - 23:07:50 UTC 36.74308 -119.70652 Fresno 35 []
703734 November 10, 2019 - 02:39:58 UTC 36.74308 -119.70652 Fresno 35 []
729237 December 04, 2019 - 12:04:27 UTC 36.75209 -119.70803 Fresno 35 []
719423 November 27, 2019 - 07:32:06 UTC 36.64876 -119.70808 Fresno 35 []
642256 October 04, 2019 - 14:35:06 UTC 36.67211 -119.7089 Fresno 35 []
642313 October 04, 2019 - 15:23:04 UTC 36.67102 -119.70976 Fresno 35 []
733638 December 08, 2019 - 17:20:06 UTC 36.75979 -119.70995 Fresno 35 []
1093681 September 26, 2020 - 06:23:38 UTC 36.70774 -119.71093 Fresno 35 []
738359 December 13, 2019 - 17:14:18 UTC 36.65316 -119.71146 Fresno 35 []
639833 October 03, 2019 - 18:19:11 UTC 36.76109 -119.71469 Fresno 35 []
719424 November 27, 2019 - 07:32:06 UTC 36.64953 -119.71479 Fresno 35 []
778814 February 06, 2020 - 01:27:06 UTC 36.73682 -119.71544 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
)
Powered by Datasette · Query took 343.158ms · About: About this site