Wikidata:Events/Belgium/CEMPER/Person without Wikipedia page

This is a list of useful queries related to persons.

No Wikipedia page

• Person should have a occupation (P106)
• Person should already have a Wikipedia page in another language

The following query uses these:

• Items: human (Q5)   , female (Q6581072)   , Belgium (Q31)   

• Properties: instance of (P31)   , sex or gender (P21)   , country of citizenship (P27)   , occupation (P106)   , field of work (P101)   , date of birth (P569)   , date of death (P570)   , family name (P734)   , given name (P735)   

  SELECT ?item ?itemLabel ?firstnameLabel ?lastnameLabel ?itemDescription ?nationalityLabel ?occupationLabel ?birthdate ?deathdate ?domainLabel ?linkcount WHERE {
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],nl,fr,de,en,es,it". }
    ?item wdt:P31 wd:Q5, ?instance;
      wdt:P21 wd:Q6581072, ?gender;
      wdt:P27 wd:Q31, ?nationality;
      wikibase:sitelinks ?linkcount;
      wdt:P106 ?occupation.
    MINUS {
      ?article schema:about ?item;
        schema:inLanguage "nl";
        schema:isPartOf <https://nl.wikipedia.org/>.
    }
    OPTIONAL { ?item wdt:P101 ?domain. }
    OPTIONAL { ?item wdt:P569 ?birthdate. }
    OPTIONAL { ?item wdt:P570 ?deathdate. }
    OPTIONAL { ?item wdt:P734 ?lastname. }
    OPTIONAL { ?item wdt:P735 ?firstname. }
  }
  ORDER BY (?itemLabel)
  

Try it!

Person having an occupation having a Wikipedia page

The following query uses these:

• Items: human (Q5)   , female (Q6581072)   , Belgium (Q31)   , actor (Q33999)   , ballerina (Q4070300)   , ballet dancer (Q805221)   , choreographer (Q2490358)   , dancer (Q5716684)   , film actor (Q10800557)   , musical theatre actor (Q1954956)   , opera singer (Q2865819)   , stage actor (Q2259451)   , theatrical director (Q3387717)   , performing artist (Q713200)   , cabaret performer (Q15214752)   , visual artist (Q3391743)   , conductor (Q158852)   , dramaturge (Q487596)   , film editor (Q7042855)   , filmmaker (Q1414443)   , film producer (Q3282637)   , film director (Q2526255)   , flautist (Q12902372)   , sound designer (Q3024424)   , comedian (Q245068)   , costume designer (Q1323191)   , librettist (Q8178443)   , lighting designer (Q1823479)   , creator (Q2500638)   , model (Q4610556)   , musician (Q639669)   , record producer (Q183945)   , pianist (Q486748)   , puppet designer (Q2217284)   , puppeteer (Q2629392)   , Q26209195, screenwriter (Q28389)   , scenographer (Q2707485)   , singer-songwriter (Q488205)   , voice actor (Q2405480)   , dub actor (Q11481802)   , television actor (Q10798782)   , keyboardist (Q1075651)   , videographer (Q3766177)   , singer (Q177220)   

