ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where fips = 50017 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
cases 447 ✖
- 9 35
- 8 27
- 822 22
- 20 17
- 25 15
- 10 14
- 5 13
- 3 10
- 4 9
- 22 9
- 14 8
- 7 7
- 15 7
- 815 7
- 825 7
- 6 6
- 11 6
- 16 6
- 24 6
- 814 5
- 831 5
- 1682 5
- 21 4
- 31 4
- 311 4
- 867 4
- 2051 4
- 2132 4
- 3177 4
- 4873 4
- 4889 4
- 1 3
- 18 3
- 27 3
- 28 3
- 33 3
- 38 3
- 40 3
- 298 3
- 514 3
- 530 3
- 537 3
- 817 3
- 821 3
- 837 3
- 846 3
- 855 3
- 2331 3
- 3087 3
- 3140 3
- 3253 3
- 4249 3
- 4339 3
- 4764 3
- 4809 3
- 4862 3
- 4879 3
- 4884 3
- 4900 3
- 4963 3
- 4986 3
- 17 2
- 32 2
- 34 2
- 188 2
- 300 2
- 312 2
- 324 2
- 444 2
- 467 2
- 476 2
- 529 2
- 531 2
- 545 2
- 546 2
- 687 2
- 713 2
- 756 2
- 779 2
- 805 2
- 809 2
- 819 2
- 824 2
- 838 2
- 850 2
- 881 2
- 2591 2
- 2678 2
- 3034 2
- 3269 2
- 4787 2
- 4883 2
- 2 1
- 19 1
- 23 1
- 26 1
- 30 1
- 43 1
- 44 1
- 49 1
- 52 1
- 56 1
- 62 1
- 73 1
- 83 1
- 89 1
- 91 1
- 106 1
- 122 1
- 129 1
- 136 1
- 159 1
- 165 1
- 172 1
- 174 1
- 178 1
- 204 1
- 205 1
- 206 1
- 211 1
- 214 1
- 223 1
- 232 1
- 237 1
- 248 1
- 250 1
- 258 1
- 259 1
- 260 1
- 269 1
- 270 1
- 271 1
- 277 1
- 278 1
- 281 1
- 287 1
- 289 1
- 290 1
- 294 1
- 295 1
- 310 1
- 319 1
- 323 1
- 330 1
- 342 1
- 352 1
- 357 1
- 361 1
- 366 1
- 368 1
- 369 1
- 376 1
- 377 1
- 380 1
- 385 1
- 391 1
- 392 1
- 395 1
- 396 1
- 397 1
- 401 1
- 403 1
- 406 1
- 408 1
- 409 1
- 410 1
- 412 1
- 419 1
- 424 1
- 428 1
- 429 1
- 432 1
- 437 1
- 438 1
- 445 1
- 447 1
- 448 1
- 462 1
- 465 1
- 478 1
- 481 1
- 482 1
- 488 1
- 492 1
- 494 1
- 496 1
- 499 1
- 503 1
- 504 1
- 508 1
- 510 1
- 512 1
- 516 1
- 518 1
- 519 1
- 520 1
- 522 1
- 527 1
- 535 1
- 536 1
- 538 1
- 540 1
- 542 1
- 547 1
- 550 1
- 564 1
- 566 1
- 567 1
- 571 1
- 572 1
- 575 1
- 578 1
- 593 1
- 602 1
- 611 1
- 630 1
- 637 1
- 641 1
- 648 1
- 659 1
- 668 1
- 669 1
- 682 1
- 694 1
- 701 1
- 702 1
- 707 1
- 718 1
- 722 1
- 734 1
- 744 1
- 752 1
- 757 1
- 761 1
- 767 1
- 775 1
- 782 1
- 784 1
- 789 1
- 793 1
- 800 1
- 801 1
- 808 1
- 810 1
- 812 1
- 818 1
- 820 1
- 823 1
- 832 1
- 835 1
- 841 1
- 844 1
- 848 1
- 856 1
- 862 1
- 864 1
- 865 1
- 866 1
- 872 1
- 873 1
- 875 1
- 887 1
- 889 1
- 891 1
- 892 1
- 895 1
- 902 1
- 906 1
- 909 1
- 910 1
- 918 1
- 924 1
- 931 1
- 938 1
- 944 1
- 948 1
- 951 1
- 955 1
- 961 1
- 965 1
- 968 1
- 969 1
- 979 1
- 981 1
- 983 1
- 986 1
- 993 1
- 998 1
- 1003 1
- 1014 1
- 1018 1
- 1020 1
- 1028 1
- 1029 1
- 1036 1
- 1042 1
- 1054 1
- 1057 1
- 1063 1
- 1068 1
- 1075 1
- 1080 1
- 1086 1
- 1091 1
- 1100 1
- 1103 1
- 1110 1
- 1125 1
- 1135 1
- 1146 1
- 1152 1
- 1160 1
- 1162 1
- 1169 1
- 1178 1
- 1185 1
- 1210 1
- 1219 1
- 1228 1
- 1233 1
- 1242 1
- 1255 1
- 1272 1
- 1281 1
- 1306 1
- 1312 1
- 1313 1
- 1318 1
- 1325 1
- 1347 1
- 1355 1
- 1374 1
- 1380 1
- 1384 1
- 1405 1
- 1434 1
- 1451 1
- 1460 1
- 1475 1
- 1493 1
- 1497 1
- 1508 1
- 1528 1
- 1543 1
- 1567 1
- 1584 1
- 1587 1
- 1595 1
- 1602 1
- 1618 1
- 1634 1
- 1651 1
- 1662 1
- 1669 1
- 1674 1
- 1727 1
- 1741 1
- 1754 1
- 1769 1
- 1788 1
- 1809 1
- 1830 1
- 1844 1
- 1855 1
- 1858 1
- 1877 1
- 1896 1
- 1902 1
- 1914 1
- 1926 1
- 1932 1
- 1941 1
- 1967 1
- 1978 1
- 1990 1
- 2011 1
- 2016 1
- 2023 1
- 2031 1
- 2078 1
- 2083 1
- 2097 1
- 2203 1
- 2214 1
- 2231 1
- 2271 1
- 2295 1
- 2321 1
- 2433 1
- 2506 1
- 2544 1
- 2557 1
- 2640 1
- 2727 1
- 2772 1
- 2833 1
- 2873 1
- 2920 1
- 2965 1
- 2989 1
- 3009 1
- 3023 1
- 3046 1
- 3053 1
- 3078 1
- 3107 1
- 3118 1
- 3129 1
- 3136 1
- 3146 1
- 3157 1
- 3163 1
- 3171 1
- 3197 1
- 3208 1
- 3240 1
- 4240 1
- 4277 1
- 4284 1
- 4306 1
- 4324 1
- 4370 1
- 4376 1
- 4388 1
- 4410 1
- 4420 1
- 4749 1
- 4762 1
- 4797 1
- 4807 1
- 4834 1
- 4838 1
- 4847 1
- 4849 1
- 4866 1
- 4868 1
- 4869 1
- 4870 1
- 4872 1
- 4882 1
- 4888 1
- 4894 1
- 4896 1
- 4930 1
- 4935 1
- 4941 1
- 4949 1
state 1
- Vermont 789
fips 1
- 50017 · 789 ✖
county 1
- Orange 789
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502500 | 2502500 | 2022-05-13 | Orange | Vermont | 50017 | 4420 | 14 |
2499242 | 2499242 | 2022-05-12 | Orange | Vermont | 50017 | 4410 | 14 |
2495984 | 2495984 | 2022-05-11 | Orange | Vermont | 50017 | 4388 | 14 |
2492726 | 2492726 | 2022-05-10 | Orange | Vermont | 50017 | 4376 | 14 |
2489468 | 2489468 | 2022-05-09 | Orange | Vermont | 50017 | 4370 | 13 |
2486210 | 2486210 | 2022-05-08 | Orange | Vermont | 50017 | 4339 | 13 |
2482952 | 2482952 | 2022-05-07 | Orange | Vermont | 50017 | 4339 | 13 |
2479694 | 2479694 | 2022-05-06 | Orange | Vermont | 50017 | 4339 | 13 |
2476436 | 2476436 | 2022-05-05 | Orange | Vermont | 50017 | 4324 | 13 |
2473179 | 2473179 | 2022-05-04 | Orange | Vermont | 50017 | 4306 | 13 |
2469923 | 2469923 | 2022-05-03 | Orange | Vermont | 50017 | 4284 | 13 |
2466667 | 2466667 | 2022-05-02 | Orange | Vermont | 50017 | 4277 | 13 |
2463412 | 2463412 | 2022-05-01 | Orange | Vermont | 50017 | 4249 | 13 |
2460156 | 2460156 | 2022-04-30 | Orange | Vermont | 50017 | 4249 | 13 |
2456900 | 2456900 | 2022-04-29 | Orange | Vermont | 50017 | 4249 | 13 |
2453644 | 2453644 | 2022-04-28 | Orange | Vermont | 50017 | 4240 | 13 |
2450388 | 2450388 | 2022-04-27 | Orange | Vermont | 50017 | 4986 | 14 |
2447131 | 2447131 | 2022-04-26 | Orange | Vermont | 50017 | 4986 | 14 |
2443876 | 2443876 | 2022-04-25 | Orange | Vermont | 50017 | 4986 | 14 |
2440620 | 2440620 | 2022-04-24 | Orange | Vermont | 50017 | 4963 | 14 |
2437364 | 2437364 | 2022-04-23 | Orange | Vermont | 50017 | 4963 | 14 |
2434108 | 2434108 | 2022-04-22 | Orange | Vermont | 50017 | 4963 | 14 |
2430852 | 2430852 | 2022-04-21 | Orange | Vermont | 50017 | 4949 | 14 |
2427596 | 2427596 | 2022-04-20 | Orange | Vermont | 50017 | 4941 | 14 |
2424340 | 2424340 | 2022-04-19 | Orange | Vermont | 50017 | 4935 | 14 |
2421084 | 2421084 | 2022-04-18 | Orange | Vermont | 50017 | 4930 | 14 |
2417828 | 2417828 | 2022-04-17 | Orange | Vermont | 50017 | 4900 | 14 |
2414572 | 2414572 | 2022-04-16 | Orange | Vermont | 50017 | 4900 | 14 |
2411316 | 2411316 | 2022-04-15 | Orange | Vermont | 50017 | 4900 | 14 |
2408060 | 2408060 | 2022-04-14 | Orange | Vermont | 50017 | 4896 | 14 |
2404804 | 2404804 | 2022-04-13 | Orange | Vermont | 50017 | 4889 | 14 |
2401549 | 2401549 | 2022-04-12 | Orange | Vermont | 50017 | 4884 | 14 |
2398294 | 2398294 | 2022-04-11 | Orange | Vermont | 50017 | 4884 | 14 |
2395039 | 2395039 | 2022-04-10 | Orange | Vermont | 50017 | 4879 | 14 |
2391783 | 2391783 | 2022-04-09 | Orange | Vermont | 50017 | 4879 | 14 |
2388527 | 2388527 | 2022-04-08 | Orange | Vermont | 50017 | 4879 | 14 |
2385272 | 2385272 | 2022-04-07 | Orange | Vermont | 50017 | 4872 | 14 |
2382017 | 2382017 | 2022-04-06 | Orange | Vermont | 50017 | 4870 | 14 |
2378762 | 2378762 | 2022-04-05 | Orange | Vermont | 50017 | 4868 | 14 |
2375508 | 2375508 | 2022-04-04 | Orange | Vermont | 50017 | 4866 | 14 |
2372256 | 2372256 | 2022-04-03 | Orange | Vermont | 50017 | 4873 | 14 |
2369003 | 2369003 | 2022-04-02 | Orange | Vermont | 50017 | 4873 | 14 |
2365750 | 2365750 | 2022-04-01 | Orange | Vermont | 50017 | 4873 | 14 |
2362497 | 2362497 | 2022-03-31 | Orange | Vermont | 50017 | 4884 | 14 |
2359243 | 2359243 | 2022-03-30 | Orange | Vermont | 50017 | 4882 | 14 |
2355989 | 2355989 | 2022-03-29 | Orange | Vermont | 50017 | 4888 | 14 |
2352736 | 2352736 | 2022-03-28 | Orange | Vermont | 50017 | 4894 | 14 |
2349484 | 2349484 | 2022-03-27 | Orange | Vermont | 50017 | 4889 | 14 |
2346231 | 2346231 | 2022-03-26 | Orange | Vermont | 50017 | 4889 | 14 |
2342978 | 2342978 | 2022-03-25 | Orange | Vermont | 50017 | 4889 | 14 |
2339725 | 2339725 | 2022-03-24 | Orange | Vermont | 50017 | 4883 | 14 |
2336471 | 2336471 | 2022-03-23 | Orange | Vermont | 50017 | 4883 | 14 |
2333217 | 2333217 | 2022-03-22 | Orange | Vermont | 50017 | 4873 | 14 |
2329964 | 2329964 | 2022-03-21 | Orange | Vermont | 50017 | 4869 | 14 |
2326712 | 2326712 | 2022-03-20 | Orange | Vermont | 50017 | 4862 | 14 |
2323459 | 2323459 | 2022-03-19 | Orange | Vermont | 50017 | 4862 | 14 |
2320205 | 2320205 | 2022-03-18 | Orange | Vermont | 50017 | 4862 | 14 |
2316951 | 2316951 | 2022-03-17 | Orange | Vermont | 50017 | 4849 | 14 |
2313698 | 2313698 | 2022-03-16 | Orange | Vermont | 50017 | 4847 | 14 |
2310445 | 2310445 | 2022-03-15 | Orange | Vermont | 50017 | 4838 | 14 |
2307192 | 2307192 | 2022-03-14 | Orange | Vermont | 50017 | 4834 | 14 |
2303941 | 2303941 | 2022-03-13 | Orange | Vermont | 50017 | 4809 | 14 |
2300689 | 2300689 | 2022-03-12 | Orange | Vermont | 50017 | 4809 | 14 |
2297437 | 2297437 | 2022-03-11 | Orange | Vermont | 50017 | 4809 | 14 |
2294185 | 2294185 | 2022-03-10 | Orange | Vermont | 50017 | 4807 | 14 |
2290933 | 2290933 | 2022-03-09 | Orange | Vermont | 50017 | 4797 | 14 |
2287681 | 2287681 | 2022-03-08 | Orange | Vermont | 50017 | 4787 | 14 |
2284429 | 2284429 | 2022-03-07 | Orange | Vermont | 50017 | 4787 | 14 |
2281177 | 2281177 | 2022-03-06 | Orange | Vermont | 50017 | 4764 | 14 |
2277924 | 2277924 | 2022-03-05 | Orange | Vermont | 50017 | 4764 | 14 |
2274671 | 2274671 | 2022-03-04 | Orange | Vermont | 50017 | 4764 | 14 |
2271418 | 2271418 | 2022-03-03 | Orange | Vermont | 50017 | 4762 | 14 |
2268166 | 2268166 | 2022-03-02 | Orange | Vermont | 50017 | 4749 | 14 |
2264913 | 2264913 | 2022-03-01 | Orange | Vermont | 50017 | 3269 | 11 |
2261663 | 2261663 | 2022-02-28 | Orange | Vermont | 50017 | 3269 | 11 |
2258412 | 2258412 | 2022-02-27 | Orange | Vermont | 50017 | 3253 | 11 |
2255161 | 2255161 | 2022-02-26 | Orange | Vermont | 50017 | 3253 | 11 |
2251910 | 2251910 | 2022-02-25 | Orange | Vermont | 50017 | 3253 | 11 |
2248659 | 2248659 | 2022-02-24 | Orange | Vermont | 50017 | 3240 | 11 |
2245408 | 2245408 | 2022-02-23 | Orange | Vermont | 50017 | 3208 | 11 |
2242157 | 2242157 | 2022-02-22 | Orange | Vermont | 50017 | 3197 | 11 |
2238906 | 2238906 | 2022-02-21 | Orange | Vermont | 50017 | 3177 | 11 |
2235655 | 2235655 | 2022-02-20 | Orange | Vermont | 50017 | 3177 | 11 |
2232404 | 2232404 | 2022-02-19 | Orange | Vermont | 50017 | 3177 | 11 |
2229153 | 2229153 | 2022-02-18 | Orange | Vermont | 50017 | 3177 | 11 |
2225902 | 2225902 | 2022-02-17 | Orange | Vermont | 50017 | 3171 | 11 |
2222651 | 2222651 | 2022-02-16 | Orange | Vermont | 50017 | 3163 | 11 |
2219400 | 2219400 | 2022-02-15 | Orange | Vermont | 50017 | 3157 | 11 |
2216149 | 2216149 | 2022-02-14 | Orange | Vermont | 50017 | 3146 | 11 |
2212898 | 2212898 | 2022-02-13 | Orange | Vermont | 50017 | 3140 | 11 |
2209645 | 2209645 | 2022-02-12 | Orange | Vermont | 50017 | 3140 | 11 |
2206392 | 2206392 | 2022-02-11 | Orange | Vermont | 50017 | 3140 | 11 |
2203139 | 2203139 | 2022-02-10 | Orange | Vermont | 50017 | 3136 | 11 |
2199885 | 2199885 | 2022-02-09 | Orange | Vermont | 50017 | 3129 | 11 |
2196631 | 2196631 | 2022-02-08 | Orange | Vermont | 50017 | 3118 | 11 |
2193377 | 2193377 | 2022-02-07 | Orange | Vermont | 50017 | 3107 | 11 |
2190124 | 2190124 | 2022-02-06 | Orange | Vermont | 50017 | 3087 | 11 |
2186871 | 2186871 | 2022-02-05 | Orange | Vermont | 50017 | 3087 | 11 |
2183618 | 2183618 | 2022-02-04 | Orange | Vermont | 50017 | 3087 | 11 |
2180366 | 2180366 | 2022-02-03 | Orange | Vermont | 50017 | 3078 | 11 |
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);