DOI: 10.5281/zenodo.16962476
title: UKBsis 2024 OA Monitor Project

description: The 2024 UNL OA Monitor consolidates metadata from open sources CrossRef, DOAJ, Unpaywall and ISSN.org with institute received reports, and UKBsis datahub snapshots, applying business rules to classify publications (DOIs) into 4 OA categories 

For this monitor, the project team requested the 2024 CRIS output from Dutch universities and university medical centres. This output is enriched with several open data sources and centrally aggregated into one dataset. Followed by  a process of reviewing and improvement, resulting in a 2nd dataset.

The 2024 UNL OA monitor builds upon the results of the UNL OA monitor project <link to zenodo>. The monitor aims to combine a transparent and reproducible process with representative results.

Overall structure

The 2024 UNL OA monitor was created in a 2 step process. For both processes a Qlik Sense application was developed and used.

A total of 52, 893 unique DOIs were included in the analysis.

Step 1: automated processing of open metadata

The developed workflow consists of the following steps:

Importing the CRIS data provided by the universities;Cleaning this data (including removing duplicates);Enriching the CRIS data with information from open data sources;Adding the OA classification according to the business rule*;     

Each DOI's ISSN is looked up within CrossRef. Each ISSN (Including the ISSNs from DOAJ) are looked up within ISSN.org.If the ISSN found per DOI appears in the DOAJ snapshot, OA Category "A" is awarded.If the ISSN of the DOI doesn't appear in the DOJA snapshot: if unpaywall states 'gold' or hybrid': OA category 'B' is awarded.If unpaywall states ‘ green’ : category 'C' is awarded.If unpaywall status 'closed' or 'bronze': category 'D' is awarded.

Step 1 results: the aggregated file is published on Zenodo;  both the scripting and the used data from UPW, Crossref and ISSN are stored on github.

Result dataset: 'UNL OA monitor 2024_automated_result_open_sources_only': link to Zenodo

                                                                                             

Step 2: review of correctness OA categories by UKB and institutions

A review  and, if applicable, correction of OA classification by both institutions and UKB.

Optionally changing the OA classification according to the business rules: 

If based on the DOI no ISSN was found, a manual check is done. If this results in an ISSN that is part of DOAJ: OA category A is added.

-        If DOI has OA category status C or D but is listed as 'published open access' in the UKB datahub, the OA category is changed to B and the url to the publication is added.

-        If DOI with OA category B, C or D is checked by an institution and the institution changes the OA category (B to C or D / C to B or D / D to B or C) a url to the publication or repository (when OA category is changed to C) is added.

Subsequently aggregating the OA information at the institutional levels.If requested corrections for 1 doi are inconsistent, highest ranking prevails. Reports are created at record, institutional and UNL levels.

In the final dataset column F shows the automated OA category result and column G shows the corrected OA category. To support users in checking the correctness of step 2, the transparancy of manual process step, column H shows the url to the url where the publication can be found.

Result dataset 'UNL OA monitor 2024_processed_result_final': 

Attachments:



FLOW OA Monitor.png (A visual representation of how data is handled)

Initial Output 2024 for OA analysis Template.csv (Initial form to be filled in with DOI information by institutes)

Send Back Template OA monitor UKBsis.xlsx (Received back template after initial Category award process for institutes checks  and corrections)

20250610.ISSN-to-ISSN-L.txt (Snapshot used from 10 October 2025 to look up the corect ISSN for each found in CrossRef and DOAJ)

DOAJ Download (20250625).xlsx (Snapshot used from 25 June 2025 to establish if DOIs' ISSNs are listed)

CROSSREF_DOI_2025-06-11.csv & CROSSREF_LICENSE_2025-06-11.csv (Python Query results from CrossRef - If questions about the query arises please contact the UKBsis team)** 

UNPAYWALL_DOI_2025-06-11.csv & UNPAYWALL_OA_LOCATIONS_2025-06-11.csv (Python Query results from Unpaywall - If questions about the query arises please contact the UKBsis team)** 

Final OA Monitor Results 2024.xlsx (Zenodo set)


The Qlik Script & GitHub repository can be accessed here : 

https://github.com/UKBsis/UKBsis-2024-OA-Monitor-Project

** a.f.schalken@vu.nl