Skip to content
This repository has been archived by the owner on Mar 10, 2023. It is now read-only.

Timeseries_Deaths_Global mit decimal numbers #3279

Closed
mbender-ith opened this issue Oct 29, 2020 · 7 comments
Closed

Timeseries_Deaths_Global mit decimal numbers #3279

mbender-ith opened this issue Oct 29, 2020 · 7 comments

Comments

@mbender-ith
Copy link

FIle Timeseries_Deaths_global shows decimal numbers (12345.0) in column for Oct 28, 2020. Before, numbers where always formated without decimal point.

@Bost
Copy link

Bost commented Oct 29, 2020

This change breaks among others the https://covid-tracker-us.herokuapp.com/all

@sapienzafra
Copy link

sapienzafra commented Oct 29, 2020

I changed my script to use the integer part of those numbers. As a result I get -23.494 deaths than yesterday. Maybe is missing last value in Colombia's row

Kilo59 pushed a commit to ExpDev07/coronavirus-tracker-api that referenced this issue Oct 29, 2020
Co-authored-by: Rostislav Svoboda <Rostislav.Svoboda@gmail.com>
@Bost
Copy link

Bost commented Oct 29, 2020

@sapienzafra The number of deaths in Colombia is definitely wrong. For the other countries this number seems to be correct. (Please correct me if I'm wrong)

@sapienzafra
Copy link

sapienzafra commented Oct 29, 2020

@Bost yes other countries look correct. I manually added in my local csv file Colombia's last value, taken from the JHU dashboard (30753) and now everything works.

@CSSEGISandData
Copy link
Owner

Hello all,

Really not sure why this happened - we will be looking into it today. I've pushed an update that removes the decimal characters and includes the correct death total for Colombia (30753).

@Bost
Copy link

Bost commented Oct 29, 2020

Really not sure why this happened - we will be looking into it today. I've pushed an update that removes the decimal characters

I think I know what's happening. Somebody at the key position or positions still speaks and things in terms of "removing decimal characters" instead of "using appropriate data type" to represent real world information. In this case using integer numerical data type to convey the information about the number of people who die, get sick, recover etc.

Instead of "Bang - Excel - Whatever"

This little "removing decimal characters" remark of yours induces one question: How much the data management improved since its worst period from the times at around #413 ? The answer is: not enough.

@mbender-ith
Copy link
Author

Issue has reappeared today

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

No branches or pull requests

4 participants