Name: Department For Education Gas And Electricity Half Hourly Data
Creator: UK Government
License: http://reference.data.gov.uk/id/open-government-licence

About this Dataset

Department For Education Gas And Electricity Half Hourly Data

Department for Education real time energy consumption from 28th July 2010.
Publisher name: Department for Education
Last updated: 2022-07-01T04:07:03Z

Tables

Department For Education Gas And Electricity Half Hourly Data

@ukgov.education_real_time_energy_consumption.department_for_education_gas_and_electricity_half_hourly_data

50.95 KB
93 rows
53 columns


CREATE TABLE department_for_education_gas_and_electricity_half_hourly_data (
  "site" VARCHAR,
  "meter" VARCHAR,
  "unit" VARCHAR,
  "date" TIMESTAMP,
  "n_00_00" DOUBLE,
  "n_00_30" DOUBLE,
  "n_01_00" DOUBLE,
  "n_01_30" DOUBLE,
  "n_02_00" DOUBLE,
  "n_02_30" DOUBLE,
  "n_03_00" DOUBLE,
  "n_03_30" DOUBLE,
  "n_04_00" DOUBLE,
  "n_04_30" DOUBLE,
  "n_05_00" DOUBLE,
  "n_05_30" DOUBLE,
  "n_06_00" DOUBLE,
  "n_06_30" DOUBLE,
  "n_07_00" DOUBLE,
  "n_07_30" DOUBLE,
  "n_08_00" DOUBLE,
  "n_08_30" DOUBLE,
  "n_09_00" DOUBLE,
  "n_09_30" DOUBLE,
  "n_10_00" DOUBLE,
  "n_10_30" DOUBLE,
  "n_11_00" DOUBLE,
  "n_11_30" DOUBLE,
  "n_12_00" DOUBLE,
  "n_12_30" DOUBLE,
  "n_13_00" DOUBLE,
  "n_13_30" DOUBLE,
  "n_14_00" DOUBLE,
  "n_14_30" DOUBLE,
  "n_15_00" DOUBLE,
  "n_15_30" DOUBLE,
  "n_16_00" DOUBLE,
  "n_16_30" DOUBLE,
  "n_17_00" DOUBLE,
  "n_17_30" DOUBLE,
  "n_18_00" DOUBLE,
  "n_18_30" DOUBLE,
  "n_19_00" DOUBLE,
  "n_19_30" DOUBLE,
  "n_20_00" DOUBLE,
  "n_20_30" DOUBLE,
  "n_21_00" DOUBLE,
  "n_21_30" DOUBLE,
  "n_22_00" DOUBLE,
  "n_22_30" DOUBLE,
  "n_23_00" DOUBLE,
  "n_23_30" DOUBLE,
  "unnamed_52" DOUBLE
);