ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where county = "Amherst" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 570 ✖
- 27 20
- 10 14
- 25 8
- 1 6
- 9 6
- 15 6
- 6 5
- 38 5
- 2979 5
- 7198 5
- 28 4
- 35 4
- 40 4
- 2985 4
- 4178 4
- 29 3
- 36 3
- 37 3
- 2930 3
- 2939 3
- 2969 3
- 2990 3
- 3007 3
- 3022 3
- 3061 3
- 3104 3
- 3154 3
- 3235 3
- 3360 3
- 3548 3
- 3794 3
- 3937 3
- 4012 3
- 4099 3
- 4252 3
- 4298 3
- 4349 3
- 4382 3
- 4440 3
- 4470 3
- 4504 3
- 4543 3
- 4623 3
- 4691 3
- 4774 3
- 4894 3
- 5146 3
- 5528 3
- 5852 3
- 6133 3
- 6385 3
- 6586 3
- 6753 3
- 6887 3
- 6991 3
- 7052 3
- 7166 3
- 7179 3
- 7193 3
- 7216 3
- 7237 3
- 7264 3
- 7292 3
- 2 2
- 3 2
- 8 2
- 12 2
- 14 2
- 26 2
- 31 2
- 325 2
- 573 2
- 626 2
- 633 2
- 665 2
- 2714 2
- 2841 2
- 2860 2
- 2879 2
- 2897 2
- 2909 2
- 2917 2
- 2918 2
- 2920 2
- 2947 2
- 2954 2
- 2972 2
- 2973 2
- 2975 2
- 2984 2
- 2999 2
- 7170 2
- 7176 2
- 7201 2
- 7300 2
- 5 1
- 11 1
- 13 1
- 16 1
- 17 1
- 20 1
- 21 1
- 22 1
- 24 1
- 32 1
- 42 1
- 43 1
- 45 1
- 49 1
- 52 1
- 60 1
- 61 1
- 66 1
- 67 1
- 71 1
- 76 1
- 81 1
- 88 1
- 92 1
- 99 1
- 101 1
- 105 1
- 108 1
- 114 1
- 118 1
- 124 1
- 130 1
- 137 1
- 154 1
- 165 1
- 175 1
- 176 1
- 183 1
- 184 1
- 196 1
- 202 1
- 206 1
- 217 1
- 219 1
- 223 1
- 228 1
- 237 1
- 246 1
- 253 1
- 259 1
- 262 1
- 269 1
- 270 1
- 273 1
- 277 1
- 282 1
- 286 1
- 290 1
- 298 1
- 307 1
- 313 1
- 319 1
- 320 1
- 323 1
- 327 1
- 328 1
- 333 1
- 339 1
- 343 1
- 345 1
- 351 1
- 354 1
- 357 1
- 367 1
- 370 1
- 372 1
- 374 1
- 379 1
- 381 1
- 388 1
- 390 1
- 395 1
- 396 1
- 398 1
- 402 1
- 403 1
- 405 1
- 421 1
- 423 1
- 427 1
- 428 1
- 433 1
- 434 1
- 445 1
- 457 1
- 464 1
- 469 1
- 473 1
- 487 1
- 497 1
- 507 1
- 517 1
- 523 1
- 525 1
- 529 1
- 540 1
- 549 1
- 555 1
- 563 1
- 568 1
- 583 1
- 600 1
- 614 1
- 619 1
- 623 1
- 639 1
- 642 1
- 651 1
- 652 1
- 656 1
- 657 1
- 661 1
- 663 1
- 668 1
- 678 1
- 691 1
- 693 1
- 699 1
- 710 1
- 715 1
- 726 1
- 735 1
- 755 1
- 769 1
- 785 1
- 791 1
- 810 1
- 818 1
- 819 1
- 829 1
- 833 1
- 841 1
- 867 1
- 884 1
- 898 1
- 912 1
- 938 1
- 982 1
- 1010 1
- 1031 1
- 1058 1
- 1065 1
- 1096 1
- 1127 1
- 1159 1
- 1179 1
- 1183 1
- 1204 1
- 1221 1
- 1236 1
- 1260 1
- 1281 1
- 1312 1
- 1335 1
- 1350 1
- 1361 1
- 1371 1
- 1400 1
- 1424 1
- 1443 1
- 1472 1
- 1490 1
- 1510 1
- 1519 1
- 1542 1
- 1566 1
- 1659 1
- 1687 1
- 1734 1
- 1754 1
- 1760 1
- 1787 1
- 1821 1
- 1858 1
- 1887 1
- 1940 1
- 1991 1
- 2033 1
- 2049 1
- 2080 1
- 2127 1
- 2156 1
- 2226 1
- 2251 1
- 2270 1
- 2284 1
- 2321 1
- 2338 1
- 2350 1
- 2372 1
- 2380 1
- 2401 1
- 2409 1
- 2421 1
- 2431 1
- 2446 1
- 2468 1
- 2479 1
- 2485 1
- 2511 1
- 2538 1
- 2574 1
- 2590 1
- 2595 1
- 2600 1
- 2601 1
- 2607 1
- 2619 1
- 2629 1
- 2632 1
- 2640 1
- 2641 1
- 2642 1
- 2649 1
- 2659 1
- 2663 1
- 2665 1
- 2673 1
- 2674 1
- 2676 1
- 2681 1
- 2683 1
- 2685 1
- 2696 1
- 2712 1
- 2721 1
- 2725 1
- 2726 1
- 2727 1
- 2729 1
- 2730 1
- 2734 1
- 2739 1
- 2742 1
- 2748 1
- 2754 1
- 2758 1
- 2759 1
- 2761 1
- 2764 1
- 2766 1
- 2773 1
- 2776 1
- 2779 1
- 2781 1
- 2784 1
- 2785 1
- 2788 1
- 2791 1
- 2795 1
- 2797 1
- 2799 1
- 2802 1
- 2804 1
- 2809 1
- 2818 1
- 2825 1
- 2835 1
- 2858 1
- 2859 1
- 2864 1
- 2865 1
- 2869 1
- 2875 1
- 2877 1
- 2878 1
- 2882 1
- 2886 1
- 2894 1
- 2902 1
- 2904 1
- 2907 1
- 2910 1
- 2914 1
- 2923 1
- 2927 1
- 2929 1
- 2934 1
- 2935 1
- 2938 1
- 2951 1
- 2953 1
- 2955 1
- 2956 1
- 2957 1
- 2962 1
- 2970 1
- 2971 1
- 2978 1
- 2980 1
- 2981 1
- 2982 1
- 2986 1
- 2987 1
- 2988 1
- 2989 1
- 2992 1
- 2994 1
- 2995 1
- 2997 1
- 3001 1
- 3002 1
- 3005 1
- 3009 1
- 3013 1
- 3018 1
- 3019 1
- 3026 1
- 3027 1
- 3036 1
- 3043 1
- 3077 1
- 3083 1
- 3086 1
- 3094 1
- 3118 1
- 3121 1
- 3131 1
- 3141 1
- 3185 1
- 3189 1
- 3207 1
- 3227 1
- 3271 1
- 3281 1
- 3299 1
- 3339 1
- 3424 1
- 3458 1
- 3478 1
- 3526 1
- 3627 1
- 3634 1
- 3653 1
- 3738 1
- 3825 1
- 3850 1
- 3891 1
- 3910 1
- 3997 1
- 4018 1
- 4040 1
- 4054 1
- 4059 1
- 4065 1
- 4071 1
- 4089 1
- 4134 1
- 4141 1
- 4161 1
- 4168 1
- 4216 1
- 4235 1
- 4246 1
- 4267 1
- 4270 1
- 4280 1
- 4293 1
- 4314 1
- 4326 1
- 4338 1
- 4340 1
- 4360 1
- 4364 1
- 4368 1
- 4373 1
- 4399 1
- 4410 1
- 4425 1
- 4429 1
- 4446 1
- 4448 1
- 4456 1
- 4467 1
- 4481 1
- 4489 1
- 4491 1
- 4497 1
- 4509 1
- 4517 1
- 4526 1
- 4538 1
- 4588 1
- 4592 1
- 4597 1
- 4610 1
- 4648 1
- 4659 1
- 4671 1
- 4684 1
- 4729 1
- 4735 1
- 4755 1
- 4760 1
- 4794 1
- 4795 1
- 4822 1
- 4845 1
- 5008 1
- 5042 1
- 5059 1
- 5100 1
- 5330 1
- 5358 1
- 5426 1
- 5495 1
- 5697 1
- 5716 1
- 5735 1
- 5798 1
- 5958 1
- 5997 1
- 6056 1
- 6101 1
- 6221 1
- 6258 1
- 6288 1
- 6331 1
- 6448 1
- 6476 1
- 6520 1
- 6552 1
- 6632 1
- 6654 1
- 6692 1
- 6721 1
- 6796 1
- 6827 1
- 6840 1
- 6869 1
- 6917 1
- 6929 1
- 6952 1
- 6973 1
- 7014 1
- 7023 1
- 7036 1
- 7041 1
- 7073 1
- 7096 1
- 7128 1
- 7147 1
- 7182 1
- 7183 1
- 7189 1
- 7191 1
- 7199 1
- 7205 1
- 7208 1
- 7213 1
- 7221 1
- 7222 1
- 7227 1
- 7229 1
- 7241 1
- 7248 1
- 7250 1
- 7256 1
- 7272 1
- 7273 1
- 7280 1
- 7283 1
- 7306 1
- 7309 1
- 7316 1
state 1
- Virginia 783
fips 1
- 51009 783
county 1
- Amherst · 783 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502515 | 2502515 | 2022-05-13 | Amherst | Virginia | 51009 | 7316 | 89 |
2499257 | 2499257 | 2022-05-12 | Amherst | Virginia | 51009 | 7309 | 89 |
2495999 | 2495999 | 2022-05-11 | Amherst | Virginia | 51009 | 7306 | 89 |
2492741 | 2492741 | 2022-05-10 | Amherst | Virginia | 51009 | 7300 | 89 |
2489483 | 2489483 | 2022-05-09 | Amherst | Virginia | 51009 | 7300 | 88 |
2486226 | 2486226 | 2022-05-08 | Amherst | Virginia | 51009 | 7292 | 88 |
2482968 | 2482968 | 2022-05-07 | Amherst | Virginia | 51009 | 7292 | 88 |
2479710 | 2479710 | 2022-05-06 | Amherst | Virginia | 51009 | 7292 | 88 |
2476452 | 2476452 | 2022-05-05 | Amherst | Virginia | 51009 | 7283 | 88 |
2473194 | 2473194 | 2022-05-04 | Amherst | Virginia | 51009 | 7280 | 88 |
2469938 | 2469938 | 2022-05-03 | Amherst | Virginia | 51009 | 7273 | 88 |
2466682 | 2466682 | 2022-05-02 | Amherst | Virginia | 51009 | 7272 | 88 |
2463427 | 2463427 | 2022-05-01 | Amherst | Virginia | 51009 | 7264 | 88 |
2460171 | 2460171 | 2022-04-30 | Amherst | Virginia | 51009 | 7264 | 88 |
2456915 | 2456915 | 2022-04-29 | Amherst | Virginia | 51009 | 7264 | 88 |
2453659 | 2453659 | 2022-04-28 | Amherst | Virginia | 51009 | 7256 | 88 |
2450403 | 2450403 | 2022-04-27 | Amherst | Virginia | 51009 | 7250 | 88 |
2447146 | 2447146 | 2022-04-26 | Amherst | Virginia | 51009 | 7248 | 88 |
2443891 | 2443891 | 2022-04-25 | Amherst | Virginia | 51009 | 7241 | 88 |
2440635 | 2440635 | 2022-04-24 | Amherst | Virginia | 51009 | 7237 | 88 |
2437379 | 2437379 | 2022-04-23 | Amherst | Virginia | 51009 | 7237 | 88 |
2434123 | 2434123 | 2022-04-22 | Amherst | Virginia | 51009 | 7237 | 88 |
2430867 | 2430867 | 2022-04-21 | Amherst | Virginia | 51009 | 7229 | 88 |
2427611 | 2427611 | 2022-04-20 | Amherst | Virginia | 51009 | 7227 | 88 |
2424355 | 2424355 | 2022-04-19 | Amherst | Virginia | 51009 | 7222 | 88 |
2421099 | 2421099 | 2022-04-18 | Amherst | Virginia | 51009 | 7221 | 88 |
2417843 | 2417843 | 2022-04-17 | Amherst | Virginia | 51009 | 7216 | 88 |
2414587 | 2414587 | 2022-04-16 | Amherst | Virginia | 51009 | 7216 | 88 |
2411331 | 2411331 | 2022-04-15 | Amherst | Virginia | 51009 | 7216 | 88 |
2408075 | 2408075 | 2022-04-14 | Amherst | Virginia | 51009 | 7213 | 88 |
2404819 | 2404819 | 2022-04-13 | Amherst | Virginia | 51009 | 7208 | 88 |
2401564 | 2401564 | 2022-04-12 | Amherst | Virginia | 51009 | 7205 | 88 |
2398309 | 2398309 | 2022-04-11 | Amherst | Virginia | 51009 | 7201 | 88 |
2395054 | 2395054 | 2022-04-10 | Amherst | Virginia | 51009 | 7198 | 87 |
2391798 | 2391798 | 2022-04-09 | Amherst | Virginia | 51009 | 7198 | 87 |
2388542 | 2388542 | 2022-04-08 | Amherst | Virginia | 51009 | 7198 | 87 |
2385287 | 2385287 | 2022-04-07 | Amherst | Virginia | 51009 | 7201 | 86 |
2382032 | 2382032 | 2022-04-06 | Amherst | Virginia | 51009 | 7199 | 86 |
2378777 | 2378777 | 2022-04-05 | Amherst | Virginia | 51009 | 7198 | 86 |
2375523 | 2375523 | 2022-04-04 | Amherst | Virginia | 51009 | 7198 | 86 |
2372271 | 2372271 | 2022-04-03 | Amherst | Virginia | 51009 | 7193 | 86 |
2369018 | 2369018 | 2022-04-02 | Amherst | Virginia | 51009 | 7193 | 86 |
2365765 | 2365765 | 2022-04-01 | Amherst | Virginia | 51009 | 7193 | 86 |
2362512 | 2362512 | 2022-03-31 | Amherst | Virginia | 51009 | 7191 | 86 |
2359258 | 2359258 | 2022-03-30 | Amherst | Virginia | 51009 | 7189 | 86 |
2356004 | 2356004 | 2022-03-29 | Amherst | Virginia | 51009 | 7183 | 85 |
2352751 | 2352751 | 2022-03-28 | Amherst | Virginia | 51009 | 7182 | 85 |
2349499 | 2349499 | 2022-03-27 | Amherst | Virginia | 51009 | 7179 | 84 |
2346246 | 2346246 | 2022-03-26 | Amherst | Virginia | 51009 | 7179 | 84 |
2342993 | 2342993 | 2022-03-25 | Amherst | Virginia | 51009 | 7179 | 84 |
2339740 | 2339740 | 2022-03-24 | Amherst | Virginia | 51009 | 7176 | 84 |
2336486 | 2336486 | 2022-03-23 | Amherst | Virginia | 51009 | 7176 | 84 |
2333232 | 2333232 | 2022-03-22 | Amherst | Virginia | 51009 | 7170 | 84 |
2329979 | 2329979 | 2022-03-21 | Amherst | Virginia | 51009 | 7170 | 84 |
2326727 | 2326727 | 2022-03-20 | Amherst | Virginia | 51009 | 7166 | 84 |
2323474 | 2323474 | 2022-03-19 | Amherst | Virginia | 51009 | 7166 | 84 |
2320220 | 2320220 | 2022-03-18 | Amherst | Virginia | 51009 | 7166 | 84 |
2316966 | 2316966 | 2022-03-17 | Amherst | Virginia | 51009 | 7147 | 84 |
2313713 | 2313713 | 2022-03-16 | Amherst | Virginia | 51009 | 7128 | 84 |
2310460 | 2310460 | 2022-03-15 | Amherst | Virginia | 51009 | 7096 | 84 |
2307207 | 2307207 | 2022-03-14 | Amherst | Virginia | 51009 | 7073 | 84 |
2303956 | 2303956 | 2022-03-13 | Amherst | Virginia | 51009 | 7052 | 84 |
2300704 | 2300704 | 2022-03-12 | Amherst | Virginia | 51009 | 7052 | 84 |
2297452 | 2297452 | 2022-03-11 | Amherst | Virginia | 51009 | 7052 | 84 |
2294200 | 2294200 | 2022-03-10 | Amherst | Virginia | 51009 | 7041 | 84 |
2290948 | 2290948 | 2022-03-09 | Amherst | Virginia | 51009 | 7036 | 83 |
2287696 | 2287696 | 2022-03-08 | Amherst | Virginia | 51009 | 7023 | 83 |
2284444 | 2284444 | 2022-03-07 | Amherst | Virginia | 51009 | 7014 | 83 |
2281192 | 2281192 | 2022-03-06 | Amherst | Virginia | 51009 | 6991 | 83 |
2277939 | 2277939 | 2022-03-05 | Amherst | Virginia | 51009 | 6991 | 83 |
2274686 | 2274686 | 2022-03-04 | Amherst | Virginia | 51009 | 6991 | 83 |
2271433 | 2271433 | 2022-03-03 | Amherst | Virginia | 51009 | 6973 | 83 |
2268181 | 2268181 | 2022-03-02 | Amherst | Virginia | 51009 | 6952 | 83 |
2264928 | 2264928 | 2022-03-01 | Amherst | Virginia | 51009 | 6929 | 83 |
2261678 | 2261678 | 2022-02-28 | Amherst | Virginia | 51009 | 6917 | 83 |
2258427 | 2258427 | 2022-02-27 | Amherst | Virginia | 51009 | 6887 | 83 |
2255176 | 2255176 | 2022-02-26 | Amherst | Virginia | 51009 | 6887 | 83 |
2251925 | 2251925 | 2022-02-25 | Amherst | Virginia | 51009 | 6887 | 83 |
2248674 | 2248674 | 2022-02-24 | Amherst | Virginia | 51009 | 6869 | 82 |
2245423 | 2245423 | 2022-02-23 | Amherst | Virginia | 51009 | 6840 | 82 |
2242172 | 2242172 | 2022-02-22 | Amherst | Virginia | 51009 | 6827 | 80 |
2238921 | 2238921 | 2022-02-21 | Amherst | Virginia | 51009 | 6796 | 80 |
2235670 | 2235670 | 2022-02-20 | Amherst | Virginia | 51009 | 6753 | 79 |
2232419 | 2232419 | 2022-02-19 | Amherst | Virginia | 51009 | 6753 | 79 |
2229168 | 2229168 | 2022-02-18 | Amherst | Virginia | 51009 | 6753 | 79 |
2225917 | 2225917 | 2022-02-17 | Amherst | Virginia | 51009 | 6721 | 79 |
2222666 | 2222666 | 2022-02-16 | Amherst | Virginia | 51009 | 6692 | 79 |
2219415 | 2219415 | 2022-02-15 | Amherst | Virginia | 51009 | 6654 | 79 |
2216165 | 2216165 | 2022-02-14 | Amherst | Virginia | 51009 | 6632 | 77 |
2212914 | 2212914 | 2022-02-13 | Amherst | Virginia | 51009 | 6586 | 76 |
2209661 | 2209661 | 2022-02-12 | Amherst | Virginia | 51009 | 6586 | 76 |
2206408 | 2206408 | 2022-02-11 | Amherst | Virginia | 51009 | 6586 | 76 |
2203155 | 2203155 | 2022-02-10 | Amherst | Virginia | 51009 | 6552 | 76 |
2199901 | 2199901 | 2022-02-09 | Amherst | Virginia | 51009 | 6520 | 76 |
2196647 | 2196647 | 2022-02-08 | Amherst | Virginia | 51009 | 6476 | 76 |
2193392 | 2193392 | 2022-02-07 | Amherst | Virginia | 51009 | 6448 | 75 |
2190139 | 2190139 | 2022-02-06 | Amherst | Virginia | 51009 | 6385 | 74 |
2186886 | 2186886 | 2022-02-05 | Amherst | Virginia | 51009 | 6385 | 74 |
2183633 | 2183633 | 2022-02-04 | Amherst | Virginia | 51009 | 6385 | 74 |
2180381 | 2180381 | 2022-02-03 | Amherst | Virginia | 51009 | 6331 | 71 |
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);