* Liberia Stat Clean Do-file Second Look * Richard Fischer * 11/2/2016 clear cd "C:\Work\OneDrive - American Red Cross\West Africa\Merge Data\Edits to Uploaded Data" use "base file.dta" rename *,lower label variable namevill "Name of community" label variable share_emerge_contact "May we share your contact information with other organizations in order to assist in responding to any future emergencies?" label define shareinfolabels 1 "Yes" 2 "No" label values share_emerge_contact shareinfolabels label variable hhnum "How many households (families that eat out of one pot) are in this community?" label define hhnumlabels 9999 "Don't know" label values hhnum hhnumlabels label variable drought "Has the community been affected by a drought since Ebola began in the country?" label define noyes 0 "No" 1 "Yes" label values drought noyes label variable famine "Has the community been affected by a famine since Ebola began in the country?" label values famine noyes label variable flooding "Has the community been affected by a flood since Ebola began in the country?" label values flooding noyes label variable landslides "Has the community been affected by a landslide since Ebola began in the country?" label values landslides noyes label variable fire "Has the community been affected by a fire since Ebola began in the country?" label values fire noyes label variable commebola "Has the community contracted or died by Ebola since Ebola began in the country?" label values commebola noyes label variable disease "Has the community been affected by a non-Ebola epidemic since Ebola began in the country?" label values disease noyes label variable distnone "No disaster or epidemic has occured in the community since Ebola began in the country" label values distnone noyes label variable othdist "Has the community been affected by any other disaster or epidemic since Ebola began in the country?" label values othdist noyes label variable ebola "And since the Ebola outbreak in this country, how many people living in this community have become sick from Ebola or died from Ebola? If you do not know the exact number, please give your best estimate." label variable drink_wat "Primary source of drinking water in community" label define drink_watlabels 1 "Piped water into dwelling, yard or plot" 2 "Public tap or standpipe" 3 "Tubewell or borehole" 4 "Protected spring" 5 "Protected dug well" 6 "Rainwater collection" 7 "Unprotected dug well" 8 "Unprotected spring" 9 "Cart with small tank or drum" 10 "Tanker truck" 11 "Surface water" 12 "Bottled water" 97 "Other" 98 "Refused" label values drink_wat drink_watlabels label variable water_time "How many minutes does it take the average person in the community to go to the drinking water source, get the water, and come back, including waiting time to collect the water?" label define dontknows 9999 "Don't know" label values water_time dontknows label define toiletlabels 1 "Flush or pour flush to piped sewer system, septic tank or pit latrine" 2 "Ventilated improved pit (VIP) latrine" 3 "Pit latrine with slab" 4 "Composting toilet" 5 "Flush or pour flush to everywhere (not piped)" 6 "Pit latrine without slab, or open pit" 7 "Bucket" 8 "Hanging toilet or hanging latrine" 9 "Shared or public facilities of any type" 10 "No facilities/Bush/Field" 97 "Other" label variable toilet "What kind of toilet facility do most people in this community usually use?" label values toilet toiletlabels label variable floor "Main material people have for their floors in their homes" label define floorlabel 1 "Earth/Sand" 2 "Dung" 3 "Wood planks" 4 " Palm" 5 "Cement" 6 "Vinyl or asphalt" 7 "Polished wood" 8 "Carpet" 97 "Other" 98 "Refused" label values floor floorlabel label variable treat_main "Type of treatment facility or person" label define treat_mainlabels 1 "Hospital operated by national government" 2 "Hospital operated by foreign government or international body" 3 "Hospital operated by non-governmental organization/charity organization" 4 "Hospital (unspecified)" 5 "Clinic operated by national government" 6 "Clinic operated by foreign government or international body" 7 "Clinic operated by non-governmental organization/charity organization" 8 "Clinic (unspecified)" 9 "Community health workers" 10 "Traditional healer" 11 "Private hospital" 12 "Midwife" 13 "Friend or family member" 97 "Other" 99 "Don't know" label values treat_main treat_mainlabels label variable treat_loc "Is facility/person located inside or outside the community?" label define treat_loclabels 1 "Inside the community" 2 "Outside the community" 99 "Don't know" label values treat_loc treat_loclabels label variable treat_time "Based on transportation available to most people in the community, how many minutes would it take to get to treatment facility/person and come back, excluding the time to receive treatment?" label define treat_timelabels 9995 "More than one day" 9999 "Don't know" label values treat_time treat_timelabels label variable hosgov "What else do community members visit for treatment: National government hospital" label values hosgov noyes label variable hosfor "What else do community members visit for treatment: Foreign government hospital" label values hosfor noyes label variable hosngo "What else do community members visit for treatment: NGO hospital" label values hosngo noyes label variable hosunsp "What else do community members visit for treatment: Unspecified hospital" label values hosunsp noyes label variable clingov "What else do community members visit for treatment: National government clinic" label values clingov noyes label variable clinfor "What else do community members visit for treatment: Foreign government clinic" label values clinfor noyes label variable clinngo "What else do community members visit for treatment: NGO clinic" label values clinngo noyes label variable clinunsp "What else do community members visit for treatment: Unspecified clinic" label values clinunsp noyes label variable chw "What else do community members visit for treatment: Community health worker" label values chw noyes label variable trad "What else do community members visit for treatment: Traditional healer" label values trad noyes label variable hospri "What else do community members visit for treatment: Private hospital" label values hospri noyes label variable midwife "What else do community members visit for treatment: Midwife" label values midwife noyes label variable friends "What else do community members visit for treatment: Friends" label values friends noyes label variable unsp "What else do community members visit for treatment: Unspecified" label values unsp noyes label variable healthnone "Nothing outside primary facility is used by community members for treatment" label values healthnone noyes label variable healthref "Refused to answer if community members visit any other facility for treatment" label values healthref noyes label variable healthdk "Don't know if community members visit any other facility for treatment" label values healthdk noyes label variable birth_loc "Is birth facility/person located inside or outside the community?" label define birth_loclabelz 1 "Inside the community" 2 "Outside the community" label values birth_loc birth_loclabelz label variable birth_time "Based on transportation available to most women in the community, how many minutes would it take to get to the birth facility/person and come back, excluding the time it takes to wait at the facility or give birth?" label define birth_timelabels 9995 "More than one day" 9999 "Don't know" label values birth_time birth_timelabels label variable birhosgov "Facility or person women go to when giving birth: National government hospital" label values birhosgov noyes label variable birhosfor "Facility or person women go to when giving birth: Foreign government hospital" label values birhosfor noyes label variable birhosngo "Facility or person women go to when giving birth: NGO hospital" label values birhosngo noyes label variable birhosunsp "Facility or person women go to when giving birth: Unspecified hospital" label values birhosunsp noyes label variable birclingov "Facility or person women go to when giving birth: National government clinic" label values birclingov noyes label variable birclinfor "Facility or person women go to when giving birth: Foreign gov clinic" label values birclinfor noyes label variable birclinngo "Facility or person women go to when giving birth: NGO clinic" label values birclinngo noyes label variable birclinunsp "Facility or person women go to when giving birth: Unspecified clinic" label values birclinunsp noyes label variable birchw "Facility or person women go to when giving birth: Community health worker" label values birchw noyes label variable birtrad "Facility or person women go to when giving birth: Traditional healer" label values birtrad noyes label variable birhospri "Facility or person women go to when giving birth: Private hospital" label values birhospri noyes label variable birmidwife "Facility or person women go to when giving birth: Midwife" label values birmidwife noyes label variable birfriends "Facility or person women go to when giving birth: Friends" label values birfriends noyes label variable birmatron "Facility or person women go to when giving birth: Matron" label values birmatron noyes label variable birposte "Facility or person women go to when giving birth: Unspecified poste" label values birposte noyes label variable birnone "Nothing outside of primary facility is used for birth" label values birnone noyes label variable birref "Refuse to answer where else women go to when giving birth" label values birref noyes label variable birdk "Don't know where else women go to when giving birth" label values birdk noyes label variable lgmoh "Do any CHWs from the Ministry of Health work in this community since Ebola began?" label values lgmoh noyes label variable redcross "Do any CHWs from the Red Cross work in this community since Ebola began?" label values redcross noyes label variable chwcomm "Do any unspecified CHWs work in this community since Ebola began?" label values chwcomm noyes label variable noworkers "There are no CHWs working in this community since Ebola began." label values noworkers noyes label variable workoth "Do any CHWs from other organizations work in this community since Ebola began?" label values workoth noyes label variable workersref "Refused to answer if any CHWs work in this community since Ebola began." label values workersref noyes label variable workersdk "Don't know if any CHWs work in this community since Ebola began." label values workersdk noyes label variable ch_or1_num "Number of reps from the national government/Ministry of Health active in community since Ebola began" label define ch_or1_numlabels 998 "Refused" 999 "Don't know" label values ch_or1_num ch_or1_numlabels label variable ch_or2_num "Number of reps from the Red Cross active in community since Ebola began" label define ch_or2_numlabelz 999 "Don't know" label values ch_or2_num ch_or2_numlabelz label variable ch_or1_time "Last time reps from the national government/Ministry of Health were active in community" label define ch_or1_timelabelz 1 "Within the last month" 2 "Within the last six months" 3 "Within the last year" 4 "Within the last two years" 98 "Refused" 99 "Don't know" label values ch_or1_time ch_or1_timelabelz label define ch_or2_timelabelz 1 "Within the last month" 2 "Within the last six months" 3 "Within the last year" 4 "Within the last two years" 98 "Refused" 99 "Don't know" label values ch_or2_time ch_or2_timelabelz label variable ch_or2_time "Last time reps from the Red Cross were active in community" label define ch_or3_numlabelz 998 "Refused" 999 "Don't know" label values ch_or3_num ch_or3_numlabelz label variable ch_or3_num "Number of community health workers active in community since Ebola outbreak" label define ch_or3_timelabelz 1 "Within the last month" 2 "Within the last six months" 3 "Within the last year" 4 "Within the last two years" 99 "Don't know" label values ch_or3_time ch_or3_timelabelz label variable ch_or3_time "Last time community health workers were active in community" label variable ch_or4_num "Number of reps from other organizations active in community since Ebola outbreak" label define ch_or4_numlabels 999 "Don't know" label values ch_or4_num ch_or4_numlabels label define ch_or4_timelabels 1 "Within the last month" 2 "Within the last six months" 3 "Within the last year" 4 "Within the last two years" 99 "Don't know" label values ch_or4_time ch_or4_timelabels label variable ch_or4_time "Last time representatives from other organizations were active in community" label variable noschool "No educational facilities are located in this community" label values noschool noyes label variable primary "Is there a primary school located in this community?" label values primary noyes label variable secondary "Is there a secondary school located in this community?" label values secondary noyes label variable vocational "Is there a vocational school located in this community?" label values vocational noyes label variable university "Is there a university located in this community?" label values university noyes label variable postgrad "Is there a post graduate institution located in this community?" label values postgrad noyes label variable schoolref "Refused to answer if there are educational facilities located in community" label values schoolref noyes label variable schooldk "Don't know if there are educational facilities located in community" label values schooldk noyes label define markoutlabels 1 "Inside the community" 2 "Outside the community" 98 "Refused" label values markout markoutlabels label variable markout "Is market located inside or outside the community?" label variable meat "Does this market sell meat?" label values meat noyes label variable poultry "Does this market sell poultry?" label values poultry noyes label variable fish "Does this market sell fish?" label values fish noyes label variable fruit "Does this market sell fruit?" label values fruit noyes label variable vegetables "Does this market sell vegetables?" label values vegetables noyes label variable marketother "Does this market sell other goods?" label values marketother noyes label variable monday "Is this market open on Monday?" label values monday noyes label variable tuesday "Is this market open on Tuesday?" label values tuesday noyes label variable wednesday "Is this market open on Wednesday?" label values wednesday noyes label variable thursday "Is this market open on Thursday?" label values thursday noyes label variable friday "Is this market open on Friday?" label values friday noyes label variable saturday "Is this market open on Saturday?" label values saturday noyes label variable sunday "Is this market open on Sunday?" label values sunday noyes label variable everyday "Is this market open everyday?" label values everyday noyes label variable dayref "Refused to answer what days the market opens" label values dayref noyes label variable daydk "Don't know what days the market opens" label values daydk noyes label variable markstall "How many stalls or vendors are selling food and other goods at market?" label define markstalllabelz 9999 "Don't know" label values markstall markstalllabelz label variable worship "Is there a place of worship in this community?" label define worshiplabels 1 "Yes" 2 "No" 98 "Refused" 99 "Don't know" label values worship worshiplabels label variable numhealth "How many healthcare facilities are in this community to map?" label variable osmsurvey "Have you completed an OSM/OMK form for this community?" label define osmsurveylabels 1 "Yes" 2 "No" 3 "No healthcare facility available" label values osmsurvey osmsurveylabels * Is this what number 3 should be? *Second Look Add-On Coding label variable comm_dist_oth "Other disaster community has experienced since Ebola outbreak" label variable comm_dist "What disasters has your community experienced since Ebola outbreak?" label define disasterlabels 1 "Drought" 2 "Famine" 3 "Flooding" 4 "Landslides" 5 "Fire Disaster" 6 "Someone in this village contracting or dying from Ebola" 7 "Village Level Epidemic (Other than Ebola)" 95 "None" 97 "Other Traumatic Event" 98 "Refused" 99 "Don't know" label variable birhome "Other facility or person women go to when giving birth: Home" label values birhome noyes label variable birth_loc_specify "If facility or person is located outside your community, what is the name of the community where the person or facility is located?" label variable birth_main "What kind of facility or person assists in the woman's birth?" label define birthmainlabels 1 "National government hospital" 2 "Foreign governemnt hospital" 3 "NGO or charity hospital" 4 "Unspecified hospital" 5 "National government clinic" 6 "Foreign government clinic" 7 "NGO or charity clinic" 8 "Unspecified clinic" 9 "Community health workers" 10 "Traditional healer" 11 "Private hospital" 12 "Midwife" 13 "Friend or family member" 14 "National government health center" 15 "Matron/Doula" 16 "At home" 95 "None/Nothing else" 97 "Other" 98 "Refused" 99 "Don't know" label variable birth_mult "What other facility or person that women go to when giving birth exists in this community?" label variable birth_name "Name of the primary facility or caregiver that a woman in this community will go to assist in birth" replace border_crossing="999995" if border_crossing==" tinkerin" destring border_crossing,replace label variable border_crossing "Is there a border crossing (formal or informal) in or near this community?" label define borderlabels 1 "Yes" 2 "No" label values border_crossing borderlabels label variable border_crossing_dest "Name of the first community on the other side of the border crossing" label variable border_crossing_name "Name of this border crossing" replace border_crossing_type="999995" if border_crossing_type==" Santa" destring border_crossing_type,replace label variable border_crossing_type "Type of border crossing" label define bordercrossingtypelabel 1 "Formal" 2 "Informal" label values border_crossing_type bordercrossingtypelabel label variable comm_health "Since the Ebola outbreak, are there any reps or CHWs from any of the following organizations working in this community? label define commhealthlabels 1 "National government/Ministry of Health" 2 "Red Cross" 3 "Unspecified community health workers" 4 "Unspecified NGO" 95 "No orgs came or were present" 97 "Other" 98 "Refused" 99 "Don't know" label variable ch_mult_oth "Name of other organizations working in community since Ebola outbreak" label variable ch_or1_num "Number of reps from the national government/Ministry of Health active in community since Ebola" label variable comment "Any important or relevant comments or questions from the community" label variable constituency "Constituency this community is in" label variable educ "Type of functioning educational facilities located within community" label define educlabels 1 "No school in community" 2 "Primary school" 3 "Secondary school" 4 "Vocational school" 5 "University" 6 "Post-graduate university" 98 "Refused" 99 "Don't know" label variable gsm_service "Is there mobile phone signal here? label define gsmlabels 1 "Yes" 2 "No" label values gsm_service gsmlabels label variable inhabited "Is this village inhabited, abandoned, or seasonally abandoned?" label define inhabitedlabels 1 "Inhabited" 2 "Abandoned" 3 "Seasonally abandoned" label values inhabited inhabitedlabels label variable drink_wat_oth "Other primary source of drinking water" label variable floor_oth "Other main material have for the floors in their homes" label variable mark_other "Other goods bought and sold at market" label variable markcomm "Name of community that market is in" label variable markday "Day(s) of the week that market is open" label variable market "Name of primary market where people in this community go to buy and sell food and other goods" label variable epidemic_specifics "Type of epidemic community has experienced since the Ebola outbreak" label variable marktype "Type of food and goods bought and sold at market people in community got to" label variable prev_interview "Has interviewee already been interviewed by another colleague?" label variable toilet_oth "Other toilet facility most people in community use" label variable treat_loc_specify "Name of community where treatment facility/person is if located outside of the community" label variable treat_mult "Other facility or person that people in the community typically visit for treatment" label variable treat_name "Name of primary facility or caregiver that person in community would go to for treatment" replace treat_name="No facility or caregiver used" if treat_name=="9995" replace treat_name="Refused/Don't know" if treat_name=="9998" label variable ward "Which ward community is in" label variable worshiploc "Name of community where people go to worship if outside community" label variable abancomm "Name of this village" replace abancomm="Cannot discover name" if abancomm=="9999" *post stephen meeting- check *11/2 edits label variable name_village "Name of this village" label variable gsm_distance "Where is the nearest Mobile Phone Signal?" label variable hh_gpsaltitude "Altitude" rename hh_gpslatitude hh_gps_latitude label variable hh_gps_latitude "Latitude" rename hh_gpslongitude hh_gps_longitude label variable hh_gps_longitude "Longitude" label variable hh_gpsprecision "Precision" label variable deviceid "Interviewer ID" label variable instanceid "Unique ID (ODK assigned)" label variable finalindex "Vulnerability index value" label variable marketclean "Name of primary market where people in this community go to buy and sell food and other goods (Cleaned)" label variable marketcomsum "How many communities travel to market within this community?" label variable marketmatch "Market node" label variable markettyperefdk "Type of goods in market: Refused or don't know" label variable region "Region" label variable relclean "Name of community where people go to worship if outside community (cleaned)" label variable relgo "How many communities travel to site of worship?" label variable religiousmatch "Worship node" label variable schoolrefdk "Type of functioning educational facilities located within community (Refused/Don't know)" label variable treatclean "Name of primary facility or caregiver that person in community would go to for treatment (cleaned)" label variable treathome "Name of primary facility or caregiver that person in community would go to for treatment (Home)" label variable treatmatch "Treatment node" label variable treatmentsum "How many communities travel to site of treatment?" label variable version "Questionnaire version for Guinea" label variable whclean "Is birth facility/person located inside or outside the community? (cleaned)" label variable whsum "How many communities traveled to location of birth facility or person?" label variable whmatch "Women's health node" label variable country "Country" label variable date "Date" label variable finalend "Final end time of interview" label variable finalstart "Start time of interview" label variable loc_adm1 "Administrative Unit 1(Guinea: Region Naturalle; Sierra Leone: District)" label variable loc_adm2 "Administrative Unit 2(Guinea: Region Naturalle; Sierra Leone: District)" label variable loc_adm3 "Administrative Unit 3(Guinea: Region Naturalle; Sierra Leone: District)" label variable loc_adm4 "Administrative Unit 4(Guinea: Region Naturalle; Sierra Leone: District)" label variable poste "What else do community members visit for treatment: Poste" label variable matron "What else do community members visit for treatment: Matron" label variable submissiontime "Time of submission" label variable other_details "Other details" label variable formid "Form ID" label variable instancename "Instance name" label variable urban_or_rural "Is this community urban or rural?" label define urbanorrurallabel 1 "Urban" 2 "Rural" 3 "Uninhabited" label variable altvillage "Alternate village name" label variable name_part_village "Village subgroup name" label variable alt_secteur_rurale "Alternative sector name (rural)" label variable alt_secteur_urbain "Alternate sector name (urban)" label variable quartier_ou_district "Community district name" label variable secteur_urbain "Sector name (urban)" label variable secteur_rural "Sector name (rural)" label variable name_carre "Subsector name" label variable names_part_villagealt_part_villa "Alternate village subgroup name 1" label variable names_part_village0alt_part_vill "Alternate village subgroup name 2" label variable names_part_village1alt_part_vill "Alternate village subgroup name 3" label variable names_part_village2alt_part_vill "Alternate village subgroup name 4" label variable names_part_village3alt_part_vill "Alternate village subgroup name 5" label variable names_part_village4alt_part_vill "Alternate village subgroup name 6" label variable names_part_village5alt_part_vill "Alternate village subgroup name 7" label variable names_part_village6alt_part_vill "Alternate village subgroup name 8" label variable alts_secteur_rurale0alt_secteur_ "Alternate sector name 1 (rural)" label variable alts_secteur_rurale1alt_secteur_ "Alternate sector name 2 (rural)" label variable alts_village0altvillage "Alternate village name 1" label variable alts_village1altvillage "Alternate village name 2" label variable alts_village2altvillage "Alternate village name 3" label variable adm4urb_def "So we can describe this area as 'Urban'. How would you describe the next administrative level here, after 'Section'?" label variable adm4urban_name "What is the name of the adm4urb_def containing this particular community?" label variable adm5urban_name "What 'Neighbourhood' do we belong to here?" label variable finalstart "Interview Start Time (Formatted)" label variable finalstart "Interview End Time (Formatted)" label variable alts_village0altvillage "Alternate Village Name 1 (Sierra Leone)" label variable alts_village1altvillage "Alternate Village Name 2 (Sierra Leone)" label variable alts_village2altvillage "Alternate Village Name 3 (Sierra Leone)" label variable alts_village1altvillage1 "Alternate Village Name 1 (Liberia)" label variable alts_village2altvillage1 "Alternate Village Name 2 (Liberia)" label variable namevillage0altvillage "Alternate Village Name 4 (Liberia)" label variable namevillage1altvillage "Alternate Village Name 5 (Liberia)" label variable namevillage4altvillage "Alternate Village Name 6 (Liberia)" label variable namevillage6altvillage "Alternate Village Name 7 (Liberia)" drop marketout drop share_emerge_contact v1 x save "WA Page Foundation Final Merge Data 2016-12-31 Stata File_Formatted.dta",replace *end of dofile