Explorative Data Analysis of the National Pandemic Cohort Network (NAPKON) Public Data Set¶

Welcome! The following statistics provide some visusal insights into NAPKON Public Data Set. The Public Data Set constitutes patient data from the NAPKON after a data cleaning process and includes data from patients documented until May 16, 2023. The NAPKON Public Data Set is originating from the NAPKON SecuTrial. The data anonymization pipeline is described by Jakob et al. in "Design and evaluation of a data anonymization pipeline to promote Open Science on COVID-19". The public data is anonymized using our "data protection concept". The anonymization process was carried out with the "ARX software"

Copyright: This work is licensed under the Creative Commons Attribution Non-Commercial 4.0 License. With the use of this data you agree to include a proper acknowledgement of the NAPKON study group in any work based on the data set. By working with this notebook you agree to maintain the confidentiality of the data set at all times and to not attempt to compromise or otherwise violate the privacy of the patients described. To view a copy of the license, visit https://creativecommons.org/licenses/by-nc/4.0/.

If you have any comments on the notebook, please drop us a message at support@napkon.de.

Data Set Structure¶

Here we provide information on the basic structure of the NAPKON Public Data Set.

The data set consists of 5702 patients and 15 variables. A row represents anonymized data of a single patient.

The columns are described by the variables:

age (categorial): age group
gender (categorial): gender
month_first_diagnosis (categorical): quartile of first confirmed diagnosis of COVID-19
year_first_diagnosis (categorical): year of first confirmed diagnosis of COVID-19
cohort (categorical): Selection of the respective cohort in which the patient was included
mild_disease_phase (categorical): yes if patient was in the Mild Phase*
moderate_disease_phase (categorical): yes if patient was in the Moderate Phase*
severe_disease_phase (categorical): yes if patient was in the Severe Phase*
patient_status_at_end_of_acute_phase (categorial): status of the patient at the end of acute phase of SARS-CoV-2
hospitalization_during_acute_phase (categorial): patient hospitalized during acute phase of SARS-CoV-2
intensive_care_treatment (categorial): patient with intensive care treatment during acute phase of SARS-CoV-2
inv_ventilation (categorial): patient with invasive ventilation during acute phase of SARS-CoV-2
availability_3month_followup (categorial): completion of the 3-month follow-up
ability_to_work_3MFU (categorial): patient is able to work at the time of 3-month follow-up
any_symptom_3MFU (categorial): patient has any symptoms at the 3-month follow-up

For further information regarding the variables please refer to: https://cloud.idcohorts.net/s/ELRzpzgBkKb5ejY and https://cloud.napkon.de/s/W2PQpmqzoRkjABL

*The Clinical Phases are defined according to the WHO clinical progression scale:

To get to know the Public Data Set better, the values of variables are shown below according to the used data set. Please be aware that the Public Data Set is only a part of the complete NAPKON data set. Anonymization processes may lead to variables having less values than in the complete NAPKON data set. For example the variable 'gender' can also have the value 'diverse', but there is no patient with this gender in the Public Data Set.

age:
18 - 39 years, 40 - 59 years, 60 - 79 years, >= 80 years

gender:
female, male

quarter_first_diagnosis:
Q1, Q2, Q3, Q4, unknown/missing

year_first_diagnosis:
2020, 2021, 2022, 2023, unknown/missing

cohort:
HAP, POP, SUEP

mild_phase:
no, yes

moderate_phase:
no, yes

severe_phase:
no, unknown/missing, yes

patient_status_end_acute_phase:
ambulant, dead, discharged, referral/transfer, unknown/missing

hospitalisation:
no, yes

intensive_care_treatment:
no, yes

inv_ventilation:
no, unknown/missing, yes

availability_3month_followup:
no/not yet, yes

ability_to_work_3MFU:
n/a, no, unknown/missing, yes

any_symptom_3MFU:
n/a, no, unknown/missing, yes

n/a: In cases where the patient was not in the respective phase a variable refers to, the variable has been given the value 'Not applicable (N/a)'. If for example a patient has never been in the completion of the 3-month follow-up, 'any symptoms at the 3-month follow-up' is a variable which is not applicable to this patient.

1. Descriptive Analysis¶

The following descriptive statistics are computed in this section:

Cohort Distribution
Date of diagnosis Distribution by Cohort
Gender Distribution by Cohort
Age Distribution by Cohort
Age - Gender Distribution by Cohort

Number of patients from HAP is lower than from SUEP and POP. Therefore please pay attention to difference in scaling especially in HAP.

The total number of patients is 5702.
Only cases with complete documentation and Review A status are considered.

The number of patients for SUEP is 2138.
The number of patients for POP is 3252.
The number of patients for HAP is 312.

2. Patient status at the end of acute phase¶

The following descriptive statistics on the health status at the end of medical consultation are computed in this section:

