Cambridgeshire Renewable Energy Completions And Commitments 2017
Cambridgeshire Insight
@ukgov.cambridgeshire_renewable_energy_completions_and_commit_22d65569
Cambridgeshire Insight
@ukgov.cambridgeshire_renewable_energy_completions_and_commit_22d65569
Number of installed capacity of renewable energy (Megawatts) in each financial year from 1999/00 to 2016/17. Worksheet includes data by district and type of renewable energy. This data supercedes data published in previous years.
Publisher name: Cambridgeshire Insight
Last updated: 2025-04-03T04:00:14Z
CREATE TABLE cambridgeshire_installed_renewable_energy_capacity_mw_1999_2017 (
"district" VARCHAR,
"renewable_energy_type" VARCHAR,
"pre_1999" DOUBLE,
"n_1999_2000" DOUBLE -- 1999-2000,
"n_2000_2001" DOUBLE -- 2000-2001,
"n_2001_2002" DOUBLE -- 2001-2002,
"n_2002_2003" DOUBLE -- 2002-2003,
"n_2003_2004" DOUBLE -- 2003-2004,
"n_2004_2005" DOUBLE -- 2004-2005,
"n_2005_06" DOUBLE -- 2005-06,
"n_2006_07" DOUBLE -- 2006-07,
"n_2007_08" DOUBLE -- 2007-08,
"n_2008_09" DOUBLE -- 2008-09,
"n_2009_10" DOUBLE -- 2009-10,
"n_2010_11" DOUBLE -- 2010-11,
"n_2011_12" DOUBLE -- 2011-12,
"n_2012_2013" DOUBLE -- 2012-2013,
"n_2013_2014" DOUBLE -- 2013-2014,
"n_2014_2015" DOUBLE -- 2014-2015,
"n_2015_2016" DOUBLE -- 2015-2016,
"n_2016_2017" DOUBLE -- 2016-2017,
"total" DOUBLE
);CREATE TABLE cambridgeshire_renewable_energy_commitments_mw_2017 (
"renewable_energy_type" VARCHAR,
"cambridge_city" DOUBLE,
"east_cambridgeshire" DOUBLE,
"fenland" DOUBLE,
"huntingdonshire" DOUBLE,
"south_cambridgeshire" DOUBLE
);Anyone who has the link will be able to view this.