ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
775 rows where county = "Marshall" and state = "South Dakota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
611440 | 611440 | 2020-10-08 | Marshall | South Dakota | 46091 | 49 | 0 |
608198 | 608198 | 2020-10-07 | Marshall | South Dakota | 46091 | 48 | 0 |
604955 | 604955 | 2020-10-06 | Marshall | South Dakota | 46091 | 48 | 0 |
601713 | 601713 | 2020-10-05 | Marshall | South Dakota | 46091 | 48 | 0 |
598470 | 598470 | 2020-10-04 | Marshall | South Dakota | 46091 | 47 | 0 |
595227 | 595227 | 2020-10-03 | Marshall | South Dakota | 46091 | 46 | 0 |
591986 | 591986 | 2020-10-02 | Marshall | South Dakota | 46091 | 46 | 0 |
588745 | 588745 | 2020-10-01 | Marshall | South Dakota | 46091 | 46 | 0 |
585505 | 585505 | 2020-09-30 | Marshall | South Dakota | 46091 | 43 | 0 |
582265 | 582265 | 2020-09-29 | Marshall | South Dakota | 46091 | 40 | 0 |
579025 | 579025 | 2020-09-28 | Marshall | South Dakota | 46091 | 38 | 0 |
575784 | 575784 | 2020-09-27 | Marshall | South Dakota | 46091 | 38 | 0 |
572540 | 572540 | 2020-09-26 | Marshall | South Dakota | 46091 | 38 | 0 |
569298 | 569298 | 2020-09-25 | Marshall | South Dakota | 46091 | 38 | 0 |
566057 | 566057 | 2020-09-24 | Marshall | South Dakota | 46091 | 37 | 0 |
562816 | 562816 | 2020-09-23 | Marshall | South Dakota | 46091 | 38 | 0 |
559579 | 559579 | 2020-09-22 | Marshall | South Dakota | 46091 | 37 | 0 |
556342 | 556342 | 2020-09-21 | Marshall | South Dakota | 46091 | 35 | 0 |
553105 | 553105 | 2020-09-20 | Marshall | South Dakota | 46091 | 35 | 0 |
549866 | 549866 | 2020-09-19 | Marshall | South Dakota | 46091 | 33 | 0 |
546627 | 546627 | 2020-09-18 | Marshall | South Dakota | 46091 | 33 | 0 |
543390 | 543390 | 2020-09-17 | Marshall | South Dakota | 46091 | 31 | 0 |
540154 | 540154 | 2020-09-16 | Marshall | South Dakota | 46091 | 29 | 0 |
536917 | 536917 | 2020-09-15 | Marshall | South Dakota | 46091 | 28 | 0 |
533681 | 533681 | 2020-09-14 | Marshall | South Dakota | 46091 | 27 | 0 |
530446 | 530446 | 2020-09-13 | Marshall | South Dakota | 46091 | 26 | 0 |
527209 | 527209 | 2020-09-12 | Marshall | South Dakota | 46091 | 24 | 0 |
523973 | 523973 | 2020-09-11 | Marshall | South Dakota | 46091 | 22 | 0 |
520737 | 520737 | 2020-09-10 | Marshall | South Dakota | 46091 | 22 | 0 |
517501 | 517501 | 2020-09-09 | Marshall | South Dakota | 46091 | 21 | 0 |
514266 | 514266 | 2020-09-08 | Marshall | South Dakota | 46091 | 20 | 0 |
511033 | 511033 | 2020-09-07 | Marshall | South Dakota | 46091 | 19 | 0 |
507800 | 507800 | 2020-09-06 | Marshall | South Dakota | 46091 | 19 | 0 |
504568 | 504568 | 2020-09-05 | Marshall | South Dakota | 46091 | 19 | 0 |
501334 | 501334 | 2020-09-04 | Marshall | South Dakota | 46091 | 19 | 0 |
498100 | 498100 | 2020-09-03 | Marshall | South Dakota | 46091 | 19 | 0 |
494867 | 494867 | 2020-09-02 | Marshall | South Dakota | 46091 | 19 | 0 |
491633 | 491633 | 2020-09-01 | Marshall | South Dakota | 46091 | 19 | 0 |
488400 | 488400 | 2020-08-31 | Marshall | South Dakota | 46091 | 19 | 0 |
485167 | 485167 | 2020-08-30 | Marshall | South Dakota | 46091 | 19 | 0 |
481932 | 481932 | 2020-08-29 | Marshall | South Dakota | 46091 | 19 | 0 |
478698 | 478698 | 2020-08-28 | Marshall | South Dakota | 46091 | 16 | 0 |
475465 | 475465 | 2020-08-27 | Marshall | South Dakota | 46091 | 16 | 0 |
472231 | 472231 | 2020-08-26 | Marshall | South Dakota | 46091 | 16 | 0 |
468999 | 468999 | 2020-08-25 | Marshall | South Dakota | 46091 | 15 | 0 |
465771 | 465771 | 2020-08-24 | Marshall | South Dakota | 46091 | 15 | 0 |
462542 | 462542 | 2020-08-23 | Marshall | South Dakota | 46091 | 15 | 0 |
459314 | 459314 | 2020-08-22 | Marshall | South Dakota | 46091 | 13 | 0 |
456086 | 456086 | 2020-08-21 | Marshall | South Dakota | 46091 | 13 | 0 |
452858 | 452858 | 2020-08-20 | Marshall | South Dakota | 46091 | 13 | 0 |
449630 | 449630 | 2020-08-19 | Marshall | South Dakota | 46091 | 12 | 0 |
446402 | 446402 | 2020-08-18 | Marshall | South Dakota | 46091 | 12 | 0 |
443176 | 443176 | 2020-08-17 | Marshall | South Dakota | 46091 | 12 | 0 |
439949 | 439949 | 2020-08-16 | Marshall | South Dakota | 46091 | 12 | 0 |
436724 | 436724 | 2020-08-15 | Marshall | South Dakota | 46091 | 12 | 0 |
433497 | 433497 | 2020-08-14 | Marshall | South Dakota | 46091 | 12 | 0 |
430272 | 430272 | 2020-08-13 | Marshall | South Dakota | 46091 | 12 | 0 |
427045 | 427045 | 2020-08-12 | Marshall | South Dakota | 46091 | 10 | 0 |
423822 | 423822 | 2020-08-11 | Marshall | South Dakota | 46091 | 9 | 0 |
420600 | 420600 | 2020-08-10 | Marshall | South Dakota | 46091 | 9 | 0 |
417379 | 417379 | 2020-08-09 | Marshall | South Dakota | 46091 | 9 | 0 |
414158 | 414158 | 2020-08-08 | Marshall | South Dakota | 46091 | 9 | 0 |
410938 | 410938 | 2020-08-07 | Marshall | South Dakota | 46091 | 8 | 0 |
407719 | 407719 | 2020-08-06 | Marshall | South Dakota | 46091 | 8 | 0 |
404499 | 404499 | 2020-08-05 | Marshall | South Dakota | 46091 | 8 | 0 |
401281 | 401281 | 2020-08-04 | Marshall | South Dakota | 46091 | 8 | 0 |
398066 | 398066 | 2020-08-03 | Marshall | South Dakota | 46091 | 8 | 0 |
394849 | 394849 | 2020-08-02 | Marshall | South Dakota | 46091 | 8 | 0 |
391633 | 391633 | 2020-08-01 | Marshall | South Dakota | 46091 | 8 | 0 |
388416 | 388416 | 2020-07-31 | Marshall | South Dakota | 46091 | 8 | 0 |
385199 | 385199 | 2020-07-30 | Marshall | South Dakota | 46091 | 8 | 0 |
381981 | 381981 | 2020-07-29 | Marshall | South Dakota | 46091 | 8 | 0 |
378764 | 378764 | 2020-07-28 | Marshall | South Dakota | 46091 | 8 | 0 |
375548 | 375548 | 2020-07-27 | Marshall | South Dakota | 46091 | 8 | 0 |
372335 | 372335 | 2020-07-26 | Marshall | South Dakota | 46091 | 8 | 0 |
369123 | 369123 | 2020-07-25 | Marshall | South Dakota | 46091 | 8 | 0 |
365914 | 365914 | 2020-07-24 | Marshall | South Dakota | 46091 | 6 | 0 |
362708 | 362708 | 2020-07-23 | Marshall | South Dakota | 46091 | 6 | 0 |
359502 | 359502 | 2020-07-22 | Marshall | South Dakota | 46091 | 6 | 0 |
356298 | 356298 | 2020-07-21 | Marshall | South Dakota | 46091 | 5 | 0 |
353095 | 353095 | 2020-07-20 | Marshall | South Dakota | 46091 | 5 | 0 |
349892 | 349892 | 2020-07-19 | Marshall | South Dakota | 46091 | 5 | 0 |
346692 | 346692 | 2020-07-18 | Marshall | South Dakota | 46091 | 5 | 0 |
343492 | 343492 | 2020-07-17 | Marshall | South Dakota | 46091 | 5 | 0 |
340294 | 340294 | 2020-07-16 | Marshall | South Dakota | 46091 | 5 | 0 |
337097 | 337097 | 2020-07-15 | Marshall | South Dakota | 46091 | 5 | 0 |
333903 | 333903 | 2020-07-14 | Marshall | South Dakota | 46091 | 5 | 0 |
330711 | 330711 | 2020-07-13 | Marshall | South Dakota | 46091 | 5 | 0 |
327525 | 327525 | 2020-07-12 | Marshall | South Dakota | 46091 | 5 | 0 |
324340 | 324340 | 2020-07-11 | Marshall | South Dakota | 46091 | 5 | 0 |
321160 | 321160 | 2020-07-10 | Marshall | South Dakota | 46091 | 5 | 0 |
317982 | 317982 | 2020-07-09 | Marshall | South Dakota | 46091 | 5 | 0 |
314809 | 314809 | 2020-07-08 | Marshall | South Dakota | 46091 | 5 | 0 |
311635 | 311635 | 2020-07-07 | Marshall | South Dakota | 46091 | 5 | 0 |
308466 | 308466 | 2020-07-06 | Marshall | South Dakota | 46091 | 5 | 0 |
305298 | 305298 | 2020-07-05 | Marshall | South Dakota | 46091 | 5 | 0 |
302135 | 302135 | 2020-07-04 | Marshall | South Dakota | 46091 | 5 | 0 |
298971 | 298971 | 2020-07-03 | Marshall | South Dakota | 46091 | 5 | 0 |
295811 | 295811 | 2020-07-02 | Marshall | South Dakota | 46091 | 5 | 0 |
292655 | 292655 | 2020-07-01 | Marshall | South Dakota | 46091 | 5 | 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);