Leeds Meteorological Data
Leeds City Council
@ukgov.leeds_meteorological_data
Leeds City Council
@ukgov.leeds_meteorological_data
CREATE TABLE n_01_01_2000_01_07_2018_hourly_readings (
"n_01_01_2000_01_00" VARCHAR,
"unnamed_1" DOUBLE,
"unnamed_2" DOUBLE,
"unnamed_3" DOUBLE,
"unnamed_4" DOUBLE,
"unnamed_5" DOUBLE,
"unnamed_6" DOUBLE,
"unnamed_7" DOUBLE
);
CREATE TABLE n_01_01_2010_01_01_2019_15min_readings (
"n_01_01_2010_00_15" VARCHAR,
"n_9_37" DOUBLE,
"n_2_428" DOUBLE,
"n_14_59" DOUBLE,
"n_0_267" DOUBLE,
"n__0_262" DOUBLE,
"unnamed_6" DOUBLE,
"n_86_8999" DOUBLE
);
CREATE TABLE n_01_01_2019_01_01_2020_15_min_readings (
"unnamed_0" VARCHAR,
"n__012_m" VARCHAR,
"n__012_m_1" VARCHAR,
"n__012_m_2" VARCHAR,
"n__002_m" VARCHAR,
"n__008_m" VARCHAR,
"n__002_m_1" VARCHAR,
"n__002_m_2" VARCHAR
);
CREATE TABLE n_01_01_2019_01_01_2020_hourly_readings (
"n_01_01_2019_01_00" VARCHAR,
"n_271_8" DOUBLE,
"n_7_48" DOUBLE,
"n_9_58" DOUBLE,
"n_9_63999" DOUBLE,
"n_9_89999" DOUBLE,
"unnamed_6" DOUBLE,
"n_81_4" DOUBLE
);
Anyone who has the link will be able to view this.