Ecuador Social Accounting Matrix (Micro-SAM), Visión Tradicional — 2007

Each row is a single extracted cell of the Banco Central del Ecuador micro Social Accounting Matrix workbook 'Visión Tradicional - 2007', located by sheet, row and column. The matrix records transactions between Ecuador's productive industries, products, factors of production, household income deciles and the rest of the world for the 2007 benchmark year, presented in the traditional view. Values are in thousands of dollars. This is a single benchmark-year matrix, not a running time series. 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-mcs-mcs1·7 columns·42 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-mcs-mcs1\" 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.