If you just want to see the prices with the things, this is a more abbreviated query:

SELECT `hospital_id`, `row_id`, `line_type`, `description`, `payer_category`, `payer_name`, `standard_charge` FROM `rate`

Adding an 'order by' clause makes the query time out.

"CC" in many of the descriptions seems to mean "complications and comorbidity". "MCC" is Major Complication or Comorbidity. Some other abbreviations can be looked up here: https://www.asha.org/practice-portal/professional-issues/doc...