Create a psql `open-access-journals` table in postgres for api.archivelab.org/scholar/journals endpoint.
Pubmed central schema looks like:
JournalTitle: AADE editors' journal
MedAbbr: AADE Ed J
ISSN (Print): 0160-6999
IsoAbbr: AADE Ed J
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:
ISO Abbreviations have no clear standard across academia. Here's a place to start on that topic:
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.)")