Property talk:P3696

Documentation

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

Sports-Reference.com college basketball player ID
identifier for a NCAA Division I college basketball player on the Sports-Reference.com college basketball website

Description	identifier for a college basketball player on the SRCBB website
Associated item	Sports Reference, LLC (Q17082873)
Applicable "stated in" value	College Basketball at Sports-Reference.com (Q100311335)
Data type	External identifier
Domain	According to this template: basketball player (Q3665646) According to statements in the property: human (Q5) When possible, data should only be stored as statements
Allowed values	According to this template: String According to statements in the property: [a-z2_-]+-\d{1,3} When possible, data should only be stored as statements
Example	Spencer Butterfield (Q27999086) → spencer-butterfield-1 Jack Cooley (Q6111803) → jack-cooley-1 Caitlin Clark (Q106298476) → caitlin-clark-1
Source	http://www.sports-reference.com/cbb/
Formatter URL	https://www.sports-reference.com/cbb/players/$1.html
Tracking: usage	Category:Pages using Wikidata property P3696 (Q28830949)
Related to country	United States of America (Q30) (See 769 others) Canada (Q16) (See 163 others)
See also	Basketball-Reference.com NBA player ID (P2685), Sports-Reference.com college football player ID (P3697), National Collegiate Basketball Hall of Fame ID (P4560), Sports-Reference.com college basketball coach ID (P4751), Sports-Reference.com college basketball box score ID (P8756), Sports-Reference.com college basketball team ID (P8825)
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 Mix'n'match (Report) Database reports/Constraint violations/P3696 Map Random list
Proposal discussion	Proposal discussion
Current uses	Total 182,191 Main statement 142,710 78.3% of uses Qualifier 3 <0.1% of uses Reference 39,478 21.7% 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/P3696#Unique value, hourly updated report, 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/P3696#Single value, SPARQL

Format “[a-z2_-]+-\d{1,3}”: 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: Michael Jones (Q100315800), Chris Van Ens (Q106814986)
List of violations of this constraint: Database reports/Constraint violations/P3696#Format, SPARQL

Item “educated at (P69)”: Items with this property should also have “educated at (P69)”. (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/P3696#Item P69, search, SPARQL

Item “member of sports team (P54)”: Items with this property should also have “member of sports team (P54)”. (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/P3696#Item P54, search, 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/P3696#Scope, hourly updated report, SPARQL

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

List of violations of this constraint: Database reports/Constraint violations/P3696#Entity types, hourly updated report

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

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

Item “league or competition (P118): NCAA Division I men's basketball (Q94861615), NCAA Division I women's basketball (Q94861433)”: Items with this property should also have “league or competition (P118): NCAA Division I men's basketball (Q94861615), NCAA Division I women's basketball (Q94861433)”. (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/P3696#Item P118, search

Type “human (Q5)”: item must contain property “instance of (P31)” with classes “human (Q5)” or their subclasses (defined using subclass of (P279)). (Help)

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

This property is being used by: he:תבנית:פרופילי כדורסלנים ja:Template:CBBstats en:Module:External links/conf/Sports (en:Module:External links, en:Template:Sports links) it:Modulo:Collegamenti esterni/Sport (it:Modulo:Collegamenti esterni, it:Template:Collegamenti esterni) Please notify projects that use this property before big changes (renaming, deletion, merge with another property, etc.)

Discussion

Mandatory occupation field ?

Is this a valid use of this constraint. College basketball players, can they truly be said to have an occupation of basketball player? They are not paid to be basketball players. Perhaps it would be better if there was a mandatory use of the item sport set to basketball.

False negatives for current regex pattern

Currently, this property uses the regular expression [a-z-_]+-\d{1,2} to test for valid IDs. After scraping all the IDs, I found a few that this regex doesn't match:

name	external_id
Karl Anderson	karl2-anderson-1
Mike Bell	mike2-bell-1
Tom 2 Brennan	tom2-brennan-1
Jim 2 Brown	jim2-brown-1
Justin Brownlee	justin-brown-116
Bill(2) Chambers	bill2-chambers-1
Charlie 2 Farrell	charlie2-farrell-1
Larry 2 Grisham	larry2-grisham-1
Greg Jones	greg-jones-911
Mike Jones	michael-jones
Sterling 2 Jones	sterling2-jones-1
Tom 2 Jones	tom2-jones-1
Johnny McCarthy	john2-mccarthy-1
Haworth 2 Parks	haworth2-parks-1
Daryle 2 Ruby	daryle2-ruby-1
Anthony Smith	anthony-smith-915
Jim 2 Walker	jim2-walker-1
Sam 2 Williams	sam2-williams-1

I'm going to update the regex to [a-z2-_]+-\d{1,3} to accommodate these. This still fails for "michael-jones", but I think that is better handled as an exception to constraint (P2303) (if we allowed for numberless slugs, people might omit the number on accident and not realize). –IagoQnsi (talk) 18:34, 12 October 2020 (UTC)

Duplicative mandatory constraints

Why does this need mandatory constraints on both league = NCAA Division I men's basketball and competition class = men's basketball. It's just duplicated data, by definition 'NCAA Division I men's basketball' is men's basketball CanadianCodhead (talk) 16:09, 16 October 2020 (UTC)

@CanadianCodhead: It's a broader way of retrieving that information; it's the same reason that sport=basketball is a mandatory constraint. If you wanted to do a query of all men's basketball, it'd be a more complex query if you had to dig into each league to figure out what competition class it was. –IagoQnsi (talk) 20:12, 17 October 2020 (UTC)

Women's basketball added

FYI: The site now includes Division I women's basketball. The site's women's database initially started with the 2009–10 season. — Dale Arnett (talk) 18:22, 21 February 2023 (UTC)