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: 2024-11-27T01:04:36.165276
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_f5ff8b85.table_1

261.81 KB
11556 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
);