pge-outages

Custom SQL query returning 101 rows (hide)

Query parameters

idoutagesnapshotlastUpdateTimecurrentEtorautoEtorestCustAffectedhazardFlaglatitudelongituderegionNamecausecrewCurrentStatus
1575487943:729731 729731 8888 December 04, 2019 - 19:25:58 UTC December 04, 2019 - 22:30:00 UTC December 04, 2019 - 22:30:00 UTC 1 1 37.62908 -121.94661 80 1 1
1575488546:729731 729731 8889 December 04, 2019 - 19:36:08 UTC December 04, 2019 - 22:30:00 UTC December 04, 2019 - 22:30:00 UTC 1 1 37.62908 -121.94661 80 1 1
1575489212:729731 729731 8890 December 04, 2019 - 19:38:47 UTC December 04, 2019 - 22:30:00 UTC December 04, 2019 - 22:30:00 UTC 1 1 37.62908 -121.94661 80 1 5
1575489770:729731 729731 8891 December 04, 2019 - 19:38:47 UTC December 04, 2019 - 22:30:00 UTC December 04, 2019 - 22:30:00 UTC 1 1 37.62908 -121.94661 80 1 5
1575490244:729731 729731 8892 December 04, 2019 - 19:38:47 UTC December 04, 2019 - 22:30:00 UTC December 04, 2019 - 22:30:00 UTC 1 1 37.62908 -121.94661 80 1 5
1575491430:729731 729731 8893 December 04, 2019 - 19:38:47 UTC December 04, 2019 - 22:30:00 UTC December 04, 2019 - 22:30:00 UTC 1 1 37.62908 -121.94661 80 1 5
1575492016:729731 729731 8894 December 04, 2019 - 19:38:47 UTC December 04, 2019 - 22:30:00 UTC December 04, 2019 - 22:30:00 UTC 1 1 37.62908 -121.94661 80 1 5
1575492689:729731 729731 8895 December 04, 2019 - 19:38:47 UTC December 04, 2019 - 22:30:00 UTC December 04, 2019 - 22:30:00 UTC 1 1 37.62908 -121.94661 80 1 5
1575493257:729731 729731 8896 December 04, 2019 - 20:53:39 UTC December 04, 2019 - 22:30:00 UTC December 04, 2019 - 22:30:00 UTC 1 1 37.62908 -121.94661 80 6 4
1575493816:729731 729731 8897 December 04, 2019 - 20:53:39 UTC December 04, 2019 - 22:30:00 UTC December 04, 2019 - 22:30:00 UTC 1 1 37.62908 -121.94661 80 6 4
1575494417:729731 729731 8898 December 04, 2019 - 20:53:39 UTC December 04, 2019 - 22:30:00 UTC December 04, 2019 - 22:30:00 UTC 1 1 37.62908 -121.94661 80 6 4
1575495030:729731 729731 8899 December 04, 2019 - 20:53:39 UTC December 04, 2019 - 22:30:00 UTC December 04, 2019 - 22:30:00 UTC 1 1 37.62908 -121.94661 80 6 4
1575495637:729731 729731 8900 December 04, 2019 - 20:53:39 UTC December 04, 2019 - 22:30:00 UTC December 04, 2019 - 22:30:00 UTC 1 1 37.62908 -121.94661 80 6 4
1575496240:729731 729731 8901 December 04, 2019 - 20:53:39 UTC December 04, 2019 - 22:30:00 UTC December 04, 2019 - 22:30:00 UTC 1 1 37.62908 -121.94661 80 6 4
1575653424:731319 731319 9162 December 06, 2019 - 17:24:40 UTC December 06, 2019 - 20:30:00 UTC December 06, 2019 - 20:30:00 UTC 1 1 37.62908 -121.94661 80 1 1
1575654027:731319 731319 9163 December 06, 2019 - 17:24:40 UTC December 06, 2019 - 20:30:00 UTC December 06, 2019 - 20:30:00 UTC 1 1 37.62908 -121.94661 80 1 1
1575654621:731319 731319 9164 December 06, 2019 - 17:24:40 UTC December 06, 2019 - 20:30:00 UTC December 06, 2019 - 20:30:00 UTC 1 1 37.62908 -121.94661 80 1 1
1575655238:731319 731319 9165 December 06, 2019 - 17:24:40 UTC December 06, 2019 - 20:30:00 UTC December 06, 2019 - 20:30:00 UTC 1 1 37.62908 -121.94661 80 1 5
1575655825:731319 731319 9166 December 06, 2019 - 17:24:40 UTC December 06, 2019 - 20:30:00 UTC December 06, 2019 - 20:30:00 UTC 1 1 37.62908 -121.94661 80 1 5
1575656422:731319 731319 9167 December 06, 2019 - 17:24:40 UTC December 06, 2019 - 20:30:00 UTC December 06, 2019 - 20:30:00 UTC 1 1 37.62908 -121.94661 80 1 5
1575657039:731319 731319 9168 December 06, 2019 - 17:24:40 UTC December 06, 2019 - 20:30:00 UTC December 06, 2019 - 20:30:00 UTC 1 1 37.62908 -121.94661 80 1 5
1575657619:731319 731319 9169 December 06, 2019 - 17:24:40 UTC December 06, 2019 - 20:30:00 UTC December 06, 2019 - 20:30:00 UTC 1 1 37.62908 -121.94661 80 1 5
1575658220:731319 731319 9170 December 06, 2019 - 18:44:49 UTC December 06, 2019 - 20:30:00 UTC December 06, 2019 - 20:30:00 UTC 1 1 37.62908 -121.94661 80 6 4
1575658834:731319 731319 9171 December 06, 2019 - 18:44:49 UTC December 06, 2019 - 20:30:00 UTC December 06, 2019 - 20:30:00 UTC 1 1 37.62908 -121.94661 80 6 4
1575659418:731319 731319 9172 December 06, 2019 - 18:44:49 UTC December 06, 2019 - 20:30:00 UTC December 06, 2019 - 20:30:00 UTC 1 1 37.62908 -121.94661 80 6 4
1575660029:731319 731319 9173 December 06, 2019 - 18:44:49 UTC December 06, 2019 - 20:30:00 UTC December 06, 2019 - 20:30:00 UTC 1 1 37.62908 -121.94661 80 6 4
1575660631:731319 731319 9174 December 06, 2019 - 18:44:49 UTC December 06, 2019 - 20:30:00 UTC December 06, 2019 - 20:30:00 UTC 1 1 37.62908 -121.94661 80 6 4
1575661223:731319 731319 9175 December 06, 2019 - 18:44:49 UTC December 06, 2019 - 20:30:00 UTC December 06, 2019 - 20:30:00 UTC 1 1 37.62908 -121.94661 80 6 4
1575661824:731319 731319 9176 December 06, 2019 - 18:44:49 UTC December 06, 2019 - 20:30:00 UTC December 06, 2019 - 20:30:00 UTC 1 1 37.62908 -121.94661 80 6 4
1575662445:731319 731319 9177 December 06, 2019 - 18:44:49 UTC December 06, 2019 - 20:30:00 UTC December 06, 2019 - 20:30:00 UTC 1 1 37.62908 -121.94661 80 6 4
1575663045:731319 731319 9178 December 06, 2019 - 18:44:49 UTC December 06, 2019 - 20:30:00 UTC December 06, 2019 - 20:30:00 UTC 1 1 37.62908 -121.94661 80 6 4
1576608025:744446 744446 10748 December 17, 2019 - 18:32:47 UTC December 17, 2019 - 21:45:00 UTC December 17, 2019 - 21:45:00 UTC 1 0 37.62932 -121.94744 80 1 1
1576608619:744446 744446 10749 December 17, 2019 - 18:32:47 UTC December 17, 2019 - 21:45:00 UTC December 17, 2019 - 21:45:00 UTC 1 0 37.62932 -121.94744 80 1 1
1576609239:744446 744446 10750 December 17, 2019 - 18:32:47 UTC December 17, 2019 - 21:45:00 UTC December 17, 2019 - 21:45:00 UTC 1 0 37.62932 -121.94744 80 1 1
1576609844:744446 744446 10751 December 17, 2019 - 18:32:47 UTC December 17, 2019 - 21:45:00 UTC December 17, 2019 - 21:45:00 UTC 1 0 37.62932 -121.94744 80 1 1
1576610420:744446 744446 10752 December 17, 2019 - 19:11:30 UTC December 18, 2019 - 03:11:00 UTC   1 0 37.62932 -121.94744 80 1 1
1576611030:744446 744446 10753 December 17, 2019 - 19:11:30 UTC December 18, 2019 - 03:11:00 UTC   1 0 37.62932 -121.94744 80 1 1
1576611649:744446 744446 10754 December 17, 2019 - 19:11:30 UTC December 18, 2019 - 03:11:00 UTC   1 0 37.62932 -121.94744 80 1 1
1576612245:744446 744446 10755 December 17, 2019 - 19:11:30 UTC December 18, 2019 - 03:11:00 UTC   1 0 37.62932 -121.94744 80 1 1
1576612833:744446 744446 10756 December 17, 2019 - 19:11:30 UTC December 18, 2019 - 03:11:00 UTC   1 0 37.62932 -121.94744 80 1 1
1576613441:744446 744446 10757 December 17, 2019 - 19:11:30 UTC December 18, 2019 - 03:11:00 UTC   1 0 37.62932 -121.94744 80 1 1
1576614013:744446 744446 10758 December 17, 2019 - 19:11:30 UTC December 18, 2019 - 03:11:00 UTC   1 0 37.62932 -121.94744 80 1 1
1576614622:744446 744446 10759 December 17, 2019 - 19:11:30 UTC December 18, 2019 - 03:11:00 UTC   1 0 37.62932 -121.94744 80 1 1
1576615215:744446 744446 10760 December 17, 2019 - 19:11:30 UTC December 18, 2019 - 03:11:00 UTC   1 0 37.62932 -121.94744 80 1 1
1576615828:744446 744446 10761 December 17, 2019 - 19:11:30 UTC December 18, 2019 - 03:11:00 UTC   1 0 37.62932 -121.94744 80 1 1
1576616416:744446 744446 10762 December 17, 2019 - 19:11:30 UTC December 18, 2019 - 03:11:00 UTC   1 0 37.62932 -121.94744 80 1 5
1576617030:744446 744446 10763 December 17, 2019 - 19:11:30 UTC December 18, 2019 - 03:11:00 UTC   1 0 37.62932 -121.94744 80 1 5
1576617619:744446 744446 10764 December 17, 2019 - 19:11:30 UTC December 18, 2019 - 03:11:00 UTC   1 0 37.62932 -121.94744 80 1 5
1576618221:744446 744446 10765 December 17, 2019 - 19:11:30 UTC December 18, 2019 - 03:11:00 UTC   1 0 37.62932 -121.94744 80 1 5
1576618833:744446 744446 10766 December 17, 2019 - 19:11:30 UTC December 18, 2019 - 03:11:00 UTC   1 0 37.62932 -121.94744 80 1 5
1576619418:744446 744446 10767 December 17, 2019 - 19:11:30 UTC December 18, 2019 - 03:11:00 UTC   1 0 37.62932 -121.94744 80 1 5
1576620035:744446 744446 10768 December 17, 2019 - 19:11:30 UTC December 18, 2019 - 03:11:00 UTC   1 0 37.62932 -121.94744 80 1 5
1576620634:744446 744446 10769 December 17, 2019 - 19:11:30 UTC December 18, 2019 - 03:11:00 UTC   1 0 37.62932 -121.94744 80 1 5
1600064997:1067470 1067470 12751 September 14, 2020 - 06:22:56 UTC September 14, 2020 - 09:15:00 UTC September 14, 2020 - 09:15:00 UTC 1 0 37.59208 -121.95656 80 1 1
1600065417:1067470 1067470 12752 September 14, 2020 - 06:34:15 UTC September 14, 2020 - 09:15:00 UTC September 14, 2020 - 09:15:00 UTC 1 0 37.59208 -121.95656 80 1 1
1600065981:1067470 1067470 12753 September 14, 2020 - 06:34:15 UTC September 14, 2020 - 09:15:00 UTC September 14, 2020 - 09:15:00 UTC 1 0 37.59208 -121.95656 80 1 1
1600066589:1067470 1067470 12754 September 14, 2020 - 06:34:15 UTC September 14, 2020 - 09:15:00 UTC September 14, 2020 - 09:15:00 UTC 1 0 37.59208 -121.95656 80 1 1
1600067988:1067470 1067470 12755 September 14, 2020 - 06:34:15 UTC September 14, 2020 - 09:15:00 UTC September 14, 2020 - 09:15:00 UTC 1 0 37.59208 -121.95656 80 1 1
1572211217:689318 689318 3612 October 27, 2019 - 21:12:37 UTC     1 0 37.59254 -122.00291 80 1 1
1572211828:689318 689318 3613 October 27, 2019 - 21:12:37 UTC     1 0 37.59254 -122.00291 80 1 1
1572212416:689318 689318 3614 October 27, 2019 - 21:12:37 UTC     1 0 37.59254 -122.00291 80 1 1
1572213020:689318 689318 3615 October 27, 2019 - 21:12:37 UTC     1 0 37.59254 -122.00291 80 1 1
1572213622:689318 689318 3616 October 27, 2019 - 21:12:37 UTC     1 0 37.59254 -122.00291 80 1 1
1572210621:689259 689259 3611 October 27, 2019 - 21:04:28 UTC     1 0 37.593 -122.00594 80 1 1
1572211217:689259 689259 3612 October 27, 2019 - 21:04:28 UTC     1 0 37.593 -122.00594 80 1 1
1572211828:689259 689259 3613 October 27, 2019 - 21:04:28 UTC     1 0 37.593 -122.00594 80 1 1
1572212416:689259 689259 3614 October 27, 2019 - 21:04:28 UTC     1 0 37.593 -122.00594 80 1 1
1572213020:689259 689259 3615 October 27, 2019 - 21:04:28 UTC     1 0 37.593 -122.00594 80 1 1
1572213622:689259 689259 3616 October 27, 2019 - 21:04:28 UTC     1 0 37.593 -122.00594 80 1 1
1572214818:689259 689259 3617 October 27, 2019 - 21:04:28 UTC     1 0 37.593 -122.00594 80 1 1
1572215421:689259 689259 3618 October 27, 2019 - 21:04:28 UTC     1 0 37.593 -122.00594 80 1 1
1572216018:689259 689259 3619 October 27, 2019 - 21:04:28 UTC     1 0 37.593 -122.00594 80 1 1
1572216627:689259 689259 3620 October 27, 2019 - 21:04:28 UTC     1 0 37.593 -122.00594 80 1 1
1572217226:689259 689259 3621 October 27, 2019 - 21:04:28 UTC     1 0 37.593 -122.00594 80 1 1
1572217823:689259 689259 3622 October 27, 2019 - 21:04:28 UTC     1 0 37.593 -122.00594 80 1 1
1572218422:689259 689259 3623 October 27, 2019 - 21:04:28 UTC     1 0 37.593 -122.00594 80 1 1
1572219023:689259 689259 3624 October 27, 2019 - 21:04:28 UTC     1 0 37.593 -122.00594 80 1 1
1572219634:689259 689259 3625 October 27, 2019 - 21:04:28 UTC     1 0 37.593 -122.00594 80 1 1
1572220252:689259 689259 3626 October 27, 2019 - 21:04:28 UTC     1 0 37.593 -122.00594 80 1 1
1572220830:689259 689259 3627 October 27, 2019 - 21:04:28 UTC     1 0 37.593 -122.00594 80 1 1
1572221431:689259 689259 3628 October 27, 2019 - 21:04:28 UTC     1 0 37.593 -122.00594 80 1 1
1572214818:689318 689318 3617 October 27, 2019 - 22:03:50 UTC     282 0 37.59414 -122.00692 80 1 1
1572215421:689318 689318 3618 October 27, 2019 - 22:25:18 UTC     282 0 37.59414 -122.00692 80 1 1
1572216018:689318 689318 3619 October 27, 2019 - 22:25:18 UTC     282 0 37.59414 -122.00692 80 1 1
1572216627:689318 689318 3620 October 27, 2019 - 22:25:18 UTC     282 0 37.59414 -122.00692 80 1 1
1572217226:689318 689318 3621 October 27, 2019 - 22:44:22 UTC     282 0 37.59414 -122.00692 80 1 1
1572217823:689318 689318 3622 October 27, 2019 - 22:44:22 UTC     282 0 37.59414 -122.00692 80 1 1
1572218422:689318 689318 3623 October 27, 2019 - 23:08:17 UTC     282 0 37.59414 -122.00692 80 1 5
1572219023:689318 689318 3624 October 27, 2019 - 23:24:10 UTC     282 0 37.59414 -122.00692 80 1 5
1572219634:689318 689318 3625 October 27, 2019 - 23:32:16 UTC     282 0 37.59414 -122.00692 80 1 5
1572220252:689318 689318 3626 October 27, 2019 - 23:32:16 UTC     282 0 37.59414 -122.00692 80 1 5
1572220830:689318 689318 3627 October 27, 2019 - 23:32:16 UTC     282 0 37.59414 -122.00692 80 1 5
1572221431:689318 689318 3628 October 27, 2019 - 23:52:38 UTC     282 0 37.59414 -122.00692 80 6 4
1572222042:689318 689318 3629 October 28, 2019 - 00:09:39 UTC     282 0 37.59414 -122.00692 80 6 4
1572388221:694249 694249 3854 October 29, 2019 - 22:14:05 UTC     1 1 37.59447 -122.00766 80 1 1
1572388818:694249 694249 3855 October 29, 2019 - 22:14:05 UTC     1 1 37.59447 -122.00766 80 1 1
1572390040:694249 694249 3856 October 29, 2019 - 22:50:16 UTC October 30, 2019 - 01:00:00 UTC   1 1 37.59447 -122.00766 80 1 5
1572390631:694249 694249 3857 October 29, 2019 - 22:50:16 UTC October 30, 2019 - 01:00:00 UTC   1 1 37.59447 -122.00766 80 1 5
1572391222:694249 694249 3858 October 29, 2019 - 22:50:16 UTC October 30, 2019 - 01:00:00 UTC   1 1 37.59447 -122.00766 80 1 5
1572392423:694249 694249 3859 October 29, 2019 - 23:24:22 UTC October 30, 2019 - 01:00:00 UTC   1 1 37.59447 -122.00766 80 6 4
1572393021:694249 694249 3860 October 29, 2019 - 23:24:22 UTC October 30, 2019 - 01:00:00 UTC   1 1 37.59447 -122.00766 80 6 4
Powered by Datasette · Query took 503.638ms · About: About this site