Scribd
Upload
26 views26 pages

Draft

The document contains data on COVID-19 cases and patient information. It includes tables with numbers of vaccinated and unvaccinated cases, a list of patients with details, and billing information. The average hospital stay was 11 days and the maximum final copay was $156,700.

Uploaded by

rheanna0076
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
26 views26 pages

Draft

The document contains data on COVID-19 cases and patient information. It includes tables with numbers of vaccinated and unvaccinated cases, a list of patients with details, and billing information. The average hospital stay was 11 days and the maximum final copay was $156,700.

Uploaded by

rheanna0076
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 26

Count of FName VStatus

Dstatus unvaccinated vaccinated Total Result


Deceased 11 3 14
Fully Recovered 11 5 16
Out-Patient 10 5 15
Total Result 32 13 45
PID FName LName VStatus Hospital
987426109 Gerald Gilbert vaccinated VJH
134562972 Felicia Field unvaccinated CRH
245826192 Hubert Walker unvaccinated UWHI
456738927 Artemis Hendrix unvaccinated UWHI
309762592 Korea Solace unvaccinated UWHI
409172682 Aphrodite Grey unvaccinated VJH
272938170 Moya Roberts vaccinated CRH
573892929 Apollo Zimmerman vaccinated UWHI
729037292 Olivia Remington unvaccinated UWHI
624159715 Percy Pierce unvaccinated VJH
228299272 Tim Carrylong unvaccinated VJH
873180272 Jonathan Sean unvaccinated UWHI
628293982 Perseus Green unvaccinated CRH
763293729 Brad Finnick unvaccinated CRH
345678291 Ares White vaccinated UWHI
263729736 Atheana Clarke unvaccinated UWHI
345127981 Richard Levine unvaccinated UWHI
251835193 Sean Matrix vaccinated CRH
976278292 Rosie Miller unvaccinated VJH
324163072 Holland Cromwell unvaccinated VJH
839238290 Jay Smith unvaccinated CRH
328191637 Joseph Monroe vaccinated CRH
273827437 Corey Davis unvaccinated UWHI
543678921 Daedalus Dawson unvaccinated CRH
152729177 Frederick Winston unvaccinated UWHI
453782926 Titan Carter vaccinated CRH
567234519 Icarus Wilson unvaccinated UWHI
783027463 Cyprus Baston unvaccinated VJH
739282827 Chad Singh unvaccinated UWHI
726392770 Nyx Moses vaccinated VJH
198752137 Ratilia Boswell vaccinated VJH
537292618 Circe Gray unvaccinated VJH
345272239 Pandora Black unvaccinated CRH
654729127 Annabeth Wittick unvaccinated VJI
735836272 Summer Walker unvaccinated VJH
912736628 Lily Jones vaccinated VJH
283732927 Dove Cameron vaccinated VJH
982736364 Ariana Becker unvaccinated UWHI
678921657 Iris Amos unvaccinated CRH
202987762 Yolanda Shirbert unvaccinated CRH
267108223 Ajare Cumberland unvaccinated VJH
426790986 Hera Adams unvaccinated CRH
298392027 Susanna Shields vaccinated CRH
509383672 Athena Lenon unvaccinated CRH
764926271 Ajare Crawford vaccinated UWHI

Averge number of days 11


