Total admissions ICU/Med: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) m updated numbers while I was in here anyway. |
||
| Line 2: | Line 2: | ||
{{Article needing periodic review | {{Article needing periodic review | ||
| NextReviewDate = 2022- | | NextReviewDate = 2022-11-09 | ||
}} | }} | ||
As of 2021- | As of 2021-11-09: | ||
{| class="wikitable" | {| class="wikitable" | ||
|- | |- | ||
| Line 13: | Line 13: | ||
|- valign="bottom" | |- valign="bottom" | ||
|| [[Definition of a Critical Care Laptop Admission|Critical Care]] | || [[Definition of a Critical Care Laptop Admission|Critical Care]] | ||
|| | || 137276 | ||
|- valign="bottom" | |- valign="bottom" | ||
|| [[Definition of a Medicine Laptop Admission|Medicine]] | || [[Definition of a Medicine Laptop Admission|Medicine]] | ||
|| | || 209556 | ||
|- valign="bottom" | |- valign="bottom" | ||
|| Total | || Total | ||
|| | || 346832 | ||
|} | |} | ||
| Line 35: | Line 35: | ||
</pre> | </pre> | ||
== Related articles == | |||
{{Related Articles}} | |||
[[Category: Reporting]] | [[Category: Reporting]] | ||
[[Category: Statistical Analysis]] | [[Category: Statistical Analysis]] | ||
[[Category: About]] | |||
Revision as of 21:49, 9 November 2021
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 2022-11-09.
As of 2021-11-09:
| Number of profiles | |
| Critical Care | 137276 |
| Medicine | 209556 |
| Total | 346832 |
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: |