ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 47021 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1091743 | 1091743 | 2021-03-05 | Cheatham | Tennessee | 47021 | 3963 | 44 |
1088497 | 1088497 | 2021-03-04 | Cheatham | Tennessee | 47021 | 3945 | 44 |
1085252 | 1085252 | 2021-03-03 | Cheatham | Tennessee | 47021 | 3930 | 44 |
1082006 | 1082006 | 2021-03-02 | Cheatham | Tennessee | 47021 | 3912 | 44 |
1078760 | 1078760 | 2021-03-01 | Cheatham | Tennessee | 47021 | 3910 | 43 |
1075515 | 1075515 | 2021-02-28 | Cheatham | Tennessee | 47021 | 3905 | 43 |
1072269 | 1072269 | 2021-02-27 | Cheatham | Tennessee | 47021 | 3900 | 44 |
1069023 | 1069023 | 2021-02-26 | Cheatham | Tennessee | 47021 | 3894 | 44 |
1065778 | 1065778 | 2021-02-25 | Cheatham | Tennessee | 47021 | 3868 | 44 |
1062533 | 1062533 | 2021-02-24 | Cheatham | Tennessee | 47021 | 3857 | 43 |
1059288 | 1059288 | 2021-02-23 | Cheatham | Tennessee | 47021 | 3851 | 43 |
1056042 | 1056042 | 2021-02-22 | Cheatham | Tennessee | 47021 | 3840 | 43 |
1052796 | 1052796 | 2021-02-21 | Cheatham | Tennessee | 47021 | 3834 | 43 |
1049549 | 1049549 | 2021-02-20 | Cheatham | Tennessee | 47021 | 3830 | 43 |
1046302 | 1046302 | 2021-02-19 | Cheatham | Tennessee | 47021 | 3815 | 43 |
1043057 | 1043057 | 2021-02-18 | Cheatham | Tennessee | 47021 | 3812 | 43 |
1039812 | 1039812 | 2021-02-17 | Cheatham | Tennessee | 47021 | 3805 | 43 |
1036567 | 1036567 | 2021-02-16 | Cheatham | Tennessee | 47021 | 3803 | 43 |
1033322 | 1033322 | 2021-02-15 | Cheatham | Tennessee | 47021 | 3801 | 41 |
1030076 | 1030076 | 2021-02-14 | Cheatham | Tennessee | 47021 | 3793 | 41 |
1026829 | 1026829 | 2021-02-13 | Cheatham | Tennessee | 47021 | 3778 | 41 |
1023584 | 1023584 | 2021-02-12 | Cheatham | Tennessee | 47021 | 3769 | 41 |
1020339 | 1020339 | 2021-02-11 | Cheatham | Tennessee | 47021 | 3739 | 40 |
1017094 | 1017094 | 2021-02-10 | Cheatham | Tennessee | 47021 | 3719 | 39 |
1013849 | 1013849 | 2021-02-09 | Cheatham | Tennessee | 47021 | 3712 | 39 |
1010604 | 1010604 | 2021-02-08 | Cheatham | Tennessee | 47021 | 3704 | 38 |
1007358 | 1007358 | 2021-02-07 | Cheatham | Tennessee | 47021 | 3700 | 38 |
1004112 | 1004112 | 2021-02-06 | Cheatham | Tennessee | 47021 | 3680 | 38 |
1000866 | 1000866 | 2021-02-05 | Cheatham | Tennessee | 47021 | 3667 | 38 |
997620 | 997620 | 2021-02-04 | Cheatham | Tennessee | 47021 | 3652 | 34 |
994374 | 994374 | 2021-02-03 | Cheatham | Tennessee | 47021 | 3638 | 34 |
991128 | 991128 | 2021-02-02 | Cheatham | Tennessee | 47021 | 3631 | 34 |
987882 | 987882 | 2021-02-01 | Cheatham | Tennessee | 47021 | 3615 | 34 |
984635 | 984635 | 2021-01-31 | Cheatham | Tennessee | 47021 | 3609 | 33 |
981388 | 981388 | 2021-01-30 | Cheatham | Tennessee | 47021 | 3593 | 33 |
978142 | 978142 | 2021-01-29 | Cheatham | Tennessee | 47021 | 3582 | 33 |
974897 | 974897 | 2021-01-28 | Cheatham | Tennessee | 47021 | 3534 | 33 |
971652 | 971652 | 2021-01-27 | Cheatham | Tennessee | 47021 | 3529 | 33 |
968407 | 968407 | 2021-01-26 | Cheatham | Tennessee | 47021 | 3512 | 32 |
965163 | 965163 | 2021-01-25 | Cheatham | Tennessee | 47021 | 3503 | 32 |
961918 | 961918 | 2021-01-24 | Cheatham | Tennessee | 47021 | 3495 | 31 |
958673 | 958673 | 2021-01-23 | Cheatham | Tennessee | 47021 | 3485 | 31 |
955427 | 955427 | 2021-01-22 | Cheatham | Tennessee | 47021 | 3473 | 31 |
952182 | 952182 | 2021-01-21 | Cheatham | Tennessee | 47021 | 3457 | 31 |
948937 | 948937 | 2021-01-20 | Cheatham | Tennessee | 47021 | 3439 | 30 |
945691 | 945691 | 2021-01-19 | Cheatham | Tennessee | 47021 | 3381 | 30 |
942444 | 942444 | 2021-01-18 | Cheatham | Tennessee | 47021 | 3362 | 30 |
939199 | 939199 | 2021-01-17 | Cheatham | Tennessee | 47021 | 3352 | 30 |
935954 | 935954 | 2021-01-16 | Cheatham | Tennessee | 47021 | 3335 | 29 |
932709 | 932709 | 2021-01-15 | Cheatham | Tennessee | 47021 | 3305 | 28 |
929464 | 929464 | 2021-01-14 | Cheatham | Tennessee | 47021 | 3285 | 28 |
926219 | 926219 | 2021-01-13 | Cheatham | Tennessee | 47021 | 3265 | 28 |
922973 | 922973 | 2021-01-12 | Cheatham | Tennessee | 47021 | 3247 | 28 |
919728 | 919728 | 2021-01-11 | Cheatham | Tennessee | 47021 | 3219 | 28 |
916483 | 916483 | 2021-01-10 | Cheatham | Tennessee | 47021 | 3199 | 28 |
913238 | 913238 | 2021-01-09 | Cheatham | Tennessee | 47021 | 3168 | 28 |
909993 | 909993 | 2021-01-08 | Cheatham | Tennessee | 47021 | 3140 | 28 |
906748 | 906748 | 2021-01-07 | Cheatham | Tennessee | 47021 | 3128 | 28 |
903502 | 903502 | 2021-01-06 | Cheatham | Tennessee | 47021 | 3068 | 27 |
900257 | 900257 | 2021-01-05 | Cheatham | Tennessee | 47021 | 3030 | 27 |
897012 | 897012 | 2021-01-04 | Cheatham | Tennessee | 47021 | 3006 | 25 |
893766 | 893766 | 2021-01-03 | Cheatham | Tennessee | 47021 | 2981 | 24 |
890520 | 890520 | 2021-01-02 | Cheatham | Tennessee | 47021 | 2966 | 24 |
887273 | 887273 | 2021-01-01 | Cheatham | Tennessee | 47021 | 2865 | 24 |
884028 | 884028 | 2020-12-31 | Cheatham | Tennessee | 47021 | 2865 | 24 |
880783 | 880783 | 2020-12-30 | Cheatham | Tennessee | 47021 | 2831 | 24 |
877538 | 877538 | 2020-12-29 | Cheatham | Tennessee | 47021 | 2787 | 24 |
874293 | 874293 | 2020-12-28 | Cheatham | Tennessee | 47021 | 2755 | 23 |
871048 | 871048 | 2020-12-27 | Cheatham | Tennessee | 47021 | 2735 | 23 |
867803 | 867803 | 2020-12-26 | Cheatham | Tennessee | 47021 | 2721 | 22 |
864558 | 864558 | 2020-12-25 | Cheatham | Tennessee | 47021 | 2694 | 22 |
861313 | 861313 | 2020-12-24 | Cheatham | Tennessee | 47021 | 2642 | 22 |
858068 | 858068 | 2020-12-23 | Cheatham | Tennessee | 47021 | 2609 | 21 |
854823 | 854823 | 2020-12-22 | Cheatham | Tennessee | 47021 | 2556 | 21 |
851578 | 851578 | 2020-12-21 | Cheatham | Tennessee | 47021 | 2518 | 21 |
848333 | 848333 | 2020-12-20 | Cheatham | Tennessee | 47021 | 2474 | 19 |
845088 | 845088 | 2020-12-19 | Cheatham | Tennessee | 47021 | 2404 | 19 |
841842 | 841842 | 2020-12-18 | Cheatham | Tennessee | 47021 | 2378 | 18 |
838597 | 838597 | 2020-12-17 | Cheatham | Tennessee | 47021 | 2316 | 18 |
835351 | 835351 | 2020-12-16 | Cheatham | Tennessee | 47021 | 2248 | 18 |
832105 | 832105 | 2020-12-15 | Cheatham | Tennessee | 47021 | 2185 | 18 |
828858 | 828858 | 2020-12-14 | Cheatham | Tennessee | 47021 | 2146 | 18 |
825612 | 825612 | 2020-12-13 | Cheatham | Tennessee | 47021 | 2066 | 18 |
822365 | 822365 | 2020-12-12 | Cheatham | Tennessee | 47021 | 2004 | 18 |
819119 | 819119 | 2020-12-11 | Cheatham | Tennessee | 47021 | 1974 | 18 |
815873 | 815873 | 2020-12-10 | Cheatham | Tennessee | 47021 | 1937 | 18 |
812627 | 812627 | 2020-12-09 | Cheatham | Tennessee | 47021 | 1879 | 18 |
809383 | 809383 | 2020-12-08 | Cheatham | Tennessee | 47021 | 1842 | 18 |
806138 | 806138 | 2020-12-07 | Cheatham | Tennessee | 47021 | 1802 | 17 |
802893 | 802893 | 2020-12-06 | Cheatham | Tennessee | 47021 | 1747 | 17 |
799648 | 799648 | 2020-12-05 | Cheatham | Tennessee | 47021 | 1742 | 17 |
796403 | 796403 | 2020-12-04 | Cheatham | Tennessee | 47021 | 1720 | 17 |
793158 | 793158 | 2020-12-03 | Cheatham | Tennessee | 47021 | 1696 | 17 |
789913 | 789913 | 2020-12-02 | Cheatham | Tennessee | 47021 | 1694 | 17 |
786668 | 786668 | 2020-12-01 | Cheatham | Tennessee | 47021 | 1685 | 17 |
783424 | 783424 | 2020-11-30 | Cheatham | Tennessee | 47021 | 1653 | 17 |
780179 | 780179 | 2020-11-29 | Cheatham | Tennessee | 47021 | 1598 | 17 |
776933 | 776933 | 2020-11-28 | Cheatham | Tennessee | 47021 | 1586 | 17 |
773688 | 773688 | 2020-11-27 | Cheatham | Tennessee | 47021 | 1553 | 17 |
770443 | 770443 | 2020-11-26 | Cheatham | Tennessee | 47021 | 1528 | 17 |
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);