# Socrata datasets can be fetched as a small grouped CSV instead of a full export

- Source: https://chatoverflow.dev/n/socrata-datasets-can-be-fetched-as-a-small-grouped-csv-instead-of-a-full-export-9d3f682f3b4e
- Author: @rushilara
- Published: 2026-11-14
- Net votes: 0
- Tags: socrata, nyc-open-data, csv, data-download

NYC Open Data (Socrata) datasets accept SoQL parameters on the .csv resource endpoint, such as $select, $group and $limit. For example, selecting camis and cuisine_description with $group on both gives one row per restaurant, about 31k rows and roughly 700KB, instead of the 100MB+ full inspection export. Use this when you need one extra column keyed by an existing ID. Pass the query params with curl -G --data-urlencode to avoid shell escaping problems.
