Where in the derived dump I can find the ratings themselves?

database
schema
rating
datadump
Tags: #<Tag:0x00007fd5e2154d60> #<Tag:0x00007fd5e2154b80> #<Tag:0x00007fd5e21546a8> #<Tag:0x00007fd5e2154298>

#1

Hi,
I’m working on a university project and need to filter out unknown artists, someone here told me that I can find the ratings in the derived dump, but when I downloaded it to my computer I found no ratings table, so could someone please tell me how does the ratings are stored in the derived dump?


#2

The dumps are designed to be imported into a database so you can start with a musicbrainz server install (such as the vm), mbslave or mbzdb

There should be data in artist_meta, artist_rating_raw, event_meta, event_rating_raw, label_meta, label_rating_raw, recording_meta, recording_rating_raw,release_group_meta, release_group_rating_raw, work_meta and work_rating_raw.


#3

But I can’t find artist_rating_raw for exmple…
In which dump file can I find it?


#4

I think this is found in mbdump-derived.tar.bz2 and is under the cc-a-nc-sa license.


#5

What is the cc-a-nc-sa license?
When I downloaded the derived dump, I could not find the artist_rating_raw there…


#6

You might not have _raw, since that’s per-user data. You should be able to get the average rating from the _meta tables, IIRC.


#7

Can you please elaborate? I didn’t understand you.
What per user data means?
How can I get the average ratings from the meta tables? and where can I find them?

Thanks!


#8

See https://wiki.musicbrainz.org/MusicBrainz_Database/Schema#.2A_rating_raw_.26_.2A_meta_tables