Cohort Definition for Covid Lab confirmed OR Diagnosed - National-Clinical-Cohort-Collaborative/Data-Ingestion-and-Harmonization GitHub Wiki

Sept 25, 2020

Based on Phenotype 2.2

SELECT distinct p.person_id > FROM person p > LEFT JOIN measurement m ON p.person_id = m.person_id > WHERE m.measurement_concept_id IN ('757680','757679','757678','757677','723459','715262','715261','715260','706181','706180','706179','706178','706177','706176','706175','706174','706173','706172','706171','706170','706169','706168','706167','706166','706165','706163','706161','706160','706159','706158','706157','706156','706155','706154','586526','586523','586522','586521','586520','586519','586518','586517','586516','586515') > and

"Positive" result

> m.value_as_concept_id IN ('4126681','45877985','45884084','9191', '36715206', '45881802')

> UNION

Covid dx ICD10 code (U07.1)

> SELECT distinct p.person_id > FROM person p > JOIN condition_occurrence co ON p.person_id = co.person_id > WHERE co.condition_concept_id = '37311061'