• Properties: instance of (P31)   , sex or gender (P21)   , country of citizenship (P27)   , occupation (P106)   , field of work (P101)   , date of birth (P569)   , date of death (P570)   , family name (P734)   , given name (P735)   

  SELECT ?item ?itemLabel ?firstnameLabel ?lastnameLabel ?itemDescription ?nationalityLabel ?occupationLabel ?birthdate ?deathdate ?domainLabel ?linkcount WHERE {
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],nl,fr,de,en,es,it". }
    ?item wdt:P31 wd:Q5, ?instance;
      wdt:P21 wd:Q6581072, ?gender;
      wdt:P27 wd:Q31, ?nationality;
      wdt:P106 ?occupation;
      wikibase:sitelinks ?linkcount.
    {
      ?article schema:about ?item;
        schema:inLanguage "nl";
        schema:isPartOf <https://nl.wikipedia.org/>.
    }
    FILTER(?occupation IN (wd:Q33999, wd:Q4070300, wd:Q805221, wd:Q2490358, wd:Q5716684, wd:Q10800557, wd:Q1954956, wd:Q2865819, wd:Q2259451, wd:Q3387717, wd:Q713200, wd:Q15214752,
  wd:Q3391743, wd:Q158852, wd:Q487596, wd:Q7042855, wd:Q1414443, wd:Q3282637, wd:Q2526255, wd:Q12902372, wd:Q3024424, wd:Q245068, wd:Q1323191, wd:Q8178443, wd:Q1823479, wd:Q2500638, wd:Q4610556, wd:Q639669, wd:Q183945, wd:Q2865819, wd:Q486748, wd:Q2217284, wd:Q2629392, wd:Q26209195, wd:Q28389, wd:Q2707485, wd:Q488205, wd:Q2405480, wd:Q11481802, wd:Q10798782, wd:Q1075651, wd:Q3766177, wd:Q177220))
    OPTIONAL { ?item wdt:P101 ?domain. }
    OPTIONAL { ?item wdt:P569 ?birthdate. }
    OPTIONAL { ?item wdt:P570 ?deathdate. }
    OPTIONAL { ?item wdt:P734 ?lastname. }
    OPTIONAL { ?item wdt:P735 ?firstname. }
  }
  ORDER BY (?itemLabel)
  

Try it!

Count of persons by Occupation

We try to identify women in Belgium that do something in performing arts (Q184485).

The following query uses these:

• Items: human (Q5)   , female (Q6581072)   , Belgium (Q31)   , actor (Q33999)   , ballerina (Q4070300)   , ballet dancer (Q805221)   , cabaret performer (Q15214752)   , choreographer (Q2490358)   , dancer (Q5716684)   , film actor (Q10800557)   , musical theatre actor (Q1954956)   , opera singer (Q2865819)   , stage actor (Q2259451)   , theatrical director (Q3387717)   , performing artist (Q713200)   , visual artist (Q3391743)   , conductor (Q158852)   , dramaturge (Q487596)   , film editor (Q7042855)   , filmmaker (Q1414443)   , film producer (Q3282637)   , film director (Q2526255)   , flautist (Q12902372)   , sound designer (Q3024424)   , comedian (Q245068)   , costume designer (Q1323191)   , librettist (Q8178443)   , lighting designer (Q1823479)   , creator (Q2500638)   , model (Q4610556)   , musician (Q639669)   , record producer (Q183945)   , pianist (Q486748)   , puppet designer (Q2217284)   , puppeteer (Q2629392)   , Q26209195, screenwriter (Q28389)   , scenographer (Q2707485)   , singer-songwriter (Q488205)   , voice actor (Q2405480)   , dub actor (Q11481802)   , television actor (Q10798782)   , keyboardist (Q1075651)   , videographer (Q3766177)   , singer (Q177220)   

• Properties: instance of (P31)   , sex or gender (P21)   , country of citizenship (P27)   , occupation (P106)   

  SELECT ?occupation ?occupationLabel (COUNT(?item) AS ?count) WHERE {
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],nl,fr,de,en". }
    ?item wdt:P31 wd:Q5, ?instance;
      wdt:P21 wd:Q6581072, ?gender;
      wdt:P27 wd:Q31, ?nationality;
      wdt:P106 ?occupation.
    FILTER(?occupation IN(wd:Q33999, wd:Q4070300, wd:Q805221, wd:Q15214752, wd:Q2490358, wd:Q5716684, wd:Q10800557, wd:Q1954956, wd:Q2865819, wd:Q2259451, wd:Q3387717, wd:Q713200,
  wd:Q3391743, wd:Q158852, wd:Q487596, wd:Q7042855, wd:Q1414443, wd:Q3282637, wd:Q2526255, wd:Q12902372, wd:Q3024424, wd:Q245068, wd:Q1323191, wd:Q8178443, wd:Q1823479, wd:Q2500638, wd:Q4610556, wd:Q639669, wd:Q183945, wd:Q2865819, wd:Q486748, wd:Q2217284, wd:Q2629392, wd:Q26209195, wd:Q28389, wd:Q2707485, wd:Q488205, wd:Q2405480, wd:Q11481802, wd:Q10798782, wd:Q1075651, wd:Q3766177, wd:Q177220))
  }
  GROUP BY ?occupation ?occupationLabel
  ORDER BY (?occupationLabel)
  

