Gateshead Mine Water Heat Living Laboratory
Coal Authority
@ukgov.gateshead_mine_water_heat_living_laboratory
Coal Authority
@ukgov.gateshead_mine_water_heat_living_laboratory
This data is a collection of data from sensors deployed as part of the Gateshead Living Lab, pertaining to mine water level, mine water chemistry, mine water temperature, pore water pressures and borehole temperature profiles.
Publisher name: Coal Authority
Last updated: 2025-05-09T04:05:36Z
CREATE TABLE bede_brass_thill_ltc_data_april_2025 (
"report_date" VARCHAR -- Report Date:,
"n_29_04_2025_08_56" VARCHAR -- 29/04/2025–08:56,
"unnamed_2" VARCHAR -- Unnamed: 2,
"unnamed_3" VARCHAR -- Unnamed: 3,
"unnamed_4" VARCHAR -- Unnamed: 4,
"unnamed_5" VARCHAR -- Unnamed: 5,
"unnamed_6" VARCHAR -- Unnamed: 6,
"unnamed_7" VARCHAR -- Unnamed: 7,
"unnamed_8" VARCHAR -- Unnamed: 8
);CREATE TABLE bede_brass_thill_ltc_data_dec_2024 (
"report_date" VARCHAR -- Report Date:,
"n_19_12_2024_16_06" VARCHAR -- 19/12/2024–16:06,
"unnamed_2" VARCHAR -- Unnamed: 2,
"unnamed_3" VARCHAR -- Unnamed: 3,
"unnamed_4" VARCHAR -- Unnamed: 4,
"unnamed_5" VARCHAR -- Unnamed: 5,
"unnamed_6" VARCHAR -- Unnamed: 6,
"unnamed_7" VARCHAR -- Unnamed: 7
);CREATE TABLE bede_brass_thill_ltc_data_feb_2025 (
"report_date" VARCHAR -- Report Date:,
"n_24_02_2025_13_35" VARCHAR -- 24/02/2025–13:35,
"unnamed_2" VARCHAR -- Unnamed: 2,
"unnamed_3" VARCHAR -- Unnamed: 3,
"unnamed_4" VARCHAR -- Unnamed: 4,
"unnamed_5" VARCHAR -- Unnamed: 5,
"unnamed_6" VARCHAR -- Unnamed: 6,
"unnamed_7" VARCHAR -- Unnamed: 7,
"unnamed_8" VARCHAR -- Unnamed: 8
);CREATE TABLE bede_brass_thill_ltc_data_jan_2025 (
"report_date" VARCHAR -- Report Date:,
"n_13_01_2025_16_24" VARCHAR -- 13/01/2025–16:24,
"unnamed_2" VARCHAR -- Unnamed: 2,
"unnamed_3" VARCHAR -- Unnamed: 3,
"unnamed_4" VARCHAR -- Unnamed: 4,
"unnamed_5" VARCHAR -- Unnamed: 5,
"unnamed_6" VARCHAR -- Unnamed: 6,
"unnamed_7" VARCHAR -- Unnamed: 7,
"unnamed_8" VARCHAR -- Unnamed: 8
);CREATE TABLE bede_brass_thill_ltc_data_march_2025 (
"report_date" VARCHAR -- Report Date:,
"n_19_03_2025_14_14" VARCHAR -- 19/03/2025–14:14,
"unnamed_2" VARCHAR -- Unnamed: 2,
"unnamed_3" VARCHAR -- Unnamed: 3,
"unnamed_4" VARCHAR -- Unnamed: 4,
"unnamed_5" VARCHAR -- Unnamed: 5,
"unnamed_6" VARCHAR -- Unnamed: 6,
"unnamed_7" VARCHAR -- Unnamed: 7,
"unnamed_8" VARCHAR -- Unnamed: 8
);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: 1,
"unnamed_2" VARCHAR -- Unnamed: 2,
"unnamed_3" VARCHAR -- Unnamed: 3,
"unnamed_4" VARCHAR -- Unnamed: 4,
"unnamed_5" VARCHAR -- Unnamed: 5,
"unnamed_6" VARCHAR -- Unnamed: 6,
"unnamed_7" VARCHAR -- Unnamed: 7,
"unnamed_8" VARCHAR -- Unnamed: 8,
"unnamed_9" VARCHAR -- Unnamed: 9,
"unnamed_10" VARCHAR -- Unnamed: 10,
"unnamed_11" VARCHAR -- Unnamed: 11,
"unnamed_12" VARCHAR -- Unnamed: 12,
"unnamed_13" VARCHAR -- Unnamed: 13,
"unnamed_14" VARCHAR -- Unnamed: 14,
"unnamed_15" VARCHAR -- Unnamed: 15,
"unnamed_16" VARCHAR -- Unnamed: 16,
"unnamed_17" VARCHAR -- Unnamed: 17,
"unnamed_18" VARCHAR -- Unnamed: 18,
"unnamed_19" VARCHAR -- Unnamed: 19,
"unnamed_20" VARCHAR -- Unnamed: 20,
"unnamed_21" VARCHAR -- Unnamed: 21,
"unnamed_22" VARCHAR -- Unnamed: 22,
"unnamed_23" VARCHAR -- Unnamed: 23,
"unnamed_24" VARCHAR -- Unnamed: 24,
"unnamed_25" VARCHAR -- Unnamed: 25,
"unnamed_26" VARCHAR -- Unnamed: 26,
"unnamed_27" VARCHAR -- Unnamed: 27
);CREATE TABLE bede_brass_thill_vwp_thermistor_data_march_2025 (
"n_29_2_2024_12_30_00" VARCHAR -- 29/2/2024–12:30:00,
"n_6_0" DOUBLE -- 6.0,
"n_11_4" DOUBLE -- 11.4,
"n_1_494" DOUBLE -- 1.494,
"n_11_9" DOUBLE -- 11.9,
"n_4_844" DOUBLE -- 4.844,
"n_12_2" DOUBLE -- 12.2,
"not_av" VARCHAR -- Not Av.,
"n_12_3" DOUBLE -- 12.3,
"n_54_477" DOUBLE -- 54.477,
"n_14_2" DOUBLE -- 14.2,
"not_av_1" VARCHAR -- Not Av..1,
"n_16_7" DOUBLE -- 16.7,
"n_u" VARCHAR -- N.U.,
"n_u_1" VARCHAR -- N.U..1,
"n_u_2" VARCHAR -- N.U..2,
"n_u_3" VARCHAR -- N.U..3,
"n_u_4" VARCHAR -- N.U..4,
"n_u_5" VARCHAR -- N.U..5,
"unnamed_19" VARCHAR -- Unnamed: 19,
"n_9151_8" DOUBLE -- 9151.8,
"n_8904_3" DOUBLE -- 8904.3,
"not_av_2" VARCHAR -- Not Av..2,
"n_8104_8" DOUBLE -- 8104.8,
"not_av_3" VARCHAR -- Not Av..3,
"n_u_6" VARCHAR -- N.U..6,
"n_u_7" VARCHAR -- N.U..7,
"n_u_8" VARCHAR -- N.U..8,
"unnamed_28" VARCHAR -- Unnamed: 28
);CREATE TABLE bede_high_main_ltc_data_april_2025 (
"report_date" VARCHAR -- Report Date:,
"n_29_04_2025_08_56" VARCHAR -- 29/04/2025–08:56,
"unnamed_2" VARCHAR -- Unnamed: 2,
"unnamed_3" VARCHAR -- Unnamed: 3,
"unnamed_4" VARCHAR -- Unnamed: 4,
"unnamed_5" VARCHAR -- Unnamed: 5,
"unnamed_6" VARCHAR -- Unnamed: 6,
"unnamed_7" VARCHAR -- Unnamed: 7,
"unnamed_8" VARCHAR -- Unnamed: 8
);CREATE TABLE bede_high_main_ltc_data_dec_2024 (
"report_date" VARCHAR -- Report Date:,
"n_19_12_2024_16_06" VARCHAR -- 19/12/2024–16:06,
"unnamed_2" VARCHAR -- Unnamed: 2,
"unnamed_3" VARCHAR -- Unnamed: 3,
"unnamed_4" VARCHAR -- Unnamed: 4,
"unnamed_5" VARCHAR -- Unnamed: 5,
"unnamed_6" VARCHAR -- Unnamed: 6,
"unnamed_7" VARCHAR -- Unnamed: 7
);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 -- Report Date:,
"n_24_02_2025_13_35" VARCHAR -- 24/02/2025–13:35,
"unnamed_2" VARCHAR -- Unnamed: 2,
"unnamed_3" VARCHAR -- Unnamed: 3,
"unnamed_4" VARCHAR -- Unnamed: 4,
"unnamed_5" VARCHAR -- Unnamed: 5,
"unnamed_6" VARCHAR -- Unnamed: 6,
"unnamed_7" VARCHAR -- Unnamed: 7,
"unnamed_8" VARCHAR -- Unnamed: 8,
"unnamed_9" VARCHAR -- Unnamed: 9
);CREATE TABLE bede_high_main_ltc_data_jan_2025 (
"report_date" VARCHAR -- Report Date:,
"n_13_01_2025_16_20" VARCHAR -- 13/01/2025–16:20,
"unnamed_2" VARCHAR -- Unnamed: 2,
"unnamed_3" VARCHAR -- Unnamed: 3,
"unnamed_4" VARCHAR -- Unnamed: 4,
"unnamed_5" VARCHAR -- Unnamed: 5,
"unnamed_6" VARCHAR -- Unnamed: 6,
"unnamed_7" VARCHAR -- Unnamed: 7,
"unnamed_8" VARCHAR -- Unnamed: 8
);CREATE TABLE bede_high_main_ltc_data_march_2025 (
"report_date" VARCHAR -- Report Date:,
"n_19_03_2025_14_08" VARCHAR -- 19/03/2025–14:08,
"unnamed_2" VARCHAR -- Unnamed: 2,
"unnamed_3" VARCHAR -- Unnamed: 3,
"unnamed_4" VARCHAR -- Unnamed: 4,
"unnamed_5" VARCHAR -- Unnamed: 5,
"unnamed_6" VARCHAR -- Unnamed: 6,
"unnamed_7" VARCHAR -- Unnamed: 7,
"unnamed_8" VARCHAR -- Unnamed: 8
);CREATE TABLE stadium_high_main_ltc_data_april_2025 (
"report_date" VARCHAR -- Report Date:,
"n_29_04_2025_08_56" VARCHAR -- 29/04/2025–08:56,
"unnamed_2" VARCHAR -- Unnamed: 2,
"unnamed_3" VARCHAR -- Unnamed: 3,
"unnamed_4" VARCHAR -- Unnamed: 4,
"unnamed_5" VARCHAR -- Unnamed: 5,
"unnamed_6" VARCHAR -- Unnamed: 6,
"unnamed_7" VARCHAR -- Unnamed: 7,
"unnamed_8" VARCHAR -- Unnamed: 8
);CREATE TABLE stadium_high_main_ltc_data_dec_2024 (
"report_date" VARCHAR -- Report Date:,
"n_19_12_2024_16_04" VARCHAR -- 19/12/2024–16:04,
"unnamed_2" VARCHAR -- Unnamed: 2,
"unnamed_3" VARCHAR -- Unnamed: 3,
"unnamed_4" VARCHAR -- Unnamed: 4,
"unnamed_5" VARCHAR -- Unnamed: 5,
"unnamed_6" VARCHAR -- Unnamed: 6,
"unnamed_7" VARCHAR -- Unnamed: 7
);CREATE TABLE stadium_high_main_ltc_data_feb_2025 (
"report_date" VARCHAR -- Report Date:,
"n_24_02_2025_13_34" VARCHAR -- 24/02/2025–13:34,
"unnamed_2" VARCHAR -- Unnamed: 2,
"unnamed_3" VARCHAR -- Unnamed: 3,
"unnamed_4" VARCHAR -- Unnamed: 4,
"unnamed_5" VARCHAR -- Unnamed: 5,
"unnamed_6" VARCHAR -- Unnamed: 6,
"unnamed_7" VARCHAR -- Unnamed: 7,
"unnamed_8" VARCHAR -- Unnamed: 8
);CREATE TABLE stadium_high_main_ltc_data_jan_2025 (
"report_date" VARCHAR -- Report Date:,
"n_13_01_2025_16_17" VARCHAR -- 13/01/2025–16:17,
"unnamed_2" VARCHAR -- Unnamed: 2,
"unnamed_3" VARCHAR -- Unnamed: 3,
"unnamed_4" VARCHAR -- Unnamed: 4,
"unnamed_5" VARCHAR -- Unnamed: 5,
"unnamed_6" VARCHAR -- Unnamed: 6,
"unnamed_7" VARCHAR -- Unnamed: 7,
"unnamed_8" VARCHAR -- Unnamed: 8
);CREATE TABLE stadium_high_main_ltc_data_march_2025 (
"report_date" VARCHAR -- Report Date:,
"n_19_03_2025_14_12" VARCHAR -- 19/03/2025–14:12,
"unnamed_2" VARCHAR -- Unnamed: 2,
"unnamed_3" VARCHAR -- Unnamed: 3,
"unnamed_4" VARCHAR -- Unnamed: 4,
"unnamed_5" VARCHAR -- Unnamed: 5,
"unnamed_6" VARCHAR -- Unnamed: 6,
"unnamed_7" VARCHAR -- Unnamed: 7,
"unnamed_8" VARCHAR -- Unnamed: 8
);CREATE TABLE stadium_hutton_ltc_data_april_2025 (
"report_date" VARCHAR -- Report Date:,
"n_29_04_2025_09_18" VARCHAR -- 29/04/2025–09:18,
"unnamed_2" VARCHAR -- Unnamed: 2,
"unnamed_3" VARCHAR -- Unnamed: 3,
"unnamed_4" VARCHAR -- Unnamed: 4,
"unnamed_5" VARCHAR -- Unnamed: 5,
"unnamed_6" VARCHAR -- Unnamed: 6,
"unnamed_7" VARCHAR -- Unnamed: 7,
"unnamed_8" VARCHAR -- Unnamed: 8
);CREATE TABLE stadium_hutton_ltc_data_dec_2024 (
"report_date" VARCHAR -- Report Date:,
"n_19_12_2024_16_05" VARCHAR -- 19/12/2024–16:05,
"unnamed_2" VARCHAR -- Unnamed: 2,
"unnamed_3" VARCHAR -- Unnamed: 3,
"unnamed_4" VARCHAR -- Unnamed: 4,
"unnamed_5" VARCHAR -- Unnamed: 5,
"unnamed_6" VARCHAR -- Unnamed: 6,
"unnamed_7" VARCHAR -- Unnamed: 7
);CREATE TABLE stadium_hutton_ltc_data_feb_2025 (
"report_date" VARCHAR -- Report Date:,
"n_24_02_2025_13_34" VARCHAR -- 24/02/2025–13:34,
"unnamed_2" VARCHAR -- Unnamed: 2,
"unnamed_3" VARCHAR -- Unnamed: 3,
"unnamed_4" VARCHAR -- Unnamed: 4,
"unnamed_5" VARCHAR -- Unnamed: 5,
"unnamed_6" VARCHAR -- Unnamed: 6,
"unnamed_7" VARCHAR -- Unnamed: 7,
"unnamed_8" VARCHAR -- Unnamed: 8
);CREATE TABLE stadium_hutton_ltc_data_jan_2025 (
"report_date" VARCHAR -- Report Date:,
"n_13_01_2025_16_18" VARCHAR -- 13/01/2025–16:18,
"unnamed_2" VARCHAR -- Unnamed: 2,
"unnamed_3" VARCHAR -- Unnamed: 3,
"unnamed_4" VARCHAR -- Unnamed: 4,
"unnamed_5" VARCHAR -- Unnamed: 5,
"unnamed_6" VARCHAR -- Unnamed: 6,
"unnamed_7" VARCHAR -- Unnamed: 7,
"unnamed_8" VARCHAR -- Unnamed: 8
);CREATE TABLE stadium_hutton_ltc_data_march_2025 (
"report_date" VARCHAR -- Report Date:,
"n_19_03_2025_14_15" VARCHAR -- 19/03/2025–14:15,
"unnamed_2" VARCHAR -- Unnamed: 2,
"unnamed_3" VARCHAR -- Unnamed: 3,
"unnamed_4" VARCHAR -- Unnamed: 4,
"unnamed_5" VARCHAR -- Unnamed: 5,
"unnamed_6" VARCHAR -- Unnamed: 6,
"unnamed_7" VARCHAR -- Unnamed: 7,
"unnamed_8" VARCHAR -- Unnamed: 8
);CREATE TABLE stadium_hutton_vwp_thermistor_data_jan_2025 (
"n_3_9_2024_13_45_00" VARCHAR -- 3/9/2024–13:45:00,
"n_5_7" DOUBLE -- 5.7,
"n_25_1" DOUBLE -- 25.1,
"n__9_916" VARCHAR -- -9.916,
"n_12_5" DOUBLE -- 12.5,
"n_8_709" VARCHAR -- 8.709,
"n_13_0" DOUBLE -- 13.0,
"not_av" VARCHAR -- Not Av.,
"n_14_3" DOUBLE -- 14.3,
"n_58_907" DOUBLE -- 58.907,
"n_15_5" DOUBLE -- 15.5,
"not_av_1" VARCHAR -- Not Av..1,
"n_15_7" DOUBLE -- 15.7,
"not_av_2" VARCHAR -- Not Av..2,
"n_17_8" DOUBLE -- 17.8,
"n_u" VARCHAR -- N.U.,
"n_u_1" VARCHAR -- N.U..1,
"n_u_2" VARCHAR -- N.U..2,
"n_u_3" VARCHAR -- N.U..3,
"unnamed_19" VARCHAR -- Unnamed: 19,
"n_9160_3" VARCHAR -- 9160.3,
"n_8662_4" VARCHAR -- 8662.4,
"not_av_3" VARCHAR -- Not Av..3,
"n_7803_6" DOUBLE -- 7803.6,
"not_av_4" VARCHAR -- Not Av..4,
"not_av_5" VARCHAR -- Not Av..5,
"n_u_4" VARCHAR -- N.U..4,
"n_u_5" VARCHAR -- N.U..5,
"unnamed_28" VARCHAR -- Unnamed: 28
);Anyone who has the link will be able to view this.