Skip to main content
All providers

Portal de Dados Abertos da Cidade de São Paulo

Open data portalsBR

dados.prefeitura.sp.gov.br

São Paulo's municipal open data portal (Brazil).

Capabilities (15)

GET /v1/data/dados-prefeitura-sp-gov-br/dataset1 credit

Full metadata for one dataset: title, notes, licence, organization, tags, extras and the complete resource list with download URLs and formats.

id
GET /v1/data/dados-prefeitura-sp-gov-br/dataset-names1 credit

Flat JSON array of every dataset slug on the portal, in alphabetical order.

limit?offset?
GET /v1/data/dados-prefeitura-sp-gov-br/datasets1 credit

Solr-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.

q?fq?sort?start?facet.field?
GET /v1/data/dados-prefeitura-sp-gov-br/dataset-suggest1 credit

Lightweight typeahead: matching datasets as {name, title, match_field} objects, no resources or descriptions.

qlimit?
GET /v1/data/dados-prefeitura-sp-gov-br/group1 credit

Metadata for one thematic group: title, description, image and dataset count.

idinclude_datasets?include_extras?
GET /v1/data/dados-prefeitura-sp-gov-br/group-datasets1 credit

A page of up to 20 full dataset records belonging to one thematic group, with the group's total count.

groupq?sort?start?
GET /v1/data/dados-prefeitura-sp-gov-br/groups1 credit

Every thematic group (subject category) on the portal with its name, display title, description and dataset count.

limit?offset?sort?
GET /v1/data/dados-prefeitura-sp-gov-br/licenses1 credit

Every licence the portal offers publishers, as {id, title, url, od_conformance, osd_conformance} objects.

No parameters
GET /v1/data/dados-prefeitura-sp-gov-br/organization1 credit

Metadata for one publishing organization: title, description, contact extras, dataset count and (optionally) its datasets.

idinclude_datasets?include_extras?include_followers?
GET /v1/data/dados-prefeitura-sp-gov-br/organization-datasets1 credit

A page of up to 20 full dataset records published by one organization, with the total count for that publisher.

organizationq?sort?start?
GET /v1/data/dados-prefeitura-sp-gov-br/organizations1 credit

Every publishing organization on the portal with its name, display title, description, image and dataset count.

limit?offset?sort?
GET /v1/data/dados-prefeitura-sp-gov-br/resource-search1 credit

Searches resource metadata (not datasets) across the whole portal and returns up to 50 matching resource records with their download URLs.

queryoffset?order_by?
GET /v1/data/dados-prefeitura-sp-gov-br/site-status1 credit

The portal's CKAN version, site title, locale and the list of installed CKAN extensions.

No parameters
GET /v1/data/dados-prefeitura-sp-gov-br/tag1 credit

The id, name and vocabulary of one tag, and optionally every dataset carrying it.

idinclude_datasets?vocabulary_id?
GET /v1/data/dados-prefeitura-sp-gov-br/tags1 credit

Flat JSON array of every free tag used on the portal.

query?vocabulary_id?

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.

JSON
{
  "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-85

Ask 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-by

Attribution

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