outage_snapshots

82 rows where snapshot = 1081

View and edit SQL

id outage snapshot lastUpdateTime currentEtor autoEtor estCustAffected hazardFlag latitude longitude regionName cause crewCurrentStatus
1570576817:645732 645732 645732 2019-10-08 16:20:17-07:00 1081 October 08, 2019 - 14:21:44 UTC     6 1 37.57056 -119.94187 Midpines 211 Unknown - PG&E will be assessing the cause. 1 PG&E is sending a repair crew to the outage location. 3
1570576817:645873 645873 645873 2019-10-08 16:20:17-07:00 1081 October 07, 2019 - 15:46:59 UTC October 17, 2019 - 20:00:00 UTC   2 0 38.44571 -121.7909 Dixon 45 Our preliminary determination is that your outage was caused by scheduled maintenance work. 3 PG&E repair crew is on-site working to restore power. 2
1570576817:646975 646975 646975 2019-10-08 16:20:17-07:00 1081 October 08, 2019 - 04:35:31 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
1570576817:647047 647047 647047 2019-10-08 16:20:17-07:00 1081 October 08, 2019 - 18:55:30 UTC October 09, 2019 - 05:00:00 UTC   10 1 35.03975 -120.52247 Nipomo 413 Our preliminary determination is that your outage was caused by a car that hit a pole. 5 PG&E repair crew is on-site working to restore power. 2
1570576817:647052 647052 647052 2019-10-08 16:20:17-07:00 1081 October 08, 2019 - 23:14:23 UTC October 08, 2019 - 23:00:00 UTC   3 0 34.6738 -120.54618 Lompoc 260 Our preliminary determination is that your outage was caused by scheduled maintenance work. 3 PG&E repair crew is on-site working to restore power. 2
1570576817:647070 647070 647070 2019-10-08 16:20:17-07:00 1081 October 08, 2019 - 20:54:15 UTC October 09, 2019 - 05:00:00 UTC   17 1 37.28635 -121.98042 Campbell 43 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E repair crew is on-site working to restore power. 2
1570576817:647107 647107 647107 2019-10-08 16:20:17-07:00 1081 October 08, 2019 - 15:18:24 UTC October 08, 2019 - 19:00:00 UTC   1 0 37.84388 -122.47747 Sausalito 561 Our preliminary determination is that your outage was caused by scheduled maintenance work. 3 PG&E repair crew is on-site working to restore power. 2
1570576817:647114 647114 647114 2019-10-08 16:20:17-07:00 1081 October 08, 2019 - 22:05:11 UTC October 09, 2019 - 02:30:00 UTC   1 1 38.71719 -122.88165 Geyserville 82 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E repair crew is on-site working to restore power. 2
1570576817:647254 647254 647254 2019-10-08 16:20:17-07:00 1081 October 08, 2019 - 23:01:06 UTC October 09, 2019 - 00:00:00 UTC   1 1 37.35306 -122.0544 Sunnyvale 129 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E repair crew is on-site working to restore power. 2
1570576817:647263 647263 647263 2019-10-08 16:20:17-07:00 1081 October 08, 2019 - 23:04:20 UTC October 08, 2019 - 23:30:00 UTC   88 0 39.01591 -121.42158 Wheatland 526 Our preliminary determination is that your outage was caused by scheduled maintenance work. 3 PG&E repair crew is on-site working to restore power. 2
1570576817:647273 647273 647273 2019-10-08 16:20:17-07:00 1081 October 08, 2019 - 18:43:00 UTC October 09, 2019 - 00:00:00 UTC   15 0 37.9892 -122.57238 San Anselmo 183 Our preliminary determination is that your outage was caused by scheduled maintenance work. 3 PG&E repair crew is on-site working to restore power. 2
1570576817:647294 647294 647294 2019-10-08 16:20:17-07:00 1081 October 08, 2019 - 16:16:01 UTC October 08, 2019 - 23:00:00 UTC   3 0 38.57953 -122.60849 Calistoga 108 Our preliminary determination is that your outage was caused by scheduled maintenance work. 3 PG&E repair crew is on-site working to restore power. 2
1570576817:647296 647296 647296 2019-10-08 16:20:17-07:00 1081 October 08, 2019 - 21:36:48 UTC October 09, 2019 - 00:00:00 UTC   58 0 37.73709 -122.39116 San Francisco 25 Our preliminary determination is that your outage was caused by scheduled maintenance work. 3 PG&E repair crew is on-site working to restore power. 2
1570576817:647346 647346 647346 2019-10-08 16:20:17-07:00 1081 October 08, 2019 - 22:10:17 UTC October 09, 2019 - 04:00:00 UTC   368 0 37.98213 -122.47545 San Rafael 144 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1570576817:647377 647377 647377 2019-10-08 16:20:17-07:00 1081 October 08, 2019 - 23:15:03 UTC October 09, 2019 - 02:00:00 UTC   1 1 36.38557 -121.86779 Carmel 378 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1570576817:647399 647399 647399 2019-10-08 16:20:17-07:00 1081 October 08, 2019 - 23:14:00 UTC October 09, 2019 - 00:00:00 UTC   1 1 37.09853 -121.59436 San Martin 305 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E repair crew is en route to the outage location. 7
1570576817:647401 647401 647401 2019-10-08 16:20:17-07:00 1081 October 08, 2019 - 20:52:14 UTC October 08, 2019 - 23:30:00 UTC   1 1 38.34453 -122.50596 Glen Ellen 90 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570576817:647402 647402 647402 2019-10-08 16:20:17-07:00 1081 October 08, 2019 - 18:03:44 UTC October 08, 2019 - 20:45:00 UTC October 08, 2019 - 20:45:00 UTC 1 0 38.3419 -121.97948 Vacaville 367 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570576817:647429 647429 647429 2019-10-08 16:20:17-07:00 1081 October 08, 2019 - 21:22:19 UTC October 09, 2019 - 05:00:00 UTC   14 1 37.98502 -122.5953 Fairfax 226 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E repair crew is on-site working to restore power. 2
1570576817:647432 647432 647432 2019-10-08 16:20:17-07:00 1081 October 08, 2019 - 23:13:08 UTC October 09, 2019 - 02:00:00 UTC   1 0 37.01923 -121.57537 Gilroy 223 Our preliminary determination is that your outage was caused by an emergency issue. 4 PG&E repair crew is on-site working to restore power. 2
1570576817:647451 647451 647451 2019-10-08 16:20:17-07:00 1081 October 08, 2019 - 20:49:46 UTC October 08, 2019 - 21:45:00 UTC October 08, 2019 - 21:45:00 UTC 1 0 39.20999 -121.06002 Grass Valley 113 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570576817:647452 647452 647452 2019-10-08 16:20:17-07:00 1081 October 08, 2019 - 22:12:51 UTC October 09, 2019 - 00:33:00 UTC   1 0 36.53914 -119.94061 Caruthers 307 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1570576817:647453 647453 647453 2019-10-08 16:20:17-07:00 1081 October 08, 2019 - 22:32:05 UTC October 09, 2019 - 00:30:00 UTC   1 1 39.05738 -120.94833 Colfax 436 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1570576817:647462 647462 647462 2019-10-08 16:20:17-07:00 1081 October 08, 2019 - 19:16:23 UTC October 08, 2019 - 22:00:00 UTC   1 0 37.95528 -122.581 Fairfax 226 Our preliminary determination is that your outage was caused by scheduled maintenance work. 3 PG&E repair crew is on-site working to restore power. 2
1570576817:647474 647474 647474 2019-10-08 16:20:17-07:00 1081 October 08, 2019 - 19:46:32 UTC October 09, 2019 - 07:01:00 UTC   3 0 36.96025 -120.11704 Madera 76 Our preliminary determination is that your outage was caused by an emergency issue. 4 PG&E repair crew is on-site working to restore power. 2
1570576817:647475 647475 647475 2019-10-08 16:20:17-07:00 1081 October 08, 2019 - 20:08:36 UTC October 09, 2019 - 07:01:00 UTC   8 0 36.96019 -120.11646 Madera 76 Our preliminary determination is that your outage was caused by an emergency issue. 4 PG&E repair crew is on-site working to restore power. 2
1570576817:647481 647481 647481 2019-10-08 16:20:17-07:00 1081 October 08, 2019 - 21:39:18 UTC October 08, 2019 - 23:00:00 UTC   1 0 39.81358 -121.6256 Magalia 481 Our preliminary determination is that your outage was caused by scheduled maintenance work. 3 PG&E repair crew is on-site working to restore power. 2
1570576817:647492 647492 647492 2019-10-08 16:20:17-07:00 1081 October 08, 2019 - 23:15:13 UTC October 09, 2019 - 01:00:00 UTC   1 0 37.32088 -121.7563 San Jose 26 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E repair crew is on-site working to restore power. 2
1570576817:647494 647494 647494 2019-10-08 16:20:17-07:00 1081 October 08, 2019 - 22:56:56 UTC October 09, 2019 - 01:30:00 UTC   1 0 37.98901 -122.59885 Fairfax 226 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570576817:647503 647503 647503 2019-10-08 16:20:17-07:00 1081 October 08, 2019 - 23:13:23 UTC October 09, 2019 - 01:00:00 UTC   1 0 37.33176 -121.82419 San Jose 26 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1570576817:647508 647508 647508 2019-10-08 16:20:17-07:00 1081 October 08, 2019 - 23:06:37 UTC October 09, 2019 - 03:00:00 UTC   64 2 39.01287 -122.00809 College City 577 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E repair crew is en route to the outage location. 7
1570576817:647509 647509 647509 2019-10-08 16:20:17-07:00 1081 October 08, 2019 - 22:42:54 UTC October 09, 2019 - 01:33:00 UTC   1 0 37.76455 -122.4081 San Francisco 25 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1570576817:647516 647516 647516 2019-10-08 16:20:17-07:00 1081 October 08, 2019 - 21:49:56 UTC October 09, 2019 - 00:15:00 UTC October 09, 2019 - 00:15:00 UTC 1 0 36.32728 -121.29875 Soledad 31 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E is sending a repair crew to the outage location. 3
1570576817:647518 647518 647518 2019-10-08 16:20:17-07:00 1081 October 08, 2019 - 22:45:30 UTC October 09, 2019 - 06:59:00 UTC   217 1 39.22256 -121.05152 Grass Valley 113 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E repair crew is en route to the outage location. 7
1570576817:647520 647520 647520 2019-10-08 16:20:17-07:00 1081 October 08, 2019 - 23:12:41 UTC October 09, 2019 - 02:00:00 UTC   1 0 37.81516 -122.24685 Oakland 16 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1570576817:647529 647529 647529 2019-10-08 16:20:17-07:00 1081 October 08, 2019 - 20:51:25 UTC October 09, 2019 - 00:00:00 UTC October 09, 2019 - 00:00:00 UTC 1 0 37.88629 -121.06718 Stockton 78 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1570576817:647530 647530 647530 2019-10-08 16:20:17-07:00 1081 October 08, 2019 - 21:00:42 UTC October 09, 2019 - 00:15:00 UTC October 09, 2019 - 00:15:00 UTC 8 0 38.58743 -122.60587 Calistoga 108 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E is sending a repair crew to the outage location. 3
1570576817:647532 647532 647532 2019-10-08 16:20:17-07:00 1081 October 08, 2019 - 21:58:50 UTC October 09, 2019 - 00:00:00 UTC October 09, 2019 - 00:00:00 UTC 1 1 38.32296 -122.48244 Fetters Hot Springs-Agua Caliente 545 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570576817:647533 647533 647533 2019-10-08 16:20:17-07:00 1081 October 08, 2019 - 23:02:38 UTC October 09, 2019 - 00:15:00 UTC October 09, 2019 - 00:15:00 UTC 10 0 38.15754 -121.29742 Acampo 576 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1570576817:647535 647535 647535 2019-10-08 16:20:17-07:00 1081 October 08, 2019 - 22:55:55 UTC October 09, 2019 - 02:16:00 UTC   1 0 37.59681 -122.01886 Union City 80 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1570576817:647538 647538 647538 2019-10-08 16:20:17-07:00 1081 October 08, 2019 - 21:52:44 UTC October 09, 2019 - 00:30:00 UTC October 09, 2019 - 00:30:00 UTC 1 0 40.01706 -122.40928 Rancho Tehama Reserve 202 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1570576817:647539 647539 647539 2019-10-08 16:20:17-07:00 1081 October 08, 2019 - 23:09:53 UTC October 09, 2019 - 00:15:00 UTC October 09, 2019 - 00:15:00 UTC 1 0 38.66218 -121.79724 Woodland 34 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E is sending a repair crew to the outage location. 3
1570576817:647541 647541 647541 2019-10-08 16:20:17-07:00 1081 October 08, 2019 - 21:03:34 UTC October 09, 2019 - 00:15:00 UTC October 09, 2019 - 00:15:00 UTC 11 0 37.28709 -121.97957 Campbell 43 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570576817:647548 647548 647548 2019-10-08 16:20:17-07:00 1081 October 08, 2019 - 23:05:56 UTC October 09, 2019 - 02:05:00 UTC   1 0 36.49452 -119.34379 Monson 578 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E repair crew is on-site working to restore power. 2
1570576817:647550 647550 647550 2019-10-08 16:20:17-07:00 1081 October 08, 2019 - 21:20:18 UTC October 09, 2019 - 00:45:00 UTC October 09, 2019 - 00:45:00 UTC 1 0 39.20946 -122.00298 Colusa 132 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1570576817:647551 647551 647551 2019-10-08 16:20:17-07:00 1081 October 08, 2019 - 21:37:26 UTC October 08, 2019 - 23:00:00 UTC October 08, 2019 - 23:00:00 UTC 1 0 38.00501 -121.32183 Stockton 78 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570576817:647553 647553 647553 2019-10-08 16:20:17-07:00 1081 October 08, 2019 - 22:48:53 UTC October 09, 2019 - 00:15:00 UTC October 09, 2019 - 00:15:00 UTC 1 0 37.98484 -122.59424 Fairfax 226 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570576817:647557 647557 647557 2019-10-08 16:20:17-07:00 1081 October 08, 2019 - 23:08:27 UTC October 09, 2019 - 02:00:00 UTC October 09, 2019 - 02:00:00 UTC 542 0 34.9277 -119.62041 Cuyama 579 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1570576817:647559 647559 647559 2019-10-08 16:20:17-07:00 1081 October 08, 2019 - 22:38:47 UTC October 09, 2019 - 00:15:00 UTC October 09, 2019 - 00:15:00 UTC 1 0 37.79119 -122.25203 Oakland 16 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570576817:647560 647560 647560 2019-10-08 16:20:17-07:00 1081 October 08, 2019 - 22:49:05 UTC October 09, 2019 - 00:30:00 UTC October 09, 2019 - 00:30:00 UTC 1 1 37.94264 -122.08387 Pleasant Hill 277 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570576817:647562 647562 647562 2019-10-08 16:20:17-07:00 1081 October 08, 2019 - 23:09:43 UTC October 09, 2019 - 01:00:00 UTC October 09, 2019 - 01:00:00 UTC 1 1 39.16557 -122.89378 Upper Lake 580 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1570576817:647568 647568 647568 2019-10-08 16:20:17-07:00 1081 October 08, 2019 - 22:01:13 UTC October 09, 2019 - 00:45:00 UTC October 09, 2019 - 00:45:00 UTC 1 0 37.98568 -122.32511 Richmond 220 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570576817:647570 647570 647570 2019-10-08 16:20:17-07:00 1081 October 08, 2019 - 22:12:06 UTC October 09, 2019 - 01:00:00 UTC October 09, 2019 - 01:00:00 UTC 1 0 37.3116 -120.48638 Merced 13 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1570576817:647571 647571 647571 2019-10-08 16:20:17-07:00 1081 October 08, 2019 - 22:08:46 UTC October 09, 2019 - 00:15:00 UTC October 09, 2019 - 00:15:00 UTC 1 0 37.46904 -122.24348 Redwood City 256 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1570576817:647577 647577 647577 2019-10-08 16:20:17-07:00 1081 October 08, 2019 - 22:35:05 UTC October 09, 2019 - 00:34:00 UTC   24 0 39.2791 -121.6608 Live Oak 388 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E repair crew is on-site working to restore power. 2
1570576817:647579 647579 647579 2019-10-08 16:20:17-07:00 1081 October 08, 2019 - 22:42:44 UTC October 09, 2019 - 01:15:00 UTC October 09, 2019 - 01:15:00 UTC 53 0 37.28284 -121.83273 San Jose 26 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570576817:647580 647580 647580 2019-10-08 16:20:17-07:00 1081 October 08, 2019 - 22:35:51 UTC October 09, 2019 - 01:30:00 UTC October 09, 2019 - 01:30:00 UTC 1 1 38.41595 -122.90147 Sebastopol 99 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1570576817:647581 647581 647581 2019-10-08 16:20:17-07:00 1081 October 08, 2019 - 23:08:27 UTC October 09, 2019 - 02:00:00 UTC   25 0 36.9083 -119.08629 Shaver Lake 564 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E repair crew is on-site working to restore power. 2
1570576817:647583 647583 647583 2019-10-08 16:20:17-07:00 1081 October 08, 2019 - 22:26:48 UTC October 09, 2019 - 02:45:00 UTC October 09, 2019 - 02:45:00 UTC 1 1 36.39794 -121.65272 Carmel Valley 570 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570576817:647584 647584 647584 2019-10-08 16:20:17-07:00 1081 October 08, 2019 - 23:03:41 UTC October 09, 2019 - 02:00:00 UTC October 09, 2019 - 02:00:00 UTC 1 0 39.38457 -121.47659 Oroville 166 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1570576817:647585 647585 647585 2019-10-08 16:20:17-07:00 1081 October 08, 2019 - 22:29:42 UTC October 09, 2019 - 01:00:00 UTC October 09, 2019 - 01:00:00 UTC 1 0 37.75648 -122.41889 San Francisco 25 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570576817:647586 647586 647586 2019-10-08 16:20:17-07:00 1081 October 08, 2019 - 22:35:59 UTC October 09, 2019 - 02:45:00 UTC October 09, 2019 - 02:45:00 UTC 1 0 40.89218 -123.57995 Salyer 514 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1570576817:647587 647587 647587 2019-10-08 16:20:17-07:00 1081 October 08, 2019 - 22:39:30 UTC October 09, 2019 - 02:00:00 UTC October 09, 2019 - 02:00:00 UTC 1 0 37.94578 -121.95289 Concord 46 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570576817:647588 647588 647588 2019-10-08 16:20:17-07:00 1081 October 08, 2019 - 22:38:08 UTC October 09, 2019 - 01:45:00 UTC October 09, 2019 - 01:45:00 UTC 1 1 38.00435 -122.5896 Fairfax 226 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1570576817:647589 647589 647589 2019-10-08 16:20:17-07:00 1081 October 08, 2019 - 22:34:15 UTC October 09, 2019 - 01:30:00 UTC October 09, 2019 - 01:30:00 UTC 1 1 36.56555 -121.91607 Carmel 378 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570576817:647590 647590 647590 2019-10-08 16:20:17-07:00 1081 October 08, 2019 - 22:50:08 UTC October 09, 2019 - 02:00:00 UTC October 09, 2019 - 02:00:00 UTC 1 0 34.76035 -120.22797 Santa Maria 52 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1570576817:647591 647591 647591 2019-10-08 16:20:17-07:00 1081 October 08, 2019 - 22:35:40 UTC October 09, 2019 - 02:15:00 UTC October 09, 2019 - 02:15:00 UTC 1 0 38.1434 -121.72547 Rio Vista 21 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570576817:647592 647592 647592 2019-10-08 16:20:17-07:00 1081 October 08, 2019 - 22:55:58 UTC October 09, 2019 - 02:45:00 UTC October 09, 2019 - 02:45:00 UTC 1 0 36.98786 -121.3818 Hollister 201 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1570576817:647593 647593 647593 2019-10-08 16:20:17-07:00 1081 October 08, 2019 - 22:58:27 UTC October 09, 2019 - 01:30:00 UTC October 09, 2019 - 01:30:00 UTC 1 0 37.64259 -122.45951 South San Francisco 156 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1570576817:647594 647594 647594 2019-10-08 16:20:17-07:00 1081 October 08, 2019 - 23:01:03 UTC October 09, 2019 - 02:15:00 UTC October 09, 2019 - 02:15:00 UTC 1 0 36.85318 -119.76448 Fresno 35 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570576817:647595 647595 647595 2019-10-08 16:20:17-07:00 1081 October 08, 2019 - 23:02:50 UTC October 09, 2019 - 01:30:00 UTC October 09, 2019 - 01:30:00 UTC 1 1 37.92894 -122.35211 Richmond 220 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1570576817:647596 647596 647596 2019-10-08 16:20:17-07:00 1081 October 08, 2019 - 22:56:20 UTC October 09, 2019 - 01:30:00 UTC October 09, 2019 - 01:30:00 UTC 1 0 38.31381 -122.3131 Napa 15 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570576817:647597 647597 647597 2019-10-08 16:20:17-07:00 1081 October 08, 2019 - 22:57:38 UTC October 09, 2019 - 00:30:00 UTC October 09, 2019 - 00:30:00 UTC 1 0 36.757 -119.81363 Fresno 35 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1570576817:647599 647599 647599 2019-10-08 16:20:17-07:00 1081 October 08, 2019 - 23:02:04 UTC October 09, 2019 - 01:30:00 UTC October 09, 2019 - 01:30:00 UTC 1 1 37.65325 -122.41326 South San Francisco 156 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1570576817:647600 647600 647600 2019-10-08 16:20:17-07:00 1081 October 08, 2019 - 23:15:24 UTC October 09, 2019 - 02:00:00 UTC October 09, 2019 - 02:00:00 UTC 1 1 37.94053 -122.05242 Pleasant Hill 277 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1570576817:647601 647601 647601 2019-10-08 16:20:17-07:00 1081 October 08, 2019 - 23:07:50 UTC October 09, 2019 - 02:30:00 UTC October 09, 2019 - 02:30:00 UTC 1 0 35.41858 -120.48925 Creston 58 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570576817:647602 647602 647602 2019-10-08 16:20:17-07:00 1081 October 08, 2019 - 23:09:44 UTC October 09, 2019 - 02:00:00 UTC October 09, 2019 - 02:00:00 UTC 1 1 38.46433 -122.66239 Santa Rosa 30 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1570576817:647603 647603 647603 2019-10-08 16:20:17-07:00 1081 October 08, 2019 - 23:09:47 UTC October 09, 2019 - 01:45:00 UTC October 09, 2019 - 01:45:00 UTC 1 1 37.7559 -122.41339 San Francisco 25 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570576817:647604 647604 647604 2019-10-08 16:20:17-07:00 1081 October 08, 2019 - 23:08:26 UTC October 09, 2019 - 01:45:00 UTC October 09, 2019 - 01:45:00 UTC 1 1 39.12411 -121.61691 Yuba City 344 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570576817:647605 647605 647605 2019-10-08 16:20:17-07:00 1081 October 08, 2019 - 23:09:25 UTC October 09, 2019 - 02:00:00 UTC October 09, 2019 - 02:00:00 UTC 1 1 37.57783 -121.9609 Fremont 140 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570576817:647606 647606 647606 2019-10-08 16:20:17-07:00 1081 October 08, 2019 - 23:16:04 UTC October 09, 2019 - 02:30:00 UTC October 09, 2019 - 02:30:00 UTC 21 0 36.61614 -121.91931 Pacific Grove 247 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570576817:647607 647607 647607 2019-10-08 16:20:17-07:00 1081 October 08, 2019 - 23:14:53 UTC October 09, 2019 - 02:15:00 UTC October 09, 2019 - 02:15:00 UTC 1 0 37.79289 -122.42445 San Francisco 25 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1

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 4655.569ms · About: About this site