User:MarioGom/Issues related to names/Top ambiguous male

From Wikidata
Jump to navigation Jump to search

This list is periodically updated by a bot. Manual changes to the list will be removed on the next update!

WDQS | PetScan | TABernacle | Find images | Recent changes | Query: SELECT (?given AS ?item) ?count WHERE { { SELECT ?given (COUNT(?item) AS ?count) WHERE { hint:Query hint:optimizer "None" . ?given wdt:P31 wd:Q11879590 . # has female given name FILTER NOT EXISTS { ?given wdt:P31 wd:Q3409032 . } # not unisex given name FILTER NOT EXISTS { ?given wdt:P31 wd:Q12308941 . } # not male given name ?item wdt:P735 ?given . ?item wdt:P21 wd:Q6581097 . # is male ?item wdt:P31 wd:Q5 . # human # Prioritize cases with sitelinks at the moment # WARN: with ?linkCount >= 1 it will timeout ?item wikibase:sitelinks ?linkcount . FILTER (?linkcount >= 1) # filter out The Peerage entries, too many wrong entries, # it should be handled separately FILTER NOT EXISTS { ?item wdt:P4638 ?thepeerageid . } FILTER NOT EXISTS { ?item wdt:P735/wdt:P31 ?otherGiven . hint:Prior hint:gearing "forward" . VALUES ?otherGiven { wd:Q3409032 # unisex given name wd:Q12308941 # male given name } } # not combined with a male or unisex given name } GROUP BY ?given } FILTER(?count >= 20) } ORDER BY DESC(?count) LIMIT 20
item label description count instance of language of work or name
Q19831808 Loren female given name 84 female given name English
Q325872 Maria female given name 49 female given name
given name
Polish
Arabic
Catalan
Dutch
German
Portuguese
Italian
Latin
Romanian
Q1043619 Carmen female given name 44 female given name Italian
Spanish
Dutch
Q19819774 Connie female given name 40 female given name
Q3335513 Nana female given name 39 female given name Japanese
Georgian
Q3836481 Lois female given name 37 female given name English
Welsh
Dutch
Q19826118 Stacey female given name 25 female given name Dutch
Q1221747 Karen female given name 24 female given name English
Danish
Dutch
Japanese
Q2456724 Iman given name 24 female given name
Q666578 Anna female given name 22 female given name Catalan
Czech
Hebrew
Latvian
Dutch
Q1611595 Tara female given name 21 female given name Arabic
Dutch
Q13138335 Tine female given name 20 female given name Dutch

∑ 12 items.

End of automatically generated list.