Covid19 US State sorted doubling numbers (updated daily)

This is a sorted US state list of doubling numbers for positive confirmed cases of COVID19 averaged over the last four days. Just computing, log(2)/(log(X_n)-log(X_n-1)) which is the doubling number.
The doubling number is the number of days predicted for the positive confirmed cases to double in number. So, for example Rhode Island reported 566 cases and 10 deaths on 2020-04-01. Then, five days later 2020-04-06,it reported roughly double the number of cases 1082 and 27 deaths. So, in the case the doubling number would be 5.

The following link is to the table with data updated daily:

sorted doubling days


Case Doubling (red < 10 days, yellow < 15 days, orange < 5 days

No warranties expressed or implied as to the accuracy of these doubling calculations. All data is from the New York Times github source database.

Here is a sample Maxima calculation for Rhode Island

(%i2) Rhode_Island:[["2020-03-01",2,0],["2020-03-02",2,0],["2020-03-03",2,0],                                                                       
                    ["2020-03-04",2,0],["2020-03-05",2,0],["2020-03-06",3,0],                                                                        
                    ["2020-03-07",3,0],["2020-03-08",3,0],["2020-03-09",3,0],                                                                        
                    ["2020-03-10",5,0],["2020-03-11",5,0],["2020-03-12",5,0],                                                                        
                    ["2020-03-13",20,0],["2020-03-14",20,0],                                                                                         
                    ["2020-03-15",20,0],["2020-03-16",21,0],                                                                                         
                    ["2020-03-17",23,0],["2020-03-18",33,0],                                                                                         
                    ["2020-03-19",44,0],["2020-03-20",44,0],                                                                                         
                    ["2020-03-21",66,0],["2020-03-22",83,0],                                                                                         
                    ["2020-03-23",106,0],["2020-03-24",124,0],                                                                                       
                    ["2020-03-25",132,0],["2020-03-26",165,0],                                                                                       
                    ["2020-03-27",203,0],["2020-03-28",239,2],                                                                                       
                    ["2020-03-29",294,3],["2020-03-30",408,4],                                                                                       
                    ["2020-03-31",488,8],["2020-04-01",566,10],                                                                                      
                    ["2020-04-02",657,12],["2020-04-03",711,14],                                                                                     
                    ["2020-04-04",806,17],["2020-04-05",922,25],                                                                                     
                    ["2020-04-06",1082,27],["2020-04-07",1229,30],                                                                                   
                    ["2020-04-08",1450,35],["2020-04-09",1727,43],                                                                                   
                    ["2020-04-10",2015,49],["2020-04-11",2349,56]]                                                                                   

(%i4) compute_slope(n,s):=block(                                                                                                                     
                    [a:log(s[n][2])-log(s[n-1][2]),                                                                                                  
                     b:log(s[n-1][2])-log(s[n-2][2]),                                                                                                
                     c:log(s[n-2][2])-log(s[n-3][2]),                                                                                                
                     d:log(s[n-3][2])-log(s[n-4][2])],0.25*(d+c+b+a))                                                                                
(%o4) compute_slope(n, s) := block([a : log((s ) ) - log((s     ) ),                                                                                 
                                              n            n - 1                                                                                     
                                                2                2                                                                                   
b : log((s     ) ) - log((s     ) ), c : log((s     ) ) - log((s     ) ),                                                                            
          n - 1            n - 2               n - 2            n - 3                                                                                
                2                2                   2                2                                                                              
d : log((s     ) ) - log((s     ) )], 0.25 (d + c + b + a))                                                                                          
          n - 3            n - 4                                                                                                                     
                2                2                                                                                                                   
(%o5)                         compute_slopes.mac                                                                                                     
(%i6) n:length(Rhode_Island);                                                                                                                        
(%o6)                                 42                                                                                                             
(%i7) compute_slope(n, Rhode_Island);                                                                                                                
(%o7)                    0.25 (log(2349) - log(1229))                                                                                                
(%i8) %,numer;                                                                                                                                       
(%o8)                         0.1619472187732196                                                                                                     
(%i9) .69/%;                                                                                                                                         
(%o9)                          4.260647420973813                                                                                                     

Leave a comment

Your email address will not be published. Required fields are marked *

2 thoughts on “Covid19 US State sorted doubling numbers (updated daily)”