| rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key | |---------+------------+---------------------+---------------------+---------------+--------+-------------+----------+-------------+----------+------------+-------------+---------------------+---------------------------------| | 2755755 | 2022-12-29 | US | South Dakota | Aurora | 46003 | 887 | 18 | 0 | | 43.7176 | -98.5605 | 2022-12-30 04:21:04 | Aurora, South Dakota, US | | 2755756 | 2022-12-29 | US | South Dakota | Beadle | 46005 | 5449 | 64 | 0 | | 44.4146 | -98.2786 | 2022-12-30 04:21:04 | Beadle, South Dakota, US | | 2755757 | 2022-12-29 | US | South Dakota | Bennett | 46007 | 905 | 16 | 0 | | 43.1949 | -101.667 | 2022-12-30 04:21:04 | Bennett, South Dakota, US | | 2755758 | 2022-12-29 | US | South Dakota | Bon Homme | 46009 | 2497 | 42 | 0 | | 42.9891 | -97.8859 | 2022-12-30 04:21:04 | Bon Homme, South Dakota, US | | 2755759 | 2022-12-29 | US | South Dakota | Brookings | 46011 | 9214 | 62 | 0 | | 44.3697 | -96.7908 | 2022-12-30 04:21:04 | Brookings, South Dakota, US | | 2755760 | 2022-12-29 | US | South Dakota | Brown | 46013 | 11777 | 132 | 0 | | 45.5899 | -98.3517 | 2022-12-30 04:21:04 | Brown, South Dakota, US | | 2755761 | 2022-12-29 | US | South Dakota | Brule | 46015 | 1654 | 27 | 0 | | 43.7176 | -99.0812 | 2022-12-30 04:21:04 | Brule, South Dakota, US | | 2755762 | 2022-12-29 | US | South Dakota | Buffalo | 46017 | 678 | 18 | 0 | | 44.0766 | -99.2081 | 2022-12-30 04:21:04 | Buffalo, South Dakota, US | | 2755763 | 2022-12-29 | US | South Dakota | Butte | 46019 | 3173 | 48 | 0 | | 44.9061 | -103.508 | 2022-12-30 04:21:04 | Butte, South Dakota, US | | 2755764 | 2022-12-29 | US | South Dakota | Campbell | 46021 | 304 | 7 | 0 | | 45.7707 | -100.051 | 2022-12-30 04:21:04 | Campbell, South Dakota, US | | 2755765 | 2022-12-29 | US | South Dakota | Charles Mix | 46023 | 3441 | 37 | 0 | | 43.2066 | -98.5886 | 2022-12-30 04:21:04 | Charles Mix, South Dakota, US | | 2755766 | 2022-12-29 | US | South Dakota | Clark | 46025 | 930 | 12 | 0 | | 44.8583 | -97.7293 | 2022-12-30 04:21:04 | Clark, South Dakota, US | | 2755767 | 2022-12-29 | US | South Dakota | Clay | 46027 | 3820 | 26 | 0 | | 42.913 | -96.9766 | 2022-12-30 04:21:04 | Clay, South Dakota, US | | 2755768 | 2022-12-29 | US | South Dakota | Codington | 46029 | 10290 | 106 | 0 | | 44.9779 | -97.1883 | 2022-12-30 04:21:04 | Codington, South Dakota, US | | 2755769 | 2022-12-29 | US | South Dakota | Corson | 46031 | 1188 | 18 | 0 | | 45.7089 | -101.197 | 2022-12-30 04:21:04 | Corson, South Dakota, US | | 2755770 | 2022-12-29 | US | South Dakota | Custer | 46033 | 2438 | 28 | 0 | | 43.6774 | -103.453 | 2022-12-30 04:21:04 | Custer, South Dakota, US | | 2755771 | 2022-12-29 | US | South Dakota | Davison | 46035 | 6908 | 86 | 0 | | 43.6749 | -98.1446 | 2022-12-30 04:21:04 | Davison, South Dakota, US | | 2755772 | 2022-12-29 | US | South Dakota | Day | 46037 | 1448 | 40 | 0 | | 45.3673 | -97.6074 | 2022-12-30 04:21:04 | Day, South Dakota, US | | 2755773 | 2022-12-29 | US | South Dakota | Deuel | 46039 | 1172 | 12 | 0 | | 44.7599 | -96.6694 | 2022-12-30 04:21:04 | Deuel, South Dakota, US | | 2755774 | 2022-12-29 | US | South Dakota | Dewey | 46041 | 3358 | 46 | 0 | | 45.1564 | -100.871 | 2022-12-30 04:21:04 | Dewey, South Dakota, US | | 2755775 | 2022-12-29 | US | South Dakota | Douglas | 46043 | 795 | 16 | 0 | | 43.3852 | -98.3698 | 2022-12-30 04:21:04 | Douglas, South Dakota, US | | 2755776 | 2022-12-29 | US | South Dakota | Edmunds | 46045 | 1040 | 17 | 0 | | 45.4185 | -99.2155 | 2022-12-30 04:21:04 | Edmunds, South Dakota, US | | 2755777 | 2022-12-29 | US | South Dakota | Fall River | 46047 | 2394 | 44 | 0 | | 43.2393 | -103.528 | 2022-12-30 04:21:04 | Fall River, South Dakota, US | | 2755778 | 2022-12-29 | US | South Dakota | Faulk | 46049 | 677 | 17 | 0 | | 45.0708 | -99.1454 | 2022-12-30 04:21:04 | Faulk, South Dakota, US | | 2755779 | 2022-12-29 | US | South Dakota | Grant | 46051 | 2366 | 51 | 0 | | 45.1724 | -96.77 | 2022-12-30 04:21:04 | Grant, South Dakota, US | | 2755780 | 2022-12-29 | US | South Dakota | Gregory | 46053 | 1201 | 34 | 0 | | 43.1942 | -99.1888 | 2022-12-30 04:21:04 | Gregory, South Dakota, US | | 2755781 | 2022-12-29 | US | South Dakota | Haakon | 46055 | 512 | 12 | 0 | | 44.293 | -101.539 | 2022-12-30 04:21:04 | Haakon, South Dakota, US | | 2755782 | 2022-12-29 | US | South Dakota | Hamlin | 46057 | 1744 | 41 | 0 | | 44.6739 | -97.1883 | 2022-12-30 04:21:04 | Hamlin, South Dakota, US | | 2755783 | 2022-12-29 | US | South Dakota | Hand | 46059 | 651 | 13 | 0 | | 44.5471 | -99.0039 | 2022-12-30 04:21:04 | Hand, South Dakota, US | | 2755784 | 2022-12-29 | US | South Dakota | Hanson | 46061 | 730 | 6 | 0 | | 43.6746 | -97.7872 | 2022-12-30 04:21:04 | Hanson, South Dakota, US | | 2755785 | 2022-12-29 | US | South Dakota | Harding | 46063 | 218 | 3 | 0 | | 45.5802 | -103.496 | 2022-12-30 04:21:04 | Harding, South Dakota, US | | 2755786 | 2022-12-29 | US | South Dakota | Hughes | 46065 | 4947 | 62 | 0 | | 44.3909 | -99.9966 | 2022-12-30 04:21:04 | Hughes, South Dakota, US | | 2755787 | 2022-12-29 | US | South Dakota | Hutchinson | 46067 | 1970 | 39 | 0 | | 43.3345 | -97.7554 | 2022-12-30 04:21:04 | Hutchinson, South Dakota, US | | 2755788 | 2022-12-29 | US | South Dakota | Hyde | 46069 | 344 | 8 | 0 | | 44.5475 | -99.4857 | 2022-12-30 04:21:04 | Hyde, South Dakota, US | | 2755789 | 2022-12-29 | US | South Dakota | Jackson | 46071 | 722 | 21 | 0 | | 43.6932 | -101.626 | 2022-12-30 04:21:04 | Jackson, South Dakota, US | | 2755790 | 2022-12-29 | US | South Dakota | Jerauld | 46073 | 470 | 20 | 0 | | 44.0664 | -98.6297 | 2022-12-30 04:21:04 | Jerauld, South Dakota, US | | 2755791 | 2022-12-29 | US | South Dakota | Jones | 46075 | 191 | 2 | 0 | | 43.9628 | -100.694 | 2022-12-30 04:21:04 | Jones, South Dakota, US | | 2755792 | 2022-12-29 | US | South Dakota | Kingsbury | 46077 | 1520 | 25 | 0 | | 44.3696 | -97.4914 | 2022-12-30 04:21:04 | Kingsbury, South Dakota, US | | 2755793 | 2022-12-29 | US | South Dakota | Lake | 46079 | 2588 | 28 | 0 | | 44.0219 | -97.1293 | 2022-12-30 04:21:04 | Lake, South Dakota, US | | 2755794 | 2022-12-29 | US | South Dakota | Lawrence | 46081 | 7640 | 88 | 0 | | 44.3592 | -103.793 | 2022-12-30 04:21:04 | Lawrence, South Dakota, US | | 2755795 | 2022-12-29 | US | South Dakota | Lincoln | 46083 | 17153 | 110 | 0 | | 43.2784 | -96.7204 | 2022-12-30 04:21:04 | Lincoln, South Dakota, US | | 2755796 | 2022-12-29 | US | South Dakota | Lyman | 46085 | 1394 | 13 | 0 | | 43.8952 | -99.852 | 2022-12-30 04:21:04 | Lyman, South Dakota, US | | 2755797 | 2022-12-29 | US | South Dakota | Marshall | 46091 | 920 | 15 | 0 | | 45.7587 | -97.5986 | 2022-12-30 04:21:04 | Marshall, South Dakota, US | | 2755798 | 2022-12-29 | US | South Dakota | McCook | 46087 | 1476 | 32 | 0 | | 43.6743 | -97.3686 | 2022-12-30 04:21:04 | McCook, South Dakota, US | | 2755799 | 2022-12-29 | US | South Dakota | McPherson | 46089 | 525 | 15 | 0 | | 45.7663 | -99.2212 | 2022-12-30 04:21:04 | McPherson, South Dakota, US | | 2755800 | 2022-12-29 | US | South Dakota | Meade | 46093 | 8206 | 68 | 0 | | 44.5668 | -102.716 | 2022-12-30 04:21:04 | Meade, South Dakota, US | | 2755801 | 2022-12-29 | US | South Dakota | Mellette | 46095 | 634 | 8 | 0 | | 43.5808 | -100.756 | 2022-12-30 04:21:04 | Mellette, South Dakota, US | | 2755802 | 2022-12-29 | US | South Dakota | Miner | 46097 | 532 | 15 | 0 | | 44.022 | -97.6099 | 2022-12-30 04:21:04 | Miner, South Dakota, US | | 2755803 | 2022-12-29 | US | South Dakota | Minnehaha | 46099 | 63867 | 550 | 0 | | 43.6744 | -96.7911 | 2022-12-30 04:21:04 | Minnehaha, South Dakota, US | | 2755804 | 2022-12-29 | US | South Dakota | Moody | 46101 | 1660 | 29 | 0 | | 44.0227 | -96.6708 | 2022-12-30 04:21:04 | Moody, South Dakota, US | | 2755805 | 2022-12-29 | US | South Dakota | Oglala Lakota | 46102 | 4790 | 62 | 0 | | 43.3375 | -102.556 | 2022-12-30 04:21:04 | Oglala Lakota, South Dakota, US | | 2755806 | 2022-12-29 | US | South Dakota | Pennington | 46103 | 37943 | 369 | 0 | | 44.0026 | -102.824 | 2022-12-30 04:21:04 | Pennington, South Dakota, US | | 2755807 | 2022-12-29 | US | South Dakota | Perkins | 46105 | 786 | 19 | 0 | | 45.4905 | -102.476 | 2022-12-30 04:21:04 | Perkins, South Dakota, US | | 2755808 | 2022-12-29 | US | South Dakota | Potter | 46107 | 776 | 9 | 0 | | 45.0658 | -99.955 | 2022-12-30 04:21:04 | Potter, South Dakota, US | | 2755809 | 2022-12-29 | US | South Dakota | Roberts | 46109 | 2777 | 56 | 0 | | 45.6298 | -96.9467 | 2022-12-30 04:21:04 | Roberts, South Dakota, US | | 2755810 | 2022-12-29 | US | South Dakota | Sanborn | 46111 | 663 | 8 | 0 | | 44.0235 | -98.091 | 2022-12-30 04:21:04 | Sanborn, South Dakota, US | | 2755811 | 2022-12-29 | US | South Dakota | Spink | 46115 | 1678 | 36 | 0 | | 44.9384 | -98.3463 | 2022-12-30 04:21:04 | Spink, South Dakota, US | | 2755812 | 2022-12-29 | US | South Dakota | Stanley | 46117 | 717 | 9 | 0 | | 44.4138 | -100.735 | 2022-12-30 04:21:04 | Stanley, South Dakota, US | | 2755813 | 2022-12-29 | US | South Dakota | Sully | 46119 | 263 | 3 | 0 | | 44.7157 | -100.128 | 2022-12-30 04:21:04 | Sully, South Dakota, US | | 2755814 | 2022-12-29 | US | South Dakota | Todd | 46121 | 3752 | 53 | 0 | | 43.1934 | -100.72 | 2022-12-30 04:21:04 | Todd, South Dakota, US | | 2755815 | 2022-12-29 | US | South Dakota | Tripp | 46123 | 1663 | 29 | 0 | | 43.3446 | -99.8855 | 2022-12-30 04:21:04 | Tripp, South Dakota, US | | 2755816 | 2022-12-29 | US | South Dakota | Turner | 46125 | 2168 | 64 | 0 | | 43.3109 | -97.1487 | 2022-12-30 04:21:04 | Turner, South Dakota, US | | 2755817 | 2022-12-29 | US | South Dakota | Unassigned | 90046 | 0 | 0 | 0 | | 45.7707 | -99.9966 | 2022-12-30 04:21:04 | Unassigned, South Dakota, US | | 2755818 | 2022-12-29 | US | South Dakota | Union | 46127 | 4299 | 55 | 0 | | 42.8311 | -96.6558 | 2022-12-30 04:21:04 | Union, South Dakota, US | | 2755819 | 2022-12-29 | US | South Dakota | Walworth | 46129 | 1484 | 28 | 0 | | 45.4302 | -100.031 | 2022-12-30 04:21:04 | Walworth, South Dakota, US | | 2755820 | 2022-12-29 | US | South Dakota | Yankton | 46135 | 6772 | 60 | 0 | | 43.0092 | -97.3947 | 2022-12-30 04:21:04 | Yankton, South Dakota, US | | 2755821 | 2022-12-29 | US | South Dakota | Ziebach | 46137 | 707 | 11 | 0 | | 44.9788 | -101.665 | 2022-12-30 04:21:04 | Ziebach, South Dakota, US | | 1076761 | 2022-12-28 | US | South Dakota | Aurora | 46003 | 887 | 18 | 0 | | 43.7176 | -98.5605 | 2022-12-29 04:21:01 | Aurora, South Dakota, US | | 1076762 | 2022-12-28 | US | South Dakota | Beadle | 46005 | 5449 | 64 | 0 | | 44.4146 | -98.2786 | 2022-12-29 04:21:01 | Beadle, South Dakota, US | | 1076763 | 2022-12-28 | US | South Dakota | Bennett | 46007 | 905 | 16 | 0 | | 43.1949 | -101.667 | 2022-12-29 04:21:01 | Bennett, South Dakota, US | | 1076764 | 2022-12-28 | US | South Dakota | Bon Homme | 46009 | 2497 | 42 | 0 | | 42.9891 | -97.8859 | 2022-12-29 04:21:01 | Bon Homme, South Dakota, US | | 1076765 | 2022-12-28 | US | South Dakota | Brookings | 46011 | 9214 | 62 | 0 | | 44.3697 | -96.7908 | 2022-12-29 04:21:01 | Brookings, South Dakota, US | | 1076766 | 2022-12-28 | US | South Dakota | Brown | 46013 | 11777 | 132 | 0 | | 45.5899 | -98.3517 | 2022-12-29 04:21:01 | Brown, South Dakota, US | | 1076767 | 2022-12-28 | US | South Dakota | Brule | 46015 | 1654 | 27 | 0 | | 43.7176 | -99.0812 | 2022-12-29 04:21:01 | Brule, South Dakota, US | | 1076768 | 2022-12-28 | US | South Dakota | Buffalo | 46017 | 678 | 18 | 0 | | 44.0766 | -99.2081 | 2022-12-29 04:21:01 | Buffalo, South Dakota, US | | 1076769 | 2022-12-28 | US | South Dakota | Butte | 46019 | 3173 | 48 | 0 | | 44.9061 | -103.508 | 2022-12-29 04:21:01 | Butte, South Dakota, US | | 1076770 | 2022-12-28 | US | South Dakota | Campbell | 46021 | 304 | 7 | 0 | | 45.7707 | -100.051 | 2022-12-29 04:21:01 | Campbell, South Dakota, US | | 1076771 | 2022-12-28 | US | South Dakota | Charles Mix | 46023 | 3441 | 37 | 0 | | 43.2066 | -98.5886 | 2022-12-29 04:21:01 | Charles Mix, South Dakota, US | | 1076772 | 2022-12-28 | US | South Dakota | Clark | 46025 | 930 | 12 | 0 | | 44.8583 | -97.7293 | 2022-12-29 04:21:01 | Clark, South Dakota, US | | 1076773 | 2022-12-28 | US | South Dakota | Clay | 46027 | 3820 | 26 | 0 | | 42.913 | -96.9766 | 2022-12-29 04:21:01 | Clay, South Dakota, US | | 1076774 | 2022-12-28 | US | South Dakota | Codington | 46029 | 10290 | 106 | 0 | | 44.9779 | -97.1883 | 2022-12-29 04:21:01 | Codington, South Dakota, US | | 1076775 | 2022-12-28 | US | South Dakota | Corson | 46031 | 1188 | 18 | 0 | | 45.7089 | -101.197 | 2022-12-29 04:21:01 | Corson, South Dakota, US | | 1076776 | 2022-12-28 | US | South Dakota | Custer | 46033 | 2438 | 28 | 0 | | 43.6774 | -103.453 | 2022-12-29 04:21:01 | Custer, South Dakota, US | | 1076777 | 2022-12-28 | US | South Dakota | Davison | 46035 | 6908 | 86 | 0 | | 43.6749 | -98.1446 | 2022-12-29 04:21:01 | Davison, South Dakota, US | | 1076778 | 2022-12-28 | US | South Dakota | Day | 46037 | 1448 | 40 | 0 | | 45.3673 | -97.6074 | 2022-12-29 04:21:01 | Day, South Dakota, US | | 1076779 | 2022-12-28 | US | South Dakota | Deuel | 46039 | 1172 | 12 | 0 | | 44.7599 | -96.6694 | 2022-12-29 04:21:01 | Deuel, South Dakota, US | | 1076780 | 2022-12-28 | US | South Dakota | Dewey | 46041 | 3358 | 46 | 0 | | 45.1564 | -100.871 | 2022-12-29 04:21:01 | Dewey, South Dakota, US | | 1076781 | 2022-12-28 | US | South Dakota | Douglas | 46043 | 795 | 16 | 0 | | 43.3852 | -98.3698 | 2022-12-29 04:21:01 | Douglas, South Dakota, US | | 1076782 | 2022-12-28 | US | South Dakota | Edmunds | 46045 | 1040 | 17 | 0 | | 45.4185 | -99.2155 | 2022-12-29 04:21:01 | Edmunds, South Dakota, US | | 1076783 | 2022-12-28 | US | South Dakota | Fall River | 46047 | 2394 | 44 | 0 | | 43.2393 | -103.528 | 2022-12-29 04:21:01 | Fall River, South Dakota, US | | 1076784 | 2022-12-28 | US | South Dakota | Faulk | 46049 | 677 | 17 | 0 | | 45.0708 | -99.1454 | 2022-12-29 04:21:01 | Faulk, South Dakota, US | | 1076785 | 2022-12-28 | US | South Dakota | Grant | 46051 | 2366 | 51 | 0 | | 45.1724 | -96.77 | 2022-12-29 04:21:01 | Grant, South Dakota, US | | 1076786 | 2022-12-28 | US | South Dakota | Gregory | 46053 | 1201 | 34 | 0 | | 43.1942 | -99.1888 | 2022-12-29 04:21:01 | Gregory, South Dakota, US | | 1076787 | 2022-12-28 | US | South Dakota | Haakon | 46055 | 512 | 12 | 0 | | 44.293 | -101.539 | 2022-12-29 04:21:01 | Haakon, South Dakota, US | | 1076788 | 2022-12-28 | US | South Dakota | Hamlin | 46057 | 1744 | 41 | 0 | | 44.6739 | -97.1883 | 2022-12-29 04:21:01 | Hamlin, South Dakota, US | | 1076789 | 2022-12-28 | US | South Dakota | Hand | 46059 | 651 | 13 | 0 | | 44.5471 | -99.0039 | 2022-12-29 04:21:01 | Hand, South Dakota, US | | 1076790 | 2022-12-28 | US | South Dakota | Hanson | 46061 | 730 | 6 | 0 | | 43.6746 | -97.7872 | 2022-12-29 04:21:01 | Hanson, South Dakota, US | | 1076791 | 2022-12-28 | US | South Dakota | Harding | 46063 | 218 | 3 | 0 | | 45.5802 | -103.496 | 2022-12-29 04:21:01 | Harding, South Dakota, US | | 1076792 | 2022-12-28 | US | South Dakota | Hughes | 46065 | 4947 | 62 | 0 | | 44.3909 | -99.9966 | 2022-12-29 04:21:01 | Hughes, South Dakota, US | | 1076793 | 2022-12-28 | US | South Dakota | Hutchinson | 46067 | 1970 | 39 | 0 | | 43.3345 | -97.7554 | 2022-12-29 04:21:01 | Hutchinson, South Dakota, US |