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 county descending
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 |
---|---|---|---|---|---|---|---|
120624 | 120624 | 2020-05-06 | Ziebach | South Dakota | 46137 | 1 | 0 |
123602 | 123602 | 2020-05-07 | Ziebach | South Dakota | 46137 | 1 | 0 |
126585 | 126585 | 2020-05-08 | Ziebach | South Dakota | 46137 | 1 | 0 |
129574 | 129574 | 2020-05-09 | Ziebach | South Dakota | 46137 | 1 | 0 |
132563 | 132563 | 2020-05-10 | Ziebach | South Dakota | 46137 | 1 | 0 |
135554 | 135554 | 2020-05-11 | Ziebach | South Dakota | 46137 | 1 | 0 |
138544 | 138544 | 2020-05-12 | Ziebach | South Dakota | 46137 | 1 | 0 |
141540 | 141540 | 2020-05-13 | Ziebach | South Dakota | 46137 | 1 | 0 |
144537 | 144537 | 2020-05-14 | Ziebach | South Dakota | 46137 | 1 | 0 |
147538 | 147538 | 2020-05-15 | Ziebach | South Dakota | 46137 | 1 | 0 |
150546 | 150546 | 2020-05-16 | Ziebach | South Dakota | 46137 | 1 | 0 |
153557 | 153557 | 2020-05-17 | Ziebach | South Dakota | 46137 | 1 | 0 |
156574 | 156574 | 2020-05-18 | Ziebach | South Dakota | 46137 | 1 | 0 |
159595 | 159595 | 2020-05-19 | Ziebach | South Dakota | 46137 | 1 | 0 |
162622 | 162622 | 2020-05-20 | Ziebach | South Dakota | 46137 | 1 | 0 |
165651 | 165651 | 2020-05-21 | Ziebach | South Dakota | 46137 | 1 | 0 |
168687 | 168687 | 2020-05-22 | Ziebach | South Dakota | 46137 | 1 | 0 |
171726 | 171726 | 2020-05-23 | Ziebach | South Dakota | 46137 | 1 | 0 |
174769 | 174769 | 2020-05-24 | Ziebach | South Dakota | 46137 | 1 | 0 |
177813 | 177813 | 2020-05-25 | Ziebach | South Dakota | 46137 | 1 | 0 |
180856 | 180856 | 2020-05-26 | Ziebach | South Dakota | 46137 | 1 | 0 |
183906 | 183906 | 2020-05-27 | Ziebach | South Dakota | 46137 | 1 | 0 |
186963 | 186963 | 2020-05-28 | Ziebach | South Dakota | 46137 | 1 | 0 |
190027 | 190027 | 2020-05-29 | Ziebach | South Dakota | 46137 | 1 | 0 |
193092 | 193092 | 2020-05-30 | Ziebach | South Dakota | 46137 | 1 | 0 |
196162 | 196162 | 2020-05-31 | Ziebach | South Dakota | 46137 | 1 | 0 |
199235 | 199235 | 2020-06-01 | Ziebach | South Dakota | 46137 | 1 | 0 |
202310 | 202310 | 2020-06-02 | Ziebach | South Dakota | 46137 | 1 | 0 |
205389 | 205389 | 2020-06-03 | Ziebach | South Dakota | 46137 | 1 | 0 |
208471 | 208471 | 2020-06-04 | Ziebach | South Dakota | 46137 | 2 | 0 |
211553 | 211553 | 2020-06-05 | Ziebach | South Dakota | 46137 | 2 | 0 |
214640 | 214640 | 2020-06-06 | Ziebach | South Dakota | 46137 | 2 | 0 |
217730 | 217730 | 2020-06-07 | Ziebach | South Dakota | 46137 | 2 | 0 |
220822 | 220822 | 2020-06-08 | Ziebach | South Dakota | 46137 | 2 | 0 |
223917 | 223917 | 2020-06-09 | Ziebach | South Dakota | 46137 | 2 | 0 |
227017 | 227017 | 2020-06-10 | Ziebach | South Dakota | 46137 | 2 | 0 |
230121 | 230121 | 2020-06-11 | Ziebach | South Dakota | 46137 | 2 | 0 |
233226 | 233226 | 2020-06-12 | Ziebach | South Dakota | 46137 | 2 | 0 |
236332 | 236332 | 2020-06-13 | Ziebach | South Dakota | 46137 | 2 | 0 |
239440 | 239440 | 2020-06-14 | Ziebach | South Dakota | 46137 | 2 | 0 |
242550 | 242550 | 2020-06-15 | Ziebach | South Dakota | 46137 | 2 | 0 |
245662 | 245662 | 2020-06-16 | Ziebach | South Dakota | 46137 | 2 | 0 |
248775 | 248775 | 2020-06-17 | Ziebach | South Dakota | 46137 | 2 | 0 |
251890 | 251890 | 2020-06-18 | Ziebach | South Dakota | 46137 | 2 | 0 |
255005 | 255005 | 2020-06-19 | Ziebach | South Dakota | 46137 | 2 | 0 |
258131 | 258131 | 2020-06-20 | Ziebach | South Dakota | 46137 | 2 | 0 |
261258 | 261258 | 2020-06-21 | Ziebach | South Dakota | 46137 | 2 | 0 |
264386 | 264386 | 2020-06-22 | Ziebach | South Dakota | 46137 | 2 | 0 |
267514 | 267514 | 2020-06-23 | Ziebach | South Dakota | 46137 | 2 | 0 |
270648 | 270648 | 2020-06-24 | Ziebach | South Dakota | 46137 | 2 | 0 |
273787 | 273787 | 2020-06-25 | Ziebach | South Dakota | 46137 | 2 | 0 |
276934 | 276934 | 2020-06-26 | Ziebach | South Dakota | 46137 | 2 | 0 |
280082 | 280082 | 2020-06-27 | Ziebach | South Dakota | 46137 | 2 | 0 |
283228 | 283228 | 2020-06-28 | Ziebach | South Dakota | 46137 | 3 | 0 |
286373 | 286373 | 2020-06-29 | Ziebach | South Dakota | 46137 | 3 | 0 |
289524 | 289524 | 2020-06-30 | Ziebach | South Dakota | 46137 | 2 | 0 |
292676 | 292676 | 2020-07-01 | Ziebach | South Dakota | 46137 | 2 | 0 |
295832 | 295832 | 2020-07-02 | Ziebach | South Dakota | 46137 | 1 | 0 |
298992 | 298992 | 2020-07-03 | Ziebach | South Dakota | 46137 | 1 | 0 |
302156 | 302156 | 2020-07-04 | Ziebach | South Dakota | 46137 | 1 | 0 |
305319 | 305319 | 2020-07-05 | Ziebach | South Dakota | 46137 | 1 | 0 |
308487 | 308487 | 2020-07-06 | Ziebach | South Dakota | 46137 | 1 | 0 |
311656 | 311656 | 2020-07-07 | Ziebach | South Dakota | 46137 | 1 | 0 |
314830 | 314830 | 2020-07-08 | Ziebach | South Dakota | 46137 | 1 | 0 |
318003 | 318003 | 2020-07-09 | Ziebach | South Dakota | 46137 | 2 | 0 |
321181 | 321181 | 2020-07-10 | Ziebach | South Dakota | 46137 | 3 | 0 |
324362 | 324362 | 2020-07-11 | Ziebach | South Dakota | 46137 | 3 | 0 |
327547 | 327547 | 2020-07-12 | Ziebach | South Dakota | 46137 | 3 | 0 |
330733 | 330733 | 2020-07-13 | Ziebach | South Dakota | 46137 | 3 | 0 |
333925 | 333925 | 2020-07-14 | Ziebach | South Dakota | 46137 | 3 | 0 |
337119 | 337119 | 2020-07-15 | Ziebach | South Dakota | 46137 | 3 | 0 |
340316 | 340316 | 2020-07-16 | Ziebach | South Dakota | 46137 | 3 | 0 |
343514 | 343514 | 2020-07-17 | Ziebach | South Dakota | 46137 | 3 | 0 |
346714 | 346714 | 2020-07-18 | Ziebach | South Dakota | 46137 | 3 | 0 |
349914 | 349914 | 2020-07-19 | Ziebach | South Dakota | 46137 | 3 | 0 |
353117 | 353117 | 2020-07-20 | Ziebach | South Dakota | 46137 | 3 | 0 |
356320 | 356320 | 2020-07-21 | Ziebach | South Dakota | 46137 | 3 | 0 |
359524 | 359524 | 2020-07-22 | Ziebach | South Dakota | 46137 | 3 | 0 |
362731 | 362731 | 2020-07-23 | Ziebach | South Dakota | 46137 | 3 | 0 |
365937 | 365937 | 2020-07-24 | Ziebach | South Dakota | 46137 | 3 | 0 |
369146 | 369146 | 2020-07-25 | Ziebach | South Dakota | 46137 | 7 | 0 |
372358 | 372358 | 2020-07-26 | Ziebach | South Dakota | 46137 | 7 | 0 |
375571 | 375571 | 2020-07-27 | Ziebach | South Dakota | 46137 | 7 | 0 |
378787 | 378787 | 2020-07-28 | Ziebach | South Dakota | 46137 | 7 | 0 |
382004 | 382004 | 2020-07-29 | Ziebach | South Dakota | 46137 | 8 | 0 |
385222 | 385222 | 2020-07-30 | Ziebach | South Dakota | 46137 | 8 | 0 |
388439 | 388439 | 2020-07-31 | Ziebach | South Dakota | 46137 | 8 | 0 |
391656 | 391656 | 2020-08-01 | Ziebach | South Dakota | 46137 | 8 | 0 |
394872 | 394872 | 2020-08-02 | Ziebach | South Dakota | 46137 | 8 | 0 |
398089 | 398089 | 2020-08-03 | Ziebach | South Dakota | 46137 | 8 | 0 |
401304 | 401304 | 2020-08-04 | Ziebach | South Dakota | 46137 | 8 | 0 |
404522 | 404522 | 2020-08-05 | Ziebach | South Dakota | 46137 | 9 | 0 |
407742 | 407742 | 2020-08-06 | Ziebach | South Dakota | 46137 | 10 | 0 |
410961 | 410961 | 2020-08-07 | Ziebach | South Dakota | 46137 | 33 | 0 |
414181 | 414181 | 2020-08-08 | Ziebach | South Dakota | 46137 | 34 | 0 |
417402 | 417402 | 2020-08-09 | Ziebach | South Dakota | 46137 | 35 | 0 |
420623 | 420623 | 2020-08-10 | Ziebach | South Dakota | 46137 | 35 | 0 |
423845 | 423845 | 2020-08-11 | Ziebach | South Dakota | 46137 | 35 | 0 |
427068 | 427068 | 2020-08-12 | Ziebach | South Dakota | 46137 | 35 | 0 |
430295 | 430295 | 2020-08-13 | Ziebach | South Dakota | 46137 | 35 | 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);