ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
103 rows where "date" is on date 2022-02-25 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2249593 | 2249593 | 2022-02-25 | Adams | Illinois | 17001 | 22119 | 229 |
2249594 | 2249594 | 2022-02-25 | Alexander | Illinois | 17003 | 1269 | 15 |
2249595 | 2249595 | 2022-02-25 | Bond | Illinois | 17005 | 4289 | 35 |
2249596 | 2249596 | 2022-02-25 | Boone | Illinois | 17007 | 13627 | 122 |
2249597 | 2249597 | 2022-02-25 | Brown | Illinois | 17009 | 2379 | 21 |
2249598 | 2249598 | 2022-02-25 | Bureau | Illinois | 17011 | 8255 | 139 |
2249599 | 2249599 | 2022-02-25 | Calhoun | Illinois | 17013 | 1513 | 8 |
2249600 | 2249600 | 2022-02-25 | Carroll | Illinois | 17015 | 4186 | 47 |
2249601 | 2249601 | 2022-02-25 | Cass | Illinois | 17017 | 4568 | 44 |
2249602 | 2249602 | 2022-02-25 | Champaign | Illinois | 17019 | 61422 | 290 |
2249603 | 2249603 | 2022-02-25 | Christian | Illinois | 17021 | 10030 | 128 |
2249604 | 2249604 | 2022-02-25 | Clark | Illinois | 17023 | 4796 | 59 |
2249605 | 2249605 | 2022-02-25 | Clay | Illinois | 17025 | 4723 | 70 |
2249606 | 2249606 | 2022-02-25 | Clinton | Illinois | 17027 | 11801 | 122 |
2249607 | 2249607 | 2022-02-25 | Coles | Illinois | 17029 | 15102 | 168 |
2249608 | 2249608 | 2022-02-25 | Cook | Illinois | 17031 | 1109348 | 14571 |
2249609 | 2249609 | 2022-02-25 | Crawford | Illinois | 17033 | 6134 | 58 |
2249610 | 2249610 | 2022-02-25 | Cumberland | Illinois | 17035 | 3334 | 49 |
2249611 | 2249611 | 2022-02-25 | De Witt | Illinois | 17039 | 4293 | 42 |
2249612 | 2249612 | 2022-02-25 | DeKalb | Illinois | 17037 | 22943 | 194 |
2249613 | 2249613 | 2022-02-25 | Douglas | Illinois | 17041 | 6419 | 58 |
2249614 | 2249614 | 2022-02-25 | DuPage | Illinois | 17043 | 205241 | 1757 |
2249615 | 2249615 | 2022-02-25 | Edgar | Illinois | 17045 | 5091 | 77 |
2249616 | 2249616 | 2022-02-25 | Edwards | Illinois | 17047 | 1764 | 28 |
2249617 | 2249617 | 2022-02-25 | Effingham | Illinois | 17049 | 10542 | 141 |
2249618 | 2249618 | 2022-02-25 | Fayette | Illinois | 17051 | 7032 | 97 |
2249619 | 2249619 | 2022-02-25 | Ford | Illinois | 17053 | 4375 | 72 |
2249620 | 2249620 | 2022-02-25 | Franklin | Illinois | 17055 | 12203 | 175 |
2249621 | 2249621 | 2022-02-25 | Fulton | Illinois | 17057 | 9914 | 127 |
2249622 | 2249622 | 2022-02-25 | Gallatin | Illinois | 17059 | 1383 | 17 |
2249623 | 2249623 | 2022-02-25 | Greene | Illinois | 17061 | 3575 | 56 |
2249624 | 2249624 | 2022-02-25 | Grundy | Illinois | 17063 | 12479 | 137 |
2249625 | 2249625 | 2022-02-25 | Hamilton | Illinois | 17065 | 2158 | 32 |
2249626 | 2249626 | 2022-02-25 | Hancock | Illinois | 17067 | 4340 | 55 |
2249627 | 2249627 | 2022-02-25 | Hardin | Illinois | 17069 | 1043 | 19 |
2249628 | 2249628 | 2022-02-25 | Henderson | Illinois | 17071 | 1137 | 26 |
2249629 | 2249629 | 2022-02-25 | Henry | Illinois | 17073 | 12519 | 145 |
2249630 | 2249630 | 2022-02-25 | Iroquois | Illinois | 17075 | 7089 | 113 |
2249631 | 2249631 | 2022-02-25 | Jackson | Illinois | 17077 | 15356 | 126 |
2249632 | 2249632 | 2022-02-25 | Jasper | Illinois | 17079 | 2665 | 28 |
2249633 | 2249633 | 2022-02-25 | Jefferson | Illinois | 17081 | 10955 | 170 |
2249634 | 2249634 | 2022-02-25 | Jersey | Illinois | 17083 | 6162 | 86 |
2249635 | 2249635 | 2022-02-25 | Jo Daviess | Illinois | 17085 | 3963 | 38 |
2249636 | 2249636 | 2022-02-25 | Johnson | Illinois | 17087 | 4379 | 46 |
2249637 | 2249637 | 2022-02-25 | Kane | Illinois | 17089 | 124286 | 1147 |
2249638 | 2249638 | 2022-02-25 | Kankakee | Illinois | 17091 | 28535 | 364 |
2249639 | 2249639 | 2022-02-25 | Kendall | Illinois | 17093 | 30458 | 163 |
2249640 | 2249640 | 2022-02-25 | Knox | Illinois | 17095 | 12438 | 237 |
2249641 | 2249641 | 2022-02-25 | LaSalle | Illinois | 17099 | 28533 | 430 |
2249642 | 2249642 | 2022-02-25 | Lake | Illinois | 17097 | 146788 | 1392 |
2249643 | 2249643 | 2022-02-25 | Lawrence | Illinois | 17101 | 5464 | 50 |
2249644 | 2249644 | 2022-02-25 | Lee | Illinois | 17103 | 8670 | 116 |
2249645 | 2249645 | 2022-02-25 | Livingston | Illinois | 17105 | 10589 | 148 |
2249646 | 2249646 | 2022-02-25 | Logan | Illinois | 17107 | 9323 | 97 |
2249647 | 2249647 | 2022-02-25 | Macon | Illinois | 17115 | 30166 | 339 |
2249648 | 2249648 | 2022-02-25 | Macoupin | Illinois | 17117 | 12611 | 166 |
2249649 | 2249649 | 2022-02-25 | Madison | Illinois | 17119 | 69600 | 841 |
2249650 | 2249650 | 2022-02-25 | Marion | Illinois | 17121 | 11768 | 210 |
2249651 | 2249651 | 2022-02-25 | Marshall | Illinois | 17123 | 2719 | 32 |
2249652 | 2249652 | 2022-02-25 | Mason | Illinois | 17125 | 3863 | 60 |
2249653 | 2249653 | 2022-02-25 | Massac | Illinois | 17127 | 3817 | 68 |
2249654 | 2249654 | 2022-02-25 | McDonough | Illinois | 17109 | 7103 | 97 |
2249655 | 2249655 | 2022-02-25 | McHenry | Illinois | 17111 | 74685 | 483 |
2249656 | 2249656 | 2022-02-25 | McLean | Illinois | 17113 | 48947 | 320 |
2249657 | 2249657 | 2022-02-25 | Menard | Illinois | 17129 | 3468 | 23 |
2249658 | 2249658 | 2022-02-25 | Mercer | Illinois | 17131 | 3958 | 46 |
2249659 | 2249659 | 2022-02-25 | Monroe | Illinois | 17133 | 9407 | 131 |
2249660 | 2249660 | 2022-02-25 | Montgomery | Illinois | 17135 | 9677 | 106 |
2249661 | 2249661 | 2022-02-25 | Morgan | Illinois | 17137 | 9353 | 145 |
2249662 | 2249662 | 2022-02-25 | Moultrie | Illinois | 17139 | 4033 | 51 |
2249663 | 2249663 | 2022-02-25 | Ogle | Illinois | 17141 | 13818 | 136 |
2249664 | 2249664 | 2022-02-25 | Peoria | Illinois | 17143 | 45986 | 553 |
2249665 | 2249665 | 2022-02-25 | Perry | Illinois | 17145 | 7357 | 104 |
2249666 | 2249666 | 2022-02-25 | Piatt | Illinois | 17147 | 4326 | 27 |
2249667 | 2249667 | 2022-02-25 | Pike | Illinois | 17149 | 4979 | 68 |
2249668 | 2249668 | 2022-02-25 | Pope | Illinois | 17151 | 943 | 7 |
2249669 | 2249669 | 2022-02-25 | Pulaski | Illinois | 17153 | 1711 | 17 |
2249670 | 2249670 | 2022-02-25 | Putnam | Illinois | 17155 | 1119 | 10 |
2249671 | 2249671 | 2022-02-25 | Randolph | Illinois | 17157 | 10390 | 127 |
2249672 | 2249672 | 2022-02-25 | Richland | Illinois | 17159 | 5141 | 82 |
2249673 | 2249673 | 2022-02-25 | Rock Island | Illinois | 17161 | 32755 | 506 |
2249674 | 2249674 | 2022-02-25 | Saline | Illinois | 17165 | 7750 | 108 |
2249675 | 2249675 | 2022-02-25 | Sangamon | Illinois | 17167 | 54098 | 416 |
2249676 | 2249676 | 2022-02-25 | Schuyler | Illinois | 17169 | 1937 | 29 |
2249677 | 2249677 | 2022-02-25 | Scott | Illinois | 17171 | 1244 | 11 |
2249678 | 2249678 | 2022-02-25 | Shelby | Illinois | 17173 | 6146 | 74 |
2249679 | 2249679 | 2022-02-25 | St. Clair | Illinois | 17163 | 68510 | 757 |
2249680 | 2249680 | 2022-02-25 | Stark | Illinois | 17175 | 1497 | 32 |
2249681 | 2249681 | 2022-02-25 | Stephenson | Illinois | 17177 | 11365 | 172 |
2249682 | 2249682 | 2022-02-25 | Tazewell | Illinois | 17179 | 36210 | 486 |
2249683 | 2249683 | 2022-02-25 | Union | Illinois | 17181 | 5327 | 67 |
2249684 | 2249684 | 2022-02-25 | Unknown | Illinois | 0 | 2091 | |
2249685 | 2249685 | 2022-02-25 | Vermilion | Illinois | 17183 | 27777 | 304 |
2249686 | 2249686 | 2022-02-25 | Wabash | Illinois | 17185 | 3748 | 30 |
2249687 | 2249687 | 2022-02-25 | Warren | Illinois | 17187 | 3963 | 83 |
2249688 | 2249688 | 2022-02-25 | Washington | Illinois | 17189 | 3395 | 40 |
2249689 | 2249689 | 2022-02-25 | Wayne | Illinois | 17191 | 5237 | 82 |
2249690 | 2249690 | 2022-02-25 | White | Illinois | 17193 | 4371 | 56 |
2249691 | 2249691 | 2022-02-25 | Whiteside | Illinois | 17195 | 15146 | 262 |
2249692 | 2249692 | 2022-02-25 | Will | Illinois | 17197 | 159575 | 1560 |
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);