These measures describe the charge and length of stay averages for the state. The measures are separated by individual MS-DRG numbers and they can all be grouped under measure group id 149.
If total charge was excessively low (total charges < $0) or high ( > $1 million), then the sample was excluded from the median/mean calculation.
...
In samples where the total charge was excluded, so was the length of stay.
Queries
Acquiring data on Median /Average LOS and Median/Average Charges
select a.* from entity_values as a, measure_groups_measures as b
where a.measure_id = b.measure_id
and a.entity_id = ######
and b.measure_group_id = 14914
Acquiring data on both Average LOS and Average ChargesMedian Length of Stay
select a.* from entity_values as a, measure_groups_measures as b
where a.measure_id = b.measure_id
and a.entity_id = ######
and b.measure_group_id in (145,146)= 15
Acquiring data on both Median LOS and Median Charges
select a.* from entity_values as a, measure_groups_measures as b
where a.measure_id = b.measure_id
and a.entity_id = ######
and b.measure_group_id in (14714,14815)