| Title: | OMOP Condition Era |
| Access field: | 20142 (Present in OMOP dataset) |
| Table name | omop_condition_era | Table group | OMOP | Debut | Feb 2023 | ||
| Row count | 30,000,000+ | Parent table | n/a | Version | Mar 2023 | ||
| Size | 1GB | Stability | Complete | Cost Tier | d2 o2 s2 |
Record Table 924
WARNING: the interactive features of this website use CSS3, which your browser does not support. To use the full features of this website, please update your browser.
Notes
In omop_condition_era, a Condition Era is defined as a span of time when the Person is assumed to have a given condition. Similar to Drug Eras, Condition Eras are chronological periods of Condition Occurrence.Further details are provided in the Standardized Derived Elements specifications - https://ohdsi.github.io/CommonDataModel/cdm53.html#CONDITION_ERA
6 Columns
| # | Column | Type | Notes |
|---|---|---|---|
| 1 | condition_concept_id | integer | A foreign key that refers to a standard Condition Concept identifier in the Standardized Vocabularies. |
| 2 | condition_era_end_date | date | The end date for the Condition Era constructed from the individual instances of Condition Occurrences. It is the end date of the final continuously recorded instance of the Condition. |
| 3 | condition_era_id | integer | A unique identifier for each Condition Era. |
| 4 | condition_era_start_date | date | The start date for the Condition Era constructed from the individual instances of Condition Occurrences. It is the start date of the very first chronologically recorded instance of the condition. |
| 5 | condition_occurrence_count | integer | The number of individual Condition Occurrences used to construct the condition era. |
| 6 | person_id | integer | A foreign key identifier to the Person who is experiencing the Condition during the Condition Era. |
15 Related OMOP Record Tables
| Table ID | Table | Title |
|---|---|---|
| 925 | omop_condition_occurrence | OMOP Condition Occurrence |
| 926 | omop_death | OMOP Death |
| 927 | omop_device_exposure | OMOP Device Exposure |
| 928 | omop_dose_era | OMOP Dose Era |
| 929 | omop_drug_era | OMOP Drug Era |
| 930 | omop_drug_exposure | OMOP Drug Exposure |
| 931 | omop_measurement | OMOP Measurement |
| 932 | omop_note | OMOP Note |
| 933 | omop_observation | OMOP Observation Period |
| 934 | omop_observation_period | OMOP Observation |
| 935 | omop_person | OMOP Person |
| 936 | omop_procedure_occurrence | OMOP Procedure Occurrence |
| 937 | omop_specimen | OMOP Specimen |
| 938 | omop_visit_detail | OMOP Visit Detail |
| 939 | omop_visit_occurrence | OMOP Visit Occurrence |
Enabling scientific discoveries that improve human health