About this Dataset

Tri-State Hospital Quarterly Revenue

Tri-State Memorial Hospital was founded in 1955. It serves the Lewis-Clark Valley with 25 licensed beds. This dataset provides revenue figures for several clinical units and patient-types. The data are taken from quarterly reports provided by the Washington Department of Health.
Organization: State of Washington
Last updated: 2021-08-07T14:18:24.600566
Tags: asotin-county

Tables

Table 1

@usgov.state_of_washington_tri_state_hospital_quarterly_revenue.table_1

47.38 KB
32 rows
54 columns


CREATE TABLE table_1 (
  "year" BIGINT,
  "quarter" BIGINT,
  "acutemedicareinpatientrevenue" BIGINT,
  "acutemedicaidinpatientrevenue" BIGINT,
  "acuteselfpayinpatientrevenue" BIGINT,
  "acuteotherinpatientrevenue" BIGINT,
  "acutemedicareoutpatient" BIGINT,
  "acutemedicaidoutpatientrevenue" BIGINT,
  "acuteselfpayoutpatientrevenue" BIGINT,
  "acuteotheroutpatientrevenue" BIGINT,
  "swingbedmedicarerevenue" BIGINT,
  "swingbedmedicaidrevenue" BIGINT,
  "swingbedselfpayrevenue" BIGINT,
  "swingbedotherrevenue" BIGINT,
  "snfmedicarerevenue" BIGINT,
  "snfmedicaidrevenue" BIGINT,
  "snfselfpayrevenue" BIGINT,
  "snfotherrevenue" BIGINT,
  "psychrehab_cdumedicarerevenue" BIGINT,
  "psychrehab_cdumedicaidrevenue" BIGINT,
  "psychrehab_cduselfpayrevenue" BIGINT,
  "psychrehab_cduotherrevenue" BIGINT,
  "homehealthmedicarerevenue" BIGINT,
  "homehealthmedicaidrevenue" BIGINT,
  "homehealthselfpayrevenue" BIGINT,
  "homehealthotherrevenue" BIGINT,
  "acutecontractualmedicare" BIGINT,
  "acutecontractualmedicaid" BIGINT,
  "acutecontractualselfpay" BIGINT,
  "acutecontractualother" BIGINT,
  "othercontractualmedicare" BIGINT,
  "othercontractualmedicaid" BIGINT,
  "othercontractualselfpay" BIGINT,
  "othercontractualother" BIGINT,
  "totalcharitycare" BIGINT,
  "facilitypayroll" BIGINT,
  "facilitypaidhours" BIGINT,
  "physicianpayroll" BIGINT,
  "physicianpaidhours" BIGINT,
  "employeebenefitexpenses" BIGINT,
  "supplyexpenses" BIGINT,
  "depretiationexpenses" BIGINT,
  "interestexpenses" BIGINT,
  "baddebts" BIGINT,
  "allotherexpenses" BIGINT,
  "otheroperatingrevenue" BIGINT,
  "operatingmargin" BIGINT,
  "netnonoperatinggains_losses" BIGINT,
  "taxsubsidies" BIGINT,
  "grossaccountsreceivedmedicare" BIGINT,
  "grossaccountsreceivedmedicaid" BIGINT,
  "grossaccountsreceivedselfpay" BIGINT,
  "grossaccountsreceivedother" BIGINT,
  "casemixindex" DOUBLE
);