Male-headed households | PublicSchema

Vue d’ensemble

Catalogue: DHS Program — Household and SP-adjacent indicator seed metric catalog
Type de valeur: proportion
Décimales: 1
Version: 1.0.0
Statut: bibo:draft
Essentiel: Oui, sous-ensemble essentiel
URI stable: https://publicschema.org/metrics/dhs_household/hc_hhhd_h_mal

Concept associé

dhs household headship

publicschema:concept/dhs/household_headship

Dimensions

dim/ref_area
dim/time_period

Alignements externes

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

Calcul

Méthode de notation proportion
Classe des sujets Ménage

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'