UntappedPotentialRenewableEnergy

REGIO-B1-PAPERS@ec.europa.eu

@esifunds.dau5_jiss

Table List

1 table(112.46 KB)

Table 1

@esifunds.dau5_jiss.table_1

112.46 KB
1000 rows
16 columns

country Country	nuts2_id Nuts2 Id	level_of_development Level Of Development	nuts3_id Nuts3 Id	name_of_the_region Name Of The Region	code_and_name_of_the_region Code And Name Of The Region	urbn_type Urbn Type	urban_rural_typology Urban Rural Typology	total_untapped_potential Total Untapped Potential	total_technical_potential Total Technical Potential	total_current_production Total Current Production	area_km2 Area Km2	total_untapped_potential_1 Total Untapped Potential 1	total_technical_potential_1 Total Technical Potential 1	total_current_production_1 Total Current Production 1	contribution_to_the_total Contribution To The Total
AT	AT11	Transition regions	AT111	Mittelburgenland	AT111-Mittelburgenland	3	Predominantly rural regions	0.4143408888	0.4292931582	0.08972280756	701	591.0711680456491	726.2969019778769	123.53461417178532	0.000033
AT	AT11	Transition regions	AT112	Nordburgenland	AT112-Nordburgenland	3	Predominantly rural regions	2.92451106	3.3924953280000003	2.546190137	1792	1631.9816183035714	2078.7582960195746	1224.8610826354695	0.000234
AT	AT11	Transition regions	AT113	Südburgenland	AT113-Südburgenland	3	Predominantly rural regions	2.258815686	2.2869156860000004	0.028136	1471	1535.564708361659	1489.299456771171	18.892103849281845	0.000181
AT	AT12	More developed regions	AT121	Mostviertel-Eisenwurzen	AT121-Mostviertel-Eisenwurzen	3	Predominantly rural regions	1.04020692	1.088900967	3.086150668	3356	309.9543861740167	3513.1006869787025	878.4691766560545	0.000083
AT	AT12	More developed regions	AT122	Niederösterreich-Süd	AT122-Niederösterreich-Süd	2	Intermediate regions	0.8199250137	0.8667007255	0.05976453007	3368	243.44566915083132	3560.1402502790847	16.7871279973633	0.000066
AT	AT12	More developed regions	AT123	Sankt Pölten	AT123-Sankt Pölten	3	Predominantly rural regions	0.4719132745	0.5811614895	0.2695115517	1230	383.66932886178864	1514.7457609501932	177.92527211360976	0.000038
AT	AT12	More developed regions	AT124	Waldviertel	AT124-Waldviertel	3	Predominantly rural regions	4.905461462	5.023010459	0.4270208327999999	4615	1062.938561646804	4725.588703092944	90.36352074409494	0.000393
AT	AT12	More developed regions	AT125	Weinviertel	AT125-Weinviertel	3	Predominantly rural regions	1.604241325	1.651814983	0.8641717172	2412	665.1083436981759	2483.5276818442508	347.9613790969593	0.000128
AT	AT12	More developed regions	AT126	Wiener Umland/Nordteil	AT126-Wiener Umland/Nordteil	1	Predominantly urban regions	1.577390055	1.681723882	5.14491685	2723	579.2838982739624	2903.1082807771354	1772.2097670510427	0.000126
AT	AT12	More developed regions	AT127	Wiener Umland/Südteil	AT127-Wiener Umland/Südteil	2	Intermediate regions	1.776579663	2.019266517	1.671332354	1475	1204.4607884745765	1676.4900412883987	996.9235204735038	0.000142


CREATE TABLE table_1 (
  "country" VARCHAR,
  "nuts2_id" VARCHAR,
  "level_of_development" VARCHAR,
  "nuts3_id" VARCHAR,
  "name_of_the_region" VARCHAR,
  "code_and_name_of_the_region" VARCHAR,
  "urbn_type" BIGINT,
  "urban_rural_typology" VARCHAR,
  "total_untapped_potential" DOUBLE,
  "total_technical_potential" DOUBLE,
  "total_current_production" DOUBLE,
  "area_km2" BIGINT,
  "total_untapped_potential_1" DOUBLE,
  "total_technical_potential_1" DOUBLE,
  "total_current_production_1" DOUBLE,
  "contribution_to_the_total" DOUBLE
);