most_recent_snapshot (view)

29 rows

View and edit SQL

id latitude longitude outage estCustAffected lastUpdateTime hazardFlag region cause crewCurrentStatus outage_url currentEtor autoEtor
1581682224:790663 35.07626 -118.98411 790663 1 February 14, 2020 - 08:41:45 UTC 0 Bakersfield 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/outage/790663 February 14, 2020 - 14:00:00 UTC  
1581682224:790688 37.58044 -122.35129 790688 1 February 14, 2020 - 11:38:06 UTC 0 Burlingame 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/outage/790688 February 14, 2020 - 13:30:00 UTC  
1581682224:790647 37.03319 -122.09202 790647 1 February 14, 2020 - 07:38:26 UTC 1 Felton 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/outage/790647 February 14, 2020 - 20:53:00 UTC  
1581682224:790665 38.79033 -123.51053 790665 7 February 14, 2020 - 06:37:38 UTC 0 Gualala 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/outage/790665 February 14, 2020 - 22:00:00 UTC  
1581682224:790389 38.81821 -121.12383 790389 1 February 14, 2020 - 01:29:33 UTC 0 Loomis 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/outage/790389 February 13, 2020 - 22:15:00 UTC February 13, 2020 - 22:15:00 UTC
1581682224:790755 35.73397 -119.73413 790755 1 February 14, 2020 - 11:43:34 UTC 0 Lost Hills 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/outage/790755 February 14, 2020 - 15:45:00 UTC February 14, 2020 - 15:45:00 UTC
1581682224:790754 38.85497 -122.53459 790754 1 February 14, 2020 - 11:35:18 UTC 0 Lower 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/outage/790754 February 14, 2020 - 15:00:00 UTC February 14, 2020 - 15:00:00 UTC
1581682224:790744 40.93954 -124.10393 790744 104 February 14, 2020 - 09:17:56 UTC 0 McKinleyville 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/outage/790744 February 14, 2020 - 13:00:00 UTC  
1581682224:787079 38.30601 -120.71517 787079 3 February 10, 2020 - 23:11:58 UTC 0 Mokelumne Hill 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/outage/787079 February 16, 2020 - 01:00:00 UTC  
1581682224:790087 37.16139 -121.65672 790087 8 February 14, 2020 - 10:53:18 UTC 1 Morgan Hill 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/outage/790087 February 14, 2020 - 13:00:00 UTC  
1581682224:790363 38.92511 -121.06046 790363 6 February 13, 2020 - 19:00:44 UTC 0 North Auburn 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/outage/790363 February 13, 2020 - 22:00:00 UTC  
1581682224:790756 37.84847 -122.26193 790756 28 February 14, 2020 - 11:51:40 UTC 0 Oakland 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/outage/790756 February 14, 2020 - 14:45:00 UTC February 14, 2020 - 14:45:00 UTC
1581682224:790734 37.99638 -121.7301 790734 1 February 14, 2020 - 07:27:54 UTC 0 Oakley 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/outage/790734 February 14, 2020 - 14:00:00 UTC  
1581682224:790746 37.99554 -121.67864 790746 1 February 14, 2020 - 09:15:32 UTC 0 Oakley 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/outage/790746 February 14, 2020 - 13:30:00 UTC February 14, 2020 - 13:30:00 UTC
1581682224:790741 38.00501 -121.89947 790741 6 February 14, 2020 - 09:56:17 UTC 0 Pittsburg 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/outage/790741 February 14, 2020 - 12:45:00 UTC February 14, 2020 - 12:45:00 UTC
1581682224:790694 37.91056 -122.31498 790694 1 February 14, 2020 - 10:08:10 UTC 0 Richmond 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/outage/790694 February 14, 2020 - 14:30:00 UTC  
1581682224:790693 37.91107 -122.31596 790693 23 February 14, 2020 - 10:04:42 UTC 0 Richmond Our preliminary determination is that your outage was caused by an equipment issue. PG&E repair crew is en route to the outage location. https://pge-outages.simonwillison.net/pge-outages/outage/790693 February 14, 2020 - 14:45:00 UTC  
1581682224:790401 37.7961 -122.40648 790401 1 February 14, 2020 - 06:43:23 UTC 0 San Francisco 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/outage/790401 February 14, 2020 - 15:00:00 UTC  
1581682224:790757 37.35922 -121.84547 790757 1 February 14, 2020 - 12:05:27 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/outage/790757 February 14, 2020 - 15:45:00 UTC February 14, 2020 - 15:45:00 UTC
1581682224:790710 37.29939 -121.93051 790710 1 February 14, 2020 - 10:54:11 UTC 0 San Jose 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/outage/790710 February 14, 2020 - 15:00:00 UTC  
1581682224:790720 35.28237 -120.65767 790720 13 February 14, 2020 - 06:15:23 UTC 0 San Luis Obispo 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/outage/790720 February 14, 2020 - 14:00:00 UTC  
1581682224:790721 35.28174 -120.65683 790721 71 February 14, 2020 - 06:47:47 UTC 0 San Luis Obispo 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/outage/790721 February 14, 2020 - 14:00:00 UTC  
1581682224:790724 37.07669 -121.98167 790724 15 February 14, 2020 - 07:57:26 UTC 1 Santa Cruz 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/outage/790724 February 14, 2020 - 20:43:00 UTC  
1581682224:790711 38.44526 -122.70611 790711 12 February 14, 2020 - 05:05:51 UTC 0 Santa Rosa 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/outage/790711 February 14, 2020 - 14:00:00 UTC  
1581682224:789667 37.89181 -121.43945 789667 4 February 14, 2020 - 02:37:12 UTC 1 Stockton 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/outage/789667 February 15, 2020 - 07:59:00 UTC  
1581682224:790751 38.02003 -121.28048 790751 1292 February 14, 2020 - 11:56:21 UTC 0 Stockton 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/outage/790751 February 14, 2020 - 13:45:00 UTC February 14, 2020 - 13:45:00 UTC
1581682224:790752 38.0264 -121.30396 790752 1 February 14, 2020 - 10:30:06 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/outage/790752 February 14, 2020 - 13:45:00 UTC February 14, 2020 - 13:45:00 UTC
1581682224:790749 37.95763 -121.30405 790749 15 February 14, 2020 - 11:01:32 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/outage/790749 February 14, 2020 - 12:15:00 UTC February 14, 2020 - 12:15:00 UTC
1581682224:790730 37.10001 -120.93058 790730 70 February 14, 2020 - 10:21:22 UTC 1 Volta 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/outage/790730 February 14, 2020 - 17:00: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/outage/' || 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)
Powered by Datasette · Query took 6134.687ms · About: About this site