About this Dataset

Rain Gauge Rainfall Data

This dataset shows rainfall data from 6 rain gauges located at various locations across the city. Please note ----------- * The siting of the gauges is not to Met Office standards (e.g.. maybe too close to a wall), which may not give an entirely accurate reflection of rainfall. The exact location of these gauges is not released. * Measurements are in millilitres. * It is recognised that there are inconsistencies in the data in respect of site readings. This can be for a number of reasons e.g. damaged cable, faulty loggers or damaged GPRS aerial.
Publisher name: Leeds City Council
Last updated: 2024-09-14T09:41:19Z

Tables

01/01/2015 - 31/01/2015

@ukgov.rain_gauge_rainfall_data.n_01_01_2015_31_01_2015

6.68 KB
31 rows
6 columns


CREATE TABLE n_01_01_2015_31_01_2015 (
  "timestamp_lessone" VARCHAR,
  "qry_allertonbywater_daily_rain_mm_tot" DOUBLE,
  "qry_middleton_daily_rain_mm_tot" DOUBLE,
  "qry_potteryfield_daily_rain_mm_tot" DOUBLE,
  "qry_shadwell_daily_rain_mm_tot" DOUBLE,
  "qry_wetherby_daily_rain_mm_tot" DOUBLE
);

01/01/2017 - 31/01/2017

@ukgov.rain_gauge_rainfall_data.n_01_01_2017_31_01_2017

6.76 KB
31 rows
6 columns


CREATE TABLE n_01_01_2017_31_01_2017 (
  "timestamp_lessone" TIMESTAMP,
  "qry_allertonbywater_daily_rain_mm_tot" DOUBLE,
  "qry_middleton_daily_rain_mm_tot" DOUBLE,
  "qry_potteryfield_daily_rain_mm_tot" DOUBLE,
  "qry_shadwell_daily_rain_mm_tot" DOUBLE,
  "qry_wetherby_daily_rain_mm_tot" DOUBLE
);

01/01/2018 - 31/01/2018

@ukgov.rain_gauge_rainfall_data.n_01_01_2018_31_01_2018

5.73 KB
31 rows
5 columns


CREATE TABLE n_01_01_2018_31_01_2018 (
  "timestamp_lessone" VARCHAR,
  "qry_allertonbywater_daily_rain_mm_tot" DOUBLE,
  "qry_middleton_daily_rain_mm_tot" DOUBLE,
  "qry_shadwell_daily_rain_mm_tot" DOUBLE,
  "qry_wetherby_daily_rain_mm_tot" DOUBLE
);

01/02/2014 - 28/02/2014

@ukgov.rain_gauge_rainfall_data.n_01_02_2014_28_02_2014

7.58 KB
28 rows
7 columns


CREATE TABLE n_01_02_2014_28_02_2014 (
  "timestamp_lessone" VARCHAR,
  "qry_allertonbywater_daily_rain_mm_tot" DOUBLE,
  "qry_middleton_daily_rain_mm_tot" DOUBLE,
  "qry_otley_daily_rain_mm_tot" DOUBLE,
  "qry_potteryfield_daily_rain_mm_tot" DOUBLE,
  "qry_shadwell_daily_rain_mm_tot" DOUBLE,
  "qry_wetherby_daily_rain_mm_tot" DOUBLE
);

01/02/2018 - 28/02/2018

@ukgov.rain_gauge_rainfall_data.n_01_02_2018_28_02_2018

5.56 KB
28 rows
5 columns


CREATE TABLE n_01_02_2018_28_02_2018 (
  "timestamp_lessone" VARCHAR,
  "qry_allertonbywater_daily_rain_mm_tot" DOUBLE,
  "qry_middleton_daily_rain_mm_tot" DOUBLE,
  "qry_shadwell_daily_rain_mm_tot" DOUBLE,
  "qry_wetherby_daily_rain_mm_tot" DOUBLE
);

01/03/2014 - 31/03/2014

@ukgov.rain_gauge_rainfall_data.n_01_03_2014_31_03_2014

6.52 KB
31 rows
6 columns


