Genea-Musings reader Ronny emailed two weeks ago offering me a spreadsheet that he compiled from the holdings of several online digitized historical newspaper providers, such as Ancestry.com, GenealogyBank, Newspapers.com, NewspaperArchive, Elephind, Old Fulton Postcards, Google News Archive, and others. If the newspaper is at a commercial site, you need a subscription or you could find a library that provides access to the site.
Ronny noted in his email:
"I got tired of hunting various sites to figure out if a town I was hunting had any newspaper archives available so I made a spreadsheet that now has over 13,000 collections, mainly from Genealogy Bank, Newspapers.com, Newspaperarchive.com, Ancestry.com, Old Fulton Post Cards, Google News Archives and Elephind. Though there are a few others included as well. I don't have a web site but would love to share the collection with others. I think if more people utilized newspaper archives, it would help break down some brick walls. "He wanted me to somehow make it public and offer it to the genealogy world for him without charge to users. I thought this was a great idea, and after a little thought, I uploaded it to a Google Drive file, and made it shareable.
The updated link is:
When you open the link, only the first page of the spreadsheet shows up (I'm not an expert at Google Drive, apparently!).
There is a download icon at the top of the page (the down arrow icon) where the complete spreadsheet can be downloaded to your computer. The file size is 1.430 megabytes. It downloads as an .xlsx file, which most spreadsheet programs should be able to read.
When you open the file in your spreadsheet program (I use LibreOffice Calc), the top of the spreadsheet starts with Alabama newspapers in alphabetical city order:
Line 13,461 of the spreadsheet is for Wright, Wyoming:
The column headings are:
E. Date Range
F: Earliest Date
G: Latest Date:
H: Site (with link to the website, not the specific newspaper)
I: Pay Site or Free
J: # of Issues
This is offered to Genea-Musings readers free of charge and as is. It may or may not be updated in the future.
NOTE: Some of the links in the "Site" are incorrect. I will try to get Ronny to fix them.
My thanks to Ronny for creating this spreadsheet - this was a labor of love, and is freely offered to Genea-Musings readers.
UPDATE 13 May 2015: On 12 May 2015, Miriam J. Robbins, who has the Online Historical Newspapers website with similar content to Ronny's spreadsheet, was concerned that Ronny had copied some or all of her information to his spreadsheet. When I was notified of this, I took this blog post down until the issue could be resolved. Ronny informed me and Miriam that he had deleted Miriam's data from his spreadsheet before he sent it to me (and others), and that none of Ronny's information included Miriam's information. Miriam double checked this, and found that this was the case. So I am reinstating the blog post.
Ronny updated the spreadsheet after I noted that some of the links were erroneous, and the updated spreadsheet has been substituted for the first one in the link above. The updated link is:
The URL for this post is: http://www.geneamusings.com/2015/05/tuesdays-tip-digital-newspaper-archive.html
Copyright (c) 2015, Randall J. Seaver
Please comment on this post on the website by clicking the URL above and then the "Comments" link at the bottom of each post. Or contact me by email at firstname.lastname@example.org.