OPENBIB: Selected curated open metadata based on OpenAlex

  Entities overview Entities overview Address information 🏛 Address information Disambiguation of address information is provided by the Disambiguation of address information is provided by the Institute for Interdisciplinary Studies Institute for Interdisciplinary Studies of Science of Science in Bielefeld. in Bielefeld. Limitations: Only includes publications that are assigned to German institutions by the Limitations: Only includes publications that are assigned to German institutions by the algorithm. algorithm. Mode A Mode A Mode A contains all assignments of publications to currently existing institutions. Mode A contains all assignments of publications to currently existing institutions. Allocation of documents to institutions (Mode A) Allocation of documents to institutions (Mode A) Data File: Data File: kb_a_addr_inst.csv kb_a_addr_inst.csv Field Field Type Type Description Description inst_id_top inst_id_top INTEGER INTEGER The institution id associated with this publication The institution id associated with this publication openalex_id openalex_id STRING STRING The OpenAlex id associated with this publication The OpenAlex id associated with this publication address_full address_full TEXT TEXT The address string found for this publication in OpenAlex The address string found for this publication in OpenAlex sector_id sector_id STRING STRING The sector id(s) associated with this publication The sector id(s) associated with this publication doi doi STRING STRING The DOI associated with this publication The DOI associated with this publication identifier identifier STRING STRING The internal identifier for this publication The internal identifier for this publication Example Record Example Record Mode S (Historic mode) Mode S (Historic mode) Mode S contains all assignments of publications to institutions that existed at the time of Mode S contains all assignments of publications to institutions that existed at the time of publication. publication. Allocation of documents to institutions (Mode S) Allocation of documents to institutions (Mode S) Data File: Data File: kb_s_addr_inst.csv kb_s_addr_inst.csv Field Field Type Type Description Description inst_id_top inst_id_top INTEGER INTEGER The institution id associated with this publication The institution id associated with this publication openalex_id openalex_id STRING STRING The OpenAlex id associated with this publication The OpenAlex id associated with this publication address_full address_full TEXT TEXT The address string found for this publication in OpenAlex The address string found for this publication in OpenAlex sector_id sector_id STRING STRING The sector id(s) associated with this publication The sector id(s) associated with this publication doi doi STRING STRING The DOI associated with this publication The DOI associated with this publication identifier identifier STRING STRING The internal identifier for this publication The internal identifier for this publication Example Record Example Record Institutions Institutions Data File: Data File: kb_inst_lookup.csv kb_inst_lookup.csv Field Field Type Type Description Description inst_id inst_id INTEGER INTEGER The id of this institution The id of this institution first_year first_year INTEGER INTEGER Date of the foundation of this institution (if available) Date of the foundation of this institution (if available) last_year last_year INTEGER INTEGER Year of closure of this institution (9999 if currently existing) Year of closure of this institution (9999 if currently existing) ror ror STRING STRING The ROR-id of this institution The ROR-id of this institution dfg_instituts_id dfg_instituts_id INTEGER INTEGER The identifier assigned to this institution by the German The identifier assigned to this institution by the German Research Foundation Research Foundation current_sectors current_sectors STRING STRING The sector id(s) associated with this institution The sector id(s) associated with this institution Example Record Example Record inst_id: 137 inst_id: 137 first_year: 1000 first_year: 1000 last_year: 9999 last_year: 9999 ror: "https://ror.org/00g30e956" ror: "https://ror.org/00g30e956" dfg_instituts_id: 10192 dfg_instituts_id: 10192 current_sectors: ["uni"] current_sectors: ["uni"] Institutions name lookup Institutions name lookup Data File: Data File: kb_inst_name_lookup.csv kb_inst_name_lookup.csv Field Field Type Type Description Description inst_id inst_id INTEGER INTEGER The id of this institution The id of this institution name name STRING STRING The name of this institution The name of this institution Example Record Example Record inst_id: 137 inst_id: 137 name: "Universität Hamburg" name: "Universität Hamburg" Sectors Sectors Data File: Data File: kb_sector_lookup.csv kb_sector_lookup.csv Field Field Type Type Description Description sector_id sector_id STRING STRING The id for this sector group The id for this sector group sectorgroup_id sectorgroup_id STRING STRING The abbreviation for this sector group The abbreviation for this sector group sectorgroup_name sectorgroup_name STRING STRING The name of this sector group The name of this sector group remarks remarks STRING STRING A description of this sector A description of this sector Example Record Example Record sector_id: "fhg" sector_id: "fhg" sectorgroup_id: "FHG" sectorgroup_id: "FHG" sectorgroup_name: "Fraunhofer-Gesellschaft" sectorgroup_name: "Fraunhofer-Gesellschaft" remarks: "" remarks: "" Sector name lookup Sector name lookup Data File: Data File: kb_sector_name_lookup.csv kb_sector_name_lookup.csv Field Field Type Type Description Description sector_id sector_id STRING STRING The id for this sector group The id for this sector group name name STRING STRING The name of this sector group The name of this sector group Example Record Example Record sector_id: "fh" sector_id: "fh" name: "Fachhochschulen" name: "Fachhochschulen" Publishers 📚 Publishers Publisher overview Publisher overview The following table lists publishers with enriched information, including ROR and wikidata IDs. The following table lists publishers with enriched information, including ROR and wikidata IDs. Data File: Data File: publishers.csv publishers.csv Field Field Type Type Description Description publisher_id publisher_id INTEGER INTEGER The id for this publisher The id for this publisher publisher_id_orig publisher_id_orig STRING STRING The OpenAlex id for this publisher The OpenAlex id for this publisher publisher_name publisher_name STRING STRING The name for this publisher The name for this publisher standard_name standard_name STRING STRING The standardised name for this publisher The standardised name for this publisher unit_pk unit_pk INTEGER INTEGER The internal ID for this publisher The internal ID for this publisher wikidata wikidata STRING STRING The Wikidata id for this publisher The Wikidata id for this publisher ror ror STRING STRING The ROR-id for this publisher The ROR-id for this publisher url url STRING STRING The URL for this publisher The URL for this publisher Example Record Example Record publisher_id: 13711 publisher_id: 13711 publisher_id_orig: "https://openalex.org/P4310320330" publisher_id_orig: "https://openalex.org/P4310320330" publisher_name: "Adis, Springer Healthcare" publisher_name: "Adis, Springer Healthcare" standard_name: "Springer Healthcare" standard_name: "Springer Healthcare" unit_pk: 249 unit_pk: 249 wikidata: "https://wikidata.org/wiki/Q52636673" wikidata: "https://wikidata.org/wiki/Q52636673" ror: "" ror: "" url: "https://springerhealthcare.com/" url: "https://springerhealthcare.com/" Relations between Publishers Relations between Publishers The following table contains relationships between publishers, e.g. when a publisher belongs to The following table contains relationships between publishers, e.g. when a publisher belongs to another publisher. another publisher. Data File: Data File: publishers_relations.csv publishers_relations.csv Field Field Type Type Description Description p_relation_id p_relation_id INTEGER INTEGER The ID for this relation The ID for this relation child_name child_name STRING STRING The name of this publisher The name of this publisher child_id child_id STRING STRING The OpenAlex ID of this publisher The OpenAlex ID of this publisher child_unit child_unit INTEGER INTEGER The internal ID of this publisher The internal ID of this publisher parent_name parent_name STRING STRING The name of the parent publisher The name of the parent publisher parent_id parent_id STRING STRING The OpenAlex ID of the parent publisher The OpenAlex ID of the parent publisher parent_unit parent_unit INTEGER INTEGER The internal ID of this parent publisher The internal ID of this parent publisher first_date first_date DATE DATE Date on which the connection to the parent publisher took Date on which the connection to the parent publisher took place place last_date last_date DATE DATE Date on which the connection to the parent publisher was Date on which the connection to the parent publisher was revoked revoked Example Record Example Record p_relation_id: 340 p_relation_id: 340 child_name: "BioMed Central" child_name: "BioMed Central" child_id: "https://openalex.org/P4310320256" child_id: "https://openalex.org/P4310320256" child_unit: 81 child_unit: 81 parent_name: "Springer Science+Business Media" parent_name: "Springer Science+Business Media" parent_id: "https://openalex.org/P4310319900" parent_id: "https://openalex.org/P4310319900" parent_unit: 79 parent_unit: 79 first_date: "2008-10-01" first_date: "2008-10-01" last_date: "2015-04-30" last_date: "2015-04-30" Funding information 📄 Funding information Funding information is provided for publications funded by the German Funding information is provided for publications funded by the German Open-AccessOpen-AccessPublikationskosten Publikationskosten program. program. Data File: Data File: funding_information.csv funding_information.csv Limitations: Only includes publications from 2020 to 2025 Limitations: Only includes publications from 2020 to 2025 Field Field Type Type Description Description openalex_id openalex_id STRING STRING The OpenAlex id of this work The OpenAlex id of this work doi doi STRING STRING The DOI of this work The DOI of this work funding_id funding_id TEXT TEXT The grant id(s) we found for this work The grant id(s) we found for this work Example Record Example Record openalex_id: "https://openalex.org/W4321327768" openalex_id: "https://openalex.org/W4321327768" doi: "10.1002/1873-3468.14601" doi: "10.1002/1873-3468.14601" funding_id: ["430651076"] funding_id: ["430651076"] Document types 🗂 Document types Journals publish different types of scholarly works such as research articles, reviews, book Journals publish different types of scholarly works such as research articles, reviews, book reviews, case reports and editorials. The latter are sometimes classified as articles in OpenAlex. reviews, case reports and editorials. The latter are sometimes classified as articles in OpenAlex. Using a machine learning classifier helps to distinguish between research contributions and Using a machine learning classifier helps to distinguish between research contributions and other types of works. other types of works. Data File: Data File: document_types.csv document_types.csv Limitations: Only includes articles and reviews from OpenAlex with the Limitations: Only includes articles and reviews from OpenAlex with the source type journal and the publication year 2014 to 2025. source type journal and the publication year 2014 to 2025. Field Field Type Type Description Description openalex_id openalex_id STRING STRING The OpenAlex id of this work The OpenAlex id of this work doi doi STRING STRING The DOI of this work The DOI of this work is_research is_research BOOLEAN BOOLEAN True if the classifier detect this work as a research True if the classifier detect this work as a research contribution contribution proba proba FLOAT FLOAT The probability that this work is a research contribution The probability that this work is a research contribution Example Record Example Record openalex_id: "https://openalex.org/W4256503663" openalex_id: "https://openalex.org/W4256503663" doi: "10.1016/s0099-2399(15)00667-6" doi: "10.1016/s0099-2399(15)00667-6" is_research: false is_research: false proba: 0.16 proba: 0.16 Examples of works that are considered as non-research publications by the classifier: Examples of works that are considered as non-research publications by the classifier: https://openalex.org/works/W2264593839 https://openalex.org/works/W2264593839 (Abstract) (Abstract) https://openalex.org/works/W4256503663 https://openalex.org/works/W4256503663 (Table of Contents) (Table of Contents) https://openalex.org/works/W4400195825 https://openalex.org/works/W4400195825 (Book Review) (Book Review) https://openalex.org/works/W4255159712 https://openalex.org/works/W4255159712 (Case Report) (Case Report) Transformative Agreements 📑 Transformative Agreements Overview Overview This dataset comprises historic snapshots from the This dataset comprises historic snapshots from the cOAlitionS Transformative Agreements cOAlitionS Transformative Agreements Public Data Public Data dump underlying the cOAlition S Journal Checker Tool (JCT). The data files were dump underlying the cOAlition S Journal Checker Tool (JCT). The data files were safeguarded on a weekly basis using a safeguarded on a weekly basis using a bot bot . . Note that this data release is based on data from July 2025, including OpenAlex. Note that this data release is based on data from July 2025, including OpenAlex. Dataset Components Dataset Components The dataset consists of four primary tables: The dataset consists of four primary tables: 1. ! ! jct_journals jct_journals ! ! - Journals covered by transformative agreements - Journals covered by transformative agreements 2. ! ! jct_institutions jct_institutions ! ! - Institutions participating in transformative agreements - Institutions participating in transformative agreements 3. ! ! jct_articles jct_articles ! ! - Articles published under transformative agreements - Articles published under transformative agreements 4. ! ! jct_esac jct_esac ! ! - Metadata about the transformative agreements from the ESAC registry - Metadata about the transformative agreements from the ESAC registry Table Descriptions Table Descriptions Journals ( Journals ( ! ! jct_journals.csv jct_journals.csv ! ! ) ) This table contains journals covered by transformative agreements. Journal ISSN variants are This table contains journals covered by transformative agreements. Journal ISSN variants are disambiguated using ISSN-L according to the ISSN agency. disambiguated using ISSN-L according to the ISSN agency. Field Field Type Type Description Description esac_id esac_id STRING STRING Identifier for the transformative agreement Identifier for the transformative agreement issn_l issn_l STRING STRING ISSN-L identifying the journal ISSN-L identifying the journal time_last_seen time_last_seen TIMESTAMP TIMESTAMP Last time this data was available in the Journal Checker Last time this data was available in the Journal Checker Tool Tool commit_hash commit_hash STRING STRING Data snapshot Git commit ID Data snapshot Git commit ID Example Record Example Record esac_id: "acm2020delft" esac_id: "acm2020delft" issn_l: "2153-2184" issn_l: "2153-2184" time_last_seen: "2024-04-01 09:23:06 UTC" time_last_seen: "2024-04-01 09:23:06 UTC" commit_hash: "a689426e782c5f42b850b327a1a89d9ad9d19a16" commit_hash: "a689426e782c5f42b850b327a1a89d9ad9d19a16" Institutions ( Institutions ( ! ! jct_institutions.csv jct_institutions.csv ! ! ) ) This table maps institutions to transformative agreements they participate in. The institution This table maps institutions to transformative agreements they participate in. The institution data is enriched with associated ROR-IDs according to OpenAlex. data is enriched with associated ROR-IDs according to OpenAlex. Field Field Type Type Description Description esac_id esac_id STRING STRING Identifier for the transformative agreement Identifier for the transformative agreement inst_name inst_name STRING STRING The institution name The institution name ror_id ror_id STRING STRING ROR-ID of the participating institution ROR-ID of the participating institution time_last_seen time_last_seen TIMESTAMP TIMESTAMP Last time this data was available in the Journal Checker Last time this data was available in the Journal Checker Tool Tool commit_hash commit_hash STRING STRING Data snapshot Git commit ID Data snapshot Git commit ID Example Record Example Record esac_id: "acm2020ie" esac_id: "acm2020ie" inst_name: "Dublin City University" inst_name: "Dublin City University" ror_id: "https://ror.org/04a1a1e81" ror_id: "https://ror.org/04a1a1e81" time_last_seen: "2023-01-02 02:19:56 UTC" time_last_seen: "2023-01-02 02:19:56 UTC" commit_hash: "fd749477fbe5e0d58040bdaa4466e63886e9fb17" commit_hash: "fd749477fbe5e0d58040bdaa4466e63886e9fb17" Articles ( Articles ( ! ! jct_articles.csv jct_articles.csv ! ! ) ) This table contains articles enabled by transformative agreements based on first-author This table contains articles enabled by transformative agreements based on first-author affiliations in OpenAlex. affiliations in OpenAlex. Field Field Type Type Description Description id id STRING STRING OpenAlex identifier for the publication OpenAlex identifier for the publication doi doi STRING STRING Digital Object Identifier for the publication Digital Object Identifier for the publication matching_issn_l matching_issn_l STRING STRING ISSN-L identifying the journal ISSN-L identifying the journal matching_ror matching_ror STRING STRING ROR-ID used to match between OpenAlex and Journal ROR-ID used to match between OpenAlex and Journal Checker Tool data Checker Tool data ror_type ror_type STRING STRING Type of ROR match (e.g., “ror_jct”) Type of ROR match (e.g., “ror_jct”) esac_id esac_id STRING STRING Identifier for the transformative agreement from ESAC Identifier for the transformative agreement from ESAC Registry Registry start_date start_date DATE DATE Agreement start date Agreement start date end_date end_date DATE DATE Agreement end date Agreement end date publication_date publication_date DATE DATE Publication date according to OpenAlex Publication date according to OpenAlex Example Record Example Record id: "https://openalex.org/W3107077096" id: "https://openalex.org/W3107077096" doi: "10.1145/3428248" doi: "10.1145/3428248" matching_issn_l: "2475-1421" matching_issn_l: "2475-1421" matching_ror: "https://ror.org/02e2c7k09" matching_ror: "https://ror.org/02e2c7k09" ror_type: "ror_jct" ror_type: "ror_jct" esac_id: "acm2020delft" esac_id: "acm2020delft" start_date: "2020-11-01" start_date: "2020-11-01" end_date: "2023-12-31" end_date: "2023-12-31" publication_date: "2020-11-13" publication_date: "2020-11-13" ESAC Registry ( ESAC Registry ( ! ! jct_esac.csv jct_esac.csv ! ! ) ) This table provides metadata about transformative agreements from the ESAC Registry. This table provides metadata about transformative agreements from the ESAC Registry. Field Field Type Type Description Description publisher publisher STRING STRING Name of the publisher Name of the publisher country country STRING STRING Country where the agreement is applicable Country where the agreement is applicable organization organization STRING STRING Organization that negotiated the agreement Organization that negotiated the agreement annual_publications annual_publications INTEGER INTEGER Estimated number of articles published annually Estimated number of articles published annually under the agreement under the agreement start_date start_date TIMESTAMP TIMESTAMP Agreement start date Agreement start date end_date end_date TIMESTAMP TIMESTAMP Agreement end date Agreement end date id id STRING STRING Unique identifier for the agreement Unique identifier for the agreement url url STRING STRING URL to the agreement details in the ESAC Registry URL to the agreement details in the ESAC Registry jct_jn jct_jn BOOLEAN BOOLEAN Indicates if any journals are recorded under this Indicates if any journals are recorded under this agreement in JCT agreement in JCT jct_inst jct_inst BOOLEAN BOOLEAN Indicates if any institutions are recorded under this Indicates if any institutions are recorded under this agreement in JCT agreement in JCT Example Record Example Record Data Relationships Data Relationships Articles to Journals Articles to Journals : Articles are linked to journals via the : Articles are linked to journals via the ! ! matching_issn_l matching_issn_l ! ! field field Articles to Institutions Articles to Institutions : Articles are linked to institutions via the : Articles are linked to institutions via the ! ! matching_ror matching_ror ! ! field field Agreements Agreements : All tables are linked via the : All tables are linked via the ! ! esac_id esac_id ! ! field representing specific field representing specific transformative agreements transformative agreements Authors (tba) 👩🎓 Authors (tba) In the Authors section, we focus on improving author name disambiguation (AND) for German In the Authors section, we focus on improving author name disambiguation (AND) for German authors by developing a machine learning pipeline that links authorships to individual authors, authors by developing a machine learning pipeline that links authorships to individual authors, using metadata from OpenAlex filtered by affiliation, publication date, etc. Key attributes from using metadata from OpenAlex filtered by affiliation, publication date, etc. Key attributes from both authorships and works (e.g., raw author names, DOIs, topics) are used, with blocking both authorships and works (e.g., raw author names, DOIs, topics) are used, with blocking strategies like Last Name First Initial (LNFI) employed to reduce comparison complexity. Future strategies like Last Name First Initial (LNFI) employed to reduce comparison complexity. Future enhancements include progressive blocking and graph embedding models to further refine the enhancements include progressive blocking and graph embedding models to further refine the disambiguation process. disambiguation process. Field Field Type Type Description Description kb_author_disambig kb_author_disambig STRING STRING Internal id for author Internal id for author work_ids work_ids ARRAY[STRING] ARRAY[STRING] Associated OpenAlex work IDs for the author Associated OpenAlex work IDs for the author author_name_arr author_name_arr ARRAY[STRING] ARRAY[STRING] Representations of raw author name in Representations of raw author name in OpenAlex OpenAlex author_id_arr author_id_arr ARRAY[STRING] ARRAY[STRING] OpenAlex Author IDs (if present) OpenAlex Author IDs (if present) orcid orcid STRING STRING Orcid (if present) Orcid (if present) inst_id_top: 5617 inst_id_top: 5617 openalex_id: "https://openalex.org/W2074596230" openalex_id: "https://openalex.org/W2074596230" address_full: "Max-Plank-Institut für Biophysikalische Chemie, Göttingen, Germany, DE" address_full: "Max-Plank-Institut für Biophysikalische Chemie, Göttingen, Germany, DE" sector_id: ["mpg"] sector_id: ["mpg"] doi: "10.1007/s004310050674" doi: "10.1007/s004310050674" identifier: "10.1007/s004310050674§5617" identifier: "10.1007/s004310050674§5617" inst_id_top: 1073 inst_id_top: 1073 openalex_id: "https://openalex.org/W3031617943" openalex_id: "https://openalex.org/W3031617943" address_full: "Department of Molecular Neurobiology, Max Planck Institute of Experimental Medicine, Göttingen 37075, Germany" address_full: "Department of Molecular Neurobiology, Max Planck Institute of Experimental Medicine, Göttingen 37075, Germany" sector_id: ["mpg"] sector_id: ["mpg"] doi: "10.1016/j.isci.2020.101203" doi: "10.1016/j.isci.2020.101203" identifier: "10.1016/j.isci.2020.101203§1073" identifier: "10.1016/j.isci.2020.101203§1073" publisher: "Taylor & Francis" publisher: "Taylor & Francis" country: "Austria" country: "Austria" organization: "KEMOE/FWF" organization: "KEMOE/FWF" annual_publications: 70 annual_publications: 70 start_date: "2014-01-01 00:00:00 UTC" start_date: "2014-01-01 00:00:00 UTC" end_date: "2016-12-31 00:00:00 UTC" end_date: "2016-12-31 00:00:00 UTC" id: "tf2014kemoe" id: "tf2014kemoe" url: "https://esac-initiative.org/about/transformative-agreements/agreement-registry/tf2014kemoe/" url: "https://esac-initiative.org/about/transformative-agreements/agreement-registry/tf2014kemoe/" jct_jn: false jct_jn: false jct_inst: false jct_inst: false Expand all Expand all Back to top Back to top Go to bottom Go to bottom Entities overview Entities overview Address information 🏛 Address information Publishers 📚 Publishers Funding information 📄 Funding information Document types 🗂 Document types Transformative Agreements 📑 Transformative Agreements Authors (tba) 👩🎓 Authors (tba)