Biodiesel Production — Brazil Monthly Producer Volumes

One row is one month, region/state, producer, and product for Brazilian state coverage in Brazil, with measured biodiesel production and temporal coverage 2005-2026. The profiled table has 23,864 rows. Known limitation: Includes ~145 subtotal rows (0.6%) with null unidade_da_federacao/produtor/produto; the remaining detail rows are otherwise unique on (ano, mes, grande_regiao, unidade_da_federacao, produtor). The `mes` column mixes two encodings across source vintages (e.g. 'ABR' vs 'Abril') — normalize before grouping by month.

anp-brazil-arquivos-producao-de-biocombustiveis-producao-biodiesel-m3·8 columns·152 KB·Creative Commons Attribution-NoDerivatives 3.0 Unported (site footer) plus ANP portal terms·updated 1mo ago
ANP Brazil

Source: ANP Brazil · connector code

Schema

dateDATE
yearINTEGER
monthINTEGER
grande_regiaoVARCHAR
unidade_da_federacaoVARCHAR
produtorVARCHAR
produtoVARCHAR
producaoDOUBLE

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-arquivos-producao-de-biocombustiveis-producao-biodiesel-m3\" 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.