To map lab results we have an amazing source in LOINC and it is the “answer of” relationship. However, many strings that are actual results of a proper measurement_concept_id are not part of the set, or even labs that have no concepts with that relationship.
If we map the string using concept_name there are cases where there is more than one concept_id with the same concept_name string. The query below gives some examples
STRING_AGG(DISTINCT(vocabulary_id), " ,") as vocabulary,
COUNT(DISTINCT concept_id) AS counts
AND domain_id = “Meas Value”
Some interesting examples
There are 47 unique concept_names with more than 100 concept_ids assigned