Re: [mb-users] where to find ratings in db dump

On Fri, Jun 13, 2014 at 01:18:08PM -0400, Calvin Walton wrote:
> On Fri, 2014-06-13 at 01:22 +0100, Marcel Ackermann wrote:
> > Hi,
> >
> > I've downloaded and extracted the latest mbdump.tar.bz2, derived,
> > edit, editor, stats - but wasn't able to locate the ratings of (track,
> > album, artist).
> > In which archive and which file within this archive do I find those?
>
> I believe that the recording, release group, and artist ratings overall
> ratings can be found in the "recording_meta", "release_group_meta" and
> "artist_meta" tables, which should be included in the dump - these
> tables are probably in the -derived tar file along with other CC-NC
> licensed data.
>
> Note that we don't store track ratings, and 'album' is just a release
> type. Depending on what you want to use the data for, either of the
> "release" or "release group" ratings might be appropriate.
>

Releases don't have ratings, only release groups
(http://tickets.musicbrainz.org/browse/MBS-4816)

Otherwise all of this is correct.

> The rating data in MusicBrainz itself is, of course, notoriously
> incomplete. You have to be a registered editor to use ratings, and not
> many active editors do anything with them.
>
> I'm not sure about whether we include per-user information about ratings
> in the dumps - this is probably stripped out for privacy issues.
>

Yes; the *_rating_raw tables are not included in data dumps, only the
aggregate information in the *_meta tables, as noted above.

> --
> Calvin Walton <[email protected]>
>
>
> _______________________________________________
> MusicBrainz-users mailing list
> [email protected]
> http://lists.musicbrainz.org/mailman/listinfo/musicbrainz-users

_______________________________________________
MusicBrainz-users mailing list
[email protected]
http://lists.musicbrainz.org/mailman/listinfo/musicbrainz-users

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.22 (GNU/Linux)

iEYEARECAAYFAlObM3cACgkQq+0avXExp2/SOQCfX7CMI42cBMnYjnuC9jaQ5lTs
TTEAn0hm+qsAn9XCMrluTTNC5XJsMSbC
=V8cB
-----END PGP SIGNATURE-----