Lab 04 — Gender-based violence & health (Minsalud, SALVIA, forensic medicine)
Cross public sources on gender-based violence in Colombia (Minsalud / SALVIA, forensic medicine and open health indicators) with data quality, ethics and safe aggregation.
- Objective
- Illustrate a critical, ethical GBV–health analysis: what can be joined at aggregate level, how to cite institutional sources, and what is not published (sensitive microdata).
- Methodology
- 1) Source inventory: Minsalud / SISPRO–SALVIA portals (as publicly available), INMLCF / forensic medicine (bulletins or open data), and health datasets on datos.gov.co. 2) Variable dictionary and allowed geography (department/municipality only if published and re-identification risk is low). 3) Cleaning, joins by DIVIPOLA or normalised names; bounded time series. 4) Aggregate visuals (rates, counts) + coverage, under-reporting and bias notes. 5) Privacy caveats on the card; no victim point maps.
- Limitations
- Under-reporting and definition changes across systems; SALVIA/SISPRO access may be restricted (do not assume an open API). High ethical risk if over-disaggregated. Public aggregates only.
Sources & APIs
- Datos Abiertos Colombia (datos.gov.co)
SODA/Socrata portal: REST + SoQL per dataset (Export → API).
Docs - Minsalud / SISPRO–SALVIA (Colombia)
Health and violence information systems (SALVIA/SISPRO by product). Access often restricted or via reports/dashboards; do not assume an open API. Lab 04: inventory public endpoints or downloads before integrating.
- INMLCF — Medicina Legal (Colombia)
Forensic bulletins and statistics (incl. interpersonal/GBV violence per publications). Prefer official aggregates and datos.gov.co when datasets are published.
- World Bank Indicators API v2
Country series (e.g. COL); no API key. Good first dashboard.
Docs