SQL Server 2019

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table QueueData(fieldValue varchar(4000));

insert into QueueData values('[  {    "Conviction_Docket": "1995_FEL_xxxxx",    "Conviction_Count": "",    "Conviction_ChargeCode": "011524",    "Conviction_Charge": "*Attempted",    "Conviction_Multiplier": 1,    "Conviction_OffenseType": "Drug",    "Conviction_Severity": "Misdemeanor Not Counted",    "Conviction_Adult": 1,    "Conviction_Juvenile": 0,    "Conviction_Adult_Revived": 0,    "Conviction_Accessary": 0,    "Conviction_Calculation": "0"  },  {    "Conviction_Docket": "2012-CTF-xxxxxx",    "Conviction_Count": "1",    "Conviction_ChargeCode": "000000",    "Conviction_Charge": "Driving Under Influence-1st Off",    "Conviction_Multiplier": 1,    "Conviction_OffenseType": "Other",    "Conviction_Severity": "Misdemeanor",    "Conviction_Adult": 1,    "Conviction_Juvenile": 0,    "Conviction_Adult_Revived": 0,    "Conviction_Accessary": 0,    "Conviction_Calculation": "0.25"  },  {    "Conviction_Docket": "xxxxx-0xx",    "Conviction_Count": "2",    "Conviction_ChargeCode": "0000",    "Conviction_Charge": "DUI (1st) Under Influence 40-716",    "Conviction_Multiplier": 1,    "Conviction_OffenseType": "Other",    "Conviction_Severity": "Duplicate",    "Conviction_Adult": 1,    "Conviction_Juvenile": 0,    "Conviction_Adult_Revived": 0,    "Conviction_Accessary": 0,    "Conviction_Calculation": "0"  },  {    "Conviction_Docket": "000000",    "Conviction_Count": "1",    "Conviction_ChargeCode": "",    "Conviction_Charge": "Possession of CDS",    "Conviction_Multiplier": 1,    "Conviction_OffenseType": "Drug",    "Conviction_Severity": "Misdemeanor",    "Conviction_Adult": 1,    "Conviction_Juvenile": 0,    "Conviction_Adult_Revived": 0,    "Conviction_Accessary": 0,    "Conviction_Calculation": "0.25"  },  {    "Conviction_Docket": "2004 CTF 005113",    "Conviction_Count": "2",    "Conviction_ChargeCode": "",    "Conviction_Charge": "DUI 1st Off",    "Conviction_Multiplier": 1,    "Conviction_OffenseType": "Other",    "Conviction_Severity": "Misdemeanor",    "Conviction_Adult": 1,    "Conviction_Juvenile": 0,    "Conviction_Adult_Revived": 0,    "Conviction_Accessary": 0,    "Conviction_Calculation": "0.25"  }]');

1 rows affected

Docket	Count	Charge	Severity
xxxxx-0xx	2	DUI (1st) Under Influence	Duplicate