query-d8e5a08782d4678a5ac74bb2fb623f68

rq turtle/ttl

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

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 ?item ?itemLabel ?sitelink ?birthplace ?birthplaceLabel ?departement ?departementLabel ?year 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")
  BIND(YEAR(?birthdate) AS ?year)
  FILTER(?year >= 1975 )
  ?departement wdt:P150* ?birthplace.
  ?birthplace rdfs:label ?birthplaceLabel.
  FILTER((LANG(?birthplaceLabel)) = "fr")
  ?sitelink schema:about ?item;
    schema:isPartOf <https://fr.wikipedia.org/>.
}
ORDER BY ?year

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 v5("?departement"):::projected v4("?departementLabel"):::projected v6("?item"):::projected v3("?itemLabel"):::projected v9("?sitelink"):::projected v9("?year"):::projected c11([https://fr.wikipedia.org/]):::iri c4(["84"]):::literal f0[["?birthplaceLabel = 'fr'"]] f0 --> v2 f1[["?year >= '1975^^xsd:integer'"]] f1 --> v9 f2[["?itemLabel = 'fr'"]] f2 --> v3 f3[["?departementLabel = 'fr'"]] f3 --> v4 v5 --"wdt:P2586"--> c4 v5 --"rdfs:label"--> v4 v6 --"wdt:P19"--> v7 v6 --"wdt:P569"--> v8 v6 --"rdfs:label"--> v3 bind4[/"year-from-dateTime(?birthdate)"/] v8 --o bind4 bind4 --as--o v9 v5 --"wdt:P150"--> v7 v7 --"rdfs:label"--> v2 v9 --"schema:about"--> v6 v9 --"schema:isPartOf"--> c11