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: deaths, date (date)
cases 712 ✖
- 2 6
- 89055 6
- 99539 5
- 1 4
- 99971 4
- 112026 4
- 148806 4
- 80991 3
- 96512 3
- 98942 3
- 99747 3
- 100627 3
- 101617 3
- 103059 3
- 156036 3
- 42 2
- 66 2
- 396 2
- 9139 2
- 23192 2
- 27697 2
- 28754 2
- 28890 2
- 58762 2
- 62783 2
- 66437 2
- 70532 2
- 72626 2
- 73817 2
- 77069 2
- 79925 2
- 83489 2
- 84798 2
- 85234 2
- 85594 2
- 86250 2
- 86522 2
- 87088 2
- 89919 2
- 95747 2
- 97969 2
- 98542 2
- 98829 2
- 99137 2
- 99323 2
- 101101 2
- 105503 2
- 109185 2
- 115471 2
- 130639 2
- 138585 2
- 147284 2
- 149836 2
- 178126 2
- 217582 2
- 236499 2
- 237526 2
- 237829 2
- 4 1
- 22 1
- 135 1
- 170 1
- 198 1
- 223 1
- 275 1
- 362 1
- 496 1
- 638 1
- 640 1
- 706 1
- 754 1
- 766 1
- 845 1
- 912 1
- 1006 1
- 1083 1
- 1147 1
- 1216 1
- 1331 1
- 1359 1
- 1432 1
- 1508 1
- 1682 1
- 1730 1
- 1778 1
- 1839 1
- 1873 1
- 1924 1
- 1953 1
- 2001 1
- 2086 1
- 2296 1
- 2327 1
- 2376 1
- 2432 1
- 2507 1
- 2599 1
- 2672 1
- 2815 1
- 2878 1
- 2922 1
- 3010 1
- 3066 1
- 3113 1
- 3189 1
- 3260 1
- 3372 1
- 3429 1
- 3475 1
- 3542 1
- 3595 1
- 3681 1
- 3726 1
- 3846 1
- 3936 1
- 4005 1
- 4034 1
- 4127 1
- 4225 1
- 4336 1
- 4451 1
- 4531 1
- 4615 1
- 4718 1
- 4823 1
- 4943 1
- 5003 1
- 5124 1
- 5314 1
- 5428 1
- 5546 1
- 5669 1
- 5812 1
- 5908 1
- 6005 1
- 6125 1
- 6220 1
- 6365 1
- 6451 1
- 6556 1
- 6773 1
- 6954 1
- 7104 1
- 7244 1
- 7290 1
- 7623 1
- 7737 1
- 7916 1
- 8064 1
- 8268 1
- 8490 1
- 8643 1
- 8988 1
- 9671 1
- 10028 1
- 10344 1
- 10765 1
- 11145 1
- 11560 1
- 11829 1
- 12019 1
- 12176 1
- 12549 1
- 12842 1
- 13135 1
- 13452 1
- 13702 1
- 14163 1
- 14555 1
- 14891 1
- 15324 1
- 15678 1
- 16224 1
- 16468 1
- 16767 1
- 16978 1
- 17255 1
- 17684 1
- 18058 1
- 18488 1
- 18764 1
- 19166 1
- 19694 1
- 20056 1
- 20380 1
- 20797 1
- 21461 1
- 21655 1
- 21913 1
- 22120 1
- 22317 1
- 22552 1
- 23529 1
- 23810 1
- 24057 1
- 24176 1
- 24347 1
- 24547 1
- 24803 1
- 25046 1
- 25275 1
- 25364 1
- 25507 1
- 25664 1
- 25811 1
- 26030 1
- 26117 1
- 26406 1
- 26528 1
- 26656 1
- 26903 1
- 27052 1
- 27273 1
- 27467 1
- 27779 1
- 27865 1
- 27975 1
- 28067 1
- 28207 1
- 28332 1
- 28478 1
- 28547 1
- 29117 1
- 29330 1
- 29504 1
- 29797 1
- 29957 1
- 30135 1
- 30255 1
- 30486 1
- 30594 1
- 30690 1
- 30837 1
- 30922 1
- 31044 1
- 31227 1
- 31391 1
- 31462 1
- 31540 1
- 31643 1
- 31771 1
- 31850 1
- 31953 1
- 32048 1
- 32306 1
- 32513 1
- 32595 1
- 32770 1
- 32916 1
- 32975 1
- 33056 1
- 33481 1
- 33625 1
- 33710 1
- 33960 1
- 34009 1
- 34221 1
- 34508 1
- 34850 1
- 35077 1
- 35279 1
- 35564 1
- 35901 1
- 36376 1
- 36685 1
- 36855 1
- 37111 1
- 37335 1
- 37618 1
- 37764 1
- 37873 1
- 38288 1
- 38352 1
- 38623 1
- 38875 1
- 39031 1
- 39328 1
- 39852 1
- 40577 1
- 40733 1
- 41125 1
- 41280 1
- 41571 1
- 42120 1
- 42660 1
- 43478 1
- 43700 1
- 44102 1
- 44474 1
- 44659 1
- 45045 1
- 45609 1
- 45952 1
- 46210 1
- 46330 1
- 46549 1
- 47215 1
- 47682 1
- 47963 1
- 48561 1
- 49077 1
- 49412 1
- 49731 1
- 50470 1
- 50923 1
- 51030 1
- 51775 1
- 52363 1
- 53058 1
- 53304 1
- 54234 1
- 54465 1
- 55456 1
- 56820 1
- 57599 1
- 59387 1
- 60651 1
- 61429 1
- 61444 1
- 63394 1
- 64013 1
- 64356 1
- 65713 1
- 66084 1
- 67198 1
- 67800 1
- 69798 1
- 70142 1
- 71728 1
- 74508 1
- 75016 1
- 75495 1
- 76534 1
- 77566 1
- 78020 1
- 78619 1
- 79051 1
- 79388 1
- 80770 1
- 81657 1
- 82428 1
- 82653 1
- 83029 1
- 83235 1
- 84123 1
- 84479 1
- 85807 1
- 86644 1
- 86686 1
- 86759 1
- 86865 1
- 86978 1
- 87449 1
- 87648 1
- 87840 1
- 87976 1
- 88111 1
- 88153 1
- 88214 1
- 88343 1
- 88521 1
- 88652 1
- 88768 1
- 88908 1
- 88949 1
- 89597 1
- 89681 1
- 89960 1
- 90110 1
- 90217 1
- 90311 1
- 90396 1
- 90497 1
- 90615 1
- 90734 1
- 90840 1
- 90959 1
- 91037 1
- 91130 1
- 91220 1
- 91349 1
- 91524 1
- 91613 1
- 91716 1
- 91792 1
- 91847 1
- 91906 1
- 92058 1
- 92219 1
- 92374 1
- 92529 1
- 92725 1
- 92836 1
- 92984 1
- 93246 1
- 93429 1
- 93598 1
- 93743 1
- 93895 1
- 93960 1
- 94069 1
- 94219 1
- 94416 1
- 94584 1
- 94703 1
- 94856 1
- 94974 1
- 95087 1
- 95262 1
- 95449 1
- 95598 1
- 95944 1
- 96050 1
- 96221 1
- 96376 1
- 96863 1
- 96952 1
- 97095 1
- 97254 1
- 97393 1
- 97530 1
- 97613 1
- 97675 1
- 97761 1
- 97870 1
- 98068 1
- 98298 1
- 98368 1
- 98465 1
- 98677 1
- 98719 1
- 98757 1
- 98779 1
- 98888 1
- 99069 1
- 99161 1
- 99213 1
- 99335 1
- 99388 1
- 99626 1
- 99643 1
- 99669 1
- 99786 1
- 99801 1
- 99826 1
- 99875 1
- 99915 1
- 100242 1
- 100330 1
- 100472 1
- 101284 1
- 101463 1
- 102083 1
- 102243 1
- 102502 1
- 102740 1
- 103891 1
- 104160 1
- 104563 1
- 105028 1
- 105625 1
- 106904 1
- 107286 1
- 107909 1
- 108458 1
- 109594 1
- 111002 1
- 111452 1
- 114967 1
- 116834 1
- 117619 1
- 118382 1
- 119500 1
- 120459 1
- 120984 1
- 121506 1
- 122041 1
- 122738 1
- 123316 1
- 124232 1
- 124646 1
- 125549 1
- 126696 1
- 127227 1
- 127508 1
- 128190 1
- 128884 1
- 129527 1
- 132357 1
- 132734 1
- 133610 1
- 134275 1
- 135371 1
- 135825 1
- 136212 1
- 136703 1
- 137139 1
- 137858 1
- 138288 1
- 139073 1
- 139496 1
- 139945 1
- 140239 1
- 140616 1
- 140718 1
- 141020 1
- 141259 1
- 141609 1
- 141919 1
- 142165 1
- 142449 1
- 142578 1
- 142717 1
- 142973 1
- 143267 1
- 143480 1
- 143639 1
- 143781 1
- 143924 1
- 144018 1
- 144149 1
- 144271 1
- 144438 1
- 144592 1
- 144705 1
- 144792 1
- 144874 1
- 144968 1
- 145070 1
- 145200 1
- 145304 1
- 145401 1
- 145455 1
- 145523 1
- 145601 1
- 145710 1
- 145832 1
- 145918 1
- 146005 1
- 146061 1
- 146101 1
- 146212 1
- 146296 1
- 146403 1
- 146472 1
- 146579 1
- 146636 1
- 146718 1
- 146814 1
- 147025 1
- 147417 1
- 147486 1
- 147557 1
- 147659 1
- 147796 1
- 148028 1
- 148192 1
- 148317 1
- 148387 1
- 148444 1
- 148549 1
- 148680 1
- 149122 1
- 149234 1
- 149410 1
- 150018 1
- 150125 1
- 150249 1
- 150388 1
- 150604 1
- 150861 1
- 151071 1
- 151242 1
- 151365 1
- 151449 1
- 151586 1
- 151851 1
- 152083 1
- 152486 1
- 152854 1
- 153234 1
- 153551 1
- 153972 1
- 154748 1
- 159425 1
- 160499 1
- 162589 1
- 165757 1
- 166471 1
- 169233 1
- 172627 1
- 176310 1
- 180331 1
- 183392 1
- 186005 1
- 188762 1
- 191089 1
- 192434 1
- 193915 1
- 196464 1
- 198837 1
- 201072 1
- 203128 1
- 204741 1
- 205793 1
- 207298 1
- 208357 1
- 210302 1
- 211884 1
- 213307 1
- 214302 1
- 215182 1
- 218534 1
- 219606 1
- 220482 1
- 221197 1
- 221671 1
- 225074 1
- 229390 1
- 230194 1
- 230977 1
- 231236 1
- 231524 1
- 231737 1
- 232164 1
- 232596 1
- 233033 1
- 233326 1
- 233722 1
- 234020 1
- 234173 1
- 234441 1
- 234702 1
- 235004 1
- 235263 1
- 235489 1
- 235626 1
- 235723 1
- 235831 1
- 236036 1
- 236228 1
- 236382 1
- 236607 1
- 236690 1
- 236781 1
- 236869 1
- 236917 1
- 236989 1
- 237029 1
- 237054 1
- 237084 1
- 237162 1
- 237196 1
- 237234 1
- 237254 1
- 237265 1
- 237279 1
- 237299 1
- 237342 1
- 237370 1
- 237393 1
- 237407 1
- 237420 1
- 237427 1
- 237438 1
- 237491 1
- 237514 1
- 237562 1
- 237581 1
- 237613 1
- 237638 1
- 237700 1
- 237749 1
- 237791 1
- 237815 1
- 237853 1
- 237884 1
- 237934 1
- 237958 1
- 237977 1
- 237984 1
- 238000 1
- 238045 1
- 238093 1
- 238137 1
- 238189 1
- 238215 1
- 238237 1
- 238290 1
- 238325 1
- 238380 1
- 238428 1
- 238478 1
- 238532 1
- 238562 1
- 238610 1
- 238711 1
- 238775 1
- 238868 1
- 238984 1
- 239040 1
- 239073 1
- 239168 1
- 239299 1
- 239518 1
- 239658 1
- 239829 1
- 239965 1
- 240062 1
- 240281 1
- 240480 1
- 240841 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);