Energy
Plymouth City Council
@ukgov.energy
Plymouth City Council
@ukgov.energy
CREATE TABLE carbon_emissions_plymouth_2005_2014 (
"year" BIGINT,
"industry_and_commercial_electricity_kt_co2" DOUBLE,
"industry_and_commercial_gas_kt_co2" DOUBLE,
"large_industrial_installations_kt_co2" DOUBLE,
"industrial_and_commercial_other_fuels_kt_co2" DOUBLE,
"agriculture_kt_co2" DOUBLE,
"industry_and_commercial_total_kt_co2" DOUBLE,
"domestic_electricity_kt_co2" DOUBLE,
"g_domestic_gas_kt_co2" DOUBLE,
"domestic_other_fuels_kt_co2" DOUBLE,
"domestic_total_kt_co2" DOUBLE,
"road_transport_a_roads_kt_co2" DOUBLE,
"road_transport_minor_roads_kt_co2" DOUBLE,
"diesel_railways_kt_co2" DOUBLE,
"transport_other_kt_co2" DOUBLE,
"transport_total_kt_co2" DOUBLE,
"n_lulucf_net_emissions_kt_co2" DOUBLE,
"grand_total_kt_co2" DOUBLE,
"population_000s_mid_year_estimate" DOUBLE,
"per_capita_emissions_t" DOUBLE
);
CREATE TABLE domestic_energy_consumption (
"domestic_energy_consumption_in_plymouth_2011_updated_2013" VARCHAR,
"method_of_counting" VARCHAR,
"type_of_measurement" VARCHAR,
"plymouth_unitary_authority" BIGINT,
"south_west_region" BIGINT,
"england" BIGINT
);
CREATE TABLE fuel_poverty_of_housholds_plymouth_2010_2014 (
"area_identifier" VARCHAR,
"area_label" VARCHAR,
"fuel_poverty_in_plymouth_in_2010_percentage_of_housholds" DOUBLE,
"fuel_poverty_in_plymouth_in_2011_percentage_of_housholds" DOUBLE,
"fuel_poverty_in_plymouth_in_2012_percentage_of_housholds" DOUBLE,
"fuel_poverty_in_plymouth_in_2013_percentage_of_housholds" DOUBLE,
"fuel_poverty_in_plymouth_in_2014_percentage_of_housholds" DOUBLE
);
Anyone who has the link will be able to view this.