search

CSSEGISandData / COVID-19

Novel Coronavirus (COVID-19) Cases, provided by JHU CSSE
https://systems.jhu.edu/research/public-health/ncov/
29.13k stars 18.43k forks source link

Cases Where Count Goes Backwards By 10+ in a Day #2256

Open MelbourneDeveloper opened 4 years ago

MelbourneDeveloper commented 4 years ago

Note: Some Urls may be out of date because some rows are being deleted or moved. Some data will be fixed by the time this is viewed. Please pay attention to the Region/Province/Location and the Date.

This is a comprehensive list of all the rows where a count value has decreased by 10 or more from the previous day. There is a Url for the row, and URL for the previous date so you can clearly see the discrepancy. The discrepancy column is how much the value decreased by from the previous day. Column is either "New Cases", "Deaths" or "Recoveries". This list is sorted by the largest discrepancy to the smallest.

This list was generated with this tool. Please contact me for help with automating data validation @CSSEGISandData

Region Provice Location Column Discrepancy PreviousUrl Date Url
France French Polynesia N/A New Cases -19849 3189 2020/03/24 3187
France N/A N/A New Cases -6526 2881 2020/04/14 2893
France French Polynesia N/A Recoveries -2200 3189 2020/03/24 3187
US New Jersey Unassigned New Cases -1314 2281 2020/04/07 2328
US New York Unassigned Deaths -951 2245 2020/04/06 2283
US Georgia Unassigned New Cases -932 2444 2020/04/14 2454
US New Jersey Unassigned New Cases -873 2115 2020/04/04 2169
France French Polynesia N/A Deaths -860 3189 2020/03/24 3187
US New Jersey Unassigned New Cases -816 2328 2020/04/08 2352
US Rhode Island Unassigned New Cases -795 2481 2020/04/15 2493
US Illinois Unassigned New Cases -660 2863 2020/03/28 2864
US New Jersey Unassigned New Cases -513 2473 2020/04/15 2485
US Tennessee Unassigned New Cases -436 2001 2020/04/02 2077
US New Jersey Unassigned New Cases -395 2352 2020/04/09 2378
US Illinois Unassigned New Cases -357 2102 2020/04/04 2154
US New Jersey Unassigned New Cases -347 2378 2020/04/10 2402
United Kingdom N/A N/A Recoveries -344 2980 2020/04/13 2994
Mainland China Hebei N/A New Cases -318 29 2020/03/11 209
Mainland China Hebei N/A Recoveries -307 29 2020/03/11 209
US New Jersey Unassigned New Cases -300 2243 2020/04/06 2281
US Michigan Unassigned New Cases -284 2370 2020/04/10 2394
US Kentucky Unassigned New Cases -273 2415 2020/04/12 2437
US Georgia Unassigned New Cases -271 2053 2020/04/03 2100
Canada Recovered N/A Recoveries -268 2236 2020/04/01 2285
US Georgia Unassigned New Cases -262 2100 2020/04/04 2152
US New Jersey Unassigned Deaths -247 1951 2020/04/01 1997
US New York Unassigned Deaths -193 2283 2020/04/07 2330
US Georgia Unassigned New Cases -179 2408 2020/04/12 2430
US Massachusetts Unassigned Deaths -166 2393 2020/04/11 2418
US California Unassigned New Cases -163 2327 2020/04/09 2353
US New Jersey Unassigned New Cases -161 2878 2020/03/31 1951
US Massachusetts Unassigned New Cases -156 2871 2020/03/31 1944
US Rhode Island Unassigned New Cases -143 2387 2020/04/10 2411
US Tennessee Davidson New Cases -142 626 2020/04/13 630
US New Jersey Unassigned New Cases -141 2485 2020/04/16 2499
US Nevada Unassigned New Cases -137 2874 2020/03/30 2876
US Washington Unassigned New Cases -135 2476 2020/04/14 2487
US Nevada Unassigned New Cases -132 2068 2020/04/03 2113
Mainland China Gansu N/A New Cases -125 46 2020/03/11 208
US Georgia Unassigned New Cases -119 2466 2020/04/16 2480
US Arkansas Unassigned New Cases -118 875 2020/03/23 2858
US Arizona Navajo New Cases -118 1674 2020/04/09 1693
US Washington Unassigned New Cases -116 2439 2020/04/12 2462
US New Jersey Unassigned New Cases -114 2169 2020/04/05 2243
US New Hampshire Hillsborough New Cases -114 1080 2020/04/14 1083
US Washington Unassigned New Cases -113 2462 2020/04/13 2476
US Washington Unassigned New Cases -111 2499 2020/04/16 2513
US New York Unassigned New Cases -107 2874 2020/03/24 2873
US Washington Unassigned New Cases -101 2487 2020/04/15 2499
US Tennessee Davidson New Cases -100 545 2020/04/03 553
US Connecticut Unassigned New Cases -99 2862 2020/03/31 1934
US Georgia Unassigned New Cases -98 2863 2020/03/30 2864
US Colorado Unassigned New Cases -90 2378 2020/04/11 2404
US Mississippi Unassigned New Cases -89 2874 2020/04/08 2346
US Kentucky Unassigned New Cases -89 2451 2020/04/14 2461
Mainland China Gansu N/A Recoveries -88 46 2020/03/11 208
US Massachusetts Unassigned Deaths -86 2464 2020/04/15 2476
US Kentucky Unassigned New Cases -84 2104 2020/04/04 2157
US Massachusetts Unassigned New Cases -82 1944 2020/04/01 1990
US Kentucky Unassigned New Cases -81 2865 2020/03/29 2866
US Rhode Island Unassigned New Cases -80 2000 2020/04/02 2075
US Rhode Island Unassigned New Cases -79 2337 2020/04/08 2360
US New York Unassigned Deaths -79 2354 2020/04/09 2380
US Arizona Coconino New Cases -78 493 2020/04/09 496
US Washington Unassigned New Cases -77 2366 2020/04/09 2393
US Kentucky Unassigned New Cases -76 2339 2020/04/09 2365
US Nevada Unassigned New Cases -74 2871 2020/03/24 2871
US Massachusetts Unassigned New Cases -74 2369 2020/04/10 2393
US New York Unassigned Deaths -73 2380 2020/04/10 2404
US Nevada Unassigned New Cases -73 2425 2020/04/12 2447
US New Jersey Unassigned New Cases -71 2449 2020/04/13 2463
US Indiana Dearborn New Cases -69 651 2020/04/14 652
US Washington Unassigned New Cases -67 2880 2020/03/28 2877
US Illinois Unassigned New Cases -63 2862 2020/03/24 2864
US Washington N/A New Cases -62 20 2020/03/18 22
US Washington Unassigned New Cases -61 2877 2020/03/25 2877
US Wisconsin Unassigned New Cases -61 2881 2020/03/28 2878
US Washington Unassigned New Cases -60 2417 2020/04/11 2439
US Massachusetts Unassigned New Cases -59 2161 2020/04/05 2235
US New Jersey Unassigned New Cases -58 2070 2020/04/03 2115
US Colorado Unassigned New Cases -57 2861 2020/03/31 1933
US Massachusetts Unassigned New Cases -57 2062 2020/04/03 2108
US New Mexico San Juan New Cases -57 2047 2020/04/09 2070
US New Hampshire Unassigned New Cases -56 2877 2020/03/31 1950
US Tennessee Out of TN New Cases -56 1582 2020/04/03 1616
US Indiana DeKalb New Cases -54 644 2020/04/14 646
US Rhode Island Unassigned New Cases -50 2874 2020/03/29 2877
US Connecticut Unassigned Deaths -50 2329 2020/04/09 2355
US Nevada Unassigned New Cases -50 2400 2020/04/11 2425
US Vermont Unassigned New Cases -48 2415 2020/04/11 2437
US Louisiana Lafayette New Cases -47 1134 2020/04/04 1161
US Florida Unassigned Deaths -47 2453 2020/04/15 2465
US Michigan Unassigned New Cases -45 2321 2020/04/08 2344
Algeria N/A N/A Recoveries -41 3255 2020/03/24 3255
US Georgia Unassigned Deaths -40 2863 2020/03/28 2862
US New York Unassigned Deaths -40 2451 2020/04/13 2465
US Louisiana Unassigned New Cases -39 251 2020/03/23 2865
US Kentucky Unassigned New Cases -39 2867 2020/03/31 1941
Algeria N/A N/A Recoveries -36 3255 2020/03/26 3254
US Indiana Unassigned New Cases -36 2863 2020/04/06 2266
US Illinois Unassigned New Cases -36 2433 2020/04/13 2447
US Pennsylvania Lancaster Deaths -36 1349 2020/04/16 1354
US Washington Unassigned New Cases -33 2878 2020/03/24 2877
US Nevada Unassigned New Cases -33 2326 2020/04/08 2350
US Colorado Unassigned Deaths -33 2378 2020/04/11 2404
US Minnesota Unassigned New Cases -33 2466 2020/04/15 2478
US Washington Franklin New Cases -33 851 2020/04/16 852
US New Hampshire Unassigned New Cases -32 2401 2020/04/11 2426
US Arkansas Unassigned New Cases -31 2326 2020/04/09 2352
Ghana N/A N/A Recoveries -31 2768 2020/04/09 2796
Germany N/A N/A Deaths -31 2824 2020/04/11 2848
US Vermont Rutland New Cases -31 2122 2020/04/14 2130
Belgium N/A N/A Recoveries -30 14 2020/03/20 14
US New Jersey Unassigned Deaths -30 2872 2020/03/29 2875
US Nevada Unassigned New Cases -30 2876 2020/03/31 1949
Latvia N/A N/A Recoveries -30 2485 2020/04/03 2541
US North Carolina Alamance New Cases -30 23 2020/04/15 23
US Florida Unassigned Deaths -29 2308 2020/04/08 2331
US Virginia Unassigned Deaths -29 2438 2020/04/12 2461
US Colorado Unassigned Deaths -28 2305 2020/04/08 2328
US Tennessee Unassigned New Cases -28 2339 2020/04/08 2362
US Florida Alachua New Cases -28 22 2020/04/13 22
US Kentucky Unassigned Deaths -28 2451 2020/04/14 2461
US Arizona Apache New Cases -26 63 2020/04/09 63
US Colorado Unassigned New Cases -26 2440 2020/04/14 2450
occupied Palestinian territory N/A N/A New Cases -25 81 2020/03/11 217
US Vermont Unassigned New Cases -25 2364 2020/04/09 2391
US Kentucky Unassigned New Cases -24 952 2020/03/23 2864
US Rhode Island Unassigned New Cases -24 1953 2020/04/01 2000
US Colorado Unassigned New Cases -24 2258 2020/04/07 2305
US Georgia Unassigned New Cases -24 2454 2020/04/15 2466
US Vermont Unassigned New Cases -24 2485 2020/04/15 2497
US Virginia Unassigned Deaths -24 2498 2020/04/16 2512
US Louisiana St. Landry New Cases -23 1955 2020/04/04 2002
US Arkansas Unassigned New Cases -23 2256 2020/04/07 2303
US Nevada Unassigned New Cases -23 2447 2020/04/13 2461
US West Virginia Unassigned New Cases -21 2367 2020/04/09 2394
Japan N/A N/A New Cases -20 29 2020/02/07 34
US Indiana Unassigned New Cases -20 2266 2020/04/07 2313
US Massachusetts Unassigned New Cases -20 2343 2020/04/09 2369
US Washington Unassigned New Cases -19 49 2020/03/23 2878
US New Hampshire Unassigned New Cases -19 2872 2020/03/27 2874
US New Jersey Bergen Deaths -19 192 2020/03/31 133
US Connecticut Unassigned New Cases -19 2149 2020/04/05 2222
US Kentucky Jefferson New Cases -19 1196 2020/04/14 1200
US Rhode Island Bristol New Cases -18 274 2020/03/26 274
US Washington Unassigned New Cases -18 2126 2020/04/04 2180
US Vermont Unassigned New Cases -18 2292 2020/04/07 2341
US Vermont Unassigned Deaths -18 2364 2020/04/09 2391
US Ohio Unassigned Deaths -18 2407 2020/04/11 2431
South Korea N/A N/A Recoveries -17 3 2020/03/08 4
Iceland N/A N/A Recoveries -17 57 2020/03/22 3266
US Vermont Unassigned New Cases -17 2884 2020/03/31 1955
US Tennessee Unassigned New Cases -17 2252 2020/04/06 2290
US Massachusetts Unassigned New Cases -17 2273 2020/04/07 2320
US New Mexico McKinley New Cases -17 1527 2020/04/09 1545
US Tennessee Out of TN New Cases -17 1885 2020/04/16 1894
US Tennessee Unassigned New Cases -16 2876 2020/03/24 2875
US Kentucky Unassigned New Cases -16 2866 2020/03/30 2867
US Tennessee Unassigned New Cases -16 2389 2020/04/10 2413
US Delaware Unassigned Deaths -16 2380 2020/04/11 2406
US Nevada Unassigned Deaths -16 2425 2020/04/12 2447
US Tennessee Out of TN New Cases -16 1854 2020/04/13 1868
Guyana N/A N/A New Cases -15 3316 2020/03/24 3317
Serbia N/A N/A Recoveries -15 3390 2020/03/26 3390
US Arkansas Unassigned New Cases -15 2859 2020/03/31 1931
US Arizona Unassigned Deaths -15 1976 2020/04/02 2046
US Michigan Unassigned New Cases -15 2465 2020/04/15 2477
Japan N/A N/A New Cases -14 23 2020/03/16 25
US Colorado Unassigned New Cases -14 2305 2020/04/08 2328
Uruguay N/A N/A New Cases -14 2958 2020/04/12 2981
US California Sutter New Cases -14 2346 2020/04/14 2355
US Hawaii Unassigned New Cases -13 2863 2020/03/26 2862
US Washington Benton New Cases -13 190 2020/03/31 132
US Florida Unassigned Deaths -13 2052 2020/04/03 2099
US Delaware Unassigned New Cases -13 2406 2020/04/12 2428
Poland N/A N/A Recoveries -12 57 2020/03/19 49
Poland N/A N/A Recoveries -12 3372 2020/03/24 3375
US California Unassigned New Cases -12 2860 2020/03/29 2860
US New Jersey Middlesex Deaths -12 1918 2020/03/31 1295
US Maryland Unassigned Deaths -12 1989 2020/04/02 2061
US Indiana Unassigned Deaths -12 2266 2020/04/07 2313
US Nevada Unassigned Deaths -12 2326 2020/04/08 2350
US Arkansas Unassigned Deaths -12 2326 2020/04/09 2352
US Nebraska Omaha New Cases -11 46 2020/02/24 90
Egypt N/A N/A Recoveries -11 57 2020/03/10 60
Lebanon N/A N/A New Cases -11 73 2020/03/16 84
US Nevada Unassigned New Cases -11 2870 2020/03/26 2868
US Tennessee Unassigned New Cases -11 2878 2020/03/28 2875
US Connecticut Unassigned New Cases -11 1980 2020/04/02 2050
US Tennessee Unassigned Deaths -11 2001 2020/04/02 2077
US Kentucky Unassigned Deaths -11 2058 2020/04/03 2104
US Colorado Unassigned New Cases -11 2426 2020/04/13 2440
US Illinois Unassigned New Cases -11 2447 2020/04/14 2457
Others Diamond Princess cruise ship N/A New Cases -10 13 2020/03/06 13
US Washington Kittitas New Cases -10 1523 2020/03/26 1522
US Louisiana Iberia New Cases -10 974 2020/04/04 996
US Arizona Unassigned Deaths -10 2093 2020/04/04 2146
US Kentucky Muhlenberg New Cases -10 1492 2020/04/05 1581
US Tennessee Unassigned New Cases -10 2290 2020/04/07 2339
US Connecticut Unassigned New Cases -10 2427 2020/04/13 2441
Aureuum commented 4 years ago

