Datasets API endpoint
Returns value counts for the PitchBook investors dataset by the required `facet`: `status`, `investor_type`, `hq_country`, `hq_state` or `run_id`. The counts follow search filters including `q`, `min_portfolio_count` and `min_exits_count`, and show the top 50 values.
/datasets/pitchbook-investors/facetsReturns terms-aggregation counts for one field over the PitchBook investors dataset, honoring the same filters as search.
Query parameters:
facet (required) — one of status, investor_type, hq_country, hq_state, run_id.q, status, investor_type, hq_country, hq_state, run_id, min_portfolio_count, min_exits_count) apply.Returns {dataset, facet, items:[{value, count}]} (top 50 buckets).
| Field | Filled in, of 31 checked | Values in the sample |
|---|---|---|
| value | 31 | |
| count | 31 | 2 to 43,113, median 189 |
| Parameter | Type | Required | Default | Description | Example |
|---|---|---|---|---|---|
| facet | string | Yes | Facet enum: status, investor_type, hq_country, hq_state, run_id Allowed values: status, investor_type, hq_country, hq_state, run_id. | status | |
| q | string | No | Full-text query over name and description, max 256 characters | ||
| status | string | No | Exact status filter, max 128 characters | ||
| investor_type | string | No | Exact investor type filter, max 128 characters | ||
| hq_country | string | No | Exact headquarters country filter, max 128 characters | ||
| hq_state | string | No | Exact headquarters state/region filter, max 128 characters | ||
| run_id | string | No | Exact crawl run-id filter, max 128 characters | ||
| min_portfolio_count | integer | No | Minimum current portfolio size | ||
| min_exits_count | integer | No | Minimum number of exits | ||
| x-api-key (header) | string | Yes | API key required |
curl -X GET "https://api.crawlora.net/api/v1/datasets/pitchbook-investors/facets?facet=status&q=coffee" \ -H "x-api-key: $CRAWLORA_API_KEY"
{
"code": 200,
"msg": "OK",
"data": {
"dataset": "pitchbook-investors",
"facet": "investor_type",
"items": [
{
"value": "Venture Capital",
"count": 5124
},
{
"value": "Private Equity",
"count": 1893
}
]
}
}Request schema
No body schema
Response schema
#/definitions/datasets.pitchbookInvestorsFacetResponseDoc
| Field | Type | Required | Enum | Bounds | Example | Description |
|---|---|---|---|---|---|---|
| code | integer | No | 200 | |||
| data | datasets.PitchbookInvestorsFacetResponse | No | ||||
| data.dataset | string | No | Identifier of the dataset queried (`pitchbook-investors`). | |||
| data.facet | string | No | Facet that was aggregated. | |||
| data.items | array | No | Facet values with the number of matching records for each. | |||
| data.items[].count | integer | No | Number of records with this value. | |||
| data.items[].value | string | No | Facet value being counted. | |||
| msg | string | No | OK |
| Status | Description | Schema |
|---|---|---|
| 400 | Bad Request | #/definitions/app.Response |
| 429 | Too Many Requests | #/definitions/app.Response |
| 500 | Internal Server Error | #/definitions/app.Response |
Use environment variables for secrets and keep Crawlora API keys server-side.
curl -X GET "https://api.crawlora.net/api/v1/datasets/pitchbook-investors/facets?facet=status&q=coffee" \
-H "x-api-key: $CRAWLORA_API_KEY"