About this Dataset

Four Quarter Summary Hospital Utilization Patient Days By Type Of Ownership

This dataset provides the fourth quarter summary roll-up of California hospitals’ financial and utilization data for average patient days by type of ownership.
Organization: State of California
Last updated: 2025-07-23T21:41:02.019952
Tags: department-of-health-care-access-and-information, hcai, ogi, patient-days-by-type-of-ownership, qfur, quarterly-financial-and-utilization-report

Tables

Table 1

@usgov.ca_gov_four_quarter_summary_hospital_utilization_patie_efd00d19.table_1

268.09 kB
11,556 rows
17 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,
  "licensed_beds" DOUBLE,
  "available_beds" DOUBLE,
  "staffed_beds" DOUBLE,
  "patient_days_by_payer" VARCHAR,
  "total_patient_days" BIGINT,
  "total_patient_days_percent" VARCHAR,
  "payer" VARCHAR,
  "ltc_patient_days" BIGINT,
  "location" VARCHAR
);

Table 2

@usgov.ca_gov_four_quarter_summary_hospital_utilization_patie_efd00d19.table_2

7.86 kB
17 rows
4 columns

CREATE TABLE table_2 (
  "column" VARCHAR,
  "type" VARCHAR,
  "label" VARCHAR,
  "description" VARCHAR
);