Supply Of Electricity - Monthly Data

Eurostat code: nrg_105m · (2008-01 - 2019-12)

@eurostat.nrg_105m

Table List

2 tables(918.49 KB)

Supply Of Electricity - Monthly Data - Raw

Supply Of Electricity - Monthly Data - Unpivoted

Supply Of Electricity - Monthly Data - Raw

@eurostat.nrg_105m.raw

This table contains the original data as downloaded from the Eurostat API, with labels mapped where available.

560.24 KB
1471 rows
149 columns
Only the first 100 columns are shown

freq Freq	unit Unit	product Product	indic_nrg Indic Nrg	geo Geo	n_2008_01 2008-01	n_2008_02 2008-02	n_2008_03 2008-03	n_2008_04 2008-04	n_2008_05 2008-05	n_2008_06 2008-06	n_2008_07 2008-07	n_2008_08 2008-08	n_2008_09 2008-09	n_2008_10 2008-10	n_2008_11 2008-11	n_2008_12 2008-12	n_2009_01 2009-01	n_2009_02 2009-02	n_2009_03 2009-03	n_2009_04 2009-04	n_2009_05 2009-05	n_2009_06 2009-06	n_2009_07 2009-07	n_2009_08 2009-08	n_2009_09 2009-09	n_2009_10 2009-10	n_2009_11 2009-11	n_2009_12 2009-12	n_2010_01 2010-01	n_2010_02 2010-02	n_2010_03 2010-03	n_2010_04 2010-04	n_2010_05 2010-05	n_2010_06 2010-06	n_2010_07 2010-07	n_2010_08 2010-08	n_2010_09 2010-09	n_2010_10 2010-10	n_2010_11 2010-11	n_2010_12 2010-12	n_2011_01 2011-01	n_2011_02 2011-02	n_2011_03 2011-03	n_2011_04 2011-04	n_2011_05 2011-05	n_2011_06 2011-06	n_2011_07 2011-07	n_2011_08 2011-08	n_2011_09 2011-09	n_2011_10 2011-10	n_2011_11 2011-11	n_2011_12 2011-12	n_2012_01 2012-01	n_2012_02 2012-02	n_2012_03 2012-03	n_2012_04 2012-04	n_2012_05 2012-05	n_2012_06 2012-06	n_2012_07 2012-07	n_2012_08 2012-08	n_2012_09 2012-09	n_2012_10 2012-10	n_2012_11 2012-11	n_2012_12 2012-12	n_2013_01 2013-01	n_2013_02 2013-02	n_2013_03 2013-03	n_2013_04 2013-04	n_2013_05 2013-05	n_2013_06 2013-06	n_2013_07 2013-07	n_2013_08 2013-08	n_2013_09 2013-09	n_2013_10 2013-10	n_2013_11 2013-11	n_2013_12 2013-12	n_2014_01 2014-01	n_2014_02 2014-02	n_2014_03 2014-03	n_2014_04 2014-04	n_2014_05 2014-05	n_2014_06 2014-06	n_2014_07 2014-07	n_2014_08 2014-08	n_2014_09 2014-09	n_2014_10 2014-10	n_2014_11 2014-11	n_2014_12 2014-12	n_2015_01 2015-01	n_2015_02 2015-02	n_2015_03 2015-03	n_2015_04 2015-04	n_2015_05 2015-05	n_2015_06 2015-06	n_2015_07 2015-07	n_2015_08 2015-08	n_2015_09 2015-09	n_2015_10 2015-10	n_2015_11 2015-11
Monthly	Gigawatt-hour	Electrical energy	Gross electricity generation - total	Austria	5529	5098	5561	5320	5677	5822	6230	5993	5366	5411	5131	5593	5346	4933	5736	5959	6463	5933	6139	5606	5619	6175	5178	5764	6036	5434	5724	4630	5914	6461	6101	6124	6042	5913	5876	6572	6293	5412	5604	4919	5367	5663	5468	5272	5131	5738	5457	5159	6194	6140	6023	5431	5898	6240	6130	5603	5775	6151	6289	6114	6488	5661	5674	5759	6571	5725	5527	4719	5174	5247	5891	5242	4882	4275	4748	5005	6301	5409	5622	6039	6040	5287	5799	5492	5996	4945	5268	5584	6288	5900	5288	4999	5040	5767	5126
Monthly	Gigawatt-hour	Electrical energy	Gross electricity generation - total	Belgium	7711	7126	6718	6334	6487	6707	7052	6810	6745	7504	7185	7765	8043	7169	7544	6815	7164	7093	7509	7841	7911	7892	7466	8336	8562	7948	8321	7543	7837	7246	7435	7702	7351	7655	7772	7761	7714	7092	7365	7069	7482	6994	7192	7538	7383	7401	7364	7576	7968	8162	6389	6445	6689	6241	6538	6037	6080	5230	5710	6499	6774	6370	6772	5573	5495	6390	6948	6535	6270	7308	7570	8093	7531	7103	6835	5318	5571	5422	5717	5215	4839	5454	5344	5847	6810	6140	5873	5045	5248	5010	4922	4673	5001	5704	6319
Monthly	Gigawatt-hour	Electrical energy	Gross electricity generation - total	Bulgaria	4435	3678	3780	3559	3381	3268	3508	3483	3336	3608	4122	4265	4519	3892	3891	2973	2893	3082	3449	3221	3211	3523	3993	4042	4301	4036	3981	3189	2999	3576	3976	3992	3494	3889	3918	4649	4790	4506	4401	3850	3661	3727	4237	4029	3810	4013	4516	4787	4643	4645	4355	3560	3472	3508	4033	3772	3606	3402	3851	4559	4565	3856	3729	3087	2611	2757	3280	3875	3599	3857	4138	4686	4690	3950	3699	3583	3422	3486	3902	3688	3479	4004	4397	4893	4961	4268	4417	3857	3299	3768	4233	4106	3564	3588	3879
Monthly	Gigawatt-hour	Electrical energy	Gross electricity generation - total	Cyprus	461	415	340	323	358	443	549	539	456	372	334	401	432	382	390	321	368	470	571	546	454	412	362	424	438	393	380	342	384	448	549	617	501	402	362	391	446	407	395	347	378	436	463	434	407	357	350	391	422	378	343	303	343	417	523	497	418	354	301	330	353	296	300	278	331	368	452	463	376	318	288	348	337	291	302	287	328	376	476	482	409	346	309	339	376	337	323	294	325	354	465	508	453	361	307
Monthly	Gigawatt-hour	Electrical energy	Gross electricity generation - total	Czechia	8497	7767	7829	7390	6406	6176	6351	6150	6129	6678	6796	7354	7935	7414	7825	6548	5871	6058	6235	5929	6109	7284	7191	7841	8481	7578	8056	7065	6206	6098	6881	6162	6736	7543	7235	7846	8369	7570	7873	6930	7062	6481	6175	6641	6573	7764	7967	8118	8519	7825	8148	7642	6948	6651	6876	6336	6443	7178	7345	7636	8203	7345	8119	7084	6931	6390	6673	6617	6282	7736	7963	7658	8213	7318	8134	7350	6799	6343	5876	6126	7223	8030	7389	7400	8277	7819	8134	7314	6415	6269	6191	6230	5926	6913	6970
Monthly	Gigawatt-hour	Electrical energy	Gross electricity generation - total	Germany	52597	50957	50607	50457	45959	43449	44251	43939	46286	50136	48871	49869	52248	46269	46477	40951	39071	40564	41361	40833	42592	46213	46702	49959	48775	43547	44394	39984	39295	35987	38838	36875	38524	42027	44078	49007	51523	47779	48908	41301	39539	37621	40063	40255	40679	44744	46459	47942	49502	50942	48312	42936	41174	40962	40903	42214	42202	46589	47431	47185	51449	47250	51690	44846	40145	40774	41788	40861	43840	47661	47340	48297	49886	45643	46777	42140	40085	39170	40259	38617	42174	46570	45949	48606	51647	47829	51288	45348	41365	42223	44611	43102	45968	47789	49813
Monthly	Gigawatt-hour	Electrical energy	Gross electricity generation - total	Denmark	4027	3494	3225	2601	2337	2499	1989	2039	2573	3537	4118	3973	4121	3723	3737	2560	2303	2385	2159	2157	2553	3265	3457	3785	4245	3964	4001	3189	2696	1999	1993	2104	2801	3484	3725	4364	4252	4130	4011	2904	2614	2123	1786	1960	2017	2676	3009	3428	3667	3628	2795	2334	2004	1812	1410	1462	2138	2708	2756	3666	3754	3331	3831	3051	2316	2191	1948	2063	2205	3038	3171	3674	4259	3225	2828	2460	2136	1356	1736	2318	2069	1834	2995	3459	3599	3050	1879	2417	2248	1866	1628	1462	1649	2021	2655
Monthly	Gigawatt-hour	Electrical energy	Gross electricity generation - total	Euro area (EA11-1999, EA12-2001, EA13-2007, EA15-2008, EA16-2009, EA17-2011, EA18-2014, EA19-2015, EA20-2023)	212276	198528	197445	187055	177805	175920	183886	175958	181217	190227	193189	203960	212439	187857	188375	166717	166606	165414	174664	167269	170188	181378	183703	203205	211129	189137	195649	168221	168439	164873	176777	166473	168905	179352	190686	213353	214907	193744	200302	169187	170623	166809	174890	169262	171402	178623	186841	198748	207663	206820	190652	171613	167088	166960	173153	170036	167630	179084	187608	198465	209987	192165	202090	176707	169425	164714	175490	159580	169063	179039	188094	199281	203292	183979	185469	166486	167110	163666	172980	163167	167616	175630	181408	197507	208468	190943	195317	171094	168595	168261	184176	169931	172904	182954	187105
Monthly	Gigawatt-hour	Electrical energy	Gross electricity generation - total	Estonia	1125	996	765	749	675	599	658	970	1042	1011	956	981	1036	948	900	602	577	724	554	594	671	673	649	808	1233	1132	1183	854	948	945	959	907	943	1109	1160	1375	1347	1127	1255	895	972	1012	946	1019	934	963	1191	1194	1081	1094	934	882	905	872	783	1059	976	1073	1102	1249	1334	1208	1248	1049	1056	976	979	1104	1104	1197	1109	958	1078	990	986	914	1009	1056	1039	967	986	1106	1083	1159	1127	1074	846	782	873	614	653	775	900	886	891
Monthly	Gigawatt-hour	Electrical energy	Gross electricity generation - total	Greece	5119	4477	3809	4128	4504	4994	5876	5418	4714	4428	4341	4813	4898	4385	4371	3998	4275	4571	5408	5108	4513	4559	4400	4784	4920	4144	4203	3654	4034	4284	5363	5540	4299	4375	4154	4800	4874	4300	4700	4003	4391	4383	5691	5143	4783	4389	4598	4795	5209	4708	4601	3940	4258	4794	5795	5362	4414	4480	4288	5039	4977	4290	4465	4002	4092	4689	5094	5245	4368	4260	3969	4896	4500	3975	3849	3682	3674	3953	4593	4422	3781	3801	3618	4060	4232	3886	3826	3383	3356	3514	5094	4709	3952	3670	3702


