Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Total covid19 patients in icu? #174

Closed
cikmarrmachang opened this issue Sep 14, 2021 · 10 comments
Closed

Total covid19 patients in icu? #174

cikmarrmachang opened this issue Sep 14, 2021 · 10 comments

Comments

@cikmarrmachang
Copy link

Which column in icu.csv data represent the number of covid19 patients in icu? beds_icu_covid or icu_x?

@NobodyButMe-Haiya
Copy link

we been asking before because non same with dg or now covidnow portal. we no idea and remove the figure % icu

@cikmarrmachang
Copy link
Author

we been asking before because non same with dg or now covidnow portal. we no idea and remove the figure % icu

what do you mean? where did you get data of daily icu usage for covid19 patients?

@NobodyButMe-Haiya
Copy link

we been asking before because non same with dg or now covidnow portal. we no idea and remove the figure % icu

what do you mean? where did you get data of daily icu usage for covid19 patients?

https://covidnow.moh.gov.my/icu see active icu and compare to here datset.

a normal would be

active icu / bed covid 19 icu * 100 . if we dont get same figure with dg or covidnow, we will not appear the data at https://www.sponline.xyz/kedah.php

data set from icu.csv

@mnyunus
Copy link

mnyunus commented Sep 14, 2021

https://covidnow.moh.gov.my/icu see active icu and compare to here datset.

a normal would be

active icu / bed covid 19 icu * 100 . if we dont get same figure with dg or covidnow, we will not appear the data at https://www.sponline.xyz/kedah.php

data set from icu.csv

The formulae CovidNow uses are:
Active ICU Patients = icu_covid + icu_pui
ICU Utilisation % = (icu_covid+icu_pui+icu_noncovid)/beds_icu_total

I use same formulae for my dashboard:
https://datastudio.google.com/s/n1w4zvwe0hw


@NobodyButMe-Haiya
Copy link

https://covidnow.moh.gov.my/icu see active icu and compare to here datset.
a normal would be
active icu / bed covid 19 icu * 100 . if we dont get same figure with dg or covidnow, we will not appear the data at https://www.sponline.xyz/kedah.php
data set from icu.csv

The formulae CovidNow uses are:
Active ICU Patients = icu_covid + icu_pui
ICU Utilisation % = (icu_covid+icu_pui+icu_noncovid)/beds_icu_total

I use same formulae for my dashboard:
https://datastudio.google.com/s/n1w4zvwe0hw

thanks mate, we will check it out tommorow and compare .

@NobodyButMe-Haiya
Copy link

update. figure dg sedikit tak same.. akan tengok beberapa hari .. jika sama dengan covidnow maka baru kami akan update ke portal kami.

@mnyunus
Copy link

mnyunus commented Sep 15, 2021

update. figure dg sedikit tak same.. akan tengok beberapa hari .. jika sama dengan covidnow maka baru kami akan update ke portal kami.

Don't think DG's figures will be same, since his press release at 6.45pm, while Github data (which CovidNow uses) is updated much later, I think midnight.

@cikmarrmachang
Copy link
Author

update. figure dg sedikit tak same.. akan tengok beberapa hari .. jika sama dengan covidnow maka baru kami akan update ke portal kami.

Don't think DG's figures will be same, since his press release at 6.45pm, while Github data (which CovidNow uses) is updated much later, I think midnight.

thank you very much for the info..really appreciate it

@cikmarrmachang
Copy link
Author

update. figure dg sedikit tak same.. akan tengok beberapa hari .. jika sama dengan covidnow maka baru kami akan update ke portal kami.

thank you very much for the info..really appreciate it

@cikmarrmachang
Copy link
Author

https://covidnow.moh.gov.my/icu see active icu and compare to here datset.
a normal would be
active icu / bed covid 19 icu * 100 . if we dont get same figure with dg or covidnow, we will not appear the data at https://www.sponline.xyz/kedah.php
data set from icu.csv

The formulae CovidNow uses are:
Active ICU Patients = icu_covid + icu_pui
ICU Utilisation % = (icu_covid+icu_pui+icu_noncovid)/beds_icu_total

I use same formulae for my dashboard:
https://datastudio.google.com/s/n1w4zvwe0hw

is there any data in a form of raw data .csv or .xls for this?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

4 participants