ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Spencer" and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
cases 477 ✖
- 16 19
- 5311 14
- 1 10
- 1654 8
- 9 7
- 25 7
- 5264 7
- 5289 7
- 5307 7
- 5323 7
- 5332 7
- 5344 7
- 5365 7
- 26 5
- 1606 5
- 1636 5
- 3056 5
- 3345 5
- 3415 5
- 5384 5
- 4 4
- 8 4
- 10 4
- 13 4
- 22 4
- 36 4
- 197 4
- 1530 4
- 1604 4
- 1628 4
- 1651 4
- 1656 4
- 2289 4
- 3892 4
- 2 3
- 3 3
- 6 3
- 17 3
- 24 3
- 29 3
- 33 3
- 38 3
- 138 3
- 169 3
- 174 3
- 188 3
- 947 3
- 987 3
- 1548 3
- 1638 3
- 1639 3
- 1647 3
- 1652 3
- 1661 3
- 1674 3
- 1715 3
- 1791 3
- 1867 3
- 2003 3
- 2144 3
- 2414 3
- 2505 3
- 2604 3
- 2680 3
- 2740 3
- 2809 3
- 2830 3
- 2868 3
- 2907 3
- 2944 3
- 2996 3
- 3170 3
- 3241 3
- 3299 3
- 3613 3
- 4367 3
- 4820 3
- 5003 3
- 5096 3
- 5191 3
- 5226 3
- 5261 3
- 19 2
- 28 2
- 37 2
- 40 2
- 41 2
- 48 2
- 62 2
- 63 2
- 77 2
- 152 2
- 163 2
- 173 2
- 225 2
- 244 2
- 591 2
- 937 2
- 1504 2
- 1512 2
- 1515 2
- 1519 2
- 1520 2
- 1522 2
- 1524 2
- 1534 2
- 1537 2
- 1545 2
- 1555 2
- 1565 2
- 1571 2
- 1585 2
- 1605 2
- 1609 2
- 1613 2
- 1619 2
- 1626 2
- 1653 2
- 1670 2
- 2817 2
- 2936 2
- 5222 2
- 5 1
- 12 1
- 14 1
- 15 1
- 31 1
- 43 1
- 49 1
- 52 1
- 53 1
- 57 1
- 58 1
- 59 1
- 65 1
- 71 1
- 74 1
- 82 1
- 84 1
- 87 1
- 94 1
- 96 1
- 97 1
- 102 1
- 107 1
- 110 1
- 111 1
- 112 1
- 113 1
- 120 1
- 121 1
- 123 1
- 128 1
- 136 1
- 141 1
- 142 1
- 145 1
- 146 1
- 149 1
- 160 1
- 161 1
- 162 1
- 166 1
- 168 1
- 171 1
- 177 1
- 183 1
- 184 1
- 189 1
- 190 1
- 191 1
- 192 1
- 198 1
- 205 1
- 208 1
- 211 1
- 213 1
- 214 1
- 215 1
- 216 1
- 218 1
- 221 1
- 222 1
- 226 1
- 232 1
- 233 1
- 235 1
- 237 1
- 242 1
- 248 1
- 250 1
- 254 1
- 257 1
- 259 1
- 263 1
- 265 1
- 269 1
- 280 1
- 284 1
- 285 1
- 293 1
- 301 1
- 308 1
- 315 1
- 319 1
- 326 1
- 337 1
- 339 1
- 341 1
- 347 1
- 359 1
- 372 1
- 382 1
- 387 1
- 389 1
- 406 1
- 408 1
- 418 1
- 427 1
- 444 1
- 485 1
- 488 1
- 496 1
- 504 1
- 508 1
- 521 1
- 538 1
- 549 1
- 554 1
- 563 1
- 570 1
- 623 1
- 634 1
- 636 1
- 643 1
- 651 1
- 660 1
- 674 1
- 688 1
- 699 1
- 719 1
- 721 1
- 722 1
- 739 1
- 772 1
- 812 1
- 836 1
- 854 1
- 859 1
- 869 1
- 876 1
- 901 1
- 906 1
- 924 1
- 934 1
- 955 1
- 963 1
- 965 1
- 974 1
- 1010 1
- 1012 1
- 1019 1
- 1025 1
- 1046 1
- 1072 1
- 1085 1
- 1097 1
- 1111 1
- 1121 1
- 1126 1
- 1134 1
- 1142 1
- 1155 1
- 1163 1
- 1176 1
- 1182 1
- 1192 1
- 1200 1
- 1213 1
- 1230 1
- 1245 1
- 1250 1
- 1257 1
- 1267 1
- 1276 1
- 1289 1
- 1291 1
- 1308 1
- 1314 1
- 1326 1
- 1330 1
- 1334 1
- 1350 1
- 1360 1
- 1366 1
- 1373 1
- 1377 1
- 1380 1
- 1389 1
- 1402 1
- 1412 1
- 1413 1
- 1422 1
- 1427 1
- 1434 1
- 1440 1
- 1454 1
- 1462 1
- 1466 1
- 1472 1
- 1477 1
- 1483 1
- 1490 1
- 1494 1
- 1497 1
- 1499 1
- 1503 1
- 1509 1
- 1514 1
- 1516 1
- 1518 1
- 1525 1
- 1526 1
- 1527 1
- 1533 1
- 1538 1
- 1540 1
- 1541 1
- 1542 1
- 1544 1
- 1546 1
- 1551 1
- 1553 1
- 1554 1
- 1560 1
- 1568 1
- 1574 1
- 1576 1
- 1578 1
- 1580 1
- 1581 1
- 1582 1
- 1584 1
- 1593 1
- 1594 1
- 1602 1
- 1603 1
- 1612 1
- 1614 1
- 1615 1
- 1624 1
- 1630 1
- 1634 1
- 1637 1
- 1643 1
- 1644 1
- 1646 1
- 1650 1
- 1655 1
- 1658 1
- 1659 1
- 1664 1
- 1673 1
- 1684 1
- 1690 1
- 1696 1
- 1703 1
- 1730 1
- 1745 1
- 1763 1
- 1771 1
- 1816 1
- 1820 1
- 1836 1
- 1844 1
- 1909 1
- 1927 1
- 1953 1
- 1985 1
- 2050 1
- 2083 1
- 2101 1
- 2121 1
- 2203 1
- 2223 1
- 2249 1
- 2277 1
- 2349 1
- 2364 1
- 2398 1
- 2441 1
- 2466 1
- 2478 1
- 2482 1
- 2547 1
- 2556 1
- 2583 1
- 2594 1
- 2631 1
- 2640 1
- 2656 1
- 2659 1
- 2700 1
- 2711 1
- 2718 1
- 2729 1
- 2751 1
- 2759 1
- 2790 1
- 2803 1
- 2818 1
- 2827 1
- 2835 1
- 2844 1
- 2850 1
- 2856 1
- 2879 1
- 2887 1
- 2894 1
- 2901 1
- 2917 1
- 2924 1
- 2961 1
- 2969 1
- 2986 1
- 3002 1
- 3022 1
- 3039 1
- 3100 1
- 3112 1
- 3138 1
- 3148 1
- 3196 1
- 3204 1
- 3227 1
- 3234 1
- 3261 1
- 3273 1
- 3281 1
- 3287 1
- 3332 1
- 3343 1
- 3374 1
- 3382 1
- 3493 1
- 3503 1
- 3543 1
- 3568 1
- 3679 1
- 3746 1
- 3812 1
- 3836 1
- 4127 1
- 4209 1
- 4280 1
- 4517 1
- 4622 1
- 4693 1
- 4761 1
- 4880 1
- 4920 1
- 4953 1
- 4989 1
- 5035 1
- 5050 1
- 5069 1
- 5086 1
- 5152 1
- 5159 1
- 5171 1
- 5179 1
- 5210 1
- 5216 1
- 5242 1
- 5245 1
- 5250 1
- 5256 1
state 1
- Kentucky · 784 ✖
fips 1
- 21215 784
county 1
- Spencer · 784 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500686 | 2500686 | 2022-05-13 | Spencer | Kentucky | 21215 | 5384 | 59 |
2497428 | 2497428 | 2022-05-12 | Spencer | Kentucky | 21215 | 5384 | 59 |
2494170 | 2494170 | 2022-05-11 | Spencer | Kentucky | 21215 | 5384 | 59 |
2490912 | 2490912 | 2022-05-10 | Spencer | Kentucky | 21215 | 5384 | 59 |
2487655 | 2487655 | 2022-05-09 | Spencer | Kentucky | 21215 | 5384 | 59 |
2484397 | 2484397 | 2022-05-08 | Spencer | Kentucky | 21215 | 5365 | 59 |
2481139 | 2481139 | 2022-05-07 | Spencer | Kentucky | 21215 | 5365 | 59 |
2477881 | 2477881 | 2022-05-06 | Spencer | Kentucky | 21215 | 5365 | 59 |
2474623 | 2474623 | 2022-05-05 | Spencer | Kentucky | 21215 | 5365 | 59 |
2471366 | 2471366 | 2022-05-04 | Spencer | Kentucky | 21215 | 5365 | 59 |
2468110 | 2468110 | 2022-05-03 | Spencer | Kentucky | 21215 | 5365 | 59 |
2464855 | 2464855 | 2022-05-02 | Spencer | Kentucky | 21215 | 5365 | 59 |
2461599 | 2461599 | 2022-05-01 | Spencer | Kentucky | 21215 | 5344 | 59 |
2458343 | 2458343 | 2022-04-30 | Spencer | Kentucky | 21215 | 5344 | 59 |
2455087 | 2455087 | 2022-04-29 | Spencer | Kentucky | 21215 | 5344 | 59 |
2451831 | 2451831 | 2022-04-28 | Spencer | Kentucky | 21215 | 5344 | 59 |
2448575 | 2448575 | 2022-04-27 | Spencer | Kentucky | 21215 | 5344 | 59 |
2445319 | 2445319 | 2022-04-26 | Spencer | Kentucky | 21215 | 5344 | 59 |
2442063 | 2442063 | 2022-04-25 | Spencer | Kentucky | 21215 | 5344 | 59 |
2438807 | 2438807 | 2022-04-24 | Spencer | Kentucky | 21215 | 5332 | 55 |
2435551 | 2435551 | 2022-04-23 | Spencer | Kentucky | 21215 | 5332 | 55 |
2432295 | 2432295 | 2022-04-22 | Spencer | Kentucky | 21215 | 5332 | 55 |
2429039 | 2429039 | 2022-04-21 | Spencer | Kentucky | 21215 | 5332 | 55 |
2425783 | 2425783 | 2022-04-20 | Spencer | Kentucky | 21215 | 5332 | 55 |
2422527 | 2422527 | 2022-04-19 | Spencer | Kentucky | 21215 | 5332 | 55 |
2419271 | 2419271 | 2022-04-18 | Spencer | Kentucky | 21215 | 5332 | 55 |
2416015 | 2416015 | 2022-04-17 | Spencer | Kentucky | 21215 | 5323 | 55 |
2412759 | 2412759 | 2022-04-16 | Spencer | Kentucky | 21215 | 5323 | 55 |
2409503 | 2409503 | 2022-04-15 | Spencer | Kentucky | 21215 | 5323 | 55 |
2406247 | 2406247 | 2022-04-14 | Spencer | Kentucky | 21215 | 5323 | 55 |
2402991 | 2402991 | 2022-04-13 | Spencer | Kentucky | 21215 | 5323 | 55 |
2399737 | 2399737 | 2022-04-12 | Spencer | Kentucky | 21215 | 5323 | 55 |
2396481 | 2396481 | 2022-04-11 | Spencer | Kentucky | 21215 | 5323 | 55 |
2393226 | 2393226 | 2022-04-10 | Spencer | Kentucky | 21215 | 5311 | 54 |
2389970 | 2389970 | 2022-04-09 | Spencer | Kentucky | 21215 | 5311 | 54 |
2386714 | 2386714 | 2022-04-08 | Spencer | Kentucky | 21215 | 5311 | 54 |
2383459 | 2383459 | 2022-04-07 | Spencer | Kentucky | 21215 | 5311 | 54 |
2380204 | 2380204 | 2022-04-06 | Spencer | Kentucky | 21215 | 5311 | 54 |
2376949 | 2376949 | 2022-04-05 | Spencer | Kentucky | 21215 | 5311 | 54 |
2373697 | 2373697 | 2022-04-04 | Spencer | Kentucky | 21215 | 5311 | 54 |
2370444 | 2370444 | 2022-04-03 | Spencer | Kentucky | 21215 | 5311 | 54 |
2367191 | 2367191 | 2022-04-02 | Spencer | Kentucky | 21215 | 5311 | 54 |
2363938 | 2363938 | 2022-04-01 | Spencer | Kentucky | 21215 | 5311 | 54 |
2360684 | 2360684 | 2022-03-31 | Spencer | Kentucky | 21215 | 5311 | 54 |
2357430 | 2357430 | 2022-03-30 | Spencer | Kentucky | 21215 | 5311 | 54 |
2354177 | 2354177 | 2022-03-29 | Spencer | Kentucky | 21215 | 5311 | 54 |
2350925 | 2350925 | 2022-03-28 | Spencer | Kentucky | 21215 | 5311 | 54 |
2347672 | 2347672 | 2022-03-27 | Spencer | Kentucky | 21215 | 5307 | 53 |
2344419 | 2344419 | 2022-03-26 | Spencer | Kentucky | 21215 | 5307 | 53 |
2341166 | 2341166 | 2022-03-25 | Spencer | Kentucky | 21215 | 5307 | 53 |
2337913 | 2337913 | 2022-03-24 | Spencer | Kentucky | 21215 | 5307 | 53 |
2334659 | 2334659 | 2022-03-23 | Spencer | Kentucky | 21215 | 5307 | 53 |
2331405 | 2331405 | 2022-03-22 | Spencer | Kentucky | 21215 | 5307 | 53 |
2328153 | 2328153 | 2022-03-21 | Spencer | Kentucky | 21215 | 5307 | 53 |
2324900 | 2324900 | 2022-03-20 | Spencer | Kentucky | 21215 | 5289 | 51 |
2321646 | 2321646 | 2022-03-19 | Spencer | Kentucky | 21215 | 5289 | 51 |
2318392 | 2318392 | 2022-03-18 | Spencer | Kentucky | 21215 | 5289 | 51 |
2315139 | 2315139 | 2022-03-17 | Spencer | Kentucky | 21215 | 5289 | 51 |
2311886 | 2311886 | 2022-03-16 | Spencer | Kentucky | 21215 | 5289 | 51 |
2308633 | 2308633 | 2022-03-15 | Spencer | Kentucky | 21215 | 5289 | 51 |
2305382 | 2305382 | 2022-03-14 | Spencer | Kentucky | 21215 | 5289 | 51 |
2302130 | 2302130 | 2022-03-13 | Spencer | Kentucky | 21215 | 5264 | 50 |
2298878 | 2298878 | 2022-03-12 | Spencer | Kentucky | 21215 | 5264 | 50 |
2295626 | 2295626 | 2022-03-11 | Spencer | Kentucky | 21215 | 5264 | 50 |
2292374 | 2292374 | 2022-03-10 | Spencer | Kentucky | 21215 | 5264 | 50 |
2289122 | 2289122 | 2022-03-09 | Spencer | Kentucky | 21215 | 5264 | 50 |
2285871 | 2285871 | 2022-03-08 | Spencer | Kentucky | 21215 | 5264 | 50 |
2282619 | 2282619 | 2022-03-07 | Spencer | Kentucky | 21215 | 5264 | 50 |
2279366 | 2279366 | 2022-03-06 | Spencer | Kentucky | 21215 | 5261 | 50 |
2276113 | 2276113 | 2022-03-05 | Spencer | Kentucky | 21215 | 5261 | 50 |
2272860 | 2272860 | 2022-03-04 | Spencer | Kentucky | 21215 | 5261 | 50 |
2269608 | 2269608 | 2022-03-03 | Spencer | Kentucky | 21215 | 5256 | 50 |
2266355 | 2266355 | 2022-03-02 | Spencer | Kentucky | 21215 | 5250 | 50 |
2263104 | 2263104 | 2022-03-01 | Spencer | Kentucky | 21215 | 5245 | 50 |
2259853 | 2259853 | 2022-02-28 | Spencer | Kentucky | 21215 | 5242 | 50 |
2256602 | 2256602 | 2022-02-27 | Spencer | Kentucky | 21215 | 5226 | 50 |
2253351 | 2253351 | 2022-02-26 | Spencer | Kentucky | 21215 | 5226 | 50 |
2250100 | 2250100 | 2022-02-25 | Spencer | Kentucky | 21215 | 5226 | 50 |
2246849 | 2246849 | 2022-02-24 | Spencer | Kentucky | 21215 | 5222 | 50 |
2243598 | 2243598 | 2022-02-23 | Spencer | Kentucky | 21215 | 5222 | 50 |
2240347 | 2240347 | 2022-02-22 | Spencer | Kentucky | 21215 | 5216 | 49 |
2237096 | 2237096 | 2022-02-21 | Spencer | Kentucky | 21215 | 5210 | 49 |
2233845 | 2233845 | 2022-02-20 | Spencer | Kentucky | 21215 | 5191 | 49 |
2230594 | 2230594 | 2022-02-19 | Spencer | Kentucky | 21215 | 5191 | 49 |
2227343 | 2227343 | 2022-02-18 | Spencer | Kentucky | 21215 | 5191 | 49 |
2224092 | 2224092 | 2022-02-17 | Spencer | Kentucky | 21215 | 5179 | 48 |
2220841 | 2220841 | 2022-02-16 | Spencer | Kentucky | 21215 | 5171 | 48 |
2217590 | 2217590 | 2022-02-15 | Spencer | Kentucky | 21215 | 5159 | 48 |
2214339 | 2214339 | 2022-02-14 | Spencer | Kentucky | 21215 | 5152 | 48 |
2211087 | 2211087 | 2022-02-13 | Spencer | Kentucky | 21215 | 5096 | 48 |
2207834 | 2207834 | 2022-02-12 | Spencer | Kentucky | 21215 | 5096 | 48 |
2204581 | 2204581 | 2022-02-11 | Spencer | Kentucky | 21215 | 5096 | 48 |
2201328 | 2201328 | 2022-02-10 | Spencer | Kentucky | 21215 | 5086 | 48 |
2198074 | 2198074 | 2022-02-09 | Spencer | Kentucky | 21215 | 5069 | 48 |
2194820 | 2194820 | 2022-02-08 | Spencer | Kentucky | 21215 | 5050 | 48 |
2191566 | 2191566 | 2022-02-07 | Spencer | Kentucky | 21215 | 5035 | 48 |
2188313 | 2188313 | 2022-02-06 | Spencer | Kentucky | 21215 | 5003 | 48 |
2185060 | 2185060 | 2022-02-05 | Spencer | Kentucky | 21215 | 5003 | 48 |
2181808 | 2181808 | 2022-02-04 | Spencer | Kentucky | 21215 | 5003 | 48 |
2178557 | 2178557 | 2022-02-03 | Spencer | Kentucky | 21215 | 4989 | 48 |
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);