# Here's a list of bands in Wikidata that are missing MusicBrainz links
**URL:** https://community.metabrainz.org/t/heres-a-list-of-bands-in-wikidata-that-are-missing-musicbrainz-links/386797
**Category:** MusicBrainz
**Tags:** wikidata, musicbrainz
**Created:** [June 20, 2018, 12:46am UTC](https://community.metabrainz.org/t/heres-a-list-of-bands-in-wikidata-that-are-missing-musicbrainz-links/386797 "2018-06-20T00:46:03Z")
**Posts on this page:** 20
**Page:** 1
### Author:  [@sibilant](https://community.metabrainz.org/u/sibilant)
#### Post date: [June 20, 2018, 12:46am UTC](https://community.metabrainz.org/t/heres-a-list-of-bands-in-wikidata-that-are-missing-musicbrainz-links/386797/1 "2018-06-20T00:46:03Z")
[Here’s the list](http://tinyurl.com/y7yy4oex), and [here’s the Wikidata query](https://query.wikidata.org/#SELECT%20DISTINCT%20%3Fband%20%3FbandLabel%20%3FDiscogs_artist_ID%20WHERE%20%7B%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%20%20%3Fband%20wdt%3AP31%2Fwdt%3AP279%2a%20wd%3AQ215380.%0A%20%20%3Fband%20wdt%3AP1953%20%3FDiscogs_artist_ID.%0A%20%20FILTER%20%28%20%21EXISTS%20%7B%20%3Fband%20wdt%3AP434%20%3FMusicBrainz_artist_ID.%20%7D%29%0A%7D%0AORDER%20BY%20%3Fband%0ALIMIT%20200) that generated it. It lists bands (not solo artists) with a Discogs link on file, but no MB artist ID. I chose this query because the set isn’t super huge (446 bands right now), and because the Discogs link can help with identification—especially for bands that only have a Wikipedia page in languages that you don’t speak.
Want to help? You don’t need a Wikimedia account. Here’s how to add an MBID:
1. Click the link in the “band” column.
2. In the new tab that opens, there are links to the artist’s Wikipedia and Discogs pages. Try to find the artist in MusicBrainz.
3. If you find the band, copy the MBID from the URI for their artist page.
4. In the Wikidata page, click “add statement”.
5. Click on the “property” field. Select “MusicBrainz artist ID”.
6. Paste the MBID (not the whole URI) into the next field.
7. Click “publish”.
To see [bands that have neither MBID nor Discogs ID on file](http://tinyurl.com/y8makc29), I use [this query](https://query.wikidata.org/#SELECT%20DISTINCT%20%3Fband%20%3FbandLabel%20WHERE%20%7B%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%20%20%3Fband%20wdt%3AP31%2Fwdt%3AP279%2a%20wd%3AQ215380.%0A%20%20FILTER%20%28%20%21EXISTS%20%7B%20%3Fband%20wdt%3AP1953%20%3FDiscogs_artist_ID.%20%7D%29%0A%20%20FILTER%20%28%20%21EXISTS%20%7B%20%3Fband%20wdt%3AP434%20%3FMusicBrainz_artist_ID.%20%7D%29%0A%7D%0ALIMIT%20200). I set a limit of 200 results, but as of now there are more than 38,000 bands in Wikidata that have no MBID on file.
---
### Author:  [@dns\_server](https://community.metabrainz.org/u/dns_server)
#### Post date: [June 20, 2018, 2:13am UTC](https://community.metabrainz.org/t/heres-a-list-of-bands-in-wikidata-that-are-missing-musicbrainz-links/386797/2 "2018-06-20T02:13:09Z")
Thanks for providing this.
I’ve tried to use the wikidata query service but I still don’t know how to use spaql well enough.
It might be an interesting project to query wikidata for links that they have and we don’t.
Wikidata can have social media accounts and links to other databases so there is probably a lot of information they have that we don’t.
---
### Author:  [@sibilant](https://community.metabrainz.org/u/sibilant)
#### Post date: [June 20, 2018, 2:45am UTC](https://community.metabrainz.org/t/heres-a-list-of-bands-in-wikidata-that-are-missing-musicbrainz-links/386797/3 "2018-06-20T02:45:03Z")
Oh sure, there are so many things that can be done. Have you tried @loujin’s Wikidata-to-MB [import script](https://bitbucket.org/loujine/musicbrainz-scripts/src/default/mb-edit-create_from_wikidata.user.js?fileviewer=file-view-default)? (I only just learned that there’s also a [MB-to-Wikidata bot](https://github.com/metabrainz/mb2wikidatabot).)
---
### Author:  [@justcheckingitout](https://community.metabrainz.org/u/justcheckingitout)
#### Post date: [June 20, 2018, 1:39pm UTC](https://community.metabrainz.org/t/heres-a-list-of-bands-in-wikidata-that-are-missing-musicbrainz-links/386797/4 "2018-06-20T13:39:08Z")
My name starts with J, so I did the listings starting with J.
---
### Author:  [@rochusw](https://community.metabrainz.org/u/rochusw)
#### Post date: [June 20, 2018, 4:39pm UTC](https://community.metabrainz.org/t/heres-a-list-of-bands-in-wikidata-that-are-missing-musicbrainz-links/386797/5 "2018-06-20T16:39:45Z")
There is just a little problem with the “instance of” filter:
A band is Q215380, but e.g. a rockband is Q5741069, so it is not included in this list.
---
### Author:  [@sibilant](https://community.metabrainz.org/u/sibilant)
#### Post date: [June 20, 2018, 8:42pm UTC](https://community.metabrainz.org/t/heres-a-list-of-bands-in-wikidata-that-are-missing-musicbrainz-links/386797/6 "2018-06-20T20:42:50Z")
Oops, you’re right. Do you know of an efficient way to include all subclasses? When I tried the `WHERE` clause `p:P31/ps:P31/wdt:P279* wd:Q215380`, the query was too expensive and it timed out.
To be clear, such a query would also not be 100% comprehensive since it doesn’t catch bands that have no “instance of” predicate. We could catch some of those by cross-referencing DBpedia. Maybe then the only bands missing would be those that have no infobox and no band-related Wikipedia categories?
---
### Author:  [@rochusw](https://community.metabrainz.org/u/rochusw)
#### Post date: [June 20, 2018, 9:28pm UTC](https://community.metabrainz.org/t/heres-a-list-of-bands-in-wikidata-that-are-missing-musicbrainz-links/386797/7 "2018-06-20T21:28:40Z")
No, I didn’t know anything about Wikidata queries before I saw yours here.
It’s still better to execute this query for each category separately than to have no query at all 😉
I was just a bit confused when I saw, that the Norwegian metal band Virus
[https://www.wikidata.org/wiki/Q4014731](https://www.wikidata.org/wiki/Q4014731) (as instance of “band” from your query)
has no Wikipedia page linked to the Wikidata item, but I found a Wikipedia Page for it which is linked to
[https://www.wikidata.org/wiki/Q2090628](https://www.wikidata.org/wiki/Q2090628) (as instance of “rock band”).
So I tried your query with “rock band” and found some artists, which were not included in the other list.
---
### Author:  [@sibilant](https://community.metabrainz.org/u/sibilant)
#### Post date: [June 20, 2018, 11:36pm UTC](https://community.metabrainz.org/t/heres-a-list-of-bands-in-wikidata-that-are-missing-musicbrainz-links/386797/8 "2018-06-20T23:36:03Z")
Nice find. it is possible to merge duplicates, but for that you need an account (Virus is already merged now).
Also, thanks (to you and everyone else) for adding MBIDs! 🤘
---
### Author:  [@Moebeus](https://community.metabrainz.org/u/Moebeus)
#### Post date: [June 21, 2018, 12:12am UTC](https://community.metabrainz.org/t/heres-a-list-of-bands-in-wikidata-that-are-missing-musicbrainz-links/386797/9 "2018-06-21T00:12:04Z")
Very cool, thanks for this!
I’ve also noted a whole bunch of entries hiding behind Q43229 “Organization”, probably because of a botched batch job 😉
Some more stuff is hiding behind these instances (nowhere near complete):
> **[jazz band](https://www.wikidata.org/wiki/Q2596245)**
>
> musical ensemble that plays jazz music
> **[musical duo](https://www.wikidata.org/wiki/Q19184926)**
>
> ensemble of two musicians
> **[trio](https://www.wikidata.org/wiki/Q281643)**
>
> group of three musicians
> **[musical ensemble](https://www.wikidata.org/wiki/Q2088357)**
>
> group of people who perform instrumental and/or vocal music, with the ensemble typically known by a distinct name
> **[vocal-musical ensemble](https://www.wikidata.org/wiki/Q29881657)**
>
> musical ensemble in which both instrumentalists and singers perform
> **[musical ensemble consisting solely of singers](https://www.wikidata.org/wiki/Q29881373)**
>
> musical ensemble
> **[musical ensemble consisting solely of instruments](https://www.wikidata.org/wiki/Q29881512)**
>
> musical ensemble
---
### Author:  [@reosarevok](https://community.metabrainz.org/u/reosarevok)
#### Post date: [June 22, 2018, 10:13am UTC](https://community.metabrainz.org/t/heres-a-list-of-bands-in-wikidata-that-are-missing-musicbrainz-links/386797/10 "2018-06-22T10:13:09Z")
> [@sibilant](#):
>
> Oops, you’re right. Do you know of an efficient way to include all subclasses? When I tried the `WHERE` clause `p:P31/ps:P31/wdt:P279* wd:Q215380` , the query was too expensive and it timed out.
wdt:P31/wdt:P279\* is the standard way to do that, so [this query](http://tinyurl.com/ybvy6glt)
---
### Author:  [@rochusw](https://community.metabrainz.org/u/rochusw)
#### Post date: [June 22, 2018, 4:47pm UTC](https://community.metabrainz.org/t/heres-a-list-of-bands-in-wikidata-that-are-missing-musicbrainz-links/386797/11 "2018-06-22T16:47:47Z")
Just a reminder for editors, who add MBIDs to Wikidata:
Please check carefully, whether the artist is really the same.
Just because only one artist with this name exists in Musicbrainz,
it doesn’t mean necessarily it is the correct one.
(Somebody had linked a Dutch metal band in Wikidata to a Danish metal band
with the same name in Musicbrainz).
---
### Author:  [@sibilant](https://community.metabrainz.org/u/sibilant)
#### Post date: [June 23, 2018, 2:23am UTC](https://community.metabrainz.org/t/heres-a-list-of-bands-in-wikidata-that-are-missing-musicbrainz-links/386797/12 "2018-06-23T02:23:44Z")
Cool, thanks. I updated the queries and stats in the original post. Fortunately, the expanded result sets are only slightly bigger.
---
### Author:  [@dns\_server](https://community.metabrainz.org/u/dns_server)
#### Post date: [June 24, 2018, 2:50am UTC](https://community.metabrainz.org/t/heres-a-list-of-bands-in-wikidata-that-are-missing-musicbrainz-links/386797/13 "2018-06-24T02:50:25Z")
I have a [modified query](http://tinyurl.com/yd2jkxwt) to only give me English wikipedia pages.
```
SELECT ?band ?bandLabel ?Discogs_artist_ID WHERE {
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
?band wdt:P31/wdt:P279* wd:Q215380.
?band wdt:P1953 ?Discogs_artist_ID.
?article schema:about ?band .
?article schema:isPartOf .
FILTER ( !EXISTS { ?band wdt:P434 ?MusicBrainz_artist_ID. })
}
LIMIT 50
```
---
### Author:  [@dns\_server](https://community.metabrainz.org/u/dns_server)
#### Post date: [July 1, 2018, 2:53pm UTC](https://community.metabrainz.org/t/heres-a-list-of-bands-in-wikidata-that-are-missing-musicbrainz-links/386797/14 "2018-07-01T14:53:52Z")
I’ve gotten the list of wikidata entries that have a discogs url down to a small list i’ve started to look at other identifiers:
The below are entries that have an isni number and not a musicbrainz id.
>
The below have a vaif id
>
---
### Author:  [@sibilant](https://community.metabrainz.org/u/sibilant)
#### Post date: [July 2, 2018, 1:33am UTC](https://community.metabrainz.org/t/heres-a-list-of-bands-in-wikidata-that-are-missing-musicbrainz-links/386797/15 "2018-07-02T01:33:03Z")
You rock, @dns_server! Thanks to you and all the other contributors, more than 300 records from the Discogs list have been updated!
---
### Author:  [@The\_King](https://community.metabrainz.org/u/The_King)
#### Post date: [May 14, 2019, 12:20am UTC](https://community.metabrainz.org/t/heres-a-list-of-bands-in-wikidata-that-are-missing-musicbrainz-links/386797/17 "2019-05-14T00:20:26Z")
Of course the first one I try there are duplicate wikidata items so it is flagged.
[https://www.wikidata.org/wiki/Q11968426](https://www.wikidata.org/wiki/Q11968426)
[https://www.wikidata.org/wiki/Q10279893](https://www.wikidata.org/wiki/Q10279893)
If they merge the records the band would have pages in two languages
---
### Author:  [@dns\_server](https://community.metabrainz.org/u/dns_server)
#### Post date: [May 14, 2019, 3:44am UTC](https://community.metabrainz.org/t/heres-a-list-of-bands-in-wikidata-that-are-missing-musicbrainz-links/386797/18 "2019-05-14T03:44:29Z")
You should be able to merge these by using:
[https://www.wikidata.org/wiki/Special:MergeItems](https://www.wikidata.org/wiki/Special:MergeItems)
---
### Author:  [@The\_King](https://community.metabrainz.org/u/The_King)
#### Post date: [May 15, 2019, 5:24am UTC](https://community.metabrainz.org/t/heres-a-list-of-bands-in-wikidata-that-are-missing-musicbrainz-links/386797/19 "2019-05-15T05:24:29Z")
I got them merged. interesting interface.
---
### Author:  [@rochusw](https://community.metabrainz.org/u/rochusw)
#### Post date: [July 31, 2019, 7:19pm UTC](https://community.metabrainz.org/t/heres-a-list-of-bands-in-wikidata-that-are-missing-musicbrainz-links/386797/20 "2019-07-31T19:19:12Z")
FYI:
A lot of Discogs links (~9000) were added recently to Wikidata and appear now in the query result.
Most of them by a bot (Soweego bot) which has severe difficulties with ambiguous names,
so don’t trust them blindly.
---
### Author:  [@sibilant](https://community.metabrainz.org/u/sibilant)
#### Post date: [May 14, 2020, 2:33am UTC](https://community.metabrainz.org/t/heres-a-list-of-bands-in-wikidata-that-are-missing-musicbrainz-links/386797/21 "2020-05-14T02:33:37Z")
Update! Here’s [a new version of the list](https://tools.wmflabs.org/tabernacle/?#/tab/sparql/SELECT%20DISTINCT%20%3Fband%20%3FbandLabel%20%3FDiscogs_artist_ID%20WHERE%20%7B%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%20%20%3Fband%20wdt%3AP31%2Fwdt%3AP279*%20wd%3AQ215380.%0A%20%20%3Fband%20wdt%3AP1953%20%3FDiscogs_artist_ID.%0A%20%20FILTER%20(%20!EXISTS%20%7B%20%3Fband%20wdt%3AP434%20%3FMusicBrainz_artist_ID.%20%7D)%0A%7D%0AORDER%20BY%20%3Fband%0ALIMIT%20200/D%3BP1953%3BP434) that’s easier to use (thanks to Magnus Manske’s excellent [TABernacle](https://tools.wmflabs.org/tabernacle/) tool). With this version, you don’t even have to visit a Wikidata page. There are artist descriptions, Discogs links, and editable fields in the query results page itself.
To add an MBID, double-click the empty cell in the `MusicBrainz artist ID` column, or click the asterisk (`*`) that appears on hover. Paste the MBID, then click the green tick mark (or press Enter). To make a correction, hover over the cell and click the pencil icon.
There is just one catch: With this version, you must be logged in. If you have an account on Wikipedia, Wikidata, or any other Wikimedia project, that will work.