ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
769 rows where county = "McLean" and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
cases 400 ✖
- 25 20
- 903 15
- 2616 14
- 900 12
- 23 10
- 27 8
- 24 7
- 901 7
- 2603 7
- 2604 7
- 2607 7
- 2609 7
- 2613 7
- 2618 7
- 19 6
- 43 6
- 50 6
- 65 6
- 2598 6
- 18 5
- 20 5
- 66 5
- 872 5
- 1551 5
- 1727 5
- 1757 5
- 2596 5
- 2621 5
- 3 4
- 5 4
- 6 4
- 16 4
- 35 4
- 36 4
- 40 4
- 52 4
- 840 4
- 858 4
- 861 4
- 877 4
- 885 4
- 904 4
- 916 4
- 1182 4
- 1955 4
- 2586 4
- 7 3
- 11 3
- 37 3
- 56 3
- 70 3
- 75 3
- 92 3
- 523 3
- 549 3
- 814 3
- 830 3
- 833 3
- 839 3
- 848 3
- 853 3
- 854 3
- 880 3
- 881 3
- 892 3
- 894 3
- 913 3
- 937 3
- 963 3
- 1001 3
- 1055 3
- 1124 3
- 1223 3
- 1278 3
- 1326 3
- 1369 3
- 1399 3
- 1439 3
- 1467 3
- 1486 3
- 1501 3
- 1512 3
- 1532 3
- 1612 3
- 1679 3
- 1711 3
- 1853 3
- 2146 3
- 2351 3
- 2483 3
- 2539 3
- 2582 3
- 2592 3
- 4 2
- 8 2
- 14 2
- 15 2
- 22 2
- 28 2
- 39 2
- 44 2
- 46 2
- 53 2
- 57 2
- 77 2
- 79 2
- 80 2
- 102 2
- 173 2
- 197 2
- 227 2
- 261 2
- 369 2
- 503 2
- 729 2
- 815 2
- 818 2
- 820 2
- 834 2
- 836 2
- 843 2
- 857 2
- 860 2
- 865 2
- 867 2
- 871 2
- 873 2
- 883 2
- 890 2
- 891 2
- 1508 2
- 2572 2
- 9 1
- 10 1
- 12 1
- 26 1
- 29 1
- 30 1
- 32 1
- 38 1
- 41 1
- 48 1
- 54 1
- 58 1
- 61 1
- 67 1
- 76 1
- 78 1
- 83 1
- 85 1
- 89 1
- 93 1
- 95 1
- 99 1
- 101 1
- 106 1
- 113 1
- 115 1
- 118 1
- 124 1
- 125 1
- 133 1
- 138 1
- 149 1
- 159 1
- 163 1
- 181 1
- 210 1
- 222 1
- 224 1
- 230 1
- 233 1
- 238 1
- 253 1
- 254 1
- 269 1
- 274 1
- 279 1
- 287 1
- 301 1
- 303 1
- 305 1
- 309 1
- 322 1
- 333 1
- 337 1
- 342 1
- 353 1
- 354 1
- 357 1
- 363 1
- 371 1
- 377 1
- 389 1
- 391 1
- 395 1
- 403 1
- 410 1
- 418 1
- 429 1
- 432 1
- 434 1
- 439 1
- 444 1
- 451 1
- 456 1
- 469 1
- 477 1
- 480 1
- 482 1
- 488 1
- 494 1
- 496 1
- 507 1
- 512 1
- 530 1
- 534 1
- 536 1
- 539 1
- 560 1
- 570 1
- 573 1
- 578 1
- 595 1
- 607 1
- 621 1
- 634 1
- 637 1
- 640 1
- 642 1
- 654 1
- 661 1
- 667 1
- 678 1
- 683 1
- 685 1
- 690 1
- 700 1
- 709 1
- 715 1
- 721 1
- 739 1
- 744 1
- 758 1
- 765 1
- 771 1
- 774 1
- 781 1
- 784 1
- 793 1
- 797 1
- 802 1
- 805 1
- 809 1
- 811 1
- 821 1
- 826 1
- 827 1
- 829 1
- 831 1
- 837 1
- 841 1
- 842 1
- 844 1
- 846 1
- 847 1
- 849 1
- 851 1
- 856 1
- 863 1
- 866 1
- 868 1
- 874 1
- 879 1
- 882 1
- 884 1
- 886 1
- 887 1
- 893 1
- 896 1
- 897 1
- 898 1
- 902 1
- 906 1
- 909 1
- 910 1
- 912 1
- 914 1
- 915 1
- 917 1
- 923 1
- 924 1
- 930 1
- 942 1
- 945 1
- 950 1
- 954 1
- 970 1
- 978 1
- 992 1
- 997 1
- 1017 1
- 1027 1
- 1039 1
- 1049 1
- 1083 1
- 1094 1
- 1107 1
- 1119 1
- 1146 1
- 1154 1
- 1162 1
- 1172 1
- 1195 1
- 1202 1
- 1210 1
- 1243 1
- 1250 1
- 1258 1
- 1267 1
- 1292 1
- 1297 1
- 1307 1
- 1308 1
- 1344 1
- 1347 1
- 1354 1
- 1362 1
- 1378 1
- 1384 1
- 1391 1
- 1394 1
- 1410 1
- 1418 1
- 1425 1
- 1431 1
- 1452 1
- 1453 1
- 1456 1
- 1463 1
- 1472 1
- 1474 1
- 1475 1
- 1479 1
- 1491 1
- 1494 1
- 1496 1
- 1500 1
- 1504 1
- 1507 1
- 1517 1
- 1522 1
- 1528 1
- 1531 1
- 1539 1
- 1542 1
- 1569 1
- 1576 1
- 1585 1
- 1598 1
- 1630 1
- 1639 1
- 1656 1
- 1666 1
- 1693 1
- 1697 1
- 1701 1
- 1706 1
- 1719 1
- 1722 1
- 1741 1
- 1748 1
- 1797 1
- 1806 1
- 1821 1
- 1835 1
- 1876 1
- 1883 1
- 1907 1
- 1933 1
- 2044 1
- 2065 1
- 2111 1
- 2222 1
- 2267 1
- 2292 1
- 2323 1
- 2419 1
- 2441 1
- 2452 1
- 2475 1
- 2499 1
- 2507 1
- 2519 1
- 2527 1
- 2577 1
- 2580 1
- 2593 1
- 2595 1
- 2599 1
state 1
- Kentucky · 769 ✖
fips 1
- 21149 769
county 1
- McLean · 769 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500659 | 2500659 | 2022-05-13 | McLean | Kentucky | 21149 | 2621 | 53 |
2497401 | 2497401 | 2022-05-12 | McLean | Kentucky | 21149 | 2621 | 53 |
2494143 | 2494143 | 2022-05-11 | McLean | Kentucky | 21149 | 2621 | 53 |
2490885 | 2490885 | 2022-05-10 | McLean | Kentucky | 21149 | 2621 | 53 |
2487628 | 2487628 | 2022-05-09 | McLean | Kentucky | 21149 | 2621 | 53 |
2484370 | 2484370 | 2022-05-08 | McLean | Kentucky | 21149 | 2618 | 50 |
2481112 | 2481112 | 2022-05-07 | McLean | Kentucky | 21149 | 2618 | 50 |
2477854 | 2477854 | 2022-05-06 | McLean | Kentucky | 21149 | 2618 | 50 |
2474596 | 2474596 | 2022-05-05 | McLean | Kentucky | 21149 | 2618 | 50 |
2471339 | 2471339 | 2022-05-04 | McLean | Kentucky | 21149 | 2618 | 50 |
2468083 | 2468083 | 2022-05-03 | McLean | Kentucky | 21149 | 2618 | 50 |
2464828 | 2464828 | 2022-05-02 | McLean | Kentucky | 21149 | 2618 | 50 |
2461572 | 2461572 | 2022-05-01 | McLean | Kentucky | 21149 | 2616 | 50 |
2458316 | 2458316 | 2022-04-30 | McLean | Kentucky | 21149 | 2616 | 50 |
2455060 | 2455060 | 2022-04-29 | McLean | Kentucky | 21149 | 2616 | 50 |
2451804 | 2451804 | 2022-04-28 | McLean | Kentucky | 21149 | 2616 | 50 |
2448548 | 2448548 | 2022-04-27 | McLean | Kentucky | 21149 | 2616 | 50 |
2445292 | 2445292 | 2022-04-26 | McLean | Kentucky | 21149 | 2616 | 50 |
2442036 | 2442036 | 2022-04-25 | McLean | Kentucky | 21149 | 2616 | 50 |
2438780 | 2438780 | 2022-04-24 | McLean | Kentucky | 21149 | 2616 | 50 |
2435524 | 2435524 | 2022-04-23 | McLean | Kentucky | 21149 | 2616 | 50 |
2432268 | 2432268 | 2022-04-22 | McLean | Kentucky | 21149 | 2616 | 50 |
2429012 | 2429012 | 2022-04-21 | McLean | Kentucky | 21149 | 2616 | 50 |
2425756 | 2425756 | 2022-04-20 | McLean | Kentucky | 21149 | 2616 | 50 |
2422500 | 2422500 | 2022-04-19 | McLean | Kentucky | 21149 | 2616 | 50 |
2419244 | 2419244 | 2022-04-18 | McLean | Kentucky | 21149 | 2616 | 50 |
2415988 | 2415988 | 2022-04-17 | McLean | Kentucky | 21149 | 2613 | 50 |
2412732 | 2412732 | 2022-04-16 | McLean | Kentucky | 21149 | 2613 | 50 |
2409476 | 2409476 | 2022-04-15 | McLean | Kentucky | 21149 | 2613 | 50 |
2406220 | 2406220 | 2022-04-14 | McLean | Kentucky | 21149 | 2613 | 50 |
2402964 | 2402964 | 2022-04-13 | McLean | Kentucky | 21149 | 2613 | 50 |
2399710 | 2399710 | 2022-04-12 | McLean | Kentucky | 21149 | 2613 | 50 |
2396454 | 2396454 | 2022-04-11 | McLean | Kentucky | 21149 | 2613 | 50 |
2393199 | 2393199 | 2022-04-10 | McLean | Kentucky | 21149 | 2609 | 50 |
2389943 | 2389943 | 2022-04-09 | McLean | Kentucky | 21149 | 2609 | 50 |
2386687 | 2386687 | 2022-04-08 | McLean | Kentucky | 21149 | 2609 | 50 |
2383432 | 2383432 | 2022-04-07 | McLean | Kentucky | 21149 | 2609 | 50 |
2380177 | 2380177 | 2022-04-06 | McLean | Kentucky | 21149 | 2609 | 50 |
2376922 | 2376922 | 2022-04-05 | McLean | Kentucky | 21149 | 2609 | 50 |
2373670 | 2373670 | 2022-04-04 | McLean | Kentucky | 21149 | 2609 | 50 |
2370417 | 2370417 | 2022-04-03 | McLean | Kentucky | 21149 | 2607 | 49 |
2367164 | 2367164 | 2022-04-02 | McLean | Kentucky | 21149 | 2607 | 49 |
2363911 | 2363911 | 2022-04-01 | McLean | Kentucky | 21149 | 2607 | 49 |
2360657 | 2360657 | 2022-03-31 | McLean | Kentucky | 21149 | 2607 | 49 |
2357403 | 2357403 | 2022-03-30 | McLean | Kentucky | 21149 | 2607 | 49 |
2354150 | 2354150 | 2022-03-29 | McLean | Kentucky | 21149 | 2607 | 49 |
2350898 | 2350898 | 2022-03-28 | McLean | Kentucky | 21149 | 2607 | 49 |
2347645 | 2347645 | 2022-03-27 | McLean | Kentucky | 21149 | 2604 | 47 |
2344392 | 2344392 | 2022-03-26 | McLean | Kentucky | 21149 | 2604 | 47 |
2341139 | 2341139 | 2022-03-25 | McLean | Kentucky | 21149 | 2604 | 47 |
2337886 | 2337886 | 2022-03-24 | McLean | Kentucky | 21149 | 2604 | 47 |
2334632 | 2334632 | 2022-03-23 | McLean | Kentucky | 21149 | 2604 | 47 |
2331378 | 2331378 | 2022-03-22 | McLean | Kentucky | 21149 | 2604 | 47 |
2328126 | 2328126 | 2022-03-21 | McLean | Kentucky | 21149 | 2604 | 47 |
2324873 | 2324873 | 2022-03-20 | McLean | Kentucky | 21149 | 2603 | 47 |
2321619 | 2321619 | 2022-03-19 | McLean | Kentucky | 21149 | 2603 | 47 |
2318365 | 2318365 | 2022-03-18 | McLean | Kentucky | 21149 | 2603 | 47 |
2315112 | 2315112 | 2022-03-17 | McLean | Kentucky | 21149 | 2603 | 47 |
2311859 | 2311859 | 2022-03-16 | McLean | Kentucky | 21149 | 2603 | 47 |
2308606 | 2308606 | 2022-03-15 | McLean | Kentucky | 21149 | 2603 | 47 |
2305355 | 2305355 | 2022-03-14 | McLean | Kentucky | 21149 | 2603 | 47 |
2302103 | 2302103 | 2022-03-13 | McLean | Kentucky | 21149 | 2596 | 45 |
2298851 | 2298851 | 2022-03-12 | McLean | Kentucky | 21149 | 2596 | 45 |
2295599 | 2295599 | 2022-03-11 | McLean | Kentucky | 21149 | 2596 | 45 |
2292347 | 2292347 | 2022-03-10 | McLean | Kentucky | 21149 | 2596 | 45 |
2289095 | 2289095 | 2022-03-09 | McLean | Kentucky | 21149 | 2598 | 46 |
2285844 | 2285844 | 2022-03-08 | McLean | Kentucky | 21149 | 2598 | 46 |
2282592 | 2282592 | 2022-03-07 | McLean | Kentucky | 21149 | 2598 | 46 |
2279339 | 2279339 | 2022-03-06 | McLean | Kentucky | 21149 | 2598 | 46 |
2276086 | 2276086 | 2022-03-05 | McLean | Kentucky | 21149 | 2598 | 46 |
2272833 | 2272833 | 2022-03-04 | McLean | Kentucky | 21149 | 2598 | 46 |
2269581 | 2269581 | 2022-03-03 | McLean | Kentucky | 21149 | 2599 | 46 |
2266328 | 2266328 | 2022-03-02 | McLean | Kentucky | 21149 | 2596 | 46 |
2263077 | 2263077 | 2022-03-01 | McLean | Kentucky | 21149 | 2595 | 45 |
2259826 | 2259826 | 2022-02-28 | McLean | Kentucky | 21149 | 2593 | 45 |
2256575 | 2256575 | 2022-02-27 | McLean | Kentucky | 21149 | 2592 | 45 |
2253324 | 2253324 | 2022-02-26 | McLean | Kentucky | 21149 | 2592 | 45 |
2250073 | 2250073 | 2022-02-25 | McLean | Kentucky | 21149 | 2592 | 45 |
2246822 | 2246822 | 2022-02-24 | McLean | Kentucky | 21149 | 2586 | 45 |
2243571 | 2243571 | 2022-02-23 | McLean | Kentucky | 21149 | 2586 | 45 |
2240320 | 2240320 | 2022-02-22 | McLean | Kentucky | 21149 | 2586 | 45 |
2237069 | 2237069 | 2022-02-21 | McLean | Kentucky | 21149 | 2586 | 45 |
2233818 | 2233818 | 2022-02-20 | McLean | Kentucky | 21149 | 2582 | 45 |
2230567 | 2230567 | 2022-02-19 | McLean | Kentucky | 21149 | 2582 | 45 |
2227316 | 2227316 | 2022-02-18 | McLean | Kentucky | 21149 | 2582 | 45 |
2224065 | 2224065 | 2022-02-17 | McLean | Kentucky | 21149 | 2580 | 45 |
2220814 | 2220814 | 2022-02-16 | McLean | Kentucky | 21149 | 2577 | 45 |
2217563 | 2217563 | 2022-02-15 | McLean | Kentucky | 21149 | 2572 | 44 |
2214312 | 2214312 | 2022-02-14 | McLean | Kentucky | 21149 | 2572 | 44 |
2211060 | 2211060 | 2022-02-13 | McLean | Kentucky | 21149 | 2539 | 44 |
2207807 | 2207807 | 2022-02-12 | McLean | Kentucky | 21149 | 2539 | 44 |
2204554 | 2204554 | 2022-02-11 | McLean | Kentucky | 21149 | 2539 | 44 |
2201301 | 2201301 | 2022-02-10 | McLean | Kentucky | 21149 | 2527 | 44 |
2198047 | 2198047 | 2022-02-09 | McLean | Kentucky | 21149 | 2519 | 44 |
2194793 | 2194793 | 2022-02-08 | McLean | Kentucky | 21149 | 2507 | 44 |
2191539 | 2191539 | 2022-02-07 | McLean | Kentucky | 21149 | 2499 | 44 |
2188286 | 2188286 | 2022-02-06 | McLean | Kentucky | 21149 | 2483 | 44 |
2185033 | 2185033 | 2022-02-05 | McLean | Kentucky | 21149 | 2483 | 44 |
2181781 | 2181781 | 2022-02-04 | McLean | Kentucky | 21149 | 2483 | 44 |
2178530 | 2178530 | 2022-02-03 | McLean | Kentucky | 21149 | 2475 | 44 |
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);