outage_snapshots

57 rows where snapshot = 123

View and edit SQL

id outage snapshot lastUpdateTime currentEtor autoEtor estCustAffected hazardFlag latitude longitude regionName cause crewCurrentStatus
1569986427:630055 630055 630055 2019-10-01 20:20:27-07:00 123 September 30, 2019 - 15:29:50 UTC October 02, 2019 - 23:00:00 UTC   1 0 38.12243 -121.83043 Rio Vista 21 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
1569986427:631014 631014 631014 2019-10-01 20:20:27-07:00 123 September 30, 2019 - 17:04:42 UTC October 03, 2019 - 21:30:00 UTC   1 0 39.0775 -121.52568 Olivehurst 17 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
1569986427:633488 633488 633488 2019-10-01 20:20:27-07:00 123 October 02, 2019 - 03:15:31 UTC October 02, 2019 - 03:00:00 UTC   27 1 35.99202 -119.57146 Kettleman City 10 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
1569986427:633546 633546 633546 2019-10-01 20:20:27-07:00 123 October 02, 2019 - 02:38:10 UTC October 02, 2019 - 13:00:00 UTC   9 0 37.87055 -122.03021 Walnut Creek 33 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
1569986427:633572 633572 633572 2019-10-01 20:20:27-07:00 123 October 01, 2019 - 22:01:08 UTC October 02, 2019 - 04:01:00 UTC   1 0 37.72031 -122.38494 San Francisco 25 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
1569986427:633774 633774 633774 2019-10-01 20:20:27-07:00 123 October 01, 2019 - 20:26:41 UTC October 01, 2019 - 21:00:00 UTC   1 0 38.64604 -120.97578 Cameron Park 101 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
1569986427:633797 633797 633797 2019-10-01 20:20:27-07:00 123 October 01, 2019 - 23:41:11 UTC October 02, 2019 - 03:00:00 UTC   11 0 40.50248 -124.28154 Ferndale 112 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
1569986427:633849 633849 633849 2019-10-01 20:20:27-07:00 123 October 02, 2019 - 02:32:58 UTC October 02, 2019 - 06:59:00 UTC   19 0 36.82228 -119.80053 Fresno 35 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
1569986427:633862 633862 633862 2019-10-01 20:20:27-07:00 123 October 01, 2019 - 21:39:42 UTC October 02, 2019 - 00:00:00 UTC   12 0 37.80511 -122.17103 Castro Valley 4 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
1569986427:633867 633867 633867 2019-10-01 20:20:27-07:00 123 October 02, 2019 - 00:00:07 UTC October 01, 2019 - 23:00:00 UTC   3 0 36.61702 -119.27686 Orange Cove 136 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
1569986427:633869 633869 633869 2019-10-01 20:20:27-07:00 123 October 01, 2019 - 22:02:27 UTC October 01, 2019 - 22:00:00 UTC   1 0 40.51095 -124.01787 Carlotta 139 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
1569986427:633903 633903 633903 2019-10-01 20:20:27-07:00 123 October 02, 2019 - 02:04:41 UTC October 02, 2019 - 06:30:00 UTC   28 0 37.84959 -122.21253 Oakland 16 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
1569986427:633964 633964 633964 2019-10-01 20:20:27-07:00 123 October 01, 2019 - 23:32:16 UTC October 02, 2019 - 11:00:00 UTC   2 0 37.57104 -121.99067 Fremont 140 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
1569986427:634613 634613 634613 2019-10-01 20:20:27-07:00 123 October 02, 2019 - 02:06:41 UTC October 02, 2019 - 04:00:00 UTC   1 0 36.38594 -119.65496 Hanford 73 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1569986427:634814 634814 634814 2019-10-01 20:20:27-07:00 123 October 02, 2019 - 02:33:02 UTC October 02, 2019 - 06:59:00 UTC   1 1 38.69436 -121.93466 Woodland 34 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
1569986427:634818 634818 634818 2019-10-01 20:20:27-07:00 123 October 02, 2019 - 02:39:25 UTC October 02, 2019 - 04:45:00 UTC   1 0 37.50102 -122.25797 San Carlos 24 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1569986427:634832 634832 634832 2019-10-01 20:20:27-07:00 123 October 01, 2019 - 21:15:47 UTC October 01, 2019 - 22:00:00 UTC   10 0 38.64148 -120.51459 Grizzly Flats 150 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
1569986427:634839 634839 634839 2019-10-01 20:20:27-07:00 123 October 02, 2019 - 03:08:26 UTC     25 0 37.73528 -122.4484 San Francisco 25 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1569986427:634865 634865 634865 2019-10-01 20:20:27-07:00 123 October 02, 2019 - 00:01:36 UTC October 02, 2019 - 05:00:00 UTC   1 0 38.78533 -120.75834 Placerville 19 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E is sending a repair crew to the outage location. 3
1569986427:634993 634993 634993 2019-10-01 20:20:27-07:00 123 October 02, 2019 - 03:07:59 UTC October 02, 2019 - 05:29:00 UTC   1 1 40.08537 -123.81121 Garberville 218 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1569986427:635098 635098 635098 2019-10-01 20:20:27-07:00 123 October 01, 2019 - 23:46:06 UTC October 02, 2019 - 02:00:00 UTC October 02, 2019 - 02:00:00 UTC 13 0 36.9922 -121.59684 Gilroy 223 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1569986427:635113 635113 635113 2019-10-01 20:20:27-07:00 123 October 02, 2019 - 03:00:26 UTC October 02, 2019 - 06:00:00 UTC   1 0 37.30889 -121.90237 San Jose 26 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1569986427:635337 635337 635337 2019-10-01 20:20:27-07:00 123 October 02, 2019 - 02:00:02 UTC October 02, 2019 - 04:15:00 UTC   3 0 36.35719 -120.09399 Huron 51 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1569986427:635341 635341 635341 2019-10-01 20:20:27-07:00 123 October 02, 2019 - 02:57:44 UTC October 02, 2019 - 07:01:00 UTC   56 1 36.22648 -121.11113 King City 196 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
1569986427:635354 635354 635354 2019-10-01 20:20:27-07:00 123 October 02, 2019 - 03:06:17 UTC October 02, 2019 - 10:03:00 UTC   53 1 37.54582 -121.9443 Fremont 140 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
1569986427:635358 635358 635358 2019-10-01 20:20:27-07:00 123 October 02, 2019 - 02:38:20 UTC October 02, 2019 - 09:00:00 UTC   6 1 37.24349 -121.01277 Gustine 228 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
1569986427:635363 635363 635363 2019-10-01 20:20:27-07:00 123 October 02, 2019 - 02:56:40 UTC October 02, 2019 - 06:00:00 UTC   27 1 35.55397 -121.07359 Cambria 3 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E is sending a repair crew to the outage location. 3
1569986427:635365 635365 635365 2019-10-01 20:20:27-07:00 123 October 02, 2019 - 02:40:31 UTC October 02, 2019 - 04:00:00 UTC   1 1 36.64152 -119.78306 Easton 233 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1569986427:635374 635374 635374 2019-10-01 20:20:27-07:00 123 October 02, 2019 - 02:52:20 UTC October 02, 2019 - 06:30:00 UTC   22 0 37.67522 -122.10853 Cherryland 232 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
1569986427:635400 635400 635400 2019-10-01 20:20:27-07:00 123 October 02, 2019 - 00:19:52 UTC October 02, 2019 - 04:00:00 UTC   3 0 37.50771 -121.94851 Fremont 140 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
1569986427:635402 635402 635402 2019-10-01 20:20:27-07:00 123 October 02, 2019 - 02:25:15 UTC October 02, 2019 - 03:30:00 UTC October 02, 2019 - 03:30:00 UTC 23 0 36.99122 -121.59603 Gilroy 223 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1569986427:635405 635405 635405 2019-10-01 20:20:27-07:00 123 October 02, 2019 - 02:55:00 UTC October 02, 2019 - 05:38:00 UTC   2 0 37.59914 -122.38716 Millbrae 173 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
1569986427:635407 635407 635407 2019-10-01 20:20:27-07:00 123 October 02, 2019 - 02:47:07 UTC October 02, 2019 - 06:30:00 UTC   1 0 37.67687 -122.10863 Cherryland 232 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1569986427:635415 635415 635415 2019-10-01 20:20:27-07:00 123 October 02, 2019 - 03:03:09 UTC October 02, 2019 - 06:00:00 UTC   14 1 37.36975 -121.8522 San Jose 26 PG&E is investigating the cause of your outage. 6 PG&E has assigned a crew to assess the outage. 1
1569986427:635433 635433 635433 2019-10-01 20:20:27-07:00 123 October 02, 2019 - 01:11:50 UTC October 02, 2019 - 06:00:00 UTC   32 0 38.98847 -122.8461 Lakeport 75 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
1569986427:635434 635434 635434 2019-10-01 20:20:27-07:00 123 October 02, 2019 - 02:48:49 UTC October 02, 2019 - 06:00:00 UTC   1 1 37.30824 -121.98493 San Jose 26 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1569986427:635436 635436 635436 2019-10-01 20:20:27-07:00 123 October 02, 2019 - 03:00:46 UTC October 02, 2019 - 08:00:00 UTC   1 0 37.55162 -122.32408 San Mateo 29 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1569986427:635437 635437 635437 2019-10-01 20:20:27-07:00 123 October 02, 2019 - 03:05:19 UTC October 02, 2019 - 04:45:00 UTC October 02, 2019 - 04:45:00 UTC 1 1 37.44192 -122.19825 Menlo Park 141 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E is sending a repair crew to the outage location. 3
1569986427:635438 635438 635438 2019-10-01 20:20:27-07:00 123 October 02, 2019 - 02:53:03 UTC October 02, 2019 - 06:00:00 UTC   7 1 38.08407 -121.98352 Suisun City 243 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1569986427:635440 635440 635440 2019-10-01 20:20:27-07:00 123 October 02, 2019 - 01:24:48 UTC October 02, 2019 - 04:00:00 UTC October 02, 2019 - 04:00:00 UTC 1 0 37.32584 -121.87129 San Jose 26 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1569986427:635441 635441 635441 2019-10-01 20:20:27-07:00 123 October 02, 2019 - 03:09:48 UTC October 02, 2019 - 06:00:00 UTC   52 0 37.31986 -121.97287 San Jose 26 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1569986427:635442 635442 635442 2019-10-01 20:20:27-07:00 123 October 02, 2019 - 02:36:11 UTC October 02, 2019 - 06:00:00 UTC   45 0 37.31943 -121.96799 San Jose 26 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1569986427:635453 635453 635453 2019-10-01 20:20:27-07:00 123 October 02, 2019 - 01:40:58 UTC October 02, 2019 - 04:00:00 UTC October 02, 2019 - 04:00:00 UTC 1 0 37.52943 -122.34497 Highlands-Baywood Park 74 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1569986427:635454 635454 635454 2019-10-01 20:20:27-07:00 123 October 02, 2019 - 01:50:51 UTC October 02, 2019 - 06:59:00 UTC   28 0 37.3989 -122.09166 Mountain View 242 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
1569986427:635455 635455 635455 2019-10-01 20:20:27-07:00 123 October 02, 2019 - 02:52:51 UTC October 02, 2019 - 04:45:00 UTC October 02, 2019 - 04:45:00 UTC 1 0 37.35649 -122.09286 Loyola 244 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1569986427:635459 635459 635459 2019-10-01 20:20:27-07:00 123 October 02, 2019 - 02:38:01 UTC     1 0 37.72681 -122.4397 San Francisco 25 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E is sending a repair crew to the outage location. 3
1569986427:635461 635461 635461 2019-10-01 20:20:27-07:00 123 October 02, 2019 - 02:24:10 UTC October 02, 2019 - 04:30:00 UTC October 02, 2019 - 04:30:00 UTC 1 1 38.89263 -121.2845 Lincoln 245 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1569986427:635476 635476 635476 2019-10-01 20:20:27-07:00 123 October 02, 2019 - 02:32:56 UTC October 02, 2019 - 05:00:00 UTC October 02, 2019 - 05:00:00 UTC 27 0 37.36879 -121.85176 San Jose 26 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1569986427:635493 635493 635493 2019-10-01 20:20:27-07:00 123 October 02, 2019 - 02:59:19 UTC October 02, 2019 - 04:45:00 UTC October 02, 2019 - 04:45:00 UTC 1 0 37.76319 -122.197 Oakland 16 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1569986427:635496 635496 635496 2019-10-01 20:20:27-07:00 123 October 02, 2019 - 02:51:07 UTC October 02, 2019 - 07:30:00 UTC October 02, 2019 - 07:30:00 UTC 1 1 35.41856 -119.03703 Oildale 246 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1569986427:635497 635497 635497 2019-10-01 20:20:27-07:00 123 October 02, 2019 - 03:13:20 UTC October 02, 2019 - 06:15:00 UTC October 02, 2019 - 06:15:00 UTC 35 4 34.90908 -120.44024 Santa Maria 52 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1569986427:635498 635498 635498 2019-10-01 20:20:27-07:00 123 October 02, 2019 - 02:30:19 UTC October 02, 2019 - 04:00:00 UTC October 02, 2019 - 04:00:00 UTC 1 0 37.45352 -121.90816 Milpitas 142 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1569986427:635513 635513 635513 2019-10-01 20:20:27-07:00 123 October 02, 2019 - 03:06:20 UTC October 02, 2019 - 05:00:00 UTC October 02, 2019 - 05:00:00 UTC 1 1 37.57683 -122.34939 Burlingame 203 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1569986427:635517 635517 635517 2019-10-01 20:20:27-07:00 123 October 02, 2019 - 03:03:16 UTC October 02, 2019 - 05:45:00 UTC October 02, 2019 - 05:45:00 UTC 13 0 37.2816 -121.8698 San Jose 26 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1569986427:635518 635518 635518 2019-10-01 20:20:27-07:00 123 October 02, 2019 - 02:54:55 UTC October 02, 2019 - 06:00:00 UTC October 02, 2019 - 06:00:00 UTC 1 0 37.95536 -122.04391 Concord 46 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1569986427:635519 635519 635519 2019-10-01 20:20:27-07:00 123 October 02, 2019 - 03:04:10 UTC October 02, 2019 - 06:00:00 UTC October 02, 2019 - 06:00:00 UTC 1 0 37.2795 -121.86861 San Jose 26 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1569986427:635520 635520 635520 2019-10-01 20:20:27-07:00 123 October 02, 2019 - 03:06:10 UTC October 02, 2019 - 06:00:00 UTC October 02, 2019 - 06:00:00 UTC 1 0 37.2853 -121.87071 San Jose 26 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])
)
Powered by Datasette · Query took 4083.061ms · About: About this site