Asphalt Sales by Municipality — Brazil Annual Kilograms

One row is one year, municipality, and asphalt product for Brazilian municipality coverage in Brazil, with measured asphalt sales and temporal coverage 1992-2024. The profiled table has 594,153 rows. Known limitation: Source ships overlapping annual partition files, so a small fraction (~4%) of (ano, uf, codigo_ibge, municipio, produto) observations repeat; de-duplicate before summing vendas.

anp-brazil-vdpb-vaehdpm-asfalto-vendas-anuais-de-asfalto-por-municipio·7 columns·5.0 MB·Creative Commons Attribution-NoDerivatives 3.0 Unported (site footer) plus ANP portal terms·updated 4h ago

Schema

yearINTEGER
grande_regiaoVARCHAR
ufVARCHAR
produtoVARCHAR
codigo_ibgeVARCHAR
municipioVARCHAR
vendasDOUBLE

Get this dataset on your machine

subsets sync --bundle medium clones the mid-size tiers as queryable local tables — use --bundle large for the widest tier

pip install subsetsio
subsets sync --bundle small # or medium, or large
subsets serve # search + SQL at http://localhost:8080

Free and open — the data syncs straight from the public bucket, and search + SQL run entirely on your machine. See docs →

Query it locally

Full docs →
Bash
subsets serve   # local API on http://localhost:8080
curl -s -X POST "http://localhost:8080/query" \
  -H "Content-Type: application/json" \
  -d '{"sql": "SELECT * FROM \"anp-brazil-vdpb-vaehdpm-asfalto-vendas-anuais-de-asfalto-por-municipio\" LIMIT 5"}'

No account, no API key — the data syncs straight from bundles.subsets.io and every query runs on your machine. See the local API reference.