3,012 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 []
1086820 September 22, 2020 - 15:55:00 UTC 36.54381 -119.73715 Fresno 35 []
1086816 September 22, 2020 - 15:55:00 UTC 36.54462 -119.73723 Fresno 35 [{"latitude": "36.54462", "longitude": "-119.73746"}, {"latitude": "36.54564", "longitude": "-119.74074"}, {"latitude": "36.54508", "longitude": "-119.74069"}]
1088674 September 23, 2020 - 03:33:26 UTC 36.54462 -119.73723 Fresno 35 [{"latitude": "36.54462", "longitude": "-119.73746"}, {"latitude": "36.54564", "longitude": "-119.74074"}, {"latitude": "36.54508", "longitude": "-119.74069"}]
1061826 September 09, 2020 - 15:04:57 UTC 36.5472 -119.76765 Fresno 35 []
1064501 September 11, 2020 - 17:18:07 UTC 36.54728 -119.74161 Fresno 35 []
677401 October 23, 2019 - 15:52:07 UTC 36.5504 -119.74485 Fresno 35 []
1141486 November 11, 2020 - 01:05:13 UTC 36.56001 -119.98943 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 []
1062292 September 09, 2020 - 22:36:57 UTC 36.5699 -119.76595 Fresno 35 []
702628 November 08, 2019 - 17:18:14 UTC 36.57628 -119.72248 Fresno 35 []
1106167 October 02, 2020 - 15:26:00 UTC 36.57632 -119.74887 Fresno 35 []
778648 February 05, 2020 - 21:50:58 UTC 36.57636 -119.78378 Fresno 35 []
1132128 October 30, 2020 - 16:24:33 UTC 36.57636 -119.75396 Fresno 35 []
706105 November 13, 2019 - 18:48:00 UTC 36.57645 -119.74775 Fresno 35 []
1152770 November 22, 2020 - 19:56:55 UTC 36.57645 -119.81784 Fresno 35 []
1111351 October 05, 2020 - 17:19:13 UTC 36.57646 -119.73906 Fresno 35 []
1122108 October 21, 2020 - 15:45:00 UTC 36.57647 -119.73742 Fresno 35 [{"latitude": "36.57321", "longitude": "-119.74894"}, {"latitude": "36.57646", "longitude": "-119.73906"}, {"latitude": "36.57849", "longitude": "-119.74271"}, {"latitude": "36.57867", "longitude": "-119.74873"}, {"latitude": "36.57641", "longitude": "-119.74939"}]
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 []
1138442 November 07, 2020 - 16:53:40 UTC 36.57847 -119.82692 Fresno 35 []
1113953 October 09, 2020 - 14:26:30 UTC 36.57885 -119.76381 Fresno 35 []
1114482 October 09, 2020 - 20:06:00 UTC 36.57885 -119.76381 Fresno 35 []
1138441 November 07, 2020 - 16:53:45 UTC 36.58184 -119.8276 Fresno 35 []
789555 February 12, 2020 - 19:44:20 UTC 36.58282 -119.92187 Fresno 35 []
1093813 September 26, 2020 - 16:51:45 UTC 36.583 -119.773 Fresno 35 []
1119282 October 16, 2020 - 17:34:22 UTC 36.58302 -119.73934 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 []
1143469 November 13, 2020 - 18:03:41 UTC 36.58541 -119.82468 Fresno 35 []
1134581 November 02, 2020 - 20:48:32 UTC 36.58594 -119.98957 Fresno 35 []
1160629 December 03, 2020 - 19:40:27 UTC 36.58666 -119.73707 Fresno 35 []
669776 October 18, 2019 - 19:55:05 UTC 36.58938 -119.7545 Fresno 35 []
1138813 November 07, 2020 - 22:48:00 UTC 36.59037 -119.87951 Fresno 35 [{"latitude": "36.56329", "longitude": "-119.83608"}, {"latitude": "36.5636", "longitude": "-119.83497"}, {"latitude": "36.59065", "longitude": "-119.79213"}, {"latitude": "36.60332", "longitude": "-119.82599"}, {"latitude": "36.60352", "longitude": "-119.84489"}, {"latitude": "36.60136", "longitude": "-119.86289"}, {"latitude": "36.58941", "longitude": "-119.87836"}, {"latitude": "36.58934", "longitude": "-119.8784"}, {"latitude": "36.58502", "longitude": "-119.87334"}]
705430 November 12, 2019 - 22:06:32 UTC 36.59073 -119.74659 Fresno 35 []
1116903 October 14, 2020 - 02:06:00 UTC 36.59251 -119.78197 Fresno 35 [{"latitude": "36.59498", "longitude": "-119.78197"}, {"latitude": "36.59692", "longitude": "-119.7778"}, {"latitude": "36.5979", "longitude": "-119.77773"}, {"latitude": "36.60389", "longitude": "-119.78187"}, {"latitude": "36.59974", "longitude": "-119.78449"}, {"latitude": "36.59612", "longitude": "-119.78547"}]
1137495 November 06, 2020 - 18:38:02 UTC 36.59274 -119.79074 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 []
1145428 November 15, 2020 - 15:22:57 UTC 36.59591 -119.76812 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"}]
1152510 November 22, 2020 - 03:47:57 UTC 36.60512 -119.84619 Fresno 35 [{"latitude": "36.60413", "longitude": "-119.84489"}, {"latitude": "36.60419", "longitude": "-119.83599"}, {"latitude": "36.60486", "longitude": "-119.83023"}, {"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.63788", "longitude": "-119.84867"}, {"latitude": "36.61589", "longitude": "-119.85822"}, {"latitude": "36.60431", "longitude": "-119.84592"}]
1152939 November 23, 2020 - 09:15:00 UTC 36.6057 -119.82669 Fresno 35 []
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"}]
1100708 September 30, 2020 - 02:25:59 UTC 36.60596 -119.76377 Fresno 35 [{"latitude": "36.60791", "longitude": "-119.76376"}, {"latitude": "36.62253", "longitude": "-119.75955"}, {"latitude": "36.62712", "longitude": "-119.75963"}, {"latitude": "36.641", "longitude": "-119.76379"}, {"latitude": "36.6271", "longitude": "-119.76802"}, {"latitude": "36.61987", "longitude": "-119.76781"}, {"latitude": "36.61438", "longitude": "-119.76671"}, {"latitude": "36.60888", "longitude": "-119.76541"}]
1117177 October 14, 2020 - 16:38:37 UTC 36.60647 -119.73166 Fresno 35 []
1093686 September 26, 2020 - 08:38:00 UTC 36.60652 -120.04326 Fresno 35 []
1117100 October 14, 2020 - 15:51:51 UTC 36.60761 -120.04324 Fresno 35 []
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 []
1140343 November 09, 2020 - 19:33:11 UTC 36.61046 -119.86265 Fresno 35 []
1116878 October 14, 2020 - 01:26:45 UTC 36.61122 -120.03421 Fresno 35 [{"latitude": "36.61168", "longitude": "-120.0342"}, {"latitude": "36.6157", "longitude": "-120.03419"}, {"latitude": "36.61783", "longitude": "-120.03419"}, {"latitude": "36.61731", "longitude": "-120.04225"}, {"latitude": "36.61631", "longitude": "-120.04212"}]
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 []
1111764 October 06, 2020 - 04:26:50 UTC 36.61251 -119.79066 Fresno 35 [{"latitude": "36.61085", "longitude": "-119.79772"}, {"latitude": "36.61251", "longitude": "-119.79118"}, {"latitude": "36.6125", "longitude": "-119.79513"}, {"latitude": "36.61249", "longitude": "-119.79806"}, {"latitude": "36.61247", "longitude": "-119.80188"}]
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 []
1153331 November 23, 2020 - 20:03:49 UTC 36.61682 -119.82664 Fresno 35 []
778944 February 06, 2020 - 15:48:32 UTC 36.61801 -119.77716 Fresno 35 []
1140318 November 09, 2020 - 18:59:23 UTC 36.61803 -119.78112 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"}]
1116879 October 14, 2020 - 01:26:45 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"}]
1116880 October 14, 2020 - 01:26:44 UTC 36.61844 -120.0253 Fresno 35 [{"latitude": "36.61814", "longitude": "-120.02976"}, {"latitude": "36.61871", "longitude": "-120.02568"}, {"latitude": "36.61935", "longitude": "-120.02519"}, {"latitude": "36.62562", "longitude": "-120.02515"}]
778933 February 06, 2020 - 15:36:59 UTC 36.61989 -119.76316 Fresno 35 []
1148252 November 18, 2020 - 15:53:55 UTC 36.62336 -119.83704 Fresno 35 []
1123824 October 23, 2020 - 03:17:09 UTC 36.62571 -120.00735 Fresno 35 []
1148857 November 18, 2020 - 22:29:50 UTC 36.62635 -120.01519 Fresno 35 []
654613 October 11, 2019 - 22:00:38 UTC 36.62646 -119.76384 Fresno 35 []
1100749 September 30, 2020 - 02:25:00 UTC 36.62805 -119.76382 Fresno 35 [{"latitude": "36.62881", "longitude": "-119.76381"}, {"latitude": "36.63045", "longitude": "-119.76108"}, {"latitude": "36.63238", "longitude": "-119.7634"}, {"latitude": "36.6315", "longitude": "-119.76546"}, {"latitude": "36.62984", "longitude": "-119.76472"}]
1153722 November 24, 2020 - 16:19:00 UTC 36.62822 -119.75483 Fresno 35 []
1123816 October 23, 2020 - 03:03:09 UTC 36.62968 -119.9931 Fresno 35 []
779226 February 06, 2020 - 18:09:16 UTC 36.6315 -119.76546 Fresno 35 []
1152369 November 21, 2020 - 23:58:00 UTC 36.63309 -119.988 Fresno 35 [{"latitude": "36.62957", "longitude": "-119.93548"}, {"latitude": "36.63238", "longitude": "-119.93495"}, {"latitude": "36.64062", "longitude": "-119.9347"}, {"latitude": "36.6427", "longitude": "-119.93469"}, {"latitude": "36.64781", "longitude": "-119.93496"}, {"latitude": "36.64856", "longitude": "-119.94345"}, {"latitude": "36.63012", "longitude": "-119.94389"}]
733426 December 08, 2019 - 04:27:32 UTC 36.6332 -119.89414 Fresno 35 []
1121529 October 20, 2020 - 16:56:54 UTC 36.63338 -119.75729 Fresno 35 []
779264 February 06, 2020 - 18:42:16 UTC 36.63434 -119.75949 Fresno 35 []
1100748 September 30, 2020 - 02:25:00 UTC 36.63437 -119.7638 Fresno 35 [{"latitude": "36.63385", "longitude": "-119.76311"}, {"latitude": "36.641", "longitude": "-119.76379"}, {"latitude": "36.63385", "longitude": "-119.76429"}]
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 []

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
);