ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 47001 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 501 ✖
- 8822 8
- 14717 8
- 10 7
- 15396 7
- 16649 7
- 18176 7
- 19504 7
- 20906 7
- 21413 7
- 21724 7
- 21877 7
- 21942 7
- 22027 7
- 22047 7
- 22060 7
- 22072 7
- 22077 7
- 22095 7
- 22120 7
- 22182 7
- 8820 6
- 1 5
- 15 5
- 37 5
- 39 5
- 40 5
- 8811 5
- 13426 5
- 11 4
- 24 4
- 28 4
- 31 4
- 8469 4
- 8838 4
- 8844 4
- 8847 4
- 10604 4
- 12881 4
- 13000 4
- 13128 4
- 14113 4
- 14409 4
- 16 3
- 36 3
- 74 3
- 8196 3
- 8334 3
- 8413 3
- 8539 3
- 8599 3
- 8674 3
- 8729 3
- 8760 3
- 8795 3
- 8817 3
- 8832 3
- 8842 3
- 8897 3
- 8986 3
- 9132 3
- 9360 3
- 9709 3
- 10115 3
- 11107 3
- 11678 3
- 12065 3
- 12333 3
- 12548 3
- 12734 3
- 13235 3
- 13358 3
- 13619 3
- 13801 3
- 13957 3
- 22228 3
- 3 2
- 12 2
- 29 2
- 35 2
- 41 2
- 42 2
- 59 2
- 60 2
- 90 2
- 851 2
- 1153 2
- 5631 2
- 8810 2
- 8814 2
- 8819 2
- 8821 2
- 8830 2
- 9922 2
- 11839 2
- 13198 2
- 13746 2
- 4 1
- 5 1
- 6 1
- 9 1
- 21 1
- 22 1
- 23 1
- 25 1
- 27 1
- 30 1
- 33 1
- 34 1
- 45 1
- 47 1
- 48 1
- 50 1
- 54 1
- 55 1
- 65 1
- 66 1
- 69 1
- 75 1
- 78 1
- 79 1
- 81 1
- 89 1
- 97 1
- 102 1
- 104 1
- 105 1
- 116 1
- 134 1
- 142 1
- 143 1
- 144 1
- 166 1
- 178 1
- 189 1
- 195 1
- 200 1
- 211 1
- 219 1
- 236 1
- 252 1
- 265 1
- 277 1
- 289 1
- 300 1
- 327 1
- 335 1
- 374 1
- 389 1
- 396 1
- 430 1
- 469 1
- 500 1
- 536 1
- 550 1
- 571 1
- 583 1
- 599 1
- 607 1
- 630 1
- 637 1
- 651 1
- 668 1
- 676 1
- 684 1
- 693 1
- 698 1
- 711 1
- 722 1
- 743 1
- 754 1
- 759 1
- 772 1
- 778 1
- 799 1
- 808 1
- 816 1
- 828 1
- 836 1
- 839 1
- 841 1
- 847 1
- 857 1
- 862 1
- 874 1
- 879 1
- 888 1
- 915 1
- 920 1
- 936 1
- 949 1
- 952 1
- 957 1
- 963 1
- 992 1
- 1012 1
- 1014 1
- 1015 1
- 1035 1
- 1042 1
- 1063 1
- 1072 1
- 1103 1
- 1117 1
- 1123 1
- 1133 1
- 1138 1
- 1165 1
- 1179 1
- 1200 1
- 1202 1
- 1210 1
- 1224 1
- 1243 1
- 1248 1
- 1266 1
- 1278 1
- 1299 1
- 1317 1
- 1337 1
- 1350 1
- 1363 1
- 1371 1
- 1386 1
- 1416 1
- 1428 1
- 1463 1
- 1486 1
- 1498 1
- 1526 1
- 1544 1
- 1555 1
- 1567 1
- 1596 1
- 1611 1
- 1646 1
- 1666 1
- 1688 1
- 1697 1
- 1727 1
- 1767 1
- 1813 1
- 1848 1
- 1868 1
- 1869 1
- 1902 1
- 1909 1
- 1938 1
- 1959 1
- 1998 1
- 2061 1
- 2123 1
- 2176 1
- 2185 1
- 2206 1
- 2227 1
- 2272 1
- 2311 1
- 2359 1
- 2452 1
- 2488 1
- 2510 1
- 2535 1
- 2589 1
- 2650 1
- 2715 1
- 2737 1
- 2744 1
- 2765 1
- 2806 1
- 2833 1
- 2946 1
- 2987 1
- 3107 1
- 3167 1
- 3197 1
- 3239 1
- 3272 1
- 3330 1
- 3361 1
- 3499 1
- 3560 1
- 3675 1
- 3741 1
- 3804 1
- 3868 1
- 4073 1
- 4205 1
- 4363 1
- 4461 1
- 4550 1
- 4705 1
- 4809 1
- 4926 1
- 5045 1
- 5085 1
- 5150 1
- 5218 1
- 5305 1
- 5373 1
- 5402 1
- 5461 1
- 5516 1
- 5595 1
- 5879 1
- 5936 1
- 5957 1
- 5998 1
- 6072 1
- 6192 1
- 6268 1
- 6323 1
- 6433 1
- 6473 1
- 6506 1
- 6553 1
- 6623 1
- 6678 1
- 6723 1
- 6759 1
- 6792 1
- 6818 1
- 6864 1
- 6904 1
- 6947 1
- 6983 1
- 7013 1
- 7031 1
- 7054 1
- 7085 1
- 7103 1
- 7181 1
- 7208 1
- 7239 1
- 7248 1
- 7264 1
- 7290 1
- 7307 1
- 7337 1
- 7359 1
- 7377 1
- 7387 1
- 7432 1
- 7524 1
- 7576 1
- 7597 1
- 7644 1
- 7675 1
- 7708 1
- 7746 1
- 7778 1
- 7794 1
- 7817 1
- 7838 1
- 7853 1
- 7863 1
- 7874 1
- 7893 1
- 7922 1
- 7941 1
- 7953 1
- 7971 1
- 7981 1
- 7991 1
- 8027 1
- 8044 1
- 8075 1
- 8103 1
- 8113 1
- 8119 1
- 8140 1
- 8155 1
- 8171 1
- 8240 1
- 8272 1
- 8295 1
- 8306 1
- 8375 1
- 8381 1
- 8391 1
- 8394 1
- 8434 1
- 8444 1
- 8454 1
- 8493 1
- 8510 1
- 8513 1
- 8533 1
- 8556 1
- 8562 1
- 8580 1
- 8591 1
- 8627 1
- 8633 1
- 8639 1
- 8657 1
- 8690 1
- 8698 1
- 8718 1
- 8724 1
- 8746 1
- 8750 1
- 8751 1
- 8758 1
- 8768 1
- 8769 1
- 8779 1
- 8792 1
- 8808 1
- 8812 1
- 8815 1
- 8816 1
- 8823 1
- 8826 1
- 8833 1
- 8835 1
- 8836 1
- 8837 1
- 8840 1
- 8845 1
- 8846 1
- 8862 1
- 8867 1
- 8883 1
- 8889 1
- 8921 1
- 8938 1
- 8959 1
- 8975 1
- 9048 1
- 9058 1
- 9083 1
- 9107 1
- 9186 1
- 9222 1
- 9256 1
- 9310 1
- 9500 1
- 9535 1
- 9582 1
- 9635 1
- 9873 1
- 10038 1
- 10303 1
- 10375 1
- 10510 1
- 10542 1
- 10960 1
- 10997 1
- 11052 1
- 11411 1
- 11490 1
- 11535 1
- 11593 1
- 11954 1
- 11992 1
- 12132 1
- 12190 1
- 12236 1
- 12273 1
- 12411 1
- 12430 1
- 12456 1
- 12483 1
- 12608 1
- 12648 1
- 12684 1
- 12716 1
- 12767 1
- 12789 1
- 12819 1
- 12853 1
- 12940 1
- 12951 1
- 12976 1
- 13056 1
- 13078 1
- 13106 1
- 13180 1
- 13259 1
- 13292 1
- 13319 1
- 13329 1
- 13389 1
- 13418 1
- 13489 1
- 13519 1
- 13542 1
- 13578 1
- 13681 1
- 13713 1
- 13859 1
- 13891 1
- 13897 1
- 13929 1
- 14018 1
- 14039 1
- 14069 1
- 14192 1
- 14240 1
- 14321 1
- 14657 1
state 1
- Tennessee 785
fips 1
- 47001 · 785 ✖
county 1
- Anderson 785
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502111 | 2502111 | 2022-05-13 | Anderson | Tennessee | 47001 | 22228 | 334 |
2498853 | 2498853 | 2022-05-12 | Anderson | Tennessee | 47001 | 22228 | 334 |
2495595 | 2495595 | 2022-05-11 | Anderson | Tennessee | 47001 | 22228 | 334 |
2492337 | 2492337 | 2022-05-10 | Anderson | Tennessee | 47001 | 22182 | 334 |
2489079 | 2489079 | 2022-05-09 | Anderson | Tennessee | 47001 | 22182 | 334 |
2485822 | 2485822 | 2022-05-08 | Anderson | Tennessee | 47001 | 22182 | 334 |
2482564 | 2482564 | 2022-05-07 | Anderson | Tennessee | 47001 | 22182 | 334 |
2479306 | 2479306 | 2022-05-06 | Anderson | Tennessee | 47001 | 22182 | 334 |
2476048 | 2476048 | 2022-05-05 | Anderson | Tennessee | 47001 | 22182 | 334 |
2472791 | 2472791 | 2022-05-04 | Anderson | Tennessee | 47001 | 22182 | 334 |
2469535 | 2469535 | 2022-05-03 | Anderson | Tennessee | 47001 | 22120 | 334 |
2466279 | 2466279 | 2022-05-02 | Anderson | Tennessee | 47001 | 22120 | 334 |
2463024 | 2463024 | 2022-05-01 | Anderson | Tennessee | 47001 | 22120 | 334 |
2459768 | 2459768 | 2022-04-30 | Anderson | Tennessee | 47001 | 22120 | 334 |
2456512 | 2456512 | 2022-04-29 | Anderson | Tennessee | 47001 | 22120 | 334 |
2453256 | 2453256 | 2022-04-28 | Anderson | Tennessee | 47001 | 22120 | 334 |
2450000 | 2450000 | 2022-04-27 | Anderson | Tennessee | 47001 | 22120 | 334 |
2446743 | 2446743 | 2022-04-26 | Anderson | Tennessee | 47001 | 22095 | 334 |
2443488 | 2443488 | 2022-04-25 | Anderson | Tennessee | 47001 | 22095 | 334 |
2440232 | 2440232 | 2022-04-24 | Anderson | Tennessee | 47001 | 22095 | 334 |
2436976 | 2436976 | 2022-04-23 | Anderson | Tennessee | 47001 | 22095 | 334 |
2433720 | 2433720 | 2022-04-22 | Anderson | Tennessee | 47001 | 22095 | 334 |
2430464 | 2430464 | 2022-04-21 | Anderson | Tennessee | 47001 | 22095 | 334 |
2427208 | 2427208 | 2022-04-20 | Anderson | Tennessee | 47001 | 22095 | 334 |
2423952 | 2423952 | 2022-04-19 | Anderson | Tennessee | 47001 | 22077 | 333 |
2420696 | 2420696 | 2022-04-18 | Anderson | Tennessee | 47001 | 22077 | 333 |
2417440 | 2417440 | 2022-04-17 | Anderson | Tennessee | 47001 | 22077 | 333 |
2414184 | 2414184 | 2022-04-16 | Anderson | Tennessee | 47001 | 22077 | 333 |
2410928 | 2410928 | 2022-04-15 | Anderson | Tennessee | 47001 | 22077 | 333 |
2407672 | 2407672 | 2022-04-14 | Anderson | Tennessee | 47001 | 22077 | 333 |
2404416 | 2404416 | 2022-04-13 | Anderson | Tennessee | 47001 | 22077 | 333 |
2401161 | 2401161 | 2022-04-12 | Anderson | Tennessee | 47001 | 22072 | 328 |
2397906 | 2397906 | 2022-04-11 | Anderson | Tennessee | 47001 | 22072 | 328 |
2394651 | 2394651 | 2022-04-10 | Anderson | Tennessee | 47001 | 22072 | 328 |
2391395 | 2391395 | 2022-04-09 | Anderson | Tennessee | 47001 | 22072 | 328 |
2388139 | 2388139 | 2022-04-08 | Anderson | Tennessee | 47001 | 22072 | 328 |
2384884 | 2384884 | 2022-04-07 | Anderson | Tennessee | 47001 | 22072 | 328 |
2381629 | 2381629 | 2022-04-06 | Anderson | Tennessee | 47001 | 22072 | 328 |
2378374 | 2378374 | 2022-04-05 | Anderson | Tennessee | 47001 | 22060 | 323 |
2375120 | 2375120 | 2022-04-04 | Anderson | Tennessee | 47001 | 22060 | 323 |
2371868 | 2371868 | 2022-04-03 | Anderson | Tennessee | 47001 | 22060 | 323 |
2368615 | 2368615 | 2022-04-02 | Anderson | Tennessee | 47001 | 22060 | 323 |
2365362 | 2365362 | 2022-04-01 | Anderson | Tennessee | 47001 | 22060 | 323 |
2362109 | 2362109 | 2022-03-31 | Anderson | Tennessee | 47001 | 22060 | 323 |
2358855 | 2358855 | 2022-03-30 | Anderson | Tennessee | 47001 | 22060 | 323 |
2355601 | 2355601 | 2022-03-29 | Anderson | Tennessee | 47001 | 22047 | 321 |
2352348 | 2352348 | 2022-03-28 | Anderson | Tennessee | 47001 | 22047 | 321 |
2349096 | 2349096 | 2022-03-27 | Anderson | Tennessee | 47001 | 22047 | 321 |
2345843 | 2345843 | 2022-03-26 | Anderson | Tennessee | 47001 | 22047 | 321 |
2342590 | 2342590 | 2022-03-25 | Anderson | Tennessee | 47001 | 22047 | 321 |
2339337 | 2339337 | 2022-03-24 | Anderson | Tennessee | 47001 | 22047 | 321 |
2336083 | 2336083 | 2022-03-23 | Anderson | Tennessee | 47001 | 22047 | 321 |
2332829 | 2332829 | 2022-03-22 | Anderson | Tennessee | 47001 | 22027 | 317 |
2329576 | 2329576 | 2022-03-21 | Anderson | Tennessee | 47001 | 22027 | 317 |
2326324 | 2326324 | 2022-03-20 | Anderson | Tennessee | 47001 | 22027 | 317 |
2323071 | 2323071 | 2022-03-19 | Anderson | Tennessee | 47001 | 22027 | 317 |
2319817 | 2319817 | 2022-03-18 | Anderson | Tennessee | 47001 | 22027 | 317 |
2316563 | 2316563 | 2022-03-17 | Anderson | Tennessee | 47001 | 22027 | 317 |
2313310 | 2313310 | 2022-03-16 | Anderson | Tennessee | 47001 | 22027 | 317 |
2310057 | 2310057 | 2022-03-15 | Anderson | Tennessee | 47001 | 21942 | 312 |
2306804 | 2306804 | 2022-03-14 | Anderson | Tennessee | 47001 | 21942 | 312 |
2303553 | 2303553 | 2022-03-13 | Anderson | Tennessee | 47001 | 21942 | 312 |
2300301 | 2300301 | 2022-03-12 | Anderson | Tennessee | 47001 | 21942 | 312 |
2297049 | 2297049 | 2022-03-11 | Anderson | Tennessee | 47001 | 21942 | 312 |
2293797 | 2293797 | 2022-03-10 | Anderson | Tennessee | 47001 | 21942 | 312 |
2290545 | 2290545 | 2022-03-09 | Anderson | Tennessee | 47001 | 21942 | 312 |
2287293 | 2287293 | 2022-03-08 | Anderson | Tennessee | 47001 | 21877 | 309 |
2284041 | 2284041 | 2022-03-07 | Anderson | Tennessee | 47001 | 21877 | 309 |
2280789 | 2280789 | 2022-03-06 | Anderson | Tennessee | 47001 | 21877 | 309 |
2277536 | 2277536 | 2022-03-05 | Anderson | Tennessee | 47001 | 21877 | 309 |
2274283 | 2274283 | 2022-03-04 | Anderson | Tennessee | 47001 | 21877 | 309 |
2271030 | 2271030 | 2022-03-03 | Anderson | Tennessee | 47001 | 21877 | 309 |
2267778 | 2267778 | 2022-03-02 | Anderson | Tennessee | 47001 | 21877 | 309 |
2264525 | 2264525 | 2022-03-01 | Anderson | Tennessee | 47001 | 21724 | 303 |
2261275 | 2261275 | 2022-02-28 | Anderson | Tennessee | 47001 | 21724 | 303 |
2258024 | 2258024 | 2022-02-27 | Anderson | Tennessee | 47001 | 21724 | 303 |
2254773 | 2254773 | 2022-02-26 | Anderson | Tennessee | 47001 | 21724 | 303 |
2251522 | 2251522 | 2022-02-25 | Anderson | Tennessee | 47001 | 21724 | 303 |
2248271 | 2248271 | 2022-02-24 | Anderson | Tennessee | 47001 | 21724 | 303 |
2245020 | 2245020 | 2022-02-23 | Anderson | Tennessee | 47001 | 21724 | 303 |
2241769 | 2241769 | 2022-02-22 | Anderson | Tennessee | 47001 | 21413 | 303 |
2238518 | 2238518 | 2022-02-21 | Anderson | Tennessee | 47001 | 21413 | 303 |
2235267 | 2235267 | 2022-02-20 | Anderson | Tennessee | 47001 | 21413 | 303 |
2232016 | 2232016 | 2022-02-19 | Anderson | Tennessee | 47001 | 21413 | 303 |
2228765 | 2228765 | 2022-02-18 | Anderson | Tennessee | 47001 | 21413 | 303 |
2225514 | 2225514 | 2022-02-17 | Anderson | Tennessee | 47001 | 21413 | 303 |
2222263 | 2222263 | 2022-02-16 | Anderson | Tennessee | 47001 | 21413 | 303 |
2219012 | 2219012 | 2022-02-15 | Anderson | Tennessee | 47001 | 20906 | 297 |
2215761 | 2215761 | 2022-02-14 | Anderson | Tennessee | 47001 | 20906 | 297 |
2212510 | 2212510 | 2022-02-13 | Anderson | Tennessee | 47001 | 20906 | 297 |
2209257 | 2209257 | 2022-02-12 | Anderson | Tennessee | 47001 | 20906 | 297 |
2206004 | 2206004 | 2022-02-11 | Anderson | Tennessee | 47001 | 20906 | 297 |
2202751 | 2202751 | 2022-02-10 | Anderson | Tennessee | 47001 | 20906 | 297 |
2199497 | 2199497 | 2022-02-09 | Anderson | Tennessee | 47001 | 20906 | 297 |
2196243 | 2196243 | 2022-02-08 | Anderson | Tennessee | 47001 | 19504 | 289 |
2192989 | 2192989 | 2022-02-07 | Anderson | Tennessee | 47001 | 19504 | 289 |
2189735 | 2189735 | 2022-02-06 | Anderson | Tennessee | 47001 | 19504 | 289 |
2186482 | 2186482 | 2022-02-05 | Anderson | Tennessee | 47001 | 19504 | 289 |
2183230 | 2183230 | 2022-02-04 | Anderson | Tennessee | 47001 | 19504 | 289 |
2179978 | 2179978 | 2022-02-03 | Anderson | Tennessee | 47001 | 19504 | 289 |
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);