Submissions for EHRI - KG
Description
The EHRI Knowledge Graph (EHRI-KG) is a Linked Open Data (LOD) representation of the EHRI Portal’s metadata about Holocaust-related archival sources. Developed to complement the EHRI Portal, it transforms archival descriptions—such as countries, institutions, collection records, and more—into a semantically enriched, interlinked graph.
2 of 2 submissions
#29
Natural Language Question
What is the average number of archival documents per institution by country of provenance?
Source
SPARQL Query
PREFIX db: <http://dbpedia.org/>
PREFIX dbp: <http://dbpedia.org/property/>
PREFIX rico: <https://www.ica.org/standards/RiC/ontology#>
PREFIX dbo: <http://dbpedia.org/ontology/>
PREFIX owl: <http://www.w3.org/2002/07/owl#>
PREFIX schema: <http://schema.org/>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX ehri: <http://lod.ehri-project-test.eu/>
PREFIX ehri_institutions: <http://lod.ehri-project-test.eu/institutions/>
PREFIX ehri_units: <http://lod.ehri-project-test.eu/units/>
PREFIX ehri_countries: <http://lod.ehri-project-test.eu/countries/>
SELECT ?country (AVG(?totalRecordByInstitution) as ?meanByCountry) WHERE {
?country a rico:Place ;
rico:containsOrContained ?institution .
{
SELECT ?institution (COUNT(?record) as ?totalRecordByInstitution) WHERE {
?institution a rico:CorporateBody ;
rico:isOrWasHolderOf ?instantiation .
?instantiation a rico:Instantiation ;
rico:isInstantiationOf ?record .
?record a rico:Record .
} GROUP BY ?institution
}
} GROUP BY ?country
#30
Natural Language Question
What is the total number of archival records per institution for heritage institutions in Great Britain?
Source
SPARQL Query
PREFIX db: <http://dbpedia.org/>
PREFIX dbp: <http://dbpedia.org/property/>
PREFIX rico: <https://www.ica.org/standards/RiC/ontology#>
PREFIX dbo: <http://dbpedia.org/ontology/>
PREFIX owl: <http://www.w3.org/2002/07/owl#>
PREFIX schema: <http://schema.org/>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX ehri: <http://lod.ehri-project-test.eu/ontology#>
PREFIX ehri_institutions: <http://lod.ehri-project-test.eu/institutions/>
PREFIX ehri_units: <http://lod.ehri-project-test.eu/units/>
PREFIX ehri_countries: <http://lod.ehri-project-test.eu/countries/>
SELECT ?institution (COUNT(?record) as ?totalRecords) WHERE {
ehri_countries:gb a ehri:Country ;
rico:isOrWasLocationOfAgent ?institution .
?record a ehri:Record ;
rico:title ?recordLabel ;
rico:hasOrHadHolder ?institution ;
} GROUP BY ?institution ORDER BY DESC(?totalRecords)
