ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 47167 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1091816 | 1091816 | 2021-03-05 | Tipton | Tennessee | 47167 | 6972 | 103 |
1088570 | 1088570 | 2021-03-04 | Tipton | Tennessee | 47167 | 6962 | 103 |
1085325 | 1085325 | 2021-03-03 | Tipton | Tennessee | 47167 | 6953 | 103 |
1082079 | 1082079 | 2021-03-02 | Tipton | Tennessee | 47167 | 6948 | 103 |
1078833 | 1078833 | 2021-03-01 | Tipton | Tennessee | 47167 | 6950 | 103 |
1075588 | 1075588 | 2021-02-28 | Tipton | Tennessee | 47167 | 6945 | 103 |
1072342 | 1072342 | 2021-02-27 | Tipton | Tennessee | 47167 | 6935 | 101 |
1069096 | 1069096 | 2021-02-26 | Tipton | Tennessee | 47167 | 6919 | 101 |
1065851 | 1065851 | 2021-02-25 | Tipton | Tennessee | 47167 | 6908 | 101 |
1062606 | 1062606 | 2021-02-24 | Tipton | Tennessee | 47167 | 6896 | 101 |
1059361 | 1059361 | 2021-02-23 | Tipton | Tennessee | 47167 | 6886 | 99 |
1056115 | 1056115 | 2021-02-22 | Tipton | Tennessee | 47167 | 6871 | 99 |
1052869 | 1052869 | 2021-02-21 | Tipton | Tennessee | 47167 | 6870 | 99 |
1049622 | 1049622 | 2021-02-20 | Tipton | Tennessee | 47167 | 6865 | 99 |
1046375 | 1046375 | 2021-02-19 | Tipton | Tennessee | 47167 | 6848 | 97 |
1043130 | 1043130 | 2021-02-18 | Tipton | Tennessee | 47167 | 6841 | 97 |
1039885 | 1039885 | 2021-02-17 | Tipton | Tennessee | 47167 | 6840 | 96 |
1036640 | 1036640 | 2021-02-16 | Tipton | Tennessee | 47167 | 6841 | 96 |
1033395 | 1033395 | 2021-02-15 | Tipton | Tennessee | 47167 | 6821 | 96 |
1030149 | 1030149 | 2021-02-14 | Tipton | Tennessee | 47167 | 6809 | 96 |
1026902 | 1026902 | 2021-02-13 | Tipton | Tennessee | 47167 | 6778 | 96 |
1023657 | 1023657 | 2021-02-12 | Tipton | Tennessee | 47167 | 6766 | 96 |
1020412 | 1020412 | 2021-02-11 | Tipton | Tennessee | 47167 | 6757 | 93 |
1017167 | 1017167 | 2021-02-10 | Tipton | Tennessee | 47167 | 6700 | 93 |
1013922 | 1013922 | 2021-02-09 | Tipton | Tennessee | 47167 | 6672 | 92 |
1010677 | 1010677 | 2021-02-08 | Tipton | Tennessee | 47167 | 6657 | 91 |
1007431 | 1007431 | 2021-02-07 | Tipton | Tennessee | 47167 | 6647 | 91 |
1004185 | 1004185 | 2021-02-06 | Tipton | Tennessee | 47167 | 6637 | 92 |
1000939 | 1000939 | 2021-02-05 | Tipton | Tennessee | 47167 | 6604 | 91 |
997693 | 997693 | 2021-02-04 | Tipton | Tennessee | 47167 | 6592 | 90 |
994447 | 994447 | 2021-02-03 | Tipton | Tennessee | 47167 | 6580 | 86 |
991201 | 991201 | 2021-02-02 | Tipton | Tennessee | 47167 | 6571 | 85 |
987955 | 987955 | 2021-02-01 | Tipton | Tennessee | 47167 | 6558 | 84 |
984708 | 984708 | 2021-01-31 | Tipton | Tennessee | 47167 | 6546 | 82 |
981461 | 981461 | 2021-01-30 | Tipton | Tennessee | 47167 | 6515 | 79 |
978215 | 978215 | 2021-01-29 | Tipton | Tennessee | 47167 | 6506 | 79 |
974970 | 974970 | 2021-01-28 | Tipton | Tennessee | 47167 | 6451 | 79 |
971725 | 971725 | 2021-01-27 | Tipton | Tennessee | 47167 | 6436 | 77 |
968480 | 968480 | 2021-01-26 | Tipton | Tennessee | 47167 | 6409 | 75 |
965236 | 965236 | 2021-01-25 | Tipton | Tennessee | 47167 | 6395 | 71 |
961991 | 961991 | 2021-01-24 | Tipton | Tennessee | 47167 | 6380 | 69 |
958746 | 958746 | 2021-01-23 | Tipton | Tennessee | 47167 | 6368 | 69 |
955500 | 955500 | 2021-01-22 | Tipton | Tennessee | 47167 | 6329 | 69 |
952255 | 952255 | 2021-01-21 | Tipton | Tennessee | 47167 | 6296 | 68 |
949010 | 949010 | 2021-01-20 | Tipton | Tennessee | 47167 | 6268 | 65 |
945764 | 945764 | 2021-01-19 | Tipton | Tennessee | 47167 | 6226 | 65 |
942517 | 942517 | 2021-01-18 | Tipton | Tennessee | 47167 | 6210 | 65 |
939272 | 939272 | 2021-01-17 | Tipton | Tennessee | 47167 | 6190 | 65 |
936027 | 936027 | 2021-01-16 | Tipton | Tennessee | 47167 | 6162 | 65 |
932782 | 932782 | 2021-01-15 | Tipton | Tennessee | 47167 | 6116 | 64 |
929537 | 929537 | 2021-01-14 | Tipton | Tennessee | 47167 | 6056 | 63 |
926292 | 926292 | 2021-01-13 | Tipton | Tennessee | 47167 | 6030 | 63 |
923046 | 923046 | 2021-01-12 | Tipton | Tennessee | 47167 | 5996 | 61 |
919801 | 919801 | 2021-01-11 | Tipton | Tennessee | 47167 | 5954 | 61 |
916556 | 916556 | 2021-01-10 | Tipton | Tennessee | 47167 | 5923 | 60 |
913311 | 913311 | 2021-01-09 | Tipton | Tennessee | 47167 | 5862 | 57 |
910066 | 910066 | 2021-01-08 | Tipton | Tennessee | 47167 | 5836 | 57 |
906821 | 906821 | 2021-01-07 | Tipton | Tennessee | 47167 | 5790 | 56 |
903575 | 903575 | 2021-01-06 | Tipton | Tennessee | 47167 | 5729 | 55 |
900330 | 900330 | 2021-01-05 | Tipton | Tennessee | 47167 | 5679 | 55 |
897085 | 897085 | 2021-01-04 | Tipton | Tennessee | 47167 | 5622 | 55 |
893839 | 893839 | 2021-01-03 | Tipton | Tennessee | 47167 | 5594 | 55 |
890593 | 890593 | 2021-01-02 | Tipton | Tennessee | 47167 | 5556 | 54 |
887346 | 887346 | 2021-01-01 | Tipton | Tennessee | 47167 | 5409 | 53 |
884101 | 884101 | 2020-12-31 | Tipton | Tennessee | 47167 | 5409 | 53 |
880856 | 880856 | 2020-12-30 | Tipton | Tennessee | 47167 | 5388 | 53 |
877611 | 877611 | 2020-12-29 | Tipton | Tennessee | 47167 | 5331 | 52 |
874366 | 874366 | 2020-12-28 | Tipton | Tennessee | 47167 | 5274 | 52 |
871121 | 871121 | 2020-12-27 | Tipton | Tennessee | 47167 | 5260 | 52 |
867876 | 867876 | 2020-12-26 | Tipton | Tennessee | 47167 | 5225 | 51 |
864631 | 864631 | 2020-12-25 | Tipton | Tennessee | 47167 | 5188 | 51 |
861386 | 861386 | 2020-12-24 | Tipton | Tennessee | 47167 | 5085 | 51 |
858141 | 858141 | 2020-12-23 | Tipton | Tennessee | 47167 | 5042 | 51 |
854896 | 854896 | 2020-12-22 | Tipton | Tennessee | 47167 | 5007 | 50 |
851651 | 851651 | 2020-12-21 | Tipton | Tennessee | 47167 | 4979 | 50 |
848406 | 848406 | 2020-12-20 | Tipton | Tennessee | 47167 | 4870 | 49 |
845161 | 845161 | 2020-12-19 | Tipton | Tennessee | 47167 | 4795 | 49 |
841915 | 841915 | 2020-12-18 | Tipton | Tennessee | 47167 | 4755 | 48 |
838670 | 838670 | 2020-12-17 | Tipton | Tennessee | 47167 | 4673 | 47 |
835424 | 835424 | 2020-12-16 | Tipton | Tennessee | 47167 | 4593 | 46 |
832178 | 832178 | 2020-12-15 | Tipton | Tennessee | 47167 | 4521 | 45 |
828931 | 828931 | 2020-12-14 | Tipton | Tennessee | 47167 | 4452 | 43 |
825685 | 825685 | 2020-12-13 | Tipton | Tennessee | 47167 | 4376 | 43 |
822438 | 822438 | 2020-12-12 | Tipton | Tennessee | 47167 | 4297 | 42 |
819192 | 819192 | 2020-12-11 | Tipton | Tennessee | 47167 | 4231 | 42 |
815946 | 815946 | 2020-12-10 | Tipton | Tennessee | 47167 | 4181 | 42 |
812700 | 812700 | 2020-12-09 | Tipton | Tennessee | 47167 | 4120 | 42 |
809456 | 809456 | 2020-12-08 | Tipton | Tennessee | 47167 | 4051 | 41 |
806211 | 806211 | 2020-12-07 | Tipton | Tennessee | 47167 | 4007 | 41 |
802966 | 802966 | 2020-12-06 | Tipton | Tennessee | 47167 | 3959 | 39 |
799721 | 799721 | 2020-12-05 | Tipton | Tennessee | 47167 | 3926 | 39 |
796476 | 796476 | 2020-12-04 | Tipton | Tennessee | 47167 | 3899 | 39 |
793231 | 793231 | 2020-12-03 | Tipton | Tennessee | 47167 | 3858 | 39 |
789986 | 789986 | 2020-12-02 | Tipton | Tennessee | 47167 | 3839 | 39 |
786741 | 786741 | 2020-12-01 | Tipton | Tennessee | 47167 | 3794 | 39 |
783497 | 783497 | 2020-11-30 | Tipton | Tennessee | 47167 | 3753 | 39 |
780252 | 780252 | 2020-11-29 | Tipton | Tennessee | 47167 | 3711 | 39 |
777006 | 777006 | 2020-11-28 | Tipton | Tennessee | 47167 | 3659 | 38 |
773761 | 773761 | 2020-11-27 | Tipton | Tennessee | 47167 | 3577 | 38 |
770516 | 770516 | 2020-11-26 | Tipton | Tennessee | 47167 | 3566 | 38 |
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);