pge-outages

Custom SQL query returning 101 rows (hide)

Query parameters

idoutagesnapshotlastUpdateTimecurrentEtorautoEtorestCustAffectedhazardFlaglatitudelongituderegionNamecausecrewCurrentStatus
1569913215:631639 631639 1 September 30, 2019 - 22:34:00 UTC October 01, 2019 - 12:00:00 UTC   7 1 35.35389 -118.95864 2 2 2
1569913838:631639 631639 2 September 30, 2019 - 22:34:00 UTC October 01, 2019 - 12:00:00 UTC   7 1 35.35389 -118.95864 2 2 2
1569914414:631639 631639 3 September 30, 2019 - 22:34:00 UTC October 01, 2019 - 12:00:00 UTC   7 1 35.35389 -118.95864 2 2 2
1569915019:631639 631639 4 September 30, 2019 - 22:34:00 UTC October 01, 2019 - 12:00:00 UTC   7 1 35.35389 -118.95864 2 2 2
1569915624:631639 631639 5 September 30, 2019 - 22:34:00 UTC October 01, 2019 - 12:00:00 UTC   7 1 35.35389 -118.95864 2 2 2
1569916231:631639 631639 6 September 30, 2019 - 22:34:00 UTC October 01, 2019 - 12:00:00 UTC   7 1 35.35389 -118.95864 2 2 2
1569916815:631639 631639 7 September 30, 2019 - 22:34:00 UTC October 01, 2019 - 12:00:00 UTC   7 1 35.35389 -118.95864 2 2 2
1569917417:631639 631639 8 September 30, 2019 - 22:34:00 UTC October 01, 2019 - 12:00:00 UTC   7 1 35.35389 -118.95864 2 2 2
1569918012:631639 631639 9 September 30, 2019 - 22:34:00 UTC October 01, 2019 - 12:00:00 UTC   7 1 35.35389 -118.95864 2 2 2
1569918645:631639 631639 10 September 30, 2019 - 22:34:00 UTC October 01, 2019 - 12:00:00 UTC   7 1 35.35389 -118.95864 2 2 2
1569919223:631639 631639 11 September 30, 2019 - 22:34:00 UTC October 01, 2019 - 12:00:00 UTC   7 1 35.35389 -118.95864 2 2 2
1569919823:631639 631639 12 September 30, 2019 - 22:34:00 UTC October 01, 2019 - 12:00:00 UTC   7 1 35.35389 -118.95864 2 2 2
1569920421:631639 631639 13 September 30, 2019 - 22:34:00 UTC October 01, 2019 - 12:00:00 UTC   7 1 35.35389 -118.95864 2 2 2
1569921023:631639 631639 14 September 30, 2019 - 22:34:00 UTC October 01, 2019 - 12:00:00 UTC   7 1 35.35389 -118.95864 2 2 2
1569921618:631639 631639 15 September 30, 2019 - 22:34:00 UTC October 01, 2019 - 12:00:00 UTC   7 1 35.35389 -118.95864 2 2 2
1569922217:631639 631639 16 September 30, 2019 - 22:34:00 UTC October 01, 2019 - 12:00:00 UTC   7 1 35.35389 -118.95864 2 2 2
1569922813:631639 631639 17 September 30, 2019 - 22:34:00 UTC October 01, 2019 - 12:00:00 UTC   7 1 35.35389 -118.95864 2 2 2
1569923412:631639 631639 18 September 30, 2019 - 22:34:00 UTC October 01, 2019 - 12:00:00 UTC   7 1 35.35389 -118.95864 2 2 2
1569924030:631639 631639 19 September 30, 2019 - 22:34:00 UTC October 01, 2019 - 12:00:00 UTC   7 1 35.35389 -118.95864 2 2 2
1569924614:631639 631639 20 September 30, 2019 - 22:34:00 UTC October 01, 2019 - 12:00:00 UTC   7 1 35.35389 -118.95864 2 2 2
1569925218:631639 631639 21 September 30, 2019 - 22:34:00 UTC October 01, 2019 - 12:00:00 UTC   7 1 35.35389 -118.95864 2 2 2
1569925819:631639 631639 22 September 30, 2019 - 22:34:00 UTC October 01, 2019 - 12:00:00 UTC   7 1 35.35389 -118.95864 2 2 2
1569926413:631639 631639 23 September 30, 2019 - 22:34:00 UTC October 01, 2019 - 12:00:00 UTC   7 1 35.35389 -118.95864 2 2 2
1569943255:633599 633599 51 October 01, 2019 - 15:08:32 UTC October 01, 2019 - 18:00:00 UTC October 01, 2019 - 18:00:00 UTC 67 0 35.30304 -119.01307 2 1 1
1569943834:633599 633599 52 October 01, 2019 - 15:19:30 UTC October 01, 2019 - 21:30:00 UTC   8 0 35.30304 -119.01307 2 3 2
1569944417:633599 633599 53 October 01, 2019 - 15:19:30 UTC October 01, 2019 - 21:30:00 UTC   8 0 35.30304 -119.01307 2 3 2
1569945023:633599 633599 54 October 01, 2019 - 15:19:30 UTC October 01, 2019 - 21:30:00 UTC   8 0 35.30304 -119.01307 2 3 2
1569945622:633599 633599 55 October 01, 2019 - 15:19:30 UTC October 01, 2019 - 21:30:00 UTC   8 0 35.30304 -119.01307 2 3 2
1569946235:633599 633599 56 October 01, 2019 - 15:19:30 UTC October 01, 2019 - 21:30:00 UTC   8 0 35.30304 -119.01307 2 3 2
1569946828:633599 633599 57 October 01, 2019 - 15:19:30 UTC October 01, 2019 - 21:30:00 UTC   8 0 35.30304 -119.01307 2 3 2
1569947434:633599 633599 58 October 01, 2019 - 15:19:30 UTC October 01, 2019 - 21:30:00 UTC   8 0 35.30304 -119.01307 2 3 2
1569948031:633599 633599 59 October 01, 2019 - 15:19:30 UTC October 01, 2019 - 21:30:00 UTC   8 0 35.30304 -119.01307 2 3 2
1569948634:633599 633599 60 October 01, 2019 - 15:19:30 UTC October 01, 2019 - 21:30:00 UTC   8 0 35.30304 -119.01307 2 3 2
1569948634:633861 633861 60 October 01, 2019 - 16:40:58 UTC October 01, 2019 - 18:15:00 UTC October 01, 2019 - 18:15:00 UTC 1 0 35.31481 -119.06578 2 1 5
1569948634:633863 633863 60 October 01, 2019 - 16:42:25 UTC October 01, 2019 - 19:45:00 UTC October 01, 2019 - 19:45:00 UTC 1 1 35.38415 -118.95472 2 1 1
1569949236:633599 633599 61 October 01, 2019 - 15:19:30 UTC October 01, 2019 - 21:30:00 UTC   8 0 35.30304 -119.01307 2 3 2
1569949236:633861 633861 61 October 01, 2019 - 16:40:58 UTC October 01, 2019 - 18:15:00 UTC October 01, 2019 - 18:15:00 UTC 1 0 35.31481 -119.06578 2 1 5
1569949236:633863 633863 61 October 01, 2019 - 16:42:25 UTC October 01, 2019 - 19:45:00 UTC October 01, 2019 - 19:45:00 UTC 1 1 35.38415 -118.95472 2 1 5
1569949829:633599 633599 62 October 01, 2019 - 15:19:30 UTC October 01, 2019 - 21:30:00 UTC   8 0 35.30304 -119.01307 2 3 2
1569949829:633861 633861 62 October 01, 2019 - 16:40:58 UTC October 01, 2019 - 18:15:00 UTC October 01, 2019 - 18:15:00 UTC 1 0 35.31481 -119.06578 2 1 5
1569949829:633863 633863 62 October 01, 2019 - 17:04:34 UTC October 01, 2019 - 19:45:00 UTC October 01, 2019 - 19:45:00 UTC 1 1 35.38415 -118.95472 2 6 4
1569950417:633599 633599 63 October 01, 2019 - 15:19:30 UTC October 01, 2019 - 21:30:00 UTC   8 0 35.30304 -119.01307 2 3 2
1569950417:633861 633861 63 October 01, 2019 - 17:10:33 UTC October 01, 2019 - 18:15:00 UTC October 01, 2019 - 18:15:00 UTC 1 0 35.31481 -119.06578 2 6 4
1569950417:633863 633863 63 October 01, 2019 - 17:04:34 UTC October 01, 2019 - 19:45:00 UTC October 01, 2019 - 19:45:00 UTC 1 1 35.38415 -118.95472 2 6 4
1569950417:633899 633899 63 October 01, 2019 - 17:13:48 UTC October 01, 2019 - 21:30:00 UTC   1 0 35.64876 -118.84143 2 3 1
1569951021:633599 633599 64 October 01, 2019 - 15:19:30 UTC October 01, 2019 - 21:30:00 UTC   8 0 35.30304 -119.01307 2 3 2
1569951021:633861 633861 64 October 01, 2019 - 17:10:33 UTC October 01, 2019 - 18:15:00 UTC October 01, 2019 - 18:15:00 UTC 1 0 35.31481 -119.06578 2 6 4
1569951021:633863 633863 64 October 01, 2019 - 17:04:34 UTC October 01, 2019 - 19:45:00 UTC October 01, 2019 - 19:45:00 UTC 1 1 35.38415 -118.95472 2 6 4
1569951021:633899 633899 64 October 01, 2019 - 17:13:48 UTC October 01, 2019 - 21:30:00 UTC   1 0 35.64876 -118.84143 2 3 1
1569951616:633599 633599 65 October 01, 2019 - 15:19:30 UTC October 01, 2019 - 21:30:00 UTC   8 0 35.30304 -119.01307 2 3 2
1569951616:633863 633863 65 October 01, 2019 - 17:04:34 UTC October 01, 2019 - 19:45:00 UTC October 01, 2019 - 19:45:00 UTC 1 1 35.38415 -118.95472 2 6 4
1569951616:633899 633899 65 October 01, 2019 - 17:13:48 UTC October 01, 2019 - 21:30:00 UTC   1 0 35.64876 -118.84143 2 3 1
1569952233:633599 633599 66 October 01, 2019 - 15:19:30 UTC October 01, 2019 - 21:30:00 UTC   8 0 35.30304 -119.01307 2 3 2
1569952233:633863 633863 66 October 01, 2019 - 17:04:34 UTC October 01, 2019 - 19:45:00 UTC October 01, 2019 - 19:45:00 UTC 1 1 35.38415 -118.95472 2 6 4
1569952839:633599 633599 67 October 01, 2019 - 15:19:30 UTC October 01, 2019 - 21:30:00 UTC   8 0 35.30304 -119.01307 2 3 2
1569952839:633863 633863 67 October 01, 2019 - 17:04:34 UTC October 01, 2019 - 19:45:00 UTC October 01, 2019 - 19:45:00 UTC 1 1 35.38415 -118.95472 2 6 4
1569953462:633599 633599 68 October 01, 2019 - 15:19:30 UTC October 01, 2019 - 21:30:00 UTC   8 0 35.30304 -119.01307 2 3 2
1569953462:633863 633863 68 October 01, 2019 - 17:04:34 UTC October 01, 2019 - 19:45:00 UTC October 01, 2019 - 19:45:00 UTC 1 1 35.38415 -118.95472 2 6 4
1569954055:633599 633599 69 October 01, 2019 - 15:19:30 UTC October 01, 2019 - 21:30:00 UTC   8 0 35.30304 -119.01307 2 3 2
1569954055:633863 633863 69 October 01, 2019 - 17:04:34 UTC October 01, 2019 - 19:45:00 UTC October 01, 2019 - 19:45:00 UTC 1 1 35.38415 -118.95472 2 6 4
1569954621:633599 633599 70 October 01, 2019 - 15:19:30 UTC October 01, 2019 - 21:30:00 UTC   8 0 35.30304 -119.01307 2 3 2
1569954621:633863 633863 70 October 01, 2019 - 17:04:34 UTC October 01, 2019 - 19:45:00 UTC October 01, 2019 - 19:45:00 UTC 1 1 35.38415 -118.95472 2 6 4
1569955253:633599 633599 71 October 01, 2019 - 15:19:30 UTC October 01, 2019 - 21:30:00 UTC   8 0 35.30304 -119.01307 2 3 2
1569955253:633863 633863 71 October 01, 2019 - 17:04:34 UTC October 01, 2019 - 19:45:00 UTC October 01, 2019 - 19:45:00 UTC 1 1 35.38415 -118.95472 2 6 4
1569955842:633599 633599 72 October 01, 2019 - 15:19:30 UTC October 01, 2019 - 21:30:00 UTC   8 0 35.30304 -119.01307 2 3 2
1569955842:633863 633863 72 October 01, 2019 - 17:04:34 UTC October 01, 2019 - 19:45:00 UTC October 01, 2019 - 19:45:00 UTC 1 1 35.38415 -118.95472 2 6 4
1569956437:633599 633599 73 October 01, 2019 - 15:19:30 UTC October 01, 2019 - 21:30:00 UTC   8 0 35.30304 -119.01307 2 3 2
1569957023:633599 633599 74 October 01, 2019 - 15:19:30 UTC October 01, 2019 - 21:30:00 UTC   8 0 35.30304 -119.01307 2 3 2
1569957630:633599 633599 75 October 01, 2019 - 19:15:20 UTC October 01, 2019 - 21:30:00 UTC   8 0 35.30304 -119.01307 2 3 2
1569958225:633599 633599 76 October 01, 2019 - 19:22:31 UTC October 01, 2019 - 21:30:00 UTC   8 0 35.30304 -119.01307 2 3 2
1569958839:633599 633599 77 October 01, 2019 - 19:22:31 UTC October 01, 2019 - 21:30:00 UTC   8 0 35.30304 -119.01307 2 3 2
1569959424:633599 633599 78 October 01, 2019 - 19:22:31 UTC October 01, 2019 - 21:30:00 UTC   8 0 35.30304 -119.01307 2 3 2
1569960023:633599 633599 79 October 01, 2019 - 19:22:31 UTC October 01, 2019 - 21:30:00 UTC   8 0 35.30304 -119.01307 2 3 2
1569960633:633599 633599 80 October 01, 2019 - 19:22:31 UTC October 01, 2019 - 21:30:00 UTC   8 0 35.30304 -119.01307 2 3 2
1569961233:633599 633599 81 October 01, 2019 - 19:22:31 UTC October 01, 2019 - 21:30:00 UTC   8 0 35.30304 -119.01307 2 3 2
1569961838:633599 633599 82 October 01, 2019 - 19:22:31 UTC October 01, 2019 - 21:30:00 UTC   8 0 35.30304 -119.01307 2 3 2
1569962421:633599 633599 83 October 01, 2019 - 19:22:31 UTC October 01, 2019 - 21:30:00 UTC   8 0 35.30304 -119.01307 2 3 2
1569963019:633599 633599 84 October 01, 2019 - 19:22:31 UTC October 01, 2019 - 21:30:00 UTC   8 0 35.30304 -119.01307 2 3 2
1569963019:634816 634816 84 October 01, 2019 - 20:35:35 UTC October 01, 2019 - 21:30:00 UTC   2 0 35.64845 -118.82716 2 3 2
1569963629:633599 633599 85 October 01, 2019 - 19:22:31 UTC October 01, 2019 - 21:30:00 UTC   8 0 35.30304 -119.01307 2 3 2
1569964228:633599 633599 86 October 01, 2019 - 19:22:31 UTC October 01, 2019 - 21:30:00 UTC   8 0 35.30304 -119.01307 2 3 2
1569964818:633599 633599 87 October 01, 2019 - 19:22:31 UTC October 01, 2019 - 21:30:00 UTC   8 0 35.30304 -119.01307 2 3 2
1569965440:633599 633599 88 October 01, 2019 - 19:22:31 UTC October 01, 2019 - 21:30:00 UTC   8 0 35.30304 -119.01307 2 3 2
1569966020:633599 633599 89 October 01, 2019 - 19:22:31 UTC October 01, 2019 - 21:30:00 UTC   8 0 35.30304 -119.01307 2 3 2
1569966613:633599 633599 90 October 01, 2019 - 19:22:31 UTC October 01, 2019 - 21:30:00 UTC   8 0 35.30304 -119.01307 2 3 2
1569966613:634853 634853 90 October 01, 2019 - 21:37:07 UTC October 01, 2019 - 21:30:00 UTC   1 0 35.64895 -118.81466 2 3 2
1569967246:633599 633599 91 October 01, 2019 - 19:22:31 UTC October 01, 2019 - 21:30:00 UTC   8 0 35.30304 -119.01307 2 3 2
1569967246:634853 634853 91 October 01, 2019 - 21:37:07 UTC October 01, 2019 - 21:30:00 UTC   1 0 35.64895 -118.81466 2 3 2
1569967836:633599 633599 92 October 01, 2019 - 19:22:31 UTC October 01, 2019 - 21:30:00 UTC   8 0 35.30304 -119.01307 2 3 2
1569968422:633599 633599 93 October 01, 2019 - 19:22:31 UTC October 01, 2019 - 21:30:00 UTC   8 0 35.30304 -119.01307 2 3 2
1569969014:633599 633599 94 October 01, 2019 - 19:22:31 UTC October 01, 2019 - 21:30:00 UTC   8 0 35.30304 -119.01307 2 3 2
1569969014:634894 634894 94 October 01, 2019 - 22:25:45 UTC October 02, 2019 - 01:30:00 UTC October 02, 2019 - 01:30:00 UTC 1 1 35.34713 -118.99035 2 1 1
1569969624:633599 633599 95 October 01, 2019 - 19:22:31 UTC October 01, 2019 - 21:30:00 UTC   8 0 35.30304 -119.01307 2 3 2
1569969624:634894 634894 95 October 01, 2019 - 22:25:45 UTC October 02, 2019 - 01:30:00 UTC October 02, 2019 - 01:30:00 UTC 1 1 35.34713 -118.99035 2 1 5
1569970224:633599 633599 96 October 01, 2019 - 19:22:31 UTC October 01, 2019 - 21:30:00 UTC   8 0 35.30304 -119.01307 2 3 2
1569970224:634894 634894 96 October 01, 2019 - 22:25:45 UTC October 02, 2019 - 01:30:00 UTC October 02, 2019 - 01:30:00 UTC 1 1 35.34713 -118.99035 2 1 5
1569970224:635101 635101 96 October 01, 2019 - 22:43:48 UTC October 02, 2019 - 01:45:00 UTC October 02, 2019 - 01:45:00 UTC 1 1 35.36461 -118.94261 2 1 1
1569970823:633599 633599 97 October 01, 2019 - 19:22:31 UTC October 01, 2019 - 21:30:00 UTC   8 0 35.30304 -119.01307 2 3 2
1569970823:634894 634894 97 October 01, 2019 - 22:51:16 UTC October 02, 2019 - 01:30:00 UTC October 02, 2019 - 01:30:00 UTC 1 1 35.34713 -118.99035 2 6 4
1569970823:635101 635101 97 October 01, 2019 - 22:47:51 UTC October 02, 2019 - 01:45:00 UTC October 02, 2019 - 01:45:00 UTC 1 1 35.36461 -118.94261 2 1 1
1569971424:633599 633599 98 October 01, 2019 - 19:22:31 UTC October 01, 2019 - 21:30:00 UTC   8 0 35.30304 -119.01307 2 3 2
Powered by Datasette · Query took 10.561ms · About: About this site