Hospital Universitario 12 de Octubre + Hospital Clínic de Barcelona efforts
The ISARIC-WHO Case Report Forms (CRFs) are used to collect data on individuals presenting with suspected or confirmed COVID-19 diagnosis. This resource has made available a collection of standardised clinical data to support patient care and COVID-19 research worldwide.
Hospital Universitario 12 de Octubre efforts have made possible the collection of observational variables associated to COVID-19 cases from Electronical Health Records using a flexible methodology based on Detailed Clinical Models (see the full article).
Clinical variables - ISARIC based model
COVID-19 ranks as the single largest health incident worldwide in decades. In such a scenario, electronic health records (EHRs) should provide a timely response to healthcare needs and to data uses that go beyond direct medical care and are known as secondary uses, which includes biomedical research. However, it is usual for each data analysis initiative to define its own information model in line with its requirements. These specifications share clinical concepts, but differ in format and recording criteria, something that creates data entry redundancy in multiple electronic data capture systems (EDCs) with the consequent investment of effort and time by the organization.
This study was undertaken at the Hospital Universitario 12 de Octubre, a 1,300-bed tertiary hospital situated in Madrid Region (Spain). It sought to design and implement a flexible methodology based on detailed clinical models (DCM), which would enable EHRs generated in a tertiary hospital to be effectively reused without loss of meaning and within a short time.
As part of the first stage of the methodology of this study a specification of an initial and expandable set of relevant concepts for COVID-19 was identified, modeled and formalized using ISO-13606 standard and SNOMED CT and LOINC terminologies. - text: The standard catalog of observable entities in COVID-19 is the specification and standardization of a set of 22 clinical observable entities and 36 laboratory-related observable entities of interest in COVID-19. These concepts, in consonance with the ISO 13606 standard and semantically linked to standard terminologies, are implemented in the multiple Hospital healthcare information systems, allowing homogenous data entry via clinical record forms or, transparently, through integration with laboratory equipment. Data are stored in each system’s database, following a dual key-value structure: standard concept of the observable entities and finding reported. This allows the reuse of data, while maintaining their original meaning unaltered.
The standard catalog and additional results of this study are the deliverables defined in the different stages of the methodology of the scientific publication cited below. Its implementation into the Hospital 12 de Octubre began on March 15, 2020 and the first EHR-derived extract was generated and validated on April 20, 2020.
Pedrera Jiménez, Miguel et al.Obtaining EHR-derived datasets for COVID-19 research within a short time: a flexible methodology based on Detailed Clinical Models.Journal of biomedical informatics, 103697. Feb 3 2021. DOI: 10.1016/j.jbi.2021.103697
+/-
Component
Description
Context
Standard
Code
Cluster
Observaciones epidemiológicas en relación con COVID-19
artefacto de registro
SNOMED CT
63261000122108
Element
Contacto con enfermo de infección respiratoria aguda
Observaciones sobre síntomas en relación con COVID-19
artefacto de registro
SNOMED CT
63271000122103
Element
Síntomas y signos observados:
artefacto de registro
SNOMED CT
63671000122101
Value
Disnea
hallazgo
SNOMED CT
267036007
Value
Broncoespasmo
hallazgo
SNOMED CT
4386001
Value
Expectoración
hallazgo
SNOMED CT
248596009
Value
Vómitos
hallazgo
SNOMED CT
422400008
Value
Diarrea
hallazgo
SNOMED CT
62315008
Value
Fiebre
hallazgo
SNOMED CT
386661006
Value
Tos
hallazgo
SNOMED CT
49727002
Value
Mialgias
hallazgo
SNOMED CT
68962001
Value
Disgeusia
hallazgo
SNOMED CT
247318005
Value
Anosmia
hallazgo
SNOMED CT
44169009
Value
Odinofagia
hallazgo
SNOMED CT
30233002
Value
Rinorrea
trastorno
SNOMED CT
64531003
Value
Dolor torácico
hallazgo
SNOMED CT
29857009
Value
Alteracion del nivel de conciencia
hallazgo
SNOMED CT
3006004
Value
Convulsiones
hallazgo
SNOMED CT
91175000
Value
Malestar general
hallazgo
SNOMED CT
367391008
Value
Congestion conjuntival
hallazgo
SNOMED CT
193894004
Value
Neumonía
hallazgo
SNOMED CT
233604007
Value
Dolor de garganta
hallazgo
SNOMED CT
162397003
Value
Escalofríos
hallazgo
SNOMED CT
43724002
Value
Síndrome de distrés respiratorio agudo
hallazgo
SNOMED CT
67782005
Value
Fallo renal agudo
hallazgo
SNOMED CT
14669001
Cluster
Observaciones clínicas en relación con COVID-19
artefacto de registro
SNOMED CT
63281000122100
Element
Peso
observable
SNOMED CT
27113001
Element
Talla
observable
SNOMED CT
50373000
Element
IMC
observable
SNOMED CT
60621009
Element
Frecuencia respiratoria
observable
SNOMED CT
86290005
Element
Frecuencia Cardíaca
observable
SNOMED CT
364075005
Element
Tensión sistólica
observable
SNOMED CT
271649006
Element
Tensión diastólica
observable
SNOMED CT
271650006
Element
Tensión arterial media
observable
SNOMED CT
6797001
Element
Temperatura
observable
SNOMED CT
386725007
Element
Saturación O2
observable
SNOMED CT
103228002
Element
Flujo de oxígeno con gafas nasales
observable
SNOMED CT
63321000122109
Element
Concentración de oxígeno con mascarilla
observable
SNOMED CT
63331000122107
Element
Tipo de Soporte Respiratorio
observable
SNOMED CT
63341000122104
Value
Gafas nasales
hallazgo
SNOMED CT
261974006
Value
Mascarilla
hallazgo
SNOMED CT
336602003
Value
Oxígeno ambiente sin soporte respiratorio
hallazgo
SNOMED CT
722742002
Value
Mascarilla Reservorio
hallazgo
SNOMED CT
720742008
Value
CPAP
hallazgo
SNOMED CT
47545007
Value
Ventilación mecánica no invasiva
hallazgo
SNOMED CT
428311008
Value
Alto flujo con gafas nasales
régimen/tratamiento
SNOMED CT
63351000122102
Element
Deposiciones
observable
SNOMED CT
162098000
Element
Vómitos
observable
SNOMED CT
63361000122100
Element
Micciones
observable
SNOMED CT
364198000
Element
Tabaquismo
observable
SNOMED CT
266918002
Value
No fumador
hallazgo
SNOMED CT
8392000
Value
Ex fumador
hallazgo
SNOMED CT
8517006
Value
Fumador
hallazgo
SNOMED CT
77176002
Element
Año de inicio del hábito tabáquico
observable
SNOMED CT
63371000122105
Element
Cantidad cigarros al día
observable
SNOMED CT
230056004
Element
Indice tabáquico acumulado
observable
SNOMED CT
63381000122108
Element
Año de abandono del hábito tabáquico
observable
SNOMED CT
160625004
Element
Candidato a valoración por uci
observable
SNOMED CT
63391000122106
Element
Candidato a Ventilación Mecánica
observable
SNOMED CT
63401000122108
Element
Resultado Rx COVID-19
observable
SNOMED CT
63401000122108
Value
Infiltrado parcheado
hallazgo
SNOMED CT
63521000122101
Value
Opacidades en vidrio delustrado
hallazgo
SNOMED CT
63531000122103
Value
Neumonía intersticial
hallazgo
SNOMED CT
63541000122106
Value
Ninguna
hallazgo
SNOMED CT
63551000122108
Value
Otros
-
Null flavors
OTH
Element
Resultado TAC COVID-19
observable
SNOMED CT
63421000122100
Value
Afectación de un lóbulo
hallazgo
SNOMED CT
63561000122105
Value
Afectación de más de un lóbulo
hallazgo
SNOMED CT
63571000122100
Value
Afectación difusa
hallazgo
SNOMED CT
63581000122102
Value
Normal
hallazgo
SNOMED CT
63591000122104
Element
Riesgo respiratorio
observable
SNOMED CT
704296008
Element
Puntaje NEWS
observable
SNOMED CT
63431000122102
Element
Resultado de Escala DOSOFA
observable
SNOMED CT
63441000122105
Element
Resultado de Escala qSOFA
observable
SNOMED CT
63451000122107
Element
Resultado de Escala Glasgow
observable
SNOMED CT
248241002
Element
Evolución COVID-19
observable
SNOMED CT
63461000122109
Value
Vivo recuperado
hallazgo
SNOMED CT
63471000122104
Value
Muerte por COVID-19
hallazgo
SNOMED CT
63481000122101
Value
Muerte por otra causa
hallazgo
SNOMED CT
63491000122103
Value
Muerte por causa desconocida
hallazgo
SNOMED CT
63501000122109
Value
Todavía en seguimiento
hallazgo
SNOMED CT
63511000122107
Value
Desconocido
-
Null flavors
UNK
Element
Fecha de defunción
observable
SNOMED CT
399753006
Value
dd/mm/aaaa
-
DATE
-
Cluster
Observaciones de laboratorio en relación con COVID-19
artefacto de registro
SNOMED CT
63291000122102
Element
Resultado PCR COVID-19
determinación
LOINC
94315-9
Value
Positivo
hallazgo
SNOMED CT
10828004
Value
Negativo
hallazgo
SNOMED CT
260385009
Value
Equívoco
hallazgo
SNOMED CT
42425007
Element
Resultado Antígenos COVID-19
determinación
LOINC
94558-4
Value
Positivo
hallazgo
SNOMED CT
10828004
Value
Negativo
hallazgo
SNOMED CT
260385009
Value
Equívoco
hallazgo
SNOMED CT
42425007
Element
Fecha prueba COVID-19
hallazgo
SNOMED CT
63301000122101
Element
Fecha resultado COVID-19
hallazgo
SNOMED CT
63311000122103
Element
Hemoglobina
determinación
LOINC
718-7
Element
Leucocitos
determinación
LOINC
6690-2
Element
Linfocitos
determinación
LOINC
731-0
Element
Plaquetas
determinación
LOINC
777-3
Element
Neutrófilos
determinación
LOINC
751-8
Element
Eosinófilos
determinación
LOINC
711-2
Element
Basófilos
determinación
LOINC
704-7
Element
Hematocrito
determinación
LOINC
4544-3
Element
Albúmina
determinación
LOINC
1751-7
Element
ALT (GPT)
determinación
LOINC
1742-6
Element
AST (GOT)
determinación
LOINC
1920-8
Element
Bilirrubina
determinación
LOINC
1975-2
Element
Creatinina
determinación
LOINC
2160-0
Element
LDH
determinación
LOINC
2532-0
Element
Ferritina
determinación
LOINC
2276-4
Element
CK
determinación
LOINC
2157-6
Element
Troponina T hs
determinación
LOINC
6598-7
Element
ESR
determinación
LOINC
30341-2
Element
TTPA
determinación
LOINC
3173-2
Element
Urea
determinación
LOINC
3091-6
Element
Lactato
determinación
LOINC
2524-7
Element
Procalcitonina
determinación
LOINC
33959-8
Element
Tiempo de Protrombina
determinación
LOINC
5964-2
Element
INR
determinación
LOINC
6301-6
Element
Sodio
determinación
LOINC
2951-2
Element
Potasio
determinación
LOINC
2823-3
Element
Dímeros D
determinación
LOINC
48067-3
Element
Triglicéridos
determinación
LOINC
2571-8
Element
Proteína C Reactiva
determinación
LOINC
1988-5
Element
Interleuquina 6
determinación
LOINC
26881-3
Element
Fibrinógeno (Derivado)
determinación
LOINC
3255-7
Element
SaO2
determinación
LOINC
2708-6
Element
pAO2 Arterial
determinación
LOINC
293472
Element
pCO2 Arterial
determinación
LOINC
2019-8
Element
pCO2 Capilar
determinación
LOINC
2020-6
Element
pCO2 Venoso
determinación
LOINC
2021-4
Element
pO2 Arterial
determinación
LOINC
19255-9
Element
pO2 Capilar
determinación
LOINC
19256-7
Element
pO2 Venoso
determinación
LOINC
19258-3
Element
FIO2
determinación
LOINC
24336-0
Element
pO2/FiO2
determinación
LOINC
50984-4
Chronic diseases variables - cohorts based
In the framework of the COVICAT study, the authors defined the chronic disease categories using the available information from COVICAT survey. The table contains self‐reported variables about chronic diseases within the COVICAT cross‐sectional survey that was answered by the participants between May 28th and July 31st 2020. Chronic diseases were defined as any long‐term condition lasting 6 or more months, being considered the variables H13_A2 to H13_A17. Those referring to asthma, chronic bronchitis and COPD, allergies and related treatments are considered in the variables H02 to H08.
This information has been extracted from a document prepared by Magda Bosch de Basea & Judith Garcia‐Aymerich in December, 2020.
The project aims to evaluate the evolution of incidences of infection by the coronavirus SARS-CoV-2 in the Catalan population during 12 months through a prospective epidemiological study of populational cohorts established before the pandemic. The study is being carried out with 24,000 people who volunteered and who are already members of different populational cohorts in a collaboration between the GCAT Genomes for Life Project of the Germans Trias i Pujol Research Institute (IGTP) and two research groups from ISGlobal, a centre supported by the "la Caixa" Foundation, and the Hospital Clínic, Barcelona.
Variable code
Disease
Possible values
H13_A2
chronic bronchitis, COPD, emphysema
Yes/No
H13_A3
other respiratory diseases
Yes/No
H13_A4
hypertension
Yes/No
H13_A5
heart disease
Yes/No
H13_A6
diabetes
Yes/No
H13_A7
digestive diseases
Yes/No
H13_A8
gynecological diseases
Yes/No
H13_A9
joint problems, rheumatism
Yes/No
H13_A10
cancer
Yes/No
H13_A11
anxiety / depression
Yes/No
H13_A16
other mental illnesses
Yes/No
H13_A12
HIV and other immunodeficiency problems
Yes/No
H13_A13
chronic liver disease
Yes/No
H13_A14
chronic kidney disease
Yes/No
H13_A15
autoimmune disease
Yes/No
H13_A17
none of the above
Yes/No
H02
Asthma ever
Yes/No
H03
Doctor Diagnosis of asthma
Yes/No
H04
Asthma attack last 12 months
Yes/No
H05
Current asthma medication
Yes/No
H06
Chronic bronchitis, COPD or emphysema
Yes/No
H07
Nasal allergy (e.g. rhinitis)
Yes/No
H08
Sometimes eczema or other skin allergy
Yes/No
H13_other
other
Free text
COVID-19 ISCIII's funded projects variables
The table below shows health variables reported by projects funded by the ISCIII funds Fondo COVID19. This information will be updated regularly as projects report new variables.
This website uses cookies, and the limited processing of your personal data to function.
By using the site you are agreeing to this as outlined in our Privacy Notice.