Home / Central Data Catalog / MCC / TZA_2013_MCC-WS_V01_M
MCC

Water Sector 2013

Tanzania, 2013
Get Microdata
Reference ID
TZA_2013_MCC-WS_v01_M
Producer(s)
Social Impact, Inc.
Collection(s)
Millennium Challenge Corporation (MCC)
Metadata
Documentation in PDF DDI/XML JSON
Created on
Jun 08, 2015
Last modified
Jun 08, 2015
Page views
404042
Downloads
3500

Data file: Roster_Anonymized_09012015

This dataset contains data for all household members, collected using the Household Survey instrument and the Phone Survey, using household member rosters. It also contains the sampling weights that should be applied to datasets prior to any analysis that will require representativeness at the city level. The file contains collected variables, as well as several sets of derived variables related to various modules of the household survey. A series of Stata programs (forthcoming) was used to produce the derived variables.

Cases: 21402
Variables: 233

Variables

uniqueid
Unique Household ID
uniqueindiv
UNIQUE IDENTIFIER FOR INDIVIDUALS IN ROSTER
City
City
DistrictID
District
District
WardID
MtaaID
CityID
City ID: 1=Mor, 2=Dar
UEAID
Unique EA ID (EDI)
HHID
Unique HHID within each EA (EDI)
MemID
Household Members above 5
U6MemID
Household Members Under 6
Respondent
Respondent indicator (1) used for merging
OthersPresent
Other individuals present during survey?
respondent1
Main respondent - roster ID
respondent2
Second respondent present - roster ID
respondent3
Third respondent present - rosterID
status
Individual's status in HH and PH surveys
member1
=1 if Member present in round 1
member2
=1 if Member present in round 2
member3
=1 if Member present in round 3
REL_HEAD
Relationship to head of household
RelHead_other
Other specify for RelHead
RelHeadU6_other
Other specify for RelHeadU6
RESIDING
Is [Name] currently residing the house?<
Membership
Is household member a permanent or temporary member of the household?
memberApril
Was this person a member of the household this past April?
StillMember
Is [NAME] still a member of the household?
SEX
Sex
AGE_YEARS
Age (years) of all household members
AGE_GROUP_by5
Age group categories by 5 year increments
AGE_GROUP_mcc
Age group categories for MCC indicators
AGE_GROUP_DEPRAT
Age group categories for dependency ratio
rc_hh_size
Recode of 99th percentile of hh_size
rc_hh_size_res
Recode of 99th percentile of hh_size_res
rc_hh_size_res_hoh
Recode of 99th percentile of hh_size_res_hoh
dependent
Indicator for dependent (age <15, >64)
productive
Indicator for workforce age (15-64)
MARITAL
Marital Status - age 12+
LIT_kiswahili
Literacy in Kiswahili (read/write)
LIT_english
Literacy in English (read/write)
EDUC
Highest level of education (USE THIS CATEGORIZATION)
hh19
Education Level: Highest grade completed
ENROLLED
Is household member in school this year?
hh20a
Why household member is not in school this year
ABSENT_DAYSFULL
Full days of school missed in the last 20 schooling days
ABSENT_DAYSPART
Partial days of school missed in the last 20 schooling days
hh21c
Main reason for absences from school during last 20 schooling days
hh21c_other
Other specify for hh21c
child_motherpresent
This child's mother present in the household
child_fatherpresent
This child's father present in the household
child_motheredu
Highest education of this child's mother
child_fatheredu
Highest education of this child's father
memberGathers
Indiv gathers water for HH - based on HH roster module
WATER_ABSENCE
[Name] missed school/ was late because of duties to collect water in last 20 day
waterCarrier
Does [CHILD] carry water for payments in cash or in-kind?
DIARRHEA
Did (Name) have diarrhea in the last 14 days? (at least 3 watery stools per day)
daysDiarrhea
For how many days out of the last 14 did [NAME] have diarrhea?
hh73
Was there mucus in the stools?
hh74
Was there blood in the stools?
hh75
Was there abdominal pain with the diarrhea?
hh76
Amount given to drink when had diarrhea
ABSENT_DIARR
Missed days of school or work due to diarrhea in last 14 days
ABSENT_DIARR_SCHOOL
# days of school missed
ABSENT_DIARR_WORK
# days of work missed
rc_DIARR_SPENT
Recode of 99th percentile of DIARR_SPENT
hh78
Was [Name] taken to health clinic or health worker for diarrhea in last 14 days?
hh78_a
Why not?
hh79
Was [Name] hospitalized with diarrhea in the last 2 weeks?
hh79_a
For how many days?
medicine
Diarrhea treatment: Meds (tablet, syrup, etc.) (0/1)
injection
Diarrhea treatment: Injection (0/1)
ORS
Diarrhea treatment: ORS (0/1)
other
Diarrhea treatment: other (0/1)
otherTreatment
Diarrhea treatment - specify other for var other (0/1)
noTreatment
Diarrhea treatment: no treatment (0/1)
totalSpentCheck
Interviewer check for total amount spent
fever
under 6 symptom: fever
headache
under 6 symptom: headache
constantCough
under 6 symptom: constantCough
congestion
under 6 symptom: congestion
breathingDiff
under 6 symptom: breathingDiff
vomiting
under 6 symptom: vomiting
stomachAche
under 6 symptom: stomachAche
bloodyUrine
under 6 symptom: bloodyUrine
bloodInStool
under 6 symptom: bloodInStool
mucusInStool
under 6 symptom: mucusInStool
refuseFeed
under 6 symptom: refuseFeed
skinItching
under 6 symptom: skinItching
eyeInfection
under 6 symptom: eyeInfection
hh91_other
Other specify for hh91
water_collector
Indiv collects water for HH - based on Water Source Roster module
WaterSource1
source #1 collected by indiv (water_collector)
WaterSource2
source #2 collected by indiv (water_collector)
WaterSource3
source #3 collected by indiv (water_collector)
WaterSource4
source #4 collected by indiv (water_collector)
Min_Coll_Wet_neighbor
Min/wk collects from neighbor (Wet Season)
Min_Coll_Wet_publictap
Min/wk collects from public tap (Wet Season)
Min_Coll_Wet_kiosk
Min/wk collects from kiosk (Wet Season)
Min_Coll_Wet_vendor
Min/wk collects from vendor (Wet Season)
Min_Coll_Wet_tanker
Min/wk collects from tanker (Wet Season)
Min_Coll_Wet_borehole
Min/wk collects from borehole (Wet Season)
Min_Coll_Wet_protwell
Min/wk collects from protected well (Wet Season)
Min_Coll_Wet_unprotwell
Min/wk collects from unprotected well (Wet Season)
Min_Coll_Wet_rainwater
Min/wk collects from rainwater (Wet Season)
Min_Coll_Wet_bottled
Min/wk collects from bottled water (Wet Season)
Min_Coll_Wet_surface
Min/wk collects from surface water (Wet Season)
Min_Coll_Wet_protspring
Min/wk collects from protected spring (Wet Season)
Min_Coll_Wet_unprotspring
Min/wk collects from unprotected spring (Wet Season)
Min_Coll_Wet_pipebusiness
Min/wk collects from piped business (Wet Season)
Min_Coll_Wet_other
Min/wk collects from other source (Wet Season)
Min_Coll_Wet_bagged
Min/wk collects from bagged water (Wet Season)
Min_Coll_Wet_Total
TOTAL MIN/WK COLLECTS WATER, all sources (Wet Season)
Min_Coll_Dry_neighbor
Min/wk collects from neighbor (Dry Season)
Min_Coll_Dry_publictap
Min/wk collects from public tap (Dry Season)
Min_Coll_Dry_kiosk
Min/wk collects from kiosk (Dry Season)
Min_Coll_Dry_vendor
Min/wk collects from vendor (Dry Season)
Min_Coll_Dry_tanker
Min/wk collects from tanker (Dry Season)
Min_Coll_Dry_borehole
Min/wk collects from borehole (Dry Season)
Min_Coll_Dry_protwell
Min/wk collects from protected well (Dry Season)
Min_Coll_Dry_unprotwell
Min/wk collects from unprotected well (Dry Season)
Min_Coll_Dry_rainwater
Min/wk collects from rainwater (Dry Season)
Min_Coll_Dry_bottled
Min/wk collects from bottled water (Dry Season)
Min_Coll_Dry_surface
Min/wk collects from surface water (Dry Season)
Min_Coll_Dry_protspring
Min/wk collects from protected spring (Dry Season)
Min_Coll_Dry_unprotspring
Min/wk collects from unprotected spring (Dry Season)
Min_Coll_Dry_pipebusiness
Min/wk collects from piped business (Dry Season)
Min_Coll_Dry_other
Min/wk collects from other source (Dry Season)
Min_Coll_Dry_bagged
Min/wk collects from bagged water (Dry Season)
Min_Coll_Dry_Total
TOTAL MIN/WK COLLECTS WATER, all sources (Dry Season)
EMPL_STATUS
What is NAME's employment status?
EMPL_FORMAL
Paid Employee
EMPL_SELF
Self-employed
EMPL_FORM_SELF
Paid employee or self-employed
EMPL_SECONDARY
Works additional secondary job
UNEMPL
Unemployed
HRS_EMPL
Hours worked in formal/informal/self emplmt, weekly
HRS_HOME
Hours worked in the home, weekly
HRS_SEC
Hours worked in secondary work, weekly
HRS_CHILD
Hours worked by child, weekly (home -> very few non-home)
HRS_WORKED
Total hours worked, weekly (adults: formal/informal/self/home/sec)
workHomeDays
How many days out of the last 7 did [Name] do work in the home?
hrsPerDayHome
Hours working per day on day doing work in home in last 7 days?
employer
Who is the employer?
registeredBus
Is the business registered?
hh95
Does [NAME] receive wages / salary / other payments from this employer
monthlyBasis
Is [Name] paid on a monthly basis for this job?
daysWorked7
How many days did [NAME] do this work in the last 7 days?
hrsPerDayEmp
Hours working per day on days worked in last 7 days?
workTimeTypical
Is this work time over the last 7 days typical of [NAME] work over the past 12 m
typicalDays
During the past 12 months, # days out of 7 [Name] typically does this work
typicalHours
On these days, about how many hours were they working per day?
hh93
During the last 12 months, for how many months did [Name] work in this job?
hh94
During L12M, how many weeks per month does [Name] usually work in this job?
secondaryWork
Does [NAME] have any secondary work, do anything part time, or do any work on th
sec_employer
Who is the employer?
sec_registeredBus
Is the business registered?
sec_monthlyBasis
Is [Name] paid on a monthly basis for this job?
sec_daysWorked7
How many days did [NAME] do this work in the last 7 days?
sec_hrsPerDayEmp
Hours working per day on days worked in last 7 days?
sec_workTimeTypical
Is this work time over the last 7 days typical of [NAME]'s work over the past 12
sec_typicalDays
During the past 12 months, # days out of 7 [Name] typically does this work
sec_typicalHours
On these days, about how many hours were they working per day?
sec_hh93
During the last 12 months, for how many months did [Name] work in this job?
sec_hh94
During L12M, how many weeks per month does [Name] usually work in this job?
sec_hh95
Does [NAME] receive wages / salary / other payments from this employer
hh92
Was [Name] available and able to work during the last 7 days?
hh92a
Why not available for work during the last 7 days
hh92a_other
Other specify for hh92a
workSearch30days
Has [NAME] taken any steps within the past 30 days to look for work?
monthLastWorked
Month last worked
yearLastWorked
Year last worked
U18Work
When not in school, does [NAME] do any work at home or outside the home?
mainWorkU18
What is the main type of work that [NAME] does?
child_employer
Who is the employer?
child_registeredBus
Is the business registered?
child_monthlyBasis
Is [Name] paid on a monthly basis for this job?
child_daysWorked7
How many days did [NAME] do this work in the last 7 days?
child_hrsPerDayHome
Hours working per day on day doing work in home in last 7 days?
child_hrsPerDayEmp
Hours working per day on days worked in last 7 days?
child_workTimeTypical
Is this work time over the last 7 days typical of [NAME] work over the past 12 m
child_typicalDays
During the past 12 months, # days out of 7 [Name] typically does this work
child_typicalHours
On these days, about how many hours were they working per day?
child_hh93
During the last 12 months, for how many months did [Name] work in this job?
child_hh94
During L12M, how many weeks per month does [Name] usually works in this job?
child_hh95
Does [NAME] receive wages / salary / other payments from this employer
call1
HH participated in phone survey round 1
call2
HH participated in phone survey round 2
call3
HH participated in phone survey round 3
PH1_stillMember
Is (NAME) still in this household?
PH1_missedWorkSchool
Missed work or school due to own diarrheal illness in last 14 days
PH1_daysSchool
# days of school missed, round 1
PH1_daysWork
# days of work missed, round 1
PH1_stillMemberU6
Is [NAME] still in this household?
PH1_diarrheaL14days
Did (NAME) have diarrhea in the last 14 days (at least 3 watery stools per day)?
PH1_daysMissedU6
Days of work or normal activity missed by hh member (>=18yrs) to care for child
PH2_stillMember
Is (NAME) still in this household?
PH2_missedWorkSchool
Missed work or school due to own diarrheal illness in last 14 days
PH2_daysSchool
# days of school missed, round 2
PH2_daysWork
# days of work missed, round 2
PH2_stillMemberU6
Is [NAME] still in this household?
PH2_diarrheaL14days
Did (NAME) have diarrhea in the last 14 days (at least 3 watery stools per day)?
PH2_daysMissedU6
Days of work or normal activity missed by hh member (>=18yrs) to care for child
PH3_stillMember
Is (NAME) still in this household?
PH3_missedWorkSchool
Missed work or school due to own diarrheal illness in last 14 days
PH3_daysSchool
# days of school missed, round 3
PH3_daysWork
# days of work missed, round 3
PH3_stillMemberU6
Is [NAME] still in this household?
PH3_diarrheaL14days
Did (NAME) have diarrhea in the last 14 days (at least 3 watery stools per day)?
PH3_daysMissedU6
Days of work or normal activity missed by hh member (>=18yrs) to care for child
enrollees
total # of school enrollees aged 6-18 in each household
enrollees_m
total # of _male_ school enrollees aged 6-18 in each household
enrollees_f
total # of _female_ school enrollees aged 6-18 in each household
ABS
# of absentee days enrollee aged 6-18 in each household
ABS_M
# of absentee days for _male_ school enrollee aged 6-18 in each household
ABS_F
# of absentee days for _female_ school enrollee aged 6-18 in each household
total_ABS
total # of absentee days for enrollees aged 6-18 in each household
total_ABS_M
total # of absentee days for _male_ school enrollees aged 6-18 in each household
total_ABS_F
total # of absentee days for _female_ school enrollees aged 6-18 in each househo
abs_norm
Absences ages 6-18 normalized by # enrollees
abs_norm_m
Absences ages 6-18 MALES normalized by # enrollees
abs_norm_f
Absences ages 6-18 FEMALES normalized by # enrollees
members_all
Indicator for all members
members_res
Indicator for members residing
members_res_hoh
Indicator for members residing + HOH
members_nostaff
Indicator if hh member but not staff
dep_ratio
Dependency ratio (0-14 and 65+ / 15-64) - all members
dep_ratio_res
Dependency ratio (0-14 and 65+ / 15-64) - residing members only
dep_ratio_res_hoh
Dependency ratio (0-14 and 65+ / 15-64) - residing members + HOH only
water
Primary drinking water source (SI CATEG. USED FOR ANALYSIS)
dw_primary
What is the primary source of drinking water in this household?
improved
Improved Water Source: Primary drinking water
SOURCE
Water Source: Primary drinking water (by WHO category)
Total: 233
Back to Catalog

This site uses cookies to optimize functionality and give you the best possible experience. If you continue to navigate this website beyond this page, cookies will be placed on your browser. To learn more about cookies, click here.