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:
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.)")