At least half the households under the North Municipal Corporation get contaminated water, a study by the civic agency has revealed.