OMOP Research CDM Endorsed
OMOP Common Data Model v5.4 tables mapped from the silver layer with OHDSI standard vocabularies, used for cohort discovery and network studies.
Product card
Version
5.4 (build 2026.10)
Domain
Research
Owner
Research Informatics
Steward
Dr. Sofia Lindqvist
Sensitivity
Limited data set
Refresh
Weekly Sunday
Rows
2,500
SQL endpoint
lakehouse.omop.personREST endpoint
/api/data-products/omop-cdm/rowsLineage inputs
silver.patient, silver.encounter, silver.diagnosis, silver.procedure, silver.medication, silver.labConsumers
| Consumer type | Consumer |
|---|---|
| Research | ATLAS cohort definitions, HADES studies |
| Research | Cohort discovery platform |
Quality checks
| Check | Result | Status |
|---|---|---|
| Row count greater than zero | 2,500 rows | Passed |
| person_id is never null | 0 null | Passed |
| person_id is unique | 0 duplicates | Passed |
Schema (18 columns)
| Column | Type | Nullable | Classification |
|---|---|---|---|
person_id | integer | YES | Identifier |
gender_concept_id | integer | YES | |
year_of_birth | integer | YES | |
month_of_birth | integer | YES | |
day_of_birth | integer | YES | |
birth_datetime | timestamp without time zone | YES | |
race_concept_id | bigint | YES | |
ethnicity_concept_id | bigint | YES | |
location_id | bigint | YES | |
provider_id | bigint | YES | |
care_site_id | bigint | YES | |
person_source_value | text | YES | |
gender_source_value | text | YES | |
gender_source_concept_id | integer | YES | |
race_source_value | text | YES | |
race_source_concept_id | integer | YES | |
ethnicity_source_value | text | YES | |
ethnicity_source_concept_id | integer | YES |
Sample (8 rows)
| person_id | gender_concept_id | year_of_birth | month_of_birth | day_of_birth | birth_datetime | race_concept_id | ethnicity_concept_id | location_id | provider_id | care_site_id | person_source_value | gender_source_value | gender_source_concept_id | race_source_value | race_source_concept_id | ethnicity_source_value | ethnicity_source_concept_id |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1,861 | 8,532 | 1,966 | 6 | 27 | 1966-06-27 00:00 | 8,527 | 38,003,564 | 353ac7cd-8b9c-a20b-46c1-49c8efe0c978 | F | 0 | White | 0 | Not Hispanic or Latino | 0 | |||
| 2,382 | 8,507 | 1,944 | 3 | 27 | 1944-03-27 00:00 | 8,527 | 38,003,564 | ee50c5d4-713e-3f6b-184c-356bd6796ccf | M | 0 | White | 0 | Not Hispanic or Latino | 0 | |||
| 2,315 | 8,507 | 1,966 | 11 | 23 | 1966-11-23 00:00 | 8,516 | 38,003,564 | 717e890d-8f4f-88cd-606d-8af888418afe | M | 0 | Black or African American | 0 | Not Hispanic or Latino | 0 | |||
| 1,850 | 8,532 | 1,956 | 5 | 5 | 1956-05-05 00:00 | 8,527 | 38,003,564 | 46d0f502-7093-f385-be97-1426d319b088 | F | 0 | White | 0 | Not Hispanic or Latino | 0 | |||
| 197 | 8,532 | 1,972 | 4 | 1 | 1972-04-01 00:00 | 8,527 | 38,003,564 | f0cca9e6-54ba-9e53-914a-1da96ed6c76f | F | 0 | White | 0 | Not Hispanic or Latino | 0 | |||
| 405 | 8,532 | 1,963 | 2 | 4 | 1963-02-04 00:00 | 8,527 | 38,003,564 | 757d99e2-4263-f319-cacd-ee104bbdafb0 | F | 0 | White | 0 | Not Hispanic or Latino | 0 | |||
| 2,206 | 8,532 | 1,968 | 9 | 20 | 1968-09-20 00:00 | 8,527 | 38,003,564 | d165ac1f-d6d0-841a-5689-9b6eff0a774b | F | 0 | White | 0 | Not Hispanic or Latino | 0 | |||
| 458 | 8,507 | 1,959 | 2 | 19 | 1959-02-19 00:00 | 8,527 | 38,003,564 | 6b98fe21-4727-84e9-f6b1-c0664091cad1 | M | 0 | White | 0 | Not Hispanic or Latino | 0 |