{"text_format":"3","workbook":"xls","n_sheets":2,"sheets":["Sheet1","Sheet2"],"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Sheet1","index":0,"n_rows":24,"n_cols":5,"rows_kept":24,"merged":[[1,0,4,0],[1,1,4,1],[1,4,2,4],[5,0,6,0],[5,1,6,1],[5,4,6,4],[7,0,8,0],[7,1,8,1],[7,4,8,4],[9,0,11,0],[9,1,11,1],[9,4,11,4],[12,0,15,0],[12,1,15,1],[12,4,15,4],[16,0,20,0],[16,1,20,1],[16,4,20,4],[17,3,20,3],[21,0,23,0],[21,1,23,1],[21,4,23,4]],"flags":["formulas_cached_only"]}
["Supplementary data source","Description","Attribute","Description","See usage in mapping scripts [34]"]
["OMOP CTD","Comparative Toxicogenomics Database (CTD) (retrieved from OHDSI’s Athena)","CONCEPT.concept_name","substance names","omop/sql/inn_ctd.sql"]
[null,null,"CONCEPT.concept_code","CAS numbers (Chemical Abstract Service Registry Number)"]
[null,null,"CONCEPT_SYNONYM.concept_synonym_name","substance name synonyms in various languages","omop/sql/inn_ctd_syn.sql"]
[null,null,"CONCEPT_RELATIONSHIP.*","‘Maps to’ relationships are used to link CTD concepts to RxN/E Ingredients","omop/sql/inn_ctd.sql"]
["OMOP ATC","ATC drug classification system (retrieved from OHDSI’s Athena)","CONCEPT.concept_code","ATC codes","omop/sql/atc_rx.sql"]
[null,null,"CONCEPT_RELATIONSHIP.*","using the 'ATC - RxNorm pr lat' relationships, ATC codes are assigned to RxN/E Ingredients and Precise Ingredient"]
["EDQM-RX","Mapping from RxNorm Dose Forms to EDQM Dose Forms used for drugs described by the European Medicines Agency (EMA)","sheet ‘Ontology + RxNorm’ column C ‘EDQM DOSAGE FORMS’","EDQM dosage forms","aux/edqm_rx.py"]
[null,null,"sheet ‘Ontology + RxNorm’ column D ‘RXNORM DOSAGE FORMS’","RxNorm dose forms assigned to EDQM dose forms"]
["EMA-PI","URLs to product information sheets for drug products recognized by EMA","Domain","only product information sheets with domain “human” are used","aux/ema_pi.py"]
[null,null,"URL(currentwebsite)","URLs used to do download the product information sheet documents"]
[null,null,"downloaded PDFs","From the downloaded PDFs, ‘PHARMACEUTICAL FORM’ and ‘MARKETING AUTHORISATION NUMBER’ starting with ‘EU/’ are extracted and used tp assign EDQM dose forms to EU registration numbers"]
["SMS","Substance names in various European Languages","Status","only substances marked with ‘Current’ are considered","aux/sms.py"]
[null,null,"Substance_Domain","only ‘Human use’ substances are considered"]
[null,null,"Language","to determine the language of this substance name"]
[null,null,"Substance_Name","textual name of a substance (and its synonyms)"]
["BEZVO","Substance names required to be used in regulatory affairs in Germany. This dataset is given as XML document","SUBSTANCES/SUBSTANCE/CAS","CAS numbers (Chemical Abstract Service Registry Number) of a given substance","aux/bezvo.py"]
[null,null,"SUBSTANCES/SUBSTANCE/HBEZ1","Substance names and synonyms"]
[null,null,"SUBSTANCES/SUBSTANCE/HBEZ2"]
[null,null,"SUBSTANCES/SUBSTANCE/HBEZ3"]
[null,null,"SUBSTANCES/SUBSTANCE/TSYN"]
["TTT","Mapping of Hungarian medicines to RxNorm and RxNorm Extension, mapped by hand in 2021","EU","EU registration numbers ","-"]
[null,null,"Rx_ClinicalDrugBox","assigned RxN/E concept of class clinical drug box"]
[null,null,"Rx_ClinicalDrug","assigned RxN/E concept of class clinical drug"]

