About this Dataset

Hospital Inpatient Discharge Rates, Average Charges, Average Payments, And Charge-to-Payment Ratios By DRG - U.S., Northwest, And Washington State - FY2011

The dataset contains hospital inpatient discharge rates, charges, covered payments, charge-to-payment ratios for the 100 most common DRGs among hospitals in the Medicare Prospective Payment System.
Organization: State of Washington
Last updated: 2020-11-10T17:21:43.665184
Tags: charge-to-payment-ratio, covered-payment, discharge-rate, drg, hospital-charges

Tables

Table 1

@usgov.state_of_washington_hospital_inpatient_discharge_rates_cc73ad6d.table_1

19.39 kB
102 rows
13 columns

CREATE TABLE table_1 (
  "drg_definiton" VARCHAR,
  "u_s_discharges_per_100_000" DOUBLE  -- U.S. - Discharges Per 100,000,
  "u_s_average_charges" DOUBLE  -- U.S. - Average Charges,
  "u_s_average_covered_payments" DOUBLE  -- U.S. - Average Covered Payments,
  "u_s_charge_to_payment_ratio" DOUBLE  -- U.S. - Charge-to-Payment Ratio,
  "nw_discharges_per_100_000" DOUBLE  -- NW - Discharges Per 100,000,
  "nw_average_charges" DOUBLE  -- NW - Average Charges,
  "nw_average_covered_payments" DOUBLE  -- NW - Average Covered Payments,
  "nw_charge_to_payment_ratio" DOUBLE  -- NW - Charge-to-Payment Ratio,
  "wa_discharges_per_100_000" DOUBLE  -- WA - Discharges Per 100,000,
  "wa_average_charges" DOUBLE  -- WA - Average Charges,
  "wa_average_covered_payments" DOUBLE  -- WA - Average Covered Payments,
  "wa_charge_to_payment_ratio" DOUBLE  -- WA - Charge-to-Payment Ratio
);