ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
103 rows where date = "2022-04-29" and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2454578 | 2454578 | 2022-04-29 | Adams | Illinois | 17001 | 22407 | 238 |
2454579 | 2454579 | 2022-04-29 | Alexander | Illinois | 17003 | 1286 | 15 |
2454580 | 2454580 | 2022-04-29 | Bond | Illinois | 17005 | 4351 | 37 |
2454581 | 2454581 | 2022-04-29 | Boone | Illinois | 17007 | 13944 | 129 |
2454582 | 2454582 | 2022-04-29 | Brown | Illinois | 17009 | 2419 | 21 |
2454583 | 2454583 | 2022-04-29 | Bureau | Illinois | 17011 | 8396 | 140 |
2454584 | 2454584 | 2022-04-29 | Calhoun | Illinois | 17013 | 1526 | 8 |
2454585 | 2454585 | 2022-04-29 | Carroll | Illinois | 17015 | 4271 | 49 |
2454586 | 2454586 | 2022-04-29 | Cass | Illinois | 17017 | 4622 | 44 |
2454587 | 2454587 | 2022-04-29 | Champaign | Illinois | 17019 | 65310 | 296 |
2454588 | 2454588 | 2022-04-29 | Christian | Illinois | 17021 | 10274 | 129 |
2454589 | 2454589 | 2022-04-29 | Clark | Illinois | 17023 | 4865 | 60 |
2454590 | 2454590 | 2022-04-29 | Clay | Illinois | 17025 | 4742 | 74 |
2454591 | 2454591 | 2022-04-29 | Clinton | Illinois | 17027 | 12000 | 122 |
2454592 | 2454592 | 2022-04-29 | Coles | Illinois | 17029 | 15419 | 175 |
2454593 | 2454593 | 2022-04-29 | Cook | Illinois | 17031 | 1161686 | 14904 |
2454594 | 2454594 | 2022-04-29 | Crawford | Illinois | 17033 | 6214 | 61 |
2454595 | 2454595 | 2022-04-29 | Cumberland | Illinois | 17035 | 3368 | 49 |
2454596 | 2454596 | 2022-04-29 | De Witt | Illinois | 17039 | 4362 | 44 |
2454597 | 2454597 | 2022-04-29 | DeKalb | Illinois | 17037 | 23837 | 200 |
2454598 | 2454598 | 2022-04-29 | Douglas | Illinois | 17041 | 6520 | 61 |
2454599 | 2454599 | 2022-04-29 | DuPage | Illinois | 17043 | 216749 | 1796 |
2454600 | 2454600 | 2022-04-29 | Edgar | Illinois | 17045 | 5191 | 79 |
2454601 | 2454601 | 2022-04-29 | Edwards | Illinois | 17047 | 1743 | 29 |
2454602 | 2454602 | 2022-04-29 | Effingham | Illinois | 17049 | 10687 | 148 |
2454603 | 2454603 | 2022-04-29 | Fayette | Illinois | 17051 | 7123 | 104 |
2454604 | 2454604 | 2022-04-29 | Ford | Illinois | 17053 | 4452 | 74 |
2454605 | 2454605 | 2022-04-29 | Franklin | Illinois | 17055 | 12239 | 177 |
2454606 | 2454606 | 2022-04-29 | Fulton | Illinois | 17057 | 10139 | 135 |
2454607 | 2454607 | 2022-04-29 | Gallatin | Illinois | 17059 | 1408 | 18 |
2454608 | 2454608 | 2022-04-29 | Greene | Illinois | 17061 | 3622 | 58 |
2454609 | 2454609 | 2022-04-29 | Grundy | Illinois | 17063 | 12820 | 140 |
2454610 | 2454610 | 2022-04-29 | Hamilton | Illinois | 17065 | 2179 | 34 |
2454611 | 2454611 | 2022-04-29 | Hancock | Illinois | 17067 | 4396 | 58 |
2454612 | 2454612 | 2022-04-29 | Hardin | Illinois | 17069 | 1054 | 20 |
2454613 | 2454613 | 2022-04-29 | Henderson | Illinois | 17071 | 1153 | 28 |
2454614 | 2454614 | 2022-04-29 | Henry | Illinois | 17073 | 12768 | 149 |
2454615 | 2454615 | 2022-04-29 | Iroquois | Illinois | 17075 | 7230 | 117 |
2454616 | 2454616 | 2022-04-29 | Jackson | Illinois | 17077 | 15646 | 130 |
2454617 | 2454617 | 2022-04-29 | Jasper | Illinois | 17079 | 2681 | 32 |
2454618 | 2454618 | 2022-04-29 | Jefferson | Illinois | 17081 | 11124 | 176 |
2454619 | 2454619 | 2022-04-29 | Jersey | Illinois | 17083 | 6272 | 91 |
2454620 | 2454620 | 2022-04-29 | Jo Daviess | Illinois | 17085 | 4057 | 39 |
2454621 | 2454621 | 2022-04-29 | Johnson | Illinois | 17087 | 4479 | 46 |
2454622 | 2454622 | 2022-04-29 | Kane | Illinois | 17089 | 128685 | 1177 |
2454623 | 2454623 | 2022-04-29 | Kankakee | Illinois | 17091 | 29027 | 373 |
2454624 | 2454624 | 2022-04-29 | Kendall | Illinois | 17093 | 31600 | 170 |
2454625 | 2454625 | 2022-04-29 | Knox | Illinois | 17095 | 12611 | 246 |
2454626 | 2454626 | 2022-04-29 | LaSalle | Illinois | 17099 | 29216 | 440 |
2454627 | 2454627 | 2022-04-29 | Lake | Illinois | 17097 | 154116 | 1461 |
2454628 | 2454628 | 2022-04-29 | Lawrence | Illinois | 17101 | 5489 | 52 |
2454629 | 2454629 | 2022-04-29 | Lee | Illinois | 17103 | 8881 | 118 |
2454630 | 2454630 | 2022-04-29 | Livingston | Illinois | 17105 | 10812 | 148 |
2454631 | 2454631 | 2022-04-29 | Logan | Illinois | 17107 | 9658 | 100 |
2454632 | 2454632 | 2022-04-29 | Macon | Illinois | 17115 | 30790 | 354 |
2454633 | 2454633 | 2022-04-29 | Macoupin | Illinois | 17117 | 12858 | 171 |
2454634 | 2454634 | 2022-04-29 | Madison | Illinois | 17119 | 70817 | 865 |
2454635 | 2454635 | 2022-04-29 | Marion | Illinois | 17121 | 11901 | 217 |
2454636 | 2454636 | 2022-04-29 | Marshall | Illinois | 17123 | 2781 | 33 |
2454637 | 2454637 | 2022-04-29 | Mason | Illinois | 17125 | 3920 | 61 |
2454638 | 2454638 | 2022-04-29 | Massac | Illinois | 17127 | 3882 | 71 |
2454639 | 2454639 | 2022-04-29 | McDonough | Illinois | 17109 | 7251 | 104 |
2454640 | 2454640 | 2022-04-29 | McHenry | Illinois | 17111 | 77298 | 509 |
2454641 | 2454641 | 2022-04-29 | McLean | Illinois | 17113 | 51100 | 329 |
2454642 | 2454642 | 2022-04-29 | Menard | Illinois | 17129 | 3531 | 24 |
2454643 | 2454643 | 2022-04-29 | Mercer | Illinois | 17131 | 4040 | 47 |
2454644 | 2454644 | 2022-04-29 | Monroe | Illinois | 17133 | 9545 | 127 |
2454645 | 2454645 | 2022-04-29 | Montgomery | Illinois | 17135 | 9828 | 111 |
2454646 | 2454646 | 2022-04-29 | Morgan | Illinois | 17137 | 9565 | 144 |
2454647 | 2454647 | 2022-04-29 | Moultrie | Illinois | 17139 | 4081 | 52 |
2454648 | 2454648 | 2022-04-29 | Ogle | Illinois | 17141 | 14104 | 136 |
2454649 | 2454649 | 2022-04-29 | Peoria | Illinois | 17143 | 47108 | 555 |
2454650 | 2454650 | 2022-04-29 | Perry | Illinois | 17145 | 7481 | 106 |
2454651 | 2454651 | 2022-04-29 | Piatt | Illinois | 17147 | 4522 | 29 |
2454652 | 2454652 | 2022-04-29 | Pike | Illinois | 17149 | 5038 | 70 |
2454653 | 2454653 | 2022-04-29 | Pope | Illinois | 17151 | 960 | 8 |
2454654 | 2454654 | 2022-04-29 | Pulaski | Illinois | 17153 | 1727 | 19 |
2454655 | 2454655 | 2022-04-29 | Putnam | Illinois | 17155 | 1151 | 10 |
2454656 | 2454656 | 2022-04-29 | Randolph | Illinois | 17157 | 10506 | 131 |
2454657 | 2454657 | 2022-04-29 | Richland | Illinois | 17159 | 5162 | 83 |
2454658 | 2454658 | 2022-04-29 | Rock Island | Illinois | 17161 | 33407 | 521 |
2454659 | 2454659 | 2022-04-29 | Saline | Illinois | 17165 | 7894 | 111 |
2454660 | 2454660 | 2022-04-29 | Sangamon | Illinois | 17167 | 55595 | 432 |
2454661 | 2454661 | 2022-04-29 | Schuyler | Illinois | 17169 | 1964 | 29 |
2454662 | 2454662 | 2022-04-29 | Scott | Illinois | 17171 | 1264 | 12 |
2454663 | 2454663 | 2022-04-29 | Shelby | Illinois | 17173 | 6240 | 80 |
2454664 | 2454664 | 2022-04-29 | St. Clair | Illinois | 17163 | 69841 | 774 |
2454665 | 2454665 | 2022-04-29 | Stark | Illinois | 17175 | 1518 | 33 |
2454666 | 2454666 | 2022-04-29 | Stephenson | Illinois | 17177 | 11553 | 176 |
2454667 | 2454667 | 2022-04-29 | Tazewell | Illinois | 17179 | 37091 | 498 |
2454668 | 2454668 | 2022-04-29 | Union | Illinois | 17181 | 5383 | 68 |
2454669 | 2454669 | 2022-04-29 | Unknown | Illinois | 0 | 2254 | |
2454670 | 2454670 | 2022-04-29 | Vermilion | Illinois | 17183 | 28066 | 313 |
2454671 | 2454671 | 2022-04-29 | Wabash | Illinois | 17185 | 3718 | 31 |
2454672 | 2454672 | 2022-04-29 | Warren | Illinois | 17187 | 4052 | 87 |
2454673 | 2454673 | 2022-04-29 | Washington | Illinois | 17189 | 3436 | 41 |
2454674 | 2454674 | 2022-04-29 | Wayne | Illinois | 17191 | 5304 | 85 |
2454675 | 2454675 | 2022-04-29 | White | Illinois | 17193 | 4405 | 59 |
2454676 | 2454676 | 2022-04-29 | Whiteside | Illinois | 17195 | 15527 | 267 |
2454677 | 2454677 | 2022-04-29 | Will | Illinois | 17197 | 165378 | 1607 |
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);