Wikidata:WikiProject Rowing/people

From Wikidata
Jump to navigation Jump to search
WikiProject Rowing
WikiProject start page • participants • statistics • l10n

Structural items[edit]

All people notable for their achievements in the sport of rowing shall be collected here (in total: more than 15.000 items as of January 2020). Rowing people can be classified to at least the following relevant groups (red font=structural item is missing):

To make a person item being in scope of WikiProject Rowing, an occupation (P106) relation with one of the values given above is expected. rowing figure (Q26270618) is considered as a structural item to conveniently access all rowing persons at once.

How to tag[edit]

Overview: Wikidata:List of properties/human. Important for rowers:

  1. Tag as human:
  2. Person data:
  3. Nation:
  4. Names (Wikidata:WikiProject Names)
  5. Family relationships: Wikidata:List of properties/human#Relationship
  6. Tag as a rower:
  7. Authority control properties:
  8. More interesting stuff:
  9. For event participation and race results, see Wikidata:WikiProject Rowing/results. This includes usage of the following properties:

For further interesting properties, see also:

Already tagged[edit]

For tagging, all rowers from local Wikipedias have automatically been collected from categories (including subcategories) of these items: Category:Rowers (Q9782304), Category:Rowing people (Q8683758), Category:Coxswains (rowing) (Q8425459), Category:Rowing coaches (Q6229182), Category:Rowing officials (Q8683751) (not very clean procedure at the moment, needs improvement).

All of these rowers have already been tagged as “rowing people” (access in SPARQL with ?item p:P106/ps:P106/wdt:P279* wd:Q26270618). This means they have a statement:

  • occupation (P106)subclass of rowing figure (Q26270618)

You can find rowers on Wikidata by following these links:

Since there are a couple of people actually categorized as rowing people in local Wikipedias, but who are not notable for rowing, the following blacklist of exceptions applies (as of October 11, 2015; needs cleanup):

Worklists[edit]

Missing given name[edit]

From Wikidata:Database reports/Humans with missing claims/P2091. Useful query: 

SELECT ?item ?itemLabel WHERE {
	?item p:P106/ps:P106/wdt:P279* wd:Q26270618 .
  	MINUS { ?item wdt:P735 ?foo . }
	SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
} ORDER BY ASC(?itemLabel)
Try it!

Wikidata:WikiProject Names#How to create a new item for a given name explains how to create items for missing given names. This is necessary for most affected items about rowers.

Missing series ordinal qualifiers[edit]

SELECT DISTINCT ?item ?itemLabel (COUNT(?givenname) AS ?cnt) WITH {
  SELECT DISTINCT ?item WHERE {
    ?item p:P106/ps:P106/wdt:P279* wd:Q26270618 .
  }
} AS %s WHERE {
  INCLUDE %s .
  ?item p:P735 ?givenname .
  MINUS { ?givenname pq:P1545 [] }
  SERVICE wikibase:label { bd:serviceParam wikibase:language 'en' }
} GROUP BY ?item ?itemLabel HAVING(?cnt>1)
Try it!

More than one given name with best rank[edit]

We use preferred rank for the preferred given name. In some cases, none of multiple given names can be identified as preferred, which means we use normal rank for all given name claims. 

SELECT DISTINCT ?item ?itemLabel (COUNT(?givenname) AS ?cnt) WITH {
  SELECT DISTINCT ?item WHERE {
    ?item p:P106/ps:P106/wdt:P279* wd:Q26270618 .
  }
} AS %s WHERE {
  INCLUDE %s .
  ?item p:P735 ?givenname .
  ?givenname a wikibase:BestRank .
  SERVICE wikibase:label { bd:serviceParam wikibase:language 'en' }
} GROUP BY ?item ?itemLabel HAVING(?cnt>1)
Try it!
Retrieved from "https://www.wikidata.org/w/index.php?title=Wikidata:WikiProject_Rowing/people&oldid=1099641754"