CWGC WW2 Air Forces Database (114400+ / 93.89% Done!) Less than 7,500 to go!

[Jagan]

Cheers Paul. ATA is completely done!

[paulmcmillan]

Jagan

Don't think link working


Should be

http://www.raf-lichfield.co.uk/ATA%20Casualties.htm

not

http://www.raf-lichfield.co.uk/ATA%2020Casualties.htm

[Jagan]

I finished the first pass of linking all the forum posts that i could find to the database.
103779 records (84.82%) have circumstances of death.
18578 records (15.18%) are still unaccounted

Among other news - the number of unaccounted has dipped below 15000 ...

107374 records (87.75%) have circumstances of death.
..14983 records (12.25%) do not have details.

Next Milestone 12236 to get us below the 10% mark (2747 records away)And getting us below 10000 after that..

I wonder how many years that will take!

[Jagan]

Your current query terms returns 122357 records,
109000 records (89.08%) have circumstances of death.
13357 records (10.92%) do not have details.

Within spitting distance of 110,000 and 90% (1125 records away)

[Jagan]

Your current query terms returns 122357 records,
110130 records (90.01%) have circumstances of death.
12227 records (9.99%) do not have details.


And finally - the number of unaccounted airmen dips below 10%..
Next milestone - get the unaccounted to drop below 10,000 .. into 9999! thats 2228 records away

And probably at that point we will hit a wall.. where we can make absolutely no progress. but that point is still some distance away.. there are far more entries that i know can be traced down .. we haven't even got to the 1944,45 threads yet.

Year	1939	1940	1941	1942	1943	1944	1945	1946	1947
Total Records	689	6887	13016	21390	29783	33061	13727	2385	1419
Accounted	675 (97.97%)	6460 (93.80%)	12228 (93.95%)	19803 (92.58%)	27805 (93.36%)	30074 (90.97%)	10923 (79.57%)	1374 (57.61%)	790 (55.67%)
Unaccounted	14 (2.03%)	427 (6.20%)	788 (6.05%)	1587 (7.42%)	1978 (6.64%)	2987 (9.03%)	2804 (20.43%)	1011 (42.39%)	629 (44.33%)

I am assuming that wall we will hit will come around when we have 8-9000 records left or so..

[James_Fitzy]

Apologies for the amateur question, but how can I report/amend an error in the database?

The crew of Wellington Mk IV Z1218 are erroneously listed under "Z6298?" : http://www.rafcommands.com/database/...hp?uniq=Z6298?

Elsewhere the database has an entry for Z1218 with the correct AIR81 file merged in: http://www.rafcommands.com/database/...php?uniq=Z1218

The 2nd link also has the incorrect date of crash by 1 day, the aircraft crashed on 20/10/1941 rather than the 21/10/1941.

Apologies if I've missed an obvious button or function to suggest corrections

[Jagan]

James, no worries - this thread is perfectly fine for the corrections. making the correction now.

[Jagan]

..and..... the number of unaccounted airmen falls BELOW 10,000

9,997 records are unaccounted..

(Thats 8.17%)

Okay, there was a little bit of cheating involved, about 200-225 records from Singapore /SEAC around Feb 15,16,17 have been added as "Probably Killed during the Battle and Surrender of Singapore"...

[PeteS]

a SUPERB achievement.

[Jagan]

Couple of Tables for Interest...

Numbers By Region

Region	Total Casualties	Unaccounted
Africa	2480	762 (30.73%)
Africa - North	6759	1029 (15.22%)
Americas	4379	124 (2.83%)
Europe	89462	5301 (5.93%)
Mediterranean	6089	683 (11.22%)
Middle East	435	243 (55.86%)
Pacific	4587	73 (1.59%)
SEAC	8166	1777 (21.76%)

Numbers By Force

Force	Total Casualties	Unaccounted
Royal Air Force Volunteer Reserve	67277	6331 (9.41%)
Royal Canadian Air Force	17355	84 (0.48%)
Royal Air Force	15275	1546 (10.12%)
Royal Australian Air Force	11071	20 (0.18%)
Royal New Zealand Air Force	3778	36 (0.95%)
South African Air Force	2666	376 (14.10%)
Polish Air Force	1462	90 (6.16%)
Royal Indian Air Force	897	628 (70.01%)
Royal Air Force (Auxiliary Air Force)	787	160 (20.33%)
Women's Auxiliary Air Force	731	384 (52.53%)
Air Transport Auxiliary	165	(0.00%)
R.A.F. Iraq Levies	144	135 (93.75%)
Royal Air Force (RAFO)	116	8 (6.90%)
Royal Air Force Ferry Command	109	2 (1.83%)
Rhodesia Air Askari Corps	73	59 (80.82%)
Women's Auxiliary Australian Air Force	59	1 (1.69%)
Royal Netherlands Navy Air Service	59	3 (5.08%)
Greek Air Force	51	39 (76.47%)
Royal Canadian Air Force (Women's Division)	39	(0.00%)
Women's Auxiliary Air Force (S.A.A.F.)	39	37 (94.87%)
Netherlands Air Force	37	2 (5.41%)
Royal Air Force Transport Command	32	(0.00%)
U.S. Army Air Forces	30	(0.00%)
West African Air Corps	28	28 (100.00%)
Norwegian Air Force	15	(0.00%)
Malayan Volunteer Air Force	13	4 (30.77%)
New Zealand Women's Auxiliary Air Force	10	(0.00%)
Burma Volunteer Air Force	8	6 (75.00%)
Princess Mary's R.A.F. Nursing Service	7	4 (57.14%)
Southern Rhodesia Air Force	7	2 (28.57%)
Italian Air Force	6	4 (66.67%)
Southern Rhodesia Women's Auxiliary Air Service	5	3 (60.00%)
Royal Australian Air Force Nursing Service	4	(0.00%)
Belgian Air Force	2	(0.00%)

Year	1939	1940	1941	1942	1943	1944	1945	1946	1947
Total Records	689	6887	13016	21390	29783	33061	13727	2385	1419
Accounted	676 (98.11%)	6564 (95.31%)	12328 (94.71%)	20104 (93.99%)	28206 (94.71%)	30762 (93.05%)	11526 (83.97%)	1392 (58.36%)	807 (56.87%)
Unaccounted	13 (1.89%)	323 (4.69%)	688 (5.29%)	1286 (6.01%)	1577 (5.29%)	2299 (6.95%)	2201 (16.03%)	993 (41.64%)	612 (43.13%)

This link has the tables updating in real time... http://www.rafcommands.com/database/wardead/charts.php