pge-outages

Custom SQL query returning 101 rows (hide)

Query parameters

idoutagesnapshotlastUpdateTimecurrentEtorautoEtorestCustAffectedhazardFlaglatitudelongituderegionNamecausecrewCurrentStatus
1570045818:637253 637253 213 October 02, 2019 - 19:33:58 UTC October 02, 2019 - 22:00:00 UTC October 02, 2019 - 22:00:00 UTC 1 0 37.49384 -122.2617 24 1 1
1570046432:637253 637253 214 October 02, 2019 - 19:33:58 UTC October 02, 2019 - 22:00:00 UTC October 02, 2019 - 22:00:00 UTC 1 0 37.49384 -122.2617 24 1 1
1570047036:637253 637253 215 October 02, 2019 - 19:33:58 UTC October 02, 2019 - 22:00:00 UTC October 02, 2019 - 22:00:00 UTC 1 0 37.49384 -122.2617 24 1 1
1570047622:637253 637253 216 October 02, 2019 - 19:33:58 UTC October 02, 2019 - 22:00:00 UTC October 02, 2019 - 22:00:00 UTC 1 0 37.49384 -122.2617 24 1 1
1570048216:637253 637253 217 October 02, 2019 - 19:33:58 UTC October 02, 2019 - 22:00:00 UTC October 02, 2019 - 22:00:00 UTC 1 0 37.49384 -122.2617 24 1 1
1570048826:637253 637253 218 October 02, 2019 - 19:33:58 UTC October 02, 2019 - 22:00:00 UTC October 02, 2019 - 22:00:00 UTC 1 0 37.49384 -122.2617 24 1 1
1570048826:637737 637737 218 October 02, 2019 - 20:36:08 UTC October 02, 2019 - 23:00:00 UTC October 02, 2019 - 23:00:00 UTC 1 0 37.51155 -122.25222 24 1 1
1570049420:637253 637253 219 October 02, 2019 - 19:33:58 UTC October 02, 2019 - 22:00:00 UTC October 02, 2019 - 22:00:00 UTC 1 0 37.49384 -122.2617 24 1 1
1570049420:637737 637737 219 October 02, 2019 - 20:36:08 UTC October 02, 2019 - 23:00:00 UTC October 02, 2019 - 23:00:00 UTC 1 0 37.51155 -122.25222 24 1 1
1570050027:637253 637253 220 October 02, 2019 - 19:33:58 UTC October 02, 2019 - 22:00:00 UTC October 02, 2019 - 22:00:00 UTC 1 0 37.49384 -122.2617 24 1 1
1570050027:637737 637737 220 October 02, 2019 - 20:54:38 UTC October 02, 2019 - 23:00:00 UTC October 02, 2019 - 23:00:00 UTC 1 0 37.51155 -122.25222 24 1 1
1570050628:637253 637253 221 October 02, 2019 - 19:33:58 UTC October 02, 2019 - 22:00:00 UTC October 02, 2019 - 22:00:00 UTC 1 0 37.49384 -122.2617 24 1 1
1570050628:637737 637737 221 October 02, 2019 - 20:54:38 UTC October 02, 2019 - 23:00:00 UTC October 02, 2019 - 23:00:00 UTC 1 0 37.51155 -122.25222 24 1 1
1570051221:637253 637253 222 October 02, 2019 - 19:33:58 UTC October 02, 2019 - 22:00:00 UTC October 02, 2019 - 22:00:00 UTC 1 0 37.49384 -122.2617 24 1 1
1570051221:637737 637737 222 October 02, 2019 - 20:54:38 UTC October 02, 2019 - 23:00:00 UTC October 02, 2019 - 23:00:00 UTC 1 0 37.51155 -122.25222 24 1 1
1570051813:637253 637253 223 October 02, 2019 - 19:33:58 UTC October 02, 2019 - 22:00:00 UTC October 02, 2019 - 22:00:00 UTC 1 0 37.49384 -122.2617 24 1 1
1570051813:637737 637737 223 October 02, 2019 - 20:54:38 UTC October 02, 2019 - 23:00:00 UTC October 02, 2019 - 23:00:00 UTC 1 0 37.51155 -122.25222 24 1 1
1570052422:637253 637253 224 October 02, 2019 - 21:30:24 UTC October 03, 2019 - 02:30:00 UTC   1 0 37.49384 -122.2617 24 1 1
1570052422:637737 637737 224 October 02, 2019 - 21:32:02 UTC October 02, 2019 - 23:00:00 UTC October 02, 2019 - 23:00:00 UTC 1 0 37.51155 -122.25222 24 1 1
1570053023:637253 637253 225 October 02, 2019 - 21:40:46 UTC October 03, 2019 - 02:30:00 UTC   1 0 37.49384 -122.2617 24 1 1
1570053023:637737 637737 225 October 02, 2019 - 21:40:33 UTC October 02, 2019 - 23:00:00 UTC October 02, 2019 - 23:00:00 UTC 1 0 37.51155 -122.25222 24 1 1
1570053631:637253 637253 226 October 02, 2019 - 21:40:46 UTC October 03, 2019 - 02:30:00 UTC   1 0 37.49384 -122.2617 24 1 1
1570053631:637737 637737 226 October 02, 2019 - 21:40:33 UTC October 02, 2019 - 23:00:00 UTC October 02, 2019 - 23:00:00 UTC 1 0 37.51155 -122.25222 24 1 1
1570054212:637253 637253 227 October 02, 2019 - 21:40:46 UTC October 03, 2019 - 02:30:00 UTC   1 0 37.49384 -122.2617 24 1 1
1570054212:637737 637737 227 October 02, 2019 - 21:40:33 UTC October 02, 2019 - 23:00:00 UTC October 02, 2019 - 23:00:00 UTC 1 0 37.51155 -122.25222 24 1 1
1570054822:637253 637253 228 October 02, 2019 - 21:40:46 UTC October 03, 2019 - 02:30:00 UTC   1 0 37.49384 -122.2617 24 1 1
1570054822:637737 637737 228 October 02, 2019 - 21:40:33 UTC October 02, 2019 - 23:00:00 UTC October 02, 2019 - 23:00:00 UTC 1 0 37.51155 -122.25222 24 1 1
1570055428:637253 637253 229 October 02, 2019 - 21:40:46 UTC October 03, 2019 - 02:30:00 UTC   1 0 37.49384 -122.2617 24 1 1
1570055428:637737 637737 229 October 02, 2019 - 21:40:33 UTC October 02, 2019 - 23:00:00 UTC October 02, 2019 - 23:00:00 UTC 1 0 37.51155 -122.25222 24 1 1
1570056020:637253 637253 230 October 02, 2019 - 21:40:46 UTC October 03, 2019 - 02:30:00 UTC   1 0 37.49384 -122.2617 24 1 1
1570056020:637737 637737 230 October 02, 2019 - 21:40:33 UTC October 02, 2019 - 23:00:00 UTC October 02, 2019 - 23:00:00 UTC 1 0 37.51155 -122.25222 24 1 1
1570056622:637253 637253 231 October 02, 2019 - 21:40:46 UTC October 03, 2019 - 02:30:00 UTC   1 0 37.49384 -122.2617 24 1 1
1570056622:637737 637737 231 October 02, 2019 - 21:40:33 UTC October 02, 2019 - 23:00:00 UTC October 02, 2019 - 23:00:00 UTC 1 0 37.51155 -122.25222 24 1 1
1570057223:637253 637253 232 October 02, 2019 - 21:40:46 UTC October 03, 2019 - 02:30:00 UTC   1 0 37.49384 -122.2617 24 1 1
1570057223:637737 637737 232 October 02, 2019 - 22:52:12 UTC October 03, 2019 - 04:52:00 UTC   1 0 37.51155 -122.25222 24 1 1
1570057821:637253 637253 233 October 02, 2019 - 21:40:46 UTC October 03, 2019 - 02:30:00 UTC   1 0 37.49384 -122.2617 24 1 1
1570057821:637737 637737 233 October 02, 2019 - 22:52:12 UTC October 03, 2019 - 04:52:00 UTC   1 0 37.51155 -122.25222 24 1 1
1570058417:637253 637253 234 October 02, 2019 - 21:40:46 UTC October 03, 2019 - 02:30:00 UTC   1 0 37.49384 -122.2617 24 1 1
1570058417:637737 637737 234 October 02, 2019 - 22:52:12 UTC October 03, 2019 - 04:52:00 UTC   1 0 37.51155 -122.25222 24 1 1
1570059023:637253 637253 235 October 02, 2019 - 21:40:46 UTC October 03, 2019 - 02:30:00 UTC   1 0 37.49384 -122.2617 24 1 1
1570059023:637737 637737 235 October 02, 2019 - 22:52:12 UTC October 03, 2019 - 04:52:00 UTC   1 0 37.51155 -122.25222 24 1 1
1570059614:637253 637253 236 October 02, 2019 - 21:40:46 UTC October 03, 2019 - 02:30:00 UTC   1 0 37.49384 -122.2617 24 1 1
1570059614:637737 637737 236 October 02, 2019 - 22:52:12 UTC October 03, 2019 - 04:52:00 UTC   1 0 37.51155 -122.25222 24 1 1
1570060219:637253 637253 237 October 02, 2019 - 21:40:46 UTC October 03, 2019 - 02:30:00 UTC   1 0 37.49384 -122.2617 24 1 1
1570060219:637737 637737 237 October 02, 2019 - 22:52:12 UTC October 03, 2019 - 04:52:00 UTC   1 0 37.51155 -122.25222 24 1 1
1570060834:637253 637253 238 October 02, 2019 - 21:40:46 UTC October 03, 2019 - 02:30:00 UTC   1 0 37.49384 -122.2617 24 1 1
1570060834:637737 637737 238 October 02, 2019 - 22:52:12 UTC October 03, 2019 - 04:52:00 UTC   1 0 37.51155 -122.25222 24 1 1
1570061433:637253 637253 239 October 02, 2019 - 21:40:46 UTC October 03, 2019 - 02:30:00 UTC   1 0 37.49384 -122.2617 24 1 1
1570061433:637737 637737 239 October 02, 2019 - 22:52:12 UTC October 03, 2019 - 04:52:00 UTC   1 0 37.51155 -122.25222 24 1 1
1570062022:637253 637253 240 October 02, 2019 - 21:40:46 UTC October 03, 2019 - 02:30:00 UTC   1 0 37.49384 -122.2617 24 1 1
1570062022:637737 637737 240 October 02, 2019 - 22:52:12 UTC October 03, 2019 - 04:52:00 UTC   1 0 37.51155 -122.25222 24 1 1
1570062631:637253 637253 241 October 02, 2019 - 21:40:46 UTC October 03, 2019 - 02:30:00 UTC   1 0 37.49384 -122.2617 24 1 1
1570062631:637737 637737 241 October 02, 2019 - 22:52:12 UTC October 03, 2019 - 04:52:00 UTC   1 0 37.51155 -122.25222 24 1 1
1570063216:637253 637253 242 October 02, 2019 - 21:40:46 UTC October 03, 2019 - 02:30:00 UTC   1 0 37.49384 -122.2617 24 1 1
1570063216:637737 637737 242 October 02, 2019 - 22:52:12 UTC October 03, 2019 - 04:52:00 UTC   1 0 37.51155 -122.25222 24 1 1
1570063816:637253 637253 243 October 02, 2019 - 21:40:46 UTC October 03, 2019 - 02:30:00 UTC   1 0 37.49384 -122.2617 24 1 1
1570063816:637737 637737 243 October 02, 2019 - 22:52:12 UTC October 03, 2019 - 04:52:00 UTC   1 0 37.51155 -122.25222 24 1 1
1570064430:637253 637253 244 October 02, 2019 - 21:40:46 UTC October 03, 2019 - 02:30:00 UTC   1 0 37.49384 -122.2617 24 1 1
1570064430:637737 637737 244 October 02, 2019 - 22:52:12 UTC October 03, 2019 - 04:52:00 UTC   1 0 37.51155 -122.25222 24 1 1
1570065022:637253 637253 245 October 02, 2019 - 21:40:46 UTC October 03, 2019 - 02:30:00 UTC   1 0 37.49384 -122.2617 24 1 1
1570065022:637737 637737 245 October 02, 2019 - 22:52:12 UTC October 03, 2019 - 04:52:00 UTC   1 0 37.51155 -122.25222 24 1 1
1570065616:637253 637253 246 October 02, 2019 - 21:40:46 UTC October 03, 2019 - 02:30:00 UTC   1 0 37.49384 -122.2617 24 1 1
1570065616:637737 637737 246 October 02, 2019 - 22:52:12 UTC October 03, 2019 - 04:52:00 UTC   1 0 37.51155 -122.25222 24 1 1
1570066217:637253 637253 247 October 02, 2019 - 21:40:46 UTC October 03, 2019 - 02:30:00 UTC   1 0 37.49384 -122.2617 24 1 5
1570066217:637737 637737 247 October 02, 2019 - 22:52:12 UTC October 03, 2019 - 04:52:00 UTC   1 0 37.51155 -122.25222 24 1 1
1570066840:637253 637253 248 October 03, 2019 - 01:30:39 UTC October 03, 2019 - 02:30:00 UTC   1 0 37.49384 -122.2617 24 1 5
1570066840:637737 637737 248 October 02, 2019 - 22:52:12 UTC October 03, 2019 - 04:52:00 UTC   1 0 37.51155 -122.25222 24 1 1
1570067419:637253 637253 249 October 03, 2019 - 01:38:58 UTC October 03, 2019 - 02:30:00 UTC   1 0 37.49384 -122.2617 24 6 4
1570067419:637737 637737 249 October 02, 2019 - 22:52:12 UTC October 03, 2019 - 04:52:00 UTC   1 0 37.51155 -122.25222 24 1 1
1570068016:637253 637253 250 October 03, 2019 - 01:38:58 UTC October 03, 2019 - 02:30:00 UTC   1 0 37.49384 -122.2617 24 6 4
1570068016:637737 637737 250 October 02, 2019 - 22:52:12 UTC October 03, 2019 - 04:52:00 UTC   1 0 37.51155 -122.25222 24 1 1
1570068627:637253 637253 251 October 03, 2019 - 02:05:02 UTC October 03, 2019 - 06:04:00 UTC   1 0 37.49384 -122.2617 24 6 4
1570068627:637737 637737 251 October 02, 2019 - 22:52:12 UTC October 03, 2019 - 04:52:00 UTC   1 0 37.51155 -122.25222 24 1 1
1570069252:637253 637253 252 October 03, 2019 - 02:05:02 UTC October 03, 2019 - 06:04:00 UTC   1 0 37.49384 -122.2617 24 6 4
1570069252:637737 637737 252 October 02, 2019 - 22:52:12 UTC October 03, 2019 - 04:52:00 UTC   1 0 37.51155 -122.25222 24 1 1
1570069819:637253 637253 253 October 03, 2019 - 02:05:02 UTC October 03, 2019 - 06:04:00 UTC   1 0 37.49384 -122.2617 24 6 4
1570069819:637737 637737 253 October 02, 2019 - 22:52:12 UTC October 03, 2019 - 04:52:00 UTC   1 0 37.51155 -122.25222 24 1 1
1570070412:637737 637737 254 October 02, 2019 - 22:52:12 UTC October 03, 2019 - 04:52:00 UTC   1 0 37.51155 -122.25222 24 1 5
1570071019:637737 637737 255 October 03, 2019 - 02:36:11 UTC October 03, 2019 - 04:52:00 UTC   1 0 37.51155 -122.25222 24 1 5
1570071613:637737 637737 256 October 03, 2019 - 02:36:11 UTC October 03, 2019 - 04:52:00 UTC   1 0 37.51155 -122.25222 24 1 5
1570072225:637737 637737 257 October 03, 2019 - 02:56:05 UTC October 03, 2019 - 04:52:00 UTC   1 0 37.51155 -122.25222 24 6 4
1570235424:643796 643796 523 October 05, 2019 - 00:21:09 UTC October 05, 2019 - 02:45:00 UTC October 05, 2019 - 02:45:00 UTC 1 1 37.51133 -122.27859 24 1 1
1570236018:643796 643796 524 October 05, 2019 - 00:29:08 UTC October 05, 2019 - 02:45:00 UTC October 05, 2019 - 02:45:00 UTC 1 1 37.51133 -122.27859 24 1 5
1570236619:643796 643796 525 October 05, 2019 - 00:29:08 UTC October 05, 2019 - 02:45:00 UTC October 05, 2019 - 02:45:00 UTC 1 1 37.51133 -122.27859 24 1 5
1570237214:643796 643796 526 October 05, 2019 - 00:29:08 UTC October 05, 2019 - 02:45:00 UTC October 05, 2019 - 02:45:00 UTC 1 1 37.51133 -122.27859 24 1 5
1570237826:643796 643796 527 October 05, 2019 - 00:29:08 UTC October 05, 2019 - 02:45:00 UTC October 05, 2019 - 02:45:00 UTC 1 1 37.51133 -122.27859 24 1 5
1570238425:643796 643796 528 October 05, 2019 - 00:29:08 UTC October 05, 2019 - 02:45:00 UTC October 05, 2019 - 02:45:00 UTC 1 1 37.51133 -122.27859 24 1 5
1570239019:643796 643796 529 October 05, 2019 - 01:24:54 UTC October 05, 2019 - 02:45:00 UTC October 05, 2019 - 02:45:00 UTC 1 1 37.51133 -122.27859 24 6 4
1570239619:643796 643796 530 October 05, 2019 - 01:24:54 UTC October 05, 2019 - 02:45:00 UTC October 05, 2019 - 02:45:00 UTC 1 1 37.51133 -122.27859 24 6 4
1570560032:647437 647437 1055 October 08, 2019 - 18:33:21 UTC October 08, 2019 - 21:00:00 UTC October 08, 2019 - 21:00:00 UTC 1 1 37.49363 -122.25923 24 1 1
1570560622:647437 647437 1056 October 08, 2019 - 18:37:49 UTC October 08, 2019 - 21:00:00 UTC October 08, 2019 - 21:00:00 UTC 1 1 37.49363 -122.25923 24 1 5
1570561220:647437 647437 1057 October 08, 2019 - 18:51:45 UTC October 08, 2019 - 21:00:00 UTC October 08, 2019 - 21:00:00 UTC 1 1 37.49363 -122.25923 24 6 4
1570566659:647519 647519 1066 October 08, 2019 - 20:26:07 UTC October 08, 2019 - 23:00:00 UTC October 08, 2019 - 23:00:00 UTC 1 1 37.50332 -122.2645 24 1 1
1570567215:647519 647519 1067 October 08, 2019 - 20:26:07 UTC October 08, 2019 - 23:00:00 UTC October 08, 2019 - 23:00:00 UTC 1 1 37.50332 -122.2645 24 1 1
1570567816:647519 647519 1068 October 08, 2019 - 20:37:52 UTC October 08, 2019 - 23:00:00 UTC October 08, 2019 - 23:00:00 UTC 1 1 37.50332 -122.2645 24 1 5
1570639226:650804 650804 1158 October 09, 2019 - 16:29:16 UTC October 09, 2019 - 19:00:00 UTC October 09, 2019 - 19:00:00 UTC 1 1 37.48704 -122.25296 24 1 1
1570639821:650804 650804 1159 October 09, 2019 - 16:29:16 UTC October 09, 2019 - 19:00:00 UTC October 09, 2019 - 19:00:00 UTC 1 1 37.48704 -122.25296 24 1 1
1570640424:650804 650804 1160 October 09, 2019 - 16:53:03 UTC October 09, 2019 - 19:00:00 UTC October 09, 2019 - 19:00:00 UTC 1 1 37.48704 -122.25296 24 1 1
1570641027:650804 650804 1161 October 09, 2019 - 16:53:03 UTC October 09, 2019 - 19:00:00 UTC October 09, 2019 - 19:00:00 UTC 1 1 37.48704 -122.25296 24 1 1
1570641639:650804 650804 1162 October 09, 2019 - 17:02:18 UTC October 09, 2019 - 19:00:00 UTC October 09, 2019 - 19:00:00 UTC 1 1 37.48704 -122.25296 24 1 5
1570642224:650804 650804 1163 October 09, 2019 - 17:02:18 UTC October 09, 2019 - 19:00:00 UTC October 09, 2019 - 19:00:00 UTC 1 1 37.48704 -122.25296 24 1 5
Powered by Datasette · Query took 56.773ms · About: About this site