pge-outages

Custom SQL query returning 101 rows (hide)

Query parameters

idoutagesnapshotlastUpdateTimecurrentEtorautoEtorestCustAffectedhazardFlaglatitudelongituderegionNamecausecrewCurrentStatus
1569913215:633481 633481 1 October 01, 2019 - 05:14:07 UTC October 01, 2019 - 13:00:00 UTC   4 0 37.69717 -122.08699 4 3 2
1569913838:633481 633481 2 October 01, 2019 - 05:14:07 UTC October 01, 2019 - 13:00:00 UTC   4 0 37.69717 -122.08699 4 3 2
1569914414:633481 633481 3 October 01, 2019 - 05:14:07 UTC October 01, 2019 - 13:00:00 UTC   4 0 37.69717 -122.08699 4 3 2
1569915019:633481 633481 4 October 01, 2019 - 05:14:07 UTC October 01, 2019 - 13:00:00 UTC   4 0 37.69717 -122.08699 4 3 2
1569915624:633481 633481 5 October 01, 2019 - 05:14:07 UTC October 01, 2019 - 13:00:00 UTC   4 0 37.69717 -122.08699 4 3 2
1569916231:633481 633481 6 October 01, 2019 - 05:14:07 UTC October 01, 2019 - 13:00:00 UTC   4 0 37.69717 -122.08699 4 3 2
1569916815:633481 633481 7 October 01, 2019 - 05:14:07 UTC October 01, 2019 - 13:00:00 UTC   4 0 37.69717 -122.08699 4 3 2
1569917417:633481 633481 8 October 01, 2019 - 05:14:07 UTC October 01, 2019 - 13:00:00 UTC   4 0 37.69717 -122.08699 4 3 2
1569918012:633481 633481 9 October 01, 2019 - 05:14:07 UTC October 01, 2019 - 13:00:00 UTC   4 0 37.69717 -122.08699 4 3 2
1569918645:633481 633481 10 October 01, 2019 - 05:14:07 UTC October 01, 2019 - 13:00:00 UTC   4 0 37.69717 -122.08699 4 3 2
1569919223:633481 633481 11 October 01, 2019 - 05:14:07 UTC October 01, 2019 - 13:00:00 UTC   4 0 37.69717 -122.08699 4 3 2
1569919823:633481 633481 12 October 01, 2019 - 05:14:07 UTC October 01, 2019 - 13:00:00 UTC   4 0 37.69717 -122.08699 4 3 2
1569920421:633481 633481 13 October 01, 2019 - 05:14:07 UTC October 01, 2019 - 13:00:00 UTC   4 0 37.69717 -122.08699 4 3 2
1569921023:633481 633481 14 October 01, 2019 - 05:14:07 UTC October 01, 2019 - 13:00:00 UTC   4 0 37.69717 -122.08699 4 3 2
1569921618:633481 633481 15 October 01, 2019 - 05:14:07 UTC October 01, 2019 - 13:00:00 UTC   4 0 37.69717 -122.08699 4 3 2
1569922217:633481 633481 16 October 01, 2019 - 05:14:07 UTC October 01, 2019 - 13:00:00 UTC   4 0 37.69717 -122.08699 4 3 2
1569922813:633481 633481 17 October 01, 2019 - 05:14:07 UTC October 01, 2019 - 13:00:00 UTC   4 0 37.69717 -122.08699 4 3 2
1569923412:633481 633481 18 October 01, 2019 - 05:14:07 UTC October 01, 2019 - 13:00:00 UTC   4 0 37.69717 -122.08699 4 3 2
1569924030:633481 633481 19 October 01, 2019 - 05:14:07 UTC October 01, 2019 - 13:00:00 UTC   4 0 37.69717 -122.08699 4 3 2
1569924614:633481 633481 20 October 01, 2019 - 05:14:07 UTC October 01, 2019 - 13:00:00 UTC   4 0 37.69717 -122.08699 4 3 2
1569925218:633481 633481 21 October 01, 2019 - 05:14:07 UTC October 01, 2019 - 13:00:00 UTC   4 0 37.69717 -122.08699 4 3 2
1569925819:633481 633481 22 October 01, 2019 - 05:14:07 UTC October 01, 2019 - 13:00:00 UTC   4 0 37.69717 -122.08699 4 3 2
1569926413:633481 633481 23 October 01, 2019 - 05:14:07 UTC October 01, 2019 - 13:00:00 UTC   4 0 37.69717 -122.08699 4 3 2
1569927022:633481 633481 24 October 01, 2019 - 05:14:07 UTC October 01, 2019 - 13:00:00 UTC   4 0 37.69717 -122.08699 4 3 2
1569927620:633481 633481 25 October 01, 2019 - 05:14:07 UTC October 01, 2019 - 13:00:00 UTC   4 0 37.69717 -122.08699 4 3 2
1569928219:633481 633481 26 October 01, 2019 - 05:14:07 UTC October 01, 2019 - 13:00:00 UTC   4 0 37.69717 -122.08699 4 3 2
1569928810:633481 633481 27 October 01, 2019 - 05:14:07 UTC October 01, 2019 - 13:00:00 UTC   4 0 37.69717 -122.08699 4 3 2
1569929414:633481 633481 28 October 01, 2019 - 05:14:07 UTC October 01, 2019 - 13:00:00 UTC   4 0 37.69717 -122.08699 4 3 2
1569930017:633481 633481 29 October 01, 2019 - 05:14:07 UTC October 01, 2019 - 13:00:00 UTC   4 0 37.69717 -122.08699 4 3 2
1569930614:633481 633481 30 October 01, 2019 - 05:14:07 UTC October 01, 2019 - 13:00:00 UTC   4 0 37.69717 -122.08699 4 3 2
1569931217:633481 633481 31 October 01, 2019 - 05:14:07 UTC October 01, 2019 - 13:00:00 UTC   4 0 37.69717 -122.08699 4 3 2
1569931817:633481 633481 32 October 01, 2019 - 05:14:07 UTC October 01, 2019 - 13:00:00 UTC   4 0 37.69717 -122.08699 4 3 2
1569932416:633481 633481 33 October 01, 2019 - 05:14:07 UTC October 01, 2019 - 13:00:00 UTC   4 0 37.69717 -122.08699 4 3 2
1569933016:633481 633481 34 October 01, 2019 - 05:14:07 UTC October 01, 2019 - 13:00:00 UTC   4 0 37.69717 -122.08699 4 3 2
1569933610:633481 633481 35 October 01, 2019 - 05:14:07 UTC October 01, 2019 - 13:00:00 UTC   4 0 37.69717 -122.08699 4 3 2
1569934216:633481 633481 36 October 01, 2019 - 12:45:54 UTC October 01, 2019 - 16:00:00 UTC   4 0 37.69717 -122.08699 4 3 2
1569934854:633481 633481 37 October 01, 2019 - 12:45:54 UTC October 01, 2019 - 16:00:00 UTC   4 0 37.69717 -122.08699 4 3 2
1569935427:633481 633481 38 October 01, 2019 - 12:45:54 UTC October 01, 2019 - 16:00:00 UTC   4 0 37.69717 -122.08699 4 3 2
1569936025:633481 633481 39 October 01, 2019 - 12:45:54 UTC October 01, 2019 - 16:00:00 UTC   4 0 37.69717 -122.08699 4 3 2
1569936639:633481 633481 40 October 01, 2019 - 12:45:54 UTC October 01, 2019 - 16:00:00 UTC   4 0 37.69717 -122.08699 4 3 2
1569937220:633481 633481 41 October 01, 2019 - 12:45:54 UTC October 01, 2019 - 16:00:00 UTC   4 0 37.69717 -122.08699 4 3 2
1569937820:633481 633481 42 October 01, 2019 - 12:45:54 UTC October 01, 2019 - 16:00:00 UTC   4 0 37.69717 -122.08699 4 3 2
1569938467:633481 633481 43 October 01, 2019 - 12:45:54 UTC October 01, 2019 - 16:00:00 UTC   4 0 37.69717 -122.08699 4 3 2
1569939021:633481 633481 44 October 01, 2019 - 12:45:54 UTC October 01, 2019 - 16:00:00 UTC   4 0 37.69717 -122.08699 4 3 2
1569939629:633481 633481 45 October 01, 2019 - 12:45:54 UTC October 01, 2019 - 16:00:00 UTC   4 0 37.69717 -122.08699 4 3 2
1569940220:633481 633481 46 October 01, 2019 - 12:45:54 UTC October 01, 2019 - 16:00:00 UTC   4 0 37.69717 -122.08699 4 3 2
1569940818:633481 633481 47 October 01, 2019 - 12:45:54 UTC October 01, 2019 - 16:00:00 UTC   4 0 37.69717 -122.08699 4 3 2
1569941431:633481 633481 48 October 01, 2019 - 12:45:54 UTC October 01, 2019 - 16:00:00 UTC   4 0 37.69717 -122.08699 4 3 2
1569942021:633481 633481 49 October 01, 2019 - 12:45:54 UTC October 01, 2019 - 16:00:00 UTC   4 0 37.69717 -122.08699 4 3 2
1569942620:633481 633481 50 October 01, 2019 - 12:45:54 UTC October 01, 2019 - 16:00:00 UTC   4 0 37.69717 -122.08699 4 3 2
1569943255:633481 633481 51 October 01, 2019 - 12:45:54 UTC October 01, 2019 - 16:00:00 UTC   4 0 37.69717 -122.08699 4 3 2
1569943834:633481 633481 52 October 01, 2019 - 12:45:54 UTC October 01, 2019 - 16:00:00 UTC   4 0 37.69717 -122.08699 4 3 2
1569944417:633481 633481 53 October 01, 2019 - 12:45:54 UTC October 01, 2019 - 16:00:00 UTC   4 0 37.69717 -122.08699 4 3 2
1569945023:633481 633481 54 October 01, 2019 - 15:39:11 UTC October 01, 2019 - 17:00:00 UTC   4 0 37.69717 -122.08699 4 3 2
1569945622:633481 633481 55 October 01, 2019 - 15:39:11 UTC October 01, 2019 - 17:00:00 UTC   4 0 37.69717 -122.08699 4 3 2
1569946235:633481 633481 56 October 01, 2019 - 15:39:11 UTC October 01, 2019 - 17:00:00 UTC   4 0 37.69717 -122.08699 4 3 2
1569946828:633481 633481 57 October 01, 2019 - 15:39:11 UTC October 01, 2019 - 17:00:00 UTC   4 0 37.69717 -122.08699 4 3 2
1569947434:633826 633826 58 October 01, 2019 - 16:23:19 UTC October 01, 2019 - 19:00:00 UTC October 01, 2019 - 19:00:00 UTC 1 0 37.70669 -122.10963 4 1 1
1569947434:633481 633481 58 October 01, 2019 - 15:39:11 UTC October 01, 2019 - 17:00:00 UTC   4 0 37.69717 -122.08699 4 3 2
1569948031:633826 633826 59 October 01, 2019 - 16:23:19 UTC October 01, 2019 - 19:00:00 UTC October 01, 2019 - 19:00:00 UTC 1 0 37.70669 -122.10963 4 1 1
1569948031:633481 633481 59 October 01, 2019 - 15:39:11 UTC October 01, 2019 - 17:00:00 UTC   4 0 37.69717 -122.08699 4 3 2
1569948634:633826 633826 60 October 01, 2019 - 16:23:19 UTC October 01, 2019 - 19:00:00 UTC October 01, 2019 - 19:00:00 UTC 1 0 37.70669 -122.10963 4 1 5
1569948634:633862 633862 60 October 01, 2019 - 16:40:01 UTC October 02, 2019 - 00:00:00 UTC   12 0 37.80511 -122.17103 4 3 1
1569948634:633481 633481 60 October 01, 2019 - 15:39:11 UTC October 01, 2019 - 17:00:00 UTC   4 0 37.69717 -122.08699 4 3 2
1569949236:633826 633826 61 October 01, 2019 - 16:23:19 UTC October 01, 2019 - 19:00:00 UTC October 01, 2019 - 19:00:00 UTC 1 0 37.70669 -122.10963 4 1 5
1569949236:633862 633862 61 October 01, 2019 - 16:40:01 UTC October 02, 2019 - 00:00:00 UTC   12 0 37.80511 -122.17103 4 3 1
1569949236:633481 633481 61 October 01, 2019 - 15:39:11 UTC October 01, 2019 - 17:00:00 UTC   4 0 37.69717 -122.08699 4 3 2
1569949829:633826 633826 62 October 01, 2019 - 16:23:19 UTC October 01, 2019 - 19:00:00 UTC October 01, 2019 - 19:00:00 UTC 1 0 37.70669 -122.10963 4 1 5
1569949829:633862 633862 62 October 01, 2019 - 16:40:01 UTC October 02, 2019 - 00:00:00 UTC   12 0 37.80511 -122.17103 4 3 1
1569950417:633826 633826 63 October 01, 2019 - 16:23:19 UTC October 01, 2019 - 19:00:00 UTC October 01, 2019 - 19:00:00 UTC 1 0 37.70669 -122.10963 4 1 5
1569950417:633862 633862 63 October 01, 2019 - 16:40:01 UTC October 02, 2019 - 00:00:00 UTC   12 0 37.80511 -122.17103 4 3 1
1569951021:633826 633826 64 October 01, 2019 - 16:23:19 UTC October 01, 2019 - 19:00:00 UTC October 01, 2019 - 19:00:00 UTC 1 0 37.70669 -122.10963 4 1 5
1569951021:633862 633862 64 October 01, 2019 - 16:40:01 UTC October 02, 2019 - 00:00:00 UTC   12 0 37.80511 -122.17103 4 3 1
1569951616:633826 633826 65 October 01, 2019 - 17:28:53 UTC October 01, 2019 - 19:00:00 UTC October 01, 2019 - 19:00:00 UTC 1 0 37.70669 -122.10963 4 6 4
1569951616:633862 633862 65 October 01, 2019 - 16:40:01 UTC October 02, 2019 - 00:00:00 UTC   12 0 37.80511 -122.17103 4 3 1
1569952233:633826 633826 66 October 01, 2019 - 17:28:53 UTC October 01, 2019 - 19:00:00 UTC October 01, 2019 - 19:00:00 UTC 1 0 37.70669 -122.10963 4 6 4
1569952233:633862 633862 66 October 01, 2019 - 16:40:01 UTC October 02, 2019 - 00:00:00 UTC   12 0 37.80511 -122.17103 4 3 1
1569952839:633826 633826 67 October 01, 2019 - 17:28:53 UTC October 01, 2019 - 19:00:00 UTC October 01, 2019 - 19:00:00 UTC 1 0 37.70669 -122.10963 4 6 4
1569952839:633862 633862 67 October 01, 2019 - 16:40:01 UTC October 02, 2019 - 00:00:00 UTC   12 0 37.80511 -122.17103 4 3 1
1569953462:633826 633826 68 October 01, 2019 - 17:28:53 UTC October 01, 2019 - 19:00:00 UTC October 01, 2019 - 19:00:00 UTC 1 0 37.70669 -122.10963 4 6 4
1569953462:633862 633862 68 October 01, 2019 - 16:40:01 UTC October 02, 2019 - 00:00:00 UTC   12 0 37.80511 -122.17103 4 3 1
1569954055:633862 633862 69 October 01, 2019 - 16:40:01 UTC October 02, 2019 - 00:00:00 UTC   12 0 37.80511 -122.17103 4 3 1
1569954621:633862 633862 70 October 01, 2019 - 16:40:01 UTC October 02, 2019 - 00:00:00 UTC   12 0 37.80511 -122.17103 4 3 1
1569955253:633862 633862 71 October 01, 2019 - 16:40:01 UTC October 02, 2019 - 00:00:00 UTC   12 0 37.80511 -122.17103 4 3 1
1569955842:633862 633862 72 October 01, 2019 - 16:40:01 UTC October 02, 2019 - 00:00:00 UTC   12 0 37.80511 -122.17103 4 3 1
1569956437:633862 633862 73 October 01, 2019 - 16:40:01 UTC October 02, 2019 - 00:00:00 UTC   12 0 37.80511 -122.17103 4 3 1
1569957023:633862 633862 74 October 01, 2019 - 16:40:01 UTC October 02, 2019 - 00:00:00 UTC   12 0 37.80511 -122.17103 4 3 1
1569957630:633862 633862 75 October 01, 2019 - 16:40:01 UTC October 02, 2019 - 00:00:00 UTC   12 0 37.80511 -122.17103 4 3 1
1569958225:633862 633862 76 October 01, 2019 - 16:40:01 UTC October 02, 2019 - 00:00:00 UTC   12 0 37.80511 -122.17103 4 3 1
1569958225:634236 634236 76 October 01, 2019 - 19:21:20 UTC October 01, 2019 - 21:00:00 UTC October 01, 2019 - 21:00:00 UTC 1 0 37.74541 -122.03152 4 1 5
1569958839:633862 633862 77 October 01, 2019 - 16:40:01 UTC October 02, 2019 - 00:00:00 UTC   12 0 37.80511 -122.17103 4 3 1
1569958839:634236 634236 77 October 01, 2019 - 19:21:20 UTC October 01, 2019 - 21:00:00 UTC October 01, 2019 - 21:00:00 UTC 1 0 37.74541 -122.03152 4 1 5
1569959424:633862 633862 78 October 01, 2019 - 16:40:01 UTC October 02, 2019 - 00:00:00 UTC   12 0 37.80511 -122.17103 4 3 1
1569959424:634236 634236 78 October 01, 2019 - 19:21:20 UTC October 01, 2019 - 21:00:00 UTC October 01, 2019 - 21:00:00 UTC 1 0 37.74541 -122.03152 4 1 5
1569960023:633862 633862 79 October 01, 2019 - 16:40:01 UTC October 02, 2019 - 00:00:00 UTC   12 0 37.80511 -122.17103 4 3 1
1569960023:634236 634236 79 October 01, 2019 - 19:21:20 UTC October 01, 2019 - 21:00:00 UTC October 01, 2019 - 21:00:00 UTC 1 0 37.74541 -122.03152 4 1 5
1569960633:633862 633862 80 October 01, 2019 - 16:40:01 UTC October 02, 2019 - 00:00:00 UTC   12 0 37.80511 -122.17103 4 3 1
1569960633:634236 634236 80 October 01, 2019 - 19:21:20 UTC October 01, 2019 - 21:00:00 UTC October 01, 2019 - 21:00:00 UTC 1 0 37.74541 -122.03152 4 1 5
1569961233:633862 633862 81 October 01, 2019 - 16:40:01 UTC October 02, 2019 - 00:00:00 UTC   12 0 37.80511 -122.17103 4 3 1
1569961233:634236 634236 81 October 01, 2019 - 19:21:20 UTC October 01, 2019 - 21:00:00 UTC October 01, 2019 - 21:00:00 UTC 1 0 37.74541 -122.03152 4 1 5
1569961838:633862 633862 82 October 01, 2019 - 16:40:01 UTC October 02, 2019 - 00:00:00 UTC   12 0 37.80511 -122.17103 4 3 1
Powered by Datasette · Query took 497.844ms · About: About this site