OMOP cohort discovery

Standardized cohort counts on the OMOP Common Data Model v5.4 built from the governed silver layer. Counts are aggregate only; record level access goes through Research Access and the honest broker.

Cohort size

224

Malignant tumor of colon

Index years

2010 to 2025

First diagnosis in the CDM

Age at index

18 to 90

No drug criterion

Query time

10 ms

Aggregate counts only

Persons by index year and sex

Cohort definition SQL

WITH first_dx AS (
  SELECT co.person_id, min(co.condition_start_date) AS index_date
  FROM omop.condition_occurrence co
  WHERE co.condition_concept_id = 4180790
  GROUP BY co.person_id
)
SELECT extract(year FROM f.index_date)::int AS index_year,
       g.concept_name AS sex,
       count(*) AS persons
FROM first_dx f
JOIN omop.person p ON p.person_id = f.person_id
LEFT JOIN omop.concept g ON g.concept_id = p.gender_concept_id
WHERE extract(year FROM f.index_date) BETWEEN 2010 AND 2025
  AND extract(year FROM f.index_date) - p.year_of_birth BETWEEN 18 AND 90
GROUP BY 1, 2
ORDER BY 1, 2

CDM tables

Table	Rows
`omop.person`	2,500
`omop.observation_period`	2,500
`omop.visit_occurrence`	80,785
`omop.condition_occurrence`	116,151
`omop.procedure_occurrence`	131,467
`omop.drug_exposure`	57,484
`omop.measurement`	259,234
`omop.concept`	121
`omop.source_to_concept_map`	84

Vocabulary mapping coverage

Domain table	Records	Mapped to standard concept	Coverage
`condition_occurrence`	116,151	116,114	99.97%
`procedure_occurrence`	131,467	131,467	100.00%
`drug_exposure`	57,484	57,484	100.00%
`measurement`	259,234	259,234	100.00%

Unmapped source codes keep concept_id 0 and are routed to the vocabulary curation queue.