ESEMPI QUERY SPARQL
[esegui query] – Ebrei stranieri arrestati e deportati dall'Italia
select distinct ?Name ?Country ?BirthPlace ?ArrestPlace ?CampName from <http://dati.cdec.it/lod/shoah/> where {?IRI a <http://xmlns.com/foaf/0.1/Person>; rdfs:label ?Name; <http://dati.cdec.it/lod/bio-ext/birthPlace> ?Birth. ?Birth rdfs:label ?BirthPlace.
?Birth <http://xmlns.com/foaf/0.1/country> ?Country.
FILTER(?Country != 'Italia').
OPTIONAL{
?IRI <http://dati.cdec.it/lod/shoah/persecution> ?pers.
?pers <http://dati.cdec.it/lod/shoah/arrestPlace> ?arr. ?arr rdfs:label ?ArrestPlace.
?pers <http://dati.cdec.it/lod/shoah/toNaziCamp> ?camp. ?camp rdfs:label ?CampName.
}
} ORDER BY ?Country
[esegui query] – Località di arresto e luoghi di partenza dei convogli
select distinct ?Name ?BirthPlace ?ArrestPlace ?raccolta from <http://dati.cdec.it/lod/shoah/> where {?IRI a <http://xmlns.com/foaf/0.1/Person>; rdfs:label ?Name; <http://dati.cdec.it/lod/bio-ext/birthPlace> ?Birth. ?Birth rdfs:label ?BirthPlace.?IRI <http://dati.cdec.it/lod/shoah/persecution> ?pers.
OPTIONAL{?pers <http://dati.cdec.it/lod/shoah/arrestPlace> ?arr. ?arr rdfs:label ?ArrestPlace.}
OPTIONAL{?pers <http://dati.cdec.it/lod/shoah/convoyDeparturePlace> ?racc. ?racc rdfs:label ?raccolta.}
} ORDER BY ?Name
[esegui query] – Tutti i convogli con data di partenza e campo di destinazione
select distinct ?convoy ?labelConvoy ?deparDate ?labelCamp from <http://dati.cdec.it/lod/shoah/> where
{?convoy a <http://dati.cdec.it/lod/shoah/Convoy>;
rdfs:label ?labelConvoy;
<http://dati.cdec.it/lod/shoah/departureDate> ?deparDate;
<http://dati.cdec.it/lod/shoah/toNaziCamp> ?naziCamp.
?naziCamp rdfs:label ?labelCamp}
ORDER BY ?deparDate
[esegui query] – Composizione dei convogli (genere)
select distinct ?convoy ?labelConvoy ?deparDate ?labelCamp ?gender (count(?gender) as ?count) from <http://dati.cdec.it/lod/shoah/> where
{?convoy a <http://dati.cdec.it/lod/shoah/Convoy>;
rdfs:label ?labelConvoy;
<http://dati.cdec.it/lod/shoah/departureDate> ?deparDate;
<http://dati.cdec.it/lod/shoah/toNaziCamp> ?naziCamp.
?naziCamp rdfs:label ?labelCamp.
?person <http://dati.cdec.it/lod/shoah/persecution> ?pers.
?pers <http://dati.cdec.it/lod/shoah/convoy> ?convoy.
OPTIONAL {?person <http://xmlns.com/foaf/0.1/gender> ?gender.}
}ORDER BY ?convoy
[esegui query] – Composizione dei convogli (bambini)
select distinct ?convoy ?labelConvoy ?deparDate ?labelCamp ?gender (count(?gender) as ?count) from <http://dati.cdec.it/lod/shoah/> where
{?convoy a <http://dati.cdec.it/lod/shoah/Convoy>;
rdfs:label ?labelConvoy;
<http://dati.cdec.it/lod/shoah/departureDate> ?deparDate;
<http://dati.cdec.it/lod/shoah/toNaziCamp> ?naziCamp.
?naziCamp rdfs:label ?labelCamp.
?person <http://dati.cdec.it/lod/shoah/persecution>?pers; <http://dati.cdec.it/lod/bio-ext/dateOfBirth> ?birth.
?pers <http://dati.cdec.it/lod/shoah/convoy> ?convoy.
OPTIONAL {?person <http://xmlns.com/foaf/0.1/gender> ?gender.}
FILTER(REGEX(?birth ,'^194','i') ||REGEX(?birth ,'^193','i'))
}ORDER BY ?convoy
[esegui query] – Luoghi e date di partenza dei convogli e numero dei deportati per località di arresto
select distinct ?labelConvoy ?labelDeparPlace ?deparDate ?ArrestPlace (count(?ArrestPlace) as ?count) ?labelCamp
FROM <http://dati.cdec.it/lod/shoah/> where
{?convoy a <http://dati.cdec.it/lod/shoah/Convoy>;
rdfs:label ?labelConvoy;
<http://dati.cdec.it/lod/shoah/departureDate> ?deparDate;
<http://dati.cdec.it/lod/shoah/convoyDeparturePlace> ?deparPlace;
<http://dati.cdec.it/lod/shoah/toNaziCamp> ?naziCamp.
?naziCamp rdfs:label ?labelCamp.
?deparPlace rdfs:label ?labelDeparPlace.
?person <http://dati.cdec.it/lod/shoah/persecution> ?pers.
?pers <http://dati.cdec.it/lod/shoah/arrestPlace> ?arr. ?arr rdfs:label ?ArrestPlace.
?pers <http://dati.cdec.it/lod/shoah/convoy> ?convoy.
}ORDER BY ?convoy ORDER BY ?labelDeparPlace
[esegui query] – Numero complessivo dei deportati selezionati all'arrivo in campo
select distinct count(?serial) from <http://dati.cdec.it/lod/shoah/> where {?s a <http://xmlns.com/foaf/0.1/Person>;
<http://dati.cdec.it/lod/shoah/persecution> ?persecution.
?persecution <http://dati.cdec.it/lod/shoah/campSerialNumber> ?serial.
FILTER (?serial= 'S')
}
[esegui query] – Elenco degli ebrei deportati come oppositori politici
select distinct ?s ?label from <http://dati.cdec.it/lod/shoah/> where {?s a <http://xmlns.com/foaf/0.1/Person>; rdfs:label ?label;
<http://dati.cdec.it/lod/shoah/persecution> ?persecution.
?persecution <http://dati.cdec.it/lod/shoah/convoyNumber> ?convoy.
FILTER (?convoy='P')
} order by ?label
[esegui query] – Numero degli ebrei morti in Italia e in campo di sterminio
select distinct ?descr (count(?descr) as ?tipomorte) from <http://dati.cdec.it/lod/shoah/> where {?s a <http://xmlns.com/foaf/0.1/Person>;
<http://dati.cdec.it/lod/shoah/persecution> ?persecution.
?persecution <http://dati.cdec.it/lod/shoah/deathDescription> ?descr.
} order by ?tipomorte
dati.cdec.it