Frequency of Health Status at the End of Medical Consultation
Hospitalisation in the acute phase
Intensive care treatment in the acute phase
Invasive ventilation in the acute phase
COVID-19 Mortality and Recovery Rates
COVID-19 Mortality vs Recovery by Age
COVID-19 Mortality vs Recovery by Gender
Crosstable Mortality vs Recovery vs Gender vs Age

Note that we will use a filtered data set for computing the rates, which we describe below.

Frequency of Health Status at the End of Medical Consultation¶

Hospitalisation in the acute phase¶

The number of patients for SUEP is 2138.
The number of patients for POP is 3252.
The number of patients for HAP is 312.

Intensive care treatment in the acute phase¶

The number of patients for SUEP is 2138.
The number of patients for POP is 3252.
The number of patients for HAP is 312.

Invasive ventilation in the acute phase¶

The number of patients for SUEP is 2138.
The number of patients for POP is 3252.
The number of patients for HAP is 312.

For the remaining section 2 we proceed with a filtered data set.¶

For the COVID-19 mortality and recovery rate computations, we exclude patients with a documented health status at the end of medical consultation of 'unknown/missing'. Please note that this influences the following computations and plots.

The number of patients in the filtered data set for SUEP is 2047.
The number of patients in the filtered data set for POP is 3111.
The number of patients in the filtered data set for HAP is 300.

Frequency of Health Status at the End of Medical Consultation in the Filtered Data Set¶

COVID-19 Overall Mortality and Recovery Rate for Filtered Data Set:¶

SUEP
COVID-19 Overall Mortality Rate: 5.96 %
COVID-19 Overall Recovery Rate: 94.04 %

POP
All POP patients survived at least 6 to 12 months after first diagnosis.

HAP
COVID-19 Overall Mortality Rate: 16.0 %
COVID-19 Overall Recovery Rate: 84.0 %

COVID-19 Mortality/Recovery for Filtered Data Set by Age:¶

All POP patients survived at least 6 to 12 months after first diagnosis. Thus POP is not shown in the following graphic.

SUEP

HAP

COVID-19 Mortality/Recovery for Filtered Data Set by Gender:¶

All POP patients survived at least 6 to 12 months after first diagnosis. Thus POP is not shown in the following graphic.

SUEP

HAP

Crosstable Mortality vs Recovery vs Gender vs Age (percentage of patients in each of the subgroups)¶

SUEP

HAP

3. Clinical Phases¶

From here on we will indicate the three clinical phases as

Mild Phase
Moderate Phase
Severe Phase

In the following we will plot the:

Frequency of Phases

Since there might be patients who have no phase documented at all we need to proceed with a filtered data set in which those patients are dropped.

The number of patients which contain at least mid, moderate or severe phase in this filtered data set is 5702.

HAP: 312.
POP: 3252.
SUEP: 2138.

Maximum phase reached by the patients.

	SUEP	POP	HAP
discharged	1310	136	235
ambulant	323	2975	0
referral/transfer	292	0	17
dead	122	0	48
unknown/missing	91	141	12
palliative care	0	0	0

	Recovery rate	Mortality rate
age
18 - 39 years	99.21	0.79
40 - 59 years	97.10	2.90
60 - 79 years	89.40	10.60
>= 80 years	88.89	11.11

	Recovery rate	Mortality rate
age
18 - 39 years	91.67	8.33
40 - 59 years	88.55	11.45
60 - 79 years	77.05	22.95
>= 80 years	0.00	0.00

	Recovery rate	Mortality rate
gender
female	95.86	4.14
male	92.82	7.18

	Recovery rate	Mortality rate
gender
female	85.71	14.29
male	83.67	16.33

		count
cohort	max_phase
HAP	moderate	186
HAP	severe	126
POP	mild	3072
	moderate	139
	severe	41
SUEP	mild	323
	moderate	1402
	severe	413

	patient_status_end_acute_phase	discharged	ambulant	referral/transfer	dead	All
gender	age
female	18 - 39 years	5.08	4.01	0.44	0.05	9.57
	40 - 59 years	9.77	3.27	1.37	0.15	14.56
	60 - 79 years	8.65	0.59	2.25	1.27	12.75
	>= 80 years	2.25	0.00	0.83	0.20	3.27
male	18 - 39 years	5.86	2.54	0.49	0.10	8.99
	40 - 59 years	14.12	4.15	3.32	0.93	22.52
	60 - 79 years	15.97	1.12	4.40	2.64	24.13
	>= 80 years	2.30	0.10	1.17	0.64	4.20
All		64.00	15.78	14.26	5.96	100.00

	patient_status_end_acute_phase	discharged	referral/transfer	dead	All
gender	age
female	40 - 59 years	9.00	1.00	1.00	11.00
female	60 - 79 years	3.67	0.33	1.33	5.33
male	40 - 59 years	36.67	2.33	5.33	44.33
	60 - 79 years	25.33	2.00	8.00	35.33
	18 - 39 years	3.67	0.00	0.33	4.00
All		78.33	5.67	16.00	100.00