MDW - Discover Metadata Catalogue

MDW Discover  > Barts Imaging Dataset @ 1491

MDW Discover

Browse All

London SDE

West Midlands SDE

Kent, Medway & Sussex SDE

MDW - Discover

Barts Health NHS Imaging Metadata and Report Dataset

Total number of distinct PERSON_ID in the OMOP_PERSON table

HDR UK

Barts Health

A foreign key to the Location table, where the detailed address information is stored

location_id

A foreign key to the predefined Concept table for the place of service concept id

place_of_service_concept_id

The identifier of the care_site as it appears in the source data

care_site_source_value

care_site_id

The source code for the place of service as it appears in the source data

place_of_service_source_value

The name of the care_site as it appears in the source data

care_site_name

OMOP CDM Care Site table - Contains a list of institutional (physical or organizational) units where healthcare delivery is practiced (offices, wards, hospitals, clinics, etc.)

omop_care_site

The source value for the condition status as it appears in the source data.

condition_status_source_value

The date and time when the instance of the condition is recorded.

condition_start_datetime

A foreign key identifier to the person who is experiencing the condition.

person_id

A foreign key to the visit in the VISIT_OCCURRENCE table during which the condition was determined.

visit_occurrence_id

The date when the instance of the condition is recorded.

condition_start_date

The reason that the condition was no longer present.

stop_reason

The date and time when the instance of the condition is considered to have ended.

condition_end_datetime

A foreign key to the predefined concept identifier in the Standardized Vocabularies reflecting the source data from which the condition was recorded.

condition_type_concept_id

A unique identifier for each condition occurrence event.

condition_occurrence_id

The source value for the condition as it appears in the source data.

condition_source_value

A foreign key that refers to a standard condition concept identifier in the Vocabulary.

condition_concept_id

The date when the instance of the condition is considered to have ended.

condition_end_date

A foreign key to the predefined concept identifier in the Standardized Vocabularies reflecting the status of the condition.

condition_status_concept_id

A foreign key to the visit detail record during which the condition was determined.

visit_detail_id

A foreign key to the provider who was responsible for determining the condition.

provider_id

A foreign key to a condition concept that refers to the code used in the source.

condition_source_concept_id

OMOP CDM Condition Occurrence table - Contains records of Events suggesting the presence of a disease or medical condition

omop_condition_occurrence

month_of_birth

A foreign key to a concept that refers to the code used in the source.

gender_source_concept_id

day_of_birth

The source code for the person as it appears in the source data.

person_source_value

A foreign key to the provider table that indicates the primary care provider of the person.

A foreign key that refers to a standard concept identifier in the Vocabulary for the race of the person.

race_concept_id

A foreign key to the care site table that indicates the primary care site of the person.

A foreign key that refers to a standard concept identifier in the Vocabulary for the gender of the person.

gender_concept_id

The date and time of birth of the person.

birth_datetime

The source code for the gender of the person as it appears in the source data.

gender_source_value

A foreign key that refers to the standard concept identifier in the Vocabulary for the ethnicity of the person.

ethnicity_concept_id

ethnicity_source_concept_id

race_source_concept_id

The source code for the race of the person as it appears in the source data.

race_source_value

A foreign key to the location table that indicates where the person is located.

year_of_birth

The source code for the ethnicity of the person as it appears in the source data.

ethnicity_source_value

OMOP CDM Person table - Contains records that uniquely identify each person in the database

omop_person

The source code for the Device as it appears in the source data.

device_source_value

A foreign key to a Device Concept that refers to the code used in the source.

device_source_concept_id

A foreign key to the Visit Detail in the VISIT_DETAIL table during which the Device exposure initiated.

device_exposure_start_date

A foreign key to the predefined Concept identifier in the Standardized Vocabularies reflecting the type of Device exposure.

device_type_concept_id

A foreign key to a predefined Concept in the Standardized Vocabularies reflecting the unit the Device was administered.

unit_concept_id

A foreign key to the Provider in the PROVIDER table who initiated the Device exposure.

A foreign key to the Visit in the VISIT_OCCURRENCE table during which the Device exposure initiated.

device_exposure_end_date

The end date and time for the Device exposure.

device_exposure_end_datetime

A foreign key that refers to a Standard Device Concept identifier in the Vocabulary.

device_concept_id

quantity

A foreign key identifier to the Person who is subjected to the Device.

The Production Identifier (UDI-PI) portion of the Unique Device Identification.

production_id

The start date and time for the Device exposure.

device_exposure_start_datetime