{"sheet":"Sheet2","index":1,"n_rows":25,"n_cols":5,"rows_kept":25,"merged":[[18,3,21,3]],"flags":["formulas_cached_only"]}
["Supplementary data source","Description","Attribute","Description","Link"]
["OMOP CTD","Concepts from the Comparative Toxicogenomics Database (CTD) incorporated into OMOP’s vocabularies. Concepts use the CAS numbers (Chemical Abstract Service Registry Number) as code","CONCEPT.concept_id",null,"omop/sql/inn_ctd.sql"]
[null,null,"CONCEPT.concept_name","substance name"]
[null,null,"CONCEPT.concept_code","CAS numbers (Chemical Abstract Service Registry Number)"]
[null,null,"CONCEPT_SYNONYM.concept_synonym_name","substance name synonyms in various languages","omop/sql/inn_ctd_syn.sql"]
[null,null,"CONCEPT_RELATIONSHIP.*","‘Maps to’ relationship is used to link CTD concepts to RxN/E Ingredients","omop/sql/inn_ctd.sql"]
["OMOP ATC","Concepts from the World Health Organizations (WHO) ATC drug classification system. These concepts are augmented by OMOP with a variety of  relationships to RxNorm and RxNorm Extension.","CONCEPT.concept_code","ATC code","omop/sql/atc_rx.sql"]
[null,null,"CONCEPT_RELATIONSHIP.*","using the 'ATC - RxNorm pr lat' relationship, ATC codes are assigned to RxN/E Ingredients (and Precise Ingredient)","omop/sql/atc_rx.sql"]
["EDQM-RX","Mapping from RxNorm Dose Forms to EDQM Dose Forms used for drugs described by the European Medicines Agency (EMA)","sheet ‘Ontology + RxNorm’ column C ‘EDQM DOSAGE FORMS’","EDQM dosage forms","aux/edqm_rx.py"]
[null,null,"sheet ‘Ontology + RxNorm’ column D ‘RXNORM DOSAGE FORMS’","RxNorm doseforms assigned to EDQM dose forms","aux/edqm_rx.py"]
["EMA-PI","URLs to product information sheets for drug products recognized by EMA","Domain","only product information sheets with domain “human” are used","aux/ema_pi.py"]
[null,null,"URL(currentwebsite)","URLs used to do download the product information sheet documents","aux/ema_pi.py"]
[null,null,"downloaded PDFs","From the downloaded PDFs, ‘PHARMACEUTICAL FORM’ and ‘MARKETING AUTHORISATION NUMBER’ starting with ‘EU/’ are extracted and used tp assign EDQM dose forms to EU registration numbers","aux/ema_pi.py"]
["SMS","Substance names in various European Languages","Status","only substances marked with ‘Current’ are considered","aux/sms.py"]
[null,null,"Substance_Domain","only ‘Human use’ substances are considered","aux/sms.py"]
[null,null,"Language","to determine the language of this substance name","aux/sms.py"]
[null,null,"Substance_Name","textual name of a substance (and its synonyms)","aux/sms.py"]
["BEZVO","Substance names required to be used in regulatory affairs in Germany. This dataset is given as XML document","SUBSTANCES/SUBSTANCE/CAS","CAS numbers (Chemical Abstract Service Registry Number) of a given substance","aux/bezvo.py"]
[null,null,"SUBSTANCES/SUBSTANCE/HBEZ1","Substance name and synonyms"]
[null,null,"SUBSTANCES/SUBSTANCE/HBEZ2"]
[null,null,"SUBSTANCES/SUBSTANCE/HBEZ3"]
[null,null,"SUBSTANCES/SUBSTANCE/TSYN"]
["TTT","Mapping of Hungarian medicines to RxNorm and RxNorm Extension, mapped by hand in 2021","EU","EU registration numbers "]
[null,null,"Rx_ClinicalDrugBox","assigned RxN/E concept of class clinical drug box"]
[null,null,"Rx_ClinicalDrug","assigned RxN/E concept of class clinical drug"]