Total of confirmed cases across the world count

[prakmyl]

Total of confirmed cases across the world count shows 9746888 as per 3/30/2020. As per the jhu.edu current count is 809,608 kindly check the data confirm.xlsx

[mehdirezaie]

@CSSEGISandData I also noticed the total number of confirmed cases do not match the jhu.edu .. Also, the dataset for the confirmed cases has an instance of Recovered for the column Province_State:

>>> import pandas as pd
>>> general_path = ("https://raw.githubusercontent.com/CSSEGISandData/COVID-19/"
                "master/csse_covid_19_data/csse_covid_19_time_series/")
​
>>> df_us = pd.read_csv(f'{general_path}time_series_covid19_confirmed_US.csv')
​
>>> df_us['Province_State'].unique()

array(['Alabama', 'Alaska', 'Arizona', 'Arkansas', 'California',
       'Colorado', 'Connecticut', 'Delaware', 'District of Columbia',
       'Florida', 'Georgia', 'Hawaii', 'Idaho', 'Illinois', 'Indiana',
       'Iowa', 'Kansas', 'Kentucky', 'Louisiana', 'Maine', 'Maryland',
       'Massachusetts', 'Michigan', 'Minnesota', 'Mississippi',
       'Missouri', 'Montana', 'Nebraska', 'Nevada', 'New Hampshire',
       'New Jersey', 'New Mexico', 'New York', 'North Carolina',
       'North Dakota', 'Ohio', 'Oklahoma', 'Oregon', 'Pennsylvania',
       'Rhode Island', 'South Carolina', 'South Dakota', 'Tennessee',
       'Texas', 'Utah', 'Vermont', 'Virginia', 'Washington',
       'West Virginia', 'Wisconsin', 'Wyoming', 'Diamond Princess',
       'Grand Princess', 'American Samoa', 'Guam',
       'Northern Mariana Islands', 'Puerto Rico', 'Virgin Islands',
       'Recovered'], dtype=object)

[mehdirezaie]

There is a country called Georgia in Eastern Europe Lol

[prakmyl]

There is a country called Georgia in Eastern Europe Lol

i was wondering why Lat and lon pointing to europe region instead of atlanta . since everything was messed up taught that could be my bad thanks for correcting

[d76d30dbl]

Your last column would be valid if the counts reported under each date were the number occurring on that day, but it is not. It is the cumulative number for that entity on that day. You will not that this number is always going up for each country, even for china, which has greatly reduced its number of new cases.

cheers. David

On Tue, Mar 31, 2020 at 12:47 PM prakmyl notifications@github.com wrote:

Total of confirmed cases across the world count shows 9746888 as per 3/30/2020. As per the js.edu current count is 809,608 check the issue confirm.xlsx https://github.com/CSSEGISandData/COVID-19/files/4410402/confirm.xlsx

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/CSSEGISandData/COVID-19/issues/1819, or unsubscribe https://github.com/notifications/unsubscribe-auth/ALHC2PDJOG4ZKSEWWHDQM7TRKINBTANCNFSM4LXXSLWQ .

[prakmyl]

Your last column would be valid if the counts reported under each date were the number occurring on that day, but it is not. It is the cumulative number for that entity on that day. You will not that this number is always going up for each country, even for china, which has greatly reduced its number of new cases. cheers. David … On Tue, Mar 31, 2020 at 12:47 PM prakmyl @.***> wrote: Total of confirmed cases across the world count shows 9746888 as per 3/30/2020. As per the js.edu current count is 809,608 check the issue confirm.xlsx https://github.com/CSSEGISandData/COVID-19/files/4410402/confirm.xlsx — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub <#1819>, or unsubscribe https://github.com/notifications/unsubscribe-auth/ALHC2PDJOG4ZKSEWWHDQM7TRKINBTANCNFSM4LXXSLWQ .

That makes and thanks for responding

[prakmyl]

Thanks all