outages

1,620 rows where regionName = 35 sorted by latitude

View and edit SQL

id outageStartTime latitude ▼ longitude regionName outageDevices
680736 October 26, 2019 - 11:11:20 UTC 36.52243 -119.75384 Fresno 35 []
680738 October 26, 2019 - 11:11:25 UTC 36.52387 -119.72809 Fresno 35 []
680740 October 26, 2019 - 11:11:29 UTC 36.52761 -119.75787 Fresno 35 []
714578 November 25, 2019 - 21:40:13 UTC 36.53133 -119.73727 Fresno 35 []
677401 October 23, 2019 - 15:52:07 UTC 36.5504 -119.74485 Fresno 35 []
660707 October 16, 2019 - 16:55:40 UTC 36.56225 -119.80432 Fresno 35 []
647193 October 08, 2019 - 15:43:13 UTC 36.56251 -119.76079 Fresno 35 []
668513 October 18, 2019 - 16:45:39 UTC 36.56626 -119.77295 Fresno 35 []
702628 November 08, 2019 - 17:18:14 UTC 36.57628 -119.72248 Fresno 35 []
778648 February 05, 2020 - 21:50:58 UTC 36.57636 -119.78378 Fresno 35 []
706105 November 13, 2019 - 18:48:00 UTC 36.57645 -119.74775 Fresno 35 []
659197 October 15, 2019 - 17:47:52 UTC 36.57732 -119.75502 Fresno 35 []
659793 October 15, 2019 - 20:36:24 UTC 36.57732 -119.75502 Fresno 35 []
789555 February 12, 2020 - 19:44:20 UTC 36.58282 -119.92187 Fresno 35 []
779132 February 06, 2020 - 17:08:02 UTC 36.58414 -119.80456 Fresno 35 []
779265 February 06, 2020 - 18:42:51 UTC 36.58514 -119.78647 Fresno 35 []
669776 October 18, 2019 - 19:55:05 UTC 36.58938 -119.7545 Fresno 35 []
705430 November 12, 2019 - 22:06:32 UTC 36.59073 -119.74659 Fresno 35 []
789398 February 12, 2020 - 17:21:00 UTC 36.59314 -119.76422 Fresno 35 []
789384 February 12, 2020 - 17:09:44 UTC 36.59323 -119.77286 Fresno 35 [{"latitude": "36.59321", "longitude": "-119.77081"}, {"latitude": "36.59323", "longitude": "-119.77309"}, {"latitude": "36.59323", "longitude": "-119.7739"}]
788520 February 11, 2020 - 17:44:18 UTC 36.59524 -119.81532 Fresno 35 []
789432 February 12, 2020 - 17:45:49 UTC 36.59524 -119.81532 Fresno 35 []
779406 February 06, 2020 - 20:21:10 UTC 36.59612 -119.78547 Fresno 35 []
789565 February 12, 2020 - 19:45:46 UTC 36.59632 -119.77273 Fresno 35 []
789559 February 12, 2020 - 19:46:11 UTC 36.59712 -119.931 Fresno 35 []
658657 October 14, 2019 - 23:56:00 UTC 36.598 -119.73016 Fresno 35 []
780014 February 07, 2020 - 17:43:45 UTC 36.59986 -119.92016 Fresno 35 []
790038 February 13, 2020 - 08:17:13 UTC 36.60092 -119.77501 Fresno 35 []
710541 November 20, 2019 - 06:55:34 UTC 36.6037 -119.737 Fresno 35 []
733800 December 08, 2019 - 20:40:37 UTC 36.6037 -119.737 Fresno 35 []
639005 October 03, 2019 - 14:55:49 UTC 36.60486 -119.87904 Fresno 35 [{"latitude": "36.59742", "longitude": "-119.85226"}, {"latitude": "36.59743", "longitude": "-119.85122"}, {"latitude": "36.6057", "longitude": "-119.82669"}, {"latitude": "36.64271", "longitude": "-119.80655"}, {"latitude": "36.64528", "longitude": "-119.80874"}, {"latitude": "36.65063", "longitude": "-119.82854"}, {"latitude": "36.65099", "longitude": "-119.83546"}, {"latitude": "36.64856", "longitude": "-119.83977"}, {"latitude": "36.63333", "longitude": "-119.86249"}, {"latitude": "36.61491", "longitude": "-119.87417"}, {"latitude": "36.60488", "longitude": "-119.87741"}, {"latitude": "36.6035", "longitude": "-119.87325"}]
650824 October 09, 2019 - 16:52:00 UTC 36.60585 -119.77346 Fresno 35 [{"latitude": "36.52174", "longitude": "-119.73231"}, {"latitude": "36.52241", "longitude": "-119.71902"}, {"latitude": "36.54359", "longitude": "-119.69644"}, {"latitude": "36.56201", "longitude": "-119.68525"}, {"latitude": "36.65611", "longitude": "-119.75396"}, {"latitude": "36.66134", "longitude": "-119.76176"}, {"latitude": "36.66137", "longitude": "-119.7631"}, {"latitude": "36.66132", "longitude": "-119.76495"}, {"latitude": "36.65714", "longitude": "-119.79433"}, {"latitude": "36.65598", "longitude": "-119.79905"}, {"latitude": "36.63145", "longitude": "-119.81782"}, {"latitude": "36.62454", "longitude": "-119.82238"}, {"latitude": "36.60351", "longitude": "-119.8239"}, {"latitude": "36.56856", "longitude": "-119.82226"}, {"latitude": "36.53273", "longitude": "-119.77103"}, {"latitude": "36.52833", "longitude": "-119.76415"}, {"latitude": "36.52196", "longitude": "-119.73685"}]
708768 November 17, 2019 - 23:46:00 UTC 36.60827 -119.91714 Fresno 35 []
707294 November 15, 2019 - 15:39:20 UTC 36.6103 -119.83049 Fresno 35 []
703185 November 09, 2019 - 15:31:06 UTC 36.61171 -119.7549 Fresno 35 [{"latitude": "36.61171", "longitude": "-119.75071"}, {"latitude": "36.61182", "longitude": "-119.75055"}, {"latitude": "36.63501", "longitude": "-119.74142"}, {"latitude": "36.64883", "longitude": "-119.7375"}, {"latitude": "36.65617", "longitude": "-119.74582"}, {"latitude": "36.65359", "longitude": "-119.75693"}, {"latitude": "36.64887", "longitude": "-119.76103"}, {"latitude": "36.63434", "longitude": "-119.75949"}, {"latitude": "36.61897", "longitude": "-119.75715"}, {"latitude": "36.61348", "longitude": "-119.7559"}]
693096 October 29, 2019 - 13:50:10 UTC 36.61172 -119.95321 Fresno 35 [{"latitude": "36.61209", "longitude": "-119.9532"}, {"latitude": "36.62121", "longitude": "-119.9531"}, {"latitude": "36.62139", "longitude": "-119.9531"}, {"latitude": "36.61891", "longitude": "-119.96353"}]
646014 October 07, 2019 - 17:14:27 UTC 36.61232 -119.85532 Fresno 35 []
647359 October 08, 2019 - 17:05:54 UTC 36.61232 -119.85532 Fresno 35 []
634753 October 01, 2019 - 20:26:21 UTC 36.61242 -119.89452 Fresno 35 []
664174 October 17, 2019 - 16:36:25 UTC 36.61348 -119.7559 Fresno 35 []
694683 October 30, 2019 - 08:55:22 UTC 36.6157 -120.03419 Fresno 35 []
708772 November 18, 2019 - 00:04:13 UTC 36.61579 -119.91681 Fresno 35 []
664046 October 17, 2019 - 16:00:20 UTC 36.61643 -119.80888 Fresno 35 []
778944 February 06, 2020 - 15:48:32 UTC 36.61801 -119.77716 Fresno 35 []
719727 November 27, 2019 - 10:38:23 UTC 36.61836 -120.02496 Fresno 35 [{"latitude": "36.61843", "longitude": "-120.02077"}, {"latitude": "36.61846", "longitude": "-120.01176"}, {"latitude": "36.61844", "longitude": "-120.02465"}]
778933 February 06, 2020 - 15:36:59 UTC 36.61989 -119.76316 Fresno 35 []
654613 October 11, 2019 - 22:00:38 UTC 36.62646 -119.76384 Fresno 35 []
779226 February 06, 2020 - 18:09:16 UTC 36.6315 -119.76546 Fresno 35 []
733426 December 08, 2019 - 04:27:32 UTC 36.6332 -119.89414 Fresno 35 []
779264 February 06, 2020 - 18:42:16 UTC 36.63434 -119.75949 Fresno 35 []
712570 November 22, 2019 - 02:32:40 UTC 36.63518 -119.72477 Fresno 35 []
789037 February 12, 2020 - 00:24:39 UTC 36.63726 -119.9665 Fresno 35 []
711202 November 20, 2019 - 17:00:00 UTC 36.63811 -119.74574 Fresno 35 []
705643 November 13, 2019 - 05:22:47 UTC 36.6396 -119.82623 Fresno 35 []
651089 October 09, 2019 - 20:49:04 UTC 36.64046 -119.7638 Fresno 35 []
779434 February 06, 2020 - 20:46:10 UTC 36.64162 -119.75922 Fresno 35 []
703366 November 09, 2019 - 19:08:07 UTC 36.64439 -119.74323 Fresno 35 []
719568 November 27, 2019 - 08:39:53 UTC 36.64781 -119.71807 Fresno 35 []
719423 November 27, 2019 - 07:32:06 UTC 36.64876 -119.70808 Fresno 35 []
787693 February 10, 2020 - 22:09:00 UTC 36.64889 -119.73008 Fresno 35 []
719425 November 27, 2019 - 07:32:06 UTC 36.64906 -119.71581 Fresno 35 []
731474 December 06, 2019 - 19:04:54 UTC 36.6494 -119.72909 Fresno 35 []
719424 November 27, 2019 - 07:32:06 UTC 36.64953 -119.71479 Fresno 35 []
640533 October 03, 2019 - 19:54:00 UTC 36.65099 -119.83546 Fresno 35 []
738359 December 13, 2019 - 17:14:18 UTC 36.65316 -119.71146 Fresno 35 []
734301 December 09, 2019 - 17:04:35 UTC 36.65372 -119.82648 Fresno 35 []
737354 December 12, 2019 - 17:32:05 UTC 36.65496 -119.83617 Fresno 35 []
789463 February 12, 2020 - 18:10:34 UTC 36.65512 -119.9433 Fresno 35 []
705743 November 13, 2019 - 14:52:20 UTC 36.65559 -119.88725 Fresno 35 []
779413 February 06, 2020 - 20:29:00 UTC 36.65617 -119.74582 Fresno 35 []
638805 October 03, 2019 - 00:17:29 UTC 36.65853 -119.82656 Fresno 35 []
787373 February 10, 2020 - 19:03:57 UTC 36.66208 -119.99333 Fresno 35 []
788548 February 11, 2020 - 17:57:09 UTC 36.66208 -119.99333 Fresno 35 []
790512 February 13, 2020 - 21:31:17 UTC 36.66244 -119.91642 Fresno 35 [{"latitude": "36.65519", "longitude": "-119.91654"}, {"latitude": "36.65545", "longitude": "-119.91653"}, {"latitude": "36.65928", "longitude": "-119.91647"}]
645896 October 07, 2019 - 16:01:48 UTC 36.66301 -119.96952 Fresno 35 []
691788 October 28, 2019 - 19:14:26 UTC 36.66301 -119.96952 Fresno 35 []
680772 October 26, 2019 - 15:36:16 UTC 36.66303 -119.81288 Fresno 35 []
707397 November 15, 2019 - 17:02:24 UTC 36.66306 -119.74709 Fresno 35 []
677386 October 23, 2019 - 15:39:43 UTC 36.66342 -119.81323 Fresno 35 []
704764 November 12, 2019 - 16:40:00 UTC 36.66345 -119.7456 Fresno 35 [{"latitude": "36.66345", "longitude": "-119.74782"}, {"latitude": "36.66346", "longitude": "-119.74612"}, {"latitude": "36.66346", "longitude": "-119.74702"}]
708425 November 16, 2019 - 17:24:00 UTC 36.66394 -119.7548 Fresno 35 [{"latitude": "36.6578", "longitude": "-119.75485"}, {"latitude": "36.65903", "longitude": "-119.75073"}, {"latitude": "36.66303", "longitude": "-119.75274"}, {"latitude": "36.66302", "longitude": "-119.75388"}, {"latitude": "36.66218", "longitude": "-119.75758"}, {"latitude": "36.66105", "longitude": "-119.7576"}]
663917 October 17, 2019 - 15:27:13 UTC 36.66754 -119.68148 Fresno 35 []
647154 October 08, 2019 - 15:35:30 UTC 36.66908 -119.65457 Fresno 35 []
738295 December 13, 2019 - 16:44:00 UTC 36.6706 -119.72927 Fresno 35 []
654267 October 11, 2019 - 16:41:47 UTC 36.6708 -119.73458 Fresno 35 []
642313 October 04, 2019 - 15:23:04 UTC 36.67102 -119.70976 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 []
709007 November 18, 2019 - 16:09:52 UTC 36.67161 -119.73805 Fresno 35 []
642256 October 04, 2019 - 14:35:06 UTC 36.67211 -119.7089 Fresno 35 []
640117 October 03, 2019 - 19:00:45 UTC 36.67364 -119.92606 Fresno 35 []
738294 December 13, 2019 - 16:42:53 UTC 36.67498 -119.7321 Fresno 35 []
738676 December 13, 2019 - 23:11:56 UTC 36.67498 -119.7321 Fresno 35 []
739588 December 14, 2019 - 19:24:00 UTC 36.6762 -119.77352 Fresno 35 []
730036 December 05, 2019 - 01:03:43 UTC 36.67703 -119.74216 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"}]
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"}]
789036 February 12, 2020 - 00:23:45 UTC 36.67924 -119.91719 Fresno 35 []
712513 November 22, 2019 - 00:01:39 UTC 36.6801 -119.82676 Fresno 35 []
787632 February 10, 2020 - 21:32:09 UTC 36.6809 -119.73821 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 390.978ms · About: About this site