ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Frederick" and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 663 ✖
- 11045 4
- 20551 4
- 4 3
- 81 3
- 8067 3
- 8081 3
- 8088 3
- 8193 3
- 8262 3
- 8334 3
- 8451 3
- 8614 3
- 8806 3
- 9041 3
- 9321 3
- 9640 3
- 9966 3
- 10324 3
- 10657 3
- 11285 3
- 11457 3
- 11606 3
- 11722 3
- 11868 3
- 12094 3
- 12321 3
- 12611 3
- 13035 3
- 13439 3
- 13865 3
- 14580 3
- 15890 3
- 17330 3
- 18268 3
- 19047 3
- 19518 3
- 19845 3
- 20103 3
- 20246 3
- 20341 3
- 20400 3
- 20460 3
- 20530 3
- 20544 3
- 20580 3
- 20625 3
- 20687 3
- 20765 3
- 87 2
- 93 2
- 115 2
- 132 2
- 435 2
- 461 2
- 597 2
- 680 2
- 681 2
- 7885 2
- 8079 2
- 8082 2
- 8085 2
- 8090 2
- 8108 2
- 8109 2
- 8112 2
- 20485 2
- 20564 2
- 2 1
- 8 1
- 10 1
- 12 1
- 15 1
- 16 1
- 20 1
- 24 1
- 27 1
- 31 1
- 43 1
- 46 1
- 54 1
- 62 1
- 63 1
- 65 1
- 66 1
- 71 1
- 72 1
- 73 1
- 76 1
- 83 1
- 86 1
- 95 1
- 97 1
- 101 1
- 105 1
- 121 1
- 126 1
- 147 1
- 150 1
- 162 1
- 164 1
- 166 1
- 175 1
- 182 1
- 191 1
- 195 1
- 209 1
- 211 1
- 217 1
- 223 1
- 234 1
- 245 1
- 249 1
- 255 1
- 262 1
- 271 1
- 272 1
- 296 1
- 319 1
- 331 1
- 344 1
- 349 1
- 359 1
- 371 1
- 378 1
- 384 1
- 388 1
- 393 1
- 409 1
- 410 1
- 413 1
- 415 1
- 416 1
- 423 1
- 428 1
- 433 1
- 440 1
- 444 1
- 446 1
- 449 1
- 456 1
- 460 1
- 464 1
- 465 1
- 479 1
- 488 1
- 491 1
- 493 1
- 505 1
- 512 1
- 517 1
- 518 1
- 520 1
- 521 1
- 524 1
- 529 1
- 534 1
- 536 1
- 543 1
- 551 1
- 553 1
- 558 1
- 565 1
- 570 1
- 575 1
- 582 1
- 588 1
- 607 1
- 614 1
- 626 1
- 634 1
- 638 1
- 639 1
- 641 1
- 644 1
- 649 1
- 651 1
- 661 1
- 663 1
- 670 1
- 672 1
- 673 1
- 675 1
- 685 1
- 686 1
- 688 1
- 690 1
- 695 1
- 698 1
- 701 1
- 709 1
- 715 1
- 719 1
- 724 1
- 730 1
- 738 1
- 744 1
- 753 1
- 755 1
- 757 1
- 758 1
- 762 1
- 763 1
- 764 1
- 766 1
- 772 1
- 774 1
- 775 1
- 777 1
- 784 1
- 787 1
- 793 1
- 794 1
- 799 1
- 806 1
- 809 1
- 813 1
- 815 1
- 821 1
- 823 1
- 829 1
- 833 1
- 838 1
- 845 1
- 848 1
- 859 1
- 860 1
- 865 1
- 873 1
- 881 1
- 883 1
- 888 1
- 895 1
- 899 1
- 905 1
- 912 1
- 931 1
- 944 1
- 951 1
- 954 1
- 957 1
- 971 1
- 979 1
- 995 1
- 1012 1
- 1018 1
- 1034 1
- 1041 1
- 1051 1
- 1068 1
- 1078 1
- 1085 1
- 1097 1
- 1107 1
- 1120 1
- 1123 1
- 1137 1
- 1144 1
- 1149 1
- 1158 1
- 1169 1
- 1181 1
- 1186 1
- 1195 1
- 1207 1
- 1215 1
- 1229 1
- 1240 1
- 1253 1
- 1275 1
- 1289 1
- 1309 1
- 1326 1
- 1342 1
- 1353 1
- 1377 1
- 1392 1
- 1427 1
- 1462 1
- 1481 1
- 1499 1
- 1558 1
- 1646 1
- 1704 1
- 1741 1
- 1759 1
- 1784 1
- 1832 1
- 1851 1
- 1885 1
- 1899 1
- 1929 1
- 2024 1
- 2109 1
- 2228 1
- 2266 1
- 2286 1
- 2319 1
- 2337 1
- 2394 1
- 2466 1
- 2508 1
- 2590 1
- 2651 1
- 2726 1
- 2776 1
- 2850 1
- 2898 1
- 2945 1
- 2995 1
- 3050 1
- 3135 1
- 3169 1
- 3211 1
- 3242 1
- 3264 1
- 3305 1
- 3347 1
- 3383 1
- 3448 1
- 3491 1
- 3555 1
- 3568 1
- 3648 1
- 3703 1
- 3732 1
- 3796 1
- 3871 1
- 3928 1
- 3962 1
- 4038 1
- 4103 1
- 4188 1
- 4247 1
- 4303 1
- 4340 1
- 4397 1
- 4472 1
- 4549 1
- 4598 1
- 4661 1
- 4738 1
- 4797 1
- 4863 1
- 4955 1
- 5037 1
- 5077 1
- 5195 1
- 5305 1
- 5368 1
- 5466 1
- 5583 1
- 5683 1
- 5841 1
- 5895 1
- 5955 1
- 6000 1
- 6023 1
- 6061 1
- 6127 1
- 6182 1
- 6217 1
- 6264 1
- 6275 1
- 6352 1
- 6416 1
- 6442 1
- 6474 1
- 6491 1
- 6516 1
- 6532 1
- 6548 1
- 6573 1
- 6585 1
- 6605 1
- 6625 1
- 6633 1
- 6661 1
- 6673 1
- 6689 1
- 6704 1
- 6711 1
- 6723 1
- 6738 1
- 6751 1
- 6760 1
- 6771 1
- 6789 1
- 6796 1
- 6820 1
- 6834 1
- 6843 1
- 6851 1
- 6863 1
- 6878 1
- 6893 1
- 6911 1
- 6930 1
- 6945 1
- 6952 1
- 6960 1
- 6979 1
- 7004 1
- 7022 1
- 7042 1
- 7054 1
- 7071 1
- 7087 1
- 7111 1
- 7132 1
- 7152 1
- 7169 1
- 7193 1
- 7205 1
- 7225 1
- 7233 1
- 7257 1
- 7280 1
- 7292 1
- 7307 1
- 7322 1
- 7343 1
- 7367 1
- 7388 1
- 7419 1
- 7450 1
- 7474 1
- 7487 1
- 7515 1
- 7525 1
- 7558 1
- 7576 1
- 7606 1
- 7618 1
- 7632 1
- 7646 1
- 7663 1
- 7681 1
- 7707 1
- 7731 1
- 7740 1
- 7749 1
- 7769 1
- 7780 1
- 7802 1
- 7831 1
- 7842 1
- 7847 1
- 7850 1
- 7864 1
- 7905 1
- 7912 1
- 7920 1
- 7925 1
- 7935 1
- 7939 1
- 7948 1
- 7960 1
- 7968 1
- 7970 1
- 7978 1
- 7987 1
- 7990 1
- 8000 1
- 8001 1
- 8009 1
- 8016 1
- 8019 1
- 8033 1
- 8041 1
- 8050 1
- 8054 1
- 8058 1
- 8063 1
- 8073 1
- 8083 1
- 8084 1
- 8086 1
- 8091 1
- 8092 1
- 8094 1
- 8098 1
- 8099 1
- 8106 1
- 8114 1
- 8119 1
- 8121 1
- 8123 1
- 8126 1
- 8128 1
- 8129 1
- 8136 1
- 8142 1
- 8144 1
- 8166 1
- 8181 1
- 8189 1
- 8213 1
- 8225 1
- 8238 1
- 8249 1
- 8285 1
- 8295 1
- 8315 1
- 8323 1
- 8360 1
- 8383 1
- 8407 1
- 8428 1
- 8511 1
- 8540 1
- 8564 1
- 8592 1
- 8683 1
- 8712 1
- 8734 1
- 8767 1
- 8880 1
- 8918 1
- 8957 1
- 8999 1
- 9132 1
- 9172 1
- 9213 1
- 9266 1
- 9428 1
- 9445 1
- 9513 1
- 9577 1
- 9777 1
- 9829 1
- 9874 1
- 9915 1
- 10105 1
- 10152 1
- 10214 1
- 10275 1
- 10446 1
- 10495 1
- 10559 1
- 10612 1
- 10806 1
- 10867 1
- 10946 1
- 10987 1
- 11148 1
- 11185 1
- 11232 1
- 11364 1
- 11398 1
- 11422 1
- 11440 1
- 11520 1
- 11536 1
- 11559 1
- 11592 1
- 11642 1
- 11661 1
- 11677 1
- 11700 1
- 11784 1
- 11806 1
- 11824 1
- 11850 1
- 11914 1
- 11946 1
- 12011 1
- 12054 1
- 12187 1
- 12220 1
- 12257 1
- 12301 1
- 12422 1
- 12455 1
- 12503 1
- 12542 1
- 12747 1
- 12796 1
- 12880 1
- 12951 1
- 13210 1
- 13264 1
- 13314 1
- 13387 1
- 13565 1
- 13611 1
- 13697 1
- 13774 1
- 14029 1
- 14080 1
- 14237 1
- 14352 1
- 15072 1
- 15230 1
- 15378 1
- 15623 1
- 16568 1
- 16738 1
- 16945 1
- 17156 1
- 17773 1
- 17853 1
- 17980 1
- 18096 1
- 18585 1
- 18677 1
- 18788 1
- 18929 1
- 19221 1
- 19293 1
- 19376 1
- 19438 1
- 19647 1
- 19684 1
- 19750 1
- 19800 1
- 19929 1
- 19974 1
- 20016 1
- 20053 1
- 20167 1
- 20193 1
- 20209 1
- 20227 1
- 20289 1
- 20319 1
- 20328 1
- 20337 1
- 20365 1
- 20377 1
- 20384 1
- 20396 1
- 20416 1
- 20422 1
- 20433 1
- 20448 1
- 20524 1
- 20528 1
- 20535 1
- 20542 1
- 20545 1
- 20546 1
- 20548 1
- 20550 1
- 20557 1
- 20563 1
- 20572 1
- 20591 1
- 20599 1
- 20604 1
- 20617 1
- 20634 1
- 20647 1
- 20660 1
- 20673 1
- 20704 1
- 20712 1
- 20725 1
- 20746 1
- 20815 1
- 20839 1
- 20854 1
- 20874 1
- 20904 1
state 1
- Virginia · 780 ✖
fips 1
- 51069 780
county 1
- Frederick · 780 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502555 | 2502555 | 2022-05-13 | Frederick | Virginia | 51069 | 20904 | 249 |
2499297 | 2499297 | 2022-05-12 | Frederick | Virginia | 51069 | 20874 | 248 |
2496039 | 2496039 | 2022-05-11 | Frederick | Virginia | 51069 | 20854 | 248 |
2492781 | 2492781 | 2022-05-10 | Frederick | Virginia | 51069 | 20839 | 247 |
2489523 | 2489523 | 2022-05-09 | Frederick | Virginia | 51069 | 20815 | 247 |
2486266 | 2486266 | 2022-05-08 | Frederick | Virginia | 51069 | 20765 | 247 |
2483008 | 2483008 | 2022-05-07 | Frederick | Virginia | 51069 | 20765 | 247 |
2479750 | 2479750 | 2022-05-06 | Frederick | Virginia | 51069 | 20765 | 247 |
2476492 | 2476492 | 2022-05-05 | Frederick | Virginia | 51069 | 20746 | 247 |
2473234 | 2473234 | 2022-05-04 | Frederick | Virginia | 51069 | 20725 | 247 |
2469978 | 2469978 | 2022-05-03 | Frederick | Virginia | 51069 | 20712 | 246 |
2466722 | 2466722 | 2022-05-02 | Frederick | Virginia | 51069 | 20704 | 246 |
2463467 | 2463467 | 2022-05-01 | Frederick | Virginia | 51069 | 20687 | 246 |
2460211 | 2460211 | 2022-04-30 | Frederick | Virginia | 51069 | 20687 | 246 |
2456955 | 2456955 | 2022-04-29 | Frederick | Virginia | 51069 | 20687 | 246 |
2453699 | 2453699 | 2022-04-28 | Frederick | Virginia | 51069 | 20673 | 245 |
2450443 | 2450443 | 2022-04-27 | Frederick | Virginia | 51069 | 20660 | 245 |
2447186 | 2447186 | 2022-04-26 | Frederick | Virginia | 51069 | 20647 | 245 |
2443931 | 2443931 | 2022-04-25 | Frederick | Virginia | 51069 | 20634 | 245 |
2440675 | 2440675 | 2022-04-24 | Frederick | Virginia | 51069 | 20625 | 244 |
2437419 | 2437419 | 2022-04-23 | Frederick | Virginia | 51069 | 20625 | 244 |
2434163 | 2434163 | 2022-04-22 | Frederick | Virginia | 51069 | 20625 | 244 |
2430907 | 2430907 | 2022-04-21 | Frederick | Virginia | 51069 | 20617 | 244 |
2427651 | 2427651 | 2022-04-20 | Frederick | Virginia | 51069 | 20604 | 244 |
2424395 | 2424395 | 2022-04-19 | Frederick | Virginia | 51069 | 20599 | 244 |
2421139 | 2421139 | 2022-04-18 | Frederick | Virginia | 51069 | 20591 | 244 |
2417883 | 2417883 | 2022-04-17 | Frederick | Virginia | 51069 | 20580 | 244 |
2414627 | 2414627 | 2022-04-16 | Frederick | Virginia | 51069 | 20580 | 244 |
2411371 | 2411371 | 2022-04-15 | Frederick | Virginia | 51069 | 20580 | 244 |
2408115 | 2408115 | 2022-04-14 | Frederick | Virginia | 51069 | 20572 | 244 |
2404859 | 2404859 | 2022-04-13 | Frederick | Virginia | 51069 | 20563 | 244 |
2401604 | 2401604 | 2022-04-12 | Frederick | Virginia | 51069 | 20551 | 244 |
2398349 | 2398349 | 2022-04-11 | Frederick | Virginia | 51069 | 20545 | 244 |
2395094 | 2395094 | 2022-04-10 | Frederick | Virginia | 51069 | 20544 | 244 |
2391838 | 2391838 | 2022-04-09 | Frederick | Virginia | 51069 | 20544 | 244 |
2388582 | 2388582 | 2022-04-08 | Frederick | Virginia | 51069 | 20544 | 244 |
2385327 | 2385327 | 2022-04-07 | Frederick | Virginia | 51069 | 20548 | 244 |
2382072 | 2382072 | 2022-04-06 | Frederick | Virginia | 51069 | 20557 | 244 |
2378817 | 2378817 | 2022-04-05 | Frederick | Virginia | 51069 | 20564 | 243 |
2375563 | 2375563 | 2022-04-04 | Frederick | Virginia | 51069 | 20564 | 243 |
2372311 | 2372311 | 2022-04-03 | Frederick | Virginia | 51069 | 20551 | 243 |
2369058 | 2369058 | 2022-04-02 | Frederick | Virginia | 51069 | 20551 | 243 |
2365805 | 2365805 | 2022-04-01 | Frederick | Virginia | 51069 | 20551 | 243 |
2362552 | 2362552 | 2022-03-31 | Frederick | Virginia | 51069 | 20550 | 242 |
2359298 | 2359298 | 2022-03-30 | Frederick | Virginia | 51069 | 20546 | 242 |
2356044 | 2356044 | 2022-03-29 | Frederick | Virginia | 51069 | 20542 | 241 |
2352791 | 2352791 | 2022-03-28 | Frederick | Virginia | 51069 | 20535 | 241 |
2349539 | 2349539 | 2022-03-27 | Frederick | Virginia | 51069 | 20530 | 241 |
2346286 | 2346286 | 2022-03-26 | Frederick | Virginia | 51069 | 20530 | 241 |
2343033 | 2343033 | 2022-03-25 | Frederick | Virginia | 51069 | 20530 | 241 |
2339780 | 2339780 | 2022-03-24 | Frederick | Virginia | 51069 | 20528 | 241 |
2336526 | 2336526 | 2022-03-23 | Frederick | Virginia | 51069 | 20524 | 241 |
2333272 | 2333272 | 2022-03-22 | Frederick | Virginia | 51069 | 20485 | 241 |
2330019 | 2330019 | 2022-03-21 | Frederick | Virginia | 51069 | 20485 | 241 |
2326767 | 2326767 | 2022-03-20 | Frederick | Virginia | 51069 | 20460 | 241 |
2323514 | 2323514 | 2022-03-19 | Frederick | Virginia | 51069 | 20460 | 241 |
2320260 | 2320260 | 2022-03-18 | Frederick | Virginia | 51069 | 20460 | 241 |
2317006 | 2317006 | 2022-03-17 | Frederick | Virginia | 51069 | 20448 | 238 |
2313753 | 2313753 | 2022-03-16 | Frederick | Virginia | 51069 | 20433 | 237 |
2310500 | 2310500 | 2022-03-15 | Frederick | Virginia | 51069 | 20422 | 234 |
2307247 | 2307247 | 2022-03-14 | Frederick | Virginia | 51069 | 20416 | 235 |
2303996 | 2303996 | 2022-03-13 | Frederick | Virginia | 51069 | 20400 | 233 |
2300744 | 2300744 | 2022-03-12 | Frederick | Virginia | 51069 | 20400 | 233 |
2297492 | 2297492 | 2022-03-11 | Frederick | Virginia | 51069 | 20400 | 233 |
2294240 | 2294240 | 2022-03-10 | Frederick | Virginia | 51069 | 20396 | 232 |
2290988 | 2290988 | 2022-03-09 | Frederick | Virginia | 51069 | 20384 | 232 |
2287736 | 2287736 | 2022-03-08 | Frederick | Virginia | 51069 | 20377 | 232 |
2284484 | 2284484 | 2022-03-07 | Frederick | Virginia | 51069 | 20365 | 231 |
2281232 | 2281232 | 2022-03-06 | Frederick | Virginia | 51069 | 20341 | 228 |
2277979 | 2277979 | 2022-03-05 | Frederick | Virginia | 51069 | 20341 | 228 |
2274726 | 2274726 | 2022-03-04 | Frederick | Virginia | 51069 | 20341 | 228 |
2271473 | 2271473 | 2022-03-03 | Frederick | Virginia | 51069 | 20328 | 228 |
2268221 | 2268221 | 2022-03-02 | Frederick | Virginia | 51069 | 20319 | 229 |
2264968 | 2264968 | 2022-03-01 | Frederick | Virginia | 51069 | 20337 | 228 |
2261718 | 2261718 | 2022-02-28 | Frederick | Virginia | 51069 | 20289 | 228 |
2258467 | 2258467 | 2022-02-27 | Frederick | Virginia | 51069 | 20246 | 228 |
2255216 | 2255216 | 2022-02-26 | Frederick | Virginia | 51069 | 20246 | 228 |
2251965 | 2251965 | 2022-02-25 | Frederick | Virginia | 51069 | 20246 | 228 |
2248714 | 2248714 | 2022-02-24 | Frederick | Virginia | 51069 | 20227 | 226 |
2245463 | 2245463 | 2022-02-23 | Frederick | Virginia | 51069 | 20209 | 224 |
2242212 | 2242212 | 2022-02-22 | Frederick | Virginia | 51069 | 20193 | 224 |
2238961 | 2238961 | 2022-02-21 | Frederick | Virginia | 51069 | 20167 | 224 |
2235710 | 2235710 | 2022-02-20 | Frederick | Virginia | 51069 | 20103 | 222 |
2232459 | 2232459 | 2022-02-19 | Frederick | Virginia | 51069 | 20103 | 222 |
2229208 | 2229208 | 2022-02-18 | Frederick | Virginia | 51069 | 20103 | 222 |
2225957 | 2225957 | 2022-02-17 | Frederick | Virginia | 51069 | 20053 | 221 |
2222706 | 2222706 | 2022-02-16 | Frederick | Virginia | 51069 | 20016 | 221 |
2219455 | 2219455 | 2022-02-15 | Frederick | Virginia | 51069 | 19974 | 217 |
2216205 | 2216205 | 2022-02-14 | Frederick | Virginia | 51069 | 19929 | 217 |
2212954 | 2212954 | 2022-02-13 | Frederick | Virginia | 51069 | 19845 | 213 |
2209701 | 2209701 | 2022-02-12 | Frederick | Virginia | 51069 | 19845 | 213 |
2206448 | 2206448 | 2022-02-11 | Frederick | Virginia | 51069 | 19845 | 213 |
2203195 | 2203195 | 2022-02-10 | Frederick | Virginia | 51069 | 19800 | 215 |
2199941 | 2199941 | 2022-02-09 | Frederick | Virginia | 51069 | 19750 | 215 |
2196687 | 2196687 | 2022-02-08 | Frederick | Virginia | 51069 | 19684 | 214 |
2193432 | 2193432 | 2022-02-07 | Frederick | Virginia | 51069 | 19647 | 211 |
2190179 | 2190179 | 2022-02-06 | Frederick | Virginia | 51069 | 19518 | 201 |
2186926 | 2186926 | 2022-02-05 | Frederick | Virginia | 51069 | 19518 | 201 |
2183673 | 2183673 | 2022-02-04 | Frederick | Virginia | 51069 | 19518 | 201 |
2180421 | 2180421 | 2022-02-03 | Frederick | Virginia | 51069 | 19438 | 200 |
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);