query-850cb25db3328ad0e9e40340f26074c5

# Quelles propriétés sont sourcées par le CQT
?property a wikibase:Property ;
   wikibase:claim ?ppp .
?item ?ppp ?statement .

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX psv: <http://www.wikidata.org/prop/statement/value/>
PREFIX prov: <http://www.w3.org/ns/prov#>
PREFIX pr: <http://www.wikidata.org/prop/reference/>
PREFIX p: <http://www.wikidata.org/prop/>
#Tous les éléments distincts sourcés avec le CQT avec les pourcentages de certaines natures, pays, naissance, etc..

SELECT (COUNT(DISTINCT ?item) AS ?total)
  (COUNT(DISTINCT ?membre_CQT) AS ?est_membre_CQT) (?est_membre_CQT / ?total * 100.0 AS ?pct_membre_CQT)
  (COUNT(DISTINCT ?item_a_pays) AS ?a_pays) (?a_pays / ?total * 100.0 AS ?pct_pays)
  (COUNT(DISTINCT ?item_a_image) AS ?a_image) (?a_image / ?total * 100.0 AS ?pct_image)
  (COUNT(DISTINCT ?item_est_géolocalisé) AS ?est_géolocalisé) (?est_géolocalisé / ?total * 100.0 AS ?pct_géolocalisé)
  (COUNT(DISTINCT ?item_est_organisation) AS ?est_organisation) (?est_organisation / ?total * 100.0 AS ?pct_organisation)
  (COUNT(?organisation_a_direction) AS ?a_direction) (?a_direction / ?est_organisation * 100.0 AS ?pct_direction)
  (COUNT(DISTINCT ?directionféminin) AS ?direction_féminin) (?direction_féminin / ?a_direction * 100.0 AS ?pct_direction_féminin)
  (COUNT(DISTINCT ?directionmasculin) AS ?direction_masculin) (?direction_masculin / ?a_direction * 100.0 AS ?pct_direction_masculin)
  (COUNT(DISTINCT ?item_est_oeuvre) AS ?est_oeuvre) (?est_oeuvre / ?total * 100.0 AS ?pct_oeuvre)
  (COUNT(?item_est_humain) AS ?est_humain) (?est_humain / ?total * 100.0 AS ?pct_humain)
  (COUNT(?item_est_féminin) AS ?est_féminin) (?est_féminin / ?est_humain * 100.0 AS ?pct_féminin)
  (COUNT(?item_est_masculin) AS ?est_masculin) (?est_masculin / ?est_humain * 100.0 AS ?pct_masculin)
  (COUNT(?item_est_nonsexué) AS ?est_nonsexué) (?est_nonsexué / ?est_humain * 100.0 AS ?pct_nonsexué) #non précisé
  (COUNT(DISTINCT ?item_a_naissance) AS ?a_naissance) (?a_naissance / ?est_humain * 100.0 AS ?pct_naissance)
  (COUNT(DISTINCT ?item_a_mort) AS ?est_mort) (?est_mort / ?est_humain * 100.0 AS ?pct_mort)
  (COUNT(DISTINCT ?date_décennie) AS ?a_décennie) (?a_décennie / ?est_humain * 100.0 AS ?pct_décennie)
  (COUNT(DISTINCT ?occupation) AS ?a_occupation) (?a_occupation / ?est_humain * 100.0 AS ?pct_occupation)
  (COUNT(DISTINCT ?fonction) AS ?a_fonction) (?a_fonction / ?est_humain * 100.0 AS ?pct_fonction)
  (COUNT(DISTINCT ?item_a_langueoeuvre) AS ?a_langueoeuvre) (?a_langueoeuvre / ?est_oeuvre * 100.0 AS ?pct_langue)
  (COUNT(DISTINCT ?oeuvre_est_fr) AS ?est_fr) (?est_fr / ?est_oeuvre * 100.0 AS ?pct_fr)
  (COUNT(DISTINCT ?oeuvre_est_en) AS ?est_en) (?est_en / ?est_oeuvre * 100.0 AS ?pct_en)
