query-94c83ab0869ae7ad527abd7065c60d58

rq turtle/ttl

PropertiesINSEE department code (P2586)   place of birth (P19)   date of birth (P569)   contains administrative territorial entity (P150)   PropertiesINSEE department code (P2586)place of birth (P19)date of birth (P569)contains the administrative territorial entity (P150)

Use at

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

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:P2586 "84";
    rdfs:label ?departementLabel.
  FILTER((LANG(?departementLabel)) = "fr")
  ?item wdt:P19 ?birthplace;
    wdt:P569 ?birthdate;
    rdfs:label ?itemLabel.
  FILTER((LANG(?itemLabel)) = "fr")
  ?departement wdt:P150* ?birthplace.
  ?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

• https://www.wikidata.org/w/index.php?title=Topic:Wps7qokf58ewsy0i&topic_showPostId=wpuag15h7ajcq1k1#flow-post-wpuag15h7ajcq1k1
• https://www.wikidata.org/wiki/Topic:Wps7qokf58ewsy0i
• https://www.wikidata.org/wiki/User:PAC2/D%C3%A9partements