Create Database for api.archivelab.org/scholar

Description

None

Environment

None

Activity

Show:
Mek Karpeles
November 15, 2015, 6:31 AM
Edited

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

Mek Karpeles
November 15, 2015, 6:32 AM

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

Anonymous
November 15, 2015, 6:39 AM

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

Anonymous
November 15, 2015, 6:50 AM

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

Assignee

Unassigned

Reporter

Mek Karpeles

Priority

Minor
Configure