About this Dataset

Four Quarter Summary Hospital Utilization Operating Revenue And Profit Margins

This dataset provides the fourth quarter summary roll-up of California hospitals’ financial and utilization data for net and operating margins.
Organization: State of California
Last updated: 2023-08-12T11:42:20.108157
Tags: department-of-health-care-access-and-information, hcai, margins, net-operating, ogi, operating-revenue, qfur, quarterly-financial-and-utilization-report

Tables

Table 1

@usgov.ca_gov_four_quarter_summary_hospital_utilization_opera_abaef67f.table_1

135.36 kB
2,463 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" BIGINT,
  "available_beds" BIGINT,
  "staffed_beds" BIGINT,
  "pretax_net_income" BIGINT,
  "other_operating_rev" VARCHAR,
  "total_operating_rev" VARCHAR,
  "total_margin" VARCHAR,
  "operating_margin" VARCHAR,
  "location" VARCHAR
);