pge-outages

Custom SQL query returning 101 rows (hide)

Query parameters

idoutagesnapshotlastUpdateTimecurrentEtorautoEtorestCustAffectedhazardFlaglatitudelongituderegionNamecausecrewCurrentStatus
1569913215:633485 633485 1 October 01, 2019 - 06:22:41 UTC October 01, 2019 - 15:00:00 UTC   6 0 38.1891 -120.82691 32 3 2
1569913838:633485 633485 2 October 01, 2019 - 06:22:41 UTC October 01, 2019 - 15:00:00 UTC   6 0 38.1891 -120.82691 32 3 2
1569914414:633485 633485 3 October 01, 2019 - 06:22:41 UTC October 01, 2019 - 15:00:00 UTC   6 0 38.1891 -120.82691 32 3 2
1569915019:633485 633485 4 October 01, 2019 - 06:22:41 UTC October 01, 2019 - 15:00:00 UTC   6 0 38.1891 -120.82691 32 3 2
1569915624:633485 633485 5 October 01, 2019 - 06:22:41 UTC October 01, 2019 - 15:00:00 UTC   6 0 38.1891 -120.82691 32 3 2
1569916231:633485 633485 6 October 01, 2019 - 06:22:41 UTC October 01, 2019 - 15:00:00 UTC   6 0 38.1891 -120.82691 32 3 2
1569916815:633485 633485 7 October 01, 2019 - 06:22:41 UTC October 01, 2019 - 15:00:00 UTC   6 0 38.1891 -120.82691 32 3 2
1569917417:633485 633485 8 October 01, 2019 - 06:22:41 UTC October 01, 2019 - 15:00:00 UTC   6 0 38.1891 -120.82691 32 3 2
1569918012:633485 633485 9 October 01, 2019 - 06:22:41 UTC October 01, 2019 - 15:00:00 UTC   6 0 38.1891 -120.82691 32 3 2
1569918645:633485 633485 10 October 01, 2019 - 06:22:41 UTC October 01, 2019 - 15:00:00 UTC   6 0 38.1891 -120.82691 32 3 2
1569919223:633485 633485 11 October 01, 2019 - 06:22:41 UTC October 01, 2019 - 15:00:00 UTC   6 0 38.1891 -120.82691 32 3 2
1569919823:633485 633485 12 October 01, 2019 - 06:22:41 UTC October 01, 2019 - 15:00:00 UTC   6 0 38.1891 -120.82691 32 3 2
1569920421:633485 633485 13 October 01, 2019 - 06:22:41 UTC October 01, 2019 - 15:00:00 UTC   6 0 38.1891 -120.82691 32 3 2
1569921023:633485 633485 14 October 01, 2019 - 06:22:41 UTC October 01, 2019 - 15:00:00 UTC   6 0 38.1891 -120.82691 32 3 2
1569921618:633485 633485 15 October 01, 2019 - 06:22:41 UTC October 01, 2019 - 15:00:00 UTC   6 0 38.1891 -120.82691 32 3 2
1569922217:633485 633485 16 October 01, 2019 - 06:22:41 UTC October 01, 2019 - 15:00:00 UTC   6 0 38.1891 -120.82691 32 3 2
1569922813:633485 633485 17 October 01, 2019 - 06:22:41 UTC October 01, 2019 - 15:00:00 UTC   6 0 38.1891 -120.82691 32 3 2
1569923412:633485 633485 18 October 01, 2019 - 06:22:41 UTC October 01, 2019 - 15:00:00 UTC   6 0 38.1891 -120.82691 32 3 2
1569924030:633485 633485 19 October 01, 2019 - 06:22:41 UTC October 01, 2019 - 15:00:00 UTC   6 0 38.1891 -120.82691 32 3 2
1569924614:633485 633485 20 October 01, 2019 - 06:22:41 UTC October 01, 2019 - 15:00:00 UTC   6 0 38.1891 -120.82691 32 3 2
1569925218:633485 633485 21 October 01, 2019 - 06:22:41 UTC October 01, 2019 - 15:00:00 UTC   6 0 38.1891 -120.82691 32 3 2
1569925819:633485 633485 22 October 01, 2019 - 06:22:41 UTC October 01, 2019 - 15:00:00 UTC   6 0 38.1891 -120.82691 32 3 2
1569926413:633485 633485 23 October 01, 2019 - 06:22:41 UTC October 01, 2019 - 15:00:00 UTC   6 0 38.1891 -120.82691 32 3 2
1569927022:633485 633485 24 October 01, 2019 - 06:22:41 UTC October 01, 2019 - 15:00:00 UTC   6 0 38.1891 -120.82691 32 3 2
1569927620:633485 633485 25 October 01, 2019 - 06:22:41 UTC October 01, 2019 - 15:00:00 UTC   6 0 38.1891 -120.82691 32 3 2
1569928219:633485 633485 26 October 01, 2019 - 06:22:41 UTC October 01, 2019 - 15:00:00 UTC   6 0 38.1891 -120.82691 32 3 2
1569928810:633485 633485 27 October 01, 2019 - 06:22:41 UTC October 01, 2019 - 15:00:00 UTC   6 0 38.1891 -120.82691 32 3 2
1569929414:633485 633485 28 October 01, 2019 - 06:22:41 UTC October 01, 2019 - 15:00:00 UTC   6 0 38.1891 -120.82691 32 3 2
1569946235:633795 633795 56 October 01, 2019 - 16:05:15 UTC October 01, 2019 - 22:00:00 UTC   1 0 38.26855 -120.76325 32 3 2
1569946828:633795 633795 57 October 01, 2019 - 16:05:15 UTC October 01, 2019 - 22:00:00 UTC   1 0 38.26855 -120.76325 32 3 2
1569946828:633810 633810 57 October 01, 2019 - 16:09:09 UTC October 01, 2019 - 22:00:00 UTC   2 0 38.21263 -120.75959 32 3 2
1569946828:633813 633813 57 October 01, 2019 - 16:09:48 UTC October 01, 2019 - 22:00:00 UTC   1 0 38.16742 -120.84556 32 3 1
1569947434:633795 633795 58 October 01, 2019 - 16:05:15 UTC October 01, 2019 - 22:00:00 UTC   1 0 38.26855 -120.76325 32 3 2
1569947434:633810 633810 58 October 01, 2019 - 16:09:09 UTC October 01, 2019 - 22:00:00 UTC   2 0 38.21263 -120.75959 32 3 2
1569947434:633813 633813 58 October 01, 2019 - 16:09:48 UTC October 01, 2019 - 22:00:00 UTC   1 0 38.16742 -120.84556 32 3 1
1569948031:633795 633795 59 October 01, 2019 - 16:05:15 UTC October 01, 2019 - 22:00:00 UTC   1 0 38.26855 -120.76325 32 3 2
1569948031:633810 633810 59 October 01, 2019 - 16:09:09 UTC October 01, 2019 - 22:00:00 UTC   2 0 38.21263 -120.75959 32 3 2
1569948031:633813 633813 59 October 01, 2019 - 16:09:48 UTC October 01, 2019 - 22:00:00 UTC   1 0 38.16742 -120.84556 32 3 1
1569948634:633795 633795 60 October 01, 2019 - 16:05:15 UTC October 01, 2019 - 22:00:00 UTC   1 0 38.26855 -120.76325 32 3 2
1569948634:633810 633810 60 October 01, 2019 - 16:09:09 UTC October 01, 2019 - 22:00:00 UTC   2 0 38.21263 -120.75959 32 3 2
1569948634:633813 633813 60 October 01, 2019 - 16:09:48 UTC October 01, 2019 - 22:00:00 UTC   1 0 38.16742 -120.84556 32 3 1
1569949236:633795 633795 61 October 01, 2019 - 16:05:15 UTC October 01, 2019 - 22:00:00 UTC   1 0 38.26855 -120.76325 32 3 2
1569949236:633810 633810 61 October 01, 2019 - 16:09:09 UTC October 01, 2019 - 22:00:00 UTC   2 0 38.21263 -120.75959 32 3 2
1569949236:633813 633813 61 October 01, 2019 - 16:09:48 UTC October 01, 2019 - 22:00:00 UTC   1 0 38.16742 -120.84556 32 3 1
1569949829:633795 633795 62 October 01, 2019 - 16:05:15 UTC October 01, 2019 - 22:00:00 UTC   1 0 38.26855 -120.76325 32 3 2
1569949829:633813 633813 62 October 01, 2019 - 16:09:48 UTC October 01, 2019 - 22:00:00 UTC   1 0 38.16742 -120.84556 32 3 1
1569950417:633813 633813 63 October 01, 2019 - 16:09:48 UTC October 01, 2019 - 22:00:00 UTC   1 0 38.16742 -120.84556 32 3 1
1569951021:633813 633813 64 October 01, 2019 - 16:09:48 UTC October 01, 2019 - 22:00:00 UTC   1 0 38.16742 -120.84556 32 3 1
1569951616:633813 633813 65 October 01, 2019 - 16:09:48 UTC October 01, 2019 - 22:00:00 UTC   1 0 38.16742 -120.84556 32 3 1
1569952233:633813 633813 66 October 01, 2019 - 16:09:48 UTC October 01, 2019 - 22:00:00 UTC   1 0 38.16742 -120.84556 32 3 1
1569952839:633813 633813 67 October 01, 2019 - 16:09:48 UTC October 01, 2019 - 22:00:00 UTC   1 0 38.16742 -120.84556 32 3 1
1569953462:633813 633813 68 October 01, 2019 - 16:09:48 UTC October 01, 2019 - 22:00:00 UTC   1 0 38.16742 -120.84556 32 3 1
1569954055:633813 633813 69 October 01, 2019 - 16:09:48 UTC October 01, 2019 - 22:00:00 UTC   1 0 38.16742 -120.84556 32 3 1
1569954621:633813 633813 70 October 01, 2019 - 16:09:48 UTC October 01, 2019 - 22:00:00 UTC   1 0 38.16742 -120.84556 32 3 1
1569955253:633813 633813 71 October 01, 2019 - 16:09:48 UTC October 01, 2019 - 22:00:00 UTC   1 0 38.16742 -120.84556 32 3 1
1569955842:633813 633813 72 October 01, 2019 - 16:09:48 UTC October 01, 2019 - 22:00:00 UTC   1 0 38.16742 -120.84556 32 3 1
1569956437:633813 633813 73 October 01, 2019 - 16:09:48 UTC October 01, 2019 - 22:00:00 UTC   1 0 38.16742 -120.84556 32 3 1
1569957023:633813 633813 74 October 01, 2019 - 16:09:48 UTC October 01, 2019 - 22:00:00 UTC   1 0 38.16742 -120.84556 32 3 1
1569957630:633813 633813 75 October 01, 2019 - 16:09:48 UTC October 01, 2019 - 22:00:00 UTC   1 0 38.16742 -120.84556 32 3 1
1569958225:633813 633813 76 October 01, 2019 - 16:09:48 UTC October 01, 2019 - 22:00:00 UTC   1 0 38.16742 -120.84556 32 3 1
1570119014:639149 639149 334 October 03, 2019 - 16:05:43 UTC October 03, 2019 - 19:00:00 UTC   2 0 38.20577 -120.89568 32 3 2
1570119626:639149 639149 335 October 03, 2019 - 16:05:43 UTC October 03, 2019 - 19:00:00 UTC   2 0 38.20577 -120.89568 32 3 2
1570120220:639149 639149 336 October 03, 2019 - 16:05:43 UTC October 03, 2019 - 19:00:00 UTC   2 0 38.20577 -120.89568 32 3 2
1570120220:639179 639179 336 October 03, 2019 - 16:16:18 UTC October 03, 2019 - 21:00:00 UTC   2 0 38.17047 -120.9182 32 3 2
1570120835:639149 639149 337 October 03, 2019 - 16:05:43 UTC October 03, 2019 - 19:00:00 UTC   2 0 38.20577 -120.89568 32 3 2
1570120835:639179 639179 337 October 03, 2019 - 16:16:18 UTC October 03, 2019 - 21:00:00 UTC   2 0 38.17047 -120.9182 32 3 2
1570121429:639149 639149 338 October 03, 2019 - 16:05:43 UTC October 03, 2019 - 19:00:00 UTC   2 0 38.20577 -120.89568 32 3 2
1570121429:639179 639179 338 October 03, 2019 - 16:16:18 UTC October 03, 2019 - 21:00:00 UTC   2 0 38.17047 -120.9182 32 3 2
1570122028:639149 639149 339 October 03, 2019 - 16:05:43 UTC October 03, 2019 - 19:00:00 UTC   2 0 38.20577 -120.89568 32 3 2
1570122028:639179 639179 339 October 03, 2019 - 16:16:18 UTC October 03, 2019 - 21:00:00 UTC   2 0 38.17047 -120.9182 32 3 2
1570122619:639149 639149 340 October 03, 2019 - 16:05:43 UTC October 03, 2019 - 19:00:00 UTC   2 0 38.20577 -120.89568 32 3 2
1570122619:639179 639179 340 October 03, 2019 - 16:16:18 UTC October 03, 2019 - 21:00:00 UTC   2 0 38.17047 -120.9182 32 3 2
1570123221:639149 639149 341 October 03, 2019 - 16:05:43 UTC October 03, 2019 - 19:00:00 UTC   2 0 38.20577 -120.89568 32 3 2
1570123221:639179 639179 341 October 03, 2019 - 16:16:18 UTC October 03, 2019 - 21:00:00 UTC   2 0 38.17047 -120.9182 32 3 2
1570123833:639149 639149 342 October 03, 2019 - 16:05:43 UTC October 03, 2019 - 19:00:00 UTC   2 0 38.20577 -120.89568 32 3 2
1570123833:639179 639179 342 October 03, 2019 - 16:16:18 UTC October 03, 2019 - 21:00:00 UTC   2 0 38.17047 -120.9182 32 3 2
1570124423:639179 639179 343 October 03, 2019 - 16:16:18 UTC October 03, 2019 - 21:00:00 UTC   2 0 38.17047 -120.9182 32 3 2
1570125030:639179 639179 344 October 03, 2019 - 16:16:18 UTC October 03, 2019 - 21:00:00 UTC   2 0 38.17047 -120.9182 32 3 2
1570125630:639179 639179 345 October 03, 2019 - 16:16:18 UTC October 03, 2019 - 21:00:00 UTC   2 0 38.17047 -120.9182 32 3 2
1570126221:639179 639179 346 October 03, 2019 - 16:16:18 UTC October 03, 2019 - 21:00:00 UTC   2 0 38.17047 -120.9182 32 3 2
1570126823:639179 639179 347 October 03, 2019 - 16:16:18 UTC October 03, 2019 - 21:00:00 UTC   2 0 38.17047 -120.9182 32 3 2
1570127427:639179 639179 348 October 03, 2019 - 16:16:18 UTC October 03, 2019 - 21:00:00 UTC   2 0 38.17047 -120.9182 32 3 2
1570128024:639179 639179 349 October 03, 2019 - 16:16:18 UTC October 03, 2019 - 21:00:00 UTC   2 0 38.17047 -120.9182 32 3 2
1570128625:639179 639179 350 October 03, 2019 - 16:16:18 UTC October 03, 2019 - 21:00:00 UTC   2 0 38.17047 -120.9182 32 3 2
1570129232:639179 639179 351 October 03, 2019 - 16:16:18 UTC October 03, 2019 - 21:00:00 UTC   2 0 38.17047 -120.9182 32 3 2
1570129818:639179 639179 352 October 03, 2019 - 16:16:18 UTC October 03, 2019 - 21:00:00 UTC   2 0 38.17047 -120.9182 32 3 2
1570130416:639179 639179 353 October 03, 2019 - 16:16:18 UTC October 03, 2019 - 21:00:00 UTC   2 0 38.17047 -120.9182 32 3 2
1570131013:639179 639179 354 October 03, 2019 - 16:16:18 UTC October 03, 2019 - 21:00:00 UTC   2 0 38.17047 -120.9182 32 3 2
1570205420:642756 642756 473 October 04, 2019 - 16:05:48 UTC October 04, 2019 - 19:00:00 UTC   2 0 38.17702 -120.92811 32 3 2
1570206026:642756 642756 474 October 04, 2019 - 16:05:48 UTC October 04, 2019 - 19:00:00 UTC   2 0 38.17702 -120.92811 32 3 2
1570206026:642759 642759 474 October 04, 2019 - 16:06:27 UTC October 04, 2019 - 19:00:00 UTC   1 0 38.18201 -120.93287 32 3 2
1570206627:642756 642756 475 October 04, 2019 - 16:05:48 UTC October 04, 2019 - 19:00:00 UTC   2 0 38.17702 -120.92811 32 3 2
1570207232:642756 642756 476 October 04, 2019 - 16:05:48 UTC October 04, 2019 - 19:00:00 UTC   2 0 38.17702 -120.92811 32 3 2
1570207812:642756 642756 477 October 04, 2019 - 16:05:48 UTC October 04, 2019 - 19:00:00 UTC   2 0 38.17702 -120.92811 32 3 2
1570208451:642756 642756 478 October 04, 2019 - 16:05:48 UTC October 04, 2019 - 19:00:00 UTC   2 0 38.17702 -120.92811 32 3 2
1570209023:642756 642756 479 October 04, 2019 - 16:05:48 UTC October 04, 2019 - 19:00:00 UTC   2 0 38.17702 -120.92811 32 3 2
1570288228:643959 643959 611 October 05, 2019 - 15:04:47 UTC October 05, 2019 - 23:00:00 UTC   1 0 38.25805 -120.75958 32 3 2
1570288816:643959 643959 612 October 05, 2019 - 15:04:47 UTC October 05, 2019 - 23:00:00 UTC   1 0 38.25805 -120.75958 32 3 2
1570289416:643959 643959 613 October 05, 2019 - 15:04:47 UTC October 05, 2019 - 23:00:00 UTC   1 0 38.25805 -120.75958 32 3 2
1570290020:643959 643959 614 October 05, 2019 - 15:04:47 UTC October 05, 2019 - 23:00:00 UTC   1 0 38.25805 -120.75958 32 3 2
1570290627:643959 643959 615 October 05, 2019 - 15:04:47 UTC October 05, 2019 - 23:00:00 UTC   1 0 38.25805 -120.75958 32 3 2
Powered by Datasette · Query took 107.54ms · About: About this site