ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
103 rows where date = "2021-07-16" 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 |
---|---|---|---|---|---|---|---|
1521603 | 1521603 | 2021-07-16 | Adams | Illinois | 17001 | 9154 | 156 |
1521604 | 1521604 | 2021-07-16 | Alexander | Illinois | 17003 | 477 | 11 |
1521605 | 1521605 | 2021-07-16 | Bond | Illinois | 17005 | 2105 | 30 |
1521606 | 1521606 | 2021-07-16 | Boone | Illinois | 17007 | 6880 | 92 |
1521607 | 1521607 | 2021-07-16 | Brown | Illinois | 17009 | 787 | 12 |
1521608 | 1521608 | 2021-07-16 | Bureau | Illinois | 17011 | 3824 | 100 |
1521609 | 1521609 | 2021-07-16 | Calhoun | Illinois | 17013 | 532 | 5 |
1521610 | 1521610 | 2021-07-16 | Carroll | Illinois | 17015 | 1908 | 38 |
1521611 | 1521611 | 2021-07-16 | Cass | Illinois | 17017 | 2084 | 36 |
1521612 | 1521612 | 2021-07-16 | Champaign | Illinois | 17019 | 21273 | 165 |
1521613 | 1521613 | 2021-07-16 | Christian | Illinois | 17021 | 3892 | 93 |
1521614 | 1521614 | 2021-07-16 | Clark | Illinois | 17023 | 1885 | 42 |
1521615 | 1521615 | 2021-07-16 | Clay | Illinois | 17025 | 1524 | 48 |
1521616 | 1521616 | 2021-07-16 | Clinton | Illinois | 17027 | 5831 | 101 |
1521617 | 1521617 | 2021-07-16 | Coles | Illinois | 17029 | 5806 | 103 |
1521618 | 1521618 | 2021-07-16 | Cook | Illinois | 17031 | 558928 | 11094 |
1521619 | 1521619 | 2021-07-16 | Crawford | Illinois | 17033 | 2151 | 42 |
1521620 | 1521620 | 2021-07-16 | Cumberland | Illinois | 17035 | 1308 | 31 |
1521621 | 1521621 | 2021-07-16 | De Witt | Illinois | 17039 | 1592 | 36 |
1521622 | 1521622 | 2021-07-16 | DeKalb | Illinois | 17037 | 10429 | 126 |
1521623 | 1521623 | 2021-07-16 | Douglas | Illinois | 17041 | 2618 | 42 |
1521624 | 1521624 | 2021-07-16 | DuPage | Illinois | 17043 | 92920 | 1406 |
1521625 | 1521625 | 2021-07-16 | Edgar | Illinois | 17045 | 1775 | 62 |
1521626 | 1521626 | 2021-07-16 | Edwards | Illinois | 17047 | 601 | 13 |
1521627 | 1521627 | 2021-07-16 | Effingham | Illinois | 17049 | 4784 | 85 |
1521628 | 1521628 | 2021-07-16 | Fayette | Illinois | 17051 | 3234 | 59 |
1521629 | 1521629 | 2021-07-16 | Ford | Illinois | 17053 | 1909 | 58 |
1521630 | 1521630 | 2021-07-16 | Franklin | Illinois | 17055 | 4666 | 90 |
1521631 | 1521631 | 2021-07-16 | Fulton | Illinois | 17057 | 4067 | 67 |
1521632 | 1521632 | 2021-07-16 | Gallatin | Illinois | 17059 | 471 | 5 |
1521633 | 1521633 | 2021-07-16 | Greene | Illinois | 17061 | 1484 | 47 |
1521634 | 1521634 | 2021-07-16 | Grundy | Illinois | 17063 | 6014 | 83 |
1521635 | 1521635 | 2021-07-16 | Hamilton | Illinois | 17065 | 863 | 19 |
1521636 | 1521636 | 2021-07-16 | Hancock | Illinois | 17067 | 1865 | 41 |
1521637 | 1521637 | 2021-07-16 | Hardin | Illinois | 17069 | 393 | 12 |
1521638 | 1521638 | 2021-07-16 | Henderson | Illinois | 17071 | 532 | 23 |
1521639 | 1521639 | 2021-07-16 | Henry | Illinois | 17073 | 5093 | 99 |
1521640 | 1521640 | 2021-07-16 | Iroquois | Illinois | 17075 | 3212 | 70 |
1521641 | 1521641 | 2021-07-16 | Jackson | Illinois | 17077 | 5228 | 76 |
1521642 | 1521642 | 2021-07-16 | Jasper | Illinois | 17079 | 1167 | 20 |
1521643 | 1521643 | 2021-07-16 | Jefferson | Illinois | 17081 | 4556 | 123 |
1521644 | 1521644 | 2021-07-16 | Jersey | Illinois | 17083 | 2744 | 71 |
1521645 | 1521645 | 2021-07-16 | Jo Daviess | Illinois | 17085 | 1830 | 27 |
1521646 | 1521646 | 2021-07-16 | Johnson | Illinois | 17087 | 1502 | 22 |
1521647 | 1521647 | 2021-07-16 | Kane | Illinois | 17089 | 59746 | 867 |
1521648 | 1521648 | 2021-07-16 | Kankakee | Illinois | 17091 | 14674 | 231 |
1521649 | 1521649 | 2021-07-16 | Kendall | Illinois | 17093 | 13977 | 109 |
1521650 | 1521650 | 2021-07-16 | Knox | Illinois | 17095 | 5696 | 187 |
1521651 | 1521651 | 2021-07-16 | LaSalle | Illinois | 17099 | 12860 | 308 |
1521652 | 1521652 | 2021-07-16 | Lake | Illinois | 17097 | 68736 | 1096 |
1521653 | 1521653 | 2021-07-16 | Lawrence | Illinois | 17101 | 2419 | 36 |
1521654 | 1521654 | 2021-07-16 | Lee | Illinois | 17103 | 4209 | 93 |
1521655 | 1521655 | 2021-07-16 | Livingston | Illinois | 17105 | 4916 | 104 |
1521656 | 1521656 | 2021-07-16 | Logan | Illinois | 17107 | 4025 | 77 |
1521657 | 1521657 | 2021-07-16 | Macon | Illinois | 17115 | 11061 | 224 |
1521658 | 1521658 | 2021-07-16 | Macoupin | Illinois | 17117 | 4881 | 118 |
1521659 | 1521659 | 2021-07-16 | Madison | Illinois | 17119 | 31674 | 606 |
1521660 | 1521660 | 2021-07-16 | Marion | Illinois | 17121 | 4630 | 123 |
1521661 | 1521661 | 2021-07-16 | Marshall | Illinois | 17123 | 1091 | 21 |
1521662 | 1521662 | 2021-07-16 | Mason | Illinois | 17125 | 1607 | 48 |
1521663 | 1521663 | 2021-07-16 | Massac | Illinois | 17127 | 1383 | 43 |
1521664 | 1521664 | 2021-07-16 | McDonough | Illinois | 17109 | 2994 | 63 |
1521665 | 1521665 | 2021-07-16 | McHenry | Illinois | 17111 | 29333 | 325 |
1521666 | 1521666 | 2021-07-16 | McLean | Illinois | 17113 | 18658 | 229 |
1521667 | 1521667 | 2021-07-16 | Menard | Illinois | 17129 | 1263 | 16 |
1521668 | 1521668 | 2021-07-16 | Mercer | Illinois | 17131 | 1509 | 34 |
1521669 | 1521669 | 2021-07-16 | Monroe | Illinois | 17133 | 4437 | 94 |
1521670 | 1521670 | 2021-07-16 | Montgomery | Illinois | 17135 | 3821 | 80 |
1521671 | 1521671 | 2021-07-16 | Morgan | Illinois | 17137 | 4152 | 109 |
1521672 | 1521672 | 2021-07-16 | Moultrie | Illinois | 17139 | 1654 | 36 |
1521673 | 1521673 | 2021-07-16 | Ogle | Illinois | 17141 | 6258 | 92 |
1521674 | 1521674 | 2021-07-16 | Peoria | Illinois | 17143 | 23614 | 372 |
1521675 | 1521675 | 2021-07-16 | Perry | Illinois | 17145 | 3232 | 69 |
1521676 | 1521676 | 2021-07-16 | Piatt | Illinois | 17147 | 1539 | 20 |
1521677 | 1521677 | 2021-07-16 | Pike | Illinois | 17149 | 1912 | 56 |
1521678 | 1521678 | 2021-07-16 | Pope | Illinois | 17151 | 333 | 4 |
1521679 | 1521679 | 2021-07-16 | Pulaski | Illinois | 17153 | 710 | 7 |
1521680 | 1521680 | 2021-07-16 | Putnam | Illinois | 17155 | 492 | 4 |
1521681 | 1521681 | 2021-07-16 | Randolph | Illinois | 17157 | 4234 | 93 |
1521682 | 1521682 | 2021-07-16 | Richland | Illinois | 17159 | 1778 | 49 |
1521683 | 1521683 | 2021-07-16 | Rock Island | Illinois | 17161 | 15289 | 372 |
1521684 | 1521684 | 2021-07-16 | Saline | Illinois | 17165 | 2647 | 73 |
1521685 | 1521685 | 2021-07-16 | Sangamon | Illinois | 17167 | 19331 | 284 |
1521686 | 1521686 | 2021-07-16 | Schuyler | Illinois | 17169 | 800 | 19 |
1521687 | 1521687 | 2021-07-16 | Scott | Illinois | 17171 | 498 | 1 |
1521688 | 1521688 | 2021-07-16 | Shelby | Illinois | 17173 | 2339 | 41 |
1521689 | 1521689 | 2021-07-16 | St. Clair | Illinois | 17163 | 32171 | 566 |
1521690 | 1521690 | 2021-07-16 | Stark | Illinois | 17175 | 650 | 24 |
1521691 | 1521691 | 2021-07-16 | Stephenson | Illinois | 17177 | 4859 | 105 |
1521692 | 1521692 | 2021-07-16 | Tazewell | Illinois | 17179 | 17319 | 341 |
1521693 | 1521693 | 2021-07-16 | Union | Illinois | 17181 | 2374 | 45 |
1521694 | 1521694 | 2021-07-16 | Unknown | Illinois | 0 | 443 | |
1521695 | 1521695 | 2021-07-16 | Vermilion | Illinois | 17183 | 10121 | 169 |
1521696 | 1521696 | 2021-07-16 | Wabash | Illinois | 17185 | 1417 | 15 |
1521697 | 1521697 | 2021-07-16 | Warren | Illinois | 17187 | 1854 | 53 |
1521698 | 1521698 | 2021-07-16 | Washington | Illinois | 17189 | 1669 | 31 |
1521699 | 1521699 | 2021-07-16 | Wayne | Illinois | 17191 | 1832 | 54 |
1521700 | 1521700 | 2021-07-16 | White | Illinois | 17193 | 1732 | 36 |
1521701 | 1521701 | 2021-07-16 | Whiteside | Illinois | 17195 | 7313 | 216 |
1521702 | 1521702 | 2021-07-16 | Will | Illinois | 17197 | 77320 | 1115 |
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);