About this Dataset

Average Rainfall And Temperature

Average Rainfall (mm) and average Temperature (centigrade) for the North East England and East England Met Office Climate district, which includes Lincolnshire. This dataset shows the average Rainfall in millimetres and average Temperature in centigrade, by month, meteorological season, and annual calendar year. The data is sourced from the UK Met Office website. See the Source link for more information about the data and the area it covers.
Publisher name: Lincolnshire County Council
Last updated: 2025-03-13T04:00:02Z

Tables

Average Rainfall And Temperature

@ukgov.average_rainfall_temperature.average_rainfall_and_temperature

15.79 kB
255 rows
12 columns

CREATE TABLE average_rainfall_and_temperature (
  "organisationname" VARCHAR,
  "organisationcode" VARCHAR,
  "publisheddate" TIMESTAMP,
  "durationfrom" TIMESTAMP,
  "durationto" TIMESTAMP,
  "latestdata" VARCHAR,
  "geoname" VARCHAR,
  "reportingperiodtype" VARCHAR,
  "year" BIGINT,
  "period" VARCHAR,
  "rainfall_mm" DOUBLE,
  "temperature_c" DOUBLE
);

Table 2

@ukgov.average_rainfall_temperature.table_2

11.4 kB
12 rows
12 columns

CREATE TABLE table_2 (
  "dataset_id_dsid" BIGINT  -- Dataset ID (DSID),
  "dataset_name" VARCHAR,
  "field" VARCHAR,
  "type" VARCHAR,
  "mandatory_or_optional_requirement_mor" VARCHAR  -- Mandatory Or Optional Requirement (MOR),
  "field_description" VARCHAR,
  "schema" VARCHAR,
  "lcc_mapping" VARCHAR,
  "schema_comments" VARCHAR,
  "schema_data_rules_comment" VARCHAR,
  "formatreference" VARCHAR,
  "example" VARCHAR
);