Multiple title_j for the same ISSN/ISSNe

[cverluise]

Issue

Some npl publications sharing the same ISSN(e) have different title_j (journal title). E.g

ISSN	journal_titles
0946-2171	Applied Physics B,Applied Physics B Laser and Optics,Applied Physics B Lasers and Optics,Applied Physics B: Lasers and Optics
0003-021X	Journal of the American Oil Chemists Society,Journal of the American Oil Chemists' Society,Journal of the American Oil Chemists’ Society
0236-5731	Journal of Radioanalytical and Nuclear Chemistry Articles,Journal of Radioanalytical and Nuclear Chemistry Letters,Journal of Radioanalytical and Nuclear Chemistry

Quantitively, this seems to be the case for 0.5-1% of npl_publications_id in the beta.

How to reproduce the behaviour

WITH
  tmp AS (
  SELECT
    title_j,
    ISSN,
    COUNT(npl_publn_id ) AS count
  FROM
    `npl-parsing.patcit.beta`
  WHERE
    ISSN IS NOT NULL
    AND ISSN!=""
  GROUP BY
    title_j,
    ISSN )
SELECT
  ISSN,
  STRING_AGG(title_j) AS journal_titles,
  SUM(count) AS sum,
  COUNT(ISSN) AS count
FROM
  tmp
GROUP BY
  ISSN
ORDER BY
  count DESC

Ideas/ solutions

title_j could be standardized using the title_proper reported at https://portal.issn.org/

Any suggestions welcome

[cverluise]

Actually, this is due to the fact that even when there is a match, the parsed attributes are not overwritten by crossref equivalents.

Also, this is a nice feature as we use it to propagate ISSN out of doi matches in v0.2.

I close the issue as this is not a real issue