@MelbourneDeveloper Thanks for providing this list! Yes, there are some strange discrepancies. However, all the states 'Unassigned' decreases are easily explained by those cases being assigned to their proper counties.

MelbourneDeveloper commented 4 years ago

@Aureuum thanks for letting me know. Is there an issue I can look at to see what that means? I can fix this issue in my database tool so that the database has the correct values.

MelbourneDeveloper commented 4 years ago

@Aureuum can "Unassigned" locations simply be ignored?

MelbourneDeveloper commented 4 years ago

Or is there a plan to revise the old data to fix the issues?

Aureuum commented 4 years ago

@MelbourneDeveloper About the 'Unassigned' cases I just include them in my presentation as they are, being both positive and negative daily changes over time. And they are usually much fewer than the assigned cases so they have less general significance. For the location of the 'Unassigned' cases, I use the same as for the state itself. I'm not aware of any plan to fix the issues.

MelbourneDeveloper commented 4 years ago

@Aureuum

Should unassigned counts be included with other locations for a given Province / Region? Or, do the counts overlap? This is important because if they are included in a Sum of all the values for a Province / Region, there will be inaccuracies.

Is there an issue somewhere that explains what the meaning of unassigned is?

Aureuum commented 4 years ago

@MelbourneDeveloper This is how I interpret it: County A: 100 assigned cases County B: 200 assigned cases State unassigned cases: 50 State total cases: 100+200+50=350 cases Does that make sense? I haven't seen or looked for any definition, just assumed that it works that way.

MelbourneDeveloper commented 4 years ago

@Aureuum that's how I originally interpreted it. How can we confirm that this is the case?

Does that mean that in cases where the unassigned drops, those cases are moved to the actual location? If that's the case, it's very hard to calculate accurate data over time for locations.

Aureuum commented 4 years ago

@MelbourneDeveloper To confirm that's true one would need to ask the data provider or find info about it from them. And yes, if 10 cases are moved from 'Unassigned' to its proper location, the 'Unassigned' will drop by that amount and the location increases by the same. So one would need to accept that as a factor for a location's statistics. However, in most practical cases I think it's a minor factor compared to the amount of new cases that are properly assigned every day. At the same time it's a valid factor that a location's amount of cases changes due to reallocation.