Wikidata:WikiProject Names/reports

From Wikidata
Jump to navigation Jump to search

Home

  

Maintenance reports

  

Reference lists

  

The maintenance reports and queries that can help improve the data in scope of WikiProject Names:

Constraint reports

[edit]

Regularly updated reports and dynamic lists

[edit]

(given names)

(surnames)

(labels on items used by P735/P734: mixed and identical)

Project reports

[edit]

Queries

[edit]

Family name doubles detection

[edit]

(cette requête ne doit renvoyer aucun résultat)

The following query uses these:

  • Properties: instance of (P31)  View with Reasonator View with SQID, family name (P734)  View with Reasonator View with SQID
    SELECT DISTINCT ?nameitem ?nameitem_label ?disambigitem ?disambigitem_label WHERE {
  #Family names that are just family names
  {
    SELECT DISTINCT ?nameitem ?nameitem_label (COUNT(?type) as ?nb) WHERE {
      ?nameitem wdt:P31 wd:Q101352 .
      ?nameitem wdt:P31 ?type .	
      ?nameitem rdfs:label ?nameitem_label . FILTER (LANG(?nameitem_label) = "en") .
    } GROUP BY ?nameitem ?nameitem_label HAVING (?nb = 1)
  }
  
  #Family names that are both family names and disambig pages
  {
    SELECT DISTINCT ?disambigitem ?disambigitem_label WHERE {
      ?disambigitem wdt:P31 wd:Q101352 .
      ?disambigitem wdt:P31 wd:Q4167410 .
      ?person wdt:P734 ?disambigitem .
      
      ?disambigitem rdfs:label ?disambigitem_label . FILTER (LANG(?disambigitem_label) = "en") .
    }
  }
  
  FILTER(?nameitem_label = ?disambigitem_label)
} LIMIT 10
Try it!
Retrieved from "https://www.wikidata.org/w/index.php?title=Wikidata:WikiProject_Names/reports&oldid=1414317260"