Ecuador National Accounts — Oil and Non-Oil Gross Value Added and GDP (Preliminary Annual, 2023)

Each row is one cell extracted from BCE's national accounts workbook 'Valor agregado bruto petrolero y no petrolero', located by sheet, row and column, carrying a numeric value or workbook text. It splits Ecuador's GDP into oil (petroleum) value added, non-oil value added, other GDP elements and total GDP, as preliminary annual estimates centered on 2023, reported in thousands of USD, chained-volume levels and price indices (base 2018=100), in gross and seasonally adjusted form. Rows are raw workbook cells mixing titles, headers, totals and subtotals, so sheet and header context is required before aggregating.

banco-central-del-ecuador-documentos-informacioneconomica-cuentasnacionales-trimestrales-vab-p-np-126-2023prel·7 columns·10 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-trimestrales-vab-p-np-126-2023prel\" 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.