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), expansion pack (Q209163)
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
Allowed values	[1-9]\d*
Source	https://usk.de/usktitle/
External links	Use in sister projects: [ar] • [az] • [de] • [en] • [es] • [fr] • [he] • [it] • [ja] • [ka] • [ko] • [nl] • [pl] • [pt] • [ru] • [sv] • [tr] • [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)[reply]

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)[reply]
Repinging:
Nicereddy — 13:40, 04 May 2015 (UTC) Danrok — 18:20, 30 October 2015 (UTC) Lewis Hulbert — 20:26, 13 December 2017 (UTC) Santer — 22:03, 26 May 2018 (UTC) Kirilloparma — 00:30, 5 August 2018 (UTC) Cwf97 — 18:33, 22 October 2018 (UTC) YotaMoteuchi — 08:09, 22 May 2019 (UTC) CptViraj — 02:49, 17 September 2019 (UTC) BugWarp — 23:19, 26 October 2019 (UTC) WikiSyn — 21:52, 26 December 2019 (UTC) Cynde Moya — 16:07, 31 March 2020 (UTC) Dexxor — 14:51, 02 May 2020 (UTC) Floyd-out — 09:14, 22 July 2020 (UTC) Jean-Frédéric — 11:22, 11 September 2020 (UTC) A particle for world to form — 11:15, 17 May 2021 (UTC) Dollarsign8 — 01:40, 01 November 2021 (UTC) Wd-Ryan — 02:20, 03 October 2022 (UTC) Master Of Ninja — 17:37, 18 October 2022 (UTC) Matthias M. — 09:28, 12 February 2023 (UTC) VGPaleontologist — 21:03, 12 February 2023 (UTC) Tomodachi94 — 18:34, 26 February 2023 (UTC) thgiex — 12:17, 6 April 2023 (UTC) DoublePendulumAttractor — 17:48, 05 May 2023 (UTC) Metafire18 — 12:55, 21 August 2023 (UTC) applsdev — 18:44, 25 September 2023 (UTC) Cupkake4Yoshi — 06:54, 26 October 2023 (UTC) Eniehack — 07:56, 07 November 2023 (UTC) RampantSpirit — 17:59, 11 November 2023 (UTC) Macocobovi — 07:35, 22 November 2023 (UTC) EdoAug — 17:10, 02 January 2024 (UTC) Keplersj — 20:53, 10 February 2024 (UTC) Arlo Barnes — 23:48, 10 March 2024 (UTC) Odjob16 — 16:24, 21 June 2024 (UTC) CommanderKefir — 14:57, 17 September 2024 (UTC) Athayahisyam — 03:10, 15 October 2024 (UTC) SuperUltraHardCoreGamer — 11:25, 25 November 2024 (UTC)[reply]
Notified participants of WikiProject Video games. Kirilloparma (talk) 23:47, 25 August 2022 (UTC)[reply]

+

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

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)[reply]
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)[reply]
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)[reply]
Support Sir Lothar (talk) 14:18, 6 September 2022 (UTC)[reply]
Support. Telaneo (User talk page) 05:21, 7 September 2022 (UTC)[reply]

@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)[reply]