CREATE TABLE raw (
  "freq" VARCHAR,
  "unit" VARCHAR,
  "product" VARCHAR,
  "indic_nrg" VARCHAR,
  "geo" VARCHAR,
  "n_2008_01" DOUBLE,
  "n_2008_02" DOUBLE,
  "n_2008_03" DOUBLE,
  "n_2008_04" DOUBLE,
  "n_2008_05" DOUBLE,
  "n_2008_06" DOUBLE,
  "n_2008_07" DOUBLE,
  "n_2008_08" DOUBLE,
  "n_2008_09" DOUBLE,
  "n_2008_10" DOUBLE,
  "n_2008_11" DOUBLE,
  "n_2008_12" DOUBLE,
  "n_2009_01" DOUBLE,
  "n_2009_02" DOUBLE,
  "n_2009_03" DOUBLE,
  "n_2009_04" DOUBLE,
  "n_2009_05" DOUBLE,
  "n_2009_06" DOUBLE,
  "n_2009_07" DOUBLE,
  "n_2009_08" DOUBLE,
  "n_2009_09" DOUBLE,
  "n_2009_10" DOUBLE,
  "n_2009_11" DOUBLE,
  "n_2009_12" DOUBLE,
  "n_2010_01" DOUBLE,
  "n_2010_02" DOUBLE,
  "n_2010_03" DOUBLE,
  "n_2010_04" DOUBLE,
  "n_2010_05" DOUBLE,
  "n_2010_06" DOUBLE,
  "n_2010_07" DOUBLE,
  "n_2010_08" DOUBLE,
  "n_2010_09" DOUBLE,
  "n_2010_10" DOUBLE,
  "n_2010_11" DOUBLE,
  "n_2010_12" DOUBLE,
  "n_2011_01" DOUBLE,
  "n_2011_02" DOUBLE,
  "n_2011_03" DOUBLE,
  "n_2011_04" DOUBLE,
  "n_2011_05" DOUBLE,
  "n_2011_06" DOUBLE,
  "n_2011_07" DOUBLE,
  "n_2011_08" DOUBLE,
  "n_2011_09" DOUBLE,
  "n_2011_10" DOUBLE,
  "n_2011_11" DOUBLE,
  "n_2011_12" DOUBLE,
  "n_2012_01" DOUBLE,
  "n_2012_02" DOUBLE,
  "n_2012_03" DOUBLE,
  "n_2012_04" DOUBLE,
  "n_2012_05" DOUBLE,
  "n_2012_06" DOUBLE,
  "n_2012_07" DOUBLE,
  "n_2012_08" DOUBLE,
  "n_2012_09" DOUBLE,
  "n_2012_10" DOUBLE,
  "n_2012_11" DOUBLE,
  "n_2012_12" DOUBLE,
  "n_2013_01" DOUBLE,
  "n_2013_02" DOUBLE,
  "n_2013_03" DOUBLE,
  "n_2013_04" DOUBLE,
  "n_2013_05" DOUBLE,
  "n_2013_06" DOUBLE,
  "n_2013_07" DOUBLE,
  "n_2013_08" DOUBLE,
  "n_2013_09" DOUBLE,
  "n_2013_10" DOUBLE,
  "n_2013_11" DOUBLE,
  "n_2013_12" DOUBLE,
  "n_2014_01" DOUBLE,
  "n_2014_02" DOUBLE,
  "n_2014_03" DOUBLE,
  "n_2014_04" DOUBLE,
  "n_2014_05" DOUBLE,
  "n_2014_06" DOUBLE,
  "n_2014_07" DOUBLE,
  "n_2014_08" DOUBLE,
  "n_2014_09" DOUBLE,
  "n_2014_10" DOUBLE,
  "n_2014_11" DOUBLE,
  "n_2014_12" DOUBLE,
  "n_2015_01" DOUBLE,
  "n_2015_02" DOUBLE,
  "n_2015_03" DOUBLE,
  "n_2015_04" DOUBLE,
  "n_2015_05" DOUBLE,
  "n_2015_06" DOUBLE,
  "n_2015_07" DOUBLE,
  "n_2015_08" DOUBLE,
  "n_2015_09" DOUBLE,
  "n_2015_10" DOUBLE,
  "n_2015_11" DOUBLE
);