I'm looking for a downloadable list of all known (or better said, online documented) species in this straightforward format, as an example the European Frog:
Species: Rana temporaria
I'd like to have this list offline in a structured text or database format that I can parse. If such a list has other useful attributes (credits, distribution, common names), it is welcome, but the above is the absolute minimum I need. I know there are more taxonomy levels in the above system (Species 2000 & ITIS Catalogue of Life: April 2013 ), but I only need these basic 6.
I have been looking at several collections and am having difficulty getting the data that I need. Either the database is incomplete, not accessible as a database, has complicated data structures, or has poorly described and slow web APIs that I cannot rely on.
Conceptually, it seems to me that http://www.catalogueoflife.org comes closest to my needs, yet their download is a tool, not a database. I do see the download has a MySQL folder containing lots of files, but I don't know how to reconstruct it into a database. It seems also that they pulled the page to describe the database download.
As simple as my question seems (I'm not a biologist, so I assumed it was simple), I have wasted several hours coming up empty. I was wondering if anybody has done the work to provide basic species info in an understandable format as requested?
As for species completeness, the 1.3m of Catalogue of Life sounds really good, as I'm currently basing my system on Wikipedia, which only has 180k species.