Department For Transport Real Time Energy Use
Department for Transport
@ukgov.dft_energy_use
Department for Transport
@ukgov.dft_energy_use
CREATE TABLE department_for_transport_real_time_energy_use (
"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
);
Anyone who has the link will be able to view this.