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 fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
- 46005 795
- 46023 795
- 46035 795
- 46099 795
- 46009 794
- 46087 792
- 46013 783
- 46029 782
- 46065 782
- 46085 782
- 46103 782
- 46011 781
- 46083 780
- 46093 780
- 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
- …
county >30
- Beadle 795
- Charles Mix 795
- Davison 795
- Minnehaha 795
- Bon Homme 794
- McCook 792
- Brown 783
- Codington 782
- Hughes 782
- Lyman 782
- Pennington 782
- Brookings 781
- Lincoln 780
- Meade 780
- 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,552 ✖
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
15413 | 15413 | 2020-03-27 | Aurora | South Dakota | 46003 | 1 | 0 |
17268 | 17268 | 2020-03-28 | Aurora | South Dakota | 46003 | 1 | 0 |
19208 | 19208 | 2020-03-29 | Aurora | South Dakota | 46003 | 1 | 0 |
21260 | 21260 | 2020-03-30 | Aurora | South Dakota | 46003 | 1 | 0 |
23398 | 23398 | 2020-03-31 | Aurora | South Dakota | 46003 | 1 | 0 |
25596 | 25596 | 2020-04-01 | Aurora | South Dakota | 46003 | 1 | 0 |
27872 | 27872 | 2020-04-02 | Aurora | South Dakota | 46003 | 1 | 0 |
30207 | 30207 | 2020-04-03 | Aurora | South Dakota | 46003 | 1 | 0 |
32598 | 32598 | 2020-04-04 | Aurora | South Dakota | 46003 | 1 | 0 |
35034 | 35034 | 2020-04-05 | Aurora | South Dakota | 46003 | 1 | 0 |
37509 | 37509 | 2020-04-06 | Aurora | South Dakota | 46003 | 1 | 0 |
40032 | 40032 | 2020-04-07 | Aurora | South Dakota | 46003 | 1 | 0 |
42592 | 42592 | 2020-04-08 | Aurora | South Dakota | 46003 | 1 | 0 |
45178 | 45178 | 2020-04-09 | Aurora | South Dakota | 46003 | 1 | 0 |
47795 | 47795 | 2020-04-10 | Aurora | South Dakota | 46003 | 1 | 0 |
50452 | 50452 | 2020-04-11 | Aurora | South Dakota | 46003 | 1 | 0 |
53125 | 53125 | 2020-04-12 | Aurora | South Dakota | 46003 | 1 | 0 |
55810 | 55810 | 2020-04-13 | Aurora | South Dakota | 46003 | 1 | 0 |
58513 | 58513 | 2020-04-14 | Aurora | South Dakota | 46003 | 1 | 0 |
61228 | 61228 | 2020-04-15 | Aurora | South Dakota | 46003 | 1 | 0 |
63954 | 63954 | 2020-04-16 | Aurora | South Dakota | 46003 | 1 | 0 |
66700 | 66700 | 2020-04-17 | Aurora | South Dakota | 46003 | 1 | 0 |
69458 | 69458 | 2020-04-18 | Aurora | South Dakota | 46003 | 1 | 0 |
72225 | 72225 | 2020-04-19 | Aurora | South Dakota | 46003 | 1 | 0 |
75000 | 75000 | 2020-04-20 | Aurora | South Dakota | 46003 | 1 | 0 |
77782 | 77782 | 2020-04-21 | Aurora | South Dakota | 46003 | 1 | 0 |
80572 | 80572 | 2020-04-22 | Aurora | South Dakota | 46003 | 1 | 0 |
83371 | 83371 | 2020-04-23 | Aurora | South Dakota | 46003 | 1 | 0 |
86175 | 86175 | 2020-04-24 | Aurora | South Dakota | 46003 | 1 | 0 |
88989 | 88989 | 2020-04-25 | Aurora | South Dakota | 46003 | 1 | 0 |
91805 | 91805 | 2020-04-26 | Aurora | South Dakota | 46003 | 1 | 0 |
94632 | 94632 | 2020-04-27 | Aurora | South Dakota | 46003 | 1 | 0 |
97471 | 97471 | 2020-04-28 | Aurora | South Dakota | 46003 | 1 | 0 |
100320 | 100320 | 2020-04-29 | Aurora | South Dakota | 46003 | 1 | 0 |
103173 | 103173 | 2020-04-30 | Aurora | South Dakota | 46003 | 1 | 0 |
106036 | 106036 | 2020-05-01 | Aurora | South Dakota | 46003 | 1 | 0 |
108903 | 108903 | 2020-05-02 | Aurora | South Dakota | 46003 | 1 | 0 |
111777 | 111777 | 2020-05-03 | Aurora | South Dakota | 46003 | 1 | 0 |
114659 | 114659 | 2020-05-04 | Aurora | South Dakota | 46003 | 1 | 0 |
117615 | 117615 | 2020-05-05 | Aurora | South Dakota | 46003 | 1 | 0 |
120577 | 120577 | 2020-05-06 | Aurora | South Dakota | 46003 | 1 | 0 |
123555 | 123555 | 2020-05-07 | Aurora | South Dakota | 46003 | 1 | 0 |
126538 | 126538 | 2020-05-08 | Aurora | South Dakota | 46003 | 1 | 0 |
129527 | 129527 | 2020-05-09 | Aurora | South Dakota | 46003 | 1 | 0 |
132516 | 132516 | 2020-05-10 | Aurora | South Dakota | 46003 | 2 | 0 |
135507 | 135507 | 2020-05-11 | Aurora | South Dakota | 46003 | 2 | 0 |
138497 | 138497 | 2020-05-12 | Aurora | South Dakota | 46003 | 2 | 0 |
141493 | 141493 | 2020-05-13 | Aurora | South Dakota | 46003 | 2 | 0 |
144489 | 144489 | 2020-05-14 | Aurora | South Dakota | 46003 | 2 | 0 |
147490 | 147490 | 2020-05-15 | Aurora | South Dakota | 46003 | 2 | 0 |
150498 | 150498 | 2020-05-16 | Aurora | South Dakota | 46003 | 2 | 0 |
153509 | 153509 | 2020-05-17 | Aurora | South Dakota | 46003 | 3 | 0 |
156526 | 156526 | 2020-05-18 | Aurora | South Dakota | 46003 | 3 | 0 |
159547 | 159547 | 2020-05-19 | Aurora | South Dakota | 46003 | 3 | 0 |
162574 | 162574 | 2020-05-20 | Aurora | South Dakota | 46003 | 8 | 0 |
165603 | 165603 | 2020-05-21 | Aurora | South Dakota | 46003 | 8 | 0 |
168639 | 168639 | 2020-05-22 | Aurora | South Dakota | 46003 | 20 | 0 |
171678 | 171678 | 2020-05-23 | Aurora | South Dakota | 46003 | 22 | 0 |
174720 | 174720 | 2020-05-24 | Aurora | South Dakota | 46003 | 22 | 0 |
177764 | 177764 | 2020-05-25 | Aurora | South Dakota | 46003 | 22 | 0 |
180807 | 180807 | 2020-05-26 | Aurora | South Dakota | 46003 | 22 | 0 |
183857 | 183857 | 2020-05-27 | Aurora | South Dakota | 46003 | 22 | 0 |
186914 | 186914 | 2020-05-28 | Aurora | South Dakota | 46003 | 23 | 0 |
189976 | 189976 | 2020-05-29 | Aurora | South Dakota | 46003 | 23 | 0 |
193041 | 193041 | 2020-05-30 | Aurora | South Dakota | 46003 | 25 | 0 |
196110 | 196110 | 2020-05-31 | Aurora | South Dakota | 46003 | 26 | 0 |
199183 | 199183 | 2020-06-01 | Aurora | South Dakota | 46003 | 26 | 0 |
202258 | 202258 | 2020-06-02 | Aurora | South Dakota | 46003 | 26 | 0 |
205335 | 205335 | 2020-06-03 | Aurora | South Dakota | 46003 | 27 | 0 |
208416 | 208416 | 2020-06-04 | Aurora | South Dakota | 46003 | 27 | 0 |
211498 | 211498 | 2020-06-05 | Aurora | South Dakota | 46003 | 27 | 0 |
214584 | 214584 | 2020-06-06 | Aurora | South Dakota | 46003 | 29 | 0 |
217674 | 217674 | 2020-06-07 | Aurora | South Dakota | 46003 | 29 | 0 |
220766 | 220766 | 2020-06-08 | Aurora | South Dakota | 46003 | 29 | 0 |
223861 | 223861 | 2020-06-09 | Aurora | South Dakota | 46003 | 29 | 0 |
226961 | 226961 | 2020-06-10 | Aurora | South Dakota | 46003 | 29 | 0 |
230065 | 230065 | 2020-06-11 | Aurora | South Dakota | 46003 | 29 | 0 |
233170 | 233170 | 2020-06-12 | Aurora | South Dakota | 46003 | 30 | 0 |
236275 | 236275 | 2020-06-13 | Aurora | South Dakota | 46003 | 33 | 0 |
239383 | 239383 | 2020-06-14 | Aurora | South Dakota | 46003 | 33 | 0 |
242492 | 242492 | 2020-06-15 | Aurora | South Dakota | 46003 | 33 | 0 |
245604 | 245604 | 2020-06-16 | Aurora | South Dakota | 46003 | 33 | 0 |
248717 | 248717 | 2020-06-17 | Aurora | South Dakota | 46003 | 33 | 0 |
251832 | 251832 | 2020-06-18 | Aurora | South Dakota | 46003 | 33 | 0 |
254947 | 254947 | 2020-06-19 | Aurora | South Dakota | 46003 | 34 | 0 |
258073 | 258073 | 2020-06-20 | Aurora | South Dakota | 46003 | 34 | 0 |
261200 | 261200 | 2020-06-21 | Aurora | South Dakota | 46003 | 34 | 0 |
264328 | 264328 | 2020-06-22 | Aurora | South Dakota | 46003 | 34 | 0 |
267456 | 267456 | 2020-06-23 | Aurora | South Dakota | 46003 | 34 | 0 |
270590 | 270590 | 2020-06-24 | Aurora | South Dakota | 46003 | 34 | 0 |
273729 | 273729 | 2020-06-25 | Aurora | South Dakota | 46003 | 34 | 0 |
276876 | 276876 | 2020-06-26 | Aurora | South Dakota | 46003 | 34 | 0 |
280024 | 280024 | 2020-06-27 | Aurora | South Dakota | 46003 | 34 | 0 |
283170 | 283170 | 2020-06-28 | Aurora | South Dakota | 46003 | 34 | 0 |
286315 | 286315 | 2020-06-29 | Aurora | South Dakota | 46003 | 34 | 0 |
289466 | 289466 | 2020-06-30 | Aurora | South Dakota | 46003 | 34 | 0 |
292618 | 292618 | 2020-07-01 | Aurora | South Dakota | 46003 | 34 | 0 |
295774 | 295774 | 2020-07-02 | Aurora | South Dakota | 46003 | 34 | 0 |
298933 | 298933 | 2020-07-03 | Aurora | South Dakota | 46003 | 34 | 0 |
302097 | 302097 | 2020-07-04 | Aurora | South Dakota | 46003 | 34 | 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);