ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 47009 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1244358 | 1244358 | 2021-04-21 | Blount | Tennessee | 47009 | 15213 | 194 |
1241111 | 1241111 | 2021-04-20 | Blount | Tennessee | 47009 | 15194 | 194 |
1237864 | 1237864 | 2021-04-19 | Blount | Tennessee | 47009 | 15180 | 194 |
1234617 | 1234617 | 2021-04-18 | Blount | Tennessee | 47009 | 14963 | 194 |
1231369 | 1231369 | 2021-04-17 | Blount | Tennessee | 47009 | 14963 | 194 |
1228121 | 1228121 | 2021-04-16 | Blount | Tennessee | 47009 | 14963 | 194 |
1224873 | 1224873 | 2021-04-15 | Blount | Tennessee | 47009 | 14940 | 194 |
1221626 | 1221626 | 2021-04-14 | Blount | Tennessee | 47009 | 14917 | 194 |
1218378 | 1218378 | 2021-04-13 | Blount | Tennessee | 47009 | 14894 | 194 |
1215130 | 1215130 | 2021-04-12 | Blount | Tennessee | 47009 | 14882 | 194 |
1211883 | 1211883 | 2021-04-11 | Blount | Tennessee | 47009 | 14839 | 194 |
1208634 | 1208634 | 2021-04-10 | Blount | Tennessee | 47009 | 14839 | 194 |
1205386 | 1205386 | 2021-04-09 | Blount | Tennessee | 47009 | 14839 | 194 |
1202138 | 1202138 | 2021-04-08 | Blount | Tennessee | 47009 | 14822 | 195 |
1198889 | 1198889 | 2021-04-07 | Blount | Tennessee | 47009 | 14798 | 194 |
1195640 | 1195640 | 2021-04-06 | Blount | Tennessee | 47009 | 14770 | 194 |
1192392 | 1192392 | 2021-04-05 | Blount | Tennessee | 47009 | 14762 | 194 |
1189143 | 1189143 | 2021-04-04 | Blount | Tennessee | 47009 | 14717 | 194 |
1185896 | 1185896 | 2021-04-03 | Blount | Tennessee | 47009 | 14717 | 194 |
1182649 | 1182649 | 2021-04-02 | Blount | Tennessee | 47009 | 14717 | 194 |
1179402 | 1179402 | 2021-04-01 | Blount | Tennessee | 47009 | 14717 | 194 |
1176155 | 1176155 | 2021-03-31 | Blount | Tennessee | 47009 | 14698 | 194 |
1172908 | 1172908 | 2021-03-30 | Blount | Tennessee | 47009 | 14684 | 193 |
1169661 | 1169661 | 2021-03-29 | Blount | Tennessee | 47009 | 14670 | 193 |
1166413 | 1166413 | 2021-03-28 | Blount | Tennessee | 47009 | 14643 | 192 |
1163165 | 1163165 | 2021-03-27 | Blount | Tennessee | 47009 | 14643 | 192 |
1159916 | 1159916 | 2021-03-26 | Blount | Tennessee | 47009 | 14643 | 192 |
1156669 | 1156669 | 2021-03-25 | Blount | Tennessee | 47009 | 14630 | 190 |
1153422 | 1153422 | 2021-03-24 | Blount | Tennessee | 47009 | 14601 | 190 |
1150175 | 1150175 | 2021-03-23 | Blount | Tennessee | 47009 | 14575 | 189 |
1146928 | 1146928 | 2021-03-22 | Blount | Tennessee | 47009 | 14554 | 189 |
1143681 | 1143681 | 2021-03-21 | Blount | Tennessee | 47009 | 14498 | 189 |
1140434 | 1140434 | 2021-03-20 | Blount | Tennessee | 47009 | 14498 | 189 |
1137188 | 1137188 | 2021-03-19 | Blount | Tennessee | 47009 | 14498 | 189 |
1133942 | 1133942 | 2021-03-18 | Blount | Tennessee | 47009 | 14456 | 186 |
1130694 | 1130694 | 2021-03-17 | Blount | Tennessee | 47009 | 14448 | 186 |
1127447 | 1127447 | 2021-03-16 | Blount | Tennessee | 47009 | 14412 | 186 |
1124201 | 1124201 | 2021-03-15 | Blount | Tennessee | 47009 | 14384 | 186 |
1120955 | 1120955 | 2021-03-14 | Blount | Tennessee | 47009 | 14334 | 186 |
1117708 | 1117708 | 2021-03-13 | Blount | Tennessee | 47009 | 14334 | 186 |
1114461 | 1114461 | 2021-03-12 | Blount | Tennessee | 47009 | 14334 | 186 |
1111215 | 1111215 | 2021-03-11 | Blount | Tennessee | 47009 | 14310 | 186 |
1107969 | 1107969 | 2021-03-10 | Blount | Tennessee | 47009 | 14272 | 185 |
1104723 | 1104723 | 2021-03-09 | Blount | Tennessee | 47009 | 14247 | 185 |
1101477 | 1101477 | 2021-03-08 | Blount | Tennessee | 47009 | 14219 | 185 |
1098231 | 1098231 | 2021-03-07 | Blount | Tennessee | 47009 | 14213 | 185 |
1094983 | 1094983 | 2021-03-06 | Blount | Tennessee | 47009 | 14189 | 184 |
1091737 | 1091737 | 2021-03-05 | Blount | Tennessee | 47009 | 14167 | 184 |
1088491 | 1088491 | 2021-03-04 | Blount | Tennessee | 47009 | 14141 | 183 |
1085246 | 1085246 | 2021-03-03 | Blount | Tennessee | 47009 | 14106 | 182 |
1082000 | 1082000 | 2021-03-02 | Blount | Tennessee | 47009 | 14066 | 181 |
1078754 | 1078754 | 2021-03-01 | Blount | Tennessee | 47009 | 14050 | 181 |
1075509 | 1075509 | 2021-02-28 | Blount | Tennessee | 47009 | 14036 | 181 |
1072263 | 1072263 | 2021-02-27 | Blount | Tennessee | 47009 | 14017 | 181 |
1069017 | 1069017 | 2021-02-26 | Blount | Tennessee | 47009 | 13990 | 179 |
1065772 | 1065772 | 2021-02-25 | Blount | Tennessee | 47009 | 13959 | 178 |
1062527 | 1062527 | 2021-02-24 | Blount | Tennessee | 47009 | 13929 | 178 |
1059282 | 1059282 | 2021-02-23 | Blount | Tennessee | 47009 | 13905 | 176 |
1056036 | 1056036 | 2021-02-22 | Blount | Tennessee | 47009 | 13880 | 175 |
1052790 | 1052790 | 2021-02-21 | Blount | Tennessee | 47009 | 13868 | 175 |
1049543 | 1049543 | 2021-02-20 | Blount | Tennessee | 47009 | 13849 | 175 |
1046296 | 1046296 | 2021-02-19 | Blount | Tennessee | 47009 | 13831 | 174 |
1043051 | 1043051 | 2021-02-18 | Blount | Tennessee | 47009 | 13800 | 174 |
1039806 | 1039806 | 2021-02-17 | Blount | Tennessee | 47009 | 13778 | 171 |
1036561 | 1036561 | 2021-02-16 | Blount | Tennessee | 47009 | 13738 | 169 |
1033316 | 1033316 | 2021-02-15 | Blount | Tennessee | 47009 | 13695 | 169 |
1030070 | 1030070 | 2021-02-14 | Blount | Tennessee | 47009 | 13655 | 169 |
1026823 | 1026823 | 2021-02-13 | Blount | Tennessee | 47009 | 13611 | 169 |
1023578 | 1023578 | 2021-02-12 | Blount | Tennessee | 47009 | 13552 | 168 |
1020333 | 1020333 | 2021-02-11 | Blount | Tennessee | 47009 | 13509 | 166 |
1017088 | 1017088 | 2021-02-10 | Blount | Tennessee | 47009 | 13212 | 162 |
1013843 | 1013843 | 2021-02-09 | Blount | Tennessee | 47009 | 13074 | 158 |
1010598 | 1010598 | 2021-02-08 | Blount | Tennessee | 47009 | 13016 | 158 |
1007352 | 1007352 | 2021-02-07 | Blount | Tennessee | 47009 | 12972 | 158 |
1004106 | 1004106 | 2021-02-06 | Blount | Tennessee | 47009 | 12922 | 158 |
1000860 | 1000860 | 2021-02-05 | Blount | Tennessee | 47009 | 12854 | 157 |
997614 | 997614 | 2021-02-04 | Blount | Tennessee | 47009 | 12827 | 150 |
994368 | 994368 | 2021-02-03 | Blount | Tennessee | 47009 | 12756 | 146 |
991122 | 991122 | 2021-02-02 | Blount | Tennessee | 47009 | 12701 | 146 |
987876 | 987876 | 2021-02-01 | Blount | Tennessee | 47009 | 12668 | 144 |
984629 | 984629 | 2021-01-31 | Blount | Tennessee | 47009 | 12645 | 143 |
981382 | 981382 | 2021-01-30 | Blount | Tennessee | 47009 | 12622 | 143 |
978136 | 978136 | 2021-01-29 | Blount | Tennessee | 47009 | 12596 | 141 |
974891 | 974891 | 2021-01-28 | Blount | Tennessee | 47009 | 12550 | 140 |
971646 | 971646 | 2021-01-27 | Blount | Tennessee | 47009 | 12491 | 137 |
968401 | 968401 | 2021-01-26 | Blount | Tennessee | 47009 | 12443 | 136 |
965157 | 965157 | 2021-01-25 | Blount | Tennessee | 47009 | 12382 | 136 |
961912 | 961912 | 2021-01-24 | Blount | Tennessee | 47009 | 12366 | 134 |
958667 | 958667 | 2021-01-23 | Blount | Tennessee | 47009 | 12321 | 133 |
955421 | 955421 | 2021-01-22 | Blount | Tennessee | 47009 | 12267 | 132 |
952176 | 952176 | 2021-01-21 | Blount | Tennessee | 47009 | 12197 | 131 |
948931 | 948931 | 2021-01-20 | Blount | Tennessee | 47009 | 12146 | 127 |
945685 | 945685 | 2021-01-19 | Blount | Tennessee | 47009 | 12029 | 126 |
942438 | 942438 | 2021-01-18 | Blount | Tennessee | 47009 | 11914 | 125 |
939193 | 939193 | 2021-01-17 | Blount | Tennessee | 47009 | 11887 | 124 |
935948 | 935948 | 2021-01-16 | Blount | Tennessee | 47009 | 11784 | 123 |
932703 | 932703 | 2021-01-15 | Blount | Tennessee | 47009 | 11708 | 122 |
929458 | 929458 | 2021-01-14 | Blount | Tennessee | 47009 | 11537 | 120 |
926213 | 926213 | 2021-01-13 | Blount | Tennessee | 47009 | 11300 | 117 |
922967 | 922967 | 2021-01-12 | Blount | Tennessee | 47009 | 11245 | 112 |
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);