Baselight

City-wide CO2 Emissions

Leicester City Council

@ukgov.city_wide_co2_emissions

Table 1
@ukgov.city_wide_co2_emissions.table_1

City-wide CO2 emissions (csv)

  • 19.12 KB
  • 17 rows
  • 23 columns
year

Year

industry_and_commercial_electricity

Industry And Commercial Electricity

industry_and_commercial_gas

Industry And Commercial Gas

industrial_and_commercial_other_fuels

Industrial And Commercial Other Fuels

agriculture

Agriculture

domestic_electricity

Domestic Electricity

domestic_gas

Domestic Gas

domestic_other_fuels

Domestic Other Fuels

road_transport_a_roads

Road Transport A Roads

road_transport_minor_roads

Road Transport Minor Roads

transport_other

Transport Other

populations_000s_mid_year_estimate

Populations 000s Mid Year Estimate

per_capita_emissions

Per Capita Emissions

grand_total_1990_only

Grand Total 1990 Only

annual_change

Annual Change

total_change

Total Change

column_17

Column 17

column_18

Column 18

column_19

Column 19

industry_and_commercial_total

Industry And Commercial Total

domestic_total

Domestic Total

transport_total

Transport Total

grand_total

Grand Total

2006630.2292.2128.41.7264.2384.46.4212.7225.83.8306.57-2.4-10.51052.5000000000002654.9999999999999442.32149.8
2010489292.498.11.6235.1375.16179.7213.13.9324.95.83.1-22.1881.1616.2396.699999999999931894
2011464.324987.81.5225309.45.9173207.93.8329.65.2-8.8-29.1802.5999999999999540.3384.71727.6
2014400.8234.8851.4187.72905.8167.8199.23.9338.54.7-12.1-35.3722483.5370.91576.4
2017225.7240.196.91.3115.1305.561651984353.53.8-3.8-44.5563.9999999999999426.63671357.6
2020142.9230.182.11.387306.65.8118.2186.63.83543.3-8.8-54.1456.4399.4308.61164.4
1990280.07188.52388.26
2005620.9333.5132.21.8253.24046.8217.9229.23.7301.57.3-8.21088.4664450.82203.2
2009498.9263.692.51.5226.7337.15.8186.3220.93.8319.75.7-9-24.5856.5569.5999999999999411.000000000000061837.1
2013493.1281.9781.6220.8342.85.9168.9197.53.9334.65.4-4-26.1854.6569.5370.31794.4

CREATE TABLE table_1 (
  "year" BIGINT,
  "industry_and_commercial_electricity" DOUBLE,
  "industry_and_commercial_gas" DOUBLE,
  "industrial_and_commercial_other_fuels" DOUBLE,
  "agriculture" DOUBLE,
  "domestic_electricity" DOUBLE,
  "domestic_gas" DOUBLE,
  "domestic_other_fuels" DOUBLE,
  "road_transport_a_roads" DOUBLE,
  "road_transport_minor_roads" DOUBLE,
  "transport_other" DOUBLE,
  "populations_000s_mid_year_estimate" DOUBLE,
  "per_capita_emissions" DOUBLE,
  "grand_total_1990_only" DOUBLE,
  "annual_change" DOUBLE,
  "total_change" DOUBLE,
  "column_17" VARCHAR,
  "column_18" VARCHAR,
  "column_19" VARCHAR,
  "industry_and_commercial_total" DOUBLE,
  "domestic_total" DOUBLE,
  "transport_total" DOUBLE,
  "grand_total" DOUBLE
);

Share link

Anyone who has the link will be able to view this.