RAF Awards Database (04 July 2021: M-in-D Update)

[Jagan]

Hugh Halliday has quite a few threads in this section with Awards to the RAF - Pretty much everything other than DFC and DFMs are listed I guess. with the most complete DSO Listing in one of the old archive forums.

I have taken a liberty to process these lists into my now standard database format.. the DB is now available at http://www.rafcommands.com/database/awards/

Ofcourse its not complete (With exception of DSOs). but it tells us the possibilities that can happen

(Full Credits to Hugh for publishing these lists)

If there are other data lists out there that can be shared - please do let me know

Thank you



--------------------------
Current State - 14 November 2020

There are a total of 72173 Awards

Numbers Awarded

VC : 30	GC : 27	GBE(M) : 4	KBE(M) : 44	DBE(M) : 3	CBE(M) : 548	DSO : 1222	OBE(M) : 1422	MBE(M) : 2338
DFC : 20927	MC : 85	AFC : 2481	CGM(F) : 107	BEM(M) : 2320	DFM : 6484	MM : 131	AFM : 292	MiD : 33708

While most data is uploaded BEM(M) Citations where available are still Work-in-Progress

[CZ_RAF]

Hi Jagan, thank you it is great idea!
I have checked the DB and to my surprise I have found there also Czech awards.
I think there is one thing we should correct - Czech Gallantry Medal was the official name and there was no other medal like Czech Medal for valour which I suppose is Czech MV.
So Czech MG = Czech MV and should be listed as Czech MG.
There are some more details in my 311 Sq book which I can provide and also there is a special TNA file for Czech awards to allied AF members which can be added into this DB.

Pavel

[Jagan]

I just used Hugh's lists that exist on the forum. i will fix the award designation.

A quick check against wikipedia gives me the following numbers. Dont have the CBE/OBE/MBE numbers. Or the foreign awards like the French, US , Polish and Czech. Are there any other awards that should be tracked? . Overall there may be over 50,000 awards, service numbers and citations to be tracked. I am sure the M-in-Ds will be tens of thousands as well?. The current DB has just over 8000 names i there...

Numbers Awarded	Total
VC	26
GC	18
DSO	1,317
DFC	23,251
DFM CGM ?	6,890
AFC	2,881
AFM	472
KBE CBE
OBE
MBE BEM M-in-D
Total	34,855

[Jagan]

Way back in 2001, Hugh Halliday had published a list of RAF and Commonwealth DSO Awardee list http://www.rafcommands.com/archive/00013.php . Taking that as a basis, with contributions from Malcolm Barrass and self, the list has been revised, cross-checked against the gazettes and loaded with Citations and links.
http://www.rafcommands.com/database/...php?qaward=DSO

Hugh’s list has been increased by an additional four awards, and citations and links to the original gazette notifications provided.
There are 1223 DSO Awards in the Database. 22 are pre WW2, and 18 Post WW2. Of the remaining 1182 awards, 504 have been gazetted without citations (they appear with “Notification Only” in the citation box). The rest have some form of a citation available. Only about a dozen or so awardee names, bulk of them Army Aviation Corps related do not have the linked information .
Feedback welcome

[jonny]

Well done on all the hard work chaps. Are you amenable to folk posting the missing DSO recs on this thread?

Rgds

Jonny

[Jagan]

Jonny,

since then all other gaps have been filled - thanks to Malcolm



For Hugh - These four were missing from the original list.

DSO 82140 RAFVR Flt Lt Alfred Philip Frank SCHNEIDAU 1943-05-25
DSO 82948 RAFVR Sqn Ldr Anthony SPOONER 1944-04-04
DSO 158240 RAFVR Fg Offr Nicoll Ramsay ROSS 1944-08-29
DSO 40586 RAF Wg Cdr Charles Vivian WINN 1945-07-03

[paulmcmillan]

Captain Walter Fraser Anderson DSO, DFC

https://en.wikipedia.org/wiki/Walter...er,_died_1936)

Also John MITCHELL

DSO for the incident listed

The London Gazette Supplement: 31847

"Anderson and Mitchell were to be nominated for the Victoria Cross, but supporting documentation was lost during the evacuation from Russia.[5] Instead of the Victoria Cross, the two received the Distinguished Service Order and later the Distinguished Flying Cross for their actions.[2]"

[PeteT]

If you are planning to add the citations for the other awards, please let me know as I have quite a few "35 Squadron" related citations and recommendations which I have obtained during my research

Regards

Pete

[COL BRUGGY]

Captain Walter Fraser Anderson DSO, DFC

https://en.wikipedia.org/wiki/Walter...er,_died_1936)

Also John MITCHELL

DSO for the incident listed

The London Gazette Supplement: 31847

"Anderson and Mitchell were to be nominated for the Victoria Cross, but supporting documentation was lost during the evacuation from Russia.[5] Instead of the Victoria Cross, the two received the Distinguished Service Order and later the Distinguished Flying Cross for their actions.[2]"

Hello,

15.9.36.

DH.86A G-ADYF, British Airways.
Crashed after night take-off, Gatwick (on the night mail service to Hamburg).
Flt Lt Walter Fraser Anderson DSO DFC (Ret) (46) killed
David Slack (21) killed (engineer)
John Jackson (28) killed (wireless operator)
Dudley Scorgie injured (second officer).

http://www.rcawsey.co.uk/Acc1937.htm

Col.

[Jagan]

If you are planning to add the citations for the other awards, please let me know as I have quite a few "35 Squadron" related citations and recommendations which I have obtained during my researchc

Pete, sent you the link to the spreadsheet on google that you can directly edit . Alternatively you can email me the info at jaganpvs AT hotmail DOT com