After matching a single yr Japanese serial with previous check for duplicates

-- List every value in `jap_2024` that appears more than once,

-- with a count of how many times each one occurs.

SELECT `jap_2024`,

       COUNT(*) AS occurrences

FROM `0_jap_raw_serials_mapped_by_year`

GROUP BY `jap_2024`

HAVING COUNT(*) > 1

ORDER BY occurrences DESC, `jap_2024`;


Produces:

 

The second serial from the top appears to be the correct one, as it has the most comprehensive data when cross-referenced with the raw MDC spreadsheets.

Solution

Make a note of the previous year's serial number. Then delete the row and replace the '-' with that serial number.

Do this in all the captured MDC groups (08, 09 & 10) files of which there a total of 53. The better way is to run a series of customised MySQL queries to do this, which can be constructed quickly in Excel.

Duplicate Jap Serial Fix.xlsx



Topic last reviewed: 22/06/26