Maximum Final Copay $ 156,700.00
Patient Billing Information
IName Coverage Dstatus Covid Result NDays
Mediplus Health Insurance Jamaica 80% Deceased Positive 4
Mediplus Health Insurance Jamaica 80% Deceased Positive 22
ParishFarm Insurance For Health 50% Deceased Positive 23
ParishFarm Insurance For Health 50% Deceased Positive 16
NationWidth Health Limited 75% Deceased Positive 8
Government Care Ministry of Health 90% Deceased Positive 3
Sagicor Health Jamaica Limited 47% Deceased Positive 5
Sagicor Health Jamaica Limited 47% Deceased Positive 5
NationWidth Health Limited 75% Deceased Negative 1
NationWidth Health Limited 75% Deceased Inconclusive 18
Government Care Ministry of Health 90% Deceased Inconclusive 11
NationWidth Health Limited 75% Deceased Inconclusive 9
Government Care Ministry of Health 90% Deceased Inconclusive 6
Sagicor Health Jamaica Limited 47% Deceased Positive 8
Sagicor Health Jamaica Limited 47% Fully Recovered Positive 7
Mediplus Health Insurance Jamaica 80% Fully Recovered Positive 6
Mediplus Health Insurance Jamaica 80% Fully Recovered Positive 4
ParishFarm Insurance For Health 50% Fully Recovered Positive 17
ParishFarm Insurance For Health 50% Fully Recovered Positive 7
Government Care Ministry of Health 90% Fully Recovered Positive 9
ParishFarm Insurance For Health 50% Fully Recovered Positive 8
ParishFarm Insurance For Health 50% Fully Recovered Positive 19
Sagicor Health Jamaica Limited 47% Fully Recovered Positive 14
ParishFarm Insurance For Health 50% Fully Recovered Positive 12
ParishFarm Insurance For Health 50% Fully Recovered Negative 10
ParishFarm Insurance For Health 50% Fully Recovered Negative 2
Mediplus Health Insurance Jamaica 80% Fully Recovered Inconclusive 2
Government Care Ministry of Health 90% Fully Recovered Inconclusive 23
Sagicor Health Jamaica Limited 47% Fully Recovered Inconclusive 15
Government Care Ministry of Health 90% Fully Recovered Inconclusive 10
Sagicor Health Jamaica Limited 47% Out-Patient Positive 30
Mediplus Health Insurance Jamaica 80% Out-Patient Positive 9
Sagicor Health Jamaica Limited 47% Out-Patient Positive 20
ParishFarm Insurance For Health 50% Out-Patient Positive 11
ParishFarm Insurance For Health 50% Out-Patient Positive 14
Government Care Ministry of Health 90% Out-Patient Positive 29
Government Care Ministry of Health 90% Out-Patient Positive 23
Sagicor Health Jamaica Limited 47% Out-Patient Positive 6
Mediplus Health Insurance Jamaica 80% Out-Patient Negative 3
NationWidth Health Limited 75% Out-Patient Negative 4
ParishFarm Insurance For Health 50% Out-Patient Negative 3
NationWidth Health Limited 75% Out-Patient Negative 1
NationWidth Health Limited 75% Out-Patient Negative 1
NationWidth Health Limited 75% Out-Patient Inconclusive 17
NationWidth Health Limited 75% Out-Patient Inconclusive 15
rmation
CRFees Room and Board Medical Supply Outpatient Care
$ 13,000.00 $ 20,000.00 $ 40,000.00 $ 13,000.00
$ 45,000.00 $ 110,000.00 $ 220,000.00 $ 45,000.00
$ 35,000.00 $ 115,000.00 $ 230,000.00 $ 35,000.00
$ 28,000.00 $ 80,000.00 $ 160,000.00 $ 28,000.00
$ 16,000.00 $ 40,000.00 $ 80,000.00 $ 16,000.00
$ 13,000.00 $ 15,000.00 $ 30,000.00 $ 13,000.00
$ 15,000.00 $ 25,000.00 $ 50,000.00 $ 15,000.00
$ 15,000.00 $ 25,000.00 $ 50,000.00 $ 15,000.00
$ 10,000.00 $ 5,000.00 $ 10,000.00 $ 10,000.00
$ 28,000.00 $ 90,000.00 $ 180,000.00 $ 28,000.00
$ 25,000.00 $ 55,000.00 $ 110,000.00 $ 25,000.00
$ 23,000.00 $ 45,000.00 $ 90,000.00 $ 23,000.00
$ 16,000.00 $ 30,000.00 $ 60,000.00 $ 16,000.00
$ 18,000.00 $ 40,000.00 $ 80,000.00 $ 18,000.00
$ 15,000.00 $ 35,000.00 $ 70,000.00 $ 15,000.00
$ 13,000.00 $ 30,000.00 $ 60,000.00 $ 13,000.00
$ 14,000.00 $ 20,000.00 $ 40,000.00 $ 14,000.00
$ 19,000.00 $ 85,000.00 $ 170,000.00 $ 19,000.00
$ 15,000.00 $ 35,000.00 $ 70,000.00 $ 15,000.00
$ 17,000.00 $ 45,000.00 $ 90,000.00 $ 17,000.00
$ 19,000.00 $ 40,000.00 $ 80,000.00 $ 19,000.00
$ 29,000.00 $ 95,000.00 $ 190,000.00 $ 29,000.00
$ 26,000.00 $ 70,000.00 $ 140,000.00 $ 26,000.00
$ 22,000.00 $ 60,000.00 $ 120,000.00 $ 22,000.00
$ 25,000.00 $ 50,000.00 $ 100,000.00 $ 25,000.00
$ 12,000.00 $ 10,000.00 $ 20,000.00 $ 12,000.00
$ 12,000.00 $ 10,000.00 $ 20,000.00 $ 12,000.00
$ 33,000.00 $ 115,000.00 $ 230,000.00 $ 33,000.00
$ 25,000.00 $ 75,000.00 $ 150,000.00 $ 25,000.00
$ 20,000.00 $ 50,000.00 $ 100,000.00 $ 20,000.00
$ 48,000.00 $ 150,000.00 $ 300,000.00 $ 51,500.00
$ 19,000.00 $ 45,000.00 $ 90,000.00 $ 22,500.00
$ 30,000.00 $ 100,000.00 $ 200,000.00 $ 33,500.00
$ 21,000.00 $ 55,000.00 $ 110,000.00 $ 24,500.00
$ 24,000.00 $ 70,000.00 $ 140,000.00 $ 27,500.00
$ 50,000.00 $ 145,000.00 $ 290,000.00 $ 53,500.00
$ 35,000.00 $ 115,000.00 $ 230,000.00 $ 38,500.00
$ 18,000.00 $ 30,000.00 $ 60,000.00 $ 21,500.00
$ 13,000.00 $ 15,000.00 $ 30,000.00 $ 16,500.00
$ 12,000.00 $ 20,000.00 $ 40,000.00 $ 15,500.00
$ 11,000.00 $ 15,000.00 $ 30,000.00 $ 14,500.00
$ 10,000.00 $ 5,000.00 $ 10,000.00 $ 13,500.00
$ 10,000.00 $ 5,000.00 $ 10,000.00 $ 13,500.00
$ 27,000.00 $ 85,000.00 $ 170,000.00 $ 30,500.00
$ 25,000.00 $ 75,000.00 $ 150,000.00 $ 28,500.00
PID FName LName
Total Hospital Cost Final Copay
$ 106,000.00 $ 31,600.00
$ 440,000.00 $ 124,000.00
$ 435,000.00 $ 104,500.00
$ 316,000.00 $ 77,200.00
$ 172,000.00 $ 46,400.00
$ 91,000.00 $ 29,900.00
$ 125,000.00 $ 32,050.00
$ 125,000.00 $ 32,050.00
$ 55,000.00 $ 18,500.00
$ 346,000.00 $ 90,200.00
$ 235,000.00 $ 69,500.00
$ 201,000.00 $ 57,450.00
$ 142,000.00 $ 42,800.00
$ 176,000.00 $ 43,660.00
$ 155,000.00 $ 38,050.00
$ 136,000.00 $ 37,600.00
$ 108,000.00 $ 32,800.00
$ 313,000.00 $ 72,100.00
$ 155,000.00 $ 38,500.00
$ 189,000.00 $ 53,100.00
$ 178,000.00 $ 45,100.00
$ 363,000.00 $ 87,100.00
$ 282,000.00 $ 68,620.00
$ 244,000.00 $ 59,800.00
$ 220,000.00 $ 56,500.00
$ 74,000.00 $ 20,800.00
$ 74,000.00 $ 24,400.00
$ 431,000.00 $ 115,900.00
$ 295,000.00 $ 70,750.00
$ 210,000.00 $ 60,000.00
$ 569,500.00 $ 136,460.00
$ 196,500.00 $ 54,500.00
$ 383,500.00 $ 90,800.00
$ 230,500.00 $ 56,600.00
$ 281,500.00 $ 68,300.00
$ 558,500.00 $ 156,700.00
$ 438,500.00 $ 119,200.00
$ 149,500.00 $ 38,360.00
$ 94,500.00 $ 29,300.00
$ 107,500.00 $ 30,500.00
$ 90,500.00 $ 23,600.00
$ 58,500.00 $ 19,200.00
$ 58,500.00 $ 19,200.00
$ 332,500.00 $ 86,750.00
$ 298,500.00 $ 78,450.00
VStatus Hospital IName Coverage DStatus Covid Result NDays CRFees
vaccinated
Room and Board Medical Supply Outpatient Care
Total Hospital Cost Final Copay
Medical Fees
Medical Description Medical cost
Daily Room and Board fees $5,000.00
Doctors Visit Fees $20,000.00
Daily Medical Supply $10,000.00
Outpatient Care $3,500.00
Mortuary Fee $15,000.00
Regular Medical Coverage 80%
Covid Result Number
Positive Results 27
Negative Results 8
Inconclusive Results 10

