Property talk:P2091

Documentation

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

World Rowing ID
identifier for a rower in the database of World Rowing (FISA)

Associated item	World Rowing (Q684885)
Applicable "stated in" value	World Rowing athlete database (Q21008628)
Data type	External identifier
Corresponding template	not applicable
Domain	persons (note: this should be moved to the property statements)
Allowed values	According to this template: numbers with 1 to 5 digits According to statements in the property: [1-9]\d{0,4}| (numeric string with 1 to 5 digits; or novalue) When possible, data should only be stored as statements
Example	Hamish Bond (Q1321253) → 20096 Kim Brennan (Q576663) → 24665 Kristof Wilke (Q64501) → 20438 Miroslava Knapková (Q435707) → 13214
Source	https://www.worldrowing.com/
Formatter URL	https://worldrowing.com/athlete/$1
Tracking: same	Category:World Rowing ID same as Wikidata (Q25350932)
Tracking: differences	Category:World Rowing ID different from Wikidata (Q25350933)
Tracking: usage	Category:World Rowing template using Wikidata (Q24689919)
Tracking: local yes, WD no	Category:World Rowing ID not in Wikidata (Q25350930)
See also	World Rowing UUID (P8990)
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/Humans with missing claims/P2091 Database reports/Constraint violations/P2091 Map Random list
Proposal discussion	Proposal discussion
Current uses	Total 17,691 Main statement 14,731 out of 51,775 (28% complete) 83.3% of uses Qualifier 4 <0.1% of uses Reference 2,956 16.7% of uses
Search for values

Explanations [bearbeiten]

World Rowing ID (P2091) is a simple authority control property to link Wikidata items to entries in the World Rowing athlete database (Q21008628). This database is operated by World Rowing (Q684885) (formerly known as FISA), the international governing body of rowing (Q159354), and contains the most complete set of data about international rowing persons and rowing events which is publicly available.

On 17 December 2020, World Rowing (Q684885) relaunched their website and issued a new Universally Unique Identifier (Q195284) for all rowers; these may be found in the Wikidata property World Rowing UUID (P8990).

On 9 January 2021, World Rowing (Q684885) returned to using the previous numeric identifier (Q93868746) for all rowers, may be found in the Wikidata property World Rowing ID (P2091).

Add this property

To use this property, you need to determine the identifier in the World Rowing database: let’s consider the example of the Olympic champion Kim Brennan (Q576663); the profile about her can be found at:

http://web.archive.org/web/20201004003834/http://www.worldrowing.com/athletes/athlete/24665/

https://www.worldrowing.com/athlete/24665/

The yellow part is the identifier to use within this property, while the remaining part of the URL is defined within the property page World Rowing ID (P2091) using the formatter URL (P1630) property.

FISA maintains a pretty nice database which comprises data of around 50 000 persons (as of February 2019); however, in roughly 1–2% of the cases there are multiple entries for the same person (amount estimated). This means that one needs to add multiple values for this property within an item, which in turn violates the single-value constraint (Q19474404) defined by a property constraint (P2302) statement on Property:P2091. In case of multiple IDs for one person, qualify each identifier with a subject named as (P1810) qualifier using the database entry title (do not use the all-uppercase family names from the database). We want to avoid using exception to constraint (P2303) qualifiers to the single-value constraint (Q19474404).

In case of multiple values it is also important to set proper ranks for the individual claims. If all important information about a person is contained within a single profile out of the available profiles, then mark the important claim with preferred rank. There are cases, however, in which this is not possible and the information is distributed across multiple important profiles. All of them should use the normal rank. Deprecated rank should not be used at all for any value that has been valid in the past.

Please also add empty profiles which often do not contain much more than a person’s name. We do not know whether FISA will start to add content to database entries which are still (almost) empty.

Use this property

Within Wikidata this property is used to link against FISA’s database and to identify multiple items per person (via the distinct-values constraint (Q21502410), defined by a property constraint (P2302) statement on Property:P2091). Identifiers can also be queried using the common query tools for applications outside Wikimedia.

On Wikipedias, there are typically templates available (such as Template:World Rowing (Q14334032) and others, see {{ExternalUse}} template on Property talk:P2091) which either store the same identifier locally within the Wikipedia, or take the data from Wikidata by using the {{#property:P2091}} oder {{#statements:P2091}} parser function or more sophisticated functions of Module:Wikidata (Q12069631) and others. In case of the existence of a local value, one can also compare it to the Wikidata value and make use of maintenance categories, which are linked from the {{Property documentation}} template on Property talk:P2091. However, be aware that in case of an item with multiple claims, of which none is the primary one marked with preferred rank, you also might get multiple values if you pull this information from Wikidata.

See also

This property is maintained by WikiProject Rowing.

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/P2091#Unique value, hourly updated report, SPARQL (every item), SPARQL (by value)

Single best value: this property generally contains a single value. If there are several, one would have preferred rank (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/P2091#single best value, SPARQL

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

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

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

List of violations of this constraint: Database reports/Constraint violations/P2091#Scope, 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/P2091#Entity types

Qualifiers “subject named as (P1810), reason for deprecated rank (P2241), reason for preferred rank (P7452)”: this property should be used only with the listed qualifiers. (Help)

List of violations of this constraint: Database reports/Constraint violations/P2091#allowed qualifiers, 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/P2091#Item P31, hourly updated report, search, SPARQL

Item “occupation (P106): rower (Q13382576), coxswain (Q1690874), rowing coach (Q21121588), rowing umpire (Q27532776), rowing administrator (Q21578283), coastal rower (Q72168361)”: Items with this property should also have “occupation (P106): rower (Q13382576), coxswain (Q1690874), rowing coach (Q21121588), rowing umpire (Q27532776), rowing administrator (Q21578283), coastal rower (Q72168361)”. (Help)

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

Item “sport (P641): rowing (Q159354), para rowing (Q1575010)”: Items with this property should also have “sport (P641): rowing (Q159354), para rowing (Q1575010)”. (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/P2091#Item P641, search

Item “country of citizenship (P27)”: Items with this property should also have “country of citizenship (P27)”. (Help)

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

Item “World Rowing UUID (P8990)”: Items with this property should also have “World Rowing UUID (P8990)”. (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/P2091#Item P8990, search, SPARQL

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

List of violations of this constraint: , hourly updated report, SPARQL (every item), SPARQL (by value),

Single value: this property generally contains a single value.

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

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

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/P2091#Format, SPARQL

Type “human (Q5)”: element must contain property instance of (P31) with class human (Q5) or its subclasses (defined using subclass of (P279))

List of violations of this constraint: Database reports/Constraint violations/P2091#Type Q5, hourly updated report, SPARQL

Item: items with this property should also have sex or gender (P21)

List of violations of this constraint: Database reports/Constraint violations/P2091#Item P21, hourly updated report, SPARQL. Count by value