query-ec8321d4b659680aaa1e0ef8324f1f9d

rq turtle/ttl

Propertieslocated in the administrative territorial entity (P131)place of birth (P19)date of birth (P569)INSEE department code (P2586)

Use at

PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX schema: <http://schema.org/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT ?birthplace ?birthplaceLabel ?departement ?departementLabel (COUNT(*) as ?count) WHERE {
  ?departement ((^wdt:P131*)/^wdt:P19) ?item.
  ?item wdt:P19 ?birthplace;
    wdt:P569 ?birthdate;
    rdfs:label ?itemLabel.
  FILTER((LANG(?itemLabel)) = "fr")
  ?departement wdt:P2586 "84";
    rdfs:label ?departementLabel.
  FILTER((LANG(?departementLabel)) = "fr")
  ?birthplace rdfs:label ?birthplaceLabel.
  FILTER((LANG(?birthplaceLabel)) = "fr")
  ?sitelink schema:about ?item;
    schema:isPartOf <https://fr.wikipedia.org/>.
}
GROUP BY ?birthplace ?birthplaceLabel ?departement ?departementLabel
ORDER BY DESC(?count)

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v8("?birthdate") v7("?birthplace"):::projected v2("?birthplaceLabel"):::projected v10("?count") v5("?departement"):::projected v3("?departementLabel"):::projected v6("?item") v4("?itemLabel") v9("?sitelink") a1((" ")) c10([https://fr.wikipedia.org/]):::iri c7(["84"]):::literal f0[["?birthplaceLabel = 'fr'"]] f0 --> v2 f1[["?departementLabel = 'fr'"]] f1 --> v3 f2[["?itemLabel = 'fr'"]] f2 --> v4 a1 --"wdt:P131"--> v5 v6 --"wdt:P19"--> a1 v6 --"wdt:P19"--> v7 v6 --"wdt:P569"--> v8 v6 --"rdfs:label"--> v4 v5 --"wdt:P2586"--> c7 v5 --"rdfs:label"--> v3 v7 --"rdfs:label"--> v2 v9 --"schema:about"--> v6 v9 --"schema:isPartOf"--> c10 bind4[/"count(*)"/] bind4 --as--o v10