Ecuador Quarterly National Accounts — Supply and Use of Goods and Services (Bulletin No. 126, Preliminary Estimate 2023)

Each row is a single cell extracted from the Banco Central del Ecuador workbook 'Oferta y utilización de bienes y servicios' (Bulletin No. 126, Preliminary Estimate 2023), located by sheet, row index and column index and carrying either a numeric value or a text label. The workbook reports the supply and use (aggregate demand) of goods and services — GDP, household and government final consumption, gross fixed capital formation, changes in inventories, and exports and imports of goods and services, presented at current prices, in chained (2018=100) volumes and as price indices, in both raw and seasonally adjusted form, in yearly preliminary panels. Because rows are raw workbook cells, the numeric value must be read in the context of its sheet, row and column headers before aggregating: the workbook mixes title rows, unit banners, totals, subtotals and notes across multiple sheet layouts.

banco-central-del-ecuador-documentos-informacioneconomica-cuentasnacionales-trimestrales-tou-126-2023prel·7 columns·15 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-tou-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.