Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Same lab/drug (labevents, chartevents) should be under same concepts #2

Open
sunbiz opened this issue Jul 12, 2022 · 0 comments
Open

Comments

@sunbiz
Copy link
Member

sunbiz commented Jul 12, 2022

To avoid duplicates through distinct itemid, we are able to import fewer obs because concepts that have similar names in prescriptions, labevents, and chartevents have different itemid in d_items and d_labitems.

e.g. SELECT * FROM mimic4.d_labitems l, mimic4.d_items i where l.label LIKE i.label; produces Hemoglobin with 4 different itemid that should refer to the same concept.

image

One approach could be create a mapping CSV that links all d_labitems.itemid to d_items.itemid and creates only one concept, for which obs.concept_id is the same, even if the obs came from chartevents, labevents, prescription or elsewhere.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant