Skip to content

Instantly share code, notes, and snippets.

@jhpoelen
Last active May 13, 2024 21:01
Show Gist options
  • Save jhpoelen/5346f4819798ced642c23c29f3ebfaf9 to your computer and use it in GitHub Desktop.
Save jhpoelen/5346f4819798ced642c23c29f3ebfaf9 to your computer and use it in GitHub Desktop.
create table with DOI, pub year, and open access status
OPEN_ALEX_VERSION=hash://sha256/f19011fe72234cb22f4326fcc95752647a11628cdaa0d24f7d55033b06cb5653
REMOTES=https://biokic6.rc.asu.edu/preston/openalex,https://linker.bio\
preston ls\
--anchor "${OPEN_ALEX_VERSION}"\
--remote "${REMOTES}"\
| grep hasVersion\
| grep -v csv\
| grep "[.]gz"\
| grep works\
| preston cat --no-cache --remote "${REMOTES}"\
| gunzip\
| jq --raw-output '[.open_access.is_oa, .publication_date, .doi ] | @tsv'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment