Original data:
https://docs.google.com/spreadsheets/d/12Dow11-pajFyt7V8Vt5CBYkllueaFJkIbKBH9gsbZhc/edit#gid=0
Test merge of DTM baseline assessments from multiple countries. Currently includes Burundi, Cameroon, CAR, Libya, Madagascar, Mali, and Nigeria.
| Region name | Country name | Country code (ISO3) | Admin 1 name | Admin 1 P-code | Total IDP households | Total IDP individuals | Report date |
|---|---|---|---|---|---|---|---|
| #region+name | #country+name | #country+code | #adm1+name | #adm1+code | #affected+hh+idps | #affected+ind+idps | #date+reported |
| Africa | Burundi | BDI | Bubanza | BDI001 | 2229 | 11200 | 2019-01-31 |
| Africa | Burundi | BDI | Bujumbura Mairie | BDI017 | 4791 | 24149 | 2019-01-31 |
| Africa | Burundi | BDI | Bujumbura Rural | BDI002 | 2758 | 14012 | 2019-01-31 |
| Africa | Burundi | BDI | Bururi | BDI003 | 736 | 3461 | 2019-01-31 |
| Africa | Burundi | BDI | Cankuzo | BDI004 | 3367 | 17557 | 2019-01-31 |
| Africa | Burundi | BDI | Cibitoke | BDI005 | 1700 | 8408 | 2019-01-31 |
| Africa | Burundi | BDI | Gitega | BDI006 | 785 | 3710 | 2019-01-31 |
| Africa | Burundi | BDI | Karuzi | BDI007 | 226 | 889 | 2019-01-31 |
| Africa | Burundi | BDI | Kayanza | BDI008 | 814 | 2516 | 2019-01-31 |
| Africa | Burundi | BDI | Kirundo | BDI009 | 1676 | 5530 | 2019-01-31 |
| Africa | Burundi | BDI | Makamba | BDI010 | 1697 | 8535 | 2019-01-31 |
| Africa | Burundi | BDI | Muramvya | BDI011 | 204 | 911 | 2019-01-31 |
| Africa | Burundi | BDI | Muyinga | BDI012 | 2009 | 7769 | 2019-01-31 |
| Africa | Burundi | BDI | Mwaro | BDI013 | 77 | 253 | 2019-01-31 |
| Africa | Burundi | BDI | Ngozi | BDI014 | 399 | 1557 | 2019-01-31 |
| Africa | Burundi | BDI | Rumonge | BDI018 | 1493 | 7864 | 2019-01-31 |
| Africa | Burundi | BDI | Rutana | BDI015 | 1656 | 7756 | 2019-01-31 |
| Africa | Burundi | BDI | Ruyigi | BDI016 | 1623 | 7977 | 2019-01-31 |
| Africa | Cameroon | CMR | Extrême-Nord | CMR004 | 40484 | 245725 | 2018-11-30 |
| Africa | Central African Republic | CAF | Bamingui-Bangoran | CF51 | 1871 | 9121 | 2018-12-31 |
| Africa | Central African Republic | CAF | Bangui | CF71 | 8103 | 40515 | 2018-12-31 |
| Africa | Central African Republic | CAF | Basse-Kotto | CF61 | 14805 | 64045 | 2018-12-31 |
| Africa | Central African Republic | CAF | Haut-Mbomou | CF63 | 10476 | 46090 | 2018-12-31 |
| Africa | Central African Republic | CAF | Haute-Kotto | CF52 | 16948 | 89093 | 2018-12-31 |
| Africa | Central African Republic | CAF | Mbomou | CF62 | 17720 | 84359 | 2018-12-31 |
| Africa | Central African Republic | CAF | Nana-Gribizi | CF42 | 25257 | 120455 | 2018-12-31 |
| Africa | Central African Republic | CAF | Ouaka | CF43 | 21425 | 107996 | 2018-12-31 |
| Africa | Central African Republic | CAF | Ouham Pendé | CF31 | 3852 | 19018 | 2018-12-31 |
| Africa | Libya | LBY | East | LY01 | 10927 | 54832 | 2018-12-31 |
| Africa | Libya | LBY | South | LY03 | 9316 | 46630 | 2018-12-31 |
| Africa | Libya | LBY | West | LY02 | 13406 | 69028 | 2018-12-31 |
| Africa | Madagascar | MDG | Androy | MDG52 | 1311 | 5250 | 2018-04-30 |
| Africa | Mali | MLI | Bamako | MLI09 | 547 | 3023 | 2019-01-30 |
| Africa | Mali | MLI | Gao | MLI07 | 6847 | 33602 | 2019-01-30 |
| Africa | Mali | MLI | Kayes | MLI01 | 125 | 626 | 2019-01-30 |
| Africa | Mali | MLI | Kidal | MLI08 | 59 | 313 | 2019-01-30 |
| Africa | Mali | MLI | Koulikouro | MLI02 | 207 | 1162 | 2019-01-30 |
| Africa | Mali | MLI | Mopti | MLI05 | 7566 | 56495 | 2019-01-30 |
| Africa | Mali | MLI | Segou | MLI04 | 1446 | 7726 | 2019-01-30 |
| Africa | Mali | MLI | Sikasso | MLI03 | 26 | 103 | 2019-01-30 |
| Africa | Mali | MLI | Tombouctou | MLI06 | 3491 | 20524 | 2019-01-30 |
| Africa | Nigeria | NGA | ADAMAWA | NG002 | 34707 | 194603 | 2019-01-20 |
| Africa | Nigeria | NGA | BAUCHI | NG005 | 10985 | 66716 | 2019-01-20 |
| Africa | Nigeria | NGA | BORNO | NG008 | 297290 | 1435817 | 2019-01-20 |
| Africa | Nigeria | NGA | GOMBE | NG016 | 5679 | 36882 | 2019-01-20 |
| Africa | Nigeria | NGA | TARABA | NG035 | 14129 | 86474 | 2019-01-20 |
| Africa | Nigeria | NGA | YOBE | NG036 | 19506 | 127857 | 2019-01-20 |