Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
IOM provided new information - that their datasets are classified into 4 categories:
  1. Site assessment
  2. Baseline assessment
  3. Flow monitoring
  4. Survey

A second analysis was performed on a selection of datasets labelled as site assessment:

IOM DTM Ecuador - Site Assessment Data - Spontaneous Sites


File: Site_Assessments_Refugios_R4.xlsx

This is at an aggregated level and has 3 sheets with the main one "uploaded_form_izr7j1" containing the header:

group_details/__1_1_a_1__survey_date__dd_mm_yyyy_group_details/__1_1_b_1__enumerator_name__person_filligroup_details/__1_1_b_2__sex_of_enumeratorgroup_details/__1_1_a_2__survey_roundgroup_hc4co39/__1.1.c.1__site_idgroup_hc4co39/Site_Statusgroup_hc4co39/establecimientogroup_hc4co39/__1.1.d.1__site_namegroup_hc4co39/Site_Alternate_Namegroup_hc4co39/Site_Start_Dategroup_hc4co39/Site_Close_Date_if_applicablegroup_hc4co39/__1_1_e_1__site_location__admin_1_group_hc4co39/__1_1_e_2__site_location__admin_2_group_hc4co39/__1_1_e_3__site_location__admin_3_group_hc4co39/__1.1.f.3__gps_coordinatesgroup_hc4co39/___1.1.f.3__gps_coordinates_latitudegroup_hc4co39/___1.1.f.3__gps_coordinates_longitudegroup_hc4co39/___1.1.f.3__gps_coordinates_altitudegroup_hc4co39/___1.1.f.3__gps_coordinates_precisiongroup_hc4co39/__1.1.f.2__gps_coordinates_manual_latgroup_hc4co39/__1.1.f.1__gps_coordinates_manual_longroup_hc4co39/tipo_de_areagroup_hc4co39/Comunidadgroup_hc4co39/Name_of_nearest_city_towngroup_hc4co39/uso_sitiogroup_hc4co39/uso_sitio_othergroup_hc4co39/Propiedadgroup_hc4co39/Propiedad_othergroup_hc4co39/areagroup_hc4co39/carpas_instaladasgroup_hc4co39/carpas_ocupadasShare_roofss_Share_roof_ssgroup_site_details/tiene_fecha_limitegroup_site_details/fecha_limitegroup_site_details/previstogroup_site_details/ir_a_alberguegroup_site_details/ir_a_albergue_othergroup_site_details/ir_a_albergue_especifiquegroup_site_details/conoce_condicionesgroup_site_details/plan_preferidogroup_site_details/porque_razongroup_site_details/plan_menos_preferidogroup_site_details/plan_menos_preferido_razongroup_site_details/aplico_bonogroup_site_details/bono_aplicadogroup_site_details/problemas_bonogroup_site_details/descripcion_problemagroup_site_details/tienen_titulosCommentsgroup_sy6yd58/__2.1.a.1__no_of_householdsgroup_sy6yd58/__2.1.b.1__total_individualsgroup_sy6yd58/__2.1.b.2__male_totalgroup_sy6yd58/__2.1.b.3__female_totalgroup_sy6yd58/Comments_002grupo_etareo/lactantes_mgrupo_etareo/lactantes_fgrupo_etareo/total_bebes_lactantesgrupo_etareo/ninosgrupo_etareo/ninasgrupo_etareo/total_ninosgrupo_etareo/adolescentes_mgrupo_etareo/adolescentes_fgrupo_etareo/total_adolescentesgrupo_etareo/adultos_menor_mgrupo_etareo/adultos_menor_fgrupo_etareo/total_adultos_menorgrupo_etareo/adultos_mgrupo_etareo/adultos_fgrupo_etareo/total_adultosgrupo_etareo/adulto_mayor_mgrupo_etareo/adulto_mayor_fgrupo_etareo/total_adulto_mayorgroup_vulnerabilities/embarazadas_menoresgroup_vulnerabilities/embarazadas_mayoresgroup_vulnerabilities/total_embarazadasgroup_vulnerabilities/lactantes_menoresgroup_vulnerabilities/lactantes_mayoresgroup_vulnerabilities/total_mujeres_lactantesgroup_vulnerabilities/__2.2.g.2__no_of_men_w_physical_disabilitiesgroup_vulnerabilities/__2.2.g.3__no_of_women_w_physical_disabilitiesgroup_vulnerabilities/__2.2.g.2__no_of_ninos_w_physical_disabilitiesgroup_vulnerabilities/__2.2.g.3__no_of_ninas_w_physical_disabilitiesgroup_vulnerabilities/total_discapacidades_fisicasgroup_vulnerabilities/__2.2.h.2__no_of_hombres_w_mental_disabilitiesgroup_vulnerabilities/__2.2.h.3__no_of_mujeres_w_mental_disabilitiesgroup_vulnerabilities/__2.2.h.2__no_of_ninos_w_mental_disabilitiesgroup_vulnerabilities/__2.2.h.3__no_of_ninas_w_mental_disabilitiesgroup_vulnerabilities/total_discapacidades_mentalesgroup_vulnerabilities/__2.2.f.1__no_of_hombres_with_chronic_diseases_or_serious_medical_conditionsgroup_vulnerabilities/__2.2.f.1__no_of_mujeres_with_chronic_diseases_or_serious_medical_conditionsgroup_vulnerabilities/__2.2.f.1__no_of_ninos_with_chronic_diseases_or_serious_medical_conditionsgroup_vulnerabilities/__2.2.f.1__no_of_ninas_with_chronic_diseases_or_serious_medical_conditionsgroup_vulnerabilities/total_personas_enfermedades_cronicasgroup_vulnerabilities/__2.2.u.7__no_of_hombres_ethnic_minoritiesgroup_vulnerabilities/__2.2.u.8__no_of_mujeres_ethnic_minoritiesgroup_vulnerabilities/__2.2.u.7__no_of_ninos_ethnic_minoritiesgroup_vulnerabilities/__2.2.u.8__no_of_ninas_ethnic_minoritiesgroup_vulnerabilities/total_minorias_etnicasgroup_vulnerabilities/__2.2.x.5__no_of_elderly_persons_mengroup_vulnerabilities/__2.2.x.6__no_of_elderly_persons_womengroup_vulnerabilities/total_ancianosgroup_vulnerabilities/__2_2_x_3__number_of_unaccompanied_elderly_mengroup_vulnerabilities/__2_2_x_4__number_of_unaccompanied_elderly_womengroup_vulnerabilities/total_ancianos_sin_companiagroup_vulnerabilities/__2.2.i.5__no_of_unaccompanied_minors_boysgroup_vulnerabilities/__2.2.i.6__no_of_unaccompanied_minors_girlsgroup_vulnerabilities/total_menores_sin_companiagroup_vulnerabilities/__2.2.i.7__no_of_separated_minors_boysgroup_vulnerabilities/__2.2.i.8__no_of_separated_minors_girlsgroup_vulnerabilities/total_menores_separadosgroup_vulnerabilities/__2.2.i.9__no_of_orphan_minors_boysgroup_vulnerabilities/__2.2.i.10__no_of_orphan_minors_girlsgroup_vulnerabilities/total_menores_huerfanosgroup_vulnerabilities/__2.2.n.1__no_of_single_mothers_menoresgroup_vulnerabilities/__2.2.n.1__no_of_single_mothers_mayoresgroup_vulnerabilities/total_madres_solterasgroup_vulnerabilities/__2.2.o.1__no_of_single_fathers_menoresgroup_vulnerabilities/__2.2.o.1__no_of_single_fathers_mayoresgroup_vulnerabilities/total_padres_solterosgroup_vulnerabilities/__2.2.p.2__no_of_boys_headsofHHgroup_vulnerabilities/__2.2.p.3__no_of_girls_headsofHHgroup_vulnerabilities/total_menores_cabeza_hogargroup_vulnerabilities/Refugees_and_asylum_seekers_malegroup_vulnerabilities/Refugees_and_asylum_seekers_femalegroup_vulnerabilities/Refugees_and_asylum_seekers_ninogroup_vulnerabilities/Refugees_and_asylum_seekers_ninagroup_vulnerabilities/total_refugiadosgroup_mobility/__2.3_j_3__idps_living_in_place_of_displacementgroup_mobility/ss_2.3_j_3_ss_idps_living_in_place_of_displacement_specifygroup_mobility/identificacion_zonas_asentamientogroup_mobility/zonas_identificadasgroup_mobility/familias_asentamientogroup_mobility/ubicacion_familias/__2.3.e.2__admin_1group_mobility/ubicacion_familias/__2.3.e.3__admin_2group_mobility/ubicacion_familias/__2.3.e.4__admin_3group_NFI_Shelter/most_common_sheltergroup_NFI_Shelter/most_common_shelter_specifygroup_NFI_Shelter/material_techogroup_NFI_Shelter/material_techo_othergroup_NFI_Shelter/material_paredesgroup_NFI_Shelter/material_paredes_othergroup_NFI_Shelter/material_pisogroup_NFI_Shelter/material_piso_othergroup_NFI_Shelter/repair_materials_neededgroup_NFI_Shelter/repair_materials_needed_specifygroup_NFI_Shelter/temporary_housing_assistancegroup_NFI_Shelter/temporary_housing_assistance_specifygroup_NFI_Shelter/NFI_being_distributedgroup_NFI_Shelter/NFI_being_distributed_specifygroup_NFI_Shelter/most_distributed_NFIgroup_NFI_Shelter/most_distributed_NFI_specifygroup_NFI_Shelter/most_needed_NFIgroup_NFI_Shelter/most_needed_NFI/kits_cocinagroup_NFI_Shelter/most_needed_NFI/mosquiterosgroup_NFI_Shelter/most_needed_NFI/kits_higienegroup_NFI_Shelter/most_needed_NFI/kits_dignidadgroup_NFI_Shelter/most_needed_NFI/ropagroup_NFI_Shelter/most_needed_NFI/kits_herramientasgroup_NFI_Shelter/most_needed_NFI/otrogroup_NFI_Shelter/most_needed_NFI/ningunogroup_NFI_Shelter/most_needed_NFI_specifygroup_WASH/servicio_aguagroup_WASH/servicio_saneamientogroup_WASH/servicio_higienegroup_WASH/__4.1.a.1__water_source_locationgroup_WASH/ss_4.1.a.1_ss_water_source_location_specifygroup_WASH/water_storagegroup_WASH/water_storage_specifygroup_WASH/litros_tanquegroup_WASH/cantidad_tanquesgroup_WASH/drinking_water_quantitygroup_WASH/drinking_water_quantity_specifygroup_WASH/drinking_water_sourcegroup_WASH/drinking_water_source_specifiygroup_WASH/domestic_water_quantitygroup_WASH/domestic_water_quantity_specifygroup_WASH/domestic_water_sourcegroup_WASH/domestic_water_source_specifygroup_WASH/Inodoros_letrinasgroup_WASH/__4.4.a.1__functioning_toiletgroup_WASH/duchasgroup_WASH/duchas_funcionandogroup_WASH/__4.4.b.1__separate_toiletsgroup_WASH/ss_4.4.b.1_ss_separate_toilets_specifygroup_WASH/duchas_separadasgroup_WASH/ss_4.5.b.1_ss_separate_bathing_areas_specifygroup_WASH/letrinas_hombresgroup_WASH/letrinas_mujeresgroup_WASH/duchas_hombresgroup_WASH/duchas_mujeresgroup_WASH/__4_8_b_1__do_toilets_and_bathrooms_have_lgroup_WASH/ss_4_8_b_1_ss_do_toilets_and_bathrooms_have_lgroup_WASH/__4_5_j_1__do_bathing_areas_have_functionigroup_WASH/ss_4_5_j_1_ss_do_bathing_areas_have_functionigroup_WASH/lavamanosgroup_WASH/higiene_personalgroup_WASH/higiene_personal_especifiquegroup_WASH/__4_7_c_2___hygiene_materials_for_women_avgroup_WASH/ss_4_7_c_2_ss_hygiene_materials_for_women_avgroup_WASH/botes_basuragroup_WASH/botes_basura_expliquegroup_WASH/cuantos_botesgroup_WASH/frecuenciagroup_Food_nutrition/servicios_alimentaciongroup_Food_nutrition/Grupo_si_nutricion/__6.1.b.1__supplementary_feeding_mothergroup_Food_nutrition/Grupo_si_nutricion/ss_6.1.b.1_ss_supplementary_feeding_mother_specifygroup_Food_nutrition/Grupo_si_nutricion/supplementary_feeding_childrengroup_Food_nutrition/Grupo_si_nutricion/supplementary_feeding_children_specifygroup_Food_nutrition/Grupo_si_nutricion/frecuencia_suplemento_ninosgroup_Food_nutrition/Grupo_si_nutricion/alimentacion_especial_dietasgroup_Food_nutrition/Grupo_si_nutricion/alimentacion_especial_dietas_especifiquegroup_Food_nutrition/alimentacion_infantilgroup_Food_nutrition/alimentacion_infantil_specifygroup_Food_nutrition/comentarios_alimentaciongroup_Health/servicios_saludgroup_Health/__7.1.b.1__most_prevalent_health_problemgroup_Health/ss_7.1.b.1_ss_most_prevalent_health_problemgroup_Health/__7.1.b.2__second_most_prevalent_health_problemgroup_Health/ss_7.1.b.2_ss_second_most_prevalent_health_problemgroup_Health/ss_7.1.p.2_ss_number_of_people_treated_for_se_last_surv_malegroup_Health/ss_number_of_people_treated_for_se_last_surv_femalegroup_Health/ss_number_of_people_treated_for_se_last_surv_totalgroup_Health/__7.2.a.3__access_to_medicinegroup_Health/ss_7.2.a.3_ss_access_to_medicine_specifygroup_Health/hombres_mental_tratadogroup_Health/mujers_mental_tratadogroup_Health/total_mental_tratadogroup_Health/acceso_apoyo_psicosocialgroup_Health/acceso_apoyo_psicosocial_expliquegroup_Health/requiere_apoyo_psicosocialgroup_Health/requiere_apoyo_psicosocial_expliquegroup_Health/ninos_psicosocialgroup_Health/adolescentes_psicosocialgroup_Health/adultos_psicosocialgroup_Health/adultos_mayores_psicosocialgroup_Health/__7.2.b.1__location_health_facilitygroup_Health/ss_7.2.b.1_ss_location_health_facility_specifygroup_Health/disponibilidad_servicios_saludgroup_Health/__7.2.c.2__health_facilities_providergroup_Health/ss_7.2.c.2_ss_health_facilities_provider_othergroup_Health/ss_7.2.c.2_ss_health_facilities_provider_specifygroup_Health/vacunacioneducacion/__8.1.b.1__access_to_educationeducacion/ss_8.1.b.1_ss_access_to_education_specifyeducacion/group_education/__8.2.b.1__education_distanceeducacion/group_education/ss_8.2.b.1_ss_education_distance_specifyeducacion/group_education/porcentaje_escolareducacion/group_education/porcentaje_escolar_especifiqueeducacion/group_education/kit_escolareducacion/group_education/seguro_ir_escuelagroup_Livelihood/__9.1.a.5__majority_men_occupationgroup_Livelihood/ss_9.1.a.5_ss_majority_occupation_men_othergroup_Livelihood/ss_9.1.a.5_ss_majority_occupation_men_specifygroup_Livelihood/__9.1.a.6__majority_women_occupationgroup_Livelihood/ss_9.1.a.6_ss_majority_occupation_women_othergroup_Livelihood/ss_9.1.a.6_ss_majority_occupation_women_specifygroup_Livelihood/acceso_ingresosgroup_Livelihood/acceso_ingresos_expliquegroup_Livelihood/__9.2.h.2__with_source_of_incomegroup_Livelihood/__9.3.a.2__livestockgroup_Livelihood/ss_9.3.a.2_ss_livestock_specifygroup_Livelihood/__9.1.c.1__cultivationgroup_Livelihood/__9.1.c.1__cultivation_specifygroup_security/__10.1.a.2__security_availablegroup_security/ss_10.1.a.2_ss_security_available_specifygroup_security/__10.1.e.1__reported_incidentgroup_security/ss_10.1.e.1_ss_reported_incident_specify_typegroup_security/ss_10.1.e.1_ss_reported_incident_specifygroup_security/__10.1.b.1__security_providergroup_security/ss_10.1.b.1_ss_security_provider_specifygroup_security/presencia_organo_controlgroup_security/organos_controlgroup_security/organos_control/defensoriagroup_security/organos_control/fiscaliagroup_security/organos_control/consejogroup_security/organos_control/dinapengroup_security/organos_control/junta_cantonalgroup_security/organos_control/othergroup_security/organos_control_othergroup_security/sirvengroup_security/van_alberguesgroup_security/tenido_contactogroup_security/resuelven_casosgroup_security/__10_1_t_1__are_there_areas_women_and_girlgroup_security/ss_10_1_t_1_ss_are_there_areas_women_and_girl_whichgroup_security/ss_10_1_t_1_ss_are_there_areas_women_and_girl_othergroup_security/ss_10_1_t_1_ss_are_there_areas_women_and_girl_specifygroup_security/hay_proteccion_menoresgroup_security/__10_1_u_1__which_child_protection_servicegroup_security/ss_10_1_u_1_ss_which_child_protection_servicegroup_security/__10.1.c.1__child_friendly_spacegroup_security/__10.1.d.1__woman_friendly_spacegroup_security/__10.2.j.2__gbv_mechanismgroup_security/ss_10.2.j.2_ss_gbv_mechanism_specifygroup_security/mecanismos_violencia_menoresgroup_security/mecanismos_violencia_menores_especifiquegroup_security/ninos_sin_cuidado_dia_nochegroup_security/tiempo_libre_ninosgroup_security/tiempo_libre_ninos/trabajargroup_security/tiempo_libre_ninos/tareas_domesticasgroup_security/tiempo_libre_ninos/estudiargroup_security/tiempo_libre_ninos/ludicasgroup_security/tiempo_libre_ninos/tv_redesgroup_security/tiempo_libre_ninos/ningunagroup_security/tiempo_libre_adolescentesgroup_security/tiempo_libre_adolescentes/trabajargroup_security/tiempo_libre_adolescentes/tareas_domesticasgroup_security/tiempo_libre_adolescentes/estudiargroup_security/tiempo_libre_adolescentes/ludicasgroup_security/tiempo_libre_adolescentes/tv_redesgroup_security/tiempo_libre_adolescentes/actividades_no_positivasgroup_security/tiempo_libre_adolescentes/ningunagroup_security/ninos_escombreras_basurerosgroup_security/ninos_escombreras_basureros_especifiquegroup_security/__10.3.a.3__women_feel_unsafegroup_security/ss_10.3.a.3_ss_women_feel_unsafe_specifygroup_security/__10.3.a.1__men_feel_unsafegroup_security/ss_10.3.a.1_ss_men_feel_unsafe_specifygroup_security/__10.3.a.2__children_feel_unsafegroup_security/ss_10.3.a.2_ss_children_feel_unsafe_specifygroup_security/__10.2.n.1__relationship_idpgroup_security/ss_10.2.n.1_ss_relationship_idp_specifygroup_security/__10.2.o.1__relationship_idp_hostgroup_security/ss_10.2.o.1_ss_relationship_idp_host_specifygroup_security/alcohol_drogasgroup_security/alcohol_drogas_especifiquegroup_security/hay_gente_sin_IDgroup_security/__10_1_f_1__do_the_majority_of_people_have_numbergroup_security/ss_10_1_f_1_ss_do_the_majority_of_people_have_specifygroup_security/__10.1.s.1__adequate_lightinggroup_security/ss_10.1.s.1_ss_adequate_lighting_specifygroup_security/__10_2_d_1__what_are_the_types_of_problemsgroup_security/__10_2_d_1__what_are_the_types_of_problems/vivienda_temporalgroup_security/__10_2_d_1__what_are_the_types_of_problems/bienes_no_alimentariosgroup_security/__10_2_d_1__what_are_the_types_of_problems/agua_saneamiento_higienegroup_security/__10_2_d_1__what_are_the_types_of_problems/saludgroup_security/__10_2_d_1__what_are_the_types_of_problems/comidagroup_security/__10_2_d_1__what_are_the_types_of_problems/educaciongroup_security/__10_2_d_1__what_are_the_types_of_problems/medios_de_vidagroup_security/__10_2_d_1__what_are_the_types_of_problems/ningunogroup_security/__10_2_d_1__what_are_the_types_of_problems/no_sabegroup_security/__10_2_s_2__what_are_the_risk_factors_in_agroup_security/__10_2_s_2__what_are_the_risk_factors_in_a/distanciagroup_security/__10_2_s_2__what_are_the_risk_factors_in_a/diseñogroup_security/__10_2_s_2__what_are_the_risk_factors_in_a/escombros_dañosgroup_security/__10_2_s_2__what_are_the_risk_factors_in_a/falta_iluminaciongroup_security/__10_2_s_2__what_are_the_risk_factors_in_a/falta_accesso_segregadogroup_security/__10_2_s_2__what_are_the_risk_factors_in_a/seguridadgroup_security/__10_2_s_2__what_are_the_risk_factors_in_a/discapacidadgroup_security/__10_2_s_2__what_are_the_risk_factors_in_a/menor_edadgroup_security/__10_2_s_2__what_are_the_risk_factors_in_a/otrogroup_security/ss_10_2_s_2_ss_what_are_the_risk_factors_in_a_specifygroup_security/__10_2_s_3__are_there_constraints_barriersgroup_security/__10_2_s_3__are_there_constraints_barriers_nogroup_security/__10_2_s_3__are_there_constraints_barriers_no/distanciagroup_security/__10_2_s_3__are_there_constraints_barriers_no/diseñogroup_security/__10_2_s_3__are_there_constraints_barriers_no/escombros_dañosgroup_security/__10_2_s_3__are_there_constraints_barriers_no/falta_iluminaciongroup_security/__10_2_s_3__are_there_constraints_barriers_no/falta_accesso_segregadogroup_security/__10_2_s_3__are_there_constraints_barriers_no/seguridadgroup_security/__10_2_s_3__are_there_constraints_barriers_no/discapacidadgroup_security/__10_2_s_3__are_there_constraints_barriers_no/menor_edadgroup_security/__10_2_s_3__are_there_constraints_barriers_no/otrogroup_security/comments_003group_information/informacion_necesariagroup_information/__11.1.c.1__main_topicgroup_information/ss_11.1.c.1_ss_main_topic_othergroup_information/__11.1.c.1__main_topic_specifygroup_information/punto_informacion_alberguegroup_information/tipo_de_informacion_provistagroup_information/tipo_de_informacion_provista_othergroup_information/mecanismo_transmision_quejasgroup_information/a_quien_se_dirigen_quejasgroup_information/mecansimo_solucion_quejasgroup_information/casos_tratagroup_information/__11.3.a.1__travel_abroad_informationgroup_information/ss_11.3.a.1_ss_travel_abroad_information_specifygroup_information/__11.3.a.2__travel_abroad_information_yesgroup_information/que_se_prometio_en_el_viajegroup_information/ss_que_se_prometio_en_el_viajegroup_information/__11_3_a_5__how_are_travel_abroad_opportun__version__meta/instanceID_id_uuid_submission_time_index_parent_table_name_parent_index_tags_notesProvinciaCantonParroquia

