In the morning light, I see my syntax error(s)!
Now for Ting from 0.19-q-20211027142973-dev-a3xelte
content query --uri content://telephony/carriers --where "numeric='310240'"
Row: 0 _id=1202, name=Ting Data, numeric=310240, mcc=310, mnc=240, carrier_id=-1, apn=wireless.dish.com, user=, server=, password=, proxy=, port=, mmsproxy=, mmsport=, mmsc=http://wholesale.mmsmvno.com/mms/wapenc, authtype=-1, type=default,admin,fota,mms,supl,hipri,internet,dun, current=NULL, protocol=IPV4V6, roaming_protocol=IPV4V6, carrier_enabled=1, bearer=0, bearer_bitmask=0, network_type_bitmask=0, mvno_type=, mvno_match_data=, sub_id=-1, profile_id=0, modem_cognitive=0, max_conns=0, wait_time=0, max_conns_time=0, mtu=0, edited=0, user_visible=1, user_editable=1, owned_by=1, apn_set_id=0, skip_464xlat=-1
A second numeric I see used, 310260 produces 27 results, two include Ting.
content query --uri content://telephony/carriers --where "numeric='310260'"
Row: 11 _id=1214, name=Ting MMS, numeric=310260, mcc=310, mnc=260, carrier_id=-1, apn=wholesale, user=, server=, password=, proxy=, port=, mmsproxy=, mmsport=, mmsc=http://wholesale.mmsmvno.com/mms/wapenc, authtype=-1, type=default,mms,supl,admin, current=NULL, protocol=IP, roaming_protocol=IP, carrier_enabled=1, bearer=0, bearer_bitmask=0, network_type_bitmask=0, mvno_type=, mvno_match_data=, sub_id=-1, profile_id=0, modem_cognitive=0, max_conns=0, wait_time=0, max_conns_time=0, mtu=0, edited=0, user_visible=1, user_editable=1, owned_by=1, apn_set_id=0, skip_464xlat=-1
Row: 25 _id=1228, name=Ting Data, numeric=310260, mcc=310, mnc=260, carrier_id=-1, apn=wholesale, user=, server=, password=, proxy=, port=, mmsproxy=, mmsport=, mmsc=, authtype=-1, type=default,admin,fota,mms,supl,hipri,internet,dun, current=NULL, protocol=IPV6, roaming_protocol=IPV6, carrier_enabled=1, bearer=0, bearer_bitmask=0, network_type_bitmask=0, mvno_type=, mvno_match_data=, sub_id=-1, profile_id=0, modem_cognitive=0, max_conns=0, wait_time=0, max_conns_time=0, mtu=0, edited=0, user_visible=1, user_editable=1, owned_by=1, apn_set_id=0, skip_464xlat=-1