Ecuador Cantonal Gross Value Added by Economic Sector — Provincial Accounts 2010

Each row is one extracted cell of the BCE provincial/cantonal accounts workbook for 2010 (Cuentas Cantonales), located by sheet, row and column. It reports gross value added (VAB), gross output/production and intermediate consumption for Ecuador's cantons and provinces (row labels combine province and canton, e.g. 'Azuay | Cuenca') broken down by economic sector — agriculture, mining, manufacturing, electricity and water, construction, commerce and services — including petroleum and non-petroleum totals, in thousands of US dollars for 2010. Because each row is one raw extracted cell located by sheet, row and column, values must be interpreted with their sheet, row label and column header context before aggregating, since the workbooks mix headers, totals, subtotals, notes and multiple table layouts.

banco-central-del-ecuador-documentos-estadisticas-sectorreal-cuentasprovinciales-can2010·7 columns·46 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-estadisticas-sectorreal-cuentasprovinciales-can2010\" 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.