Total admissions ICU/Med
Jump to navigation
Jump to search
Total number of encounters in the ICU and Medicine in Database: CCMDB.
This article is tagged to be reviewed periodically. The next scheduled review is on 2023-01-01.
As of 2021-12-31:
| Number of profiles | |
| Critical Care | 138141 |
| Medicine | 211415 |
| Total | 349556 |
Data Collection Start Dates for each Hospital in Region Go to: Site and Location table
SQL
To generate a per-unit count in Access paste the following:
SELECT Count(L_Log.D_ID) AS CountOfD_ID, s_dispo.program FROM L_Log INNER JOIN s_dispo ON L_Log.Service_Location = s_dispo.dispo_ID GROUP BY s_dispo.program;
Related articles
| Related articles: |
|