Major Diagnostic Categories Summary by US Government | Healthcare

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.42 MB
1048576 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
);