Parsed from dump: 30 regions, 145 districts, 3994 wards, 1913 postcodes. Added district 'Njombe' (new id 152) to region 'Njombe' — it was missing from the legacy district table but wards referenced it. Added district 'Kibiti' (new id 153) to region 'Pwani' — it was missing from the legacy district table but wards referenced it. Corrected district reference 'mtakuja' -> 'geita' on ward rows. Corrected district reference 'mangeni' -> 'moshi' on ward rows. Corrected district reference 'chunyak' -> 'chunya' on ward rows. Corrected district reference 'mbinga mjini b' -> 'mbinga' on ward rows. Corrected district reference 'kiliua' -> 'kaliua' on ward rows. Corrected district reference 'llala' -> 'ilala' on ward rows. Fixed 2 postcode rows whose code/ward columns were swapped. Result: 30 regions (4 verification), 147 districts (0 duplicates merged, 2 added), 4058 wards (59 duplicates merged, 125 copies created for same-named districts across regions), 2023 wards carry a postcode, 186 ambiguous postcodes resolved by region prefix. Wards whose district was not found (NOT imported — add them with bin/add.php if needed): - Msisi (id 137, district 'Mtitaa') - Arumeru (id 3988, district 'Ambureni') Postcodes whose ward was not found (NOT imported — add the ward with bin/add.php if needed): - 'poli' -> 23304 - 'seela seela sing'isi' -> 23305 - 'sokon i' -> 23115 - 'ngorongoro' -> 23719 - 'mtitaa' -> 41318 - 'chilonwa' -> 41401 - 'idifun' -> 41415 - 'zajilwa' -> 41430 - 'bugulula' -> 30132 - 'mtakuja' -> 30106 - 'kamsisi' -> 50325 - 'basanza' -> 47610 - 'mabogini' -> 25201 - 'mengeni' -> 25707 - 'mchinga' -> 65131 - 'mkotokuyana' -> 65308 - 'mnero miembeni' -> 65313 - 'naipanga' -> 65309 - 'luchelegwa' -> 65615 - 'gallapo' -> 27212 - 'mogitu' -> 27303 - 'lengatei' -> 27515 - 'ndirgishi' -> 27520 - 'ayamohe' -> 27401 - 'marang' -> 27415 - 'loiborsiret' -> 27615 - 'neruma' -> 31518 - 'bukabwa' -> 31205 - 'buswahili' -> 31225 - 'bukumi' -> 31123 - 'nyakatende' -> 31137 - 'nyathorogo' -> 31316 - 'machochwe' -> 31611 - 'ganyange' -> 31430 - 'madibira' -> 53610 - '53133' -> 53220 - 'utengule /usongwe' -> 53208 - 'kawetele' -> 53505 Postcodes attached to every same-named ward because no region prefix matched: - 'majengo' code 25104 (no region prefix match — attached to all 19 candidates)