Lung Cancer Cohort Example
type: Dataset
description: Synthetic OMOP-based cohort for lung cancer
keyword: lung cancer
keyword: lung carcinoma
keyword: thoracic oncology
alternative: LC
alternative: NSCLC
alternative: SCLC
type: Statistical
type: Personal data
theme: Health
access rights: RESTRICTED
health category: Lung Cancer
modified: 2025-11-09
sample: Distribution
  access URL: http://example.org/resource/access_URL
  applicable legislation: oj
has purpose: ResearchAndDevelopment
publisher: UniversityofLuxembourg
provenance: ProvenanceStatement
  description: The Lung Cancer OMOP CDM dataset was derived from routinely collected electronic health records and hospital cancer registry data from three tertiary hospitals and one regional cancer center in Country X, covering the period 2016-01-01 to 2024-12-31. Source systems included inpatient and outpatient EHR modules (diagnoses, procedures, medications, labs, pathology, imaging summaries) and the institutional tumor registry. Data were transformed to OMOP CDM v5.4 using a documented ETL pipeline (SQL + Python) with concept mapping to SNOMED CT (YYYY-MM release), RxNorm (YYYY-MM), LOINC (YYYY-MM), and ICD-10-CM (2024). Data quality checks were performed with OHDSI Achilles and the Data Quality Dashboard (all critical checks passed; non-critical conformance warnings documented).
healththeme: http://13.81.34.152:1101/resource/authority/health-theme/CANCER_DISEASE
hdab: Health Data Access Body 1
  type: Agent
  contact point: ContactPoint
distribution: distributions
contact point: Kind
  has URL: http://example.org/resource/contact_page
  fn: Dataset contact
applicable legislation: oj
language: ENG
temporal: PeriodOfTime
  start date: 2010-01-01
  end date: 2020-12-31
spatial: LUX
version: V1.0
rights: https://example.org/rights#standard
has personal data: https://w3id.org/dpv/pd#Age
has personal data: https://w3id.org/dpv/pd#Gender
has personal data: https://w3id.org/dpv/pd#Identifier
has legal basis: https://w3id.org/dpv/dpv-gdpr#A6-1-a
has legal basis: https://w3id.org/dpv/dpv-gdpr#A9-2-j
has data subject: https://w3id.org/dpv#Patient
has data subject: https://w3id.org/dpv#DataSubject
max typical age: 89
min typical age: 18
number of unique individuals: 6500
number of records: 9500
age median: 57
number of studies: 120
number of series: 800
condition: https://cancerimage.eu/ontology/EUCAIM#CLIN1000084
image modality: https://hyperontology.eucaim.cancerimage.eu/#IMG1004460
image vendor: https://hyperontology.eucaim.cancerimage.eu/#IMG1000051
number of persons: 6500
number of persons by gender:
  measure type: sdmx-measure:obsValue
  structure: http://IDERHA.org/structure/gender
  observation:
    obs value: 7450
    gender: male
  observation:
    obs value: 4750
    gender: female
  observation:
    obs value: 145
    gender: unknown
number of persons by year of birth:
  measure type: sdmx-measure:obsValue
  structure: http://IDERHA.org/structure/year_of_birth
  observation:
    obs value: 500
    year of birth: 1940-01-01
  observation:
    obs value: 1500
    year of birth: 1950-01-01
  observation:
    obs value: 2500
    year of birth: 1960-01-01
  observation:
    obs value: 3000
    year of birth: 1970-01-01
  observation:
    obs value: 1000
    year of birth: 1980-01-01
number of persons by race:
  measure type: sdmx-measure:obsValue
  structure: http://IDERHA.org/structure/race
  observation:
    obs value: 5500
    race: white
  observation:
    obs value: 2500
    race: black
  observation:
    obs value: 1000
    race: asian
  observation:
    obs value: 500
    race: other
number of persons by ethnicity:
  measure type: sdmx-measure:obsValue
  structure: http://IDERHA.org/structure/ethnicity
  observation:
    obs value: 4500
    ethnicity: hispanic
  observation:
    obs value: 2000
    ethnicity: non-hispanic
  observation:
    obs value: 2000
    ethnicity: unknown
