Introduction to the 2nd NZEF Spreadsheet

 

“Many of the names on the database are not on war memorials. But they have been immortalised, thanks to Dale”.

Craig Cooper, Editor, Northern Advocate.

 

DEDICATIONdedication image

This website’s official launch was timed to coincide with the 2015 Battle of Gallipoli Centennial.

The Freedom’s Call 2nd N.Z.E.F. database spreadsheet was compiled by Dale Calder, over the ten year period between 2006 and 2016. As further information comes to hand so it will be updated. That said it is now all but complete.

What you can expect to find here: 

* At your fingertips, a massive, comprehensive spreadsheet of 2nd N.Z.E.F. soldiers and war nurses listed in the Nominal Rolls, deployed overseas during World War II and with J-Force; having identity in some way with Northland, New Zealand. 

‘Northland’ refers “to that area, extending from the North Cape down to Port Albert and across to Wellsford and Great Barrier Island“.

* Interesting and useful  supporting information, with links to relevant websites, where a wealth of further information is available.

Lay genealogists and Whakapapa researchers or anyone with an interest in the military history of Northland will find this an indispensable research tool. 

I set myself the following parameters.  The servicemen and women had to meet any one or more of the following criteria as regards the region. They

Kaye, George Frederick, 1914-2004. New Zealand soldier at the Cassino battlefront, Italy, during manoeuvres, World War 2. New Zealand. Department of Internal Affairs. War History Branch :Photographs relating to World War 1914-1918, World War 1939-1945, occupation of Japan, Korean War, and Malayan Emergency. Ref: DA-05513-F. Alexander Turnbull Library, Wellington, New Zealand. http://natlib.govt.nz/records/23060524. “Permission of the Alexander Turnbull Library, Wellington, New Zealand, must be obtained before any re-use of this image.”

Kaye, George Frederick, 1914-2004. New Zealand soldier at the Cassino battlefront, Italy, during manoeuvres, World War 2. New Zealand. Department of Internal Affairs. War History Branch :Photographs relating to World War 1914-1918, World War 1939-1945, occupation of Japan, Korean War, and Malayan Emergency. Ref: DA-05513-F. Alexander Turnbull Library, Wellington, New Zealand. http://natlib.govt.nz/records/23060524.
“Permission of the Alexander Turnbull Library, Wellington, New Zealand, must be obtained before any re-use of this image.”

– enlisted there 

– lived there when enlisting

– had next of kin residing there

+this including some whose association may have been tenuous to say the least, who may just have been passing through when deciding to enlist.

I am confident that I have met that brief.

As time has progressed and more information has come to light online, I have added some other entries where I have ascertained that the person:

 – was born there

– died post war there

 – was laid to rest in this area of Northland

 – was memorialised there

 – was otherwise known to have lived, worked, trained or studied there before enlisting.

That said, there will be many others meeting these last five criteria who have not been listed. Those I have managed to include should be regarded as ‘bonus entries.’

There will likely be many who moved into the region after the war who had no identity with it, at time of embarkation. A case can be argued for their inclusion , but no practical method exists to find out just who these people are. Some names might be picked up from obituary notices or gravestones, but where to start? Naturally, if I am alerted to someone in this category, then I will ensure that they are included on the database. You will see I have included the names of a few people I personally knew, who lived in the area for some years post-war.

With all that said, I have painstakingly sifted through copious records to ensure a very complete and largely accurate account is provided, so as to meet my original self imposed brief.

Where you will find this information:

The 2nd N.Z.E.F. Freedom’s Call downloadable spreadsheet containing 6,813 lines of data, pertaining to over 5,800 servicemen and women is your primary resource.

Before undertaking any research, I strongly recommend you download the Quickstart guide. It is just 7 pages long, but you will find it of great assistance.

At the foot of the roll are a further 4 entries – one for a civilian NZ Coastwatcher executed by the Japanese and posthumously awarded the honorary rank of Corporal, one not on the roll but killed in the course of training for overseas service and two whose gravestones showed they served in the N.Z.E.F. but whom I could not find on the rolls. One whose family had stated (per the Cenotaph record) he had served with the N.Z.E.F. has not been entered, as he was not on the rolls. He apparently served in the army and also in the navy. He is to be found on the Other Forces spreadsheet .

