outage_snapshots

2,556 rows where snapshot = 1269 sorted by cause

View and edit SQL

id outage snapshot lastUpdateTime currentEtor autoEtor estCustAffected hazardFlag latitude longitude regionName cause ▼ crewCurrentStatus
1570749020:651138 651138 651138 2019-10-10 16:10:20-07:00 1269 October 10, 2019 - 03:34:00 UTC     1 0 40.4653 -122.28053 Anderson 106 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570749020:653577 653577 653577 2019-10-10 16:10:20-07:00 1269 October 10, 2019 - 22:57:31 UTC     1 0 38.9509 -122.09964 Arbuckle 457 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570749020:651632 651632 651632 2019-10-10 16:10:20-07:00 1269 October 10, 2019 - 06:24:29 UTC     1 0 38.88169 -121.07374 Auburn 181 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570749020:653568 653568 653568 2019-10-10 16:10:20-07:00 1269 October 10, 2019 - 23:01:10 UTC October 11, 2019 - 02:00:00 UTC October 11, 2019 - 02:00:00 UTC 1 0 35.34753 -119.04656 Bakersfield 2 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1570749020:653546 653546 653546 2019-10-10 16:10:20-07:00 1269 October 10, 2019 - 22:42:35 UTC     1 0 37.8844 -122.25534 Berkeley 47 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570749020:652332 652332 652332 2019-10-10 16:10:20-07:00 1269 October 10, 2019 - 22:39:18 UTC     13 0 37.89569 -122.26386 Berkeley 47 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570749020:652246 652246 652246 2019-10-10 16:10:20-07:00 1269 October 10, 2019 - 13:33:42 UTC     17 0 37.88598 -122.26681 Berkeley 47 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570749020:651171 651171 651171 2019-10-10 16:10:20-07:00 1269 October 10, 2019 - 03:44:46 UTC     1 0 38.68644 -120.99916 Cameron Park 101 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570749020:653408 653408 653408 2019-10-10 16:10:20-07:00 1269 October 10, 2019 - 21:24:56 UTC     1 0 36.56004 -121.9227 Carmel-by-the-Sea 715 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570749020:652987 652987 652987 2019-10-10 16:10:20-07:00 1269 October 10, 2019 - 18:24:48 UTC     1 0 37.70156 -122.04593 Castro Valley 4 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570749020:653392 653392 653392 2019-10-10 16:10:20-07:00 1269 October 10, 2019 - 21:02:54 UTC     1 0 37.71387 -122.07219 Castro Valley 4 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570749020:653549 653549 653549 2019-10-10 16:10:20-07:00 1269 October 10, 2019 - 23:05:55 UTC     828 0 39.76373 -121.86864 Chico 41 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570749020:653357 653357 653357 2019-10-10 16:10:20-07:00 1269 October 10, 2019 - 20:42:12 UTC     1 0 39.76811 -121.85277 Chico 41 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570749020:653528 653528 653528 2019-10-10 16:10:20-07:00 1269 October 10, 2019 - 23:01:17 UTC     1 1 37.88557 -121.84111 Clayton 53 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570749020:653446 653446 653446 2019-10-10 16:10:20-07:00 1269 October 10, 2019 - 22:12:51 UTC     12 0 37.9246 -121.91867 Clayton 53 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570749020:653487 653487 653487 2019-10-10 16:10:20-07:00 1269 October 10, 2019 - 21:56:28 UTC     1 0 38.80027 -123.01879 Cloverdale 81 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570749020:653526 653526 653526 2019-10-10 16:10:20-07:00 1269 October 10, 2019 - 22:38:32 UTC     1 1 39.21506 -122.00579 Colusa 132 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1570749020:652935 652935 652935 2019-10-10 16:10:20-07:00 1269 October 10, 2019 - 17:55:56 UTC     1 1 37.98562 -121.99993 Concord 46 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570749020:652694 652694 652694 2019-10-10 16:10:20-07:00 1269 October 10, 2019 - 21:48:32 UTC     1 1 37.9239 -122.50101 Corte Madera 387 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570749020:652891 652891 652891 2019-10-10 16:10:20-07:00 1269 October 10, 2019 - 17:43:38 UTC     1 0 40.4104 -122.25235 Cottonwood 56 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570749020:651462 651462 651462 2019-10-10 16:10:20-07:00 1269 October 10, 2019 - 05:02:34 UTC     1 0 40.39962 -122.25184 Cottonwood 56 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570749020:653563 653563 653563 2019-10-10 16:10:20-07:00 1269 October 10, 2019 - 22:50:39 UTC     1 0 37.31664 -122.0696 Cupertino 123 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570749020:653535 653535 653535 2019-10-10 16:10:20-07:00 1269 October 10, 2019 - 22:36:08 UTC     1 0 37.32957 -122.05645 Cupertino 123 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570749020:652710 652710 652710 2019-10-10 16:10:20-07:00 1269 October 10, 2019 - 22:10:36 UTC     3 0 37.32089 -122.18727 Cupertino 123 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570749020:653441 653441 653441 2019-10-10 16:10:20-07:00 1269 October 10, 2019 - 21:42:31 UTC     1 0 37.31812 -122.07124 Cupertino 123 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570749020:653411 653411 653411 2019-10-10 16:10:20-07:00 1269 October 10, 2019 - 21:20:25 UTC     1 0 37.84253 -121.97021 Danville 213 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570749020:653434 653434 653434 2019-10-10 16:10:20-07:00 1269 October 10, 2019 - 21:36:29 UTC     1 0 37.84344 -121.96855 Danville 213 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570749020:653114 653114 653114 2019-10-10 16:10:20-07:00 1269 October 10, 2019 - 19:19:42 UTC     1 0 37.83716 -121.96453 Diablo 707 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570749020:653430 653430 653430 2019-10-10 16:10:20-07:00 1269 October 10, 2019 - 21:34:36 UTC     1 0 37.84289 -121.96361 Diablo 707 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570749020:653450 653450 653450 2019-10-10 16:10:20-07:00 1269 October 10, 2019 - 21:53:20 UTC     1 1 37.17151 -120.65423 Dos Palos 394 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570749020:653508 653508 653508 2019-10-10 16:10:20-07:00 1269 October 10, 2019 - 22:13:39 UTC     1 0 37.39315 -121.82349 East Foothills 133 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570749020:653581 653581 653581 2019-10-10 16:10:20-07:00 1269 October 10, 2019 - 22:58:47 UTC     1 0 37.3757 -121.80222 East Foothills 133 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570749020:653578 653578 653578 2019-10-10 16:10:20-07:00 1269 October 10, 2019 - 22:58:07 UTC     10 0 37.97768 -120.34091 East Sonora 680 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570749020:653536 653536 653536 2019-10-10 16:10:20-07:00 1269 October 10, 2019 - 22:36:21 UTC     1 0 38.67389 -121.00557 El Dorado Hills 298 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570749020:653495 653495 653495 2019-10-10 16:10:20-07:00 1269 October 10, 2019 - 22:28:38 UTC     1 0 40.79134 -124.16512 Eureka 6 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1570749020:653335 653335 653335 2019-10-10 16:10:20-07:00 1269 October 10, 2019 - 22:28:18 UTC     1 0 40.78695 -124.1692 Eureka 6 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570749020:653548 653548 653548 2019-10-10 16:10:20-07:00 1269 October 10, 2019 - 22:54:15 UTC     1 0 37.99945 -122.5935 Fairfax 226 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570749020:652378 652378 652378 2019-10-10 16:10:20-07:00 1269 October 10, 2019 - 12:44:30 UTC     1 0 38.23098 -122.13261 Fairfield 169 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570749020:651121 651121 651121 2019-10-10 16:10:20-07:00 1269 October 10, 2019 - 06:47:20 UTC     84 0 38.29748 -121.96977 Fairfield 169 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570749020:651438 651438 651438 2019-10-10 16:10:20-07:00 1269 October 10, 2019 - 04:49:57 UTC     1 0 38.29434 -121.97406 Fairfield 169 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570749020:652701 652701 652701 2019-10-10 16:10:20-07:00 1269 October 10, 2019 - 21:57:35 UTC     1 1 38.28702 -121.98021 Fairfield 169 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570749020:653580 653580 653580 2019-10-10 16:10:20-07:00 1269 October 10, 2019 - 23:03:58 UTC October 11, 2019 - 02:15:00 UTC October 11, 2019 - 02:15:00 UTC 1 1 35.15658 -119.46201 Ford City 719 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570749020:653537 653537 653537 2019-10-10 16:10:20-07:00 1269 October 10, 2019 - 22:54:21 UTC October 11, 2019 - 01:30:00 UTC October 11, 2019 - 01:30:00 UTC 1 0 36.59844 -119.64788 Fowler 89 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570749020:653150 653150 653150 2019-10-10 16:10:20-07:00 1269 October 10, 2019 - 19:27:18 UTC     1 0 37.54427 -121.95136 Fremont 140 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570749020:653591 653591 653591 2019-10-10 16:10:20-07:00 1269 October 10, 2019 - 23:04:39 UTC October 11, 2019 - 01:45:00 UTC October 11, 2019 - 01:45:00 UTC 1 1 36.77547 -119.77578 Fresno 35 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570749020:653387 653387 653387 2019-10-10 16:10:20-07:00 1269 October 10, 2019 - 20:59:51 UTC     1 0 38.79551 -121.12884 Granite Bay 531 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570749020:653386 653386 653386 2019-10-10 16:10:20-07:00 1269 October 10, 2019 - 20:59:22 UTC     1 0 38.78717 -121.16313 Granite Bay 531 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570749020:653589 653589 653589 2019-10-10 16:10:20-07:00 1269 October 10, 2019 - 23:05:26 UTC     1 0 38.00876 -122.274 Hercules 720 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570749020:653571 653571 653571 2019-10-10 16:10:20-07:00 1269 October 10, 2019 - 22:58:26 UTC     1 0 36.89448 -121.35458 Hollister 201 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1570749020:653570 653570 653570 2019-10-10 16:10:20-07:00 1269 October 10, 2019 - 23:00:52 UTC     1 0 36.89977 -121.3536 Hollister 201 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570749020:653582 653582 653582 2019-10-10 16:10:20-07:00 1269 October 10, 2019 - 22:58:47 UTC     1 0 36.90231 -121.35288 Hollister 201 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570749020:653042 653042 653042 2019-10-10 16:10:20-07:00 1269 October 10, 2019 - 18:50:04 UTC     1 0 38.35952 -120.77855 Jackson 360 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570749020:653564 653564 653564 2019-10-10 16:10:20-07:00 1269 October 10, 2019 - 22:50:49 UTC     1 0 37.90761 -122.27032 Kensington 134 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570749020:653545 653545 653545 2019-10-10 16:10:20-07:00 1269 October 10, 2019 - 22:57:22 UTC     39 0 37.95355 -122.53524 Kentfield 153 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570749020:652334 652334 652334 2019-10-10 16:10:20-07:00 1269 October 10, 2019 - 22:19:47 UTC     1 0 37.89467 -122.10751 Lafayette 155 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570749020:653347 653347 653347 2019-10-10 16:10:20-07:00 1269 October 10, 2019 - 20:36:46 UTC     1 1 37.91427 -122.11819 Lafayette 155 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570749020:652692 652692 652692 2019-10-10 16:10:20-07:00 1269 October 10, 2019 - 22:20:04 UTC     1 1 37.93017 -122.53797 Larkspur 382 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570749020:653489 653489 653489 2019-10-10 16:10:20-07:00 1269 October 10, 2019 - 22:27:27 UTC     1 0 37.67601 -121.72345 Livermore 12 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570749020:653433 653433 653433 2019-10-10 16:10:20-07:00 1269 October 10, 2019 - 22:27:54 UTC     1 0 37.69155 -121.79411 Livermore 12 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570749020:652286 652286 652286 2019-10-10 16:10:20-07:00 1269 October 10, 2019 - 16:37:06 UTC     1 0 37.21268 -121.956 Los Gatos 121 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570749020:646975 646975 646975 2019-10-10 16:10:20-07:00 1269 October 09, 2019 - 00:54:10 UTC     56 0 37.57056 -119.94187 Midpines 211 Unknown - PG&E will be assessing the cause. 1 PG&E is unable to access the affected equipment. 6
1570749020:653033 653033 653033 2019-10-10 16:10:20-07:00 1269 October 10, 2019 - 18:50:55 UTC     1 1 37.90696 -122.55664 Mill Valley 239 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570749020:653561 653561 653561 2019-10-10 16:10:20-07:00 1269 October 10, 2019 - 22:53:44 UTC     1 1 37.46232 -121.90458 Milpitas 142 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570749020:652875 652875 652875 2019-10-10 16:10:20-07:00 1269 October 10, 2019 - 17:35:18 UTC     2 0 37.10707 -121.68336 Morgan Hill 319 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570749020:653404 653404 653404 2019-10-10 16:10:20-07:00 1269 October 10, 2019 - 21:13:34 UTC     1 0 37.14257 -121.6508 Morgan Hill 319 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570749020:653575 653575 653575 2019-10-10 16:10:20-07:00 1269 October 10, 2019 - 22:56:07 UTC     1 0 38.28839 -122.31106 Napa 15 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570749020:653427 653427 653427 2019-10-10 16:10:20-07:00 1269 October 10, 2019 - 21:48:32 UTC     1 1 37.32233 -121.00249 Newman 355 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570749020:653390 653390 653390 2019-10-10 16:10:20-07:00 1269 October 10, 2019 - 21:21:58 UTC     1 0 37.32066 -121.01812 Newman 355 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570749020:651144 651144 651144 2019-10-10 16:10:20-07:00 1269 October 10, 2019 - 03:24:40 UTC     1 0 38.92317 -121.08899 North Auburn 345 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570749020:653108 653108 653108 2019-10-10 16:10:20-07:00 1269 October 10, 2019 - 21:45:00 UTC     1 0 38.14025 -122.55315 Novato 93 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570749020:653368 653368 653368 2019-10-10 16:10:20-07:00 1269 October 10, 2019 - 21:44:34 UTC     1 0 38.11465 -122.57785 Novato 93 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570749020:653502 653502 653502 2019-10-10 16:10:20-07:00 1269 October 10, 2019 - 22:08:57 UTC     1 1 37.84728 -122.2564 Oakland 16 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570749020:653574 653574 653574 2019-10-10 16:10:20-07:00 1269 October 10, 2019 - 23:02:54 UTC     51 0 37.79427 -122.24226 Oakland 16 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570749020:652419 652419 652419 2019-10-10 16:10:20-07:00 1269 October 10, 2019 - 22:08:46 UTC     20 0 37.74688 -122.15804 Oakland 16 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570749020:653456 653456 653456 2019-10-10 16:10:20-07:00 1269 October 10, 2019 - 21:50:48 UTC     1 0 37.80207 -122.22493 Oakland 16 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570749020:653459 653459 653459 2019-10-10 16:10:20-07:00 1269 October 10, 2019 - 21:51:40 UTC     1 0 37.80354 -122.22492 Oakland 16 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570749020:652897 652897 652897 2019-10-10 16:10:20-07:00 1269 October 10, 2019 - 18:38:11 UTC     1 1 37.75886 -122.16851 Oakland 16 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570749020:652912 652912 652912 2019-10-10 16:10:20-07:00 1269 October 10, 2019 - 17:51:17 UTC     1 0 37.80275 -122.20612 Oakland 16 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570749020:652958 652958 652958 2019-10-10 16:10:20-07:00 1269 October 10, 2019 - 18:11:17 UTC     1 0 37.77216 -122.1894 Oakland 16 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570749020:653156 653156 653156 2019-10-10 16:10:20-07:00 1269 October 10, 2019 - 19:28:34 UTC     1 0 37.79555 -122.23403 Oakland 16 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570749020:652633 652633 652633 2019-10-10 16:10:20-07:00 1269 October 10, 2019 - 20:33:02 UTC     1 0 37.8207 -122.29019 Oakland 16 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570749020:652243 652243 652243 2019-10-10 16:10:20-07:00 1269 October 10, 2019 - 12:20:06 UTC     1 0 37.8009 -122.20755 Oakland 16 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570749020:653320 653320 653320 2019-10-10 16:10:20-07:00 1269 October 10, 2019 - 20:23:09 UTC     1 1 37.80878 -122.21622 Oakland 16 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570749020:653325 653325 653325 2019-10-10 16:10:20-07:00 1269 October 10, 2019 - 21:07:50 UTC     1 1 37.77698 -122.1899 Oakland 16 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570749020:653323 653323 653323 2019-10-10 16:10:20-07:00 1269 October 10, 2019 - 20:21:19 UTC     31 0 37.76754 -122.20938 Oakland 16 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570749020:652687 652687 652687 2019-10-10 16:10:20-07:00 1269 October 10, 2019 - 21:44:53 UTC     1 0 37.74077 -122.15966 Oakland 16 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570749020:653292 653292 653292 2019-10-10 16:10:20-07:00 1269 October 10, 2019 - 20:22:55 UTC     1 1 37.7649 -122.2011 Oakland 16 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570749020:653243 653243 653243 2019-10-10 16:10:20-07:00 1269 October 10, 2019 - 20:23:29 UTC     1 1 37.74432 -122.17478 Oakland 16 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570749020:653045 653045 653045 2019-10-10 16:10:20-07:00 1269 October 10, 2019 - 21:50:37 UTC     93 2 37.77212 -122.16524 Oakland 16 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570749020:653047 653047 653047 2019-10-10 16:10:20-07:00 1269 October 10, 2019 - 18:52:58 UTC     1 0 37.83885 -122.23151 Oakland 16 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570749020:652338 652338 652338 2019-10-10 16:10:20-07:00 1269 October 10, 2019 - 12:30:15 UTC     1 0 37.83958 -122.21016 Oakland 16 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570749020:652333 652333 652333 2019-10-10 16:10:20-07:00 1269 October 10, 2019 - 18:19:31 UTC     38 0 37.80248 -122.22711 Oakland 16 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570749020:652761 652761 652761 2019-10-10 16:10:20-07:00 1269 October 10, 2019 - 22:45:26 UTC     1 0 37.75034 -122.15433 Oakland 16 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570749020:652755 652755 652755 2019-10-10 16:10:20-07:00 1269 October 10, 2019 - 22:44:38 UTC     1 0 37.81484 -122.27444 Oakland 16 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570749020:652757 652757 652757 2019-10-10 16:10:20-07:00 1269 October 10, 2019 - 22:45:05 UTC     1 0 37.74559 -122.19311 Oakland 16 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570749020:653426 653426 653426 2019-10-10 16:10:20-07:00 1269 October 10, 2019 - 22:30:16 UTC     1 1 37.81108 -122.29968 Oakland 16 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570749020:653438 653438 653438 2019-10-10 16:10:20-07:00 1269 October 10, 2019 - 21:41:24 UTC     1 1 37.80092 -122.21638 Oakland 16 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570749020:653454 653454 653454 2019-10-10 16:10:20-07:00 1269 October 10, 2019 - 21:50:37 UTC     1 1 37.7719 -122.22944 Oakland 16 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570749020:653069 653069 653069 2019-10-10 16:10:20-07:00 1269 October 10, 2019 - 19:05:59 UTC     1 0 37.75738 -122.17091 Oakland 16 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570749020:653061 653061 653061 2019-10-10 16:10:20-07:00 1269 October 10, 2019 - 19:34:57 UTC     1 1 37.8435 -122.26892 Oakland 16 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE [outage_snapshots] (
   [id] TEXT PRIMARY KEY,
   [outage] INTEGER REFERENCES [outages]([id]),
   [snapshot] INTEGER REFERENCES [snapshots]([id]),
   [lastUpdateTime] INTEGER,
   [currentEtor] INTEGER,
   [autoEtor] INTEGER,
   [estCustAffected] INTEGER,
   [hazardFlag] INTEGER,
   [latitude] TEXT,
   [longitude] TEXT,
   [regionName] INTEGER REFERENCES [regionName]([id]),
   [cause] INTEGER REFERENCES [cause]([id]),
   [crewCurrentStatus] INTEGER REFERENCES [crewCurrentStatus]([id])
)
Powered by Datasette · Query took 2819.509ms · About: About this site