You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
The org_name column in the microbiologyevents table contains the data "CANCELLED" (org_itemid: 90760). Is this a case the culture was implemented but the culture was cancelled?
In order to identify negative culture, should I add the condition if org_name="CANCELLED"?
me AS (
SELECT micro_specimen_id
-- the following columns are identical for all rows
-- of the same micro_specimen_id
-- these aggregates simply collapse duplicates down to 1 row
, MAX(subject_id) AS subject_id
, MAX(hadm_id) AS hadm_id
, CAST(MAX(chartdate) AS DATE) AS chartdate
, MAX(charttime) AS charttime
, MAX(spec_type_desc) AS spec_type_desc
-- identify negative cultures as NULL organism
-- or a specific itemid saying "NEGATIVE"
, MAX(
CASE WHEN org_name IS NOT NULL
AND org_itemid != 90856
AND org_name != ''
THEN 1 ELSE 0
END) AS positiveculture
FROM mimiciv_hosp.microbiologyevents
GROUP BY micro_specimen_id
)
The text was updated successfully, but these errors were encountered:
The org_name column in the microbiologyevents table contains the data "CANCELLED" (org_itemid: 90760). Is this a case the culture was implemented but the culture was cancelled?
In order to identify negative culture, should I add the condition if org_name="CANCELLED"?
https://github.com/MIT-LCP/mimic-code/blob/main/mimic-iv/concepts_postgres/sepsis/suspicion_of_infection.sql
The text was updated successfully, but these errors were encountered: