CWGC WW2 Air Forces Database (120633+ / 98.5% Done!) Just 1800 (< 1.5%) to go!

**Steve Brew** · 11th January 2019, 22:41

This is a spectacular database. Thanks very much Jagan.

Not to detract from all your hard work, but I note two errors on my 41 Sqn people, and can certainly add more detail to many. I can also identify which of the '41 Sqdn' entries are actually 41 Sqn SAAF as opposed to RAF. I see the database, but how can I access the page to update the entries for you?

Thanks
Steve

**Jagan** · 14th March 2019, 02:58

Steve,

Sorry I missed your post with the corrections - I can set you up with access to update the database on your own - give me a day to email you the details

regards

Jagan

**Jagan** · 14th March 2019, 03:02

As i keep populating the data (almost done with 1941 entries).. the data can also be used to draw charts.. here is a sample

http://www.rafcommands.com/database/wardead/charts.php

Chart 1 - Month wise fatalities totals for the duration of war
Chart 2 - Aircraft type-wise fatality numbers till 1940
Chart 3 - Aircraft type-wise fatality numbers till 1941
Chart 4 - Aircraft typewrite fatality numbers All available..

(Had to truncate the ac name to 8 characters to give an accurate rendering)

The source for the data

10751 links to AIR81 Records
2486 links to NA AIR27 ORBs
2448 links to current Forum Posts
162 archived forum posts
1516 External http URLs

**Jagan** · 20th April 2019, 18:24

Current Status - 20% of the Data is "Accounted for"

Your current query returns 122357 records,of which 24728 records (20.21%) have circumstances of death.

**Jagan** · 24th April 2019, 01:35

Ran an major update - A majority of Bomber Command serials have been updated . About 2800 records short of 50%

Current query returns 122357 records,of which 58380 records (47.71%) have circumstances of death.

Year	1939	1940	1941	1942	1943	1944	1945	1946	1947
Total Records	689	6887	13016	21391	29783	33059	13730	2383	1419
Accounted	667	6358	11015	7263	12986	15778	4085	59	173
Unaccounted	22	529	2001	14128	16797	17281	9645	2324	1246

Deaths by Aircraft Type

Lancaster (34.1), Wellington (15.6), Halifax (14.9), Blenheim and Stirling (5.5 each) in the order.. no doubt the chart will change as the data gets populated with other commands...

Additional Charts (Query-able by Year) at http://www.rafcommands.com/database/...rts.php?qyear=

**Jagan** · 1st May 2019, 23:59

Over the hill! - more than half the CWGC records are now 'accounted for' .

Of the 122357 records, 67203 records (54.92%) have circumstances of death. 55154 records (45.08%) do not have details.

**Jagan** · 18th May 2019, 20:09

**Jagan** · 27th May 2019, 17:44

A milestone - 70K records

70007 records (57.22%) have some details on circumstances of death.

Used a tiny bit of Alex Smart's data from the Coastal Commands thread to get the records in for 210 and 202 Sqdns.. this took it beyond 70K

52350 records (42.78%) to go!

**Jagan** · 10th August 2019, 22:40

60% Coverage of all CWGC airmen
Your current query returns 122357 records,
73460 records (60.04%) have circumstances of death.
48897 records (39.96%) do not have details.

thanks to Malcolm's rafweb website that i used on 1945 entries..

**Jagan** · 19th September 2019, 03:53

The CWGC Database is enhanced a bit more.. Now in the search results, the Surname is a hyper link - and clicking it will take you to an individual casualty page that will have additional details - eg - a search of the Gazette, and even a rough search of the forum for additional posts..

An example page http://www.rafcommands.com/database/...php?qnum=33508 (J B NICOLSON VC)