The ‘Lest We Forget‘ roll is also downloadable. This lists 588 personnel taken from the roll who were killed or who otherwise died in the course of service. This includes the two personnel killed, mentioned in the last paragraph. Note: There are are some names of personnel, who are listed on the main roll, also listed on the CWGC site who died post WWII in New Zealand and who did not serve with J-Force. I noted one who’d died in 1946. They are NOT included on this roll. 

Individual rolls are also available for each embarkation. The lists on these rolls do NOT contain all the information to be found on the main spreadsheet. You should also note that to assist with your research these lists also include married names and other known aliases as they are separately listed on the main spreadsheet, such information of course not being on the nominal rolls.

Lodge, Nevile Sidney, 1918-1989. Security poster in a series drawn by Nevile Lodge in World War II. New Zealand. Department of Internal Affairs. War History Branch :Photographs relating to World War 1914-1918, World War 1939-1945, occupation of Japan, Korean War, and Malayan Emergency. Ref: DA-01984-F. Alexander Turnbull Library, Wellington, New Zealand. http://natlib.govt.nz/records/23191306 “Permission of the Alexander Turnbull Library, Wellington, New Zealand, must be obtained before any re-use of this image.”

Lodge, Nevile Sidney, 1918-1989. Security poster in a series drawn by Nevile Lodge in World War II. New Zealand. Department of Internal Affairs. War History Branch :Photographs relating to World War 1914-1918, World War 1939-1945, occupation of Japan, Korean War, and Malayan Emergency. Ref: DA-01984-F. Alexander Turnbull Library, Wellington, New Zealand. http://natlib.govt.nz/records/23191306
“Permission of the Alexander Turnbull Library, Wellington, New Zealand, must be obtained before any re-use of this image.”

To March 1940

April 1940 to June 1940

July 1940 to March 1941 

April 1941 to June 1941

July 1941 to September 1941

October 1941 to December 1941

January 1942 to March 1942

April 1942 to June 1942    

July 1942 to December 1942

January 1943 to March 1943

April 1943 to June 1943

July 1943 to December 1943

January 1944 to March 1944

April 1944 to December 1944

January 1945 to December 1945

January 1946 to June 1948

 

Do not be fazed by the various coloured cells and some of the coloured text .. this is more to assist me with my ongoing research than for your purposes. You are strongly advised though before clicking through to the spreadsheet to have a good read through the Quickstart guide you’ve downloaded.

Furthermore, the Freedom’s Call website in itself (around 30 pages of information) is a tremendous resource and well worth your time perusing. It has been set up as a tool to help you get the most out of your research.

Specifically what you will find:

Information comprises the following extracted from the Nominal Rolls spanning the period March 1940 to June 1948.

Surname; Christian name; Regimental Number; Formation/ Unit/Corp attached to at time of embarkation; embarkation dates; marital status; enlistment district; occupation; last address and next of kin.

Where an entry is also to be found on the Auckland War Museum Cenotaph database, then that entry has been duly noted to that effect.

Other information has also been obtained to assist the researcher in zeroing in on the right person and stems from several sources including:

  Auckland War Museum Cenotaph database,

 – New Zealand Births, Deaths & Marriages (BDM) Index,

 – Northland, Auckland and Hamilton Council Online Cemetery Records (and a few others),

 – New Zealand Army Nursing Service Rolls,

 – 28th Maori Battalion Roll

 – Commonwealth War Graves Commission (CWGC) website

 – Other online databases for private cemeteries.

This information comprises the following:

Category A: Those who died on active service – where they died, the name of the cemetery, the CWGC grave or memorial reference; their date of death and age at death and where found their date of birth; nicknames, aliases or other adaptations of the name appearing on the Nominal Roll and in some instances very brief notes.

Category B: Those who survived the war – date of birth and death and age at death (where known), whether buried or cremated, either date of cremation or of burial/sprinkling of ashes, cemetery and plot number; funeral director if known and here too you’ll find some very brief notes, where accompanying information has been found which can assist with correct ID.

