125 rows where snapshot = 9055

View and edit SQL

id ▼ outage snapshot lastUpdateTime currentEtor autoEtor estCustAffected hazardFlag latitude longitude regionName cause crewCurrentStatus
1575588620:730766 730766 730766 2019-12-05 15:30:20-08:00 9055 December 05, 2019 - 22:46:53 UTC December 06, 2019 - 02:00:00 UTC December 06, 2019 - 02:00:00 UTC 1 0 37.88385 -120.39567 Jamestown 193 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1575588620:730767 730767 730767 2019-12-05 15:30:20-08:00 9055 December 05, 2019 - 23:17:40 UTC December 06, 2019 - 02:00:00 UTC December 06, 2019 - 02:00:00 UTC 1 0 36.84225 -119.79278 Fresno 35 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1575588620:730770 730770 730770 2019-12-05 15:30:20-08:00 9055 December 05, 2019 - 22:54:09 UTC December 06, 2019 - 01:45:00 UTC December 06, 2019 - 01:45:00 UTC 1 0 36.50302 -121.44636 Gonzales 406 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1575588620:730771 730771 730771 2019-12-05 15:30:20-08:00 9055 December 05, 2019 - 22:56:32 UTC December 06, 2019 - 01:15:00 UTC December 06, 2019 - 01:15:00 UTC 1 0 36.72781 -119.80023 Fresno 35 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1575588620:730772 730772 730772 2019-12-05 15:30:20-08:00 9055 December 05, 2019 - 23:22:18 UTC December 06, 2019 - 01:45:00 UTC December 06, 2019 - 01:45:00 UTC 1 0 36.49484 -119.58403 Kingsburg 390 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
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: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:730776 730776 730776 2019-12-05 15:30:20-08:00 9055 December 05, 2019 - 23:00:53 UTC December 06, 2019 - 02:15:00 UTC December 06, 2019 - 02:15:00 UTC 1 0 36.95574 -122.035 Santa Cruz 104 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1575588620:730781 730781 730781 2019-12-05 15:30:20-08:00 9055 December 05, 2019 - 23:07:11 UTC December 06, 2019 - 00:30:00 UTC December 06, 2019 - 00:30:00 UTC 1 0 34.86789 -120.42429 Orcutt 249 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
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:730783 730783 730783 2019-12-05 15:30:20-08:00 9055 December 05, 2019 - 23:04:24 UTC December 06, 2019 - 02:00:00 UTC December 06, 2019 - 02:00:00 UTC 1 0 37.33795 -120.58037 Atwater 87 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1575588620:730784 730784 730784 2019-12-05 15:30:20-08:00 9055 December 05, 2019 - 23:03:59 UTC December 06, 2019 - 01:45:00 UTC December 06, 2019 - 01:45:00 UTC 1 1 37.54141 -121.99799 Fremont 140 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1575588620:730788 730788 730788 2019-12-05 15:30:20-08:00 9055 December 05, 2019 - 22:57:01 UTC     1 0 40.76787 -124.18802 Bayview/Pine Hill 612 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1575588620:730792 730792 730792 2019-12-05 15:30:20-08:00 9055 December 05, 2019 - 22:54:32 UTC December 06, 2019 - 01:45:00 UTC December 06, 2019 - 01:45:00 UTC 1 0 37.38621 -122.08299 Mountain View 242 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1575588620:730796 730796 730796 2019-12-05 15:30:20-08:00 9055 December 05, 2019 - 23:04:30 UTC December 06, 2019 - 02:45:00 UTC December 06, 2019 - 02:45:00 UTC 1 1 40.72948 -122.31812 Mountain Gate 587 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1575588620:730801 730801 730801 2019-12-05 15:30:20-08:00 9055 December 05, 2019 - 23:19:09 UTC December 06, 2019 - 00:45:00 UTC December 06, 2019 - 00:45:00 UTC 1 1 37.29765 -121.97512 San Jose 26 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1575588620:730802 730802 730802 2019-12-05 15:30:20-08:00 9055 December 05, 2019 - 23:23:49 UTC December 06, 2019 - 02:00:00 UTC December 06, 2019 - 02:00:00 UTC 1 1 37.99517 -122.57766 San Anselmo 183 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1575588620:730803 730803 730803 2019-12-05 15:30:20-08:00 9055 December 05, 2019 - 23:13:55 UTC December 06, 2019 - 02:45:00 UTC December 06, 2019 - 02:45:00 UTC 1 1 37.37982 -122.13633 Los Altos Hills 125 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1575588620:730805 730805 730805 2019-12-05 15:30:20-08:00 9055 December 05, 2019 - 23:25:43 UTC December 06, 2019 - 02:15:00 UTC December 06, 2019 - 02:15:00 UTC 1 0 38.42048 -122.76112 Santa Rosa 30 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1575588620:730807 730807 730807 2019-12-05 15:30:20-08:00 9055 December 05, 2019 - 23:17:16 UTC December 06, 2019 - 01:00:00 UTC December 06, 2019 - 01:00:00 UTC 1 0 37.53799 -121.99506 Fremont 140 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1575588620:730808 730808 730808 2019-12-05 15:30:20-08:00 9055 December 05, 2019 - 23:16:32 UTC December 06, 2019 - 03:30:00 UTC December 06, 2019 - 03:30:00 UTC 2 0 38.10071 -122.87328 Inverness 402 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1575588620:730810 730810 730810 2019-12-05 15:30:20-08:00 9055 December 05, 2019 - 23:22:48 UTC December 06, 2019 - 01:45:00 UTC December 06, 2019 - 01:45:00 UTC 1 0 37.29092 -119.53027 North Fork 128 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1575588620:730811 730811 730811 2019-12-05 15:30:20-08:00 9055 December 05, 2019 - 23:26:03 UTC December 06, 2019 - 02:15:00 UTC December 06, 2019 - 02:15:00 UTC 9 1 36.62093 -119.71371 Fowler 89 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
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:730813 730813 730813 2019-12-05 15:30:20-08:00 9055 December 05, 2019 - 23:26:00 UTC December 06, 2019 - 02:00:00 UTC December 06, 2019 - 02:00:00 UTC 1 0 37.80178 -122.41439 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])
);
CREATE INDEX [idx_outage_snapshots_outage]
    ON [outage_snapshots] ([outage]);