logoPandorLabs
Sign inGet my data
Art Collections

Bonhams lots

Bonhams auction data: every upcoming and past lot (with Skinner and Cornette de Saint Cyr), with artist, medium, dimensions, signature, provenance, literature, exhibitions, estimates, hammer and premium prices and full-resolution images.

bonhams-lotsartauctionsbonhamslotspricesprovenance

35,200 rows in the dataset · last run Oct 27, 2026

Prefer a file without code? Buy the Bonhams lots dataset or get a free 100-row sample.

Download the dataset

Get the full dataset as one CSV or JSONL file. If the data is older than maxAgeHours, it is refreshed automatically first. The key needs the datasets:export scope.

DOWNLOAD_ID=$(curl -s -X POST "https://api.pandorlabs.com/v1/datasets/bonhams-lots/downloads" \  -H "Authorization: Bearer $PANDORLABS_KEY" \  -H "Content-Type: application/json" \  -d '{"maxAgeHours":24,"format":"csv"}' | jq -r '.id')while true; do  STATUS=$(curl -s "https://api.pandorlabs.com/v1/downloads/$DOWNLOAD_ID" \    -H "Authorization: Bearer $PANDORLABS_KEY" | jq -r '.status')  [ "$STATUS" != "refreshing" ] && break  sleep 5donecurl -s "https://api.pandorlabs.com/v1/downloads/$DOWNLOAD_ID/file" \  -H "Authorization: Bearer $PANDORLABS_KEY" \  -o dataset.csv

At its current 35,200 rows, this download costs $21.12, down to $5.28 in volume (352 credits) when the data is fresh enough, or $42.24, down to $10.56 in volume (704 credits) when it has to be refreshed first.

This is a Standard dataset: 1 credit per 100 rows cached and 2 credits live, charged on the rows in the dataset when the download becomes ready. A failed refresh is not charged. The file stays downloadable for 24 hours. See pricing.

Start a run

To get exactly the targets you want, send the parameters below as input. The call returns 202 with the run; the key needs the scrapers:run scope and the account a positive credit balance.

curl -X POST "https://api.pandorlabs.com/v1/scrapers/bonhams-lots/runs" \  -H "Authorization: Bearer $PANDORLABS_KEY" \  -H "Content-Type: application/json" \  -d '{    "input": {      "maxLots": 0,      "maxSales": 0,      "includePast": true,      "includeUpcoming": true    }  }'

A run is billed at the live rate once it finishes: 2 credits per 100 rows it collected ($1.2, down to $0.3 in volume per 1,000 rows). A run that collects nothing costs nothing.

Parameters

Every parameter is optional. Anything you leave out uses the default shown here; an unknown name or an invalid value is rejected with a 400 that lists each problem.

Limits

  • maxLots

    number

    Max lots

    0 means no limit.

    Default
    0
    Range
    at least 0
  • maxSales

    number

    Max sales / auctions

    0 means no limit.

    Default
    0
    Range
    at least 0

Targeting

  • includePast

    boolean

    Include past (results) sales

    Default
    true
  • includeUpcoming

    boolean

    Include upcoming / live sales

    Default
    true
  • fetchLotDetails

    boolean

    Include full lot details

    Adds provenance, literature, condition and the full image set. Turning this off is faster but returns fewer fields.

    Default
    true
  • brands

    string[]

    Brands

    Bonhams group brands to include: bonhams, skinner, cornette, bonhams-cars, bruun_rasmussen, bukowskis.

    Default
    ["bonhams","skinner","cornette"]
  • departments

    string[]

    Department code prefixes

    Only keep lots whose department code starts with one of these (PIC = pictures). Empty keeps every lot.

    Default
    none
    Example
    PIC, CON
  • auctionIds

    string[]

    Auction ids

    Collect only these auctions instead of the upcoming and past sales.

    Default
    none
    Example
    32588

Pacing

  • requestDelayMs

    number

    Delay between requests (ms)

    Default
    750
    Range
    0 to 60000
Input as JSON Schema

The same schema the API validates against. Use it as a tool input schema or to generate a typed client.