In the columns U and V (for the showing of date of birth or date of death) ..  if this has been grayed out irrespective of whether it shows dashes —-, an asterisk or a note, you can take it that I will be undertaking no further line of enquiry as regards that particular entry. That does NOT MEAN that you should not pursue researching this yourself. 

Irrespective if whether Category A or Category B, if it shows up that they served with the Maori Battalion or the New Zealand Army Nursing Service, or that they were a Prisoner of War (POW)then this has been noted.

Further information on who is and who is not to be found on the spreadsheet can be found here.

New Zealanders of J Force listening to a Japanese music-seller on guitar, Yamaguchi, Japan. New Zealand. Department of Internal Affairs. War History Branch :Photographs relating to World War 1914-1918, World War 1939-1945, occupation of Japan, Korean War, and Malayan Emergency. Ref: J-0388-F. Alexander Turnbull Library, Wellington, New Zealand. http://natlib.govt.nz/records/23215791 “Permission of the Alexander Turnbull Library, Wellington, New Zealand, must be obtained before any re-use of this image.”

New Zealanders of J Force listening to a Japanese music-seller on guitar, Yamaguchi, Japan. New Zealand. Department of Internal Affairs. War History Branch :Photographs relating to World War 1914-1918, World War 1939-1945, occupation of Japan, Korean War, and Malayan Emergency. Ref: J-0388-F. Alexander Turnbull Library, Wellington, New Zealand. http://natlib.govt.nz/records/23215791
“Permission of the Alexander Turnbull Library, Wellington, New Zealand, must be obtained before any re-use of this image.”

Disclaimer: While every attempt has been made to ensure that the information is accurate, in some instances I have had to exercise my own judgment on the basis of probability, when deciding for instance whether a date of birth or death should be entered. Such instances have been relatively rare and sometimes have led to ‘possibilities’ being recorded in the ‘Details’ column rather than an entry in the date of birth or death column.

I would also point out that it has not been uncommon to find errors in the many sources I have drawn on, so I cannot categorically state that the data when extracted from these sources is always correct.

The overwhelming majority of entries will have data that can be substantively relied upon.

Two complete trawls of the rolls were undertaken. The first some years ago, focusing on an area within about a 50 km radius of Whangarei, the second opening up to bring in the whole of the area from North Cape down to around Wellsford. 

For the moment you will be able to identify these more recent names by way of the entries highlighted in RED, both on the main spreadsheet and the separate spreadsheets for each roll.

There are also a few entries highlighted in GREEN, being some names added as a result of crosschecking of graves at the Maunu Cemetery, Whangarei and three names pulled off the internment.net site – credit: Alan Wagener. These were crosschecked to the entries on the nominal rolls. Their sole criterium for inclusion was that the persons found were interred in Northland. They may or may not have lived or died there. If time permits there will be more extracts undertaken from the Maunu gravestones when I next visit the cemetery.

A Plug For the Auckland War Museum Cenotaph Database 

If an entry shows a record also exists in the Cenotaph database, then you will do yourself a grave mis-service, if you do not check it out. A lot more information is to be found there than I could ever include here. Believe me you will be so enriched by the experience!

A couple of years ago there were more personnel showing on the spreadsheet who were NOT on the database, than there were who were there. That has all now changed and a new trawl suggests that most if not all 2nd NZEF personnel are now up there. A remarkable achievement, so kudos to the Auckland Museum staff who made this happen.

Important: © Copyright D W Calder, Auckland, New Zealand,  2014. Not to be reproduced in any way without prior written consent from the author.

Have you enjoyed the information available to you through this website? Then perhaps you may consider helping those whose lives have been greatly impacted by war in this country.

 

Courage, Compassion, Camaraderie, Commitment

This is what the RSA stands for. 
The National Office is responsible for helping local RSAs with the great work they do, from classic kiwi hospitality, to support for our past and present servicemen and women including the NZ Police, and their dependents. This can be anything from financial assistance and advocacy to creating support networks with other RSA members who have had similar experiences. 

Make a donation.

 To post a donation, find the address of an RSA near you.
To donate via internet banking, make your deposit to account number 02-0500-0021094-00 (or 000 if your banking facility requires 3 digits in the last field). Use your surname and the code 4-1018 as a reference.
If you’d like a receipt, email accounts@rsa.org.nz with the subject line “Internet banking donation”, making sure to add your name, date and the amount of your donation. A receipt will be emailed to you.

 

