Ecuador Cantonal National Accounts Backcast Series — Gross Value Added by Canton (2007–2018)

Each row is one extracted cell of the Banco Central del Ecuador cantonal accounts backcast (retropolación) workbook covering 2007–2018, with one sheet per year plus an index, located by sheet, row and column index and holding a numeric value or descriptive text. It provides a consistent long-run historical series of canton-level gross value added (values in thousands of US dollars) by province and canton, reconstructed onto the current methodology. 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-cantonales-retropolaci-n-cnr-cantonal-2007-2018-pub-valores·7 columns·334 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-cantonales-retropolaci-n-cnr-cantonal-2007-2018-pub-valores\" 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.