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 deaths
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 ▼ |
---|---|---|---|---|---|---|---|
843 | 843 | 2020-03-08 | Shelby | Tennessee | 47157 | 1 | 0 |
972 | 972 | 2020-03-09 | Shelby | Tennessee | 47157 | 1 | 0 |
1129 | 1129 | 2020-03-10 | Shelby | Tennessee | 47157 | 1 | 0 |
1325 | 1325 | 2020-03-11 | Shelby | Tennessee | 47157 | 1 | 0 |
1572 | 1572 | 2020-03-12 | Shelby | Tennessee | 47157 | 2 | 0 |
1876 | 1876 | 2020-03-13 | Shelby | Tennessee | 47157 | 2 | 0 |
2241 | 2241 | 2020-03-14 | Shelby | Tennessee | 47157 | 2 | 0 |
2666 | 2666 | 2020-03-15 | Shelby | Tennessee | 47157 | 2 | 0 |
3133 | 3133 | 2020-03-16 | Shelby | Tennessee | 47157 | 2 | 0 |
3666 | 3666 | 2020-03-17 | Shelby | Tennessee | 47157 | 2 | 0 |
4288 | 4288 | 2020-03-18 | Shelby | Tennessee | 47157 | 4 | 0 |
5036 | 5036 | 2020-03-19 | Shelby | Tennessee | 47157 | 22 | 0 |
5924 | 5924 | 2020-03-20 | Shelby | Tennessee | 47157 | 42 | 0 |
6941 | 6941 | 2020-03-21 | Shelby | Tennessee | 47157 | 42 | 0 |
8071 | 8071 | 2020-03-22 | Shelby | Tennessee | 47157 | 66 | 0 |
9289 | 9289 | 2020-03-23 | Shelby | Tennessee | 47157 | 66 | 0 |
10623 | 10623 | 2020-03-24 | Shelby | Tennessee | 47157 | 135 | 0 |
12102 | 12102 | 2020-03-25 | Shelby | Tennessee | 47157 | 170 | 0 |
13728 | 13728 | 2020-03-26 | Shelby | Tennessee | 47157 | 198 | 0 |
15480 | 15480 | 2020-03-27 | Shelby | Tennessee | 47157 | 223 | 0 |
17344 | 17344 | 2020-03-28 | Shelby | Tennessee | 47157 | 275 | 0 |
19294 | 19294 | 2020-03-29 | Shelby | Tennessee | 47157 | 362 | 1 |
21351 | 21351 | 2020-03-30 | Shelby | Tennessee | 47157 | 396 | 1 |
23490 | 23490 | 2020-03-31 | Shelby | Tennessee | 47157 | 396 | 1 |
25693 | 25693 | 2020-04-01 | Shelby | Tennessee | 47157 | 496 | 3 |
27973 | 27973 | 2020-04-02 | Shelby | Tennessee | 47157 | 638 | 7 |
30308 | 30308 | 2020-04-03 | Shelby | Tennessee | 47157 | 640 | 7 |
32699 | 32699 | 2020-04-04 | Shelby | Tennessee | 47157 | 706 | 10 |
35136 | 35136 | 2020-04-05 | Shelby | Tennessee | 47157 | 754 | 11 |
37612 | 37612 | 2020-04-06 | Shelby | Tennessee | 47157 | 766 | 13 |
40135 | 40135 | 2020-04-07 | Shelby | Tennessee | 47157 | 845 | 18 |
42697 | 42697 | 2020-04-08 | Shelby | Tennessee | 47157 | 912 | 21 |
45284 | 45284 | 2020-04-09 | Shelby | Tennessee | 47157 | 1006 | 23 |
47902 | 47902 | 2020-04-10 | Shelby | Tennessee | 47157 | 1083 | 25 |
50560 | 50560 | 2020-04-11 | Shelby | Tennessee | 47157 | 1147 | 26 |
53235 | 53235 | 2020-04-12 | Shelby | Tennessee | 47157 | 1216 | 26 |
55922 | 55922 | 2020-04-13 | Shelby | Tennessee | 47157 | 1331 | 26 |
58625 | 58625 | 2020-04-14 | Shelby | Tennessee | 47157 | 1359 | 26 |
61341 | 61341 | 2020-04-15 | Shelby | Tennessee | 47157 | 1432 | 31 |
64068 | 64068 | 2020-04-16 | Shelby | Tennessee | 47157 | 1508 | 33 |
66815 | 66815 | 2020-04-17 | Shelby | Tennessee | 47157 | 1682 | 35 |
69574 | 69574 | 2020-04-18 | Shelby | Tennessee | 47157 | 1730 | 35 |
72341 | 72341 | 2020-04-19 | Shelby | Tennessee | 47157 | 1778 | 37 |
75116 | 75116 | 2020-04-20 | Shelby | Tennessee | 47157 | 1839 | 38 |
77898 | 77898 | 2020-04-21 | Shelby | Tennessee | 47157 | 1873 | 39 |
80688 | 80688 | 2020-04-22 | Shelby | Tennessee | 47157 | 1924 | 43 |
83487 | 83487 | 2020-04-23 | Shelby | Tennessee | 47157 | 1953 | 44 |
86292 | 86292 | 2020-04-24 | Shelby | Tennessee | 47157 | 2001 | 44 |
89107 | 89107 | 2020-04-25 | Shelby | Tennessee | 47157 | 2086 | 44 |
91924 | 91924 | 2020-04-26 | Shelby | Tennessee | 47157 | 2296 | 45 |
94752 | 94752 | 2020-04-27 | Shelby | Tennessee | 47157 | 2327 | 45 |
97592 | 97592 | 2020-04-28 | Shelby | Tennessee | 47157 | 2376 | 46 |
100442 | 100442 | 2020-04-29 | Shelby | Tennessee | 47157 | 2432 | 46 |
103295 | 103295 | 2020-04-30 | Shelby | Tennessee | 47157 | 2507 | 47 |
106158 | 106158 | 2020-05-01 | Shelby | Tennessee | 47157 | 2599 | 51 |
109025 | 109025 | 2020-05-02 | Shelby | Tennessee | 47157 | 2672 | 55 |
111899 | 111899 | 2020-05-03 | Shelby | Tennessee | 47157 | 2815 | 55 |
114781 | 114781 | 2020-05-04 | Shelby | Tennessee | 47157 | 2878 | 58 |
117737 | 117737 | 2020-05-05 | Shelby | Tennessee | 47157 | 2922 | 60 |
120701 | 120701 | 2020-05-06 | Shelby | Tennessee | 47157 | 3010 | 64 |
123679 | 123679 | 2020-05-07 | Shelby | Tennessee | 47157 | 3066 | 64 |
126662 | 126662 | 2020-05-08 | Shelby | Tennessee | 47157 | 3113 | 67 |
129651 | 129651 | 2020-05-09 | Shelby | Tennessee | 47157 | 3189 | 68 |
132641 | 132641 | 2020-05-10 | Shelby | Tennessee | 47157 | 3260 | 68 |
135632 | 135632 | 2020-05-11 | Shelby | Tennessee | 47157 | 3372 | 70 |
138622 | 138622 | 2020-05-12 | Shelby | Tennessee | 47157 | 3429 | 73 |
141618 | 141618 | 2020-05-13 | Shelby | Tennessee | 47157 | 3475 | 76 |
144615 | 144615 | 2020-05-14 | Shelby | Tennessee | 47157 | 3542 | 81 |
147616 | 147616 | 2020-05-15 | Shelby | Tennessee | 47157 | 3595 | 82 |
150624 | 150624 | 2020-05-16 | Shelby | Tennessee | 47157 | 3681 | 85 |
153635 | 153635 | 2020-05-17 | Shelby | Tennessee | 47157 | 3726 | 85 |
156652 | 156652 | 2020-05-18 | Shelby | Tennessee | 47157 | 3846 | 87 |
159674 | 159674 | 2020-05-19 | Shelby | Tennessee | 47157 | 3936 | 88 |
162701 | 162701 | 2020-05-20 | Shelby | Tennessee | 47157 | 4005 | 88 |
165730 | 165730 | 2020-05-21 | Shelby | Tennessee | 47157 | 4034 | 91 |
168766 | 168766 | 2020-05-22 | Shelby | Tennessee | 47157 | 4127 | 92 |
171805 | 171805 | 2020-05-23 | Shelby | Tennessee | 47157 | 4225 | 92 |
174848 | 174848 | 2020-05-24 | Shelby | Tennessee | 47157 | 4336 | 94 |
177892 | 177892 | 2020-05-25 | Shelby | Tennessee | 47157 | 4451 | 94 |
180935 | 180935 | 2020-05-26 | Shelby | Tennessee | 47157 | 4531 | 96 |
183985 | 183985 | 2020-05-27 | Shelby | Tennessee | 47157 | 4615 | 105 |
187042 | 187042 | 2020-05-28 | Shelby | Tennessee | 47157 | 4718 | 107 |
190106 | 190106 | 2020-05-29 | Shelby | Tennessee | 47157 | 4823 | 110 |
193171 | 193171 | 2020-05-30 | Shelby | Tennessee | 47157 | 4943 | 111 |
196241 | 196241 | 2020-05-31 | Shelby | Tennessee | 47157 | 5003 | 111 |
199314 | 199314 | 2020-06-01 | Shelby | Tennessee | 47157 | 5124 | 111 |
202389 | 202389 | 2020-06-02 | Shelby | Tennessee | 47157 | 5314 | 117 |
205468 | 205468 | 2020-06-03 | Shelby | Tennessee | 47157 | 5428 | 119 |
208550 | 208550 | 2020-06-04 | Shelby | Tennessee | 47157 | 5546 | 124 |
211632 | 211632 | 2020-06-05 | Shelby | Tennessee | 47157 | 5669 | 127 |
214719 | 214719 | 2020-06-06 | Shelby | Tennessee | 47157 | 5812 | 129 |
217809 | 217809 | 2020-06-07 | Shelby | Tennessee | 47157 | 5908 | 130 |
220901 | 220901 | 2020-06-08 | Shelby | Tennessee | 47157 | 6005 | 133 |
223996 | 223996 | 2020-06-09 | Shelby | Tennessee | 47157 | 6125 | 135 |
227096 | 227096 | 2020-06-10 | Shelby | Tennessee | 47157 | 6220 | 136 |
230200 | 230200 | 2020-06-11 | Shelby | Tennessee | 47157 | 6365 | 136 |
233305 | 233305 | 2020-06-12 | Shelby | Tennessee | 47157 | 6451 | 151 |
236411 | 236411 | 2020-06-13 | Shelby | Tennessee | 47157 | 6556 | 151 |
239519 | 239519 | 2020-06-14 | Shelby | Tennessee | 47157 | 6773 | 151 |
242629 | 242629 | 2020-06-15 | Shelby | Tennessee | 47157 | 6954 | 153 |
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);