Gateshead Mine Water Heat Living Laboratory
Coal Authority
@ukgov.gateshead_mine_water_heat_living_laboratory
Coal Authority
@ukgov.gateshead_mine_water_heat_living_laboratory
CREATE TABLE bede_brass_thill_ltc_data_april_2025 (
"report_date" VARCHAR,
"n_29_04_2025_08_56" VARCHAR,
"unnamed_2" VARCHAR,
"unnamed_3" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR,
"unnamed_6" VARCHAR,
"unnamed_7" VARCHAR,
"unnamed_8" VARCHAR
);
CREATE TABLE bede_brass_thill_ltc_data_dec_2024 (
"report_date" VARCHAR,
"n_19_12_2024_16_06" VARCHAR,
"unnamed_2" VARCHAR,
"unnamed_3" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR,
"unnamed_6" VARCHAR,
"unnamed_7" VARCHAR
);
CREATE TABLE bede_brass_thill_ltc_data_feb_2025 (
"report_date" VARCHAR,
"n_24_02_2025_13_35" VARCHAR,
"unnamed_2" VARCHAR,
"unnamed_3" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR,
"unnamed_6" VARCHAR,
"unnamed_7" VARCHAR,
"unnamed_8" VARCHAR
);
CREATE TABLE bede_brass_thill_ltc_data_jan_2025 (
"report_date" VARCHAR,
"n_13_01_2025_16_24" VARCHAR,
"unnamed_2" VARCHAR,
"unnamed_3" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR,
"unnamed_6" VARCHAR,
"unnamed_7" VARCHAR,
"unnamed_8" VARCHAR
);
CREATE TABLE bede_brass_thill_ltc_data_march_2025 (
"report_date" VARCHAR,
"n_19_03_2025_14_14" VARCHAR,
"unnamed_2" VARCHAR,
"unnamed_3" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR,
"unnamed_6" VARCHAR,
"unnamed_7" VARCHAR,
"unnamed_8" VARCHAR
);
CREATE TABLE bede_brass_thill_ltc_data_nov_2023_solinst (
"date" TIMESTAMP,
"time" VARCHAR,
"ms" BIGINT,
"level" DOUBLE,
"temperature" DOUBLE,
"conductivity" DOUBLE
);
CREATE TABLE bede_brass_thill_vwp_thermistor_data_august_2023 (
"linx_8ch_v_1_0_4" VARCHAR,
"unnamed_1" VARCHAR,
"unnamed_2" VARCHAR,
"unnamed_3" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR,
"unnamed_6" VARCHAR,
"unnamed_7" VARCHAR,
"unnamed_8" VARCHAR,
"unnamed_9" VARCHAR,
"unnamed_10" VARCHAR,
"unnamed_11" VARCHAR,
"unnamed_12" VARCHAR,
"unnamed_13" VARCHAR,
"unnamed_14" VARCHAR,
"unnamed_15" VARCHAR,
"unnamed_16" VARCHAR,
"unnamed_17" VARCHAR,
"unnamed_18" VARCHAR,
"unnamed_19" VARCHAR,
"unnamed_20" VARCHAR,
"unnamed_21" VARCHAR,
"unnamed_22" VARCHAR,
"unnamed_23" VARCHAR,
"unnamed_24" VARCHAR,
"unnamed_25" VARCHAR,
"unnamed_26" VARCHAR,
"unnamed_27" VARCHAR
);
CREATE TABLE bede_brass_thill_vwp_thermistor_data_march_2025 (
"n_29_2_2024_12_30_00" VARCHAR,
"n_6_0" DOUBLE,
"n_11_4" DOUBLE,
"n_1_494" DOUBLE,
"n_11_9" DOUBLE,
"n_4_844" DOUBLE,
"n_12_2" DOUBLE,
"not_av" VARCHAR,
"n_12_3" DOUBLE,
"n_54_477" DOUBLE,
"n_14_2" DOUBLE,
"not_av_1" VARCHAR,
"n_16_7" DOUBLE,
"n_u" VARCHAR,
"n_u_1" VARCHAR,
"n_u_2" VARCHAR,
"n_u_3" VARCHAR,
"n_u_4" VARCHAR,
"n_u_5" VARCHAR,
"unnamed_19" VARCHAR,
"n_9151_8" DOUBLE,
"n_8904_3" DOUBLE,
"not_av_2" VARCHAR,
"n_8104_8" DOUBLE,
"not_av_3" VARCHAR,
"n_u_6" VARCHAR,
"n_u_7" VARCHAR,
"n_u_8" VARCHAR,
"unnamed_28" VARCHAR
);
CREATE TABLE bede_high_main_ltc_data_april_2025 (
"report_date" VARCHAR,
"n_29_04_2025_08_56" VARCHAR,
"unnamed_2" VARCHAR,
"unnamed_3" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR,
"unnamed_6" VARCHAR,
"unnamed_7" VARCHAR,
"unnamed_8" VARCHAR
);
CREATE TABLE bede_high_main_ltc_data_dec_2024 (
"report_date" VARCHAR,
"n_19_12_2024_16_06" VARCHAR,
"unnamed_2" VARCHAR,
"unnamed_3" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR,
"unnamed_6" VARCHAR,
"unnamed_7" VARCHAR
);
CREATE TABLE bede_high_main_ltc_data_feb_2024_solinst (
"date" TIMESTAMP,
"time" VARCHAR,
"ms" BIGINT,
"level" DOUBLE,
"temperature" DOUBLE,
"con_uctivity" DOUBLE
);
CREATE TABLE bede_high_main_ltc_data_feb_2025 (
"report_date" VARCHAR,
"n_24_02_2025_13_35" VARCHAR,
"unnamed_2" VARCHAR,
"unnamed_3" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR,
"unnamed_6" VARCHAR,
"unnamed_7" VARCHAR,
"unnamed_8" VARCHAR,
"unnamed_9" VARCHAR
);
CREATE TABLE bede_high_main_ltc_data_jan_2025 (
"report_date" VARCHAR,
"n_13_01_2025_16_20" VARCHAR,
"unnamed_2" VARCHAR,
"unnamed_3" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR,
"unnamed_6" VARCHAR,
"unnamed_7" VARCHAR,
"unnamed_8" VARCHAR
);
CREATE TABLE bede_high_main_ltc_data_march_2025 (
"report_date" VARCHAR,
"n_19_03_2025_14_08" VARCHAR,
"unnamed_2" VARCHAR,
"unnamed_3" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR,
"unnamed_6" VARCHAR,
"unnamed_7" VARCHAR,
"unnamed_8" VARCHAR
);
CREATE TABLE stadium_high_main_ltc_data_april_2025 (
"report_date" VARCHAR,
"n_29_04_2025_08_56" VARCHAR,
"unnamed_2" VARCHAR,
"unnamed_3" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR,
"unnamed_6" VARCHAR,
"unnamed_7" VARCHAR,
"unnamed_8" VARCHAR
);
CREATE TABLE stadium_high_main_ltc_data_dec_2024 (
"report_date" VARCHAR,
"n_19_12_2024_16_04" VARCHAR,
"unnamed_2" VARCHAR,
"unnamed_3" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR,
"unnamed_6" VARCHAR,
"unnamed_7" VARCHAR
);
CREATE TABLE stadium_high_main_ltc_data_feb_2025 (
"report_date" VARCHAR,
"n_24_02_2025_13_34" VARCHAR,
"unnamed_2" VARCHAR,
"unnamed_3" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR,
"unnamed_6" VARCHAR,
"unnamed_7" VARCHAR,
"unnamed_8" VARCHAR
);
CREATE TABLE stadium_high_main_ltc_data_jan_2025 (
"report_date" VARCHAR,
"n_13_01_2025_16_17" VARCHAR,
"unnamed_2" VARCHAR,
"unnamed_3" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR,
"unnamed_6" VARCHAR,
"unnamed_7" VARCHAR,
"unnamed_8" VARCHAR
);
CREATE TABLE stadium_high_main_ltc_data_march_2025 (
"report_date" VARCHAR,
"n_19_03_2025_14_12" VARCHAR,
"unnamed_2" VARCHAR,
"unnamed_3" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR,
"unnamed_6" VARCHAR,
"unnamed_7" VARCHAR,
"unnamed_8" VARCHAR
);
CREATE TABLE stadium_hutton_ltc_data_april_2025 (
"report_date" VARCHAR,
"n_29_04_2025_09_18" VARCHAR,
"unnamed_2" VARCHAR,
"unnamed_3" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR,
"unnamed_6" VARCHAR,
"unnamed_7" VARCHAR,
"unnamed_8" VARCHAR
);
CREATE TABLE stadium_hutton_ltc_data_dec_2024 (
"report_date" VARCHAR,
"n_19_12_2024_16_05" VARCHAR,
"unnamed_2" VARCHAR,
"unnamed_3" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR,
"unnamed_6" VARCHAR,
"unnamed_7" VARCHAR
);
CREATE TABLE stadium_hutton_ltc_data_feb_2025 (
"report_date" VARCHAR,
"n_24_02_2025_13_34" VARCHAR,
"unnamed_2" VARCHAR,
"unnamed_3" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR,
"unnamed_6" VARCHAR,
"unnamed_7" VARCHAR,
"unnamed_8" VARCHAR
);
CREATE TABLE stadium_hutton_ltc_data_jan_2025 (
"report_date" VARCHAR,
"n_13_01_2025_16_18" VARCHAR,
"unnamed_2" VARCHAR,
"unnamed_3" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR,
"unnamed_6" VARCHAR,
"unnamed_7" VARCHAR,
"unnamed_8" VARCHAR
);
CREATE TABLE stadium_hutton_ltc_data_march_2025 (
"report_date" VARCHAR,
"n_19_03_2025_14_15" VARCHAR,
"unnamed_2" VARCHAR,
"unnamed_3" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR,
"unnamed_6" VARCHAR,
"unnamed_7" VARCHAR,
"unnamed_8" VARCHAR
);
CREATE TABLE stadium_hutton_vwp_thermistor_data_jan_2025 (
"n_3_9_2024_13_45_00" VARCHAR,
"n_5_7" DOUBLE,
"n_25_1" DOUBLE,
"n__9_916" VARCHAR,
"n_12_5" DOUBLE,
"n_8_709" VARCHAR,
"n_13_0" DOUBLE,
"not_av" VARCHAR,
"n_14_3" DOUBLE,
"n_58_907" DOUBLE,
"n_15_5" DOUBLE,
"not_av_1" VARCHAR,
"n_15_7" DOUBLE,
"not_av_2" VARCHAR,
"n_17_8" DOUBLE,
"n_u" VARCHAR,
"n_u_1" VARCHAR,
"n_u_2" VARCHAR,
"n_u_3" VARCHAR,
"unnamed_19" VARCHAR,
"n_9160_3" VARCHAR,
"n_8662_4" VARCHAR,
"not_av_3" VARCHAR,
"n_7803_6" DOUBLE,
"not_av_4" VARCHAR,
"not_av_5" VARCHAR,
"n_u_4" VARCHAR,
"n_u_5" VARCHAR,
"unnamed_28" VARCHAR
);
Anyone who has the link will be able to view this.