Property talk:P3804

Documentation

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

TV Guide show ID (former scheme)
ID of a television program at TV Guide

Applicable "stated in" value	TVGuide.com (Q86537902)
Data type	External identifier
Corresponding template	Template:TV Guide show (Q14399533)
Template parameter	en:Template:TV Guide show
Domain	According to this template: television program According to statements in the property: human (Q5), film (Q11424) or broadcasting program (Q11578774) When possible, data should only be stored as statements
Allowed values	\d+
Example	Veritas: The Quest (Q2530070) → 100564 You Me Her (Q24514642) → 911601
Source	https://www.tvguide.com/
Formatter URL	https://web.archive.org/web/*/https://www.tvguide.com/tvshows/wd/$1 https://www.tvguide.com/tvshows/wd/$1
Related to country	United States of America (Q30) (See 770 others)
See also	TV Guide person ID (former scheme) (P3845)
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 Map of people by place values: place of birth educated at work location residence place of death place of burial January 1st dates People with date of birth on January 1 People with date of death on January 1 People with both dates on January 1 Database reports/Constraint violations/P3804 Map Random list
Proposal discussion	Proposal discussion
Current uses	Total 18,113 Main statement 18,107 >99.9% of uses Qualifier 2 <0.1% of uses Reference 4 <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)

List of violations of this constraint: Database reports/Constraint violations/P3804#Unique value, hourly updated report, SPARQL (every item), SPARQL (by value)

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

List of violations of this constraint: Database reports/Constraint violations/P3804#Single value, hourly updated report, SPARQL

Format “\d{6,7}|\d{10}|”: value must be formatted using this pattern (PCRE syntax). (Help)

List of violations of this constraint: Database reports/Constraint violations/P3804#Format, hourly updated report, SPARQL

Type “human (Q5), film (Q11424), broadcasting program (Q11578774)”: item must contain property “instance of (P31)” with classes “human (Q5), film (Q11424), broadcasting program (Q11578774)” or their subclasses (defined using subclass of (P279)). (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/P3804#Type Q5, Q11424, Q11578774, 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)

List of violations of this constraint: Database reports/Constraint violations/P3804#Conflicts with P31, hourly updated report, 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/P3804#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/P3804#Scope, SPARQL

This property is being used by: en:Template:TV Guide show ne:ढाँचा:TV Guide ms:Templat:Rancangan TV Guide sr:Шаблон:TV Guide show my:တမ်းပလိတ်:TV Guide show vi:Bản mẫu:TV Guide, vi:Bản mẫu:TV Guide show arz:قالب:TV Guide show Please notify projects that use this property before big changes (renaming, deletion, merge with another property, etc.)

Discussion

New scheme

There is a report about a change of scheme at here. Accordingly, I de-activated the formatter url. If the new ids are to be stored, a different property should be used. --- Jura 21:36, 17 January 2021 (UTC)

I added a formatter URL which works with the old and new ID numbers. Examples for Veritas: The Quest (Q2530070):

Old ID: https://www.tvguide.com/tvshows/-/100564/

New ID: https://www.tvguide.com/tvshows/-/1030264268/

Either one redirects to: https://www.tvguide.com/tvshows/veritas-the-quest/1030264268/

-- Zyxw (talk) 02:35, 20 May 2021 (UTC)

• The usual approach would be to create a new property, not to re-purpose this. --- Jura 07:09, 20 May 2021 (UTC)

I am not suggesting this property be repurposed. I had added a format constraint to limit it to these old ID numbers which are 6 or 7 digits. The new 10 digit ID numbers can go in a new property once it is created. But if there is an updated TVGuide.com formatter URL that works with these old ID numbers, why shouldn't we use it? -- Zyxw (talk) 14:03, 20 May 2021 (UTC)

The formatter could indeed be updated and the constraint is helpful. It seems I misunderstood the addition of an id in the new scheme as sample of values to add [1]. I guess we should just skip that part. --- Jura 13:12, 21 May 2021 (UTC)