ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
759 rows where fips = 47127 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 357 ✖
- 3 41
- 2238 35
- 5 24
- 1019 17
- 2237 14
- 1034 13
- 1033 12
- 1561 8
- 1018 7
- 1219 7
- 1625 7
- 1769 7
- 1940 7
- 2050 7
- 2157 7
- 2186 7
- 2208 7
- 2225 7
- 2235 7
- 2236 7
- 992 6
- 1438 6
- 1429 5
- 1435 5
- 1459 5
- 2 4
- 28 4
- 947 4
- 988 4
- 993 4
- 1003 4
- 1008 4
- 1024 4
- 1032 4
- 1036 4
- 1450 4
- 1483 4
- 1496 4
- 1524 4
- 1 3
- 6 3
- 12 3
- 17 3
- 35 3
- 286 3
- 829 3
- 854 3
- 929 3
- 944 3
- 950 3
- 959 3
- 975 3
- 997 3
- 1010 3
- 1011 3
- 1017 3
- 1049 3
- 1070 3
- 1087 3
- 1112 3
- 1164 3
- 1194 3
- 1264 3
- 1325 3
- 1363 3
- 1397 3
- 1411 3
- 1424 3
- 1441 3
- 1465 3
- 1474 3
- 2239 3
- 21 2
- 23 2
- 32 2
- 36 2
- 37 2
- 42 2
- 60 2
- 61 2
- 77 2
- 84 2
- 93 2
- 115 2
- 117 2
- 118 2
- 125 2
- 145 2
- 154 2
- 188 2
- 189 2
- 245 2
- 297 2
- 299 2
- 701 2
- 863 2
- 934 2
- 936 2
- 945 2
- 948 2
- 1012 2
- 1014 2
- 1035 2
- 1074 2
- 1185 2
- 1301 2
- 1333 2
- 1403 2
- 1427 2
- 1436 2
- 1439 2
- 1445 2
- 1463 2
- 1464 2
- 1471 2
- 1489 2
- 4 1
- 7 1
- 8 1
- 10 1
- 13 1
- 15 1
- 26 1
- 34 1
- 41 1
- 43 1
- 44 1
- 45 1
- 53 1
- 55 1
- 63 1
- 64 1
- 68 1
- 72 1
- 74 1
- 75 1
- 80 1
- 81 1
- 82 1
- 83 1
- 85 1
- 86 1
- 89 1
- 90 1
- 92 1
- 94 1
- 97 1
- 116 1
- 121 1
- 126 1
- 129 1
- 133 1
- 139 1
- 141 1
- 153 1
- 161 1
- 164 1
- 169 1
- 175 1
- 179 1
- 180 1
- 183 1
- 193 1
- 201 1
- 202 1
- 206 1
- 207 1
- 213 1
- 216 1
- 217 1
- 222 1
- 223 1
- 227 1
- 228 1
- 230 1
- 239 1
- 241 1
- 249 1
- 254 1
- 259 1
- 265 1
- 269 1
- 271 1
- 272 1
- 277 1
- 283 1
- 288 1
- 290 1
- 303 1
- 311 1
- 313 1
- 317 1
- 320 1
- 326 1
- 329 1
- 332 1
- 338 1
- 343 1
- 348 1
- 352 1
- 355 1
- 361 1
- 365 1
- 369 1
- 370 1
- 377 1
- 383 1
- 389 1
- 394 1
- 396 1
- 404 1
- 408 1
- 413 1
- 420 1
- 421 1
- 424 1
- 426 1
- 438 1
- 444 1
- 449 1
- 459 1
- 471 1
- 479 1
- 498 1
- 522 1
- 541 1
- 560 1
- 568 1
- 583 1
- 590 1
- 604 1
- 614 1
- 621 1
- 630 1
- 637 1
- 652 1
- 655 1
- 666 1
- 670 1
- 672 1
- 684 1
- 715 1
- 719 1
- 720 1
- 728 1
- 733 1
- 753 1
- 755 1
- 764 1
- 770 1
- 773 1
- 775 1
- 782 1
- 785 1
- 788 1
- 794 1
- 795 1
- 800 1
- 808 1
- 817 1
- 831 1
- 834 1
- 835 1
- 838 1
- 844 1
- 848 1
- 850 1
- 855 1
- 859 1
- 861 1
- 864 1
- 874 1
- 894 1
- 917 1
- 919 1
- 920 1
- 921 1
- 926 1
- 928 1
- 930 1
- 940 1
- 941 1
- 943 1
- 946 1
- 952 1
- 953 1
- 956 1
- 958 1
- 964 1
- 965 1
- 969 1
- 974 1
- 982 1
- 984 1
- 985 1
- 990 1
- 1000 1
- 1001 1
- 1002 1
- 1004 1
- 1005 1
- 1007 1
- 1009 1
- 1020 1
- 1037 1
- 1041 1
- 1046 1
- 1055 1
- 1057 1
- 1064 1
- 1068 1
- 1073 1
- 1086 1
- 1095 1
- 1096 1
- 1099 1
- 1103 1
- 1132 1
- 1139 1
- 1146 1
- 1150 1
- 1181 1
- 1188 1
- 1205 1
- 1251 1
- 1255 1
- 1260 1
- 1308 1
- 1318 1
- 1347 1
- 1359 1
- 1382 1
- 1386 1
- 1394 1
- 1396 1
- 1402 1
- 1404 1
- 1415 1
- 1416 1
- 1420 1
- 1423 1
- 1425 1
- 1431 1
- 1432 1
- 1447 1
- 1455 1
- 1456 1
- 1467 1
- 1468 1
- 1477 1
- 1480 1
- 1482 1
- 1494 1
- 1504 1
- 1508 1
- 1517 1
- 1557 1
state 1
- Tennessee · 759 ✖
fips 1
- 47127 · 759 ✖
county 1
- Moore 759
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502174 | 2502174 | 2022-05-13 | Moore | Tennessee | 47127 | 2239 | 40 |
2498916 | 2498916 | 2022-05-12 | Moore | Tennessee | 47127 | 2239 | 40 |
2495658 | 2495658 | 2022-05-11 | Moore | Tennessee | 47127 | 2239 | 40 |
2492400 | 2492400 | 2022-05-10 | Moore | Tennessee | 47127 | 2238 | 40 |
2489142 | 2489142 | 2022-05-09 | Moore | Tennessee | 47127 | 2238 | 40 |
2485885 | 2485885 | 2022-05-08 | Moore | Tennessee | 47127 | 2238 | 40 |
2482627 | 2482627 | 2022-05-07 | Moore | Tennessee | 47127 | 2238 | 40 |
2479369 | 2479369 | 2022-05-06 | Moore | Tennessee | 47127 | 2238 | 40 |
2476111 | 2476111 | 2022-05-05 | Moore | Tennessee | 47127 | 2238 | 40 |
2472854 | 2472854 | 2022-05-04 | Moore | Tennessee | 47127 | 2238 | 40 |
2469598 | 2469598 | 2022-05-03 | Moore | Tennessee | 47127 | 2238 | 40 |
2466342 | 2466342 | 2022-05-02 | Moore | Tennessee | 47127 | 2238 | 40 |
2463087 | 2463087 | 2022-05-01 | Moore | Tennessee | 47127 | 2238 | 40 |
2459831 | 2459831 | 2022-04-30 | Moore | Tennessee | 47127 | 2238 | 40 |
2456575 | 2456575 | 2022-04-29 | Moore | Tennessee | 47127 | 2238 | 40 |
2453319 | 2453319 | 2022-04-28 | Moore | Tennessee | 47127 | 2238 | 40 |
2450063 | 2450063 | 2022-04-27 | Moore | Tennessee | 47127 | 2238 | 40 |
2446806 | 2446806 | 2022-04-26 | Moore | Tennessee | 47127 | 2238 | 40 |
2443551 | 2443551 | 2022-04-25 | Moore | Tennessee | 47127 | 2238 | 40 |
2440295 | 2440295 | 2022-04-24 | Moore | Tennessee | 47127 | 2238 | 40 |
2437039 | 2437039 | 2022-04-23 | Moore | Tennessee | 47127 | 2238 | 40 |
2433783 | 2433783 | 2022-04-22 | Moore | Tennessee | 47127 | 2238 | 40 |
2430527 | 2430527 | 2022-04-21 | Moore | Tennessee | 47127 | 2238 | 40 |
2427271 | 2427271 | 2022-04-20 | Moore | Tennessee | 47127 | 2238 | 40 |
2424015 | 2424015 | 2022-04-19 | Moore | Tennessee | 47127 | 2238 | 40 |
2420759 | 2420759 | 2022-04-18 | Moore | Tennessee | 47127 | 2238 | 40 |
2417503 | 2417503 | 2022-04-17 | Moore | Tennessee | 47127 | 2238 | 40 |
2414247 | 2414247 | 2022-04-16 | Moore | Tennessee | 47127 | 2238 | 40 |
2410991 | 2410991 | 2022-04-15 | Moore | Tennessee | 47127 | 2238 | 40 |
2407735 | 2407735 | 2022-04-14 | Moore | Tennessee | 47127 | 2238 | 40 |
2404479 | 2404479 | 2022-04-13 | Moore | Tennessee | 47127 | 2238 | 40 |
2401224 | 2401224 | 2022-04-12 | Moore | Tennessee | 47127 | 2238 | 39 |
2397969 | 2397969 | 2022-04-11 | Moore | Tennessee | 47127 | 2238 | 39 |
2394714 | 2394714 | 2022-04-10 | Moore | Tennessee | 47127 | 2238 | 39 |
2391458 | 2391458 | 2022-04-09 | Moore | Tennessee | 47127 | 2238 | 39 |
2388202 | 2388202 | 2022-04-08 | Moore | Tennessee | 47127 | 2238 | 39 |
2384947 | 2384947 | 2022-04-07 | Moore | Tennessee | 47127 | 2238 | 39 |
2381692 | 2381692 | 2022-04-06 | Moore | Tennessee | 47127 | 2238 | 39 |
2378437 | 2378437 | 2022-04-05 | Moore | Tennessee | 47127 | 2237 | 39 |
2375183 | 2375183 | 2022-04-04 | Moore | Tennessee | 47127 | 2237 | 39 |
2371931 | 2371931 | 2022-04-03 | Moore | Tennessee | 47127 | 2237 | 39 |
2368678 | 2368678 | 2022-04-02 | Moore | Tennessee | 47127 | 2237 | 39 |
2365425 | 2365425 | 2022-04-01 | Moore | Tennessee | 47127 | 2237 | 39 |
2362172 | 2362172 | 2022-03-31 | Moore | Tennessee | 47127 | 2237 | 39 |
2358918 | 2358918 | 2022-03-30 | Moore | Tennessee | 47127 | 2237 | 39 |
2355664 | 2355664 | 2022-03-29 | Moore | Tennessee | 47127 | 2237 | 40 |
2352411 | 2352411 | 2022-03-28 | Moore | Tennessee | 47127 | 2237 | 40 |
2349159 | 2349159 | 2022-03-27 | Moore | Tennessee | 47127 | 2237 | 40 |
2345906 | 2345906 | 2022-03-26 | Moore | Tennessee | 47127 | 2237 | 40 |
2342653 | 2342653 | 2022-03-25 | Moore | Tennessee | 47127 | 2237 | 40 |
2339400 | 2339400 | 2022-03-24 | Moore | Tennessee | 47127 | 2237 | 40 |
2336146 | 2336146 | 2022-03-23 | Moore | Tennessee | 47127 | 2237 | 40 |
2332892 | 2332892 | 2022-03-22 | Moore | Tennessee | 47127 | 2236 | 40 |
2329639 | 2329639 | 2022-03-21 | Moore | Tennessee | 47127 | 2236 | 40 |
2326387 | 2326387 | 2022-03-20 | Moore | Tennessee | 47127 | 2236 | 40 |
2323134 | 2323134 | 2022-03-19 | Moore | Tennessee | 47127 | 2236 | 40 |
2319880 | 2319880 | 2022-03-18 | Moore | Tennessee | 47127 | 2236 | 40 |
2316626 | 2316626 | 2022-03-17 | Moore | Tennessee | 47127 | 2236 | 40 |
2313373 | 2313373 | 2022-03-16 | Moore | Tennessee | 47127 | 2236 | 40 |
2310120 | 2310120 | 2022-03-15 | Moore | Tennessee | 47127 | 2235 | 39 |
2306867 | 2306867 | 2022-03-14 | Moore | Tennessee | 47127 | 2235 | 39 |
2303616 | 2303616 | 2022-03-13 | Moore | Tennessee | 47127 | 2235 | 39 |
2300364 | 2300364 | 2022-03-12 | Moore | Tennessee | 47127 | 2235 | 39 |
2297112 | 2297112 | 2022-03-11 | Moore | Tennessee | 47127 | 2235 | 39 |
2293860 | 2293860 | 2022-03-10 | Moore | Tennessee | 47127 | 2235 | 39 |
2290608 | 2290608 | 2022-03-09 | Moore | Tennessee | 47127 | 2235 | 39 |
2287356 | 2287356 | 2022-03-08 | Moore | Tennessee | 47127 | 2225 | 37 |
2284104 | 2284104 | 2022-03-07 | Moore | Tennessee | 47127 | 2225 | 37 |
2280852 | 2280852 | 2022-03-06 | Moore | Tennessee | 47127 | 2225 | 37 |
2277599 | 2277599 | 2022-03-05 | Moore | Tennessee | 47127 | 2225 | 37 |
2274346 | 2274346 | 2022-03-04 | Moore | Tennessee | 47127 | 2225 | 37 |
2271093 | 2271093 | 2022-03-03 | Moore | Tennessee | 47127 | 2225 | 37 |
2267841 | 2267841 | 2022-03-02 | Moore | Tennessee | 47127 | 2225 | 37 |
2264588 | 2264588 | 2022-03-01 | Moore | Tennessee | 47127 | 2208 | 37 |
2261338 | 2261338 | 2022-02-28 | Moore | Tennessee | 47127 | 2208 | 37 |
2258087 | 2258087 | 2022-02-27 | Moore | Tennessee | 47127 | 2208 | 37 |
2254836 | 2254836 | 2022-02-26 | Moore | Tennessee | 47127 | 2208 | 37 |
2251585 | 2251585 | 2022-02-25 | Moore | Tennessee | 47127 | 2208 | 37 |
2248334 | 2248334 | 2022-02-24 | Moore | Tennessee | 47127 | 2208 | 37 |
2245083 | 2245083 | 2022-02-23 | Moore | Tennessee | 47127 | 2208 | 37 |
2241832 | 2241832 | 2022-02-22 | Moore | Tennessee | 47127 | 2186 | 36 |
2238581 | 2238581 | 2022-02-21 | Moore | Tennessee | 47127 | 2186 | 36 |
2235330 | 2235330 | 2022-02-20 | Moore | Tennessee | 47127 | 2186 | 36 |
2232079 | 2232079 | 2022-02-19 | Moore | Tennessee | 47127 | 2186 | 36 |
2228828 | 2228828 | 2022-02-18 | Moore | Tennessee | 47127 | 2186 | 36 |
2225577 | 2225577 | 2022-02-17 | Moore | Tennessee | 47127 | 2186 | 36 |
2222326 | 2222326 | 2022-02-16 | Moore | Tennessee | 47127 | 2186 | 36 |
2219075 | 2219075 | 2022-02-15 | Moore | Tennessee | 47127 | 2157 | 36 |
2215824 | 2215824 | 2022-02-14 | Moore | Tennessee | 47127 | 2157 | 36 |
2212573 | 2212573 | 2022-02-13 | Moore | Tennessee | 47127 | 2157 | 36 |
2209320 | 2209320 | 2022-02-12 | Moore | Tennessee | 47127 | 2157 | 36 |
2206067 | 2206067 | 2022-02-11 | Moore | Tennessee | 47127 | 2157 | 36 |
2202814 | 2202814 | 2022-02-10 | Moore | Tennessee | 47127 | 2157 | 36 |
2199560 | 2199560 | 2022-02-09 | Moore | Tennessee | 47127 | 2157 | 36 |
2196306 | 2196306 | 2022-02-08 | Moore | Tennessee | 47127 | 2050 | 35 |
2193052 | 2193052 | 2022-02-07 | Moore | Tennessee | 47127 | 2050 | 35 |
2189798 | 2189798 | 2022-02-06 | Moore | Tennessee | 47127 | 2050 | 35 |
2186545 | 2186545 | 2022-02-05 | Moore | Tennessee | 47127 | 2050 | 35 |
2183293 | 2183293 | 2022-02-04 | Moore | Tennessee | 47127 | 2050 | 35 |
2180041 | 2180041 | 2022-02-03 | Moore | Tennessee | 47127 | 2050 | 35 |
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);