Common Medical Procedure Prices in Utah

Pursuant to the Utah Health Data Authority Act, Section 106 (UCA 26-33a-106.5), the Office of Health Care Statistics (OHCS) has produced a list common medical procedures and their associated costs for Utah's commercially-insured market, using the state's All Payer Claims Database (APCD).The 25th, 50th, 75th and average charged and allowed amount percentiles will be displayed for both line items and claim headers (entire claim cost).

The analysis breaks the claims into groupings based on the Health Care Cost Institute methodology.

Flags are created to identify professional or technical components as well as an assistant surgeon indicator. Additionally, place of service codes are used to classify professional claims as facility or non-facility categories.

Please see methodology further information.

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"opendata-utah-gov/common-medical-procedure-prices-in-utah-6c3e-vvdg\".\"common_medical_procedure_prices_in_utah\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.