ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Rush" and fips = 18139 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 512 ✖
- 4835 17
- 1828 11
- 1832 9
- 1833 8
- 67 7
- 4906 7
- 59 6
- 112 6
- 1821 6
- 4840 6
- 1734 5
- 3004 5
- 3445 5
- 4845 5
- 4849 5
- 77 4
- 80 4
- 206 4
- 1814 4
- 2078 4
- 3536 4
- 4898 4
- 14 3
- 17 3
- 22 3
- 47 3
- 48 3
- 55 3
- 65 3
- 68 3
- 82 3
- 113 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
- 1 2
- 2 2
- 4 2
- 10 2
- 12 2
- 49 2
- 53 2
- 61 2
- 62 2
- 66 2
- 71 2
- 72 2
- 74 2
- 86 2
- 87 2
- 91 2
- 99 2
- 101 2
- 105 2
- 116 2
- 141 2
- 177 2
- 178 2
- 180 2
- 182 2
- 189 2
- 190 2
- 192 2
- 194 2
- 199 2
- 201 2
- 202 2
- 208 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
- 3 1
- 5 1
- 7 1
- 8 1
- 13 1
- 15 1
- 16 1
- 18 1
- 19 1
- 20 1
- 21 1
- 27 1
- 29 1
- 30 1
- 31 1
- 34 1
- 35 1
- 37 1
- 38 1
- 39 1
- 40 1
- 41 1
- 43 1
- 51 1
- 54 1
- 57 1
- 58 1
- 64 1
- 70 1
- 73 1
- 81 1
- 83 1
- 85 1
- 89 1
- 93 1
- 95 1
- 97 1
- 102 1
- 104 1
- 106 1
- 109 1
- 110 1
- 121 1
- 126 1
- 129 1
- 138 1
- 139 1
- 143 1
- 153 1
- 158 1
- 162 1
- 164 1
- 165 1
- 166 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
- 264 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
- 428 1
- 440 1
- 452 1
- 461 1
- 476 1
- 485 1
- 489 1
- 498 1
- 504 1
- 520 1
- 526 1
- 544 1
- 552 1
- 572 1
- 582 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
- 801 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
state 1
- Indiana 780
fips 1
- 18139 · 780 ✖
county 1
- Rush · 780 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500349 | 2500349 | 2022-05-13 | Rush | Indiana | 18139 | 4866 | 58 |
2497091 | 2497091 | 2022-05-12 | Rush | Indiana | 18139 | 4857 | 58 |
2493833 | 2493833 | 2022-05-11 | Rush | Indiana | 18139 | 4857 | 58 |
2490575 | 2490575 | 2022-05-10 | Rush | Indiana | 18139 | 4854 | 58 |
2487318 | 2487318 | 2022-05-09 | Rush | Indiana | 18139 | 4854 | 58 |
2484060 | 2484060 | 2022-05-08 | Rush | Indiana | 18139 | 4849 | 58 |
2480802 | 2480802 | 2022-05-07 | Rush | Indiana | 18139 | 4849 | 58 |
2477544 | 2477544 | 2022-05-06 | Rush | Indiana | 18139 | 4849 | 58 |
2474286 | 2474286 | 2022-05-05 | Rush | Indiana | 18139 | 4849 | 58 |
2471029 | 2471029 | 2022-05-04 | Rush | Indiana | 18139 | 4849 | 58 |
2467773 | 2467773 | 2022-05-03 | Rush | Indiana | 18139 | 4847 | 58 |
2464518 | 2464518 | 2022-05-02 | Rush | Indiana | 18139 | 4847 | 58 |
2461262 | 2461262 | 2022-05-01 | Rush | Indiana | 18139 | 4845 | 58 |
2458006 | 2458006 | 2022-04-30 | Rush | Indiana | 18139 | 4845 | 58 |
2454750 | 2454750 | 2022-04-29 | Rush | Indiana | 18139 | 4845 | 58 |
2451494 | 2451494 | 2022-04-28 | Rush | Indiana | 18139 | 4845 | 58 |
2448238 | 2448238 | 2022-04-27 | Rush | Indiana | 18139 | 4845 | 58 |
2444982 | 2444982 | 2022-04-26 | Rush | Indiana | 18139 | 4844 | 58 |
2441726 | 2441726 | 2022-04-25 | Rush | Indiana | 18139 | 4844 | 58 |
2438470 | 2438470 | 2022-04-24 | Rush | Indiana | 18139 | 4840 | 58 |
2435214 | 2435214 | 2022-04-23 | Rush | Indiana | 18139 | 4840 | 58 |
2431958 | 2431958 | 2022-04-22 | Rush | Indiana | 18139 | 4840 | 58 |
2428702 | 2428702 | 2022-04-21 | Rush | Indiana | 18139 | 4842 | 58 |
2425446 | 2425446 | 2022-04-20 | Rush | Indiana | 18139 | 4842 | 58 |
2422190 | 2422190 | 2022-04-19 | Rush | Indiana | 18139 | 4840 | 58 |
2418934 | 2418934 | 2022-04-18 | Rush | Indiana | 18139 | 4840 | 58 |
2415678 | 2415678 | 2022-04-17 | Rush | Indiana | 18139 | 4835 | 58 |
2412422 | 2412422 | 2022-04-16 | Rush | Indiana | 18139 | 4835 | 58 |
2409166 | 2409166 | 2022-04-15 | Rush | Indiana | 18139 | 4835 | 58 |
2405910 | 2405910 | 2022-04-14 | Rush | Indiana | 18139 | 4835 | 58 |
2402655 | 2402655 | 2022-04-13 | Rush | Indiana | 18139 | 4835 | 58 |
2399400 | 2399400 | 2022-04-12 | Rush | Indiana | 18139 | 4835 | 58 |
2396145 | 2396145 | 2022-04-11 | Rush | Indiana | 18139 | 4835 | 58 |
2392889 | 2392889 | 2022-04-10 | Rush | Indiana | 18139 | 4835 | 58 |
2389633 | 2389633 | 2022-04-09 | Rush | Indiana | 18139 | 4835 | 58 |
2386378 | 2386378 | 2022-04-08 | Rush | Indiana | 18139 | 4835 | 58 |
2383123 | 2383123 | 2022-04-07 | Rush | Indiana | 18139 | 4835 | 58 |
2379868 | 2379868 | 2022-04-06 | Rush | Indiana | 18139 | 4835 | 58 |
2376614 | 2376614 | 2022-04-05 | Rush | Indiana | 18139 | 4835 | 58 |
2373362 | 2373362 | 2022-04-04 | Rush | Indiana | 18139 | 4835 | 58 |
2370109 | 2370109 | 2022-04-03 | Rush | Indiana | 18139 | 4835 | 58 |
2366856 | 2366856 | 2022-04-02 | Rush | Indiana | 18139 | 4835 | 58 |
2363603 | 2363603 | 2022-04-01 | Rush | Indiana | 18139 | 4835 | 58 |
2360349 | 2360349 | 2022-03-31 | Rush | Indiana | 18139 | 4834 | 58 |
2357095 | 2357095 | 2022-03-30 | Rush | Indiana | 18139 | 4834 | 58 |
2353842 | 2353842 | 2022-03-29 | Rush | Indiana | 18139 | 4906 | 58 |
2350590 | 2350590 | 2022-03-28 | Rush | Indiana | 18139 | 4906 | 58 |
2347337 | 2347337 | 2022-03-27 | Rush | Indiana | 18139 | 4906 | 58 |
2344084 | 2344084 | 2022-03-26 | Rush | Indiana | 18139 | 4906 | 58 |
2340831 | 2340831 | 2022-03-25 | Rush | Indiana | 18139 | 4906 | 58 |
2337578 | 2337578 | 2022-03-24 | Rush | Indiana | 18139 | 4906 | 58 |
2334324 | 2334324 | 2022-03-23 | Rush | Indiana | 18139 | 4906 | 58 |
2331070 | 2331070 | 2022-03-22 | Rush | Indiana | 18139 | 4905 | 58 |
2327818 | 2327818 | 2022-03-21 | Rush | Indiana | 18139 | 4907 | 58 |
2324565 | 2324565 | 2022-03-20 | Rush | Indiana | 18139 | 4903 | 58 |
2321311 | 2321311 | 2022-03-19 | Rush | Indiana | 18139 | 4903 | 58 |
2318057 | 2318057 | 2022-03-18 | Rush | Indiana | 18139 | 4903 | 58 |
2314804 | 2314804 | 2022-03-17 | Rush | Indiana | 18139 | 4902 | 58 |
2311551 | 2311551 | 2022-03-16 | Rush | Indiana | 18139 | 4900 | 58 |
2308298 | 2308298 | 2022-03-15 | Rush | Indiana | 18139 | 4900 | 59 |
2305047 | 2305047 | 2022-03-14 | Rush | Indiana | 18139 | 4899 | 59 |
2301795 | 2301795 | 2022-03-13 | Rush | Indiana | 18139 | 4898 | 59 |
2298543 | 2298543 | 2022-03-12 | Rush | Indiana | 18139 | 4898 | 59 |
2295291 | 2295291 | 2022-03-11 | Rush | Indiana | 18139 | 4898 | 59 |
2292039 | 2292039 | 2022-03-10 | Rush | Indiana | 18139 | 4898 | 58 |
2288787 | 2288787 | 2022-03-09 | Rush | Indiana | 18139 | 4897 | 58 |
2285536 | 2285536 | 2022-03-08 | Rush | Indiana | 18139 | 4896 | 58 |
2282284 | 2282284 | 2022-03-07 | Rush | Indiana | 18139 | 4897 | 58 |
2279031 | 2279031 | 2022-03-06 | Rush | Indiana | 18139 | 4894 | 57 |
2275778 | 2275778 | 2022-03-05 | Rush | Indiana | 18139 | 4894 | 57 |
2272525 | 2272525 | 2022-03-04 | Rush | Indiana | 18139 | 4894 | 57 |
2269273 | 2269273 | 2022-03-03 | Rush | Indiana | 18139 | 4891 | 56 |
2266020 | 2266020 | 2022-03-02 | Rush | Indiana | 18139 | 4887 | 56 |
2262769 | 2262769 | 2022-03-01 | Rush | Indiana | 18139 | 4886 | 56 |
2259518 | 2259518 | 2022-02-28 | Rush | Indiana | 18139 | 4885 | 56 |
2256267 | 2256267 | 2022-02-27 | Rush | Indiana | 18139 | 4872 | 56 |
2253016 | 2253016 | 2022-02-26 | Rush | Indiana | 18139 | 4872 | 56 |
2249765 | 2249765 | 2022-02-25 | Rush | Indiana | 18139 | 4872 | 56 |
2246514 | 2246514 | 2022-02-24 | Rush | Indiana | 18139 | 4871 | 55 |
2243263 | 2243263 | 2022-02-23 | Rush | Indiana | 18139 | 4870 | 55 |
2240012 | 2240012 | 2022-02-22 | Rush | Indiana | 18139 | 4864 | 55 |
2236761 | 2236761 | 2022-02-21 | Rush | Indiana | 18139 | 4858 | 55 |
2233510 | 2233510 | 2022-02-20 | Rush | Indiana | 18139 | 4852 | 54 |
2230259 | 2230259 | 2022-02-19 | Rush | Indiana | 18139 | 4852 | 54 |
2227008 | 2227008 | 2022-02-18 | Rush | Indiana | 18139 | 4852 | 54 |
2223757 | 2223757 | 2022-02-17 | Rush | Indiana | 18139 | 4846 | 52 |
2220506 | 2220506 | 2022-02-16 | Rush | Indiana | 18139 | 4840 | 52 |
2217255 | 2217255 | 2022-02-15 | Rush | Indiana | 18139 | 4837 | 51 |
2214004 | 2214004 | 2022-02-14 | Rush | Indiana | 18139 | 4830 | 50 |
2210752 | 2210752 | 2022-02-13 | Rush | Indiana | 18139 | 4815 | 50 |
2207499 | 2207499 | 2022-02-12 | Rush | Indiana | 18139 | 4815 | 50 |
2204246 | 2204246 | 2022-02-11 | Rush | Indiana | 18139 | 4815 | 50 |
2200993 | 2200993 | 2022-02-10 | Rush | Indiana | 18139 | 4814 | 50 |
2197739 | 2197739 | 2022-02-09 | Rush | Indiana | 18139 | 4781 | 50 |
2194485 | 2194485 | 2022-02-08 | Rush | Indiana | 18139 | 4781 | 50 |
2191231 | 2191231 | 2022-02-07 | Rush | Indiana | 18139 | 4768 | 49 |
2187978 | 2187978 | 2022-02-06 | Rush | Indiana | 18139 | 4750 | 47 |
2184725 | 2184725 | 2022-02-05 | Rush | Indiana | 18139 | 4750 | 47 |
2181473 | 2181473 | 2022-02-04 | Rush | Indiana | 18139 | 4750 | 47 |
2178222 | 2178222 | 2022-02-03 | Rush | Indiana | 18139 | 4717 | 46 |
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);