pge-outages

Custom SQL query returning 101 rows (hide)

Query parameters

idoutagesnapshotlastUpdateTimecurrentEtorautoEtorestCustAffectedhazardFlaglatitudelongituderegionNamecausecrewCurrentStatus
1569913215:633478 633478 1 October 01, 2019 - 06:34:37 UTC October 01, 2019 - 07:45:00 UTC October 01, 2019 - 07:45:00 UTC 1 0 37.25687 -120.43449 13 2 3
1569913838:633478 633478 2 October 01, 2019 - 06:34:37 UTC October 01, 2019 - 07:45:00 UTC October 01, 2019 - 07:45:00 UTC 1 0 37.25687 -120.43449 13 2 3
1569914414:633478 633478 3 October 01, 2019 - 06:34:37 UTC October 01, 2019 - 07:45:00 UTC October 01, 2019 - 07:45:00 UTC 1 0 37.25687 -120.43449 13 2 3
1569914414:633504 633504 3 October 01, 2019 - 07:07:05 UTC October 01, 2019 - 10:00:00 UTC October 01, 2019 - 10:00:00 UTC 1 0 37.25754 -120.4345 13 1 1
1569915019:633478 633478 4 October 01, 2019 - 07:17:58 UTC October 01, 2019 - 15:30:00 UTC   1 0 37.25687 -120.43449 13 2 3
1569915019:633504 633504 4 October 01, 2019 - 07:25:02 UTC October 01, 2019 - 15:30:00 UTC   1 0 37.25754 -120.4345 13 1 5
1569915624:633478 633478 5 October 01, 2019 - 07:17:58 UTC October 01, 2019 - 15:30:00 UTC   1 0 37.25687 -120.43449 13 2 3
1569915624:633504 633504 5 October 01, 2019 - 07:25:02 UTC October 01, 2019 - 15:30:00 UTC   1 0 37.25754 -120.4345 13 1 5
1569916231:633478 633478 6 October 01, 2019 - 07:17:58 UTC October 01, 2019 - 15:30:00 UTC   1 0 37.25687 -120.43449 13 2 3
1569916231:633504 633504 6 October 01, 2019 - 07:45:29 UTC October 01, 2019 - 15:30:00 UTC   1 0 37.25754 -120.4345 13 6 4
1569916815:633478 633478 7 October 01, 2019 - 07:17:58 UTC October 01, 2019 - 15:30:00 UTC   1 0 37.25687 -120.43449 13 2 3
1569916815:633504 633504 7 October 01, 2019 - 07:45:29 UTC October 01, 2019 - 15:30:00 UTC   1 0 37.25754 -120.4345 13 6 4
1569917417:633478 633478 8 October 01, 2019 - 07:17:58 UTC October 01, 2019 - 15:30:00 UTC   1 0 37.25687 -120.43449 13 2 3
1569917417:633504 633504 8 October 01, 2019 - 07:59:17 UTC October 01, 2019 - 15:30:00 UTC   5 0 37.25996 -120.43418 13 6 4
1569918012:633478 633478 9 October 01, 2019 - 07:17:58 UTC October 01, 2019 - 15:30:00 UTC   1 0 37.25687 -120.43449 13 2 3
1569918012:633504 633504 9 October 01, 2019 - 08:02:28 UTC October 01, 2019 - 15:30:00 UTC   5 0 37.25996 -120.43418 13 6 4
1569918645:633478 633478 10 October 01, 2019 - 08:19:21 UTC October 01, 2019 - 15:30:00 UTC   1 0 37.25687 -120.43449 13 2 1
1569918645:633504 633504 10 October 01, 2019 - 08:02:28 UTC October 01, 2019 - 15:30:00 UTC   5 0 37.25996 -120.43418 13 6 4
1569919223:633478 633478 11 October 01, 2019 - 08:19:21 UTC October 01, 2019 - 15:30:00 UTC   1 0 37.25687 -120.43449 13 2 1
1569919223:633504 633504 11 October 01, 2019 - 08:02:28 UTC October 01, 2019 - 15:30:00 UTC   5 0 37.25996 -120.43418 13 6 4
1569919823:633478 633478 12 October 01, 2019 - 08:19:21 UTC October 01, 2019 - 15:30:00 UTC   1 0 37.25687 -120.43449 13 2 1
1569920421:633478 633478 13 October 01, 2019 - 08:19:21 UTC October 01, 2019 - 15:30:00 UTC   1 0 37.25687 -120.43449 13 2 5
1569921023:633478 633478 14 October 01, 2019 - 08:19:21 UTC October 01, 2019 - 15:30:00 UTC   1 0 37.25687 -120.43449 13 2 5
1569921618:633478 633478 15 October 01, 2019 - 08:19:21 UTC October 01, 2019 - 15:30:00 UTC   1 0 37.25687 -120.43449 13 2 5
1569922217:633478 633478 16 October 01, 2019 - 08:19:21 UTC October 01, 2019 - 15:30:00 UTC   1 0 37.25687 -120.43449 13 2 5
1569922813:633478 633478 17 October 01, 2019 - 08:19:21 UTC October 01, 2019 - 15:30:00 UTC   1 0 37.25687 -120.43449 13 2 5
1569923412:633478 633478 18 October 01, 2019 - 08:19:21 UTC October 01, 2019 - 15:30:00 UTC   1 0 37.25687 -120.43449 13 2 5
1569924030:633478 633478 19 October 01, 2019 - 09:55:03 UTC October 01, 2019 - 15:30:00 UTC   1 0 37.25687 -120.43449 13 2 4
1569924614:633478 633478 20 October 01, 2019 - 09:55:03 UTC October 01, 2019 - 15:30:00 UTC   1 0 37.25687 -120.43449 13 2 4
1569925218:633478 633478 21 October 01, 2019 - 09:55:03 UTC October 01, 2019 - 15:30:00 UTC   1 0 37.25687 -120.43449 13 2 4
1569925819:633478 633478 22 October 01, 2019 - 09:55:03 UTC October 01, 2019 - 15:30:00 UTC   1 0 37.25687 -120.43449 13 2 4
1569926413:633478 633478 23 October 01, 2019 - 09:55:03 UTC October 01, 2019 - 15:30:00 UTC   1 0 37.25687 -120.43449 13 2 4
1569927022:633478 633478 24 October 01, 2019 - 09:55:03 UTC October 01, 2019 - 15:30:00 UTC   1 0 37.25687 -120.43449 13 2 4
1569927620:633478 633478 25 October 01, 2019 - 09:55:03 UTC October 01, 2019 - 15:30:00 UTC   1 0 37.25687 -120.43449 13 2 4
1569928219:633478 633478 26 October 01, 2019 - 09:55:03 UTC October 01, 2019 - 15:30:00 UTC   1 0 37.25687 -120.43449 13 2 4
1569949829:633889 633889 62 October 01, 2019 - 17:03:20 UTC October 01, 2019 - 20:00:00 UTC October 01, 2019 - 20:00:00 UTC 1 1 37.30767 -120.46987 13 1 1
1569955253:633994 633994 71 October 01, 2019 - 18:29:41 UTC October 01, 2019 - 21:15:00 UTC October 01, 2019 - 21:15:00 UTC 1 0 37.3018 -120.46319 13 1 1
1569955842:633994 633994 72 October 01, 2019 - 18:29:41 UTC October 01, 2019 - 21:15:00 UTC October 01, 2019 - 21:15:00 UTC 1 0 37.3018 -120.46319 13 1 1
1569956437:633994 633994 73 October 01, 2019 - 18:29:41 UTC October 01, 2019 - 21:15:00 UTC October 01, 2019 - 21:15:00 UTC 1 0 37.3018 -120.46319 13 1 1
1569957023:633994 633994 74 October 01, 2019 - 18:29:41 UTC October 01, 2019 - 21:15:00 UTC October 01, 2019 - 21:15:00 UTC 1 0 37.3018 -120.46319 13 1 1
1569957630:633994 633994 75 October 01, 2019 - 18:29:41 UTC October 01, 2019 - 21:15:00 UTC October 01, 2019 - 21:15:00 UTC 1 0 37.3018 -120.46319 13 1 1
1569958225:633994 633994 76 October 01, 2019 - 18:29:41 UTC October 01, 2019 - 21:15:00 UTC October 01, 2019 - 21:15:00 UTC 1 0 37.3018 -120.46319 13 1 1
1569958839:633994 633994 77 October 01, 2019 - 18:29:41 UTC October 01, 2019 - 21:15:00 UTC October 01, 2019 - 21:15:00 UTC 1 0 37.3018 -120.46319 13 1 1
1569959424:633994 633994 78 October 01, 2019 - 18:29:41 UTC October 01, 2019 - 21:15:00 UTC October 01, 2019 - 21:15:00 UTC 1 0 37.3018 -120.46319 13 1 1
1569960023:633994 633994 79 October 01, 2019 - 18:29:41 UTC October 01, 2019 - 21:15:00 UTC October 01, 2019 - 21:15:00 UTC 1 0 37.3018 -120.46319 13 1 1
1569960633:633994 633994 80 October 01, 2019 - 18:29:41 UTC October 01, 2019 - 21:15:00 UTC October 01, 2019 - 21:15:00 UTC 1 0 37.3018 -120.46319 13 1 1
1569961233:633994 633994 81 October 01, 2019 - 18:29:41 UTC October 01, 2019 - 21:15:00 UTC October 01, 2019 - 21:15:00 UTC 1 0 37.3018 -120.46319 13 1 1
1569961838:633994 633994 82 October 01, 2019 - 18:29:41 UTC October 01, 2019 - 21:15:00 UTC October 01, 2019 - 21:15:00 UTC 1 0 37.3018 -120.46319 13 1 1
1569962421:633994 633994 83 October 01, 2019 - 18:29:41 UTC October 01, 2019 - 21:15:00 UTC October 01, 2019 - 21:15:00 UTC 1 0 37.3018 -120.46319 13 1 1
1569963019:633994 633994 84 October 01, 2019 - 18:29:41 UTC October 01, 2019 - 21:15:00 UTC October 01, 2019 - 21:15:00 UTC 1 0 37.3018 -120.46319 13 1 1
1569963629:633994 633994 85 October 01, 2019 - 20:48:54 UTC October 02, 2019 - 00:00:00 UTC   1 0 37.3018 -120.46319 13 1 1
1569964228:633994 633994 86 October 01, 2019 - 20:48:54 UTC October 02, 2019 - 00:00:00 UTC   1 0 37.3018 -120.46319 13 1 1
1569964818:633994 633994 87 October 01, 2019 - 20:48:54 UTC October 02, 2019 - 00:00:00 UTC   1 0 37.3018 -120.46319 13 1 1
1569965440:633994 633994 88 October 01, 2019 - 20:48:54 UTC October 02, 2019 - 00:00:00 UTC   1 0 37.3018 -120.46319 13 1 1
1569966020:633994 633994 89 October 01, 2019 - 20:48:54 UTC October 02, 2019 - 00:00:00 UTC   1 0 37.3018 -120.46319 13 1 1
1569966613:633994 633994 90 October 01, 2019 - 20:48:54 UTC October 02, 2019 - 00:00:00 UTC   1 0 37.3018 -120.46319 13 1 1
1569967246:633994 633994 91 October 01, 2019 - 20:48:54 UTC October 02, 2019 - 00:00:00 UTC   1 0 37.3018 -120.46319 13 1 1
1569967836:633994 633994 92 October 01, 2019 - 20:48:54 UTC October 02, 2019 - 00:00:00 UTC   1 0 37.3018 -120.46319 13 1 1
1569968422:633994 633994 93 October 01, 2019 - 22:08:17 UTC October 02, 2019 - 00:00:00 UTC   1 0 37.3018 -120.46319 13 6 4
1569969014:633994 633994 94 October 01, 2019 - 22:08:17 UTC October 02, 2019 - 00:00:00 UTC   1 0 37.3018 -120.46319 13 6 4
1569969624:633994 633994 95 October 01, 2019 - 22:08:17 UTC October 02, 2019 - 00:00:00 UTC   1 0 37.3018 -120.46319 13 6 4
1569970224:633994 633994 96 October 01, 2019 - 22:08:17 UTC October 02, 2019 - 00:00:00 UTC   1 0 37.3018 -120.46319 13 6 4
1569970823:633994 633994 97 October 01, 2019 - 22:08:17 UTC October 02, 2019 - 00:00:00 UTC   1 0 37.3018 -120.46319 13 6 4
1569972029:635293 635293 99 October 01, 2019 - 23:08:38 UTC October 02, 2019 - 02:00:00 UTC October 02, 2019 - 02:00:00 UTC 1 1 37.28064 -120.47231 13 1 1
1569972627:635293 635293 100 October 01, 2019 - 23:08:38 UTC October 02, 2019 - 02:00:00 UTC October 02, 2019 - 02:00:00 UTC 1 1 37.28064 -120.47231 13 1 1
1569973221:635293 635293 101 October 01, 2019 - 23:28:42 UTC October 02, 2019 - 02:00:00 UTC October 02, 2019 - 02:00:00 UTC 1 1 37.28064 -120.47231 13 1 5
1569973815:635293 635293 102 October 01, 2019 - 23:28:42 UTC October 02, 2019 - 02:00:00 UTC October 02, 2019 - 02:00:00 UTC 1 1 37.28064 -120.47231 13 1 5
1569974427:635293 635293 103 October 01, 2019 - 23:48:15 UTC October 02, 2019 - 02:00:00 UTC October 02, 2019 - 02:00:00 UTC 1 1 37.28064 -120.47231 13 6 4
1569975023:635293 635293 104 October 01, 2019 - 23:48:15 UTC October 02, 2019 - 02:00:00 UTC October 02, 2019 - 02:00:00 UTC 1 1 37.28064 -120.47231 13 6 4
1569975632:635293 635293 105 October 02, 2019 - 00:07:52 UTC October 02, 2019 - 02:00:00 UTC October 02, 2019 - 02:00:00 UTC 1 1 37.28064 -120.47231 13 6 4
1569976224:635293 635293 106 October 02, 2019 - 00:07:52 UTC October 02, 2019 - 02:00:00 UTC October 02, 2019 - 02:00:00 UTC 1 1 37.28064 -120.47231 13 6 4
1569987614:635553 635553 125 October 02, 2019 - 03:31:51 UTC October 02, 2019 - 06:30:00 UTC October 02, 2019 - 06:30:00 UTC 8 0 37.29316 -120.45997 13 1 5
1569988216:635553 635553 126 October 02, 2019 - 03:31:51 UTC October 02, 2019 - 06:30:00 UTC October 02, 2019 - 06:30:00 UTC 8 0 37.29316 -120.45997 13 1 5
1569988829:635553 635553 127 October 02, 2019 - 03:51:11 UTC October 02, 2019 - 06:30:00 UTC October 02, 2019 - 06:30:00 UTC 8 0 37.29316 -120.45997 13 6 4
1569989417:635553 635553 128 October 02, 2019 - 03:51:11 UTC October 02, 2019 - 06:30:00 UTC October 02, 2019 - 06:30:00 UTC 8 0 37.29316 -120.45997 13 6 4
1569990017:635553 635553 129 October 02, 2019 - 03:51:11 UTC October 02, 2019 - 06:30:00 UTC October 02, 2019 - 06:30:00 UTC 8 0 37.29316 -120.45997 13 6 4
1569990616:635553 635553 130 October 02, 2019 - 03:51:11 UTC October 02, 2019 - 06:30:00 UTC October 02, 2019 - 06:30:00 UTC 8 0 37.29316 -120.45997 13 6 4
1569991222:635553 635553 131 October 02, 2019 - 04:29:00 UTC October 02, 2019 - 06:30:00 UTC October 02, 2019 - 06:30:00 UTC 8 0 37.29316 -120.45997 13 2 4
1569991812:635553 635553 132 October 02, 2019 - 04:29:00 UTC October 02, 2019 - 06:30:00 UTC October 02, 2019 - 06:30:00 UTC 8 0 37.29316 -120.45997 13 2 4
1569992427:635553 635553 133 October 02, 2019 - 04:29:00 UTC October 02, 2019 - 06:30:00 UTC October 02, 2019 - 06:30:00 UTC 8 0 37.29316 -120.45997 13 2 4
1569993031:635553 635553 134 October 02, 2019 - 04:29:00 UTC October 02, 2019 - 06:30:00 UTC October 02, 2019 - 06:30:00 UTC 8 0 37.29316 -120.45997 13 2 4
1569993623:635553 635553 135 October 02, 2019 - 05:11:31 UTC October 02, 2019 - 06:30:00 UTC October 02, 2019 - 06:30:00 UTC 8 0 37.29316 -120.45997 13 2 3
1569994216:635553 635553 136 October 02, 2019 - 05:11:31 UTC October 02, 2019 - 06:30:00 UTC October 02, 2019 - 06:30:00 UTC 8 0 37.29316 -120.45997 13 2 3
1569994818:635553 635553 137 October 02, 2019 - 05:11:31 UTC October 02, 2019 - 06:30:00 UTC October 02, 2019 - 06:30:00 UTC 8 0 37.29316 -120.45997 13 2 3
1569995420:635553 635553 138 October 02, 2019 - 05:11:31 UTC October 02, 2019 - 06:30:00 UTC October 02, 2019 - 06:30:00 UTC 8 0 37.29316 -120.45997 13 2 3
1569996025:635553 635553 139 October 02, 2019 - 05:11:31 UTC October 02, 2019 - 06:30:00 UTC October 02, 2019 - 06:30:00 UTC 8 0 37.29316 -120.45997 13 2 3
1569996619:635553 635553 140 October 02, 2019 - 06:01:58 UTC October 02, 2019 - 11:00:00 UTC   8 0 37.29316 -120.45997 13 2 3
1569997216:635553 635553 141 October 02, 2019 - 06:01:58 UTC October 02, 2019 - 11:00:00 UTC   8 0 37.29316 -120.45997 13 2 3
1569997848:635553 635553 142 October 02, 2019 - 06:01:58 UTC October 02, 2019 - 11:00:00 UTC   8 0 37.29316 -120.45997 13 2 3
1569998423:635553 635553 143 October 02, 2019 - 06:01:58 UTC October 02, 2019 - 11:00:00 UTC   8 0 37.29316 -120.45997 13 2 3
1569999020:635553 635553 144 October 02, 2019 - 06:01:58 UTC October 02, 2019 - 11:00:00 UTC   8 0 37.29316 -120.45997 13 2 3
1569999655:635553 635553 145 October 02, 2019 - 06:01:58 UTC October 02, 2019 - 11:00:00 UTC   8 0 37.29316 -120.45997 13 2 3
1570000230:635553 635553 146 October 02, 2019 - 06:01:58 UTC October 02, 2019 - 11:00:00 UTC   8 0 37.29316 -120.45997 13 2 3
1570001422:635553 635553 147 October 02, 2019 - 07:20:34 UTC October 02, 2019 - 11:00:00 UTC   8 0 37.29316 -120.45997 13 2 2
1570003822:635553 635553 148 October 02, 2019 - 08:05:12 UTC October 02, 2019 - 11:00:00 UTC   8 0 37.29316 -120.45997 13 2 2
1570004422:635553 635553 149 October 02, 2019 - 08:05:12 UTC October 02, 2019 - 11:00:00 UTC   8 0 37.29316 -120.45997 13 2 2
1570005020:635553 635553 150 October 02, 2019 - 08:05:12 UTC October 02, 2019 - 11:00:00 UTC   8 0 37.29316 -120.45997 13 2 2
1570005614:635553 635553 151 October 02, 2019 - 08:05:12 UTC October 02, 2019 - 11:00:00 UTC   8 0 37.29316 -120.45997 13 2 2
1570006221:635553 635553 152 October 02, 2019 - 08:05:12 UTC October 02, 2019 - 11:00:00 UTC   8 0 37.29316 -120.45997 13 2 2
1570006830:635553 635553 153 October 02, 2019 - 08:05:12 UTC October 02, 2019 - 11:00:00 UTC   8 0 37.29316 -120.45997 13 2 2
1570007430:635553 635553 154 October 02, 2019 - 08:05:12 UTC October 02, 2019 - 11:00:00 UTC   8 0 37.29316 -120.45997 13 2 2
Powered by Datasette · Query took 21.242ms · About: About this site