pge-outages

Custom SQL query returning 101 rows (hide)

Query parameters

idoutagesnapshotlastUpdateTimecurrentEtorautoEtorestCustAffectedhazardFlaglatitudelongituderegionNamecausecrewCurrentStatus
1569930017:633524 633524 29 October 01, 2019 - 11:35:59 UTC October 01, 2019 - 14:45:00 UTC October 01, 2019 - 14:45:00 UTC 94 0 37.29081 -121.95834 43 1 1
1569930017:633526 633526 29 October 01, 2019 - 11:28:16 UTC October 01, 2019 - 14:45:00 UTC October 01, 2019 - 14:45:00 UTC 1 1 37.29066 -121.95854 43 1 1
1569930017:633528 633528 29 October 01, 2019 - 11:31:59 UTC October 01, 2019 - 14:45:00 UTC October 01, 2019 - 14:45:00 UTC 1 1 37.29 -121.9594 43 1 1
1569930614:633524 633524 30 October 01, 2019 - 11:38:29 UTC October 01, 2019 - 14:45:00 UTC October 01, 2019 - 14:45:00 UTC 94 0 37.29081 -121.95834 43 1 1
1569930614:633526 633526 30 October 01, 2019 - 11:28:16 UTC October 01, 2019 - 14:45:00 UTC October 01, 2019 - 14:45:00 UTC 1 1 37.29066 -121.95854 43 1 1
1569930614:633528 633528 30 October 01, 2019 - 11:40:22 UTC October 01, 2019 - 14:45:00 UTC October 01, 2019 - 14:45:00 UTC 1 1 37.29 -121.9594 43 1 5
1569931217:633524 633524 31 October 01, 2019 - 11:47:48 UTC October 01, 2019 - 14:45:00 UTC October 01, 2019 - 14:45:00 UTC 94 0 37.29081 -121.95834 43 1 1
1569931217:633526 633526 31 October 01, 2019 - 11:55:58 UTC October 01, 2019 - 14:45:00 UTC October 01, 2019 - 14:45:00 UTC 3 2 37.29066 -121.95854 43 1 1
1569931217:633528 633528 31 October 01, 2019 - 11:40:22 UTC October 01, 2019 - 14:45:00 UTC October 01, 2019 - 14:45:00 UTC 1 1 37.29 -121.9594 43 1 5
1569931817:633524 633524 32 October 01, 2019 - 11:57:46 UTC October 01, 2019 - 14:45:00 UTC October 01, 2019 - 14:45:00 UTC 94 0 37.29081 -121.95834 43 1 1
1569931817:633526 633526 32 October 01, 2019 - 12:00:36 UTC October 01, 2019 - 14:45:00 UTC October 01, 2019 - 14:45:00 UTC 3 2 37.29066 -121.95854 43 1 5
1569931817:633528 633528 32 October 01, 2019 - 12:01:10 UTC October 01, 2019 - 14:45:00 UTC October 01, 2019 - 14:45:00 UTC 1 1 37.29 -121.9594 43 1 1
1569932416:633524 633524 33 October 01, 2019 - 11:57:46 UTC October 01, 2019 - 14:45:00 UTC October 01, 2019 - 14:45:00 UTC 94 0 37.29081 -121.95834 43 1 1
1569932416:633526 633526 33 October 01, 2019 - 12:00:36 UTC October 01, 2019 - 14:45:00 UTC October 01, 2019 - 14:45:00 UTC 3 2 37.29066 -121.95854 43 1 5
1569932416:633528 633528 33 October 01, 2019 - 12:01:10 UTC October 01, 2019 - 14:45:00 UTC October 01, 2019 - 14:45:00 UTC 1 1 37.29 -121.9594 43 1 1
1569933016:633524 633524 34 October 01, 2019 - 12:24:03 UTC October 01, 2019 - 14:45:00 UTC October 01, 2019 - 14:45:00 UTC 94 0 37.29072 -121.95844 43 1 1
1569933016:633528 633528 34 October 01, 2019 - 12:24:17 UTC October 01, 2019 - 14:45:00 UTC October 01, 2019 - 14:45:00 UTC 2615 3 37.29172 -121.93561 43 6 4
1569933610:633524 633524 35 October 01, 2019 - 12:24:03 UTC October 01, 2019 - 14:45:00 UTC October 01, 2019 - 14:45:00 UTC 94 0 37.29072 -121.95844 43 1 1
1569933610:633528 633528 35 October 01, 2019 - 12:35:34 UTC October 01, 2019 - 14:45:00 UTC October 01, 2019 - 14:45:00 UTC 2615 3 37.29172 -121.93561 43 6 4
1569934216:633524 633524 36 October 01, 2019 - 12:45:31 UTC October 01, 2019 - 14:45:00 UTC October 01, 2019 - 14:45:00 UTC 94 0 37.29072 -121.95844 43 1 1
1569934216:633537 633537 36 October 01, 2019 - 12:45:44 UTC October 01, 2019 - 16:00:00 UTC October 01, 2019 - 16:00:00 UTC 1 0 37.29243 -121.96658 43 1 1
1569934854:633524 633524 37 October 01, 2019 - 12:46:21 UTC October 01, 2019 - 14:45:00 UTC October 01, 2019 - 14:45:00 UTC 94 0 37.29072 -121.95844 43 1 1
1569935427:633524 633524 38 October 01, 2019 - 12:46:21 UTC October 01, 2019 - 14:45:00 UTC October 01, 2019 - 14:45:00 UTC 94 0 37.29072 -121.95844 43 1 1
1569936025:633524 633524 39 October 01, 2019 - 12:46:21 UTC October 01, 2019 - 14:45:00 UTC October 01, 2019 - 14:45:00 UTC 94 0 37.29072 -121.95844 43 1 1
1569936639:633524 633524 40 October 01, 2019 - 13:24:36 UTC October 01, 2019 - 14:45:00 UTC October 01, 2019 - 14:45:00 UTC 94 0 37.29072 -121.95844 43 6 4
1569937220:633524 633524 41 October 01, 2019 - 13:34:10 UTC October 01, 2019 - 14:45:00 UTC October 01, 2019 - 14:45:00 UTC 94 0 37.29072 -121.95844 43 6 4
1569937820:633524 633524 42 October 01, 2019 - 13:38:19 UTC October 01, 2019 - 14:45:00 UTC October 01, 2019 - 14:45:00 UTC 94 0 37.29072 -121.95844 43 6 4
1569938467:633524 633524 43 October 01, 2019 - 13:38:19 UTC October 01, 2019 - 14:45:00 UTC October 01, 2019 - 14:45:00 UTC 94 0 37.29072 -121.95844 43 6 4
1569938467:633549 633549 43 October 01, 2019 - 13:43:48 UTC October 01, 2019 - 17:00:00 UTC October 01, 2019 - 17:00:00 UTC 1 0 37.29066 -121.95854 43 1 1
1569939021:633524 633524 44 October 01, 2019 - 13:38:19 UTC October 01, 2019 - 14:45:00 UTC October 01, 2019 - 14:45:00 UTC 94 0 37.29072 -121.95844 43 6 4
1569939021:633549 633549 44 October 01, 2019 - 13:43:48 UTC October 01, 2019 - 17:00:00 UTC October 01, 2019 - 17:00:00 UTC 1 0 37.29066 -121.95854 43 1 1
1569939629:633524 633524 45 October 01, 2019 - 14:06:37 UTC October 01, 2019 - 14:45:00 UTC October 01, 2019 - 14:45:00 UTC 94 0 37.29072 -121.95844 43 6 3
1569939629:633549 633549 45 October 01, 2019 - 13:43:48 UTC October 01, 2019 - 17:00:00 UTC October 01, 2019 - 17:00:00 UTC 1 0 37.29066 -121.95854 43 1 1
1569940220:633524 633524 46 October 01, 2019 - 14:06:37 UTC October 01, 2019 - 14:45:00 UTC October 01, 2019 - 14:45:00 UTC 94 0 37.29072 -121.95844 43 6 3
1569940220:633549 633549 46 October 01, 2019 - 14:24:49 UTC October 01, 2019 - 17:00:00 UTC October 01, 2019 - 17:00:00 UTC 1 0 37.29066 -121.95854 43 1 1
1569940818:633524 633524 47 October 01, 2019 - 14:27:44 UTC October 01, 2019 - 14:45:00 UTC October 01, 2019 - 14:45:00 UTC 94 0 37.29072 -121.95844 43 6 3
1569940818:633549 633549 47 October 01, 2019 - 14:24:49 UTC October 01, 2019 - 17:00:00 UTC October 01, 2019 - 17:00:00 UTC 1 0 37.29066 -121.95854 43 1 1
1569941431:633524 633524 48 October 01, 2019 - 14:27:44 UTC October 01, 2019 - 14:45:00 UTC October 01, 2019 - 14:45:00 UTC 94 0 37.29072 -121.95844 43 6 3
1569941431:633549 633549 48 October 01, 2019 - 14:24:49 UTC October 01, 2019 - 17:00:00 UTC October 01, 2019 - 17:00:00 UTC 1 0 37.29066 -121.95854 43 1 1
1569942021:633524 633524 49 October 01, 2019 - 14:48:14 UTC October 01, 2019 - 22:00:00 UTC   94 0 37.29072 -121.95844 43 2 7
1569942021:633549 633549 49 October 01, 2019 - 14:24:49 UTC October 01, 2019 - 17:00:00 UTC October 01, 2019 - 17:00:00 UTC 1 0 37.29066 -121.95854 43 1 1
1569942620:633524 633524 50 October 01, 2019 - 14:48:14 UTC October 01, 2019 - 22:00:00 UTC   94 0 37.29072 -121.95844 43 2 7
1569942620:633549 633549 50 October 01, 2019 - 14:24:49 UTC October 01, 2019 - 17:00:00 UTC October 01, 2019 - 17:00:00 UTC 1 0 37.29066 -121.95854 43 1 1
1569943255:633524 633524 51 October 01, 2019 - 14:48:14 UTC October 01, 2019 - 22:00:00 UTC   94 0 37.29072 -121.95844 43 2 7
1569943255:633549 633549 51 October 01, 2019 - 14:24:49 UTC October 01, 2019 - 17:00:00 UTC October 01, 2019 - 17:00:00 UTC 1 0 37.29066 -121.95854 43 1 1
1569943834:633524 633524 52 October 01, 2019 - 14:48:14 UTC October 01, 2019 - 22:00:00 UTC   94 0 37.29072 -121.95844 43 2 7
1569943834:633549 633549 52 October 01, 2019 - 15:15:24 UTC October 01, 2019 - 17:00:00 UTC October 01, 2019 - 17:00:00 UTC 3 0 37.29066 -121.95854 43 1 1
1569944417:633524 633524 53 October 01, 2019 - 14:48:14 UTC October 01, 2019 - 22:00:00 UTC   94 0 37.29072 -121.95844 43 2 7
1569944417:633549 633549 53 October 01, 2019 - 15:15:24 UTC October 01, 2019 - 17:00:00 UTC October 01, 2019 - 17:00:00 UTC 3 0 37.29066 -121.95854 43 1 1
1569945023:633524 633524 54 October 01, 2019 - 14:48:14 UTC October 01, 2019 - 22:00:00 UTC   94 0 37.29072 -121.95844 43 2 7
1569945023:633549 633549 54 October 01, 2019 - 15:15:24 UTC October 01, 2019 - 17:00:00 UTC October 01, 2019 - 17:00:00 UTC 3 0 37.29066 -121.95854 43 1 1
1569945622:633524 633524 55 October 01, 2019 - 14:48:14 UTC October 01, 2019 - 22:00:00 UTC   94 0 37.29072 -121.95844 43 2 7
1569945622:633549 633549 55 October 01, 2019 - 15:15:24 UTC October 01, 2019 - 17:00:00 UTC October 01, 2019 - 17:00:00 UTC 3 0 37.29066 -121.95854 43 1 1
1569946235:633524 633524 56 October 01, 2019 - 14:48:14 UTC October 01, 2019 - 22:00:00 UTC   94 0 37.29072 -121.95844 43 2 7
1569946235:633549 633549 56 October 01, 2019 - 15:15:24 UTC October 01, 2019 - 17:00:00 UTC October 01, 2019 - 17:00:00 UTC 3 0 37.29066 -121.95854 43 1 1
1569946828:633524 633524 57 October 01, 2019 - 14:48:14 UTC October 01, 2019 - 22:00:00 UTC   94 0 37.29072 -121.95844 43 2 7
1569946828:633549 633549 57 October 01, 2019 - 15:15:24 UTC October 01, 2019 - 17:00:00 UTC October 01, 2019 - 17:00:00 UTC 3 0 37.29066 -121.95854 43 1 1
1569947434:633524 633524 58 October 01, 2019 - 14:48:14 UTC October 01, 2019 - 22:00:00 UTC   94 0 37.29072 -121.95844 43 2 7
1569947434:633549 633549 58 October 01, 2019 - 15:15:24 UTC October 01, 2019 - 17:00:00 UTC October 01, 2019 - 17:00:00 UTC 3 0 37.29066 -121.95854 43 1 1
1569948031:633524 633524 59 October 01, 2019 - 16:29:40 UTC October 01, 2019 - 22:00:00 UTC   94 0 37.29072 -121.95844 43 2 7
1569948031:633549 633549 59 October 01, 2019 - 16:35:59 UTC October 01, 2019 - 22:00:00 UTC   3 0 37.29066 -121.95854 43 1 1
1569948634:633524 633524 60 October 01, 2019 - 16:29:40 UTC October 01, 2019 - 22:00:00 UTC   94 0 37.29072 -121.95844 43 2 7
1569948634:633549 633549 60 October 01, 2019 - 16:36:18 UTC October 01, 2019 - 22:00:00 UTC   3 0 37.29066 -121.95854 43 1 1
1569949236:633524 633524 61 October 01, 2019 - 16:29:40 UTC October 01, 2019 - 22:00:00 UTC   94 0 37.29072 -121.95844 43 2 7
1569949236:633549 633549 61 October 01, 2019 - 16:36:18 UTC October 01, 2019 - 22:00:00 UTC   3 0 37.29066 -121.95854 43 1 1
1569949829:633524 633524 62 October 01, 2019 - 17:01:00 UTC October 01, 2019 - 22:00:00 UTC   94 0 37.29072 -121.95844 43 2 2
1569949829:633549 633549 62 October 01, 2019 - 16:36:18 UTC October 01, 2019 - 22:00:00 UTC   3 0 37.29066 -121.95854 43 1 1
1569950417:633524 633524 63 October 01, 2019 - 17:01:00 UTC October 01, 2019 - 22:00:00 UTC   94 0 37.29072 -121.95844 43 2 2
1569950417:633549 633549 63 October 01, 2019 - 16:36:18 UTC October 01, 2019 - 22:00:00 UTC   3 0 37.29066 -121.95854 43 1 1
1569951021:633524 633524 64 October 01, 2019 - 17:01:00 UTC October 01, 2019 - 22:00:00 UTC   94 0 37.29072 -121.95844 43 2 2
1569951021:633549 633549 64 October 01, 2019 - 16:36:18 UTC October 01, 2019 - 22:00:00 UTC   3 0 37.29066 -121.95854 43 1 1
1569951021:633912 633912 64 October 01, 2019 - 17:22:05 UTC October 01, 2019 - 20:30:00 UTC October 01, 2019 - 20:30:00 UTC 1 0 37.29407 -121.94072 43 1 1
1569951616:633524 633524 65 October 01, 2019 - 17:35:54 UTC October 01, 2019 - 22:00:00 UTC   94 0 37.29072 -121.95844 43 2 1
1569951616:633549 633549 65 October 01, 2019 - 16:36:18 UTC October 01, 2019 - 22:00:00 UTC   3 0 37.29066 -121.95854 43 1 1
1569951616:633912 633912 65 October 01, 2019 - 17:22:05 UTC October 01, 2019 - 20:30:00 UTC October 01, 2019 - 20:30:00 UTC 1 0 37.29407 -121.94072 43 1 1
1569952233:633524 633524 66 October 01, 2019 - 17:35:54 UTC October 01, 2019 - 22:00:00 UTC   94 0 37.29072 -121.95844 43 2 1
1569952233:633549 633549 66 October 01, 2019 - 16:36:18 UTC October 01, 2019 - 22:00:00 UTC   3 0 37.29066 -121.95854 43 1 1
1569952233:633912 633912 66 October 01, 2019 - 17:22:05 UTC October 01, 2019 - 20:30:00 UTC October 01, 2019 - 20:30:00 UTC 1 0 37.29407 -121.94072 43 1 1
1569952233:633947 633947 66 October 01, 2019 - 17:44:09 UTC October 01, 2019 - 20:45:00 UTC October 01, 2019 - 20:45:00 UTC 1 1 37.2844 -121.94634 43 1 1
1569952839:633524 633524 67 October 01, 2019 - 17:53:00 UTC October 01, 2019 - 22:00:00 UTC   94 0 37.29072 -121.95844 43 2 2
1569952839:633549 633549 67 October 01, 2019 - 16:36:18 UTC October 01, 2019 - 22:00:00 UTC   3 0 37.29066 -121.95854 43 1 1
1569952839:633912 633912 67 October 01, 2019 - 17:22:05 UTC October 01, 2019 - 20:30:00 UTC October 01, 2019 - 20:30:00 UTC 1 0 37.29407 -121.94072 43 1 1
1569952839:633947 633947 67 October 01, 2019 - 17:44:09 UTC October 01, 2019 - 20:45:00 UTC October 01, 2019 - 20:45:00 UTC 1 1 37.2844 -121.94634 43 1 1
1569953462:633524 633524 68 October 01, 2019 - 17:53:00 UTC October 01, 2019 - 22:00:00 UTC   94 0 37.29072 -121.95844 43 2 2
1569953462:633549 633549 68 October 01, 2019 - 16:36:18 UTC October 01, 2019 - 22:00:00 UTC   3 0 37.29066 -121.95854 43 1 1
1569953462:633912 633912 68 October 01, 2019 - 17:22:05 UTC October 01, 2019 - 20:30:00 UTC October 01, 2019 - 20:30:00 UTC 1 0 37.29407 -121.94072 43 1 1
1569953462:633947 633947 68 October 01, 2019 - 17:56:32 UTC October 01, 2019 - 20:45:00 UTC October 01, 2019 - 20:45:00 UTC 1 1 37.2844 -121.94634 43 1 5
1569954055:633524 633524 69 October 01, 2019 - 17:53:00 UTC October 01, 2019 - 22:00:00 UTC   94 0 37.29072 -121.95844 43 2 2
1569954055:633549 633549 69 October 01, 2019 - 16:36:18 UTC October 01, 2019 - 22:00:00 UTC   3 0 37.29066 -121.95854 43 1 1
1569954055:633912 633912 69 October 01, 2019 - 17:22:05 UTC October 01, 2019 - 20:30:00 UTC October 01, 2019 - 20:30:00 UTC 1 0 37.29407 -121.94072 43 1 5
1569954621:633524 633524 70 October 01, 2019 - 17:53:00 UTC October 01, 2019 - 22:00:00 UTC   94 0 37.29072 -121.95844 43 2 2
1569954621:633549 633549 70 October 01, 2019 - 16:36:18 UTC October 01, 2019 - 22:00:00 UTC   3 0 37.29066 -121.95854 43 1 1
1569955253:633524 633524 71 October 01, 2019 - 17:53:00 UTC October 01, 2019 - 22:00:00 UTC   94 0 37.29072 -121.95844 43 2 2
1569955253:633549 633549 71 October 01, 2019 - 16:36:18 UTC October 01, 2019 - 22:00:00 UTC   3 0 37.29066 -121.95854 43 1 1
1569955842:633524 633524 72 October 01, 2019 - 17:53:00 UTC October 01, 2019 - 22:00:00 UTC   94 0 37.29072 -121.95844 43 2 2
1569955842:633549 633549 72 October 01, 2019 - 16:36:18 UTC October 01, 2019 - 22:00:00 UTC   3 0 37.29066 -121.95854 43 1 1
1569956437:633524 633524 73 October 01, 2019 - 17:53:00 UTC October 01, 2019 - 22:00:00 UTC   94 0 37.29072 -121.95844 43 2 2
1569956437:633549 633549 73 October 01, 2019 - 16:36:18 UTC October 01, 2019 - 22:00:00 UTC   3 0 37.29066 -121.95854 43 1 1
1569957023:633524 633524 74 October 01, 2019 - 19:04:34 UTC October 01, 2019 - 22:00:00 UTC   94 0 37.29072 -121.95844 43 2 2
1569957023:633549 633549 74 October 01, 2019 - 16:36:18 UTC October 01, 2019 - 22:00:00 UTC   3 0 37.29066 -121.95854 43 1 1
1569957630:633524 633524 75 October 01, 2019 - 19:04:34 UTC October 01, 2019 - 22:00:00 UTC   94 0 37.29072 -121.95844 43 2 2
Powered by Datasette · Query took 4959.162ms · About: About this site