There is a sheet with the list of respondents including their names. Should this be publicly available?

IOM DTM Somalia - Site Assessment Data


File: IOM_SOM_DTM_Master_Data_Site_Assessments_Final_Rou...XLS

This is at an aggregated level and there is one sheet named "Master Dataset" with a two line header:


A. Survey DetailsB. Site/Settlement Area DetailsC. Population Demographics (Best Estimate Number of)D. Persons with Special Vulnerabilities (Best estimate number of)E. MobilityF. Shelter and Non Food Items (NFI)G. Water, Sanitation and HygieneH. Food and NutritionI. HealthJ. EducationK. LivelihoodL. Protection of Child, Women, and other Vulnerable PersonsM. Communication









Verified byDate of verificationDatabase input by?Date of inputSurvey date dd mm yyyyEnumerator name person filling out the form?Survey roundSex of enumeratorSite nameSite RegionSite DistrictVillage/TownSite_SSIDSite GPS longitudeSite GPS latitudeIs there a site management committee (SMC) in the site?If No AnswerIs the site management committee (SMC) made up from the community at the site?If No AnswerSMC member name or focal pointSMC member phone numberIs there a site management agency at the siteIf No AnswerSite classificationType of organization managing the siteIf No AnswerType of SiteIf Other SpeciyName of SMASMA member name or focal pointSMA member phone numberSite start open date dd_mm_yyyySite expected closing dateClosing date dd_mm_yyyyIs there any registration activity?If No AnswerIs there a service provider contact list?If No AnswerAccessibility to site?Estimated area of camp per meter?Ownership of land of site?What is the most common type of Shelter?If Other SpeciyIs WASH support being provided at the site?If No AnswerIs HEALTH support being provided at the site?If No AnswerIs SHELTER/NFI support provided at the site?If No AnswerIs FOOD support provided at the site?If No AnswerIs PROTECTION support provided at the site?If No AnswerIs EDUCATION support provided at the site?If No AnswerIs LIVELIHOOD support being provided at the site?If No AnswerPlace of origin of the largest IDP group in camp (Region)Place of origin of the largest IDP group in camp (District)Place of origin of the largest IDP group in camp (Village/Town)Place of origin of the second largest IDP group in camp (Settlement)Place of origin of the second largest IDP group in camp (Region)Place of origin of the second largest IDP group in camp (District)Place of origin of the second largest IDP group in camp (Village/Town)Place of origin of the second largest IDP group in camp (Settlement)Total number of IDP families/HHNumber of males by age less than one year?Number of males by age 1-5 years?Number of males by age 6-17 years?Number of males by age 18 -59 years?Number of males by age over 60 years?Total number of IDP Male individuals?Number of females by age less than one year?Number of females by age 1-5 years?Number of females by age 6-17 years?Number of females by age 18 -59 years?Number of females by age over 60 years?Total number of IDP Female individuals?Number of individuals by age, less than one year?Number of individuals by age 1-5 years?Number of individuals by age 6-17 years?Number of individuals by age 18-59 years?Number of individuals by age over 60 years?Total number of IDP individuaLS?Number of pregnant women?Number of unaccompanied child?Number of breastfeeding mothers?Number of orphaned children?Number of persons with physical Disabilities?Number of single Female headed-households?Number of persons with Mental Disabilities?Number of single Male-headed households?Number of unaccompanied elderly persons?Number of child-headed households?Number of persons with Chronic Diseases or Serious Medical conditions?Date of arrival of first IDP groupHave IDPs previously been displaced?If No AnswerDate of arrival of last IDP groupArea of intended return for largest IDP group?If No AnswerRegion of intended area of return for largest group of IDPs?District of intended area of return for largest group of IDPs?Village/Town of intended area of return for largest group of IDPs?Settlement of intended area of return for largest group of IDPs?Area of intended relocation plan for largest group of IDPs?If No AnswerName the relocation site (new camp)Estimated percentage of IDPs sleeping in the siteWhat is preventing the largest IDP group from returning home?If No AnswerPercentage of HH living outside (no shelter)Percentage of HH living in tents?Percentage of HH living in makeshift/self-made shelter?Percentage of HH living indoorS (Solid walls)Percentage of HH with access to electricity (solar generator)Percentage of HH with access to safe cooking facilities?Percentage of HH with private houses (living area)Percentage of HH with mosquito nets?Most needed type of NFIIf Other, SpecifySecond most needed type of NFIIf Other, SpecifyThird most needed type of NFIIf Other, SpecifyIs there a need for shelter repair materials?If No AnswerLocation of site's main water source (walking, one-way)If No AnswerHave water points (hand-pump, piped,...)been improvedIf No AnswerHow operational are they?If No AnswerMain non drinking water source provided or availableIf Other specifyWhat is the main drinking water source provided or availableIf Other specifyAverage amount of water available per day and per personIf No AnswerIs the drinking water potable?If No AnswerWhat is the problem with the water?If Other, SpecifyComplaints about drinking water quality?If No AnswerCondition of most of the latrinesIf No AnswerNumber of functioning toilets available on-siteAvailability of separate male and female toilets?If No AnswerGarbage disposal type?If No AnswerAvailability of separate male and female bathing areas?If No AnswerDo toilets and bathrooms have locks from the inside?If No AnswerNumber of garbage disposals pointsSolid waste/garbage problem at the site?If No AnswerAvailability of hand washing station filed in with water and soap close to toilets?If No AnswerEvidence of hand washing practicesIf No AnswerHygiene promotion campaign?If No AnswerEvidence of open defecation?If No AnswerIs there access to food (distribution, vouchers, trade, fishing..)If No AnswerIs there access to a market near from the site?If No AnswerFrequency of food (or cash/vouchers) distributionIf No AnswerMost common source for obtaining foodIf Other, SpecifyScreening for malnutrition conducted in the area? (i.e weight, height, mid-upper arm circumference screening)If No AnswerAvailability of supplementary feeding for pregnant and lactating mothersIf No AnswerAvailability of supplementary feeding for childrenIf No AnswerWhat is the most prevalent health problem at the siteIf Other, SpecifyWhat is the second most prevalent health problem at the siteIf Other, SpecifyWhat is the third most prevalent health problem at the siteIf Other, SpecifyIs std (sexually transmitted diseases) a concern on this site?Regular access to medicine?If No AnswerAccess to health facilities?If No AnswerLocation of health facilities/servicesIf No AnswerWho provides health facilities/servicesIf Other, SpecifyAccess to formal/informal education facilities/services for children from displaced HHs.If No AnswerLocation of formal/informal education facilities/services for children from displaced HHs.If No AnswerDistance to nearest education facilityIf No AnswerPercentage of the children at the site attending schoolOccupation/trade of majority of displaced HH (Copying mechanism)If Other, SpecifyNumber of HH in the site with a source of incomeAccess to income generating activities If No AnswerIs there livestock on site?If No AnswerDo IDPs have access to land for cultivation?If No AnswerIs there security on site/settlement areas?Security incidents are reported on site?Who provides main security in the site?Most common type of security incidents reported/known occuring in the settlement area?Most common type of GBV incidents reported/known occuring in the settlement area?Most common type of harmful traditional practices reported/known occuring in the settlement area?Most common type of child protection incidents reported/known occuring in the settlement area?Most reported problem in receiving support?Number of children friendly spacesNumber of women friendly spacesDo the majority of people have identification card or other documentation?Reporting/referral mechanism for GBV survivorsDo women feel safe at the settlement area?Do men feel safe at the settlement area?Do children feel safe at the settlement area?How is relationship amongst IDPs?How is relationship between IDPs and host communityIs there adequate lighting in the majority of communal point (WASH facilities, public spaces…)Where do residents mostly get their information from?If No AnswerWhat is the main topic on which the community is requesting information on?If Other, SpecifyIs travel abroad opportunities are being discussed/advertised within the community?If No AnswerIf Yes, Specify Countrymeta/instanceID_id_uuid_submission_time_index_parent_table_name_parent_index_tags_notesComments



