OHDSI Home | Forums | Wiki | Github

Urgent: Vocabulary Release for the upcoming Covid-19 Study-a-thon

vocabularies

(Christian Reich) #1

Friends:

The Vocab team just finished the latest update on the Standardized Vocabularies. As usual, turned out a LOT more work that anticipated. Here is what you need to know:

  1. If you are getting your data ready for the study-a-thon, or for the subsequent activities, please:
  • Download the latest from Athena.
  • Read the instructions carefully. Covid-19 is happening rapidly, and the representation in source data is developing equally rapidly.
  1. If you are working on cohorts to apply to the studies please
  • Read the instructions to make sure you develop the right conceptsets and criteria
  • Have your Atlas refreshed with a database built or refreshed through 1).
  • If you don’t have that, use Athena to browse the vocabularies

All questions welcome, as usual.


(Christian Reich) #2

But, why would things be easy, if they can be complicated. Turns out we made a booboo. If you are working with the new LOINC concepts for Coronavirus 2 detection you will find them in the Vocabularies, but unfortunately as non-standard. You have two choices:

  • You wait for the hot fix on Monday (which will also fix the hierarchy)
  • You make your own hot fix and set the field standard_concept to “S” in the CONCEPT table for concept_ids 706154, 706155, 706156, 706157, 706158, 706159, 706160, 706161, 706162, 706163, 706164, 706165, 706166, 706167, 706168, 706169, 706170, 706171, 706172, 706173, 706174, 706175, 706176, 706177, 706178, 706179, 706180, 706181.

Or in SQL:

update concept set standard_concept='S' where concept_id in (706154, 706155, 706156, 706157, 706158, 706159, 706160, 706161, 706162, 706163, 706164, 706165, 706166, 706167, 706168, 706169, 706170, 706171, 706172, 706173, 706174, 706175, 706176, 706177, 706178, 706179, 706180, 706181)
;

If you don’t have such codes disregard this. Sorry for the craziness.


#3

Favipiravir, an approved drug in Japan for influenza, is undergoing clinical trials for Covid-19. There isn’t a standard drug code in Athena yet.


(Seng Chan You) #4

Awesome @Christian_Reich Thank you so much!


(Christian Reich) #5

Friends: No booboo anymore. Please disregard the message above and just download from Athena. You will need it to be able to participate in the study-a-thon.

You got it. Will add to the next hot release. For all other folks not having data with this drug - don’t wait for that release.


(Alexander Davydov) #6

Hi @CSung,

We added this ingredient to the vocabularies. Will be available through Athena on the earliest release.

concept_id concept_name domain_id vocabulary_id concept_class_id standard_concept concept_code valid_start_date valid_end_date invalid_reason
32765 Favipiravir Drug RxNorm Extension Ingredient S OMOP4873976 01-01-70 31-12-99 NULL

(Alexander Davydov) #7

We added some more Drug ingredients. Already available with the latest release in Athena:
Tagging @CSung

concept_id concept_name domain_id vocabulary_id concept_class_id standard_concept concept_code valid_start_date valid_end_date invalid_reason
32764 Umifenovir Drug RxNorm Extension Ingredient S OMOP4873975 01-01-70 31-12-99 NULL
32765 Favipiravir Drug RxNorm Extension Ingredient S OMOP4873976 01-01-70 31-12-99 NULL
32766 Middle East Respiratory Syndrome heterologous combined adenoviral-based vector vaccine Drug RxNorm Extension Ingredient S OMOP4873977 01-01-70 31-12-99 NULL
32767 Carrimycin Drug RxNorm Extension Ingredient S OMOP4873978 01-01-70 31-12-99 NULL
32768 CD24 Extracellular Domain-IgG1 Fc Domain Recombinant Fusion Protein CD24Fc Drug RxNorm Extension Ingredient S OMOP4873979 01-01-70 31-12-99 NULL
32769 Tetrandrine Drug RxNorm Extension Ingredient S OMOP4873980 01-01-70 31-12-99 NULL
32770 Xiyanping Drug RxNorm Extension Ingredient S OMOP4873981 01-01-70 31-12-99 NULL

(Andrew S. Kanter, MD MPH FACMI FAMIA) #8

These were drugs we added for the CIEL dictionary (code is the CIEL concept ID). I’d be interested if people are using the other ones added by Alexander? Should they be added to CIEL for the open source EHR community?

165872 Tocilizumab Drug Misc
165873 Sarilumab Drug Misc
165874 Baricitinib Drug Misc
165875 Boceprevir Drug Misc
165876 Siltuximab Drug Misc
165877 Favilavir Drug Misc
165878 Remdesivir Drug Misc
165879 Pegylated interferon alfa-2b Drug Misc
165880 Pegylated interferon alfa-2a Drug Misc
165881 Pegylated interferon beta-1a Drug Misc

Here is a link to Open Concept Lab for a starter set of mapped concepts around COVID-19. It was released prior to some additional concepts including those above: https://openconceptlab.org/orgs/CIEL/collections/COVID-19-Starter-Set/concepts/


t