Ecuador Integrated Economic Accounts by Sector and Subsector 2007-2016

Each row is one extracted cell of the BCE 'Sectores y subsectores Institucionales (2007-2016 sd) - Cuentas Económicas Integradas' Excel workbook, located by sheet, row index and column index and holding either a numeric value or a text label. It presents Ecuador's integrated economic accounts by institutional sector and subsector for 2007-2016, including public and private non-financial corporations, petroleum public corporations, private depository corporations and financial auxiliaries, with balancing items such as gross value added, national income, disposable income and gross saving. Rows are raw extracted workbook cells located by sheet, row and column, so values must be interpreted with their sheet, row label and column header context before aggregating, since the workbook mixes headers, totals, subtotals and notes.

banco-central-del-ecuador-documentos-publicacionesnotas-catalogo-cuentasnacionales-ceinivel2sd·7 columns·95 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-publicacionesnotas-catalogo-cuentasnacionales-ceinivel2sd\" 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.