Property talk:P3145

Documentation

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

Sratim ID
identifier for a movie or person at the Israeli movie database Sratim (sratim.co.il)

Has quality	complex constraint label language (Q102746314)
Data type	External identifier
Domain	According to this template: film (Q11424), human (Q5) According to statements in the property: human (Q5), film (Q11424), film series (Q24856) or television series (Q5398426) When possible, data should only be stored as statements
Allowed values	(tt|nm)\d+
Example	Alila (film) (Q2836922) → tt158057 Amos Gitai (Q474262) → nm18338 Sophie Marceau (Q162753) → nm1432 Lauren German (Q261583) → nm12 Kelly Lynch (Q242523) → nm200
Source	https://www.sratim.co.il
Formatter URL	https://www.sratim.co.il/$1/
Related to country	Israel (Q801) (See 60 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 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/Complex constraint violations/P3145 Database reports/Humans with missing claims/P3145 Database reports/Constraint violations/P3145 Map Random list
Proposal discussion	Proposal discussion
Current uses	Total 7,237 Main statement 7,213 99.7% of uses Qualifier 6 <0.1% of uses Reference 18 0.2% 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 this constraint violations: Database reports/Constraint violations/P3145#Unique value, hourly updated report, SPARQL (every item), SPARQL (by value)

Single value: this property generally contains a single value. (Help) List of this constraint violations: Database reports/Constraint violations/P3145#Single value, hourly updated report, SPARQL

Type “human (Q5), film (Q11424), film series (Q24856), television series (Q5398426)”: element must contain property “instance of (P31)” with classes “human (Q5), film (Q11424), film series (Q24856), television series (Q5398426)” or their subclasses (defined using subclass of (P279)). (Help) List of this constraint violations: Database reports/Constraint violations/P3145#type, hourly updated report, 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 this constraint violations: Database reports/Constraint violations/P3145#Conflicts with, hourly updated report, SPARQL

Format “(tt|nm)[1-9]\d{0,9}”: value must be formatted using this pattern (PCRE syntax). (Help) List of this constraint violations: Database reports/Constraint violations/P3145#Format, hourly updated report, SPARQL

Format “(tt1?|nm)\d{0,8}”: value must be formatted using this pattern (PCRE syntax). (Help) Exceptions are possible as rare values may exist. List of this constraint violations: Database reports/Constraint violations/P3145#Format, 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. List of this constraint violations: Database reports/Constraint violations/P3145#allowed 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. List of this constraint violations: Database reports/Constraint violations/P3145#scope, SPARQL

Label language (1) items with this property would generally have a label in the language(s) defined at Property:P3145#P1552 with complex constraint label language (Q102746314) (Help) Violations query: SELECT DISTINCT ?item ?lang { hint:Query hint:optimizer "None". wd:P3145 p:P1552 [ ps:P1552 wd:Q102746314 ; pq:P407 / wdt:P424 ?lang ] . ?item wdt:P3145 [] . OPTIONAL { ?item rdfs:label ?l . FILTER( lang(?l)= ?lang ) } FILTER ( !BOUND(?l) ) } LIMIT 1000 List of this constraint violations: Database reports/Complex constraint violations/P3145#Label language (1)

Label language: total missing by language (1) number of items missing a label in the language(s) defined at Property:P3145#P1552 with complex constraint label language (Q102746314) (Help) Violations query: SELECT ?item ?lang (COUNT(?entity) as ?count) { hint:Query hint:optimizer "None". wd:P3145 p:P1552 [ ps:P1552 wd:Q102746314 ; pq:P407 ?item] . ?item wdt:P424 ?lang . ?entity wdt:P3145 [] . OPTIONAL { ?entity rdfs:label ?l. FILTER( lang(?l)= ?lang ) } FILTER ( !BOUND(?l) ) } GROUP BY ?item ?lang List of this constraint violations: Database reports/Complex constraint violations/P3145#Label language: total missing by language (1)

This property is being used by: he:תבנית:סרטים, he:תבנית:פרופילי שחקנים Please notify projects that use this property before big changes (renaming, deletion, merge with another property, etc.)