pge-outages

This data as json, CSV

id	outage	snapshot	lastUpdateTime	currentEtor	autoEtor	estCustAffected	hazardFlag	latitude	longitude	regionName	cause	crewCurrentStatus
1575591039:730087	730087	9059	December 05, 2019 - 23:24:02 UTC	December 06, 2019 - 04:30:00 UTC		1	1	39.3062	-120.382	653	2	2
1575591039:730135	730135	9059	December 05, 2019 - 20:56:45 UTC	December 06, 2019 - 06:34:00 UTC		5	0	36.86715	-121.62129	486	2	2
1575591039:730192	730192	9059	December 05, 2019 - 18:50:01 UTC	December 06, 2019 - 00:35:00 UTC		10	1	37.01634	-121.7201	223	2	2
1575591039:730204	730204	9059	December 06, 2019 - 00:00:45 UTC	December 06, 2019 - 02:00:00 UTC		129	0	37.84714	-122.27711	16	2	2
1575591039:730226	730226	9059	December 05, 2019 - 14:53:27 UTC	December 06, 2019 - 01:00:00 UTC		8	0	40.44834	-124.26697	112	3	2
1575591039:730250	730250	9059	December 05, 2019 - 15:34:31 UTC	December 05, 2019 - 20:00:00 UTC		3	0	37.01648	-121.79066	49	3	2
1575591039:730267	730267	9059	December 05, 2019 - 23:20:31 UTC	December 06, 2019 - 10:00:00 UTC		55	6	35.38864	-119.00425	2	2	7
1575591039:730275	730275	9059	December 05, 2019 - 20:23:23 UTC	December 06, 2019 - 00:00:00 UTC		8	0	38.38129	-122.9027	99	3	2
1575591039:730280	730280	9059	December 05, 2019 - 23:10:24 UTC	December 06, 2019 - 00:00:00 UTC		1	0	39.72528	-123.80779	543	3	2
1575591039:730282	730282	9059	December 05, 2019 - 16:15:56 UTC	December 06, 2019 - 01:00:00 UTC		28	0	40.46928	-123.70108	620	3	1
1575591039:730295	730295	9059	December 05, 2019 - 23:07:15 UTC	December 06, 2019 - 05:00:00 UTC		1	0	37.39456	-122.1163	151	2	2
1575591039:730296	730296	9059	December 05, 2019 - 23:20:58 UTC	December 06, 2019 - 01:00:00 UTC		195	0	37.7431	-122.46167	25	3	2
1575591039:730298	730298	9059	December 05, 2019 - 23:52:03 UTC	December 06, 2019 - 04:00:00 UTC		1	0	40.10501	-122.18712	20	2	2
1575591039:730299	730299	9059	December 05, 2019 - 16:25:58 UTC	December 06, 2019 - 01:00:00 UTC		1	0	39.74199	-121.67622	479	3	2
1575591039:730310	730310	9059	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	25	1	1
1575591039:730325	730325	9059	December 05, 2019 - 22:47:26 UTC	December 06, 2019 - 00:00:00 UTC		1	0	35.41004	-119.01855	246	2	1
1575591039:730332	730332	9059	December 05, 2019 - 23:36:36 UTC	December 06, 2019 - 00:00:00 UTC		317	0	38.84946	-121.15955	352	3	2
1575591039:730349	730349	9059	December 05, 2019 - 23:32:12 UTC	December 06, 2019 - 02:30:00 UTC		6	0	35.50166	-120.67342	40	3	2
1575591039:730356	730356	9059	December 05, 2019 - 17:14:07 UTC	December 06, 2019 - 01:30:00 UTC		102	0	37.95955	-122.10526	37	3	2
1575591039:730366	730366	9059	December 05, 2019 - 17:07:44 UTC	December 06, 2019 - 01:00:00 UTC		42	0	37.72951	-122.3732	25	3	1
1575591039:730374	730374	9059	December 05, 2019 - 17:18:50 UTC	December 06, 2019 - 01:00:00 UTC		3	0	38.54953	-122.47208	275	3	2
1575591039:730394	730394	9059	December 05, 2019 - 17:18:48 UTC	December 05, 2019 - 23:30:00 UTC		10	0	38.93443	-120.75144	161	3	2
1575591039:730409	730409	9059	December 05, 2019 - 18:02:56 UTC	December 06, 2019 - 01:00:00 UTC		80	0	40.66832	-124.19738	440	3	2
1575591039:730432	730432	9059	December 06, 2019 - 00:04:53 UTC	December 06, 2019 - 01:00:00 UTC		48	0	37.01404	-121.59986	223	3	2
1575591039:730433	730433	9059	December 05, 2019 - 23:27:43 UTC	December 06, 2019 - 02:46:00 UTC		5	0	37.11157	-122.04778	474	4	2
1575591039:730434	730434	9059	December 05, 2019 - 22:57:32 UTC	December 06, 2019 - 00:30:00 UTC		1	0	37.76553	-122.20758	16	2	2
1575591039:730438	730438	9059	December 05, 2019 - 23:53:11 UTC	December 06, 2019 - 01:00:00 UTC		1	0	35.75485	-119.65518	126	1	6
1575591039:730440	730440	9059	December 05, 2019 - 23:10:28 UTC	December 06, 2019 - 06:30:00 UTC		1	0	37.26046	-121.99748	152	2	3
1575591039:730479	730479	9059	December 05, 2019 - 18:47:52 UTC	December 05, 2019 - 23:00:00 UTC		81	0	39.46722	-120.84607	633	3	2
1575591039:730486	730486	9059	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	38	1	1
1575591039:730490	730490	9059	December 05, 2019 - 18:18:41 UTC	December 05, 2019 - 23:00:00 UTC		1	0	40.23435	-123.80354	257	3	1
1575591039:730507	730507	9059	December 05, 2019 - 23:31:38 UTC	December 06, 2019 - 01:31:00 UTC		1	0	35.09398	-120.36633	368	1	5
1575591039:730513	730513	9059	December 05, 2019 - 18:35:18 UTC	December 06, 2019 - 00:00:00 UTC		7	0	37.93276	-122.53387	382	3	1
1575591039:730516	730516	9059	December 05, 2019 - 18:39:11 UTC	December 05, 2019 - 22:00:00 UTC		3	0	39.22051	-121.28465	429	3	2
1575591039:730526	730526	9059	December 05, 2019 - 18:45:42 UTC	December 05, 2019 - 22:00:00 UTC	December 05, 2019 - 22:00:00 UTC	1	0	37.67209	-122.06441	562	1	1
1575591039:730529	730529	9059	December 05, 2019 - 22:41:01 UTC	December 06, 2019 - 05:00:00 UTC		6	0	36.7621	-121.754	227	2	2
1575591039:730547	730547	9059	December 05, 2019 - 20:13:38 UTC			1	0	36.53228	-121.48877	406	1	6
1575591039:730550	730550	9059	December 05, 2019 - 23:09:30 UTC	December 06, 2019 - 01:00:00 UTC		1	0	39.34901	-121.1207	69	2	2
1575591039:730568	730568	9059	December 05, 2019 - 23:37:14 UTC	December 06, 2019 - 00:00:00 UTC		1	0	36.93278	-120.40071	8	3	3
1575591039:730572	730572	9059	December 05, 2019 - 21:03:16 UTC	December 05, 2019 - 23:00:00 UTC	December 05, 2019 - 23:00:00 UTC	1	1	40.86681	-124.04719	230	6	3
1575591039:730577	730577	9059	December 05, 2019 - 23:21:00 UTC	December 05, 2019 - 18:00:00 UTC		41	0	37.12285	-121.6593	319	3	3
1575591039:730587	730587	9059	December 05, 2019 - 19:47:35 UTC	December 06, 2019 - 00:00:00 UTC		3	0	39.24336	-121.29383	293	3	2
1575591039:730595	730595	9059	December 06, 2019 - 00:04:52 UTC	December 06, 2019 - 02:00:00 UTC		1	0	37.54022	-122.06446	225	6	1
1575591039:730603	730603	9059	December 05, 2019 - 23:45:10 UTC	December 06, 2019 - 02:00:00 UTC		1	0	37.65133	-122.4348	156	6	4
1575591039:730606	730606	9059	December 05, 2019 - 23:10:12 UTC	December 06, 2019 - 04:00:00 UTC		1	0	37.08065	-121.57816	305	2	7
1575591039:730619	730619	9059	December 06, 2019 - 00:00:45 UTC	December 06, 2019 - 02:00:00 UTC		1	1	36.7697	-119.8307	35	1	1
1575591039:730623	730623	9059	December 06, 2019 - 00:05:06 UTC	December 06, 2019 - 02:00:00 UTC		1	0	37.55185	-122.05814	140	6	1
1575591039:730624	730624	9059	December 05, 2019 - 22:12:34 UTC	December 06, 2019 - 00:15:00 UTC	December 06, 2019 - 00:15:00 UTC	1	0	37.95769	-122.61044	226	6	3
1575591039:730631	730631	9059	December 05, 2019 - 23:30:18 UTC	December 06, 2019 - 18:00:00 UTC		1	0	37.80383	-122.27033	16	2	3
1575591039:730644	730644	9059	December 05, 2019 - 23:50:56 UTC			1	1	36.86012	-121.75165	49	6	4
1575591039:730646	730646	9059	December 06, 2019 - 00:03:15 UTC	December 06, 2019 - 01:00:00 UTC		1	0	37.54608	-122.06248	140	6	4
1575591039:730647	730647	9059	December 05, 2019 - 22:50:24 UTC	December 06, 2019 - 01:00:00 UTC		4	1	38.11664	-122.92621	402	2	2
1575591039:730651	730651	9059	December 05, 2019 - 23:39:24 UTC	December 06, 2019 - 01:30:00 UTC		3	0	39.25708	-121.01235	69	3	2
1575591039:730660	730660	9059	December 05, 2019 - 22:05:19 UTC	December 06, 2019 - 00:30:00 UTC		1	0	37.36157	-120.72486	308	1	1
1575591039:730681	730681	9059	December 05, 2019 - 23:44:43 UTC	December 06, 2019 - 02:00:00 UTC		1	0	37.23414	-121.9231	121	6	4
1575591039:730686	730686	9059	December 06, 2019 - 00:05:39 UTC	December 06, 2019 - 06:00:00 UTC		13	0	37.97091	-122.02877	46	2	2
1575591039:730689	730689	9059	December 05, 2019 - 21:27:56 UTC	December 06, 2019 - 00:45:00 UTC	December 06, 2019 - 00:45:00 UTC	1	0	38.7578	-120.59344	278	1	1
1575591039:730699	730699	9059	December 05, 2019 - 22:07:26 UTC	December 06, 2019 - 01:45:00 UTC	December 06, 2019 - 01:45:00 UTC	1	1	37.99779	-123.0137	402	1	5
1575591039:730701	730701	9059	December 06, 2019 - 00:00:10 UTC	December 06, 2019 - 01:45:00 UTC	December 06, 2019 - 01:45:00 UTC	2	0	35.0058	-118.94967	2	2	7
1575591039:730703	730703	9059	December 05, 2019 - 22:14:07 UTC	December 06, 2019 - 03:00:00 UTC	December 06, 2019 - 03:00:00 UTC	1	0	38.02378	-121.5328	78	1	1
1575591039:730707	730707	9059	December 05, 2019 - 23:51:12 UTC	December 06, 2019 - 01:30:00 UTC		1	1	38.00569	-121.3301	91	6	4
1575591039:730716	730716	9059	December 05, 2019 - 23:50:28 UTC			16	0	39.00805	-123.36628	771	6	4
1575591039:730717	730717	9059	December 05, 2019 - 23:01:23 UTC	December 06, 2019 - 01:00:00 UTC	December 06, 2019 - 01:00:00 UTC	1	1	38.83668	-121.05012	573	1	5
1575591039:730722	730722	9059	December 05, 2019 - 22:02:21 UTC	December 06, 2019 - 00:45:00 UTC	December 06, 2019 - 00:45:00 UTC	1	0	37.54277	-122.0623	225	1	1
1575591039:730724	730724	9059	December 05, 2019 - 21:58:55 UTC	December 05, 2019 - 23:30:00 UTC		1	0	40.60956	-122.49411	588	3	2
1575591039:730725	730725	9059	December 06, 2019 - 00:03:22 UTC	December 06, 2019 - 00:45:00 UTC	December 06, 2019 - 00:45:00 UTC	1371	1	37.33594	-120.5054	13	4	3
1575591039:730726	730726	9059	December 06, 2019 - 00:04:03 UTC	December 06, 2019 - 00:45:00 UTC	December 06, 2019 - 00:45:00 UTC	20	0	37.33594	-120.50542	13	2	1
1575591039:730732	730732	9059	December 05, 2019 - 23:59:02 UTC	December 06, 2019 - 04:00:00 UTC		1	0	37.57922	-122.37503	313	2	2
1575591039:730753	730753	9059	December 05, 2019 - 22:41:58 UTC	December 06, 2019 - 01:30:00 UTC	December 06, 2019 - 01:30:00 UTC	1	1	37.28024	-121.95922	43	1	1
1575591039:730754	730754	9059	December 05, 2019 - 22:46:30 UTC	December 06, 2019 - 04:30:00 UTC	December 06, 2019 - 04:30:00 UTC	1	1	37.37894	-119.60949	312	1	5
1575591039:730755	730755	9059	December 05, 2019 - 22:16:08 UTC	December 06, 2019 - 01:15:00 UTC	December 06, 2019 - 01:15:00 UTC	1	0	39.28709	-121.05074	69	1	1
1575591039:730757	730757	9059	December 05, 2019 - 23:57:26 UTC	December 06, 2019 - 00:00:00 UTC	December 06, 2019 - 00:00:00 UTC	1	0	36.78478	-119.85902	35	2	3
1575591039:730761	730761	9059	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	13	1	1
1575591039:730762	730762	9059	December 05, 2019 - 23:03:28 UTC	December 06, 2019 - 01:45:00 UTC	December 06, 2019 - 01:45:00 UTC	1	0	36.60126	-121.90221	163	6	4
1575591039:730765	730765	9059	December 05, 2019 - 22:51:34 UTC	December 06, 2019 - 01:15:00 UTC	December 06, 2019 - 01:15:00 UTC	1	1	37.96296	-121.30274	78	1	1
1575591039:730766	730766	9059	December 05, 2019 - 23:28:01 UTC	December 06, 2019 - 02:00:00 UTC	December 06, 2019 - 02:00:00 UTC	1	0	37.88385	-120.39567	193	1	5
1575591039:730770	730770	9059	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	406	1	1
1575591039:730771	730771	9059	December 05, 2019 - 23:57:02 UTC	December 06, 2019 - 01:15:00 UTC	December 06, 2019 - 01:15:00 UTC	1	0	36.72781	-119.80023	35	1	5
1575591039:730781	730781	9059	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	249	1	5
1575591039:730782	730782	9059	December 06, 2019 - 00:03:12 UTC			111	0	38.97812	-122.87044	282	6	5
1575591039:730784	730784	9059	December 05, 2019 - 23:49:33 UTC	December 06, 2019 - 01:45:00 UTC	December 06, 2019 - 01:45:00 UTC	1	1	37.54141	-121.99799	140	6	4
1575591039:730788	730788	9059	December 05, 2019 - 22:57:01 UTC			1	0	40.76787	-124.18802	612	1	1
1575591039:730792	730792	9059	December 05, 2019 - 23:27:02 UTC	December 06, 2019 - 01:45:00 UTC	December 06, 2019 - 01:45:00 UTC	1	0	37.38621	-122.08299	242	1	5
1575591039:730796	730796	9059	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	587	1	1
1575591039:730801	730801	9059	December 05, 2019 - 23:41:17 UTC	December 06, 2019 - 00:45:00 UTC	December 06, 2019 - 00:45:00 UTC	1	1	37.29765	-121.97512	26	6	4
1575591039:730802	730802	9059	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	183	6	4
1575591039:730803	730803	9059	December 05, 2019 - 23:59:40 UTC	December 06, 2019 - 02:45:00 UTC	December 06, 2019 - 02:45:00 UTC	1	1	37.37982	-122.13633	125	1	1
1575591039:730805	730805	9059	December 05, 2019 - 23:29:16 UTC	December 06, 2019 - 02:15:00 UTC	December 06, 2019 - 02:15:00 UTC	1	0	38.42048	-122.76112	30	1	5
1575591039:730807	730807	9059	December 05, 2019 - 23:30:34 UTC	December 06, 2019 - 01:00:00 UTC	December 06, 2019 - 01:00:00 UTC	1	0	37.53799	-121.99506	140	1	1
1575591039:730808	730808	9059	December 05, 2019 - 23:44:53 UTC	December 06, 2019 - 03:30:00 UTC	December 06, 2019 - 03:30:00 UTC	2	0	38.10071	-122.87328	402	1	1
1575591039:730810	730810	9059	December 05, 2019 - 23:38:06 UTC	December 06, 2019 - 04:00:00 UTC		1	0	37.29092	-119.53027	128	2	2
1575591039:730811	730811	9059	December 05, 2019 - 23:42:24 UTC	December 06, 2019 - 02:15:00 UTC	December 06, 2019 - 02:15:00 UTC	9	1	36.62093	-119.71371	89	6	4
1575591039:730813	730813	9059	December 05, 2019 - 23:34:19 UTC	December 06, 2019 - 02:00:00 UTC	December 06, 2019 - 02:00:00 UTC	1	0	37.80178	-122.41439	25	1	1
1575591039:730814	730814	9059	December 05, 2019 - 23:28:28 UTC	December 06, 2019 - 02:45:00 UTC	December 06, 2019 - 02:45:00 UTC	1	0	38.58534	-121.77344	120	1	1
1575591039:730815	730815	9059	December 06, 2019 - 00:02:03 UTC	December 06, 2019 - 02:15:00 UTC	December 06, 2019 - 02:15:00 UTC	1	1	37.46235	-122.25169	256	6	4
1575591039:730816	730816	9059	December 05, 2019 - 23:34:56 UTC	December 06, 2019 - 02:45:00 UTC	December 06, 2019 - 02:45:00 UTC	1	1	38.02051	-122.14502	37	1	5
1575591039:730817	730817	9059	December 05, 2019 - 23:54:02 UTC	December 06, 2019 - 02:30:00 UTC	December 06, 2019 - 02:30:00 UTC	3	0	37.4388	-122.24005	130	1	1
1575591039:730818	730818	9059	December 05, 2019 - 23:51:33 UTC	December 06, 2019 - 02:30:00 UTC	December 06, 2019 - 02:30:00 UTC	1	1	40.4875	-122.3668	106	1	1
1575591039:730819	730819	9059	December 05, 2019 - 23:42:42 UTC	December 06, 2019 - 01:15:00 UTC	December 06, 2019 - 01:15:00 UTC	1	1	37.31204	-121.95417	26	1	1
1575591039:730820	730820	9059	December 05, 2019 - 23:46:48 UTC	December 06, 2019 - 02:45:00 UTC	December 06, 2019 - 02:45:00 UTC	1	1	37.88958	-122.1233	155	1	1
1575591039:730821	730821	9059	December 05, 2019 - 23:55:35 UTC	December 06, 2019 - 01:30:00 UTC	December 06, 2019 - 01:30:00 UTC	1	0	37.93048	-121.25876	78	1	1

pge-outages

Custom SQL query returning 101 rows (hide)

Query parameters