Nigeria - IOM DTM Dataset (June 2016) - Site assessment data

File: rd10_DTM_Master_List_Jun2016.xlsx

This is at an aggregated level and has just one sheet "Sheet1" with a single line header:

LGAWARDSTATUSLATITUDELONGITUDESITE MANAGEMENT AGENCY (SMA)SMA TYPEREGISTRATION ACTIVITYSUPPORT WASHSUPPORT HEALTHSUPPORT SHELTER/NFISUPPORT FOODSUPPORT PROTECTIONSUPPORT EDUCATIONSUPPORT LIVELIHOODSITE CLASSIFICATIONSITE TYPELAND OWNERSHIPCOMMON SHELTER TYPENO OF HOUSEHOLDSINFANTS MALEINFANTS FEMALECHILDREN MALECHILDREN FEMALEYOUTH MALEYOUTH FEMALEADULT MALEADULT FEMALEELDERLY MALEELDERLY FEMALETOTAL NUMBER OF IDPSPREVIOUSLY BEEN DISPLACEDINTENDED RETURN AREAWHY NOT RETURNNO SHELTERTENTSMAKESHIFTINDOORSACCESS ELECTRICITYACCESS SAFE COOKINGHAVE PRIVATE AREASHAVE MOSQUITO NETSMOST NEEDED NFIWATER SOURCE LOCATIONDRINKING WATER SOURCEWATER CONSUMPTIONDRINKING WATER POTABLEDRINKING WATER QUALITY COMPLAINTSLATRINE CONDITIONFUNCTIONING TOILETGARBAGE DISPOSALSOLID WASTE PROBLEMHAND WASHING STATIONSHYGIENE PROMOTION CAMPAIGNOPEN DEFECATIONACCESS TO FOODACCESS TO MARKETDISTRIBUTION FREQUENCYOBTAINING FOODMALNUTRITION SCREENINGMOST PREVALENT HEALTH PROBLEMACCESS TO MEDICINEACCESS TO HEALTH FACILITYLOCATION HEALTH FACILITYHEALTH FACILITIES PROVIDERACCESS TO EDUCATIONEDUCATION LOCATIONATTENDING SCHOOLMAJORITY OCCUPATIONACCESS TO INCOMELIVESTOCKCULTIVATION



Haiti - IOM DTM Dataset (June 2016) - Site assessment data

File: rd25_DTM_Master_List_Mar2016.xlsx


This is at an aggregated level and has just one sheet "DTM Rnd 25" with a single line header although it is to be noted that there is another table right next to the main table:
SSIDCamp NameCommuneLatitudeLongitudeHouseholdsIndividualsShelters% SheltersEvictionOrganization ReturnCMA PresenceCommittee PresencePresence of ToiletsWater ProvisionCommittee for WaterPresence of BathingWaste ManagementCommittee for GarbageOther Organization provide Services

Common Fields

From the headers above, there are certain fields which are common to all. These are:

  1. Latitude
  2. Longitude
  3. Location Name (ward, district, camp name etc.)
  4. Families/Households
  5. Individuals


Similar Fields

The below fields communicate similar information but are not consistent between the spreadsheets:

  1. Shelter (either a number of a type) 
  2. Toilet availability (either a number or yes/no)
  3. Water provision (yes/no or various inconsistent values expressing onsite, offsite and/or distance from water)
  4. Waste management (yes/no or a type)