search

uf-hobi-informatics-lab / UTH-omoponfhir-main-v54-r4

OMOP v5.4 on FHIR R4 with SQL Render - GUI Server
Apache License 2.0
0 stars 0 forks source link

look up omoponfhir query and share with uth site #3

Open huyuaaaray opened 1 month ago

huyuaaaray commented 1 month ago

using xiaohan's ontology information to query on omoponfhir

huyuaaaray commented 1 month ago

original dashboard and the patient counts only showed after manually read: Image

  1. ATC (Anatomical Therapeutic Chemical (ATC) Classification) This only has one entry Apixabn

Image

  1. ConceptCode This corresponds to the Code column on Athena (https://athena.ohdsi.org/search-terms/start)

  2. ConceptID This corresponds to the ID column on Athena

  3. DrugBankID This is not used at all

  4. has_Athena It appears that this should be the same as ConceptID given most of the values are identical, but for some entries the URI to Athena as a string is given instead of the actual ID.

  5. has_MONDO There's only 1 entry Atrial_Fibrillation

  6. MeSH There's only 1 entry Atrial_Fibrillation

  7. RxNorm This is not used at all

  8. SNOMED By the name of it, it should be the SNOMED Code which corresponds to the ConceptCode property, but in reality it is the same as ConceptID.

  9. synonym Synonym of the concepts as a string

  10. UMLS_CUI There's only 1 entry Atrial_Fibrillation

query results: Image Athena: Image database cache: Image

For most of codes shown above, I cannot search out any samples except for the Apixaban ATC: B01AF02, which can return 1 count: { "resourceType": "Bundle", "id": "2b076dd2-3cd1-4d17-99a6-f8fbe35ef939", "meta": { "lastUpdated": "2024-10-07T14:07:08.321+00:00", "tag": [ { "system": "http://terminology.hl7.org/CodeSystem/v3-ObservationValue", "code": "SUBSETTED", "display": "Resource encoded in summary mode" } ] }, "type": "searchset", "total": 1 }

Query details link: https://docs.google.com/spreadsheets/d/1QXh3ceyS2YwvyuC5E0I2lLtl9vNtOwNdf7PbYcJ_r6Q/edit?usp=sharing

huyuaaaray commented 1 month ago

When i search 431855005 on the condition page, it shows: Image