WHERE
{

{
  SELECT DISTINCT ?item
  WHERE
  {
    # Trouver les éléments avec le CQT en référence
    ?autre_statement pr:P248 wd:Q100443909 .
    ?statement prov:wasDerivedFrom ?autre_statement .

    # Quelles propriétés sont sourcées par le CQT
    ?property a wikibase:Property ;
       wikibase:claim ?ppp .
    ?item ?ppp ?statement .
  }
}  OPTIONAL
  {
    ?item wdt:P463 wd:Q64402570 .
    BIND (?item AS ?membre_CQT)
  }
  OPTIONAL
  {
    ?item (wdt:P17 | wdt:P27) ?pays .
    BIND (?item AS ?item_a_pays)
  }
  OPTIONAL
  {
    ?item wdt:P18 ?image .
    BIND (?item AS ?item_a_image)
  }
  OPTIONAL
  {
    ?item wdt:P625 ?géolocalisé .
    BIND (?item AS ?item_est_géolocalisé)
  }
  OPTIONAL
  {
    ?item wdt:P31 / wdt:P279* wd:Q43229 .

    BIND (?item AS ?item_est_organisation)
  }
    OPTIONAL
  {
    ?item wdt:P31 / wdt:P279* wd:Q43229 ;
          (wdt:P1037|wdt:P169|wdt:P8938) ?direction .
    BIND (?item AS ?organisation_a_direction)
  }
    OPTIONAL
  {
    ?item wdt:P31 / wdt:P279* wd:Q43229 ;
          (wdt:P1037|wdt:P169|wdt:P8938) ?direction .
    ?direction wdt:P21 wd:Q6581072 .
    BIND (?item AS ?directionféminin)
  }
    OPTIONAL
  {
    ?item wdt:P31 / wdt:P279* wd:Q43229 ;
          (wdt:P1037|wdt:P169|wdt:P8938) ?direction .
    ?direction wdt:P21 wd:Q6581097 .
    BIND (?item AS ?directionmasculin)
  }
    OPTIONAL
  {
    ?item wdt:P31 / wdt:P279* wd:Q386724 .

    BIND (?item AS ?item_est_oeuvre)
  }
  OPTIONAL
  {
    ?item wdt:P31 wd:Q5 .
    BIND (true AS ?item_est_humain)
  }
  OPTIONAL
  {
    ?item wdt:P31 wd:Q5.
    minus {?item wdt:P21 ?sexe .}
    BIND (true AS ?item_est_nonsexué)
  }
  OPTIONAL
  {
    ?item wdt:P21 wd:Q6581072 .
    BIND (true AS ?item_est_féminin)
  }
  OPTIONAL
  {
    ?item wdt:P21 wd:Q6581097 .
    BIND (true AS ?item_est_masculin)
  }
  OPTIONAL
  {
    ?item wdt:P569 ?naissance .
    BIND (?item AS ?item_a_naissance)
  }
  OPTIONAL
  {
    ?item wdt:P570 ?mort .
    BIND (?item AS ?item_a_mort)
  }
  OPTIONAL
  {
    ?item (p:P569/psv:P569|p:P570/psv:P570) [wikibase:timePrecision ?datePrecision; wikibase:timeValue ?naissance ] .
  filter(?datePrecision=8)
    BIND (?item AS ?date_décennie)
  }
  OPTIONAL
  {
    ?item wdt:P106 ?occupation .
    BIND (?item AS ?item_a_occupation)
  }
  OPTIONAL
  {
    ?item wdt:P39 ?fonction .
    BIND (?item AS ?item_a_fonction)
  }
   OPTIONAL
  {
    ?item wdt:P407 ?langueoeuvre .
    BIND (?item AS ?item_a_langueoeuvre)
  }
    OPTIONAL
  {
    ?item wdt:P407 wd:Q150 .
    BIND (?item AS ?oeuvre_est_fr)
  }
      OPTIONAL
  {
    ?item wdt:P407 wd:Q1860 .
    BIND (?item AS ?oeuvre_est_en)
  }
}

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v49("?a_direction"):::projected v69("?a_décennie"):::projected v73("?a_fonction"):::projected v43("?a_image"):::projected v75("?a_langueoeuvre"):::projected v65("?a_naissance"):::projected v71("?a_occupation"):::projected v41("?a_pays"):::projected v2("?autre_statement") v1("?datePrecision") v29("?date_décennie"):::projected v15("?direction") v51("?direction_féminin"):::projected v53("?direction_masculin"):::projected v17("?directionféminin"):::projected v18("?directionmasculin"):::projected v79("?est_en"):::projected v77("?est_fr"):::projected v59("?est_féminin"):::projected v45("?est_géolocalisé"):::projected v57("?est_humain"):::projected v61("?est_masculin"):::projected v39("?est_membre_CQT"):::projected v67("?est_mort"):::projected v63("?est_nonsexué"):::projected v55("?est_oeuvre"):::projected v47("?est_organisation"):::projected v32("?fonction"):::projected v12("?géolocalisé") v10("?image") v6("?item"):::projected v33("?item_a_fonction") v11("?item_a_image"):::projected v35("?item_a_langueoeuvre"):::projected v28("?item_a_mort"):::projected v26("?item_a_naissance"):::projected v31("?item_a_occupation") v9("?item_a_pays"):::projected v23("?item_est_féminin"):::projected v13("?item_est_géolocalisé"):::projected v20("?item_est_humain"):::projected v24("?item_est_masculin"):::projected v22("?item_est_nonsexué"):::projected v19("?item_est_oeuvre"):::projected v14("?item_est_organisation"):::projected v34("?langueoeuvre") v7("?membre_CQT"):::projected v27("?mort") v25("?naissance") v30("?occupation"):::projected v37("?oeuvre_est_en"):::projected v36("?oeuvre_est_fr"):::projected v16("?organisation_a_direction"):::projected v8("?pays") v50("?pct_direction") v52("?pct_direction_féminin") v54("?pct_direction_masculin") v70("?pct_décennie") v80("?pct_en") v74("?pct_fonction") v78("?pct_fr") v60("?pct_féminin") v46("?pct_géolocalisé") v58("?pct_humain") v44("?pct_image") v76("?pct_langue") v62("?pct_masculin") v40("?pct_membre_CQT") v68("?pct_mort") v66("?pct_naissance") v64("?pct_nonsexué") v72("?pct_occupation") v56("?pct_oeuvre") v48("?pct_organisation") v42("?pct_pays") v5("?ppp") v4("?property") v21("?sexe") v3("?statement") v38("?total"):::projected a1((" ")) a2((" ")) a3((" ")) a4((" ")) a5((" ")) a7((" ")) a8((" ")) a6((" ")) c6(["wikibase:Property"]):::iri c22(["wd:Q6581097"]):::iri c21(["wd:Q6581072"]):::iri c23(["wd:Q386724"]):::iri c24(["wd:Q5"]):::iri c36(["wd:Q150"]):::iri c37(["wd:Q1860"]):::iri c16(["wd:Q43229"]):::iri c9(["wd:Q64402570"]):::iri c3(["wd:Q100443909"]):::iri v2 --"p:reference/P248"--> c3 v3 --"prov:wasDerivedFrom"--> v2 v4 --"a"--> c6 v4 --"wikibase:claim"--> v5 v6 -->v5--> v3 subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v6 -."p:direct/P463".-> c9 bind0[/"?item"/] v6 --o bind0 bind0 --as--o v7 end subgraph optional1["(optional)"] style optional1 fill:#bbf,stroke-dasharray: 5 5; subgraph union0[" Union "] subgraph union0l[" "] style union0l fill:#abf,stroke-dasharray: 3 3; v6 -."p:direct/P27".-> v8 end subgraph union0r[" "] style union0r fill:#abf,stroke-dasharray: 3 3; v6 --"p:direct/P17"--> v8 end union0r <== or ==> union0l end bind1[/"?item"/] v6 --o bind1 bind1 --as--o v9 end subgraph optional2["(optional)"] style optional2 fill:#bbf,stroke-dasharray: 5 5; v6 -."p:direct/P18".-> v10 bind2[/"?item"/] v6 --o bind2 bind2 --as--o v11 end subgraph optional3["(optional)"] style optional3 fill:#bbf,stroke-dasharray: 5 5; v6 -."p:direct/P625".-> v12 bind3[/"?item"/] v6 --o bind3 bind3 --as--o v13 end subgraph optional4["(optional)"] style optional4 fill:#bbf,stroke-dasharray: 5 5; v6 -."p:direct/P31".-> a1 a1 --"p:direct/P279"--> c16 bind4[/"?item"/] v6 --o bind4 bind4 --as--o v14 end subgraph optional5["(optional)"] style optional5 fill:#bbf,stroke-dasharray: 5 5; v6 -."p:direct/P31".-> a2 a2 --"p:direct/P279"--> c16 subgraph union1[" Union "] subgraph union1l[" "] style union1l fill:#abf,stroke-dasharray: 3 3; subgraph union2[" Union "] subgraph union2l[" "] style union2l fill:#abf,stroke-dasharray: 3 3; v6 --"p:direct/P8938"--> v15 end subgraph union2r[" "] style union2r fill:#abf,stroke-dasharray: 3 3; v6 --"p:direct/P169"--> v15 end union2r <== or ==> union2l end end subgraph union1r[" "] style union1r fill:#abf,stroke-dasharray: 3 3; v6 --"p:direct/P1037"--> v15 end union1r <== or ==> union1l end bind5[/"?item"/] v6 --o bind5 bind5 --as--o v16 end subgraph optional6["(optional)"] style optional6 fill:#bbf,stroke-dasharray: 5 5; v6 -."p:direct/P31".-> a3 a3 --"p:direct/P279"--> c16 subgraph union3[" Union "] subgraph union3l[" "] style union3l fill:#abf,stroke-dasharray: 3 3; subgraph union4[" Union "] subgraph union4l[" "] style union4l fill:#abf,stroke-dasharray: 3 3; v6 --"p:direct/P8938"--> v15 end subgraph union4r[" "] style union4r fill:#abf,stroke-dasharray: 3 3; v6 --"p:direct/P169"--> v15 end union4r <== or ==> union4l end end subgraph union3r[" "] style union3r fill:#abf,stroke-dasharray: 3 3; v6 --"p:direct/P1037"--> v15 end union3r <== or ==> union3l end v15 --"p:direct/P21"--> c21 bind6[/"?item"/] v6 --o bind6 bind6 --as--o v17 end subgraph optional7["(optional)"] style optional7 fill:#bbf,stroke-dasharray: 5 5; v6 -."p:direct/P31".-> a4 a4 --"p:direct/P279"--> c16 subgraph union5[" Union "] subgraph union5l[" "] style union5l fill:#abf,stroke-dasharray: 3 3; subgraph union6[" Union "] subgraph union6l[" "] style union6l fill:#abf,stroke-dasharray: 3 3; v6 --"p:direct/P8938"--> v15 end subgraph union6r[" "] style union6r fill:#abf,stroke-dasharray: 3 3; v6 --"p:direct/P169"--> v15 end union6r <== or ==> union6l end end subgraph union5r[" "] style union5r fill:#abf,stroke-dasharray: 3 3; v6 --"p:direct/P1037"--> v15 end union5r <== or ==> union5l end v15 --"p:direct/P21"--> c22 bind7[/"?item"/] v6 --o bind7 bind7 --as--o v18 end subgraph optional8["(optional)"] style optional8 fill:#bbf,stroke-dasharray: 5 5; v6 -."p:direct/P31".-> a5 a5 --"p:direct/P279"--> c23 bind8[/"?item"/] v6 --o bind8 bind8 --as--o v19 end subgraph optional9["(optional)"] style optional9 fill:#bbf,stroke-dasharray: 5 5; v6 -."p:direct/P31".-> c24 bind9[/"'true^^xsd:boolean'"/] bind9 --as--o v20 end subgraph optional10["(optional)"] style optional10 fill:#bbf,stroke-dasharray: 5 5; v6 -."p:direct/P31".-> c24 subgraph minus10["MINUS"] style minus10 stroke-width:6px,fill:pink,stroke:red; v6 --"p:direct/P21"--> v21 end bind11[/"'true^^xsd:boolean'"/] bind11 --as--o v22 end subgraph optional11["(optional)"] style optional11 fill:#bbf,stroke-dasharray: 5 5; v6 -."p:direct/P21".-> c21 bind12[/"'true^^xsd:boolean'"/] bind12 --as--o v23 end subgraph optional12["(optional)"] style optional12 fill:#bbf,stroke-dasharray: 5 5; v6 -."p:direct/P21".-> c22 bind13[/"'true^^xsd:boolean'"/] bind13 --as--o v24 end subgraph optional13["(optional)"] style optional13 fill:#bbf,stroke-dasharray: 5 5; v6 -."p:direct/P569".-> v25 bind14[/"?item"/] v6 --o bind14 bind14 --as--o v26 end subgraph optional14["(optional)"] style optional14 fill:#bbf,stroke-dasharray: 5 5; v6 -."p:direct/P570".-> v27 bind15[/"?item"/] v6 --o bind15 bind15 --as--o v28 end subgraph optional15["(optional)"] style optional15 fill:#bbf,stroke-dasharray: 5 5; a6 -."wikibase:timePrecision".-> v1 a6 --"wikibase:timeValue"--> v25 subgraph union7[" Union "] subgraph union7l[" "] style union7l fill:#abf,stroke-dasharray: 3 3; v6 --"p:P570"--> a8 a8 --"p:statement/value/P570"--> a6 end subgraph union7r[" "] style union7r fill:#abf,stroke-dasharray: 3 3; v6 --"p:P569"--> a7 a7 --"p:statement/value/P569"--> a6 end union7r <== or ==> union7l end bind16[/"?item"/] v6 --o bind16 bind16 --as--o v29 end subgraph optional16["(optional)"] style optional16 fill:#bbf,stroke-dasharray: 5 5; v6 -."p:direct/P106".-> v30 bind17[/"?item"/] v6 --o bind17 bind17 --as--o v31 end subgraph optional17["(optional)"] style optional17 fill:#bbf,stroke-dasharray: 5 5; v6 -."p:direct/P39".-> v32 bind18[/"?item"/] v6 --o bind18 bind18 --as--o v33 end subgraph optional18["(optional)"] style optional18 fill:#bbf,stroke-dasharray: 5 5; v6 -."p:direct/P407".-> v34 bind19[/"?item"/] v6 --o bind19 bind19 --as--o v35 end subgraph optional19["(optional)"] style optional19 fill:#bbf,stroke-dasharray: 5 5; v6 -."p:direct/P407".-> c36 bind20[/"?item"/] v6 --o bind20 bind20 --as--o v36 end subgraph optional20["(optional)"] style optional20 fill:#bbf,stroke-dasharray: 5 5; v6 -."p:direct/P407".-> c37 bind21[/"?item"/] v6 --o bind21 bind21 --as--o v37 end bind44[/"count(?item)"/] v6 --o bind44 bind44 --as--o v38 bind45[/"count(?membre_CQT)"/] v7 --o bind45 bind45 --as--o v39 bind46[/"?est_membre_CQT / ?total * '100.0^^xsd:decimal'"/] v39 --o bind46 v38 --o bind46 bind46 --as--o v40 bind47[/"count(?item_a_pays)"/] v9 --o bind47 bind47 --as--o v41 bind48[/"?a_pays / ?total * '100.0^^xsd:decimal'"/] v41 --o bind48 v38 --o bind48 bind48 --as--o v42 bind49[/"count(?item_a_image)"/] v11 --o bind49 bind49 --as--o v43 bind50[/"?a_image / ?total * '100.0^^xsd:decimal'"/] v43 --o bind50 v38 --o bind50 bind50 --as--o v44 bind51[/"count(?item_est_géolocalisé)"/] v13 --o bind51 bind51 --as--o v45 bind52[/"?est_géolocalisé / ?total * '100.0^^xsd:decimal'"/] v45 --o bind52 v38 --o bind52 bind52 --as--o v46 bind53[/"count(?item_est_organisation)"/] v14 --o bind53 bind53 --as--o v47 bind54[/"?est_organisation / ?total * '100.0^^xsd:decimal'"/] v47 --o bind54 v38 --o bind54 bind54 --as--o v48 bind55[/"count(?organisation_a_direction)"/] v16 --o bind55 bind55 --as--o v49 bind56[/"?a_direction / ?est_organisation * '100.0^^xsd:decimal'"/] v49 --o bind56 v47 --o bind56 bind56 --as--o v50 bind57[/"count(?directionféminin)"/] v17 --o bind57 bind57 --as--o v51 bind58[/"?direction_féminin / ?a_direction * '100.0^^xsd:decimal'"/] v51 --o bind58 v49 --o bind58 bind58 --as--o v52 bind59[/"count(?directionmasculin)"/] v18 --o bind59 bind59 --as--o v53 bind60[/"?direction_masculin / ?a_direction * '100.0^^xsd:decimal'"/] v53 --o bind60 v49 --o bind60 bind60 --as--o v54 bind61[/"count(?item_est_oeuvre)"/] v19 --o bind61 bind61 --as--o v55 bind62[/"?est_oeuvre / ?total * '100.0^^xsd:decimal'"/] v55 --o bind62 v38 --o bind62 bind62 --as--o v56 bind63[/"count(?item_est_humain)"/] v20 --o bind63 bind63 --as--o v57 bind64[/"?est_humain / ?total * '100.0^^xsd:decimal'"/] v57 --o bind64 v38 --o bind64 bind64 --as--o v58 bind65[/"count(?item_est_féminin)"/] v23 --o bind65 bind65 --as--o v59 bind66[/"?est_féminin / ?est_humain * '100.0^^xsd:decimal'"/] v59 --o bind66 v57 --o bind66 bind66 --as--o v60 bind67[/"count(?item_est_masculin)"/] v24 --o bind67 bind67 --as--o v61 bind68[/"?est_masculin / ?est_humain * '100.0^^xsd:decimal'"/] v61 --o bind68 v57 --o bind68 bind68 --as--o v62 bind69[/"count(?item_est_nonsexué)"/] v22 --o bind69 bind69 --as--o v63 bind70[/"?est_nonsexué / ?est_humain * '100.0^^xsd:decimal'"/] v63 --o bind70 v57 --o bind70 bind70 --as--o v64 bind71[/"count(?item_a_naissance)"/] v26 --o bind71 bind71 --as--o v65 bind72[/"?a_naissance / ?est_humain * '100.0^^xsd:decimal'"/] v65 --o bind72 v57 --o bind72 bind72 --as--o v66 bind73[/"count(?item_a_mort)"/] v28 --o bind73 bind73 --as--o v67 bind74[/"?est_mort / ?est_humain * '100.0^^xsd:decimal'"/] v67 --o bind74 v57 --o bind74 bind74 --as--o v68 bind75[/"count(?date_décennie)"/] v29 --o bind75 bind75 --as--o v69 bind76[/"?a_décennie / ?est_humain * '100.0^^xsd:decimal'"/] v69 --o bind76 v57 --o bind76 bind76 --as--o v70 bind77[/"count(?occupation)"/] v30 --o bind77 bind77 --as--o v71 bind78[/"?a_occupation / ?est_humain * '100.0^^xsd:decimal'"/] v71 --o bind78 v57 --o bind78 bind78 --as--o v72 bind79[/"count(?fonction)"/] v32 --o bind79 bind79 --as--o v73 bind80[/"?a_fonction / ?est_humain * '100.0^^xsd:decimal'"/] v73 --o bind80 v57 --o bind80 bind80 --as--o v74 bind81[/"count(?item_a_langueoeuvre)"/] v35 --o bind81 bind81 --as--o v75 bind82[/"?a_langueoeuvre / ?est_oeuvre * '100.0^^xsd:decimal'"/] v75 --o bind82 v55 --o bind82 bind82 --as--o v76 bind83[/"count(?oeuvre_est_fr)"/] v36 --o bind83 bind83 --as--o v77 bind84[/"?est_fr / ?est_oeuvre * '100.0^^xsd:decimal'"/] v77 --o bind84 v55 --o bind84 bind84 --as--o v78 bind85[/"count(?oeuvre_est_en)"/] v37 --o bind85 bind85 --as--o v79 bind86[/"?est_en / ?est_oeuvre * '100.0^^xsd:decimal'"/] v79 --o bind86 v55 --o bind86 bind86 --as--o v80