pge-outages

This data as json, CSV

id	outage	snapshot	lastUpdateTime	currentEtor	autoEtor	estCustAffected	latitude	longitude	regionName	cause	crewCurrentStatus
1569963629:634833	634833	85	October 01, 2019 - 20:55:17 UTC	October 02, 2019 - 03:30:00 UTC	October 02, 2019 - 03:30:00 UTC	1	35.28337	-119.63854	195	1	1
1569964228:634833	634833	86	October 01, 2019 - 20:57:36 UTC	October 02, 2019 - 03:30:00 UTC	October 02, 2019 - 03:30:00 UTC	1	35.28337	-119.63854	195	1	5
1569964818:634833	634833	87	October 01, 2019 - 20:57:36 UTC	October 02, 2019 - 03:30:00 UTC	October 02, 2019 - 03:30:00 UTC	1	35.28337	-119.63854	195	1	5
1569965440:634833	634833	88	October 01, 2019 - 20:57:36 UTC	October 02, 2019 - 03:30:00 UTC	October 02, 2019 - 03:30:00 UTC	1	35.28337	-119.63854	195	1	5
1569966020:634833	634833	89	October 01, 2019 - 20:57:36 UTC	October 02, 2019 - 03:30:00 UTC	October 02, 2019 - 03:30:00 UTC	1	35.28337	-119.63854	195	1	5
1569966613:634833	634833	90	October 01, 2019 - 20:57:36 UTC	October 02, 2019 - 03:30:00 UTC	October 02, 2019 - 03:30:00 UTC	1	35.28337	-119.63854	195	1	5
1569967246:634833	634833	91	October 01, 2019 - 20:57:36 UTC	October 02, 2019 - 03:30:00 UTC	October 02, 2019 - 03:30:00 UTC	1	35.28337	-119.63854	195	1	5
1569967836:634833	634833	92	October 01, 2019 - 21:58:07 UTC	October 02, 2019 - 03:30:00 UTC	October 02, 2019 - 03:30:00 UTC	1	35.28337	-119.63854	195	6	4
1569968422:634833	634833	93	October 01, 2019 - 21:58:07 UTC	October 02, 2019 - 03:30:00 UTC	October 02, 2019 - 03:30:00 UTC	1	35.28337	-119.63854	195	6	4
1569969014:634833	634833	94	October 01, 2019 - 21:58:07 UTC	October 02, 2019 - 03:30:00 UTC	October 02, 2019 - 03:30:00 UTC	1	35.28337	-119.63854	195	6	4
1571779221:677010	677010	2944	October 22, 2019 - 21:13:03 UTC	October 23, 2019 - 01:15:00 UTC	October 23, 2019 - 01:15:00 UTC	1	35.2309	-119.5979	195	1	1
1571779221:677015	677015	2944	October 22, 2019 - 21:15:37 UTC	October 23, 2019 - 01:15:00 UTC	October 23, 2019 - 01:15:00 UTC	14	35.22419	-119.59838	195	1	1
1571779837:677010	677010	2945	October 22, 2019 - 21:13:03 UTC	October 23, 2019 - 01:15:00 UTC	October 23, 2019 - 01:15:00 UTC	1	35.2309	-119.5979	195	1	1
1571779837:677015	677015	2945	October 22, 2019 - 21:21:02 UTC	October 23, 2019 - 01:15:00 UTC	October 23, 2019 - 01:15:00 UTC	10	35.22419	-119.59838	195	1	1
1571780421:677010	677010	2946	October 22, 2019 - 21:13:03 UTC	October 23, 2019 - 01:15:00 UTC	October 23, 2019 - 01:15:00 UTC	1	35.2309	-119.5979	195	1	1
1571780421:677015	677015	2946	October 22, 2019 - 21:21:02 UTC	October 23, 2019 - 01:15:00 UTC	October 23, 2019 - 01:15:00 UTC	10	35.22419	-119.59838	195	1	5
1571781014:677010	677010	2947	October 22, 2019 - 21:13:03 UTC	October 23, 2019 - 01:15:00 UTC	October 23, 2019 - 01:15:00 UTC	1	35.2309	-119.5979	195	1	1
1571781014:677015	677015	2947	October 22, 2019 - 21:21:02 UTC	October 23, 2019 - 01:15:00 UTC	October 23, 2019 - 01:15:00 UTC	10	35.22419	-119.59838	195	1	5
1571781624:677010	677010	2948	October 22, 2019 - 21:49:37 UTC	October 23, 2019 - 01:15:00 UTC	October 23, 2019 - 01:15:00 UTC	1	35.2309	-119.5979	195	1	1
1571781624:677015	677015	2948	October 22, 2019 - 21:47:55 UTC	October 23, 2019 - 01:15:00 UTC	October 23, 2019 - 01:15:00 UTC	10	35.22419	-119.59838	195	6	4
1571782216:677010	677010	2949	October 22, 2019 - 21:49:37 UTC	October 23, 2019 - 01:15:00 UTC	October 23, 2019 - 01:15:00 UTC	1	35.2309	-119.5979	195	1	1
1571782216:677015	677015	2949	October 22, 2019 - 21:47:55 UTC	October 23, 2019 - 01:15:00 UTC	October 23, 2019 - 01:15:00 UTC	10	35.22419	-119.59838	195	6	4
1571782826:677010	677010	2950	October 22, 2019 - 21:49:37 UTC	October 23, 2019 - 01:15:00 UTC	October 23, 2019 - 01:15:00 UTC	1	35.2309	-119.5979	195	1	1
1571782826:677015	677015	2950	October 22, 2019 - 21:47:55 UTC	October 23, 2019 - 01:15:00 UTC	October 23, 2019 - 01:15:00 UTC	10	35.22419	-119.59838	195	6	4
1571783413:677010	677010	2951	October 22, 2019 - 21:49:37 UTC	October 23, 2019 - 01:15:00 UTC	October 23, 2019 - 01:15:00 UTC	1	35.2309	-119.5979	195	1	1
1571783413:677015	677015	2951	October 22, 2019 - 21:47:55 UTC	October 23, 2019 - 01:15:00 UTC	October 23, 2019 - 01:15:00 UTC	10	35.22419	-119.59838	195	6	4
1571785225:677010	677010	2952	October 22, 2019 - 21:49:37 UTC	October 23, 2019 - 01:15:00 UTC	October 23, 2019 - 01:15:00 UTC	1	35.2309	-119.5979	195	1	1
1571785225:677015	677015	2952	October 22, 2019 - 21:47:55 UTC	October 23, 2019 - 01:15:00 UTC	October 23, 2019 - 01:15:00 UTC	10	35.22419	-119.59838	195	6	4
1571785813:677010	677010	2953	October 22, 2019 - 21:49:37 UTC	October 23, 2019 - 01:15:00 UTC	October 23, 2019 - 01:15:00 UTC	1	35.2309	-119.5979	195	1	1
1571785813:677015	677015	2953	October 22, 2019 - 21:47:55 UTC	October 23, 2019 - 01:15:00 UTC	October 23, 2019 - 01:15:00 UTC	10	35.22419	-119.59838	195	6	4
1571786423:677010	677010	2954	October 22, 2019 - 21:49:37 UTC	October 23, 2019 - 01:15:00 UTC	October 23, 2019 - 01:15:00 UTC	1	35.2309	-119.5979	195	1	1
1571786423:677015	677015	2954	October 22, 2019 - 23:15:26 UTC	October 23, 2019 - 01:15:00 UTC	October 23, 2019 - 01:15:00 UTC	4	35.22419	-119.59838	195	6	4
1571787037:677010	677010	2955	October 22, 2019 - 21:49:37 UTC	October 23, 2019 - 01:15:00 UTC	October 23, 2019 - 01:15:00 UTC	1	35.2309	-119.5979	195	1	1
1571787037:677015	677015	2955	October 22, 2019 - 23:15:26 UTC	October 23, 2019 - 01:15:00 UTC	October 23, 2019 - 01:15:00 UTC	4	35.22419	-119.59838	195	6	4
1571787618:677010	677010	2956	October 22, 2019 - 21:49:37 UTC	October 23, 2019 - 01:15:00 UTC	October 23, 2019 - 01:15:00 UTC	1	35.2309	-119.5979	195	1	1
1571787618:677015	677015	2956	October 22, 2019 - 23:15:26 UTC	October 23, 2019 - 01:15:00 UTC	October 23, 2019 - 01:15:00 UTC	4	35.22419	-119.59838	195	6	4
1571788220:677010	677010	2957	October 22, 2019 - 21:49:37 UTC	October 23, 2019 - 01:15:00 UTC	October 23, 2019 - 01:15:00 UTC	1	35.2309	-119.5979	195	1	1
1571788220:677015	677015	2957	October 22, 2019 - 23:15:26 UTC	October 23, 2019 - 01:15:00 UTC	October 23, 2019 - 01:15:00 UTC	4	35.22419	-119.59838	195	6	4
1571788821:677010	677010	2958	October 22, 2019 - 21:49:37 UTC	October 23, 2019 - 01:15:00 UTC	October 23, 2019 - 01:15:00 UTC	1	35.2309	-119.5979	195	1	1
1571788821:677015	677015	2958	October 22, 2019 - 23:15:26 UTC	October 23, 2019 - 01:15:00 UTC	October 23, 2019 - 01:15:00 UTC	4	35.22419	-119.59838	195	6	4
1571789429:677010	677010	2959	October 22, 2019 - 21:49:37 UTC	October 23, 2019 - 01:15:00 UTC	October 23, 2019 - 01:15:00 UTC	1	35.2309	-119.5979	195	1	1
1571789429:677015	677015	2959	October 22, 2019 - 23:15:26 UTC	October 23, 2019 - 01:15:00 UTC	October 23, 2019 - 01:15:00 UTC	4	35.22419	-119.59838	195	6	4
1571790025:677010	677010	2960	October 22, 2019 - 21:49:37 UTC	October 23, 2019 - 01:15:00 UTC	October 23, 2019 - 01:15:00 UTC	1	35.2309	-119.5979	195	1	1
1571790025:677015	677015	2960	October 23, 2019 - 00:14:25 UTC	October 23, 2019 - 01:15:00 UTC	October 23, 2019 - 01:15:00 UTC	2	35.22419	-119.59838	195	6	4
1571790617:677010	677010	2961	October 22, 2019 - 21:49:37 UTC	October 23, 2019 - 01:15:00 UTC	October 23, 2019 - 01:15:00 UTC	1	35.2309	-119.5979	195	1	1
1571790617:677015	677015	2961	October 23, 2019 - 00:14:25 UTC	October 23, 2019 - 01:15:00 UTC	October 23, 2019 - 01:15:00 UTC	2	35.22419	-119.59838	195	6	4
1571791226:677010	677010	2962	October 22, 2019 - 21:49:37 UTC	October 23, 2019 - 01:15:00 UTC	October 23, 2019 - 01:15:00 UTC	1	35.2309	-119.5979	195	1	1
1571791226:677015	677015	2962	October 23, 2019 - 00:14:25 UTC	October 23, 2019 - 01:15:00 UTC	October 23, 2019 - 01:15:00 UTC	2	35.22419	-119.59838	195	6	4
1571791826:677010	677010	2963	October 22, 2019 - 21:49:37 UTC	October 23, 2019 - 01:15:00 UTC	October 23, 2019 - 01:15:00 UTC	1	35.2309	-119.5979	195	1	1
1571791826:677015	677015	2963	October 23, 2019 - 00:14:25 UTC	October 23, 2019 - 01:15:00 UTC	October 23, 2019 - 01:15:00 UTC	2	35.22419	-119.59838	195	6	4
1571792438:677010	677010	2964	October 23, 2019 - 00:47:36 UTC	October 23, 2019 - 05:47:00 UTC		1	35.2309	-119.5979	195	1	1
1571792438:677015	677015	2964	October 23, 2019 - 00:14:25 UTC	October 23, 2019 - 01:15:00 UTC	October 23, 2019 - 01:15:00 UTC	2	35.22419	-119.59838	195	6	4
1571793020:677010	677010	2965	October 23, 2019 - 00:47:36 UTC	October 23, 2019 - 05:47:00 UTC		1	35.2309	-119.5979	195	1	1
1571793020:677015	677015	2965	October 23, 2019 - 00:14:25 UTC	October 23, 2019 - 01:15:00 UTC	October 23, 2019 - 01:15:00 UTC	2	35.22419	-119.59838	195	6	4
1571793616:677010	677010	2966	October 23, 2019 - 00:47:36 UTC	October 23, 2019 - 05:47:00 UTC		1	35.2309	-119.5979	195	1	1
1571793616:677015	677015	2966	October 23, 2019 - 01:08:15 UTC	October 23, 2019 - 01:15:00 UTC	October 23, 2019 - 01:15:00 UTC	2	35.22419	-119.59838	195	6	4
1571794220:677010	677010	2967	October 23, 2019 - 00:47:36 UTC	October 23, 2019 - 05:47:00 UTC		1	35.2309	-119.5979	195	1	1
1571794220:677015	677015	2967	October 23, 2019 - 01:12:27 UTC	October 23, 2019 - 05:45:00 UTC		2	35.22419	-119.59838	195	6	4
1571794820:677010	677010	2968	October 23, 2019 - 00:47:36 UTC	October 23, 2019 - 05:47:00 UTC		1	35.2309	-119.5979	195	1	1
1571794820:677015	677015	2968	October 23, 2019 - 01:12:27 UTC	October 23, 2019 - 05:45:00 UTC		2	35.22419	-119.59838	195	6	4
1571795414:677010	677010	2969	October 23, 2019 - 00:47:36 UTC	October 23, 2019 - 05:47:00 UTC		1	35.2309	-119.5979	195	1	1
1571795414:677015	677015	2969	October 23, 2019 - 01:12:27 UTC	October 23, 2019 - 05:45:00 UTC		2	35.22419	-119.59838	195	6	4
1571796022:677010	677010	2970	October 23, 2019 - 00:47:36 UTC	October 23, 2019 - 05:47:00 UTC		1	35.2309	-119.5979	195	1	1
1571796022:677015	677015	2970	October 23, 2019 - 01:12:27 UTC	October 23, 2019 - 05:45:00 UTC		2	35.22419	-119.59838	195	6	4
1571796622:677010	677010	2971	October 23, 2019 - 00:47:36 UTC	October 23, 2019 - 05:47:00 UTC		1	35.2309	-119.5979	195	1	1
1571796622:677015	677015	2971	October 23, 2019 - 01:12:27 UTC	October 23, 2019 - 05:45:00 UTC		2	35.22419	-119.59838	195	6	4
1571797221:677010	677010	2972	October 23, 2019 - 00:47:36 UTC	October 23, 2019 - 05:47:00 UTC		1	35.2309	-119.5979	195	1	1
1571797221:677015	677015	2972	October 23, 2019 - 01:12:27 UTC	October 23, 2019 - 05:45:00 UTC		2	35.22419	-119.59838	195	6	4
1571797822:677010	677010	2973	October 23, 2019 - 00:47:36 UTC	October 23, 2019 - 05:47:00 UTC		1	35.2309	-119.5979	195	1	1
1571797822:677015	677015	2973	October 23, 2019 - 01:12:27 UTC	October 23, 2019 - 05:45:00 UTC		2	35.22419	-119.59838	195	6	4
1571798423:677010	677010	2974	October 23, 2019 - 00:47:36 UTC	October 23, 2019 - 05:47:00 UTC		1	35.2309	-119.5979	195	1	1
1571798423:677015	677015	2974	October 23, 2019 - 01:12:27 UTC	October 23, 2019 - 05:45:00 UTC		2	35.22419	-119.59838	195	6	4
1571799021:677010	677010	2975	October 23, 2019 - 00:47:36 UTC	October 23, 2019 - 05:47:00 UTC		1	35.2309	-119.5979	195	1	1
1571799021:677015	677015	2975	October 23, 2019 - 01:12:27 UTC	October 23, 2019 - 05:45:00 UTC		2	35.22419	-119.59838	195	6	4
1571799629:677010	677010	2976	October 23, 2019 - 00:47:36 UTC	October 23, 2019 - 05:47:00 UTC		1	35.2309	-119.5979	195	1	1
1571799629:677015	677015	2976	October 23, 2019 - 01:12:27 UTC	October 23, 2019 - 05:45:00 UTC		2	35.22419	-119.59838	195	6	4
1571800222:677010	677010	2977	October 23, 2019 - 00:47:36 UTC	October 23, 2019 - 05:47:00 UTC		1	35.2309	-119.5979	195	1	1
1571800222:677015	677015	2977	October 23, 2019 - 01:12:27 UTC	October 23, 2019 - 05:45:00 UTC		2	35.22419	-119.59838	195	6	4
1571800832:677010	677010	2978	October 23, 2019 - 00:47:36 UTC	October 23, 2019 - 05:47:00 UTC		1	35.2309	-119.5979	195	1	1
1571800832:677015	677015	2978	October 23, 2019 - 01:12:27 UTC	October 23, 2019 - 05:45:00 UTC		2	35.22419	-119.59838	195	6	4
1571801426:677010	677010	2979	October 23, 2019 - 00:47:36 UTC	October 23, 2019 - 05:47:00 UTC		1	35.2309	-119.5979	195	1	1
1571801426:677015	677015	2979	October 23, 2019 - 01:12:27 UTC	October 23, 2019 - 05:45:00 UTC		2	35.22419	-119.59838	195	6	4
1571802030:677010	677010	2980	October 23, 2019 - 00:47:36 UTC	October 23, 2019 - 05:47:00 UTC		1	35.2309	-119.5979	195	1	1
1571802030:677015	677015	2980	October 23, 2019 - 01:12:27 UTC	October 23, 2019 - 05:45:00 UTC		2	35.22419	-119.59838	195	6	4
1571802616:677010	677010	2981	October 23, 2019 - 00:47:36 UTC	October 23, 2019 - 05:47:00 UTC		1	35.2309	-119.5979	195	1	1
1571802616:677015	677015	2981	October 23, 2019 - 01:12:27 UTC	October 23, 2019 - 05:45:00 UTC		2	35.22419	-119.59838	195	6	4
1571803230:677010	677010	2982	October 23, 2019 - 00:47:36 UTC	October 23, 2019 - 05:47:00 UTC		1	35.2309	-119.5979	195	1	1
1571803230:677015	677015	2982	October 23, 2019 - 01:12:27 UTC	October 23, 2019 - 05:45:00 UTC		2	35.22419	-119.59838	195	6	4
1571803830:677010	677010	2983	October 23, 2019 - 00:47:36 UTC	October 23, 2019 - 05:47:00 UTC		1	35.2309	-119.5979	195	1	1
1571803830:677015	677015	2983	October 23, 2019 - 01:12:27 UTC	October 23, 2019 - 05:45:00 UTC		2	35.22419	-119.59838	195	6	4
1571804422:677010	677010	2984	October 23, 2019 - 00:47:36 UTC	October 23, 2019 - 05:47:00 UTC		1	35.2309	-119.5979	195	1	1
1571804422:677015	677015	2984	October 23, 2019 - 01:12:27 UTC	October 23, 2019 - 05:45:00 UTC		2	35.22419	-119.59838	195	6	4
1571805017:677010	677010	2985	October 23, 2019 - 00:47:36 UTC	October 23, 2019 - 05:47:00 UTC		1	35.2309	-119.5979	195	1	1
1571805017:677015	677015	2985	October 23, 2019 - 01:12:27 UTC	October 23, 2019 - 05:45:00 UTC		2	35.22419	-119.59838	195	6	4
1571805613:677010	677010	2986	October 23, 2019 - 00:47:36 UTC	October 23, 2019 - 05:47:00 UTC		1	35.2309	-119.5979	195	1	1
1571805613:677015	677015	2986	October 23, 2019 - 01:12:27 UTC	October 23, 2019 - 05:45:00 UTC		2	35.22419	-119.59838	195	6	4
1571806213:677010	677010	2987	October 23, 2019 - 00:47:36 UTC	October 23, 2019 - 05:47:00 UTC		1	35.2309	-119.5979	195	1	1
1571806213:677015	677015	2987	October 23, 2019 - 01:12:27 UTC	October 23, 2019 - 05:45:00 UTC		2	35.22419	-119.59838	195	6	4
1571806848:677010	677010	2988	October 23, 2019 - 00:47:36 UTC	October 23, 2019 - 05:47:00 UTC		1	35.2309	-119.5979	195	1	1
1571806848:677015	677015	2988	October 23, 2019 - 01:12:27 UTC	October 23, 2019 - 05:45:00 UTC		2	35.22419	-119.59838	195	6	4
1571808019:677015	677015	2989	October 23, 2019 - 05:04:23 UTC	October 23, 2019 - 05:45:00 UTC		2	35.22419	-119.59838	195	2	4

pge-outages

Custom SQL query returning 101 rows (hide)

Query parameters