Crude Oil Production — Brazil Monthly State and Location Volumes

One row is one month, state, product, and location category with production volume for Brazilian state coverage in Brazil, with measured crude oil production and temporal coverage 1997-2026. The profiled table has 15,607 rows.

anp-brazil-ppgn-el-producao-petroleo-m3·8 columns·134 KB·Creative Commons Attribution-NoDerivatives 3.0 Unported (site footer) plus ANP portal terms·updated 19d ago
ANP Brazil

Source: ANP Brazil · connector code

Schema

dateDATE
yearINTEGER
monthINTEGER
grande_regiaoVARCHAR
unidade_da_federacaoVARCHAR
produtoVARCHAR
localizacaoVARCHAR
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-ppgn-el-producao-petroleo-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.