ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
103 rows where date = "2021-08-21" 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 |
---|---|---|---|---|---|---|---|
1638534 | 1638534 | 2021-08-21 | Adams | Illinois | 17001 | 11047 | 164 |
1638535 | 1638535 | 2021-08-21 | Alexander | Illinois | 17003 | 560 | 11 |
1638536 | 1638536 | 2021-08-21 | Bond | Illinois | 17005 | 2224 | 29 |
1638537 | 1638537 | 2021-08-21 | Boone | Illinois | 17007 | 7164 | 93 |
1638538 | 1638538 | 2021-08-21 | Brown | Illinois | 17009 | 935 | 12 |
1638539 | 1638539 | 2021-08-21 | Bureau | Illinois | 17011 | 3985 | 99 |
1638540 | 1638540 | 2021-08-21 | Calhoun | Illinois | 17013 | 581 | 5 |
1638541 | 1638541 | 2021-08-21 | Carroll | Illinois | 17015 | 2101 | 38 |
1638542 | 1638542 | 2021-08-21 | Cass | Illinois | 17017 | 2232 | 36 |
1638543 | 1638543 | 2021-08-21 | Champaign | Illinois | 17019 | 23169 | 174 |
1638544 | 1638544 | 2021-08-21 | Christian | Illinois | 17021 | 4289 | 95 |
1638545 | 1638545 | 2021-08-21 | Clark | Illinois | 17023 | 2077 | 44 |
1638546 | 1638546 | 2021-08-21 | Clay | Illinois | 17025 | 1828 | 48 |
1638547 | 1638547 | 2021-08-21 | Clinton | Illinois | 17027 | 6271 | 102 |
1638548 | 1638548 | 2021-08-21 | Coles | Illinois | 17029 | 6288 | 104 |
1638549 | 1638549 | 2021-08-21 | Cook | Illinois | 17031 | 581027 | 11222 |
1638550 | 1638550 | 2021-08-21 | Crawford | Illinois | 17033 | 2593 | 43 |
1638551 | 1638551 | 2021-08-21 | Cumberland | Illinois | 17035 | 1368 | 32 |
1638552 | 1638552 | 2021-08-21 | De Witt | Illinois | 17039 | 1713 | 36 |
1638553 | 1638553 | 2021-08-21 | DeKalb | Illinois | 17037 | 10937 | 128 |
1638554 | 1638554 | 2021-08-21 | Douglas | Illinois | 17041 | 2780 | 42 |
1638555 | 1638555 | 2021-08-21 | DuPage | Illinois | 17043 | 97397 | 1413 |
1638556 | 1638556 | 2021-08-21 | Edgar | Illinois | 17045 | 1897 | 62 |
1638557 | 1638557 | 2021-08-21 | Edwards | Illinois | 17047 | 742 | 14 |
1638558 | 1638558 | 2021-08-21 | Effingham | Illinois | 17049 | 5006 | 86 |
1638559 | 1638559 | 2021-08-21 | Fayette | Illinois | 17051 | 3395 | 59 |
1638560 | 1638560 | 2021-08-21 | Ford | Illinois | 17053 | 2055 | 60 |
1638561 | 1638561 | 2021-08-21 | Franklin | Illinois | 17055 | 5641 | 95 |
1638562 | 1638562 | 2021-08-21 | Fulton | Illinois | 17057 | 4361 | 69 |
1638563 | 1638563 | 2021-08-21 | Gallatin | Illinois | 17059 | 588 | 5 |
1638564 | 1638564 | 2021-08-21 | Greene | Illinois | 17061 | 1725 | 48 |
1638565 | 1638565 | 2021-08-21 | Grundy | Illinois | 17063 | 6387 | 83 |
1638566 | 1638566 | 2021-08-21 | Hamilton | Illinois | 17065 | 1019 | 19 |
1638567 | 1638567 | 2021-08-21 | Hancock | Illinois | 17067 | 2170 | 43 |
1638568 | 1638568 | 2021-08-21 | Hardin | Illinois | 17069 | 480 | 12 |
1638569 | 1638569 | 2021-08-21 | Henderson | Illinois | 17071 | 565 | 23 |
1638570 | 1638570 | 2021-08-21 | Henry | Illinois | 17073 | 5395 | 99 |
1638571 | 1638571 | 2021-08-21 | Iroquois | Illinois | 17075 | 3461 | 71 |
1638572 | 1638572 | 2021-08-21 | Jackson | Illinois | 17077 | 6387 | 80 |
1638573 | 1638573 | 2021-08-21 | Jasper | Illinois | 17079 | 1237 | 20 |
1638574 | 1638574 | 2021-08-21 | Jefferson | Illinois | 17081 | 5159 | 126 |
1638575 | 1638575 | 2021-08-21 | Jersey | Illinois | 17083 | 2965 | 71 |
1638576 | 1638576 | 2021-08-21 | Jo Daviess | Illinois | 17085 | 1909 | 27 |
1638577 | 1638577 | 2021-08-21 | Johnson | Illinois | 17087 | 1771 | 25 |
1638578 | 1638578 | 2021-08-21 | Kane | Illinois | 17089 | 62111 | 874 |
1638579 | 1638579 | 2021-08-21 | Kankakee | Illinois | 17091 | 15290 | 232 |
1638580 | 1638580 | 2021-08-21 | Kendall | Illinois | 17093 | 14682 | 110 |
1638581 | 1638581 | 2021-08-21 | Knox | Illinois | 17095 | 5965 | 188 |
1638582 | 1638582 | 2021-08-21 | LaSalle | Illinois | 17099 | 13418 | 319 |
1638583 | 1638583 | 2021-08-21 | Lake | Illinois | 17097 | 71889 | 1103 |
1638584 | 1638584 | 2021-08-21 | Lawrence | Illinois | 17101 | 2611 | 38 |
1638585 | 1638585 | 2021-08-21 | Lee | Illinois | 17103 | 4319 | 95 |
1638586 | 1638586 | 2021-08-21 | Livingston | Illinois | 17105 | 5126 | 106 |
1638587 | 1638587 | 2021-08-21 | Logan | Illinois | 17107 | 4379 | 80 |
1638588 | 1638588 | 2021-08-21 | Macon | Illinois | 17115 | 12143 | 226 |
1638589 | 1638589 | 2021-08-21 | Macoupin | Illinois | 17117 | 5432 | 122 |
1638590 | 1638590 | 2021-08-21 | Madison | Illinois | 17119 | 34848 | 618 |
1638591 | 1638591 | 2021-08-21 | Marion | Illinois | 17121 | 5514 | 132 |
1638592 | 1638592 | 2021-08-21 | Marshall | Illinois | 17123 | 1203 | 21 |
1638593 | 1638593 | 2021-08-21 | Mason | Illinois | 17125 | 1760 | 49 |
1638594 | 1638594 | 2021-08-21 | Massac | Illinois | 17127 | 1597 | 45 |
1638595 | 1638595 | 2021-08-21 | McDonough | Illinois | 17109 | 3283 | 64 |
1638596 | 1638596 | 2021-08-21 | McHenry | Illinois | 17111 | 30827 | 327 |
1638597 | 1638597 | 2021-08-21 | McLean | Illinois | 17113 | 19898 | 231 |
1638598 | 1638598 | 2021-08-21 | Menard | Illinois | 17129 | 1385 | 16 |
1638599 | 1638599 | 2021-08-21 | Mercer | Illinois | 17131 | 1617 | 34 |
1638600 | 1638600 | 2021-08-21 | Monroe | Illinois | 17133 | 4753 | 96 |
1638601 | 1638601 | 2021-08-21 | Montgomery | Illinois | 17135 | 4096 | 80 |
1638602 | 1638602 | 2021-08-21 | Morgan | Illinois | 17137 | 4536 | 117 |
1638603 | 1638603 | 2021-08-21 | Moultrie | Illinois | 17139 | 1772 | 37 |
1638604 | 1638604 | 2021-08-21 | Ogle | Illinois | 17141 | 6507 | 92 |
1638605 | 1638605 | 2021-08-21 | Peoria | Illinois | 17143 | 24469 | 379 |
1638606 | 1638606 | 2021-08-21 | Perry | Illinois | 17145 | 3630 | 74 |
1638607 | 1638607 | 2021-08-21 | Piatt | Illinois | 17147 | 1687 | 20 |
1638608 | 1638608 | 2021-08-21 | Pike | Illinois | 17149 | 2272 | 57 |
1638609 | 1638609 | 2021-08-21 | Pope | Illinois | 17151 | 387 | 4 |
1638610 | 1638610 | 2021-08-21 | Pulaski | Illinois | 17153 | 830 | 9 |
1638611 | 1638611 | 2021-08-21 | Putnam | Illinois | 17155 | 513 | 4 |
1638612 | 1638612 | 2021-08-21 | Randolph | Illinois | 17157 | 4784 | 96 |
1638613 | 1638613 | 2021-08-21 | Richland | Illinois | 17159 | 2045 | 56 |
1638614 | 1638614 | 2021-08-21 | Rock Island | Illinois | 17161 | 16132 | 374 |
1638615 | 1638615 | 2021-08-21 | Saline | Illinois | 17165 | 3121 | 74 |
1638616 | 1638616 | 2021-08-21 | Sangamon | Illinois | 17167 | 21674 | 291 |
1638617 | 1638617 | 2021-08-21 | Schuyler | Illinois | 17169 | 884 | 19 |
1638618 | 1638618 | 2021-08-21 | Scott | Illinois | 17171 | 613 | 2 |
1638619 | 1638619 | 2021-08-21 | Shelby | Illinois | 17173 | 2508 | 42 |
1638620 | 1638620 | 2021-08-21 | St. Clair | Illinois | 17163 | 35874 | 583 |
1638621 | 1638621 | 2021-08-21 | Stark | Illinois | 17175 | 695 | 26 |
1638622 | 1638622 | 2021-08-21 | Stephenson | Illinois | 17177 | 5036 | 106 |
1638623 | 1638623 | 2021-08-21 | Tazewell | Illinois | 17179 | 18311 | 346 |
1638624 | 1638624 | 2021-08-21 | Union | Illinois | 17181 | 2724 | 46 |
1638625 | 1638625 | 2021-08-21 | Unknown | Illinois | 0 | 480 | |
1638626 | 1638626 | 2021-08-21 | Vermilion | Illinois | 17183 | 11251 | 175 |
1638627 | 1638627 | 2021-08-21 | Wabash | Illinois | 17185 | 1681 | 15 |
1638628 | 1638628 | 2021-08-21 | Warren | Illinois | 17187 | 1951 | 53 |
1638629 | 1638629 | 2021-08-21 | Washington | Illinois | 17189 | 1859 | 31 |
1638630 | 1638630 | 2021-08-21 | Wayne | Illinois | 17191 | 2155 | 55 |
1638631 | 1638631 | 2021-08-21 | White | Illinois | 17193 | 2056 | 37 |
1638632 | 1638632 | 2021-08-21 | Whiteside | Illinois | 17195 | 7520 | 216 |
1638633 | 1638633 | 2021-08-21 | Will | Illinois | 17197 | 81616 | 1126 |
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);