About this Dataset

Fourth Quarter Summary Hospital Utilization Net Patient Revenue By Payer Source

This dataset provides the fourth quarter summary roll-up of California hospitals’ financial and utilization data for net patient revenue by payer source.
Organization: State of California
Last updated: 2024-11-27T01:04:31.942023
Tags: department-of-health-care-access-and-information, hcai, net-patient-revenue-by-payer-source, ogi, qfur, quarterly-financial-and-utilization-report

Tables

Table 1

@usgov.ca_gov_fourth_quarter_summary_hospital_utilization_net_6728dfc3.table_1

309.44 kB
10,901 rows
16 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" BIGINT,
  "available_beds" BIGINT,
  "staffed_beds" BIGINT,
  "total_by_payer" VARCHAR,
  "total_net_patient_rev" VARCHAR,
  "net_patient_rev_payer_percent" VARCHAR,
  "payer" VARCHAR,
  "location" VARCHAR
);