Home / Central Data Catalog / TZA_2013_MCC-WS_V01_M
central

Water Sector 2013

Tanzania, 2013
Get Microdata
Reference ID
TZA_2013_MCC-WS_v01_M
Producer(s)
Social Impact, Inc.
Metadata
DDI/XML JSON
Created on
Jul 07, 2015
Last modified
Mar 29, 2019
Page views
28554
Downloads
2426

Data file: HH_Anonymized_18032015

This dataset contains household-level data, collected using the Household Survey instrument and the Phone Survey. 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: 5001
Variables: 621

Variables

uniqueid
Unique Household ID
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)
Stratum
Stratum, Cluster Sample (Dar only)
n_EA_frame
Number of EAs in the stratum frame
NoHHListed
Number of households listed in the cluster (EA)
SAMP_WEIGHT
Sampling weight for HH (1/(PSU_prob*SSU_prob))
Supplying_Plant
Plant which supplies this ward (Dar only) if applicable
Lower_Ruvu
Ward served by Lower Ruvu plant
replacement
ID of (non-responding) household replaced by this surveyed HH
Interviewer
Interviewer ID
Consent
Do you understand these conditions and are you willing to participate?
NumVisits
Number of visits required to complete the interview
IntvResult
Result - First visit
IntvResult_other
Other specify for IntvResult
ReasonPartCompleted
Why is the interview not completed?
IntvResult2
Interview result second visit
IntvLanguage
Language used for majority of survey
InterviewStart
Date and time of interview start
IntvEnd
Date and time of interview end
InterviewResume
Date and time of interview resumption (if applicable)
IntvResumeEnd
Date and time of interview finish (second session)
int_start
Interview Start Time - Encoded
int_end
Interview End Time - Encoded
int_resume
Interview Resume Start Time - Encoded
int_rend
Interview Resume End Time - Encoded
int_dur1
Duration of Interviews Complete in Visit 1
int_dur2
Duration of Interviews Complete in Visit 2
interv_duration
Duration of Interviews (HH:MM)
str_duration
Interview Duration (String - Use to tabulate)
dur_minutes
INTERVIEW DURATION (MINUTES)
duration_outlier
Interview <45 min or >150 min (manually defined outlier)
Respondent
Respondent indicator (1) used for merging
respondent1
Main respondent - roster ID
educat
Head of household: highest education - categorical
OthersPresent
Other individuals present during survey?
respondent2
Second respondent present - roster ID
respondent3
Third respondent present - rosterID
respondent_SEX
Respondent: Sex
respondent_AGE_YEARS
Respondent: Age (yrs)
respondent_REL_HEAD
Respondent: Relationship to HOH
respondent_EDUC
Respondent: Highest level of education
HOH_RESIDING
Head of HH: Currently resides in HH
HOH_SEX
Head of HH: Sex
HOH_AGE_YEARS
Head of HH: Age (yrs)
HOH_AGE_GROUP_by5
Head of HH: Age group categories by 5 year increments
HOH_MARITAL
Head of HH: Marital Status - age 12+
HOH_EDUC
Head of HH: Highest level of education
HOH_LIT_kiswahili
Head of HH: Literacy in Kiswahili (read/write)
HOH_LIT_english
Head of HH: Literacy in English (read/write)
HOH_EMPL_STATUS
Head of HH: Employment status
HOH_DIARRHEA
Head of HH: Diarrhea in the last 14 days? (at least 3 watery stools per day)
HOH_EMPL_FORMAL
Head of HH: Paid Employee
HOH_EMPL_SELF
Head of HH: Self-employed
HOH_EMPL_FORM_SELF
Head of HH: Paid employee or self-employed
HOH_EMPL_SECONDARY
Head of HH: Works additional secondary job
HOH_UNEMPL
Head of HH: Unemployed
HOH_HRS_EMPL
Head of HH: Hours worked in formal/informal/self emplmt, weekly
HOH_HRS_HOME
Head of HH: Hours worked in the home, weekly
HOH_HRS_SEC
Head of HH: Hours worked in secondary work, weekly
HOH_HRS_WORKED
Head of HH: Total hours worked, weekly (adults: formal/informal/self/home/sec)
new_fullbaseline
HH's status relative to mini-survey (Mor only)
OtherMembersApril
Is there any person who was a member of the household in April that is no longer
under6YN
Are there any children 5 years or younger in this household?
deathsL6mnths
Has there been any death of a household member in the past 6 months?
rc_hh_size
Recode of hh_size [upper 99th percentile]
rc_hh_size_res
Recode of hh_size_res [upper 99th percentile]
rc_hh_size_res_hoh
Recode of hh_size_res_hoh [upper 99th percentile]
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
over18illness
Any member over 18 missed school or work due to diarrhea in last 14 days?
HHCommYrs
#Years household has lived together in community
HHCommMnths
#Months household has lived together in community
HHCommWks
#Weeks household has lived together in community
TenureStatus
What is the ownership status at this dwelling?
TenureStatus_other
Other specify for TenureStatus
build_type
What type of building is this?
wall_mat
The walls of the main dwelling are made mainly of what materials?
roof_mat
The roof of the main dwelling is made mainly of what materials?
floor_mat
The floor of the main dwelling is made mainly of what materials?
sewer_conn
Does your household have a municipal sewer connection?
sewer_reason
What is the main reason you do not have a sewer connection?
toilet_type
Which type of toilet do you primarily use in this household?
handle_sewage
How do you handle sewage from your toilet?
share_latrine
Does this household share a latrine with other households?
cook_fuel
In this household, what is the major fuel used for cooking?
light_fuel
In this household, what is the major fuel used for lighting?
electr_access
Access to electricity (lighting/cooking/expenditures)
personroom
Persons per sleeping room
index_cont_dar
Scores for component 1
ses_Dar
SES quintiles Dar PCA (quantities of assets)
index_cont_mor
Scores for component 1
ses_Mor
SES quintiles Mor PCA (quantities of assets)
ses_combined
SES quintiles - PCA asset index - Dar, Mor combined (USED BY JA MODELS)
quint_cepcpd_Dar
5 quantiles of ce_pcpd
quint_cepcpd_Mor
5 quantiles of ce_pcpd
quint_CE_all
Quintiles of CE per capita per day (USED TO DISAGGREGATE)
toilet_new
Main toilet type (USED TO DISAGGREGATE)
p125
Per capita expenditures <$1.25PPP per day
p250
Per capita expenditures <$2.50PPP per day
p155
Per capita expenditures <$1.55PPP per day
pipedWater
Piped water connection? (Dwelling, plot, none)
piped_any
Piped water connection: 1=Yes 0=No
piped_network
Piped water connection to public network: 1=Yes 0=No (among connected)
network
Household connected to public network: 1=Yes 0=No (all HHs)
pipedWaterSource
What is the source of your piped water?
pipedWaterSource_other
Other specify for pipedWaterSource
reasonNotConnected
Main reason not conn pub ntwk (Mistake enablmt: piped_any=1 & piped_network=0)
compWater
Compared to the past month, is the current water cleaner?
connectionStatus
What is the current status of the connection?
meterWorking
Is your meter currently working?
shareBill
Do you share your bill with other households?
totShareBill
How many other households share this meter?
receiveBills
Do you receive water bills from [DAWASCO / MORUWASA]?
utilityPaidBill
Has [MORUWASA / DAWASCO] ever paid your bill?
freqBills
How often do you receive water bills from [DAWASCO / MORUWASA]?
combinedBill
Does your household pay for sewerage and water together?
accurateBill
In your opinion, was the last water bill accurate?
sellWater
Do you sell water to others from this tap?
paysBill
Who pays your water bill?
paysBill_other
Other specify for paysBill
utilityBill
On average, how much is paid to the utility per month for your water?
rationingWet
How often do you experience water rationing in the wet season?
rationingDry
How often do you experience rationing in the dry season?
water
Primary drinking water source (SI CATEG. USED FOR ANALYSIS)
nonPipedMainSource
Most freq used source (among HHs with access to neigh/public tap/vendor/kiosk/ta
storageTank
Do you have a storage tank?
tankCapacity
How many liters of water does the storage tank hold?
dw_primary
What is the primary source of drinking water in this household?
dw_prim_treat
Do you treat the water from your primary source before drinking?
dw_prim_treatMethod
Most common method of treating water from primary source
dw_prim_none
Other water treatment: none
dw_prim_boil
Other treatment method: Boil
dw_prim_chlorine
Other treatment method: Water Guard, Bleach, Chlorine
dw_prim_strain
Other water treatment: Filter through a cloth
dw_prim_waterFilter
Other treatment method: Water filter
dw_prim_solarDisinfection
Other wate treatment: Solar Disinfection
dw_prim_stand
Other water treatment: Let Stand and Settle
dw_prim_aluSulphate
Other water treatment: Aluminium Sulphate
dw_secondary
Other source used for drinking water when cannot get water from main source.
dw_sec_times
No. times in last 30 days got drinking water from this other source
dw_sec_treat
Do you treat the water from your secondary source before drinking?
dw_sec_treatMethod
Most common method of treating water from secondary source
dw_sec_none
Other water treatment: none
dw_sec_boil
Other treatment method: Boil
dw_sec_chlorine
Other treatment method: Water Guard, Bleach, Chlorine
dw_sec_strain
Other water treatment: Filter through a cloth
dw_sec_waterFilter
Other treatment method: Water filter
dw_sec_solarDisinfection
Other wate treatment: Solar Disinfection
dw_sec_stand
Other water treatment: Let Stand and Settle
dw_sec_aluSulphate
Other water treatment: Aluminium Sulphate
treatWater
In general, how often do you treat non-bottled/bagged water before giving to chi
boil
Water treatment method (children): boil
chlorine
Water treatment method (children): Water Guard, Bleach, Chlorine
strain
Water treatment method (children): Filter through a cloth
waterFilter
Water treatment method (children): Water filter
solarDisinfection
Water treatment method (children): Solar Disinfection
stand
Water treatment method (children): Let Stand and Settle
aluSulphate
Water treatment method (children): Aluminium Sulphate
storeWater
Do you usually store or reserve drinking water in the household, excluding bottl
storeWaterNow
Are you stocking drinking water in the home at this moment?
waterRetrieved
When was this water retrieved?
storeContainer
When was the water put in this container?
piped
HH reported access to source: piped
neighbor
HH reported access to source: neighbor
pubtap
HH reported access to source: pubtap
kiosk
HH reported access to source: kiosk
vendor
HH reported access to source: vendor
tanker
HH reported access to source: tanker
borehole
HH reported access to source: borehole
protwell
HH reported access to source: protwell
unprotwell
HH reported access to source: unprotwell
rainwater
HH reported access to source: rainwater
bottled
HH reported access to source: bottled
surface
HH reported access to source: surface
protspring
HH reported access to source: protspring
unprotspring
HH reported access to source: unprotspring
pipebusiness
HH reported access to source: pipebusiness
other
HH reported access to source: other
bagged
HH reported access to source: bagged
TAP_ONLY
HH relies on tap water exclusively for all HH activities
otherWaterSource
Specify other from HHWaterSource module - source of water used for any activity
SOURCE
Primary DW source (categories) - WHO classification
improved
Primary DW from improved water source (1/0) - WHO classification
HAUL_WET
Time (minutes) spent hauling, weekly, wet season
HAUL_DRY
Time (minutes) spent hauling, weekly, dry season
cubicm
Cubic meters billed on avg utility bill
LITERS_BILL
Liters billed avg monthly (using bill & tariffs)
LITERS_BILL_WK
Liters billed (by utility) per week, avg monthly bill
billwk
Utility bill payment - weekly (utilityBill/4)
VOL_WEEK_WET
Liters hauled weekly, wet season (excludes tap)
VOL_WEEK_DRY
Liters hauled weekly, dry season (excludes tap)
VOL_WEEK_WET_PC
Volume hauled weekly (L) per capita, wet season, HH level
VOL_WEEK_DRY_PC
Volume hauled weekly (L) per capita, dry season, HH level
VOL_CONS_WET
Consumption: weekly liters, wet season (haul+piped)
VOL_CONS_DRY
Consumption: weekly liters, dry season (haul+piped)
LITERS_PC_PD_WET
Consumption: liters per capita/day, wet season (haul+piped)
LITERS_PC_PD_DRY
Consumption: liters per capita/day, dry season (haul+piped)
EXPEND_WET
Water expenditures (TSH) weekly, wet season (excludes tap)
EXPEND_DRY
Water expenditures (TSH) weekly, dry season (excludes tap)
EXP_TOT_WET
Water expenditures (TSH) weekly, wet season (haul+piped)
EXP_TOT_DRY
Water expenditures (TSH) weekly, dry season (haul+piped)
EXP_TOT_WET_PC
Water expenditures (TSH) per capita weekly, wet season (haul+piped)
EXP_TOT_DRY_PC
Water expenditures (TSH) per capita weekly, dry season (haul+piped)
SEASON
HH response: [What is current season?] (partly reconciled incorrect enablemt)
shortagesLastWk
Any water shortages or rationing from your tap/main-source in the last week
hours_unavail
Hours per week water not available among HH reporting shortage
hrs_wk
Hours per week of access (needs to be combined with -no- shortage responses)
days_wk
Days per week - USE FOR STATS (needs to be combined with -no- shortage responses
days_per_week
Days per week, 8 categories (needs to be combined with -no- shortage responses)
V218
HOURS/WK of supply (based on shortage reports)
V219
DAYS/WK of supply (based on shortage reports) USE FOR STATS
SUPPLY_DAYS
DAYS/WK of supply (based on shortage reports) (Ordinal var)
shortage_secondary
HH sought secondary source due to a shortage last 7 days
otherSource
Specify other source used during last 7 days
shortage6
Total time spent by HH in last 7 days collecting water from other sources
shortage6unit
Unit (time spent collecting water from this other source)
shortage7
Total amnt spent on water from other sources during last 7 days (TSH)
shortageused_neighbor
HH during shortageused_neighbor
shortageused_pubtap
HH during shortageused_pubtap
shortageused_kiosk
HH during shortageused_kiosk
shortageused_vendor
HH during shortageused_vendor
shortageused_tanker
HH during shortageused_tanker
shortageused_borehole
HH during shortageused_borehole
shortageused_protwell
HH during shortageused_protwell
shortageused_unprotwell
HH during shortageused_unprotwell
shortageused_rainwater
HH during shortageused_rainwater
shortageused_bottled
HH during shortageused_bottled
shortageused_surface
HH during shortageused_surface
shortageused_protspring
HH during shortageused_protspring
shortageused_unprotspring
HH during shortageused_unprotspring
shortageused_other
HH during shortageused_other
SHORTAGE_COLL_MIN
Time spent collecting water last 7 days due to shortage (minutes)
Shock_1st
Most Severe shock
Shock_2nd
Second Most Severe shock
Shock_3rd
Third Most Severe shock
shock_1_drought
Drought
shock_2_flood
Floods
shock_3_cropdisease
Crop disease or crop pests
shock_4_livestock
Livestock died or were stolen
shock_5_cropfail
Severe food shortage from crop failure (famine)
shock_6_busfail
Household business failure, non-agricultural
shock_7_lossemploy
Loss of salaried employment or non-payment of salary
shock_8_cropprice
Large fall in sale prices for crops
shock_9_foodprice
Large rise in price of food
shock_10_inputprice
Large rise in agricultural input prices
shock_11_landloss
Loss of land
shock_12_illness
Chronic/severe illness or accident of household member
shock_13_hhdeath
Death of a member of household
shock_14_famdeath
Death of other family member
shock_15_hhbreakup
Break-up of the household
shock_18_robbery
Hijacking/Robbery/burglary/assault
shock_20_watershock
Severe water shock
shock_OTHER
Recode: Collapsed rare/private shocks into one category
shock_sum
Sum of shocks reported by HH (last 2 yrs)
shock_any
Indicator: HH reported any shock (last 2 yrs)
worried_water_adequate
Worried whether adequate water supply for HH, in last 30 days?
worried_water_days_last30
1 shockDays
rc_DIARR_SPENT_HH
Recode of DIARR_SPENT_HH [upper 99th percentile]
wellbeingLife
All things considered, how satisfied are you with your life as a whole nowadays?
wellbeingHealth
Your health:
wellbeingFinancial
Your financial situation
wellbeingHousing
Your housing
wellbeingJob
Employment situation
wellbeingHealthCare
The health care available for members of your household
wellbeingEduHH
The schooling available for members of your household
mealsPerDay7
During the last 7 days, how many meals did your household normally have per day?
mealsPerDay30
During the last 30 days, how many meals did your household normally have per day
Eligible
Confirm: Does hh have tap connected to public distribution network?
wt_consent
Respondent consents to test
hhWaterTest
Tick to confirm household has been selected for water quality testing
wt_startTime
Water test start time
wt_tapLocation
Location of Tap
wt_waterRunning
Is there water running from the tap?
wt_notes
Useful info regarding rationing schedule or known water shortages for next few d
wt_waterSample
Water Sample Taken
wt_containerA
Test Container # (A)
wt_containerB
Test Container # (B)
rust
Rust on spout/nozzle
slime
Black slime on spout/nozzle
leaking
Leaking
wt_endTime
Water sample collection end time (for household)
hhold_comm1
1 hhold_comm
HHID1
WQ Test 1: HHID
chlorine1
WQ Test 1: chlorine tested (yes/no)
freeChlorine1
WQ Test 1: FREE CHLORINE RESULT
totalChlorine1
WQ Test 1: TOTAL CHLORINE RESULT
colonies1
WQ Test 1: FECAL BACTERIA RESULT (colonies)
waterRisk1
WQ Test 1: FECAL BACT. RISK RATING (0/1)
hhold_comm2
2 hhold_comm
HHID2
WQ Test 2: HHID
chlorine2
WQ Test 2: chlorine tested (yes/no)
freeChlorine2
WQ Test 2: FREE CHLORINE RESULT
Total: 621
Back to Catalog