query-79922631bb3b11010850d282abc02837

rq turtle/ttl

Tagishsimon

Use at

• https://query.wikidata.org/sparql

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX schema: <http://schema.org/>
PREFIX bd: <http://www.bigdata.com/rdf#>
select ?oc ?ocLabel  (count(?item) as ?number_of_women) where {

  #############################################################
  # select (an approximation of) the top level occupation classes

  #select occupations (instance of occupation) which have no occupation as a direct superclass
  ?oc wdt:P31 wd:Q28640 
    filter not exists { 
      ?superocc wdt:P31 wd:Q28640 . 
      ?oc wdt:P279 ?superocc .
    }

  # find all of their (non direct) specialisation
  ?suboc wdt:P31 wd:Q28640 .
  ?suboc wdt:P279+ ?oc .
  #############################################################

  # dealing with the "woman" part

  # ?item is a woman, which has any of the specialization of the occupation ?oc  
  ?item wdt:P106 ?suboc.


  {
    # subquery to select only the woman with no article on enwiki - made to be able to limit the size of the sample to avoid timout
    select ?item where {
      ?item wdt:P21 wd:Q6581072 .
      ?item wdt:P31 wd:Q5 
            filter not exists {
              ?article schema:about ?item .
              ?article schema:inLanguage "en" .
            }
    } limit 10000 # change the limit to change the size of the woman sample
  }

  #############################################################

  SERVICE wikibase:label {
   bd:serviceParam wikibase:language "en" .
  }

} group by ?oc ?ocLabel order by desc(?number_of_subclass)

Query found at

• https://www.wikidata.org/wiki/Wikidata:Request_a_query/Archive/2016/10