Dataset: Average Rainfall And Temperature

Dataset for Average Rainfall and Temperature

organisationname OrganisationName	organisationcode OrganisationCode	publisheddate PublishedDate	durationfrom DurationFrom	durationto DurationTo	geoname GeoName	reportingperiodtype ReportingPeriodType	year Year	period Period	rainfall_mm Rainfall Mm	temperature_c Temperature C
Lincolnshire	http://opendatacommunities.org/id/county-council/lincolnshire	Thu Feb 27 2025 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Jan 01 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun Jan 31 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	England E & NE	Month	2010	JAN	69.5	0.8
Lincolnshire	http://opendatacommunities.org/id/county-council/lincolnshire	Thu Feb 27 2025 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Feb 01 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun Feb 28 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	England E & NE	Month	2010	FEB	71.7	1.6
Lincolnshire	http://opendatacommunities.org/id/county-council/lincolnshire	Thu Feb 27 2025 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Mar 01 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Mar 31 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	England E & NE	Month	2010	MAR	65.1	5.5
Lincolnshire	http://opendatacommunities.org/id/county-council/lincolnshire	Thu Feb 27 2025 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Apr 01 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Apr 30 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	England E & NE	Month	2010	APR	21.4	8.2
Lincolnshire	http://opendatacommunities.org/id/county-council/lincolnshire	Thu Feb 27 2025 00:00:00 GMT+0000 (Coordinated Universal Time)	Sat May 01 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon May 31 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	England E & NE	Month	2010	MAY	22.1	9.8
Lincolnshire	http://opendatacommunities.org/id/county-council/lincolnshire	Thu Feb 27 2025 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Jun 01 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Jun 30 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	England E & NE	Month	2010	JUN	42.7	14.3
Lincolnshire	http://opendatacommunities.org/id/county-council/lincolnshire	Thu Feb 27 2025 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Jul 01 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	Sat Jul 31 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	England E & NE	Month	2010	JUL	61.1	16.4
Lincolnshire	http://opendatacommunities.org/id/county-council/lincolnshire	Thu Feb 27 2025 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun Aug 01 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Aug 31 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	England E & NE	Month	2010	AUG	76.6	14.6
Lincolnshire	http://opendatacommunities.org/id/county-council/lincolnshire	Thu Feb 27 2025 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Sep 01 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Sep 30 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	England E & NE	Month	2010	SEP	83.9	13.4
Lincolnshire	http://opendatacommunities.org/id/county-council/lincolnshire	Thu Feb 27 2025 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Oct 01 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun Oct 31 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	England E & NE	Month	2010	OCT	65	9.6

organisationname

OrganisationName

organisationcode

OrganisationCode

publisheddate

PublishedDate

durationfrom

DurationFrom

durationto

DurationTo

latestdata

LatestData

geoname

GeoName

reportingperiodtype

ReportingPeriodType

year

Year

period

Period

rainfall_mm

Rainfall Mm

temperature_c

Temperature C

Lincolnshire

http://opendatacommunities.org/id/county-council/lincolnshire

Thu Feb 27 2025 00:00:00 GMT+0000 (Coordinated Universal Time)

Fri Jan 01 2010 00:00:00 GMT+0000 (Coordinated Universal Time)

Sun Jan 31 2010 00:00:00 GMT+0000 (Coordinated Universal Time)

England E & NE

Month

2010

JAN

69.5

0.8

Lincolnshire

http://opendatacommunities.org/id/county-council/lincolnshire

Thu Feb 27 2025 00:00:00 GMT+0000 (Coordinated Universal Time)

Mon Feb 01 2010 00:00:00 GMT+0000 (Coordinated Universal Time)

Sun Feb 28 2010 00:00:00 GMT+0000 (Coordinated Universal Time)

England E & NE

Month

2010

FEB

71.7

1.6

Lincolnshire

http://opendatacommunities.org/id/county-council/lincolnshire

Thu Feb 27 2025 00:00:00 GMT+0000 (Coordinated Universal Time)

Mon Mar 01 2010 00:00:00 GMT+0000 (Coordinated Universal Time)

Wed Mar 31 2010 00:00:00 GMT+0000 (Coordinated Universal Time)

England E & NE

Month

2010

MAR

65.1

5.5

Lincolnshire

http://opendatacommunities.org/id/county-council/lincolnshire

Thu Feb 27 2025 00:00:00 GMT+0000 (Coordinated Universal Time)

Thu Apr 01 2010 00:00:00 GMT+0000 (Coordinated Universal Time)

Fri Apr 30 2010 00:00:00 GMT+0000 (Coordinated Universal Time)

England E & NE

Month

2010

APR

21.4

8.2

Lincolnshire

http://opendatacommunities.org/id/county-council/lincolnshire

Thu Feb 27 2025 00:00:00 GMT+0000 (Coordinated Universal Time)

Sat May 01 2010 00:00:00 GMT+0000 (Coordinated Universal Time)

Mon May 31 2010 00:00:00 GMT+0000 (Coordinated Universal Time)

England E & NE

Month

2010

MAY

22.1

9.8

Lincolnshire

http://opendatacommunities.org/id/county-council/lincolnshire

Thu Feb 27 2025 00:00:00 GMT+0000 (Coordinated Universal Time)

Tue Jun 01 2010 00:00:00 GMT+0000 (Coordinated Universal Time)

Wed Jun 30 2010 00:00:00 GMT+0000 (Coordinated Universal Time)

England E & NE

Month

2010

JUN

42.7

14.3

Lincolnshire

http://opendatacommunities.org/id/county-council/lincolnshire

Thu Feb 27 2025 00:00:00 GMT+0000 (Coordinated Universal Time)

Thu Jul 01 2010 00:00:00 GMT+0000 (Coordinated Universal Time)

Sat Jul 31 2010 00:00:00 GMT+0000 (Coordinated Universal Time)

England E & NE

Month

2010

JUL

61.1

16.4

Lincolnshire

http://opendatacommunities.org/id/county-council/lincolnshire

Thu Feb 27 2025 00:00:00 GMT+0000 (Coordinated Universal Time)

Sun Aug 01 2010 00:00:00 GMT+0000 (Coordinated Universal Time)

Tue Aug 31 2010 00:00:00 GMT+0000 (Coordinated Universal Time)

England E & NE

Month

2010

AUG

76.6

14.6

Lincolnshire

http://opendatacommunities.org/id/county-council/lincolnshire

Thu Feb 27 2025 00:00:00 GMT+0000 (Coordinated Universal Time)

Wed Sep 01 2010 00:00:00 GMT+0000 (Coordinated Universal Time)

Thu Sep 30 2010 00:00:00 GMT+0000 (Coordinated Universal Time)

England E & NE

Month

2010

SEP

83.9

13.4

Lincolnshire

http://opendatacommunities.org/id/county-council/lincolnshire

Thu Feb 27 2025 00:00:00 GMT+0000 (Coordinated Universal Time)

Fri Oct 01 2010 00:00:00 GMT+0000 (Coordinated Universal Time)

Sun Oct 31 2010 00:00:00 GMT+0000 (Coordinated Universal Time)

England E & NE

Month

2010

OCT

9.6

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 );

Average Rainfall And Temperature

Table List

Average Rainfall And Temperature

@ukgov.average_rainfall_temperature.average_rainfall_and_temperature

organisationname

organisationcode

publisheddate

durationfrom

durationto

latestdata

geoname

reportingperiodtype

year

period

rainfall_mm

temperature_c

Share link