ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
49,552 rows where state = "South Dakota" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
- 46011 780
- 46013 780
- 46023 780
- 46029 780
- 46035 780
- 46065 780
- 46083 780
- 46085 780
- 46087 780
- 46093 780
- 46099 780
- 46103 780
- 46005 779
- 46009 779
- 46003 778
- 46049 778
- 46081 778
- 46121 778
- 46127 778
- 46039 777
- 46057 777
- 46067 777
- 46135 777
- 46025 776
- 46027 776
- 46047 776
- 46109 776
- 46125 776
- 46091 775
- 46079 772
- …
date (date) >30 ✖
- 2020-08-25 67
- 2020-08-26 67
- 2020-08-13 66
- 2020-08-14 66
- 2020-08-15 66
- 2020-08-16 66
- 2020-08-17 66
- 2020-08-18 66
- 2020-08-19 66
- 2020-08-20 66
- 2020-08-21 66
- 2020-08-22 66
- 2020-08-23 66
- 2020-08-24 66
- 2020-08-27 66
- 2020-08-28 66
- 2020-08-29 66
- 2020-08-30 66
- 2020-08-31 66
- 2020-09-01 66
- 2020-09-02 66
- 2020-09-03 66
- 2020-09-04 66
- 2020-09-05 66
- 2020-09-06 66
- 2020-09-07 66
- 2020-09-08 66
- 2020-09-09 66
- 2020-09-10 66
- 2020-09-11 66
- …
county >30
- Brookings 780
- Brown 780
- Charles Mix 780
- Codington 780
- Davison 780
- Hughes 780
- Lincoln 780
- Lyman 780
- McCook 780
- Meade 780
- Minnehaha 780
- Pennington 780
- Beadle 779
- Bon Homme 779
- Aurora 778
- Faulk 778
- Lawrence 778
- Todd 778
- Union 778
- Deuel 777
- Hamlin 777
- Hutchinson 777
- Yankton 777
- Clark 776
- Clay 776
- Fall River 776
- Roberts 776
- Turner 776
- Marshall 775
- Lake 772
- …
state 1
- South Dakota · 49,452 ✖
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
12046 | 12046 | 2020-03-25 | Brookings | South Dakota | 46011 | 1 | 0 |
12047 | 12047 | 2020-03-25 | Brown | South Dakota | 46013 | 2 | 0 |
12048 | 12048 | 2020-03-25 | Charles Mix | South Dakota | 46023 | 1 | 0 |
12049 | 12049 | 2020-03-25 | Codington | South Dakota | 46029 | 1 | 0 |
12050 | 12050 | 2020-03-25 | Davison | South Dakota | 46035 | 2 | 1 |
12051 | 12051 | 2020-03-25 | Hughes | South Dakota | 46065 | 1 | 0 |
12052 | 12052 | 2020-03-25 | Lincoln | South Dakota | 46083 | 1 | 0 |
12053 | 12053 | 2020-03-25 | Lyman | South Dakota | 46085 | 1 | 0 |
12054 | 12054 | 2020-03-25 | McCook | South Dakota | 46087 | 2 | 0 |
12055 | 12055 | 2020-03-25 | Meade | South Dakota | 46093 | 1 | 0 |
12056 | 12056 | 2020-03-25 | Minnehaha | South Dakota | 46099 | 13 | 0 |
12057 | 12057 | 2020-03-25 | Pennington | South Dakota | 46103 | 1 | 0 |
13666 | 13666 | 2020-03-26 | Beadle | South Dakota | 46005 | 14 | 0 |
13667 | 13667 | 2020-03-26 | Bon Homme | South Dakota | 46009 | 1 | 0 |
13668 | 13668 | 2020-03-26 | Brookings | South Dakota | 46011 | 1 | 0 |
13669 | 13669 | 2020-03-26 | Brown | South Dakota | 46013 | 2 | 0 |
13670 | 13670 | 2020-03-26 | Charles Mix | South Dakota | 46023 | 1 | 0 |
13671 | 13671 | 2020-03-26 | Codington | South Dakota | 46029 | 1 | 0 |
13672 | 13672 | 2020-03-26 | Davison | South Dakota | 46035 | 2 | 1 |
13673 | 13673 | 2020-03-26 | Hughes | South Dakota | 46065 | 1 | 0 |
13674 | 13674 | 2020-03-26 | Lincoln | South Dakota | 46083 | 2 | 0 |
13675 | 13675 | 2020-03-26 | Lyman | South Dakota | 46085 | 1 | 0 |
13676 | 13676 | 2020-03-26 | McCook | South Dakota | 46087 | 2 | 0 |
13677 | 13677 | 2020-03-26 | Meade | South Dakota | 46093 | 1 | 0 |
13678 | 13678 | 2020-03-26 | Minnehaha | South Dakota | 46099 | 16 | 0 |
13679 | 13679 | 2020-03-26 | Pennington | South Dakota | 46103 | 1 | 0 |
15413 | 15413 | 2020-03-27 | Aurora | South Dakota | 46003 | 1 | 0 |
15414 | 15414 | 2020-03-27 | Beadle | South Dakota | 46005 | 16 | 0 |
15415 | 15415 | 2020-03-27 | Bon Homme | South Dakota | 46009 | 1 | 0 |
15416 | 15416 | 2020-03-27 | Brookings | South Dakota | 46011 | 1 | 0 |
15417 | 15417 | 2020-03-27 | Brown | South Dakota | 46013 | 2 | 0 |
15418 | 15418 | 2020-03-27 | Charles Mix | South Dakota | 46023 | 1 | 0 |
15419 | 15419 | 2020-03-27 | Codington | South Dakota | 46029 | 1 | 0 |
15420 | 15420 | 2020-03-27 | Davison | South Dakota | 46035 | 2 | 1 |
15421 | 15421 | 2020-03-27 | Faulk | South Dakota | 46049 | 1 | 0 |
15422 | 15422 | 2020-03-27 | Hughes | South Dakota | 46065 | 1 | 0 |
15423 | 15423 | 2020-03-27 | Lawrence | South Dakota | 46081 | 2 | 0 |
15424 | 15424 | 2020-03-27 | Lincoln | South Dakota | 46083 | 2 | 0 |
15425 | 15425 | 2020-03-27 | Lyman | South Dakota | 46085 | 1 | 0 |
15426 | 15426 | 2020-03-27 | McCook | South Dakota | 46087 | 2 | 0 |
15427 | 15427 | 2020-03-27 | Meade | South Dakota | 46093 | 1 | 0 |
15428 | 15428 | 2020-03-27 | Minnehaha | South Dakota | 46099 | 18 | 0 |
15429 | 15429 | 2020-03-27 | Pennington | South Dakota | 46103 | 3 | 0 |
15430 | 15430 | 2020-03-27 | Todd | South Dakota | 46121 | 1 | 0 |
15431 | 15431 | 2020-03-27 | Union | South Dakota | 46127 | 1 | 0 |
17268 | 17268 | 2020-03-28 | Aurora | South Dakota | 46003 | 1 | 0 |
17269 | 17269 | 2020-03-28 | Beadle | South Dakota | 46005 | 16 | 0 |
17270 | 17270 | 2020-03-28 | Bon Homme | South Dakota | 46009 | 1 | 0 |
17271 | 17271 | 2020-03-28 | Brookings | South Dakota | 46011 | 1 | 0 |
17272 | 17272 | 2020-03-28 | Brown | South Dakota | 46013 | 2 | 0 |
17273 | 17273 | 2020-03-28 | Charles Mix | South Dakota | 46023 | 1 | 0 |
17274 | 17274 | 2020-03-28 | Codington | South Dakota | 46029 | 2 | 0 |
17275 | 17275 | 2020-03-28 | Davison | South Dakota | 46035 | 2 | 1 |
17276 | 17276 | 2020-03-28 | Deuel | South Dakota | 46039 | 1 | 0 |
17277 | 17277 | 2020-03-28 | Faulk | South Dakota | 46049 | 1 | 0 |
17278 | 17278 | 2020-03-28 | Hamlin | South Dakota | 46057 | 1 | 0 |
17279 | 17279 | 2020-03-28 | Hughes | South Dakota | 46065 | 1 | 0 |
17280 | 17280 | 2020-03-28 | Hutchinson | South Dakota | 46067 | 2 | 0 |
17281 | 17281 | 2020-03-28 | Lawrence | South Dakota | 46081 | 2 | 0 |
17282 | 17282 | 2020-03-28 | Lincoln | South Dakota | 46083 | 3 | 0 |
17283 | 17283 | 2020-03-28 | Lyman | South Dakota | 46085 | 1 | 0 |
17284 | 17284 | 2020-03-28 | McCook | South Dakota | 46087 | 2 | 0 |
17285 | 17285 | 2020-03-28 | Meade | South Dakota | 46093 | 1 | 0 |
17286 | 17286 | 2020-03-28 | Minnehaha | South Dakota | 46099 | 21 | 0 |
17287 | 17287 | 2020-03-28 | Pennington | South Dakota | 46103 | 3 | 0 |
17288 | 17288 | 2020-03-28 | Todd | South Dakota | 46121 | 1 | 0 |
17289 | 17289 | 2020-03-28 | Union | South Dakota | 46127 | 1 | 0 |
17290 | 17290 | 2020-03-28 | Yankton | South Dakota | 46135 | 1 | 0 |
19208 | 19208 | 2020-03-29 | Aurora | South Dakota | 46003 | 1 | 0 |
19209 | 19209 | 2020-03-29 | Beadle | South Dakota | 46005 | 20 | 0 |
19210 | 19210 | 2020-03-29 | Bon Homme | South Dakota | 46009 | 1 | 0 |
19211 | 19211 | 2020-03-29 | Brookings | South Dakota | 46011 | 1 | 0 |
19212 | 19212 | 2020-03-29 | Brown | South Dakota | 46013 | 2 | 0 |
19213 | 19213 | 2020-03-29 | Charles Mix | South Dakota | 46023 | 1 | 0 |
19214 | 19214 | 2020-03-29 | Clark | South Dakota | 46025 | 1 | 0 |
19215 | 19215 | 2020-03-29 | Clay | South Dakota | 46027 | 2 | 0 |
19216 | 19216 | 2020-03-29 | Codington | South Dakota | 46029 | 4 | 0 |
19217 | 19217 | 2020-03-29 | Davison | South Dakota | 46035 | 2 | 1 |
19218 | 19218 | 2020-03-29 | Deuel | South Dakota | 46039 | 1 | 0 |
19219 | 19219 | 2020-03-29 | Fall River | South Dakota | 46047 | 1 | 0 |
19220 | 19220 | 2020-03-29 | Faulk | South Dakota | 46049 | 1 | 0 |
19221 | 19221 | 2020-03-29 | Hamlin | South Dakota | 46057 | 1 | 0 |
19222 | 19222 | 2020-03-29 | Hughes | South Dakota | 46065 | 1 | 0 |
19223 | 19223 | 2020-03-29 | Hutchinson | South Dakota | 46067 | 2 | 0 |
19224 | 19224 | 2020-03-29 | Lawrence | South Dakota | 46081 | 3 | 0 |
19225 | 19225 | 2020-03-29 | Lincoln | South Dakota | 46083 | 4 | 0 |
19226 | 19226 | 2020-03-29 | Lyman | South Dakota | 46085 | 1 | 0 |
19227 | 19227 | 2020-03-29 | McCook | South Dakota | 46087 | 2 | 0 |
19228 | 19228 | 2020-03-29 | Meade | South Dakota | 46093 | 1 | 0 |
19229 | 19229 | 2020-03-29 | Minnehaha | South Dakota | 46099 | 25 | 0 |
19230 | 19230 | 2020-03-29 | Pennington | South Dakota | 46103 | 4 | 0 |
19231 | 19231 | 2020-03-29 | Roberts | South Dakota | 46109 | 1 | 0 |
19232 | 19232 | 2020-03-29 | Todd | South Dakota | 46121 | 1 | 0 |
19233 | 19233 | 2020-03-29 | Turner | South Dakota | 46125 | 1 | 0 |
19234 | 19234 | 2020-03-29 | Union | South Dakota | 46127 | 1 | 0 |
19235 | 19235 | 2020-03-29 | Yankton | South Dakota | 46135 | 4 | 0 |
21260 | 21260 | 2020-03-30 | Aurora | South Dakota | 46003 | 1 | 0 |
21261 | 21261 | 2020-03-30 | Beadle | South Dakota | 46005 | 20 | 0 |
21262 | 21262 | 2020-03-30 | Bon Homme | South Dakota | 46009 | 1 | 0 |
21263 | 21263 | 2020-03-30 | Brookings | South Dakota | 46011 | 1 | 0 |
Advanced export
JSON shape: default, array, newline-delimited
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);