War Memorials

Leeds City Council

@ukgov.war_memorials

Table List

1 table(16.37 KB)

2015

@ukgov.war_memorials.n_2015

War Memorial locations

16.37 KB
55 rows
14 columns

extractdate ExtractDate	organisationuri OrganisationURI	organisationlabel OrganisationLabel	servicetypeuri ServiceTypeURI	servicetypelabel ServiceTypeLabel	address_line_1 Address Line 1	address_line_2 Address Line 2	address_line_3 Address Line 3	post_code Post Code	ward Ward	ons_stats ONS Stats	latitude Latitude	longitude Longitude	descriptor Descriptor
Thu Dec 11 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	http://opendatacommunities.org/id/metropolitan-district-council/leeds	Leeds	http://id.esd.org.uk/service/849	Memorial provision and maintenance	Main Street	Aberford	Leeds	LS25 3AA	Harewood	http://statistics.data.gov.uk/id/statistical-geography/E05001426	53.828826	-1.343036	Opposite Almshouses, Main Street
Thu Dec 11 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	http://opendatacommunities.org/id/metropolitan-district-council/leeds	Leeds	http://id.esd.org.uk/service/849	Memorial provision and maintenance	Station Road	Allerton Bywater	Castleford	WF10 2DL	Kippax and Methley	http://statistics.data.gov.uk/id/statistical-geography/E05001431	53.745412	-1.368055	Opposite Church Main street, Station Road
Thu Dec 11 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	http://opendatacommunities.org/id/metropolitan-district-council/leeds	Leeds	http://id.esd.org.uk/service/849	Memorial provision and maintenance	Armley Park	Stanningley Road	Armley	LS12 3LW	Armley	http://statistics.data.gov.uk/id/statistical-geography/E05001414	53.79984	-1.592996	Armley Park
Thu Dec 11 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	http://opendatacommunities.org/id/metropolitan-district-council/leeds	Leeds	http://id.esd.org.uk/service/849	Memorial provision and maintenance	Main Street	Barwick in Elmet	Leeds	LS15 4JQ	Harewood	http://statistics.data.gov.uk/id/statistical-geography/E05001426	53.831776	-1.393912	By the Maypole
Thu Dec 11 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	http://opendatacommunities.org/id/metropolitan-district-council/leeds	Leeds	http://id.esd.org.uk/service/849	Memorial provision and maintenance	Leeds Cemetery	Beckett Street	Leeds	LS9 7AA	Burmantofts and Richmond Hill	http://statistics.data.gov.uk/id/statistical-geography/E05001417	53.807861	-1.5168	In the Cemetery
Thu Dec 11 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	http://opendatacommunities.org/id/metropolitan-district-council/leeds	Leeds	http://id.esd.org.uk/service/849	Memorial provision and maintenance	Beeston Cemetary	Beeston Road	Leeds	LS11 6AW	City and Hunslet	http://statistics.data.gov.uk/id/statistical-geography/E05001420	53.777276	-1.558621	In the Cemetery
Thu Dec 11 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	http://opendatacommunities.org/id/metropolitan-district-council/leeds	Leeds	http://id.esd.org.uk/service/849	Memorial provision and maintenance	St Peters Court, Dewsbury Road	Beeston	Leeds	LS11 5NR	City and Hunslet	http://statistics.data.gov.uk/id/statistical-geography/E05001420	53.780953	-1.54433	Bottom of Dewsbury Road
Thu Dec 11 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	http://opendatacommunities.org/id/metropolitan-district-council/leeds	Leeds	http://id.esd.org.uk/service/849	Memorial provision and maintenance	High Street	Boston Spa	Leeds	LS23 6AA	Wetherby	http://statistics.data.gov.uk/id/statistical-geography/E05001443	53.903795	-1.343594	High Street
Thu Dec 11 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	http://opendatacommunities.org/id/metropolitan-district-council/leeds	Leeds	http://id.esd.org.uk/service/849	Memorial provision and maintenance	Front Street and Bowcliffe Road Junction	Bramham	Leeds	LS23 6QU	Wetherby	http://statistics.data.gov.uk/id/statistical-geography/E05001443	53.880388	-1.355267	Middle of junction with Front Street & Low Way
Thu Dec 11 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	http://opendatacommunities.org/id/metropolitan-district-council/leeds	Leeds	http://id.esd.org.uk/service/849	Memorial provision and maintenance	Calverley Victoria Park	Carr Road	Calverley	LS28 5NF	Calverley and Farsley	http://statistics.data.gov.uk/id/statistical-geography/E05001418	53.829522	-1.690307	Victoria Park opposite Methodist Church


CREATE TABLE n_2015 (
  "extractdate" TIMESTAMP,
  "organisationuri" VARCHAR,
  "organisationlabel" VARCHAR,
  "servicetypeuri" VARCHAR,
  "servicetypelabel" VARCHAR,
  "address_line_1" VARCHAR,
  "address_line_2" VARCHAR,
  "address_line_3" VARCHAR,
  "post_code" VARCHAR,
  "ward" VARCHAR,
  "ons_stats" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "descriptor" VARCHAR
);