Published October 15, 2025 | Version v2

UKBsis Open Access Monitoring 2024 - Open Source [Datasets]

  • 1. Samenwerkingsverband van de Nederlandse universiteitsbibliotheken en de Koninklijke Bibliotheek
  • 2. ROR icon Vrije Universiteit Amsterdam

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': downloadable in the files section below

 

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 'OA_monitor_2024_final_curated_result_20250917': link to Zenodo : https://doi.org/10.5281/zenodo.17141707

The Qlik Script & GitHub repository can be accessed here : https://github.com/UKBsis/UKBsis-2024-OA-Monitor-Project

** a.f.schalken@vu.nl

Files

20250610.ISSN-to-ISSN-L.txt

Files (165.4 MB)

Name Size Download all
md5:38f7f3a39059cbc006c20b058c4db29e
57.7 MB Preview Download
md5:5fbcdeddec7a776f0d0e8761fbb19034
27.4 MB Preview Download
md5:f76bf29c7c1284479143ec1286143f65
7.2 MB Preview Download
md5:012967e79b6f352b7ee24d92bd89920d
10.6 kB Download
md5:282cbe6aec70a7ff08e557bbbde57f23
9.3 MB Download
md5:2da2b0fd7ac3f3555b142d2f7da827f2
236.7 kB Preview Download
md5:c3c8aa0e72e82d0d2e45f51c60e5b415
7.1 MB Download
md5:e7534fe87e24a80c6085bc0aa6743a3f
23.6 MB Preview Download
md5:cc28028aa3c48128851259e4ed076344
32.8 MB Preview Download

Additional details

Software