A unique identifier for each Device exposure event.

device_exposure_id

A foreign key to a Unit Concept that refers to the code used in the source.

unit_source_concept_id

The source code for the unit as it appears in the source data.

unit_source_value

The Unique Device Identification (UDI-DI) number for devices regulated by the FDA.

unique_device_id

OMOP CDM Device Exposure table - Contains records about exposure to a foreign physical object or instrument used for diagnostic or therapeutic purposes

omop_device_exposure

The end date for the drug era constructed from the individual instance of drug exposures. It is the end date of the final continuously recorded instance of utilization of a drug.

drug_era_end_date

drug_era_id

The start date for the drug era constructed from the individual instances of drug exposures. It is the start date of the very first chronologically recorded instance of utilization of a drug.

drug_era_start_date

The number of days that separates two drugs that are adjacent to each other, if there is a gap of more than 30 days between two drug eras, then they are considered two separate eras.

gap_days

A foreign key identifier to the person who is subjected to the drug during the drug era.

The number of individual drug exposure occurrences used to construct the drug era.

drug_exposure_count

A foreign key that refers to a standard concept identifier in the Vocabulary for the drug concept.

drug_concept_id

OMOP CDM Drug Era table - Contains records of the span of time when the Person is assumed to be exposed to a particular active ingredient

omop_drug_era

The start date of the observation period for which data are available from the data source.

observation_period_start_date

A foreign key identifier to the Person for whom the observation period is defined.

A foreign key to the predefined concept identifier in the Standardized Vocabularies reflecting the source of the observation period information.

period_type_concept_id

The end date of the observation period for which data are available from the data source.

observation_period_end_date

A unique identifier for each observation period.

observation_period_id

OMOP CDM Observation Period table - Contains records which define spans of time during which clinical events are recorded for a Person

omop_observation_period

The time of the measurement (in the event that MEASUREMENT_DATETIME is not well defined).

measurement_time

measurement_datetime

A foreign key to the visit in the VISIT_OCCURRENCE table during which the measurement was taken.

A foreign key to a standard concept identifier for the unit used in the measurement.

A foreign key to a concept that refers to the field in the MEASUREMENT_EVENT table.

meas_event_field_concept_id

The lower limit of the normal range of the measurement.

range_low

measurement_source_concept_id

A unique identifier for each Measurement.

measurement_id

A foreign key identifier to the Person about whom the measurement was recorded.

A foreign key to the predefined concept identifier in the Standardized Vocabularies reflecting the type of the measurement.

measurement_type_concept_id

The source value associated with the structured value stored as numeric or concept.

value_source_value

A foreign key to the MEASUREMENT_EVENT table.

measurement_event_id

The measurement name as it appears in the source data.

measurement_source_value

A foreign key to a concept that refers to the unit code used in the source.

The measurement result stored as a number. This is applicable to measurements where the result is expressed as a numeric value.

value_as_number

A foreign key to a standard concept identifier for a categorical result.

value_as_concept_id

measurement_date

A foreign key to the visit detail in the VISIT_DETAIL table during which the measurement was taken.

The upper limit of the normal range of the measurement.

range_high

A foreign key to the standard measurement concept identifier in the Vocabulary.

measurement_concept_id

A foreign key to a standard concept identifier for the mathematical operator applied to the value.

operator_concept_id

A foreign key to the provider in the PROVIDER table who was responsible for taking the measurement.

omop_measurement

A foreign key identifier to the deceased Person.

The date and time the person was deceased.

death_datetime

cause_source_concept_id

A foreign key to the predefined concept identifier in the Standardized Vocabularies reflecting how the death was represented in the source data.

death_type_concept_id

A foreign key to the predefined concept identifier in the Standardized Vocabularies reflecting the cause of death

cause_concept_id

The source code for the cause of death as it appears in the source data.

cause_source_value

death_date

OMOP CDM Death table - Contains the clinical event for how and when a Person dies

omop_death

The source value for the Provider gender.

A foreign key to a Concept that refers to the code used in the source.

specialty_source_concept_id

The Drug Enforcement Administration (DEA) number of the provider.

The National Provider Identifier (NPI) of the provider.

A foreign key to the main Care Site where the provider is practicing.

A foreign key to a Standard Specialty Concept ID in the Standardized Vocabularies.

specialty_concept_id

OMOP CDM Provider table - Contains a list of uniquely identified healthcare providers

Barts Imaging Dataset

Documentation

Coverage

Provenance

Origin

Temporal

Accessibility

Access

Usage

Format and Standards

Observations

Origin