pge-outages

Custom SQL query returning 101 rows (hide)

Query parameters

idoutagesnapshotlastUpdateTimecurrentEtorautoEtorestCustAffectedhazardFlaglatitudelongituderegionNamecausecrewCurrentStatus
1569913215:631794 631794 1 October 01, 2019 - 05:48:52 UTC October 01, 2019 - 15:30:00 UTC   1 0 36.37987 -119.92783 22 2 2
1569913838:631794 631794 2 October 01, 2019 - 05:48:52 UTC October 01, 2019 - 15:30:00 UTC   1 0 36.37987 -119.92783 22 2 2
1569914414:631794 631794 3 October 01, 2019 - 05:48:52 UTC October 01, 2019 - 15:30:00 UTC   1 0 36.37987 -119.92783 22 2 2
1569915019:631794 631794 4 October 01, 2019 - 05:48:52 UTC October 01, 2019 - 15:30:00 UTC   1 0 36.37987 -119.92783 22 2 2
1569915624:631794 631794 5 October 01, 2019 - 05:48:52 UTC October 01, 2019 - 15:30:00 UTC   1 0 36.37987 -119.92783 22 2 2
1569916231:631794 631794 6 October 01, 2019 - 05:48:52 UTC October 01, 2019 - 15:30:00 UTC   1 0 36.37987 -119.92783 22 2 2
1569916815:631794 631794 7 October 01, 2019 - 05:48:52 UTC October 01, 2019 - 15:30:00 UTC   1 0 36.37987 -119.92783 22 2 2
1569917417:631794 631794 8 October 01, 2019 - 05:48:52 UTC October 01, 2019 - 15:30:00 UTC   1 0 36.37987 -119.92783 22 2 2
1569918012:631794 631794 9 October 01, 2019 - 05:48:52 UTC October 01, 2019 - 15:30:00 UTC   1 0 36.37987 -119.92783 22 2 2
1569955842:634013 634013 72 October 01, 2019 - 18:46:00 UTC October 01, 2019 - 21:45:00 UTC October 01, 2019 - 21:45:00 UTC 1 0 36.42984 -119.99478 22 1 1
1569956437:634013 634013 73 October 01, 2019 - 18:47:22 UTC October 01, 2019 - 21:45:00 UTC October 01, 2019 - 21:45:00 UTC 1 0 36.42984 -119.99478 22 1 1
1569957023:634013 634013 74 October 01, 2019 - 18:47:22 UTC October 01, 2019 - 21:45:00 UTC October 01, 2019 - 21:45:00 UTC 1 0 36.42984 -119.99478 22 1 1
1569957630:634013 634013 75 October 01, 2019 - 18:47:22 UTC October 01, 2019 - 21:45:00 UTC October 01, 2019 - 21:45:00 UTC 1 0 36.42984 -119.99478 22 1 1
1569958225:634013 634013 76 October 01, 2019 - 18:47:22 UTC October 01, 2019 - 21:45:00 UTC October 01, 2019 - 21:45:00 UTC 1 0 36.42984 -119.99478 22 1 1
1569958839:634013 634013 77 October 01, 2019 - 18:47:22 UTC October 01, 2019 - 21:45:00 UTC October 01, 2019 - 21:45:00 UTC 1 0 36.42984 -119.99478 22 1 1
1569959424:634013 634013 78 October 01, 2019 - 18:47:22 UTC October 01, 2019 - 21:45:00 UTC October 01, 2019 - 21:45:00 UTC 1 0 36.42984 -119.99478 22 1 1
1569960023:634013 634013 79 October 01, 2019 - 18:47:22 UTC October 01, 2019 - 21:45:00 UTC October 01, 2019 - 21:45:00 UTC 1 0 36.42984 -119.99478 22 1 1
1569960633:634013 634013 80 October 01, 2019 - 18:47:22 UTC October 01, 2019 - 21:45:00 UTC October 01, 2019 - 21:45:00 UTC 1 0 36.42984 -119.99478 22 1 1
1569961233:634013 634013 81 October 01, 2019 - 18:47:22 UTC October 01, 2019 - 21:45:00 UTC October 01, 2019 - 21:45:00 UTC 1 0 36.42984 -119.99478 22 1 1
1569961838:634013 634013 82 October 01, 2019 - 18:47:22 UTC October 01, 2019 - 21:45:00 UTC October 01, 2019 - 21:45:00 UTC 1 0 36.42984 -119.99478 22 1 1
1569962421:634013 634013 83 October 01, 2019 - 18:47:22 UTC October 01, 2019 - 21:45:00 UTC October 01, 2019 - 21:45:00 UTC 1 0 36.42984 -119.99478 22 1 1
1569963019:634013 634013 84 October 01, 2019 - 18:47:22 UTC October 01, 2019 - 21:45:00 UTC October 01, 2019 - 21:45:00 UTC 1 0 36.42984 -119.99478 22 1 1
1569963629:634013 634013 85 October 01, 2019 - 18:47:22 UTC October 01, 2019 - 21:45:00 UTC October 01, 2019 - 21:45:00 UTC 1 0 36.42984 -119.99478 22 1 1
1569964228:634013 634013 86 October 01, 2019 - 18:47:22 UTC October 01, 2019 - 21:45:00 UTC October 01, 2019 - 21:45:00 UTC 1 0 36.42984 -119.99478 22 1 1
1569964818:634013 634013 87 October 01, 2019 - 18:47:22 UTC October 01, 2019 - 21:45:00 UTC October 01, 2019 - 21:45:00 UTC 1 0 36.42984 -119.99478 22 1 1
1569965440:634013 634013 88 October 01, 2019 - 18:47:22 UTC October 01, 2019 - 21:45:00 UTC October 01, 2019 - 21:45:00 UTC 1 0 36.42984 -119.99478 22 1 1
1569966020:634013 634013 89 October 01, 2019 - 18:47:22 UTC October 01, 2019 - 21:45:00 UTC October 01, 2019 - 21:45:00 UTC 1 0 36.42984 -119.99478 22 1 1
1569966613:634013 634013 90 October 01, 2019 - 21:43:39 UTC October 01, 2019 - 23:45:00 UTC   1 0 36.42984 -119.99478 22 1 5
1569967246:634013 634013 91 October 01, 2019 - 21:43:39 UTC October 01, 2019 - 23:45:00 UTC   1 0 36.42984 -119.99478 22 1 5
1569967836:634013 634013 92 October 01, 2019 - 21:43:39 UTC October 01, 2019 - 23:45:00 UTC   1 0 36.42984 -119.99478 22 1 5
1569968422:634013 634013 93 October 01, 2019 - 21:43:39 UTC October 01, 2019 - 23:45:00 UTC   1 0 36.42984 -119.99478 22 1 5
1569969014:634013 634013 94 October 01, 2019 - 21:43:39 UTC October 01, 2019 - 23:45:00 UTC   1 0 36.42984 -119.99478 22 1 5
1569969624:634013 634013 95 October 01, 2019 - 21:43:39 UTC October 01, 2019 - 23:45:00 UTC   1 0 36.42984 -119.99478 22 1 5
1569970224:634013 634013 96 October 01, 2019 - 22:43:58 UTC October 01, 2019 - 23:45:00 UTC   1 0 36.42984 -119.99478 22 6 4
1569970823:634013 634013 97 October 01, 2019 - 22:43:58 UTC October 01, 2019 - 23:45:00 UTC   1 0 36.42984 -119.99478 22 6 4
1569971424:634013 634013 98 October 01, 2019 - 22:43:58 UTC October 01, 2019 - 23:45:00 UTC   1 0 36.42984 -119.99478 22 6 4
1570030223:635780 635780 187 October 02, 2019 - 15:23:40 UTC October 02, 2019 - 23:00:00 UTC   2 0 36.44541 -119.80802 22 3 2
1570030821:635780 635780 188 October 02, 2019 - 15:28:47 UTC October 02, 2019 - 23:00:00 UTC   2 0 36.44541 -119.80802 22 3 2
1570031422:635780 635780 189 October 02, 2019 - 15:28:47 UTC October 02, 2019 - 23:00:00 UTC   2 0 36.44541 -119.80802 22 3 2
1570032029:635780 635780 190 October 02, 2019 - 15:28:47 UTC October 02, 2019 - 23:00:00 UTC   2 0 36.44541 -119.80802 22 3 2
1570032635:635780 635780 191 October 02, 2019 - 15:28:47 UTC October 02, 2019 - 23:00:00 UTC   2 0 36.44541 -119.80802 22 3 2
1570033232:635780 635780 192 October 02, 2019 - 15:28:47 UTC October 02, 2019 - 23:00:00 UTC   2 0 36.44541 -119.80802 22 3 2
1570033830:635780 635780 193 October 02, 2019 - 15:28:47 UTC October 02, 2019 - 23:00:00 UTC   2 0 36.44541 -119.80802 22 3 2
1570034425:635780 635780 194 October 02, 2019 - 15:28:47 UTC October 02, 2019 - 23:00:00 UTC   2 0 36.44541 -119.80802 22 3 2
1570035025:635780 635780 195 October 02, 2019 - 15:28:47 UTC October 02, 2019 - 23:00:00 UTC   2 0 36.44541 -119.80802 22 3 2
1570035638:635780 635780 196 October 02, 2019 - 15:28:47 UTC October 02, 2019 - 23:00:00 UTC   2 0 36.44541 -119.80802 22 3 2
1570036222:635780 635780 197 October 02, 2019 - 15:28:47 UTC October 02, 2019 - 23:00:00 UTC   2 0 36.44541 -119.80802 22 3 2
1570036832:635780 635780 198 October 02, 2019 - 15:28:47 UTC October 02, 2019 - 23:00:00 UTC   2 0 36.44541 -119.80802 22 3 2
1570037426:635780 635780 199 October 02, 2019 - 15:28:47 UTC October 02, 2019 - 23:00:00 UTC   2 0 36.44541 -119.80802 22 3 2
1570037426:636454 636454 199 October 02, 2019 - 17:24:35 UTC October 02, 2019 - 20:30:00 UTC October 02, 2019 - 20:30:00 UTC 1 1 36.44661 -119.93651 22 1 1
1570038018:635780 635780 200 October 02, 2019 - 15:28:47 UTC October 02, 2019 - 23:00:00 UTC   2 0 36.44541 -119.80802 22 3 2
1570038018:636454 636454 200 October 02, 2019 - 17:35:13 UTC October 02, 2019 - 20:30:00 UTC October 02, 2019 - 20:30:00 UTC 1 1 36.44661 -119.93651 22 1 5
1570038618:635780 635780 201 October 02, 2019 - 15:28:47 UTC October 02, 2019 - 23:00:00 UTC   2 0 36.44541 -119.80802 22 3 2
1570038618:636454 636454 201 October 02, 2019 - 17:35:13 UTC October 02, 2019 - 20:30:00 UTC October 02, 2019 - 20:30:00 UTC 1 1 36.44661 -119.93651 22 1 5
1570039244:635780 635780 202 October 02, 2019 - 15:28:47 UTC October 02, 2019 - 23:00:00 UTC   2 0 36.44541 -119.80802 22 3 2
1570039244:636454 636454 202 October 02, 2019 - 17:35:13 UTC October 02, 2019 - 20:30:00 UTC October 02, 2019 - 20:30:00 UTC 1 1 36.44661 -119.93651 22 1 5
1570039827:635780 635780 203 October 02, 2019 - 15:28:47 UTC October 02, 2019 - 23:00:00 UTC   2 0 36.44541 -119.80802 22 3 2
1570039827:636454 636454 203 October 02, 2019 - 17:35:13 UTC October 02, 2019 - 20:30:00 UTC October 02, 2019 - 20:30:00 UTC 1 1 36.44661 -119.93651 22 1 5
1570040448:635780 635780 204 October 02, 2019 - 15:28:47 UTC October 02, 2019 - 23:00:00 UTC   2 0 36.44541 -119.80802 22 3 2
1570040448:636454 636454 204 October 02, 2019 - 17:35:13 UTC October 02, 2019 - 20:30:00 UTC October 02, 2019 - 20:30:00 UTC 1 1 36.44661 -119.93651 22 1 5
1570041037:635780 635780 205 October 02, 2019 - 15:28:47 UTC October 02, 2019 - 23:00:00 UTC   2 0 36.44541 -119.80802 22 3 2
1570041037:636454 636454 205 October 02, 2019 - 18:17:17 UTC October 02, 2019 - 20:30:00 UTC October 02, 2019 - 20:30:00 UTC 1 1 36.44661 -119.93651 22 1 5
1570041620:635780 635780 206 October 02, 2019 - 15:28:47 UTC October 02, 2019 - 23:00:00 UTC   2 0 36.44541 -119.80802 22 3 2
1570041620:636454 636454 206 October 02, 2019 - 18:17:17 UTC October 02, 2019 - 20:30:00 UTC October 02, 2019 - 20:30:00 UTC 1 1 36.44661 -119.93651 22 1 5
1570042231:635780 635780 207 October 02, 2019 - 15:28:47 UTC October 02, 2019 - 23:00:00 UTC   2 0 36.44541 -119.80802 22 3 2
1570042231:636454 636454 207 October 02, 2019 - 18:17:17 UTC October 02, 2019 - 20:30:00 UTC October 02, 2019 - 20:30:00 UTC 1 1 36.44661 -119.93651 22 1 5
1570042828:635780 635780 208 October 02, 2019 - 15:28:47 UTC October 02, 2019 - 23:00:00 UTC   2 0 36.44541 -119.80802 22 3 2
1570042828:636454 636454 208 October 02, 2019 - 18:48:06 UTC October 02, 2019 - 20:30:00 UTC October 02, 2019 - 20:30:00 UTC 1 1 36.44661 -119.93651 22 6 4
1570043415:635780 635780 209 October 02, 2019 - 18:58:31 UTC October 02, 2019 - 23:00:00 UTC   2 0 36.44541 -119.80802 22 3 2
1570043415:636454 636454 209 October 02, 2019 - 18:48:06 UTC October 02, 2019 - 20:30:00 UTC October 02, 2019 - 20:30:00 UTC 1 1 36.44661 -119.93651 22 6 4
1570044019:636454 636454 210 October 02, 2019 - 18:48:06 UTC October 02, 2019 - 20:30:00 UTC October 02, 2019 - 20:30:00 UTC 1 1 36.44661 -119.93651 22 6 4
1570044619:636454 636454 211 October 02, 2019 - 18:48:06 UTC October 02, 2019 - 20:30:00 UTC October 02, 2019 - 20:30:00 UTC 1 1 36.44661 -119.93651 22 6 4
1570045222:636454 636454 212 October 02, 2019 - 18:48:06 UTC October 02, 2019 - 20:30:00 UTC October 02, 2019 - 20:30:00 UTC 1 1 36.44661 -119.93651 22 6 4
1570045818:636454 636454 213 October 02, 2019 - 18:48:06 UTC October 02, 2019 - 20:30:00 UTC October 02, 2019 - 20:30:00 UTC 1 1 36.44661 -119.93651 22 6 4
1570046432:636454 636454 214 October 02, 2019 - 18:48:06 UTC October 02, 2019 - 20:30:00 UTC October 02, 2019 - 20:30:00 UTC 1 1 36.44661 -119.93651 22 6 4
1570224624:643711 643711 505 October 04, 2019 - 21:23:02 UTC October 05, 2019 - 00:15:00 UTC October 05, 2019 - 00:15:00 UTC 2 0 36.41798 -119.89538 22 1 1
1570225220:643711 643711 506 October 04, 2019 - 21:23:02 UTC October 05, 2019 - 00:15:00 UTC October 05, 2019 - 00:15:00 UTC 2 0 36.41798 -119.89538 22 1 1
1570225811:643711 643711 507 October 04, 2019 - 21:42:08 UTC October 05, 2019 - 00:15:00 UTC October 05, 2019 - 00:15:00 UTC 2 0 36.41798 -119.89538 22 1 5
1570226445:643711 643711 508 October 04, 2019 - 21:42:08 UTC October 05, 2019 - 00:15:00 UTC October 05, 2019 - 00:15:00 UTC 2 0 36.41798 -119.89538 22 1 5
1570227017:643711 643711 509 October 04, 2019 - 21:42:08 UTC October 05, 2019 - 00:15:00 UTC October 05, 2019 - 00:15:00 UTC 2 0 36.41798 -119.89538 22 1 5
1570227614:643711 643711 510 October 04, 2019 - 21:42:08 UTC October 05, 2019 - 00:15:00 UTC October 05, 2019 - 00:15:00 UTC 2 0 36.41798 -119.89538 22 1 5
1570228218:643711 643711 511 October 04, 2019 - 22:20:29 UTC October 05, 2019 - 00:15:00 UTC October 05, 2019 - 00:15:00 UTC 2 0 36.41798 -119.89538 22 6 4
1570228836:643711 643711 512 October 04, 2019 - 22:20:29 UTC October 05, 2019 - 00:15:00 UTC October 05, 2019 - 00:15:00 UTC 2 0 36.41798 -119.89538 22 6 4
1570229417:643711 643711 513 October 04, 2019 - 22:40:57 UTC October 05, 2019 - 00:15:00 UTC October 05, 2019 - 00:15:00 UTC 2 0 36.41798 -119.89538 22 6 4
1570468827:646003 646003 909 October 07, 2019 - 17:11:09 UTC October 07, 2019 - 20:30:00 UTC October 07, 2019 - 20:30:00 UTC 1 0 36.48897 -119.98446 22 1 1
1570469421:646003 646003 910 October 07, 2019 - 17:19:20 UTC October 07, 2019 - 20:30:00 UTC October 07, 2019 - 20:30:00 UTC 1 0 36.48897 -119.98446 22 1 1
1570470025:646003 646003 911 October 07, 2019 - 17:19:20 UTC October 07, 2019 - 20:30:00 UTC October 07, 2019 - 20:30:00 UTC 1 0 36.48897 -119.98446 22 1 1
1570470636:646003 646003 912 October 07, 2019 - 17:19:20 UTC October 07, 2019 - 20:30:00 UTC October 07, 2019 - 20:30:00 UTC 1 0 36.48897 -119.98446 22 1 1
1570471230:646003 646003 913 October 07, 2019 - 17:19:20 UTC October 07, 2019 - 20:30:00 UTC October 07, 2019 - 20:30:00 UTC 1 0 36.48897 -119.98446 22 1 1
1570471828:646003 646003 914 October 07, 2019 - 17:19:20 UTC October 07, 2019 - 20:30:00 UTC October 07, 2019 - 20:30:00 UTC 1 0 36.48897 -119.98446 22 1 1
1570472424:646003 646003 915 October 07, 2019 - 17:19:20 UTC October 07, 2019 - 20:30:00 UTC October 07, 2019 - 20:30:00 UTC 1 0 36.48897 -119.98446 22 1 1
1570473017:646003 646003 916 October 07, 2019 - 17:19:20 UTC October 07, 2019 - 20:30:00 UTC October 07, 2019 - 20:30:00 UTC 1 0 36.48897 -119.98446 22 1 1
1570473628:646003 646003 917 October 07, 2019 - 17:19:20 UTC October 07, 2019 - 20:30:00 UTC October 07, 2019 - 20:30:00 UTC 1 0 36.48897 -119.98446 22 1 5
1570474238:646003 646003 918 October 07, 2019 - 17:19:20 UTC October 07, 2019 - 20:30:00 UTC October 07, 2019 - 20:30:00 UTC 1 0 36.48897 -119.98446 22 1 5
1570474877:646003 646003 919 October 07, 2019 - 18:51:43 UTC October 07, 2019 - 20:30:00 UTC October 07, 2019 - 20:30:00 UTC 1 0 36.48897 -119.98446 22 6 4
1570485639:646831 646831 937 October 07, 2019 - 21:55:59 UTC October 08, 2019 - 01:00:00 UTC October 08, 2019 - 01:00:00 UTC 1 1 36.3795 -119.94166 22 1 1
1570486222:646831 646831 938 October 07, 2019 - 21:57:15 UTC October 08, 2019 - 01:00:00 UTC October 08, 2019 - 01:00:00 UTC 1 1 36.3795 -119.94166 22 1 5
1570486811:646831 646831 939 October 07, 2019 - 21:57:15 UTC October 08, 2019 - 01:00:00 UTC October 08, 2019 - 01:00:00 UTC 1 1 36.3795 -119.94166 22 1 5
1570487422:646831 646831 940 October 07, 2019 - 21:57:15 UTC October 08, 2019 - 01:00:00 UTC October 08, 2019 - 01:00:00 UTC 1 1 36.3795 -119.94166 22 1 5
1570488021:646831 646831 941 October 07, 2019 - 21:57:15 UTC October 08, 2019 - 01:00:00 UTC October 08, 2019 - 01:00:00 UTC 1 1 36.3795 -119.94166 22 1 5
1570488626:646831 646831 942 October 07, 2019 - 22:40:37 UTC October 08, 2019 - 01:00:00 UTC October 08, 2019 - 01:00:00 UTC 1 1 36.3795 -119.94166 22 6 4