Property talk:P8825

Documentation

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

Sports-Reference.com college basketball team ID
identifier for a NCAA college basketball team on the Sports-Reference.com college basketball website

Applicable "stated in" value	College Basketball at Sports-Reference.com (Q100311335)
Data type	External identifier
Domain	basketball team (Q13393265)
Allowed values	[a-z]+[a-z-]*[a-z]+\/(men|women)
Example	Duke Blue Devils men's basketball (Q4171772) → duke/men UCLA Bruins men's basketball (Q3615392) → ucla/men UMBC Retrievers women's basketball (Q30325973) → maryland-baltimore-county/women
Source	https://www.sports-reference.com/cbb/schools/
Formatter URL	https://www.sports-reference.com/cbb/schools/$1/
Tracking: usage	Category:Pages using Wikidata property P8825 (Q102045911)
Related to country	United States of America (Q30) (See 771 others)
See also	Sports-Reference.com college basketball player ID (P3696), Sports-Reference.com college basketball coach ID (P4751), Sports-Reference.com college basketball box score ID (P8756)
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 Mix'n'match (Report) Database reports/Constraint violations/P8825 Map Random list
Proposal discussion	Proposal discussion
Current uses	Total 868 Main statement 861 out of 861 (100% complete) 99.2% of uses Qualifier 3 0.3% of uses Reference 4 0.5% of uses
Search for values

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

Format “[a-z]+[a-z-]*[a-z]+\/(men|women)”: 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).
List of violations of this constraint: Database reports/Constraint violations/P8825#Format, SPARQL

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

Type “basketball team (Q13393265)”: item must contain property “instance of (P31)” with classes “basketball team (Q13393265)” 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/P8825#Type Q13393265, 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/P8825#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/P8825#Scope, 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/P8825#Item P118, search

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

Item “country (P17): United States of America (Q30)”: Items with this property should also have “country (P17): United States of America (Q30)”. (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/P8825#Item P17, search, SPARQL

Item “parent club (P831)”: Items with this property should also have “parent club (P831)”. (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/P8825#Item P831, search, SPARQL

Adding women's teams

Today/yesterday, Sports Reference added women's teams to their college basketball site. They implemented this by adding `/men` to all existing team URLs, and all the women's teams can be found by changing `/men` to `/women` (e.g. the Duke men's team moved from https://www.sports-reference.com/cbb/schools/duke/ to https://www.sports-reference.com/cbb/schools/duke/men/, and the women's team is now available at https://www.sports-reference.com/cbb/schools/duke/women/).

To me, it seems like the easiest and best way to handle this change on Wikidata is simply to include the `/men` or `/women` part in the ID that we store (e.g. the ID stored on the Duke men's team would change from 'duke' to 'duke/men'). That way, any template that naively builds URLs with this property will continue to work just as before, and will be able to support women's teams with no changes. If for some reason, someone needed the old IDs (not sure why they would), they can just strip '/men' from the new IDs (and ignore any IDs ending in '/women'). IagoQnsi (talk) 02:39, 11 February 2023 (UTC)

Went ahead and updated the regex, and ran a batch to add '/men' to all existing IDs. Planning to batch-add women's teams soon. IagoQnsi (talk) 03:12, 11 February 2023 (UTC)

Finally added IDs to all women's teams earlier today, and also created new items for the 8 teams which didn't already have items (7 historical teams plus Queens Royals, which just joined D1 this season). –IagoQnsi (talk) 04:49, 6 March 2023 (UTC)