ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
270 rows where county = "Smith" and deaths = 0 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
state 4
- Kansas 217
- Mississippi 21
- Tennessee 19
- Texas 13
county 1
- Smith · 270 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
739678 | 739678 | 2020-11-17 | Smith | Kansas | 20183 | 86 | 0 |
736434 | 736434 | 2020-11-16 | Smith | Kansas | 20183 | 86 | 0 |
733188 | 733188 | 2020-11-15 | Smith | Kansas | 20183 | 80 | 0 |
729943 | 729943 | 2020-11-14 | Smith | Kansas | 20183 | 80 | 0 |
726700 | 726700 | 2020-11-13 | Smith | Kansas | 20183 | 72 | 0 |
723457 | 723457 | 2020-11-12 | Smith | Kansas | 20183 | 63 | 0 |
720214 | 720214 | 2020-11-11 | Smith | Kansas | 20183 | 63 | 0 |
716971 | 716971 | 2020-11-10 | Smith | Kansas | 20183 | 59 | 0 |
713727 | 713727 | 2020-11-09 | Smith | Kansas | 20183 | 59 | 0 |
710483 | 710483 | 2020-11-08 | Smith | Kansas | 20183 | 55 | 0 |
707239 | 707239 | 2020-11-07 | Smith | Kansas | 20183 | 53 | 0 |
703996 | 703996 | 2020-11-06 | Smith | Kansas | 20183 | 53 | 0 |
700754 | 700754 | 2020-11-05 | Smith | Kansas | 20183 | 45 | 0 |
697510 | 697510 | 2020-11-04 | Smith | Kansas | 20183 | 45 | 0 |
694268 | 694268 | 2020-11-03 | Smith | Kansas | 20183 | 34 | 0 |
691025 | 691025 | 2020-11-02 | Smith | Kansas | 20183 | 34 | 0 |
687780 | 687780 | 2020-11-01 | Smith | Kansas | 20183 | 28 | 0 |
684536 | 684536 | 2020-10-31 | Smith | Kansas | 20183 | 28 | 0 |
681293 | 681293 | 2020-10-30 | Smith | Kansas | 20183 | 28 | 0 |
678050 | 678050 | 2020-10-29 | Smith | Kansas | 20183 | 24 | 0 |
674807 | 674807 | 2020-10-28 | Smith | Kansas | 20183 | 24 | 0 |
671565 | 671565 | 2020-10-27 | Smith | Kansas | 20183 | 22 | 0 |
668322 | 668322 | 2020-10-26 | Smith | Kansas | 20183 | 22 | 0 |
665078 | 665078 | 2020-10-25 | Smith | Kansas | 20183 | 22 | 0 |
661833 | 661833 | 2020-10-24 | Smith | Kansas | 20183 | 22 | 0 |
658589 | 658589 | 2020-10-23 | Smith | Kansas | 20183 | 22 | 0 |
655344 | 655344 | 2020-10-22 | Smith | Kansas | 20183 | 19 | 0 |
652099 | 652099 | 2020-10-21 | Smith | Kansas | 20183 | 19 | 0 |
648855 | 648855 | 2020-10-20 | Smith | Kansas | 20183 | 19 | 0 |
645610 | 645610 | 2020-10-19 | Smith | Kansas | 20183 | 19 | 0 |
642363 | 642363 | 2020-10-18 | Smith | Kansas | 20183 | 19 | 0 |
639116 | 639116 | 2020-10-17 | Smith | Kansas | 20183 | 19 | 0 |
635870 | 635870 | 2020-10-16 | Smith | Kansas | 20183 | 19 | 0 |
632624 | 632624 | 2020-10-15 | Smith | Kansas | 20183 | 19 | 0 |
629380 | 629380 | 2020-10-14 | Smith | Kansas | 20183 | 19 | 0 |
626137 | 626137 | 2020-10-13 | Smith | Kansas | 20183 | 19 | 0 |
622895 | 622895 | 2020-10-12 | Smith | Kansas | 20183 | 17 | 0 |
619651 | 619651 | 2020-10-11 | Smith | Kansas | 20183 | 13 | 0 |
616409 | 616409 | 2020-10-10 | Smith | Kansas | 20183 | 13 | 0 |
613168 | 613168 | 2020-10-09 | Smith | Kansas | 20183 | 13 | 0 |
609926 | 609926 | 2020-10-08 | Smith | Kansas | 20183 | 12 | 0 |
606683 | 606683 | 2020-10-07 | Smith | Kansas | 20183 | 12 | 0 |
603441 | 603441 | 2020-10-06 | Smith | Kansas | 20183 | 12 | 0 |
600198 | 600198 | 2020-10-05 | Smith | Kansas | 20183 | 12 | 0 |
596956 | 596956 | 2020-10-04 | Smith | Kansas | 20183 | 11 | 0 |
593714 | 593714 | 2020-10-03 | Smith | Kansas | 20183 | 10 | 0 |
590473 | 590473 | 2020-10-02 | Smith | Kansas | 20183 | 10 | 0 |
587232 | 587232 | 2020-10-01 | Smith | Kansas | 20183 | 8 | 0 |
583992 | 583992 | 2020-09-30 | Smith | Kansas | 20183 | 8 | 0 |
580753 | 580753 | 2020-09-29 | Smith | Kansas | 20183 | 8 | 0 |
577512 | 577512 | 2020-09-28 | Smith | Kansas | 20183 | 8 | 0 |
574270 | 574270 | 2020-09-27 | Smith | Kansas | 20183 | 7 | 0 |
571027 | 571027 | 2020-09-26 | Smith | Kansas | 20183 | 7 | 0 |
567785 | 567785 | 2020-09-25 | Smith | Kansas | 20183 | 7 | 0 |
564545 | 564545 | 2020-09-24 | Smith | Kansas | 20183 | 6 | 0 |
561305 | 561305 | 2020-09-23 | Smith | Kansas | 20183 | 6 | 0 |
558069 | 558069 | 2020-09-22 | Smith | Kansas | 20183 | 5 | 0 |
554832 | 554832 | 2020-09-21 | Smith | Kansas | 20183 | 5 | 0 |
551593 | 551593 | 2020-09-20 | Smith | Kansas | 20183 | 5 | 0 |
548354 | 548354 | 2020-09-19 | Smith | Kansas | 20183 | 5 | 0 |
545116 | 545116 | 2020-09-18 | Smith | Kansas | 20183 | 5 | 0 |
541880 | 541880 | 2020-09-17 | Smith | Kansas | 20183 | 6 | 0 |
538643 | 538643 | 2020-09-16 | Smith | Kansas | 20183 | 6 | 0 |
535407 | 535407 | 2020-09-15 | Smith | Kansas | 20183 | 6 | 0 |
532172 | 532172 | 2020-09-14 | Smith | Kansas | 20183 | 6 | 0 |
528935 | 528935 | 2020-09-13 | Smith | Kansas | 20183 | 6 | 0 |
525699 | 525699 | 2020-09-12 | Smith | Kansas | 20183 | 6 | 0 |
522463 | 522463 | 2020-09-11 | Smith | Kansas | 20183 | 6 | 0 |
519226 | 519226 | 2020-09-10 | Smith | Kansas | 20183 | 6 | 0 |
515991 | 515991 | 2020-09-09 | Smith | Kansas | 20183 | 6 | 0 |
512758 | 512758 | 2020-09-08 | Smith | Kansas | 20183 | 6 | 0 |
509525 | 509525 | 2020-09-07 | Smith | Kansas | 20183 | 6 | 0 |
506293 | 506293 | 2020-09-06 | Smith | Kansas | 20183 | 4 | 0 |
503059 | 503059 | 2020-09-05 | Smith | Kansas | 20183 | 4 | 0 |
499825 | 499825 | 2020-09-04 | Smith | Kansas | 20183 | 4 | 0 |
496592 | 496592 | 2020-09-03 | Smith | Kansas | 20183 | 5 | 0 |
493358 | 493358 | 2020-09-02 | Smith | Kansas | 20183 | 5 | 0 |
490125 | 490125 | 2020-09-01 | Smith | Kansas | 20183 | 4 | 0 |
486892 | 486892 | 2020-08-31 | Smith | Kansas | 20183 | 4 | 0 |
483657 | 483657 | 2020-08-30 | Smith | Kansas | 20183 | 3 | 0 |
480423 | 480423 | 2020-08-29 | Smith | Kansas | 20183 | 3 | 0 |
477190 | 477190 | 2020-08-28 | Smith | Kansas | 20183 | 3 | 0 |
473957 | 473957 | 2020-08-27 | Smith | Kansas | 20183 | 3 | 0 |
470725 | 470725 | 2020-08-26 | Smith | Kansas | 20183 | 3 | 0 |
467496 | 467496 | 2020-08-25 | Smith | Kansas | 20183 | 3 | 0 |
464267 | 464267 | 2020-08-24 | Smith | Kansas | 20183 | 3 | 0 |
461037 | 461037 | 2020-08-23 | Smith | Kansas | 20183 | 3 | 0 |
457810 | 457810 | 2020-08-22 | Smith | Kansas | 20183 | 3 | 0 |
454582 | 454582 | 2020-08-21 | Smith | Kansas | 20183 | 3 | 0 |
451354 | 451354 | 2020-08-20 | Smith | Kansas | 20183 | 3 | 0 |
448126 | 448126 | 2020-08-19 | Smith | Kansas | 20183 | 3 | 0 |
444899 | 444899 | 2020-08-18 | Smith | Kansas | 20183 | 3 | 0 |
441673 | 441673 | 2020-08-17 | Smith | Kansas | 20183 | 3 | 0 |
438446 | 438446 | 2020-08-16 | Smith | Kansas | 20183 | 3 | 0 |
435221 | 435221 | 2020-08-15 | Smith | Kansas | 20183 | 3 | 0 |
431996 | 431996 | 2020-08-14 | Smith | Kansas | 20183 | 3 | 0 |
428768 | 428768 | 2020-08-13 | Smith | Kansas | 20183 | 3 | 0 |
425544 | 425544 | 2020-08-12 | Smith | Kansas | 20183 | 3 | 0 |
422323 | 422323 | 2020-08-11 | Smith | Kansas | 20183 | 3 | 0 |
419100 | 419100 | 2020-08-10 | Smith | Kansas | 20183 | 3 | 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);