Public Finance & Government
Fetch a single row by `:id`
Single row fetch from /resource/{dataset_id}.json?:id={row_id}. Uses the Socrata :id system column, which is present on every dataset. For datasets that expose a natural primary key (e.g. unique_key on NYC 311), query via the /rows/{dataset_id} endpoint with a $where filter instead.
get/api/v1/socrata/{portal}/row/{dataset_id}/{row_id}
Path parameters
portalstring required
Portal slug (e.g. nyc).
Portal slug (e.g. nyc).
dataset_idstring required
Socrata 4-4 hex dataset identifier.
Socrata 4-4 hex dataset identifier.
row_idstring required
Row identifier from the upstream :id system column.
Row identifier from the upstream :id system column.
Response
Single row keyed by SoQL field names.
Example response
{
"data": {
"portal": "nyc",
"domain": "data.cityofnewyork.us",
"dataset_id": "erm2-nwe9"
},
"meta": {
"endpoint": "/api/v1/fred/us/cpi",
"data_time": "2026-04-16T14:30:00Z",
"response_time": "2026-04-16T14:30:12Z",
"provider": "Sugra API v1.0.1",
"source": "sugra_crypto",
"attribution": "Short interest and Reg SHO daily short volume data is owned by and sourced from FINRA (Financial Industry Regulatory Authority).",
"fallback_chain": [
"sugra_crypto",
"sugra_finance"
]
}
}