Property talk:P2638

Documentation

• Start a query
• Current uses
• Statistics by class
• String length
• List of qualifiers
• Count

TV.com ID
identifier for an entry on TV.com for movies, people and TV series

Applicable "stated in" value	TV.com (Q838639)
Has quality	prefix (Q23585486)
Data type	External identifier
Template parameter	en:Template:Tv.com show, en:Template:Tv.com movie, en:Template:Tv.com episode, ro:Format:Tv.com person
Domain	TV series and web series (note: this should be moved to the property statements)
Allowed values	(shows|movies|people|web)/[a-z\d][a-z_\d/-]*[a-z\d-]
Example	Firefly (Q11622) → shows/firefly Serenity (Q691611) → movies/serenity Joss Whedon (Q298025) → people/joss-whedon Simpsons Roasting on an Open Fire (Q753507) → shows/the-simpsons/simpsons-roasting-on-an-open-fire-1286 A Day in the Life (Q4656314) → web/a-day-in-the-life-hulu
Source	According to this template: en:Template:Tv.com show, en:Template:Tv.com movie, en:Template:Tv.com episode, ro:Format:Tv.com person According to statements in the property: https://web.archive.org/web/20080201113148/http://www.tv.com/ When possible, data should only be stored as statements
Formatter URL	https://web.archive.org/web/20080201113148/http://www.tv.com/$1/
Robot and gadget jobs	DeltaBot does the following jobs: <DeltaBot-format-removeLast> Bots can import values from various Wikipedias
Tracking: same	no label (Q32042433)
Tracking: differences	no label (Q32042017)
Tracking: usage	Category:Pages using Wikidata property P2638 (Q28007639)
Tracking: local yes, WD no	no label (Q32042035)
Related to country	United States of America (Q30) (See 762 others)
Lists	Items with the most statements of this property Count of items by number of statements (chart) Items with the most statements Items with the fewest statements Count of items by number of sitelinks (chart) Items with the most sitelinks Items with the most sitelinks, but no link to one Wikipedia (sample: Welsh Wikipedia, cywiki) Items with the fewest sitelinks Most linked wikis Items with the most identifier properties Items with no other external identifier Items with no other statements Most recently created items Items with novalue claims Items with unknown value claims Usage history (total) Usage history (main statement) Chart by item creation date Database reports/Humans with missing claims/P2638 Database reports/Constraint violations/P2638 Map Random list
Proposal discussion	Proposal discussion
Current uses	Total 51,402 Main statement 51,345 99.9% of uses Qualifier 5 <0.1% of uses Reference 52 0.1% of uses
Search for values

[create Create a translatable help page (preferably in English) for this property to be included here]

Distinct values: this property likely contains a value that is different from all other items. (Help)

Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P2638#Unique value, SPARQL (every item), SPARQL (by value)

Single value: this property generally contains a single value. (Help)

Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P2638#Single value, SPARQL

Format “(shows|movies|people|web)/[a-z\d][a-z_\d/-]*[a-z\d-]”: value must be formatted using this pattern (PCRE syntax). (Help)

Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303). Known exceptions: V (Q1076940), R (Q615237)
List of violations of this constraint: Database reports/Constraint violations/P2638#Format, SPARQL

Conflicts with “instance of (P31): Wikimedia list article (Q13406463)”: this property must not be used with the listed properties and values. (Help)

List of violations of this constraint: Database reports/Constraint violations/P2638#Conflicts with P31, hourly updated report, search, SPARQL

Conflicts with “instance of (P31): Wikimedia disambiguation page (Q4167410), Wikimedia category (Q4167836), Wikimedia project page (Q14204246), Wikimedia template (Q11266439)”: this property must not be used with the listed properties and values. (Help)

Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P2638#Conflicts with P31, SPARQL

Allowed entity types are Wikibase item (Q29934200): the property may only be used on a certain entity type (Help)

Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P2638#Entity types

Scope is as main value (Q54828448), as reference (Q54828450): the property must be used by specified way only (Help)

Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P2638#Scope, SPARQL

Property infos

