ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
797 rows where fips = 47157 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
deaths 502 ✖
- 0 21
- 1682 8
- 1677 7
- 3219 7
- 3232 7
- 3241 7
- 3294 7
- 3299 7
- 3301 7
- 3302 7
- 1529 6
- 1681 6
- 1685 6
- 2327 6
- 1706 5
- 2307 5
- 26 4
- 1539 4
- 1546 4
- 1574 4
- 1585 4
- 1620 4
- 1695 4
- 1736 4
- 1967 4
- 2236 4
- 2256 4
- 2276 4
- 2298 4
- 2663 4
- 2708 4
- 2715 4
- 1 3
- 44 3
- 111 3
- 151 3
- 573 3
- 1441 3
- 1460 3
- 1527 3
- 1599 3
- 1613 3
- 1629 3
- 1646 3
- 1671 3
- 1699 3
- 1719 3
- 1744 3
- 1753 3
- 1777 3
- 1849 3
- 1900 3
- 1937 3
- 2045 3
- 2085 3
- 2172 3
- 2194 3
- 2380 3
- 2409 3
- 2431 3
- 2719 3
- 3066 3
- 3154 3
- 3159 3
- 3178 3
- 3199 3
- 3269 3
- 3307 3
- 7 2
- 35 2
- 45 2
- 46 2
- 55 2
- 64 2
- 68 2
- 85 2
- 88 2
- 92 2
- 94 2
- 136 2
- 163 2
- 182 2
- 224 2
- 233 2
- 245 2
- 302 2
- 380 2
- 387 2
- 402 2
- 440 2
- 447 2
- 449 2
- 563 2
- 570 2
- 580 2
- 612 2
- 630 2
- 659 2
- 818 2
- 839 2
- 903 2
- 1115 2
- 1140 2
- 1182 2
- 1378 2
- 1387 2
- 1496 2
- 1498 2
- 1558 2
- 1567 2
- 1570 2
- 1575 2
- 1593 2
- 1600 2
- 1610 2
- 1617 2
- 1628 2
- 1632 2
- 1648 2
- 1654 2
- 1668 2
- 1675 2
- 1689 2
- 1696 2
- 1712 2
- 1760 2
- 1790 2
- 1814 2
- 1834 2
- 1996 2
- 2066 2
- 2291 2
- 2402 2
- 2808 2
- 2822 2
- 2862 2
- 2915 2
- 2968 2
- 3004 2
- 3132 2
- 3 1
- 10 1
- 11 1
- 13 1
- 18 1
- 21 1
- 23 1
- 25 1
- 31 1
- 33 1
- 37 1
- 38 1
- 39 1
- 43 1
- 47 1
- 51 1
- 58 1
- 60 1
- 67 1
- 70 1
- 73 1
- 76 1
- 81 1
- 82 1
- 87 1
- 91 1
- 96 1
- 105 1
- 107 1
- 110 1
- 117 1
- 119 1
- 124 1
- 127 1
- 129 1
- 130 1
- 133 1
- 135 1
- 153 1
- 154 1
- 155 1
- 158 1
- 160 1
- 165 1
- 166 1
- 170 1
- 175 1
- 181 1
- 186 1
- 192 1
- 193 1
- 195 1
- 197 1
- 198 1
- 200 1
- 201 1
- 202 1
- 208 1
- 214 1
- 219 1
- 223 1
- 229 1
- 235 1
- 241 1
- 252 1
- 257 1
- 260 1
- 263 1
- 264 1
- 265 1
- 267 1
- 269 1
- 273 1
- 275 1
- 279 1
- 284 1
- 285 1
- 288 1
- 293 1
- 298 1
- 300 1
- 304 1
- 308 1
- 314 1
- 315 1
- 319 1
- 321 1
- 323 1
- 327 1
- 334 1
- 340 1
- 341 1
- 346 1
- 360 1
- 364 1
- 369 1
- 370 1
- 374 1
- 377 1
- 378 1
- 385 1
- 389 1
- 393 1
- 398 1
- 400 1
- 406 1
- 407 1
- 412 1
- 417 1
- 421 1
- 427 1
- 428 1
- 433 1
- 443 1
- 446 1
- 452 1
- 455 1
- 458 1
- 459 1
- 460 1
- 466 1
- 472 1
- 479 1
- 480 1
- 483 1
- 487 1
- 489 1
- 491 1
- 493 1
- 524 1
- 529 1
- 533 1
- 537 1
- 538 1
- 540 1
- 545 1
- 547 1
- 548 1
- 549 1
- 551 1
- 553 1
- 554 1
- 556 1
- 558 1
- 562 1
- 565 1
- 568 1
- 571 1
- 578 1
- 582 1
- 586 1
- 588 1
- 589 1
- 593 1
- 604 1
- 606 1
- 609 1
- 613 1
- 616 1
- 623 1
- 626 1
- 635 1
- 637 1
- 645 1
- 652 1
- 658 1
- 660 1
- 672 1
- 673 1
- 681 1
- 687 1
- 696 1
- 702 1
- 705 1
- 709 1
- 716 1
- 722 1
- 726 1
- 731 1
- 737 1
- 744 1
- 753 1
- 757 1
- 761 1
- 782 1
- 802 1
- 810 1
- 826 1
- 835 1
- 837 1
- 849 1
- 861 1
- 877 1
- 889 1
- 914 1
- 925 1
- 945 1
- 947 1
- 984 1
- 1003 1
- 1009 1
- 1024 1
- 1029 1
- 1039 1
- 1055 1
- 1080 1
- 1102 1
- 1128 1
- 1154 1
- 1169 1
- 1194 1
- 1202 1
- 1211 1
- 1223 1
- 1241 1
- 1254 1
- 1265 1
- 1280 1
- 1289 1
- 1296 1
- 1298 1
- 1348 1
- 1371 1
- 1406 1
- 1410 1
- 1424 1
- 1440 1
- 1443 1
- 1452 1
- 1454 1
- 1459 1
- 1479 1
- 1484 1
- 1500 1
- 1511 1
- 1517 1
- 1523 1
- 1544 1
- 1548 1
- 1560 1
- 1566 1
- 1569 1
- 1584 1
- 1586 1
- 1596 1
- 1619 1
- 1623 1
- 1635 1
- 1637 1
- 1638 1
- 1661 1
- 1674 1
- 1679 1
- 1688 1
- 1697 1
- 1701 1
- 1704 1
- 1709 1
- 1718 1
- 1726 1
- 1731 1
- 1735 1
- 1742 1
- 1757 1
- 1761 1
- 1783 1
- 1806 1
- 1815 1
- 1831 1
- 1847 1
- 1866 1
- 1878 1
- 1883 1
- 1888 1
- 1905 1
- 1909 1
- 1921 1
- 1936 1
- 1938 1
- 1943 1
- 1958 1
- 2017 1
- 2030 1
- 2074 1
- 2078 1
- 2125 1
- 2142 1
- 2147 1
- 2159 1
- 2173 1
- 2180 1
- 2187 1
- 2193 1
- 2203 1
- 2211 1
- 2220 1
- 2229 1
- 2238 1
- 2246 1
- 2255 1
- 2267 1
- 2269 1
- 2273 1
- 2288 1
- 2305 1
- 2312 1
- 2321 1
- 2334 1
- 2352 1
- 2363 1
- 2387 1
- 2399 1
- 2412 1
- 2416 1
- 2424 1
- 2430 1
- 2435 1
- 2442 1
- 2449 1
- 2689 1
- 2698 1
- 2705 1
- 2710 1
- 2716 1
- 2731 1
- 2734 1
- 2752 1
- 2781 1
- 2804 1
- 2827 1
- 2845 1
- 2863 1
- 2880 1
- 2885 1
- 2899 1
- 2903 1
- 2920 1
- 2935 1
- 2942 1
- 2958 1
- 2966 1
- 2970 1
- 2984 1
- 2988 1
- 2992 1
- 2999 1
- 3009 1
- 3044 1
- 3045 1
- 3052 1
- 3058 1
- 3081 1
- 3090 1
- 3127 1
- 3131 1
- 3136 1
- 3149 1
- 3189 1
- 3251 1
- 3258 1
- 3262 1
- 3268 1
state 1
- Tennessee 797
fips 1
- 47157 · 797 ✖
county 1
- Shelby 797
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502189 | 2502189 | 2022-05-13 | Shelby | Tennessee | 47157 | 240841 | 3307 |
2498931 | 2498931 | 2022-05-12 | Shelby | Tennessee | 47157 | 240480 | 3307 |
2495673 | 2495673 | 2022-05-11 | Shelby | Tennessee | 47157 | 240281 | 3307 |
2492415 | 2492415 | 2022-05-10 | Shelby | Tennessee | 47157 | 240062 | 3302 |
2489157 | 2489157 | 2022-05-09 | Shelby | Tennessee | 47157 | 239965 | 3302 |
2485900 | 2485900 | 2022-05-08 | Shelby | Tennessee | 47157 | 239829 | 3302 |
2482642 | 2482642 | 2022-05-07 | Shelby | Tennessee | 47157 | 239658 | 3302 |
2479384 | 2479384 | 2022-05-06 | Shelby | Tennessee | 47157 | 239518 | 3302 |
2476126 | 2476126 | 2022-05-05 | Shelby | Tennessee | 47157 | 239299 | 3302 |
2472869 | 2472869 | 2022-05-04 | Shelby | Tennessee | 47157 | 239168 | 3302 |
2469613 | 2469613 | 2022-05-03 | Shelby | Tennessee | 47157 | 239073 | 3301 |
2466357 | 2466357 | 2022-05-02 | Shelby | Tennessee | 47157 | 239040 | 3301 |
2463102 | 2463102 | 2022-05-01 | Shelby | Tennessee | 47157 | 238984 | 3301 |
2459846 | 2459846 | 2022-04-30 | Shelby | Tennessee | 47157 | 238868 | 3301 |
2456590 | 2456590 | 2022-04-29 | Shelby | Tennessee | 47157 | 238775 | 3301 |
2453334 | 2453334 | 2022-04-28 | Shelby | Tennessee | 47157 | 238711 | 3301 |
2450078 | 2450078 | 2022-04-27 | Shelby | Tennessee | 47157 | 238610 | 3301 |
2446821 | 2446821 | 2022-04-26 | Shelby | Tennessee | 47157 | 238562 | 3299 |
2443566 | 2443566 | 2022-04-25 | Shelby | Tennessee | 47157 | 238532 | 3299 |
2440310 | 2440310 | 2022-04-24 | Shelby | Tennessee | 47157 | 238478 | 3299 |
2437054 | 2437054 | 2022-04-23 | Shelby | Tennessee | 47157 | 238428 | 3299 |
2433798 | 2433798 | 2022-04-22 | Shelby | Tennessee | 47157 | 238380 | 3299 |
2430542 | 2430542 | 2022-04-21 | Shelby | Tennessee | 47157 | 238325 | 3299 |
2427286 | 2427286 | 2022-04-20 | Shelby | Tennessee | 47157 | 238290 | 3299 |
2424030 | 2424030 | 2022-04-19 | Shelby | Tennessee | 47157 | 238237 | 3294 |
2420774 | 2420774 | 2022-04-18 | Shelby | Tennessee | 47157 | 238215 | 3294 |
2417518 | 2417518 | 2022-04-17 | Shelby | Tennessee | 47157 | 238189 | 3294 |
2414262 | 2414262 | 2022-04-16 | Shelby | Tennessee | 47157 | 238137 | 3294 |
2411006 | 2411006 | 2022-04-15 | Shelby | Tennessee | 47157 | 238093 | 3294 |
2407750 | 2407750 | 2022-04-14 | Shelby | Tennessee | 47157 | 238045 | 3294 |
2404494 | 2404494 | 2022-04-13 | Shelby | Tennessee | 47157 | 238000 | 3294 |
2401239 | 2401239 | 2022-04-12 | Shelby | Tennessee | 47157 | 237984 | 3269 |
2397984 | 2397984 | 2022-04-11 | Shelby | Tennessee | 47157 | 237977 | 3269 |
2394729 | 2394729 | 2022-04-10 | Shelby | Tennessee | 47157 | 237958 | 3269 |
2391473 | 2391473 | 2022-04-09 | Shelby | Tennessee | 47157 | 237934 | 3268 |
2388217 | 2388217 | 2022-04-08 | Shelby | Tennessee | 47157 | 237884 | 3262 |
2384962 | 2384962 | 2022-04-07 | Shelby | Tennessee | 47157 | 237853 | 3258 |
2381707 | 2381707 | 2022-04-06 | Shelby | Tennessee | 47157 | 237829 | 3251 |
2378452 | 2378452 | 2022-04-05 | Shelby | Tennessee | 47157 | 237829 | 3241 |
2375198 | 2375198 | 2022-04-04 | Shelby | Tennessee | 47157 | 237815 | 3241 |
2371946 | 2371946 | 2022-04-03 | Shelby | Tennessee | 47157 | 237791 | 3241 |
2368693 | 2368693 | 2022-04-02 | Shelby | Tennessee | 47157 | 237749 | 3241 |
2365440 | 2365440 | 2022-04-01 | Shelby | Tennessee | 47157 | 237700 | 3241 |
2362187 | 2362187 | 2022-03-31 | Shelby | Tennessee | 47157 | 237638 | 3241 |
2358933 | 2358933 | 2022-03-30 | Shelby | Tennessee | 47157 | 237613 | 3241 |
2355679 | 2355679 | 2022-03-29 | Shelby | Tennessee | 47157 | 237581 | 3232 |
2352426 | 2352426 | 2022-03-28 | Shelby | Tennessee | 47157 | 237562 | 3232 |
2349174 | 2349174 | 2022-03-27 | Shelby | Tennessee | 47157 | 237526 | 3232 |
2345921 | 2345921 | 2022-03-26 | Shelby | Tennessee | 47157 | 237526 | 3232 |
2342668 | 2342668 | 2022-03-25 | Shelby | Tennessee | 47157 | 237514 | 3232 |
2339415 | 2339415 | 2022-03-24 | Shelby | Tennessee | 47157 | 237491 | 3232 |
2336161 | 2336161 | 2022-03-23 | Shelby | Tennessee | 47157 | 237438 | 3232 |
2332907 | 2332907 | 2022-03-22 | Shelby | Tennessee | 47157 | 237427 | 3219 |
2329654 | 2329654 | 2022-03-21 | Shelby | Tennessee | 47157 | 237420 | 3219 |
2326402 | 2326402 | 2022-03-20 | Shelby | Tennessee | 47157 | 237407 | 3219 |
2323149 | 2323149 | 2022-03-19 | Shelby | Tennessee | 47157 | 237393 | 3219 |
2319895 | 2319895 | 2022-03-18 | Shelby | Tennessee | 47157 | 237370 | 3219 |
2316641 | 2316641 | 2022-03-17 | Shelby | Tennessee | 47157 | 237342 | 3219 |
2313388 | 2313388 | 2022-03-16 | Shelby | Tennessee | 47157 | 237299 | 3219 |
2310135 | 2310135 | 2022-03-15 | Shelby | Tennessee | 47157 | 237279 | 3199 |
2306882 | 2306882 | 2022-03-14 | Shelby | Tennessee | 47157 | 237265 | 3199 |
2303631 | 2303631 | 2022-03-13 | Shelby | Tennessee | 47157 | 237254 | 3199 |
2300379 | 2300379 | 2022-03-12 | Shelby | Tennessee | 47157 | 237234 | 3189 |
2297127 | 2297127 | 2022-03-11 | Shelby | Tennessee | 47157 | 237196 | 3178 |
2293875 | 2293875 | 2022-03-10 | Shelby | Tennessee | 47157 | 237162 | 3178 |
2290623 | 2290623 | 2022-03-09 | Shelby | Tennessee | 47157 | 237084 | 3178 |
2287371 | 2287371 | 2022-03-08 | Shelby | Tennessee | 47157 | 237054 | 3159 |
2284119 | 2284119 | 2022-03-07 | Shelby | Tennessee | 47157 | 237029 | 3159 |
2280867 | 2280867 | 2022-03-06 | Shelby | Tennessee | 47157 | 236989 | 3159 |
2277614 | 2277614 | 2022-03-05 | Shelby | Tennessee | 47157 | 236917 | 3154 |
2274361 | 2274361 | 2022-03-04 | Shelby | Tennessee | 47157 | 236869 | 3154 |
2271108 | 2271108 | 2022-03-03 | Shelby | Tennessee | 47157 | 236781 | 3154 |
2267856 | 2267856 | 2022-03-02 | Shelby | Tennessee | 47157 | 236690 | 3149 |
2264603 | 2264603 | 2022-03-01 | Shelby | Tennessee | 47157 | 236607 | 3136 |
2261353 | 2261353 | 2022-02-28 | Shelby | Tennessee | 47157 | 236499 | 3132 |
2258102 | 2258102 | 2022-02-27 | Shelby | Tennessee | 47157 | 236499 | 3132 |
2254851 | 2254851 | 2022-02-26 | Shelby | Tennessee | 47157 | 236382 | 3131 |
2251600 | 2251600 | 2022-02-25 | Shelby | Tennessee | 47157 | 236228 | 3127 |
2248349 | 2248349 | 2022-02-24 | Shelby | Tennessee | 47157 | 236036 | 3090 |
2245098 | 2245098 | 2022-02-23 | Shelby | Tennessee | 47157 | 235831 | 3081 |
2241847 | 2241847 | 2022-02-22 | Shelby | Tennessee | 47157 | 235723 | 3066 |
2238596 | 2238596 | 2022-02-21 | Shelby | Tennessee | 47157 | 235626 | 3066 |
2235345 | 2235345 | 2022-02-20 | Shelby | Tennessee | 47157 | 235489 | 3066 |
2232094 | 2232094 | 2022-02-19 | Shelby | Tennessee | 47157 | 235263 | 3058 |
2228843 | 2228843 | 2022-02-18 | Shelby | Tennessee | 47157 | 235004 | 3052 |
2225592 | 2225592 | 2022-02-17 | Shelby | Tennessee | 47157 | 234702 | 3044 |
2222341 | 2222341 | 2022-02-16 | Shelby | Tennessee | 47157 | 234441 | 3045 |
2219090 | 2219090 | 2022-02-15 | Shelby | Tennessee | 47157 | 234173 | 3009 |
2215839 | 2215839 | 2022-02-14 | Shelby | Tennessee | 47157 | 234020 | 3004 |
2212588 | 2212588 | 2022-02-13 | Shelby | Tennessee | 47157 | 233722 | 3004 |
2209335 | 2209335 | 2022-02-12 | Shelby | Tennessee | 47157 | 233326 | 2999 |
2206082 | 2206082 | 2022-02-11 | Shelby | Tennessee | 47157 | 233033 | 2992 |
2202829 | 2202829 | 2022-02-10 | Shelby | Tennessee | 47157 | 232596 | 2988 |
2199575 | 2199575 | 2022-02-09 | Shelby | Tennessee | 47157 | 232164 | 2984 |
2196321 | 2196321 | 2022-02-08 | Shelby | Tennessee | 47157 | 231737 | 2970 |
2193067 | 2193067 | 2022-02-07 | Shelby | Tennessee | 47157 | 231524 | 2968 |
2189813 | 2189813 | 2022-02-06 | Shelby | Tennessee | 47157 | 231236 | 2968 |
2186560 | 2186560 | 2022-02-05 | Shelby | Tennessee | 47157 | 230977 | 2966 |
2183308 | 2183308 | 2022-02-04 | Shelby | Tennessee | 47157 | 230194 | 2958 |
2180056 | 2180056 | 2022-02-03 | Shelby | Tennessee | 47157 | 229390 | 2942 |
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);