{"id":7635,"date":"2026-02-16T04:10:10","date_gmt":"2026-02-16T04:10:10","guid":{"rendered":"https:\/\/blog.doaj.org\/?p=7635"},"modified":"2026-02-16T04:10:10","modified_gmt":"2026-02-16T04:10:10","slug":"update-to-our-metadata-four-new-columns-in-our-journal-csv","status":"publish","type":"post","link":"https:\/\/blog.doaj.org\/de\/2026\/02\/16\/update-to-our-metadata-four-new-columns-in-our-journal-csv\/","title":{"rendered":"Update to our metadata: Four new columns in our journal CSV"},"content":{"rendered":"

We have added new metadata to our journal CSV, journal TOC pages, search results and API that you need to know about, especially if you integrate our metadata into any of your systems.<\/em><\/em><\/em><\/p>\n\n\n\n

The new metadata is best explained by looking at our Journal CSV<\/a>. In the sections below, the column name (for example \u201cColumn AR\u201d) maps exactly to the columns in our journal CSV file. We have added four new columns:<\/p>\n\n\n\n

Column AR: \u2018Subscribe to Open\u2019<\/strong><\/p>\n\n\n\n

This was added back in March 2025 and was the first of several planned labels. This column indicates whether or not the journal uses the Subscribe to Open (S2O) business model. The information comes from a list of journals we hold at DOAJ.\u00a0 The information appears in the CSV, the API, on a journal’s individual page in DOAJ and in search results (see screenshot below).<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Column AS: \u2018Mirror Journal\u2019<\/strong><\/p>\n\n\n\n

Added on 18th December 2025 and indicates whether or not a journal uses the \u2018mirror journal\u2019 model that, at one point in time, was popular with Elsevier publishing in particular, although it is not limited to this publisher’s journals. This information comes from an internal list held by DOAJ. The information appears in the journal CSV only.<\/p>\n\n\n\n

Column AT: \u2018Open Journals Collective\u2019<\/strong><\/p>\n\n\n\n

Added on 18th December 2025 and indicates whether or not a journal can be found in the Open Journals Collective (OJC) collection<\/a>. This information comes from a list of journals provided to DOAJ by OJC. The information appears in the journal CSV only.<\/p>\n\n\n\n

ColumnAX: \u2018Last Full Review Date\u2019<\/strong><\/p>\n\n\n\n

Added on 15th January 2026 and indicates the last time every metadata point in the journal record was reviewed by one of our Managing Editors. The information appears at the bottom of a journal’s individual entry in DOAJ, in search results, in the CSV and in the API. The purpose of this field is to better indicate the recency of an entire record, rather than the ‘Updated’ date, which changes if only one metadata point is edited in a journal’s record. For example: a publisher may update a journal’s APC but nothing else. In this case, only the ‘Updated’ date will change. If a Managing Editor reviews the entire record at the same time, both the ‘Updated’ and the ‘Last Full Review’ dates will change.<\/p>\n\n\n\n

\u2018Last Full Review\u2019 versus \u2018Updated\u2019<\/strong><\/p>\n\n\n\n

Moving forward, we believe that the ‘Last Full Review’ date will be more useful to the community as an indication of a record’s recency than the ‘Updated’ date. Currently, both appear alongside the ‘Date added’ on the bottom a journal’s DOAJ entry<\/a> (screenshot below):<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Later in the year, we will consider removing the ‘Updated’ date from the journal pages but will retain it in our metadata endpoints. <\/p>\n\n\n\n

If you have any questions about any of these additions, please don’t hesitate to leave a response here or contact us.<\/p>\n\n\n\n

<\/p>\n\n\n\n

<\/p>\n\n\n\n

<\/p>","protected":false},"excerpt":{"rendered":"

We have added new metadata to our journal CSV, journal TOC pages, search results and API that you need to know about, especially if you integrate our metadata into any of your systems. The new metadata is best explained by looking at our Journal CSV. In the sections below, the column name (for example \u201cColumn…<\/p>","protected":false},"author":378,"featured_media":5683,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_s2mail":"yes","_kadence_starter_templates_imported_post":false,"_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"_kad_post_classname":"","footnotes":""},"categories":[616,617,618,1285],"tags":[1286,276,334,1300,1287,459],"class_list":["post-7635","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-metadata","category-new-feature","category-news-update","category-research-and-data","tag-doaj-data","tag-infrastructure","tag-metadata","tag-open-journals-collective","tag-research-data","tag-scholarly-communications"],"_links":{"self":[{"href":"https:\/\/blog.doaj.org\/de\/wp-json\/wp\/v2\/posts\/7635","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.doaj.org\/de\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.doaj.org\/de\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.doaj.org\/de\/wp-json\/wp\/v2\/users\/378"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.doaj.org\/de\/wp-json\/wp\/v2\/comments?post=7635"}],"version-history":[{"count":4,"href":"https:\/\/blog.doaj.org\/de\/wp-json\/wp\/v2\/posts\/7635\/revisions"}],"predecessor-version":[{"id":7642,"href":"https:\/\/blog.doaj.org\/de\/wp-json\/wp\/v2\/posts\/7635\/revisions\/7642"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.doaj.org\/de\/wp-json\/wp\/v2\/media\/5683"}],"wp:attachment":[{"href":"https:\/\/blog.doaj.org\/de\/wp-json\/wp\/v2\/media?parent=7635"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.doaj.org\/de\/wp-json\/wp\/v2\/categories?post=7635"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.doaj.org\/de\/wp-json\/wp\/v2\/tags?post=7635"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}