ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 47029 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1091747 | 1091747 | 2021-03-05 | Cocke | Tennessee | 47029 | 4025 | 96 |
1088501 | 1088501 | 2021-03-04 | Cocke | Tennessee | 47029 | 4012 | 95 |
1085256 | 1085256 | 2021-03-03 | Cocke | Tennessee | 47029 | 4001 | 93 |
1082010 | 1082010 | 2021-03-02 | Cocke | Tennessee | 47029 | 3990 | 93 |
1078764 | 1078764 | 2021-03-01 | Cocke | Tennessee | 47029 | 3989 | 93 |
1075519 | 1075519 | 2021-02-28 | Cocke | Tennessee | 47029 | 3975 | 93 |
1072273 | 1072273 | 2021-02-27 | Cocke | Tennessee | 47029 | 3973 | 92 |
1069027 | 1069027 | 2021-02-26 | Cocke | Tennessee | 47029 | 3972 | 92 |
1065782 | 1065782 | 2021-02-25 | Cocke | Tennessee | 47029 | 3968 | 92 |
1062537 | 1062537 | 2021-02-24 | Cocke | Tennessee | 47029 | 3961 | 92 |
1059292 | 1059292 | 2021-02-23 | Cocke | Tennessee | 47029 | 3956 | 91 |
1056046 | 1056046 | 2021-02-22 | Cocke | Tennessee | 47029 | 3951 | 91 |
1052800 | 1052800 | 2021-02-21 | Cocke | Tennessee | 47029 | 3948 | 91 |
1049553 | 1049553 | 2021-02-20 | Cocke | Tennessee | 47029 | 3943 | 91 |
1046306 | 1046306 | 2021-02-19 | Cocke | Tennessee | 47029 | 3933 | 91 |
1043061 | 1043061 | 2021-02-18 | Cocke | Tennessee | 47029 | 3932 | 91 |
1039816 | 1039816 | 2021-02-17 | Cocke | Tennessee | 47029 | 3926 | 91 |
1036571 | 1036571 | 2021-02-16 | Cocke | Tennessee | 47029 | 3919 | 91 |
1033326 | 1033326 | 2021-02-15 | Cocke | Tennessee | 47029 | 3905 | 90 |
1030080 | 1030080 | 2021-02-14 | Cocke | Tennessee | 47029 | 3881 | 90 |
1026833 | 1026833 | 2021-02-13 | Cocke | Tennessee | 47029 | 3855 | 89 |
1023588 | 1023588 | 2021-02-12 | Cocke | Tennessee | 47029 | 3828 | 89 |
1020343 | 1020343 | 2021-02-11 | Cocke | Tennessee | 47029 | 3817 | 87 |
1017098 | 1017098 | 2021-02-10 | Cocke | Tennessee | 47029 | 3788 | 85 |
1013853 | 1013853 | 2021-02-09 | Cocke | Tennessee | 47029 | 3778 | 85 |
1010608 | 1010608 | 2021-02-08 | Cocke | Tennessee | 47029 | 3777 | 85 |
1007362 | 1007362 | 2021-02-07 | Cocke | Tennessee | 47029 | 3770 | 84 |
1004116 | 1004116 | 2021-02-06 | Cocke | Tennessee | 47029 | 3762 | 84 |
1000870 | 1000870 | 2021-02-05 | Cocke | Tennessee | 47029 | 3746 | 83 |
997624 | 997624 | 2021-02-04 | Cocke | Tennessee | 47029 | 3734 | 80 |
994378 | 994378 | 2021-02-03 | Cocke | Tennessee | 47029 | 3725 | 78 |
991132 | 991132 | 2021-02-02 | Cocke | Tennessee | 47029 | 3710 | 75 |
987886 | 987886 | 2021-02-01 | Cocke | Tennessee | 47029 | 3698 | 73 |
984639 | 984639 | 2021-01-31 | Cocke | Tennessee | 47029 | 3695 | 71 |
981392 | 981392 | 2021-01-30 | Cocke | Tennessee | 47029 | 3670 | 71 |
978146 | 978146 | 2021-01-29 | Cocke | Tennessee | 47029 | 3660 | 70 |
974901 | 974901 | 2021-01-28 | Cocke | Tennessee | 47029 | 3635 | 70 |
971656 | 971656 | 2021-01-27 | Cocke | Tennessee | 47029 | 3623 | 69 |
968411 | 968411 | 2021-01-26 | Cocke | Tennessee | 47029 | 3606 | 66 |
965167 | 965167 | 2021-01-25 | Cocke | Tennessee | 47029 | 3590 | 63 |
961922 | 961922 | 2021-01-24 | Cocke | Tennessee | 47029 | 3565 | 61 |
958677 | 958677 | 2021-01-23 | Cocke | Tennessee | 47029 | 3557 | 60 |
955431 | 955431 | 2021-01-22 | Cocke | Tennessee | 47029 | 3527 | 58 |
952186 | 952186 | 2021-01-21 | Cocke | Tennessee | 47029 | 3502 | 57 |
948941 | 948941 | 2021-01-20 | Cocke | Tennessee | 47029 | 3486 | 57 |
945695 | 945695 | 2021-01-19 | Cocke | Tennessee | 47029 | 3456 | 56 |
942448 | 942448 | 2021-01-18 | Cocke | Tennessee | 47029 | 3438 | 56 |
939203 | 939203 | 2021-01-17 | Cocke | Tennessee | 47029 | 3428 | 56 |
935958 | 935958 | 2021-01-16 | Cocke | Tennessee | 47029 | 3412 | 56 |
932713 | 932713 | 2021-01-15 | Cocke | Tennessee | 47029 | 3389 | 56 |
929468 | 929468 | 2021-01-14 | Cocke | Tennessee | 47029 | 3366 | 55 |
926223 | 926223 | 2021-01-13 | Cocke | Tennessee | 47029 | 3336 | 55 |
922977 | 922977 | 2021-01-12 | Cocke | Tennessee | 47029 | 3312 | 55 |
919732 | 919732 | 2021-01-11 | Cocke | Tennessee | 47029 | 3285 | 54 |
916487 | 916487 | 2021-01-10 | Cocke | Tennessee | 47029 | 3270 | 52 |
913242 | 913242 | 2021-01-09 | Cocke | Tennessee | 47029 | 3214 | 52 |
909997 | 909997 | 2021-01-08 | Cocke | Tennessee | 47029 | 3188 | 52 |
906752 | 906752 | 2021-01-07 | Cocke | Tennessee | 47029 | 3137 | 51 |
903506 | 903506 | 2021-01-06 | Cocke | Tennessee | 47029 | 3112 | 51 |
900261 | 900261 | 2021-01-05 | Cocke | Tennessee | 47029 | 3059 | 50 |
897016 | 897016 | 2021-01-04 | Cocke | Tennessee | 47029 | 3028 | 47 |
893770 | 893770 | 2021-01-03 | Cocke | Tennessee | 47029 | 2995 | 47 |
890524 | 890524 | 2021-01-02 | Cocke | Tennessee | 47029 | 2968 | 45 |
887277 | 887277 | 2021-01-01 | Cocke | Tennessee | 47029 | 2841 | 44 |
884032 | 884032 | 2020-12-31 | Cocke | Tennessee | 47029 | 2841 | 44 |
880787 | 880787 | 2020-12-30 | Cocke | Tennessee | 47029 | 2814 | 40 |
877542 | 877542 | 2020-12-29 | Cocke | Tennessee | 47029 | 2762 | 39 |
874297 | 874297 | 2020-12-28 | Cocke | Tennessee | 47029 | 2739 | 39 |
871052 | 871052 | 2020-12-27 | Cocke | Tennessee | 47029 | 2704 | 39 |
867807 | 867807 | 2020-12-26 | Cocke | Tennessee | 47029 | 2674 | 39 |
864562 | 864562 | 2020-12-25 | Cocke | Tennessee | 47029 | 2645 | 39 |
861317 | 861317 | 2020-12-24 | Cocke | Tennessee | 47029 | 2596 | 39 |
858072 | 858072 | 2020-12-23 | Cocke | Tennessee | 47029 | 2587 | 39 |
854827 | 854827 | 2020-12-22 | Cocke | Tennessee | 47029 | 2514 | 39 |
851582 | 851582 | 2020-12-21 | Cocke | Tennessee | 47029 | 2488 | 37 |
848337 | 848337 | 2020-12-20 | Cocke | Tennessee | 47029 | 2433 | 37 |
845092 | 845092 | 2020-12-19 | Cocke | Tennessee | 47029 | 2386 | 35 |
841846 | 841846 | 2020-12-18 | Cocke | Tennessee | 47029 | 2330 | 35 |
838601 | 838601 | 2020-12-17 | Cocke | Tennessee | 47029 | 2276 | 34 |
835355 | 835355 | 2020-12-16 | Cocke | Tennessee | 47029 | 2228 | 33 |
832109 | 832109 | 2020-12-15 | Cocke | Tennessee | 47029 | 2139 | 33 |
828862 | 828862 | 2020-12-14 | Cocke | Tennessee | 47029 | 2098 | 32 |
825616 | 825616 | 2020-12-13 | Cocke | Tennessee | 47029 | 2052 | 32 |
822369 | 822369 | 2020-12-12 | Cocke | Tennessee | 47029 | 2001 | 32 |
819123 | 819123 | 2020-12-11 | Cocke | Tennessee | 47029 | 1971 | 31 |
815877 | 815877 | 2020-12-10 | Cocke | Tennessee | 47029 | 1924 | 30 |
812631 | 812631 | 2020-12-09 | Cocke | Tennessee | 47029 | 1896 | 30 |
809387 | 809387 | 2020-12-08 | Cocke | Tennessee | 47029 | 1835 | 30 |
806142 | 806142 | 2020-12-07 | Cocke | Tennessee | 47029 | 1815 | 30 |
802897 | 802897 | 2020-12-06 | Cocke | Tennessee | 47029 | 1770 | 30 |
799652 | 799652 | 2020-12-05 | Cocke | Tennessee | 47029 | 1756 | 30 |
796407 | 796407 | 2020-12-04 | Cocke | Tennessee | 47029 | 1744 | 30 |
793162 | 793162 | 2020-12-03 | Cocke | Tennessee | 47029 | 1720 | 30 |
789917 | 789917 | 2020-12-02 | Cocke | Tennessee | 47029 | 1692 | 30 |
786672 | 786672 | 2020-12-01 | Cocke | Tennessee | 47029 | 1683 | 30 |
783428 | 783428 | 2020-11-30 | Cocke | Tennessee | 47029 | 1653 | 30 |
780183 | 780183 | 2020-11-29 | Cocke | Tennessee | 47029 | 1623 | 30 |
776937 | 776937 | 2020-11-28 | Cocke | Tennessee | 47029 | 1606 | 30 |
773692 | 773692 | 2020-11-27 | Cocke | Tennessee | 47029 | 1595 | 30 |
770447 | 770447 | 2020-11-26 | Cocke | Tennessee | 47029 | 1583 | 30 |
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);