Changes

Page history
Update drugs authored by Cossin Sebastien's avatar Cossin Sebastien
Show whitespace changes
Inline Side-by-side
drugs.md
View page @ 73ad1b82
...@@ -38,10 +38,11 @@ To sum-up we have: ...@@ -38,10 +38,11 @@ To sum-up we have:
* CIS-CIP relations in the **ANSM-database** * CIS-CIP relations in the **ANSM-database**
* CIS-UCD relations in our local hospital database system * CIS-UCD relations in our local hospital database system
By following the path UCD-CIS-CIP we can find mappings between UCD codes and standards concepts.
### Mapping process ### Mapping process
We have a total of 11,096 French drugs in our hospital database system that were administered at least one time. We have a total of 11,096 French drugs in our hospital database system, drugs that were administered at least one time.
In this repository we removed all drugs prescribed less than 30 times (see drugs_to_map.csv file). Only 7.4% of our hospital drugs don't have a UCD code. In this git repository we removed all drugs prescribed less than 30 times (see drugs_to_map.csv file). Only 7.4% of our hospital drugs don't have a UCD code.
```sql ```sql
SELECT DRUG_SOURCE_CONCEPT_ID, COUNT(*) AS FREQUENCY FROM OMOP.DRUG_EXPOSURE SELECT DRUG_SOURCE_CONCEPT_ID, COUNT(*) AS FREQUENCY FROM OMOP.DRUG_EXPOSURE
... ...
......