ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
773 rows where county = "Clay" and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1052799 | 1052799 | 2021-02-21 | Clay | Tennessee | 47027 | 1056 | 30 |
1049552 | 1049552 | 2021-02-20 | Clay | Tennessee | 47027 | 1056 | 30 |
1046305 | 1046305 | 2021-02-19 | Clay | Tennessee | 47027 | 1055 | 29 |
1043060 | 1043060 | 2021-02-18 | Clay | Tennessee | 47027 | 1055 | 29 |
1039815 | 1039815 | 2021-02-17 | Clay | Tennessee | 47027 | 1056 | 29 |
1036570 | 1036570 | 2021-02-16 | Clay | Tennessee | 47027 | 1056 | 29 |
1033325 | 1033325 | 2021-02-15 | Clay | Tennessee | 47027 | 1056 | 29 |
1030079 | 1030079 | 2021-02-14 | Clay | Tennessee | 47027 | 1056 | 29 |
1026832 | 1026832 | 2021-02-13 | Clay | Tennessee | 47027 | 1056 | 29 |
1023587 | 1023587 | 2021-02-12 | Clay | Tennessee | 47027 | 1055 | 29 |
1020342 | 1020342 | 2021-02-11 | Clay | Tennessee | 47027 | 1050 | 29 |
1017097 | 1017097 | 2021-02-10 | Clay | Tennessee | 47027 | 1043 | 29 |
1013852 | 1013852 | 2021-02-09 | Clay | Tennessee | 47027 | 1010 | 30 |
1010607 | 1010607 | 2021-02-08 | Clay | Tennessee | 47027 | 996 | 30 |
1007361 | 1007361 | 2021-02-07 | Clay | Tennessee | 47027 | 995 | 29 |
1004115 | 1004115 | 2021-02-06 | Clay | Tennessee | 47027 | 995 | 29 |
1000869 | 1000869 | 2021-02-05 | Clay | Tennessee | 47027 | 986 | 29 |
997623 | 997623 | 2021-02-04 | Clay | Tennessee | 47027 | 984 | 29 |
994377 | 994377 | 2021-02-03 | Clay | Tennessee | 47027 | 982 | 28 |
991131 | 991131 | 2021-02-02 | Clay | Tennessee | 47027 | 981 | 27 |
987885 | 987885 | 2021-02-01 | Clay | Tennessee | 47027 | 979 | 27 |
984638 | 984638 | 2021-01-31 | Clay | Tennessee | 47027 | 979 | 27 |
981391 | 981391 | 2021-01-30 | Clay | Tennessee | 47027 | 978 | 27 |
978145 | 978145 | 2021-01-29 | Clay | Tennessee | 47027 | 978 | 26 |
974900 | 974900 | 2021-01-28 | Clay | Tennessee | 47027 | 970 | 26 |
971655 | 971655 | 2021-01-27 | Clay | Tennessee | 47027 | 969 | 26 |
968410 | 968410 | 2021-01-26 | Clay | Tennessee | 47027 | 969 | 26 |
965166 | 965166 | 2021-01-25 | Clay | Tennessee | 47027 | 965 | 26 |
961921 | 961921 | 2021-01-24 | Clay | Tennessee | 47027 | 965 | 26 |
958676 | 958676 | 2021-01-23 | Clay | Tennessee | 47027 | 965 | 26 |
955430 | 955430 | 2021-01-22 | Clay | Tennessee | 47027 | 954 | 26 |
952185 | 952185 | 2021-01-21 | Clay | Tennessee | 47027 | 953 | 26 |
948940 | 948940 | 2021-01-20 | Clay | Tennessee | 47027 | 946 | 26 |
945694 | 945694 | 2021-01-19 | Clay | Tennessee | 47027 | 940 | 26 |
942447 | 942447 | 2021-01-18 | Clay | Tennessee | 47027 | 939 | 26 |
939202 | 939202 | 2021-01-17 | Clay | Tennessee | 47027 | 937 | 26 |
935957 | 935957 | 2021-01-16 | Clay | Tennessee | 47027 | 934 | 26 |
932712 | 932712 | 2021-01-15 | Clay | Tennessee | 47027 | 920 | 26 |
929467 | 929467 | 2021-01-14 | Clay | Tennessee | 47027 | 906 | 26 |
926222 | 926222 | 2021-01-13 | Clay | Tennessee | 47027 | 900 | 25 |
922976 | 922976 | 2021-01-12 | Clay | Tennessee | 47027 | 896 | 25 |
919731 | 919731 | 2021-01-11 | Clay | Tennessee | 47027 | 894 | 25 |
916486 | 916486 | 2021-01-10 | Clay | Tennessee | 47027 | 894 | 25 |
913241 | 913241 | 2021-01-09 | Clay | Tennessee | 47027 | 888 | 25 |
909996 | 909996 | 2021-01-08 | Clay | Tennessee | 47027 | 876 | 24 |
906751 | 906751 | 2021-01-07 | Clay | Tennessee | 47027 | 873 | 24 |
903505 | 903505 | 2021-01-06 | Clay | Tennessee | 47027 | 864 | 23 |
900260 | 900260 | 2021-01-05 | Clay | Tennessee | 47027 | 859 | 23 |
897015 | 897015 | 2021-01-04 | Clay | Tennessee | 47027 | 854 | 23 |
893769 | 893769 | 2021-01-03 | Clay | Tennessee | 47027 | 854 | 23 |
890523 | 890523 | 2021-01-02 | Clay | Tennessee | 47027 | 853 | 23 |
887276 | 887276 | 2021-01-01 | Clay | Tennessee | 47027 | 845 | 23 |
884031 | 884031 | 2020-12-31 | Clay | Tennessee | 47027 | 845 | 23 |
880786 | 880786 | 2020-12-30 | Clay | Tennessee | 47027 | 840 | 23 |
877541 | 877541 | 2020-12-29 | Clay | Tennessee | 47027 | 829 | 23 |
874296 | 874296 | 2020-12-28 | Clay | Tennessee | 47027 | 825 | 23 |
871051 | 871051 | 2020-12-27 | Clay | Tennessee | 47027 | 823 | 23 |
867806 | 867806 | 2020-12-26 | Clay | Tennessee | 47027 | 823 | 23 |
864561 | 864561 | 2020-12-25 | Clay | Tennessee | 47027 | 822 | 23 |
861316 | 861316 | 2020-12-24 | Clay | Tennessee | 47027 | 808 | 23 |
858071 | 858071 | 2020-12-23 | Clay | Tennessee | 47027 | 796 | 23 |
854826 | 854826 | 2020-12-22 | Clay | Tennessee | 47027 | 787 | 21 |
851581 | 851581 | 2020-12-21 | Clay | Tennessee | 47027 | 782 | 21 |
848336 | 848336 | 2020-12-20 | Clay | Tennessee | 47027 | 776 | 21 |
845091 | 845091 | 2020-12-19 | Clay | Tennessee | 47027 | 768 | 21 |
841845 | 841845 | 2020-12-18 | Clay | Tennessee | 47027 | 758 | 21 |
838600 | 838600 | 2020-12-17 | Clay | Tennessee | 47027 | 740 | 21 |
835354 | 835354 | 2020-12-16 | Clay | Tennessee | 47027 | 706 | 19 |
832108 | 832108 | 2020-12-15 | Clay | Tennessee | 47027 | 687 | 19 |
828861 | 828861 | 2020-12-14 | Clay | Tennessee | 47027 | 676 | 19 |
825615 | 825615 | 2020-12-13 | Clay | Tennessee | 47027 | 663 | 19 |
822368 | 822368 | 2020-12-12 | Clay | Tennessee | 47027 | 655 | 19 |
819122 | 819122 | 2020-12-11 | Clay | Tennessee | 47027 | 647 | 19 |
815876 | 815876 | 2020-12-10 | Clay | Tennessee | 47027 | 629 | 19 |
812630 | 812630 | 2020-12-09 | Clay | Tennessee | 47027 | 614 | 19 |
809386 | 809386 | 2020-12-08 | Clay | Tennessee | 47027 | 610 | 19 |
806141 | 806141 | 2020-12-07 | Clay | Tennessee | 47027 | 605 | 19 |
802896 | 802896 | 2020-12-06 | Clay | Tennessee | 47027 | 596 | 19 |
799651 | 799651 | 2020-12-05 | Clay | Tennessee | 47027 | 586 | 19 |
796406 | 796406 | 2020-12-04 | Clay | Tennessee | 47027 | 578 | 19 |
793161 | 793161 | 2020-12-03 | Clay | Tennessee | 47027 | 571 | 19 |
789916 | 789916 | 2020-12-02 | Clay | Tennessee | 47027 | 571 | 18 |
786671 | 786671 | 2020-12-01 | Clay | Tennessee | 47027 | 562 | 18 |
783427 | 783427 | 2020-11-30 | Clay | Tennessee | 47027 | 560 | 18 |
780182 | 780182 | 2020-11-29 | Clay | Tennessee | 47027 | 554 | 18 |
776936 | 776936 | 2020-11-28 | Clay | Tennessee | 47027 | 553 | 18 |
773691 | 773691 | 2020-11-27 | Clay | Tennessee | 47027 | 540 | 18 |
770446 | 770446 | 2020-11-26 | Clay | Tennessee | 47027 | 538 | 18 |
767200 | 767200 | 2020-11-25 | Clay | Tennessee | 47027 | 533 | 18 |
763955 | 763955 | 2020-11-24 | Clay | Tennessee | 47027 | 528 | 18 |
760710 | 760710 | 2020-11-23 | Clay | Tennessee | 47027 | 525 | 18 |
757465 | 757465 | 2020-11-22 | Clay | Tennessee | 47027 | 524 | 18 |
754218 | 754218 | 2020-11-21 | Clay | Tennessee | 47027 | 520 | 18 |
750972 | 750972 | 2020-11-20 | Clay | Tennessee | 47027 | 519 | 18 |
747726 | 747726 | 2020-11-19 | Clay | Tennessee | 47027 | 510 | 18 |
744480 | 744480 | 2020-11-18 | Clay | Tennessee | 47027 | 497 | 17 |
741233 | 741233 | 2020-11-17 | Clay | Tennessee | 47027 | 485 | 17 |
737987 | 737987 | 2020-11-16 | Clay | Tennessee | 47027 | 479 | 17 |
734743 | 734743 | 2020-11-15 | Clay | Tennessee | 47027 | 474 | 16 |
731497 | 731497 | 2020-11-14 | Clay | Tennessee | 47027 | 470 | 16 |
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);