CREATE TABLE n_01_03_2014_31_03_2014 (
  "timestamp_lessone" VARCHAR,
  "qry_allertonbywater_daily_rain_mm_tot" DOUBLE,
  "qry_middleton_daily_rain_mm_tot" DOUBLE,
  "qry_otley_daily_rain_mm_tot" DOUBLE,
  "qry_shadwell_daily_rain_mm_tot" DOUBLE,
  "qry_potteryfield_daily_rain_mm_tot" DOUBLE
);

01/04/16 - 30/04/2016

@ukgov.rain_gauge_rainfall_data.n_01_04_16_30_04_2016

7.8 KB
30 rows
7 columns


CREATE TABLE n_01_04_16_30_04_2016 (
  "timestamp_lessone" TIMESTAMP,
  "qry_allertonbywater_daily_rain_mm_tot" DOUBLE,
  "qry_middleton_daily_rain_mm_tot" DOUBLE,
  "qry_otley_daily_rain_mm_tot" DOUBLE,
  "qry_potteryfield_daily_rain_mm_tot" DOUBLE,
  "qry_shadwell_daily_rain_mm_tot" DOUBLE,
  "qry_wetherby_daily_rain_mm_tot" DOUBLE
);

01/04/2014 - 30/04/2014

@ukgov.rain_gauge_rainfall_data.n_01_04_2014_30_04_2014

6.53 KB
30 rows
6 columns


CREATE TABLE n_01_04_2014_30_04_2014 (
  "timestamp_lessone" VARCHAR,
  "qry_allertonbywater_daily_rain_mm_tot" DOUBLE,
  "qry_middleton_daily_rain_mm_tot" DOUBLE,
  "qry_otley_daily_rain_mm_tot" DOUBLE,
  "qry_shadwell_daily_rain_mm_tot" DOUBLE,
  "qry_potteryfield_daily_rain_mm_tot" DOUBLE
);

01/04/2015 - 30/04/2015

@ukgov.rain_gauge_rainfall_data.n_01_04_2015_30_04_2015

5.75 KB
30 rows
5 columns


CREATE TABLE n_01_04_2015_30_04_2015 (
  "timestamp_lessone" TIMESTAMP,
  "qry_allertonbywater_daily_rain_mm_tot" DOUBLE,
  "qry_potteryfield_daily_rain_mm_tot" DOUBLE,
  "qry_shadwell_daily_rain_mm_tot" DOUBLE,
  "qry_wetherby_daily_rain_mm_tot" DOUBLE
);

01/04/2017 - 30/04/2017

@ukgov.rain_gauge_rainfall_data.n_01_04_2017_30_04_2017

6.36 KB
30 rows
6 columns


CREATE TABLE n_01_04_2017_30_04_2017 (
  "timestamp_lessone" VARCHAR,
  "qry_allertonbywater_daily_rain_mm_tot" DOUBLE,
  "qry_otley_daily_rain_mm_tot" DOUBLE,
  "qry_potteryfield_daily_rain_mm_tot" DOUBLE,
  "qry_shadwell_daily_rain_mm_tot" DOUBLE,
  "qry_wetherby_daily_rain_mm_tot" DOUBLE
);

01/05/2014 - 31/05/2014

@ukgov.rain_gauge_rainfall_data.n_01_05_2014_31_05_2014

6.69 KB
31 rows
6 columns


CREATE TABLE n_01_05_2014_31_05_2014 (
  "timestamp_lessone" VARCHAR,
  "qry_allertonbywater_daily_rain_mm_tot" DOUBLE,
  "qry_middleton_daily_rain_mm_tot" DOUBLE,
  "qry_otley_daily_rain_mm_tot" BIGINT,
  "qry_shadwell_daily_rain_mm_tot" DOUBLE,
  "qry_potteryfield_daily_rain_mm_tot" DOUBLE
);

01/05/2015 - 31/05/2015

@ukgov.rain_gauge_rainfall_data.n_01_05_2015_31_05_2015

6.78 KB
31 rows
6 columns


CREATE TABLE n_01_05_2015_31_05_2015 (
  "timestamp_lessone" TIMESTAMP,
  "qry_allertonbywater_daily_rain_mm_tot" DOUBLE,
  "qry_middleton_daily_rain_mm_tot" DOUBLE,
  "qry_potteryfield_daily_rain_mm_tot" DOUBLE,
  "qry_shadwell_daily_rain_mm_tot" DOUBLE,
  "qry_wetherby_daily_rain_mm_tot" DOUBLE
);

