pge-outages

Custom SQL query returning 101 rows (hide)

Query parameters

idoutagesnapshotlastUpdateTimecurrentEtorautoEtorestCustAffectedhazardFlaglatitudelongituderegionNamecausecrewCurrentStatus
1569913838:633503 633503 2 October 01, 2019 - 07:02:31 UTC October 01, 2019 - 09:45:00 UTC October 01, 2019 - 09:45:00 UTC 1 1 36.76072 -119.7904 35 1 1
1569914414:633503 633503 3 October 01, 2019 - 07:11:19 UTC October 01, 2019 - 09:45:00 UTC October 01, 2019 - 09:45:00 UTC 1 1 36.76072 -119.7904 35 1 5
1569915019:633503 633503 4 October 01, 2019 - 07:11:19 UTC October 01, 2019 - 09:45:00 UTC October 01, 2019 - 09:45:00 UTC 1 1 36.76072 -119.7904 35 1 5
1569915624:633503 633503 5 October 01, 2019 - 07:34:16 UTC October 01, 2019 - 09:45:00 UTC October 01, 2019 - 09:45:00 UTC 1 1 36.76072 -119.7904 35 6 4
1569925218:633512 633512 21 October 01, 2019 - 10:13:27 UTC October 01, 2019 - 12:45:00 UTC October 01, 2019 - 12:45:00 UTC 1 0 36.81268 -119.76425 35 1 1
1569925819:633512 633512 22 October 01, 2019 - 10:25:58 UTC October 01, 2019 - 12:45:00 UTC October 01, 2019 - 12:45:00 UTC 1 0 36.81268 -119.76425 35 1 1
1569926413:633512 633512 23 October 01, 2019 - 10:25:58 UTC October 01, 2019 - 12:45:00 UTC October 01, 2019 - 12:45:00 UTC 1 0 36.81268 -119.76425 35 1 1
1569927022:633512 633512 24 October 01, 2019 - 10:25:58 UTC October 01, 2019 - 12:45:00 UTC October 01, 2019 - 12:45:00 UTC 1 0 36.81268 -119.76425 35 1 5
1569927620:633512 633512 25 October 01, 2019 - 10:25:58 UTC October 01, 2019 - 12:45:00 UTC October 01, 2019 - 12:45:00 UTC 1 0 36.81268 -119.76425 35 1 5
1569928219:633512 633512 26 October 01, 2019 - 10:56:28 UTC October 01, 2019 - 12:45:00 UTC October 01, 2019 - 12:45:00 UTC 1 0 36.81268 -119.76425 35 6 4
1569928810:633512 633512 27 October 01, 2019 - 10:56:28 UTC October 01, 2019 - 12:45:00 UTC October 01, 2019 - 12:45:00 UTC 1 0 36.81268 -119.76425 35 6 4
1569945622:633775 633775 55 October 01, 2019 - 15:52:49 UTC October 01, 2019 - 18:30:00 UTC October 01, 2019 - 18:30:00 UTC 1 0 36.77528 -119.8636 35 1 1
1569946235:633775 633775 56 October 01, 2019 - 15:52:49 UTC October 01, 2019 - 18:30:00 UTC October 01, 2019 - 18:30:00 UTC 1 0 36.77528 -119.8636 35 1 1
1569946828:633775 633775 57 October 01, 2019 - 15:52:49 UTC October 01, 2019 - 18:30:00 UTC October 01, 2019 - 18:30:00 UTC 1 0 36.77528 -119.8636 35 1 1
1569947434:633775 633775 58 October 01, 2019 - 15:52:49 UTC October 01, 2019 - 18:30:00 UTC October 01, 2019 - 18:30:00 UTC 1 0 36.77528 -119.8636 35 1 1
1569948031:633775 633775 59 October 01, 2019 - 15:52:49 UTC October 01, 2019 - 18:30:00 UTC October 01, 2019 - 18:30:00 UTC 1 0 36.77528 -119.8636 35 1 1
1569948031:633848 633848 59 October 01, 2019 - 16:34:43 UTC October 01, 2019 - 18:15:00 UTC October 01, 2019 - 18:15:00 UTC 89 0 36.82208 -119.79917 35 1 5
1569948031:633849 633849 59 October 01, 2019 - 16:34:04 UTC October 01, 2019 - 18:15:00 UTC October 01, 2019 - 18:15:00 UTC 19 0 36.82228 -119.80053 35 1 1
1569948634:633775 633775 60 October 01, 2019 - 15:52:49 UTC October 01, 2019 - 18:30:00 UTC October 01, 2019 - 18:30:00 UTC 1 0 36.77528 -119.8636 35 1 1
1569948634:633848 633848 60 October 01, 2019 - 16:44:08 UTC October 01, 2019 - 18:15:00 UTC October 01, 2019 - 18:15:00 UTC 89 0 36.82208 -119.79917 35 6 4
1569948634:633849 633849 60 October 01, 2019 - 16:34:04 UTC October 01, 2019 - 18:15:00 UTC October 01, 2019 - 18:15:00 UTC 19 0 36.82228 -119.80053 35 1 1
1569949236:633775 633775 61 October 01, 2019 - 15:52:49 UTC October 01, 2019 - 18:30:00 UTC October 01, 2019 - 18:30:00 UTC 1 0 36.77528 -119.8636 35 1 1
1569949236:633848 633848 61 October 01, 2019 - 16:44:08 UTC October 01, 2019 - 18:15:00 UTC October 01, 2019 - 18:15:00 UTC 89 0 36.82208 -119.79917 35 6 4
1569949236:633849 633849 61 October 01, 2019 - 16:34:04 UTC October 01, 2019 - 18:15:00 UTC October 01, 2019 - 18:15:00 UTC 19 0 36.82228 -119.80053 35 1 1
1569949829:633775 633775 62 October 01, 2019 - 15:52:49 UTC October 01, 2019 - 18:30:00 UTC October 01, 2019 - 18:30:00 UTC 1 0 36.77528 -119.8636 35 1 1
1569949829:633848 633848 62 October 01, 2019 - 16:44:08 UTC October 01, 2019 - 18:15:00 UTC October 01, 2019 - 18:15:00 UTC 89 0 36.82208 -119.79917 35 6 4
1569949829:633849 633849 62 October 01, 2019 - 16:34:04 UTC October 01, 2019 - 18:15:00 UTC October 01, 2019 - 18:15:00 UTC 19 0 36.82228 -119.80053 35 1 1
1569950417:633775 633775 63 October 01, 2019 - 15:52:49 UTC October 01, 2019 - 18:30:00 UTC October 01, 2019 - 18:30:00 UTC 1 0 36.77528 -119.8636 35 1 1
1569950417:633848 633848 63 October 01, 2019 - 16:44:08 UTC October 01, 2019 - 18:15:00 UTC October 01, 2019 - 18:15:00 UTC 89 0 36.82208 -119.79917 35 6 4
1569950417:633849 633849 63 October 01, 2019 - 16:34:04 UTC October 01, 2019 - 18:15:00 UTC October 01, 2019 - 18:15:00 UTC 19 0 36.82228 -119.80053 35 1 1
1569951021:633775 633775 64 October 01, 2019 - 15:52:49 UTC October 01, 2019 - 18:30:00 UTC October 01, 2019 - 18:30:00 UTC 1 0 36.77528 -119.8636 35 1 1
1569951021:633848 633848 64 October 01, 2019 - 17:23:30 UTC October 01, 2019 - 18:15:00 UTC October 01, 2019 - 18:15:00 UTC 89 0 36.82208 -119.79917 35 6 4
1569951021:633849 633849 64 October 01, 2019 - 16:34:04 UTC October 01, 2019 - 18:15:00 UTC October 01, 2019 - 18:15:00 UTC 19 0 36.82228 -119.80053 35 1 1
1569951021:633917 633917 64 October 01, 2019 - 17:26:09 UTC October 01, 2019 - 20:00:00 UTC October 01, 2019 - 20:00:00 UTC 1 1 36.77444 -119.76961 35 1 1
1569951616:633775 633775 65 October 01, 2019 - 17:34:57 UTC October 01, 2019 - 18:30:00 UTC October 01, 2019 - 18:30:00 UTC 1 0 36.77528 -119.8636 35 1 1
1569951616:633848 633848 65 October 01, 2019 - 17:34:05 UTC October 01, 2019 - 18:15:00 UTC October 01, 2019 - 18:15:00 UTC 89 0 36.82208 -119.79917 35 6 4
1569951616:633849 633849 65 October 01, 2019 - 16:34:04 UTC October 01, 2019 - 18:15:00 UTC October 01, 2019 - 18:15:00 UTC 19 0 36.82228 -119.80053 35 1 1
1569951616:633917 633917 65 October 01, 2019 - 17:33:06 UTC October 01, 2019 - 20:00:00 UTC October 01, 2019 - 20:00:00 UTC 1 1 36.77444 -119.76961 35 1 5
1569951616:633939 633939 65 October 01, 2019 - 17:32:48 UTC October 01, 2019 - 20:15:00 UTC October 01, 2019 - 20:15:00 UTC 1 0 36.80194 -119.76819 35 1 1
1569952233:633775 633775 66 October 01, 2019 - 17:34:57 UTC October 01, 2019 - 18:30:00 UTC October 01, 2019 - 18:30:00 UTC 1 0 36.77528 -119.8636 35 1 5
1569952233:633848 633848 66 October 01, 2019 - 17:46:00 UTC October 01, 2019 - 18:15:00 UTC October 01, 2019 - 18:15:00 UTC 89 0 36.82208 -119.79917 35 6 4
1569952233:633849 633849 66 October 01, 2019 - 16:34:04 UTC October 01, 2019 - 18:15:00 UTC October 01, 2019 - 18:15:00 UTC 19 0 36.82228 -119.80053 35 1 1
1569952233:633917 633917 66 October 01, 2019 - 17:33:06 UTC October 01, 2019 - 20:00:00 UTC October 01, 2019 - 20:00:00 UTC 1 1 36.77444 -119.76961 35 1 5
1569952233:633939 633939 66 October 01, 2019 - 17:37:51 UTC October 01, 2019 - 20:15:00 UTC October 01, 2019 - 20:15:00 UTC 1 0 36.80194 -119.76819 35 1 1
1569952839:633775 633775 67 October 01, 2019 - 17:48:56 UTC October 01, 2019 - 18:30:00 UTC October 01, 2019 - 18:30:00 UTC 1 0 36.77528 -119.8636 35 1 5
1569952839:633848 633848 67 October 01, 2019 - 17:50:16 UTC October 01, 2019 - 18:15:00 UTC October 01, 2019 - 18:15:00 UTC 89 0 36.82208 -119.79917 35 6 4
1569952839:633849 633849 67 October 01, 2019 - 16:34:04 UTC October 01, 2019 - 18:15:00 UTC October 01, 2019 - 18:15:00 UTC 19 0 36.82228 -119.80053 35 1 1
1569952839:633917 633917 67 October 01, 2019 - 17:49:52 UTC October 01, 2019 - 20:00:00 UTC October 01, 2019 - 20:00:00 UTC 1 1 36.77444 -119.76961 35 6 4
1569952839:633939 633939 67 October 01, 2019 - 17:37:51 UTC October 01, 2019 - 20:15:00 UTC October 01, 2019 - 20:15:00 UTC 1 0 36.80194 -119.76819 35 1 1
1569953462:633775 633775 68 October 01, 2019 - 17:59:15 UTC October 01, 2019 - 18:30:00 UTC October 01, 2019 - 18:30:00 UTC 1 0 36.77528 -119.8636 35 6 4
1569953462:633848 633848 68 October 01, 2019 - 17:50:16 UTC October 01, 2019 - 18:15:00 UTC October 01, 2019 - 18:15:00 UTC 89 0 36.82208 -119.79917 35 6 4
1569953462:633849 633849 68 October 01, 2019 - 16:34:04 UTC October 01, 2019 - 18:15:00 UTC October 01, 2019 - 18:15:00 UTC 19 0 36.82228 -119.80053 35 1 1
1569953462:633917 633917 68 October 01, 2019 - 17:49:52 UTC October 01, 2019 - 20:00:00 UTC October 01, 2019 - 20:00:00 UTC 1 1 36.77444 -119.76961 35 6 4
1569953462:633939 633939 68 October 01, 2019 - 17:37:51 UTC October 01, 2019 - 20:15:00 UTC October 01, 2019 - 20:15:00 UTC 1 0 36.80194 -119.76819 35 1 1
1569954055:633775 633775 69 October 01, 2019 - 17:59:15 UTC October 01, 2019 - 18:30:00 UTC October 01, 2019 - 18:30:00 UTC 1 0 36.77528 -119.8636 35 6 4
1569954055:633848 633848 69 October 01, 2019 - 17:50:16 UTC October 01, 2019 - 18:15:00 UTC October 01, 2019 - 18:15:00 UTC 89 0 36.82208 -119.79917 35 6 4
1569954055:633849 633849 69 October 01, 2019 - 16:34:04 UTC October 01, 2019 - 18:15:00 UTC October 01, 2019 - 18:15:00 UTC 19 0 36.82228 -119.80053 35 1 1
1569954055:633917 633917 69 October 01, 2019 - 17:49:52 UTC October 01, 2019 - 20:00:00 UTC October 01, 2019 - 20:00:00 UTC 1 1 36.77444 -119.76961 35 6 4
1569954055:633939 633939 69 October 01, 2019 - 17:37:51 UTC October 01, 2019 - 20:15:00 UTC October 01, 2019 - 20:15:00 UTC 1 0 36.80194 -119.76819 35 1 1
1569954621:633775 633775 70 October 01, 2019 - 18:21:03 UTC October 01, 2019 - 21:30:00 UTC   1 0 36.77528 -119.8636 35 6 4
1569954621:633848 633848 70 October 01, 2019 - 18:24:09 UTC October 01, 2019 - 21:30:00 UTC   89 0 36.82208 -119.79917 35 6 4
1569954621:633849 633849 70 October 01, 2019 - 18:21:04 UTC October 01, 2019 - 21:30:00 UTC   19 0 36.82228 -119.80053 35 1 1
1569954621:633917 633917 70 October 01, 2019 - 17:49:52 UTC October 01, 2019 - 20:00:00 UTC October 01, 2019 - 20:00:00 UTC 1 1 36.77444 -119.76961 35 6 4
1569954621:633939 633939 70 October 01, 2019 - 17:37:51 UTC October 01, 2019 - 20:15:00 UTC October 01, 2019 - 20:15:00 UTC 1 0 36.80194 -119.76819 35 1 1
1569955253:633848 633848 71 October 01, 2019 - 18:26:57 UTC October 01, 2019 - 21:30:00 UTC   89 0 36.82208 -119.79917 35 6 4
1569955253:633849 633849 71 October 01, 2019 - 18:21:04 UTC October 01, 2019 - 21:30:00 UTC   19 0 36.82228 -119.80053 35 1 1
1569955253:633917 633917 71 October 01, 2019 - 17:49:52 UTC October 01, 2019 - 20:00:00 UTC October 01, 2019 - 20:00:00 UTC 1 1 36.77444 -119.76961 35 6 4
1569955253:633939 633939 71 October 01, 2019 - 17:37:51 UTC October 01, 2019 - 20:15:00 UTC October 01, 2019 - 20:15:00 UTC 1 0 36.80194 -119.76819 35 1 1
1569955842:633848 633848 72 October 01, 2019 - 18:43:35 UTC October 01, 2019 - 21:30:00 UTC   89 0 36.82208 -119.79917 35 6 4
1569955842:633849 633849 72 October 01, 2019 - 18:21:04 UTC October 01, 2019 - 21:30:00 UTC   19 0 36.82228 -119.80053 35 1 1
1569955842:633939 633939 72 October 01, 2019 - 17:37:51 UTC October 01, 2019 - 20:15:00 UTC October 01, 2019 - 20:15:00 UTC 1 0 36.80194 -119.76819 35 1 1
1569955842:634009 634009 72 October 01, 2019 - 18:44:55 UTC October 01, 2019 - 20:30:00 UTC October 01, 2019 - 20:30:00 UTC 1 0 36.78797 -119.81413 35 1 1
1569956437:633848 633848 73 October 01, 2019 - 18:49:26 UTC October 01, 2019 - 21:30:00 UTC   89 0 36.82208 -119.79917 35 6 4
1569956437:633849 633849 73 October 01, 2019 - 18:47:47 UTC October 01, 2019 - 21:30:00 UTC   19 0 36.82228 -119.80053 35 1 1
1569956437:633939 633939 73 October 01, 2019 - 17:37:51 UTC October 01, 2019 - 20:15:00 UTC October 01, 2019 - 20:15:00 UTC 1 0 36.80194 -119.76819 35 1 1
1569956437:634009 634009 73 October 01, 2019 - 18:44:55 UTC October 01, 2019 - 20:30:00 UTC October 01, 2019 - 20:30:00 UTC 1 0 36.78797 -119.81413 35 1 1
1569957023:633848 633848 74 October 01, 2019 - 18:49:26 UTC October 01, 2019 - 21:30:00 UTC   89 0 36.82208 -119.79917 35 6 4
1569957023:633849 633849 74 October 01, 2019 - 18:47:47 UTC October 01, 2019 - 21:30:00 UTC   19 0 36.82228 -119.80053 35 1 1
1569957023:633939 633939 74 October 01, 2019 - 17:37:51 UTC October 01, 2019 - 20:15:00 UTC October 01, 2019 - 20:15:00 UTC 1 0 36.80194 -119.76819 35 1 1
1569957023:634009 634009 74 October 01, 2019 - 18:58:57 UTC October 01, 2019 - 20:30:00 UTC October 01, 2019 - 20:30:00 UTC 1 0 36.78797 -119.81413 35 1 1
1569957630:633848 633848 75 October 01, 2019 - 19:15:20 UTC October 01, 2019 - 21:30:00 UTC   89 0 36.82208 -119.79917 35 6 4
1569957630:633849 633849 75 October 01, 2019 - 19:15:56 UTC October 01, 2019 - 21:30:00 UTC   19 0 36.82228 -119.80053 35 1 1
1569957630:633939 633939 75 October 01, 2019 - 17:37:51 UTC October 01, 2019 - 20:15:00 UTC October 01, 2019 - 20:15:00 UTC 1 0 36.80194 -119.76819 35 1 1
1569957630:634009 634009 75 October 01, 2019 - 18:58:57 UTC October 01, 2019 - 20:30:00 UTC October 01, 2019 - 20:30:00 UTC 1 0 36.78797 -119.81413 35 1 1
1569958225:633848 633848 76 October 01, 2019 - 19:24:43 UTC October 01, 2019 - 21:30:00 UTC   89 0 36.82208 -119.79917 35 6 4
1569958225:633849 633849 76 October 01, 2019 - 19:15:56 UTC October 01, 2019 - 21:30:00 UTC   19 0 36.82228 -119.80053 35 1 1
1569958225:633939 633939 76 October 01, 2019 - 17:37:51 UTC October 01, 2019 - 20:15:00 UTC October 01, 2019 - 20:15:00 UTC 1 0 36.80194 -119.76819 35 1 1
1569958225:634009 634009 76 October 01, 2019 - 18:58:57 UTC October 01, 2019 - 20:30:00 UTC October 01, 2019 - 20:30:00 UTC 1 0 36.78797 -119.81413 35 1 1
1569958839:633848 633848 77 October 01, 2019 - 19:33:32 UTC October 01, 2019 - 21:30:00 UTC   89 0 36.82208 -119.79917 35 6 4
1569958839:633849 633849 77 October 01, 2019 - 19:15:56 UTC October 01, 2019 - 21:30:00 UTC   19 0 36.82228 -119.80053 35 1 1
1569958839:633939 633939 77 October 01, 2019 - 17:37:51 UTC October 01, 2019 - 20:15:00 UTC October 01, 2019 - 20:15:00 UTC 1 0 36.80194 -119.76819 35 1 1
1569958839:634009 634009 77 October 01, 2019 - 18:58:57 UTC October 01, 2019 - 20:30:00 UTC October 01, 2019 - 20:30:00 UTC 1 0 36.78797 -119.81413 35 1 1
1569959424:633848 633848 78 October 01, 2019 - 19:45:17 UTC October 01, 2019 - 21:30:00 UTC   89 0 36.82208 -119.79917 35 6 4
1569959424:633849 633849 78 October 01, 2019 - 19:15:56 UTC October 01, 2019 - 21:30:00 UTC   19 0 36.82228 -119.80053 35 1 1
1569959424:633939 633939 78 October 01, 2019 - 17:37:51 UTC October 01, 2019 - 20:15:00 UTC October 01, 2019 - 20:15:00 UTC 1 0 36.80194 -119.76819 35 1 1
1569959424:634009 634009 78 October 01, 2019 - 18:58:57 UTC October 01, 2019 - 20:30:00 UTC October 01, 2019 - 20:30:00 UTC 1 0 36.78797 -119.81413 35 1 1
1569960023:633848 633848 79 October 01, 2019 - 19:48:44 UTC October 01, 2019 - 21:30:00 UTC   89 0 36.82208 -119.79917 35 6 4
1569960023:633849 633849 79 October 01, 2019 - 19:15:56 UTC October 01, 2019 - 21:30:00 UTC   19 0 36.82228 -119.80053 35 1 1
1569960023:633939 633939 79 October 01, 2019 - 17:37:51 UTC October 01, 2019 - 20:15:00 UTC October 01, 2019 - 20:15:00 UTC 1 0 36.80194 -119.76819 35 1 1
1569960023:634009 634009 79 October 01, 2019 - 18:58:57 UTC October 01, 2019 - 20:30:00 UTC October 01, 2019 - 20:30:00 UTC 1 0 36.78797 -119.81413 35 1 1
1569960633:633849 633849 80 October 01, 2019 - 19:15:56 UTC October 01, 2019 - 21:30:00 UTC   19 0 36.82228 -119.80053 35 1 1
Powered by Datasette · Query took 3.736ms · About: About this site