ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Cocke" and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
767201 | 767201 | 2020-11-25 | Cocke | Tennessee | 47029 | 1561 | 30 |
763956 | 763956 | 2020-11-24 | Cocke | Tennessee | 47029 | 1555 | 28 |
760711 | 760711 | 2020-11-23 | Cocke | Tennessee | 47029 | 1549 | 28 |
757466 | 757466 | 2020-11-22 | Cocke | Tennessee | 47029 | 1539 | 28 |
754219 | 754219 | 2020-11-21 | Cocke | Tennessee | 47029 | 1512 | 26 |
750973 | 750973 | 2020-11-20 | Cocke | Tennessee | 47029 | 1497 | 26 |
747727 | 747727 | 2020-11-19 | Cocke | Tennessee | 47029 | 1488 | 26 |
744481 | 744481 | 2020-11-18 | Cocke | Tennessee | 47029 | 1488 | 26 |
741234 | 741234 | 2020-11-17 | Cocke | Tennessee | 47029 | 1470 | 26 |
737988 | 737988 | 2020-11-16 | Cocke | Tennessee | 47029 | 1466 | 26 |
734744 | 734744 | 2020-11-15 | Cocke | Tennessee | 47029 | 1424 | 26 |
731498 | 731498 | 2020-11-14 | Cocke | Tennessee | 47029 | 1405 | 26 |
728254 | 728254 | 2020-11-13 | Cocke | Tennessee | 47029 | 1374 | 26 |
725010 | 725010 | 2020-11-12 | Cocke | Tennessee | 47029 | 1354 | 24 |
721767 | 721767 | 2020-11-11 | Cocke | Tennessee | 47029 | 1340 | 24 |
718524 | 718524 | 2020-11-10 | Cocke | Tennessee | 47029 | 1321 | 22 |
715281 | 715281 | 2020-11-09 | Cocke | Tennessee | 47029 | 1303 | 22 |
712037 | 712037 | 2020-11-08 | Cocke | Tennessee | 47029 | 1292 | 22 |
708793 | 708793 | 2020-11-07 | Cocke | Tennessee | 47029 | 1273 | 21 |
705550 | 705550 | 2020-11-06 | Cocke | Tennessee | 47029 | 1251 | 20 |
702307 | 702307 | 2020-11-05 | Cocke | Tennessee | 47029 | 1246 | 20 |
699063 | 699063 | 2020-11-04 | Cocke | Tennessee | 47029 | 1232 | 20 |
695820 | 695820 | 2020-11-03 | Cocke | Tennessee | 47029 | 1209 | 18 |
692578 | 692578 | 2020-11-02 | Cocke | Tennessee | 47029 | 1201 | 17 |
689334 | 689334 | 2020-11-01 | Cocke | Tennessee | 47029 | 1178 | 17 |
686089 | 686089 | 2020-10-31 | Cocke | Tennessee | 47029 | 1173 | 17 |
682846 | 682846 | 2020-10-30 | Cocke | Tennessee | 47029 | 1167 | 16 |
679603 | 679603 | 2020-10-29 | Cocke | Tennessee | 47029 | 1150 | 14 |
676360 | 676360 | 2020-10-28 | Cocke | Tennessee | 47029 | 1123 | 14 |
673117 | 673117 | 2020-10-27 | Cocke | Tennessee | 47029 | 1097 | 14 |
669875 | 669875 | 2020-10-26 | Cocke | Tennessee | 47029 | 1080 | 14 |
666631 | 666631 | 2020-10-25 | Cocke | Tennessee | 47029 | 1058 | 14 |
663386 | 663386 | 2020-10-24 | Cocke | Tennessee | 47029 | 1035 | 14 |
660142 | 660142 | 2020-10-23 | Cocke | Tennessee | 47029 | 1014 | 12 |
656898 | 656898 | 2020-10-22 | Cocke | Tennessee | 47029 | 966 | 12 |
653653 | 653653 | 2020-10-21 | Cocke | Tennessee | 47029 | 952 | 12 |
650408 | 650408 | 2020-10-20 | Cocke | Tennessee | 47029 | 926 | 12 |
647164 | 647164 | 2020-10-19 | Cocke | Tennessee | 47029 | 922 | 12 |
643918 | 643918 | 2020-10-18 | Cocke | Tennessee | 47029 | 913 | 12 |
640670 | 640670 | 2020-10-17 | Cocke | Tennessee | 47029 | 895 | 12 |
637424 | 637424 | 2020-10-16 | Cocke | Tennessee | 47029 | 884 | 12 |
634178 | 634178 | 2020-10-15 | Cocke | Tennessee | 47029 | 878 | 12 |
630933 | 630933 | 2020-10-14 | Cocke | Tennessee | 47029 | 870 | 11 |
627689 | 627689 | 2020-10-13 | Cocke | Tennessee | 47029 | 865 | 11 |
624447 | 624447 | 2020-10-12 | Cocke | Tennessee | 47029 | 866 | 11 |
621204 | 621204 | 2020-10-11 | Cocke | Tennessee | 47029 | 849 | 11 |
617961 | 617961 | 2020-10-10 | Cocke | Tennessee | 47029 | 848 | 11 |
614719 | 614719 | 2020-10-09 | Cocke | Tennessee | 47029 | 843 | 11 |
611478 | 611478 | 2020-10-08 | Cocke | Tennessee | 47029 | 836 | 11 |
608236 | 608236 | 2020-10-07 | Cocke | Tennessee | 47029 | 821 | 11 |
604993 | 604993 | 2020-10-06 | Cocke | Tennessee | 47029 | 806 | 11 |
601751 | 601751 | 2020-10-05 | Cocke | Tennessee | 47029 | 793 | 11 |
598508 | 598508 | 2020-10-04 | Cocke | Tennessee | 47029 | 781 | 11 |
595265 | 595265 | 2020-10-03 | Cocke | Tennessee | 47029 | 776 | 11 |
592024 | 592024 | 2020-10-02 | Cocke | Tennessee | 47029 | 774 | 10 |
588783 | 588783 | 2020-10-01 | Cocke | Tennessee | 47029 | 765 | 10 |
585543 | 585543 | 2020-09-30 | Cocke | Tennessee | 47029 | 759 | 10 |
582303 | 582303 | 2020-09-29 | Cocke | Tennessee | 47029 | 753 | 10 |
579063 | 579063 | 2020-09-28 | Cocke | Tennessee | 47029 | 753 | 10 |
575822 | 575822 | 2020-09-27 | Cocke | Tennessee | 47029 | 754 | 9 |
572578 | 572578 | 2020-09-26 | Cocke | Tennessee | 47029 | 746 | 9 |
569336 | 569336 | 2020-09-25 | Cocke | Tennessee | 47029 | 743 | 9 |
566095 | 566095 | 2020-09-24 | Cocke | Tennessee | 47029 | 741 | 9 |
562854 | 562854 | 2020-09-23 | Cocke | Tennessee | 47029 | 737 | 9 |
559617 | 559617 | 2020-09-22 | Cocke | Tennessee | 47029 | 736 | 9 |
556380 | 556380 | 2020-09-21 | Cocke | Tennessee | 47029 | 734 | 9 |
553143 | 553143 | 2020-09-20 | Cocke | Tennessee | 47029 | 732 | 9 |
549904 | 549904 | 2020-09-19 | Cocke | Tennessee | 47029 | 730 | 9 |
546665 | 546665 | 2020-09-18 | Cocke | Tennessee | 47029 | 724 | 9 |
543428 | 543428 | 2020-09-17 | Cocke | Tennessee | 47029 | 720 | 9 |
540192 | 540192 | 2020-09-16 | Cocke | Tennessee | 47029 | 719 | 9 |
536955 | 536955 | 2020-09-15 | Cocke | Tennessee | 47029 | 712 | 9 |
533719 | 533719 | 2020-09-14 | Cocke | Tennessee | 47029 | 712 | 9 |
530484 | 530484 | 2020-09-13 | Cocke | Tennessee | 47029 | 709 | 9 |
527247 | 527247 | 2020-09-12 | Cocke | Tennessee | 47029 | 708 | 9 |
524011 | 524011 | 2020-09-11 | Cocke | Tennessee | 47029 | 706 | 8 |
520775 | 520775 | 2020-09-10 | Cocke | Tennessee | 47029 | 697 | 7 |
517539 | 517539 | 2020-09-09 | Cocke | Tennessee | 47029 | 672 | 7 |
514304 | 514304 | 2020-09-08 | Cocke | Tennessee | 47029 | 671 | 7 |
511071 | 511071 | 2020-09-07 | Cocke | Tennessee | 47029 | 673 | 7 |
507838 | 507838 | 2020-09-06 | Cocke | Tennessee | 47029 | 670 | 7 |
504606 | 504606 | 2020-09-05 | Cocke | Tennessee | 47029 | 665 | 7 |
501372 | 501372 | 2020-09-04 | Cocke | Tennessee | 47029 | 655 | 7 |
498138 | 498138 | 2020-09-03 | Cocke | Tennessee | 47029 | 653 | 7 |
494905 | 494905 | 2020-09-02 | Cocke | Tennessee | 47029 | 652 | 7 |
491671 | 491671 | 2020-09-01 | Cocke | Tennessee | 47029 | 644 | 7 |
488438 | 488438 | 2020-08-31 | Cocke | Tennessee | 47029 | 642 | 7 |
485205 | 485205 | 2020-08-30 | Cocke | Tennessee | 47029 | 641 | 7 |
481970 | 481970 | 2020-08-29 | Cocke | Tennessee | 47029 | 639 | 7 |
478736 | 478736 | 2020-08-28 | Cocke | Tennessee | 47029 | 630 | 7 |
475503 | 475503 | 2020-08-27 | Cocke | Tennessee | 47029 | 622 | 7 |
472270 | 472270 | 2020-08-26 | Cocke | Tennessee | 47029 | 619 | 7 |
469038 | 469038 | 2020-08-25 | Cocke | Tennessee | 47029 | 612 | 6 |
465809 | 465809 | 2020-08-24 | Cocke | Tennessee | 47029 | 606 | 6 |
462580 | 462580 | 2020-08-23 | Cocke | Tennessee | 47029 | 600 | 6 |
459352 | 459352 | 2020-08-22 | Cocke | Tennessee | 47029 | 591 | 6 |
456124 | 456124 | 2020-08-21 | Cocke | Tennessee | 47029 | 588 | 6 |
452896 | 452896 | 2020-08-20 | Cocke | Tennessee | 47029 | 583 | 6 |
449668 | 449668 | 2020-08-19 | Cocke | Tennessee | 47029 | 578 | 6 |
446440 | 446440 | 2020-08-18 | Cocke | Tennessee | 47029 | 560 | 5 |
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);