Data Structure - Second Analysis
- Michael Rans
Owned by Michael Rans
IOM provided new information - that their datasets are classified into 4 categories:
- Site assessment
- Baseline assessment
- Flow monitoring
- 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_filli | group_details/__1_1_b_2__sex_of_enumerator | group_details/__1_1_a_2__survey_round | group_hc4co39/__1.1.c.1__site_id | group_hc4co39/Site_Status | group_hc4co39/establecimiento | group_hc4co39/__1.1.d.1__site_name | group_hc4co39/Site_Alternate_Name | group_hc4co39/Site_Start_Date | group_hc4co39/Site_Close_Date_if_applicable | group_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_coordinates | group_hc4co39/___1.1.f.3__gps_coordinates_latitude | group_hc4co39/___1.1.f.3__gps_coordinates_longitude | group_hc4co39/___1.1.f.3__gps_coordinates_altitude | group_hc4co39/___1.1.f.3__gps_coordinates_precision | group_hc4co39/__1.1.f.2__gps_coordinates_manual_lat | group_hc4co39/__1.1.f.1__gps_coordinates_manual_lon | group_hc4co39/tipo_de_area | group_hc4co39/Comunidad | group_hc4co39/Name_of_nearest_city_town | group_hc4co39/uso_sitio | group_hc4co39/uso_sitio_other | group_hc4co39/Propiedad | group_hc4co39/Propiedad_other | group_hc4co39/area | group_hc4co39/carpas_instaladas | group_hc4co39/carpas_ocupadas | Share_roof | ss_Share_roof_ss | group_site_details/tiene_fecha_limite | group_site_details/fecha_limite | group_site_details/previsto | group_site_details/ir_a_albergue | group_site_details/ir_a_albergue_other | group_site_details/ir_a_albergue_especifique | group_site_details/conoce_condiciones | group_site_details/plan_preferido | group_site_details/porque_razon | group_site_details/plan_menos_preferido | group_site_details/plan_menos_preferido_razon | group_site_details/aplico_bono | group_site_details/bono_aplicado | group_site_details/problemas_bono | group_site_details/descripcion_problema | group_site_details/tienen_titulos | Comments | group_sy6yd58/__2.1.a.1__no_of_households | group_sy6yd58/__2.1.b.1__total_individuals | group_sy6yd58/__2.1.b.2__male_total | group_sy6yd58/__2.1.b.3__female_total | group_sy6yd58/Comments_002 | grupo_etareo/lactantes_m | grupo_etareo/lactantes_f | grupo_etareo/total_bebes_lactantes | grupo_etareo/ninos | grupo_etareo/ninas | grupo_etareo/total_ninos | grupo_etareo/adolescentes_m | grupo_etareo/adolescentes_f | grupo_etareo/total_adolescentes | grupo_etareo/adultos_menor_m | grupo_etareo/adultos_menor_f | grupo_etareo/total_adultos_menor | grupo_etareo/adultos_m | grupo_etareo/adultos_f | grupo_etareo/total_adultos | grupo_etareo/adulto_mayor_m | grupo_etareo/adulto_mayor_f | grupo_etareo/total_adulto_mayor | group_vulnerabilities/embarazadas_menores | group_vulnerabilities/embarazadas_mayores | group_vulnerabilities/total_embarazadas | group_vulnerabilities/lactantes_menores | group_vulnerabilities/lactantes_mayores | group_vulnerabilities/total_mujeres_lactantes | group_vulnerabilities/__2.2.g.2__no_of_men_w_physical_disabilities | group_vulnerabilities/__2.2.g.3__no_of_women_w_physical_disabilities | group_vulnerabilities/__2.2.g.2__no_of_ninos_w_physical_disabilities | group_vulnerabilities/__2.2.g.3__no_of_ninas_w_physical_disabilities | group_vulnerabilities/total_discapacidades_fisicas | group_vulnerabilities/__2.2.h.2__no_of_hombres_w_mental_disabilities | group_vulnerabilities/__2.2.h.3__no_of_mujeres_w_mental_disabilities | group_vulnerabilities/__2.2.h.2__no_of_ninos_w_mental_disabilities | group_vulnerabilities/__2.2.h.3__no_of_ninas_w_mental_disabilities | group_vulnerabilities/total_discapacidades_mentales | group_vulnerabilities/__2.2.f.1__no_of_hombres_with_chronic_diseases_or_serious_medical_conditions | group_vulnerabilities/__2.2.f.1__no_of_mujeres_with_chronic_diseases_or_serious_medical_conditions | group_vulnerabilities/__2.2.f.1__no_of_ninos_with_chronic_diseases_or_serious_medical_conditions | group_vulnerabilities/__2.2.f.1__no_of_ninas_with_chronic_diseases_or_serious_medical_conditions | group_vulnerabilities/total_personas_enfermedades_cronicas | group_vulnerabilities/__2.2.u.7__no_of_hombres_ethnic_minorities | group_vulnerabilities/__2.2.u.8__no_of_mujeres_ethnic_minorities | group_vulnerabilities/__2.2.u.7__no_of_ninos_ethnic_minorities | group_vulnerabilities/__2.2.u.8__no_of_ninas_ethnic_minorities | group_vulnerabilities/total_minorias_etnicas | group_vulnerabilities/__2.2.x.5__no_of_elderly_persons_men | group_vulnerabilities/__2.2.x.6__no_of_elderly_persons_women | group_vulnerabilities/total_ancianos | group_vulnerabilities/__2_2_x_3__number_of_unaccompanied_elderly_men | group_vulnerabilities/__2_2_x_4__number_of_unaccompanied_elderly_women | group_vulnerabilities/total_ancianos_sin_compania | group_vulnerabilities/__2.2.i.5__no_of_unaccompanied_minors_boys | group_vulnerabilities/__2.2.i.6__no_of_unaccompanied_minors_girls | group_vulnerabilities/total_menores_sin_compania | group_vulnerabilities/__2.2.i.7__no_of_separated_minors_boys | group_vulnerabilities/__2.2.i.8__no_of_separated_minors_girls | group_vulnerabilities/total_menores_separados | group_vulnerabilities/__2.2.i.9__no_of_orphan_minors_boys | group_vulnerabilities/__2.2.i.10__no_of_orphan_minors_girls | group_vulnerabilities/total_menores_huerfanos | group_vulnerabilities/__2.2.n.1__no_of_single_mothers_menores | group_vulnerabilities/__2.2.n.1__no_of_single_mothers_mayores | group_vulnerabilities/total_madres_solteras | group_vulnerabilities/__2.2.o.1__no_of_single_fathers_menores | group_vulnerabilities/__2.2.o.1__no_of_single_fathers_mayores | group_vulnerabilities/total_padres_solteros | group_vulnerabilities/__2.2.p.2__no_of_boys_headsofHH | group_vulnerabilities/__2.2.p.3__no_of_girls_headsofHH | group_vulnerabilities/total_menores_cabeza_hogar | group_vulnerabilities/Refugees_and_asylum_seekers_male | group_vulnerabilities/Refugees_and_asylum_seekers_female | group_vulnerabilities/Refugees_and_asylum_seekers_nino | group_vulnerabilities/Refugees_and_asylum_seekers_nina | group_vulnerabilities/total_refugiados | group_mobility/__2.3_j_3__idps_living_in_place_of_displacement | group_mobility/ss_2.3_j_3_ss_idps_living_in_place_of_displacement_specify | group_mobility/identificacion_zonas_asentamiento | group_mobility/zonas_identificadas | group_mobility/familias_asentamiento | group_mobility/ubicacion_familias/__2.3.e.2__admin_1 | group_mobility/ubicacion_familias/__2.3.e.3__admin_2 | group_mobility/ubicacion_familias/__2.3.e.4__admin_3 | group_NFI_Shelter/most_common_shelter | group_NFI_Shelter/most_common_shelter_specify | group_NFI_Shelter/material_techo | group_NFI_Shelter/material_techo_other | group_NFI_Shelter/material_paredes | group_NFI_Shelter/material_paredes_other | group_NFI_Shelter/material_piso | group_NFI_Shelter/material_piso_other | group_NFI_Shelter/repair_materials_needed | group_NFI_Shelter/repair_materials_needed_specify | group_NFI_Shelter/temporary_housing_assistance | group_NFI_Shelter/temporary_housing_assistance_specify | group_NFI_Shelter/NFI_being_distributed | group_NFI_Shelter/NFI_being_distributed_specify | group_NFI_Shelter/most_distributed_NFI | group_NFI_Shelter/most_distributed_NFI_specify | group_NFI_Shelter/most_needed_NFI | group_NFI_Shelter/most_needed_NFI/kits_cocina | group_NFI_Shelter/most_needed_NFI/mosquiteros | group_NFI_Shelter/most_needed_NFI/kits_higiene | group_NFI_Shelter/most_needed_NFI/kits_dignidad | group_NFI_Shelter/most_needed_NFI/ropa | group_NFI_Shelter/most_needed_NFI/kits_herramientas | group_NFI_Shelter/most_needed_NFI/otro | group_NFI_Shelter/most_needed_NFI/ninguno | group_NFI_Shelter/most_needed_NFI_specify | group_WASH/servicio_agua | group_WASH/servicio_saneamiento | group_WASH/servicio_higiene | group_WASH/__4.1.a.1__water_source_location | group_WASH/ss_4.1.a.1_ss_water_source_location_specify | group_WASH/water_storage | group_WASH/water_storage_specify | group_WASH/litros_tanque | group_WASH/cantidad_tanques | group_WASH/drinking_water_quantity | group_WASH/drinking_water_quantity_specify | group_WASH/drinking_water_source | group_WASH/drinking_water_source_specifiy | group_WASH/domestic_water_quantity | group_WASH/domestic_water_quantity_specify | group_WASH/domestic_water_source | group_WASH/domestic_water_source_specify | group_WASH/Inodoros_letrinas | group_WASH/__4.4.a.1__functioning_toilet | group_WASH/duchas | group_WASH/duchas_funcionando | group_WASH/__4.4.b.1__separate_toilets | group_WASH/ss_4.4.b.1_ss_separate_toilets_specify | group_WASH/duchas_separadas | group_WASH/ss_4.5.b.1_ss_separate_bathing_areas_specify | group_WASH/letrinas_hombres | group_WASH/letrinas_mujeres | group_WASH/duchas_hombres | group_WASH/duchas_mujeres | group_WASH/__4_8_b_1__do_toilets_and_bathrooms_have_l | group_WASH/ss_4_8_b_1_ss_do_toilets_and_bathrooms_have_l | group_WASH/__4_5_j_1__do_bathing_areas_have_functioni | group_WASH/ss_4_5_j_1_ss_do_bathing_areas_have_functioni | group_WASH/lavamanos | group_WASH/higiene_personal | group_WASH/higiene_personal_especifique | group_WASH/__4_7_c_2___hygiene_materials_for_women_av | group_WASH/ss_4_7_c_2_ss_hygiene_materials_for_women_av | group_WASH/botes_basura | group_WASH/botes_basura_explique | group_WASH/cuantos_botes | group_WASH/frecuencia | group_Food_nutrition/servicios_alimentacion | group_Food_nutrition/Grupo_si_nutricion/__6.1.b.1__supplementary_feeding_mother | group_Food_nutrition/Grupo_si_nutricion/ss_6.1.b.1_ss_supplementary_feeding_mother_specify | group_Food_nutrition/Grupo_si_nutricion/supplementary_feeding_children | group_Food_nutrition/Grupo_si_nutricion/supplementary_feeding_children_specify | group_Food_nutrition/Grupo_si_nutricion/frecuencia_suplemento_ninos | group_Food_nutrition/Grupo_si_nutricion/alimentacion_especial_dietas | group_Food_nutrition/Grupo_si_nutricion/alimentacion_especial_dietas_especifique | group_Food_nutrition/alimentacion_infantil | group_Food_nutrition/alimentacion_infantil_specify | group_Food_nutrition/comentarios_alimentacion | group_Health/servicios_salud | group_Health/__7.1.b.1__most_prevalent_health_problem | group_Health/ss_7.1.b.1_ss_most_prevalent_health_problem | group_Health/__7.1.b.2__second_most_prevalent_health_problem | group_Health/ss_7.1.b.2_ss_second_most_prevalent_health_problem | group_Health/ss_7.1.p.2_ss_number_of_people_treated_for_se_last_surv_male | group_Health/ss_number_of_people_treated_for_se_last_surv_female | group_Health/ss_number_of_people_treated_for_se_last_surv_total | group_Health/__7.2.a.3__access_to_medicine | group_Health/ss_7.2.a.3_ss_access_to_medicine_specify | group_Health/hombres_mental_tratado | group_Health/mujers_mental_tratado | group_Health/total_mental_tratado | group_Health/acceso_apoyo_psicosocial | group_Health/acceso_apoyo_psicosocial_explique | group_Health/requiere_apoyo_psicosocial | group_Health/requiere_apoyo_psicosocial_explique | group_Health/ninos_psicosocial | group_Health/adolescentes_psicosocial | group_Health/adultos_psicosocial | group_Health/adultos_mayores_psicosocial | group_Health/__7.2.b.1__location_health_facility | group_Health/ss_7.2.b.1_ss_location_health_facility_specify | group_Health/disponibilidad_servicios_salud | group_Health/__7.2.c.2__health_facilities_provider | group_Health/ss_7.2.c.2_ss_health_facilities_provider_other | group_Health/ss_7.2.c.2_ss_health_facilities_provider_specify | group_Health/vacunacion | educacion/__8.1.b.1__access_to_education | educacion/ss_8.1.b.1_ss_access_to_education_specify | educacion/group_education/__8.2.b.1__education_distance | educacion/group_education/ss_8.2.b.1_ss_education_distance_specify | educacion/group_education/porcentaje_escolar | educacion/group_education/porcentaje_escolar_especifique | educacion/group_education/kit_escolar | educacion/group_education/seguro_ir_escuela | group_Livelihood/__9.1.a.5__majority_men_occupation | group_Livelihood/ss_9.1.a.5_ss_majority_occupation_men_other | group_Livelihood/ss_9.1.a.5_ss_majority_occupation_men_specify | group_Livelihood/__9.1.a.6__majority_women_occupation | group_Livelihood/ss_9.1.a.6_ss_majority_occupation_women_other | group_Livelihood/ss_9.1.a.6_ss_majority_occupation_women_specify | group_Livelihood/acceso_ingresos | group_Livelihood/acceso_ingresos_explique | group_Livelihood/__9.2.h.2__with_source_of_income | group_Livelihood/__9.3.a.2__livestock | group_Livelihood/ss_9.3.a.2_ss_livestock_specify | group_Livelihood/__9.1.c.1__cultivation | group_Livelihood/__9.1.c.1__cultivation_specify | group_security/__10.1.a.2__security_available | group_security/ss_10.1.a.2_ss_security_available_specify | group_security/__10.1.e.1__reported_incident | group_security/ss_10.1.e.1_ss_reported_incident_specify_type | group_security/ss_10.1.e.1_ss_reported_incident_specify | group_security/__10.1.b.1__security_provider | group_security/ss_10.1.b.1_ss_security_provider_specify | group_security/presencia_organo_control | group_security/organos_control | group_security/organos_control/defensoria | group_security/organos_control/fiscalia | group_security/organos_control/consejo | group_security/organos_control/dinapen | group_security/organos_control/junta_cantonal | group_security/organos_control/other | group_security/organos_control_other | group_security/sirven | group_security/van_albergues | group_security/tenido_contacto | group_security/resuelven_casos | group_security/__10_1_t_1__are_there_areas_women_and_girl | group_security/ss_10_1_t_1_ss_are_there_areas_women_and_girl_which | group_security/ss_10_1_t_1_ss_are_there_areas_women_and_girl_other | group_security/ss_10_1_t_1_ss_are_there_areas_women_and_girl_specify | group_security/hay_proteccion_menores | group_security/__10_1_u_1__which_child_protection_service | group_security/ss_10_1_u_1_ss_which_child_protection_service | group_security/__10.1.c.1__child_friendly_space | group_security/__10.1.d.1__woman_friendly_space | group_security/__10.2.j.2__gbv_mechanism | group_security/ss_10.2.j.2_ss_gbv_mechanism_specify | group_security/mecanismos_violencia_menores | group_security/mecanismos_violencia_menores_especifique | group_security/ninos_sin_cuidado_dia_noche | group_security/tiempo_libre_ninos | group_security/tiempo_libre_ninos/trabajar | group_security/tiempo_libre_ninos/tareas_domesticas | group_security/tiempo_libre_ninos/estudiar | group_security/tiempo_libre_ninos/ludicas | group_security/tiempo_libre_ninos/tv_redes | group_security/tiempo_libre_ninos/ninguna | group_security/tiempo_libre_adolescentes | group_security/tiempo_libre_adolescentes/trabajar | group_security/tiempo_libre_adolescentes/tareas_domesticas | group_security/tiempo_libre_adolescentes/estudiar | group_security/tiempo_libre_adolescentes/ludicas | group_security/tiempo_libre_adolescentes/tv_redes | group_security/tiempo_libre_adolescentes/actividades_no_positivas | group_security/tiempo_libre_adolescentes/ninguna | group_security/ninos_escombreras_basureros | group_security/ninos_escombreras_basureros_especifique | group_security/__10.3.a.3__women_feel_unsafe | group_security/ss_10.3.a.3_ss_women_feel_unsafe_specify | group_security/__10.3.a.1__men_feel_unsafe | group_security/ss_10.3.a.1_ss_men_feel_unsafe_specify | group_security/__10.3.a.2__children_feel_unsafe | group_security/ss_10.3.a.2_ss_children_feel_unsafe_specify | group_security/__10.2.n.1__relationship_idp | group_security/ss_10.2.n.1_ss_relationship_idp_specify | group_security/__10.2.o.1__relationship_idp_host | group_security/ss_10.2.o.1_ss_relationship_idp_host_specify | group_security/alcohol_drogas | group_security/alcohol_drogas_especifique | group_security/hay_gente_sin_ID | group_security/__10_1_f_1__do_the_majority_of_people_have_number | group_security/ss_10_1_f_1_ss_do_the_majority_of_people_have_specify | group_security/__10.1.s.1__adequate_lighting | group_security/ss_10.1.s.1_ss_adequate_lighting_specify | group_security/__10_2_d_1__what_are_the_types_of_problems | group_security/__10_2_d_1__what_are_the_types_of_problems/vivienda_temporal | group_security/__10_2_d_1__what_are_the_types_of_problems/bienes_no_alimentarios | group_security/__10_2_d_1__what_are_the_types_of_problems/agua_saneamiento_higiene | group_security/__10_2_d_1__what_are_the_types_of_problems/salud | group_security/__10_2_d_1__what_are_the_types_of_problems/comida | group_security/__10_2_d_1__what_are_the_types_of_problems/educacion | group_security/__10_2_d_1__what_are_the_types_of_problems/medios_de_vida | group_security/__10_2_d_1__what_are_the_types_of_problems/ninguno | group_security/__10_2_d_1__what_are_the_types_of_problems/no_sabe | group_security/__10_2_s_2__what_are_the_risk_factors_in_a | group_security/__10_2_s_2__what_are_the_risk_factors_in_a/distancia | group_security/__10_2_s_2__what_are_the_risk_factors_in_a/diseño | group_security/__10_2_s_2__what_are_the_risk_factors_in_a/escombros_daños | group_security/__10_2_s_2__what_are_the_risk_factors_in_a/falta_iluminacion | group_security/__10_2_s_2__what_are_the_risk_factors_in_a/falta_accesso_segregado | group_security/__10_2_s_2__what_are_the_risk_factors_in_a/seguridad | group_security/__10_2_s_2__what_are_the_risk_factors_in_a/discapacidad | group_security/__10_2_s_2__what_are_the_risk_factors_in_a/menor_edad | group_security/__10_2_s_2__what_are_the_risk_factors_in_a/otro | group_security/ss_10_2_s_2_ss_what_are_the_risk_factors_in_a_specify | group_security/__10_2_s_3__are_there_constraints_barriers | group_security/__10_2_s_3__are_there_constraints_barriers_no | group_security/__10_2_s_3__are_there_constraints_barriers_no/distancia | group_security/__10_2_s_3__are_there_constraints_barriers_no/diseño | group_security/__10_2_s_3__are_there_constraints_barriers_no/escombros_daños | group_security/__10_2_s_3__are_there_constraints_barriers_no/falta_iluminacion | group_security/__10_2_s_3__are_there_constraints_barriers_no/falta_accesso_segregado | group_security/__10_2_s_3__are_there_constraints_barriers_no/seguridad | group_security/__10_2_s_3__are_there_constraints_barriers_no/discapacidad | group_security/__10_2_s_3__are_there_constraints_barriers_no/menor_edad | group_security/__10_2_s_3__are_there_constraints_barriers_no/otro | group_security/comments_003 | group_information/informacion_necesaria | group_information/__11.1.c.1__main_topic | group_information/ss_11.1.c.1_ss_main_topic_other | group_information/__11.1.c.1__main_topic_specify | group_information/punto_informacion_albergue | group_information/tipo_de_informacion_provista | group_information/tipo_de_informacion_provista_other | group_information/mecanismo_transmision_quejas | group_information/a_quien_se_dirigen_quejas | group_information/mecansimo_solucion_quejas | group_information/casos_trata | group_information/__11.3.a.1__travel_abroad_information | group_information/ss_11.3.a.1_ss_travel_abroad_information_specify | group_information/__11.3.a.2__travel_abroad_information_yes | group_information/que_se_prometio_en_el_viaje | group_information/ss_que_se_prometio_en_el_viaje | group_information/__11_3_a_5__how_are_travel_abroad_opportun | __version__ | meta/instanceID | _id | _uuid | _submission_time | _index | _parent_table_name | _parent_index | _tags | _notes | Provincia | Canton | Parroquia |
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 Details | B. Site/Settlement Area Details | C. Population Demographics (Best Estimate Number of) | D. Persons with Special Vulnerabilities (Best estimate number of) | E. Mobility | F. Shelter and Non Food Items (NFI) | G. Water, Sanitation and Hygiene | H. Food and Nutrition | I. Health | J. Education | K. Livelihood | L. Protection of Child, Women, and other Vulnerable Persons | M. Communication | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Verified by | Date of verification | Database input by? | Date of input | Survey date dd mm yyyy | Enumerator name person filling out the form? | Survey round | Sex of enumerator | Site name | Site Region | Site District | Village/Town | Site_SSID | Site GPS longitude | Site GPS latitude | Is there a site management committee (SMC) in the site? | If No Answer | Is the site management committee (SMC) made up from the community at the site? | If No Answer | SMC member name or focal point | SMC member phone number | Is there a site management agency at the site | If No Answer | Site classification | Type of organization managing the site | If No Answer | Type of Site | If Other Speciy | Name of SMA | SMA member name or focal point | SMA member phone number | Site start open date dd_mm_yyyy | Site expected closing date | Closing date dd_mm_yyyy | Is there any registration activity? | If No Answer | Is there a service provider contact list? | If No Answer | Accessibility to site? | Estimated area of camp per meter? | Ownership of land of site? | What is the most common type of Shelter? | If Other Speciy | Is WASH support being provided at the site? | If No Answer | Is HEALTH support being provided at the site? | If No Answer | Is SHELTER/NFI support provided at the site? | If No Answer | Is FOOD support provided at the site? | If No Answer | Is PROTECTION support provided at the site? | If No Answer | Is EDUCATION support provided at the site? | If No Answer | Is LIVELIHOOD support being provided at the site? | If No Answer | Place 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/HH | Number 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 group | Have IDPs previously been displaced? | If No Answer | Date of arrival of last IDP group | Area of intended return for largest IDP group? | If No Answer | Region 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 Answer | Name the relocation site (new camp) | Estimated percentage of IDPs sleeping in the site | What is preventing the largest IDP group from returning home? | If No Answer | Percentage 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 NFI | If Other, Specify | Second most needed type of NFI | If Other, Specify | Third most needed type of NFI | If Other, Specify | Is there a need for shelter repair materials? | If No Answer | Location of site's main water source (walking, one-way) | If No Answer | Have water points (hand-pump, piped,...)been improved | If No Answer | How operational are they? | If No Answer | Main non drinking water source provided or available | If Other specify | What is the main drinking water source provided or available | If Other specify | Average amount of water available per day and per person | If No Answer | Is the drinking water potable? | If No Answer | What is the problem with the water? | If Other, Specify | Complaints about drinking water quality? | If No Answer | Condition of most of the latrines | If No Answer | Number of functioning toilets available on-site | Availability of separate male and female toilets? | If No Answer | Garbage disposal type? | If No Answer | Availability of separate male and female bathing areas? | If No Answer | Do toilets and bathrooms have locks from the inside? | If No Answer | Number of garbage disposals points | Solid waste/garbage problem at the site? | If No Answer | Availability of hand washing station filed in with water and soap close to toilets? | If No Answer | Evidence of hand washing practices | If No Answer | Hygiene promotion campaign? | If No Answer | Evidence of open defecation? | If No Answer | Is there access to food (distribution, vouchers, trade, fishing..) | If No Answer | Is there access to a market near from the site? | If No Answer | Frequency of food (or cash/vouchers) distribution | If No Answer | Most common source for obtaining food | If Other, Specify | Screening for malnutrition conducted in the area? (i.e weight, height, mid-upper arm circumference screening) | If No Answer | Availability of supplementary feeding for pregnant and lactating mothers | If No Answer | Availability of supplementary feeding for children | If No Answer | What is the most prevalent health problem at the site | If Other, Specify | What is the second most prevalent health problem at the site | If Other, Specify | What is the third most prevalent health problem at the site | If Other, Specify | Is std (sexually transmitted diseases) a concern on this site? | Regular access to medicine? | If No Answer | Access to health facilities? | If No Answer | Location of health facilities/services | If No Answer | Who provides health facilities/services | If Other, Specify | Access to formal/informal education facilities/services for children from displaced HHs. | If No Answer | Location of formal/informal education facilities/services for children from displaced HHs. | If No Answer | Distance to nearest education facility | If No Answer | Percentage of the children at the site attending school | Occupation/trade of majority of displaced HH (Copying mechanism) | If Other, Specify | Number of HH in the site with a source of income | Access to income generating activities | If No Answer | Is there livestock on site? | If No Answer | Do IDPs have access to land for cultivation? | If No Answer | Is 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 spaces | Number of women friendly spaces | Do the majority of people have identification card or other documentation? | Reporting/referral mechanism for GBV survivors | Do 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 community | Is there adequate lighting in the majority of communal point (WASH facilities, public spaces…) | Where do residents mostly get their information from? | If No Answer | What is the main topic on which the community is requesting information on? | If Other, Specify | Is travel abroad opportunities are being discussed/advertised within the community? | If No Answer | If Yes, Specify Country | meta/instanceID | _id | _uuid | _submission_time | _index | _parent_table_name | _parent_index | _tags | _notes | Comments |
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:
| LGA | WARD | STATUS | LATITUDE | LONGITUDE | SITE MANAGEMENT AGENCY (SMA) | SMA TYPE | REGISTRATION ACTIVITY | SUPPORT WASH | SUPPORT HEALTH | SUPPORT SHELTER/NFI | SUPPORT FOOD | SUPPORT PROTECTION | SUPPORT EDUCATION | SUPPORT LIVELIHOOD | SITE CLASSIFICATION | SITE TYPE | LAND OWNERSHIP | COMMON SHELTER TYPE | NO OF HOUSEHOLDS | INFANTS MALE | INFANTS FEMALE | CHILDREN MALE | CHILDREN FEMALE | YOUTH MALE | YOUTH FEMALE | ADULT MALE | ADULT FEMALE | ELDERLY MALE | ELDERLY FEMALE | TOTAL NUMBER OF IDPS | PREVIOUSLY BEEN DISPLACED | INTENDED RETURN AREA | WHY NOT RETURN | NO SHELTER | TENTS | MAKESHIFT | INDOORS | ACCESS ELECTRICITY | ACCESS SAFE COOKING | HAVE PRIVATE AREAS | HAVE MOSQUITO NETS | MOST NEEDED NFI | WATER SOURCE LOCATION | DRINKING WATER SOURCE | WATER CONSUMPTION | DRINKING WATER POTABLE | DRINKING WATER QUALITY COMPLAINTS | LATRINE CONDITION | FUNCTIONING TOILET | GARBAGE DISPOSAL | SOLID WASTE PROBLEM | HAND WASHING STATIONS | HYGIENE PROMOTION CAMPAIGN | OPEN DEFECATION | ACCESS TO FOOD | ACCESS TO MARKET | DISTRIBUTION FREQUENCY | OBTAINING FOOD | MALNUTRITION SCREENING | MOST PREVALENT HEALTH PROBLEM | ACCESS TO MEDICINE | ACCESS TO HEALTH FACILITY | LOCATION HEALTH FACILITY | HEALTH FACILITIES PROVIDER | ACCESS TO EDUCATION | EDUCATION LOCATION | ATTENDING SCHOOL | MAJORITY OCCUPATION | ACCESS TO INCOME | LIVESTOCK | CULTIVATION |
Haiti - IOM DTM Dataset (June 2016) - Site assessment data
File: rd25_DTM_Master_List_Mar2016.xlsx
| SSID | Camp Name | Commune | Latitude | Longitude | Households | Individuals | Shelters | % Shelters | Eviction | Organization Return | CMA Presence | Committee Presence | Presence of Toilets | Water Provision | Committee for Water | Presence of Bathing | Waste Management | Committee for Garbage | Other Organization provide Services |
Common Fields
From the headers above, there are certain fields which are common to all. These are:
- Latitude
- Longitude
- Location Name (ward, district, camp name etc.)
- Families/Households
- Individuals
Similar Fields
The below fields communicate similar information but are not consistent between the spreadsheets:
- Shelter (either a number of a type)
- Toilet availability (either a number or yes/no)
- Water provision (yes/no or various inconsistent values expressing onsite, offsite and/or distance from water)
- Waste management (yes/no or a type)