ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 47125 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1244416 | 1244416 | 2021-04-21 | Montgomery | Tennessee | 47125 | 19740 | 224 |
1241169 | 1241169 | 2021-04-20 | Montgomery | Tennessee | 47125 | 19661 | 224 |
1237922 | 1237922 | 2021-04-19 | Montgomery | Tennessee | 47125 | 19623 | 224 |
1234675 | 1234675 | 2021-04-18 | Montgomery | Tennessee | 47125 | 19075 | 224 |
1231427 | 1231427 | 2021-04-17 | Montgomery | Tennessee | 47125 | 19075 | 224 |
1228179 | 1228179 | 2021-04-16 | Montgomery | Tennessee | 47125 | 19075 | 224 |
1224931 | 1224931 | 2021-04-15 | Montgomery | Tennessee | 47125 | 19032 | 224 |
1221684 | 1221684 | 2021-04-14 | Montgomery | Tennessee | 47125 | 18976 | 224 |
1218436 | 1218436 | 2021-04-13 | Montgomery | Tennessee | 47125 | 18939 | 223 |
1215188 | 1215188 | 2021-04-12 | Montgomery | Tennessee | 47125 | 18880 | 223 |
1211941 | 1211941 | 2021-04-11 | Montgomery | Tennessee | 47125 | 18780 | 223 |
1208692 | 1208692 | 2021-04-10 | Montgomery | Tennessee | 47125 | 18780 | 223 |
1205444 | 1205444 | 2021-04-09 | Montgomery | Tennessee | 47125 | 18780 | 223 |
1202196 | 1202196 | 2021-04-08 | Montgomery | Tennessee | 47125 | 18738 | 223 |
1198947 | 1198947 | 2021-04-07 | Montgomery | Tennessee | 47125 | 18695 | 223 |
1195698 | 1195698 | 2021-04-06 | Montgomery | Tennessee | 47125 | 18652 | 223 |
1192450 | 1192450 | 2021-04-05 | Montgomery | Tennessee | 47125 | 18617 | 221 |
1189201 | 1189201 | 2021-04-04 | Montgomery | Tennessee | 47125 | 18441 | 221 |
1185954 | 1185954 | 2021-04-03 | Montgomery | Tennessee | 47125 | 18441 | 221 |
1182707 | 1182707 | 2021-04-02 | Montgomery | Tennessee | 47125 | 18441 | 221 |
1179460 | 1179460 | 2021-04-01 | Montgomery | Tennessee | 47125 | 18441 | 221 |
1176213 | 1176213 | 2021-03-31 | Montgomery | Tennessee | 47125 | 18392 | 221 |
1172966 | 1172966 | 2021-03-30 | Montgomery | Tennessee | 47125 | 18348 | 221 |
1169719 | 1169719 | 2021-03-29 | Montgomery | Tennessee | 47125 | 18312 | 220 |
1166471 | 1166471 | 2021-03-28 | Montgomery | Tennessee | 47125 | 18221 | 217 |
1163223 | 1163223 | 2021-03-27 | Montgomery | Tennessee | 47125 | 18221 | 217 |
1159974 | 1159974 | 2021-03-26 | Montgomery | Tennessee | 47125 | 18221 | 217 |
1156727 | 1156727 | 2021-03-25 | Montgomery | Tennessee | 47125 | 18164 | 217 |
1153480 | 1153480 | 2021-03-24 | Montgomery | Tennessee | 47125 | 18110 | 217 |
1150233 | 1150233 | 2021-03-23 | Montgomery | Tennessee | 47125 | 18071 | 215 |
1146986 | 1146986 | 2021-03-22 | Montgomery | Tennessee | 47125 | 18031 | 214 |
1143739 | 1143739 | 2021-03-21 | Montgomery | Tennessee | 47125 | 17951 | 214 |
1140492 | 1140492 | 2021-03-20 | Montgomery | Tennessee | 47125 | 17951 | 214 |
1137246 | 1137246 | 2021-03-19 | Montgomery | Tennessee | 47125 | 17951 | 214 |
1134000 | 1134000 | 2021-03-18 | Montgomery | Tennessee | 47125 | 17904 | 213 |
1130752 | 1130752 | 2021-03-17 | Montgomery | Tennessee | 47125 | 17881 | 213 |
1127505 | 1127505 | 2021-03-16 | Montgomery | Tennessee | 47125 | 17834 | 213 |
1124259 | 1124259 | 2021-03-15 | Montgomery | Tennessee | 47125 | 17816 | 213 |
1121013 | 1121013 | 2021-03-14 | Montgomery | Tennessee | 47125 | 17695 | 213 |
1117766 | 1117766 | 2021-03-13 | Montgomery | Tennessee | 47125 | 17695 | 213 |
1114519 | 1114519 | 2021-03-12 | Montgomery | Tennessee | 47125 | 17695 | 213 |
1111273 | 1111273 | 2021-03-11 | Montgomery | Tennessee | 47125 | 17664 | 213 |
1108027 | 1108027 | 2021-03-10 | Montgomery | Tennessee | 47125 | 17611 | 213 |
1104781 | 1104781 | 2021-03-09 | Montgomery | Tennessee | 47125 | 17591 | 213 |
1101535 | 1101535 | 2021-03-08 | Montgomery | Tennessee | 47125 | 17578 | 213 |
1098289 | 1098289 | 2021-03-07 | Montgomery | Tennessee | 47125 | 17563 | 213 |
1095041 | 1095041 | 2021-03-06 | Montgomery | Tennessee | 47125 | 17539 | 213 |
1091795 | 1091795 | 2021-03-05 | Montgomery | Tennessee | 47125 | 17505 | 213 |
1088549 | 1088549 | 2021-03-04 | Montgomery | Tennessee | 47125 | 17484 | 213 |
1085304 | 1085304 | 2021-03-03 | Montgomery | Tennessee | 47125 | 17440 | 213 |
1082058 | 1082058 | 2021-03-02 | Montgomery | Tennessee | 47125 | 17414 | 213 |
1078812 | 1078812 | 2021-03-01 | Montgomery | Tennessee | 47125 | 17399 | 213 |
1075567 | 1075567 | 2021-02-28 | Montgomery | Tennessee | 47125 | 17380 | 212 |
1072321 | 1072321 | 2021-02-27 | Montgomery | Tennessee | 47125 | 17344 | 212 |
1069075 | 1069075 | 2021-02-26 | Montgomery | Tennessee | 47125 | 17310 | 212 |
1065830 | 1065830 | 2021-02-25 | Montgomery | Tennessee | 47125 | 17269 | 209 |
1062585 | 1062585 | 2021-02-24 | Montgomery | Tennessee | 47125 | 17207 | 207 |
1059340 | 1059340 | 2021-02-23 | Montgomery | Tennessee | 47125 | 17171 | 207 |
1056094 | 1056094 | 2021-02-22 | Montgomery | Tennessee | 47125 | 17150 | 205 |
1052848 | 1052848 | 2021-02-21 | Montgomery | Tennessee | 47125 | 17132 | 205 |
1049601 | 1049601 | 2021-02-20 | Montgomery | Tennessee | 47125 | 17074 | 204 |
1046354 | 1046354 | 2021-02-19 | Montgomery | Tennessee | 47125 | 17063 | 203 |
1043109 | 1043109 | 2021-02-18 | Montgomery | Tennessee | 47125 | 17025 | 203 |
1039864 | 1039864 | 2021-02-17 | Montgomery | Tennessee | 47125 | 17007 | 203 |
1036619 | 1036619 | 2021-02-16 | Montgomery | Tennessee | 47125 | 16995 | 202 |
1033374 | 1033374 | 2021-02-15 | Montgomery | Tennessee | 47125 | 16973 | 201 |
1030128 | 1030128 | 2021-02-14 | Montgomery | Tennessee | 47125 | 16937 | 201 |
1026881 | 1026881 | 2021-02-13 | Montgomery | Tennessee | 47125 | 16892 | 200 |
1023636 | 1023636 | 2021-02-12 | Montgomery | Tennessee | 47125 | 16832 | 200 |
1020391 | 1020391 | 2021-02-11 | Montgomery | Tennessee | 47125 | 16618 | 198 |
1017146 | 1017146 | 2021-02-10 | Montgomery | Tennessee | 47125 | 16477 | 190 |
1013901 | 1013901 | 2021-02-09 | Montgomery | Tennessee | 47125 | 16374 | 188 |
1010656 | 1010656 | 2021-02-08 | Montgomery | Tennessee | 47125 | 16329 | 188 |
1007410 | 1007410 | 2021-02-07 | Montgomery | Tennessee | 47125 | 16294 | 184 |
1004164 | 1004164 | 2021-02-06 | Montgomery | Tennessee | 47125 | 16210 | 184 |
1000918 | 1000918 | 2021-02-05 | Montgomery | Tennessee | 47125 | 16115 | 182 |
997672 | 997672 | 2021-02-04 | Montgomery | Tennessee | 47125 | 16004 | 173 |
994426 | 994426 | 2021-02-03 | Montgomery | Tennessee | 47125 | 15913 | 171 |
991180 | 991180 | 2021-02-02 | Montgomery | Tennessee | 47125 | 15868 | 166 |
987934 | 987934 | 2021-02-01 | Montgomery | Tennessee | 47125 | 15817 | 165 |
984687 | 984687 | 2021-01-31 | Montgomery | Tennessee | 47125 | 15765 | 164 |
981440 | 981440 | 2021-01-30 | Montgomery | Tennessee | 47125 | 15652 | 164 |
978194 | 978194 | 2021-01-29 | Montgomery | Tennessee | 47125 | 15591 | 162 |
974949 | 974949 | 2021-01-28 | Montgomery | Tennessee | 47125 | 15455 | 160 |
971704 | 971704 | 2021-01-27 | Montgomery | Tennessee | 47125 | 15388 | 158 |
968459 | 968459 | 2021-01-26 | Montgomery | Tennessee | 47125 | 15282 | 156 |
965215 | 965215 | 2021-01-25 | Montgomery | Tennessee | 47125 | 15200 | 153 |
961970 | 961970 | 2021-01-24 | Montgomery | Tennessee | 47125 | 15154 | 149 |
958725 | 958725 | 2021-01-23 | Montgomery | Tennessee | 47125 | 15092 | 149 |
955479 | 955479 | 2021-01-22 | Montgomery | Tennessee | 47125 | 14979 | 149 |
952234 | 952234 | 2021-01-21 | Montgomery | Tennessee | 47125 | 14836 | 149 |
948989 | 948989 | 2021-01-20 | Montgomery | Tennessee | 47125 | 14719 | 149 |
945743 | 945743 | 2021-01-19 | Montgomery | Tennessee | 47125 | 14507 | 149 |
942496 | 942496 | 2021-01-18 | Montgomery | Tennessee | 47125 | 14450 | 149 |
939251 | 939251 | 2021-01-17 | Montgomery | Tennessee | 47125 | 14367 | 149 |
936006 | 936006 | 2021-01-16 | Montgomery | Tennessee | 47125 | 14229 | 148 |
932761 | 932761 | 2021-01-15 | Montgomery | Tennessee | 47125 | 14085 | 148 |
929516 | 929516 | 2021-01-14 | Montgomery | Tennessee | 47125 | 13874 | 145 |
926271 | 926271 | 2021-01-13 | Montgomery | Tennessee | 47125 | 13667 | 145 |
923025 | 923025 | 2021-01-12 | Montgomery | Tennessee | 47125 | 13540 | 142 |
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);