ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

49,552 rows where state = "South Dakota" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

fips >30

county >30

state 1

  • South Dakota · 49,552 ✖
Link rowid date ▲ county state fips cases deaths
2502045 2502045 2022-05-13 Aurora South Dakota 46003 805 17
2502046 2502046 2022-05-13 Beadle South Dakota 46005 4596 60
2502047 2502047 2022-05-13 Bennett South Dakota 46007 789 14
2502048 2502048 2022-05-13 Bon Homme South Dakota 46009 2292 39
2502049 2502049 2022-05-13 Brookings South Dakota 46011 8149 52
2502050 2502050 2022-05-13 Brown South Dakota 46013 10344 121
2502051 2502051 2022-05-13 Brule South Dakota 46015 1415 20
2502052 2502052 2022-05-13 Buffalo South Dakota 46017 620 18
2502053 2502053 2022-05-13 Butte South Dakota 46019 2757 45
2502054 2502054 2022-05-13 Campbell South Dakota 46021 268 7
2502055 2502055 2022-05-13 Charles Mix South Dakota 46023 2942 35
2502056 2502056 2022-05-13 Clark South Dakota 46025 804 9
2502057 2502057 2022-05-13 Clay South Dakota 46027 3493 21
2502058 2502058 2022-05-13 Codington South Dakota 46029 8474 101
2502059 2502059 2022-05-13 Corson South Dakota 46031 1070 17
2502060 2502060 2022-05-13 Custer South Dakota 46033 2034 26
2502061 2502061 2022-05-13 Davison South Dakota 46035 5907 80
2502062 2502062 2022-05-13 Day South Dakota 46037 1295 35
2502063 2502063 2022-05-13 Deuel South Dakota 46039 1043 12
2502064 2502064 2022-05-13 Dewey South Dakota 46041 3139 44
2502065 2502065 2022-05-13 Douglas South Dakota 46043 684 16
2502066 2502066 2022-05-13 Edmunds South Dakota 46045 949 16
2502067 2502067 2022-05-13 Fall River South Dakota 46047 1807 39
2502068 2502068 2022-05-13 Faulk South Dakota 46049 572 16
2502069 2502069 2022-05-13 Grant South Dakota 46051 2047 51
2502070 2502070 2022-05-13 Gregory South Dakota 46053 1065 34
2502071 2502071 2022-05-13 Haakon South Dakota 46055 452 12
2502072 2502072 2022-05-13 Hamlin South Dakota 46057 1508 41
2502073 2502073 2022-05-13 Hand South Dakota 46059 562 12
2502074 2502074 2022-05-13 Hanson South Dakota 46061 655 6
2502075 2502075 2022-05-13 Harding South Dakota 46063 201 3
2502076 2502076 2022-05-13 Hughes South Dakota 46065 4335 58
2502077 2502077 2022-05-13 Hutchinson South Dakota 46067 1733 36
2502078 2502078 2022-05-13 Hyde South Dakota 46069 307 8
2502079 2502079 2022-05-13 Jackson South Dakota 46071 632 21
2502080 2502080 2022-05-13 Jerauld South Dakota 46073 415 20
2502081 2502081 2022-05-13 Jones South Dakota 46075 177 2
2502082 2502082 2022-05-13 Kingsbury South Dakota 46077 1340 22
2502083 2502083 2022-05-13 Lake South Dakota 46079 2335 28
2502084 2502084 2022-05-13 Lawrence South Dakota 46081 6605 83
2502085 2502085 2022-05-13 Lincoln South Dakota 46083 15590 102
2502086 2502086 2022-05-13 Lyman South Dakota 46085 1205 12
2502087 2502087 2022-05-13 Marshall South Dakota 46091 796 13
2502088 2502088 2022-05-13 McCook South Dakota 46087 1348 31
2502089 2502089 2022-05-13 McPherson South Dakota 46089 426 9
2502090 2502090 2022-05-13 Meade South Dakota 46093 7042 64
2502091 2502091 2022-05-13 Mellette South Dakota 46095 527 8
2502092 2502092 2022-05-13 Miner South Dakota 46097 457 13
2502093 2502093 2022-05-13 Minnehaha South Dakota 46099 57428 519
2502094 2502094 2022-05-13 Moody South Dakota 46101 1386 28
2502095 2502095 2022-05-13 Oglala Lakota South Dakota 46102 3952 62
2502096 2502096 2022-05-13 Pennington South Dakota 46103 32903 342
2502097 2502097 2022-05-13 Perkins South Dakota 46105 684 18
2502098 2502098 2022-05-13 Potter South Dakota 46107 703 7
2502099 2502099 2022-05-13 Roberts South Dakota 46109 2436 53
2502100 2502100 2022-05-13 Sanborn South Dakota 46111 575 6
2502101 2502101 2022-05-13 Spink South Dakota 46115 1418 36
2502102 2502102 2022-05-13 Stanley South Dakota 46117 637 7
2502103 2502103 2022-05-13 Sully South Dakota 46119 245 3
2502104 2502104 2022-05-13 Todd South Dakota 46121 2975 53
2502105 2502105 2022-05-13 Tripp South Dakota 46123 1382 24
2502106 2502106 2022-05-13 Turner South Dakota 46125 1969 62
2502107 2502107 2022-05-13 Union South Dakota 46127 4026 52
2502108 2502108 2022-05-13 Walworth South Dakota 46129 1315 26
2502109 2502109 2022-05-13 Yankton South Dakota 46135 5929 59
2502110 2502110 2022-05-13 Ziebach South Dakota 46137 664 11
2498787 2498787 2022-05-12 Aurora South Dakota 46003 805 17
2498788 2498788 2022-05-12 Beadle South Dakota 46005 4596 60
2498789 2498789 2022-05-12 Bennett South Dakota 46007 789 14
2498790 2498790 2022-05-12 Bon Homme South Dakota 46009 2292 39
2498791 2498791 2022-05-12 Brookings South Dakota 46011 8149 52
2498792 2498792 2022-05-12 Brown South Dakota 46013 10344 121
2498793 2498793 2022-05-12 Brule South Dakota 46015 1415 20
2498794 2498794 2022-05-12 Buffalo South Dakota 46017 620 18
2498795 2498795 2022-05-12 Butte South Dakota 46019 2757 45
2498796 2498796 2022-05-12 Campbell South Dakota 46021 268 7
2498797 2498797 2022-05-12 Charles Mix South Dakota 46023 2942 35
2498798 2498798 2022-05-12 Clark South Dakota 46025 804 9
2498799 2498799 2022-05-12 Clay South Dakota 46027 3493 21
2498800 2498800 2022-05-12 Codington South Dakota 46029 8474 101
2498801 2498801 2022-05-12 Corson South Dakota 46031 1070 17
2498802 2498802 2022-05-12 Custer South Dakota 46033 2034 26
2498803 2498803 2022-05-12 Davison South Dakota 46035 5907 80
2498804 2498804 2022-05-12 Day South Dakota 46037 1295 35
2498805 2498805 2022-05-12 Deuel South Dakota 46039 1043 12
2498806 2498806 2022-05-12 Dewey South Dakota 46041 3139 44
2498807 2498807 2022-05-12 Douglas South Dakota 46043 684 16
2498808 2498808 2022-05-12 Edmunds South Dakota 46045 949 16
2498809 2498809 2022-05-12 Fall River South Dakota 46047 1807 39
2498810 2498810 2022-05-12 Faulk South Dakota 46049 572 16
2498811 2498811 2022-05-12 Grant South Dakota 46051 2047 51
2498812 2498812 2022-05-12 Gregory South Dakota 46053 1065 34
2498813 2498813 2022-05-12 Haakon South Dakota 46055 452 12
2498814 2498814 2022-05-12 Hamlin South Dakota 46057 1508 41
2498815 2498815 2022-05-12 Hand South Dakota 46059 562 12
2498816 2498816 2022-05-12 Hanson South Dakota 46061 655 6
2498817 2498817 2022-05-12 Harding South Dakota 46063 201 3
2498818 2498818 2022-05-12 Hughes South Dakota 46065 4335 58
2498819 2498819 2022-05-12 Hutchinson South Dakota 46067 1733 36
2498820 2498820 2022-05-12 Hyde South Dakota 46069 307 8

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [ny_times_us_counties] (
   [date] TEXT,
   [county] TEXT,
   [state] TEXT,
   [fips] INTEGER,
   [cases] INTEGER,
   [deaths] INTEGER
);
CREATE INDEX [idx_ny_times_us_counties_state]
    ON [ny_times_us_counties] ([state]);
CREATE INDEX [idx_ny_times_us_counties_county]
    ON [ny_times_us_counties] ([county]);
CREATE INDEX [idx_ny_times_us_counties_fips]
    ON [ny_times_us_counties] ([fips]);
CREATE INDEX [idx_ny_times_us_counties_date]
    ON [ny_times_us_counties] ([date] desc);