The International Organization for Migration (IOM) is the leading inter-governmental organization in the field of migration and works closely with governmental, intergovernmental and non-governmental partners. It is dedicated to promoting humane and orderly migration for the benefit of all and works to help ensure the orderly and humane management of migration, to promote international cooperation on migration issues, to assist in the search for practical solutions to migration problems and to provide humanitarian assistance to migrants in need, including refugees and internally displaced people.
The Displacement Tracking Matrix (DTM) continually tracks and monitors displacement across countries allowing IOM to identify the locations to which IDPs have chosen to settle. The location and population of these IDPs are recorded and further in-depth assessments are conducted to identify the multi-sectorial needs of the displaced.
IOM is currently working on a global DTM out of their office in Geneva. The goal is to produce a monthly combined DTM for all countries, starting with camp status (the type of DTM usually shared on HDX), and about 25 columns (which they refer to as "indicators"). The global DTM will be HXL tagged. We've also begun discussions between UNHCR (Laurent Pitoiset) and IOM (Muhammad Rizki) to ensure that the HXL tags they use for refugee and migrant data are well-aligned, and each is interested in becoming a consumer of the other's data.
The initial overview and first analysis of the data structure of datasets have been moved into separate pages, so that this page contains the latest analysis (below).
Jump to Initial Overview
Jump to Data Structure - First Analysis
Data Structure - Second Analysis
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)
Conclusion
Given the lack of any consistency between the DTM Master List spreadsheets, writing a one size fits all automated data checker and cleaner for all of them is challenging. It would involve placing a great deal of "intelligence" into the cleaning program with the possibility that errors are introduced during cleaning for example, by accidentally matching the wrong column heading when making an algorithm to match a very diverse range of names. It may be possible to write cleaners per country but the effort involved would be large.
A better approach is to try to encourage the different offices to use a similar template for their spreadsheets, as from this starting point, writing a cleaner would not be too onerous. If such a template were introduced, it could be HXLated from day one. How easy it would be to invent a template that covers the range of needs is debatable but it is likely to be much easier than trying to process greatly varying spreadsheet formats.
Appendix: IOM Global DTM information
The following files contain a data dictionary and partial sample for the in-progress global DTM, as supplied by IOM in Geneva.
This Google Sheet contains proposed HXL hashtags for the global DTM: https://docs.google.com/spreadsheets/d/1gifTnrz9A2fZ8Tuwg-EClsFvu4QEbC4OUtdgb61dXGs/edit?usp=sharing