Hospital Inpatient - Characteristics By Patient County Of Residence by US Government | Healthcare

About this Dataset

Hospital Inpatient - Characteristics By Patient County Of Residence

This dataset contains annual hospital inpatient summary data based upon the Patient’s County of Residence. The summary data includes discharge disposition, expected payer, sex, Medicare Severity-Diagnosis Related Group (MS-DRG), Major Diagnostic Categories (MDC), race group, admission source, and type of care.
Organization: State of California
Last updated: 2023-08-12T12:00:29.329774
Tags: department-of-health-care-access-and-information, diagnosis-code, disposition, expected-payer, external-cause, frequencies, gender, hcai, hospital, inpatient, mdc, medicare-severity-diagnosis-related-group, ms-drg, patient-county, pdd, procedure-code, race-group, sex, source-of-admission, type-of-care

Tables

Hospital Inpatient Characteristics - Disposition By Patient County Of Residence

@usgov.ca_gov_hospital_inpatient_characteristics_by_patient_c_986910a9.hospital_inpatient_characteristics_disposition_by_pati_0450b782

35.71 KB
10266 rows
4 columns


CREATE TABLE hospital_inpatient_characteristics_disposition_by_pati_0450b782 (
  "patcnty1" VARCHAR,
  "dsch_yr" BIGINT,
  "disp1" VARCHAR,
  "discharges" BIGINT
);

Hospital Inpatient Characteristics - Expected Payer By Patient County Of Residence

@usgov.ca_gov_hospital_inpatient_characteristics_by_patient_c_986910a9.hospital_inpatient_characteristics_expected_payer_by_p_e787e299

27.7 KB
6494 rows
4 columns


CREATE TABLE hospital_inpatient_characteristics_expected_payer_by_p_e787e299 (
  "patcnty1" VARCHAR,
  "dsch_yr" BIGINT,
  "pay_cat1" VARCHAR,
  "discharges" BIGINT
);

Hospital Inpatient Characteristics - Sex By Patient County Of Residence

@usgov.ca_gov_hospital_inpatient_characteristics_by_patient_c_986910a9.hospital_inpatient_characteristics_sex_by_patient_coun_a50155d4

15.28 KB
1853 rows
6 columns


CREATE TABLE hospital_inpatient_characteristics_sex_by_patient_coun_a50155d4 (
  "patcnty1" VARCHAR,
  "dsch_yr" BIGINT,
  "sex" VARCHAR,
  "discharges" DOUBLE,
  "annotationcode" DOUBLE,
  "annotationdesc" VARCHAR
);

Hospital Inpatient Characteristics – MS-DRG By Patient County Of Residence

@usgov.ca_gov_hospital_inpatient_characteristics_by_patient_c_986910a9.hospital_inpatient_characteristics_ms_drg_by_patient_c_a142b4e0

1.27 MB
421595 rows
7 columns


CREATE TABLE hospital_inpatient_characteristics_ms_drg_by_patient_c_a142b4e0 (
  "patcnty1" VARCHAR,
  "dsch_yr" BIGINT,
  "msdrg" BIGINT,
  "msdrgcode" VARCHAR,
  "discharges" VARCHAR,
  "annotationcode" DOUBLE,
  "annotationdesc" VARCHAR
);

Hospital Inpatient Characteristics - MDC By Patient County Of Residence

@usgov.ca_gov_hospital_inpatient_characteristics_by_patient_c_986910a9.hospital_inpatient_characteristics_mdc_by_patient_coun_43c93fcd

62.88 KB
17776 rows
7 columns


CREATE TABLE hospital_inpatient_characteristics_mdc_by_patient_coun_43c93fcd (
  "patcnty1" VARCHAR,
  "dsch_yr" BIGINT,
  "mdc" BIGINT,
  "mdc_desc" VARCHAR,
  "discharges" DOUBLE,
  "annotationcode" DOUBLE,
  "annotationdesc" VARCHAR
);

Hospital Inpatient Characteristics – Race Group By Patient County Of Residence

@usgov.ca_gov_hospital_inpatient_characteristics_by_patient_c_986910a9.hospital_inpatient_characteristics_race_group_by_patie_76efe8b2

29.61 KB
5564 rows
6 columns


CREATE TABLE hospital_inpatient_characteristics_race_group_by_patie_76efe8b2 (
  "patcnty1" VARCHAR,
  "dsch_yr" BIGINT,
  "race_grp1" VARCHAR,
  "discharges" VARCHAR,
  "annotationcode" DOUBLE,
  "annotationdesc" VARCHAR
);

Hospital Inpatient Characteristics – Admission Source By Patient County Of Residence

@usgov.ca_gov_hospital_inpatient_characteristics_by_patient_c_986910a9.hospital_inpatient_characteristics_admission_source_by_bd60ff2b

32.92 KB
7654 rows
6 columns


CREATE TABLE hospital_inpatient_characteristics_admission_source_by_bd60ff2b (
  "patcnty1" VARCHAR,
  "dsch_yr" BIGINT,
  "srcsite1" VARCHAR,
  "discharges" DOUBLE,
  "annotationcode" DOUBLE,
  "annotationdesc" VARCHAR
);

Hospital Inpatient Characteristics – Type Of Care By Patient County Of Residence

@usgov.ca_gov_hospital_inpatient_characteristics_by_patient_c_986910a9.hospital_inpatient_characteristics_type_of_care_by_pat_41689cfe

17.54 KB
3565 rows
4 columns


CREATE TABLE hospital_inpatient_characteristics_type_of_care_by_pat_41689cfe (
  "patcnty1" VARCHAR,
  "dsch_yr" BIGINT,
  "typcare1" VARCHAR,
  "discharges" BIGINT
);