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

missing rxcui ids in rxcui_setid_map table #68

Open
inessmit opened this issue Jan 7, 2025 · 0 comments
Open

missing rxcui ids in rxcui_setid_map table #68

inessmit opened this issue Jan 7, 2025 · 0 comments
Assignees

Comments

@inessmit
Copy link

inessmit commented Jan 7, 2025

I'm using Onsides version 20240925

I notice many rxcui ids that are in the adverse_reactions table but they don't appear in the rxcui_setid_map table.
Examples: 10582 (levothyroxine), 6851 (methotrexate), 1202 (atenolol).

select * from rxcui_setid_map rsm where rxcui in (1202, 10582, 6851);
returns no results

This means that there is no traceable setid to provide a link to the source data of the adverse events in the adverse_reactions table, so the data has no provenance.

However there is data for e.g. levothyroxine in the adverse_reactions table, e.g.
the query

select * from adverse_reactions_active_labels aral 
where aral.ingredients_names like '%levothyroxine%';

returns various results including e.g. setid 73c3d459-dcbf-4458-8edd-2637275a96a1, which is indeed about levothyroxine.
However it's mapped to rxcui 892255 in the rxcui_setid_map table.

select * from rxcui_setid_map rsm where rsm.setid = '73c3d459-dcbf-4458-8edd-2637275a96a1'

Is there be any guidance on how to navigate this?

@zietzm zietzm self-assigned this Jan 15, 2025
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

2 participants