The field in the Discogs database that is definitely the most misunderstood is the so called "Label Code". Many people think that this is a generic "catch all" field for any code printed on a label, but that is COMPLETELY WRONG. The Label Code is a (somewhat) unique identifier for a record label. It was introduced in Europe somewhere in the 1970s and is now in widespread use. This is all explained in the other articles I have written about this field and I recommend you read those first (especially the first article).
Many Discogs contributors think that just because there is a code on a label it should be in the Label Code field. In the latest download (all releases up until October 31 2019) there are a bit over 44,000 releases that have a wrong value in this field. That's quite a few.
Then there are also releases where a Label Code should be present, but isn't (and of course I don't know how many), plus around 9,000 where someone indicated that there could be a Label Code (including wrong ones, I didn't check there) but where the wrong field was used.
For the following tests I ignored all of those and focused on the Label Codes where I was 100% certain that they were correct:
I looked at 732,368 Label Code fields, of which 701,214 were found to be valid according to the criteria above. I found 12,079 unique label codes. The top 10:
I am certain that people mistyped digits, so the results are most probably not entirely accurate. I have not checked that, as that will take more time to write the code to map label names back to label codes, and time is something I currently don't have.
Just for completeness, here is the top 50 of Label Codes that were found. Please note: they have been padded to 6 digits, so when searching you might want to remove the first zero or the first two zeroes. For a list of some of the label codes I recommend to look at this Discogs forum post.
Many Discogs contributors think that just because there is a code on a label it should be in the Label Code field. In the latest download (all releases up until October 31 2019) there are a bit over 44,000 releases that have a wrong value in this field. That's quite a few.
Then there are also releases where a Label Code should be present, but isn't (and of course I don't know how many), plus around 9,000 where someone indicated that there could be a Label Code (including wrong ones, I didn't check there) but where the wrong field was used.
For the following tests I ignored all of those and focused on the Label Codes where I was 100% certain that they were correct:
- letters "LC"
- 4 to 6 digits
I looked at 732,368 Label Code fields, of which 701,214 were found to be valid according to the criteria above. I found 12,079 unique label codes. The top 10:
- LC 000309: 23064 (Polydor)
- LC 003098: 20591 (Virgin)
- LC 000542: 20498 (EMI)
- LC 000149: 18328 (CBS)
- LC 000316: 18152 (RCA)
- LC 000162: 16573 (Columbia)
- LC 000199: 15550 (Epic)
- LC 000268: 12705 (Mercury)
- LC 004281: 11747 (WEA)
- LC 000116: 11500 (Ariola)
I am certain that people mistyped digits, so the results are most probably not entirely accurate. I have not checked that, as that will take more time to write the code to map label names back to label codes, and time is something I currently don't have.
Just for completeness, here is the top 50 of Label Codes that were found. Please note: they have been padded to 6 digits, so when searching you might want to remove the first zero or the first two zeroes. For a list of some of the label codes I recommend to look at this Discogs forum post.
- LC 000309: 23064
- LC 003098: 20591
- LC 000542: 20498
- LC 000149: 18328
- LC 000316: 18152
- LC 000162: 16573
- LC 000199: 15550
- LC 000268: 12705
- LC 004281: 11747
- LC 000116: 11500
- LC 000407: 9945
- LC 000392: 8920
- LC 000173: 8123
- LC 006350: 8029
- LC 000485: 7165
- LC 000121: 7143
- LC 001846: 6589
- LC 007027: 6191
- LC 000299: 6014
- LC 000171: 5744
- LC 003484: 5605
- LC 001056: 5340
- LC 000148: 5126
- LC 006448: 5021
- LC 000305: 4339
- LC 005834: 4266
- LC 000835: 3985
- LC 001557: 3956
- LC 007800: 3786
- LC 007654: 3650
- LC 007266: 3626
- LC 001633: 3497
- LC 002516: 3442
- LC 006975: 3392
- LC 006406: 3329
- LC 005680: 3196
- LC 000192: 3158
- LC 000270: 3020
- LC 001626: 2963
- LC 003706: 2915
- LC 000322: 2789
- LC 007925: 2755
- LC 005537: 2716
- LC 000967: 2679
- LC 009231: 2580
- LC 000383: 2563
- LC 006646: 2550
- LC 000881: 2421
- LC 006868: 2419
- LC 001666: 2262
Comments
Post a Comment