pge-outages

Custom SQL query returning 101 rows (hide)

Query parameters

idoutagesnapshotlastUpdateTimecurrentEtorautoEtorestCustAffectedhazardFlaglatitudelongituderegionNamecausecrewCurrentStatus
1569943255:633610 633610 51 October 01, 2019 - 15:07:17 UTC October 01, 2019 - 18:00:00 UTC October 01, 2019 - 18:00:00 UTC 1 0 37.60368 -122.02977 80 1 1
1569943834:633610 633610 52 October 01, 2019 - 15:15:38 UTC October 01, 2019 - 18:00:00 UTC October 01, 2019 - 18:00:00 UTC 1 0 37.60368 -122.02977 80 1 1
1569944417:633610 633610 53 October 01, 2019 - 15:23:05 UTC October 01, 2019 - 18:00:00 UTC October 01, 2019 - 18:00:00 UTC 1 0 37.60368 -122.02977 80 1 1
1569945023:633610 633610 54 October 01, 2019 - 15:39:43 UTC October 01, 2019 - 18:00:00 UTC October 01, 2019 - 18:00:00 UTC 1 0 37.60368 -122.02977 80 1 1
1569945622:633610 633610 55 October 01, 2019 - 15:39:43 UTC October 01, 2019 - 18:00:00 UTC October 01, 2019 - 18:00:00 UTC 1 0 37.60368 -122.02977 80 1 1
1569946235:633610 633610 56 October 01, 2019 - 15:39:43 UTC October 01, 2019 - 18:00:00 UTC October 01, 2019 - 18:00:00 UTC 1 0 37.60368 -122.02977 80 1 1
1569946828:633610 633610 57 October 01, 2019 - 16:09:25 UTC October 02, 2019 - 02:09:00 UTC   1 0 37.60368 -122.02977 80 1 5
1569947434:633610 633610 58 October 01, 2019 - 16:09:25 UTC October 02, 2019 - 02:09:00 UTC   1 0 37.60368 -122.02977 80 1 5
1569948031:633610 633610 59 October 01, 2019 - 16:09:25 UTC October 02, 2019 - 02:09:00 UTC   1 0 37.60368 -122.02977 80 1 5
1569948634:633610 633610 60 October 01, 2019 - 16:09:25 UTC October 02, 2019 - 02:09:00 UTC   1 0 37.60368 -122.02977 80 1 5
1569949236:633610 633610 61 October 01, 2019 - 16:09:25 UTC October 02, 2019 - 02:09:00 UTC   1 0 37.60368 -122.02977 80 1 5
1569949236:633883 633883 61 October 01, 2019 - 16:55:16 UTC October 01, 2019 - 19:45:00 UTC October 01, 2019 - 19:45:00 UTC 9 0 37.6083 -122.03215 80 1 1
1569949829:633610 633610 62 October 01, 2019 - 17:04:57 UTC October 02, 2019 - 02:09:00 UTC   1 0 37.60368 -122.02977 80 6 4
1569949829:633883 633883 62 October 01, 2019 - 17:00:05 UTC October 01, 2019 - 19:45:00 UTC October 01, 2019 - 19:45:00 UTC 9 0 37.6083 -122.03215 80 1 1
1569950417:633883 633883 63 October 01, 2019 - 17:00:05 UTC October 01, 2019 - 19:45:00 UTC October 01, 2019 - 19:45:00 UTC 9 0 37.6083 -122.03215 80 1 1
1569951021:633883 633883 64 October 01, 2019 - 17:00:05 UTC October 01, 2019 - 19:45:00 UTC October 01, 2019 - 19:45:00 UTC 9 0 37.6083 -122.03215 80 1 1
1569951616:633883 633883 65 October 01, 2019 - 17:00:05 UTC October 01, 2019 - 19:45:00 UTC October 01, 2019 - 19:45:00 UTC 9 0 37.6083 -122.03215 80 1 1
1569952233:633883 633883 66 October 01, 2019 - 17:00:05 UTC October 01, 2019 - 19:45:00 UTC October 01, 2019 - 19:45:00 UTC 9 0 37.6083 -122.03215 80 1 1
1569952839:633883 633883 67 October 01, 2019 - 17:00:05 UTC October 01, 2019 - 19:45:00 UTC October 01, 2019 - 19:45:00 UTC 9 0 37.6083 -122.03215 80 1 1
1569953462:633883 633883 68 October 01, 2019 - 17:00:05 UTC October 01, 2019 - 19:45:00 UTC October 01, 2019 - 19:45:00 UTC 9 0 37.6083 -122.03215 80 1 1
1569954055:633985 633985 69 October 01, 2019 - 18:14:37 UTC October 01, 2019 - 19:45:00 UTC October 01, 2019 - 19:45:00 UTC 1 0 37.6083 -122.03215 80 1 1
1569954621:633985 633985 70 October 01, 2019 - 18:14:37 UTC October 01, 2019 - 19:45:00 UTC October 01, 2019 - 19:45:00 UTC 1 0 37.6083 -122.03215 80 1 1
1569955253:633985 633985 71 October 01, 2019 - 18:14:37 UTC October 01, 2019 - 19:45:00 UTC October 01, 2019 - 19:45:00 UTC 1 0 37.6083 -122.03215 80 1 1
1569955842:633985 633985 72 October 01, 2019 - 18:14:37 UTC October 01, 2019 - 19:45:00 UTC October 01, 2019 - 19:45:00 UTC 1 0 37.6083 -122.03215 80 1 1
1569956437:633985 633985 73 October 01, 2019 - 18:14:37 UTC October 01, 2019 - 19:45:00 UTC October 01, 2019 - 19:45:00 UTC 1 0 37.6083 -122.03215 80 1 1
1569957023:633985 633985 74 October 01, 2019 - 18:14:37 UTC October 01, 2019 - 19:45:00 UTC October 01, 2019 - 19:45:00 UTC 1 0 37.6083 -122.03215 80 1 1
1569957630:633985 633985 75 October 01, 2019 - 19:08:32 UTC October 01, 2019 - 19:45:00 UTC October 01, 2019 - 19:45:00 UTC 1 0 37.6083 -122.03215 80 1 1
1569958225:633985 633985 76 October 01, 2019 - 19:08:32 UTC October 01, 2019 - 19:45:00 UTC October 01, 2019 - 19:45:00 UTC 1 0 37.6083 -122.03215 80 1 1
1570218015:643515 643515 494 October 04, 2019 - 19:24:43 UTC October 04, 2019 - 22:15:00 UTC October 04, 2019 - 22:15:00 UTC 1 1 37.59419 -122.02682 80 1 1
1570218625:643515 643515 495 October 04, 2019 - 19:24:43 UTC October 04, 2019 - 22:15:00 UTC October 04, 2019 - 22:15:00 UTC 1 1 37.59419 -122.02682 80 1 1
1570219228:643515 643515 496 October 04, 2019 - 19:50:10 UTC October 04, 2019 - 22:15:00 UTC October 04, 2019 - 22:15:00 UTC 1 1 37.59419 -122.02682 80 1 1
1570219836:643515 643515 497 October 04, 2019 - 19:50:10 UTC October 04, 2019 - 22:15:00 UTC October 04, 2019 - 22:15:00 UTC 1 1 37.59419 -122.02682 80 1 1
1570220413:643515 643515 498 October 04, 2019 - 19:50:10 UTC October 04, 2019 - 22:15:00 UTC October 04, 2019 - 22:15:00 UTC 1 1 37.59419 -122.02682 80 1 1
1570221024:643515 643515 499 October 04, 2019 - 19:50:10 UTC October 04, 2019 - 22:15:00 UTC October 04, 2019 - 22:15:00 UTC 1 1 37.59419 -122.02682 80 1 5
1570221633:643515 643515 500 October 04, 2019 - 19:50:10 UTC October 04, 2019 - 22:15:00 UTC October 04, 2019 - 22:15:00 UTC 1 1 37.59419 -122.02682 80 1 5
1570222225:643515 643515 501 October 04, 2019 - 20:41:00 UTC October 04, 2019 - 22:15:00 UTC October 04, 2019 - 22:15:00 UTC 1 1 37.59419 -122.02682 80 6 4
1570222834:643515 643515 502 October 04, 2019 - 20:41:00 UTC October 04, 2019 - 22:15:00 UTC October 04, 2019 - 22:15:00 UTC 1 1 37.59419 -122.02682 80 6 4
1570223423:643515 643515 503 October 04, 2019 - 20:41:00 UTC October 04, 2019 - 22:15:00 UTC October 04, 2019 - 22:15:00 UTC 1 1 37.59419 -122.02682 80 6 4
1570224018:643515 643515 504 October 04, 2019 - 20:41:00 UTC October 04, 2019 - 22:15:00 UTC October 04, 2019 - 22:15:00 UTC 1 1 37.59419 -122.02682 80 6 4
1570224624:643515 643515 505 October 04, 2019 - 20:41:00 UTC October 04, 2019 - 22:15:00 UTC October 04, 2019 - 22:15:00 UTC 1 1 37.59419 -122.02682 80 6 4
1570225220:643515 643515 506 October 04, 2019 - 20:41:00 UTC October 04, 2019 - 22:15:00 UTC October 04, 2019 - 22:15:00 UTC 1 1 37.59419 -122.02682 80 6 4
1570225811:643515 643515 507 October 04, 2019 - 20:41:00 UTC October 04, 2019 - 22:15:00 UTC October 04, 2019 - 22:15:00 UTC 1 1 37.59419 -122.02682 80 6 4
1570226445:643515 643515 508 October 04, 2019 - 21:54:23 UTC October 05, 2019 - 01:00:00 UTC   1 1 37.59419 -122.02682 80 6 4
1570227017:643515 643515 509 October 04, 2019 - 21:54:23 UTC October 05, 2019 - 01:00:00 UTC   1 1 37.59419 -122.02682 80 6 4
1570227614:643515 643515 510 October 04, 2019 - 21:54:23 UTC October 05, 2019 - 01:00:00 UTC   1 1 37.59419 -122.02682 80 6 4
1570228218:643515 643515 511 October 04, 2019 - 21:54:23 UTC October 05, 2019 - 01:00:00 UTC   1 1 37.59419 -122.02682 80 6 4
1570228836:643515 643515 512 October 04, 2019 - 21:54:23 UTC October 05, 2019 - 01:00:00 UTC   1 1 37.59419 -122.02682 80 6 4
1570229417:643515 643515 513 October 04, 2019 - 21:54:23 UTC October 05, 2019 - 01:00:00 UTC   1 1 37.59419 -122.02682 80 6 4
1570568423:647535 647535 1069 October 08, 2019 - 20:49:38 UTC October 08, 2019 - 23:45:00 UTC October 08, 2019 - 23:45:00 UTC 1 0 37.59681 -122.01886 80 1 1
1570569022:647535 647535 1070 October 08, 2019 - 20:51:16 UTC October 08, 2019 - 23:45:00 UTC October 08, 2019 - 23:45:00 UTC 1 0 37.59681 -122.01886 80 1 1
1570569628:647535 647535 1071 October 08, 2019 - 20:51:16 UTC October 08, 2019 - 23:45:00 UTC October 08, 2019 - 23:45:00 UTC 1 0 37.59681 -122.01886 80 1 1
1570570222:647535 647535 1072 October 08, 2019 - 21:16:22 UTC October 09, 2019 - 02:16:00 UTC   1 0 37.59681 -122.01886 80 1 1
1570570826:647535 647535 1073 October 08, 2019 - 21:16:22 UTC October 09, 2019 - 02:16:00 UTC   1 0 37.59681 -122.01886 80 1 1
1570571412:647535 647535 1074 October 08, 2019 - 21:16:22 UTC October 09, 2019 - 02:16:00 UTC   1 0 37.59681 -122.01886 80 1 1
1570572039:647535 647535 1075 October 08, 2019 - 21:16:22 UTC October 09, 2019 - 02:16:00 UTC   1 0 37.59681 -122.01886 80 1 1
1570572631:647535 647535 1076 October 08, 2019 - 21:16:22 UTC October 09, 2019 - 02:16:00 UTC   1 0 37.59681 -122.01886 80 1 1
1570573819:647535 647535 1077 October 08, 2019 - 21:16:22 UTC October 09, 2019 - 02:16:00 UTC   1 0 37.59681 -122.01886 80 1 1
1570575031:647535 647535 1078 October 08, 2019 - 21:16:22 UTC October 09, 2019 - 02:16:00 UTC   1 0 37.59681 -122.01886 80 1 5
1570575630:647535 647535 1079 October 08, 2019 - 22:55:55 UTC October 09, 2019 - 02:16:00 UTC   1 0 37.59681 -122.01886 80 6 4
1570576221:647535 647535 1080 October 08, 2019 - 22:55:55 UTC October 09, 2019 - 02:16:00 UTC   1 0 37.59681 -122.01886 80 6 4
1570576817:647535 647535 1081 October 08, 2019 - 22:55:55 UTC October 09, 2019 - 02:16:00 UTC   1 0 37.59681 -122.01886 80 6 4
1570577422:647535 647535 1082 October 08, 2019 - 22:55:55 UTC October 09, 2019 - 02:16:00 UTC   1 0 37.59681 -122.01886 80 6 4
1570578018:647535 647535 1083 October 08, 2019 - 22:55:55 UTC October 09, 2019 - 02:16:00 UTC   1 0 37.59681 -122.01886 80 6 4
1570578612:647535 647535 1084 October 08, 2019 - 22:55:55 UTC October 09, 2019 - 02:16:00 UTC   1 0 37.59681 -122.01886 80 6 4
1570579822:647535 647535 1085 October 08, 2019 - 22:55:55 UTC October 09, 2019 - 02:16:00 UTC   1 0 37.59681 -122.01886 80 6 4
1570580416:647535 647535 1086 October 08, 2019 - 22:55:55 UTC October 09, 2019 - 02:16:00 UTC   1 0 37.59681 -122.01886 80 6 4
1570581024:647535 647535 1087 October 08, 2019 - 22:55:55 UTC October 09, 2019 - 02:16:00 UTC   1 0 37.59681 -122.01886 80 6 4
1570582223:647535 647535 1088 October 08, 2019 - 22:55:55 UTC October 09, 2019 - 02:16:00 UTC   1 0 37.59681 -122.01886 80 6 4
1570582816:647535 647535 1089 October 08, 2019 - 22:55:55 UTC October 09, 2019 - 02:16:00 UTC   1 0 37.59681 -122.01886 80 6 4
1570738222:653196 653196 1253 October 10, 2019 - 19:46:18 UTC     1 0 37.59304 -122.05933 80 1 1
1570738822:653196 653196 1254 October 10, 2019 - 19:46:18 UTC     1 0 37.59304 -122.05933 80 1 1
1570755639:653723 653723 1280 October 11, 2019 - 00:54:13 UTC     1 0 37.58493 -122.0209 80 1 1
1570755639:653724 653724 1280 October 11, 2019 - 00:54:02 UTC     1 0 37.59266 -122.02591 80 1 1
1570755639:653725 653725 1280 October 11, 2019 - 00:54:56 UTC     1 0 37.58721 -122.01909 80 1 1
1570756220:653723 653723 1281 October 11, 2019 - 00:54:13 UTC     1 0 37.58493 -122.0209 80 1 1
1570756220:653724 653724 1281 October 11, 2019 - 00:54:02 UTC     1 0 37.59266 -122.02591 80 1 1
1570756220:653725 653725 1281 October 11, 2019 - 00:54:56 UTC     1 0 37.58721 -122.01909 80 1 1
1570756815:653723 653723 1282 October 11, 2019 - 00:54:13 UTC     1 0 37.58493 -122.0209 80 1 1
1570756815:653724 653724 1282 October 11, 2019 - 00:54:02 UTC     1 0 37.59266 -122.02591 80 1 1
1570756815:653725 653725 1282 October 11, 2019 - 00:54:56 UTC     1 0 37.58721 -122.01909 80 1 1
1570757419:653723 653723 1283 October 11, 2019 - 00:54:13 UTC     1 0 37.58493 -122.0209 80 1 1
1570757419:653724 653724 1283 October 11, 2019 - 00:54:02 UTC     1 0 37.59266 -122.02591 80 1 1
1570757419:653725 653725 1283 October 11, 2019 - 00:54:56 UTC     1 0 37.58721 -122.01909 80 1 1
1570758024:653723 653723 1284 October 11, 2019 - 00:54:13 UTC     1 0 37.58493 -122.0209 80 1 1
1570758024:653724 653724 1284 October 11, 2019 - 00:54:02 UTC     1 0 37.59266 -122.02591 80 1 1
1570758024:653725 653725 1284 October 11, 2019 - 00:54:56 UTC     1 0 37.58721 -122.01909 80 1 5
1570758619:653723 653723 1285 October 11, 2019 - 00:54:13 UTC     1 0 37.58493 -122.0209 80 1 1
1570758619:653724 653724 1285 October 11, 2019 - 00:54:02 UTC     1 0 37.59266 -122.02591 80 1 1
1570758619:653725 653725 1285 October 11, 2019 - 00:54:56 UTC     1 0 37.58721 -122.01909 80 1 5
1570759218:653723 653723 1286 October 11, 2019 - 00:54:13 UTC     1 0 37.58493 -122.0209 80 1 1
1570759218:653724 653724 1286 October 11, 2019 - 00:54:02 UTC     1 0 37.59266 -122.02591 80 1 1
1570759218:653725 653725 1286 October 11, 2019 - 00:54:56 UTC     1 0 37.58721 -122.01909 80 1 5
1570760423:653723 653723 1287 October 11, 2019 - 00:54:13 UTC     1 0 37.58493 -122.0209 80 1 1
1570760423:653724 653724 1287 October 11, 2019 - 00:54:02 UTC     1 0 37.59266 -122.02591 80 1 1
1570760423:653725 653725 1287 October 11, 2019 - 02:14:48 UTC     1 0 37.58721 -122.01909 80 6 4
1570761077:653724 653724 1288 October 11, 2019 - 00:54:02 UTC     1 0 37.59266 -122.02591 80 1 5
1570761629:653724 653724 1289 October 11, 2019 - 00:54:02 UTC     1 0 37.59266 -122.02591 80 1 5
1570762215:653724 653724 1290 October 11, 2019 - 02:32:56 UTC     1 0 37.59266 -122.02591 80 6 3
1570763458:653724 653724 1291 October 11, 2019 - 02:32:56 UTC     1 0 37.59266 -122.02591 80 6 3
1570764016:653724 653724 1292 October 11, 2019 - 02:32:56 UTC     1 0 37.59266 -122.02591 80 6 3
1570765221:653724 653724 1293 October 11, 2019 - 02:32:56 UTC     1 0 37.59266 -122.02591 80 6 3
Powered by Datasette · Query took 510.928ms · About: About this site