number of persons by observation period start month:
  measure type: sdmx-measure:obsValue
  structure: http://IDERHA.org/structure/observation_period_start_month
  observation:
    obs value: 500
    observation period start month: 2016-01-01
  observation:
    obs value: 750
    observation period start month: 2017-01-01
  observation:
    obs value: 1000
    observation period start month: 2018-01-01
  observation:
    obs value: 1200
    observation period start month: 2019-01-01
  observation:
    obs value: 1500
    observation period start month: 2020-01-01
  observation:
    obs value: 1600
    observation period start month: 2021-01-01
  observation:
    obs value: 950
    observation period start month: 2022-01-01
number of persons by number of observation periods:
  measure type: sdmx-measure:obsValue
  structure: http://IDERHA.org/structure/number_of_observation_periods
  observation:
    obs value: 4000
    number of observation periods: 1
  observation:
    obs value: 2000
    number of observation periods: 2
  observation:
    obs value: 500
    number of observation periods: 3
number of observation periods by length of observation:
  measure type: sdmx-measure:obsValue
  structure: http://IDERHA.org/structure/length_of_observation
  observation:
    obs value: 2000
    length of observation: < 1 year
  observation:
    obs value: 3000
    length of observation: 1-3 years
  observation:
    obs value: 1500
    length of observation: 3-5 years
  observation:
    obs value: 1000
    length of observation: 5-10 years
  observation:
    obs value: 500
    length of observation: > 10 years
number of persons with at least one visit occurrence by VISIT CONCEPT ID:
  measure type: sdmx-measure:obsValue
  structure: http://IDERHA.org/structure/visit_concept_id
  observation:
    obs value: 5000
    visit concept id: 9201
  observation:
    obs value: 3000
    visit concept id: 9202
number of VISIT OCCURRENCE records by VISIT CONCEPT ID:
  measure type: sdmx-measure:obsValue
  structure: http://IDERHA.org/structure/visit_concept_id
  observation:
    obs value: 7000
    visit concept id: 9201
  observation:
    obs value: 4500
    visit concept id: 9202
number of persons with at least one concept id by MEASUREMENT CONCEPT ID:
  measure type: sdmx-measure:obsValue
  structure: http://IDERHA.org/structure/measurement_concept_id
  observation:
    obs value: 5000
    measurement concept id: 3004410
  observation:
    obs value: 2500
    measurement concept id: 3000963
number of MEASUREMENT records by MEASUREMENT CONCEPT ID:
  measure type: sdmx-measure:obsValue
  structure: http://IDERHA.org/structure/measurement_concept_id
  observation:
    obs value: 25000
    measurement concept id: 3004410
  observation:
    obs value: 14000
    measurement concept id: 3000963
cdm field: 95
cdm table: 95
is required: 95
cdm datatype: 95
is primary key: 95
is foreign key: 95
fk domain: 95
fk class: 95
is standard valid concept: 95
measure person completeness: 95
measure value completeness: 95
standard concept record completeness: 95
source concept record completeness: 95
source value completeness: 95
plausible value low: 95
plausible value high: 95
plausible temporal after: 95
plausible during life: 95
plausible gender: 95

Statistical
type: Concept

Personal data
type: Concept

Health
type: Concept

Lung Cancer
type: Concept

UniversityofLuxembourg
type: Agent
contact point: ContactPoint

IDERHA Data Catalog
type: Catalogue
description: IDERHA Data Catalog
publisher: IDERHA Data catalog
applicable legislation: oj

IDERHA Data catalog
type: Agent

example text
type: Study
acronym: LCSD
description: Lung Cancer Study
keywords: LC
funded by: UniversityofLuxembourg
agent: UniversityofLuxembourg
project website: https://www.uni.lu/en/

measure type: sdmx-measure:obsValue
structure: http://IDERHA.org/structure/measurement_source_concept_id
observation:
  obs value: 20000
  measurement source concept id: 123456
