Difference between revisions of "User:Jokipii"
From MusicBrainz Wiki
Jump to navigationJump to search (Linking stats) |
|||
Line 3: | Line 3: | ||
== Currently working with == |
== Currently working with == |
||
I have both MusicBrainz and Discogs databases installed on PostgreSQL. I am currently trying to improve linking between those. |
|||
⚫ | |||
⚫ | |||
** Labels |
|||
== Bot queue == |
== Bot queue == |
||
Line 21: | Line 19: | ||
* Artist that have Discogs link, and not have type(person/group) set, and have Discogs realname without characters "&,/+" and word "and" (indicating type:person) |
* Artist that have Discogs link, and not have type(person/group) set, and have Discogs realname without characters "&,/+" and word "and" (indicating type:person) |
||
** 1699 |
** 1699 |
||
== Some stats == |
|||
{| |
|||
! |
|||
! MusicBrainz Total |
|||
⚫ | |||
! Links (all these are not unique) |
|||
! Percent done (compared to smaller total) |
|||
! Sum of unique MusicBrainz releases connected to linked entities |
|||
! Percent of all MusicBrainz releases |
|||
! Sum of unique Discogs releases connected to linked entities |
|||
! Percent of all Discogs releases |
|||
|- |
|||
! Releases: |
|||
| 988301 |
|||
| 2720810 |
|||
| 171170 |
|||
| (17%) |
|||
| |
|||
| |
|||
| |
|||
| |
|||
| |
|||
|- |
|||
! Release groups: |
|||
| 822442 |
|||
| 365081 |
|||
| 47387 |
|||
| (13%) |
|||
| 106445 |
|||
| (11%) |
|||
| 277207 |
|||
| (10%) |
|||
|- |
|||
⚫ | |||
| 626598 |
|||
| 2100250 |
|||
| 110825 |
|||
| (18%) |
|||
| 606737 |
|||
| (61%) |
|||
| 1738474 |
|||
| (64%) |
|||
|- |
|||
! Label: |
|||
| 55844 |
|||
| 245988 |
|||
| 16004 |
|||
| (29%) |
|||
| 414436 |
|||
| (42%) see note |
|||
| 1542803 |
|||
| (57%) |
|||
|} |
|||
note: In MB only 567392 releases have label information, and 420909 don't have. |
Revision as of 21:57, 15 December 2011
Who am I?
MusicBrainz editor Jokipii and operator of Jokipii_bot.
Currently working with
I have both MusicBrainz and Discogs databases installed on PostgreSQL. I am currently trying to improve linking between those.
Bot queue
- Artist Discogs links
- Exact name match. Have release(s) with Discogs links. All releases found that way point on same artist at Discogs.
- 5137
- Exact name match. Have release(s) with Discogs links. All releases found that way point on same artist at Discogs.
Possible future sets
- Artist (type:group) name with exact (case insensitive) match, have members with Discogs links, all members found that way have been also market as members in Discogs entry.
- 2083
- Artist name with exact (case insensitive) match, is member of groups with Discogs links, all groups found that way have same Discogs artist as member.
- 8692
- Artist that have Discogs link, and not have type(person/group) set, and have multiple members in Discogs (indicating type:group)
- 1309
- Artist that have Discogs link, and not have type(person/group) set, and have Discogs realname without characters "&,/+" and word "and" (indicating type:person)
- 1699
Some stats
MusicBrainz Total | Discogs Total | Links (all these are not unique) | Percent done (compared to smaller total) | Sum of unique MusicBrainz releases connected to linked entities | Percent of all MusicBrainz releases | Sum of unique Discogs releases connected to linked entities | Percent of all Discogs releases | ||
---|---|---|---|---|---|---|---|---|---|
Releases: | 988301 | 2720810 | 171170 | (17%) | |||||
Release groups: | 822442 | 365081 | 47387 | (13%) | 106445 | (11%) | 277207 | (10%) | |
Artist: | 626598 | 2100250 | 110825 | (18%) | 606737 | (61%) | 1738474 | (64%) | |
Label: | 55844 | 245988 | 16004 | (29%) | 414436 | (42%) see note | 1542803 | (57%) |
note: In MB only 567392 releases have label information, and 420909 don't have.