Page 5 of 5 FirstFirst 12345
Results 41 to 50 of 50

Thread: CWGC WW2 Air Forces Database (113000+ / 92.5% Done!) Only 9,200 to go!

  1. #41
    Join Date
    Jan 2008
    Location
    Delaware, USA
    Posts
    1,108
    Thanks
    352
    Thanked 49 Times in 38 Posts

    Default

    Cheers Paul. ATA is completely done!

  2. #42
    Join Date
    Nov 2007
    Posts
    5,189
    Thanks
    9
    Thanked 139 Times in 128 Posts

    Default

    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

  3. #43
    Join Date
    Jan 2008
    Location
    Delaware, USA
    Posts
    1,108
    Thanks
    352
    Thanked 49 Times in 38 Posts

    Default Re: CWGC WW2 Air Forces Database (100000+ Accounted Airmen Data)

    Quote Originally Posted by Jagan View Post
    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!

  4. #44
    Join Date
    Jan 2008
    Location
    Delaware, USA
    Posts
    1,108
    Thanks
    352
    Thanked 49 Times in 38 Posts

    Default Re: CWGC WW2 Air Forces Database (100000+ Accounted Airmen Data)

    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)

  5. The Following User Says Thank You to Jagan For This Useful Post:

    CZ_RAF (28th April 2020)

  6. #45
    Join Date
    Jan 2008
    Location
    Delaware, USA
    Posts
    1,108
    Thanks
    352
    Thanked 49 Times in 38 Posts

    Default Re: CWGC WW2 Air Forces Database (100000+ Accounted Airmen Data)

    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..
    Last edited by Jagan; 6th May 2020 at 02:00.

  7. The Following User Says Thank You to Jagan For This Useful Post:

    PeteS (13th May 2020)

  8. #46
    Join Date
    Oct 2018
    Posts
    4
    Thanks
    0
    Thanked 2 Times in 2 Posts

    Default Re: CWGC WW2 Air Forces Database (110000+ Accounted - 90% Done!)

    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

  9. The Following User Says Thank You to James_Fitzy For This Useful Post:

    Jagan (11th May 2020)

  10. #47
    Join Date
    Jan 2008
    Location
    Delaware, USA
    Posts
    1,108
    Thanks
    352
    Thanked 49 Times in 38 Posts

    Default Re: CWGC WW2 Air Forces Database (110000+ Accounted - 90% Done!)

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

  11. #48
    Join Date
    Jan 2008
    Location
    Delaware, USA
    Posts
    1,108
    Thanks
    352
    Thanked 49 Times in 38 Posts

    Default Re: CWGC WW2 Air Forces Database (110000+ Accounted - 90% Done!)

    ..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"...

  12. #49
    Join Date
    Dec 2007
    Posts
    345
    Thanks
    5
    Thanked 5 Times in 4 Posts

    Default Re: CWGC WW2 Air Forces Database (112000+ / 90% Done!) Only 9,999 to go!

    a SUPERB achievement.

  13. The Following User Says Thank You to PeteS For This Useful Post:

    Jagan (21st May 2020)

  14. #50
    Join Date
    Jan 2008
    Location
    Delaware, USA
    Posts
    1,108
    Thanks
    352
    Thanked 49 Times in 38 Posts

    Default Re: CWGC WW2 Air Forces Database (112000+ / 90% Done!) Only 9,999 to go!

    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



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •