Wikidata:Property proposal/USK ID

USK ID

Originally proposed at Wikidata:Property proposal/Creative work

   Done: USK ID (P11063) (Talk and documentation)

Description	identifier of a work in the USK database
Represents	Unterhaltungssoftware Selbstkontrolle (Q157754)
Data type	External identifier
Domain	video game (Q7889), video game compilation (Q16070115), video game expansion pack (Q209163)
Allowed values	[1-9]\d*
Example 1	BloodNet (Q4927532) → 1
Example 2	Elden Ring (Q64826862) → 50644, 50632, 50645, 50646
Example 3	Monster Hunter World: Iceborne (Q81690497) → 46484, 46485
Example 4	Metal Gear Solid: The Legacy Collection (Q15199106) → 35702
Example 5	SaGa Frontier 2 (Q2660493) → 4496
Source	https://usk.de/usktitle/
External links	Use 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].
Mix'n'match	5413, 5414, 5415, 5416, 5417, 5476
Expected completeness	eventually complete (Q21873974)
Formatter URL	https://usk.de/usktitle/$1, https://usk.de/en/usktitle/$1
See also	USK rating (P914)
Distinct-values constraint	yes
Wikidata project	WikiProject Video games (Q8485882)

Motivation

Unterhaltungssoftware Selbstkontrolle (Q157754) is the organisation responsible for video game ratings in Germany − we have the rating property as USK rating (P914) − and it turns out it has a database with resolvable IDs. The data model is per-release (in Germany, presumably), so for each platform and distribution package − hence eg. 6 IDs for Dark Souls 3. Jean-Fred (talk) 19:53, 3 August 2022 (UTC)

applsdev Arlo Barnes BugWarp Coloradohusky CptViraj Cupkake4Yoshi Cwf97 Cynde Moya Danrok Datumizer Dexxor Diggr Dispenser Dollarsign8 DoublePendulumAttractor EdoAug Edolusill Eniehack Facenapalm Floyd-out FullyAwesome Harshrathod50 Jean-Frédéric Keplersj Kirilloparma Lewis Hulbert LotsofTheories Macocobovi Macrike Master Of Ninja Matthias M. Metafire18 Nicereddy Nw520 Oduci Poslovitch Rampagingcarrot RampantSpirit Santer Sight Contamination thgiex Tomodachi94 VGPaleontologist Wd-Ryan WikiSyn YotaMoteuchi

Notified participants of WikiProject Video games

Discussion

•  Comment. @Jean-Frédéric: This property, just like ESRB game ID (P8303) is supposed to be used as main value, right? But what do we do with rating certificate ID (P2676) that is currently used for this numeric ID as qualifier (example)? Remove it from items and replace it with USK ID that will be used as the main one? By the way, a number like 50231/21 does not seem to be a rating certificate at all. What do you think? Regards Kirilloparma (talk) 23:46, 25 August 2022 (UTC)
• Repinging:
  applsdev Arlo Barnes BugWarp Coloradohusky CptViraj Cupkake4Yoshi Cwf97 Cynde Moya Danrok Datumizer Dexxor Diggr Dispenser Dollarsign8 DoublePendulumAttractor EdoAug Edolusill Eniehack Facenapalm Floyd-out FullyAwesome Harshrathod50 Jean-Frédéric Keplersj Kirilloparma Lewis Hulbert LotsofTheories Macocobovi Macrike Master Of Ninja Matthias M. Metafire18 Nicereddy Nw520 Oduci Poslovitch Rampagingcarrot RampantSpirit Santer Sight Contamination thgiex Tomodachi94 VGPaleontologist Wd-Ryan WikiSyn YotaMoteuchi
  Notified participants of WikiProject Video games. Kirilloparma (talk) 23:47, 25 August 2022 (UTC)

+

Bigbossfarin Galaktos Labant M2k~dewiki Mathieu Kappler PantherStrix Wiljes jobu0101 cookroach Looniverse LockaPicker

Notified participants of WikiProject Germany. Kirilloparma (talk) 23:48, 25 August 2022 (UTC)

•  Support Finally a good way to link to individual ratings on usk.de! This needs to be used as main value so that the IDs can be refined with platform (P400) qualifiers. The rating certificate ID (P2676) values should be moved to the new property. I wonder whether the new property should also include the last two digits of the classification date like rating certificate ID (P2676) does—it wouldn't effect the formatter URL because the website ignores a trailing slash + number, e.g. usk.de/usktitle/50644/22 redirects to usk.de/usktitle/50644. —Dexxor (talk) 08:41, 26 August 2022 (UTC)

  Not sure what to think of rating certificate ID (P2676) to be honest. We do need to annotate the rating with ID somehow ; we could use the ID as qualifier ; we could use references instead... Not too sure there.

  I would prefer not to use the certificate ID for this (and counting on the last 2 digits to be ignored) − we have no guarantee this will stay that way, and the best IMO is to follow the URL scheme as it is. Jean-Fred (talk) 08:13, 28 August 2022 (UTC)

•  Info. So far I've added 5 catalogs to Mix'n'match ([1], [2], [3], [4], [5]). Catalogs are divided by platform and new ones will be added. Unfortunately USK does not sort the database alphabetically, but you can get all IDs if sorted by platform. Regards Kirilloparma (talk) 22:01, 27 August 2022 (UTC)
•  Support Sir Lothar (talk) 14:18, 6 September 2022 (UTC)
•  Support. Telaneo (User talk page) 05:21, 7 September 2022 (UTC)

---

• @Jean-Frédéric, Dexxor, Sir Lothar, Telaneo:  Done: USK ID (P11063). Not sure what happened to previous m'n'm catalogs, but I created a new one for all platforms. The catalog is a must-see because, besides video games, I found a lot of interesting stuff in the USK database. Regards Kirilloparma (talk) 22:44, 23 September 2022 (UTC)