ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 47119 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1091790 | 1091790 | 2021-03-05 | Maury | Tennessee | 47119 | 12262 | 162 |
1088544 | 1088544 | 2021-03-04 | Maury | Tennessee | 47119 | 12246 | 163 |
1085299 | 1085299 | 2021-03-03 | Maury | Tennessee | 47119 | 12238 | 163 |
1082053 | 1082053 | 2021-03-02 | Maury | Tennessee | 47119 | 12220 | 163 |
1078807 | 1078807 | 2021-03-01 | Maury | Tennessee | 47119 | 12206 | 163 |
1075562 | 1075562 | 2021-02-28 | Maury | Tennessee | 47119 | 12203 | 163 |
1072316 | 1072316 | 2021-02-27 | Maury | Tennessee | 47119 | 12200 | 163 |
1069070 | 1069070 | 2021-02-26 | Maury | Tennessee | 47119 | 12176 | 162 |
1065825 | 1065825 | 2021-02-25 | Maury | Tennessee | 47119 | 12158 | 160 |
1062580 | 1062580 | 2021-02-24 | Maury | Tennessee | 47119 | 12141 | 159 |
1059335 | 1059335 | 2021-02-23 | Maury | Tennessee | 47119 | 12124 | 158 |
1056089 | 1056089 | 2021-02-22 | Maury | Tennessee | 47119 | 12099 | 158 |
1052843 | 1052843 | 2021-02-21 | Maury | Tennessee | 47119 | 12087 | 157 |
1049596 | 1049596 | 2021-02-20 | Maury | Tennessee | 47119 | 12078 | 156 |
1046349 | 1046349 | 2021-02-19 | Maury | Tennessee | 47119 | 12074 | 155 |
1043104 | 1043104 | 2021-02-18 | Maury | Tennessee | 47119 | 12064 | 155 |
1039859 | 1039859 | 2021-02-17 | Maury | Tennessee | 47119 | 12057 | 154 |
1036614 | 1036614 | 2021-02-16 | Maury | Tennessee | 47119 | 12055 | 153 |
1033369 | 1033369 | 2021-02-15 | Maury | Tennessee | 47119 | 12037 | 153 |
1030123 | 1030123 | 2021-02-14 | Maury | Tennessee | 47119 | 12027 | 153 |
1026876 | 1026876 | 2021-02-13 | Maury | Tennessee | 47119 | 11998 | 152 |
1023631 | 1023631 | 2021-02-12 | Maury | Tennessee | 47119 | 11981 | 152 |
1020386 | 1020386 | 2021-02-11 | Maury | Tennessee | 47119 | 11953 | 151 |
1017141 | 1017141 | 2021-02-10 | Maury | Tennessee | 47119 | 11921 | 151 |
1013896 | 1013896 | 2021-02-09 | Maury | Tennessee | 47119 | 11946 | 151 |
1010651 | 1010651 | 2021-02-08 | Maury | Tennessee | 47119 | 11945 | 152 |
1007405 | 1007405 | 2021-02-07 | Maury | Tennessee | 47119 | 11927 | 152 |
1004159 | 1004159 | 2021-02-06 | Maury | Tennessee | 47119 | 11875 | 152 |
1000913 | 1000913 | 2021-02-05 | Maury | Tennessee | 47119 | 11850 | 150 |
997667 | 997667 | 2021-02-04 | Maury | Tennessee | 47119 | 11790 | 149 |
994421 | 994421 | 2021-02-03 | Maury | Tennessee | 47119 | 11738 | 149 |
991175 | 991175 | 2021-02-02 | Maury | Tennessee | 47119 | 11695 | 145 |
987929 | 987929 | 2021-02-01 | Maury | Tennessee | 47119 | 11653 | 142 |
984682 | 984682 | 2021-01-31 | Maury | Tennessee | 47119 | 11640 | 141 |
981435 | 981435 | 2021-01-30 | Maury | Tennessee | 47119 | 11556 | 141 |
978189 | 978189 | 2021-01-29 | Maury | Tennessee | 47119 | 11531 | 140 |
974944 | 974944 | 2021-01-28 | Maury | Tennessee | 47119 | 11445 | 138 |
971699 | 971699 | 2021-01-27 | Maury | Tennessee | 47119 | 11420 | 136 |
968454 | 968454 | 2021-01-26 | Maury | Tennessee | 47119 | 11346 | 133 |
965210 | 965210 | 2021-01-25 | Maury | Tennessee | 47119 | 11337 | 131 |
961965 | 961965 | 2021-01-24 | Maury | Tennessee | 47119 | 11295 | 131 |
958720 | 958720 | 2021-01-23 | Maury | Tennessee | 47119 | 11264 | 131 |
955474 | 955474 | 2021-01-22 | Maury | Tennessee | 47119 | 11179 | 128 |
952229 | 952229 | 2021-01-21 | Maury | Tennessee | 47119 | 11145 | 127 |
948984 | 948984 | 2021-01-20 | Maury | Tennessee | 47119 | 11079 | 125 |
945738 | 945738 | 2021-01-19 | Maury | Tennessee | 47119 | 11003 | 123 |
942491 | 942491 | 2021-01-18 | Maury | Tennessee | 47119 | 10962 | 123 |
939246 | 939246 | 2021-01-17 | Maury | Tennessee | 47119 | 10941 | 123 |
936001 | 936001 | 2021-01-16 | Maury | Tennessee | 47119 | 10903 | 123 |
932756 | 932756 | 2021-01-15 | Maury | Tennessee | 47119 | 10812 | 122 |
929511 | 929511 | 2021-01-14 | Maury | Tennessee | 47119 | 10746 | 120 |
926266 | 926266 | 2021-01-13 | Maury | Tennessee | 47119 | 10666 | 118 |
923020 | 923020 | 2021-01-12 | Maury | Tennessee | 47119 | 10591 | 118 |
919775 | 919775 | 2021-01-11 | Maury | Tennessee | 47119 | 10494 | 117 |
916530 | 916530 | 2021-01-10 | Maury | Tennessee | 47119 | 10442 | 116 |
913285 | 913285 | 2021-01-09 | Maury | Tennessee | 47119 | 10205 | 115 |
910040 | 910040 | 2021-01-08 | Maury | Tennessee | 47119 | 10149 | 113 |
906795 | 906795 | 2021-01-07 | Maury | Tennessee | 47119 | 10065 | 110 |
903549 | 903549 | 2021-01-06 | Maury | Tennessee | 47119 | 9827 | 107 |
900304 | 900304 | 2021-01-05 | Maury | Tennessee | 47119 | 9724 | 107 |
897059 | 897059 | 2021-01-04 | Maury | Tennessee | 47119 | 9647 | 107 |
893813 | 893813 | 2021-01-03 | Maury | Tennessee | 47119 | 9579 | 105 |
890567 | 890567 | 2021-01-02 | Maury | Tennessee | 47119 | 9530 | 105 |
887320 | 887320 | 2021-01-01 | Maury | Tennessee | 47119 | 9248 | 104 |
884075 | 884075 | 2020-12-31 | Maury | Tennessee | 47119 | 9248 | 104 |
880830 | 880830 | 2020-12-30 | Maury | Tennessee | 47119 | 9173 | 104 |
877585 | 877585 | 2020-12-29 | Maury | Tennessee | 47119 | 9079 | 104 |
874340 | 874340 | 2020-12-28 | Maury | Tennessee | 47119 | 9023 | 102 |
871095 | 871095 | 2020-12-27 | Maury | Tennessee | 47119 | 8956 | 102 |
867850 | 867850 | 2020-12-26 | Maury | Tennessee | 47119 | 8900 | 100 |
864605 | 864605 | 2020-12-25 | Maury | Tennessee | 47119 | 8840 | 100 |
861360 | 861360 | 2020-12-24 | Maury | Tennessee | 47119 | 8675 | 100 |
858115 | 858115 | 2020-12-23 | Maury | Tennessee | 47119 | 8601 | 98 |
854870 | 854870 | 2020-12-22 | Maury | Tennessee | 47119 | 8506 | 97 |
851625 | 851625 | 2020-12-21 | Maury | Tennessee | 47119 | 8477 | 96 |
848380 | 848380 | 2020-12-20 | Maury | Tennessee | 47119 | 8300 | 95 |
845135 | 845135 | 2020-12-19 | Maury | Tennessee | 47119 | 8109 | 95 |
841889 | 841889 | 2020-12-18 | Maury | Tennessee | 47119 | 8060 | 94 |
838644 | 838644 | 2020-12-17 | Maury | Tennessee | 47119 | 7893 | 94 |
835398 | 835398 | 2020-12-16 | Maury | Tennessee | 47119 | 7724 | 94 |
832152 | 832152 | 2020-12-15 | Maury | Tennessee | 47119 | 7593 | 92 |
828905 | 828905 | 2020-12-14 | Maury | Tennessee | 47119 | 7365 | 92 |
825659 | 825659 | 2020-12-13 | Maury | Tennessee | 47119 | 7311 | 92 |
822412 | 822412 | 2020-12-12 | Maury | Tennessee | 47119 | 7163 | 91 |
819166 | 819166 | 2020-12-11 | Maury | Tennessee | 47119 | 7110 | 83 |
815920 | 815920 | 2020-12-10 | Maury | Tennessee | 47119 | 7000 | 82 |
812674 | 812674 | 2020-12-09 | Maury | Tennessee | 47119 | 6897 | 81 |
809430 | 809430 | 2020-12-08 | Maury | Tennessee | 47119 | 6776 | 81 |
806185 | 806185 | 2020-12-07 | Maury | Tennessee | 47119 | 6627 | 77 |
802940 | 802940 | 2020-12-06 | Maury | Tennessee | 47119 | 6475 | 77 |
799695 | 799695 | 2020-12-05 | Maury | Tennessee | 47119 | 6457 | 77 |
796450 | 796450 | 2020-12-04 | Maury | Tennessee | 47119 | 6396 | 75 |
793205 | 793205 | 2020-12-03 | Maury | Tennessee | 47119 | 6364 | 72 |
789960 | 789960 | 2020-12-02 | Maury | Tennessee | 47119 | 6320 | 70 |
786715 | 786715 | 2020-12-01 | Maury | Tennessee | 47119 | 6261 | 69 |
783471 | 783471 | 2020-11-30 | Maury | Tennessee | 47119 | 6106 | 67 |
780226 | 780226 | 2020-11-29 | Maury | Tennessee | 47119 | 5918 | 67 |
776980 | 776980 | 2020-11-28 | Maury | Tennessee | 47119 | 5842 | 67 |
773735 | 773735 | 2020-11-27 | Maury | Tennessee | 47119 | 5783 | 67 |
770490 | 770490 | 2020-11-26 | Maury | Tennessee | 47119 | 5678 | 68 |
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);