About this Dataset

Four Quarter Financial Summary Hospital Utilization Charity Care And Bad Debt Summary

This dataset provides the fourth quarter summary roll-up of California hospitals’ financial and utilization data for Charity Care and Bad Debts.
Organization: State of California
Last updated: 2024-11-27T01:04:40.921850
Tags: bad-debt, charity-care, debts, department-of-health-care-access-and-information, hcai, ogi, payer-source, qfur, quarterly-financial-and-utilization-report

Tables

Table 1

@usgov.ca_gov_four_quarter_financial_summary_hospital_utiliza_8906bcbb.table_1

104.53 kB
2,653 rows
14 columns

CREATE TABLE table_1 (
  "year" BIGINT,
  "oshpd_id" BIGINT,
  "facility_name" VARCHAR,
  "county" VARCHAR,
  "type_of_ownership" VARCHAR,
  "hospital_type" VARCHAR,
  "teaching" VARCHAR,
  "small_rural" VARCHAR,
  "average_licensed_beds" BIGINT,
  "average_available_beds" BIGINT,
  "average_staffed_beds" BIGINT,
  "bad_debts" VARCHAR,
  "charity_care" VARCHAR,
  "location" VARCHAR
);