Roll of Honour - data sheet

A Roll of Honour may refer to any list of people who are praised officially for something they have done. It more usually refers to a list of names of people who have died in the military or other services. Most places have a military Roll of Honour in some format for the Great War and the 1939-45 War.
Most families throughout the UK suffered the loss of close family relatives in the Great War of 1914 -18. It appears that barely a family or community across the UK escaped World War I untouched, except that is for the “Thankful Villages”. Losing one family member must have been truly devastating but try to image the grief of the Rissington family in Gloucestershire who lost five sons. The term “Thankful Villages” was first used by the British writer and journalist Arthur Mee in his King’s England, a guide to the counties of England in the 1930s. A Thankful Village was said to be one which lost no men in the Great War as all those who had left to serve ‘King and Country’ came home again. For instance, in Yorkshire East Riding he writes about Catwick, “Thirty men went from Catwick to the Great War and thirty came back, though one left an arm behind.” Incredibly, Arkholme in Lancashire saw 59 of their sons go to war and all returned. It was also suggested that such villages had no war memorials, although some had monuments, usually in the church, in gratitude for their good fortune. Recent and ongoing research has identified 41 parishes throughout England and Wales from which all soldiers returned.
Further information:

Records found = 21 from 124504
ID	Name	Died	Notes
50954	YOUNGMAN Robert	11.06.1915	1st Btn, Norfolk Regiment; Private; died 11.06.1915 aged 24
50955	CODLING Harry	20.08.1915	1st/4th Btn, Norfolk Regiment; Private; died 20.08.1915 aged 18
50956	HANNENT Cecil Twite	05.07.1916	8th Btn, Border Regiment; Private; died 05.07.1916 aged 35
50957	LARTER Joseph Alfred	15.09.1916	9th Btn, Norfolk Regiment; Private; died 15.09.1916 aged 28
50958	PETT Harry Percival	15.09.1916	9th Btn, Norfolk Regiment; L/Corporal; died 15.09.1916 aged 23
50959	CLARKE Alfred	26.09.1916	Canadian Corps Cavalry Regiment; Private; died 26.09.1916 aged 22
50960	PEARCE Samuel Albert	21.10.1916	11th Btn, Royal Sussex Regiment; Corporal; died 21.10.1916 aged 29
50961	CHENEY Charles William	13.12.1916	1st Btn, The Buffs, East Kent Regiment; Private; died 13.12.1916 aged 26
50962	GOODWIN James Frederick	26.01.1917	10th Btn, Essex Regiment; Private; died 26.01.1917 aged 25
50963	YOUNGMAN William	19.04.1917	1st/4th Btn, Norfolk Regiment; Private; died 19.04.1917 aged 28
50964	MAYHEW Harry Geroge	23.04.1917	1st Btn, Norfolk Regiment; Private; died 23.04.1917 aged 27
50965	CLARKE Benjamin	14.05.1917	1st Btn, Norfolk Regiment; Private; died 14.05.1917 aged 29
50966	HEWGILL John	30.08.1917	1st Btn, Grenadier Guards;p Private; died 30.08.1917 aged 34
50967	RANDELL Cecil Jesse	22.10.1917	8th Btn, Norfolk Regiment; Private; died 22.10.1917 aged 30
50968	WICKS Leonard	22.10.1917	8th Btn, Norfolk Regiment; Private; died 22.10.1917 aged 30
50969	LANE William Britton	20.12.1917	5th Btn, King??�s Shropshire Light Infantry; L/Sergeant; died 20.12.1917 aged 22
50970	FLINT George Robert	11.09.1918	12th Btn, Norfolk Regiment; Sergeant; died 11.09.1918 aged 26
50971	HARWOOD Harry Thomas	23.04.1941	5th Btn, Royal Norfolk Regiment; Private; died 23.04.1941 aged 22
50972	FELLOWS Robert	10.03.1915	1st Btn, King??�s Royal Rifle Corps; 2nd Lieut.; died 10.03.1915 aged 18
50973	NORTON John Bosworth	27.03.1943	Royal Navy; Leading Signalman; died 27.03.1943 aged 23
50974	SUTTON John Hedworth	01.03.1945	Royal Naval Volunteer Reserve; Sub-Lieut; died 01.03.1945 aged 20
SQL: " SELECT * FROM Complete WHERE ParishCode='SHOT' AND EventType = 'RoH' ORDER BY ID"