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 county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, 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 |
---|---|---|---|---|---|---|---|
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);