anp_postos
Fuel stations (ANP)
Register of retail automotive fuel resellers authorized by the ANP, with CNPJ, address, brand and municipality. Contains two snapshots of the same register; filter by snapshot to avoid double-counting stations.
Query via MCP ↓91,396 rows · 15 columns
- One row is
- one row per (cnpj, snapshot)
- Key columns
- cnpj, snapshot
- License
- CC BY 4.0 (ANP)
- Domain
- Energy
- Snapshot
- 2026-09-25
Columns
| Column | Type | Description |
|---|---|---|
| snapshotKEY | VARCHAR | Date of the downloaded file (AAAA-MM-DD). |
| codigo_isimp | VARCHAR | Agent code in the ANP system. |
| autorizacao | VARCHAR | ANP authorization number. |
| data_publicacao | VARCHAR | Authorization publication date (DD/MM/AAAA, text). |
| razao_social | VARCHAR | Legal company name (some names have corrupted accents at the source). |
| cnpjKEY | VARCHAR | CNPJ of the station (14 digits). |
| endereco | VARCHAR | Street and number. |
| bairro | VARCHAR | Neighborhood. |
| cep | VARCHAR | CEP (8 digits). |
| uf | VARCHAR | State abbreviation (UF). |
| municipio | VARCHAR | Municipality name (uppercase, no accents). |
| bandeira | VARCHAR | Brand (distributor) or BANDEIRA BRANCA (unbranded). |
| data_vinculacao | VARCHAR | Date of affiliation with the brand (DD/MM/AAAA, text). |
| ibge_code | BIGINT | IBGE municipality code (7 digits). Resolved by name; null in ~0.2% of rows. |
| complemento | VARCHAR | Address complement. |
Queries that read this table
- postos_anp1 credit
Municipality fuel stations. Retail fuel resellers authorized by ANP in the municipality (most recent registry), optionally by brand.
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).
postos_anp
Which fuel stations are there in Santos, and under which brands?