Ecuador Per Capita Gross Value Added by Province and Canton (2018–2023)

Each row is one extracted cell of the Banco Central del Ecuador per capita gross value added workbook covering 2018–2023, with sheets for cantonal and provincial per capita VAB plus an index, located by sheet, row and column index and holding a numeric value or descriptive text. It pairs current-price gross value added (thousands of US dollars) with population to give per capita VAB in US dollars and its variation rates, by province and canton. Rows are raw extracted workbook cells, so each numeric value must be read in the context of its sheet, row label and column header — the source mixes titles, headers, totals, subtotals and notes across multiple sheet layouts — before any aggregation.

banco-central-del-ecuador-documentos-informacioneconomica-cuentasnacionales-regionales-vab-percapita-cnrc-2018-2023p·7 columns·59 KB·Ecuador public information / open data legal framework·updated 4mo ago

Schema

sheetVARCHAR
row_indexINTEGER
col_indexINTEGER
row_labelVARCHAR
col_headerVARCHAR
valueDOUBLE
value_textVARCHAR

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 \"banco-central-del-ecuador-documentos-informacioneconomica-cuentasnacionales-regionales-vab-percapita-cnrc-2018-2023p\" 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.