Skip to main content

Finding out of date formatting codes in Discogs

Like many other websites Discogs allows you to use certain formatting codes that is then automatically expanded. For example, to link to a release you can use [r000000] (where of course "000000" should be a real release number) which is then expanded to a link to the release. There are also other formatting codes. The benefit is that if necessary Discogs can rearrange their infrastructure and then the links will (or at least should) still be working. Unfortunately they don't have it implemented correctly everywhere (yet), as on the iOS app it doesn't seem to be working (bug report has been sent):



These codes are not automatically updated when releases are merged, or removed and then the links basically become useless. So I was wondering: how many releases are there with formatting codes to releases that no longer exist: how many dangling pointers are still there?

I grabbed the latest data dump and first looked at all the existing releases that were not drafts and stored them, then checked all the notes for any formatting codes for releases and extracted them, and then checked whether or not they could be found in the list of existing releases.

I looked at notes of 11,232,020 releases and found that 250,679 releases are referencing one or more other releases using the formatting tags. That is actually a lot less than expected, namely a bit over 2.23%. There are quite a few (old) releases that are still using direct URLs (before there were formatting tags), but how many is something for another day.

Of these releases I found 963 releases that potentially have out of date references. Some of these pointed to draft releases that have now been promoted to full releases, but these are really just a handful. Most of the dangling pointers point to either draft releases (the result of a merge of other releases) or point to releases that no longer exist. This is actually not too bad, but the releases should still be fixed.

There were also 8 releases where someone typed in a few too many digits, referencing a release that likely won't be added in the next few years, because it has a release number that won't be handed out anytime soon: release numbers are assigned incrementally in Discogs. Currently almost 14 million release numbers have been assigned. One of the invalid pointers references a release with release number larger than 133 million. As said before: data entry is hard and people don't check.

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: