pge-outages

Custom SQL query returning 101 rows (hide)

Query parameters

idoutagesnapshotlastUpdateTimecurrentEtorautoEtorestCustAffectedhazardFlaglatitudelongituderegionNamecausecrewCurrentStatus
1569913215:633433 633433 1 October 01, 2019 - 05:33:16 UTC October 01, 2019 - 19:00:00 UTC   1 0 38.65738 -121.77805 34 2 3
1569913838:633433 633433 2 October 01, 2019 - 05:33:16 UTC October 01, 2019 - 19:00:00 UTC   1 0 38.65738 -121.77805 34 2 3
1569914414:633433 633433 3 October 01, 2019 - 05:33:16 UTC October 01, 2019 - 19:00:00 UTC   1 0 38.65738 -121.77805 34 2 3
1569915019:633433 633433 4 October 01, 2019 - 05:33:16 UTC October 01, 2019 - 19:00:00 UTC   1 0 38.65738 -121.77805 34 2 3
1569915624:633433 633433 5 October 01, 2019 - 05:33:16 UTC October 01, 2019 - 19:00:00 UTC   1 0 38.65738 -121.77805 34 2 3
1569916231:633433 633433 6 October 01, 2019 - 07:41:30 UTC October 01, 2019 - 19:00:00 UTC   1 0 38.65738 -121.77805 34 2 3
1569916815:633433 633433 7 October 01, 2019 - 07:41:30 UTC October 01, 2019 - 19:00:00 UTC   1 0 38.65738 -121.77805 34 2 3
1569917417:633433 633433 8 October 01, 2019 - 07:41:30 UTC October 01, 2019 - 19:00:00 UTC   1 0 38.65738 -121.77805 34 2 3
1569918012:633433 633433 9 October 01, 2019 - 07:41:30 UTC October 01, 2019 - 19:00:00 UTC   1 0 38.65738 -121.77805 34 2 3
1569918645:633433 633433 10 October 01, 2019 - 07:41:30 UTC October 01, 2019 - 19:00:00 UTC   1 0 38.65738 -121.77805 34 2 3
1569919223:633433 633433 11 October 01, 2019 - 07:41:30 UTC October 01, 2019 - 19:00:00 UTC   1 0 38.65738 -121.77805 34 2 3
1569919823:633433 633433 12 October 01, 2019 - 07:41:30 UTC October 01, 2019 - 19:00:00 UTC   1 0 38.65738 -121.77805 34 2 3
1569920421:633433 633433 13 October 01, 2019 - 07:41:30 UTC October 01, 2019 - 19:00:00 UTC   1 0 38.65738 -121.77805 34 2 3
1569921023:633433 633433 14 October 01, 2019 - 07:41:30 UTC October 01, 2019 - 19:00:00 UTC   1 0 38.65738 -121.77805 34 2 3
1569921618:633433 633433 15 October 01, 2019 - 07:41:30 UTC October 01, 2019 - 19:00:00 UTC   1 0 38.65738 -121.77805 34 2 3
1569922217:633433 633433 16 October 01, 2019 - 07:41:30 UTC October 01, 2019 - 19:00:00 UTC   1 0 38.65738 -121.77805 34 2 3
1569922813:633433 633433 17 October 01, 2019 - 07:41:30 UTC October 01, 2019 - 19:00:00 UTC   1 0 38.65738 -121.77805 34 2 3
1569923412:633433 633433 18 October 01, 2019 - 07:41:30 UTC October 01, 2019 - 19:00:00 UTC   1 0 38.65738 -121.77805 34 2 3
1569924030:633433 633433 19 October 01, 2019 - 07:41:30 UTC October 01, 2019 - 19:00:00 UTC   1 0 38.65738 -121.77805 34 2 3
1569924614:633433 633433 20 October 01, 2019 - 07:41:30 UTC October 01, 2019 - 19:00:00 UTC   1 0 38.65738 -121.77805 34 2 3
1569925218:633433 633433 21 October 01, 2019 - 07:41:30 UTC October 01, 2019 - 19:00:00 UTC   1 0 38.65738 -121.77805 34 2 3
1569925819:633433 633433 22 October 01, 2019 - 07:41:30 UTC October 01, 2019 - 19:00:00 UTC   1 0 38.65738 -121.77805 34 2 3
1569926413:633433 633433 23 October 01, 2019 - 07:41:30 UTC October 01, 2019 - 19:00:00 UTC   1 0 38.65738 -121.77805 34 2 3
1569927022:633433 633433 24 October 01, 2019 - 07:41:30 UTC October 01, 2019 - 19:00:00 UTC   1 0 38.65738 -121.77805 34 2 3
1569927620:633433 633433 25 October 01, 2019 - 07:41:30 UTC October 01, 2019 - 19:00:00 UTC   1 0 38.65738 -121.77805 34 2 3
1569928219:633433 633433 26 October 01, 2019 - 07:41:30 UTC October 01, 2019 - 19:00:00 UTC   1 0 38.65738 -121.77805 34 2 3
1569928810:633433 633433 27 October 01, 2019 - 07:41:30 UTC October 01, 2019 - 19:00:00 UTC   1 0 38.65738 -121.77805 34 2 3
1569929414:633433 633433 28 October 01, 2019 - 07:41:30 UTC October 01, 2019 - 19:00:00 UTC   1 0 38.65738 -121.77805 34 2 3
1569930017:633433 633433 29 October 01, 2019 - 07:41:30 UTC October 01, 2019 - 19:00:00 UTC   1 0 38.65738 -121.77805 34 2 3
1569930614:633433 633433 30 October 01, 2019 - 07:41:30 UTC October 01, 2019 - 19:00:00 UTC   1 0 38.65738 -121.77805 34 2 3
1569931217:633433 633433 31 October 01, 2019 - 07:41:30 UTC October 01, 2019 - 19:00:00 UTC   1 0 38.65738 -121.77805 34 2 3
1569931817:633433 633433 32 October 01, 2019 - 07:41:30 UTC October 01, 2019 - 19:00:00 UTC   1 0 38.65738 -121.77805 34 2 3
1569932416:633433 633433 33 October 01, 2019 - 07:41:30 UTC October 01, 2019 - 19:00:00 UTC   1 0 38.65738 -121.77805 34 2 3
1569933016:633433 633433 34 October 01, 2019 - 07:41:30 UTC October 01, 2019 - 19:00:00 UTC   1 0 38.65738 -121.77805 34 2 3
1569933610:633433 633433 35 October 01, 2019 - 07:41:30 UTC October 01, 2019 - 19:00:00 UTC   1 0 38.65738 -121.77805 34 2 3
1569934216:633433 633433 36 October 01, 2019 - 07:41:30 UTC October 01, 2019 - 19:00:00 UTC   1 0 38.65738 -121.77805 34 2 3
1569934854:633433 633433 37 October 01, 2019 - 07:41:30 UTC October 01, 2019 - 19:00:00 UTC   1 0 38.65738 -121.77805 34 2 3
1569935427:633433 633433 38 October 01, 2019 - 07:41:30 UTC October 01, 2019 - 19:00:00 UTC   1 0 38.65738 -121.77805 34 2 3
1569936025:633433 633433 39 October 01, 2019 - 07:41:30 UTC October 01, 2019 - 19:00:00 UTC   1 0 38.65738 -121.77805 34 2 3
1569936639:633433 633433 40 October 01, 2019 - 07:41:30 UTC October 01, 2019 - 19:00:00 UTC   1 0 38.65738 -121.77805 34 2 3
1569937220:633433 633433 41 October 01, 2019 - 07:41:30 UTC October 01, 2019 - 19:00:00 UTC   1 0 38.65738 -121.77805 34 2 3
1569937820:633433 633433 42 October 01, 2019 - 07:41:30 UTC October 01, 2019 - 19:00:00 UTC   1 0 38.65738 -121.77805 34 2 3
1569938467:633433 633433 43 October 01, 2019 - 07:41:30 UTC October 01, 2019 - 19:00:00 UTC   1 0 38.65738 -121.77805 34 2 3
1569939021:633433 633433 44 October 01, 2019 - 14:03:16 UTC October 01, 2019 - 19:00:00 UTC   1 0 38.65738 -121.77805 34 2 3
1569939629:633433 633433 45 October 01, 2019 - 14:03:16 UTC October 01, 2019 - 19:00:00 UTC   1 0 38.65738 -121.77805 34 2 3
1569940220:633433 633433 46 October 01, 2019 - 14:03:16 UTC October 01, 2019 - 19:00:00 UTC   1 0 38.65738 -121.77805 34 2 3
1569940220:633574 633574 46 October 01, 2019 - 14:24:06 UTC October 01, 2019 - 18:00:00 UTC October 01, 2019 - 18:00:00 UTC 1 0 38.72937 -121.782 34 1 1
1569940818:633433 633433 47 October 01, 2019 - 14:03:16 UTC October 01, 2019 - 19:00:00 UTC   1 0 38.65738 -121.77805 34 2 3
1569940818:633574 633574 47 October 01, 2019 - 14:24:06 UTC October 01, 2019 - 18:00:00 UTC October 01, 2019 - 18:00:00 UTC 1 0 38.72937 -121.782 34 1 1
1569940818:633582 633582 47 October 01, 2019 - 14:35:13 UTC October 01, 2019 - 18:00:00 UTC October 01, 2019 - 18:00:00 UTC 1 0 38.72181 -121.83119 34 1 1
1569941431:633433 633433 48 October 01, 2019 - 14:03:16 UTC October 01, 2019 - 19:00:00 UTC   1 0 38.65738 -121.77805 34 2 3
1569941431:633574 633574 48 October 01, 2019 - 14:24:06 UTC October 01, 2019 - 18:00:00 UTC October 01, 2019 - 18:00:00 UTC 1 0 38.72937 -121.782 34 1 1
1569941431:633582 633582 48 October 01, 2019 - 14:36:43 UTC October 01, 2019 - 18:00:00 UTC October 01, 2019 - 18:00:00 UTC 1 0 38.72181 -121.83119 34 1 1
1569942021:633433 633433 49 October 01, 2019 - 14:03:16 UTC October 01, 2019 - 19:00:00 UTC   1 0 38.65738 -121.77805 34 2 3
1569942021:633574 633574 49 October 01, 2019 - 14:24:06 UTC October 01, 2019 - 18:00:00 UTC October 01, 2019 - 18:00:00 UTC 1 0 38.72937 -121.782 34 1 5
1569942021:633582 633582 49 October 01, 2019 - 14:36:43 UTC October 01, 2019 - 18:00:00 UTC October 01, 2019 - 18:00:00 UTC 1 0 38.72181 -121.83119 34 1 1
1569942620:633433 633433 50 October 01, 2019 - 14:03:16 UTC October 01, 2019 - 19:00:00 UTC   1 0 38.65738 -121.77805 34 2 3
1569942620:633574 633574 50 October 01, 2019 - 14:24:06 UTC October 01, 2019 - 18:00:00 UTC October 01, 2019 - 18:00:00 UTC 1 0 38.72937 -121.782 34 1 5
1569942620:633582 633582 50 October 01, 2019 - 14:36:43 UTC October 01, 2019 - 18:00:00 UTC October 01, 2019 - 18:00:00 UTC 1 0 38.72181 -121.83119 34 1 1
1569943255:633433 633433 51 October 01, 2019 - 14:03:16 UTC October 01, 2019 - 19:00:00 UTC   1 0 38.65738 -121.77805 34 2 3
1569943255:633574 633574 51 October 01, 2019 - 14:24:06 UTC October 01, 2019 - 18:00:00 UTC October 01, 2019 - 18:00:00 UTC 1 0 38.72937 -121.782 34 1 5
1569943255:633582 633582 51 October 01, 2019 - 14:36:43 UTC October 01, 2019 - 18:00:00 UTC October 01, 2019 - 18:00:00 UTC 1 0 38.72181 -121.83119 34 1 1
1569943834:633433 633433 52 October 01, 2019 - 14:03:16 UTC October 01, 2019 - 19:00:00 UTC   1 0 38.65738 -121.77805 34 2 3
1569943834:633574 633574 52 October 01, 2019 - 14:24:06 UTC October 01, 2019 - 18:00:00 UTC October 01, 2019 - 18:00:00 UTC 1 0 38.72937 -121.782 34 1 5
1569943834:633582 633582 52 October 01, 2019 - 14:36:43 UTC October 01, 2019 - 18:00:00 UTC October 01, 2019 - 18:00:00 UTC 1 0 38.72181 -121.83119 34 1 1
1569944417:633433 633433 53 October 01, 2019 - 14:03:16 UTC October 01, 2019 - 19:00:00 UTC   1 0 38.65738 -121.77805 34 2 3
1569944417:633574 633574 53 October 01, 2019 - 15:22:59 UTC October 01, 2019 - 18:00:00 UTC October 01, 2019 - 18:00:00 UTC 1 0 38.72937 -121.782 34 6 4
1569944417:633582 633582 53 October 01, 2019 - 14:36:43 UTC October 01, 2019 - 18:00:00 UTC October 01, 2019 - 18:00:00 UTC 1 0 38.72181 -121.83119 34 1 1
1569945023:633433 633433 54 October 01, 2019 - 14:03:16 UTC October 01, 2019 - 19:00:00 UTC   1 0 38.65738 -121.77805 34 2 3
1569945023:633582 633582 54 October 01, 2019 - 14:36:43 UTC October 01, 2019 - 18:00:00 UTC October 01, 2019 - 18:00:00 UTC 1 0 38.72181 -121.83119 34 1 5
1569945622:633433 633433 55 October 01, 2019 - 14:03:16 UTC October 01, 2019 - 19:00:00 UTC   1 0 38.65738 -121.77805 34 2 3
1569945622:633582 633582 55 October 01, 2019 - 14:36:43 UTC October 01, 2019 - 18:00:00 UTC October 01, 2019 - 18:00:00 UTC 1 0 38.72181 -121.83119 34 1 5
1569946235:633433 633433 56 October 01, 2019 - 14:03:16 UTC October 01, 2019 - 19:00:00 UTC   1 0 38.65738 -121.77805 34 2 3
1569946235:633582 633582 56 October 01, 2019 - 14:36:43 UTC October 01, 2019 - 18:00:00 UTC October 01, 2019 - 18:00:00 UTC 1 0 38.72181 -121.83119 34 1 5
1569946828:633433 633433 57 October 01, 2019 - 14:03:16 UTC October 01, 2019 - 19:00:00 UTC   1 0 38.65738 -121.77805 34 2 3
1569946828:633582 633582 57 October 01, 2019 - 16:13:57 UTC October 01, 2019 - 18:00:00 UTC October 01, 2019 - 18:00:00 UTC 1 0 38.72181 -121.83119 34 6 4
1569947434:633433 633433 58 October 01, 2019 - 14:03:16 UTC October 01, 2019 - 19:00:00 UTC   1 0 38.65738 -121.77805 34 2 3
1569947434:633582 633582 58 October 01, 2019 - 16:13:57 UTC October 01, 2019 - 18:00:00 UTC October 01, 2019 - 18:00:00 UTC 1 0 38.72181 -121.83119 34 6 4
1569948031:633433 633433 59 October 01, 2019 - 14:03:16 UTC October 01, 2019 - 19:00:00 UTC   1 0 38.65738 -121.77805 34 2 7
1569948031:633582 633582 59 October 01, 2019 - 16:13:57 UTC October 01, 2019 - 18:00:00 UTC October 01, 2019 - 18:00:00 UTC 1 0 38.72181 -121.83119 34 6 4
1569948634:633433 633433 60 October 01, 2019 - 14:03:16 UTC October 01, 2019 - 19:00:00 UTC   1 0 38.65738 -121.77805 34 2 7
1569948634:633582 633582 60 October 01, 2019 - 16:13:57 UTC October 01, 2019 - 18:00:00 UTC October 01, 2019 - 18:00:00 UTC 1 0 38.72181 -121.83119 34 6 4
1569949236:633433 633433 61 October 01, 2019 - 14:03:16 UTC October 01, 2019 - 19:00:00 UTC   1 0 38.65738 -121.77805 34 2 7
1569949236:633582 633582 61 October 01, 2019 - 16:48:19 UTC October 01, 2019 - 18:00:00 UTC October 01, 2019 - 18:00:00 UTC 1 0 38.72181 -121.83119 34 6 3
1569949236:633882 633882 61 October 01, 2019 - 16:52:42 UTC October 02, 2019 - 00:00:00 UTC   1 0 38.69174 -121.75947 34 3 1
1569949829:633433 633433 62 October 01, 2019 - 14:03:16 UTC October 01, 2019 - 19:00:00 UTC   1 0 38.65738 -121.77805 34 2 7
1569949829:633582 633582 62 October 01, 2019 - 16:48:19 UTC October 01, 2019 - 18:00:00 UTC October 01, 2019 - 18:00:00 UTC 1 0 38.72181 -121.83119 34 6 3
1569949829:633882 633882 62 October 01, 2019 - 16:52:42 UTC October 02, 2019 - 00:00:00 UTC   1 0 38.69174 -121.75947 34 3 1
1569950417:633433 633433 63 October 01, 2019 - 14:03:16 UTC October 01, 2019 - 19:00:00 UTC   1 0 38.65738 -121.77805 34 2 7
1569950417:633582 633582 63 October 01, 2019 - 16:48:19 UTC October 01, 2019 - 18:00:00 UTC October 01, 2019 - 18:00:00 UTC 1 0 38.72181 -121.83119 34 6 3
1569950417:633882 633882 63 October 01, 2019 - 16:52:42 UTC October 02, 2019 - 00:00:00 UTC   1 0 38.69174 -121.75947 34 3 1
1569951021:633433 633433 64 October 01, 2019 - 17:19:15 UTC October 01, 2019 - 19:00:00 UTC   1 0 38.65738 -121.77805 34 2 3
1569951021:633582 633582 64 October 01, 2019 - 16:48:19 UTC October 01, 2019 - 18:00:00 UTC October 01, 2019 - 18:00:00 UTC 1 0 38.72181 -121.83119 34 6 3
1569951021:633882 633882 64 October 01, 2019 - 16:52:42 UTC October 02, 2019 - 00:00:00 UTC   1 0 38.69174 -121.75947 34 3 1
1569951616:633433 633433 65 October 01, 2019 - 17:19:15 UTC October 01, 2019 - 19:00:00 UTC   1 0 38.65738 -121.77805 34 2 3
1569951616:633582 633582 65 October 01, 2019 - 17:35:18 UTC October 02, 2019 - 01:33:00 UTC   1 0 38.72181 -121.83119 34 2 3
1569951616:633882 633882 65 October 01, 2019 - 16:52:42 UTC October 02, 2019 - 00:00:00 UTC   1 0 38.69174 -121.75947 34 3 1
1569952233:633433 633433 66 October 01, 2019 - 17:19:15 UTC October 01, 2019 - 19:00:00 UTC   1 0 38.65738 -121.77805 34 2 3
1569952233:633582 633582 66 October 01, 2019 - 17:35:18 UTC October 02, 2019 - 01:33:00 UTC   1 0 38.72181 -121.83119 34 2 3
1569952233:633882 633882 66 October 01, 2019 - 16:52:42 UTC October 02, 2019 - 00:00:00 UTC   1 0 38.69174 -121.75947 34 3 1
1569952839:633433 633433 67 October 01, 2019 - 17:53:25 UTC October 01, 2019 - 19:00:00 UTC   1 0 38.65738 -121.77805 34 2 3
Powered by Datasette · Query took 3.296ms · About: About this site