Try it!

List of Occupations for Performing arts

The following query uses these:

• Items: human (Q5)   , female (Q6581072)   , Belgium (Q31)   , performing arts (Q184485)   

• Properties: instance of (P31)   , sex or gender (P21)   , country of citizenship (P27)   , field of work (P101)   , occupation (P106)   

  SELECT ?occupation ?occupationLabel (COUNT(?item) AS ?count) WHERE {
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],nl,fr,de,en". }
    ?item wdt:P31 wd:Q5, ?instance;
      wdt:P21 wd:Q6581072, ?gender;
      wdt:P27 wd:Q31, ?nationality;
      wdt:P101 wd:Q184485, ?domain;
      wdt:P106 ?occupation.
  }
  GROUP BY ?occupation ?occupationLabel
  ORDER BY (?occupationLabel)
  

Try it!

Searching persons with a missing Domain

The following query uses these:

• Items: human (Q5)   , female (Q6581072)   , Belgium (Q31)   

• Properties: instance of (P31)   , sex or gender (P21)   , country of citizenship (P27)   , occupation (P106)   , field of work (P101)   , date of birth (P569)   , date of death (P570)   , family name (P734)   , given name (P735)   

  SELECT ?item ?itemLabel ?firstnameLabel ?lastnameLabel ?itemDescription ?nationalityLabel ?occupationLabel ?birthdate ?deathdate WHERE {
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],nl,fr,de,en,es,it". }
    ?item wdt:P31 wd:Q5, ?instance;
      wdt:P21 wd:Q6581072, ?gender;
      wdt:P27 wd:Q31, ?nationality;
      wdt:P106 ?occupation.
    FILTER(!(EXISTS { ?item wdt:P101 ?domain. }))
    OPTIONAL { ?item wdt:P569 ?birthdate. }
    OPTIONAL { ?item wdt:P570 ?deathdate. }
    OPTIONAL { ?item wdt:P734 ?lastname. }
    OPTIONAL { ?item wdt:P735 ?firstname. }
  }
  ORDER BY (?itemLabel)
  

Try it!

• You can use QuickStatements to add the missing field of work (P101)

Run in WDFIST to assign matching pictures in Wikidata

The following query uses these:

• Items: human (Q5)   , female (Q6581072)   , Belgium (Q31)   , performing arts (Q184485)   

• Properties: instance of (P31)   , sex or gender (P21)   , country of citizenship (P27)   , field of work (P101)   , image (P18)   

  SELECT ?item WHERE {
    ?item wdt:P31 wd:Q5, ?instance;
      wdt:P21 wd:Q6581072, ?gender;
      wdt:P27 wd:Q31, ?nationality;
      wdt:P101 wd:Q184485, ?domain;
      wikibase:sitelinks ?linkcount.
    FILTER(?linkcount >= 1 )
    MINUS {?item wdt:P18 []}
  }
  

Try it!

Get the label of a list of Qnumbers

The following query uses these:

• Items: actor (Q33999)   

  SELECT ?item ?itemLabel WHERE {
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],nl,fr,de,en,es,it". }
    VALUES ?item {
      wd:Q33999
      # list with whitespace separator
    }
  }
  

Try it!

Result: acteur, etc.

Ideas

Schrijven voor Wikipedia project Vrouw en Dans (2020)

• Sort by descending linkcount; this should give you the most important persons having no page
• Replace sex or gender (P21) female (Q6581072) by male (Q6581097) to get the men

See also

• (nl) Projectpagina Dans Vrouwen in 't rood
• (nl) ListeriaBot query
• Wikidata:Events/Belgium/Open Knowledge Belgium/Towards Equal Street Names with Open Data