I am compiling the musicBrainz database for a music related project of my own, and I have to dedupe releases for each unique track/song based on most recent release. I also associate ISRC and artist details to my recording data.
Question: How do I associate genre to these recordings? In the schema description, it is given that there is an entity called “Tags” which should have genres. But, I am not able to figure out how to connect these tags to each recording.
Hi! Sorry, I completely missed this, and it seems so did others
This is mentioned on a section on the schema docs but it can be confusing.
Basically, there’s a recording_tag
table that should contain the connections between tags and recordings (how many up/downvotes they have and whatnot). You can join to recording
and tag
to actually get the matching between a recording ID and a tag name.
If you want only tags we consider genres, you can join the resulting tags with the genre
table on tag name = genre name, to restrict the results. You can also just filter the tags yourself based on your own genre list if you want less or more genres than we do.
1 Like