Socrata Open Data: Socrata Query Dataset

Query a government open-data dataset by portal domain and dataset ID, with SQL-like filters, grouping and sorting.

Tool ID: socrata_query_dataset

Run this action

This action has conditional or dynamic inputs. A static example cannot describe these inputs reliably. Read the live contract before you execute this action:

deepline describe socrata_query_dataset --json

Example response

The static output schema lacks the details for a reliable example. Use deepline describe socrata_query_dataset --json for the complete live contract.

Input reference

Run a SoQL query against a Socrata dataset

Name	Type	Required	Default	Details
`payload.datasetId`	`string`	Yes	—	Pattern: `^[a-z0-9]{4}-[a-z0-9]{4}$`.
`payload.domain`	`string`	Yes	—	Socrata host for this dataset, e.g. `data.cityofnewyork.us`. Routed at runtime. Not sent upstream as a query parameter.
`payload.$select`	`string`	No	—	SoQL SELECT clause, e.g. `borough,issuance_date` or `count(*)`.
`payload.$where`	`string`	No	—	SoQL WHERE clause, e.g. `borough='BRONX' AND issuance_date > '2026-01-01'`.
`payload.$order`	`string`	No	—	SoQL ORDER BY clause. Defaults to `:id` when omitted, because Socrata does not guarantee stable row order across pages without one. paging an unordered query silently duplicates and skips rows.
`payload.$group`	`string`	No	—	—
`payload.$having`	`string`	No	—	—
`payload.$q`	`string`	No	—	Full-text search across the dataset.
`payload.$limit`	`integer`	No	`1000`	Rows per request, capped at 50000. Socrata itself accepts arbitrarily large values and will stream hundreds of megabytes in a single 200 response, so this cap is enforced client-side. Minimum: 1. Maximum: 50000.
`payload.$offset`	`integer`	No	`0`	Minimum: 0.

Output reference

Standard tool result payload.

Name	Type	Required	Default	Details
`result.data`	`array`	Yes	—	Provider response payload.
`result.meta`	`object`	No	—	Additional response metadata (status, paging).

Deepline cost

Pricing model: fixed (per call).
Estimated Deepline credits: 0 per pricing unit.
Provider-native pricing may still exist outside Deepline credit billing.

​Run this action

​Example response

​Input reference

​Output reference

​Deepline cost

​Related documentation

Run this action

Example response

Input reference

Output reference

Deepline cost

Related documentation