01/05/2017 - 31/05/2017

@ukgov.rain_gauge_rainfall_data.n_01_05_2017_31_05_2017

7.39 KB
31 rows
7 columns


CREATE TABLE n_01_05_2017_31_05_2017 (
  "timestamp_lessone" VARCHAR,
  "qry_allertonbywater_daily_rain_mm_tot" DOUBLE,
  "qry_middleton_daily_rain_mm_tot" DOUBLE,
  "qry_otley_daily_rain_mm_tot" DOUBLE,
  "qry_potteryfield_daily_rain_mm_tot" DOUBLE,
  "qry_shadwell_daily_rain_mm_tot" DOUBLE,
  "qry_wetherby_daily_rain_mm_tot" DOUBLE
);

01/05/2018 - 31/05/2018

@ukgov.rain_gauge_rainfall_data.n_01_05_2018_31_05_2018

5.48 KB
31 rows
5 columns


CREATE TABLE n_01_05_2018_31_05_2018 (
  "timestamp_lessone" VARCHAR,
  "qry_allertonbywater_daily_rain_mm_tot" DOUBLE,
  "qry_middleton_daily_rain_mm_tot" DOUBLE,
  "qry_shadwell_daily_rain_mm_tot" DOUBLE,
  "qry_wetherby_daily_rain_mm_tot" DOUBLE
);

01/06/2015 - 30/06/2015

@ukgov.rain_gauge_rainfall_data.n_01_06_2015_30_06_2015

6.66 KB
30 rows
6 columns


CREATE TABLE n_01_06_2015_30_06_2015 (
  "timestamp_lessone" TIMESTAMP,
  "qry_allertonbywater_daily_rain_mm_tot" DOUBLE,
  "qry_middleton_daily_rain_mm_tot" DOUBLE,
  "qry_potteryfield_daily_rain_mm_tot" DOUBLE,
  "qry_shadwell_daily_rain_mm_tot" DOUBLE,
  "qry_wetherby_daily_rain_mm_tot" DOUBLE
);

01/06/2018 - 30/06/2018

@ukgov.rain_gauge_rainfall_data.n_01_06_2018_30_06_2018

5.39 KB
31 rows
5 columns


CREATE TABLE n_01_06_2018_30_06_2018 (
  "timestamp_lessone" VARCHAR,
  "qry_allertonbywater_daily_rain_mm_tot" DOUBLE,
  "qry_middleton_daily_rain_mm_tot" DOUBLE,
  "qry_shadwell_daily_rain_mm_tot" DOUBLE,
  "qry_wetherby_daily_rain_mm_tot" DOUBLE
);

01/07/2014 - 31/07/2014

@ukgov.rain_gauge_rainfall_data.n_01_07_2014_31_07_2014

4.69 KB
31 rows
4 columns


CREATE TABLE n_01_07_2014_31_07_2014 (
  "timestamp_lessone" VARCHAR,
  "qry_allertonbywater_daily_rain_mm_tot" DOUBLE,
  "qry_middleton_daily_rain_mm_tot" DOUBLE,
  "qry_potteryfield_daily_rain_mm_tot" DOUBLE
);

01/07/2015 - 31/07/2015

@ukgov.rain_gauge_rainfall_data.n_01_07_2015_31_07_2015

6.88 KB
31 rows
6 columns


CREATE TABLE n_01_07_2015_31_07_2015 (
  "timestamp_lessone" TIMESTAMP,
  "qry_allertonbywater_daily_rain_mm_tot" DOUBLE,
  "qry_middleton_daily_rain_mm_tot" DOUBLE,
  "qry_potteryfield_daily_rain_mm_tot" DOUBLE,
  "qry_shadwell_daily_rain_mm_tot" DOUBLE,
  "qry_wetherby_daily_rain_mm_tot" DOUBLE
);

01/08/2015 - 31/08/2015

@ukgov.rain_gauge_rainfall_data.n_01_08_2015_31_08_2015

7.7 KB
31 rows
7 columns


