DOI: 10.5281/zenodo.14446400
title: EPDOS - Team Science - author contributor data (CRediT) - accompanying data to the White paper

description: The archive institutional data and dashboards.zip contains various files related to the Team Science project, which focuses on analyzing research contributions using the CRediT taxonomy. The project is designed to improve the recognition of diverse roles in academic research teams through structured data. The archive is divided into three main folders:

Folder Structure and Files





1_input_credit_data:



Contains raw data files related to the number of publications and the authors' contributions across different institutions.



Example files:



AUMC_file_1_publication_counts.csv

TUE_file_2a_author_year_counts.csv

UM_file_2b_author_publication_role_tuple.csv









2_output_reports:



Contains generated reports, models, and data visualizations related to the project's analysis of CRediT roles.



Example files:



AUMC_20241211 Amsterdam UMC toevoeging - final.docx

Elsevier_CRediT_slidesAP.pdf

VU_2024_EPDOS_team_science_dashboard_powerbi.pbix

VU_2024_EPDOS_team_science_dashboard_powerbi.pdf









3_usercase_survey_results:



Contains survey results from different institutions regarding the use of CRediT and Team Science use cases.



Example files:



UM_usecases_survey_results.md

VU_usecases_survey_results.md
description: The files in 1_input_credit_data are structured based on different universities, and the naming convention indicates the specific type of data they contain. Here's a more detailed breakdown of the contents of the files with the prefixes indicating data from various universities:

File Breakdown

Here’s a more detailed description of the columns and the value types for the CSV files 

1. XXXX_file_1_publication_counts.csv





Columns:



ScopusEid: String. Represents the unique identifier for the publication in Scopus.

pii: String. Another identifier for the publication, possibly a publisher-specific ID.

doi: String. The Digital Object Identifier (DOI) for the publication.

supervision, data curation, visualization, writing - original draft, funding acquisition, etc.: Integer (0 or n higher). These columns represent specific roles in the CRediT taxonomy, with n indicating that the role was performed a number of times by different contributors for that publication and 0 indicating that it was not.





Value Types:



The majority of the columns represent controlled vocabulary based on the CRediT taxonomy, such as supervision, data curation, and writing - original draft, where the values are integers (either 0 or n), indicating whether an author played that role in the publication.

ScopusEid, pii, and doi are strings representing publication identifiers.




2. XXXX_file_2a_author_year_counts.csv





Columns:



author_id: String. A unique identifier for each author.

ScopusEid: String. A unique identifier for each publication in Scopus.

year: Integer. The publication year.

author_count: Integer. The number of publications contributed by the author in that year.





Value Types:



author_id and ScopusEid are strings representing unique identifiers.

year is an integer representing the year of publication.

author_count is an integer showing the number of publications an author has contributed to in the specified year.




3. XXXX_file_2b_author_publication_role_tuple.csv





Columns:



author_id: String. A unique identifier for each author.

ScopusEid: String. A unique identifier for each publication.

credit: String. The specific CRediT role performed by the author (e.g., writing - review & editing, conceptualization, methodology).





Value Types:



author_id and ScopusEid are strings representing unique identifiers.

credit is a string representing the role assigned to the author in that publication. This is a controlled vocabulary from the CRediT taxonomy (e.g., writing - review & editing, data curation).




Connections Between the Files:

The files XXXX_file_1_publication_counts.csv, XXXX_file_2a_author_year_counts.csv, and XXXX_file_2b_author_publication_role_tuple.csv are related through the ScopusEid and author_id columns. These files track different aspects of publication and author contributions, so understanding how they connect is key to performing analyses.



XXXX_file_1_publication_counts.csv (Publication metadata)



This file contains metadata about each publication, such as its unique ScopusEid, which is the publication's identifier. It also tracks whether certain roles from the CRediT taxonomy (such as supervision, writing, data curation, etc.) were involved in the publication (with 1 for involvement and 0 for no involvement).



XXXX_file_2a_author_year_counts.csv (Author contribution count by year)



This file contains author_id (a unique identifier for each author) and the ScopusEid linking each author to the publication. It also includes the author_count to indicate the number of publications the author has contributed to in a particular year.



XXXX_file_2b_author_publication_role_tuple.csv (Author roles in publications)



In this file, author_id links to a specific author, and ScopusEid connects them to a particular publication. The credit column specifies the role the author played in that publication (e.g., writing - review & editing, data curation).




How They Connect:



ScopusEid:



It connects XXXX_file_1 (publication data) with both XXXX_file_2a (author-year data) and XXXX_file_2b (author-role data). It allows us to track all of the publications associated with specific authors and determine their roles in those publications.



author_id:



It links XXXX_file_2a (author-year data) and XXXX_file_2b (author-role data), providing the connection between authors and their specific contributions and roles within each publication.




ASCII Diagram: How They Connect Together

+-----------------------------------------+             +--------------------------------------------+
|       XXXX_file_1_publication_counts    |             |  XXXX_file_2a_author_year_counts          |
|  (Publication Metadata)                 |<-ScopusEid->|  (Author-Year Contributions)              |
|-----------------------------------------|             |--------------------------------------------|
| ScopusEid (String)                      |             | author_id (String)                         |
| pii (String)                            |             | ScopusEid (String)                         |
| doi (String)                            |             | year (Integer)                             |
| supervision (Integer)                   |             | author_count (Integer)                     |
| data curation (Integer)                 |             +--------------------------------------------+
| visualization (Integer)                 |
| writing - original draft (Integer)      |
| funding acquisition (Integer)           |             +--------------------------------------------+
| software (Integer)                      |             | XXXX_file_2b_author_publication_role_tuple  |
| formal analysis (Integer)               |<-ScopusEid->|  (Author Roles in Publications)           |
| resources (Integer)                     |             |--------------------------------------------|
| writing - review & editing (Integer)    |             | author_id (String)                         |
| conceptualization (Integer)             |             | ScopusEid (String)                         |
| methodology (Integer)                   |             | credit (String) (CRediT Role)              |
| validation (Integer)                    |             +--------------------------------------------+
| investigation (Integer)                 |
| project administration (Integer)        |
| other (Integer)                         |
+-----------------------------------------+             +--------------------------------------------+


Explanation of the Diagram:





XXXX_file_1_publication_counts:



Contains the ScopusEid for each publication (e.g., 2-s2.0-85120174377), and tracks whether various CRediT roles (e.g., supervision, data curation) were involved in the publication. These roles are represented by integer values (0 or 1).





XXXX_file_2a_author_year_counts:



author_id links to individual authors. The ScopusEid links to the same publications found in AUMC_file_1, and we can track how many publications the author contributed to in a given year (author_count).





XXXX_file_2b_author_publication_role_tuple:



author_id links to the author and ScopusEid links them to specific publications. The credit column lists the CRediT roles (e.g., writing - review & editing, conceptualization) that the author performed in the publication.




Summary:

The ScopusEid connects publications across all files, allowing us to link the metadata about the publication (such as its CRediT roles) to the authors who contributed to it. The author_id provides the key to track individual author contributions both in terms of the number of publications and the specific roles they took on in each publication. These connections form the foundation for detailed analysis of publication counts, author productivity, and the roles authors play within the team science framework.