#!/bin/sh
g.region rast=conus_countyns
r.mask -r
v.db.select -c tl_2022_us_county col=COUNTYNS,NAMELSAD,STATEFP sep=tab | sort |
while read l; do
	echo "$l" | sed "s/\t[0-9]*$/, $(v.db.select -c tl_2022_us_state col=STUSPS where="STATEFP='$(echo "$l" | cut -d"	" -f 3)'")/"
done > conus_countyns.cats

r.category conus_countyns rules=conus_countyns.cats