CAPS Pneumonia and exposure to household air pollution in children under the age of 5 in rural Malawi 2014 - 2016

CAPS blchild (data from form F01 and extra children from F0

CAPS blchild links to the other MEIRU database table(s) using keys as indicated below in the form tablename key:
caps_blhse capshse
caps_fuphse stid
caps_fupchild stid
caps_burns stid+cno
caps_monitor stid+cno
caps_tracking stid
caps_blpneum stid
caps_register stid

CAPS blhse (data from form F01)

CAPS blhse links to the other MEIRU database table(s) using keys as indicated below in the form tablename key:
caps_stove capshse
caps_fuphse capshse
caps_blchild capshse
caps_monpm capshse
caps_monae capshse
caps_monsu capshse
caps_monco capshse

CAPS baseline pneumonia episodes (from F01 or F02)

CAPS blpneum links to the other MEIRU database table(s) using keys as indicated below in the form tablename key:
caps_blchild stid

CAPs data about burns from Form 01 or Form 02

CAPS_burns links to the other MEIRU database table(s) using keys as indicated below in the form tablename key:
caps_fuphse stid+cno
caps_blchild stid+cno

CAPS equipment distribution data (from form F02/F03)

CAPS_equipdistrib links to the other MEIRU database table(s) using keys as indicated below in the form tablename key:
caps_stove cno
caps_fuphse cno
caps_equipstatus cno+equipid

CAPS equipment status data (from form F02/F03)

CAPS_equipstatus links to the other MEIRU database table(s) using keys as indicated below in the form tablename key:
caps_equipdistrib cno+equipid
caps_fuphse cno

CAPS followup child (data from form F02)

CAPS_fupchild links to the other MEIRU database table(s) using keys as indicated below in the form tablename key:
caps_FUPpneum stid+cno
caps_fuphse capshse+cno
caps_blchild stid
caps_burns stid+cno
caps_FUPhdoc stid+cno

CAPs STID of SUMS participants from Form 03

CAPS_fuphdoc links to the other MEIRU database table(s) using keys as indicated below in the form tablename key:
caps_FUPchild stid+cno

CAPS followup house (data from form F02)

CAPS_FUPhse links to the other MEIRU database table(s) using keys as indicated below in the form tablename key:
caps_blchild stid
caps_BLhse capshse
caps_equipdistrib cno
caps_equipstatus cno
caps_fupchild capshse+cno

CAPS follow up pneumonia episodes (from F02)



CAPS_fuppnueum links to the other MEIRU database table(s) using keys as indicated below in the form tablename key:
caps_blchild stid

CAPS meals data from form F06


CAPS_maels links to the other MEIRU database table(s) using keys as indicated below in the form tablename key:
caps_monitor stid+cno

CAPs monitor data from Form 06

CAPS_monitor links to the other MEIRU database table(s) using keys as indicated below in the form tablename key:
caps_meals stid+cno
caps_BLchild stid+cno

Data on CAPS households which did not consent

CAPS field register

CAPS field equipment register

CAPs stove data from Form 03

CAPs STID of SUMS participants from Form 03

CAPs tracking data from Form 04