Friday, July 10, 2015

All of Tom Pick's Eiffel Germany Survey in a Single Downloadable Query-able File!!!

I am very pleased to say I am finished compiling all of Tom Pick's Eiffel Germany Birth and Death survey into a single query-able file, and you can download it right here!

I cannot imagine how long it took Tom to originally put together his website and obtain all of those records.  He will be sorely missed and I only wish he had longer on this earth so he could have done more.  He compiled about 550,000 birth records and many thousands of marriage records from over 650 cities in Germany.  They weren't perfect and there are some errors, but it's an amazingly valuable resource.  His original website with the records in separate city files are here.

The fields in the database are the same as Tom used with explanations are:

MO - Month of birth
DA - Day of Birth
YEAR - Year of Birth
FatherLast - Last name of father
FatherFirst - First name of father
MotherLast - Last name of mother
MotherFirst - First name of mother
Marriage - Marriage date of mother and father(only recorded in one record for each family if he                           found it)
ChildName - First and middle name of child born on date in MO, DA, and YEAR fields
SpouseName - Spouse of child in ChildName field if found

You can download the single file in csv, xlsx (Excel format), or in Access 2013 database format BELOW!!, just click on the blue box.



-Jamie

3 comments:

  1. Just saw this - and I can say it took him a long time and many hours. I used to work with him a little and correspond over some of our shared ancestry. Really too bad to have lost him when we did. Thanks for your work on this!

    ReplyDelete
    Replies
    1. Hello - Tom Pick was my father (I was his firstborn, Aimee Pick) and I just wanted to thank you and everyone out there for continuing my dad's work. As we are approaching the 10 year mark since he died (hemorrhagic stroke), I am so pleased to be able to google his name today and see his legacy of family history research being continued by so many. My dad spent countless hours at libraries doing old fashioned, pre-internet research and compiling everything (in DOS, no less!) and put together a lovely book for me years ago with photos going back as far as he possibly could. In 2017, I updated my Ancestry.com listing (Aimee Levens, Portland, Oregon - should be pretty easy to find) with all of these photographs that I hand-scanned along with any stories he had about the people in those photos. Again, thank you!

      Delete
  2. This comment has been removed by the author.

    ReplyDelete