CREATE TABLE n_01_08_2015_31_08_2015 (
  "timestamp_lessone" TIMESTAMP,
  "qry_allertonbywater_daily_rain_mm_tot" DOUBLE,
  "qry_middleton_daily_rain_mm_tot" DOUBLE,
  "qry_otley_daily_rain_mm_tot" DOUBLE,
  "qry_potteryfield_daily_rain_mm_tot" DOUBLE,
  "qry_shadwell_daily_rain_mm_tot" DOUBLE,
  "qry_wetherby_daily_rain_mm_tot" DOUBLE
);

01/09/2014 - 30/09/2014

@ukgov.rain_gauge_rainfall_data.n_01_09_2014_30_09_2014

7.33 KB
30 rows
7 columns


CREATE TABLE n_01_09_2014_30_09_2014 (
  "timestamp_lessone" VARCHAR,
  "qry_allertonbywater_daily_rain_mm_tot" DOUBLE,
  "qry_middleton_daily_rain_mm_tot" DOUBLE,
  "qry_otley_daily_rain_mm_tot" DOUBLE,
  "qry_potteryfield_daily_rain_mm_tot" DOUBLE,
  "qry_shadwell_daily_rain_mm_tot" DOUBLE,
  "qry_wetherby_daily_rain_mm_tot" DOUBLE
);

01/09/2016 - 30/09/2016

@ukgov.rain_gauge_rainfall_data.n_01_09_2016_30_09_2016

5.77 KB
30 rows
5 columns


CREATE TABLE n_01_09_2016_30_09_2016 (
  "timestamp_lessone" TIMESTAMP,
  "qry_middleton_daily_rain_mm_tot" DOUBLE,
  "qry_otley_daily_rain_mm_tot" DOUBLE,
  "qry_potteryfield_daily_rain_mm_tot" DOUBLE,
  "qry_shadwell_daily_rain_mm_tot" DOUBLE
);

01/09/2017 - 30/09/2017

@ukgov.rain_gauge_rainfall_data.n_01_09_2017_30_09_2017

4.75 KB
30 rows
4 columns


CREATE TABLE n_01_09_2017_30_09_2017 (
  "timestamp_lessone" VARCHAR,
  "qry_allertonbywater_daily_rain_mm_tot" DOUBLE,
  "qry_otley_daily_rain_mm_tot" DOUBLE,
  "qry_shadwell_daily_rain_mm_tot" DOUBLE
);

01/10/2014 - 31/10/2014

@ukgov.rain_gauge_rainfall_data.n_01_10_2014_31_10_2014

6.65 KB
31 rows
6 columns


CREATE TABLE n_01_10_2014_31_10_2014 (
  "timestamp_lessone" VARCHAR,
  "qry_allertonbywater_daily_rain_mm_tot" DOUBLE,
  "qry_middleton_daily_rain_mm_tot" DOUBLE,
  "qry_otley_daily_rain_mm_tot" DOUBLE,
  "qry_potteryfield_daily_rain_mm_tot" DOUBLE,
  "qry_wetherby_daily_rain_mm_tot" DOUBLE
);

01/10/2015 - 31/10/2015

@ukgov.rain_gauge_rainfall_data.n_01_10_2015_31_10_2015

7.66 KB
31 rows
7 columns


CREATE TABLE n_01_10_2015_31_10_2015 (
  "timestamp_lessone" TIMESTAMP,
  "qry_allertonbywater_daily_rain_mm_tot" DOUBLE,
  "qry_middleton_daily_rain_mm_tot" DOUBLE,
  "qry_otley_daily_rain_mm_tot" DOUBLE,
  "qry_potteryfield_daily_rain_mm_tot" DOUBLE,
  "qry_shadwell_daily_rain_mm_tot" DOUBLE,
  "qry_wetherby_daily_rain_mm_tot" DOUBLE
);

01/10/2016 - 31/10/16

@ukgov.rain_gauge_rainfall_data.n_01_10_2016_31_10_16

6.71 KB
31 rows
6 columns


CREATE TABLE n_01_10_2016_31_10_16 (
  "timestamp_lessone" TIMESTAMP,
  "qry_allertonbywater_daily_rain_mm_tot" DOUBLE,
  "qry_middleton_daily_rain_mm_tot" DOUBLE,
  "qry_otley_daily_rain_mm_tot" DOUBLE,
  "qry_shadwell_daily_rain_mm_tot" DOUBLE,
  "qry_potteryfield_daily_rain_mm_tot" DOUBLE
);