Generates cleaning log
create_cleaning_log.RdGenerates cleaning log
Usage
create_cleaning_log(
raw_dataset,
raw_dataset_uuid_column = "uuid",
clean_dataset = clean_dataset,
clean_dataset_uuid_column = "uuid",
check_for_deletion_log = T,
columns_not_to_check = NULL,
check_for_variable_name = T
)Arguments
- raw_dataset
Raw dataset
- raw_dataset_uuid_column
uuid column in the raw dataset. Default is "uuid".
- clean_dataset
Clean dataset
- clean_dataset_uuid_column
uuid column in the raw dataset. Default is "uuid".
- check_for_deletion_log
TRUE to flag the removed survey
- columns_not_to_check
Columns to exclude from the checks
- check_for_variable_name
TRUE to flag the removed variables
Examples
log <- create_cleaning_log( raw_dataset = cleaningtools::cleaningtools_raw_data,
raw_dataset_uuid_column = "X_uuid",
clean_dataset = cleaningtools::cleaningtools_clean_data,
clean_dataset_uuid_column = "X_uuid",
check_for_deletion_log = TRUE,
check_for_variable_name = TRUE)
#> X.U.FEFF.start
#> date_assessment
#> deviceid
#> enumerator_num
#> neighbourhood
#> consent_remote
#> hhh_r
#> will_to_response_r
#> age_respondent_r
#> age_hoh
#> gender_hoh
#> displace_status
#> displace_status_returnee
#> num_hh_member
#> hh_hosting
#> hh_hosted
#> shelter_occupation
#> shelter_occupation_other
#> property_title
#> rental_contract
#> inc_employment_pension
#> primary_livelihood
#> primary_livelihood.savings
#> primary_livelihood.employment
#> primary_livelihood.remittences
#> primary_livelihood.retirement_fund
#> primary_livelihood.income_renting
#> primary_livelihood.selling_assets
#> primary_livelihood.selling_assisantance
#> primary_livelihood.loans
#> primary_livelihood.modm
#> primary_livelihood.support
#> primary_livelihood.ngo
#> primary_livelihood.social_service
#> primary_livelihood.illegal
#> primary_livelihood.zakat
#> primary_livelihood.other
#> primary_livelihood.dont_know
#> primary_livelihood.prefer_not_answer
#> primary_livelihood.own_business
#> primary_livelihood_other
#> type_employment
#> water_sources
#> water_sources.piped
#> water_sources.tap
#> water_sources.well
#> water_sources.bottled
#> water_sources.trucking
#> water_sources.spring
#> water_sources.rainwater
#> water_sources.surface
#> water_sources.other
#> water_sources.dont_know
#> water_source_drinking
#> treat_drink_water_how
#> treat_drink_water_how.boil
#> treat_drink_water_how.let_stand
#> treat_drink_water_how.use_chlorine
#> treat_drink_water_how.other
#> treat_drink_water_how.dont_know
#> water_source_cook
#> treat_cook_water
#> treat_cook_water_how
#> treat_cook_water_how.boil
#> treat_cook_water_how.let_stand
#> treat_cook_water_how.expose_sunlight
#> treat_cook_water_how.use_chlorine
#> treat_cook_water_how.filter
#> treat_cook_water_how.other
#> treat_cook_water_how.dont_know
#> piped_quality
#> piped_quality.acceptable
#> piped_quality.unacceptable_taste
#> piped_quality.unacceptable_colour
#> piped_quality.unacceptable_smell
#> piped_quality.materials
#> piped_quality.no_other
#> piped_quality.dont_know
#> tap_quality
#> tap_quality.acceptable
#> tap_quality.unacceptable_taste
#> tap_quality.unacceptable_colour
#> tap_quality.unacceptable_smell
#> tap_quality.materials
#> tap_quality.no_other
#> tap_quality.dont_know
#> borehole_quality
#> borehole_quality.acceptable
#> borehole_quality.unacceptable_taste
#> borehole_quality.unacceptable_colour
#> borehole_quality.unacceptable_smell
#> borehole_quality.materials
#> borehole_quality.no_other
#> borehole_quality.dont_know
#> trucking_quality
#> trucking_quality.acceptable
#> trucking_quality.unacceptable_taste
#> trucking_quality.unacceptable_colour
#> trucking_quality.unacceptable_smell
#> trucking_quality.materials
#> trucking_quality.no_other
#> trucking_quality.dont_know
#> water_source_bath
#> water_source_clothes
#> water_source_house
#> own_animals
#> water_source_animals
#> cultivate_crops
#> water_source_crops
#> days_available_piped
#> days_available_tap
#> days_available_borehole
#> days_available_trucking
#> hours_available_piped
#> hours_available_tap
#> hours_available_borehole
#> hours_available_trucking
#> satisfaction_piped
#> satisfaction_tap
#> satisfaction_borehole
#> satisfaction_bottled
#> satisfaction_trucking
#> spend_piped
#> spend_borehole
#> spend_bottled
#> spend_trucking
#> water_tank
#> water_tank_nb_sharing
#> water_tank_litres
#> water_tank_consent
#> water_tank_shape
#> water_tank_height
#> water_tank_diameter
#> water_tank_obs_number
#> tank_store_piped
#> tank_store_tap
#> tank_store_borehole
#> tank_store_trucking
#> tank_fill_piped
#> tank_fill_tap
#> tank_fill_borehole
#> tank_fill_trucking
#> tank_emptied
#> bottle_volume
#> bottles_per_week
#> pump_horsepower
#> pump_days
#> pump_hours
#> pump_connection_piped_sys
#> responsible_collect_water
#> seasonal_variation
#> air_coolers
#> air_coolers_hours
#> access_water_enough
#> access_water_enough_why_not
#> access_water_enough_why_not.not_enough_hours
#> access_water_enough_why_not.amount_not_enough
#> access_water_enough_why_not.inconvenient_hours
#> access_water_enough_why_not.supply_inconsistent
#> access_water_enough_why_not.too_expensive
#> access_water_enough_why_not.quality_poor
#> access_water_enough_why_not.water_pressure
#> access_water_enough_why_not.sources_closed
#> access_water_enough_why_not.not_available_shops
#> access_water_enough_why_not.tank_capacity
#> access_water_enough_why_not.points_difficult_reach
#> access_water_enough_why_not.some_groups_no_access
#> access_water_enough_why_not.other
#> access_water_enough_why_not.dont_know
#> access_water_enough_why_not.prefer_not_answer
#> access_water_enough_why_not_other
#> money_coping_strategy_water
#> water_system_connection
#> connection_fees
#> pay_water_charges_when
#> pay_water_charges_last
#> pay_water_charges_method
#> pay_water_charges_prefer
#> pay_water_charges_why_not
#> pay_water_charges_why_not_other
#> value_water_service
#> pay_more_water_service
#> water_meter_know
#> water_meter_willing
#> why_share_connection
#> why_share_connection.cannot_afford
#> why_share_connection.legal_status_property
#> why_share_connection.legal_status_hh
#> why_share_connection.paperwork
#> why_share_connection.not_worth
#> why_share_connection.government_responsibility
#> why_share_connection.civil_docs
#> why_share_connection.staff_refused
#> why_share_connection.other
#> why_share_connection.dont_know
#> why_share_connection.prefer_not_answer
#> why_no_subscription
#> why_no_subscription.cannot_afford
#> why_no_subscription.legal_status_property
#> why_no_subscription.legal_status_hh
#> why_no_subscription.paperwork
#> why_no_subscription.not_worth
#> why_no_subscription.government_responsibility
#> why_no_subscription.civil_docs
#> why_no_subscription.staff_refused
#> why_no_subscription.other
#> why_no_subscription.dont_know
#> why_no_subscription.prefer_not_answer
#> own_subscription_want
#> own_subscription_assist
#> own_subscription_assist_type
#> own_subscription_assist_type.paperwork
#> own_subscription_assist_type.legalising_property
#> own_subscription_assist_type.civil_docs
#> own_subscription_assist_type.dealing_staff
#> own_subscription_assist_type.paying
#> own_subscription_assist_type.other
#> own_subscription_assist_type.dont_know
#> problems_water
#> problems_water_who_appr
#> problems_water_who_appr.nobody
#> problems_water_who_appr.water_office
#> problems_water_who_appr.municipal_staff
#> problems_water_who_appr.community_rep
#> problems_water_who_appr.ninewa_dow
#> problems_water_who_appr.ngo
#> problems_water_who_appr.plumber
#> problems_water_who_appr.other
#> problems_water_who_appr.dont_know
#> problems_water_who_appr.prefer_not_answer
#> problems_water_who_appr_not
#> problems_water_who_appr_not_other
#> problems_water_action
#> problems_water_time
#> problems_water_who_attend
#> problems_water_who_attend.nobody
#> problems_water_who_attend.water_office
#> problems_water_who_attend.municipal_staff
#> problems_water_who_attend.community_rep
#> problems_water_who_attend.ninewa_dow
#> problems_water_who_attend.ngo
#> problems_water_who_attend.plumber
#> problems_water_who_attend.other
#> problems_water_who_attend.dont_know
#> problems_water_who_attend.prefer_not_answer
#> problems_water_main_complaint
#> problems_water_main_complaint_other
#> leaks
#> leaks_reported
#> level_service
#> level_service_why_poor
#> level_service_why_poor_other
#> regularity_supply
#> water_office_receptiveness
#> water_supply_before_2014
#> water_supply_rest_neighbourhood
#> water_supply_other_neighbourhoods
#> water_supply_other_neighbourhoods_how
#> water_supply_other_neighbourhoods_how.less_hours_days
#> water_supply_other_neighbourhoods_how.smaller_quantity
#> water_supply_other_neighbourhoods_how.hours_less_inconvenient
#> water_supply_other_neighbourhoods_how.charges_higher
#> water_supply_other_neighbourhoods_how.quality_poorer
#> water_supply_other_neighbourhoods_how.pressure_lower
#> water_supply_other_neighbourhoods_how.infrastructure_poorer
#> water_supply_other_neighbourhoods_how.less_infrastructure
#> water_supply_other_neighbourhoods_how.other
#> water_supply_other_neighbourhoods_how.prefer_not_answer
#> water_supply_other_neighbourhoods_why
#> majority_pay
#> water_office_fixes_leaks
#> water_office_maintains
#> received_outreach
#> trust_water_office
#> trust_water_office_why_not
#> users_build_trust
#> users_build_trust.nothing
#> users_build_trust.pay_bills
#> users_build_trust.report_leaks
#> users_build_trust.conserve_water
#> users_build_trust.other
#> users_build_trust.dont_know
#> users_build_trust.prefer_not_answer
#> suggestions_improve_services
#> suggestions_improve_services.increase_hours
#> suggestions_improve_services.hours_more_convenient
#> suggestions_improve_services.improve_quality
#> suggestions_improve_services.reduce_price
#> suggestions_improve_services.increase_pressure
#> suggestions_improve_services.improve_infrastructure
#> suggestions_improve_services.new_infrastructure
#> suggestions_improve_services.extend_network
#> suggestions_improve_services.repair_leaks
#> suggestions_improve_services.other
#> suggestions_improve_services.dont_know
#> suggestions_improve_services.prefer_not_answer
#> suggestions_improve_services_other
#> help_office_improve
#> help_office_improve.cannot_help
#> help_office_improve.pay_bills
#> help_office_improve.report_leaks
#> help_office_improve.conserve_water
#> help_office_improve.other
#> help_office_improve.dont_know
#> help_office_improve.prefer_not_answer
#> how_engaged_by_office
#> how_engaged_by_office.prefer_not_engaged
#> how_engaged_by_office.face_to_face_home
#> how_engaged_by_office.face_to_face_office
#> how_engaged_by_office.community_rep
#> how_engaged_by_office.phone
#> how_engaged_by_office.sms
#> how_engaged_by_office.email
#> how_engaged_by_office.letter
#> how_engaged_by_office.twitter
#> how_engaged_by_office.facebook
#> how_engaged_by_office.whatsapp
#> how_engaged_by_office.complaints_box
#> how_engaged_by_office.billboards
#> how_engaged_by_office.posters
#> how_engaged_by_office.leaflets
#> how_engaged_by_office.other
#> how_engaged_by_office.prefer_not_answer
#> prefer_not_engage
#> prefer_not_engage_other
#> consent_telephone_number
#> consent_share_location
#> X_id
#> X_notes
#> X.U.FEFF.start
#> date_assessment
#> deviceid
#> enumerator_num
#> neighbourhood
#> consent_remote
#> hhh_r
#> will_to_response_r
#> age_respondent_r
#> age_hoh
#> gender_hoh
#> displace_status
#> displace_status_returnee
#> return_date
#> num_hh_member
#> hh_hosting
#> num_hh_hosting
#> hh_hosted
#> shelter_occupation
#> shelter_occupation_other
#> property_title
#> rental_contract
#> inc_employment_pension
#> tot_expenses
#> primary_livelihood
#> primary_livelihood.savings
#> primary_livelihood.employment
#> primary_livelihood.remittences
#> primary_livelihood.retirement_fund
#> primary_livelihood.income_renting
#> primary_livelihood.selling_assets
#> primary_livelihood.selling_assisantance
#> primary_livelihood.loans
#> primary_livelihood.modm
#> primary_livelihood.support
#> primary_livelihood.ngo
#> primary_livelihood.social_service
#> primary_livelihood.illegal
#> primary_livelihood.zakat
#> primary_livelihood.other
#> primary_livelihood.dont_know
#> primary_livelihood.prefer_not_answer
#> primary_livelihood.own_business
#> primary_livelihood_other
#> type_employment
#> water_sources
#> water_sources.piped
#> water_sources.tap
#> water_sources.borehole
#> water_sources.well
#> water_sources.bottled
#> water_sources.trucking
#> water_sources.spring
#> water_sources.rainwater
#> water_sources.surface
#> water_sources.other
#> water_sources.dont_know
#> water_source_drinking
#> treat_drink_water
#> treat_drink_water_how
#> treat_drink_water_how.boil
#> treat_drink_water_how.let_stand
#> treat_drink_water_how.expose_sunlight
#> treat_drink_water_how.use_chlorine
#> treat_drink_water_how.filter
#> treat_drink_water_how.other
#> treat_drink_water_how.dont_know
#> water_source_cook
#> treat_cook_water
#> treat_cook_water_how
#> treat_cook_water_how.boil
#> treat_cook_water_how.let_stand
#> treat_cook_water_how.expose_sunlight
#> treat_cook_water_how.use_chlorine
#> treat_cook_water_how.filter
#> treat_cook_water_how.other
#> treat_cook_water_how.dont_know
#> piped_quality
#> piped_quality.acceptable
#> piped_quality.unacceptable_taste
#> piped_quality.unacceptable_colour
#> piped_quality.unacceptable_smell
#> piped_quality.materials
#> piped_quality.no_other
#> piped_quality.dont_know
#> tap_quality
#> tap_quality.acceptable
#> tap_quality.unacceptable_taste
#> tap_quality.unacceptable_colour
#> tap_quality.unacceptable_smell
#> tap_quality.materials
#> tap_quality.no_other
#> tap_quality.dont_know
#> borehole_quality
#> borehole_quality.acceptable
#> borehole_quality.unacceptable_taste
#> borehole_quality.unacceptable_colour
#> borehole_quality.unacceptable_smell
#> borehole_quality.materials
#> borehole_quality.no_other
#> borehole_quality.dont_know
#> trucking_quality
#> trucking_quality.acceptable
#> trucking_quality.unacceptable_taste
#> trucking_quality.unacceptable_colour
#> trucking_quality.unacceptable_smell
#> trucking_quality.materials
#> trucking_quality.no_other
#> trucking_quality.dont_know
#> water_source_bath
#> water_source_clothes
#> water_source_house
#> own_animals
#> water_source_animals
#> cultivate_crops
#> water_source_crops
#> days_available_piped
#> days_available_tap
#> days_available_borehole
#> days_available_trucking
#> hours_available_piped
#> hours_available_tap
#> hours_available_borehole
#> hours_available_trucking
#> satisfaction_piped
#> satisfaction_tap
#> satisfaction_borehole
#> satisfaction_bottled
#> satisfaction_trucking
#> spend_piped
#> spend_tap
#> spend_borehole
#> spend_bottled
#> spend_trucking
#> water_tank
#> water_tank_nb_sharing
#> water_tank_litres
#> water_tank_litres_nb
#> water_tank_consent
#> water_tank_shape
#> water_tank_height
#> water_tank_diameter
#> water_tank_obs_number
#> tank_store_piped
#> tank_store_tap
#> tank_store_borehole
#> tank_store_trucking
#> tank_fill_piped
#> tank_fill_tap
#> tank_fill_borehole
#> tank_fill_trucking
#> tank_emptied
#> bottle_volume
#> bottles_per_week
#> number_pumps
#> pump_horsepower
#> pump_days
#> pump_hours
#> pump_connection_piped_sys
#> responsible_collect_water
#> seasonal_variation
#> air_coolers
#> air_coolers_nb
#> air_coolers_hours
#> access_water_enough
#> access_water_enough_why_not
#> access_water_enough_why_not.not_enough_hours
#> access_water_enough_why_not.amount_not_enough
#> access_water_enough_why_not.inconvenient_hours
#> access_water_enough_why_not.supply_inconsistent
#> access_water_enough_why_not.too_expensive
#> access_water_enough_why_not.quality_poor
#> access_water_enough_why_not.water_pressure
#> access_water_enough_why_not.sources_closed
#> access_water_enough_why_not.not_available_shops
#> access_water_enough_why_not.tank_capacity
#> access_water_enough_why_not.points_difficult_reach
#> access_water_enough_why_not.some_groups_no_access
#> access_water_enough_why_not.other
#> access_water_enough_why_not.dont_know
#> access_water_enough_why_not.prefer_not_answer
#> access_water_enough_why_not_other
#> money_coping_strategy_water
#> water_system_connection
#> connection_fees
#> connection_fees_amount
#> pay_water_charges_when
#> pay_water_charges_last
#> pay_water_charges_amount
#> pay_water_charges_method
#> pay_water_charges_prefer
#> pay_water_charges_why_not
#> pay_water_charges_why_not_other
#> value_water_service
#> pay_more_water_service
#> water_meter_know
#> water_meter_willing
#> why_share_connection
#> why_share_connection.cannot_afford
#> why_share_connection.legal_status_property
#> why_share_connection.legal_status_hh
#> why_share_connection.paperwork
#> why_share_connection.not_worth
#> why_share_connection.government_responsibility
#> why_share_connection.civil_docs
#> why_share_connection.staff_refused
#> why_share_connection.other
#> why_share_connection.dont_know
#> why_share_connection.prefer_not_answer
#> why_no_subscription
#> why_no_subscription.cannot_afford
#> why_no_subscription.legal_status_property
#> why_no_subscription.legal_status_hh
#> why_no_subscription.paperwork
#> why_no_subscription.not_worth
#> why_no_subscription.government_responsibility
#> why_no_subscription.civil_docs
#> why_no_subscription.staff_refused
#> why_no_subscription.other
#> why_no_subscription.dont_know
#> why_no_subscription.prefer_not_answer
#> own_subscription_want
#> own_subscription_assist
#> own_subscription_assist_type
#> own_subscription_assist_type.paperwork
#> own_subscription_assist_type.legalising_property
#> own_subscription_assist_type.civil_docs
#> own_subscription_assist_type.dealing_staff
#> own_subscription_assist_type.paying
#> own_subscription_assist_type.other
#> own_subscription_assist_type.dont_know
#> problems_water
#> problems_water_who_appr
#> problems_water_who_appr.nobody
#> problems_water_who_appr.water_office
#> problems_water_who_appr.municipal_staff
#> problems_water_who_appr.community_rep
#> problems_water_who_appr.ninewa_dow
#> problems_water_who_appr.ngo
#> problems_water_who_appr.plumber
#> problems_water_who_appr.other
#> problems_water_who_appr.dont_know
#> problems_water_who_appr.prefer_not_answer
#> problems_water_who_appr_not
#> problems_water_who_appr_not_other
#> problems_water_action
#> problems_water_time
#> problems_water_who_attend
#> problems_water_who_attend.nobody
#> problems_water_who_attend.water_office
#> problems_water_who_attend.municipal_staff
#> problems_water_who_attend.community_rep
#> problems_water_who_attend.ninewa_dow
#> problems_water_who_attend.ngo
#> problems_water_who_attend.plumber
#> problems_water_who_attend.other
#> problems_water_who_attend.dont_know
#> problems_water_who_attend.prefer_not_answer
#> problems_water_main_complaint
#> problems_water_main_complaint_other
#> leaks
#> leaks_reported
#> level_service
#> level_service_why_poor
#> level_service_why_poor_other
#> regularity_supply
#> water_office_receptiveness
#> water_supply_before_2014
#> water_supply_rest_neighbourhood
#> water_supply_other_neighbourhoods
#> water_supply_other_neighbourhoods_how
#> water_supply_other_neighbourhoods_how.less_hours_days
#> water_supply_other_neighbourhoods_how.smaller_quantity
#> water_supply_other_neighbourhoods_how.hours_less_inconvenient
#> water_supply_other_neighbourhoods_how.charges_higher
#> water_supply_other_neighbourhoods_how.quality_poorer
#> water_supply_other_neighbourhoods_how.pressure_lower
#> water_supply_other_neighbourhoods_how.infrastructure_poorer
#> water_supply_other_neighbourhoods_how.less_infrastructure
#> water_supply_other_neighbourhoods_how.other
#> water_supply_other_neighbourhoods_how.prefer_not_answer
#> water_supply_other_neighbourhoods_why
#> majority_pay
#> water_office_fixes_leaks
#> water_office_maintains
#> received_outreach
#> trust_water_office
#> trust_water_office_why_not
#> users_build_trust
#> users_build_trust.nothing
#> users_build_trust.pay_bills
#> users_build_trust.report_leaks
#> users_build_trust.conserve_water
#> users_build_trust.other
#> users_build_trust.dont_know
#> users_build_trust.prefer_not_answer
#> suggestions_improve_services
#> suggestions_improve_services.increase_hours
#> suggestions_improve_services.hours_more_convenient
#> suggestions_improve_services.improve_quality
#> suggestions_improve_services.reduce_price
#> suggestions_improve_services.increase_pressure
#> suggestions_improve_services.improve_infrastructure
#> suggestions_improve_services.new_infrastructure
#> suggestions_improve_services.extend_network
#> suggestions_improve_services.repair_leaks
#> suggestions_improve_services.other
#> suggestions_improve_services.dont_know
#> suggestions_improve_services.prefer_not_answer
#> suggestions_improve_services_other
#> help_office_improve
#> help_office_improve.cannot_help
#> help_office_improve.pay_bills
#> help_office_improve.report_leaks
#> help_office_improve.conserve_water
#> help_office_improve.other
#> help_office_improve.dont_know
#> help_office_improve.prefer_not_answer
#> how_engaged_by_office
#> how_engaged_by_office.prefer_not_engaged
#> how_engaged_by_office.face_to_face_home
#> how_engaged_by_office.face_to_face_office
#> how_engaged_by_office.community_rep
#> how_engaged_by_office.phone
#> how_engaged_by_office.sms
#> how_engaged_by_office.email
#> how_engaged_by_office.letter
#> how_engaged_by_office.twitter
#> how_engaged_by_office.facebook
#> how_engaged_by_office.whatsapp
#> how_engaged_by_office.complaints_box
#> how_engaged_by_office.billboards
#> how_engaged_by_office.posters
#> how_engaged_by_office.leaflets
#> how_engaged_by_office.other
#> how_engaged_by_office.prefer_not_answer
#> prefer_not_engage
#> prefer_not_engage_other
#> consent_telephone_number
#> consent_share_location
#> X_id
#> X_notes
#> X.U.FEFF.start
#> date_assessment
#> deviceid
#> enumerator_num
#> neighbourhood
#> consent_remote
#> hhh_r
#> will_to_response_r
#> age_respondent_r
#> age_hoh
#> gender_hoh
#> displace_status
#> displace_status_returnee
#> num_hh_member
#> hh_hosting
#> num_hh_hosting
#> hh_hosted
#> shelter_occupation
#> shelter_occupation_other
#> property_title
#> rental_contract
#> inc_employment_pension
#> tot_expenses
#> primary_livelihood
#> primary_livelihood.savings
#> primary_livelihood.employment
#> primary_livelihood.remittences
#> primary_livelihood.retirement_fund
#> primary_livelihood.income_renting
#> primary_livelihood.selling_assets
#> primary_livelihood.selling_assisantance
#> primary_livelihood.loans
#> primary_livelihood.modm
#> primary_livelihood.support
#> primary_livelihood.ngo
#> primary_livelihood.social_service
#> primary_livelihood.illegal
#> primary_livelihood.zakat
#> primary_livelihood.other
#> primary_livelihood.dont_know
#> primary_livelihood.prefer_not_answer
#> primary_livelihood.own_business
#> primary_livelihood_other
#> type_employment
#> water_sources
#> water_sources.piped
#> water_sources.tap
#> water_sources.borehole
#> water_sources.well
#> water_sources.bottled
#> water_sources.trucking
#> water_sources.spring
#> water_sources.rainwater
#> water_sources.surface
#> water_sources.other
#> water_sources.dont_know
#> water_source_drinking
#> treat_drink_water
#> treat_drink_water_how
#> treat_drink_water_how.boil
#> treat_drink_water_how.let_stand
#> treat_drink_water_how.expose_sunlight
#> treat_drink_water_how.use_chlorine
#> treat_drink_water_how.filter
#> treat_drink_water_how.other
#> treat_drink_water_how.dont_know
#> water_source_cook
#> treat_cook_water
#> treat_cook_water_how
#> treat_cook_water_how.boil
#> treat_cook_water_how.let_stand
#> treat_cook_water_how.expose_sunlight
#> treat_cook_water_how.use_chlorine
#> treat_cook_water_how.filter
#> treat_cook_water_how.other
#> treat_cook_water_how.dont_know
#> piped_quality
#> piped_quality.acceptable
#> piped_quality.unacceptable_taste
#> piped_quality.unacceptable_colour
#> piped_quality.unacceptable_smell
#> piped_quality.materials
#> piped_quality.no_other
#> piped_quality.dont_know
#> tap_quality
#> tap_quality.acceptable
#> tap_quality.unacceptable_taste
#> tap_quality.unacceptable_colour
#> tap_quality.unacceptable_smell
#> tap_quality.materials
#> tap_quality.no_other
#> tap_quality.dont_know
#> borehole_quality
#> borehole_quality.acceptable
#> borehole_quality.unacceptable_taste
#> borehole_quality.unacceptable_colour
#> borehole_quality.unacceptable_smell
#> borehole_quality.materials
#> borehole_quality.no_other
#> borehole_quality.dont_know
#> trucking_quality
#> trucking_quality.acceptable
#> trucking_quality.unacceptable_taste
#> trucking_quality.unacceptable_colour
#> trucking_quality.unacceptable_smell
#> trucking_quality.materials
#> trucking_quality.no_other
#> trucking_quality.dont_know
#> water_source_bath
#> water_source_clothes
#> water_source_house
#> own_animals
#> water_source_animals
#> cultivate_crops
#> water_source_crops
#> days_available_piped
#> days_available_tap
#> days_available_borehole
#> days_available_trucking
#> hours_available_piped
#> hours_available_tap
#> hours_available_borehole
#> hours_available_trucking
#> satisfaction_piped
#> satisfaction_tap
#> satisfaction_borehole
#> satisfaction_bottled
#> satisfaction_trucking
#> spend_piped
#> spend_tap
#> spend_borehole
#> spend_bottled
#> spend_trucking
#> water_tank
#> water_tank_nb_sharing
#> water_tank_litres
#> water_tank_litres_nb
#> water_tank_consent
#> water_tank_shape
#> water_tank_height
#> water_tank_diameter
#> water_tank_obs_number
#> tank_store_piped
#> tank_store_tap
#> tank_store_borehole
#> tank_store_trucking
#> tank_fill_piped
#> tank_fill_tap
#> tank_fill_borehole
#> tank_fill_trucking
#> tank_emptied
#> bottle_volume
#> bottles_per_week
#> number_pumps
#> pump_horsepower
#> pump_days
#> pump_hours
#> pump_connection_piped_sys
#> responsible_collect_water
#> seasonal_variation
#> air_coolers
#> air_coolers_nb
#> air_coolers_hours
#> access_water_enough
#> access_water_enough_why_not
#> access_water_enough_why_not.not_enough_hours
#> access_water_enough_why_not.amount_not_enough
#> access_water_enough_why_not.inconvenient_hours
#> access_water_enough_why_not.supply_inconsistent
#> access_water_enough_why_not.too_expensive
#> access_water_enough_why_not.quality_poor
#> access_water_enough_why_not.water_pressure
#> access_water_enough_why_not.sources_closed
#> access_water_enough_why_not.not_available_shops
#> access_water_enough_why_not.tank_capacity
#> access_water_enough_why_not.points_difficult_reach
#> access_water_enough_why_not.some_groups_no_access
#> access_water_enough_why_not.other
#> access_water_enough_why_not.dont_know
#> access_water_enough_why_not.prefer_not_answer
#> access_water_enough_why_not_other
#> money_coping_strategy_water
#> water_system_connection
#> connection_fees
#> connection_fees_amount
#> pay_water_charges_when
#> pay_water_charges_last
#> pay_water_charges_amount
#> pay_water_charges_method
#> pay_water_charges_prefer
#> pay_water_charges_why_not
#> pay_water_charges_why_not_other
#> value_water_service
#> pay_more_water_service
#> water_meter_know
#> water_meter_willing
#> why_share_connection
#> why_share_connection.cannot_afford
#> why_share_connection.legal_status_property
#> why_share_connection.legal_status_hh
#> why_share_connection.paperwork
#> why_share_connection.not_worth
#> why_share_connection.government_responsibility
#> why_share_connection.civil_docs
#> why_share_connection.staff_refused
#> why_share_connection.other
#> why_share_connection.dont_know
#> why_share_connection.prefer_not_answer
#> why_no_subscription
#> why_no_subscription.cannot_afford
#> why_no_subscription.legal_status_property
#> why_no_subscription.legal_status_hh
#> why_no_subscription.paperwork
#> why_no_subscription.not_worth
#> why_no_subscription.government_responsibility
#> why_no_subscription.civil_docs
#> why_no_subscription.staff_refused
#> why_no_subscription.other
#> why_no_subscription.dont_know
#> why_no_subscription.prefer_not_answer
#> own_subscription_want
#> own_subscription_assist
#> own_subscription_assist_type
#> own_subscription_assist_type.paperwork
#> own_subscription_assist_type.legalising_property
#> own_subscription_assist_type.civil_docs
#> own_subscription_assist_type.dealing_staff
#> own_subscription_assist_type.paying
#> own_subscription_assist_type.other
#> own_subscription_assist_type.dont_know
#> problems_water
#> problems_water_who_appr
#> problems_water_who_appr.nobody
#> problems_water_who_appr.water_office
#> problems_water_who_appr.municipal_staff
#> problems_water_who_appr.community_rep
#> problems_water_who_appr.ninewa_dow
#> problems_water_who_appr.ngo
#> problems_water_who_appr.plumber
#> problems_water_who_appr.other
#> problems_water_who_appr.dont_know
#> problems_water_who_appr.prefer_not_answer
#> problems_water_who_appr_not
#> problems_water_who_appr_not_other
#> problems_water_action
#> problems_water_time
#> problems_water_who_attend
#> problems_water_who_attend.nobody
#> problems_water_who_attend.water_office
#> problems_water_who_attend.municipal_staff
#> problems_water_who_attend.community_rep
#> problems_water_who_attend.ninewa_dow
#> problems_water_who_attend.ngo
#> problems_water_who_attend.plumber
#> problems_water_who_attend.other
#> problems_water_who_attend.dont_know
#> problems_water_who_attend.prefer_not_answer
#> problems_water_main_complaint
#> problems_water_main_complaint_other
#> leaks
#> leaks_reported
#> level_service
#> level_service_why_poor
#> level_service_why_poor_other
#> regularity_supply
#> water_office_receptiveness
#> water_supply_before_2014
#> water_supply_rest_neighbourhood
#> water_supply_other_neighbourhoods
#> water_supply_other_neighbourhoods_how
#> water_supply_other_neighbourhoods_how.less_hours_days
#> water_supply_other_neighbourhoods_how.smaller_quantity
#> water_supply_other_neighbourhoods_how.hours_less_inconvenient
#> water_supply_other_neighbourhoods_how.charges_higher
#> water_supply_other_neighbourhoods_how.quality_poorer
#> water_supply_other_neighbourhoods_how.pressure_lower
#> water_supply_other_neighbourhoods_how.infrastructure_poorer
#> water_supply_other_neighbourhoods_how.less_infrastructure
#> water_supply_other_neighbourhoods_how.other
#> water_supply_other_neighbourhoods_how.prefer_not_answer
#> water_supply_other_neighbourhoods_why
#> majority_pay
#> water_office_fixes_leaks
#> water_office_maintains
#> received_outreach
#> trust_water_office
#> trust_water_office_why_not
#> users_build_trust
#> users_build_trust.nothing
#> users_build_trust.pay_bills
#> users_build_trust.report_leaks
#> users_build_trust.conserve_water
#> users_build_trust.other
#> users_build_trust.dont_know
#> users_build_trust.prefer_not_answer
#> suggestions_improve_services
#> suggestions_improve_services.increase_hours
#> suggestions_improve_services.hours_more_convenient
#> suggestions_improve_services.improve_quality
#> suggestions_improve_services.reduce_price
#> suggestions_improve_services.increase_pressure
#> suggestions_improve_services.improve_infrastructure
#> suggestions_improve_services.new_infrastructure
#> suggestions_improve_services.extend_network
#> suggestions_improve_services.repair_leaks
#> suggestions_improve_services.other
#> suggestions_improve_services.dont_know
#> suggestions_improve_services.prefer_not_answer
#> suggestions_improve_services_other
#> help_office_improve
#> help_office_improve.cannot_help
#> help_office_improve.pay_bills
#> help_office_improve.report_leaks
#> help_office_improve.conserve_water
#> help_office_improve.other
#> help_office_improve.dont_know
#> help_office_improve.prefer_not_answer
#> how_engaged_by_office
#> how_engaged_by_office.prefer_not_engaged
#> how_engaged_by_office.face_to_face_home
#> how_engaged_by_office.face_to_face_office
#> how_engaged_by_office.community_rep
#> how_engaged_by_office.phone
#> how_engaged_by_office.sms
#> how_engaged_by_office.email
#> how_engaged_by_office.letter
#> how_engaged_by_office.twitter
#> how_engaged_by_office.facebook
#> how_engaged_by_office.whatsapp
#> how_engaged_by_office.complaints_box
#> how_engaged_by_office.billboards
#> how_engaged_by_office.posters
#> how_engaged_by_office.leaflets
#> how_engaged_by_office.other
#> how_engaged_by_office.prefer_not_answer
#> prefer_not_engage
#> prefer_not_engage_other
#> consent_telephone_number
#> consent_share_location
#> X_id
#> X_notes
log |> knitr::kable()
#>
#>
#> | |uuid |question |change_type |new_value |old_value |comment |
#> |:------|:------------------------------------|:-------------------------------------|:---------------|:-----------|:------------|:---------------------------------------|
#> |...1 |dcf2753a-6ea2-40f5-b493-3527931ef96c |NA |remove_survey |NA |NA |No matching uuid in the cleaned dataset |
#> |...2 |8790ce5c-1c35-41a2-b3c0-538f937d5397 |NA |remove_survey |NA |NA |No matching uuid in the cleaned dataset |
#> |...3 |bb818e04-9c40-408e-919f-6b40ff1fdbb3 |NA |remove_survey |NA |NA |No matching uuid in the cleaned dataset |
#> |...4 |28b90cbb-2cf0-41c5-9ee1-1c719c0d4c02 |NA |remove_survey |NA |NA |No matching uuid in the cleaned dataset |
#> |...5 |7f2a0c6a-529b-481f-963f-a96dca2ec034 |NA |remove_survey |NA |NA |No matching uuid in the cleaned dataset |
#> |...6 |b4f92064-12ea-4970-b0f5-fd309de1dda3 |NA |remove_survey |NA |NA |No matching uuid in the cleaned dataset |
#> |...7 |f5ce0576-bfe5-4d1b-a247-26d31c7e7a86 |NA |remove_survey |NA |NA |No matching uuid in the cleaned dataset |
#> |...8 |6c9e9356-5810-43d2-bf5c-a2044ecef219 |NA |remove_survey |NA |NA |No matching uuid in the cleaned dataset |
#> |...9 |0b74b52d-d221-4b81-a5e6-9f9db48b1f86 |NA |remove_survey |NA |NA |No matching uuid in the cleaned dataset |
#> |...10 |67e7482b-a543-40f5-856d-29d5b1c60f9a |NA |remove_survey |NA |NA |No matching uuid in the cleaned dataset |
#> |...11 |a8d89047-792f-4d95-9adf-25e2e42ff66d |NA |remove_survey |NA |NA |No matching uuid in the cleaned dataset |
#> |...12 |a52c231b-20c5-4520-bf73-d86410b0f26c |NA |remove_survey |NA |NA |No matching uuid in the cleaned dataset |
#> |...13 |987dbeee-d809-4a62-b2ed-15a1673f4f18 |NA |remove_survey |NA |NA |No matching uuid in the cleaned dataset |
#> |...14 |8c7568cb-0815-4b9a-a19e-89b3db792441 |NA |remove_survey |NA |NA |No matching uuid in the cleaned dataset |
#> |...15 |248f7774-319a-4368-91d2-a1f8dec9972d |NA |remove_survey |NA |NA |No matching uuid in the cleaned dataset |
#> |...16 |2777683b-aa86-40b7-8da1-77dcc2e4d553 |NA |remove_survey |NA |NA |No matching uuid in the cleaned dataset |
#> |...17 |f1175d29-ce1f-43a7-b3d1-ee26cd1b8cdb |NA |remove_survey |NA |NA |No matching uuid in the cleaned dataset |
#> |...18 |3438f313-24e6-46fc-9597-cec440a737ce |NA |remove_survey |NA |NA |No matching uuid in the cleaned dataset |
#> |...19 |e9f8b44c-c507-45a1-8d76-66d886437b8f |NA |remove_survey |NA |NA |No matching uuid in the cleaned dataset |
#> |...20 |d7714f1e-0ed2-46ea-a94d-54a6c6423e39 |NA |remove_survey |NA |NA |No matching uuid in the cleaned dataset |
#> |...21 |2498556b-4165-4a85-a7d9-c6ce75032747 |NA |remove_survey |NA |NA |No matching uuid in the cleaned dataset |
#> |...22 |d75a0458-16bc-4b0c-af7a-5b22ab73dfb7 |NA |remove_survey |NA |NA |No matching uuid in the cleaned dataset |
#> |...23 |50be30c5-86b8-4fd1-bd59-be31d8bd128c |NA |remove_survey |NA |NA |No matching uuid in the cleaned dataset |
#> |...24 |31742119-37a2-4a4c-a688-15efa7914aff |NA |remove_survey |NA |NA |No matching uuid in the cleaned dataset |
#> |...25 |683e97a1-a6df-4442-b1ba-effe04612b86 |NA |remove_survey |NA |NA |No matching uuid in the cleaned dataset |
#> |...26 |3fbf82e7-8009-44b7-bb09-eabd9e38b18c |NA |remove_survey |NA |NA |No matching uuid in the cleaned dataset |
#> |...27 |a25896b2-49e6-4187-972a-519101968647 |NA |remove_survey |NA |NA |No matching uuid in the cleaned dataset |
#> |...28 |994a60b8-e640-425c-9774-160651d7af04 |NA |remove_survey |NA |NA |No matching uuid in the cleaned dataset |
#> |...29 |d9ff616f-b3ac-4eae-88dc-601946260d82 |NA |remove_survey |NA |NA |No matching uuid in the cleaned dataset |
#> |...30 |c3a52fa9-63f5-4d02-b2b0-6eebbef944a7 |NA |remove_survey |NA |NA |No matching uuid in the cleaned dataset |
#> |...31 |17bad766-fc25-49fe-a041-c6503e05941d |NA |remove_survey |NA |NA |No matching uuid in the cleaned dataset |
#> |...32 |308b7de7-7f09-4578-8373-8c81f74480f4 |NA |remove_survey |NA |NA |No matching uuid in the cleaned dataset |
#> |...33 |bd2a7c9f-4eed-4943-b39a-659d5c1d9a31 |NA |remove_survey |NA |NA |No matching uuid in the cleaned dataset |
#> |...34 |7f7a6714-a334-4079-bfe4-e590667f4aee |NA |remove_survey |NA |NA |No matching uuid in the cleaned dataset |
#> |...35 |1a80239e-a815-4fcd-8549-294fb190c27f |NA |remove_survey |NA |NA |No matching uuid in the cleaned dataset |
#> |...36 |bcd16469-8f6e-4d88-94c9-6fd700e352fa |NA |remove_survey |NA |NA |No matching uuid in the cleaned dataset |
#> |...37 |bdcca634-6e9d-434a-bac0-5d17540848e8 |NA |remove_survey |NA |NA |No matching uuid in the cleaned dataset |
#> |...38 |6cb6e1dc-3d68-4d49-9d4a-29e3cb992f37 |NA |remove_survey |NA |NA |No matching uuid in the cleaned dataset |
#> |...39 |dd3a9983-0bcd-4fcd-933b-6c2dea5ea0ca |NA |remove_survey |NA |NA |No matching uuid in the cleaned dataset |
#> |...40 |90e8ef05-9604-471e-8c1a-94fa5592cc46 |NA |remove_survey |NA |NA |No matching uuid in the cleaned dataset |
#> |...41 |f0fd8ae4-a149-45a7-9cfa-d51e30e7a55c |NA |remove_survey |NA |NA |No matching uuid in the cleaned dataset |
#> |...42 |9dac8c9e-a5a5-435d-b28c-82d5f43b2f7f |NA |remove_survey |NA |NA |No matching uuid in the cleaned dataset |
#> |...43 |a37512fa-f4ea-4c6c-a873-851f69df6c93 |NA |remove_survey |NA |NA |No matching uuid in the cleaned dataset |
#> |...44 |1b473a2c-71bd-4bcc-8040-621dde1475dc |NA |remove_survey |NA |NA |No matching uuid in the cleaned dataset |
#> |...45 |f45d4ca7-adce-416d-b096-04ab6ff79d12 |NA |remove_survey |NA |NA |No matching uuid in the cleaned dataset |
#> |...46 |2b148a6e-90fc-496b-9d03-061377df2290 |NA |remove_survey |NA |NA |No matching uuid in the cleaned dataset |
#> |...47 |5205540c-6019-4137-9c18-fb597d5af35c |NA |remove_survey |NA |NA |No matching uuid in the cleaned dataset |
#> |...48 |1f97f421-40a5-4c4d-9ec5-569d58718c5f |NA |remove_survey |NA |NA |No matching uuid in the cleaned dataset |
#> |...49 |c928be0f-0f0e-4a56-8603-501f533f2fc6 |NA |remove_survey |NA |NA |No matching uuid in the cleaned dataset |
#> |...50 |bb7cb050-5b65-43c9-b7bb-2de4f56ecdda |NA |remove_survey |NA |NA |No matching uuid in the cleaned dataset |
#> |...51 |cc73c878-71e9-44b1-9156-49c33d86731b |NA |remove_survey |NA |NA |No matching uuid in the cleaned dataset |
#> |...52 |5c80617f-88b4-441d-8990-cdb3c33559e0 |NA |remove_survey |NA |NA |No matching uuid in the cleaned dataset |
#> |...53 |2b49e747-84e8-429a-95a0-8d25f6448aa0 |NA |remove_survey |NA |NA |No matching uuid in the cleaned dataset |
#> |...54 |c1c69337-eb3e-4427-a578-26f94bf3aeaf |NA |remove_survey |NA |NA |No matching uuid in the cleaned dataset |
#> |...55 |all |socio_eco_division |variable_added |NA |NA |variable added to the clean dataset |
#> |...56 |all |water_sector |variable_added |NA |NA |variable added to the clean dataset |
#> |7 |0349b616-aeb9-49e4-a3dc-e8e7ca9ac9cf |return_date |change_response |2017-01-01 |2021-07-10 |An alteration was performed |
#> |10 |03f9bc62-8a14-49eb-8b24-02992fc4dc31 |return_date |change_response |2018-07-01 |2021-07-14 |An alteration was performed |
#> |38 |0d4fafd8-9243-4a05-be2a-2100c2e60185 |return_date |change_response |2018-03-01 |2021-07-11 |An alteration was performed |
#> |42 |101e7fa9-eacd-40a8-bab0-4630488b8e1d |return_date |change_response |2017-01-01 |2021-07-09 |An alteration was performed |
#> |43 |11067dc4-45b5-4b35-8d43-5dec9f7276c5 |return_date |change_response |2018-03-01 |2021-07-14 |An alteration was performed |
#> |52 |1475ab22-557c-4c93-ba46-68427f29375a |return_date |change_response |2018-03-01 |2021-07-08 |An alteration was performed |
#> |78 |1fcf8417-5cd9-4c65-9090-83e828881939 |return_date |change_response |2019-01-20 |2021-07-13 |An alteration was performed |
#> |84 |222d5a7f-1962-4516-9127-6f5c2e574f96 |return_date |change_response |2019-07-15 |2021-07-14 |An alteration was performed |
#> |114 |34cba4d1-371e-425b-a189-cb1cb3519ade |return_date |change_response |2018-03-01 |2021-07-13 |An alteration was performed |
#> |216 |5f5b64bc-c53b-40fb-98cd-a615205b5954 |return_date |change_response |2018-04-19 |2021-07-07 |An alteration was performed |
#> |250 |6c7176cc-dfcf-495e-bc45-90c9e1be5b85 |return_date |change_response |2019-05-01 |2021-07-06 |An alteration was performed |
#> |260 |6fb6b60c-70cf-4940-8f3d-603cf7d7c6c2 |return_date |change_response |2017-12-10 |2021-07-08 |An alteration was performed |
#> |269 |7309b048-b6d5-4250-bf12-c7648dee943e |return_date |change_response |2018-08-01 |2021-07-12 |An alteration was performed |
#> |287 |7c71081a-1ba9-43fd-8ba7-eb46c43dc79f |return_date |change_response |2018-07-12 |2021-07-07 |An alteration was performed |
#> |300 |81ae2bfd-6c29-4846-b171-9512ec8eda41 |return_date |change_response |2018-04-06 |2021-07-07 |An alteration was performed |
#> |302 |842b1321-7ab5-4494-b98b-29ae93fc654e |return_date |change_response |2018-01-26 |2021-07-06 |An alteration was performed |
#> |309 |87d64595-1a2f-4cd2-99b3-723134f45ff6 |return_date |change_response |2021-03-01 |2021-07-12 |An alteration was performed |
#> |349 |9ea03a5e-aad9-46b3-99bc-7c0786d1abce |return_date |change_response |2018-01-01 |2021-07-14 |An alteration was performed |
#> |355 |a11f3cee-428d-4cbd-8c9b-41fd9a5d2697 |return_date |change_response |2018-10-01 |2021-07-11 |An alteration was performed |
#> |380 |ab5f789b-a3a4-4ee6-a781-53b3366bbd62 |return_date |change_response |2018-01-01 |2021-07-11 |An alteration was performed |
#> |402 |b427827c-949b-4524-a802-7432285b5ced |return_date |change_response |2017-12-21 |2021-07-14 |An alteration was performed |
#> |410 |b67bf5ec-a2b3-4c34-8bb3-25410ee92082 |return_date |change_response |2018-10-18 |2021-07-06 |An alteration was performed |
#> |433 |c50e380e-64a4-4cee-84f2-daaebdbb78db |return_date |change_response |2018-11-11 |2021-07-08 |An alteration was performed |
#> |436 |c746e682-cb56-4604-95df-b200a98d3a8e |return_date |change_response |2018-02-17 |2021-07-07 |An alteration was performed |
#> |446 |c9b3a3df-4775-4ba3-bc1c-1b8237f714c4 |return_date |change_response |2018-06-09 |2021-07-06 |An alteration was performed |
#> |458 |cfb721ab-e7b5-4b01-ac3a-c536c5fe8517 |return_date |change_response |2018-02-01 |2021-07-09 |An alteration was performed |
#> |471 |d4142ede-2082-4091-accc-0989c34d6516 |return_date |change_response |2018-01-01 |2021-07-06 |An alteration was performed |
#> |495 |dc499548-3308-4207-ac8f-3a14fc92baf0 |return_date |change_response |2020-03-01 |2021-07-14 |An alteration was performed |
#> |519 |eb3b9935-fa0b-4d54-8058-3b629f1421ad |return_date |change_response |2018-02-27 |2021-07-08 |An alteration was performed |
#> |569 |fcc6b9e8-c72a-4228-8dc0-6e803114b6d6 |return_date |change_response |2018-02-01 |2021-07-06 |An alteration was performed |
#> |4581 |cfb721ab-e7b5-4b01-ac3a-c536c5fe8517 |num_hh_hosting |change_response |7 |10 |An alteration was performed |
#> |135 |3dbe6df8-c2d7-449d-8082-c2b92738ce4d |tot_expenses |change_response |350000 |35000 |An alteration was performed |
#> |185 |51324001-970c-4fb5-bacf-de696e1b7eaa |water_sources.borehole |change_response |TRUE |FALSE |An alteration was performed |
#> |477 |d5d26992-388b-4c71-a461-18a63cac8738 |water_sources.borehole |change_response |TRUE |FALSE |An alteration was performed |
#> |130 |3b9732e2-a0d7-4dc3-962d-12efcd2ded15 |treat_drink_water |change_response |never_treat |always_treat |An alteration was performed |
#> |268 |728e4de0-7356-4bb5-9db4-9479b3ffe098 |treat_drink_water |change_response |never_treat |always_treat |An alteration was performed |
#> |1301 |3b9732e2-a0d7-4dc3-962d-12efcd2ded15 |treat_drink_water_how.expose_sunlight |change_response |FALSE |TRUE |An alteration was performed |
#> |2681 |728e4de0-7356-4bb5-9db4-9479b3ffe098 |treat_drink_water_how.filter |change_response |FALSE |TRUE |An alteration was performed |
#> |14 |04e28a1d-fc2a-4384-b889-e56c498bc485 |spend_tap |change_response |FALSE |0 |An alteration was performed |
#> |45 |1238747b-6616-4c8e-9a1f-571c2927d66d |spend_tap |change_response |FALSE |0 |An alteration was performed |
#> |145 |40d8ee6f-8e47-497a-9005-fde107b209b8 |spend_tap |change_response |FALSE |0 |An alteration was performed |
#> |205 |5a2d6c59-3675-4da0-8af5-eeeda3142981 |spend_tap |change_response |FALSE |0 |An alteration was performed |
#> |275 |745ce148-192b-42bf-9dc1-63d6860fed81 |spend_tap |change_response |FALSE |0 |An alteration was performed |
#> |324 |90e04250-0e94-42a2-8a3d-676df3dd7edb |spend_tap |change_response |FALSE |0 |An alteration was performed |
#> |462 |d04074f2-cbbe-48be-9837-ccf3dc8e186e |spend_tap |change_response |FALSE |0 |An alteration was performed |
#> |542 |f28e9f8d-f9a4-4039-9ddf-2491518d2af3 |spend_tap |change_response |FALSE |0 |An alteration was performed |
#> |5691 |fcc6b9e8-c72a-4228-8dc0-6e803114b6d6 |water_tank_litres_nb |change_response |7000 |70000 |An alteration was performed |
#> |238 |686846a0-5733-420f-99d5-b690233045d6 |number_pumps |change_response |1 |7 |An alteration was performed |
#> |351 |9eeec67f-6bf7-4948-900e-2101b6346fc1 |air_coolers_nb |change_response |2 |18 |An alteration was performed |
#> |139 |3ef4cdde-bdce-4378-8e12-b7488ff68180 |connection_fees_amount |change_response |45000 |45 |An alteration was performed |
#> |470 |d3a9b6cb-fb33-46f0-b140-308331a1fa7e |connection_fees_amount |change_response |50000 |50 |An alteration was performed |
#> |4 |03183d24-0275-43fe-8976-d076f29de590 |pay_water_charges_amount |change_response |10000 |10 |An alteration was performed |
#> |...109 |407984dd-075f-49b9-b808-2772fc5399ec |return_date |blank_response |NA |2021-07-08 |changed to NA |
#> |...110 |489b4d13-7eaf-4732-af22-28d6cfd77466 |return_date |blank_response |NA |2021-07-13 |changed to NA |
#> |...111 |d752c413-dce7-48aa-a2b2-3de90c1bb218 |return_date |blank_response |NA |2021-07-13 |changed to NA |