observation:
  obs value: 10000
  measurement source concept id: 654321

measure type: sdmx-measure:obsValue
structure: http://IDERHA.org/structure/measurement_no_value
observation:
  obs value: 500
  measurement concept id: 3004410
observation:
  obs value: 200
  measurement concept id: 3000963

measure type: sdmx-measure:obsValue
structure: http://IDERHA.org/structure/condition_concept_id
observation:
  obs value: 5000
  condition concept id: 254761
observation:
  obs value: 3000
  condition concept id: 2547610

measure type: sdmx-measure:obsValue
structure: http://IDERHA.org/structure/condition_concept_id
observation:
  obs value: 12000
  condition concept id: 254761
observation:
  obs value: 8000
  condition concept id: 2547610

measure type: sdmx-measure:obsValue
structure: http://IDERHA.org/structure/condition_source_concept_id
observation:
  obs value: 11500
  condition source concept id: 98765
observation:
  obs value: 7500
  condition source concept id: 56789

measure type: sdmx-measure:obsValue
structure: http://IDERHA.org/structure/procedure_concept_id
observation:
  obs value: 4500
  procedure concept id: 2211361
observation:
  obs value: 3000
  procedure concept id: 2211362

measure type: sdmx-measure:obsValue
structure: http://IDERHA.org/structure/procedure_concept_id
observation:
  obs value: 9000
  procedure concept id: 2211361
observation:
  obs value: 6500
  procedure concept id: 2211362

measure type: sdmx-measure:obsValue
structure: http://IDERHA.org/structure/procedure_source_concept_id
observation:
  obs value: 8500
  procedure source concept id: 76543
observation:
  obs value: 6000
  procedure source concept id: 34567

measure type: sdmx-measure:obsValue
structure: http://IDERHA.org/structure/drug_concept_id
observation:
  obs value: 4800
  drug concept id: 1125360
observation:
  obs value: 3200
  drug concept id: 19019073

measure type: sdmx-measure:obsValue
structure: http://IDERHA.org/structure/drug_concept_id
observation:
  obs value: 22000
  drug concept id: 1125360
observation:
  obs value: 15000
  drug concept id: 19019073

measure type: sdmx-measure:obsValue
structure: http://IDERHA.org/structure/drug_source_concept_id
observation:
  obs value: 21000
  drug source concept id: 54321
observation:
  obs value: 14000
  drug source concept id: 12345

measure type: sdmx-measure:obsValue
structure: http://IDERHA.org/structure/drug_era_concept_id
observation:
  obs value: 4300
  drug concept id: 1125360
observation:
  obs value: 2900
  drug concept id: 19019073

measure type: sdmx-measure:obsValue
structure: http://IDERHA.org/structure/drug_era_concept_id
observation:
  obs value: 18000
  drug concept id: 1125360
observation:
  obs value: 12000
  drug concept id: 19019073

measure type: sdmx-measure:obsValue
structure: http://IDERHA.org/structure/observation_concept_id
observation:
  obs value: 3000
  observation concept id: 4317139
observation:
  obs value: 2000
  observation concept id: 4056240

measure type: sdmx-measure:obsValue
structure: http://IDERHA.org/structure/observation_concept_id
observation:
  obs value: 8000
  observation concept id: 4317139
observation:
  obs value: 6000
  observation concept id: 4056240

measure type: sdmx-measure:obsValue
structure: http://IDERHA.org/structure/observation_source_concept_id
observation:
  obs value: 7500
  observation source concept id: 24680
observation:
  obs value: 5500
  observation source concept id: 13579

measure type: sdmx-measure:obsValue
structure: http://IDERHA.org/structure/observation_concept_value_as_concept
observation:
  obs value: 4000
  observation concept id: 4317139
  value as concept id: 4181412
observation:
  obs value: 3000
  observation concept id: 4056240
  value as concept id: 4181412

measure type: sdmx-measure:obsValue
structure: http://IDERHA.org/structure/measurement_concept_unit
observation:
  obs value: 1
  measurement concept id: 3004410
  unit concept id: 8876