ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where fips = 17043 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 681 ✖
- 116025 5
- 92595 4
- 100436 4
- 106401 4
- 132440 4
- 142738 4
- 174516 4
- 202077 4
- 204194 4
- 92368 3
- 92473 3
- 92713 3
- 92920 3
- 93353 3
- 94007 3
- 94926 3
- 96160 3
- 97397 3
- 98780 3
- 101781 3
- 103152 3
- 104268 3
- 105273 3
- 107465 3
- 108621 3
- 109707 3
- 111030 3
- 112586 3
- 114540 3
- 119376 3
- 122720 3
- 126654 3
- 159801 3
- 187028 3
- 196061 3
- 200020 3
- 205241 3
- 206102 3
- 206949 3
- 207916 3
- 208874 3
- 209648 3
- 210607 3
- 212040 3
- 214147 3
- 216749 3
- 220393 3
- 1 2
- 24696 2
- 61805 2
- 92446 2
- 112094 2
- 198539 2
- 5 1
- 26 1
- 45 1
- 54 1
- 57 1
- 68 1
- 79 1
- 95 1
- 103 1
- 131 1
- 182 1
- 199 1
- 202 1
- 274 1
- 320 1
- 356 1
- 392 1
- 448 1
- 500 1
- 590 1
- 656 1
- 715 1
- 795 1
- 875 1
- 943 1
- 1008 1
- 1048 1
- 1162 1
- 1223 1
- 1312 1
- 1386 1
- 1463 1
- 1560 1
- 1642 1
- 1695 1
- 1761 1
- 1864 1
- 1947 1
- 2047 1
- 2219 1
- 2311 1
- 2443 1
- 2628 1
- 2736 1
- 2870 1
- 3081 1
- 3256 1
- 3432 1
- 3611 1
- 3803 1
- 3918 1
- 4056 1
- 4213 1
- 4374 1
- 4493 1
- 4603 1
- 4745 1
- 5121 1
- 5244 1
- 5453 1
- 5634 1
- 5780 1
- 5904 1
- 6076 1
- 6171 1
- 6308 1
- 6471 1
- 6744 1
- 6891 1
- 7063 1
- 7207 1
- 7305 1
- 7369 1
- 7479 1
- 7564 1
- 7640 1
- 7717 1
- 7773 1
- 7838 1
- 7915 1
- 7947 1
- 8003 1
- 8070 1
- 8120 1
- 8157 1
- 8223 1
- 8263 1
- 8318 1
- 8360 1
- 8402 1
- 8434 1
- 8465 1
- 8501 1
- 8546 1
- 8575 1
- 8611 1
- 8648 1
- 8684 1
- 8716 1
- 8742 1
- 8782 1
- 8829 1
- 8879 1
- 8922 1
- 8951 1
- 8996 1
- 9036 1
- 9086 1
- 9147 1
- 9209 1
- 9276 1
- 9315 1
- 9364 1
- 9395 1
- 9457 1
- 9507 1
- 9571 1
- 9641 1
- 9721 1
- 9794 1
- 9810 1
- 9867 1
- 9917 1
- 10020 1
- 10107 1
- 10196 1
- 10317 1
- 10414 1
- 10531 1
- 10627 1
- 10705 1
- 10771 1
- 10880 1
- 10953 1
- 11005 1
- 11084 1
- 11177 1
- 11267 1
- 11380 1
- 11470 1
- 11558 1
- 11689 1
- 11804 1
- 11926 1
- 12021 1
- 12155 1
- 12233 1
- 12312 1
- 12427 1
- 12511 1
- 12592 1
- 12693 1
- 12815 1
- 12892 1
- 13032 1
- 13151 1
- 13289 1
- 13410 1
- 13530 1
- 13686 1
- 13778 1
- 13909 1
- 14001 1
- 14103 1
- 14200 1
- 14299 1
- 14398 1
- 14493 1
- 14615 1
- 14679 1
- 14770 1
- 14840 1
- 15109 1
- 15247 1
- 15322 1
- 15385 1
- 15499 1
- 15592 1
- 15704 1
- 15826 1
- 15938 1
- 16022 1
- 16123 1
- 16209 1
- 16304 1
- 16374 1
- 16488 1
- 16622 1
- 16694 1
- 16799 1
- 16883 1
- 16955 1
- 17091 1
- 17253 1
- 17393 1
- 17471 1
- 17589 1
- 17690 1
- 17786 1
- 17873 1
- 18021 1
- 18129 1
- 18209 1
- 18305 1
- 18414 1
- 18583 1
- 18788 1
- 18985 1
- 19156 1
- 19310 1
- 19467 1
- 19640 1
- 19767 1
- 19967 1
- 20277 1
- 20477 1
- 20724 1
- 20947 1
- 21231 1
- 21470 1
- 21776 1
- 22100 1
- 22546 1
- 22783 1
- 23099 1
- 23408 1
- 23780 1
- 24240 1
- 25681 1
- 26065 1
- 26512 1
- 27065 1
- 27584 1
- 28834 1
- 29541 1
- 30244 1
- 30977 1
- 31830 1
- 32487 1
- 33102 1
- 33851 1
- 34607 1
- 35284 1
- 35878 1
- 36941 1
- 37632 1
- 38670 1
- 39547 1
- 40314 1
- 41006 1
- 41602 1
- 42201 1
- 42881 1
- 43513 1
- 44035 1
- 44656 1
- 45087 1
- 45446 1
- 47179 1
- 47742 1
- 48499 1
- 49311 1
- 49976 1
- 50484 1
- 51051 1
- 51672 1
- 52300 1
- 52882 1
- 53456 1
- 54080 1
- 54533 1
- 55013 1
- 55495 1
- 55941 1
- 56512 1
- 56881 1
- 57421 1
- 57784 1
- 58048 1
- 58402 1
- 58741 1
- 59212 1
- 59577 1
- 59758 1
- 60077 1
- 60473 1
- 60839 1
- 61271 1
- 62676 1
- 63022 1
- 63396 1
- 63831 1
- 64259 1
- 64755 1
- 65385 1
- 65784 1
- 66084 1
- 66414 1
- 66858 1
- 67271 1
- 67651 1
- 68156 1
- 68534 1
- 68737 1
- 68970 1
- 69285 1
- 69579 1
- 69900 1
- 70324 1
- 70712 1
- 70890 1
- 71070 1
- 71323 1
- 71529 1
- 71819 1
- 72068 1
- 72279 1
- 72454 1
- 72610 1
- 72732 1
- 72945 1
- 73167 1
- 73399 1
- 73602 1
- 73692 1
- 73832 1
- 73981 1
- 74151 1
- 74406 1
- 74578 1
- 74742 1
- 74877 1
- 74991 1
- 75140 1
- 75281 1
- 75419 1
- 75587 1
- 75701 1
- 75826 1
- 76009 1
- 76156 1
- 76287 1
- 76398 1
- 76542 1
- 76659 1
- 76765 1
- 76871 1
- 77025 1
- 77279 1
- 77406 1
- 77506 1
- 77796 1
- 77882 1
- 77960 1
- 78098 1
- 78207 1
- 78341 1
- 78450 1
- 78589 1
- 78889 1
- 79010 1
- 79165 1
- 79328 1
- 79511 1
- 79730 1
- 79898 1
- 79994 1
- 80121 1
- 80285 1
- 80560 1
- 80728 1
- 80980 1
- 81165 1
- 81323 1
- 81487 1
- 81698 1
- 81889 1
- 82163 1
- 82391 1
- 82635 1
- 82864 1
- 83031 1
- 83350 1
- 83637 1
- 83927 1
- 84261 1
- 84570 1
- 84777 1
- 85016 1
- 85272 1
- 85523 1
- 85799 1
- 85994 1
- 86225 1
- 86397 1
- 86547 1
- 86723 1
- 86921 1
- 87172 1
- 87430 1
- 87668 1
- 87807 1
- 87994 1
- 88158 1
- 88323 1
- 88519 1
- 88752 1
- 88941 1
- 89043 1
- 89180 1
- 89343 1
- 89505 1
- 89618 1
- 89821 1
- 89941 1
- 90032 1
- 90140 1
- 90266 1
- 90387 1
- 90503 1
- 90628 1
- 90731 1
- 90799 1
- 90835 1
- 90946 1
- 91075 1
- 91170 1
- 91288 1
- 91352 1
- 91423 1
- 91498 1
- 91548 1
- 91623 1
- 91658 1
- 91717 1
- 91771 1
- 91814 1
- 91860 1
- 91893 1
- 91907 1
- 91981 1
- 92068 1
- 92132 1
- 92142 1
- 92170 1
- 92213 1
- 92249 1
- 92264 1
- 92281 1
- 92297 1
- 92309 1
- 92318 1
- 92328 1
- 92351 1
- 92362 1
- 92413 1
- 92425 1
- 92547 1
- 92561 1
- 92565 1
- 92579 1
- 92651 1
- 92668 1
- 92688 1
- 92788 1
- 92808 1
- 92846 1
- 92888 1
- 93057 1
- 93095 1
- 93155 1
- 93274 1
- 93568 1
- 93641 1
- 93753 1
- 93852 1
- 94295 1
- 94445 1
- 94558 1
- 94782 1
- 95374 1
- 95529 1
- 95750 1
- 95914 1
- 96689 1
- 96851 1
- 96987 1
- 97141 1
- 97864 1
- 98022 1
- 98245 1
- 98462 1
- 99315 1
- 99590 1
- 99854 1
- 100120 1
- 101096 1
- 101319 1
- 101493 1
- 102230 1
- 102512 1
- 102689 1
- 102939 1
- 103580 1
- 103738 1
- 103917 1
- 104074 1
- 104661 1
- 104762 1
- 104910 1
- 105071 1
- 105694 1
- 105921 1
- 106076 1
- 106259 1
- 106932 1
- 107150 1
- 107312 1
- 107803 1
- 107962 1
- 108127 1
- 108322 1
- 108983 1
- 109167 1
- 109320 1
- 109481 1
- 110185 1
- 110357 1
- 110504 1
- 110799 1
- 111581 1
- 111728 1
- 113228 1
- 113440 1
- 113752 1
- 114154 1
- 115383 1
- 115663 1
- 117356 1
- 117788 1
- 118195 1
- 118871 1
- 120758 1
- 121183 1
- 121677 1
- 122278 1
- 123990 1
- 124480 1
- 125077 1
- 125867 1
- 128733 1
- 129527 1
- 130919 1
- 137174 1
- 138854 1
- 140447 1
- 150149 1
- 151681 1
- 153713 1
- 157094 1
- 165689 1
- 167764 1
- 170233 1
- 172571 1
- 181078 1
- 182650 1
- 183881 1
- 192468 1
- 193409 1
- 194360 1
- 195260 1
- 197510 1
- 198028 1
- 201174 1
- 201470 1
- 201773 1
- 203281 1
- 203531 1
- 203761 1
- 203938 1
- 204624 1
- 204842 1
- 205045 1
- 205611 1
- 205749 1
- 205873 1
- 205987 1
- 206388 1
- 206492 1
- 206604 1
- 206722 1
- 207207 1
- 207517 1
- 207613 1
- 207752 1
- 208217 1
- 208425 1
- 208560 1
- 208727 1
- 209111 1
- 209243 1
- 209364 1
- 209488 1
- 209943 1
- 210113 1
- 210284 1
- 210423 1
- 211029 1
- 211246 1
- 211415 1
- 211805 1
- 212610 1
- 212946 1
- 213313 1
- 213700 1
- 215045 1
- 215333 1
- 215700 1
- 216186 1
- 217928 1
- 218447 1
- 219075 1
- 219496 1
- 222090 1
- 222726 1
- 223271 1
- 223877 1
- 224631 1
state 1
- Illinois · 791 ✖
fips 1
- 17043 · 791 ✖
county 1
- DuPage 791
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500198 | 2500198 | 2022-05-13 | DuPage | Illinois | 17043 | 224631 | 1806 |
2496940 | 2496940 | 2022-05-12 | DuPage | Illinois | 17043 | 223877 | 1806 |
2493682 | 2493682 | 2022-05-11 | DuPage | Illinois | 17043 | 223271 | 1805 |
2490424 | 2490424 | 2022-05-10 | DuPage | Illinois | 17043 | 222726 | 1804 |
2487167 | 2487167 | 2022-05-09 | DuPage | Illinois | 17043 | 222090 | 1800 |
2483909 | 2483909 | 2022-05-08 | DuPage | Illinois | 17043 | 220393 | 1800 |
2480651 | 2480651 | 2022-05-07 | DuPage | Illinois | 17043 | 220393 | 1800 |
2477393 | 2477393 | 2022-05-06 | DuPage | Illinois | 17043 | 220393 | 1800 |
2474135 | 2474135 | 2022-05-05 | DuPage | Illinois | 17043 | 219496 | 1800 |
2470878 | 2470878 | 2022-05-04 | DuPage | Illinois | 17043 | 219075 | 1798 |
2467622 | 2467622 | 2022-05-03 | DuPage | Illinois | 17043 | 218447 | 1798 |
2464367 | 2464367 | 2022-05-02 | DuPage | Illinois | 17043 | 217928 | 1798 |
2461111 | 2461111 | 2022-05-01 | DuPage | Illinois | 17043 | 216749 | 1796 |
2457855 | 2457855 | 2022-04-30 | DuPage | Illinois | 17043 | 216749 | 1796 |
2454599 | 2454599 | 2022-04-29 | DuPage | Illinois | 17043 | 216749 | 1796 |
2451343 | 2451343 | 2022-04-28 | DuPage | Illinois | 17043 | 216186 | 1796 |
2448087 | 2448087 | 2022-04-27 | DuPage | Illinois | 17043 | 215700 | 1796 |
2444831 | 2444831 | 2022-04-26 | DuPage | Illinois | 17043 | 215333 | 1794 |
2441575 | 2441575 | 2022-04-25 | DuPage | Illinois | 17043 | 215045 | 1794 |
2438319 | 2438319 | 2022-04-24 | DuPage | Illinois | 17043 | 214147 | 1793 |
2435063 | 2435063 | 2022-04-23 | DuPage | Illinois | 17043 | 214147 | 1793 |
2431807 | 2431807 | 2022-04-22 | DuPage | Illinois | 17043 | 214147 | 1793 |
2428551 | 2428551 | 2022-04-21 | DuPage | Illinois | 17043 | 213700 | 1791 |
2425295 | 2425295 | 2022-04-20 | DuPage | Illinois | 17043 | 213313 | 1791 |
2422039 | 2422039 | 2022-04-19 | DuPage | Illinois | 17043 | 212946 | 1789 |
2418783 | 2418783 | 2022-04-18 | DuPage | Illinois | 17043 | 212610 | 1789 |
2415527 | 2415527 | 2022-04-17 | DuPage | Illinois | 17043 | 212040 | 1789 |
2412271 | 2412271 | 2022-04-16 | DuPage | Illinois | 17043 | 212040 | 1789 |
2409015 | 2409015 | 2022-04-15 | DuPage | Illinois | 17043 | 212040 | 1789 |
2405759 | 2405759 | 2022-04-14 | DuPage | Illinois | 17043 | 211805 | 1788 |
2402504 | 2402504 | 2022-04-13 | DuPage | Illinois | 17043 | 211415 | 1788 |
2399249 | 2399249 | 2022-04-12 | DuPage | Illinois | 17043 | 211246 | 1788 |
2395994 | 2395994 | 2022-04-11 | DuPage | Illinois | 17043 | 211029 | 1787 |
2392738 | 2392738 | 2022-04-10 | DuPage | Illinois | 17043 | 210607 | 1786 |
2389482 | 2389482 | 2022-04-09 | DuPage | Illinois | 17043 | 210607 | 1786 |
2386227 | 2386227 | 2022-04-08 | DuPage | Illinois | 17043 | 210607 | 1786 |
2382972 | 2382972 | 2022-04-07 | DuPage | Illinois | 17043 | 210423 | 1786 |
2379717 | 2379717 | 2022-04-06 | DuPage | Illinois | 17043 | 210284 | 1786 |
2376463 | 2376463 | 2022-04-05 | DuPage | Illinois | 17043 | 210113 | 1786 |
2373211 | 2373211 | 2022-04-04 | DuPage | Illinois | 17043 | 209943 | 1786 |
2369958 | 2369958 | 2022-04-03 | DuPage | Illinois | 17043 | 209648 | 1786 |
2366705 | 2366705 | 2022-04-02 | DuPage | Illinois | 17043 | 209648 | 1786 |
2363452 | 2363452 | 2022-04-01 | DuPage | Illinois | 17043 | 209648 | 1786 |
2360198 | 2360198 | 2022-03-31 | DuPage | Illinois | 17043 | 209488 | 1784 |
2356944 | 2356944 | 2022-03-30 | DuPage | Illinois | 17043 | 209364 | 1783 |
2353691 | 2353691 | 2022-03-29 | DuPage | Illinois | 17043 | 209243 | 1782 |
2350439 | 2350439 | 2022-03-28 | DuPage | Illinois | 17043 | 209111 | 1781 |
2347186 | 2347186 | 2022-03-27 | DuPage | Illinois | 17043 | 208874 | 1779 |
2343933 | 2343933 | 2022-03-26 | DuPage | Illinois | 17043 | 208874 | 1779 |
2340680 | 2340680 | 2022-03-25 | DuPage | Illinois | 17043 | 208874 | 1779 |
2337427 | 2337427 | 2022-03-24 | DuPage | Illinois | 17043 | 208727 | 1778 |
2334173 | 2334173 | 2022-03-23 | DuPage | Illinois | 17043 | 208560 | 1777 |
2330919 | 2330919 | 2022-03-22 | DuPage | Illinois | 17043 | 208425 | 1777 |
2327667 | 2327667 | 2022-03-21 | DuPage | Illinois | 17043 | 208217 | 1775 |
2324414 | 2324414 | 2022-03-20 | DuPage | Illinois | 17043 | 207916 | 1774 |
2321160 | 2321160 | 2022-03-19 | DuPage | Illinois | 17043 | 207916 | 1774 |
2317906 | 2317906 | 2022-03-18 | DuPage | Illinois | 17043 | 207916 | 1774 |
2314653 | 2314653 | 2022-03-17 | DuPage | Illinois | 17043 | 207752 | 1774 |
2311400 | 2311400 | 2022-03-16 | DuPage | Illinois | 17043 | 207613 | 1774 |
2308147 | 2308147 | 2022-03-15 | DuPage | Illinois | 17043 | 207517 | 1773 |
2304896 | 2304896 | 2022-03-14 | DuPage | Illinois | 17043 | 207207 | 1770 |
2301644 | 2301644 | 2022-03-13 | DuPage | Illinois | 17043 | 206949 | 1770 |
2298392 | 2298392 | 2022-03-12 | DuPage | Illinois | 17043 | 206949 | 1770 |
2295140 | 2295140 | 2022-03-11 | DuPage | Illinois | 17043 | 206949 | 1770 |
2291888 | 2291888 | 2022-03-10 | DuPage | Illinois | 17043 | 206722 | 1770 |
2288636 | 2288636 | 2022-03-09 | DuPage | Illinois | 17043 | 206604 | 1768 |
2285385 | 2285385 | 2022-03-08 | DuPage | Illinois | 17043 | 206492 | 1768 |
2282133 | 2282133 | 2022-03-07 | DuPage | Illinois | 17043 | 206388 | 1766 |
2278880 | 2278880 | 2022-03-06 | DuPage | Illinois | 17043 | 206102 | 1766 |
2275627 | 2275627 | 2022-03-05 | DuPage | Illinois | 17043 | 206102 | 1766 |
2272374 | 2272374 | 2022-03-04 | DuPage | Illinois | 17043 | 206102 | 1766 |
2269122 | 2269122 | 2022-03-03 | DuPage | Illinois | 17043 | 205987 | 1766 |
2265869 | 2265869 | 2022-03-02 | DuPage | Illinois | 17043 | 205873 | 1765 |
2262618 | 2262618 | 2022-03-01 | DuPage | Illinois | 17043 | 205749 | 1763 |
2259367 | 2259367 | 2022-02-28 | DuPage | Illinois | 17043 | 205611 | 1762 |
2256116 | 2256116 | 2022-02-27 | DuPage | Illinois | 17043 | 205241 | 1757 |
2252865 | 2252865 | 2022-02-26 | DuPage | Illinois | 17043 | 205241 | 1757 |
2249614 | 2249614 | 2022-02-25 | DuPage | Illinois | 17043 | 205241 | 1757 |
2246363 | 2246363 | 2022-02-24 | DuPage | Illinois | 17043 | 205045 | 1754 |
2243112 | 2243112 | 2022-02-23 | DuPage | Illinois | 17043 | 204842 | 1752 |
2239861 | 2239861 | 2022-02-22 | DuPage | Illinois | 17043 | 204624 | 1748 |
2236610 | 2236610 | 2022-02-21 | DuPage | Illinois | 17043 | 204194 | 1743 |
2233359 | 2233359 | 2022-02-20 | DuPage | Illinois | 17043 | 204194 | 1743 |
2230108 | 2230108 | 2022-02-19 | DuPage | Illinois | 17043 | 204194 | 1743 |
2226857 | 2226857 | 2022-02-18 | DuPage | Illinois | 17043 | 204194 | 1743 |
2223606 | 2223606 | 2022-02-17 | DuPage | Illinois | 17043 | 203938 | 1743 |
2220355 | 2220355 | 2022-02-16 | DuPage | Illinois | 17043 | 203761 | 1738 |
2217104 | 2217104 | 2022-02-15 | DuPage | Illinois | 17043 | 203531 | 1733 |
2213853 | 2213853 | 2022-02-14 | DuPage | Illinois | 17043 | 203281 | 1733 |
2210601 | 2210601 | 2022-02-13 | DuPage | Illinois | 17043 | 202077 | 1723 |
2207348 | 2207348 | 2022-02-12 | DuPage | Illinois | 17043 | 202077 | 1723 |
2204095 | 2204095 | 2022-02-11 | DuPage | Illinois | 17043 | 202077 | 1723 |
2200842 | 2200842 | 2022-02-10 | DuPage | Illinois | 17043 | 202077 | 1723 |
2197588 | 2197588 | 2022-02-09 | DuPage | Illinois | 17043 | 201773 | 1719 |
2194334 | 2194334 | 2022-02-08 | DuPage | Illinois | 17043 | 201470 | 1711 |
2191080 | 2191080 | 2022-02-07 | DuPage | Illinois | 17043 | 201174 | 1709 |
2187827 | 2187827 | 2022-02-06 | DuPage | Illinois | 17043 | 200020 | 1696 |
2184574 | 2184574 | 2022-02-05 | DuPage | Illinois | 17043 | 200020 | 1696 |
2181322 | 2181322 | 2022-02-04 | DuPage | Illinois | 17043 | 200020 | 1696 |
2178071 | 2178071 | 2022-02-03 | DuPage | Illinois | 17043 | 198539 | 1679 |
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);