Male-headed households | PublicSchema

Overview

Catalog: DHS Program — Household and SP-adjacent indicator seed metric catalog
Value type: proportion
Decimals: 1
Version: 1.0.0
Status: bibo:draft
Core: Yes — must-have subset
Stable URI: https://publicschema.org/metrics/dhs_household/hc_hhhd_h_mal

Linked concept

dhs household headship

publicschema:concept/dhs/household_headship

Dimensions

dim/ref_area
dim/time_period

External alignments

api.dhsprogram.com /rest/dhs/indicators/HC_HHHD_H_MAL

Calculation

Scoring proportion
Subject class Household

Populations

initial-population application/sql
```
SELECT id FROM ${ps.Household}
```
denominator application/sql
```
SELECT id FROM ${ps.Household}
```

numerator application/sql

SELECT DISTINCT h.id
FROM ${ps.Household} h
JOIN ${ps.GroupMembership} gm ON gm.group = h.id
JOIN ${ps.Person} p ON p.id = gm.person
WHERE gm.role = 'head'
  AND gm.is_active = true
  AND p.sex = 'male'