Sunday afternoon Genealogy Fun

Sunday Afternoon Genealogy Fun – What Source Have You Used the Most

Each week on Randy Seaver’s Genea-musings blog he has a post for Saturday night Genealogy fun.  Because of the time difference, I have called my series Sunday Afternoon Genealogy Fun. This week the mission was:

1)  Have you done a good job of citing your sources in your genealogy management program or online family tree?  How are you doing?  How many source citations do you have, and how many people are in your tree?  What is the sources to persons ratio?

2)  Which master source (e.g., 1900 U.S. census, Find A Grave, specific book, etc.) do you have the most citations for?  How many?  How did you figure this out?

3)  Tell us about it in your own blog post, in a comment on this blog post, or in a post on Facebook.

1) I have not been as diligent as I could have been in citing my sources, mainly because I have been trying for years to organize my old research, and to fix up the existing sources in my tree.  At the moment, I have 11975 individuals in my tree, 3609 master sources and 27095 citations. The source/person ratio is 2.26263.

In 2015, my statistics were: 3327 master source, 24691 citations, 11039 individuals– the source/person ratio is 2.236706.

In 2017, my statistics were: 11850 individuals, 3403 master sources, and 25277 citations.  The source/person ratio is 2.13308

I have only added 125 individuals in the last two years, but I have added another 206 master sources, and 1818 source citations.

2) At the moment, the master source with the most citations is the Death Index Victoria 1921-1985 CD , with 1724 citations

My top ten master sources are

  1. Death Index Victoria 1921-1985 CD – 1724 citations
  2. Pioneer Index Victoria 1836-1888 CD – 1162 citations
  3. Edwardian Index Victoria 1902-1913 CD  – 1054 citations
  4. Federation Index Victoria 1889-1901 CD – 880 citations
  5. Year of birth calculated from age at time of death – 651 citations
  6. Great War Index Victoria 1914-1920 CD – 595 citations
  7. NSW Registry of Births Deaths & Marriages online – 429 citations
  8. Rootsweb WorldConnect a23238 database submitted by – 392 citations
  9. Old Parish Register Births & Baptisms, ScotlandsPeople – 330 citations
  10. England & Wales, FreeBDM Birth Index: 1837-1983 ( – 306 citations

Since I no longer have a computer with a CD drive, I plan to replace my citations from the Victorian BDM CDs, and use the Births Deaths and Marriages Victoria website instead.  I have also found that over the years, I have ended up with multiple copies of the same master source.  It will be interesting to see what my top ten master sources will be, once I go in and update my master sources and source citations.


I use Legacy Family Tree.  To find the sources with the most citations, I choose Other Reports, Source Citations, and select All Sources, Master Sources and Citation Summary Counts.  Rather than going from the Source Citation Report, and checking each source individually, I saved the report as a PDF file.

Then I copied the file into Microsoft Excel, and then sorted the report by Column A.  I then deleted everything except the lines starting with the word Individual.  I then used Data: Text to Columns to move the number to Column B.  I then sorted Column B from Largest to smallest.

This gave me a list with the top 10 numbers.

Then it was just a matter of searching the PDF file for these numbers, to find which source they belonged to

2 thoughts on “Sunday Afternoon Genealogy Fun – What Source Have You Used the Most

Comments are closed.