Create list of LOINC grade concepts to destandardize

[kzollove]

See the answers for this concept

Follow the rabbit hole from here and here

select *
from prod.concept c
where concept_id = 3019275
union all 
select c.*
from prod.concept c
inner join prod.concept_relationship cr
on c.concept_id =cr.concept_id_2 
and concept_id_1 = 3019275
and relationship_id = 'Has Answer'
and standard_concept = 'S'
union all
select *
from prod.concept c
where concept_id = 40762604
union all 
select c.*
from prod.concept c
inner join prod.concept_relationship cr
on c.concept_id =cr.concept_id_2 
and concept_id_1 = 40762604
and relationship_id = 'Has Answer'
and standard_concept = 'S'

[kzollove]

All concepts I've identified to be destandardized at this point

concept_LOINCtoCM_grade.csv

[kzollove]

Updated list of LOINC concepts to be destandardized:

Source: grade_LOINC.csv