cnpj_estabelecimentos_municipio
CNPJ establishments by municipality, CNAE and registration status
Count of establishments in the National Register of Legal Entities (CNPJ, Federal Revenue Service) aggregated by municipality, primary CNAE and registration status, from the monthly dump. Used to measure the active, closed or unfit business base of each municipality and sector.
Query via MCP ↓3,870,135 rows · 7 columns
- One row is
- one row per (snapshot, ibge_code, cnae_principal, situacao_cadastral)
- Key columns
- snapshot, municipio_codigo_rf, cnae_principal, situacao_cadastral
- License
- gov.br open data (CC0/LAI in the project's source catalog)
- Domain
- Companies
- Snapshot
- 2026-09-25
Columns
| Column | Type | Description |
|---|---|---|
| snapshotKEY | VARCHAR | Month of the Receita dump (AAAA-MM). |
| uf | VARCHAR | State abbreviation (UF). Includes 'EX' for establishments abroad. |
| municipio_codigo_rfKEY | VARCHAR | Federal Revenue Service municipality code (4 digits, TOM/SIAFI table). |
| ibge_code | BIGINT | IBGE municipality code (7 digits). Derived from municipio_codigo_rf via the SIAFI code; null for establishments abroad (uf EX). |
| cnae_principalKEY | VARCHAR | Primary fiscal CNAE (7 digits). |
| situacao_cadastralKEY | VARCHAR | Registration status: 01 null, 02 active, 03 suspended, 04 unfit, 08 closed. |
| qtd | BIGINT | Number of establishments. |
Queries that read this table
No curated query reads this table directly yet — it feeds the lake's derived tables. Browse all queries.
Query via MCP
The lake is served through curated queries. Connect your agent to the MCP server and ask — it finds the right query on its own. All you need is an API key — new keys come with 50 free credits (pricing).
cnpj_estabelecimentos_municipio
CNPJ establishments by municipality, CNAE and registration status.
Use the lakebrasil MCP — start with consultas_buscar — and cite the
source of each number.