Submissions for Semantic Census
Description
The Semantic Census is an open, linked-data version of the Census of Antique Works of Art and Architecture Known in the Renaissance, a research collection built up since 1946. It records which ancient artworks were known in the Renaissance, linking each one to the drawings, prints, texts and sculptures that show knowledge of it, along with the artists, places, dates and bibliography involved. Between 2021 and 2023 the database was remodelled using the CIDOC-CRM standard so the data can be reused and queried beyond its original purpose. It is freely downloadable from Zenodo and Humboldt-Universität's eDoc server. Publication: https://doi.org/10.19282/ac.36.2.2025.05
1 of 1 submissions
#339
Natural Language Question
How many sculptures from the Hellenistic period does this knowledge graph contain?
SPARQL Query
PREFIX crm: <http://www.cidoc-crm.org/cidoc-crm/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
SELECT ?typeLabel (COUNT(DISTINCT ?object) AS ?count)
WHERE {
?period a crm:E4_Period ;
rdfs:label "Hellenistic" ;
crm:P4_has_time-span [ crm:P82a_begin_of_the_begin ?periodBegin ;
crm:P82b_end_of_the_end ?periodEnd ] .
BIND(xsd:integer(REPLACE(STR(?periodBegin), "^(-?[0-9]+)-.*$", "$1")) AS ?periodStart)
BIND(xsd:integer(REPLACE(STR(?periodEnd), "^(-?[0-9]+)-.*$", "$1")) AS ?periodEndYear)
?object a crm:E22_Human-Made_Object ;
crm:P2_has_type [ rdfs:label ?typeLabel ] ;
crm:P108i_was_produced_by [ crm:P4_has_time-span [ crm:P82a_begin_of_the_begin ?begin ] ] .
BIND(xsd:integer(REPLACE(STR(?begin), "^(-?[0-9]+)-.*$", "$1")) AS ?year)
FILTER(?year >= ?periodStart && ?year <= ?periodEndYear)
FILTER(LCASE(?typeLabel) = "sculpture" || LCASE(?typeLabel) = "statue"
|| LCASE(?typeLabel) = "bust" || LCASE(?typeLabel) = "relief")
}
GROUP BY ?typeLabel
ORDER BY DESC(?count)
