Download as SQLite
A signed link (valid 15 minutes) to the gzipped SQLite file: tables `items and observations, view latest`. Open it with sqlite3, DuckDB, pandas or Datasette.
Request
https://api.scrapercompany.com/v1/datasets/{name}/downloadAuthenticate with your API key in the x-api-key header (see Authentication).
Run this request on your own API key from this page, with the values you type. Signed out? Sign in or get an API key.
Parameters
- namestringpathrequired
- daystring (date) | null
A past day's file, while kept: the newest 7 days and the first of each of the last 12 months. Omit for the latest, which holds the whole history.
Example request
curl "https://api.scrapercompany.com/v1/datasets/llm-prices/download" \
-H "x-api-key: $SCRAPERCOMPANY_API_KEY"Response
200 — A signed link to the SQLite file. Metered responses carry x-credits-charged and x-credits-remaining headers (see credit headers).
{
"dataset": "llm-prices",
"day": "latest",
"url": "https://storage.example.com/example-bucket/datasets/llm-prices/latest.sqlite.gz?X-Amz-Signature=...",
"expires_in_seconds": 900,
"format": "sqlite.gz"
}Errors
Errors return a JSON body with a detail field. Failed requests are not charged. See Errors for the full list and retry advice.
| Status | Meaning | Retry? |
|---|---|---|
401Unauthorized | Missing or invalid API key. {"detail":"missing or invalid API key"} | No, fix the request |
402Payment Required | Not enough credits for this request: the account's credits mode is {"detail":"insufficient credits: this request costs 5, 0 available. Credits renew 2026-11-01."} | No, fix the request |
404Not Found | The property, stay, job or record was not found. {"detail":"job not found"} | No, fix the request |
422Unprocessable Content | Request validation failed. {"detail":[{"loc":["body","token"],"msg":"Field required","type":"missing"}]} | No, fix the request |
429Too Many Requests | Too many requests: the key's requests-per-minute limit was exceeded, or (in {"detail":"rate limit 60/min exceeded"} | Yes, with backoff |
503Service Unavailable | Temporarily unavailable: a dependency of this endpoint is down, or the upstream source changed its contract. Retry later. {"detail":"database unavailable: OperationalError"} | Yes, with backoff |
Try it
Press Try it above to run this request on your own key, with the values you type (sign in first). For a no-code walkthrough, use the workspace’s guided Try it.
- Export your key:
export SCRAPERCOMPANY_API_KEY=sk_...(no key yet? start a free trial). - Copy the cURL example above and run it in a terminal.
Questions about this page?
Send the page link and your question, and the team will answer.