Some helpful queries for researchers concerned by Nazi-looted art
Wikidata
100 or so short links to Wikidata queries designed to facilitate the research into Nazi looted art (Google Sheets)
https://docs.google.com/spreadsheets/d/e/2PACX-1vRAwUD3eHud0-xLcw38MQGcEzB5y77NpPMy0IKy7Ww2EtUrHrLC96I6-op2nQms5dz8zPDVVWnp4LNf/pubhtml?gid=0&single=trueAdditional Wikidata queries
Holocaust victim, art looting Red Flag name, Nazi party member, or persecuted person?
Table of contextual information about Art Market People
All Wikidata Items that link to Amedeo Modigliani
Getty Museum Sparql endpoint
https://data.getty.edu/museum/collection/sparql-ui#
Sparql Query to get items that changed hands with filter on word or name
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX crm: <http://www.cidoc-crm.org/cidoc-crm/>
PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
PREFIX la: <https://linked.art/ns/terms/>
PREFIX aat: <http://vocab.getty.edu/aat/>
PREFIX getty: <http://data.getty.edu/local/>
SELECT ?humanMadeObject ?humanMadeObjectLabel ?objLabel WHERE {
?humanMadeObject rdf:type crm:E22_Human-Made_Object;
crm:P24i_changed_ownership_through ?obj.
?obj rdfs:label ?objLabel .
?humanMadeObject rdfs:label ?humanMadeObjectLabel
# Filtering on crm:P24i_changed_ownership_through that contains "Speelman"
FILTER (CONTAINS(?objLabel, "Speelman"))
Sparql query to retrieve "Groups" with their Slug identifier
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX crm: <http://www.cidoc-crm.org/cidoc-crm/>
PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
PREFIX la: <https://linked.art/ns/terms/>
PREFIX aat: <http://vocab.getty.edu/aat/>
PREFIX getty: <http://data.getty.edu/local/>
SELECT ?group ?groupLabel ?slug WHERE {
?group rdf:type crm:E74_Group.
?group rdfs:label ?groupLabel.
?group crm:P129i_is_subject_of ?slug.
# FILTER (?IDLabel = "Slug Identifier")
}
LIMIT 500
****
The Getty data structure can be complex. This query shows the uris and their label for a single item, which can be helpful in designing queries.
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX crm: <http://www.cidoc-crm.org/cidoc-crm/>
SELECT ?property ?value ?valueLabel WHERE {
<https://data.getty.edu/museum/collection/object/04b051a9-92fa-4bea-95cd-b8657f319c39> ?property ?value.
?value rdfs:label ?valueLabel.
}
***
Acquisition: names associated with the acquisition of an item
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX crm: <http://www.cidoc-crm.org/cidoc-crm/>
SELECT ?acquisition ?acquisitionLabel?property ?value ?valueLabel WHERE {
?acquisition rdf:type crm:E8_Acquisition.
?acquisition ?property ?value.
?object ?rel ?acquisition.
?acquisition rdfs:label ?acquisitionLabel.
?value rdfs:label ?valueLabel.
FILTER (?object = <https://data.getty.edu/museum/collection/object/04b051a9-92fa-4bea-95cd-b8657f319c39>)
}
***
Nested query getting the artist for a object after a search on an acquisition name
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX crm: <http://www.cidoc-crm.org/cidoc-crm/>
PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
PREFIX la: <https://linked.art/ns/terms/>
PREFIX aat: <http://vocab.getty.edu/aat/>
PREFIX getty: <http://data.getty.edu/local/>
SELECT ?humanMadeObject ?humanMadeObjectLabel ?creatorName WHERE {
{
SELECT ?humanMadeObject ?humanMadeObjectLabel WHERE {
?humanMadeObject rdf:type crm:E22_Human-Made_Object;
crm:P24i_changed_ownership_through ?obj.
?obj rdfs:label ?objLabel .
?humanMadeObject rdfs:label ?humanMadeObjectLabel
FILTER (CONTAINS(?objLabel, "Flechtheim"))
} LIMIT 100
}
OPTIONAL {
?humanMadeObject crm:P108i_was_produced_by ?creationEvent .
?creationEvent crm:P14_carried_out_by ?creator .
?creator rdfs:label ?creatorName .
}
}
***
Nested query which first filters for objects and then retrieves the names associated with the acquisition of those objects
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX crm: <http://www.cidoc-crm.org/cidoc-crm/>
SELECT ?humanMadeObject ?humanMadeObjectLabel ?acquisition ?acquisitionLabel ?property ?value ?valueLabel WHERE {
{
SELECT ?humanMadeObject ?humanMadeObjectLabel WHERE {
?humanMadeObject rdf:type crm:E22_Human-Made_Object;
crm:P24i_changed_ownership_through ?obj.
?obj rdfs:label ?objLabel .
?humanMadeObject rdfs:label ?humanMadeObjectLabel
FILTER (CONTAINS(?objLabel, "Flechtheim"))
} LIMIT 100
}
?acquisition rdf:type crm:E8_Acquisition.
?acquisition ?property ?value.
?humanMadeObject ?rel ?acquisition.
?acquisition rdfs:label ?acquisitionLabel.
OPTIONAL { ?value rdfs:label ?valueLabel. }
}
No comments:
Post a Comment