query_dataset
Query real data from a dataset. Check instructions for featured dataset_ids and NOTES section for common filter patterns (municipal budgets, contracts, weather, energy, fuel prices).
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | Number of rows to return. Min 1, max 100. Default 20. Use offset for pagination. | |
| offset | No | Number of rows to skip for pagination. Default 0. Combine with limit to navigate large results. | |
| search | No | Free text search within dataset data. Works with Socrata ($q) and CKAN (q). For Diba and CIDO, use specific filters. | |
| filters | No | Key-value filters where the key is the field name and the value is the filter value. Examples: {"municipi": "Barcelona"}, {"any": "2024"}, {"NOM_ENS": "Ajuntament de Tiana"}. Use list_dataset_fields to know valid field names. | |
| dataset_id | Yes | Unique dataset identifier in 'portal:id' format. Obtained from search_datasets results. |