500. Aggregation

Price summaries per shoppable service, by network and by professional/facility, restricted to comparable fee-for-service dollar prices.

Read medians, not means. These summaries still include "ghost rates" — placeholder prices for services a provider never actually bills (often a tiny fraction of Medicare). They drag the lower tail and the mean down but barely move the median. We do not hard-drop them (any cutoff is a judgement call); the analysis page flags prices below 25% of Medicare. See the guide section on ghost rates.
Contents

Summary by procedure x provider-type x network x snapshot

.     di as result "saved price summary by network: `=_N' rows"
saved price summary by network: 1703 rows

Summary by procedure x provider-type (across networks)

.     di as result "saved overall price summary: `=_N' rows"
saved overall price summary: 167 rows

.     di as txt _n "Most price-dispersed services (top 15 by p90/p10, n>=20 prices):"

Most price-dispersed services (top 15 by p90/p10, n>=20 prices):



.     list service_label provider_type p50 p10 p90 p9010 n_prices ///
>         if n_prices>=20 in 1/`=min(_N,15)', noobs sep(0) abbreviate(26)

  +---------------------------------------------------------------------------------------------------------+
  |                     service_label   provider_type        p50       p10        p90      p9010   n_prices |
  |---------------------------------------------------------------------------------------------------------|
  |       Total shoulder arthroplasty   institutional    3248.91   1375.12   28807.94    20.9494       3717 |
  |            Total hip arthroplasty   institutional   12539.82   1428.88   29751.77   20.82174       3558 |
  |                  ED visit level 5   institutional     572.94    260.43       5080    19.5062       3686 |
  |           Total knee arthroplasty   institutional    13159.8   1540.34   29751.77   19.31507       3549 |
  |                  ED visit level 4   institutional     386.97    177.76       3040   17.10171       3846 |
  |                  ED visit level 3   institutional     245.67    111.67       1456   13.03842       3831 |
  |         CT head/brain wo contrast    professional      80.61     30.46      326.6   10.72226      24258 |
  |       Polysomnography sleep study    professional     337.83     94.28     863.57   9.159631      27628 |
  |      Office visit new pt 15-29min   institutional      66.72     25.77     221.62   8.599922       3217 |
  |      Office visit est pt 30-39min   institutional     108.01     40.01     342.44    8.55886       3148 |
  |      Office visit new pt 45-59min   institutional     178.14     65.59     557.51   8.499924       3113 |
  |           MRI brain w/wo contrast   institutional     492.88    252.78    2046.72   8.096843       3652 |
  | Echocardiogram complete w Doppler   institutional     152.38     69.27     548.82    7.92291       3735 |
  |      Office visit est pt 10-19min   institutional      29.23     12.97     101.46   7.822668       4076 |
  |        Antepartum care 4-6 visits   institutional     617.57    378.63    2937.12    7.75723       1773 |
  +---------------------------------------------------------------------------------------------------------+