Whangarei RSA President Chris Harold said the list was ..

“very rare. The war memorial museum, even they don’t have that. So for this guy to find 5,000 names – it’s brilliant!” 

 

Good hunting!

Dale W Calder

18th March 2015

 

31 Responses to Introduction to the 2nd NZEF Spreadsheet

  1. John Barber says:

    The entry for Barber L Regimental number 2747 is incorrect. He is my father and his details are as follows
    Name : George Wilfred Lawrence Barber aka Laurie
    Birth : 29th January 1916
    Death: 25th February 1983
    Place of death : Whangarei
    Buried Maunu cemetary RSA section
    Rank at exit from Army : L/Cpl
    Next of kin : Mrs M Barber 110 Jefferies Rd Christchurch
    Age at death 67

    John Barber

  2. emytopi1 says:

    Hi there John. I have just taken a look at this and rectified the situation. I do of course remember your Dad and you. Sorry … , that one certainly was off base .. I was led down the wrong garden path there.

    You will see that there are two entries now on the database. One shows the correct information you have given me and refers folk also to the next line where the name as it appears in the Nominal (Embarkation) Rolls is shown. This has been done in all cases, and has been continued with this entry to maintain consistency.

    Thank you for alerting me to this ..

    Regards

    Dale Calder

  3. Leanne Osborne says:

    Hi there Dale would it be possible to trace my grandfathers details he was in WWII he returned to Dargaville after the war but I can’t be sure where he enlisted. His name was David Stanley Laurie aka Stan Laurie. His next of kin would have been Dorothy May Laurie he is buried at RSA Cemetry Mount Wesley Dargaville .

    Much appreciated
    Leanne

    • emytopi1 says:

      Hi there Leanne. It should be possible to run a check on the Embarkation Rolls but that could be quite a task and would involve me going in to the Auckland Public Library. In due course of time, when I get quite a large number of names for possible inclusion I will do that, but just not time effective to do it for the one person.

      If he definitely went overseas, we can include minimal information on the database now, and follow up to flesh out the detail later. Do you know where he served? That is pretty important. Who his next of kin were? Any idea on his rank when he enlisted? Any snippet would be appreciated. Unfortunately, the Northern Wairoa council don’t have an online cemetery database, so any information you can give me re his date of death and age (and also birth date if you have it) would be useful. If he definitely served overseas, he should be on the database.

      Looking forward to hearing back from you.

      Cheers

      Dale

    • emytopi1 says:

      Thanks Leanne .. I have sent a further follow up email through to you, today. Cheers .. Dale

  4. Suzanne Dodds says:

    I have just had a phone call regarding a website database of almost 5000 North landers who fought in World War ll. My niece has commented that my father Noel James Rusk is not on the list. He served in the Royal New Zealand Air Force as an Air Gunner. I have all his records and medals .I am the daughter of Noel Rusk.
    I do have his official number if required.
    Suzanne Dodds.

  5. emytopi1 says:

    Hello Suzanne ..

    I have posted a response to your daughter’s query on the Embarkation Rolls page.

    This read as follows:

    “The main spreadsheet (the one with the nearly 5,000 names on it), is just for Army and Nursing personnel. Unfortunately, the record keeping by the NZ Defence Dept during the war years was pretty abysmal as regards airforce and navy personnel.

    You will see that I have a small secondary list as regards airforce and navy staff, gleaned from the Auckland Museum Cenotaph records, but it is hardly a database. Unfortunately, your grand-dad does not show up there.

    Did he serve overseas? Any and all information you can give me would be helpful, to see whether I can add him to the secondary list.

    Cheers

    Dale”

    I would just add to this Suzanne .. I would be delighted to put him on the secondary list. Unfortunately, the air force records were just so lacking it was not possible to create a database as such from them. Can you please advise:

    1. His serial number
    2. Any alias if he had one
    3. Any of the following if you wish.
    a) Your father’s place of death
    b) His date of death
    c) The cemetery where he lies or where he is memorialised
    d) His next of kin when he would have embarked

    Many thanks ..

    Dale

  6. Suzanne Dodds says:

    Hi Dale here are more details regarding my father
    Name .Noel James Rusk.
    Birth. 15.07.1924 @ .Whangarei
    Death.21.04.2008.@ Whangarei
    Buried. Hukerenui Cemetery
    Age of Death. 84 years
    Next of kin when he embarked. Mrs H W Rusk. Mother.
    Service number 432068 He served overseas from 1.02.1944 to 16.11.1945. His rank at Time of discharge was SGT.

    Suzanne Dodds

    • emytopi1 says:

      Hello Suzanne. Thank you for sending that on through.

      I have now updated the secondary spreadsheet with this information.

      Thank you ..

      Dale

  7. Melanie Wilson says:

    My grandfather served.
    Evan Garton born 5 June 1912 in Oruru
    Joined the artillery core and was called up for home defence, joined 10A O.C.T.U
    After 1943 he was drafted into the pool of reinforcements for second Division Middle East and posted to Italy. He sailed on the M V Ruys to Maadi Camp,Egypt in april 1944 and joined division at folingo and was posted to gun E2 ‘E’ troop 28th battery fifth regiment NZA
    He died on 16th November 2003 and is buried in Maunu RSA Cometery

    • emytopi1 says:

      Hello Melanie. I have added most of the information you have given me, along with some other information which I have gleaned from other sources.

      Would you:

      a) please confirm that what is recorded there is correct
      b) try and fill in some of the other blanks for me as regards some of the other columns, eg regimental number, rank on enlistment, marital staus on enlistment, place of enlistment, address prior to enlistment, next of kin, last known rank. Any or all of this information would be appreciated. Regimental number is most important, as I think all other servicmen and women have theirs recorded. I will also send you an email.

      Cheers

      Dale

  8. Raine says:

    Congrats. You have done a great job. While checking out my family (all correct), I found some inconsistencies for another person eg death year, but he is not my immediate family as I am working on a relatives tree. The confusion is not surprising as I found his name spelling incorrect on nominal rolls. I have the correct info if you would like it.

    • emytopi1 says:

      Many thanks, Raine. Yes, please .. I would very much appreciate you emailing that information through to me.

      I wll also email you this response to your post ..

      Regards

      Dale

    • emytopi1 says:

      Hi Raine .. I have now emailed you about this. Thanks for emailing me. Cheers, Dale

  9. ERIN SPRAY says:

    I am the next of kin of my Uncle Errol Holga Roland HOWARD Reg 32195 Sapper & Signalman 18th Field Co NZE served 1940 – 1944. He served in Italy, Egypt & Fiji. I have his Army records. On his death in 2006 I received photos which I did not know existed of his time overseas. I am compiling an album of his history and would like help identifying where these photos were taken. I have contacted the Whangarei RSA who were unable to help me. Can you or anybody in Whangarei who may have had family serving in the same areas help me with identifying where these photos were taken etc., I would be very grateful for any help pointing me in the right direction. Thank you Dale for a wonderful resource.

    • emytopi1 says:

      Hello Erin,

      Nice to have your kind feedback.

      First just a couple of points. Was your Uncle’s last known rank, Signalman? If so, I will show that in the last known rank column. I see you have spelt his middle name Holga. Is the spelling I have wrong?

      I will send you an email confirming this response. You may like to email me back with copies of photos attached and I’ll have a go at identifying where these may have been taken. Certainly, no guarantees though.

      Also, anyone else reading this .. are you happy for them to email you, should they feel they might be able to help?

      Cheers

      Dale

    • emytopi1 says:

      Erin would be pleased if folk could email her if they are able to assist with her request concerning the photos.

      Her email address is : eandps@xtra.co.nz .

  10. Erima Henare says:

    Dale, tena koe. Firstly, let me congratulate you for completing this monumental task. It will be a most valuable source for families as we remember these men and women.
    Would love to talk with you in person about our project as your list will be most valuable In helping us.
    My father is Lt Col James C Henare 63390 28 Maori Battalion.

    • emytopi1 says:

      Greetings, Erima and thank you for your very kind words.

      It would be a pleasure to speak with you.

      I will email you later this morning, with my contact details.

      Best regards

      Dale

    • emytopi1 says:

      Sadly, I learn of the passing of Erima. RIP, sir ..

  11. Dave Wistrand says:

    Yes good work – three missing I think – two brothers to Reinhold Wistrand you identified:
    Jack Albion Wistrand – Gunner
    Thomas Edward Wistrand
    and also couldn’t see
    Douglas ?? Snooks also from Dargaville a brother in law to the Wistrand’s
    All from Dargaville both served overseas during WW2 will have to track down more details if you require that. I should know more

    • emytopi1 says:

      Hi there Dave. Thank you for your kind comment and for alerting me to that.

      If the two Wistrand brothers and Douglas?? Snooks served overseas in the army and have links to Northland, then they should be on the list.

      I will explain the likely reason why they are not.

      When the project was first undertaken through the Embarkation Rolls, the outer geographical limit to the west of Whangarei I set was Tangiteroria. Only, as more and more info became available online did I extend out. I was able to bring in many of the soldiers/nurses on the Cenotaph and Maori Battalion websites, who lived further out, e.g. Dargaville. Most of these people however had not survived the war. That left me with a follow-up job to do .. to return to the rolls and extract details of service personnel who lived further west; and also south of Waipu and north of Moerewa. I will be doing that over the next few months so should come across the names you have mentioned.

      Meanwhile, if there is anything further you can give me about the abovenamed, particularly details of their connection to the north and regimental numbers, if known, that would be a great help. I can then add them to the list and include the additional info from the rolls, later.

      Thanks again Dave .. I will also email you with this response…

      Cheers

      Dale

      • emytopi1 says:

        Dave – Douglas Snooks has now been placed on the rolls as a result of my second trawl through the April 1940-Jun 1940 Embarkation Roll. Cheers .. Dale.

  12. Stuart Park says:

    I’m pleased to see Robert George Ledlie listed, since Kaitaia RSA refused to acknowledge him as a Northlander killed in action for the memorial in Kaitaia. Although born and educated in Otago, George was teaching at Ngataki School in 1939- 1940, when he enlisted at Kaitaia in October 1940. As you show, he died in Italy in 1942. His mother’s rather unusual name was Frederina, not Frederika as you have – probably a transcription error

    • Stuart Park says:

      Sorry, one further thing. George’s nok was his mother, Mrs SA Ledlie, though you have (f) for father after her name. Her husband’s initials are used, as was common at that time.

    • emytopi1 says:

      Thank you, Stuart. Great that I was able to pick him up. The fact that so many of these chaps who served (and in some cases fell) and are not to be found on a physical memorial was one of the reasons I created this resource. I will leave next of kin as per the spreadsheet as this is what was recorded on the roll. I will however put a notation in the comments column covering what you have said. Cheers .. Dale

  13. Bill Ashdown says:

    Thank you so much for the link to your incredible data bases. such a valuable record.
    would’t it be great to have this record for the whole of NZ. Come on NZ defence force!!!
    Bill Ashdown. President Pt. Chevalier Memorial RSA.

    • emytopi1 says:

      Thank you kindly for your very favourable response, Bill. It is much appreciated. Hopefully, it may prove of some use to Aucklanders too who may be wanting to find out a bit more about the WWII history of family members. A good number of their forebears appear on the database.

  14. Hi Dale,
    You have a great resource here!
    I may well be in contact again on other aspects, but for now could I could I suggest that the phrase “Do not be phased by the various coloured cells…” on your Intro page should be “Do not be fazed by the various coloured cells…”
    cheers,
    Philip Hinton
    Collections Data Analyst
    Auckland War Memorial Museum

    • emytopi1 says:

      Thank you, Philip. Sorry I am just replying now. I have been overseas and am doing some updating. Thank you for alerting me to that. I will correct.
      By the way, I must congratulate you. Around 2 years ago, I noted about two thirds of those on my list were not on the Cenotaph database. Now, on trolling through it looks like all are now there. If that is a reflection of the whole of NZ then that is a remarkable achievement in such a short time span. You and your team can be justly proud. Cheers, Dale.

Leave a Reply

Your email address will not be published. Required fields are marked *