This property is being used by: it:Template:Tv.com, it:Template:Collegamenti cinema ca:Plantilla:Infotaula sèrie de televisió, ca:Plantilla:Programa de televisió, ca:Plantilla:Infotaula de programa audiovisual, ca:Plantilla:Identificadors, ca:Plantilla:Infotaula programa audiovisual hu:Sablon:Televíziós műsor infobox, hu:Sablon:X-Faktor infobox, hu:Sablon:Észbontók infobox, hu:Sablon:Valóvilág infobox, hu:Sablon:The Voice infobox lv:Veidne:TV.com show es:Plantilla:Ficha de programa de televisión, es:Plantilla:Tv.com, es:Plantilla:Ficha de programa de televisión/zona de pruebas/2, es:Plantilla:Ficha de programa de televisión/zona de pruebas/3 ast:Plantía:Tvtome person, ast:Plantía:Tv.com person, ast:Plantía:Tv.com persona, ast:Plantía:Tvtome persona, ast:Plantía:Tv.com en:Template:TV.com anthology, en:Template:TV.com episode, en:Template:TV.com movie, en:Template:TV.com show, en:Template:Tvmaze, en:Template:TV.com name ko:틀:Tv.com 쇼, ko:틀:Tv.com 에피소드, ko:틀:TV.com 쇼, ko:틀:TV.com 앤솔러지, ko:틀:TV.com 에피소드, ko:틀:TV.com 영화 vi:Bản mẫu:Tv.com movie uk:Шаблон:Tv.com episode diq:Şablon:TV.com show eo:Ŝablono:Tv.com nomo, eo:Ŝablono:Tv.com nomo/dokumentado, eo:Ŝablono:TV.com titolo ml:ഫലകം:TV.com episode kn:ಟೆಂಪ್ಲೇಟು:TV.com anthology, kn:ಟೆಂಪ್ಲೇಟು:TV.com episode, kn:ಟೆಂಪ್ಲೇಟು:TV.com movie, kn:ಟೆಂಪ್ಲೇಟು:TV.com name, kn:ಟೆಂಪ್ಲೇಟು:TV.com show azb:شابلون:TV.com name bn:টেমপ্লেট:টিভি.কম অনুষ্ঠান fa:الگو:TV.com movie, fa:الگو:TV.com anthology, fa:الگو:TV.com name, fa:الگو:TV.com show vec:Modèl:Identifegadori, vec:Modeło:Identifegadori, vec:Modeło:Infobox de Produsion audioviziva ru:Шаблон:Tv.com movie simple:Template:TV.com movie zh-yue:Template:人物拎 cbk-zam:Plantilla:Ficha de serie de televisión ga:Teimpléad:WD Bosca Sonraí Sraith Teilifíse hak:模板:Ngoi-phu lièn-kiet yue:Template:人物拎 Please notify projects that use this property before big changes (renaming, deletion, merge with another property, etc.)

Discussion

Format tweak

@Pasleim, Matěj Suchánek: (or anybody else) maybe you could tweak the regex a little bit? Would like not to allow values like "shows/304615" (where tha part after prefix is digit-only). Those IDs gives 404s. --Edgars2007 (talk) 07:53, 23 March 2016 (UTC)

Oh, and would be good to fail those IDs, which have / as last symbol. --Edgars2007 (talk) 09:29, 23 March 2016 (UTC)

@Edgars2007: Firstly, I would rather have clear when there can be numbers at all. Matěj Suchánek (talk) 15:14, 23 March 2016 (UTC)

@Matěj Suchánek: that is the problem, that they can be anywhere (of course, after the slash). Some valid examples: "shows/finale-part-1-2821422", "shows/9-to-5", "shows/last-man-standing-2011" --Edgars2007 (talk) 17:43, 23 March 2016 (UTC)

I have added a new constraint as the test. How's it with slashes? Can they really be part of the string? Matěj Suchánek (talk) 19:17, 23 March 2016 (UTC)

@Matěj Suchánek: thank you. SPARQL looks good. --Edgars2007 (talk) 20:02, 23 March 2016 (UTC)

@Matěj Suchánek: forgot... the regex isn't working for values like "shows/304615" (which was the original question :D ). That is, those values should be reported as violations. If you need, you can test it with any of these IDs (those will be exceptions): 24 (Q56194), 90210 (Q276071), 227 (Q1248238), 20/20 (Q197867), 50/50 (Q4639709) --Edgars2007 (talk) 09:32, 25 March 2016 (UTC)

Used (?=...), now it should catch these. Matěj Suchánek (talk)

Cool, thanks! --Edgars2007 (talk) 10:09, 25 March 2016 (UTC)

The current format is just a URL string, which is a bit cumbersome. TV.com does have numeric IDs for shows and episodes and they are resolvable. The number spaces do overlap so these are separate IDs (Show ID and Episode ID). For example, TVDB resolves TV.com show IDs with this template: http://www.tv.com/show/$1/summary.html

Scope

@Máté: I assume, you would be interested... Maybe we could include also TV seasons and "List of x episodes" as scope for this property? a) knowing ID for the show, it is pretty easy to add one for episode list and seasons items b) in this way, we could have easier import from Wikipedias (not so much errors). What do you think? P.S. I'm still importing the values from enwiki (from harvesttemplates logfile). Just need some rest for few days :) --Edgars2007 (talk) 09:27, 25 March 2016 (UTC)

For episode lists it seems quite unnecessary since you just have to add "/episodes/" after the ID of the linked series. For that there is no need to store the ID again. It would make more sense with seasons (even if in theory that could be computed as well in many if not most cases). I may support extending the scope to seasons (like in the case of Rotten Tomatoes IDs) but not to episode lists. I don't think that it'll be such a huge inconvenience to get rid of the claims on episode lists after the import. – Máté (talk) 10:21, 25 March 2016 (UTC)

@Máté: well, I don't think it's too trivial for episode lists, because ID for the show is on different item (of course). We then probably could also get rid off something else, for example, the same IMDb ID (P345) for 88th Academy Awards (Q20022969), as it also requires just to add "2016". OK, I understand, that Academy example is more close to TV season example in TV.com case. --Edgars2007 (talk) 18:39, 25 March 2016 (UTC)