Skip to main content

ISRC codes in Discogs (part 3)

Time to revisit the ISRC codes. I already talked about these twice, namely how many errors for these codes there are in Discogs, as well as how to extract them from a CD.

In the first of those posts I already hinted at that there is actually a year component in the ISRC codes. The ISRC code for a single track has 12 characters. Characters 6 and 7 should be digits indicating the year the code was assigned (although in the early days some ISRC codes were handed out where the year the song was written or when the recording was made). It would of course been easier if they would have used 4 characters, but they didn't.

That means that the year component from the ISRC code can be used to check whether or not a release is correctly dated, because a release cannot be from earlier than the year the ISRC was assigned.

I adapted my scripts to check for a few things:
  • is the format confirming to the ISRC standard?
  • is the year recorded in the ISRC not later than the date of the release?
The latter could indicate a few things: wrong release date, mistake in the ISRC, or mistake when entering the data.

I only looked at the entries where ISRC fields were very clearly marked using the ISRC field. As shown in earlier blog posts there are still some 55,000 other entries where this needs to be fixed. These have not been looked at.

For this blog post I looked at 18550 releases with in total 45446 ISRC codes. Of these I could find 676 ISRC codes with an error, in 280 releases (my guess is that when looking at the other 55,000 releases as well these numbers will likely triple). In Discogs they are distributed as follows:

Distribution of releases with wrong ISRC fields
Of these 7 releases (with 8 ISRC codes) were not confirming to the format. As it turned out a few of these actually described a range of ISRC codes and were meant for the entire release (another reason to try to record the ISRC codes with the tracks). Others were errors, where for example 'O' (capital o) was used instead of '0' (zero).

The other releases (273 individual releases with 668 ISRC codes) had an error where the release year was earlier than the year stored in the ISRC. For a handful of these I already confirmed that it was in fact a data entry error, but I still need to look at the others.

Personally I think that this check is quite effective and I am happy with the results.

Comments

Popular posts from this blog

SID codes (part 1)

One thing that I only learned about after using Discogs is the so called Source Identification Code, or SID. These codes were introduced in 1994 to combat piracy and to find out on which machines a CD was made. It was introduced by Philips and adopted by IFPI, and specifications are publicly available which clearly describe the two available SID codes (mastering SID code and mould SID code). Since quite a few months Discogs has two fields available in the " Barcode and Other Identifiers " (BaOI) section: Mould SID code Mastering SID code A few questions immediately popped up in my mind: how many releases don't have a SID field defined when there should be (for example, the free text field indicates it is a SID field)? how many releases have a SID field with values that should not be in the SID field? how many release have a SID field, but a wrong year (as SID codes were only introduced in 1994) how many vinyl releases have a SID code defined (which is impossi

SPARS codes (part 1)

Let's talk about SPARS codes used on CDs (or CD-like formats). You have most likely seen it used, but maybe don't know its name. The SPARS code is a three letter code indicating if recording, mixing and mastering were analogue or digital. For example they could look like the ones below. There is not a fixed format, so there are other variants as well. Personally I am not paying too much attention to these codes (I simply do not care), but in the classical music world if something was labeled as DDD (so everything digital) companies could ask premium prices. That makes it interesting information to mine and unlock, which is something that Discogs does not allow people to do when searching (yet!) even though it could be a helpful filter. I wanted to see if it can be used as an identifier to tell releases apart (are there similar releases where the only difference is the SPARS code?). SPARS code in Discogs Since a few months SPARS is a separate field in the Discogs

Country statistics (part 2)

One thing I wondered about: for how many releases is the country field changed? I looked at the two most recent data dumps (covering February and March 2019) and see where they differed. In total 5274 releases "moved". The top 20 moves are: unknown -> US: 454 Germany -> Europe: 319 UK & Europe -> Europe: 217 unknown -> UK: 178 UK -> Europe: 149 Netherlands -> Europe: 147 unknown -> Europe: 139 unknown -> Germany: 120 UK -> US: 118 Europe -> Germany: 84 US -> UK: 79 USA & Canada -> US: 76 US -> Canada: 65 unknown -> France: 64 UK -> UK & Europe: 62 UK & Europe -> UK: 51 France -> Europe: 51 Saudi Arabia -> United Arab Emirates: 49 US -> Europe: 46 unknown -> Japan: 45 When you think about it these all make sense (there was a big consolidation in Europe in the 1980s and releases for multiple countries were made in a single pressing plant) but there are also a few weird changes: