ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 18059 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 642 ✖
- 20665 7
- 12672 5
- 14297 5
- 20778 5
- 8636 4
- 10024 4
- 15058 4
- 371 3
- 8614 3
- 8663 3
- 8690 3
- 8732 3
- 8824 3
- 8962 3
- 9123 3
- 9377 3
- 9660 3
- 10344 3
- 10662 3
- 10961 3
- 11233 3
- 11466 3
- 11624 3
- 11755 3
- 11864 3
- 11981 3
- 12212 3
- 12455 3
- 13142 3
- 13584 3
- 14015 3
- 16204 3
- 17688 3
- 18888 3
- 19786 3
- 20258 3
- 20422 3
- 20493 3
- 20561 3
- 20599 3
- 20620 3
- 20636 3
- 20639 3
- 20643 3
- 20647 3
- 20651 3
- 20653 3
- 20698 3
- 20741 3
- 118 2
- 152 2
- 266 2
- 272 2
- 331 2
- 386 2
- 397 2
- 402 2
- 861 2
- 873 2
- 1158 2
- 7433 2
- 7671 2
- 8470 2
- 8479 2
- 8540 2
- 8565 2
- 8600 2
- 8602 2
- 8713 2
- 20333 2
- 20592 2
- 20619 2
- 20622 2
- 20683 2
- 20690 2
- 20706 2
- 20717 2
- 20759 2
- 20831 2
- 20849 2
- 1 1
- 2 1
- 3 1
- 4 1
- 8 1
- 9 1
- 14 1
- 19 1
- 22 1
- 26 1
- 28 1
- 33 1
- 37 1
- 41 1
- 57 1
- 61 1
- 72 1
- 89 1
- 99 1
- 100 1
- 109 1
- 112 1
- 122 1
- 128 1
- 130 1
- 133 1
- 136 1
- 144 1
- 150 1
- 161 1
- 172 1
- 178 1
- 179 1
- 185 1
- 206 1
- 215 1
- 220 1
- 229 1
- 231 1
- 232 1
- 233 1
- 235 1
- 239 1
- 243 1
- 248 1
- 279 1
- 281 1
- 285 1
- 290 1
- 294 1
- 295 1
- 304 1
- 306 1
- 313 1
- 316 1
- 319 1
- 321 1
- 323 1
- 325 1
- 327 1
- 335 1
- 342 1
- 344 1
- 349 1
- 353 1
- 355 1
- 358 1
- 364 1
- 366 1
- 370 1
- 375 1
- 378 1
- 383 1
- 385 1
- 389 1
- 390 1
- 392 1
- 395 1
- 399 1
- 409 1
- 413 1
- 418 1
- 423 1
- 431 1
- 434 1
- 442 1
- 445 1
- 453 1
- 454 1
- 455 1
- 457 1
- 462 1
- 465 1
- 472 1
- 473 1
- 477 1
- 479 1
- 481 1
- 485 1
- 489 1
- 503 1
- 511 1
- 516 1
- 524 1
- 533 1
- 535 1
- 551 1
- 574 1
- 576 1
- 585 1
- 586 1
- 593 1
- 597 1
- 603 1
- 614 1
- 622 1
- 629 1
- 634 1
- 640 1
- 644 1
- 648 1
- 655 1
- 668 1
- 678 1
- 692 1
- 697 1
- 703 1
- 711 1
- 720 1
- 728 1
- 730 1
- 734 1
- 741 1
- 747 1
- 750 1
- 761 1
- 763 1
- 790 1
- 793 1
- 799 1
- 806 1
- 817 1
- 826 1
- 832 1
- 835 1
- 837 1
- 839 1
- 843 1
- 851 1
- 855 1
- 864 1
- 865 1
- 871 1
- 892 1
- 895 1
- 896 1
- 903 1
- 907 1
- 913 1
- 915 1
- 920 1
- 922 1
- 926 1
- 929 1
- 932 1
- 936 1
- 945 1
- 947 1
- 961 1
- 963 1
- 966 1
- 971 1
- 974 1
- 980 1
- 985 1
- 990 1
- 996 1
- 1004 1
- 1022 1
- 1026 1
- 1048 1
- 1065 1
- 1069 1
- 1081 1
- 1091 1
- 1107 1
- 1115 1
- 1129 1
- 1145 1
- 1173 1
- 1199 1
- 1216 1
- 1240 1
- 1248 1
- 1264 1
- 1267 1
- 1288 1
- 1319 1
- 1341 1
- 1370 1
- 1385 1
- 1404 1
- 1426 1
- 1466 1
- 1513 1
- 1566 1
- 1603 1
- 1629 1
- 1657 1
- 1708 1
- 1764 1
- 1821 1
- 1884 1
- 1949 1
- 2030 1
- 2045 1
- 2119 1
- 2187 1
- 2236 1
- 2287 1
- 2366 1
- 2406 1
- 2454 1
- 2482 1
- 2557 1
- 2622 1
- 2747 1
- 2811 1
- 2887 1
- 2961 1
- 2994 1
- 3095 1
- 3224 1
- 3322 1
- 3414 1
- 3524 1
- 3540 1
- 3588 1
- 3683 1
- 3762 1
- 3855 1
- 3982 1
- 4071 1
- 4136 1
- 4199 1
- 4276 1
- 4353 1
- 4429 1
- 4501 1
- 4586 1
- 4597 1
- 4644 1
- 4713 1
- 4765 1
- 4848 1
- 4877 1
- 4883 1
- 4931 1
- 5006 1
- 5071 1
- 5166 1
- 5268 1
- 5338 1
- 5407 1
- 5484 1
- 5536 1
- 5651 1
- 5799 1
- 5881 1
- 5952 1
- 6023 1
- 6084 1
- 6126 1
- 6172 1
- 6241 1
- 6318 1
- 6354 1
- 6409 1
- 6447 1
- 6491 1
- 6557 1
- 6597 1
- 6661 1
- 6719 1
- 6763 1
- 6804 1
- 6805 1
- 6854 1
- 6883 1
- 6912 1
- 6937 1
- 6991 1
- 7018 1
- 7044 1
- 7070 1
- 7107 1
- 7127 1
- 7179 1
- 7209 1
- 7220 1
- 7244 1
- 7260 1
- 7283 1
- 7303 1
- 7314 1
- 7332 1
- 7341 1
- 7344 1
- 7359 1
- 7366 1
- 7372 1
- 7375 1
- 7377 1
- 7386 1
- 7388 1
- 7403 1
- 7416 1
- 7418 1
- 7423 1
- 7428 1
- 7442 1
- 7452 1
- 7463 1
- 7486 1
- 7495 1
- 7500 1
- 7504 1
- 7511 1
- 7526 1
- 7541 1
- 7549 1
- 7559 1
- 7563 1
- 7564 1
- 7576 1
- 7582 1
- 7598 1
- 7616 1
- 7629 1
- 7638 1
- 7644 1
- 7645 1
- 7657 1
- 7684 1
- 7699 1
- 7709 1
- 7714 1
- 7729 1
- 7747 1
- 7761 1
- 7779 1
- 7793 1
- 7797 1
- 7809 1
- 7829 1
- 7843 1
- 7867 1
- 7891 1
- 7903 1
- 7921 1
- 7947 1
- 7964 1
- 7979 1
- 7989 1
- 8004 1
- 8015 1
- 8025 1
- 8039 1
- 8056 1
- 8063 1
- 8079 1
- 8095 1
- 8106 1
- 8113 1
- 8134 1
- 8157 1
- 8187 1
- 8197 1
- 8214 1
- 8226 1
- 8229 1
- 8250 1
- 8263 1
- 8275 1
- 8284 1
- 8299 1
- 8303 1
- 8308 1
- 8325 1
- 8334 1
- 8349 1
- 8370 1
- 8391 1
- 8397 1
- 8400 1
- 8408 1
- 8415 1
- 8424 1
- 8431 1
- 8437 1
- 8441 1
- 8450 1
- 8457 1
- 8474 1
- 8487 1
- 8488 1
- 8532 1
- 8535 1
- 8550 1
- 8556 1
- 8558 1
- 8562 1
- 8564 1
- 8573 1
- 8580 1
- 8584 1
- 8586 1
- 8587 1
- 8601 1
- 8610 1
- 8623 1
- 8627 1
- 8630 1
- 8632 1
- 8649 1
- 8651 1
- 8653 1
- 8670 1
- 8671 1
- 8679 1
- 8683 1
- 8716 1
- 8724 1
- 8759 1
- 8765 1
- 8786 1
- 8803 1
- 8870 1
- 8880 1
- 8921 1
- 8939 1
- 9009 1
- 9033 1
- 9069 1
- 9082 1
- 9197 1
- 9237 1
- 9294 1
- 9320 1
- 9490 1
- 9515 1
- 9573 1
- 9624 1
- 9809 1
- 9844 1
- 9904 1
- 9960 1
- 10183 1
- 10203 1
- 10273 1
- 10465 1
- 10507 1
- 10559 1
- 10631 1
- 10775 1
- 10811 1
- 10867 1
- 10912 1
- 11048 1
- 11071 1
- 11111 1
- 11166 1
- 11343 1
- 11374 1
- 11410 1
- 11429 1
- 11539 1
- 11559 1
- 11570 1
- 11589 1
- 11657 1
- 11666 1
- 11709 1
- 11736 1
- 11800 1
- 11815 1
- 11830 1
- 11843 1
- 11905 1
- 11906 1
- 11932 1
- 11961 1
- 12030 1
- 12058 1
- 12110 1
- 12174 1
- 12315 1
- 12316 1
- 12370 1
- 12396 1
- 12588 1
- 12616 1
- 12870 1
- 12928 1
- 13013 1
- 13090 1
- 13288 1
- 13317 1
- 13400 1
- 13507 1
- 13751 1
- 13787 1
- 13840 1
- 13948 1
- 14177 1
- 14222 1
- 14590 1
- 14699 1
- 14867 1
- 15502 1
- 15609 1
- 15736 1
- 16025 1
- 16811 1
- 16874 1
- 17122 1
- 17424 1
- 18320 1
- 18518 1
- 18525 1
- 18717 1
- 19345 1
- 19354 1
- 19400 1
- 19553 1
- 20040 1
- 20071 1
- 20152 1
- 20204 1
- 20335 1
- 20402 1
- 20460 1
- 20471 1
- 20473 1
- 20486 1
- 20536 1
- 20544 1
- 20558 1
- 20559 1
- 20584 1
- 20588 1
- 20615 1
- 20618 1
- 20625 1
- 20626 1
- 20631 1
- 20633 1
- 20642 1
- 20649 1
- 20657 1
- 20660 1
- 20888 1
state 1
- Indiana 784
fips 1
- 18059 · 784 ✖
county 1
- Hancock 784
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500309 | 2500309 | 2022-05-13 | Hancock | Indiana | 18059 | 20888 | 258 |
2497051 | 2497051 | 2022-05-12 | Hancock | Indiana | 18059 | 20849 | 258 |
2493793 | 2493793 | 2022-05-11 | Hancock | Indiana | 18059 | 20849 | 258 |
2490535 | 2490535 | 2022-05-10 | Hancock | Indiana | 18059 | 20831 | 258 |
2487278 | 2487278 | 2022-05-09 | Hancock | Indiana | 18059 | 20831 | 258 |
2484020 | 2484020 | 2022-05-08 | Hancock | Indiana | 18059 | 20778 | 258 |
2480762 | 2480762 | 2022-05-07 | Hancock | Indiana | 18059 | 20778 | 258 |
2477504 | 2477504 | 2022-05-06 | Hancock | Indiana | 18059 | 20778 | 258 |
2474246 | 2474246 | 2022-05-05 | Hancock | Indiana | 18059 | 20778 | 258 |
2470989 | 2470989 | 2022-05-04 | Hancock | Indiana | 18059 | 20778 | 258 |
2467733 | 2467733 | 2022-05-03 | Hancock | Indiana | 18059 | 20759 | 258 |
2464478 | 2464478 | 2022-05-02 | Hancock | Indiana | 18059 | 20759 | 258 |
2461222 | 2461222 | 2022-05-01 | Hancock | Indiana | 18059 | 20741 | 258 |
2457966 | 2457966 | 2022-04-30 | Hancock | Indiana | 18059 | 20741 | 258 |
2454710 | 2454710 | 2022-04-29 | Hancock | Indiana | 18059 | 20741 | 258 |
2451454 | 2451454 | 2022-04-28 | Hancock | Indiana | 18059 | 20717 | 258 |
2448198 | 2448198 | 2022-04-27 | Hancock | Indiana | 18059 | 20717 | 258 |
2444942 | 2444942 | 2022-04-26 | Hancock | Indiana | 18059 | 20706 | 258 |
2441686 | 2441686 | 2022-04-25 | Hancock | Indiana | 18059 | 20706 | 258 |
2438430 | 2438430 | 2022-04-24 | Hancock | Indiana | 18059 | 20698 | 258 |
2435174 | 2435174 | 2022-04-23 | Hancock | Indiana | 18059 | 20698 | 258 |
2431918 | 2431918 | 2022-04-22 | Hancock | Indiana | 18059 | 20698 | 258 |
2428662 | 2428662 | 2022-04-21 | Hancock | Indiana | 18059 | 20690 | 258 |
2425406 | 2425406 | 2022-04-20 | Hancock | Indiana | 18059 | 20690 | 258 |
2422150 | 2422150 | 2022-04-19 | Hancock | Indiana | 18059 | 20683 | 258 |
2418894 | 2418894 | 2022-04-18 | Hancock | Indiana | 18059 | 20683 | 258 |
2415638 | 2415638 | 2022-04-17 | Hancock | Indiana | 18059 | 20665 | 258 |
2412382 | 2412382 | 2022-04-16 | Hancock | Indiana | 18059 | 20665 | 258 |
2409126 | 2409126 | 2022-04-15 | Hancock | Indiana | 18059 | 20665 | 258 |
2405870 | 2405870 | 2022-04-14 | Hancock | Indiana | 18059 | 20665 | 258 |
2402615 | 2402615 | 2022-04-13 | Hancock | Indiana | 18059 | 20665 | 258 |
2399360 | 2399360 | 2022-04-12 | Hancock | Indiana | 18059 | 20665 | 258 |
2396105 | 2396105 | 2022-04-11 | Hancock | Indiana | 18059 | 20665 | 258 |
2392849 | 2392849 | 2022-04-10 | Hancock | Indiana | 18059 | 20651 | 258 |
2389593 | 2389593 | 2022-04-09 | Hancock | Indiana | 18059 | 20651 | 258 |
2386338 | 2386338 | 2022-04-08 | Hancock | Indiana | 18059 | 20651 | 258 |
2383083 | 2383083 | 2022-04-07 | Hancock | Indiana | 18059 | 20647 | 258 |
2379828 | 2379828 | 2022-04-06 | Hancock | Indiana | 18059 | 20647 | 258 |
2376574 | 2376574 | 2022-04-05 | Hancock | Indiana | 18059 | 20643 | 258 |
2373322 | 2373322 | 2022-04-04 | Hancock | Indiana | 18059 | 20643 | 258 |
2370069 | 2370069 | 2022-04-03 | Hancock | Indiana | 18059 | 20636 | 258 |
2366816 | 2366816 | 2022-04-02 | Hancock | Indiana | 18059 | 20636 | 258 |
2363563 | 2363563 | 2022-04-01 | Hancock | Indiana | 18059 | 20636 | 258 |
2360309 | 2360309 | 2022-03-31 | Hancock | Indiana | 18059 | 20622 | 258 |
2357055 | 2357055 | 2022-03-30 | Hancock | Indiana | 18059 | 20622 | 258 |
2353802 | 2353802 | 2022-03-29 | Hancock | Indiana | 18059 | 20657 | 258 |
2350550 | 2350550 | 2022-03-28 | Hancock | Indiana | 18059 | 20660 | 258 |
2347297 | 2347297 | 2022-03-27 | Hancock | Indiana | 18059 | 20653 | 258 |
2344044 | 2344044 | 2022-03-26 | Hancock | Indiana | 18059 | 20653 | 258 |
2340791 | 2340791 | 2022-03-25 | Hancock | Indiana | 18059 | 20653 | 258 |
2337538 | 2337538 | 2022-03-24 | Hancock | Indiana | 18059 | 20649 | 258 |
2334284 | 2334284 | 2022-03-23 | Hancock | Indiana | 18059 | 20647 | 258 |
2331030 | 2331030 | 2022-03-22 | Hancock | Indiana | 18059 | 20642 | 258 |
2327778 | 2327778 | 2022-03-21 | Hancock | Indiana | 18059 | 20643 | 258 |
2324525 | 2324525 | 2022-03-20 | Hancock | Indiana | 18059 | 20639 | 258 |
2321271 | 2321271 | 2022-03-19 | Hancock | Indiana | 18059 | 20639 | 258 |
2318017 | 2318017 | 2022-03-18 | Hancock | Indiana | 18059 | 20639 | 258 |
2314764 | 2314764 | 2022-03-17 | Hancock | Indiana | 18059 | 20633 | 258 |
2311511 | 2311511 | 2022-03-16 | Hancock | Indiana | 18059 | 20631 | 258 |
2308258 | 2308258 | 2022-03-15 | Hancock | Indiana | 18059 | 20626 | 258 |
2305007 | 2305007 | 2022-03-14 | Hancock | Indiana | 18059 | 20625 | 258 |
2301755 | 2301755 | 2022-03-13 | Hancock | Indiana | 18059 | 20620 | 257 |
2298503 | 2298503 | 2022-03-12 | Hancock | Indiana | 18059 | 20620 | 257 |
2295251 | 2295251 | 2022-03-11 | Hancock | Indiana | 18059 | 20620 | 257 |
2291999 | 2291999 | 2022-03-10 | Hancock | Indiana | 18059 | 20619 | 257 |
2288747 | 2288747 | 2022-03-09 | Hancock | Indiana | 18059 | 20619 | 257 |
2285496 | 2285496 | 2022-03-08 | Hancock | Indiana | 18059 | 20615 | 256 |
2282244 | 2282244 | 2022-03-07 | Hancock | Indiana | 18059 | 20618 | 256 |
2278991 | 2278991 | 2022-03-06 | Hancock | Indiana | 18059 | 20599 | 256 |
2275738 | 2275738 | 2022-03-05 | Hancock | Indiana | 18059 | 20599 | 256 |
2272485 | 2272485 | 2022-03-04 | Hancock | Indiana | 18059 | 20599 | 256 |
2269233 | 2269233 | 2022-03-03 | Hancock | Indiana | 18059 | 20592 | 256 |
2265980 | 2265980 | 2022-03-02 | Hancock | Indiana | 18059 | 20592 | 256 |
2262729 | 2262729 | 2022-03-01 | Hancock | Indiana | 18059 | 20588 | 255 |
2259478 | 2259478 | 2022-02-28 | Hancock | Indiana | 18059 | 20584 | 255 |
2256227 | 2256227 | 2022-02-27 | Hancock | Indiana | 18059 | 20561 | 255 |
2252976 | 2252976 | 2022-02-26 | Hancock | Indiana | 18059 | 20561 | 255 |
2249725 | 2249725 | 2022-02-25 | Hancock | Indiana | 18059 | 20561 | 255 |
2246474 | 2246474 | 2022-02-24 | Hancock | Indiana | 18059 | 20558 | 255 |
2243223 | 2243223 | 2022-02-23 | Hancock | Indiana | 18059 | 20559 | 255 |
2239972 | 2239972 | 2022-02-22 | Hancock | Indiana | 18059 | 20544 | 254 |
2236721 | 2236721 | 2022-02-21 | Hancock | Indiana | 18059 | 20536 | 253 |
2233470 | 2233470 | 2022-02-20 | Hancock | Indiana | 18059 | 20493 | 253 |
2230219 | 2230219 | 2022-02-19 | Hancock | Indiana | 18059 | 20493 | 253 |
2226968 | 2226968 | 2022-02-18 | Hancock | Indiana | 18059 | 20493 | 253 |
2223717 | 2223717 | 2022-02-17 | Hancock | Indiana | 18059 | 20486 | 250 |
2220466 | 2220466 | 2022-02-16 | Hancock | Indiana | 18059 | 20473 | 250 |
2217215 | 2217215 | 2022-02-15 | Hancock | Indiana | 18059 | 20471 | 249 |
2213964 | 2213964 | 2022-02-14 | Hancock | Indiana | 18059 | 20460 | 248 |
2210712 | 2210712 | 2022-02-13 | Hancock | Indiana | 18059 | 20422 | 248 |
2207459 | 2207459 | 2022-02-12 | Hancock | Indiana | 18059 | 20422 | 248 |
2204206 | 2204206 | 2022-02-11 | Hancock | Indiana | 18059 | 20422 | 248 |
2200953 | 2200953 | 2022-02-10 | Hancock | Indiana | 18059 | 20402 | 246 |
2197699 | 2197699 | 2022-02-09 | Hancock | Indiana | 18059 | 20333 | 245 |
2194445 | 2194445 | 2022-02-08 | Hancock | Indiana | 18059 | 20333 | 245 |
2191191 | 2191191 | 2022-02-07 | Hancock | Indiana | 18059 | 20335 | 241 |
2187938 | 2187938 | 2022-02-06 | Hancock | Indiana | 18059 | 20258 | 239 |
2184685 | 2184685 | 2022-02-05 | Hancock | Indiana | 18059 | 20258 | 239 |
2181433 | 2181433 | 2022-02-04 | Hancock | Indiana | 18059 | 20258 | 239 |
2178182 | 2178182 | 2022-02-03 | Hancock | Indiana | 18059 | 20204 | 239 |
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);