Create Database for api.archivelab.org/scholar

Create a psql `open-access-journals` table in postgres for api.archivelab.org/scholar/journals endpoint.

Pubmed central schema looks like:

JrId: 1
JournalTitle: AADE editors' journal
MedAbbr: AADE Ed J
ISSN (Print): 0160-6999
ISSN (Online):
IsoAbbr: AADE Ed J
NlmId: 7708172

Every pubmed ID included in Pubmed Central until Nov 7, 2015 – https://files.slack.com/files-pri/T0E3DCW73-F0EHKRWKU/download/pmids_in_pmc.gz

This is a good start (subtracting out the MedAbbr, JrId, and NlmId) for a general-purpose journal DB

What would make it really useful is to include also the DOI prefix that each journal uses. (See also http://www.crossref.org/01company/15doi_info.html )

So the schema so far:

title
issn_print
issn_online
isoabbr
doi_prefix

ISO Abbreviations have no clear standard across academia. Here's a place to start on that topic:

http://www.library.illinois.edu/biotech/j-abbrev.html

Re: ISO Abbreviations have no clear standard – that's not completely true (and that is my comment, i am not an anonytroll, i promise!).

They mostly follow good heuristics (i.e. you could probably convert a title to an iso abbreviation correctly 90% of the time), but there are numerous places where they don't (e.g. where the need to avoid name collisions results in something like "Blood (Philadelphia.)")