Wikidata:Property proposal/BBC artist ID

From Wikidata
Jump to navigation Jump to search

BBC artist ID[edit]

Originally proposed at Wikidata:Property proposal/Generic

   Withdrawn
Descriptionidentifier for an artist on BBC site
RepresentsBBC (Q9531)
Data typeExternal identifier
Domainhuman (Q5)
Example 1Basshunter (Q383541)255e2420-5b02-452b-9771-0512ebe78090
Example 2Stromae (Q313453)ab2528d9-719f-4261-8098-21849222a0f2
Example 3Sean Paul (Q200577)c3da3346-2643-48a7-93cd-011f6834b3d7
Sourcehttps://www.bbc.co.uk
External linksUse in sister projects: [ar][de][en][es][fr][he][it][ja][ko][nl][pl][pt][ru][sv][vi][zh][commons][species][wd][en.wikt][fr.wikt].
Planned usePutting value to musical artists available from the BBC site.
Expected completenessalways incomplete (Q21873886)
Formatter URLhttps://www.bbc.co.uk/music/artists/$1
See alsoBBC programme ID (P827)

Motivation[edit]

Property for artists included in BBC. Eurohunter (talk) 10:18, 19 June 2019 (UTC)[reply]

SELECT ?mb_URL ?bbc_URL WHERE {
  wd:Q383541 wdt:P434 ?mb_id .  # get BassHunter's MusicBrainz id
  
  # generate MusicBrainz URL
  wd:P434 p:P1630 ?stmt .
  ?stmt ps:P1630 ?mb_formatter .
  ?stmt pq:P137 wd:Q14005 .   # operator MusicBrainz
  BIND(IRI(REPLACE(?mb_id, '^(.+)$', ?mb_formatter)) AS ?mb_URL).
  
  # generate BBC Music URL
  wd:P434 p:P3303 ?stmt1 .
  ?stmt1 ps:P3303 ?mb_bbc_formatter .
  ?stmt1 pq:P137 wd:Q4834855 . # operator BBC Music
  BIND(IRI(REPLACE(?mb_id, '^(.+)$', ?mb_bbc_formatter)) AS ?bbc_URL).
}
Try it!

Piecesofuk (talk) 20:28, 24 June 2019 (UTC)[reply]

@Piecesofuk: What is this? Eurohunter (talk) 22:11, 24 June 2019 (UTC)[reply]
it's just to show that we can use the MusicBrainz ID to generate a URL to get to the BBC Music Artist page; the URL is just www.bbc.co.uk/music/artists/...the musicbrainz id... Piecesofuk (talk) 06:42, 25 June 2019 (UTC)[reply]
@Piecesofuk: @Moebeus: I mean I have already id but how to add it to WD. Eurohunter (talk) 07:59, 25 June 2019 (UTC)[reply]
@Eurohunter: Check to see if it has a MusicBrainz artist ID (P434), if not then add a MusicBrainz Artist ID statement with the ID, for example on Basshunter there are two IDs, both are identical to the BBC Music ID https://www.wikidata.org/wiki/Q383541#P434 Piecesofuk (talk) 08:05, 25 June 2019 (UTC)[reply]
@Piecesofuk: Yes but how to add information about BBC Music id or link it to Basshunter (something like "See also"?). Otherwise this is pointless. Eurohunter (talk) 12:34, 25 June 2019 (UTC)[reply]
@Eurohunter: The BBC Music Artist ID is the same as the Musicbrainz Artist ID so doesn't need to be added as it will just be duplicating data. Basshunter has two BBC Music Artist IDs on its Wikidata item but they just happen to be called MusicBrainz Artist IDs. If it helps I've added BBC Music Artist ID as an alias to the MusicBrainz artist ID (P434) Piecesofuk (talk) 12:51, 25 June 2019 (UTC)[reply]
@Piecesofuk: Thanks. Eurohunter (talk) 16:36, 25 June 2019 (UTC)[reply]

 Comment @Piecesofuk: is right, BBC has adopted Musicbrainz IDs (and are paying for the pleasure, I believe). The above code is a "database query" fetching results from Wikidata, click the link that says "Try it" to...eh, try it out. Moebeus (talk) 00:09, 25 June 2019 (UTC)[reply]