outage_snapshots

125 rows where snapshot = 9055 sorted by estCustAffected

✎ View and edit SQL

This data as json, CSV (advanced)

id outage snapshot lastUpdateTime currentEtor autoEtor estCustAffected ▼ hazardFlag latitude longitude regionName cause crewCurrentStatus
1575588620:730716 730716 730716 2019-12-05 15:30:20-08:00 9055 December 05, 2019 - 22:18:52 UTC     16 0 39.00805 -123.36628 Boonville 771 PG&E is investigating the cause of your outage. 6 PG&E has assigned a crew to assess the outage. 1
1575588620:730397 730397 730397 2019-12-05 15:30:20-08:00 9055 December 05, 2019 - 19:51:54 UTC December 06, 2019 - 03:00:00 UTC   23 0 37.47131 -122.16683 Menlo Park 141 Our preliminary determination is that your outage was caused by scheduled maintenance work. 3 PG&E is assessing the cause at the outage location. 4
1575588620:730761 730761 730761 2019-12-05 15:30:20-08:00 9055 December 05, 2019 - 23:09:47 UTC December 06, 2019 - 01:15:00 UTC December 06, 2019 - 01:15:00 UTC 24 0 37.32187 -120.49011 Merced 13 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1575588620:730436 730436 730436 2019-12-05 15:30:20-08:00 9055 December 05, 2019 - 17:45:25 UTC December 06, 2019 - 00:30:00 UTC   26 0 38.44686 -122.72323 Santa Rosa 30 Our preliminary determination is that your outage was caused by scheduled maintenance work. 3 PG&E has assigned a crew to assess the outage. 1
1575588620:730282 730282 730282 2019-12-05 15:30:20-08:00 9055 December 05, 2019 - 16:15:56 UTC December 06, 2019 - 01:00:00 UTC   28 0 40.46928 -123.70108 Bridgeville 620 Our preliminary determination is that your outage was caused by scheduled maintenance work. 3 PG&E has assigned a crew to assess the outage. 1
1575588620:730773 730773 730773 2019-12-05 15:30:20-08:00 9055 December 05, 2019 - 22:42:47 UTC December 06, 2019 - 01:45:00 UTC December 06, 2019 - 01:45:00 UTC 34 0 36.76241 -121.7538 Castroville 227 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1575588620:730577 730577 730577 2019-12-05 15:30:20-08:00 9055 December 05, 2019 - 23:21:00 UTC December 05, 2019 - 18:00:00 UTC   41 0 37.12285 -121.6593 Morgan Hill 319 Our preliminary determination is that your outage was caused by scheduled maintenance work. 3 PG&E is sending a repair crew to the outage location. 3
1575588620:730366 730366 730366 2019-12-05 15:30:20-08:00 9055 December 05, 2019 - 17:07:44 UTC December 06, 2019 - 01:00:00 UTC   42 0 37.72951 -122.3732 San Francisco 25 Our preliminary determination is that your outage was caused by scheduled maintenance work. 3 PG&E has assigned a crew to assess the outage. 1
1575588620:730310 730310 730310 2019-12-05 15:30:20-08:00 9055 December 05, 2019 - 22:34:08 UTC December 05, 2019 - 18:15:00 UTC December 05, 2019 - 18:15:00 UTC 48 0 37.72025 -122.43422 San Francisco 25 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1575588620:730432 730432 730432 2019-12-05 15:30:20-08:00 9055 December 05, 2019 - 17:49:44 UTC December 06, 2019 - 01:00:00 UTC   48 0 37.01404 -121.59986 Gilroy 223 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
1575588620:730713 730713 730713 2019-12-05 15:30:20-08:00 9055 December 05, 2019 - 22:43:12 UTC December 06, 2019 - 00:45:00 UTC December 06, 2019 - 00:45:00 UTC 54 0 39.18402 -120.99946 Grass Valley 113 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1575588620:730267 730267 730267 2019-12-05 15:30:20-08:00 9055 December 05, 2019 - 23:20:31 UTC December 06, 2019 - 10:00:00 UTC   55 6 35.38864 -119.00425 Bakersfield 2 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
1575588620:730812 730812 730812 2019-12-05 15:30:20-08:00 9055 December 05, 2019 - 23:26:06 UTC December 06, 2019 - 02:00:00 UTC December 06, 2019 - 02:00:00 UTC 68 0 37.78078 -122.48059 San Francisco 25 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1575588620:730409 730409 730409 2019-12-05 15:30:20-08:00 9055 December 05, 2019 - 18:02:56 UTC December 06, 2019 - 01:00:00 UTC   80 0 40.66832 -124.19738 Loleta 440 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
1575588620:730479 730479 730479 2019-12-05 15:30:20-08:00 9055 December 05, 2019 - 18:47:52 UTC December 05, 2019 - 23:00:00 UTC   81 0 39.46722 -120.84607 Alleghany 633 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
1575588620:730356 730356 730356 2019-12-05 15:30:20-08:00 9055 December 05, 2019 - 17:14:07 UTC December 06, 2019 - 01:30:00 UTC   102 0 37.95955 -122.10526 Martinez 37 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
1575588620:730782 730782 730782 2019-12-05 15:30:20-08:00 9055 December 05, 2019 - 23:05:09 UTC     111 0 38.97812 -122.87044 Kelseyville 282 PG&E is investigating the cause of your outage. 6 PG&E assessment crew is en route to the outage. 5
1575588620:730204 730204 730204 2019-12-05 15:30:20-08:00 9055 December 05, 2019 - 23:15:43 UTC December 06, 2019 - 02:00:00 UTC   129 0 37.84714 -122.27711 Oakland 16 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
1575588620:730387 730387 730387 2019-12-05 15:30:20-08:00 9055 December 05, 2019 - 23:01:27 UTC December 06, 2019 - 01:00:00 UTC   143 0 37.5652 -122.29286 San Mateo 29 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
1575588620:730296 730296 730296 2019-12-05 15:30:20-08:00 9055 December 05, 2019 - 23:20:58 UTC December 06, 2019 - 01:00:00 UTC   195 0 37.7431 -122.46167 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
1575588620:730486 730486 730486 2019-12-05 15:30:20-08:00 9055 December 05, 2019 - 21:06:22 UTC December 05, 2019 - 21:15:00 UTC December 05, 2019 - 21:15:00 UTC 220 0 37.74062 -121.44116 Tracy 38 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1575588620:730775 730775 730775 2019-12-05 15:30:20-08:00 9055 December 05, 2019 - 23:25:27 UTC December 06, 2019 - 00:00:00 UTC   273 0 38.50613 -122.94368 Forestville 214 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
1575588620:730332 730332 730332 2019-12-05 15:30:20-08:00 9055 December 05, 2019 - 23:24:21 UTC December 06, 2019 - 00:00:00 UTC   317 0 38.84946 -121.15955 Penryn 352 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
1575588620:730725 730725 730725 2019-12-05 15:30:20-08:00 9055 December 05, 2019 - 23:25:26 UTC December 06, 2019 - 00:45:00 UTC December 06, 2019 - 00:45:00 UTC 1371 1 37.33594 -120.5054 Merced 13 Our preliminary determination is that your outage was caused by an emergency issue. 4 PG&E is sending a repair crew to the outage location. 3
1575588620:730726 730726 730726 2019-12-05 15:30:20-08:00 9055 December 05, 2019 - 23:25:10 UTC December 06, 2019 - 00:45:00 UTC December 06, 2019 - 00:45:00 UTC 3300 0 37.33594 -120.50542 Merced 13 Our preliminary determination is that your outage was caused by an equipment issue. 2 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])
);
CREATE INDEX [idx_outage_snapshots_outage]
    ON [outage_snapshots] ([outage]);