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.
...
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.
Country DTMs
(Unless otherwise noted, all datasets are shared by IOM and consist of a single DTM round.)
Country DTMs are not well-standardised, though IOM in Geneva is starting an initiative to define a common core set of columns. Some countries use databases to manage their DTMs, while others are entirely spreadsheet based. Note that as of 2016-09-23, most of the DTMs on HDX are operationally out-of-date (shared once but not updated regularly).
...
HDX dataset
...
Date
...
Notes
...
...
2016-04-30
...
...
2015-10-31
...
Raw DTM (with some sensitive fields removed). Much-more granular than the other examples, with 175 columns, and structured as a survey. This lets us see what the DTM originally looks like, before it’s digested into the high-level reports that are more typically shared publicly. Includes ADM1, ADM2, “Payam”, and “Village”, as well as site id and lat/lon. Lists number of IDPs and households.
...
Nepal - IOM DTM Earthquake Dataset
...
2015-11-25
...
IOM DTM Mozambique Dataset Round 1
...
2015-04-30
...
Libya - IOM DTM Dataset Round 1
...
2016-01-10
...
...
2016-01-20
...
Multiple rounds.
...
...
2015-12-30
...
Multiple rounds.
...
...
2016-01-28
...
Multiple rounds.
...
...
2015-11-30
...
...
2016-03-01
...
...
2015-11-03
...
...
2015-11-30
...
Iraq - Displacement Tracking Matrix (DTM) 14 Sept 2014
...
2014-09-14
...
Shared by OCHA Iraq.
...
Iraq - Affected Persons Locations (DTM) 7 August 2014
...
2014-08-07
...
Shared by OCHA Iraq.
...
Iraq - Affected Persons Locations(DTM) 24 August 2014
...
2014-08-24
...
Shared by OCHA Iraq.
...
...
2014-09-01
...
Shared by HDX team. Multiple rounds.
...
Iraq - Affected Persons Locations(25 November 2014)
...
2014-11-25
...
Shared by OCHA Iraq.
...
Iraq - Affected Persons Locations(Jun to July 2014)
...
2014-07-02
...
Shared by OCHA Iraq.
...
Malawi - Displacement Tracking Matrix
...
2015-05-20
...
Shared by OCHA ROSA.
...
Malawi - Displacement Tracking Matrix
...
2015-03-06
...
Shared by OCHA ROSA.
...
...
2015-03-06
...
Shared by OCHA ROSA.
...
...
2015-05-31
...
Shared by OCHA Mali.
Data Structure - First Analysis
Some spreadsheets have "master list" in the title and some do not.
Taking the latest master list for a few countries, unfortunately we see that the DTMs do not have a fixed structure.
Below are examples of different headings for various DTM spreadsheets:
Libya: rd4_DTM_Master_List_Jun2016.xlsx
This is at an aggregated rather than survey level, has several sheets and 2 rows of headers for the main sheet entitled "1-DTM Round 4 Dataset":
...
Nigeria: rd10_DTM_Master_List_Jun2016.xlsx
This is at an aggregated level and has just one sheet "Sheet1" with a single line header:
...
Iraq: rd_50_DTM_Master_List_July2016.xlsx
This is at an aggregated level and has two sheets. The main sheet is "DTM DATASET" with a two line header:
...
Yemen: r4_DTM_Master_List_Apr2016.xlsx
This has aggregated level data in different sheets. Sheet "Returnee hybrid data Locationlv" which has a single line header:
...
Sheet "IDPs Raw data" has this single line header:
...
Common Fields
From the headers above, there are certain fields which are common to all. These are:
...
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
...
- 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 appears to be at a survey level. There are 3 sheets with the sheet "uploaded_form_izr7j1" containing the data.
IOM DTM Somalia - Site Assessment Data
File: IOM_SOM_DTM_Master_Data_Site_Assessments_Final_Rou...XLS
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
...