pge-outages

Custom SQL query returning 101 rows (hide)

Query parameters

idoutagesnapshotlastUpdateTimecurrentEtorautoEtorestCustAffectedhazardFlaglatitudelongituderegionNamecausecrewCurrentStatus
1569913215:632153 632153 1 October 01, 2019 - 06:31:11 UTC October 01, 2019 - 09:00:00 UTC   1 0 37.89203 -122.03894 33 2 3
1569913838:632153 632153 2 October 01, 2019 - 06:31:11 UTC October 01, 2019 - 09:00:00 UTC   1 0 37.89203 -122.03894 33 2 3
1569914414:632153 632153 3 October 01, 2019 - 06:31:11 UTC October 01, 2019 - 09:00:00 UTC   1 0 37.89203 -122.03894 33 2 3
1569915019:632153 632153 4 October 01, 2019 - 06:31:11 UTC October 01, 2019 - 09:00:00 UTC   1 0 37.89203 -122.03894 33 2 3
1569915624:632153 632153 5 October 01, 2019 - 06:31:11 UTC October 01, 2019 - 09:00:00 UTC   1 0 37.89203 -122.03894 33 2 3
1569916231:632153 632153 6 October 01, 2019 - 06:31:11 UTC October 01, 2019 - 09:00:00 UTC   1 0 37.89203 -122.03894 33 2 3
1569916815:632153 632153 7 October 01, 2019 - 06:31:11 UTC October 01, 2019 - 09:00:00 UTC   1 0 37.89203 -122.03894 33 2 3
1569917417:632153 632153 8 October 01, 2019 - 06:31:11 UTC October 01, 2019 - 09:00:00 UTC   1 0 37.89203 -122.03894 33 2 3
1569918012:632153 632153 9 October 01, 2019 - 06:31:11 UTC October 01, 2019 - 09:00:00 UTC   1 0 37.89203 -122.03894 33 2 3
1569918645:632153 632153 10 October 01, 2019 - 06:31:11 UTC October 01, 2019 - 09:00:00 UTC   1 0 37.89203 -122.03894 33 2 3
1569919223:632153 632153 11 October 01, 2019 - 08:34:22 UTC October 01, 2019 - 15:00:00 UTC   1 0 37.89203 -122.03894 33 2 3
1569919823:632153 632153 12 October 01, 2019 - 08:34:22 UTC October 01, 2019 - 15:00:00 UTC   1 0 37.89203 -122.03894 33 2 3
1569920421:632153 632153 13 October 01, 2019 - 08:34:22 UTC October 01, 2019 - 15:00:00 UTC   1 0 37.89203 -122.03894 33 2 3
1569921023:632153 632153 14 October 01, 2019 - 08:34:22 UTC October 01, 2019 - 15:00:00 UTC   1 0 37.89203 -122.03894 33 2 3
1569921618:632153 632153 15 October 01, 2019 - 08:34:22 UTC October 01, 2019 - 15:00:00 UTC   1 0 37.89203 -122.03894 33 2 3
1569922217:632153 632153 16 October 01, 2019 - 08:34:22 UTC October 01, 2019 - 15:00:00 UTC   1 0 37.89203 -122.03894 33 2 3
1569922813:632153 632153 17 October 01, 2019 - 08:34:22 UTC October 01, 2019 - 15:00:00 UTC   1 0 37.89203 -122.03894 33 2 3
1569923412:632153 632153 18 October 01, 2019 - 08:34:22 UTC October 01, 2019 - 15:00:00 UTC   1 0 37.89203 -122.03894 33 2 3
1569924030:632153 632153 19 October 01, 2019 - 08:34:22 UTC October 01, 2019 - 15:00:00 UTC   1 0 37.89203 -122.03894 33 2 3
1569924614:632153 632153 20 October 01, 2019 - 08:34:22 UTC October 01, 2019 - 15:00:00 UTC   1 0 37.89203 -122.03894 33 2 3
1569925218:632153 632153 21 October 01, 2019 - 08:34:22 UTC October 01, 2019 - 15:00:00 UTC   1 0 37.89203 -122.03894 33 2 3
1569925819:632153 632153 22 October 01, 2019 - 08:34:22 UTC October 01, 2019 - 15:00:00 UTC   1 0 37.89203 -122.03894 33 2 3
1569926413:632153 632153 23 October 01, 2019 - 08:34:22 UTC October 01, 2019 - 15:00:00 UTC   1 0 37.89203 -122.03894 33 2 3
1569927022:632153 632153 24 October 01, 2019 - 08:34:22 UTC October 01, 2019 - 15:00:00 UTC   1 0 37.89203 -122.03894 33 2 3
1569927620:632153 632153 25 October 01, 2019 - 08:34:22 UTC October 01, 2019 - 15:00:00 UTC   1 0 37.89203 -122.03894 33 2 3
1569928219:632153 632153 26 October 01, 2019 - 08:34:22 UTC October 01, 2019 - 15:00:00 UTC   1 0 37.89203 -122.03894 33 2 3
1569928810:632153 632153 27 October 01, 2019 - 08:34:22 UTC October 01, 2019 - 15:00:00 UTC   1 0 37.89203 -122.03894 33 2 3
1569936025:633546 633546 39 October 01, 2019 - 13:08:47 UTC October 01, 2019 - 16:45:00 UTC October 01, 2019 - 16:45:00 UTC 20 0 37.87055 -122.03021 33 1 1
1569936639:633546 633546 40 October 01, 2019 - 13:08:47 UTC October 01, 2019 - 16:45:00 UTC October 01, 2019 - 16:45:00 UTC 20 0 37.87055 -122.03021 33 1 1
1569937220:633546 633546 41 October 01, 2019 - 13:08:47 UTC October 01, 2019 - 16:45:00 UTC October 01, 2019 - 16:45:00 UTC 20 0 37.87055 -122.03021 33 1 1
1569937820:633546 633546 42 October 01, 2019 - 13:45:56 UTC October 01, 2019 - 16:45:00 UTC October 01, 2019 - 16:45:00 UTC 20 0 37.87055 -122.03021 33 1 1
1569938467:633546 633546 43 October 01, 2019 - 13:45:56 UTC October 01, 2019 - 16:45:00 UTC October 01, 2019 - 16:45:00 UTC 20 0 37.87055 -122.03021 33 1 1
1569939021:633546 633546 44 October 01, 2019 - 13:45:56 UTC October 01, 2019 - 16:45:00 UTC October 01, 2019 - 16:45:00 UTC 20 0 37.87055 -122.03021 33 1 1
1569939629:633546 633546 45 October 01, 2019 - 13:45:56 UTC October 01, 2019 - 16:45:00 UTC October 01, 2019 - 16:45:00 UTC 20 0 37.87055 -122.03021 33 1 1
1569940220:633546 633546 46 October 01, 2019 - 14:25:03 UTC October 01, 2019 - 16:45:00 UTC October 01, 2019 - 16:45:00 UTC 20 0 37.87055 -122.03021 33 1 1
1569940818:633546 633546 47 October 01, 2019 - 14:25:03 UTC October 01, 2019 - 16:45:00 UTC October 01, 2019 - 16:45:00 UTC 20 0 37.87055 -122.03021 33 1 5
1569941431:633546 633546 48 October 01, 2019 - 14:25:03 UTC October 01, 2019 - 16:45:00 UTC October 01, 2019 - 16:45:00 UTC 20 0 37.87055 -122.03021 33 1 5
1569942021:633546 633546 49 October 01, 2019 - 14:25:03 UTC October 01, 2019 - 16:45:00 UTC October 01, 2019 - 16:45:00 UTC 20 0 37.87055 -122.03021 33 1 5
1569942620:633546 633546 50 October 01, 2019 - 14:53:08 UTC October 01, 2019 - 16:45:00 UTC October 01, 2019 - 16:45:00 UTC 20 0 37.87055 -122.03021 33 1 5
1569942620:633594 633594 50 October 01, 2019 - 14:59:35 UTC October 01, 2019 - 19:00:00 UTC October 01, 2019 - 19:00:00 UTC 9 0 37.91565 -122.02158 33 1 1
1569943255:633546 633546 51 October 01, 2019 - 15:10:34 UTC October 01, 2019 - 16:45:00 UTC October 01, 2019 - 16:45:00 UTC 20 0 37.87055 -122.03021 33 6 4
1569943255:633594 633594 51 October 01, 2019 - 15:01:39 UTC October 01, 2019 - 19:00:00 UTC October 01, 2019 - 19:00:00 UTC 9 0 37.91565 -122.02158 33 1 1
1569943834:633546 633546 52 October 01, 2019 - 15:14:30 UTC October 01, 2019 - 16:45:00 UTC October 01, 2019 - 16:45:00 UTC 20 0 37.87055 -122.03021 33 6 4
1569943834:633594 633594 52 October 01, 2019 - 15:01:39 UTC October 01, 2019 - 19:00:00 UTC October 01, 2019 - 19:00:00 UTC 9 0 37.91565 -122.02158 33 1 1
1569944417:633546 633546 53 October 01, 2019 - 15:14:30 UTC October 01, 2019 - 16:45:00 UTC October 01, 2019 - 16:45:00 UTC 20 0 37.87055 -122.03021 33 6 4
1569944417:633594 633594 53 October 01, 2019 - 15:01:39 UTC October 01, 2019 - 19:00:00 UTC October 01, 2019 - 19:00:00 UTC 9 0 37.91565 -122.02158 33 1 1
1569945023:633546 633546 54 October 01, 2019 - 15:14:30 UTC October 01, 2019 - 16:45:00 UTC October 01, 2019 - 16:45:00 UTC 20 0 37.87055 -122.03021 33 6 4
1569945023:633594 633594 54 October 01, 2019 - 15:01:39 UTC October 01, 2019 - 19:00:00 UTC October 01, 2019 - 19:00:00 UTC 9 0 37.91565 -122.02158 33 1 1
1569945622:633546 633546 55 October 01, 2019 - 15:14:30 UTC October 01, 2019 - 16:45:00 UTC October 01, 2019 - 16:45:00 UTC 20 0 37.87055 -122.03021 33 6 4
1569945622:633594 633594 55 October 01, 2019 - 15:01:39 UTC October 01, 2019 - 19:00:00 UTC October 01, 2019 - 19:00:00 UTC 9 0 37.91565 -122.02158 33 1 1
1569946235:633546 633546 56 October 01, 2019 - 15:14:30 UTC October 01, 2019 - 16:45:00 UTC October 01, 2019 - 16:45:00 UTC 20 0 37.87055 -122.03021 33 6 4
1569946235:633594 633594 56 October 01, 2019 - 15:01:39 UTC October 01, 2019 - 19:00:00 UTC October 01, 2019 - 19:00:00 UTC 9 0 37.91565 -122.02158 33 1 1
1569946828:633546 633546 57 October 01, 2019 - 15:14:30 UTC October 01, 2019 - 16:45:00 UTC October 01, 2019 - 16:45:00 UTC 20 0 37.87055 -122.03021 33 6 4
1569946828:633594 633594 57 October 01, 2019 - 15:01:39 UTC October 01, 2019 - 19:00:00 UTC October 01, 2019 - 19:00:00 UTC 9 0 37.91565 -122.02158 33 1 1
1569947434:633546 633546 58 October 01, 2019 - 15:14:30 UTC October 01, 2019 - 16:45:00 UTC October 01, 2019 - 16:45:00 UTC 20 0 37.87055 -122.03021 33 6 4
1569947434:633594 633594 58 October 01, 2019 - 15:01:39 UTC October 01, 2019 - 19:00:00 UTC October 01, 2019 - 19:00:00 UTC 9 0 37.91565 -122.02158 33 1 1
1569948031:633546 633546 59 October 01, 2019 - 15:14:30 UTC October 01, 2019 - 16:45:00 UTC October 01, 2019 - 16:45:00 UTC 20 0 37.87055 -122.03021 33 6 4
1569948031:633594 633594 59 October 01, 2019 - 15:01:39 UTC October 01, 2019 - 19:00:00 UTC October 01, 2019 - 19:00:00 UTC 9 0 37.91565 -122.02158 33 1 1
1569948634:633546 633546 60 October 01, 2019 - 16:37:46 UTC October 01, 2019 - 22:37:00 UTC   20 0 37.87055 -122.03021 33 6 4
1569948634:633594 633594 60 October 01, 2019 - 15:01:39 UTC October 01, 2019 - 19:00:00 UTC October 01, 2019 - 19:00:00 UTC 9 0 37.91565 -122.02158 33 1 1
1569949236:633546 633546 61 October 01, 2019 - 16:37:46 UTC October 01, 2019 - 22:37:00 UTC   20 0 37.87055 -122.03021 33 6 4
1569949236:633594 633594 61 October 01, 2019 - 15:01:39 UTC October 01, 2019 - 19:00:00 UTC October 01, 2019 - 19:00:00 UTC 9 0 37.91565 -122.02158 33 1 1
1569949829:633546 633546 62 October 01, 2019 - 16:37:46 UTC October 01, 2019 - 22:37:00 UTC   20 0 37.87055 -122.03021 33 6 4
1569949829:633594 633594 62 October 01, 2019 - 15:01:39 UTC October 01, 2019 - 19:00:00 UTC October 01, 2019 - 19:00:00 UTC 9 0 37.91565 -122.02158 33 1 1
1569950417:633546 633546 63 October 01, 2019 - 17:13:59 UTC October 01, 2019 - 22:37:00 UTC   20 0 37.87055 -122.03021 33 6 1
1569950417:633594 633594 63 October 01, 2019 - 15:01:39 UTC October 01, 2019 - 19:00:00 UTC October 01, 2019 - 19:00:00 UTC 9 0 37.91565 -122.02158 33 1 5
1569950417:633894 633894 63 October 01, 2019 - 17:14:33 UTC October 01, 2019 - 20:15:00 UTC October 01, 2019 - 20:15:00 UTC 1 1 37.88173 -122.06065 33 1 1
1569951021:633546 633546 64 October 01, 2019 - 17:13:59 UTC October 01, 2019 - 22:37:00 UTC   20 0 37.87055 -122.03021 33 6 1
1569951021:633594 633594 64 October 01, 2019 - 15:01:39 UTC October 01, 2019 - 19:00:00 UTC October 01, 2019 - 19:00:00 UTC 9 0 37.91565 -122.02158 33 1 5
1569951021:633894 633894 64 October 01, 2019 - 17:14:33 UTC October 01, 2019 - 20:15:00 UTC October 01, 2019 - 20:15:00 UTC 1 1 37.88173 -122.06065 33 1 1
1569951616:633546 633546 65 October 01, 2019 - 17:32:51 UTC October 01, 2019 - 22:37:00 UTC   20 0 37.87055 -122.03021 33 2 3
1569951616:633594 633594 65 October 01, 2019 - 15:01:39 UTC October 01, 2019 - 19:00:00 UTC October 01, 2019 - 19:00:00 UTC 9 0 37.91565 -122.02158 33 1 5
1569951616:633894 633894 65 October 01, 2019 - 17:14:33 UTC October 01, 2019 - 20:15:00 UTC October 01, 2019 - 20:15:00 UTC 1 1 37.88173 -122.06065 33 1 1
1569952233:633546 633546 66 October 01, 2019 - 17:32:51 UTC October 01, 2019 - 22:37:00 UTC   20 0 37.87055 -122.03021 33 2 3
1569952233:633594 633594 66 October 01, 2019 - 17:39:05 UTC October 01, 2019 - 19:00:00 UTC October 01, 2019 - 19:00:00 UTC 9 0 37.91533 -122.02156 33 1 5
1569952233:633894 633894 66 October 01, 2019 - 17:37:06 UTC October 01, 2019 - 20:15:00 UTC October 01, 2019 - 20:15:00 UTC 1 1 37.88173 -122.06065 33 1 5
1569952839:633546 633546 67 October 01, 2019 - 17:32:51 UTC October 01, 2019 - 22:37:00 UTC   20 0 37.87055 -122.03021 33 2 3
1569952839:633594 633594 67 October 01, 2019 - 17:52:35 UTC October 01, 2019 - 19:00:00 UTC October 01, 2019 - 19:00:00 UTC 9 0 37.91533 -122.02156 33 1 5
1569952839:633894 633894 67 October 01, 2019 - 17:37:06 UTC October 01, 2019 - 20:15:00 UTC October 01, 2019 - 20:15:00 UTC 1 1 37.88173 -122.06065 33 1 5
1569953462:633546 633546 68 October 01, 2019 - 17:32:51 UTC October 01, 2019 - 22:37:00 UTC   20 0 37.87055 -122.03021 33 2 3
1569953462:633894 633894 68 October 01, 2019 - 18:01:12 UTC October 01, 2019 - 20:15:00 UTC October 01, 2019 - 20:15:00 UTC 1 1 37.88173 -122.06065 33 6 4
1569954055:633546 633546 69 October 01, 2019 - 17:32:51 UTC October 01, 2019 - 22:37:00 UTC   20 0 37.87055 -122.03021 33 2 3
1569954621:633546 633546 70 October 01, 2019 - 17:32:51 UTC October 01, 2019 - 22:37:00 UTC   20 0 37.87055 -122.03021 33 2 3
1569955253:633546 633546 71 October 01, 2019 - 18:29:36 UTC October 01, 2019 - 22:37:00 UTC   20 0 37.87055 -122.03021 33 2 2
1569955842:633546 633546 72 October 01, 2019 - 18:29:36 UTC October 01, 2019 - 22:37:00 UTC   20 0 37.87055 -122.03021 33 2 2
1569956437:633546 633546 73 October 01, 2019 - 18:29:36 UTC October 01, 2019 - 22:37:00 UTC   20 0 37.87055 -122.03021 33 2 2
1569957023:633546 633546 74 October 01, 2019 - 18:29:36 UTC October 01, 2019 - 22:37:00 UTC   20 0 37.87055 -122.03021 33 2 2
1569957630:633546 633546 75 October 01, 2019 - 18:29:36 UTC October 01, 2019 - 22:37:00 UTC   20 0 37.87055 -122.03021 33 2 2
1569958225:633546 633546 76 October 01, 2019 - 18:29:36 UTC October 01, 2019 - 22:37:00 UTC   20 0 37.87055 -122.03021 33 2 2
1569958839:633546 633546 77 October 01, 2019 - 18:29:36 UTC October 01, 2019 - 22:37:00 UTC   20 0 37.87055 -122.03021 33 2 2
1569959424:633546 633546 78 October 01, 2019 - 18:29:36 UTC October 01, 2019 - 22:37:00 UTC   20 0 37.87055 -122.03021 33 2 2
1569960023:633546 633546 79 October 01, 2019 - 18:29:36 UTC October 01, 2019 - 22:37:00 UTC   20 0 37.87055 -122.03021 33 2 2
1569960633:633546 633546 80 October 01, 2019 - 20:06:02 UTC October 01, 2019 - 22:37:00 UTC   20 0 37.87055 -122.03021 33 2 2
1569961233:633546 633546 81 October 01, 2019 - 20:06:02 UTC October 01, 2019 - 22:37:00 UTC   20 0 37.87055 -122.03021 33 2 2
1569961838:633546 633546 82 October 01, 2019 - 20:15:50 UTC October 01, 2019 - 22:37:00 UTC   9 0 37.87055 -122.03021 33 2 2
1569962421:633546 633546 83 October 01, 2019 - 20:15:50 UTC October 01, 2019 - 22:37:00 UTC   9 0 37.87055 -122.03021 33 2 2
1569963019:633546 633546 84 October 01, 2019 - 20:40:20 UTC October 02, 2019 - 03:00:00 UTC   9 0 37.87055 -122.03021 33 2 2
1569963629:633546 633546 85 October 01, 2019 - 20:40:20 UTC October 02, 2019 - 03:00:00 UTC   9 0 37.87055 -122.03021 33 2 2
1569964228:633546 633546 86 October 01, 2019 - 20:40:20 UTC October 02, 2019 - 03:00:00 UTC   9 0 37.87055 -122.03021 33 2 2
1569964818:633546 633546 87 October 01, 2019 - 21:11:46 UTC October 02, 2019 - 03:00:00 UTC   9 0 37.87055 -122.03021 33 2 2
1569965440:633546 633546 88 October 01, 2019 - 21:11:46 UTC October 02, 2019 - 03:00:00 UTC   9 0 37.87055 -122.03021 33 2 2
Powered by Datasette · Query took 5.631ms · About: About this site