Portal de Dados Abertos da Cidade de São Paulo
Open data portalsBRdados.prefeitura.sp.gov.br
São Paulo's municipal open data portal (Brazil).
Capabilities (15)
GET /v1/data/dados-prefeitura-sp-gov-br/dataset1 creditFull metadata for one dataset: title, notes, licence, organization, tags, extras and the complete resource list with download URLs and formats.
GET /v1/data/dados-prefeitura-sp-gov-br/dataset-names1 creditFlat JSON array of every dataset slug on the portal, in alphabetical order.
GET /v1/data/dados-prefeitura-sp-gov-br/datasets1 creditSolr-backed search over every dataset published on the Latvian open data portal; returns a page of 20 full dataset records plus the total match count and facets.
GET /v1/data/dados-prefeitura-sp-gov-br/dataset-suggest1 creditLightweight typeahead: matching datasets as {name, title, match_field} objects, no resources or descriptions.
GET /v1/data/dados-prefeitura-sp-gov-br/group1 creditMetadata for one thematic group: title, description, image and dataset count.
GET /v1/data/dados-prefeitura-sp-gov-br/group-datasets1 creditA page of up to 20 full dataset records belonging to one thematic group, with the group's total count.
GET /v1/data/dados-prefeitura-sp-gov-br/groups1 creditEvery thematic group (subject category) on the portal with its name, display title, description and dataset count.
GET /v1/data/dados-prefeitura-sp-gov-br/licenses1 creditEvery licence the portal offers publishers, as {id, title, url, od_conformance, osd_conformance} objects.
GET /v1/data/dados-prefeitura-sp-gov-br/organization1 creditMetadata for one publishing organization: title, description, contact extras, dataset count and (optionally) its datasets.
GET /v1/data/dados-prefeitura-sp-gov-br/organization-datasets1 creditA page of up to 20 full dataset records published by one organization, with the total count for that publisher.
GET /v1/data/dados-prefeitura-sp-gov-br/organizations1 creditEvery publishing organization on the portal with its name, display title, description, image and dataset count.
GET /v1/data/dados-prefeitura-sp-gov-br/resource-search1 creditSearches resource metadata (not datasets) across the whole portal and returns up to 50 matching resource records with their download URLs.
GET /v1/data/dados-prefeitura-sp-gov-br/site-status1 creditThe portal's CKAN version, site title, locale and the list of installed CKAN extensions.
GET /v1/data/dados-prefeitura-sp-gov-br/tag1 creditThe id, name and vocabulary of one tag, and optionally every dataset carrying it.
GET /v1/data/dados-prefeitura-sp-gov-br/tags1 creditFlat JSON array of every free tag used on the portal.
Response example
The shape of data from dados-prefeitura-sp-gov-br/dataset (Dataset detail). A sample, not live data.
Example truncated, full shape in JSON from the API.
{
"help": "https://dados.prefeitura.sp.gov.br/api/3/action/help_show?name=package_show",
"success": true,
"result": {
"license_title": "Creative Commons Atribuição",
"maintainer": "",
"relationships_as_object": [],
"private": false,
"maintainer_email": "",
"num_tags": 3,
"id": "e239e5f2-cbcc-4535-8555-e49649af578a",
"metadata_created": "2026-10-21T13:24:21.229930",
"metadata_modified": "2026-10-21T13:33:37.910128",
"author": "",
"author_email": "guaianases@smsub.prefeitura.sp.gov.br",
"state": "active",
"version": "",
"creator_user_id": "707a3021-70d6-4700-b08b-a6ccd1a3ec62",
"type": "dataset",
"resources": [
{
"mimetype": "text/csv",
"cache_url": null,
"hash": "",
"description": "Informações sobre manutenção e conservação de galerias no território de Guaianases e Lajeado realizada em Janeiro.",
"name": "JANEIRO.csv",
"format": "CSV",
"url": "https://dados.prefeitura.sp.gov.br/dataset/e239e5f2-cbcc-4535-8555-e49649af578a/resource/db5360b3-4f69-4f68-a6eb-cecb06335621/download/janeiro.csv",
"datastore_active": false,
"cache_last_updated": null,
"package_id": "e239e5f2-cbcc-4535-8555-e49649af578a",
"created": "2026-10-21T13:25:29.807230",
"state": "active",
"mimetype_inner": null,
"last_modified": "2026-10-21T13:25:29.742536",
"position": 0,
"revision_id": "eba0246b-92bb-4d6b-a732-431042ea3ed9",
"url_type": "upload",
"id": "db5360b3-4f69-4f68-a6eb-cecb06335621",
"resource_type": null,
"size": 389
},
{
"mimetype": "application/pdf",
"cache_url": null,
"hash": "",
"description": "Informações sobre manutenção e conservação de galerias no território de Guaianases e Lajeado realizada em Janeiro",
"name": "JANEIRO.pdf",
"format": "PDF",
"url": "https://dados.prefeitura.sp.gov.br/dataset/e239e5f2-cbcc-4535-8555-e49649af578a/resource/7d1ef555-925e-4bbb-9c5b-04b2598bcc4c/download/janeiro.pdf",
"datastore_active": false,
"cache_last_updated": null,
"package_id": "e239e5f2-cbcc-4535-8555-e49649af578a",
"created": "2026-10-21T13:29:30.232533",
"state": "active",
"mimetype_inner": null,
"last_modified": "2026-10-21T13:29:30.131356",
"position": 1,
"revision_id": "724e3e74-fbcf-47fa-8fc7-c2dc47e262a6",
"url_type": "upload",
"id": "7d1ef555-925e-4bbb-9c5b-04b2598bcc4c",
"resource_type": null,
"size": 34784
},
{
"mimetype": "text/csv",
"cache_url": null,
"hash": "",
"description": "Informações sobre manutenção e conservação de galerias no território de Guaianases e Lajeado realizada em Fevereiro.",
"name": "FEVEREIRO.csv",
"format": "CSV",
"url": "https://dados.prefeitura.sp.gov.br/dataset/e239e5f2-cbcc-4535-8555-e49649af578a/resource/83bbd31b-6847-4fec-aa23-983223b84913/download/fevereiro.csv",
"datastore_active": false,
"cache_last_updated": null,
"package_id": "e239e5f2-cbcc-4535-8555-e49649af578a",
"created": "2026-10-21T13:26:13.233873",
"state": "active",
"mimetype_inner": null,
"last_modified": "2026-10-21T13:26:13.162020",
"position": 2,
"revision_id": "724e3e74-fbcf-47fa-8fc7-c2dc47e262a6",
"url_type": "upload",
"id": "83bbd31b-6847-4fec-aa23-983223b84913",
"resource_type": null,
"size": 389
},
{
"mimetype": "application/pdf",
"cache_url": null,
"hash": "",
"description": "Informações sobre manutenção e conservação de galerias no território de Guaianases e Lajeado realizada em Fevereiro",
"name": "FEVEREIRO.pdf",
"format": "PDF",
"url": "https://dados.prefeitura.sp.gov.br/dataset/e239e5f2-cbcc-4535-85Ask with this source
A prompt for your agent that names this source and how to call it through the crw MCP.
Dataset detail
Use Portal de Dados Abertos da Cidade de São Paulo (dados-prefeitura-sp-gov-br) from fastCRW Pergamon, capability "Dataset detail" (dataset). You already have a dataset name or UUID from a search and need its resources, licence or full description. Example options: id=manutencao-e-conservacao-de-galerias. Use the crw MCP tools: crw_find_data to confirm the source and its options, then crw_get_data with provider "dados-prefeitura-sp-gov-br" and capability "dataset". Tell me the credits used and cite the licence from the response. If the crw MCP tools are missing, install them with: npx -y crw-mcp install --api-key <your fastCRW API key>
All dataset names
Use Portal de Dados Abertos da Cidade de São Paulo (dados-prefeitura-sp-gov-br) from fastCRW Pergamon, capability "All dataset names" (dataset-names). You want the complete inventory of dataset ids to iterate over, rather than a scored search page. Example options: limit=100, offset=0. Use the crw MCP tools: crw_find_data to confirm the source and its options, then crw_get_data with provider "dados-prefeitura-sp-gov-br" and capability "dataset-names". Tell me the credits used and cite the licence from the response. If the crw MCP tools are missing, install them with: npx -y crw-mcp install --api-key <your fastCRW API key>
Dataset search
Use Portal de Dados Abertos da Cidade de São Paulo (dados-prefeitura-sp-gov-br) from fastCRW Pergamon, capability "Dataset search" (datasets). You want to find datasets on this portal by keyword, filter, or recency, and you do not already know a dataset id. Example options: q=statistika, fq=res_format:CSV, sort=metadata_modified desc. Use the crw MCP tools: crw_find_data to confirm the source and its options, then crw_get_data with provider "dados-prefeitura-sp-gov-br" and capability "datasets". Tell me the credits used and cite the licence from the response. If the crw MCP tools are missing, install them with: npx -y crw-mcp install --api-key <your fastCRW API key>
Dataset title autocomplete
Use Portal de Dados Abertos da Cidade de São Paulo (dados-prefeitura-sp-gov-br) from fastCRW Pergamon, capability "Dataset title autocomplete" (dataset-suggest). You are resolving a partly-remembered dataset title into an id and do not want full search payloads. Example options: q=manute, limit=10. Use the crw MCP tools: crw_find_data to confirm the source and its options, then crw_get_data with provider "dados-prefeitura-sp-gov-br" and capability "dataset-suggest". Tell me the credits used and cite the licence from the response. If the crw MCP tools are missing, install them with: npx -y crw-mcp install --api-key <your fastCRW API key>
Licence
Dataset records on this portal declare the licence "Creative Commons Atribuição" (http://www.opendefinition.org/licenses/cc-by). This is the licence the publishing organisations attach to their own datasets; the portal itself states no separate API licence. Quoted as found in the portal's own dataset metadata.
http://www.opendefinition.org/licenses/cc-byAttribution
Display this wherever you show the data. It arrives on every response as provenance.attribution_text.
Source: Portal de Dados Abertos da Cidade de São Paulo (Município de São Paulo (City of São Paulo, SP, Brazil)). Data published by the portal's contributing organisations.
Cache: up to 3600s
