Department For Transport Real Time Energy Use

CREATE TABLE department_for_transport_real_time_energy_use (
  "site" VARCHAR,
  "meter" VARCHAR,
  "unit" VARCHAR,
  "date" TIMESTAMP,
  "n_00_00" DOUBLE  -- 00:00,
  "n_00_30" DOUBLE  -- 00:30,
  "n_01_00" DOUBLE  -- 01:00,
  "n_01_30" DOUBLE  -- 01:30,
  "n_02_00" DOUBLE  -- 02:00,
  "n_02_30" DOUBLE  -- 02:30,
  "n_03_00" DOUBLE  -- 03:00,
  "n_03_30" DOUBLE  -- 03:30,
  "n_04_00" DOUBLE  -- 04:00,
  "n_04_30" DOUBLE  -- 04:30,
  "n_05_00" DOUBLE  -- 05:00,
  "n_05_30" DOUBLE  -- 05:30,
  "n_06_00" DOUBLE  -- 06:00,
  "n_06_30" DOUBLE  -- 06:30,
  "n_07_00" DOUBLE  -- 07:00,
  "n_07_30" DOUBLE  -- 07:30,
  "n_08_00" DOUBLE  -- 08:00,
  "n_08_30" DOUBLE  -- 08:30,
  "n_09_00" DOUBLE  -- 09:00,
  "n_09_30" DOUBLE  -- 09:30,
  "n_10_00" DOUBLE  -- 10:00,
  "n_10_30" DOUBLE  -- 10:30,
  "n_11_00" DOUBLE  -- 11:00,
  "n_11_30" DOUBLE  -- 11:30,
  "n_12_00" DOUBLE  -- 12:00,
  "n_12_30" DOUBLE  -- 12:30,
  "n_13_00" DOUBLE  -- 13:00,
  "n_13_30" DOUBLE  -- 13:30,
  "n_14_00" DOUBLE  -- 14:00,
  "n_14_30" DOUBLE  -- 14:30,
  "n_15_00" DOUBLE  -- 15:00,
  "n_15_30" DOUBLE  -- 15:30,
  "n_16_00" DOUBLE  -- 16:00,
  "n_16_30" DOUBLE  -- 16:30,
  "n_17_00" DOUBLE  -- 17:00,
  "n_17_30" DOUBLE  -- 17:30,
  "n_18_00" DOUBLE  -- 18:00,
  "n_18_30" DOUBLE  -- 18:30,
  "n_19_00" DOUBLE  -- 19:00,
  "n_19_30" DOUBLE  -- 19:30,
  "n_20_00" DOUBLE  -- 20:00,
  "n_20_30" DOUBLE  -- 20:30,
  "n_21_00" DOUBLE  -- 21:00,
  "n_21_30" DOUBLE  -- 21:30,
  "n_22_00" DOUBLE  -- 22:00,
  "n_22_30" DOUBLE  -- 22:30,
  "n_23_00" DOUBLE  -- 23:00,
  "n_23_30" DOUBLE  -- 23:30
);