PIE CHART SHOWING THE NUMBER OF VAR-


IOUS COVID RESULTS
Inconclusive
Results
22%
Positive Results
Negative Result
Inconclusive Res

Negative Positive
Results Results
18% 60%
E NUMBER OF VAR-
RESULTS

Positive Results
Negative Results
Inconclusive Results

Positive
Results
60%
PID FName LName VStatus Hospital
987426109 Gerald Gilbert vaccinated VJH
272938170 Moya Roberts vaccinated CRH
573892929 Apollo Zimmerman vaccinated UWHI
345678291 Ares White vaccinated UWHI
251835193 Sean Matrix vaccinated CRH
328191637 Joseph Monroe vaccinated CRH
726392770 Nyx Moses vaccinated VJH
198752137 Ratilia Boswell vaccinated VJH
764926271 Ajare Crawford vaccinated UWHI
912736628 Lily Jones vaccinated VJH
283732927 Dove Cameron vaccinated VJH
453782926 Titan Carter vaccinated CRH
298392027 Susanna Shields vaccinated CRH
Vaccinated Patients
IName Coverage DStatus Covid Result NDays
Mediplus Health Insurance Jamaica 80% Deceased Positive 4
Sagicor Health Jamaica Limited 47% Deceased Positive 5
Sagicor Health Jamaica Limited 47% Deceased Positive 5
Sagicor Health Jamaica Limited 47% Fully Recovered Positive 7
ParishFarm Insurance For Health 50% Fully Recovered Positive 17
ParishFarm Insurance For Health 50% Fully Recovered Positive 19
Government Care Ministry of Health 90% Fully Recovered Inconclusive 10
Sagicor Health Jamaica Limited 47% Out-Patient Positive 30
NationWidth Health Limited 75% Out-Patient Inconclusive 15
Government Care Ministry of Health 90% Out-Patient Positive 29
Government Care Ministry of Health 90% Out-Patient Positive 23
ParishFarm Insurance For Health 50% Fully Recovered Negative 2
NationWidth Health Limited 75% Out-Patient Negative 1
ents
CRFees Room and Board Medical Supply Outpatient Care
$ 13,000.00 $ 20,000.00 $ 40,000.00 $ 13,000.00
$ 15,000.00 $ 25,000.00 $ 50,000.00 $ 15,000.00
$ 15,000.00 $ 25,000.00 $ 50,000.00 $ 15,000.00
$ 15,000.00 $ 35,000.00 $ 70,000.00 $ 15,000.00
$ 19,000.00 $ 85,000.00 $ 170,000.00 $ 19,000.00
$ 29,000.00 $ 95,000.00 $ 190,000.00 $ 29,000.00
$ 20,000.00 $ 50,000.00 $ 100,000.00 $ 20,000.00
$ 48,000.00 $ 150,000.00 $ 300,000.00 $ 51,500.00
$ 25,000.00 $ 75,000.00 $ 150,000.00 $ 25,000.00
$ 50,000.00 $ 145,000.00 $ 290,000.00 $ 50,000.00
$ 35,000.00 $ 115,000.00 $ 230,000.00 $ 35,000.00
$ 12,000.00 $ 10,000.00 $ 20,000.00 $ 12,000.00
$ 10,000.00 $ 5,000.00 $ 10,000.00 $ 10,000.00
Total Hospital Cost Final Copay
$ 106,000.00 $ 31,600.00
$ 125,000.00 $ 32,050.00
$ 125,000.00 $ 32,050.00
$ 155,000.00 $ 38,050.00
$ 313,000.00 $ 72,100.00
$ 363,000.00 $ 87,100.00
$ 210,000.00 $ 60,000.00
$ 569,500.00 $ 136,460.00
$ 295,000.00 $ 77,750.00
$ 555,000.00 $ 156,000.00
$ 435,000.00 $ 118,500.00
$ 74,000.00 $ 20,800.00
$ 55,000.00 $ 18,500.00
PID FName LName VStatus Hospital IName Coverage DStatus
763293729 Brad Finnick unvaccinated CRH Sagicor He 0.47 Deceased
Covid Result NDays CRFees Room and Board Medical Supply Outpatient Care
Positive 8 18000 40000 80000 18000
Total Hospital Cost Final Copay
176000 43660
PID FName LName VStatus Hospital IName Coverage DStatus Covid Result
729037292 Olivia Remingtonunvaccinat UWHI NationWidt 0.75 Deceased Negative
624159715 Percy Pierce unvaccinat VJH NationWidt 0.75 Deceased Inconclusive
134562972 Felicia Field unvaccinat CRH Mediplus H 0.8 Deceased Positive
245826192 Hubert Walker unvaccinat UWHI ParishFarm 0.5 Deceased Positive
456738927 Artemis Hendrix unvaccinat UWHI ParishFarm 0.5 Deceased Positive
228299272 Tim Carrylong unvaccinat VJH Government 0.9 Deceased Inconclusive
309762592 Korea Solace unvaccinat UWHI NationWidt 0.75 Deceased Positive
409172682 Aphrodite Grey unvaccinat VJH Government 0.9 Deceased Positive
628293982 Perseus Green unvaccinat CRH Government 0.9 Deceased Inconclusive
873180272 Jonathan Sean unvaccinat UWHI NationWidt 0.75 Deceased Inconclusive
NDays CRFees Room and Board Medical Supply Outpatient Care Total Hospital Cost
1 10000 5000 10000 10000 55000
18 28000 90000 180000 28000 346000
22 45000 110000 220000 45000 440000
23 35000 115000 230000 35000 435000
16 28000 80000 160000 28000 316000
11 25000 55000 110000 25000 235000
8 16000 40000 80000 16000 172000
3 13000 15000 30000 13000 91000
6 16000 30000 60000 16000 142000
9 23000 45000 90000 23000 201000
Final Copay
18500
90200
124000
104500
77200
69500
46400
29900
42800
57450
Count of Column Labels
Row LabelsunvaccinatvaccinatedGrand Total
Deceased 11 3 14
Fully Reco 11 5 16
Out-Patien 10 5 15
Grand Tota 32 13 45

You might also like