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