I can't remember how to effectively reshape repeating dates in a time series into a new table.

Below is a region by region count of COVID confirmed cases & deaths. Naturally, the dates are only unique for each region ('admin2'). I've isolated California for the below example to see. I'm trying to add confirmed and deaths across each state variable (in this case 'province_state'). And then ultimately reshape the data so each state has its own column with no repeating dates.


----------------------- copy starting from the next line -----------------------
Code:
* Example generated by -dataex-. To install: ssc install dataex
clear
input long uid str2 iso2 str3 iso3 int code3 long fips str21 admin2 str24 province_state str2 country_region float(lat long_) str44 combined_key long population str7 date int(confirmed deaths) float datevar
84006001 "US" "USA" 840 6001 "Alameda" "California" "US" 37.646294 -121.89293 "Alameda, California, US" 1671329 "1/22/20"   0  0 21936
84006001 "US" "USA" 840 6001 "Alameda" "California" "US" 37.646294 -121.89293 "Alameda, California, US" 1671329 "1/23/20"   0  0 21937
84006001 "US" "USA" 840 6001 "Alameda" "California" "US" 37.646294 -121.89293 "Alameda, California, US" 1671329 "1/24/20"   0  0 21938
84006001 "US" "USA" 840 6001 "Alameda" "California" "US" 37.646294 -121.89293 "Alameda, California, US" 1671329 "1/25/20"   0  0 21939
84006001 "US" "USA" 840 6001 "Alameda" "California" "US" 37.646294 -121.89293 "Alameda, California, US" 1671329 "1/26/20"   0  0 21940
84006001 "US" "USA" 840 6001 "Alameda" "California" "US" 37.646294 -121.89293 "Alameda, California, US" 1671329 "1/27/20"   0  0 21941
84006001 "US" "USA" 840 6001 "Alameda" "California" "US" 37.646294 -121.89293 "Alameda, California, US" 1671329 "1/28/20"   0  0 21942
84006001 "US" "USA" 840 6001 "Alameda" "California" "US" 37.646294 -121.89293 "Alameda, California, US" 1671329 "1/29/20"   0  0 21943
84006001 "US" "USA" 840 6001 "Alameda" "California" "US" 37.646294 -121.89293 "Alameda, California, US" 1671329 "1/30/20"   0  0 21944
84006001 "US" "USA" 840 6001 "Alameda" "California" "US" 37.646294 -121.89293 "Alameda, California, US" 1671329 "1/31/20"   0  0 21945
84006001 "US" "USA" 840 6001 "Alameda" "California" "US" 37.646294 -121.89293 "Alameda, California, US" 1671329 "2/1/20"    0  0 21946
84006001 "US" "USA" 840 6001 "Alameda" "California" "US" 37.646294 -121.89293 "Alameda, California, US" 1671329 "2/2/20"    0  0 21947
84006001 "US" "USA" 840 6001 "Alameda" "California" "US" 37.646294 -121.89293 "Alameda, California, US" 1671329 "2/3/20"    0  0 21948
84006001 "US" "USA" 840 6001 "Alameda" "California" "US" 37.646294 -121.89293 "Alameda, California, US" 1671329 "2/4/20"    0  0 21949
84006001 "US" "USA" 840 6001 "Alameda" "California" "US" 37.646294 -121.89293 "Alameda, California, US" 1671329 "2/5/20"    0  0 21950
84006001 "US" "USA" 840 6001 "Alameda" "California" "US" 37.646294 -121.89293 "Alameda, California, US" 1671329 "2/6/20"    0  0 21951
84006001 "US" "USA" 840 6001 "Alameda" "California" "US" 37.646294 -121.89293 "Alameda, California, US" 1671329 "2/7/20"    0  0 21952
84006001 "US" "USA" 840 6001 "Alameda" "California" "US" 37.646294 -121.89293 "Alameda, California, US" 1671329 "2/8/20"    0  0 21953
84006001 "US" "USA" 840 6001 "Alameda" "California" "US" 37.646294 -121.89293 "Alameda, California, US" 1671329 "2/9/20"    0  0 21954
84006001 "US" "USA" 840 6001 "Alameda" "California" "US" 37.646294 -121.89293 "Alameda, California, US" 1671329 "2/10/20"   0  0 21955
84006001 "US" "USA" 840 6001 "Alameda" "California" "US" 37.646294 -121.89293 "Alameda, California, US" 1671329 "2/11/20"   0  0 21956
84006001 "US" "USA" 840 6001 "Alameda" "California" "US" 37.646294 -121.89293 "Alameda, California, US" 1671329 "2/12/20"   0  0 21957
84006001 "US" "USA" 840 6001 "Alameda" "California" "US" 37.646294 -121.89293 "Alameda, California, US" 1671329 "2/13/20"   0  0 21958
84006001 "US" "USA" 840 6001 "Alameda" "California" "US" 37.646294 -121.89293 "Alameda, California, US" 1671329 "2/14/20"   0  0 21959
84006001 "US" "USA" 840 6001 "Alameda" "California" "US" 37.646294 -121.89293 "Alameda, California, US" 1671329 "2/15/20"   0  0 21960
84006001 "US" "USA" 840 6001 "Alameda" "California" "US" 37.646294 -121.89293 "Alameda, California, US" 1671329 "2/16/20"   0  0 21961
84006001 "US" "USA" 840 6001 "Alameda" "California" "US" 37.646294 -121.89293 "Alameda, California, US" 1671329 "2/17/20"   0  0 21962
84006001 "US" "USA" 840 6001 "Alameda" "California" "US" 37.646294 -121.89293 "Alameda, California, US" 1671329 "2/18/20"   0  0 21963
84006001 "US" "USA" 840 6001 "Alameda" "California" "US" 37.646294 -121.89293 "Alameda, California, US" 1671329 "2/19/20"   0  0 21964
84006001 "US" "USA" 840 6001 "Alameda" "California" "US" 37.646294 -121.89293 "Alameda, California, US" 1671329 "2/20/20"   0  0 21965
84006001 "US" "USA" 840 6001 "Alameda" "California" "US" 37.646294 -121.89293 "Alameda, California, US" 1671329 "2/21/20"   0  0 21966
84006001 "US" "USA" 840 6001 "Alameda" "California" "US" 37.646294 -121.89293 "Alameda, California, US" 1671329 "2/22/20"   0  0 21967
84006001 "US" "USA" 840 6001 "Alameda" "California" "US" 37.646294 -121.89293 "Alameda, California, US" 1671329 "2/23/20"   0  0 21968
84006001 "US" "USA" 840 6001 "Alameda" "California" "US" 37.646294 -121.89293 "Alameda, California, US" 1671329 "2/24/20"   0  0 21969
84006001 "US" "USA" 840 6001 "Alameda" "California" "US" 37.646294 -121.89293 "Alameda, California, US" 1671329 "2/25/20"   0  0 21970
84006001 "US" "USA" 840 6001 "Alameda" "California" "US" 37.646294 -121.89293 "Alameda, California, US" 1671329 "2/26/20"   0  0 21971
84006001 "US" "USA" 840 6001 "Alameda" "California" "US" 37.646294 -121.89293 "Alameda, California, US" 1671329 "2/27/20"   0  0 21972
84006001 "US" "USA" 840 6001 "Alameda" "California" "US" 37.646294 -121.89293 "Alameda, California, US" 1671329 "2/28/20"   0  0 21973
84006001 "US" "USA" 840 6001 "Alameda" "California" "US" 37.646294 -121.89293 "Alameda, California, US" 1671329 "2/29/20"   0  0 21974
84006001 "US" "USA" 840 6001 "Alameda" "California" "US" 37.646294 -121.89293 "Alameda, California, US" 1671329 "3/1/20"    0  0 21975
84006001 "US" "USA" 840 6001 "Alameda" "California" "US" 37.646294 -121.89293 "Alameda, California, US" 1671329 "3/2/20"    0  0 21976
84006001 "US" "USA" 840 6001 "Alameda" "California" "US" 37.646294 -121.89293 "Alameda, California, US" 1671329 "3/3/20"    1  0 21977
84006001 "US" "USA" 840 6001 "Alameda" "California" "US" 37.646294 -121.89293 "Alameda, California, US" 1671329 "3/4/20"    1  0 21978
84006001 "US" "USA" 840 6001 "Alameda" "California" "US" 37.646294 -121.89293 "Alameda, California, US" 1671329 "3/5/20"    1  0 21979
84006001 "US" "USA" 840 6001 "Alameda" "California" "US" 37.646294 -121.89293 "Alameda, California, US" 1671329 "3/6/20"    1  0 21980
84006001 "US" "USA" 840 6001 "Alameda" "California" "US" 37.646294 -121.89293 "Alameda, California, US" 1671329 "3/7/20"    2  0 21981
84006001 "US" "USA" 840 6001 "Alameda" "California" "US" 37.646294 -121.89293 "Alameda, California, US" 1671329 "3/8/20"    2  0 21982
84006001 "US" "USA" 840 6001 "Alameda" "California" "US" 37.646294 -121.89293 "Alameda, California, US" 1671329 "3/9/20"    2  0 21983
84006001 "US" "USA" 840 6001 "Alameda" "California" "US" 37.646294 -121.89293 "Alameda, California, US" 1671329 "3/10/20"   3  0 21984
84006001 "US" "USA" 840 6001 "Alameda" "California" "US" 37.646294 -121.89293 "Alameda, California, US" 1671329 "3/11/20"   5  0 21985
84006001 "US" "USA" 840 6001 "Alameda" "California" "US" 37.646294 -121.89293 "Alameda, California, US" 1671329 "3/12/20"   5  0 21986
84006001 "US" "USA" 840 6001 "Alameda" "California" "US" 37.646294 -121.89293 "Alameda, California, US" 1671329 "3/13/20"   7  0 21987
84006001 "US" "USA" 840 6001 "Alameda" "California" "US" 37.646294 -121.89293 "Alameda, California, US" 1671329 "3/14/20"  11  0 21988
84006001 "US" "USA" 840 6001 "Alameda" "California" "US" 37.646294 -121.89293 "Alameda, California, US" 1671329 "3/15/20"  11  0 21989
84006001 "US" "USA" 840 6001 "Alameda" "California" "US" 37.646294 -121.89293 "Alameda, California, US" 1671329 "3/16/20"  18  0 21990
84006001 "US" "USA" 840 6001 "Alameda" "California" "US" 37.646294 -121.89293 "Alameda, California, US" 1671329 "3/17/20"  27  0 21991
84006001 "US" "USA" 840 6001 "Alameda" "California" "US" 37.646294 -121.89293 "Alameda, California, US" 1671329 "3/18/20"  30  0 21992
84006001 "US" "USA" 840 6001 "Alameda" "California" "US" 37.646294 -121.89293 "Alameda, California, US" 1671329 "3/19/20"  38  0 21993
84006001 "US" "USA" 840 6001 "Alameda" "California" "US" 37.646294 -121.89293 "Alameda, California, US" 1671329 "3/20/20"  48  0 21994
84006001 "US" "USA" 840 6001 "Alameda" "California" "US" 37.646294 -121.89293 "Alameda, California, US" 1671329 "3/21/20"  68  0 21995
84006001 "US" "USA" 840 6001 "Alameda" "California" "US" 37.646294 -121.89293 "Alameda, California, US" 1671329 "3/22/20"  71  0 21996
84006001 "US" "USA" 840 6001 "Alameda" "California" "US" 37.646294 -121.89293 "Alameda, California, US" 1671329 "3/23/20" 118  1 21997
84006001 "US" "USA" 840 6001 "Alameda" "California" "US" 37.646294 -121.89293 "Alameda, California, US" 1671329 "3/24/20" 135  2 21998
84006001 "US" "USA" 840 6001 "Alameda" "California" "US" 37.646294 -121.89293 "Alameda, California, US" 1671329 "3/25/20" 135  2 21999
84006001 "US" "USA" 840 6001 "Alameda" "California" "US" 37.646294 -121.89293 "Alameda, California, US" 1671329 "3/26/20" 178  4 22000
84006001 "US" "USA" 840 6001 "Alameda" "California" "US" 37.646294 -121.89293 "Alameda, California, US" 1671329 "3/27/20" 220  4 22001
84006001 "US" "USA" 840 6001 "Alameda" "California" "US" 37.646294 -121.89293 "Alameda, California, US" 1671329 "3/28/20" 220  4 22002
84006001 "US" "USA" 840 6001 "Alameda" "California" "US" 37.646294 -121.89293 "Alameda, California, US" 1671329 "3/29/20" 270  6 22003
84006001 "US" "USA" 840 6001 "Alameda" "California" "US" 37.646294 -121.89293 "Alameda, California, US" 1671329 "3/30/20" 283  7 22004
84006001 "US" "USA" 840 6001 "Alameda" "California" "US" 37.646294 -121.89293 "Alameda, California, US" 1671329 "3/31/20" 313  7 22005
84006001 "US" "USA" 840 6001 "Alameda" "California" "US" 37.646294 -121.89293 "Alameda, California, US" 1671329 "4/1/20"  313  7 22006
84006001 "US" "USA" 840 6001 "Alameda" "California" "US" 37.646294 -121.89293 "Alameda, California, US" 1671329 "4/2/20"  359  8 22007
84006001 "US" "USA" 840 6001 "Alameda" "California" "US" 37.646294 -121.89293 "Alameda, California, US" 1671329 "4/3/20"  443 12 22008
84006001 "US" "USA" 840 6001 "Alameda" "California" "US" 37.646294 -121.89293 "Alameda, California, US" 1671329 "4/4/20"  443 12 22009
84006003 "US" "USA" 840 6003 "Alpine"  "California" "US"  38.59679 -119.82236 "Alpine, California, US"     1129 "1/22/20"   0  0 21936
84006003 "US" "USA" 840 6003 "Alpine"  "California" "US"  38.59679 -119.82236 "Alpine, California, US"     1129 "1/23/20"   0  0 21937
84006003 "US" "USA" 840 6003 "Alpine"  "California" "US"  38.59679 -119.82236 "Alpine, California, US"     1129 "1/24/20"   0  0 21938
84006003 "US" "USA" 840 6003 "Alpine"  "California" "US"  38.59679 -119.82236 "Alpine, California, US"     1129 "1/25/20"   0  0 21939
84006003 "US" "USA" 840 6003 "Alpine"  "California" "US"  38.59679 -119.82236 "Alpine, California, US"     1129 "1/26/20"   0  0 21940
84006003 "US" "USA" 840 6003 "Alpine"  "California" "US"  38.59679 -119.82236 "Alpine, California, US"     1129 "1/27/20"   0  0 21941
84006003 "US" "USA" 840 6003 "Alpine"  "California" "US"  38.59679 -119.82236 "Alpine, California, US"     1129 "1/28/20"   0  0 21942
84006003 "US" "USA" 840 6003 "Alpine"  "California" "US"  38.59679 -119.82236 "Alpine, California, US"     1129 "1/29/20"   0  0 21943
84006003 "US" "USA" 840 6003 "Alpine"  "California" "US"  38.59679 -119.82236 "Alpine, California, US"     1129 "1/30/20"   0  0 21944
84006003 "US" "USA" 840 6003 "Alpine"  "California" "US"  38.59679 -119.82236 "Alpine, California, US"     1129 "1/31/20"   0  0 21945
84006003 "US" "USA" 840 6003 "Alpine"  "California" "US"  38.59679 -119.82236 "Alpine, California, US"     1129 "2/1/20"    0  0 21946
84006003 "US" "USA" 840 6003 "Alpine"  "California" "US"  38.59679 -119.82236 "Alpine, California, US"     1129 "2/2/20"    0  0 21947
84006003 "US" "USA" 840 6003 "Alpine"  "California" "US"  38.59679 -119.82236 "Alpine, California, US"     1129 "2/3/20"    0  0 21948
84006003 "US" "USA" 840 6003 "Alpine"  "California" "US"  38.59679 -119.82236 "Alpine, California, US"     1129 "2/4/20"    0  0 21949
84006003 "US" "USA" 840 6003 "Alpine"  "California" "US"  38.59679 -119.82236 "Alpine, California, US"     1129 "2/5/20"    0  0 21950
84006003 "US" "USA" 840 6003 "Alpine"  "California" "US"  38.59679 -119.82236 "Alpine, California, US"     1129 "2/6/20"    0  0 21951
84006003 "US" "USA" 840 6003 "Alpine"  "California" "US"  38.59679 -119.82236 "Alpine, California, US"     1129 "2/7/20"    0  0 21952
84006003 "US" "USA" 840 6003 "Alpine"  "California" "US"  38.59679 -119.82236 "Alpine, California, US"     1129 "2/8/20"    0  0 21953
84006003 "US" "USA" 840 6003 "Alpine"  "California" "US"  38.59679 -119.82236 "Alpine, California, US"     1129 "2/9/20"    0  0 21954
84006003 "US" "USA" 840 6003 "Alpine"  "California" "US"  38.59679 -119.82236 "Alpine, California, US"     1129 "2/10/20"   0  0 21955
84006003 "US" "USA" 840 6003 "Alpine"  "California" "US"  38.59679 -119.82236 "Alpine, California, US"     1129 "2/11/20"   0  0 21956
84006003 "US" "USA" 840 6003 "Alpine"  "California" "US"  38.59679 -119.82236 "Alpine, California, US"     1129 "2/12/20"   0  0 21957
84006003 "US" "USA" 840 6003 "Alpine"  "California" "US"  38.59679 -119.82236 "Alpine, California, US"     1129 "2/13/20"   0  0 21958
84006003 "US" "USA" 840 6003 "Alpine"  "California" "US"  38.59679 -119.82236 "Alpine, California, US"     1129 "2/14/20"   0  0 21959
84006003 "US" "USA" 840 6003 "Alpine"  "California" "US"  38.59679 -119.82236 "Alpine, California, US"     1129 "2/15/20"   0  0 21960
84006003 "US" "USA" 840 6003 "Alpine"  "California" "US"  38.59679 -119.82236 "Alpine, California, US"     1129 "2/16/20"   0  0 21961
end
format %td datevar
------------------ copy up to and including the previous line ------------------

I did the below, which provides the number but retains the shape. Is there a way to do this concisely without having to go back to drop repeating dates?
Code:
. bysort datevar: egen cumsum=total(confirmed)