SELECT area, area_name, CASE WHEN ((length(area) = 5)) THEN ('municipality') WHEN ((length(area) = 9)) THEN ('small_area') WHEN ((length(area) = 11)) THEN ('small_area_detail') ELSE NULL END AS area_level, cat01, family_type, cat02, secrecy, unit, "value" FROM {DUCKLAKE_CATALOG}.census.stg_census_small_area_household