About this Dataset

Acute Care Hospital Transfers By Major Diagnostic Category (MDC)

The three datasets (i.e., Transfer-Encounters, Transfer-Outcomes, Transfer-Locations) provide the number of hospital transfers and Major Diagnostic Categories (MDCs). The Transfer-Encounters Dataset provides transfer counts by patient characteristics (i.e., Race/Ethnicity, Language Group, Expected Payer, Age Group and Assigned Sex at Birth) for each MDC. The Transfer-Outcomes shows the transfer outcomes (i.e., Median Length of Stay, Percent of Leaving Against Medical Advice and Percent of Inpatient Death) by MDC. The Transfer-Location dataset shows the locations of Acute Care Hospitals which received at least 25 transfers by MDC.
Organization: State of California
Last updated: 2024-03-30T03:38:23.613426
Tags: department-of-health-care-access-and-information, hcai, healthcare-encounters, hospitals, inpatient-discharges, outcomes, transfers

Tables

Data Dictionary - Locations

@usgov.ca_gov_acute_care_hospital_transfers_by_major_diagnost_143e1f56.data_dictionary_locations

3.83 KB
4 rows
4 columns


CREATE TABLE data_dictionary_locations (
  "field_title" VARCHAR,
  "field_name" VARCHAR,
  "data_type" VARCHAR,
  "description" VARCHAR
);

Data Dictionary - Outcomes

@usgov.ca_gov_acute_care_hospital_transfers_by_major_diagnost_143e1f56.data_dictionary_outcomes

3.74 KB
3 rows
4 columns


CREATE TABLE data_dictionary_outcomes (
  "field_title" VARCHAR,
  "field_name" VARCHAR,
  "data_type" VARCHAR,
  "description" VARCHAR
);

Data Dictionary - Transfers

@usgov.ca_gov_acute_care_hospital_transfers_by_major_diagnost_143e1f56.data_dictionary_transfers

3.96 KB
5 rows
4 columns


CREATE TABLE data_dictionary_transfers (
  "field_title" VARCHAR,
  "field_name" VARCHAR,
  "data_type" VARCHAR,
  "description" VARCHAR
);