ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where county = "Grundy" and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
955447 | 955447 | 2021-01-22 | Grundy | Tennessee | 47061 | 1426 | 22 |
952202 | 952202 | 2021-01-21 | Grundy | Tennessee | 47061 | 1414 | 22 |
948957 | 948957 | 2021-01-20 | Grundy | Tennessee | 47061 | 1403 | 21 |
945711 | 945711 | 2021-01-19 | Grundy | Tennessee | 47061 | 1393 | 21 |
942464 | 942464 | 2021-01-18 | Grundy | Tennessee | 47061 | 1393 | 21 |
939219 | 939219 | 2021-01-17 | Grundy | Tennessee | 47061 | 1393 | 20 |
935974 | 935974 | 2021-01-16 | Grundy | Tennessee | 47061 | 1391 | 20 |
932729 | 932729 | 2021-01-15 | Grundy | Tennessee | 47061 | 1382 | 20 |
929484 | 929484 | 2021-01-14 | Grundy | Tennessee | 47061 | 1374 | 20 |
926239 | 926239 | 2021-01-13 | Grundy | Tennessee | 47061 | 1371 | 20 |
922993 | 922993 | 2021-01-12 | Grundy | Tennessee | 47061 | 1359 | 20 |
919748 | 919748 | 2021-01-11 | Grundy | Tennessee | 47061 | 1353 | 20 |
916503 | 916503 | 2021-01-10 | Grundy | Tennessee | 47061 | 1348 | 20 |
913258 | 913258 | 2021-01-09 | Grundy | Tennessee | 47061 | 1340 | 20 |
910013 | 910013 | 2021-01-08 | Grundy | Tennessee | 47061 | 1336 | 20 |
906768 | 906768 | 2021-01-07 | Grundy | Tennessee | 47061 | 1318 | 20 |
903522 | 903522 | 2021-01-06 | Grundy | Tennessee | 47061 | 1289 | 20 |
900277 | 900277 | 2021-01-05 | Grundy | Tennessee | 47061 | 1272 | 20 |
897032 | 897032 | 2021-01-04 | Grundy | Tennessee | 47061 | 1256 | 19 |
893786 | 893786 | 2021-01-03 | Grundy | Tennessee | 47061 | 1244 | 19 |
890540 | 890540 | 2021-01-02 | Grundy | Tennessee | 47061 | 1236 | 19 |
887293 | 887293 | 2021-01-01 | Grundy | Tennessee | 47061 | 1193 | 19 |
884048 | 884048 | 2020-12-31 | Grundy | Tennessee | 47061 | 1193 | 19 |
880803 | 880803 | 2020-12-30 | Grundy | Tennessee | 47061 | 1186 | 18 |
877558 | 877558 | 2020-12-29 | Grundy | Tennessee | 47061 | 1170 | 18 |
874313 | 874313 | 2020-12-28 | Grundy | Tennessee | 47061 | 1162 | 16 |
871068 | 871068 | 2020-12-27 | Grundy | Tennessee | 47061 | 1155 | 16 |
867823 | 867823 | 2020-12-26 | Grundy | Tennessee | 47061 | 1153 | 15 |
864578 | 864578 | 2020-12-25 | Grundy | Tennessee | 47061 | 1149 | 15 |
861333 | 861333 | 2020-12-24 | Grundy | Tennessee | 47061 | 1122 | 15 |
858088 | 858088 | 2020-12-23 | Grundy | Tennessee | 47061 | 1109 | 15 |
854843 | 854843 | 2020-12-22 | Grundy | Tennessee | 47061 | 1092 | 15 |
851598 | 851598 | 2020-12-21 | Grundy | Tennessee | 47061 | 1082 | 15 |
848353 | 848353 | 2020-12-20 | Grundy | Tennessee | 47061 | 1068 | 15 |
845108 | 845108 | 2020-12-19 | Grundy | Tennessee | 47061 | 1056 | 14 |
841862 | 841862 | 2020-12-18 | Grundy | Tennessee | 47061 | 1045 | 14 |
838617 | 838617 | 2020-12-17 | Grundy | Tennessee | 47061 | 1030 | 14 |
835371 | 835371 | 2020-12-16 | Grundy | Tennessee | 47061 | 1002 | 14 |
832125 | 832125 | 2020-12-15 | Grundy | Tennessee | 47061 | 978 | 14 |
828878 | 828878 | 2020-12-14 | Grundy | Tennessee | 47061 | 962 | 14 |
825632 | 825632 | 2020-12-13 | Grundy | Tennessee | 47061 | 943 | 14 |
822385 | 822385 | 2020-12-12 | Grundy | Tennessee | 47061 | 913 | 14 |
819139 | 819139 | 2020-12-11 | Grundy | Tennessee | 47061 | 906 | 14 |
815893 | 815893 | 2020-12-10 | Grundy | Tennessee | 47061 | 898 | 14 |
812647 | 812647 | 2020-12-09 | Grundy | Tennessee | 47061 | 881 | 14 |
809403 | 809403 | 2020-12-08 | Grundy | Tennessee | 47061 | 865 | 14 |
806158 | 806158 | 2020-12-07 | Grundy | Tennessee | 47061 | 854 | 14 |
802913 | 802913 | 2020-12-06 | Grundy | Tennessee | 47061 | 840 | 14 |
799668 | 799668 | 2020-12-05 | Grundy | Tennessee | 47061 | 824 | 14 |
796423 | 796423 | 2020-12-04 | Grundy | Tennessee | 47061 | 815 | 14 |
793178 | 793178 | 2020-12-03 | Grundy | Tennessee | 47061 | 806 | 14 |
789933 | 789933 | 2020-12-02 | Grundy | Tennessee | 47061 | 803 | 14 |
786688 | 786688 | 2020-12-01 | Grundy | Tennessee | 47061 | 800 | 14 |
783444 | 783444 | 2020-11-30 | Grundy | Tennessee | 47061 | 792 | 14 |
780199 | 780199 | 2020-11-29 | Grundy | Tennessee | 47061 | 779 | 14 |
776953 | 776953 | 2020-11-28 | Grundy | Tennessee | 47061 | 777 | 14 |
773708 | 773708 | 2020-11-27 | Grundy | Tennessee | 47061 | 769 | 14 |
770463 | 770463 | 2020-11-26 | Grundy | Tennessee | 47061 | 756 | 14 |
767217 | 767217 | 2020-11-25 | Grundy | Tennessee | 47061 | 749 | 14 |
763972 | 763972 | 2020-11-24 | Grundy | Tennessee | 47061 | 742 | 14 |
760727 | 760727 | 2020-11-23 | Grundy | Tennessee | 47061 | 742 | 14 |
757482 | 757482 | 2020-11-22 | Grundy | Tennessee | 47061 | 734 | 14 |
754235 | 754235 | 2020-11-21 | Grundy | Tennessee | 47061 | 727 | 14 |
750989 | 750989 | 2020-11-20 | Grundy | Tennessee | 47061 | 720 | 14 |
747743 | 747743 | 2020-11-19 | Grundy | Tennessee | 47061 | 714 | 14 |
744497 | 744497 | 2020-11-18 | Grundy | Tennessee | 47061 | 708 | 14 |
741250 | 741250 | 2020-11-17 | Grundy | Tennessee | 47061 | 704 | 14 |
738004 | 738004 | 2020-11-16 | Grundy | Tennessee | 47061 | 701 | 14 |
734760 | 734760 | 2020-11-15 | Grundy | Tennessee | 47061 | 694 | 14 |
731514 | 731514 | 2020-11-14 | Grundy | Tennessee | 47061 | 682 | 14 |
728270 | 728270 | 2020-11-13 | Grundy | Tennessee | 47061 | 672 | 14 |
725026 | 725026 | 2020-11-12 | Grundy | Tennessee | 47061 | 668 | 15 |
721783 | 721783 | 2020-11-11 | Grundy | Tennessee | 47061 | 651 | 15 |
718540 | 718540 | 2020-11-10 | Grundy | Tennessee | 47061 | 648 | 15 |
715297 | 715297 | 2020-11-09 | Grundy | Tennessee | 47061 | 642 | 14 |
712053 | 712053 | 2020-11-08 | Grundy | Tennessee | 47061 | 641 | 14 |
708809 | 708809 | 2020-11-07 | Grundy | Tennessee | 47061 | 639 | 14 |
705566 | 705566 | 2020-11-06 | Grundy | Tennessee | 47061 | 633 | 14 |
702323 | 702323 | 2020-11-05 | Grundy | Tennessee | 47061 | 630 | 14 |
699079 | 699079 | 2020-11-04 | Grundy | Tennessee | 47061 | 628 | 14 |
695836 | 695836 | 2020-11-03 | Grundy | Tennessee | 47061 | 617 | 14 |
692594 | 692594 | 2020-11-02 | Grundy | Tennessee | 47061 | 609 | 14 |
689350 | 689350 | 2020-11-01 | Grundy | Tennessee | 47061 | 605 | 13 |
686105 | 686105 | 2020-10-31 | Grundy | Tennessee | 47061 | 605 | 13 |
682862 | 682862 | 2020-10-30 | Grundy | Tennessee | 47061 | 600 | 13 |
679619 | 679619 | 2020-10-29 | Grundy | Tennessee | 47061 | 587 | 12 |
676376 | 676376 | 2020-10-28 | Grundy | Tennessee | 47061 | 585 | 11 |
673133 | 673133 | 2020-10-27 | Grundy | Tennessee | 47061 | 578 | 11 |
669891 | 669891 | 2020-10-26 | Grundy | Tennessee | 47061 | 575 | 11 |
666647 | 666647 | 2020-10-25 | Grundy | Tennessee | 47061 | 570 | 11 |
663402 | 663402 | 2020-10-24 | Grundy | Tennessee | 47061 | 553 | 11 |
660158 | 660158 | 2020-10-23 | Grundy | Tennessee | 47061 | 545 | 11 |
656914 | 656914 | 2020-10-22 | Grundy | Tennessee | 47061 | 535 | 11 |
653669 | 653669 | 2020-10-21 | Grundy | Tennessee | 47061 | 525 | 10 |
650424 | 650424 | 2020-10-20 | Grundy | Tennessee | 47061 | 524 | 8 |
647180 | 647180 | 2020-10-19 | Grundy | Tennessee | 47061 | 516 | 8 |
643934 | 643934 | 2020-10-18 | Grundy | Tennessee | 47061 | 504 | 8 |
640686 | 640686 | 2020-10-17 | Grundy | Tennessee | 47061 | 498 | 8 |
637440 | 637440 | 2020-10-16 | Grundy | Tennessee | 47061 | 488 | 8 |
634194 | 634194 | 2020-10-15 | Grundy | Tennessee | 47061 | 483 | 8 |
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);