Renewable Energy Completions And Commitments 2014
Cambridgeshire Insight
@ukgov.renewable_energy_completions_and_commitments_20141
Cambridgeshire Insight
@ukgov.renewable_energy_completions_and_commitments_20141
CREATE TABLE cambridge_renewables_completions_and_commitments_2014 (
"case_no" VARCHAR,
"district_name" VARCHAR,
"parish" VARCHAR,
"location_address" VARCHAR,
"proposal" VARCHAR,
"applicant" VARCHAR,
"agent" VARCHAR,
"green_brown_development" VARCHAR,
"decision_date" TIMESTAMP,
"lapse_date_of_development" TIMESTAMP,
"type_of_renewable" VARCHAR,
"date_of_last_monitoring_visit" TIMESTAMP,
"target_lost" BIGINT,
"target_new" BIGINT,
"target_net" BIGINT,
"under_construction" BIGINT,
"unimplement" DOUBLE,
"total" BIGINT,
"comp_2002" DOUBLE,
"comp_2003" DOUBLE,
"comp_2004" DOUBLE,
"comp_2005" DOUBLE,
"comp_2006" DOUBLE,
"comp_2007" DOUBLE,
"comp_2008" DOUBLE,
"comp_2009" DOUBLE,
"comp_2010" DOUBLE,
"comp_2011" DOUBLE,
"comp_2012" DOUBLE,
"comp_2013" DOUBLE,
"comp_2014" DOUBLE,
"completed_total" BIGINT,
"total_capacity_mw" DOUBLE,
"under_construction_mw" DOUBLE,
"unimplement_mw" DOUBLE,
"total_mw" DOUBLE,
"comp_2002_mw" DOUBLE,
"comp_2003_mw" DOUBLE,
"comp_2004_mw" DOUBLE,
"comp_2005_mw" DOUBLE,
"comp_2006_mw" DOUBLE,
"comp_2007_mw" DOUBLE,
"comp_2008_mw" DOUBLE,
"comp_2009_mw" DOUBLE,
"comp_2010_mw" DOUBLE,
"comp_2011_mw" DOUBLE,
"comp_2012_mw" DOUBLE,
"comp_2013_mw" DOUBLE,
"comp_2014_mw" DOUBLE,
"completed_total_mw" DOUBLE
);
Anyone who has the link will be able to view this.