ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 36041 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 317 ✖
- 6 40
- 5 39
- 313 34
- 316 30
- 3 27
- 15 24
- 14 22
- 2 20
- 16 15
- 7 13
- 8 10
- 294 10
- 301 9
- 303 9
- 19 8
- 290 7
- 318 7
- 12 5
- 285 5
- 307 5
- 315 5
- 439 5
- 870 5
- 871 5
- 874 5
- 11 4
- 20 4
- 60 4
- 68 4
- 286 4
- 292 4
- 304 4
- 305 4
- 335 4
- 358 4
- 407 4
- 414 4
- 584 4
- 834 4
- 885 4
- 904 4
- 13 3
- 26 3
- 276 3
- 288 3
- 291 3
- 296 3
- 332 3
- 354 3
- 396 3
- 408 3
- 409 3
- 434 3
- 510 3
- 787 3
- 842 3
- 846 3
- 890 3
- 919 3
- 1 2
- 17 2
- 18 2
- 35 2
- 42 2
- 56 2
- 97 2
- 98 2
- 99 2
- 143 2
- 145 2
- 146 2
- 161 2
- 166 2
- 214 2
- 251 2
- 261 2
- 269 2
- 275 2
- 277 2
- 284 2
- 293 2
- 302 2
- 327 2
- 364 2
- 370 2
- 415 2
- 424 2
- 426 2
- 430 2
- 438 2
- 486 2
- 506 2
- 525 2
- 527 2
- 565 2
- 803 2
- 819 2
- 823 2
- 827 2
- 829 2
- 833 2
- 852 2
- 856 2
- 873 2
- 909 2
- 910 2
- 22 1
- 25 1
- 31 1
- 36 1
- 37 1
- 39 1
- 40 1
- 41 1
- 44 1
- 45 1
- 46 1
- 47 1
- 49 1
- 63 1
- 65 1
- 70 1
- 73 1
- 75 1
- 77 1
- 81 1
- 82 1
- 85 1
- 87 1
- 90 1
- 100 1
- 102 1
- 112 1
- 115 1
- 119 1
- 120 1
- 121 1
- 122 1
- 124 1
- 128 1
- 129 1
- 132 1
- 133 1
- 140 1
- 141 1
- 147 1
- 150 1
- 171 1
- 172 1
- 194 1
- 195 1
- 216 1
- 220 1
- 221 1
- 237 1
- 246 1
- 250 1
- 254 1
- 264 1
- 270 1
- 271 1
- 273 1
- 279 1
- 281 1
- 282 1
- 287 1
- 298 1
- 300 1
- 310 1
- 312 1
- 319 1
- 320 1
- 325 1
- 328 1
- 331 1
- 338 1
- 341 1
- 343 1
- 346 1
- 350 1
- 351 1
- 355 1
- 361 1
- 368 1
- 382 1
- 384 1
- 391 1
- 395 1
- 398 1
- 401 1
- 403 1
- 404 1
- 412 1
- 418 1
- 422 1
- 425 1
- 427 1
- 429 1
- 435 1
- 436 1
- 442 1
- 444 1
- 457 1
- 458 1
- 459 1
- 460 1
- 463 1
- 465 1
- 467 1
- 468 1
- 469 1
- 470 1
- 472 1
- 474 1
- 479 1
- 481 1
- 487 1
- 490 1
- 493 1
- 497 1
- 500 1
- 504 1
- 507 1
- 508 1
- 511 1
- 512 1
- 513 1
- 516 1
- 519 1
- 531 1
- 533 1
- 539 1
- 543 1
- 551 1
- 557 1
- 558 1
- 561 1
- 563 1
- 573 1
- 575 1
- 576 1
- 577 1
- 578 1
- 583 1
- 591 1
- 597 1
- 605 1
- 616 1
- 630 1
- 635 1
- 638 1
- 652 1
- 664 1
- 680 1
- 692 1
- 704 1
- 708 1
- 711 1
- 719 1
- 724 1
- 729 1
- 732 1
- 734 1
- 738 1
- 744 1
- 746 1
- 752 1
- 757 1
- 766 1
- 769 1
- 770 1
- 774 1
- 776 1
- 777 1
- 779 1
- 781 1
- 785 1
- 791 1
- 797 1
- 800 1
- 804 1
- 806 1
- 807 1
- 810 1
- 812 1
- 818 1
- 820 1
- 822 1
- 825 1
- 826 1
- 828 1
- 830 1
- 836 1
- 837 1
- 838 1
- 844 1
- 849 1
- 850 1
- 854 1
- 862 1
- 865 1
- 868 1
- 872 1
- 875 1
- 879 1
- 881 1
- 886 1
- 888 1
- 889 1
- 891 1
- 895 1
- 901 1
- 905 1
- 908 1
- 914 1
- 915 1
- 916 1
state 1
- New York 787
fips 1
- 36041 · 787 ✖
county 1
- Hamilton 787
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501447 | 2501447 | 2022-05-13 | Hamilton | New York | 36041 | 919 | 5 |
2498189 | 2498189 | 2022-05-12 | Hamilton | New York | 36041 | 919 | 5 |
2494931 | 2494931 | 2022-05-11 | Hamilton | New York | 36041 | 919 | 5 |
2491673 | 2491673 | 2022-05-10 | Hamilton | New York | 36041 | 916 | 5 |
2488415 | 2488415 | 2022-05-09 | Hamilton | New York | 36041 | 915 | 5 |
2485158 | 2485158 | 2022-05-08 | Hamilton | New York | 36041 | 914 | 5 |
2481900 | 2481900 | 2022-05-07 | Hamilton | New York | 36041 | 910 | 5 |
2478642 | 2478642 | 2022-05-06 | Hamilton | New York | 36041 | 910 | 5 |
2475384 | 2475384 | 2022-05-05 | Hamilton | New York | 36041 | 909 | 5 |
2472127 | 2472127 | 2022-05-04 | Hamilton | New York | 36041 | 909 | 5 |
2468871 | 2468871 | 2022-05-03 | Hamilton | New York | 36041 | 908 | 5 |
2465615 | 2465615 | 2022-05-02 | Hamilton | New York | 36041 | 905 | 5 |
2462360 | 2462360 | 2022-05-01 | Hamilton | New York | 36041 | 904 | 5 |
2459104 | 2459104 | 2022-04-30 | Hamilton | New York | 36041 | 904 | 5 |
2455848 | 2455848 | 2022-04-29 | Hamilton | New York | 36041 | 904 | 5 |
2452592 | 2452592 | 2022-04-28 | Hamilton | New York | 36041 | 904 | 5 |
2449336 | 2449336 | 2022-04-27 | Hamilton | New York | 36041 | 901 | 5 |
2446079 | 2446079 | 2022-04-26 | Hamilton | New York | 36041 | 895 | 5 |
2442824 | 2442824 | 2022-04-25 | Hamilton | New York | 36041 | 891 | 5 |
2439568 | 2439568 | 2022-04-24 | Hamilton | New York | 36041 | 890 | 5 |
2436312 | 2436312 | 2022-04-23 | Hamilton | New York | 36041 | 890 | 5 |
2433056 | 2433056 | 2022-04-22 | Hamilton | New York | 36041 | 890 | 5 |
2429800 | 2429800 | 2022-04-21 | Hamilton | New York | 36041 | 889 | 5 |
2426544 | 2426544 | 2022-04-20 | Hamilton | New York | 36041 | 888 | 5 |
2423288 | 2423288 | 2022-04-19 | Hamilton | New York | 36041 | 886 | 5 |
2420031 | 2420031 | 2022-04-18 | Hamilton | New York | 36041 | 885 | 5 |
2416776 | 2416776 | 2022-04-17 | Hamilton | New York | 36041 | 885 | 5 |
2413520 | 2413520 | 2022-04-16 | Hamilton | New York | 36041 | 885 | 5 |
2410264 | 2410264 | 2022-04-15 | Hamilton | New York | 36041 | 885 | 5 |
2407008 | 2407008 | 2022-04-14 | Hamilton | New York | 36041 | 881 | 5 |
2403752 | 2403752 | 2022-04-13 | Hamilton | New York | 36041 | 879 | 5 |
2400497 | 2400497 | 2022-04-12 | Hamilton | New York | 36041 | 875 | 5 |
2397242 | 2397242 | 2022-04-11 | Hamilton | New York | 36041 | 874 | 5 |
2393987 | 2393987 | 2022-04-10 | Hamilton | New York | 36041 | 874 | 5 |
2390731 | 2390731 | 2022-04-09 | Hamilton | New York | 36041 | 874 | 5 |
2387475 | 2387475 | 2022-04-08 | Hamilton | New York | 36041 | 874 | 5 |
2384220 | 2384220 | 2022-04-07 | Hamilton | New York | 36041 | 874 | 5 |
2380965 | 2380965 | 2022-04-06 | Hamilton | New York | 36041 | 873 | 5 |
2377710 | 2377710 | 2022-04-05 | Hamilton | New York | 36041 | 873 | 5 |
2374457 | 2374457 | 2022-04-04 | Hamilton | New York | 36041 | 872 | 5 |
2371205 | 2371205 | 2022-04-03 | Hamilton | New York | 36041 | 871 | 5 |
2367952 | 2367952 | 2022-04-02 | Hamilton | New York | 36041 | 871 | 5 |
2364699 | 2364699 | 2022-04-01 | Hamilton | New York | 36041 | 871 | 5 |
2361445 | 2361445 | 2022-03-31 | Hamilton | New York | 36041 | 871 | 5 |
2358191 | 2358191 | 2022-03-30 | Hamilton | New York | 36041 | 871 | 5 |
2354937 | 2354937 | 2022-03-29 | Hamilton | New York | 36041 | 870 | 5 |
2351684 | 2351684 | 2022-03-28 | Hamilton | New York | 36041 | 870 | 5 |
2348432 | 2348432 | 2022-03-27 | Hamilton | New York | 36041 | 870 | 5 |
2345179 | 2345179 | 2022-03-26 | Hamilton | New York | 36041 | 870 | 5 |
2341926 | 2341926 | 2022-03-25 | Hamilton | New York | 36041 | 870 | 5 |
2338673 | 2338673 | 2022-03-24 | Hamilton | New York | 36041 | 868 | 5 |
2335419 | 2335419 | 2022-03-23 | Hamilton | New York | 36041 | 865 | 5 |
2332165 | 2332165 | 2022-03-22 | Hamilton | New York | 36041 | 862 | 5 |
2328912 | 2328912 | 2022-03-21 | Hamilton | New York | 36041 | 856 | 5 |
2325660 | 2325660 | 2022-03-20 | Hamilton | New York | 36041 | 856 | 5 |
2322407 | 2322407 | 2022-03-19 | Hamilton | New York | 36041 | 854 | 5 |
2319153 | 2319153 | 2022-03-18 | Hamilton | New York | 36041 | 852 | 5 |
2315899 | 2315899 | 2022-03-17 | Hamilton | New York | 36041 | 852 | 5 |
2312646 | 2312646 | 2022-03-16 | Hamilton | New York | 36041 | 850 | 5 |
2309393 | 2309393 | 2022-03-15 | Hamilton | New York | 36041 | 849 | 5 |
2306140 | 2306140 | 2022-03-14 | Hamilton | New York | 36041 | 846 | 5 |
2302889 | 2302889 | 2022-03-13 | Hamilton | New York | 36041 | 846 | 5 |
2299637 | 2299637 | 2022-03-12 | Hamilton | New York | 36041 | 846 | 5 |
2296385 | 2296385 | 2022-03-11 | Hamilton | New York | 36041 | 844 | 5 |
2293133 | 2293133 | 2022-03-10 | Hamilton | New York | 36041 | 842 | 5 |
2289881 | 2289881 | 2022-03-09 | Hamilton | New York | 36041 | 842 | 5 |
2286629 | 2286629 | 2022-03-08 | Hamilton | New York | 36041 | 842 | 5 |
2283377 | 2283377 | 2022-03-07 | Hamilton | New York | 36041 | 838 | 5 |
2280125 | 2280125 | 2022-03-06 | Hamilton | New York | 36041 | 837 | 5 |
2276872 | 2276872 | 2022-03-05 | Hamilton | New York | 36041 | 836 | 5 |
2273619 | 2273619 | 2022-03-04 | Hamilton | New York | 36041 | 834 | 5 |
2270366 | 2270366 | 2022-03-03 | Hamilton | New York | 36041 | 834 | 5 |
2267114 | 2267114 | 2022-03-02 | Hamilton | New York | 36041 | 834 | 5 |
2263862 | 2263862 | 2022-03-01 | Hamilton | New York | 36041 | 834 | 5 |
2260611 | 2260611 | 2022-02-28 | Hamilton | New York | 36041 | 833 | 5 |
2257360 | 2257360 | 2022-02-27 | Hamilton | New York | 36041 | 833 | 5 |
2254109 | 2254109 | 2022-02-26 | Hamilton | New York | 36041 | 830 | 5 |
2250858 | 2250858 | 2022-02-25 | Hamilton | New York | 36041 | 829 | 5 |
2247607 | 2247607 | 2022-02-24 | Hamilton | New York | 36041 | 829 | 5 |
2244356 | 2244356 | 2022-02-23 | Hamilton | New York | 36041 | 828 | 5 |
2241105 | 2241105 | 2022-02-22 | Hamilton | New York | 36041 | 827 | 5 |
2237854 | 2237854 | 2022-02-21 | Hamilton | New York | 36041 | 827 | 5 |
2234603 | 2234603 | 2022-02-20 | Hamilton | New York | 36041 | 826 | 5 |
2231352 | 2231352 | 2022-02-19 | Hamilton | New York | 36041 | 825 | 5 |
2228101 | 2228101 | 2022-02-18 | Hamilton | New York | 36041 | 823 | 5 |
2224850 | 2224850 | 2022-02-17 | Hamilton | New York | 36041 | 823 | 5 |
2221599 | 2221599 | 2022-02-16 | Hamilton | New York | 36041 | 822 | 5 |
2218348 | 2218348 | 2022-02-15 | Hamilton | New York | 36041 | 820 | 5 |
2215097 | 2215097 | 2022-02-14 | Hamilton | New York | 36041 | 819 | 5 |
2211846 | 2211846 | 2022-02-13 | Hamilton | New York | 36041 | 819 | 5 |
2208593 | 2208593 | 2022-02-12 | Hamilton | New York | 36041 | 818 | 5 |
2205340 | 2205340 | 2022-02-11 | Hamilton | New York | 36041 | 812 | 5 |
2202087 | 2202087 | 2022-02-10 | Hamilton | New York | 36041 | 810 | 5 |
2198833 | 2198833 | 2022-02-09 | Hamilton | New York | 36041 | 807 | 5 |
2195579 | 2195579 | 2022-02-08 | Hamilton | New York | 36041 | 806 | 5 |
2192325 | 2192325 | 2022-02-07 | Hamilton | New York | 36041 | 804 | 5 |
2189071 | 2189071 | 2022-02-06 | Hamilton | New York | 36041 | 803 | 5 |
2185818 | 2185818 | 2022-02-05 | Hamilton | New York | 36041 | 803 | 5 |
2182566 | 2182566 | 2022-02-04 | Hamilton | New York | 36041 | 800 | 5 |
2179314 | 2179314 | 2022-02-03 | Hamilton | New York | 36041 | 797 | 5 |
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);