Phillips auction lots
Phillips auction data: every lot across modern and contemporary art, design, photographs, editions, watches and jewels, with catalogue details, provenance, literature, exhibitions, condition reports, images, estimates and realised prices.
2,166 rows in the dataset · last run Nov 1, 2026
Prefer a file without code? Buy the Phillips auction 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/phillips-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.csvAt its current 2,166 rows, this download costs $1.32, down to $0.33 in volume (22 credits) when the data is fresh enough, or $2.64, down to $0.66 in volume (44 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/phillips-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
maxLotsnumber
Max lots
0 means no limit.
- Default
0- Range
- at least 0
maxSalesnumber
Max sales / auctions
0 means no limit.
- Default
0- Range
- at least 0
Targeting
includePastboolean
Include past (results) sales
- Default
true
includeUpcomingboolean
Include upcoming / live sales
- Default
true
fetchLotDetailsboolean
Include full lot details
Adds provenance, literature, condition and the full image set. Turning this off is faster but returns fewer fields.
- Default
true
auctionCodesstring[]
Auction codes
Collect only these sales instead of the upcoming and past sales.
- Default
- none
- Example
NY010125, UK011026
Pacing
requestDelayMsnumber
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.
{ "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 }, "auctionCodes": { "type": "array", "items": { "type": "string" }, "maxItems": 1000, "title": "Auction codes", "description": "Collect only these sales instead of the upcoming and past sales.", "examples": [ "NY010125, UK011026" ] } }}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/phillips-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.
| Field | Type | Coverage |
|---|---|---|
| artist_birth_year | number | 32% |
| artist_death_year | number | 4% |
| artist_id | string | 93% |
| artist_name | string | 93% |
| artist_nationality | string | 47% |
| auction_house | string | 100% |
| condition_report | string | 82% |
| creation_date_text | string | 85% |
| creation_year | number | 85% |
| currency | string | 100% |
| depth_cm | number | 10% |
| description | string | 33% |
| diameter_cm | number | 24% |
| dimensions_text | string | 85% |
| edition | string | 20% |
| estimate_high | number | 99% |
| estimate_low | number | 99% |
| exhibition_history | string | 16% |
| extra | object | 100% |
| hammer_price | number | 24% |
| height_cm | number | 61% |
| image_url | string | 100% |
| images | array | 100% |
| inscription | string | 85% |
| last_sold_currency | string | 24% |
| last_sold_price | number | 24% |
| literature | string | 26% |
| lot_key | string | 100% |
| lot_number | string | 100% |
| medium | string | 62% |
| object_category | string | 100% |
| premium_price | number | 24% |
| price_history | array | 100% |
| provenance | string | 48% |
| sale_id | string | 100% |
| sale_location | string | 100% |
| sale_number | string | 100% |
| sale_status | string | 100% |
| sale_title | string | 100% |
| sale_type | string | 100% |
| signature | string | 23% |
| sold_price | number | 24% |
| source_lot_id | string | 100% |
| title | string | 99% |
| width_cm | number | 52% |
| created_at | date | 100% |
| first_seen_at | date | 100% |
| last_seen_at | date | 100% |
| last_sold_at | date | 24% |
| sale_end_at | date | 58% |
| sale_start_at | date | 100% |
| sold_at | date | 24% |
| updated_at | date | 100% |
| _id | string | 100% |