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
29976
Downloads
2427

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

totalChlorine2
WQ Test 2: TOTAL CHLORINE RESULT
colonies2
WQ Test 2: FECAL BACTERIA RESULT (colonies)
waterRisk2
WQ Test 2: FECAL BACT. RISK RATING (0/1)
TminusFree1
TminusFree2
freeChlorine
Free chlorine - cluster (EA) level (1 tested)
totalChlorine
Total chlorine - cluster (EA) level (1 tested)
avg_colonies
Average # fecal bact. colonies - cluster (EA) level (up to 2 tested)
rc_acres
Recode of acres [upper 99th percentile]
aircon
Air Conditioning (quantity)
bajaj
Bajaji (quantity)
bike
Bicycles (quantity)
cddvd
CD/DVD Player (quantity)
vehicle
Car/truck/other motor vehicle (quantity)
cart
Cart (quantity)
comp
Computers (quantity)
fans
Electric/Ceiling Fans (quantity)
boat
Fishing boat or canoe (quantity)
generator
Generators (quantity)
rc_gstove
Recode of gstove [upper 99th percentile]
rc_Rooms
Recode of Rooms [upper 99th percentile]
irons
Irons (Charcoal or electric) (quantity)
lamps
Kerosene lamps/lanterns (quantity)
mobiletel
Mobile telephones (quantity)
mosnet
Mosquito nets
motos
Motorbikes/mopeds/motorcycles (quantity)
ostoves
Other stove (Charcoal) (quantity)
radio
Radio or radio cassette (quantity)
frige
Refrigerators/Freezers (quantity)
sewing
Sewing machines (quantity)
estove
Electric stoves (quantity)
tv
Televisions (quantity)
tractor
Tractor (quantity)
washing
Washing machines (quantity)
wheater
Water heater (quantity)
rc_electricity
Recode of electricity [upper 99th percentile]
FOOD_SHARE
Total food share, monthly, PPP
HHFOOD_SHARE
Total in-home food share, monthly, PPP
rc_ce_pcpd
Recode of ce_pcpd [upper 99th percentile]
rc_hhfood_cons
Recode of hhfood_cons [upper 99th percentile]
rc_outfood_cons
Recode of outfood_cons [upper 99th percentile]
rc_totalfood_cons
Recode of totalfood_cons [upper 99th percentile]
rc_hhfood_cons_ppp
Recode of hhfood_cons_ppp [upper 99th percentile]
rc_outfood_cons_ppp
Recode of outfood_cons_ppp [upper 99th percentile]
rc_totalfood_cons_ppp
Recode of totalfood_cons_ppp [upper 99th percentile]
rc_hhfood_cons_ppp_monthly
Recode of hhfood_cons_ppp_monthly [upper 99th percentile]
rc_outfood_cons_ppp_monthly
Recode of outfood_cons_ppp_monthly [upper 99th percentile]
rc_totalfood_cons_ppp_monthly
Recode of totalfood_cons_ppp_monthly [upper 99th percentile]
rc_hhfood_cons_ppp_pc
Recode of hhfood_cons_ppp_pc [upper 99th percentile]
rc_outfood_cons_ppp_pc
Recode of outfood_cons_ppp_pc [upper 99th percentile]
rc_totalfood_cons_ppp_pc
Recode of totalfood_cons_ppp_pc [upper 99th percentile]
rc_total_nfe_month
Recode of total_nfe_month [upper 99th percentile]
rc_total_nfe_month_ppp
Recode of total_nfe_month_ppp [upper 99th percentile]
rc_total_nfe_month_ppp_pc
Recode of total_nfe_month_ppp_pc [upper 99th percentile]
rc_total_nfe_year
Recode of total_nfe_year [upper 99th percentile]
rc_total_nfe_year_ppp
Recode of total_nfe_year_ppp [upper 99th percentile]
rc_total_nfe_year_ppp_pc
Recode of total_nfe_year_ppp_pc [upper 99th percentile]
rc_CONS_EXP_PPP_PC
Recode of CONS_EXP_PPP_PC [upper 99th percentile]
rc_CONS_EXP_PPP
Recode of CONS_EXP_PPP [upper 99th percentile]
rc_FOOD_EXP_PCPD
Recode of FOOD_EXP_PCPD [upper 99th percentile]
rc_HHFOOD_EXP_PCPD
Recode of HHFOOD_EXP_PCPD [upper 99th percentile]
hhBusiness
Any HH business or self employment during last 12 months (other than agri.)?
busSector
Sector of business
busGrowthL12M
Has business added any equipment or capital stock in the past 12 months?
busGrowthVal
Was addition small, medium, or large relative to tot value of equip or capital s
busInventory
Has business added any additional inventory in past 12 months?
busInventoryVal
Was addition small, medium, or large relative to tot value of inventory in bus?
sourceCapital
What was the main source of start-up capital for this income-generating activity
monthBusL12M
# months during the last 12m business has been operated by a HH mem
busLocatedHH
Is this business located in the household?
rc_totEmployees
Recode of totEmployees [upper 99th percentile]
rc_paidWages
Recode of paidWages [upper 99th percentile]
rc_hh105
Recode of hh105 [upper 99th percentile]
rc_netIncome
Recode of netIncome [upper 99th percentile]
fullTimePerm
# Full-Time Permanent
fullTimeTemp
# Full-Time Temporary
partTimePerm
# Part-Time Permanent
partTimeTemp
# Part-Time Temporary
paidInKind
# Paid In-Kind
famFullTime
# Family Full-time
famPartTime
# Family Part-time
unitNetIncome
Unit (net income)
relyWaterNo
No
relyWaterSelling
Selling water
relyWaterProd
Production
relyWaterCleaning
Cleaning
relyWaterEquip
Running equipment
relyWaterOther
Other
bus_rely_water_other
Specify other
BUS_RELY_WATER
Household business relies on water (sum of ways business uses water, 0-3)
busWaterSourceHH
Does the business and the household use a common source of water?
sharedSource
Which source? (is shared between business and HH)
sharedSource_other
Other specify for sharedSource
WaterUse
Which one uses more water - the business or other uses in the household?
businessMeter
Does your business tap use the same or different meter as your own?
primarySourceBus
Is this (shared source) the primary source of water for the business?
WaterSourceBus
What is the primary source of water for this business?
connection_hh
HH connection status throughout baseline surveying
busWaterQuantity
Amount of water used for business per week
busWaterQuantityUnit
Unit of amount of water used
busWaterQuantityUnit_other
Other specify for busWaterQuantityUnit
bus_often
How often do you obtain water from this source? -99=DK/-97=Refused/-98=NA
bus_often_unit
Unit for frequency of water collection for business
bus_often_unit_other
bus_time
Time to collect
bus_time_unit
Unit for collection time - wet season
bus_price
Amnt usually paid for water from this source (for business). TSH
bus_price_unit
Unit (business water price)
bus_price_unit_other
Other specify for bus_price_unit
BUS_LITERS_WEEKLY
Liters used per week for HH-owned business
BUS_PRICE_PERL
Price per liter paid by HH-owned businesses
BUS_WAT_EXP
Water expenditures per week for household businesses
phone_rounds
Number of phone rounds for each HH
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_Interviewer
Interviewer
PH1_physicalVisit
=1 if phone-rd1 was physical visit to track HH
PH1_timeStart
Time start
PH1_available1
Is the respondent able to speak now?
PH1_appointment
Appointment details
PH1_available2
Is the respondent able to speak now?
PH1_consent
May we continue with this short interview?
PH1_householdMoved
Has the household moved since the last interview?
PH1_stillConnected
Do you still have a tap to the dwelling or plot connected to the public water di
PH1_reasonNotConnected
Why not?
PH1_reasonNotConnected_other
Other specify for reasonNotConnected
PH1_newConnection
Do you now have a tap to the dwelling or plot connected to the public water dist
PH1_shortagesLastWk
To your knowledge, were there any water shortages from this tap in the last week
PH1_otherSource
Specify other source used during last 7 days
PH1_shortageTime
Total time spent by HH in last 7 days collecting water from other sources
PH1_shortageUnit
Unit (time spent collecting water from this other source)
PH1_shortageExp
Total amnt spent on water from other sources during last 7 days (TSH)
PH1_lastBill
What was the amount outstanding on the last bill you received?
PH1_billStart
Bill start month
PH1_billEnd
Bill end month
PH1_mainWaterSource
Main water source
PH1_tripsL7Days
In the last 7 days, how many trips did you take to collect water from this sourc
PH1_quantityL7Days
Amount of water collected in last 7 days
PH1_unitL7Days
Unit of amount collected
PH1_unitL7Days_other
Other specify for unitL7Days
PH1_priceL7Days
How much did you pay for water from this source in last 7 days? TSH
PH1_nt_shortagesLastWk
To your knowledge, were there any water shortages from this source in the last w
PH1_nt_otherSource
Specify other source used during last 7 days
PH1_nt_shortageTime
Total time spent by HH in last 7 days collecting water from other sources
PH1_nt_shortageUnit
Unit (time spent collecting water from this other source)
PH1_nt_shortageExp
Total amnt spent on water from other sources during last 7 days (TSH)
PH1_newChildren
Have any other children under 6 been born or joined the HH since last intv
PH1_newMembers
Have any other members 6 years or above joined the HH since last intv
PH1_timeEnd
Time end
PH1_IntvResult
Interview result
PH1_IntvResult_other
Other specify for IntvResult
PH1_respondent
Select main respondent
PH1_shortageHaul
Minutes spent hauling from other sources due to shortages, last 7 days - Round 1
PH1_shortageSpend
Shillings spent on water from other sources due to shortages, last 7 days - Roun
PH1_expend_wk
Expenditures-water weekly, haul+tap, based on last bill - Round 1
PH1_consume_wk
Vol consumed (liters) weekly, haul+tap, based on last bill - Round 1
PH1_consume_PCPD
Vol consumed (liters) per capita per day, haul+tap, based on last bill - Round 1
PH1_supply_all
Supply from own-taps last 7 days: ordinal var
PH1_days_supply
Supply from own-taps last 7 days, round 1: continuous var
PH1_nt_supply_all
Supply from not-own-taps last 7 days: ordinal var
PH1_nt_days_supply
Supply from not-own-taps last 7 days, round 1: continuous var
ph1_int_start
Interview start date/time, phone survey round 1
round1_hauled
Volume hauled from main source last 7 days (liters) - Round 1
round1_ppliter
Price per liter paid at main source last 7 days - Round 1
round1_expend
Expenditures on water from main source last 7 days - Round 1
month_1
Round 1, Interview Month
connected_tap_1
=1 if has piped cxn (binary), round 1
cubicm_1
Cubic meters billed *monthly* on last utility bill - Round 1
liters_bill_1
Liters billed *monthly* based on last bill - Round 1
liters_bill_1_wk
Liters billed per week (last month's bill), phone round 1
PH2_Interviewer
Interviewer (2)
PH2_timeStart
Time start (2)
PH2_available1
Is the respondent able to speak now?
PH2_appointment
Appointment details
PH2_available2
Is the respondent able to speak now?
PH2_consent
May we continue with this short interview? (2)
PH2_householdMoved
Has the household moved since the last interview?
PH2_stillConnected
Do you still have a tap to the dwelling or plot connected to the public water di
PH2_reasonNotConnected
Why not? (2)
PH2_reasonNotConnected_other
Other specify for PH2_reasonNotConnected
PH2_newConnection
Do you now have a tap to the dwelling or plot connected to the public water dist
PH2_shortagesLastWk
To your knowledge, were there any water shortages from this tap in the last week
PH2_otherSource
Specify other source used during last 7 days
PH2_shortageTime
Total time spent by HH in last 7 days collecting water from other sources
PH2_shortageUnit
Unit (time spent collecting water from this other source)
PH2_shortageExp
Total amnt spent on water from other sources during last 7 days (TSH)
PH2_lastBill
What was the amount outstanding on the last bill you received?
PH2_billStart
Bill start month
PH2_billEnd
Bill end month
PH2_billDiff
Explanation for different bill amount to follow-up 1
PH2_mainWaterSource
Main water source
PH2_tripsL7Days
In the last 7 days, how many trips did you take to collect water from this sourc
PH2_quantityL7Days
Amount of water collected in last 7 days
PH2_unitL7Days
Unit of amount collected
PH2_unitL7Days_other
Other specify for PH2_unitL7Days
PH2_priceL7Days
Amnt usually paid for water from this source. TSH
PH2_nt_shortagesLastWk
To your knowledge, were there any water shortages from this source in the last w
PH2_nt_otherSource
Specify other source used during last 7 days
PH2_nt_shortageTime
Total time spent by HH in last 7 days collecting water from other sources
PH2_nt_shortageUnit
Unit (time spent collecting water from this other source)
PH2_nt_shortageExp
Total amnt spent on water from other sources during last 7 days (TSH)
PH2_newChildren
Have any other children under 6 been born or joined the HH since last call
PH2_newMembers
Have any other members 6 years or above joined the HH since last call
PH2_timeEnd
Time end
PH2_IntvResult
Interview result
PH2_IntvResult_other
Other specify for PH2_IntvResult
PH2_respondent
Select main respondent
PH2_shortageHaul
Minutes spent hauling from other sources due to shortages, last 7 days - Round 2
PH2_shortageSpend
Shillings spent on water from other sources due to shortages, last 7 days - Roun
PH2_expend_wk
Expenditures-water weekly, haul+tap, based on last bill - Round 2
PH2_consume_wk
Vol consumed (liters) weekly, haul+tap, based on last bill - Round 2
PH2_consume_PCPD
Vol consumed (liters) per capita per day, haul+tap, based on last bill - Round 2
PH2_supply_all
Supply from own-taps last 7 days: ordinal var
PH2_days_supply
Supply from own-taps last 7 days, round 2: continuous var
PH2_nt_supply_all
Supply from not-own-taps last 7 days: ordinal var
PH2_nt_days_supply
Supply from not-own-taps last 7 days, round 2: continuous var
ph2_int_start
Interview start date/time, phone survey round 2
round2_hauled
Volume hauled from main source last 7 days (liters) - Round 2
round2_ppliter
Price per liter paid at main source last 7 days - Round 2
round2_expend
Expenditures on water from main source last 7 days - Round 2
month_2
Round 2, Interview Month
connected_tap_2
=1 if has piped cxn (binary), round 2
cubicm_2
Cubic meters billed *monthly* on last utility bill - Round 2
liters_bill_2
Liters billed *monthly* based on last bill - Round 2
liters_bill_2_wk
Liters billed per week (last month's bill), phone round 2
PH3_Interviewer
Interviewer (3)
PH3_timeStart
Time start (3)
PH3_available1
Is the respondent able to speak now?
PH3_appointment
Appointment details
PH3_available2
Is the respondent able to speak now?
PH3_consent
May we continue with this short interview? (3)
PH3_householdMoved
Has the household moved since the last interview?
PH3_stillConnected
Do you still have a tap to the dwelling or plot connected to the public water di
PH3_reasonNotConnected
Why not? (3)
PH3_reasonNotConnected_other
Other specify for PH3_reasonNotConnected
PH3_newConnection
Do you now have a tap to the dwelling or plot connected to the public water dist
PH3_shortagesLastWk
To your knowledge, were there any water shortages from this tap in the last week
PH3_otherSource
Specify other source used during last 7 days
PH3_shortageTime
Total time spent by HH in last 7 days collecting water from other sources
PH3_shortageUnit
Unit (time spent collecting water from this other source)
PH3_shortageExp
Total amnt spent on water from other sources during last 7 days (TSH)
PH3_lastBill
What was the amount outstanding on the last bill you received?
PH3_billStart
Bill start month
PH3_billEnd
Bill end month
PH3_billDiff
Explanation for different bill amount to follow-up 1 or 2
PH3_daysWater
How many days per week do you usually get water from the network? (In this seaso
PH3_hoursWater
On those days, for how many hours does water flow? (Rounded half hour)
PH3_mainWaterSource
Main water source
PH3_tripsL7Days
In the last 7 days, how many trips did you take to collect water from this sourc
PH3_quantityL7Days
Amount of water collected in last 7 days
PH3_unitL7Days
Unit of amount collected
PH3_priceL7Days
Amnt usually paid for water from this source. TSH
PH3_nt_shortagesLastWk
To your knowledge, were there any water shortages from this source in the last w
PH3_nt_otherSource
Specify other source used during last 7 days
PH3_nt_shortageTime
Total time spent by HH in last 7 days collecting water from other sources
PH3_nt_shortageUnit
Unit (time spent collecting water from this other source)
PH3_nt_shortageExp
Total amnt spent on water from other sources during last 7 days (TSH)
PH3_newChildren
Have any other children under 6 been born or joined the HH since last call
PH3_newMembers
Have any other members 6 years or above joined the HH since last call
PH3_timeEnd
Time end
PH3_IntvResult
Interview result
PH3_IntvResult_other
Other specify for PH3_IntvResult
PH3_respondent
Select main respondent
PH3_shortageHaul
Minutes spent hauling from other sources due to shortages, last 7 days - Round 3
PH3_shortageSpend
Shillings spent on water from other sources due to shortages, last 7 days - Roun
PH3_expend_wk
Expenditures-water weekly, haul+tap, based on last bill - Round 3
PH3_consume_wk
Vol consumed (liters) weekly, haul+tap, based on last bill - Round 3
PH3_consume_PCPD
Vol consumed (liters) per capita per day, haul+tap, based on last bill - Round 3
PH3_supply_all
Supply from own-taps last 7 days: ordinal var
PH3_days_supply
Supply from own-taps last 7 days, round 3: continuous var
PH3_nt_supply_all
Supply from not-own-taps last 7 days: ordinal var
PH3_nt_days_supply
Supply from not-own-taps last 7 days, round 3: continuous var
ph3_int_start
Interview start date/time, phone survey round 3
round3_hauled
Volume hauled from main source last 7 days (liters) - Round 3
round3_ppliter
Price per liter paid at main source last 7 days - Round 3
round3_expend
Expenditures on water from main source last 7 days - Round 3
month_3
Round 3, Interview Month
connected_tap_3
=1 if has piped cxn (binary), round 3
cubicm_3
Cubic meters billed *monthly* on last utility bill - Round 3
liters_bill_3
Liters billed *monthly* based on last bill - Round 3
liters_bill_3_wk
Liters billed per week (last month's bill), phone round 3
AVAILABLE
Days water is usually available through tap, current season
EA_Mean_1
Round 1: Cluster mean of shortage days
EA_Var_1
Round 1: Cluster variance of shortage days
EA_n_1
Round 1: Cluster n surveyed in this round (not just shortages)
EA_Mean_2
Round 2: Cluster mean of shortage days
EA_Var_2
Round 2: Cluster variance of shortage days
EA_n_2
Round 2: Cluster n surveyed in this round (not just shortages)
EA_Mean_3
Round 3: Cluster mean of shortage days
EA_Var_3
Round 3: Cluster variance of shortage days
EA_n_3
Round 3: Cluster n surveyed in this round (not just shortages)
nt_EA_Mean_1
Round 1: Cluster mean of shortage days (not-own-tap)
nt_EA_Var_1
Round 1: Cluster variance of shortage days (not-own-tap)
nt_EA_n_1
Round 1: Cluster n surveyed in this round (not just shortages) (not-own-tap)
nt_EA_Mean_2
Round 2: Cluster mean of shortage days (not-own-tap)
nt_EA_Var_2
Round 2: Cluster variance of shortage days (not-own-tap)
nt_EA_n_2
Round 2: Cluster n surveyed in this round (not just shortages) (not-own-tap)
nt_EA_Mean_3
Round 3: Cluster mean of shortage days (not-own-tap)
nt_EA_Var_3
Round 3: Cluster variance of shortage days (not-own-tap)
Total: 621
Back to Catalog