Wikidata:Property proposal/last appearance

last appearance

Return to Wikidata:Property proposal/Creative work

   Under discussion

Description	last work featuring a fictional character or item
Represents	last appearance (Q125686982)
Data type	External identifier
Example 1	Mary Camden (Q125682212)→…And Thank You (Q114523400)
Example 2	Dane Vogel (Q56613123)→Saints Row: Gat out of Hell (Q17911588)
Example 3	Victor Vance (Q2469911)→Grand Theft Auto: Vice City (Q94671)
Example 4	Troy McClure (Q1504550)→Bart the Mother (Q2617345)
Example 5	Mermaid Man (Q93186548)→Patrick-Man! (Q29566244)
Example 6	Leonard Burton (Q107024611)→The Hundred Year Play (Q109677017)
Example 7	Bulldog (Q60649159)→Saints Row IV (Q13060351)
Expected completeness	always incomplete (Q21873886)
Wikidata project	WikiProject Video games (Q8485882)

Motivation

This seemed needed--Trade (talk) 04:10, 29 April 2024 (UTC)

• Valentina.Anitnelav Thierry Caro Shisma Arlo Barnes Tsaorin SilentSpike Maxime জয়শ্রীরাম সরকার Wolverène Rampant Spirit Rtnf dseomn lijil
  Notified participants of WikiProject Narration
  TomT0m Valentina.Anitnelav Shisma (talk) ElanHR Arlo Barnes (talk) Maria zaos (talk) EEMIV (talk) OmegaFallon (talk) Kurzov (talk) dseomn (talk) Natureshadow (talk)
  Notified participants of WikiProject Fictional universes--Trade (talk) 04:13, 29 April 2024 (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 Jotamide 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--Trade (talk) 04:14, 29 April 2024 (UTC)

Discussion

•  Support some implementation of this but we should consider how to minimise data staleness if a new addition to a franchise is released (perhaps unexpectedly). This isn't a problem with first appearance (P4584). Arlo Barnes (talk) 05:33, 29 April 2024 (UTC)

  number of episodes (P1113) would be a better example Trade (talk) 20:43, 29 April 2024 (UTC)

•  Question I think this is doable in a different way, by present in work (P1441) we get an appearance on works, by publication date (P577) we get the publication date of the work. We can always sort by publication date to get the last appearance, doable in sparql and in lua both. If the point is to mark that it is known that it won't appear again (or is now forgotten) why not adding a qualifier
  ⟨ The Adventures of Tintin (Q744536)    ⟩ present in work (P1441) ⟨ Tintin and the Picaros (Q612595)    ⟩
  followed by (P156) ⟨ no value Help ⟩
  or something like that

  What would be the issue with that ? Too complicated ? Do not cover all cases ? author  TomT0m / talk page 09:43, 30 April 2024 (UTC)

  The only way we would be able to infer this would be if the vast majority of items about works and episodic works had a complete dataset. And you would still all of said items that a character have appeared in to be linked to them or vice versa which is even more rare Trade (talk) 23:43, 30 April 2024 (UTC)

•  Oppose Using P1441 with qualifiers as TomT0m said should be enough. --Tinker Bell ★ ♥ 16:15, 30 April 2024 (UTC)

  There isn't much of a benefit unless one consider the existence of new non-identifier properties to be actively harmful to the project. --Trade (talk) 00:06, 1 May 2024 (UTC)

•  Support This property is widely used in infoboxes of fictional characters on many wikipedias (enwiki, a couple on ruwiki). It will be difficult if not impossible to output the value of P1441 with the latest date to this param. Also, TV series characters often have a last episode listed, and there is no practice on WD to list dozens/hundreds of episodes in the character's P1441. Solidest (talk) 03:58, 8 May 2024 (UTC)

I would even say that P1441 itself needs to be redesigned. Filling in all kinds of media, individual works, episodes of works, series of works of one media, series of works of cross-media (franchise) - this is all bad practice, because of which there are now difficulties with tuning infoboxes. Solidest (talk) 04:02, 8 May 2024 (UTC)

The problem is not on the data model, but in the infoboxes. We shouldn't model the data considering only Wikipedia usecases, Wikidata does not exist only to fullfill Wikipedia infoboxes and tables. The real problem is that now there isn't a way to make SPARQL queries from Lua templates for query data that has complex relationships. Changing the data model will not fix that. There is no problem on the way P1441 is used, because all of these uses express the same relationship, and SPARQL can be used to get further data, based in whether the predicate is a franchise, collection or a single creative work. --Tinker Bell ★ ♥ 23:42, 8 May 2024 (UTC)

Could you elaborate? I am confused what the issue you are referring to is Trade (talk) 22:43, 10 May 2024 (UTC)

•  Support adding some form of this, whether it be through a new property or otherwise -Kurzov (talk) 13:37, 13 May 2024 (UTC)
•  Support good point.--Frettie (talk) 22:49, 14 May 2024 (UTC)