Ecuador GDP by the Income Approach — Current Prices, to 2020p

Each row is a single extracted cell of the Banco Central del Ecuador workbook 'PIB por enfoque del Ingreso (current)', located by sheet, row and column, holding a numeric value or text. The workbook presents Ecuador's gross domestic product measured by the income approach in current prices, in thousands of dollars, with the component aggregates by year through 2020p. Years (2017–2020, provisional) appear inside cell text rather than in a dedicated date column. Rows are raw extracted workbook cells, so each numeric value must be read in the context of its sheet, row and column header — the workbooks mix headers, totals, subtotals, notes and multiple table layouts — before it can be aggregated.

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