query-834e36b9dfbfa952620d6f0e95db2244
title:umani nati e morti in Italia con DBI id, senza VIAF, senza fonte per P570, morti prima del 1861 SELECT ?human ?humanLabel ?datan ?datam ?luogomLabel (URI(CONCAT("https://www.treccani.it/enciclopedia/",?idDBI,"_(Dizionario-Biografico)")) as ?idDBIurl) WHERE { ?human wdt:P569 ?datan; wdt:P570 ?datam; wdt:P19 ?luogon; wdt:P20 ?luogom. ?luogon wdt:P17 wd:Q38. ?luogom wdt:P17 wd:Q38. ?human wdt:P1986 ?idDBI . ?human p:P570 ?dm. MINUS { ?human wdt:P214 ?viaf. } MINUS { ?dm prov:wasDerivedFrom ?refm. } FILTER("1861-01-01"^^xsd:dateTime < ?datam) SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } }
Use at
- https://query.wikidata.org/sparql
PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX prov: <http://www.w3.org/ns/prov#>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
#title:umani nati e morti in Italia con DBI id, senza VIAF, senza fonte per P570, morti prima del 1861
SELECT ?human ?humanLabel ?datan ?datam ?luogomLabel (URI(CONCAT("https://www.treccani.it/enciclopedia/",?idDBI,"_(Dizionario-Biografico)")) as ?idDBIurl) WHERE {
?human wdt:P569 ?datan; wdt:P570 ?datam; wdt:P19 ?luogon; wdt:P20 ?luogom.
?luogon wdt:P17 wd:Q38.
?luogom wdt:P17 wd:Q38.
?human wdt:P1986 ?idDBI .
?human p:P570 ?dm.
MINUS { ?human wdt:P214 ?viaf. }
MINUS { ?dm prov:wasDerivedFrom ?refm. }
FILTER("1861-01-01"^^xsd:date < ?datam)
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v1("?datam"):::projected
v3("?datan"):::projected
v7("?dm")
v2("?human"):::projected
v6("?idDBI"):::projected
v10("?idDBIurl")
v5("?luogom")
v4("?luogon")
v9("?refm")
v8("?viaf")
c7(["wd:Q38"]):::iri
c13(["bd:serviceParam"]):::iri
c15(["#91;AUTO_LANGUAGE#93;,en"]):::literal
f0[["'1861-01-01^^xsd:date' < ?datam"]]
f0 --> v1
v2 --"p:direct/P569"--> v3
v2 --"p:direct/P570"--> v1
v2 --"p:direct/P19"--> v4
v2 --"p:direct/P20"--> v5
v4 --"p:direct/P17"--> c7
v5 --"p:direct/P17"--> c7
v2 --"p:direct/P1986"--> v6
v2 --"p:P570"--> v7
subgraph minus1["MINUS"]
style minus1 stroke-width:6px,fill:pink,stroke:red;
v2 --"p:direct/P214"--> v8
end
subgraph minus2["MINUS"]
style minus2 stroke-width:6px,fill:pink,stroke:red;
v7 --"prov:wasDerivedFrom"--> v9
end
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c13 --"wikibase:language"--> c15
end
bind3[/"concat('https://www.treccani.it/enciclopedia/',?idDBI,'_(Dizionario-Biografico)')"/]
v6 --o bind3
bind3 --as--o v10