48 rows sorted by estCustAffected descending

View and edit SQL

id latitude longitude outage estCustAffected ▲ lastUpdateTime hazardFlag region cause crewCurrentStatus outage_url currentEtor autoEtor
1606599986:1155532 37.94633 -122.31813 1155532 150 November 28, 2020 - 21:31:37 UTC 1 East Richmond Heights PG&E is investigating the cause of your outage. PG&E is assessing the cause at the outage location. https://pge-outages.simonwillison.net/pge-outages/outages/1155532 November 29, 2020 - 02:00:00 UTC  
1606599986:1155578 35.96639 -121.11527 1155578 140 November 28, 2020 - 21:37:54 UTC 0 Lockwood Unknown - PG&E will be assessing the cause. PG&E has assigned a crew to assess the outage. https://pge-outages.simonwillison.net/pge-outages/outages/1155578 November 29, 2020 - 00:00:00 UTC November 29, 2020 - 00:00:00 UTC
1606599986:1155438 40.63896 -122.3673 1155438 60 November 28, 2020 - 21:00:20 UTC 2 Redding Our preliminary determination is that your outage was caused by a car that hit a pole. PG&E repair crew is on-site working to restore power. https://pge-outages.simonwillison.net/pge-outages/outages/1155438 November 28, 2020 - 22:00:00 UTC  
1606599986:1155349 37.32084 -121.84197 1155349 57 November 28, 2020 - 19:08:48 UTC 0 San Jose Our preliminary determination is that your outage was caused by an equipment issue. PG&E repair crew is on-site working to restore power. https://pge-outages.simonwillison.net/pge-outages/outages/1155349 November 29, 2020 - 01:30:00 UTC  
1606599986:1155566 37.47141 -122.22514 1155566 43 November 28, 2020 - 21:32:41 UTC 0 Redwood City PG&E is investigating the cause of your outage. PG&E is assessing the cause at the outage location. https://pge-outages.simonwillison.net/pge-outages/outages/1155566 November 28, 2020 - 23:00:00 UTC November 28, 2020 - 23:00:00 UTC
1606599986:1155573 37.5713 -122.32588 1155573 28 November 28, 2020 - 21:40:23 UTC 0 San Mateo PG&E is investigating the cause of your outage. PG&E is assessing the cause at the outage location. https://pge-outages.simonwillison.net/pge-outages/outages/1155573 November 28, 2020 - 22:45:00 UTC November 28, 2020 - 22:45:00 UTC
1606599986:1155414 37.23919 -121.97813 1155414 16 November 28, 2020 - 21:35:11 UTC 0 Monte Sereno Our preliminary determination is that your outage was caused by an equipment issue. PG&E repair crew is on-site working to restore power. https://pge-outages.simonwillison.net/pge-outages/outages/1155414 November 28, 2020 - 22:15:00 UTC  
1606599986:1155493 37.34371 -121.78173 1155493 16 November 28, 2020 - 19:56:07 UTC 0 San Jose Our preliminary determination is that your outage was caused by scheduled maintenance work. PG&E repair crew is on-site working to restore power. https://pge-outages.simonwillison.net/pge-outages/outages/1155493 November 28, 2020 - 22:30:00 UTC  
1606599986:1155388 36.33694 -121.25409 1155388 12 November 28, 2020 - 17:35:25 UTC 1 Greenfield Our preliminary determination is that your outage was caused by an equipment issue. PG&E repair crew is on-site working to restore power. https://pge-outages.simonwillison.net/pge-outages/outages/1155388 November 28, 2020 - 23:30:00 UTC  
1606599986:1155485 39.3695 -121.21362 1155485 10 November 28, 2020 - 21:11:55 UTC 0 Dobbins PG&E is investigating the cause of your outage. PG&E is sending a repair crew to the outage location. https://pge-outages.simonwillison.net/pge-outages/outages/1155485 November 29, 2020 - 00:00:00 UTC  
1606599986:1155568 37.29584 -119.52221 1155568 8 November 28, 2020 - 21:02:33 UTC 1 Bass Lake Unknown - PG&E will be assessing the cause. PG&E assessment crew is en route to the outage. https://pge-outages.simonwillison.net/pge-outages/outages/1155568 November 28, 2020 - 23:15:00 UTC November 28, 2020 - 23:15:00 UTC
1606599986:1155454 40.48195 -123.89141 1155454 8 November 28, 2020 - 21:27:15 UTC 0 Carlotta Our preliminary determination is that your outage was caused by scheduled maintenance work. PG&E repair crew is on-site working to restore power. https://pge-outages.simonwillison.net/pge-outages/outages/1155454 November 29, 2020 - 00:30:00 UTC  
1606599986:1155571 40.89781 -124.11545 1155571 4 November 28, 2020 - 21:36:01 UTC 0 Arcata Our preliminary determination is that your outage was caused by an equipment issue. PG&E repair crew is on-site working to restore power. https://pge-outages.simonwillison.net/pge-outages/outages/1155571 November 29, 2020 - 01:00:00 UTC  
1606599986:1155582 39.01733 -120.8438 1155582 4 November 28, 2020 - 21:30:53 UTC 0 Foresthill Unknown - PG&E will be assessing the cause. PG&E assessment crew is en route to the outage. https://pge-outages.simonwillison.net/pge-outages/outages/1155582 November 29, 2020 - 01:00:00 UTC November 29, 2020 - 01:00:00 UTC
1606599986:1155516 39.11417 -121.01032 1155516 2 November 28, 2020 - 21:36:19 UTC 0 Grass Valley Our preliminary determination is that your outage was caused by an equipment issue. PG&E is assessing the cause at the outage location. https://pge-outages.simonwillison.net/pge-outages/outages/1155516 November 28, 2020 - 22:00:00 UTC November 28, 2020 - 22:00:00 UTC
1606599986:1155538 37.76087 -122.38746 1155538 2 November 28, 2020 - 21:32:31 UTC 0 San Francisco Our preliminary determination is that your outage was caused by scheduled maintenance work. PG&E has assigned a crew to assess the outage. https://pge-outages.simonwillison.net/pge-outages/outages/1155538 November 29, 2020 - 04:00:00 UTC  
1606599986:1155522 38.40706 -120.72593 1155522 2 November 28, 2020 - 21:20:22 UTC 0 Sutter Creek PG&E is investigating the cause of your outage. PG&E has assigned a crew to assess the outage. https://pge-outages.simonwillison.net/pge-outages/outages/1155522 November 29, 2020 - 01:00:00 UTC  
1606599986:1155552 37.37006 -121.82064 1155552 1 November 28, 2020 - 21:34:57 UTC 0 Alum Rock PG&E is investigating the cause of your outage. PG&E is assessing the cause at the outage location. https://pge-outages.simonwillison.net/pge-outages/outages/1155552 November 28, 2020 - 22:45:00 UTC November 28, 2020 - 22:45:00 UTC
1606599986:1155581 38.95332 -122.03654 1155581 1 November 28, 2020 - 21:29:55 UTC 1 Arbuckle Unknown - PG&E will be assessing the cause. PG&E assessment crew is en route to the outage. https://pge-outages.simonwillison.net/pge-outages/outages/1155581 November 29, 2020 - 01:00:00 UTC November 29, 2020 - 01:00:00 UTC
1606599986:1155549 39.1134 -122.00692 1155549 1 November 28, 2020 - 21:30:11 UTC 0 Arbuckle Unknown - PG&E will be assessing the cause. PG&E has assigned a crew to assess the outage. https://pge-outages.simonwillison.net/pge-outages/outages/1155549 November 28, 2020 - 23:30:00 UTC November 28, 2020 - 23:30:00 UTC
1606599986:1155546 39.01636 -122.66847 1155546 1 November 28, 2020 - 20:05:28 UTC 0 Clearlake Oaks Unknown - PG&E will be assessing the cause. PG&E assessment crew is en route to the outage. https://pge-outages.simonwillison.net/pge-outages/outages/1155546 November 28, 2020 - 23:00:00 UTC November 28, 2020 - 23:00:00 UTC
1606599986:1155505 36.87386 -119.69299 1155505 1 November 28, 2020 - 21:18:20 UTC 0 Clovis Our preliminary determination is that your outage was caused by an equipment issue. PG&E is assessing the cause at the outage location. https://pge-outages.simonwillison.net/pge-outages/outages/1155505 November 29, 2020 - 00:15:00 UTC  
1606599986:1155579 36.83331 -119.65923 1155579 1 November 28, 2020 - 21:27:53 UTC 0 Clovis Unknown - PG&E will be assessing the cause. PG&E has assigned a crew to assess the outage. https://pge-outages.simonwillison.net/pge-outages/outages/1155579 November 29, 2020 - 00:15:00 UTC November 29, 2020 - 00:15:00 UTC
1606599986:1155569 36.14144 -120.35938 1155569 1 November 28, 2020 - 21:04:15 UTC 1 Coalinga Unknown - PG&E will be assessing the cause. PG&E assessment crew is en route to the outage. https://pge-outages.simonwillison.net/pge-outages/outages/1155569 November 28, 2020 - 23:45:00 UTC November 28, 2020 - 23:45:00 UTC
1606599986:1155561 38.86717 -121.91396 1155561 1 November 28, 2020 - 20:19:50 UTC 0 Dunnigan Unknown - PG&E will be assessing the cause. PG&E has assigned a crew to assess the outage. https://pge-outages.simonwillison.net/pge-outages/outages/1155561 November 29, 2020 - 00:15:00 UTC November 29, 2020 - 00:15:00 UTC
1606599986:1155529 36.68081 -119.64616 1155529 1 November 28, 2020 - 21:40:47 UTC 0 Fresno PG&E is investigating the cause of your outage. PG&E is assessing the cause at the outage location. https://pge-outages.simonwillison.net/pge-outages/outages/1155529 November 28, 2020 - 22:15:00 UTC November 28, 2020 - 22:15:00 UTC
1606599986:1155584 36.82014 -119.79708 1155584 1 November 28, 2020 - 21:40:27 UTC 1 Fresno Unknown - PG&E will be assessing the cause. PG&E has assigned a crew to assess the outage. https://pge-outages.simonwillison.net/pge-outages/outages/1155584 November 28, 2020 - 23:15:00 UTC November 28, 2020 - 23:15:00 UTC
1606599986:1155510 36.72735 -119.73741 1155510 1 November 28, 2020 - 21:02:24 UTC 0 Fresno Unknown - PG&E will be assessing the cause. PG&E assessment crew is en route to the outage. https://pge-outages.simonwillison.net/pge-outages/outages/1155510 November 28, 2020 - 23:45:00 UTC  
1606599986:1155520 37.60947 -122.02402 1155520 1 November 28, 2020 - 21:38:01 UTC 0 Hayward PG&E is investigating the cause of your outage. PG&E is sending a repair crew to the outage location. https://pge-outages.simonwillison.net/pge-outages/outages/1155520 November 29, 2020 - 02:00:00 UTC  
1606599986:1155576 37.61168 -122.02641 1155576 1 November 28, 2020 - 21:31:53 UTC 0 Hayward Unknown - PG&E will be assessing the cause. PG&E has assigned a crew to assess the outage. https://pge-outages.simonwillison.net/pge-outages/outages/1155576 November 29, 2020 - 02:00:00 UTC  
1606599986:1155555 36.2668 -121.08057 1155555 1 November 28, 2020 - 21:38:29 UTC 0 King City PG&E is investigating the cause of your outage. PG&E is assessing the cause at the outage location. https://pge-outages.simonwillison.net/pge-outages/outages/1155555 November 28, 2020 - 23:00:00 UTC November 28, 2020 - 23:00:00 UTC
1606599986:1155585 37.22984 -122.32734 1155585 1 November 28, 2020 - 21:39:19 UTC 0 Loma Mar Unknown - PG&E will be assessing the cause. PG&E has assigned a crew to assess the outage. https://pge-outages.simonwillison.net/pge-outages/outages/1155585 November 29, 2020 - 01:00:00 UTC November 29, 2020 - 01:00:00 UTC
1606599986:1155583 37.60594 -122.41776 1155583 1 November 28, 2020 - 21:38:02 UTC 0 Millbrae Unknown - PG&E will be assessing the cause. PG&E has assigned a crew to assess the outage. https://pge-outages.simonwillison.net/pge-outages/outages/1155583 November 28, 2020 - 23:15:00 UTC November 28, 2020 - 23:15:00 UTC
1606599986:1155499 34.99848 -120.50515 1155499 1 November 28, 2020 - 20:58:53 UTC 0 Nipomo Our preliminary determination is that your outage was caused by an equipment issue. PG&E is sending a repair crew to the outage location. https://pge-outages.simonwillison.net/pge-outages/outages/1155499 November 29, 2020 - 03:30:00 UTC  
1606599986:1155537 38.69386 -122.37466 1155537 1 November 28, 2020 - 19:50:21 UTC 1 Pope Valley Unknown - PG&E will be assessing the cause. PG&E assessment crew is en route to the outage. https://pge-outages.simonwillison.net/pge-outages/outages/1155537 November 28, 2020 - 22:45:00 UTC November 28, 2020 - 22:45:00 UTC
1606599986:1155500 37.75926 -122.42277 1155500 1 November 28, 2020 - 20:52:00 UTC 0 San Francisco Unknown - PG&E will be assessing the cause. PG&E assessment crew is en route to the outage. https://pge-outages.simonwillison.net/pge-outages/outages/1155500 November 28, 2020 - 23:30:00 UTC  
1606599986:1155572 37.745 -122.47597 1155572 1 November 28, 2020 - 21:03:32 UTC 0 San Francisco Unknown - PG&E will be assessing the cause. PG&E has assigned a crew to assess the outage. https://pge-outages.simonwillison.net/pge-outages/outages/1155572 November 28, 2020 - 23:30:00 UTC November 28, 2020 - 23:30:00 UTC
1606599986:1155473 37.31993 -121.8925 1155473 1 November 28, 2020 - 20:29:34 UTC 1 San Jose Unknown - PG&E will be assessing the cause. PG&E has assigned a crew to assess the outage. https://pge-outages.simonwillison.net/pge-outages/outages/1155473 November 28, 2020 - 23:00:00 UTC  
1606599986:1155506 37.29816 -121.8785 1155506 1 November 28, 2020 - 21:05:57 UTC 0 San Jose Unknown - PG&E will be assessing the cause. PG&E assessment crew is en route to the outage. https://pge-outages.simonwillison.net/pge-outages/outages/1155506 November 28, 2020 - 23:15:00 UTC  
1606599986:1155558 37.23748 -121.87598 1155558 1 November 28, 2020 - 20:14:59 UTC 0 San Jose Unknown - PG&E will be assessing the cause. PG&E has assigned a crew to assess the outage. https://pge-outages.simonwillison.net/pge-outages/outages/1155558 November 28, 2020 - 23:00:00 UTC November 28, 2020 - 23:00:00 UTC
1606599986:1155503 37.67 -122.14124 1155503 1 November 28, 2020 - 20:50:35 UTC 0 San Lorenzo PG&E is investigating the cause of your outage. PG&E assessment crew is en route to the outage. https://pge-outages.simonwillison.net/pge-outages/outages/1155503 November 29, 2020 - 00:15:00 UTC  
1606599986:1155526 37.10424 -121.61693 1155526 1 November 28, 2020 - 19:08:59 UTC 0 San Martin Unknown - PG&E will be assessing the cause. PG&E has assigned a crew to assess the outage. https://pge-outages.simonwillison.net/pge-outages/outages/1155526 November 28, 2020 - 22:15:00 UTC November 28, 2020 - 22:15:00 UTC
1606599986:1155440 40.42891 -121.99563 1155440 1 November 28, 2020 - 21:32:24 UTC 0 Shingletown Unknown - PG&E will be assessing the cause. PG&E assessment crew is en route to the outage. https://pge-outages.simonwillison.net/pge-outages/outages/1155440 November 28, 2020 - 23:00:00 UTC  
1606599986:1155565 38.02378 -121.5328 1155565 1 November 28, 2020 - 21:15:49 UTC 0 Stockton Unknown - PG&E will be assessing the cause. PG&E has assigned a crew to assess the outage. https://pge-outages.simonwillison.net/pge-outages/outages/1155565 November 29, 2020 - 01:45:00 UTC November 29, 2020 - 01:45:00 UTC
1606599986:1155567 38.11965 -122.26738 1155567 1 November 28, 2020 - 21:18:02 UTC 0 Vallejo PG&E is investigating the cause of your outage. PG&E is assessing the cause at the outage location. https://pge-outages.simonwillison.net/pge-outages/outages/1155567 November 28, 2020 - 23:15:00 UTC November 28, 2020 - 23:15:00 UTC
1606599986:1155575 38.10658 -122.24177 1155575 1 November 28, 2020 - 21:05:44 UTC 0 Vallejo Unknown - PG&E will be assessing the cause. PG&E has assigned a crew to assess the outage. https://pge-outages.simonwillison.net/pge-outages/outages/1155575 November 28, 2020 - 23:30:00 UTC November 28, 2020 - 23:30:00 UTC
1606599986:1155577 37.9155 -122.06907 1155577 1 November 28, 2020 - 21:28:44 UTC 1 Walnut Creek Unknown - PG&E will be assessing the cause. PG&E assessment crew is en route to the outage. https://pge-outages.simonwillison.net/pge-outages/outages/1155577 November 29, 2020 - 00:15:00 UTC November 29, 2020 - 00:15:00 UTC
1606599986:1155574 38.22854 -121.46689 1155574 1 November 28, 2020 - 21:12:00 UTC 0 Walnut Grove Unknown - PG&E will be assessing the cause. PG&E assessment crew is en route to the outage. https://pge-outages.simonwillison.net/pge-outages/outages/1155574 November 29, 2020 - 00:45:00 UTC November 29, 2020 - 00:45:00 UTC

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE VIEW most_recent_snapshot as
select
    outage_snapshots.id, latitude, longitude, outage, estCustAffected,
    lastUpdateTime, hazardFlag, regionName.name as region, cause.name as cause,
    crewCurrentStatus.name as crewCurrentStatus,
    'https://pge-outages.simonwillison.net/pge-outages/outages/' || outage as outage_url, currentEtor, autoEtor
from outage_snapshots
    join regionName on outage_snapshots.regionName = regionName.id
    join cause on outage_snapshots.cause = cause.id
    join crewCurrentStatus on outage_snapshots.crewCurrentStatus = crewCurrentStatus.id
where
    snapshot in (select id from snapshots order by id desc limit 1);