ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
709 rows where county = "Custer" and state = "South Dakota" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
208428 | 208428 | 2020-06-04 | Custer | South Dakota | 46033 | 1 | 0 |
211510 | 211510 | 2020-06-05 | Custer | South Dakota | 46033 | 1 | 0 |
214596 | 214596 | 2020-06-06 | Custer | South Dakota | 46033 | 1 | 0 |
217686 | 217686 | 2020-06-07 | Custer | South Dakota | 46033 | 1 | 0 |
220778 | 220778 | 2020-06-08 | Custer | South Dakota | 46033 | 1 | 0 |
223873 | 223873 | 2020-06-09 | Custer | South Dakota | 46033 | 1 | 0 |
226973 | 226973 | 2020-06-10 | Custer | South Dakota | 46033 | 1 | 0 |
230077 | 230077 | 2020-06-11 | Custer | South Dakota | 46033 | 1 | 0 |
233182 | 233182 | 2020-06-12 | Custer | South Dakota | 46033 | 2 | 0 |
236287 | 236287 | 2020-06-13 | Custer | South Dakota | 46033 | 2 | 0 |
239395 | 239395 | 2020-06-14 | Custer | South Dakota | 46033 | 2 | 0 |
242505 | 242505 | 2020-06-15 | Custer | South Dakota | 46033 | 2 | 0 |
245617 | 245617 | 2020-06-16 | Custer | South Dakota | 46033 | 2 | 0 |
248730 | 248730 | 2020-06-17 | Custer | South Dakota | 46033 | 2 | 0 |
251845 | 251845 | 2020-06-18 | Custer | South Dakota | 46033 | 2 | 0 |
254960 | 254960 | 2020-06-19 | Custer | South Dakota | 46033 | 3 | 0 |
258086 | 258086 | 2020-06-20 | Custer | South Dakota | 46033 | 6 | 0 |
261213 | 261213 | 2020-06-21 | Custer | South Dakota | 46033 | 7 | 0 |
264341 | 264341 | 2020-06-22 | Custer | South Dakota | 46033 | 7 | 0 |
267469 | 267469 | 2020-06-23 | Custer | South Dakota | 46033 | 7 | 0 |
270603 | 270603 | 2020-06-24 | Custer | South Dakota | 46033 | 7 | 0 |
273742 | 273742 | 2020-06-25 | Custer | South Dakota | 46033 | 7 | 0 |
276889 | 276889 | 2020-06-26 | Custer | South Dakota | 46033 | 7 | 0 |
280037 | 280037 | 2020-06-27 | Custer | South Dakota | 46033 | 8 | 0 |
283183 | 283183 | 2020-06-28 | Custer | South Dakota | 46033 | 8 | 0 |
286328 | 286328 | 2020-06-29 | Custer | South Dakota | 46033 | 8 | 0 |
289479 | 289479 | 2020-06-30 | Custer | South Dakota | 46033 | 8 | 0 |
292631 | 292631 | 2020-07-01 | Custer | South Dakota | 46033 | 9 | 0 |
295787 | 295787 | 2020-07-02 | Custer | South Dakota | 46033 | 10 | 0 |
298947 | 298947 | 2020-07-03 | Custer | South Dakota | 46033 | 10 | 0 |
302111 | 302111 | 2020-07-04 | Custer | South Dakota | 46033 | 10 | 0 |
305274 | 305274 | 2020-07-05 | Custer | South Dakota | 46033 | 10 | 0 |
308441 | 308441 | 2020-07-06 | Custer | South Dakota | 46033 | 10 | 0 |
311610 | 311610 | 2020-07-07 | Custer | South Dakota | 46033 | 10 | 0 |
314783 | 314783 | 2020-07-08 | Custer | South Dakota | 46033 | 10 | 0 |
317956 | 317956 | 2020-07-09 | Custer | South Dakota | 46033 | 10 | 0 |
321134 | 321134 | 2020-07-10 | Custer | South Dakota | 46033 | 10 | 0 |
324314 | 324314 | 2020-07-11 | Custer | South Dakota | 46033 | 10 | 0 |
327499 | 327499 | 2020-07-12 | Custer | South Dakota | 46033 | 10 | 0 |
330685 | 330685 | 2020-07-13 | Custer | South Dakota | 46033 | 11 | 0 |
333877 | 333877 | 2020-07-14 | Custer | South Dakota | 46033 | 11 | 0 |
337071 | 337071 | 2020-07-15 | Custer | South Dakota | 46033 | 11 | 0 |
340268 | 340268 | 2020-07-16 | Custer | South Dakota | 46033 | 11 | 0 |
343466 | 343466 | 2020-07-17 | Custer | South Dakota | 46033 | 11 | 0 |
346666 | 346666 | 2020-07-18 | Custer | South Dakota | 46033 | 11 | 0 |
349866 | 349866 | 2020-07-19 | Custer | South Dakota | 46033 | 11 | 0 |
353069 | 353069 | 2020-07-20 | Custer | South Dakota | 46033 | 11 | 0 |
356272 | 356272 | 2020-07-21 | Custer | South Dakota | 46033 | 11 | 0 |
359476 | 359476 | 2020-07-22 | Custer | South Dakota | 46033 | 11 | 0 |
362682 | 362682 | 2020-07-23 | Custer | South Dakota | 46033 | 11 | 0 |
365888 | 365888 | 2020-07-24 | Custer | South Dakota | 46033 | 11 | 0 |
369097 | 369097 | 2020-07-25 | Custer | South Dakota | 46033 | 11 | 0 |
372309 | 372309 | 2020-07-26 | Custer | South Dakota | 46033 | 11 | 0 |
375522 | 375522 | 2020-07-27 | Custer | South Dakota | 46033 | 11 | 0 |
378738 | 378738 | 2020-07-28 | Custer | South Dakota | 46033 | 12 | 0 |
381955 | 381955 | 2020-07-29 | Custer | South Dakota | 46033 | 13 | 0 |
385173 | 385173 | 2020-07-30 | Custer | South Dakota | 46033 | 13 | 0 |
388390 | 388390 | 2020-07-31 | Custer | South Dakota | 46033 | 18 | 0 |
391607 | 391607 | 2020-08-01 | Custer | South Dakota | 46033 | 19 | 0 |
394823 | 394823 | 2020-08-02 | Custer | South Dakota | 46033 | 23 | 0 |
398040 | 398040 | 2020-08-03 | Custer | South Dakota | 46033 | 23 | 0 |
401255 | 401255 | 2020-08-04 | Custer | South Dakota | 46033 | 23 | 0 |
404473 | 404473 | 2020-08-05 | Custer | South Dakota | 46033 | 23 | 0 |
407693 | 407693 | 2020-08-06 | Custer | South Dakota | 46033 | 26 | 0 |
410912 | 410912 | 2020-08-07 | Custer | South Dakota | 46033 | 29 | 0 |
414132 | 414132 | 2020-08-08 | Custer | South Dakota | 46033 | 32 | 0 |
417353 | 417353 | 2020-08-09 | Custer | South Dakota | 46033 | 35 | 0 |
420574 | 420574 | 2020-08-10 | Custer | South Dakota | 46033 | 36 | 0 |
423796 | 423796 | 2020-08-11 | Custer | South Dakota | 46033 | 36 | 0 |
427019 | 427019 | 2020-08-12 | Custer | South Dakota | 46033 | 36 | 0 |
430245 | 430245 | 2020-08-13 | Custer | South Dakota | 46033 | 36 | 0 |
433470 | 433470 | 2020-08-14 | Custer | South Dakota | 46033 | 37 | 0 |
436697 | 436697 | 2020-08-15 | Custer | South Dakota | 46033 | 39 | 0 |
439922 | 439922 | 2020-08-16 | Custer | South Dakota | 46033 | 45 | 0 |
443149 | 443149 | 2020-08-17 | Custer | South Dakota | 46033 | 47 | 0 |
446375 | 446375 | 2020-08-18 | Custer | South Dakota | 46033 | 49 | 0 |
449603 | 449603 | 2020-08-19 | Custer | South Dakota | 46033 | 51 | 0 |
452831 | 452831 | 2020-08-20 | Custer | South Dakota | 46033 | 58 | 0 |
456059 | 456059 | 2020-08-21 | Custer | South Dakota | 46033 | 64 | 0 |
459287 | 459287 | 2020-08-22 | Custer | South Dakota | 46033 | 74 | 0 |
462515 | 462515 | 2020-08-23 | Custer | South Dakota | 46033 | 82 | 0 |
465744 | 465744 | 2020-08-24 | Custer | South Dakota | 46033 | 86 | 0 |
468972 | 468972 | 2020-08-25 | Custer | South Dakota | 46033 | 90 | 0 |
472204 | 472204 | 2020-08-26 | Custer | South Dakota | 46033 | 92 | 0 |
475438 | 475438 | 2020-08-27 | Custer | South Dakota | 46033 | 104 | 0 |
478671 | 478671 | 2020-08-28 | Custer | South Dakota | 46033 | 110 | 0 |
481905 | 481905 | 2020-08-29 | Custer | South Dakota | 46033 | 114 | 0 |
485140 | 485140 | 2020-08-30 | Custer | South Dakota | 46033 | 116 | 0 |
488373 | 488373 | 2020-08-31 | Custer | South Dakota | 46033 | 117 | 0 |
491606 | 491606 | 2020-09-01 | Custer | South Dakota | 46033 | 117 | 0 |
494840 | 494840 | 2020-09-02 | Custer | South Dakota | 46033 | 130 | 0 |
498073 | 498073 | 2020-09-03 | Custer | South Dakota | 46033 | 130 | 0 |
501307 | 501307 | 2020-09-04 | Custer | South Dakota | 46033 | 131 | 0 |
504541 | 504541 | 2020-09-05 | Custer | South Dakota | 46033 | 136 | 1 |
507773 | 507773 | 2020-09-06 | Custer | South Dakota | 46033 | 138 | 1 |
511006 | 511006 | 2020-09-07 | Custer | South Dakota | 46033 | 138 | 1 |
514239 | 514239 | 2020-09-08 | Custer | South Dakota | 46033 | 138 | 1 |
517474 | 517474 | 2020-09-09 | Custer | South Dakota | 46033 | 139 | 1 |
520710 | 520710 | 2020-09-10 | Custer | South Dakota | 46033 | 145 | 1 |
523946 | 523946 | 2020-09-11 | Custer | South Dakota | 46033 | 152 | 1 |
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);