outage_snapshots

1,912 rows where cause = 7

View and edit SQL

id outage snapshot lastUpdateTime currentEtor autoEtor estCustAffected hazardFlag latitude longitude regionName cause crewCurrentStatus
1569951021:633893 633893 633893 2019-10-01 10:30:21-07:00 64 October 01, 2019 - 17:21:00 UTC October 01, 2019 - 19:00:00 UTC   22 0 37.35501 -122.02688 Sunnyvale 129 We are clearing vegetation to address potential safety risks in your area. 7 PG&E repair crew is on-site working to restore power. 2
1569951616:633893 633893 633893 2019-10-01 10:40:16-07:00 65 October 01, 2019 - 17:21:00 UTC October 01, 2019 - 19:00:00 UTC   22 0 37.35501 -122.02688 Sunnyvale 129 We are clearing vegetation to address potential safety risks in your area. 7 PG&E repair crew is on-site working to restore power. 2
1569952233:633893 633893 633893 2019-10-01 10:50:33-07:00 66 October 01, 2019 - 17:21:00 UTC October 01, 2019 - 19:00:00 UTC   22 0 37.35501 -122.02688 Sunnyvale 129 We are clearing vegetation to address potential safety risks in your area. 7 PG&E repair crew is on-site working to restore power. 2
1569952839:633893 633893 633893 2019-10-01 11:00:39-07:00 67 October 01, 2019 - 17:21:00 UTC October 01, 2019 - 19:00:00 UTC   22 0 37.35501 -122.02688 Sunnyvale 129 We are clearing vegetation to address potential safety risks in your area. 7 PG&E repair crew is on-site working to restore power. 2
1569953462:633893 633893 633893 2019-10-01 11:11:02-07:00 68 October 01, 2019 - 17:21:00 UTC October 01, 2019 - 19:00:00 UTC   22 0 37.35501 -122.02688 Sunnyvale 129 We are clearing vegetation to address potential safety risks in your area. 7 PG&E repair crew is on-site working to restore power. 2
1569954055:633893 633893 633893 2019-10-01 11:20:55-07:00 69 October 01, 2019 - 17:21:00 UTC October 01, 2019 - 19:00:00 UTC   22 0 37.35501 -122.02688 Sunnyvale 129 We are clearing vegetation to address potential safety risks in your area. 7 PG&E repair crew is on-site working to restore power. 2
1569954621:633893 633893 633893 2019-10-01 11:30:21-07:00 70 October 01, 2019 - 17:21:00 UTC October 01, 2019 - 19:00:00 UTC   22 0 37.35501 -122.02688 Sunnyvale 129 We are clearing vegetation to address potential safety risks in your area. 7 PG&E repair crew is on-site working to restore power. 2
1569955253:633893 633893 633893 2019-10-01 11:40:53-07:00 71 October 01, 2019 - 17:21:00 UTC October 01, 2019 - 19:00:00 UTC   22 0 37.35501 -122.02688 Sunnyvale 129 We are clearing vegetation to address potential safety risks in your area. 7 PG&E repair crew is on-site working to restore power. 2
1569955842:633893 633893 633893 2019-10-01 11:50:42-07:00 72 October 01, 2019 - 17:21:00 UTC October 01, 2019 - 19:00:00 UTC   22 0 37.35501 -122.02688 Sunnyvale 129 We are clearing vegetation to address potential safety risks in your area. 7 PG&E repair crew is on-site working to restore power. 2
1569956437:633893 633893 633893 2019-10-01 12:00:37-07:00 73 October 01, 2019 - 17:21:00 UTC October 01, 2019 - 19:00:00 UTC   22 0 37.35501 -122.02688 Sunnyvale 129 We are clearing vegetation to address potential safety risks in your area. 7 PG&E repair crew is on-site working to restore power. 2
1569957023:633893 633893 633893 2019-10-01 12:10:23-07:00 74 October 01, 2019 - 17:21:00 UTC October 01, 2019 - 19:00:00 UTC   22 0 37.35501 -122.02688 Sunnyvale 129 We are clearing vegetation to address potential safety risks in your area. 7 PG&E repair crew is on-site working to restore power. 2
1569957630:633893 633893 633893 2019-10-01 12:20:30-07:00 75 October 01, 2019 - 17:21:00 UTC October 01, 2019 - 19:00:00 UTC   22 0 37.35501 -122.02688 Sunnyvale 129 We are clearing vegetation to address potential safety risks in your area. 7 PG&E repair crew is on-site working to restore power. 2
1569958225:633893 633893 633893 2019-10-01 12:30:25-07:00 76 October 01, 2019 - 17:21:00 UTC October 01, 2019 - 19:00:00 UTC   22 0 37.35501 -122.02688 Sunnyvale 129 We are clearing vegetation to address potential safety risks in your area. 7 PG&E repair crew is on-site working to restore power. 2
1569958839:633893 633893 633893 2019-10-01 12:40:39-07:00 77 October 01, 2019 - 19:27:59 UTC October 01, 2019 - 19:00:00 UTC   22 0 37.35501 -122.02688 Sunnyvale 129 We are clearing vegetation to address potential safety risks in your area. 7 PG&E repair crew is on-site working to restore power. 2
1569959424:633893 633893 633893 2019-10-01 12:50:24-07:00 78 October 01, 2019 - 19:27:59 UTC October 01, 2019 - 19:00:00 UTC   22 0 37.35501 -122.02688 Sunnyvale 129 We are clearing vegetation to address potential safety risks in your area. 7 PG&E repair crew is on-site working to restore power. 2
1569960023:633893 633893 633893 2019-10-01 13:00:23-07:00 79 October 01, 2019 - 19:27:59 UTC October 01, 2019 - 19:00:00 UTC   22 0 37.35501 -122.02688 Sunnyvale 129 We are clearing vegetation to address potential safety risks in your area. 7 PG&E repair crew is on-site working to restore power. 2
1569960633:633893 633893 633893 2019-10-01 13:10:33-07:00 80 October 01, 2019 - 19:27:59 UTC October 01, 2019 - 19:00:00 UTC   22 0 37.35501 -122.02688 Sunnyvale 129 We are clearing vegetation to address potential safety risks in your area. 7 PG&E repair crew is on-site working to restore power. 2
1569961233:633893 633893 633893 2019-10-01 13:20:33-07:00 81 October 01, 2019 - 19:27:59 UTC October 01, 2019 - 19:00:00 UTC   22 0 37.35501 -122.02688 Sunnyvale 129 We are clearing vegetation to address potential safety risks in your area. 7 PG&E repair crew is on-site working to restore power. 2
1569961838:633893 633893 633893 2019-10-01 13:30:38-07:00 82 October 01, 2019 - 19:27:59 UTC October 01, 2019 - 19:00:00 UTC   22 0 37.35501 -122.02688 Sunnyvale 129 We are clearing vegetation to address potential safety risks in your area. 7 PG&E repair crew is on-site working to restore power. 2
1569962421:633893 633893 633893 2019-10-01 13:40:21-07:00 83 October 01, 2019 - 20:23:50 UTC October 01, 2019 - 19:00:00 UTC   22 0 37.35501 -122.02688 Sunnyvale 129 We are clearing vegetation to address potential safety risks in your area. 7 PG&E repair crew is on-site working to restore power. 2
1570185633:642230 642230 642230 2019-10-04 03:40:33-07:00 443 October 04, 2019 - 10:31:45 UTC October 04, 2019 - 14:00:00 UTC October 04, 2019 - 14:00:00 UTC 1 1 37.29505 -122.00067 San Jose 26 We are clearing vegetation to address potential safety risks in your area. 7 PG&E has assigned a crew to assess the outage. 1
1570186222:642230 642230 642230 2019-10-04 03:50:22-07:00 444 October 04, 2019 - 10:45:17 UTC October 04, 2019 - 14:00:00 UTC October 04, 2019 - 14:00:00 UTC 1 1 37.29505 -122.00067 San Jose 26 We are clearing vegetation to address potential safety risks in your area. 7 PG&E assessment crew is en route to the outage. 5
1570187416:642230 642230 642230 2019-10-04 04:10:16-07:00 445 October 04, 2019 - 10:57:25 UTC October 04, 2019 - 14:00:00 UTC October 04, 2019 - 14:00:00 UTC 1 1 37.29505 -122.00067 San Jose 26 We are clearing vegetation to address potential safety risks in your area. 7 PG&E is assessing the cause at the outage location. 4
1570188029:642230 642230 642230 2019-10-04 04:20:29-07:00 446 October 04, 2019 - 11:09:11 UTC October 04, 2019 - 14:00:00 UTC October 04, 2019 - 14:00:00 UTC 1 1 37.29505 -122.00067 San Jose 26 We are clearing vegetation to address potential safety risks in your area. 7 PG&E is assessing the cause at the outage location. 4
1570188615:642230 642230 642230 2019-10-04 04:30:15-07:00 447 October 04, 2019 - 11:09:11 UTC October 04, 2019 - 14:00:00 UTC October 04, 2019 - 14:00:00 UTC 1 1 37.29505 -122.00067 San Jose 26 We are clearing vegetation to address potential safety risks in your area. 7 PG&E is assessing the cause at the outage location. 4
1570189224:642230 642230 642230 2019-10-04 04:40:24-07:00 448 October 04, 2019 - 11:09:11 UTC October 04, 2019 - 14:00:00 UTC October 04, 2019 - 14:00:00 UTC 1 1 37.29505 -122.00067 San Jose 26 We are clearing vegetation to address potential safety risks in your area. 7 PG&E is assessing the cause at the outage location. 4
1570211439:643423 643423 643423 2019-10-04 10:50:39-07:00 483 October 04, 2019 - 17:46:05 UTC October 05, 2019 - 02:00:00 UTC   4 0 37.27373 -122.0296 Saratoga 152 We are clearing vegetation to address potential safety risks in your area. 7 PG&E repair crew is on-site working to restore power. 2
1570212049:643423 643423 643423 2019-10-04 11:00:49-07:00 484 October 04, 2019 - 17:49:48 UTC October 05, 2019 - 02:00:00 UTC   4 0 37.27373 -122.0296 Saratoga 152 We are clearing vegetation to address potential safety risks in your area. 7 PG&E repair crew is on-site working to restore power. 2
1570212624:643423 643423 643423 2019-10-04 11:10:24-07:00 485 October 04, 2019 - 17:49:48 UTC October 05, 2019 - 02:00:00 UTC   4 0 37.27373 -122.0296 Saratoga 152 We are clearing vegetation to address potential safety risks in your area. 7 PG&E repair crew is on-site working to restore power. 2
1570213237:643423 643423 643423 2019-10-04 11:20:37-07:00 486 October 04, 2019 - 17:49:48 UTC October 05, 2019 - 02:00:00 UTC   4 0 37.27373 -122.0296 Saratoga 152 We are clearing vegetation to address potential safety risks in your area. 7 PG&E repair crew is on-site working to restore power. 2
1570213824:643423 643423 643423 2019-10-04 11:30:24-07:00 487 October 04, 2019 - 17:49:48 UTC October 05, 2019 - 02:00:00 UTC   4 0 37.27373 -122.0296 Saratoga 152 We are clearing vegetation to address potential safety risks in your area. 7 PG&E repair crew is on-site working to restore power. 2
1570214435:643423 643423 643423 2019-10-04 11:40:35-07:00 488 October 04, 2019 - 17:49:48 UTC October 05, 2019 - 02:00:00 UTC   4 0 37.27373 -122.0296 Saratoga 152 We are clearing vegetation to address potential safety risks in your area. 7 PG&E repair crew is on-site working to restore power. 2
1570215022:643423 643423 643423 2019-10-04 11:50:22-07:00 489 October 04, 2019 - 17:49:48 UTC October 05, 2019 - 02:00:00 UTC   4 0 37.27373 -122.0296 Saratoga 152 We are clearing vegetation to address potential safety risks in your area. 7 PG&E repair crew is on-site working to restore power. 2
1570215656:643423 643423 643423 2019-10-04 12:00:56-07:00 490 October 04, 2019 - 17:49:48 UTC October 05, 2019 - 02:00:00 UTC   4 0 37.27373 -122.0296 Saratoga 152 We are clearing vegetation to address potential safety risks in your area. 7 PG&E repair crew is on-site working to restore power. 2
1570216223:643423 643423 643423 2019-10-04 12:10:23-07:00 491 October 04, 2019 - 17:49:48 UTC October 05, 2019 - 02:00:00 UTC   4 0 37.27373 -122.0296 Saratoga 152 We are clearing vegetation to address potential safety risks in your area. 7 PG&E repair crew is on-site working to restore power. 2
1570216828:643423 643423 643423 2019-10-04 12:20:28-07:00 492 October 04, 2019 - 17:49:48 UTC October 05, 2019 - 02:00:00 UTC   4 0 37.27373 -122.0296 Saratoga 152 We are clearing vegetation to address potential safety risks in your area. 7 PG&E repair crew is on-site working to restore power. 2
1570217424:643423 643423 643423 2019-10-04 12:30:24-07:00 493 October 04, 2019 - 17:49:48 UTC October 05, 2019 - 02:00:00 UTC   4 0 37.27373 -122.0296 Saratoga 152 We are clearing vegetation to address potential safety risks in your area. 7 PG&E repair crew is on-site working to restore power. 2
1570218015:643423 643423 643423 2019-10-04 12:40:15-07:00 494 October 04, 2019 - 17:49:48 UTC October 05, 2019 - 02:00:00 UTC   4 0 37.27373 -122.0296 Saratoga 152 We are clearing vegetation to address potential safety risks in your area. 7 PG&E repair crew is on-site working to restore power. 2
1570218625:643423 643423 643423 2019-10-04 12:50:25-07:00 495 October 04, 2019 - 17:49:48 UTC October 05, 2019 - 02:00:00 UTC   4 0 37.27373 -122.0296 Saratoga 152 We are clearing vegetation to address potential safety risks in your area. 7 PG&E repair crew is on-site working to restore power. 2
1570219228:643423 643423 643423 2019-10-04 13:00:28-07:00 496 October 04, 2019 - 17:49:48 UTC October 05, 2019 - 02:00:00 UTC   4 0 37.27373 -122.0296 Saratoga 152 We are clearing vegetation to address potential safety risks in your area. 7 PG&E repair crew is on-site working to restore power. 2
1570219836:643423 643423 643423 2019-10-04 13:10:36-07:00 497 October 04, 2019 - 17:49:48 UTC October 05, 2019 - 02:00:00 UTC   4 0 37.27373 -122.0296 Saratoga 152 We are clearing vegetation to address potential safety risks in your area. 7 PG&E repair crew is on-site working to restore power. 2
1570220413:643423 643423 643423 2019-10-04 13:20:13-07:00 498 October 04, 2019 - 17:49:48 UTC October 05, 2019 - 02:00:00 UTC   4 0 37.27373 -122.0296 Saratoga 152 We are clearing vegetation to address potential safety risks in your area. 7 PG&E repair crew is on-site working to restore power. 2
1570221024:643423 643423 643423 2019-10-04 13:30:24-07:00 499 October 04, 2019 - 17:49:48 UTC October 05, 2019 - 02:00:00 UTC   4 0 37.27373 -122.0296 Saratoga 152 We are clearing vegetation to address potential safety risks in your area. 7 PG&E repair crew is on-site working to restore power. 2
1570221633:643423 643423 643423 2019-10-04 13:40:33-07:00 500 October 04, 2019 - 20:29:11 UTC October 05, 2019 - 02:00:00 UTC   4 0 37.27373 -122.0296 Saratoga 152 We are clearing vegetation to address potential safety risks in your area. 7 PG&E repair crew is on-site working to restore power. 2
1570222225:643423 643423 643423 2019-10-04 13:50:25-07:00 501 October 04, 2019 - 20:29:11 UTC October 05, 2019 - 02:00:00 UTC   4 0 37.27373 -122.0296 Saratoga 152 We are clearing vegetation to address potential safety risks in your area. 7 PG&E repair crew is on-site working to restore power. 2
1570222834:643423 643423 643423 2019-10-04 14:00:34-07:00 502 October 04, 2019 - 20:29:11 UTC October 05, 2019 - 02:00:00 UTC   4 0 37.27373 -122.0296 Saratoga 152 We are clearing vegetation to address potential safety risks in your area. 7 PG&E repair crew is on-site working to restore power. 2
1571167216:659635 659635 659635 2019-10-15 12:20:16-07:00 1943 October 15, 2019 - 19:13:35 UTC October 15, 2019 - 23:30:00 UTC   32 0 38.02471 -121.31861 Stockton 78 We are clearing vegetation to address potential safety risks in your area. 7 PG&E repair crew is on-site working to restore power. 2
1571167832:659635 659635 659635 2019-10-15 12:30:32-07:00 1944 October 15, 2019 - 19:20:50 UTC October 15, 2019 - 23:30:00 UTC   32 0 38.02471 -121.31861 Stockton 78 We are clearing vegetation to address potential safety risks in your area. 7 PG&E repair crew is on-site working to restore power. 2
1571168422:659635 659635 659635 2019-10-15 12:40:22-07:00 1945 October 15, 2019 - 19:20:50 UTC October 15, 2019 - 23:30:00 UTC   32 0 38.02471 -121.31861 Stockton 78 We are clearing vegetation to address potential safety risks in your area. 7 PG&E repair crew is on-site working to restore power. 2
1571169039:659635 659635 659635 2019-10-15 12:50:39-07:00 1946 October 15, 2019 - 19:20:50 UTC October 15, 2019 - 23:30:00 UTC   32 0 38.02471 -121.31861 Stockton 78 We are clearing vegetation to address potential safety risks in your area. 7 PG&E repair crew is on-site working to restore power. 2
1571169652:659635 659635 659635 2019-10-15 13:00:52-07:00 1947 October 15, 2019 - 19:47:43 UTC October 15, 2019 - 23:30:00 UTC   32 0 38.02471 -121.31861 Stockton 78 We are clearing vegetation to address potential safety risks in your area. 7 PG&E repair crew is on-site working to restore power. 2
1571170229:659635 659635 659635 2019-10-15 13:10:29-07:00 1948 October 15, 2019 - 19:56:41 UTC October 15, 2019 - 23:30:00 UTC   32 0 38.02471 -121.31861 Stockton 78 We are clearing vegetation to address potential safety risks in your area. 7 PG&E repair crew is on-site working to restore power. 2
1571170831:659635 659635 659635 2019-10-15 13:20:31-07:00 1949 October 15, 2019 - 19:56:41 UTC October 15, 2019 - 23:30:00 UTC   32 0 38.02471 -121.31861 Stockton 78 We are clearing vegetation to address potential safety risks in your area. 7 PG&E repair crew is on-site working to restore power. 2
1571171434:659635 659635 659635 2019-10-15 13:30:34-07:00 1950 October 15, 2019 - 19:56:41 UTC October 15, 2019 - 23:30:00 UTC   32 0 38.02471 -121.31861 Stockton 78 We are clearing vegetation to address potential safety risks in your area. 7 PG&E repair crew is on-site working to restore power. 2
1571172049:659635 659635 659635 2019-10-15 13:40:49-07:00 1951 October 15, 2019 - 19:56:41 UTC October 15, 2019 - 23:30:00 UTC   32 0 38.02471 -121.31861 Stockton 78 We are clearing vegetation to address potential safety risks in your area. 7 PG&E repair crew is on-site working to restore power. 2
1571172626:659635 659635 659635 2019-10-15 13:50:26-07:00 1952 October 15, 2019 - 19:56:41 UTC October 15, 2019 - 23:30:00 UTC   32 0 38.02471 -121.31861 Stockton 78 We are clearing vegetation to address potential safety risks in your area. 7 PG&E repair crew is on-site working to restore power. 2
1571173250:659635 659635 659635 2019-10-15 14:00:50-07:00 1953 October 15, 2019 - 19:56:41 UTC October 15, 2019 - 23:30:00 UTC   32 0 38.02471 -121.31861 Stockton 78 We are clearing vegetation to address potential safety risks in your area. 7 PG&E repair crew is on-site working to restore power. 2
1571173839:659635 659635 659635 2019-10-15 14:10:39-07:00 1954 October 15, 2019 - 19:56:41 UTC October 15, 2019 - 23:30:00 UTC   32 0 38.02471 -121.31861 Stockton 78 We are clearing vegetation to address potential safety risks in your area. 7 PG&E repair crew is on-site working to restore power. 2
1571174424:659635 659635 659635 2019-10-15 14:20:24-07:00 1955 October 15, 2019 - 19:56:41 UTC October 15, 2019 - 23:30:00 UTC   32 0 38.02471 -121.31861 Stockton 78 We are clearing vegetation to address potential safety risks in your area. 7 PG&E repair crew is on-site working to restore power. 2
1571175021:659635 659635 659635 2019-10-15 14:30:21-07:00 1956 October 15, 2019 - 19:56:41 UTC October 15, 2019 - 23:30:00 UTC   32 0 38.02471 -121.31861 Stockton 78 We are clearing vegetation to address potential safety risks in your area. 7 PG&E repair crew is on-site working to restore power. 2
1571175633:659635 659635 659635 2019-10-15 14:40:33-07:00 1957 October 15, 2019 - 19:56:41 UTC October 15, 2019 - 23:30:00 UTC   32 0 38.02471 -121.31861 Stockton 78 We are clearing vegetation to address potential safety risks in your area. 7 PG&E repair crew is on-site working to restore power. 2
1571176215:659635 659635 659635 2019-10-15 14:50:15-07:00 1958 October 15, 2019 - 19:56:41 UTC October 15, 2019 - 23:30:00 UTC   32 0 38.02471 -121.31861 Stockton 78 We are clearing vegetation to address potential safety risks in your area. 7 PG&E repair crew is on-site working to restore power. 2
1571176824:659635 659635 659635 2019-10-15 15:00:24-07:00 1959 October 15, 2019 - 19:56:41 UTC October 15, 2019 - 23:30:00 UTC   32 0 38.02471 -121.31861 Stockton 78 We are clearing vegetation to address potential safety risks in your area. 7 PG&E repair crew is on-site working to restore power. 2
1571177424:659635 659635 659635 2019-10-15 15:10:24-07:00 1960 October 15, 2019 - 22:03:35 UTC October 15, 2019 - 23:30:00 UTC   32 0 38.02471 -121.31861 Stockton 78 We are clearing vegetation to address potential safety risks in your area. 7 PG&E repair crew is on-site working to restore power. 2
1571843433:677346 677346 677346 2019-10-23 08:10:33-07:00 3044 October 23, 2019 - 15:05:51 UTC October 23, 2019 - 20:05:00 UTC   30 0 37.01603 -121.82069 Watsonville 49 We are clearing vegetation to address potential safety risks in your area. 7 PG&E repair crew is on-site working to restore power. 2
1571844035:677346 677346 677346 2019-10-23 08:20:35-07:00 3045 October 23, 2019 - 15:08:50 UTC October 23, 2019 - 20:05:00 UTC   30 0 37.01603 -121.82069 Watsonville 49 We are clearing vegetation to address potential safety risks in your area. 7 PG&E repair crew is on-site working to restore power. 2
1571844630:677346 677346 677346 2019-10-23 08:30:30-07:00 3046 October 23, 2019 - 15:08:50 UTC October 23, 2019 - 20:05:00 UTC   30 0 37.01603 -121.82069 Watsonville 49 We are clearing vegetation to address potential safety risks in your area. 7 PG&E repair crew is on-site working to restore power. 2
1571845228:677346 677346 677346 2019-10-23 08:40:28-07:00 3047 October 23, 2019 - 15:08:50 UTC October 23, 2019 - 20:05:00 UTC   30 0 37.01603 -121.82069 Watsonville 49 We are clearing vegetation to address potential safety risks in your area. 7 PG&E repair crew is on-site working to restore power. 2
1571846012:677346 677346 677346 2019-10-23 08:53:32-07:00 3048 October 23, 2019 - 15:08:50 UTC October 23, 2019 - 20:05:00 UTC   30 0 37.01603 -121.82069 Watsonville 49 We are clearing vegetation to address potential safety risks in your area. 7 PG&E repair crew is on-site working to restore power. 2
1571846457:677346 677346 677346 2019-10-23 09:00:57-07:00 3049 October 23, 2019 - 15:08:50 UTC October 23, 2019 - 20:05:00 UTC   30 0 37.01603 -121.82069 Watsonville 49 We are clearing vegetation to address potential safety risks in your area. 7 PG&E repair crew is on-site working to restore power. 2
1571847021:677346 677346 677346 2019-10-23 09:10:21-07:00 3050 October 23, 2019 - 15:08:50 UTC October 23, 2019 - 20:05:00 UTC   30 0 37.01603 -121.82069 Watsonville 49 We are clearing vegetation to address potential safety risks in your area. 7 PG&E repair crew is on-site working to restore power. 2
1571848232:677346 677346 677346 2019-10-23 09:30:32-07:00 3051 October 23, 2019 - 15:08:50 UTC October 23, 2019 - 20:05:00 UTC   30 0 37.01603 -121.82069 Watsonville 49 We are clearing vegetation to address potential safety risks in your area. 7 PG&E repair crew is on-site working to restore power. 2
1571848821:677346 677346 677346 2019-10-23 09:40:21-07:00 3052 October 23, 2019 - 16:30:41 UTC October 23, 2019 - 20:05:00 UTC   30 0 37.01603 -121.82069 Watsonville 49 We are clearing vegetation to address potential safety risks in your area. 7 PG&E repair crew is on-site working to restore power. 2
1571849412:677346 677346 677346 2019-10-23 09:50:12-07:00 3053 October 23, 2019 - 16:30:41 UTC October 23, 2019 - 20:05:00 UTC   30 0 37.01603 -121.82069 Watsonville 49 We are clearing vegetation to address potential safety risks in your area. 7 PG&E repair crew is on-site working to restore power. 2
1571850052:677346 677346 677346 2019-10-23 10:00:52-07:00 3054 October 23, 2019 - 16:42:25 UTC October 23, 2019 - 20:05:00 UTC   30 0 37.01603 -121.82069 Watsonville 49 We are clearing vegetation to address potential safety risks in your area. 7 PG&E repair crew is on-site working to restore power. 2
1571850628:677346 677346 677346 2019-10-23 10:10:28-07:00 3055 October 23, 2019 - 16:42:25 UTC October 23, 2019 - 20:05:00 UTC   30 0 37.01603 -121.82069 Watsonville 49 We are clearing vegetation to address potential safety risks in your area. 7 PG&E repair crew is on-site working to restore power. 2
1571851226:677346 677346 677346 2019-10-23 10:20:26-07:00 3056 October 23, 2019 - 16:42:25 UTC October 23, 2019 - 20:05:00 UTC   30 0 37.01603 -121.82069 Watsonville 49 We are clearing vegetation to address potential safety risks in your area. 7 PG&E repair crew is on-site working to restore power. 2
1571851837:677346 677346 677346 2019-10-23 10:30:37-07:00 3057 October 23, 2019 - 16:42:25 UTC October 23, 2019 - 20:05:00 UTC   30 0 37.01603 -121.82069 Watsonville 49 We are clearing vegetation to address potential safety risks in your area. 7 PG&E repair crew is on-site working to restore power. 2
1571852438:677346 677346 677346 2019-10-23 10:40:38-07:00 3058 October 23, 2019 - 16:42:25 UTC October 23, 2019 - 20:05:00 UTC   30 0 37.01603 -121.82069 Watsonville 49 We are clearing vegetation to address potential safety risks in your area. 7 PG&E repair crew is on-site working to restore power. 2
1571853018:677346 677346 677346 2019-10-23 10:50:18-07:00 3059 October 23, 2019 - 16:42:25 UTC October 23, 2019 - 20:05:00 UTC   30 0 37.01603 -121.82069 Watsonville 49 We are clearing vegetation to address potential safety risks in your area. 7 PG&E repair crew is on-site working to restore power. 2
1571853635:677346 677346 677346 2019-10-23 11:00:35-07:00 3060 October 23, 2019 - 16:42:25 UTC October 23, 2019 - 20:05:00 UTC   30 0 37.01603 -121.82069 Watsonville 49 We are clearing vegetation to address potential safety risks in your area. 7 PG&E repair crew is on-site working to restore power. 2
1571854225:677346 677346 677346 2019-10-23 11:10:25-07:00 3061 October 23, 2019 - 16:42:25 UTC October 23, 2019 - 20:05:00 UTC   30 0 37.01603 -121.82069 Watsonville 49 We are clearing vegetation to address potential safety risks in your area. 7 PG&E repair crew is on-site working to restore power. 2
1571854836:677346 677346 677346 2019-10-23 11:20:36-07:00 3062 October 23, 2019 - 16:42:25 UTC October 23, 2019 - 20:05:00 UTC   30 0 37.01603 -121.82069 Watsonville 49 We are clearing vegetation to address potential safety risks in your area. 7 PG&E repair crew is on-site working to restore power. 2
1571855455:677346 677346 677346 2019-10-23 11:30:55-07:00 3063 October 23, 2019 - 16:42:25 UTC October 23, 2019 - 20:05:00 UTC   30 0 37.01603 -121.82069 Watsonville 49 We are clearing vegetation to address potential safety risks in your area. 7 PG&E repair crew is on-site working to restore power. 2
1571856019:677346 677346 677346 2019-10-23 11:40:19-07:00 3064 October 23, 2019 - 18:27:39 UTC October 23, 2019 - 20:05:00 UTC   30 0 37.01603 -121.82069 Watsonville 49 We are clearing vegetation to address potential safety risks in your area. 7 PG&E repair crew is on-site working to restore power. 2
1571856616:677346 677346 677346 2019-10-23 11:50:16-07:00 3065 October 23, 2019 - 18:27:39 UTC October 23, 2019 - 20:05:00 UTC   30 0 37.01603 -121.82069 Watsonville 49 We are clearing vegetation to address potential safety risks in your area. 7 PG&E repair crew is on-site working to restore power. 2
1571868036:677568 677568 677568 2019-10-23 15:00:36-07:00 3084 October 23, 2019 - 21:55:53 UTC October 24, 2019 - 03:00:00 UTC   1 1 38.3112 -122.34927 Napa 15 We are clearing vegetation to address potential safety risks in your area. 7 PG&E repair crew is on-site working to restore power. 2
1571869248:677568 677568 677568 2019-10-23 15:20:48-07:00 3085 October 23, 2019 - 21:58:21 UTC October 24, 2019 - 03:00:00 UTC   1 1 38.3112 -122.34927 Napa 15 We are clearing vegetation to address potential safety risks in your area. 7 PG&E repair crew is on-site working to restore power. 2
1571869248:678237 678237 678237 2019-10-23 15:20:48-07:00 3085 October 23, 2019 - 22:04:01 UTC October 24, 2019 - 03:00:00 UTC   1 0 37.16844 -122.07451 Boulder Creek 241 We are clearing vegetation to address potential safety risks in your area. 7 PG&E repair crew is on-site working to restore power. 2
1571869826:677568 677568 677568 2019-10-23 15:30:26-07:00 3086 October 23, 2019 - 21:58:21 UTC October 24, 2019 - 03:00:00 UTC   1 1 38.3112 -122.34927 Napa 15 We are clearing vegetation to address potential safety risks in your area. 7 PG&E repair crew is on-site working to restore power. 2
1571869826:678237 678237 678237 2019-10-23 15:30:26-07:00 3086 October 23, 2019 - 22:04:01 UTC October 24, 2019 - 03:00:00 UTC   1 0 37.16844 -122.07451 Boulder Creek 241 We are clearing vegetation to address potential safety risks in your area. 7 PG&E repair crew is on-site working to restore power. 2
1571870425:677568 677568 677568 2019-10-23 15:40:25-07:00 3087 October 23, 2019 - 21:58:21 UTC October 24, 2019 - 03:00:00 UTC   1 1 38.3112 -122.34927 Napa 15 We are clearing vegetation to address potential safety risks in your area. 7 PG&E repair crew is on-site working to restore power. 2
1571870425:678237 678237 678237 2019-10-23 15:40:25-07:00 3087 October 23, 2019 - 22:04:01 UTC October 24, 2019 - 03:00:00 UTC   1 0 37.16844 -122.07451 Boulder Creek 241 We are clearing vegetation to address potential safety risks in your area. 7 PG&E repair crew is on-site working to restore power. 2
1571871022:677568 677568 677568 2019-10-23 15:50:22-07:00 3088 October 23, 2019 - 21:58:21 UTC October 24, 2019 - 03:00:00 UTC   1 1 38.3112 -122.34927 Napa 15 We are clearing vegetation to address potential safety risks in your area. 7 PG&E repair crew is on-site working to restore power. 2
1571871022:678237 678237 678237 2019-10-23 15:50:22-07:00 3088 October 23, 2019 - 22:04:01 UTC October 24, 2019 - 03:00:00 UTC   1 0 37.16844 -122.07451 Boulder Creek 241 We are clearing vegetation to address potential safety risks in your area. 7 PG&E repair crew is on-site working to restore power. 2
1571871618:677568 677568 677568 2019-10-23 16:00:18-07:00 3089 October 23, 2019 - 21:58:21 UTC October 24, 2019 - 03:00:00 UTC   1 1 38.3112 -122.34927 Napa 15 We are clearing vegetation to address potential safety risks in your area. 7 PG&E repair crew is on-site working to restore power. 2
1571871618:678237 678237 678237 2019-10-23 16:00:18-07:00 3089 October 23, 2019 - 22:04:01 UTC October 24, 2019 - 03:00:00 UTC   1 0 37.16844 -122.07451 Boulder Creek 241 We are clearing vegetation to address potential safety risks in your area. 7 PG&E repair crew is on-site working to restore power. 2
1571872220:677568 677568 677568 2019-10-23 16:10:20-07:00 3090 October 23, 2019 - 21:58:21 UTC October 24, 2019 - 03:00:00 UTC   1 1 38.3112 -122.34927 Napa 15 We are clearing vegetation to address potential safety risks in your area. 7 PG&E repair crew is on-site working to restore power. 2
1571872220:678237 678237 678237 2019-10-23 16:10:20-07:00 3090 October 23, 2019 - 22:04:01 UTC October 24, 2019 - 03:00:00 UTC   1 0 37.16844 -122.07451 Boulder Creek 241 We are clearing vegetation to address potential safety risks in your area. 7 PG&E repair crew is on-site working to restore power. 2
1571872836:677568 677568 677568 2019-10-23 16:20:36-07:00 3091 October 23, 2019 - 21:58:21 UTC October 24, 2019 - 03:00:00 UTC   1 1 38.3112 -122.34927 Napa 15 We are clearing vegetation to address potential safety risks in your area. 7 PG&E repair crew is on-site working to restore power. 2

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