MBDUMP.TAR Trying to link Genre to release group

I’m performing some music consolidation against the Musicbrainz Database dump mbdump.tar.bz2 and I’ve identifed most of the things I’m looking for, but what I can’t work out is how to link Genres to release groups.
There’s a table called genre which lists all the valid genres but I can’t find the associated table, and it’s not mentioned in the schema (https://musicbrainz.org/doc/MusicBrainz_Database/Schema).

Hoping someone can help.

Genres are implemented on top of the folksonomy tags, so I think you need to look at the *_tag tables.

The genre table then just lists the tags that are considered genres.

I had seen reference to tags but there aren’t any tables named like that in the export (mbdump.tar.bz2). Maybe they’re not exported, or there’s another to download?

looking at
https://musicbrainz.org/doc/MusicBrainz_Database/Download it mentions “user tags” as being in the mbdump-derived download.

1 Like

That’s excellent, I don’t know how I missed that!

It looks like the release id (first column from mbdump.release_group) links to mbdump-derived.release_group_tag which in turn links to mbdump-derived.tag to give you the literal translation. My guess is that the Musicbrainz approved list of genres is from mbdump.genre.

Thanks for your help everyone.