pyzmark

tags	language	difficulty	topic
activities artists under construction	sparql	intermediate	auction-events

This query returns auction events and the artists involved in them. By including URIs for particular artists, you can use it to filter for only those artists.

Introduction

In 0001, users were shown how to proceed from events to artists (among other things). In theory, one could reverse this query to do the opposite. But this is not the recommended path, especially if we do not wish to reconstruct the results of particular auction_events. This is a simple query, moving from artist to sale_activity (and sale_sub_activity, as the user will see).

pyzmark

tags	language	difficulty	topic
locations events auctions under construction	sparql	intermediate	auction-data

This query accepts a place URI and returns events that took place there. The goal is both to do something that Arches currently cannot, and also to provide users with some guidance about how events relate to locations in the data model.

Introduction

pyzmark

tags	language	difficulty	topic
events sets lots auctions under construction	sparql	intermediate	auction-events

This query helps the user navigate the Provenance model from auction events to lots. This is trickier than you might think, and requires some backwards and forward querying.

Introduction

The challenge of getting from an auction-event to a lot is several-fold.

pyzmark

tags	language	difficulty	topic
paintings Rembrandt events prices dates statistics under construction	sparql	intermediate	rembrandt-average

This query provides some basic statistics, including average prices, of paintings by the artist Rembrandt van Rijn (i.e., Rembrandt).

Introduction

Query

pyzmark

tags	language	difficulty	topic
famous sales lots events auctions paintings famous painters	sparql	intermediate	auction-data

The so-called Orléans Sale is a major touchstone in European provenance studies. This query drills down on the auction-event, getting to individual paintings and then providing information on their trajectories (chains of ownership) going forward.

Related entries: Getting from auction events to individual lots (0003).