Skip to content

Instantly share code, notes, and snippets.

@tecoholic
Last active November 25, 2020 04:31
Show Gist options
  • Save tecoholic/af51aa22a675d8f934716a92b1fe60d7 to your computer and use it in GitHub Desktop.
Save tecoholic/af51aa22a675d8f934716a92b1fe60d7 to your computer and use it in GitHub Desktop.
CovidBulletinExtractor.ipynb
COVID-19 Positive Deaths without comorbidities – Total: 2
Death in Private health facilities without comorbidities
Death Case No. 11133
A 58 Years old Male from Vellore having COVID-19 RTPCR Positivity on
29.10.2020 admitted on 18.10.2020 at 09.32 AM in a private medical college
and hospital, Vellore with Complaints of Fever, Cough for 5 days and
Difficulty in Breathing for 2 days died on 29.10.2020 at 04.30 AM due to
ARDS / COVID-19 Pneumonia.
Death in Government health facilities (DMS) without comorbidities
Death Case No. 11134
A 67 Years old Female from Kancheepuram having COVID-19 RTPCR
Positivity on 30.10.2020 admitted on 30.10.2020 at 04.30 PM in Govt
Headquarters Hospital, Kancheepuram with Complaints of Cough for 4 days
died on 30.10.2020 at 04.50 PM due to COVID-19 Pneumonia.
COVID-19 Positive Deaths due to comorbidities – Total: 28
Death in Private health facilities due to comorbidities
Death Case No. 11139
A 74 Years old Male from Villupuram having COVID-19 RTPCR Positivity on
27.10.2020 with T2DM/HTN/CAD admitted on 14.09.2020 at 03.36 PM in
a private hospital, Chennai with Complaints of Cough died on 1.11.2020 at
01.30 AM due to MODS / COVID-19 Pneumonia.
Death Case No. 11140
A 74 Years old Male from Chennai having COVID-19 RTPCR Positivity on
20.10.2020 with DM/SHTN admitted on 20.10.2020 at 06.18 PM in a
private hospital, Chennai with Complaints of Fever for 5 days Cough for 7
days Difficulty in Breathing died on 01.11.2020 at 02.40 AM due to ARDS /
COVID-19 Pneumonia.
Death Case No. 11141
A 71 Years old Male from Thanjavur having COVID-19 RTPCR Positivity on
25.10.2020 with HTN/DM/CAD admitted on 13.10.2020 at 04.41 AM in a
private hospital, Chennai with Complaints of Cough for 7 days Difficulty in
Breathing for 1 day died on 31.10.2020 at 11.15 PM due to MODS / COVID-
19 Pneumonia.
Death Case No. 11142
A 84 Years old Male from Chennai having COVID-19 RTPCR Positivity on
22.10.2020 with CAD/SHTN/Dementia admitted on 24.10.2020 at 10.38
PM in a private hospital, Chennai with Complaints of Fever For 3 days died
on 31.10.2020 at 12.10 AM due to ARDS / COVID-19 Pneumonia.
Death Case No. 11143
A 76 Years old Male from Chennai having COVID-19 RTPCR Positivity on
29.10.2020 with DM/CAD admitted on 28.10.2020 at 06.14 AM in a private
hospital, Chennai with Complaints of Fever, Cough for 5 days and Difficulty
in Breathing for 3 days died on 31.10.2020 at 12.40 AM due to COVID-19
Pneumonia.
Death Case No. 11144
A 73 Years old Female from Kancheepuram having COVID-19 RTPCR
Positivity on 31.10.2020 with DM/HTN admitted on 30.10.2020 at 2.00 PM
in a private medical college and hospital, Chennai with Complaints of
Difficulty in Breathing for 2 days died on 31.10.2020 at 07.16 AM due to
COVID-19 Pneumonia.
Death Case No. 11145
A 94 Years old Male from Chennai having COVID-19 RTPCR Positivity on
24.10.2020 with DM/HTN/CAD admitted on 23.10.2020 at 10.32 PM in a
private hospital, Chennai with Complaints of Drowsiness died on
31.10.2020 at 11.00 AM due to COVID-19 Pneumonia.
Death Case No. 11146
A 88 Years old Male from Chennai having COVID-19 RTPCR Positivity on
30.10.2020 with DM/HTN/CAD/Head injury admitted on 31.10.2020 at
10.30 AM in a private hospital, Chennai with Complaints of Fever, Cough
and Difficulty in Breathing died on 31.10.2020 at 11.30 AM due to COVID-
19 Pneumonia.
Death Case No. 11147
A 31 Years old Male from Chennai having COVID-19 RTPCR Positivity on
22.10.2020 with DM/HTN/CKD admitted on 22.10.2020 at 01.48 PM in a
private hospital, Chennai with Complaints of Fever for 6 days and Cough for
2 days died on 31.10.2020 at 05.15 PM due to ARDS / COVID-19
Pneumonia.
Death Case No. 11148
A 91 Years old Female from Chennai having COVID-19 RTPCR Positivity on
20.10.2020 admitted on 19.10.2020 at 06.44 PM in a private hospital,
Chennai with Complaints of Fever and Difficulty in Breathing for 1 day died
on 31.10.2020 at 07.20 AM due to ARDS / COVID-19 Pneumonia.
Death Case No. 11149
A 71 Years old Female from Chengalpattu having COVID-19 RTPCR
Positivity on 27.10.2020 with T2DM/HTN/CKD admitted on 26.10.2020 at
01.26 PM in a private hospital, Chennai with Complaints of Fever,Cough for
4 days Difficulty in Breathing for 2 days died on 31.10.2020 at 07.26 PM
due to COVID-19 Pneumonia.
Death Case No. 11150
A 74 Years old Male from Kancheepuram having COVID-19 RTPCR Positivity
on 28.10.2020 with T2DM/SHTN/CAD/CABG admitted on 29.10.2020 at
12.02 AM in a private medical college and hospital, Chennai with
Complaints of Fever,Cough for 2 days died on 31.10.2020 at 11.25 PM due
to COVID-19 Pneumonia.
Death Case No. 11151
A 85 Years old Male from Tenkasi having COVID-19 RTPCR Positivity on
20.10.2020 with T2DM/HTN/CAD admitted on 20.10.2020 at 05.13 AM in
a private hospital, Madurai with Complaints of Cough for 30 days and
difficulty in breathing for 3 days died on 31.10.2020 at 08.35 AM due to
COVID-19 Pneumonia.
Death Case No. 11152
A 69 Years old Male from Chennai having COVID-19 RTPCR Positivity on
26.10.2020 with CAD admitted on 26.10.2020 at 02.00 PM in a private
hospital, Chennai with Complaints of Cough and Difficulty in Breathing died
on 27.10.2020 at 08.10 AM due to COVID-19 Brancho Pneumonia.
Death in Government health facilities (DMS) due to comorbidities
Death Case No. 11136
A 51 Years old Male from Nagapattinam having COVID-19 RTPCR Positivity
on 29.10.2020 with T2DM/SHTN/Lung Disease admitted on 30.10.2020 at
03.35 PM in Govt Periyar Hospital, Mayiladuthurai, Nagapattinam with
Complaints of Fever, Cough for 2 days and Difficulty in Breathing for 1 day
died on 31.10.2020 at 07.30 AM due to ARDS / COVID-19 Pneumonia.
Death Case No. 11137
A 58 Years old Male from Nagapattinam having COVID-19 RTPCR Positivity
on 27.10.2020 with T2DM admitted on 26.10.2020 at 05.30 PM in Govt
Periyar Hospital, Mayiladuthurai, Nagapattinam with Complaints of Fever
for 3 days, Cough for 5 days and Difficulty in Breathing for 2 days died on
31.10.2020 at 12.35 AM due to ARDS / COVID-19 Pneumonia.
Death in Government health facilities (Other Government Institutions
like Railway Hospitals, ESI hospitals) due to comorbidities
Death Case No. 11135
A 59 Years old Female from Chennai having COVID-19 RTPCR Positivity on
24.10.2020 with SHTN admitted on 22.10.2020 at 12.35 PM in
ESIC,K.K.Nagar, Chennai with Complaints of Fever,Cough for 2 days
Difficulty in Breathing for 1 days died on 01.11.2020 at 12.08 AM due to
ARDS / COVID-19 Pneumonia.
Death Case No. 11138
A 88 Years old Male from Chennai having COVID-19 RTPCR Positivity on
26.10.2020 with DM/HTN admitted on 24.10.2020 at 10.18 PM in
ESIC,K.K.Nagar, Chennai with Complaints of Difficulty in Breathing for 1
day died on 31.10.2020 at 09.08 PM due to ARDS / COVID-19 Pneumonia.
Death in Government health facilities (DME) due to comorbidities
Death Case No. 11123
A 74 years old Male from Karur with Diabetes Mellitus admitted on
30.10.2020 at 05.47 PM in Government Corona Hospital, Guindy, Chennai.
Outcome of COVID test positive result on 23.10.2020. The patient died on
31.10.2020 at 07.48 AM due to Severe COVID Pneumonia / Respiratory
Failure / Acute Respiratory Distress Syndrome / Diabetes Mellitus.
Death Case No. 11124
A 76 years old Male from Chennai with Coronary Artery Disease / Chronic
Kidney Disease / Systemic Hypertension / Diabetes Mellitus admitted
on 30.10.2020 at 04.13 PM in Government Corona Hospital, Guindy,
Chennai. Outcome of COVID test positive result on 25.10.2020. The patient
died on 30.10.2020 at 06.00 PM due to Severe COVID Pneumonia /
Respiratory Failure / Coronary Artery Disease / Chronic Kidney
Disease / Systemic Hypertension / Diabetes Mellitus.
Death Case No. 11125
A 60 years old Male from Cuddalore with Systemic Hypertension admitted
on 07.10.2020 at in Rajah Muthiah Medical College Hospital, Chidambaram.
Outcome of COVID test positive result on 05.10.2020. The patient died on
30.10.2020 at 10.15 PM due to Acute Respiratory Distress Syndrome /
SAR CoV2 Pneumonia.
Death Case No. 11126
A 60 years old Male from Tenkasi with Diabetes Mellitus admitted on
18.10.2020 at 12.25 PM in Tirunelveli Medical College Hospital. Outcome of
COVID test positive result on 13.10.2020. The patient died on 30.10.2020 at
10.10 PM due to COVID Pneumonitis / Acute Respiratory Failure /
Diabetes Mellitus.
Death Case No. 11127
A 52 years old Male from Namakkal with Type 2 Diabetes Mellitus /
Chronic Kidney Disease admitted on 30.10.2020 at 09.13 PM in Mohan
Kumaramangalam Medical College Hospital, Salem. Outcome of COVID test
positive result on 30.10.2020. The patient died on 31.10.2020 at 05.40 AM
due to COVID Pneumonia / Respiratory Failure / Type 2 Diabetes
Mellitus / Chronic Kidney Disease.
Death Case No. 11128
A 65 years old Male from Kancheepuram with Systemic Hypertension /
Type 2 Diabetes Mellitus admitted on 28.10.2020 at 03.21 AM in Rajiv
Gandhi Government General Hospital, Chennai. Outcome of COVID test
positive result on 27.10.2020. The patient died on 01.11.2020 at 01.05 AM
due to COVID Pneumonia / Respiratory Failure / Type 2 Diabetes
Mellitus / Systemic Hypertension.
Death Case No. 11129
A 81 years old Male from Kancheepuram with Type 2 Diabetes Mellitus
admitted on 28.10.2020 at 08.37 PM in Rajiv Gandhi Government General
Hospital, Chennai. Outcome of COVID test positive result on 23.10.2020.
The patient died on 31.10.2020 at 07.30 AM due to COVID Pneumonia /
Respiratory Failure / Type 2 Diabetes Mellitus.
Death Case No. 11130
A 33 years old Male from Chengalpattu with Systemic Hypertension /
Type 2 Diabetes Mellitus / Chronic Kidney Disease admitted on
29.10.2020 at 05.35 PM in Rajiv Gandhi Government General Hospital,
Chennai. Outcome of COVID test positive result on 29.10.2020. The patient
died on 31.10.2020 at 11.45 AM due to COVID Pneumonia / Respiratory
Failure / Systemic Hypertension / Type 2 Diabetes Mellitus / Chronic
Kidney Disease.
Death Case No. 11131
A 61 years old Male from Trichy with Type 2 Diabetes Mellitus / Systemic
Hypertension / Chronic Kidney Disease admitted on 29.10.2020 at 09.51
AM in Erode Medical College Hospital, Perundurai. Outcome of COVID test
positive result on 31.10.2020. The patient died on 31.10.2020 at 05.30 PM
due to COVID Pneumonia / Respiratory Failure / Chronic Kidney
Disease / Metabolic Encephalopathy / Type 2 Diabetes Mellitus /
Systemic Hypertension.
Death Case No. 11132
A 67 years old Male from Vellore with Diabetes Mellitus / Systemic
Hypertension admitted on 29.10.2020 at 04.10 PM in Vellore Medical
College Hospital. Outcome of COVID test positive result on 30.10.2020. The
patient died on 01.11.2020 at 03.10 AM due to COVID Pneumonia /
Respiratory Failure / Diabetes Mellitus / Systemic Hypertension.
COVID-19 Positive Deaths without comorbidities – Total: 3
Death in Private health facilities without comorbidities
Death Case No.11153
A 54 Years old Female from Erode having COVID-19 RTPCR Positivity on
27.10.2020 admitted on 27.10.2020 at 11.19 PM in a private hospital, Erode
with Complaints of Cough for 3 days Difficulty in Breathing for 1 day died
on 01.11.2020 at 07.30 AM due to ARDS / COVID-19 Pneumonia.
Death Case No. 11154
A 36 Years old Male from Chengalpattu having COVID-19 RTPCR Positivity
on 22.10.2020 admitted on 23.10.2020 at 09.42 AM in a private medical
college and hospital, Kancheepuram with Complaints of Fever, Throat Pain
for 3 days Cough for 1 day died on 01.11.2020 at 08.20 PM due to COVID-
19 Pneumonia.
Death in Government health facilities (Other Government Institutions
like Railway Hospitals, ESI hospitals) without comorbidities
Death Case No. 11174
A 58 years old Male from Coimbatore with admitted on 31.10.2020 at 06.47
PM in Coimbatore Medical College and ESI Hospital. Outcome of COVID test
positive result on 31.10.2020. The patient died on 31.10.2020 at 07.30 PM
due to COVID Pneumonia / Acute Respiratory Distress Syndrome.
COVID-19 Positive Deaths due to comorbidities – Total: 28
Death in Private health facilities due to comorbidities
Death Case No. 11155
A 53 Years old Male from Kancheepuram having COVID-19 RTPCR Positivity
on 19.10.2020 with Type 2 DM / SHTN admitted on 18.10.2020 at 03.01
PM in a private medical college and hospital, Kancheepuram with
Complaints of Fever,Cough and Difficulty in Breathing for 3 days died on
02.11.2020 at 05.15 AM due to COVID-19 Pneumonia.
Death Case No. 11156
A 43 Years old Male from Thiruvallur having COVID-19 RTPCR Positivity on
23.10.2020 with Type 2 DM admitted on 31.10.2020 at 07.52 AM in a
private hospital, Chennai with Complaints of Fever,Cough for 16 days
Difficulty in Breathing for 1 day died on 02.11.2020 at 05.52 AM due to
ARDS / COVID-19 Pneumonia.
Death Case No. 11157
A 55 Years old Male from Chennai having COVID-19 RTPCR Positivity on
25.10.2020 with DM / SHTN / CAD / s/p CABG admitted on 25.10.2020 at
03.37 PM in a private hospital, Chennai with Complaints of Fever,Cough for
5 days Swelling of Both Lower Limbs for 15 days died on 02.11.2020 at
03.10 AM due to COVID-19 Pneumonia.
Death Case No. 11158
A 74 Years old Female from Kanyakumari having COVID-19 RTPCR
Positivity on 27.10.2020 with SHTN / BA / IHD / Dyslipidemia /
Psychiatric Illness admitted on 27.10.2020 at 02.10 PM in a private
hospital, Nagercoil with Complaints of Fever, Cough for 7 days Difficulty in
Breathing for 3 days died on 01.11.2020 at 01.05 AM due to ARDS /
COVID-19 Pneumonia.
Death Case No. 11159
A 74 Years old Male from Chennai having COVID-19 RTPCR Positivity on
31.10.2020 with DM / SHTN / Parkinsonism admitted on 30.10.2020 at
01.30 PM in a private hospital, Chennai with Complaints of Fever,Cough
and Difficulty in Breathing died on 01.11.2020 at 04.29 PM due to COVID-
19 Pneumonia.
Death Case No. 11160
A 58 Years old Male from Kancheepuram having COVID-19 RTPCR Positivity
on 28.10.2020 with Type 2 DM admitted on 29.10.2020 at 03.43 PM in a
private medical college and hospital, Kancheepuram with Complaints of
Fever,Cough and Sore Throat for 4 days died on 01.11.2020 at 02.20 PM
due to COVID-19 Pneumonia.
Death Case No. 11161
A 85 Years old Male from Chennai having COVID-19 RTPCR Positivity on
29.10.2020 with Type 2 DM / SHTN admitted on 30.10.2020 at 06.53 PM
in a private hospital, Chennai with Complaints of Fever for 3 days
Myalgia,Sore Throat for 3 days died on 01.11.2020 at 01.00 PM due to
COVID-19 Pneumonia.
Death Case No. 11162
A 89 Years old Female from Kancheepuram having COVID-19 RTPCR
Positivity on 20.10.2020 with DM / HTN admitted on 20.10.2020 at 10.06
PM in a private hospital, Chennai with Complaints of Fever for 2 days
Altered Sensorium, Decreased Appetite died on 01.11.2020 at 01.30 PM due
to ARDS / COVID-19 Pneumonia.
Death Case No. 11163
A 59 Years old Female from Chengalpattu having COVID-19 RTPCR
Positivity on 30.10.2020 with DM / HTN / Hypothyroidism admitted on
01.11.2020 at 11.00 AM in a private hospital, Chennai with Complaints of
Difficulty in Breathing for 5 days died on 01.11.2020 at 01.30 PM due to
ARDS /COVID-19 Pneumonia.
Death Case No. 11164
A 57 Years old Male from Chennai having COVID-19 RTPCR Positivity on
01.11.2020 with DM / HTN / CKD admitted on 31.10.2020 at 08.22 AM in
a private hospital, Chennai with Complaints of Difficulty in Breathing died
on 01.11.2020 at 11.38 AM due to COVID-19 Pneumonia.
Death Case No. 11165
A 65 Years old Female from Chengalpattu having COVID-19 RTPCR
Positivity on 31.10.2020 with Type 2 DM / Bronchial Asthma admitted on
30.10.2020 at 01.49 PM in a private hospital, Chennai with Complaints of
Cough for 2 days Difficulty in Breathing for 1 day Myalgia for 4 days died on
01.11.2020 at 11.00 AM due to COVID-19 Pneumonia.
Death Case No. 11166
A 55 Years old Female from Madurai having COVID-19 RTPCR Positivity on
22.10.2020 with Type 2 DM / SHTN / CAD admitted on 22.10.2020 at
12.18 AM in a private hospital, Madurai with Complaints of Fever, Myalgia
for 2 days Difficulty in Breathing for 1 day died on 01.11.2020 at 08.39 AM
due to COVID-19 Pneumonia.
Death Case No. 11167
A 85 Years old Female from Coimbatore having COVID-19 RTPCR Positivity
on 27.10.2020 with Type 2 DM admitted on 27.10.2020 at 08.05 PM in a
private hospital, Coimbatore with Complaints of Fever for 5 days died on
01.11.2020 at 10.20 AM due to COVID-19 Pneumonia.
Death Case No. 11168
A 72 Years old Female from Coimbatore having COVID-19 RTPCR Positivity
on 31.10.2020 with Chronic Renal Failure / DM admitted on 30.10.2020
at 05.45 PM in a private hospital, Coimbatore with Complaints of Difficulty
in Breathing died on 01.11.2020 at 11.00 PM due to COVID-19 Pneumonia.
Death Case No. 11169
A 78 Years old Male from Chennai having COVID-19 RTPCR Positivity on
24.10.2020 with DM / HTN / CKD / Hypothyroidism / CAD admitted on
24.10.2020 at 10.02 AM in a private hospital, Chennai with Complaints of
Cough and Difficulty in Breathing for 6 days died on 31.10.2020 at 07.27
PM due to ARDS / MODS / COVID-19 Pneumonia.
Death Case No. 11170
A 44 Years old Female from Salem having COVID-19 RTPCR Positivity on
28.10.2020 with Type 2 DM / Hypothyroidism admitted on 28.10.2020 at
01.43 PM in a private hospital, Salem with Complaints of Fever, Body Pain,
Cough for 3 days died on 31.10.2020 at 06.10 PM due to ARDS / COVID-19
Pneumonia.
Death Case No. 11171
A 69 Years old Male from Vellore having COVID-19 RTPCR Positivity on
14.10.2020 with Rheumatoid Arthrits admitted on 14.10.2020 at 12.31
AM in a private hospital, Vellore with Complaints of Fever,Cough and
Difficulty in Breathing for 3 days died on 31.10.2020 at 11.50 PM due to
ARDS / COVID-19 Pneumonia.
Death Case No. 11172
A 84 Years old Male from Virudhunagar having COVID-19 RTPCR Positivity
on 21.10.2020 admitted on 22.10.2020 at 01.30 PM in a private hospital,
Virudhunagar with Complaints of Cough and DIfficulty in Breathing for 14
days died on 29.10.2020 at 02.35 PM due to ARDS / COVID-19
Pneumonia.
Death Case No. 11173
A 73 Years old Male from Salem having COVID-19 TRUNAT Positivity on
28.10.2020 with T2DM / BPH / Parkinson Disease admitted on
28.10.2020 at 10.45 p.m in a private hospital, Salem with Complaints of
Fever,Cough and Difficulty in Breathing for 2 days died on 01.11.2020 at
12.55 AM due to COVID-19 Pneumonia.
Death in Government health facilities (Other Government Institutions
like Railway Hospitals, ESI hospitals) due to comorbidities
Death Case No. 11178
A 55 years old Male from Coimbatore with Diabetes Mellitus admitted on
29.10.2020 in Coimbatore Medical College and ESI Hospital. Outcome of
COVID test positive result on 28.10.2020. The patient died on 31.10.2020 at
10.36 AM due to COVID Pneumonia / Acute Respiratory Distress
Syndrome.
Death in Government health facilities (DME) due to comorbidities
Death Case No. 11175
A 54 years old Male from Chengalpattu with Systemic Hypertension
admitted on 28.10.2020 at 5.30 PM in Chengalpattu Medical College
Hospital. Outcome of COVID test positive result on 28.10.2020. The patient
died on 30.10.2020 at 5.35 PM due to COVID Pneumonia / Cardiogenic
Shock / Acute Pulmonary Edema.
Death Case No. 11176
A 60 years old Female from Chengalpattu with Type 2 Diabetes Mellitus /
Systemic Hypertension / Coronary Artery Heart Disease admitted on
29.10.2020 at 12.25 PM in Chengalpattu Medical College Hospital.
Outcome of COVID test positive result on 26.10.2020. The patient died on
30.10.2020 at 02.25 PM due to COVID Pneumonia / Aspiration
Pneumonitis / Metabolic Encephalopathy.
Death Case No. 11177
A 67 years old Male from Chengalpattu with Chronic Kidney Disease /
Hypertension admitted on 26.10.2020 at 08.22 PM in Chengalpattu
Medical College Hospital. Outcome of COVID test positive result on
28.10.2020. The patient died on 31.10.2020 at 12.30 PM due to COVID
Pneumonia / Acute Respiratory Distress Syndrome / Chronic Kidney
Disease / Systemic Hypertension.
Death Case No. 11179
A 88 years old Female from Chennai with Systemic Hypertension admitted
on 31.10.2020 at 09.50 PM in Rajiv Gandhi Government General Hospital,
Chennai. Outcome of COVID test positive result on 31.10.2020. The patient
died on 01.11.2020 at 10.40 PM due to COVID Pneumonia / Respiratory
Failure / Systemic Hypertension.
Death Case No. 11180
A 78 years old Male from Chennai with Coronary Artery Disease /
Diabetes Mellitus admitted on 28.10.2020 at 10.49 AM in Kilpauk Medical
College Hospital. Outcome of COVID test positive result on 28.10.2020. The
patient died on 01.11.2020 at 11.10 AM due to COVID Pneumonia / Sepsis
/ Septic Shock / Coronary Artery Disease / Type 2 Diabetes Mellitus.
Death Case No. 11181
A 63 years old Male from Chennai with Systemic Hypertension / Diabetes
Mellitus / Elephantiasis / Obesity admitted on 30.10.2020 at 11.50 AM in
Government Medical College, Omandurar Government Estate, Chennai.
Outcome of COVID test positive result on 31.10.2020. The patient died on
01.11.2020 at 03.45 PM due to COVID Pneumonia / Acute Respiratory
Distress Syndrome / Acute Respiratory Failure / Sepsis / Systemic
Hypertension / Diabetes Mellitus.
Death Case No. 11182
A 65 years old Male from Coimbatore with Type 2 Diabetes Mellitus
admitted on 28.10.2020 at 11.36 AM in Coimbatore Medical College
Hospital. Outcome of COVID test positive result on 29.10.2020. The patient
died on 31.10.2020 at 08.10 AM due to Bilateral Brochopneumonia /
Acute Respiratory Distress Syndrome / Type 2 Diabetes Mellitus.
Death Case No. 11183
A 56 years old Female from Chennai with Morbid Obesity /
Hypothyroidism / Type 2 Diabetes Mellitus admitted on 29.10.2020 at
12.04 AM in Kilpauk Medical College Hospital. Outcome of COVID test
positive result on 29.10.2020. The patient died on 01.11.2020 at 11.10 AM
due to COVID Pneumonia / Acute Respiratory Distress Syndrome /
Morbid Obesity / Hypothyridism / Type 2 Diabetes Mellitus.
Display the source blob
Display the rendered blob
Raw
{
"nbformat": 4,
"nbformat_minor": 0,
"metadata": {
"colab": {
"name": "CovidBulletinExtractor.ipynb",
"provenance": [],
"collapsed_sections": [],
"authorship_tag": "ABX9TyNH52O0Rx2T47GC6sWtsN5T",
"include_colab_link": true
},
"kernelspec": {
"name": "python3",
"display_name": "Python 3"
}
},
"cells": [
{
"cell_type": "markdown",
"metadata": {
"id": "view-in-github",
"colab_type": "text"
},
"source": [
"<a href=\"https://colab.research.google.com/gist/tecoholic/af51aa22a675d8f934716a92b1fe60d7/covidbulletinextractor.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
]
},
{
"cell_type": "code",
"metadata": {
"id": "9RXW_50snaLI"
},
"source": [
"# Extract cases into individual strings\n",
"cases = []\n",
"with open(\"02-11-2020.txt\") as fp:\n",
" current = []\n",
" for line in fp:\n",
" if line.startswith(\"Death Case No.\"):\n",
" if current:\n",
" cases.append(current)\n",
" current = [line]\n",
" elif line.startswith(\"Death\"):\n",
" cases.append(current)\n",
" current = []\n",
" #print(line)\n",
" elif current:\n",
" current.append(line)\n",
" else:\n",
" #print(line)\n",
" pass\n",
"\n",
"cases = [\"\".join(case).replace(\"\\n\", \" \").strip() for case in cases if case]\n",
"with open(\"02-11-2020-cases.txt\", \"w\") as op:\n",
" op.write(\"\\n\".join(cases))"
],
"execution_count": 5,
"outputs": []
},
{
"cell_type": "code",
"metadata": {
"id": "C3q9E9qnpil0"
},
"source": [
"import spacy\n",
"from spacy import displacy\n",
"import en_core_web_sm\n",
"\n",
"nlp = en_core_web_sm.load()"
],
"execution_count": 6,
"outputs": []
},
{
"cell_type": "code",
"metadata": {
"id": "1nlz0iZit_ZL"
},
"source": [
"import random\n",
"import json\n",
"\n",
"with open(\"data.json\") as fp:\n",
" data = json.load(fp)\n",
"\n",
"\n",
"nlp = spacy.blank('en') # new, empty model. Let’s say it’s for the English language\n",
"nlp.vocab.vectors.name = 'example_model_training' # give a name to our list of vectors\n",
"# add NER pipeline\n",
"ner = nlp.create_pipe('ner') # our pipeline would just do NER\n",
"nlp.add_pipe(ner, last=True) # we add the pipeline to the model\n",
"\n",
"for label in data[\"classes\"]:\n",
" nlp.entity.add_label(label)\n",
"\n",
"optimizer = nlp.begin_training()\n",
"\n",
"for i in range(20):\n",
" random.shuffle(data[\"annotations\"])\n",
" for text, annotations in data[\"annotations\"]:\n",
" nlp.update([text], [annotations], sgd=optimizer)"
],
"execution_count": 7,
"outputs": []
},
{
"cell_type": "code",
"metadata": {
"id": "pQN7jZwr6gfM",
"colab": {
"base_uri": "https://localhost:8080/",
"height": 122
},
"outputId": "f1230aab-620d-45aa-cf32-1188f53197a6"
},
"source": [
"from spacy import displacy\n",
"\n",
"colors = [\"#2E8B57\", \"#00FFFF\", \"#FF4500\", \"#00FF00\", \"#C8C8FF\", \"#FFA07A\", \"#90EE90\", \"#AB958B\", \"#BA55D3\", \"#FFFF00\", \"#FFC0CB\", \"#FF69B4\", \"#7FFFD4\"]\n",
"options = {\"colors\": dict(zip([l.upper() for l in data[\"classes\"]], colors))}\n",
"\n",
"displacy.render(nlp(cases[26]), jupyter=True, style='ent', options=options)\n"
],
"execution_count": 9,
"outputs": [
{
"output_type": "display_data",
"data": {
"text/html": [
"<span class=\"tex2jax_ignore\"><div class=\"entities\" style=\"line-height: 2.5; direction: ltr\">Death Case No. \n",
"<mark class=\"entity\" style=\"background: #2E8B57; padding: 0.45em 0.6em; margin: 0 0.25em; line-height: 1; border-radius: 0.35em;\">\n",
" 11179\n",
" <span style=\"font-size: 0.8em; font-weight: bold; line-height: 1; border-radius: 0.35em; text-transform: uppercase; vertical-align: middle; margin-left: 0.5rem\">CASENO</span>\n",
"</mark>\n",
" A \n",
"<mark class=\"entity\" style=\"background: #7FFFD4; padding: 0.45em 0.6em; margin: 0 0.25em; line-height: 1; border-radius: 0.35em;\">\n",
" 88\n",
" <span style=\"font-size: 0.8em; font-weight: bold; line-height: 1; border-radius: 0.35em; text-transform: uppercase; vertical-align: middle; margin-left: 0.5rem\">AGE</span>\n",
"</mark>\n",
" years old \n",
"<mark class=\"entity\" style=\"background: #00FFFF; padding: 0.45em 0.6em; margin: 0 0.25em; line-height: 1; border-radius: 0.35em;\">\n",
" Female\n",
" <span style=\"font-size: 0.8em; font-weight: bold; line-height: 1; border-radius: 0.35em; text-transform: uppercase; vertical-align: middle; margin-left: 0.5rem\">GENDER</span>\n",
"</mark>\n",
" from \n",
"<mark class=\"entity\" style=\"background: #FF4500; padding: 0.45em 0.6em; margin: 0 0.25em; line-height: 1; border-radius: 0.35em;\">\n",
" Chennai\n",
" <span style=\"font-size: 0.8em; font-weight: bold; line-height: 1; border-radius: 0.35em; text-transform: uppercase; vertical-align: middle; margin-left: 0.5rem\">PLACE</span>\n",
"</mark>\n",
" with Systemic Hypertension admitted on \n",
"<mark class=\"entity\" style=\"background: #C8C8FF; padding: 0.45em 0.6em; margin: 0 0.25em; line-height: 1; border-radius: 0.35em;\">\n",
" 31.10.2020\n",
" <span style=\"font-size: 0.8em; font-weight: bold; line-height: 1; border-radius: 0.35em; text-transform: uppercase; vertical-align: middle; margin-left: 0.5rem\">ADMITDATE</span>\n",
"</mark>\n",
" at \n",
"<mark class=\"entity\" style=\"background: #FFA07A; padding: 0.45em 0.6em; margin: 0 0.25em; line-height: 1; border-radius: 0.35em;\">\n",
" 09.50 PM\n",
" <span style=\"font-size: 0.8em; font-weight: bold; line-height: 1; border-radius: 0.35em; text-transform: uppercase; vertical-align: middle; margin-left: 0.5rem\">ADMITTIME</span>\n",
"</mark>\n",
" in Rajiv Gandhi Government General Hospital, Chennai. Outcome of COVID test positive result on 31.10.2020. The patient died on \n",
"<mark class=\"entity\" style=\"background: #FFFF00; padding: 0.45em 0.6em; margin: 0 0.25em; line-height: 1; border-radius: 0.35em;\">\n",
" 01.11.2020\n",
" <span style=\"font-size: 0.8em; font-weight: bold; line-height: 1; border-radius: 0.35em; text-transform: uppercase; vertical-align: middle; margin-left: 0.5rem\">DATEOFDEATH</span>\n",
"</mark>\n",
" at \n",
"<mark class=\"entity\" style=\"background: #FFC0CB; padding: 0.45em 0.6em; margin: 0 0.25em; line-height: 1; border-radius: 0.35em;\">\n",
" 10.40 PM\n",
" <span style=\"font-size: 0.8em; font-weight: bold; line-height: 1; border-radius: 0.35em; text-transform: uppercase; vertical-align: middle; margin-left: 0.5rem\">TIMEOFDEATH</span>\n",
"</mark>\n",
" due to \n",
"<mark class=\"entity\" style=\"background: #FF69B4; padding: 0.45em 0.6em; margin: 0 0.25em; line-height: 1; border-radius: 0.35em;\">\n",
" COVID Pneumonia / Respiratory Failure\n",
" <span style=\"font-size: 0.8em; font-weight: bold; line-height: 1; border-radius: 0.35em; text-transform: uppercase; vertical-align: middle; margin-left: 0.5rem\">CAUSEOFDEATH</span>\n",
"</mark>\n",
" / Systemic Hypertension.</div></span>"
],
"text/plain": [
"<IPython.core.display.HTML object>"
]
},
"metadata": {
"tags": []
}
}
]
},
{
"cell_type": "code",
"metadata": {
"id": "q8YBbr6s7J5x",
"colab": {
"base_uri": "https://localhost:8080/",
"height": 122
},
"outputId": "acd99e59-2c31-465c-c9fd-1a348e1d57ee"
},
"source": [
"case = \"\"\"Death Case No. 11258 A 28 Years old Male from Thoothukudi having COVID-19 RTPCR Positivity on 30.10.2020 admitted on 29.10.2020 at 10.22 PM in a private hospital, Madurai with complaints of Chronic Pancreatities died on 04.11.2020 at 09.27 AM due to COVID-19 Pneumonia.\"\"\"\n",
"displacy.render(nlp(case), jupyter=True, style=\"ent\", options=options)"
],
"execution_count": 10,
"outputs": [
{
"output_type": "display_data",
"data": {
"text/html": [
"<span class=\"tex2jax_ignore\"><div class=\"entities\" style=\"line-height: 2.5; direction: ltr\">Death Case No. \n",
"<mark class=\"entity\" style=\"background: #2E8B57; padding: 0.45em 0.6em; margin: 0 0.25em; line-height: 1; border-radius: 0.35em;\">\n",
" 11258\n",
" <span style=\"font-size: 0.8em; font-weight: bold; line-height: 1; border-radius: 0.35em; text-transform: uppercase; vertical-align: middle; margin-left: 0.5rem\">CASENO</span>\n",
"</mark>\n",
" A \n",
"<mark class=\"entity\" style=\"background: #7FFFD4; padding: 0.45em 0.6em; margin: 0 0.25em; line-height: 1; border-radius: 0.35em;\">\n",
" 28\n",
" <span style=\"font-size: 0.8em; font-weight: bold; line-height: 1; border-radius: 0.35em; text-transform: uppercase; vertical-align: middle; margin-left: 0.5rem\">AGE</span>\n",
"</mark>\n",
" Years old \n",
"<mark class=\"entity\" style=\"background: #00FFFF; padding: 0.45em 0.6em; margin: 0 0.25em; line-height: 1; border-radius: 0.35em;\">\n",
" Male\n",
" <span style=\"font-size: 0.8em; font-weight: bold; line-height: 1; border-radius: 0.35em; text-transform: uppercase; vertical-align: middle; margin-left: 0.5rem\">GENDER</span>\n",
"</mark>\n",
" from \n",
"<mark class=\"entity\" style=\"background: #FF4500; padding: 0.45em 0.6em; margin: 0 0.25em; line-height: 1; border-radius: 0.35em;\">\n",
" Thoothukudi\n",
" <span style=\"font-size: 0.8em; font-weight: bold; line-height: 1; border-radius: 0.35em; text-transform: uppercase; vertical-align: middle; margin-left: 0.5rem\">PLACE</span>\n",
"</mark>\n",
" having COVID-19 RTPCR Positivity on \n",
"<mark class=\"entity\" style=\"background: #00FF00; padding: 0.45em 0.6em; margin: 0 0.25em; line-height: 1; border-radius: 0.35em;\">\n",
" 30.10.2020\n",
" <span style=\"font-size: 0.8em; font-weight: bold; line-height: 1; border-radius: 0.35em; text-transform: uppercase; vertical-align: middle; margin-left: 0.5rem\">TESTEDON</span>\n",
"</mark>\n",
" admitted on \n",
"<mark class=\"entity\" style=\"background: #C8C8FF; padding: 0.45em 0.6em; margin: 0 0.25em; line-height: 1; border-radius: 0.35em;\">\n",
" 29.10.2020\n",
" <span style=\"font-size: 0.8em; font-weight: bold; line-height: 1; border-radius: 0.35em; text-transform: uppercase; vertical-align: middle; margin-left: 0.5rem\">ADMITDATE</span>\n",
"</mark>\n",
" at \n",
"<mark class=\"entity\" style=\"background: #FFA07A; padding: 0.45em 0.6em; margin: 0 0.25em; line-height: 1; border-radius: 0.35em;\">\n",
" 10.22 PM\n",
" <span style=\"font-size: 0.8em; font-weight: bold; line-height: 1; border-radius: 0.35em; text-transform: uppercase; vertical-align: middle; margin-left: 0.5rem\">ADMITTIME</span>\n",
"</mark>\n",
" in a \n",
"<mark class=\"entity\" style=\"background: #90EE90; padding: 0.45em 0.6em; margin: 0 0.25em; line-height: 1; border-radius: 0.35em;\">\n",
" private hospital, Madurai\n",
" <span style=\"font-size: 0.8em; font-weight: bold; line-height: 1; border-radius: 0.35em; text-transform: uppercase; vertical-align: middle; margin-left: 0.5rem\">HOSPITAL</span>\n",
"</mark>\n",
" with \n",
"<mark class=\"entity\" style=\"background: #AB958B; padding: 0.45em 0.6em; margin: 0 0.25em; line-height: 1; border-radius: 0.35em;\">\n",
" complaints of Chronic Pancreatities\n",
" <span style=\"font-size: 0.8em; font-weight: bold; line-height: 1; border-radius: 0.35em; text-transform: uppercase; vertical-align: middle; margin-left: 0.5rem\">SYMPTOMS</span>\n",
"</mark>\n",
" died on \n",
"<mark class=\"entity\" style=\"background: #FFFF00; padding: 0.45em 0.6em; margin: 0 0.25em; line-height: 1; border-radius: 0.35em;\">\n",
" 04.11.2020\n",
" <span style=\"font-size: 0.8em; font-weight: bold; line-height: 1; border-radius: 0.35em; text-transform: uppercase; vertical-align: middle; margin-left: 0.5rem\">DATEOFDEATH</span>\n",
"</mark>\n",
" at \n",
"<mark class=\"entity\" style=\"background: #FFC0CB; padding: 0.45em 0.6em; margin: 0 0.25em; line-height: 1; border-radius: 0.35em;\">\n",
" 09.27 AM\n",
" <span style=\"font-size: 0.8em; font-weight: bold; line-height: 1; border-radius: 0.35em; text-transform: uppercase; vertical-align: middle; margin-left: 0.5rem\">TIMEOFDEATH</span>\n",
"</mark>\n",
" due to \n",
"<mark class=\"entity\" style=\"background: #FF69B4; padding: 0.45em 0.6em; margin: 0 0.25em; line-height: 1; border-radius: 0.35em;\">\n",
" COVID-19 Pneumonia\n",
" <span style=\"font-size: 0.8em; font-weight: bold; line-height: 1; border-radius: 0.35em; text-transform: uppercase; vertical-align: middle; margin-left: 0.5rem\">CAUSEOFDEATH</span>\n",
"</mark>\n",
".</div></span>"
],
"text/plain": [
"<IPython.core.display.HTML object>"
]
},
"metadata": {
"tags": []
}
}
]
},
{
"cell_type": "code",
"metadata": {
"id": "Zi347rhz8JrN",
"outputId": "47246cee-1bf6-483d-a586-87e5c54b80ae",
"colab": {
"base_uri": "https://localhost:8080/",
"height": 1000
}
},
"source": [
"from collections import defaultdict\n",
"\n",
"def get_preds(text):\n",
" out = defaultdict(set)\n",
" for entity in nlp(text).ents:\n",
" out[entity.label_].add(entity.text)\n",
" return out\n",
"\n",
"outcome = []\n",
"for case in cases:\n",
" out = get_preds(case)\n",
" outcome.append({\n",
" k: \", \".join(v) for k, v in out.items()\n",
" })\n",
"\n",
"import pandas as pd\n",
"\n",
"df = pd.DataFrame(outcome)\n",
"df.to_csv(\"02-11-2020.csv\")\n",
"df"
],
"execution_count": 12,
"outputs": [
{
"output_type": "execute_result",
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>GENDER</th>\n",
" <th>PLACE</th>\n",
" <th>TESTEDON</th>\n",
" <th>ADMITDATE</th>\n",
" <th>ADMITTIME</th>\n",
" <th>HOSPITAL</th>\n",
" <th>SYMPTOMS</th>\n",
" <th>SYMPTOMDAYS</th>\n",
" <th>DATEOFDEATH</th>\n",
" <th>CASENO</th>\n",
" <th>AGE</th>\n",
" <th>TIMEOFDEATH</th>\n",
" <th>CAUSEOFDEATH</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>Female</td>\n",
" <td>Erode</td>\n",
" <td>27.10.2020</td>\n",
" <td>27.10.2020</td>\n",
" <td>11.19 PM</td>\n",
" <td>private hospital, Erode</td>\n",
" <td>Difficulty in Breathing, Cough</td>\n",
" <td>3, 1</td>\n",
" <td>01.11.2020</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>Male</td>\n",
" <td>Chengalpattu</td>\n",
" <td>22.10.2020</td>\n",
" <td>23.10.2020</td>\n",
" <td>09.42 AM</td>\n",
" <td>private medical college and hospital, Kancheep...</td>\n",
" <td>Complaints of Fever, Throat Pain, Cough</td>\n",
" <td>3, 1</td>\n",
" <td>01.11.2020</td>\n",
" <td>11154</td>\n",
" <td>36</td>\n",
" <td>08.20 PM</td>\n",
" <td>COVID- 19 Pneumonia</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>Male</td>\n",
" <td>Coimbatore</td>\n",
" <td>NaN</td>\n",
" <td>31.10.2020</td>\n",
" <td>06.47 PM</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>11174</td>\n",
" <td>58</td>\n",
" <td>Syndrome.</td>\n",
" <td>COVID Pneumonia / Acute Respiratory</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>Male</td>\n",
" <td>Kancheepuram</td>\n",
" <td>19.10.2020</td>\n",
" <td>18.10.2020</td>\n",
" <td>03.01 PM</td>\n",
" <td>private medical college and hospital, Kancheep...</td>\n",
" <td>Complaints of Fever,Cough, Difficulty in Breat...</td>\n",
" <td>3</td>\n",
" <td>02.11.2020</td>\n",
" <td>11155</td>\n",
" <td>53</td>\n",
" <td>05.15 AM</td>\n",
" <td>COVID-19 Pneumonia</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>Male</td>\n",
" <td>Thiruvallur</td>\n",
" <td>23.10.2020</td>\n",
" <td>31.10.2020</td>\n",
" <td>07.52 AM</td>\n",
" <td>private hospital, Chennai</td>\n",
" <td>Complaints of Fever,Cough, Difficulty in Breat...</td>\n",
" <td>16, 1</td>\n",
" <td>02.11.2020</td>\n",
" <td>11156</td>\n",
" <td>43</td>\n",
" <td>05.52 AM</td>\n",
" <td>ARDS / COVID-19 Pneumonia</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5</th>\n",
" <td>Male</td>\n",
" <td>Chennai</td>\n",
" <td>25.10.2020</td>\n",
" <td>25.10.2020</td>\n",
" <td>03.37 PM</td>\n",
" <td>private hospital, Chennai</td>\n",
" <td>Complaints of Fever,Cough, Swelling of Both</td>\n",
" <td>5, 15</td>\n",
" <td>02.11.2020</td>\n",
" <td>11157</td>\n",
" <td>55</td>\n",
" <td>03.10 AM</td>\n",
" <td>COVID-19 Pneumonia, Lower Limbs</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6</th>\n",
" <td>Female</td>\n",
" <td>Kanyakumari</td>\n",
" <td>27.10.2020</td>\n",
" <td>27.10.2020</td>\n",
" <td>02.10 PM</td>\n",
" <td>private hospital, Nagercoil</td>\n",
" <td>Complaints of Fever, Cough, Difficulty in Brea...</td>\n",
" <td>3, 7</td>\n",
" <td>01.11.2020</td>\n",
" <td>11158</td>\n",
" <td>74</td>\n",
" <td>01.05 AM</td>\n",
" <td>ARDS / COVID-19 Pneumonia</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7</th>\n",
" <td>Male</td>\n",
" <td>Chennai</td>\n",
" <td>31.10.2020</td>\n",
" <td>30.10.2020</td>\n",
" <td>01.30 PM</td>\n",
" <td>private hospital, Chennai</td>\n",
" <td>Complaints of Fever,Cough, Difficulty in Breat...</td>\n",
" <td>NaN</td>\n",
" <td>01.11.2020</td>\n",
" <td>11159</td>\n",
" <td>74</td>\n",
" <td>04.29 PM</td>\n",
" <td>COVID- 19 Pneumonia</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8</th>\n",
" <td>Male</td>\n",
" <td>Kancheepuram</td>\n",
" <td>28.10.2020</td>\n",
" <td>29.10.2020</td>\n",
" <td>03.43 PM</td>\n",
" <td>private medical college and hospital, Kancheep...</td>\n",
" <td>Complaints of Fever,Cough</td>\n",
" <td>4, Sore</td>\n",
" <td>01.11.2020</td>\n",
" <td>11160</td>\n",
" <td>58</td>\n",
" <td>02.20 PM</td>\n",
" <td>COVID-19 Pneumonia</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9</th>\n",
" <td>Male</td>\n",
" <td>Chennai</td>\n",
" <td>29.10.2020</td>\n",
" <td>30.10.2020</td>\n",
" <td>06.53 PM</td>\n",
" <td>private hospital, Chennai</td>\n",
" <td>Myalgia,Sore Throat, Complaints of Fever</td>\n",
" <td>3</td>\n",
" <td>01.11.2020</td>\n",
" <td>11161</td>\n",
" <td>85</td>\n",
" <td>01.00 PM</td>\n",
" <td>COVID-19 Pneumonia</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10</th>\n",
" <td>Female</td>\n",
" <td>Kancheepuram</td>\n",
" <td>20.10.2020</td>\n",
" <td>20.10.2020</td>\n",
" <td>10.06 PM</td>\n",
" <td>private hospital, Chennai</td>\n",
" <td>Complaints of Fever</td>\n",
" <td>2</td>\n",
" <td>01.11.2020</td>\n",
" <td>11162</td>\n",
" <td>89</td>\n",
" <td>01.30 PM</td>\n",
" <td>ARDS / COVID-19 Pneumonia</td>\n",
" </tr>\n",
" <tr>\n",
" <th>11</th>\n",
" <td>Female</td>\n",
" <td>Chengalpattu</td>\n",
" <td>30.10.2020</td>\n",
" <td>01.11.2020</td>\n",
" <td>11.00 AM</td>\n",
" <td>private hospital, Chennai</td>\n",
" <td>Complaints of Difficulty</td>\n",
" <td>5</td>\n",
" <td>01.11.2020</td>\n",
" <td>11163</td>\n",
" <td>59</td>\n",
" <td>01.30 PM</td>\n",
" <td>ARDS /COVID-19 Pneumonia, in Breathing</td>\n",
" </tr>\n",
" <tr>\n",
" <th>12</th>\n",
" <td>Male</td>\n",
" <td>Chennai</td>\n",
" <td>01.11.2020</td>\n",
" <td>31.10.2020</td>\n",
" <td>08.22 AM</td>\n",
" <td>private hospital, Chennai</td>\n",
" <td>Complaints of Difficulty</td>\n",
" <td>NaN</td>\n",
" <td>01.11.2020</td>\n",
" <td>11164</td>\n",
" <td>57</td>\n",
" <td>11.38 AM</td>\n",
" <td>COVID-19 Pneumonia, in Breathing</td>\n",
" </tr>\n",
" <tr>\n",
" <th>13</th>\n",
" <td>Female</td>\n",
" <td>Chengalpattu</td>\n",
" <td>31.10.2020</td>\n",
" <td>30.10.2020</td>\n",
" <td>01.49 PM</td>\n",
" <td>private hospital, Chennai</td>\n",
" <td>Myalgia, Difficulty in Breathing, Cough</td>\n",
" <td>2, 4, 1</td>\n",
" <td>01.11.2020</td>\n",
" <td>11165</td>\n",
" <td>65</td>\n",
" <td>11.00 AM</td>\n",
" <td>COVID-19 Pneumonia</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14</th>\n",
" <td>Female</td>\n",
" <td>Madurai</td>\n",
" <td>22.10.2020</td>\n",
" <td>22.10.2020</td>\n",
" <td>12.18 AM</td>\n",
" <td>private hospital, Madurai</td>\n",
" <td>Complaints of Fever, Myalgia, Difficulty in Br...</td>\n",
" <td>2, 1</td>\n",
" <td>01.11.2020</td>\n",
" <td>11166</td>\n",
" <td>55</td>\n",
" <td>08.39 AM</td>\n",
" <td>COVID-19 Pneumonia</td>\n",
" </tr>\n",
" <tr>\n",
" <th>15</th>\n",
" <td>Female</td>\n",
" <td>Coimbatore</td>\n",
" <td>27.10.2020</td>\n",
" <td>27.10.2020</td>\n",
" <td>08.05 PM</td>\n",
" <td>private hospital, Coimbatore</td>\n",
" <td>Complaints of Fever</td>\n",
" <td>5</td>\n",
" <td>01.11.2020</td>\n",
" <td>11167</td>\n",
" <td>85</td>\n",
" <td>10.20 AM</td>\n",
" <td>COVID-19 Pneumonia</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16</th>\n",
" <td>Female</td>\n",
" <td>Coimbatore</td>\n",
" <td>31.10.2020</td>\n",
" <td>30.10.2020</td>\n",
" <td>05.45 PM</td>\n",
" <td>private hospital, Coimbatore</td>\n",
" <td>Complaints of Difficulty</td>\n",
" <td>NaN</td>\n",
" <td>01.11.2020</td>\n",
" <td>11168</td>\n",
" <td>72</td>\n",
" <td>11.00 PM</td>\n",
" <td>COVID-19 Pneumonia, in Breathing</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17</th>\n",
" <td>Male</td>\n",
" <td>Chennai</td>\n",
" <td>24.10.2020</td>\n",
" <td>24.10.2020</td>\n",
" <td>10.02 AM</td>\n",
" <td>private hospital, Chennai</td>\n",
" <td>Difficulty in Breathing, Cough</td>\n",
" <td>6</td>\n",
" <td>31.10.2020</td>\n",
" <td>11169</td>\n",
" <td>78</td>\n",
" <td>07.27 PM</td>\n",
" <td>ARDS / MODS / COVID-19 Pneumonia</td>\n",
" </tr>\n",
" <tr>\n",
" <th>18</th>\n",
" <td>Female</td>\n",
" <td>Salem</td>\n",
" <td>28.10.2020</td>\n",
" <td>28.10.2020</td>\n",
" <td>01.43 PM</td>\n",
" <td>private hospital, Salem</td>\n",
" <td>Complaints of Fever, Body</td>\n",
" <td>3</td>\n",
" <td>31.10.2020</td>\n",
" <td>11170</td>\n",
" <td>44</td>\n",
" <td>06.10 PM, , Cough</td>\n",
" <td>ARDS / COVID-19 Pneumonia</td>\n",
" </tr>\n",
" <tr>\n",
" <th>19</th>\n",
" <td>Male</td>\n",
" <td>Vellore</td>\n",
" <td>14.10.2020</td>\n",
" <td>14.10.2020</td>\n",
" <td>12.31 AM</td>\n",
" <td>private hospital, Vellore</td>\n",
" <td>Complaints of Fever,Cough, Difficulty in Breat...</td>\n",
" <td>3</td>\n",
" <td>31.10.2020</td>\n",
" <td>11171</td>\n",
" <td>NaN</td>\n",
" <td>11.50 PM</td>\n",
" <td>ARDS / COVID-19 Pneumonia</td>\n",
" </tr>\n",
" <tr>\n",
" <th>20</th>\n",
" <td>Male</td>\n",
" <td>Virudhunagar</td>\n",
" <td>21.10.2020</td>\n",
" <td>22.10.2020</td>\n",
" <td>01.30 PM</td>\n",
" <td>private hospital, Virudhunagar</td>\n",
" <td>DIfficulty in Breathing, Cough</td>\n",
" <td>14</td>\n",
" <td>29.10.2020</td>\n",
" <td>11172</td>\n",
" <td>84</td>\n",
" <td>02.35 PM</td>\n",
" <td>ARDS / COVID-19 Pneumonia</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21</th>\n",
" <td>Male</td>\n",
" <td>Salem</td>\n",
" <td>28.10.2020</td>\n",
" <td>28.10.2020</td>\n",
" <td>10.45 p.m</td>\n",
" <td>private hospital, Salem</td>\n",
" <td>Complaints of Fever,Cough, Difficulty in Breat...</td>\n",
" <td>2</td>\n",
" <td>01.11.2020</td>\n",
" <td>11173</td>\n",
" <td>73</td>\n",
" <td>12.55 AM</td>\n",
" <td>COVID-19 Pneumonia</td>\n",
" </tr>\n",
" <tr>\n",
" <th>22</th>\n",
" <td>Male</td>\n",
" <td>Coimbatore</td>\n",
" <td>29.10.2020</td>\n",
" <td>College</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>ESI Hospital. Outcome</td>\n",
" <td>NaN</td>\n",
" <td>28.10.2020, 31.10.2020</td>\n",
" <td>11178</td>\n",
" <td>55</td>\n",
" <td>10.36 AM</td>\n",
" <td>COVID Pneumonia / Acute Respiratory</td>\n",
" </tr>\n",
" <tr>\n",
" <th>23</th>\n",
" <td>Male</td>\n",
" <td>Chengalpattu</td>\n",
" <td>NaN</td>\n",
" <td>28.10.2020</td>\n",
" <td>5.30 PM</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>30.10.2020</td>\n",
" <td>11175</td>\n",
" <td>54</td>\n",
" <td>5.35 PM</td>\n",
" <td>COVID Pneumonia / Cardiogenic Shock / Acute Pu...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>24</th>\n",
" <td>Female</td>\n",
" <td>Chengalpattu</td>\n",
" <td>NaN</td>\n",
" <td>29.10.2020</td>\n",
" <td>12.25 PM</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>30.10.2020</td>\n",
" <td>11176</td>\n",
" <td>60</td>\n",
" <td>02.25 PM</td>\n",
" <td>COVID Pneumonia / Aspiration Pneumonitis</td>\n",
" </tr>\n",
" <tr>\n",
" <th>25</th>\n",
" <td>Male</td>\n",
" <td>Chengalpattu</td>\n",
" <td>NaN</td>\n",
" <td>26.10.2020</td>\n",
" <td>08.22 PM</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>31.10.2020</td>\n",
" <td>11177</td>\n",
" <td>67</td>\n",
" <td>12.30 PM</td>\n",
" <td>COVID Pneumonia / Acute Respiratory</td>\n",
" </tr>\n",
" <tr>\n",
" <th>26</th>\n",
" <td>Female</td>\n",
" <td>Chennai</td>\n",
" <td>NaN</td>\n",
" <td>31.10.2020</td>\n",
" <td>09.50 PM</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>01.11.2020</td>\n",
" <td>11179</td>\n",
" <td>88</td>\n",
" <td>10.40 PM</td>\n",
" <td>COVID Pneumonia / Respiratory Failure</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27</th>\n",
" <td>Male</td>\n",
" <td>Chennai</td>\n",
" <td>NaN</td>\n",
" <td>28.10.2020</td>\n",
" <td>10.49 AM</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>01.11.2020</td>\n",
" <td>11180</td>\n",
" <td>78</td>\n",
" <td>11.10 AM</td>\n",
" <td>COVID Pneumonia / Sepsis / Septic Shock / Coro...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>28</th>\n",
" <td>Male</td>\n",
" <td>Chennai</td>\n",
" <td>NaN</td>\n",
" <td>30.10.2020</td>\n",
" <td>11.50 AM</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>01.11.2020</td>\n",
" <td>11181</td>\n",
" <td>63</td>\n",
" <td>03.45 PM</td>\n",
" <td>COVID Pneumonia / Acute Respiratory</td>\n",
" </tr>\n",
" <tr>\n",
" <th>29</th>\n",
" <td>Male</td>\n",
" <td>Coimbatore</td>\n",
" <td>NaN</td>\n",
" <td>28.10.2020</td>\n",
" <td>11.36 AM</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>31.10.2020</td>\n",
" <td>11182</td>\n",
" <td>65</td>\n",
" <td>08.10 AM</td>\n",
" <td>Bilateral Brochopneumonia / Acute Respiratory</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" GENDER ... CAUSEOFDEATH\n",
"0 Female ... NaN\n",
"1 Male ... COVID- 19 Pneumonia\n",
"2 Male ... COVID Pneumonia / Acute Respiratory\n",
"3 Male ... COVID-19 Pneumonia\n",
"4 Male ... ARDS / COVID-19 Pneumonia\n",
"5 Male ... COVID-19 Pneumonia, Lower Limbs\n",
"6 Female ... ARDS / COVID-19 Pneumonia\n",
"7 Male ... COVID- 19 Pneumonia\n",
"8 Male ... COVID-19 Pneumonia\n",
"9 Male ... COVID-19 Pneumonia\n",
"10 Female ... ARDS / COVID-19 Pneumonia\n",
"11 Female ... ARDS /COVID-19 Pneumonia, in Breathing\n",
"12 Male ... COVID-19 Pneumonia, in Breathing\n",
"13 Female ... COVID-19 Pneumonia\n",
"14 Female ... COVID-19 Pneumonia\n",
"15 Female ... COVID-19 Pneumonia\n",
"16 Female ... COVID-19 Pneumonia, in Breathing\n",
"17 Male ... ARDS / MODS / COVID-19 Pneumonia\n",
"18 Female ... ARDS / COVID-19 Pneumonia\n",
"19 Male ... ARDS / COVID-19 Pneumonia\n",
"20 Male ... ARDS / COVID-19 Pneumonia\n",
"21 Male ... COVID-19 Pneumonia\n",
"22 Male ... COVID Pneumonia / Acute Respiratory\n",
"23 Male ... COVID Pneumonia / Cardiogenic Shock / Acute Pu...\n",
"24 Female ... COVID Pneumonia / Aspiration Pneumonitis\n",
"25 Male ... COVID Pneumonia / Acute Respiratory\n",
"26 Female ... COVID Pneumonia / Respiratory Failure\n",
"27 Male ... COVID Pneumonia / Sepsis / Septic Shock / Coro...\n",
"28 Male ... COVID Pneumonia / Acute Respiratory\n",
"29 Male ... Bilateral Brochopneumonia / Acute Respiratory\n",
"\n",
"[30 rows x 13 columns]"
]
},
"metadata": {
"tags": []
},
"execution_count": 12
}
]
},
{
"cell_type": "code",
"metadata": {
"id": "8Xb54hKGqd0M",
"outputId": "2a0cb280-050e-41a8-f050-2d2d156a4a74",
"colab": {
"base_uri": "https://localhost:8080/",
"height": 54
}
},
"source": [
"cases[0]"
],
"execution_count": 13,
"outputs": [
{
"output_type": "execute_result",
"data": {
"application/vnd.google.colaboratory.intrinsic+json": {
"type": "string"
},
"text/plain": [
"'Death Case No.11153 A 54 Years old Female from Erode having COVID-19 RTPCR Positivity on 27.10.2020 admitted on 27.10.2020 at 11.19 PM in a private hospital, Erode with Complaints of Cough for 3 days Difficulty in Breathing for 1 day died on 01.11.2020 at 07.30 AM due to ARDS / COVID-19 Pneumonia.'"
]
},
"metadata": {
"tags": []
},
"execution_count": 13
}
]
}
]
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment