state_query
Query any state's Socrata open data by its 4-character dataset ID. Use SoQL $select, $where, $order, $group, $q to filter and shape results.
Instructions
Query any state's Socrata open data dataset by its 4-character ID. Works for ANY state in the registry, even without category mappings. Find dataset IDs by browsing the state's portal (e.g., data.ny.gov, opendata.maryland.gov). Supports full SoQL: $select, $where, $order, $group, $q (full-text), $limit, $offset.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| q | No | Full-text search | |
| group | No | SoQL $group: group-by clause | |
| limit | No | Max results (default 100) | |
| order | No | SoQL $order: sort clause | |
| state | Yes | Two-letter state code | |
| where | No | SoQL $where: filter condition | |
| offset | No | Offset for pagination | |
| select | No | SoQL $select: columns to return | |
| dataset_id | Yes | Socrata 4-character dataset ID, e.g. 'jwfa-fdxs' |