Ecuador Social Accounting Matrix — Traditional Macroeconomic View (VMA-T)

Each row is a single cell extracted from the Banco Central del Ecuador "Visión Macroeconómica Tradicional" statistical Excel workbook (mcs_vmat_2018_2024p.xlsx), located by its sheet, row index and column index and holding either a numeric value or a text label. The workbook reports Ecuador's Social Accounting Matrix (Matriz de Contabilidad Social) under the traditional macroeconomic view, mapping economic activities, institutional sectors and national-accounting transactions — indirect taxes on products (D21), direct taxes (D5), gross fixed capital formation (P51g) and the capital account — into an economy-wide matrix covering 2018–2024. Because each row is a raw workbook cell, its sheet, row, and column-header context must be interpreted before aggregating the numeric values, since the workbook mixes header rows, totals, subtotals, notes, and multiple table layouts.

banco-central-del-ecuador-documentos-informacioneconomica-cuentasnacionales-anuales-mcs-vmat-2018-2024p·7 columns·13 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-anuales-mcs-vmat-2018-2024p\" 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.