• Code and data on Github: https://github. com/Curtin-Open-Knowledge-Initiative/presentation-acs2021/
• Presentation on Github: https://curtin-open-knowledge-initiative.github.io/presentation-acs2021/
• Code and presentation at Zenodo: doi:10.5281/zenodo.4680985

Copyright Cameron Neylon 2020-2021. This slide deck is licensed under a Creative Commons Attribution 4.0 International License. Code is available under an Apache v2.0 license at Github.

Data is derived from the following sources

• Crossref - weekly dump via Metadata Plus program
• Unpaywall - Open Access Status data via open data dump (October 2020)
• Microsoft Academic - Affiliation and authorship data via biweekly dump
• GRID - Information on organisations via regular data dump

Data is integrated and processed via Observatory Platform, an open source workflow system developed within COKI to integrate data related to scholarly communications. The code is available on Github including the template for SQL queries which generates the OA status we use from the Unpaywall data. More detail on the OA categories is also provided on the slide below.

For this analysis, publisher is defined by the text string in the Crossref metadata, affiliation is derived from the assignment by Microsoft Academic and field is the Level Zero field "Chemistry" from Microsoft Academic as provided in the data dump used. Some comparative data for "Materials Science" and "Biology" is presented in additional slides.

The following is derived from the template SQL query used to define the OA categories in Observatory Platform. For the most up to date information view the file on Github.

AGGREGATE UNPAYWALL QUERY TEMPLATE

This template query contains the SQL that directly interprets Unpaywall data to determine OA categories at the output level. This is therefore the canonical location for the precise definitions used for OA categories. Ideally this file should contain both the queries themselves and a description clear enough for a non-expert in SQL to understand how each category is defined.

The current categories of Open Access described in this file are:

• is_oa: derived directly from Unpaywall
• hybrid: accessible at the publisher with a recognised license
• bronze: accessible at the publisher with no recognised license
• gold_just_doaj: an article in a journal that is in DOAJ
• gold: an article that is in a DOAJ journal OR is accessible at the publisher site with a recognised license (hybrid)
• green: accessible at any site recognised as a repository (including preprints)
• green_only: accessible at a repository and not (in a DOAJ journal OR hybrid OR bronze)
• green_only_ignoring_bronze: accessible at a repository and not (in a DOAJ journal or hybrid)

Levels of open access publishing are as provided by Unpaywall for all outputs with RSC and ACS as publisher in Crossref metadata. In the Observatory Platform terminology this is "gold" open access and includes all articles published in either fully open access (as defined by indexing in DOAJ) and in mixed journals (i.e. "hybrid")

As defined in the SQL used to generate these categories.

Gold Open Access:

gold OA is defined as either the journal being in DOAJ or the best_oa_location being a publisher and a license being detected. This works because Unpaywall will set the publisher as the best oa location if it identifies an accessible publisher copy.

  CASE
    WHEN journal_is_in_doaj OR (best_oa_location.host_type = "publisher" AND best_oa_location.license is not null AND not journal_is_in_doaj) THEN TRUE
    ELSE FALSE
  END
    as gold,