Property talk:P2447

Documentation

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

Transfermarkt manager ID
identifier for an association football (soccer) manager or coach in the transfermarkt.com database

Applicable "stated in" value	Transfermarkt (Q2449070)
Data type	External identifier
Template parameter	Template:Transfermarkt (Q12713043)
Allowed values	[1-9]\d{0,5} (numeric string, 1 to 6 digits)
Example	Josef Eichkorn (Q1704521) → 55 Felix Magath (Q153293) → 149 Jürgen Klopp (Q83106) → 118
Formatter URL	https://www.transfermarkt.com/-/profil/trainer/$1 https://www.transfermarkt.it/-/profil/trainer/$1 https://www.transfermarkt.co.in/-/profil/trainer/$1 https://www.transfermarkt.fr/-/profil/trainer/$1 https://www.transfermarkt.nl/-/profil/trainer/$1 https://www.transfermarkt.pt/-/profil/trainer/$1 https://www.transfermarkt.pl/-/profil/trainer/$1 https://www.transfermarkt.ru/-/profil/trainer/$1 https://www.transfermarkt.es/-/profil/trainer/$1 https://www.transfermarkt.ch/-/profil/trainer/$1 https://www.transfermarkt.co.uk/-/profil/trainer/$1 https://www.transfermarkt.de/-/profil/trainer/$1 https://www.transfermarkt.us/-/profil/trainer/$1 https://www.transfermarkt.com.br/-/profil/trainer/$1 https://www.transfermarkt.at/-/profil/trainer/$1 https://www.transfermarkt.com.tr/-/profil/trainer/$1
Tracking: same	no label (Q25969813)
Tracking: differences	no label (Q25969819)
Tracking: usage	Category:Pages using Wikidata property P2447 (Q25969821)
Tracking: local yes, WD no	no label (Q25969816)
See also	Transfermarkt player ID (P2446), Transfermarkt referee ID (P3699), Transfermarkt team ID (P7223), Transfermarkt match ID (P7455)
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/P2447 Database reports/Humans with missing claims/P2447 Database reports/Constraint violations/P2447 Map Random list
Proposal discussion	Proposal discussion
Current uses	Total 34,533 Main statement 29,628 85.8% of uses Qualifier 3 <0.1% of uses Reference 4,902 14.2% of uses
Search for values

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

Format “[1-9]\d{0,5}”: value must be formatted using this pattern (PCRE syntax). (Help)

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

Item “instance of (P31): human (Q5)”: Items with this property should also have “instance of (P31): human (Q5)”. (Help)

List of violations of this constraint: Database reports/Constraint violations/P2447#Item P31, hourly updated report, search, SPARQL

Item “sex or gender (P21)”: Items with this property should also have “sex or gender (P21)”. (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/P2447#Item P21, search, SPARQL

Item “occupation (P106)”: Items with this property should also have “occupation (P106)”. (Help)

List of violations of this constraint: Database reports/Constraint violations/P2447#Item P106, hourly updated report, search, SPARQL

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/P2447#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/P2447#Single value, 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/P2447#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/P2447#Scope, SPARQL

Item “sport (P641): association football (Q2736)”: Items with this property should also have “sport (P641): association football (Q2736)”. (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/P2447#Item P641, search, SPARQL

Label required in languages: en: Entities using this property should have labels in one of the following languages: en (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/P2447#Label in 'en' language, search, SPARQL

Label required in languages: de: Entities using this property should have labels in one of the following languages: de (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/P2447#Label in 'de' language, search, SPARQL

Identical ID for Transfermarkt player and coach
Person that has both "Transfermarkt player ID" and "Transfermarkt coach ID", and the ID is the same. These are normally errors, because the player and coach IDs are different (even for the same person!). (Help)
Violations query: SELECT ?item ?id WHERE { ?item wdt:P2446 ?id; wdt:P2447 ?id }
List of this constraint violations: Database reports/Complex constraint violations/P2447#Identical ID for Transfermarkt player and coach

This property is being used by: it:Template:Transfermarkt, it:Template:Collegamenti esterni fr:Modèle:Bases footballeur he:תבנית:פרופילי כדורגלנים no:Mal:Sportslenker uk:Шаблон:Transfermarkt be:Шаблон:Transfermarkt ru:Шаблон:TFF, ru:Шаблон:Transfermarkt ka:თარგი:Transfermarkt ce:Кеп:Transfermarkt vec:Modeło:Infobox de Sèrie de tełevixion tr:Şablon:Transfermarkt teknik direktör uz:Andoza:Transfermarkt Please notify projects that use this property before big changes (renaming, deletion, merge with another property, etc.)