Wikidata:Property proposal/Kanobu numeric ID

Kanobu numeric ID edit

Originally proposed at Wikidata:Property proposal/Creative work

Descriptionnumeric identifier of a video game in the Kanobu database
RepresentsKanobu (Q4042056)
Data typeExternal identifier
Domainvideo game (Q7889)
Allowed values^[1-9]\d*$
Example 1The Last of Us (Q1986744) → 11579
Example 2God of War Ragnarök (Q99397916) → 59970
Example 3Alan Wake II (Q108417001) → 53282
Example 4Senua's Saga: Hellblade II (Q78418853) → 58870
Example 5Cuphead (Q18149495) → 13516
Sourcehttps://kanobu.ru/games
Planned useIt's planned to be used as a qualifier for the main property.
Expected completenessalways incomplete (Q21873886)
Robot and gadget jobsYes. Here it will be necessary to use a bot to try to scrape the data through the API (https://kanobu.ru/api/) if it possible.
See alsoIgromania ID (P6827), VK Play ID (P9697), P8279 (P8279)
Applicable "stated in"-valueKanobu (Q4042056)
Single-value constraintYes
Distinct-values constraintYes
Wikidata projectWikiProject Video games (Q8485882)

Motivation edit

  Notified participants of WikiProject Video games

As I mentioned earlier in another proposal here, this should be a complementary property used as qualifier for the main property. Just like in the case of IGDB, the property would be used to keep track of games in case Kanobu (Q4042056) removes URL slugs in the future. Numeric identifier can be found by the string "game":{"id": or "element":{"id": using Ctrl+U on the game's page.

Example 1: The Last of Us (Q1986744)

Kanobu game ID
  the-last-of-us
Kanobu numeric ID 11579
0 references
add reference


add value

Example 2: God of War Ragnarök (Q99397916)

Kanobu game ID
  god-war-2-ragnarok
Kanobu numeric ID 59970
0 references
add reference


add value

Example 3: Alan Wake II (Q108417001)

Kanobu game ID
  alan-wake-2
Kanobu numeric ID 53282
0 references
add reference


add value

Example 4: Senua's Saga: Hellblade II (Q78418853)

Kanobu game ID
  senuas-saga-hellblade-2
Kanobu numeric ID 58870
0 references
add reference


add value

Example 5: Cuphead (Q18149495)

Kanobu game ID
  cuphead
Kanobu numeric ID 13516
0 references
add reference


add value

Regards Kirilloparma (talk) 13:59, 17 December 2021 (UTC)[reply]

Discussion edit

Pinging also

  Notified participants of WikiProject Russia. Regards Kirilloparma (talk) 14:02, 17 December 2021 (UTC)[reply]

Thanks for your opinion Jura! I will try to give a clear example of how this property should be used. Let's assume that one day Kanobu will update the database and subsequently switch to numeric identifiers. So, how can this property be useful?
Well, to begin with, thanks to this property, we will be able to track down the numeric identifiers that are contained in the database (see the instructions above on how to find them). They will come in handy as soon as the Kanobu database stops using URL slugs, which as we know are unstable and can be changed and subsequently broken at any time.
Using a SPARQL query service, we can easily detect numeric IDs and, thanks to Quickstatements, run a batch that will replace URL slugs with them. I hope I have better explained what this property is for and how it will be used. Regards Kirilloparma (talk) 13:26, 5 February 2022 (UTC)[reply]
Example of such a query for Internet Game Database numeric game ID (P9043):
SELECT ?item ?itemLabel ?IGDB_numeric_game_ID WHERE {
  ?item wdt:P31/wdt:P279* wd:Q7889.
  ?item p:P5794 ?statement.
  OPTIONAL { ?statement pq:P9043 ?IGDB_numeric_game_ID. }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
Try it!
Regards Kirilloparma (talk) 02:57, 8 February 2022 (UTC)[reply]
@Trade: The main property cannot be used as numeric ID, see the reason. Regards Kirilloparma (talk) 01:41, 27 February 2022 (UTC)[reply]
Are the numeral values usable at this time? @Kirilloparma: --Trade (talk) 01:49, 27 February 2022 (UTC)[reply]
@Trade: Yes, as a separate qualifier property (see the full discussion above). Regards Kirilloparma (talk) 02:16, 27 February 2022 (UTC)[reply]

@Kirilloparma, Jean-Frédéric: Done--Trade (talk) 18:50, 1 March 2022 (UTC)[reply]