ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,454 rows where county = "Elk" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, deaths, date (date)
cases 654 ✖
- 1 82
- 6 41
- 179 40
- 570 37
- 178 35
- 181 28
- 569 24
- 2 21
- 180 21
- 2868 17
- 4 15
- 15 15
- 64 14
- 187 14
- 167 13
- 7131 11
- 568 9
- 2871 9
- 571 8
- 12 7
- 13 7
- 29 7
- 63 7
- 65 7
- 66 7
- 176 7
- 7156 7
- 3 6
- 5 6
- 54 6
- 154 6
- 221 6
- 2872 6
- 20 5
- 67 5
- 71 5
- 96 5
- 136 5
- 159 5
- 190 5
- 199 5
- 347 5
- 378 5
- 381 5
- 386 5
- 388 5
- 432 5
- 558 5
- 563 5
- 9 4
- 38 4
- 40 4
- 48 4
- 58 4
- 73 4
- 87 4
- 182 4
- 270 4
- 2865 4
- 2866 4
- 2869 4
- 2892 4
- 7 3
- 8 3
- 16 3
- 28 3
- 33 3
- 39 3
- 77 3
- 78 3
- 114 3
- 148 3
- 151 3
- 163 3
- 164 3
- 174 3
- 183 3
- 207 3
- 216 3
- 228 3
- 232 3
- 244 3
- 250 3
- 253 3
- 257 3
- 273 3
- 275 3
- 284 3
- 291 3
- 302 3
- 308 3
- 324 3
- 335 3
- 341 3
- 371 3
- 393 3
- 402 3
- 491 3
- 532 3
- 553 3
- 2847 3
- 2856 3
- 2859 3
- 2878 3
- 7122 3
- 7125 3
- 7135 3
- 7193 3
- 10 2
- 11 2
- 14 2
- 17 2
- 23 2
- 31 2
- 36 2
- 37 2
- 42 2
- 43 2
- 46 2
- 47 2
- 51 2
- 56 2
- 62 2
- 72 2
- 76 2
- 81 2
- 84 2
- 85 2
- 90 2
- 98 2
- 106 2
- 115 2
- 126 2
- 144 2
- 149 2
- 158 2
- 162 2
- 169 2
- 172 2
- 175 2
- 177 2
- 185 2
- 189 2
- 200 2
- 204 2
- 209 2
- 212 2
- 219 2
- 220 2
- 233 2
- 236 2
- 246 2
- 254 2
- 256 2
- 260 2
- 265 2
- 271 2
- 276 2
- 278 2
- 300 2
- 303 2
- 307 2
- 311 2
- 317 2
- 327 2
- 342 2
- 349 2
- 364 2
- 373 2
- 375 2
- 380 2
- 387 2
- 399 2
- 405 2
- 414 2
- 461 2
- 501 2
- 524 2
- 541 2
- 550 2
- 556 2
- 560 2
- 565 2
- 566 2
- 2351 2
- 2851 2
- 2854 2
- 2858 2
- 2876 2
- 2902 2
- 4178 2
- 7022 2
- 7084 2
- 7113 2
- 7118 2
- 7128 2
- 7130 2
- 7139 2
- 7148 2
- 7150 2
- 19 1
- 24 1
- 30 1
- 32 1
- 35 1
- 44 1
- 45 1
- 49 1
- 50 1
- 60 1
- 68 1
- 69 1
- 82 1
- 91 1
- 93 1
- 99 1
- 102 1
- 105 1
- 111 1
- 116 1
- 127 1
- 134 1
- 143 1
- 155 1
- 160 1
- 198 1
- 203 1
- 235 1
- 262 1
- 304 1
- 313 1
- 321 1
- 343 1
- 368 1
- 377 1
- 383 1
- 407 1
- 419 1
- 429 1
- 442 1
- 454 1
- 481 1
- 498 1
- 509 1
- 535 1
- 540 1
- 545 1
- 557 1
- 582 1
- 593 1
- 613 1
- 651 1
- 681 1
- 686 1
- 720 1
- 746 1
- 767 1
- 801 1
- 836 1
- 855 1
- 861 1
- 898 1
- 938 1
- 967 1
- 1021 1
- 1066 1
- 1075 1
- 1091 1
- 1131 1
- 1207 1
- 1264 1
- 1275 1
- 1284 1
- 1299 1
- 1313 1
- 1353 1
- 1375 1
- 1437 1
- 1465 1
- 1496 1
- 1515 1
- 1520 1
- 1562 1
- 1590 1
- 1605 1
- 1628 1
- 1662 1
- 1670 1
- 1675 1
- 1712 1
- 1745 1
- 1785 1
- 1884 1
- 1924 1
- 1938 1
- 1947 1
- 1983 1
- 1996 1
- 2010 1
- 2031 1
- 2045 1
- 2058 1
- 2064 1
- 2067 1
- 2088 1
- 2103 1
- 2121 1
- 2128 1
- 2132 1
- 2145 1
- 2159 1
- 2165 1
- 2179 1
- 2185 1
- 2190 1
- 2199 1
- 2203 1
- 2220 1
- 2233 1
- 2236 1
- 2243 1
- 2253 1
- 2258 1
- 2260 1
- 2267 1
- 2273 1
- 2281 1
- 2284 1
- 2289 1
- 2296 1
- 2300 1
- 2304 1
- 2308 1
- 2315 1
- 2323 1
- 2325 1
- 2329 1
- 2332 1
- 2338 1
- 2342 1
- 2348 1
- 2349 1
- 2350 1
- 2358 1
- 2360 1
- 2362 1
- 2364 1
- 2366 1
- 2367 1
- 2370 1
- 2376 1
- 2381 1
- 2395 1
- 2402 1
- 2407 1
- 2427 1
- 2436 1
- 2446 1
- 2464 1
- 2483 1
- 2498 1
- 2508 1
- 2511 1
- 2514 1
- 2538 1
- 2548 1
- 2563 1
- 2576 1
- 2586 1
- 2602 1
- 2604 1
- 2612 1
- 2628 1
- 2651 1
- 2671 1
- 2677 1
- 2683 1
- 2687 1
- 2699 1
- 2705 1
- 2716 1
- 2730 1
- 2738 1
- 2740 1
- 2743 1
- 2749 1
- 2757 1
- 2761 1
- 2771 1
- 2775 1
- 2780 1
- 2785 1
- 2793 1
- 2794 1
- 2800 1
- 2804 1
- 2809 1
- 2810 1
- 2812 1
- 2816 1
- 2818 1
- 2821 1
- 2823 1
- 2825 1
- 2826 1
- 2827 1
- 2832 1
- 2834 1
- 2836 1
- 2837 1
- 2852 1
- 2855 1
- 2861 1
- 2864 1
- 2867 1
- 2870 1
- 2873 1
- 2875 1
- 2877 1
- 2881 1
- 2883 1
- 2891 1
- 2893 1
- 2895 1
- 2897 1
- 2901 1
- 2906 1
- 2910 1
- 2914 1
- 2919 1
- 2924 1
- 2925 1
- 2927 1
- 2928 1
- 2932 1
- 2941 1
- 2946 1
- 2955 1
- 2958 1
- 2959 1
- 2963 1
- 2968 1
- 2976 1
- 2985 1
- 2994 1
- 3001 1
- 3009 1
- 3019 1
- 3029 1
- 3042 1
- 3056 1
- 3067 1
- 3094 1
- 3102 1
- 3117 1
- 3125 1
- 3155 1
- 3171 1
- 3194 1
- 3220 1
- 3230 1
- 3236 1
- 3273 1
- 3286 1
- 3346 1
- 3367 1
- 3400 1
- 3416 1
- 3422 1
- 3431 1
- 3438 1
- 3461 1
- 3482 1
- 3509 1
- 3535 1
- 3556 1
- 3582 1
- 3593 1
- 3604 1
- 3639 1
- 3653 1
- 3678 1
- 3689 1
- 3709 1
- 3724 1
- 3750 1
- 3784 1
- 3808 1
- 3823 1
- 3839 1
- 3859 1
- 3873 1
- 3889 1
- 3912 1
- 3922 1
- 3929 1
- 3932 1
- 3961 1
- 3999 1
- 4012 1
- 4028 1
- 4049 1
- 4060 1
- 4069 1
- 4100 1
- 4113 1
- 4136 1
- 4148 1
- 4168 1
- 4207 1
- 4217 1
- 4236 1
- 4263 1
- 4283 1
- 4299 1
- 4312 1
- 4324 1
- 4337 1
- 4367 1
- 4411 1
- 4480 1
- 4519 1
- 4538 1
- 4562 1
- 4578 1
- 4608 1
- 4633 1
- 4648 1
- 4671 1
- 4684 1
- 4696 1
- 4722 1
- 4731 1
- 4736 1
- 4752 1
- 4762 1
- 4784 1
- 4795 1
- 4839 1
- 4865 1
- 4895 1
- 4905 1
- 4916 1
- 4917 1
- 4934 1
- 4949 1
- 4973 1
- 5023 1
- 5041 1
- 5058 1
- 5074 1
- 5093 1
- 5101 1
- 5132 1
- 5142 1
- 5156 1
- 5171 1
- 5174 1
- 5195 1
- 5208 1
- 5223 1
- 5240 1
- 5253 1
- 5255 1
- 5269 1
- 5281 1
- 5302 1
- 5322 1
- 5335 1
- 5369 1
- 5382 1
- 5405 1
- 5444 1
- 5485 1
- 5527 1
- 5589 1
- 5634 1
- 5669 1
- 5699 1
- 5734 1
- 5801 1
- 5870 1
- 5929 1
- 6002 1
- 6103 1
- 6124 1
- 6168 1
- 6237 1
- 6311 1
- 6362 1
- 6396 1
- 6441 1
- 6467 1
- 6518 1
- 6542 1
- 6597 1
- 6640 1
- 6680 1
- 6705 1
- 6719 1
- 6734 1
- 6774 1
- 6804 1
- 6832 1
- 6867 1
- 6873 1
- 6896 1
- 6914 1
- 6915 1
- 6924 1
- 6939 1
- 6957 1
- 6964 1
- 6971 1
- 6979 1
- 6990 1
- 7001 1
- 7012 1
- 7019 1
- 7036 1
- 7038 1
- 7049 1
- 7054 1
- 7061 1
- 7062 1
- 7064 1
- 7067 1
- 7070 1
- 7076 1
- 7078 1
- 7082 1
- 7086 1
- 7088 1
- 7091 1
- 7094 1
- 7095 1
- 7097 1
- 7098 1
- 7101 1
- 7102 1
- 7108 1
- 7110 1
- 7112 1
- 7114 1
- 7115 1
- 7127 1
- 7129 1
- 7132 1
- 7136 1
- 7138 1
- 7140 1
- 7141 1
- 7144 1
- 7153 1
state 2
- Pennsylvania 767
- Kansas 687
county 1
- Elk · 1,454 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500497 | 2500497 | 2022-05-13 | Elk | Kansas | 20049 | 571 | 10 |
2501870 | 2501870 | 2022-05-13 | Elk | Pennsylvania | 42047 | 7193 | 101 |
2497239 | 2497239 | 2022-05-12 | Elk | Kansas | 20049 | 571 | 10 |
2498612 | 2498612 | 2022-05-12 | Elk | Pennsylvania | 42047 | 7193 | 101 |
2493981 | 2493981 | 2022-05-11 | Elk | Kansas | 20049 | 571 | 10 |
2495354 | 2495354 | 2022-05-11 | Elk | Pennsylvania | 42047 | 7193 | 101 |
2490723 | 2490723 | 2022-05-10 | Elk | Kansas | 20049 | 571 | 10 |
2492096 | 2492096 | 2022-05-10 | Elk | Pennsylvania | 42047 | 7156 | 101 |
2487466 | 2487466 | 2022-05-09 | Elk | Kansas | 20049 | 571 | 10 |
2488838 | 2488838 | 2022-05-09 | Elk | Pennsylvania | 42047 | 7156 | 101 |
2484208 | 2484208 | 2022-05-08 | Elk | Kansas | 20049 | 571 | 10 |
2485581 | 2485581 | 2022-05-08 | Elk | Pennsylvania | 42047 | 7156 | 101 |
2480950 | 2480950 | 2022-05-07 | Elk | Kansas | 20049 | 571 | 10 |
2482323 | 2482323 | 2022-05-07 | Elk | Pennsylvania | 42047 | 7156 | 101 |
2477692 | 2477692 | 2022-05-06 | Elk | Kansas | 20049 | 571 | 10 |
2479065 | 2479065 | 2022-05-06 | Elk | Pennsylvania | 42047 | 7156 | 101 |
2474434 | 2474434 | 2022-05-05 | Elk | Kansas | 20049 | 570 | 10 |
2475807 | 2475807 | 2022-05-05 | Elk | Pennsylvania | 42047 | 7156 | 101 |
2471177 | 2471177 | 2022-05-04 | Elk | Kansas | 20049 | 570 | 10 |
2472550 | 2472550 | 2022-05-04 | Elk | Pennsylvania | 42047 | 7156 | 101 |
2467921 | 2467921 | 2022-05-03 | Elk | Kansas | 20049 | 570 | 10 |
2469294 | 2469294 | 2022-05-03 | Elk | Pennsylvania | 42047 | 7153 | 101 |
2464666 | 2464666 | 2022-05-02 | Elk | Kansas | 20049 | 570 | 10 |
2466038 | 2466038 | 2022-05-02 | Elk | Pennsylvania | 42047 | 7150 | 101 |
2461410 | 2461410 | 2022-05-01 | Elk | Kansas | 20049 | 570 | 10 |
2462783 | 2462783 | 2022-05-01 | Elk | Pennsylvania | 42047 | 7150 | 101 |
2458154 | 2458154 | 2022-04-30 | Elk | Kansas | 20049 | 570 | 10 |
2459527 | 2459527 | 2022-04-30 | Elk | Pennsylvania | 42047 | 7148 | 101 |
2454898 | 2454898 | 2022-04-29 | Elk | Kansas | 20049 | 570 | 10 |
2456271 | 2456271 | 2022-04-29 | Elk | Pennsylvania | 42047 | 7148 | 101 |
2451642 | 2451642 | 2022-04-28 | Elk | Kansas | 20049 | 569 | 10 |
2453015 | 2453015 | 2022-04-28 | Elk | Pennsylvania | 42047 | 7144 | 101 |
2448386 | 2448386 | 2022-04-27 | Elk | Kansas | 20049 | 569 | 10 |
2449759 | 2449759 | 2022-04-27 | Elk | Pennsylvania | 42047 | 7141 | 101 |
2445130 | 2445130 | 2022-04-26 | Elk | Kansas | 20049 | 569 | 10 |
2446502 | 2446502 | 2022-04-26 | Elk | Pennsylvania | 42047 | 7140 | 101 |
2441874 | 2441874 | 2022-04-25 | Elk | Kansas | 20049 | 569 | 10 |
2443247 | 2443247 | 2022-04-25 | Elk | Pennsylvania | 42047 | 7139 | 101 |
2438618 | 2438618 | 2022-04-24 | Elk | Kansas | 20049 | 569 | 10 |
2439991 | 2439991 | 2022-04-24 | Elk | Pennsylvania | 42047 | 7139 | 101 |
2435362 | 2435362 | 2022-04-23 | Elk | Kansas | 20049 | 569 | 10 |
2436735 | 2436735 | 2022-04-23 | Elk | Pennsylvania | 42047 | 7138 | 101 |
2432106 | 2432106 | 2022-04-22 | Elk | Kansas | 20049 | 569 | 10 |
2433479 | 2433479 | 2022-04-22 | Elk | Pennsylvania | 42047 | 7136 | 101 |
2428850 | 2428850 | 2022-04-21 | Elk | Kansas | 20049 | 568 | 10 |
2430223 | 2430223 | 2022-04-21 | Elk | Pennsylvania | 42047 | 7135 | 101 |
2425594 | 2425594 | 2022-04-20 | Elk | Kansas | 20049 | 568 | 10 |
2426967 | 2426967 | 2022-04-20 | Elk | Pennsylvania | 42047 | 7135 | 101 |
2422338 | 2422338 | 2022-04-19 | Elk | Kansas | 20049 | 568 | 10 |
2423711 | 2423711 | 2022-04-19 | Elk | Pennsylvania | 42047 | 7135 | 101 |
2419082 | 2419082 | 2022-04-18 | Elk | Kansas | 20049 | 568 | 10 |
2420455 | 2420455 | 2022-04-18 | Elk | Pennsylvania | 42047 | 7132 | 101 |
2415826 | 2415826 | 2022-04-17 | Elk | Kansas | 20049 | 568 | 10 |
2417199 | 2417199 | 2022-04-17 | Elk | Pennsylvania | 42047 | 7131 | 101 |
2412570 | 2412570 | 2022-04-16 | Elk | Kansas | 20049 | 568 | 10 |
2413943 | 2413943 | 2022-04-16 | Elk | Pennsylvania | 42047 | 7131 | 101 |
2409314 | 2409314 | 2022-04-15 | Elk | Kansas | 20049 | 568 | 10 |
2410687 | 2410687 | 2022-04-15 | Elk | Pennsylvania | 42047 | 7131 | 101 |
2406058 | 2406058 | 2022-04-14 | Elk | Kansas | 20049 | 570 | 10 |
2407431 | 2407431 | 2022-04-14 | Elk | Pennsylvania | 42047 | 7131 | 101 |
2402802 | 2402802 | 2022-04-13 | Elk | Kansas | 20049 | 570 | 10 |
2404175 | 2404175 | 2022-04-13 | Elk | Pennsylvania | 42047 | 7131 | 100 |
2399548 | 2399548 | 2022-04-12 | Elk | Kansas | 20049 | 570 | 10 |
2400920 | 2400920 | 2022-04-12 | Elk | Pennsylvania | 42047 | 7131 | 100 |
2396292 | 2396292 | 2022-04-11 | Elk | Kansas | 20049 | 570 | 10 |
2397665 | 2397665 | 2022-04-11 | Elk | Pennsylvania | 42047 | 7131 | 100 |
2393037 | 2393037 | 2022-04-10 | Elk | Kansas | 20049 | 570 | 10 |
2394410 | 2394410 | 2022-04-10 | Elk | Pennsylvania | 42047 | 7131 | 100 |
2389781 | 2389781 | 2022-04-09 | Elk | Kansas | 20049 | 570 | 10 |
2391154 | 2391154 | 2022-04-09 | Elk | Pennsylvania | 42047 | 7131 | 100 |
2386525 | 2386525 | 2022-04-08 | Elk | Kansas | 20049 | 570 | 10 |
2387898 | 2387898 | 2022-04-08 | Elk | Pennsylvania | 42047 | 7131 | 100 |
2383271 | 2383271 | 2022-04-07 | Elk | Kansas | 20049 | 570 | 10 |
2384643 | 2384643 | 2022-04-07 | Elk | Pennsylvania | 42047 | 7131 | 100 |
2380016 | 2380016 | 2022-04-06 | Elk | Kansas | 20049 | 570 | 10 |
2381388 | 2381388 | 2022-04-06 | Elk | Pennsylvania | 42047 | 7130 | 100 |
2376761 | 2376761 | 2022-04-05 | Elk | Kansas | 20049 | 570 | 10 |
2378133 | 2378133 | 2022-04-05 | Elk | Pennsylvania | 42047 | 7130 | 100 |
2373509 | 2373509 | 2022-04-04 | Elk | Kansas | 20049 | 570 | 10 |
2374879 | 2374879 | 2022-04-04 | Elk | Pennsylvania | 42047 | 7129 | 100 |
2370256 | 2370256 | 2022-04-03 | Elk | Kansas | 20049 | 570 | 10 |
2371627 | 2371627 | 2022-04-03 | Elk | Pennsylvania | 42047 | 7128 | 100 |
2367003 | 2367003 | 2022-04-02 | Elk | Kansas | 20049 | 570 | 10 |
2368374 | 2368374 | 2022-04-02 | Elk | Pennsylvania | 42047 | 7128 | 100 |
2363750 | 2363750 | 2022-04-01 | Elk | Kansas | 20049 | 570 | 10 |
2365121 | 2365121 | 2022-04-01 | Elk | Pennsylvania | 42047 | 7127 | 100 |
2360496 | 2360496 | 2022-03-31 | Elk | Kansas | 20049 | 570 | 9 |
2361868 | 2361868 | 2022-03-31 | Elk | Pennsylvania | 42047 | 7125 | 99 |
2357242 | 2357242 | 2022-03-30 | Elk | Kansas | 20049 | 570 | 9 |
2358614 | 2358614 | 2022-03-30 | Elk | Pennsylvania | 42047 | 7125 | 99 |
2353989 | 2353989 | 2022-03-29 | Elk | Kansas | 20049 | 570 | 9 |
2355360 | 2355360 | 2022-03-29 | Elk | Pennsylvania | 42047 | 7125 | 98 |
2350737 | 2350737 | 2022-03-28 | Elk | Kansas | 20049 | 570 | 9 |
2352107 | 2352107 | 2022-03-28 | Elk | Pennsylvania | 42047 | 7122 | 98 |
2347484 | 2347484 | 2022-03-27 | Elk | Kansas | 20049 | 570 | 9 |
2348855 | 2348855 | 2022-03-27 | Elk | Pennsylvania | 42047 | 7122 | 98 |
2344231 | 2344231 | 2022-03-26 | Elk | Kansas | 20049 | 570 | 9 |
2345602 | 2345602 | 2022-03-26 | Elk | Pennsylvania | 42047 | 7122 | 98 |
2340978 | 2340978 | 2022-03-25 | Elk | Kansas | 20049 | 570 | 9 |
2342349 | 2342349 | 2022-03-25 | Elk | Pennsylvania | 42047 | 7118 | 97 |
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);