ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
776 rows where county = "Clay" and fips = 46027 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
637356 | 637356 | 2020-10-16 | Clay | South Dakota | 46027 | 683 | 8 |
634110 | 634110 | 2020-10-15 | Clay | South Dakota | 46027 | 677 | 8 |
630865 | 630865 | 2020-10-14 | Clay | South Dakota | 46027 | 667 | 8 |
627621 | 627621 | 2020-10-13 | Clay | South Dakota | 46027 | 654 | 8 |
624379 | 624379 | 2020-10-12 | Clay | South Dakota | 46027 | 650 | 8 |
621136 | 621136 | 2020-10-11 | Clay | South Dakota | 46027 | 643 | 8 |
617893 | 617893 | 2020-10-10 | Clay | South Dakota | 46027 | 634 | 8 |
614651 | 614651 | 2020-10-09 | Clay | South Dakota | 46027 | 619 | 7 |
611410 | 611410 | 2020-10-08 | Clay | South Dakota | 46027 | 606 | 7 |
608168 | 608168 | 2020-10-07 | Clay | South Dakota | 46027 | 603 | 7 |
604925 | 604925 | 2020-10-06 | Clay | South Dakota | 46027 | 589 | 7 |
601683 | 601683 | 2020-10-05 | Clay | South Dakota | 46027 | 586 | 7 |
598440 | 598440 | 2020-10-04 | Clay | South Dakota | 46027 | 585 | 7 |
595197 | 595197 | 2020-10-03 | Clay | South Dakota | 46027 | 581 | 7 |
591956 | 591956 | 2020-10-02 | Clay | South Dakota | 46027 | 576 | 7 |
588715 | 588715 | 2020-10-01 | Clay | South Dakota | 46027 | 572 | 7 |
585475 | 585475 | 2020-09-30 | Clay | South Dakota | 46027 | 568 | 6 |
582235 | 582235 | 2020-09-29 | Clay | South Dakota | 46027 | 564 | 6 |
578995 | 578995 | 2020-09-28 | Clay | South Dakota | 46027 | 564 | 5 |
575754 | 575754 | 2020-09-27 | Clay | South Dakota | 46027 | 563 | 5 |
572510 | 572510 | 2020-09-26 | Clay | South Dakota | 46027 | 558 | 5 |
569268 | 569268 | 2020-09-25 | Clay | South Dakota | 46027 | 554 | 5 |
566027 | 566027 | 2020-09-24 | Clay | South Dakota | 46027 | 548 | 5 |
562786 | 562786 | 2020-09-23 | Clay | South Dakota | 46027 | 540 | 5 |
559549 | 559549 | 2020-09-22 | Clay | South Dakota | 46027 | 540 | 5 |
556312 | 556312 | 2020-09-21 | Clay | South Dakota | 46027 | 537 | 5 |
553075 | 553075 | 2020-09-20 | Clay | South Dakota | 46027 | 535 | 5 |
549836 | 549836 | 2020-09-19 | Clay | South Dakota | 46027 | 531 | 5 |
546597 | 546597 | 2020-09-18 | Clay | South Dakota | 46027 | 529 | 5 |
543360 | 543360 | 2020-09-17 | Clay | South Dakota | 46027 | 526 | 5 |
540124 | 540124 | 2020-09-16 | Clay | South Dakota | 46027 | 522 | 5 |
536887 | 536887 | 2020-09-15 | Clay | South Dakota | 46027 | 517 | 4 |
533651 | 533651 | 2020-09-14 | Clay | South Dakota | 46027 | 508 | 4 |
530416 | 530416 | 2020-09-13 | Clay | South Dakota | 46027 | 501 | 4 |
527179 | 527179 | 2020-09-12 | Clay | South Dakota | 46027 | 499 | 4 |
523943 | 523943 | 2020-09-11 | Clay | South Dakota | 46027 | 490 | 4 |
520707 | 520707 | 2020-09-10 | Clay | South Dakota | 46027 | 483 | 4 |
517471 | 517471 | 2020-09-09 | Clay | South Dakota | 46027 | 479 | 3 |
514236 | 514236 | 2020-09-08 | Clay | South Dakota | 46027 | 464 | 3 |
511003 | 511003 | 2020-09-07 | Clay | South Dakota | 46027 | 462 | 3 |
507770 | 507770 | 2020-09-06 | Clay | South Dakota | 46027 | 449 | 3 |
504538 | 504538 | 2020-09-05 | Clay | South Dakota | 46027 | 446 | 3 |
501304 | 501304 | 2020-09-04 | Clay | South Dakota | 46027 | 427 | 2 |
498070 | 498070 | 2020-09-03 | Clay | South Dakota | 46027 | 413 | 2 |
494837 | 494837 | 2020-09-02 | Clay | South Dakota | 46027 | 381 | 2 |
491603 | 491603 | 2020-09-01 | Clay | South Dakota | 46027 | 372 | 2 |
488370 | 488370 | 2020-08-31 | Clay | South Dakota | 46027 | 353 | 2 |
485137 | 485137 | 2020-08-30 | Clay | South Dakota | 46027 | 344 | 2 |
481902 | 481902 | 2020-08-29 | Clay | South Dakota | 46027 | 294 | 2 |
478668 | 478668 | 2020-08-28 | Clay | South Dakota | 46027 | 252 | 2 |
475435 | 475435 | 2020-08-27 | Clay | South Dakota | 46027 | 230 | 1 |
472201 | 472201 | 2020-08-26 | Clay | South Dakota | 46027 | 176 | 1 |
468969 | 468969 | 2020-08-25 | Clay | South Dakota | 46027 | 176 | 1 |
465741 | 465741 | 2020-08-24 | Clay | South Dakota | 46027 | 172 | 1 |
462512 | 462512 | 2020-08-23 | Clay | South Dakota | 46027 | 158 | 1 |
459284 | 459284 | 2020-08-22 | Clay | South Dakota | 46027 | 152 | 1 |
456056 | 456056 | 2020-08-21 | Clay | South Dakota | 46027 | 142 | 1 |
452828 | 452828 | 2020-08-20 | Clay | South Dakota | 46027 | 142 | 0 |
449600 | 449600 | 2020-08-19 | Clay | South Dakota | 46027 | 142 | 0 |
446372 | 446372 | 2020-08-18 | Clay | South Dakota | 46027 | 141 | 0 |
443146 | 443146 | 2020-08-17 | Clay | South Dakota | 46027 | 141 | 0 |
439919 | 439919 | 2020-08-16 | Clay | South Dakota | 46027 | 142 | 0 |
436694 | 436694 | 2020-08-15 | Clay | South Dakota | 46027 | 137 | 0 |
433467 | 433467 | 2020-08-14 | Clay | South Dakota | 46027 | 136 | 0 |
430242 | 430242 | 2020-08-13 | Clay | South Dakota | 46027 | 135 | 0 |
427016 | 427016 | 2020-08-12 | Clay | South Dakota | 46027 | 132 | 0 |
423793 | 423793 | 2020-08-11 | Clay | South Dakota | 46027 | 131 | 0 |
420571 | 420571 | 2020-08-10 | Clay | South Dakota | 46027 | 130 | 0 |
417350 | 417350 | 2020-08-09 | Clay | South Dakota | 46027 | 128 | 0 |
414129 | 414129 | 2020-08-08 | Clay | South Dakota | 46027 | 124 | 0 |
410909 | 410909 | 2020-08-07 | Clay | South Dakota | 46027 | 124 | 0 |
407690 | 407690 | 2020-08-06 | Clay | South Dakota | 46027 | 123 | 0 |
404470 | 404470 | 2020-08-05 | Clay | South Dakota | 46027 | 120 | 0 |
401252 | 401252 | 2020-08-04 | Clay | South Dakota | 46027 | 120 | 0 |
398037 | 398037 | 2020-08-03 | Clay | South Dakota | 46027 | 118 | 0 |
394820 | 394820 | 2020-08-02 | Clay | South Dakota | 46027 | 117 | 0 |
391604 | 391604 | 2020-08-01 | Clay | South Dakota | 46027 | 114 | 0 |
388387 | 388387 | 2020-07-31 | Clay | South Dakota | 46027 | 113 | 0 |
385170 | 385170 | 2020-07-30 | Clay | South Dakota | 46027 | 111 | 0 |
381952 | 381952 | 2020-07-29 | Clay | South Dakota | 46027 | 110 | 0 |
378735 | 378735 | 2020-07-28 | Clay | South Dakota | 46027 | 107 | 0 |
375519 | 375519 | 2020-07-27 | Clay | South Dakota | 46027 | 106 | 0 |
372306 | 372306 | 2020-07-26 | Clay | South Dakota | 46027 | 106 | 0 |
369094 | 369094 | 2020-07-25 | Clay | South Dakota | 46027 | 104 | 0 |
365885 | 365885 | 2020-07-24 | Clay | South Dakota | 46027 | 103 | 0 |
362679 | 362679 | 2020-07-23 | Clay | South Dakota | 46027 | 101 | 0 |
359473 | 359473 | 2020-07-22 | Clay | South Dakota | 46027 | 100 | 0 |
356269 | 356269 | 2020-07-21 | Clay | South Dakota | 46027 | 99 | 0 |
353066 | 353066 | 2020-07-20 | Clay | South Dakota | 46027 | 97 | 0 |
349863 | 349863 | 2020-07-19 | Clay | South Dakota | 46027 | 97 | 0 |
346663 | 346663 | 2020-07-18 | Clay | South Dakota | 46027 | 95 | 0 |
343463 | 343463 | 2020-07-17 | Clay | South Dakota | 46027 | 95 | 0 |
340265 | 340265 | 2020-07-16 | Clay | South Dakota | 46027 | 94 | 0 |
337068 | 337068 | 2020-07-15 | Clay | South Dakota | 46027 | 94 | 0 |
333874 | 333874 | 2020-07-14 | Clay | South Dakota | 46027 | 94 | 0 |
330682 | 330682 | 2020-07-13 | Clay | South Dakota | 46027 | 93 | 0 |
327496 | 327496 | 2020-07-12 | Clay | South Dakota | 46027 | 93 | 0 |
324311 | 324311 | 2020-07-11 | Clay | South Dakota | 46027 | 93 | 0 |
321131 | 321131 | 2020-07-10 | Clay | South Dakota | 46027 | 93 | 0 |
317953 | 317953 | 2020-07-09 | Clay | South Dakota | 46027 | 92 | 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);