inputSchema
{  "type": "object",  "additionalProperties": false,  "properties": {    "maxLots": {      "type": "number",      "minimum": 0,      "title": "Max lots",      "description": "0 means no limit.",      "default": 0    },    "maxSales": {      "type": "number",      "minimum": 0,      "title": "Max sales / auctions",      "description": "0 means no limit.",      "default": 0    },    "includePast": {      "type": "boolean",      "title": "Include past (results) sales",      "default": true    },    "includeUpcoming": {      "type": "boolean",      "title": "Include upcoming / live sales",      "default": true    },    "fetchLotDetails": {      "type": "boolean",      "title": "Include full lot details",      "description": "Adds provenance, literature, condition and the full image set. Turning this off is faster but returns fewer fields.",      "default": true    },    "requestDelayMs": {      "type": "number",      "minimum": 0,      "maximum": 60000,      "title": "Delay between requests (ms)",      "default": 750    },    "brands": {      "type": "array",      "items": {        "type": "string"      },      "maxItems": 1000,      "title": "Brands",      "description": "Bonhams group brands to include: bonhams, skinner, cornette, bonhams-cars, bruun_rasmussen, bukowskis.",      "default": [        "bonhams",        "skinner",        "cornette"      ]    },    "departments": {      "type": "array",      "items": {        "type": "string"      },      "maxItems": 1000,      "title": "Department code prefixes",      "description": "Only keep lots whose department code starts with one of these (PIC = pictures). Empty keeps every lot.",      "examples": [        "PIC, CON"      ]    },    "auctionIds": {      "type": "array",      "items": {        "type": "string"      },      "maxItems": 1000,      "title": "Auction ids",      "description": "Collect only these auctions instead of the upcoming and past sales.",      "examples": [        "32588"      ]    }  }}

Run, poll, read rows

The run is asynchronous. Poll it until it reaches a terminal status and its billing is paid, then page through its rows. Until then the rows endpoint answers 409 (still queued or running) or 402 (payment required).

RUN_ID=$(curl -s -X POST "https://api.pandorlabs.com/v1/scrapers/bonhams-lots/runs" \  -H "Authorization: Bearer $PANDORLABS_KEY" \  -H "Content-Type: application/json" \  -d '{    "input": {      "maxLots": 0,      "maxSales": 0,      "includePast": true,      "includeUpcoming": true    }  }' | jq -r '.id')while true; do  RUN=$(curl -s "https://api.pandorlabs.com/v1/runs/$RUN_ID" \    -H "Authorization: Bearer $PANDORLABS_KEY")  STATUS=$(echo "$RUN" | jq -r '.status')  BILLING=$(echo "$RUN" | jq -r '.billing.status')  case "$STATUS" in queued|running) ;; *) [ "$BILLING" != "pending" ] && break ;; esac  sleep 5doneecho "$RUN" | jq '{status, rowCount, billing}'curl -s "https://api.pandorlabs.com/v1/runs/$RUN_ID/rows?page=1&limit=100" \  -H "Authorization: Bearer $PANDORLABS_KEY"

See the API reference for pagination, cancelling and listing runs.

Output fields

The fields this scraper delivers. Coverage is the share of rows that include each field.

FieldTypeCoverage
artist_birth_yearnumber28%
artist_death_yearnumber23%
artist_namestring28%
artist_nationalitystring8%
auction_housestring100%
condition_reportstring1%
creation_date_textstring28%
creation_yearnumber28%
currencystring100%
depth_cmnumber6%
descriptionstring100%
diameter_cmnumber4%
dimensions_textstring81%
editionstring6%
estimate_highnumber99%
estimate_lownumber99%
exhibition_historystring3%
extraobject100%
hammer_pricenumber60%
height_cmnumber69%
image_urlstring100%
imagesarray100%
inscriptionstring7%
last_sold_currencystring60%
last_sold_pricenumber60%
literaturestring7%
lot_keystring100%
lot_numberstring100%
mediumstring32%
object_categorystring100%
premium_pricenumber60%
provenancestring27%
sale_idstring100%
sale_locationstring100%
sale_numberstring100%
sale_statusstring100%
sale_titlestring100%
sale_typestring100%
signaturestring38%
sold_pricenumber60%
source_lot_idstring100%
titlestring100%
width_cmnumber44%
created_atdate100%
first_seen_atdate100%
last_seen_atdate100%
last_sold_atdate60%
sale_end_atdate100%
sale_start_atdate100%
sold_atdate60%
updated_atdate100%
_idstring100%