About this Dataset

Major Diagnostic Categories Summary

This dataset provides the adjusted length of stay, type of care, discharges with valid charges, charges by hospital, licensure of bed, and Major Diagnostic Category (MDC).
Organization: State of California
Last updated: 2023-08-25T21:29:10.329817
Tags: adjusted-length-of-stay, charges, department-of-health-care-access-and-information, discharges, hcai, inpatient-discharge-data, major-diagnostic-category, mdc, valid-charges

Tables

Table 1

@usgov.ca_gov_major_diagnostic_categories_summary_38976.table_1

8.83 MB
1,048,576 rows
11 columns

CREATE TABLE table_1 (
  "discharge_yr" BIGINT,
  "oshpd_id" BIGINT,
  "facility_name" VARCHAR,
  "hospital_county" VARCHAR,
  "hospital_zip" BIGINT,
  "typecare" VARCHAR,
  "adjusted_length_of_stay" BIGINT,
  "mdc" VARCHAR,
  "payer" VARCHAR,
  "discharges" BIGINT,
  "valid_charges" BIGINT
);