ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,464 rows where county = "Rush" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, date (date)
cases 641 ✖
- 431 47
- 434 40
- 807 31
- 806 28
- 808 22
- 4835 17
- 424 15
- 433 14
- 428 13
- 1 11
- 4 11
- 1828 11
- 5 10
- 423 9
- 425 9
- 430 9
- 1832 9
- 1833 8
- 9 7
- 10 7
- 53 7
- 67 7
- 343 7
- 459 7
- 495 7
- 4906 7
- 59 6
- 112 6
- 504 6
- 1821 6
- 4840 6
- 17 5
- 41 5
- 333 5
- 418 5
- 427 5
- 438 5
- 447 5
- 465 5
- 477 5
- 490 5
- 515 5
- 519 5
- 555 5
- 594 5
- 608 5
- 672 5
- 798 5
- 1734 5
- 3004 5
- 3445 5
- 4845 5
- 4849 5
- 2 4
- 3 4
- 15 4
- 18 4
- 30 4
- 43 4
- 62 4
- 66 4
- 73 4
- 77 4
- 80 4
- 81 4
- 97 4
- 101 4
- 206 4
- 443 4
- 498 4
- 1814 4
- 2078 4
- 3536 4
- 4898 4
- 6 3
- 7 3
- 13 3
- 14 3
- 16 3
- 20 3
- 22 3
- 27 3
- 34 3
- 35 3
- 36 3
- 47 3
- 48 3
- 55 3
- 65 3
- 68 3
- 82 3
- 94 3
- 104 3
- 108 3
- 110 3
- 113 3
- 118 3
- 140 3
- 166 3
- 181 3
- 251 3
- 264 3
- 284 3
- 301 3
- 323 3
- 365 3
- 391 3
- 409 3
- 440 3
- 441 3
- 444 3
- 457 3
- 481 3
- 485 3
- 486 3
- 489 3
- 534 3
- 547 3
- 565 3
- 575 3
- 582 3
- 586 3
- 632 3
- 737 3
- 764 3
- 786 3
- 801 3
- 1706 3
- 1720 3
- 1733 3
- 1774 3
- 1775 3
- 1806 3
- 1809 3
- 1816 3
- 1819 3
- 1840 3
- 1856 3
- 1872 3
- 1914 3
- 1961 3
- 2001 3
- 2219 3
- 2357 3
- 2437 3
- 2518 3
- 2595 3
- 2642 3
- 2693 3
- 2743 3
- 2791 3
- 2877 3
- 2931 3
- 3166 3
- 3291 3
- 3390 3
- 3718 3
- 3915 3
- 4260 3
- 4577 3
- 4750 3
- 4815 3
- 4852 3
- 4872 3
- 4894 3
- 4903 3
- 11 2
- 12 2
- 49 2
- 50 2
- 61 2
- 71 2
- 72 2
- 74 2
- 75 2
- 76 2
- 86 2
- 87 2
- 88 2
- 90 2
- 91 2
- 96 2
- 98 2
- 99 2
- 105 2
- 114 2
- 116 2
- 123 2
- 132 2
- 141 2
- 156 2
- 177 2
- 178 2
- 180 2
- 182 2
- 189 2
- 190 2
- 192 2
- 194 2
- 199 2
- 201 2
- 202 2
- 203 2
- 208 2
- 230 2
- 272 2
- 286 2
- 298 2
- 308 2
- 317 2
- 324 2
- 336 2
- 349 2
- 370 2
- 383 2
- 400 2
- 402 2
- 414 2
- 416 2
- 422 2
- 429 2
- 432 2
- 436 2
- 437 2
- 445 2
- 448 2
- 453 2
- 458 2
- 463 2
- 474 2
- 479 2
- 484 2
- 491 2
- 494 2
- 500 2
- 506 2
- 508 2
- 524 2
- 527 2
- 539 2
- 543 2
- 549 2
- 556 2
- 562 2
- 566 2
- 573 2
- 577 2
- 589 2
- 601 2
- 612 2
- 619 2
- 639 2
- 653 2
- 726 2
- 744 2
- 754 2
- 774 2
- 780 2
- 796 2
- 804 2
- 809 2
- 810 2
- 1656 2
- 1678 2
- 1686 2
- 1716 2
- 1723 2
- 1777 2
- 1798 2
- 1803 2
- 1820 2
- 1824 2
- 1825 2
- 1826 2
- 1827 2
- 1838 2
- 4781 2
- 4834 2
- 4842 2
- 4844 2
- 4847 2
- 4854 2
- 4857 2
- 4897 2
- 4900 2
- 8 1
- 19 1
- 21 1
- 29 1
- 31 1
- 37 1
- 38 1
- 39 1
- 40 1
- 51 1
- 54 1
- 57 1
- 58 1
- 64 1
- 70 1
- 83 1
- 85 1
- 89 1
- 93 1
- 95 1
- 102 1
- 106 1
- 109 1
- 121 1
- 126 1
- 129 1
- 138 1
- 139 1
- 143 1
- 153 1
- 158 1
- 162 1
- 164 1
- 165 1
- 167 1
- 168 1
- 169 1
- 172 1
- 174 1
- 175 1
- 176 1
- 184 1
- 185 1
- 187 1
- 188 1
- 191 1
- 195 1
- 196 1
- 197 1
- 204 1
- 207 1
- 209 1
- 211 1
- 214 1
- 217 1
- 219 1
- 221 1
- 224 1
- 227 1
- 238 1
- 244 1
- 249 1
- 250 1
- 254 1
- 261 1
- 271 1
- 276 1
- 292 1
- 300 1
- 311 1
- 319 1
- 341 1
- 342 1
- 344 1
- 352 1
- 361 1
- 367 1
- 373 1
- 394 1
- 406 1
- 411 1
- 421 1
- 452 1
- 461 1
- 476 1
- 520 1
- 526 1
- 544 1
- 552 1
- 572 1
- 595 1
- 618 1
- 623 1
- 630 1
- 646 1
- 662 1
- 674 1
- 683 1
- 704 1
- 723 1
- 748 1
- 770 1
- 783 1
- 787 1
- 827 1
- 852 1
- 869 1
- 900 1
- 912 1
- 949 1
- 970 1
- 1003 1
- 1032 1
- 1050 1
- 1065 1
- 1077 1
- 1090 1
- 1117 1
- 1137 1
- 1145 1
- 1168 1
- 1171 1
- 1187 1
- 1200 1
- 1231 1
- 1254 1
- 1283 1
- 1301 1
- 1314 1
- 1326 1
- 1344 1
- 1377 1
- 1408 1
- 1426 1
- 1434 1
- 1449 1
- 1460 1
- 1475 1
- 1495 1
- 1518 1
- 1529 1
- 1542 1
- 1560 1
- 1569 1
- 1577 1
- 1584 1
- 1594 1
- 1606 1
- 1612 1
- 1619 1
- 1624 1
- 1625 1
- 1633 1
- 1639 1
- 1647 1
- 1648 1
- 1649 1
- 1650 1
- 1653 1
- 1660 1
- 1662 1
- 1667 1
- 1669 1
- 1671 1
- 1680 1
- 1682 1
- 1683 1
- 1684 1
- 1687 1
- 1689 1
- 1693 1
- 1697 1
- 1699 1
- 1701 1
- 1704 1
- 1710 1
- 1711 1
- 1714 1
- 1717 1
- 1719 1
- 1722 1
- 1725 1
- 1726 1
- 1727 1
- 1728 1
- 1730 1
- 1732 1
- 1735 1
- 1737 1
- 1738 1
- 1739 1
- 1741 1
- 1743 1
- 1745 1
- 1746 1
- 1749 1
- 1750 1
- 1751 1
- 1752 1
- 1753 1
- 1755 1
- 1760 1
- 1761 1
- 1764 1
- 1765 1
- 1769 1
- 1770 1
- 1773 1
- 1776 1
- 1778 1
- 1779 1
- 1782 1
- 1784 1
- 1787 1
- 1790 1
- 1792 1
- 1793 1
- 1795 1
- 1796 1
- 1799 1
- 1800 1
- 1801 1
- 1811 1
- 1812 1
- 1818 1
- 1822 1
- 1829 1
- 1830 1
- 1831 1
- 1837 1
- 1839 1
- 1843 1
- 1845 1
- 1846 1
- 1853 1
- 1859 1
- 1861 1
- 1863 1
- 1864 1
- 1884 1
- 1890 1
- 1896 1
- 1910 1
- 1929 1
- 1935 1
- 1949 1
- 1954 1
- 1975 1
- 1981 1
- 1983 1
- 1999 1
- 2024 1
- 2034 1
- 2046 1
- 2061 1
- 2135 1
- 2145 1
- 2188 1
- 2265 1
- 2274 1
- 2323 1
- 2348 1
- 2380 1
- 2384 1
- 2408 1
- 2423 1
- 2456 1
- 2459 1
- 2490 1
- 2508 1
- 2543 1
- 2544 1
- 2559 1
- 2578 1
- 2607 1
- 2614 1
- 2627 1
- 2637 1
- 2658 1
- 2665 1
- 2677 1
- 2682 1
- 2707 1
- 2713 1
- 2726 1
- 2738 1
- 2759 1
- 2764 1
- 2778 1
- 2785 1
- 2811 1
- 2818 1
- 2829 1
- 2866 1
- 2889 1
- 2901 1
- 2917 1
- 2922 1
- 2971 1
- 2983 1
- 3054 1
- 3067 1
- 3114 1
- 3139 1
- 3219 1
- 3227 1
- 3254 1
- 3271 1
- 3327 1
- 3346 1
- 3363 1
- 3370 1
- 3417 1
- 3426 1
- 3489 1
- 3494 1
- 3508 1
- 3601 1
- 3620 1
- 3657 1
- 3687 1
- 3783 1
- 3813 1
- 3839 1
- 3873 1
- 4029 1
- 4059 1
- 4111 1
- 4174 1
- 4411 1
- 4435 1
- 4447 1
- 4509 1
- 4660 1
- 4674 1
- 4695 1
- 4717 1
- 4768 1
- 4814 1
- 4830 1
- 4837 1
- 4846 1
- 4858 1
- 4864 1
- 4866 1
- 4870 1
- 4871 1
- 4885 1
- 4886 1
- 4887 1
- 4891 1
- 4896 1
- 4899 1
- 4902 1
- 4905 1
- 4907 1
county 1
- Rush · 1,464 ✖
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
11270 | 11270 | 2020-03-25 | Rush | Indiana | 18139 | 1 | 0 |
12830 | 12830 | 2020-03-26 | Rush | Indiana | 18139 | 1 | 0 |
284888 | 284888 | 2020-06-29 | Rush | Kansas | 20165 | 1 | 0 |
288037 | 288037 | 2020-06-30 | Rush | Kansas | 20165 | 1 | 0 |
291187 | 291187 | 2020-07-01 | Rush | Kansas | 20165 | 1 | 0 |
294341 | 294341 | 2020-07-02 | Rush | Kansas | 20165 | 1 | 0 |
297499 | 297499 | 2020-07-03 | Rush | Kansas | 20165 | 1 | 0 |
300661 | 300661 | 2020-07-04 | Rush | Kansas | 20165 | 1 | 0 |
303825 | 303825 | 2020-07-05 | Rush | Kansas | 20165 | 1 | 0 |
306992 | 306992 | 2020-07-06 | Rush | Kansas | 20165 | 1 | 0 |
310160 | 310160 | 2020-07-07 | Rush | Kansas | 20165 | 1 | 0 |
16315 | 16315 | 2020-03-28 | Rush | Indiana | 18139 | 2 | 0 |
18219 | 18219 | 2020-03-29 | Rush | Indiana | 18139 | 2 | 0 |
313330 | 313330 | 2020-07-08 | Rush | Kansas | 20165 | 2 | 0 |
316504 | 316504 | 2020-07-09 | Rush | Kansas | 20165 | 2 | 0 |
14516 | 14516 | 2020-03-27 | Rush | Indiana | 18139 | 3 | 0 |
319678 | 319678 | 2020-07-10 | Rush | Kansas | 20165 | 3 | 0 |
322857 | 322857 | 2020-07-11 | Rush | Kansas | 20165 | 3 | 0 |
326040 | 326040 | 2020-07-12 | Rush | Kansas | 20165 | 3 | 0 |
20225 | 20225 | 2020-03-30 | Rush | Indiana | 18139 | 4 | 0 |
22320 | 22320 | 2020-03-31 | Rush | Indiana | 18139 | 4 | 0 |
329226 | 329226 | 2020-07-13 | Rush | Kansas | 20165 | 4 | 0 |
332413 | 332413 | 2020-07-14 | Rush | Kansas | 20165 | 4 | 0 |
335606 | 335606 | 2020-07-15 | Rush | Kansas | 20165 | 4 | 0 |
338802 | 338802 | 2020-07-16 | Rush | Kansas | 20165 | 4 | 0 |
341998 | 341998 | 2020-07-17 | Rush | Kansas | 20165 | 4 | 0 |
345198 | 345198 | 2020-07-18 | Rush | Kansas | 20165 | 4 | 0 |
348399 | 348399 | 2020-07-19 | Rush | Kansas | 20165 | 4 | 0 |
351599 | 351599 | 2020-07-20 | Rush | Kansas | 20165 | 4 | 0 |
354801 | 354801 | 2020-07-21 | Rush | Kansas | 20165 | 4 | 0 |
24491 | 24491 | 2020-04-01 | Rush | Indiana | 18139 | 5 | 0 |
358003 | 358003 | 2020-07-22 | Rush | Kansas | 20165 | 5 | 0 |
361208 | 361208 | 2020-07-23 | Rush | Kansas | 20165 | 5 | 0 |
364415 | 364415 | 2020-07-24 | Rush | Kansas | 20165 | 5 | 0 |
367622 | 367622 | 2020-07-25 | Rush | Kansas | 20165 | 5 | 0 |
370832 | 370832 | 2020-07-26 | Rush | Kansas | 20165 | 5 | 0 |
374044 | 374044 | 2020-07-27 | Rush | Kansas | 20165 | 5 | 0 |
377259 | 377259 | 2020-07-28 | Rush | Kansas | 20165 | 5 | 0 |
380476 | 380476 | 2020-07-29 | Rush | Kansas | 20165 | 5 | 0 |
383693 | 383693 | 2020-07-30 | Rush | Kansas | 20165 | 5 | 0 |
386911 | 386911 | 2020-07-31 | Rush | Kansas | 20165 | 6 | 0 |
390128 | 390128 | 2020-08-01 | Rush | Kansas | 20165 | 6 | 0 |
393345 | 393345 | 2020-08-02 | Rush | Kansas | 20165 | 6 | 0 |
26730 | 26730 | 2020-04-02 | Rush | Indiana | 18139 | 7 | 0 |
396561 | 396561 | 2020-08-03 | Rush | Kansas | 20165 | 7 | 0 |
399776 | 399776 | 2020-08-04 | Rush | Kansas | 20165 | 7 | 0 |
29041 | 29041 | 2020-04-03 | Rush | Indiana | 18139 | 8 | 1 |
402993 | 402993 | 2020-08-05 | Rush | Kansas | 20165 | 9 | 0 |
406211 | 406211 | 2020-08-06 | Rush | Kansas | 20165 | 9 | 0 |
409430 | 409430 | 2020-08-07 | Rush | Kansas | 20165 | 9 | 0 |
412650 | 412650 | 2020-08-08 | Rush | Kansas | 20165 | 9 | 0 |
415870 | 415870 | 2020-08-09 | Rush | Kansas | 20165 | 9 | 0 |
419091 | 419091 | 2020-08-10 | Rush | Kansas | 20165 | 9 | 0 |
422314 | 422314 | 2020-08-11 | Rush | Kansas | 20165 | 9 | 0 |
31408 | 31408 | 2020-04-04 | Rush | Indiana | 18139 | 10 | 1 |
33819 | 33819 | 2020-04-05 | Rush | Indiana | 18139 | 10 | 1 |
425535 | 425535 | 2020-08-12 | Rush | Kansas | 20165 | 10 | 0 |
428759 | 428759 | 2020-08-13 | Rush | Kansas | 20165 | 10 | 0 |
431987 | 431987 | 2020-08-14 | Rush | Kansas | 20165 | 10 | 0 |
435212 | 435212 | 2020-08-15 | Rush | Kansas | 20165 | 10 | 0 |
438437 | 438437 | 2020-08-16 | Rush | Kansas | 20165 | 10 | 0 |
441664 | 441664 | 2020-08-17 | Rush | Kansas | 20165 | 11 | 0 |
444890 | 444890 | 2020-08-18 | Rush | Kansas | 20165 | 11 | 0 |
36273 | 36273 | 2020-04-06 | Rush | Indiana | 18139 | 12 | 1 |
46498 | 46498 | 2020-04-10 | Rush | Indiana | 18139 | 12 | 1 |
49132 | 49132 | 2020-04-11 | Rush | Indiana | 18139 | 13 | 1 |
448117 | 448117 | 2020-08-19 | Rush | Kansas | 20165 | 13 | 0 |
451345 | 451345 | 2020-08-20 | Rush | Kansas | 20165 | 13 | 0 |
38771 | 38771 | 2020-04-07 | Rush | Indiana | 18139 | 14 | 1 |
41317 | 41317 | 2020-04-08 | Rush | Indiana | 18139 | 14 | 1 |
43893 | 43893 | 2020-04-09 | Rush | Indiana | 18139 | 14 | 1 |
51796 | 51796 | 2020-04-12 | Rush | Indiana | 18139 | 15 | 1 |
454573 | 454573 | 2020-08-21 | Rush | Kansas | 20165 | 15 | 0 |
457801 | 457801 | 2020-08-22 | Rush | Kansas | 20165 | 15 | 0 |
461028 | 461028 | 2020-08-23 | Rush | Kansas | 20165 | 15 | 0 |
57170 | 57170 | 2020-04-14 | Rush | Indiana | 18139 | 16 | 1 |
464258 | 464258 | 2020-08-24 | Rush | Kansas | 20165 | 16 | 0 |
467487 | 467487 | 2020-08-25 | Rush | Kansas | 20165 | 16 | 0 |
54477 | 54477 | 2020-04-13 | Rush | Indiana | 18139 | 17 | 1 |
59878 | 59878 | 2020-04-15 | Rush | Indiana | 18139 | 17 | 1 |
62599 | 62599 | 2020-04-16 | Rush | Indiana | 18139 | 17 | 1 |
470716 | 470716 | 2020-08-26 | Rush | Kansas | 20165 | 17 | 0 |
473948 | 473948 | 2020-08-27 | Rush | Kansas | 20165 | 17 | 0 |
70844 | 70844 | 2020-04-19 | Rush | Indiana | 18139 | 18 | 1 |
477181 | 477181 | 2020-08-28 | Rush | Kansas | 20165 | 18 | 0 |
480414 | 480414 | 2020-08-29 | Rush | Kansas | 20165 | 18 | 0 |
483648 | 483648 | 2020-08-30 | Rush | Kansas | 20165 | 18 | 0 |
68082 | 68082 | 2020-04-18 | Rush | Indiana | 18139 | 19 | 1 |
65333 | 65333 | 2020-04-17 | Rush | Indiana | 18139 | 20 | 1 |
486883 | 486883 | 2020-08-31 | Rush | Kansas | 20165 | 20 | 0 |
490116 | 490116 | 2020-09-01 | Rush | Kansas | 20165 | 20 | 0 |
73615 | 73615 | 2020-04-20 | Rush | Indiana | 18139 | 21 | 1 |
76392 | 76392 | 2020-04-21 | Rush | Indiana | 18139 | 22 | 1 |
79176 | 79176 | 2020-04-22 | Rush | Indiana | 18139 | 22 | 1 |
81969 | 81969 | 2020-04-23 | Rush | Indiana | 18139 | 22 | 1 |
84769 | 84769 | 2020-04-24 | Rush | Indiana | 18139 | 27 | 1 |
493349 | 493349 | 2020-09-02 | Rush | Kansas | 20165 | 27 | 0 |
496583 | 496583 | 2020-09-03 | Rush | Kansas | 20165 | 27 | 0 |
87579 | 87579 | 2020-04-25 | Rush | Indiana | 18139 | 29 | 1 |
90395 | 90395 | 2020-04-26 | Rush | Indiana | 18139 | 30 | 1 |
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);