query-b9474b977453b9eb424124e548b63703
Most commons name in Germany by year of birth and I wonder if we could be able to get the most commons 2-4 names in Germany by year of birth (of people who is alive). I have this, but it takes too long: this newsHello! I just read
Use at
- https://query.wikidata.org/sparql
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT ?Alemania ?AlemaniaLabel ?year ?name WHERE {
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
?Alemania wdt:P27 wd:Q183;
wdt:P569 ?dob.
MINUS { ?Alemania wdt:P570 ?dod. }
BIND(YEAR(?dob) AS ?year)
?Alemania wdt:P735 ?name.
}
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v1("?Alemania"):::projected
v2("?dob")
v3("?dod")
v5("?name"):::projected
v4("?year"):::projected
c2(["bd:serviceParam"]):::iri
c4(["#91;AUTO_LANGUAGE#93;,en"]):::literal
c6(["wd:Q183"]):::iri
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c2 --"wikibase:language"--> c4
end
v1 --"wdt:P27"--> c6
v1 --"wdt:P569"--> v2
subgraph minus0["MINUS"]
style minus0 stroke-width:6px,fill:pink,stroke:red;
v1 --"wdt:P570"--> v3
end
bind1[/"year-from-dateTime(?dob)"/]
v2 --o bind1
bind1 --as--o v4
v1 --"wdt:P735"--> v5