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 2021-12-16 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2018711 | 2018711 | 2021-12-16 | Adams | Illinois | 17001 | 15347 | 192 |
2018712 | 2018712 | 2021-12-16 | Alexander | Illinois | 17003 | 841 | 13 |
2018713 | 2018713 | 2021-12-16 | Bond | Illinois | 17005 | 2906 | 34 |
2018714 | 2018714 | 2021-12-16 | Boone | Illinois | 17007 | 9467 | 101 |
2018715 | 2018715 | 2021-12-16 | Brown | Illinois | 17009 | 1175 | 18 |
2018716 | 2018716 | 2021-12-16 | Bureau | Illinois | 17011 | 5283 | 116 |
2018717 | 2018717 | 2021-12-16 | Calhoun | Illinois | 17013 | 897 | 6 |
2018718 | 2018718 | 2021-12-16 | Carroll | Illinois | 17015 | 2867 | 42 |
2018719 | 2018719 | 2021-12-16 | Cass | Illinois | 17017 | 2926 | 40 |
2018720 | 2018720 | 2021-12-16 | Champaign | Illinois | 17019 | 32740 | 222 |
2018721 | 2018721 | 2021-12-16 | Christian | Illinois | 17021 | 6311 | 102 |
2018722 | 2018722 | 2021-12-16 | Clark | Illinois | 17023 | 3142 | 52 |
2018723 | 2018723 | 2021-12-16 | Clay | Illinois | 17025 | 3161 | 60 |
2018724 | 2018724 | 2021-12-16 | Clinton | Illinois | 17027 | 7794 | 116 |
2018725 | 2018725 | 2021-12-16 | Coles | Illinois | 17029 | 9217 | 144 |
2018726 | 2018726 | 2021-12-16 | Cook | Illinois | 17031 | 716675 | 12257 |
2018727 | 2018727 | 2021-12-16 | Crawford | Illinois | 17033 | 3704 | 47 |
2018728 | 2018728 | 2021-12-16 | Cumberland | Illinois | 17035 | 2230 | 41 |
2018729 | 2018729 | 2021-12-16 | De Witt | Illinois | 17039 | 2709 | 39 |
2018730 | 2018730 | 2021-12-16 | DeKalb | Illinois | 17037 | 14752 | 157 |
2018731 | 2018731 | 2021-12-16 | Douglas | Illinois | 17041 | 3841 | 44 |
2018732 | 2018732 | 2021-12-16 | DuPage | Illinois | 17043 | 125867 | 1510 |
2018733 | 2018733 | 2021-12-16 | Edgar | Illinois | 17045 | 3254 | 71 |
2018734 | 2018734 | 2021-12-16 | Edwards | Illinois | 17047 | 1210 | 21 |
2018735 | 2018735 | 2021-12-16 | Effingham | Illinois | 17049 | 7566 | 123 |
2018736 | 2018736 | 2021-12-16 | Fayette | Illinois | 17051 | 4865 | 74 |
2018737 | 2018737 | 2021-12-16 | Ford | Illinois | 17053 | 2869 | 67 |
2018738 | 2018738 | 2021-12-16 | Franklin | Illinois | 17055 | 8160 | 139 |
2018739 | 2018739 | 2021-12-16 | Fulton | Illinois | 17057 | 6058 | 96 |
2018740 | 2018740 | 2021-12-16 | Gallatin | Illinois | 17059 | 864 | 11 |
2018741 | 2018741 | 2021-12-16 | Greene | Illinois | 17061 | 2381 | 53 |
2018742 | 2018742 | 2021-12-16 | Grundy | Illinois | 17063 | 8953 | 96 |
2018743 | 2018743 | 2021-12-16 | Hamilton | Illinois | 17065 | 1479 | 26 |
2018744 | 2018744 | 2021-12-16 | Hancock | Illinois | 17067 | 3230 | 45 |
2018745 | 2018745 | 2021-12-16 | Hardin | Illinois | 17069 | 721 | 16 |
2018746 | 2018746 | 2021-12-16 | Henderson | Illinois | 17071 | 854 | 24 |
2018747 | 2018747 | 2021-12-16 | Henry | Illinois | 17073 | 7936 | 115 |
2018748 | 2018748 | 2021-12-16 | Iroquois | Illinois | 17075 | 5054 | 88 |
2018749 | 2018749 | 2021-12-16 | Jackson | Illinois | 17077 | 8749 | 110 |
2018750 | 2018750 | 2021-12-16 | Jasper | Illinois | 17079 | 1831 | 23 |
2018751 | 2018751 | 2021-12-16 | Jefferson | Illinois | 17081 | 7225 | 149 |
2018752 | 2018752 | 2021-12-16 | Jersey | Illinois | 17083 | 4022 | 74 |
2018753 | 2018753 | 2021-12-16 | Jo Daviess | Illinois | 17085 | 2762 | 34 |
2018754 | 2018754 | 2021-12-16 | Johnson | Illinois | 17087 | 2589 | 38 |
2018755 | 2018755 | 2021-12-16 | Kane | Illinois | 17089 | 78353 | 981 |
2018756 | 2018756 | 2021-12-16 | Kankakee | Illinois | 17091 | 20784 | 288 |
2018757 | 2018757 | 2021-12-16 | Kendall | Illinois | 17093 | 19942 | 134 |
2018758 | 2018758 | 2021-12-16 | Knox | Illinois | 17095 | 8296 | 211 |
2018759 | 2018759 | 2021-12-16 | LaSalle | Illinois | 17099 | 17553 | 353 |
2018760 | 2018760 | 2021-12-16 | Lake | Illinois | 17097 | 92815 | 1197 |
2018761 | 2018761 | 2021-12-16 | Lawrence | Illinois | 17101 | 3702 | 46 |
2018762 | 2018762 | 2021-12-16 | Lee | Illinois | 17103 | 5589 | 105 |
2018763 | 2018763 | 2021-12-16 | Livingston | Illinois | 17105 | 6860 | 123 |
2018764 | 2018764 | 2021-12-16 | Logan | Illinois | 17107 | 5711 | 90 |
2018765 | 2018765 | 2021-12-16 | Macon | Illinois | 17115 | 18214 | 276 |
2018766 | 2018766 | 2021-12-16 | Macoupin | Illinois | 17117 | 8061 | 149 |
2018767 | 2018767 | 2021-12-16 | Madison | Illinois | 17119 | 45272 | 710 |
2018768 | 2018768 | 2021-12-16 | Marion | Illinois | 17121 | 7880 | 163 |
2018769 | 2018769 | 2021-12-16 | Marshall | Illinois | 17123 | 1710 | 25 |
2018770 | 2018770 | 2021-12-16 | Mason | Illinois | 17125 | 2518 | 54 |
2018771 | 2018771 | 2021-12-16 | Massac | Illinois | 17127 | 2483 | 59 |
2018772 | 2018772 | 2021-12-16 | McDonough | Illinois | 17109 | 4365 | 82 |
2018773 | 2018773 | 2021-12-16 | McHenry | Illinois | 17111 | 42717 | 379 |
2018774 | 2018774 | 2021-12-16 | McLean | Illinois | 17113 | 27406 | 276 |
2018775 | 2018775 | 2021-12-16 | Menard | Illinois | 17129 | 2046 | 19 |
2018776 | 2018776 | 2021-12-16 | Mercer | Illinois | 17131 | 2547 | 37 |
2018777 | 2018777 | 2021-12-16 | Monroe | Illinois | 17133 | 5951 | 107 |
2018778 | 2018778 | 2021-12-16 | Montgomery | Illinois | 17135 | 5739 | 91 |
2018779 | 2018779 | 2021-12-16 | Morgan | Illinois | 17137 | 5831 | 125 |
2018780 | 2018780 | 2021-12-16 | Moultrie | Illinois | 17139 | 2785 | 44 |
2018781 | 2018781 | 2021-12-16 | Ogle | Illinois | 17141 | 9424 | 111 |
2018782 | 2018782 | 2021-12-16 | Peoria | Illinois | 17143 | 30959 | 435 |
2018783 | 2018783 | 2021-12-16 | Perry | Illinois | 17145 | 4685 | 89 |
2018784 | 2018784 | 2021-12-16 | Piatt | Illinois | 17147 | 2678 | 21 |
2018785 | 2018785 | 2021-12-16 | Pike | Illinois | 17149 | 3256 | 61 |
2018786 | 2018786 | 2021-12-16 | Pope | Illinois | 17151 | 644 | 6 |
2018787 | 2018787 | 2021-12-16 | Pulaski | Illinois | 17153 | 1137 | 15 |
2018788 | 2018788 | 2021-12-16 | Putnam | Illinois | 17155 | 715 | 6 |
2018789 | 2018789 | 2021-12-16 | Randolph | Illinois | 17157 | 5982 | 111 |
2018790 | 2018790 | 2021-12-16 | Richland | Illinois | 17159 | 3336 | 74 |
2018791 | 2018791 | 2021-12-16 | Rock Island | Illinois | 17161 | 22339 | 431 |
2018792 | 2018792 | 2021-12-16 | Saline | Illinois | 17165 | 4784 | 90 |
2018793 | 2018793 | 2021-12-16 | Sangamon | Illinois | 17167 | 29661 | 345 |
2018794 | 2018794 | 2021-12-16 | Schuyler | Illinois | 17169 | 1234 | 25 |
2018795 | 2018795 | 2021-12-16 | Scott | Illinois | 17171 | 831 | 7 |
2018796 | 2018796 | 2021-12-16 | Shelby | Illinois | 17173 | 4171 | 57 |
2018797 | 2018797 | 2021-12-16 | St. Clair | Illinois | 17163 | 44930 | 668 |
2018798 | 2018798 | 2021-12-16 | Stark | Illinois | 17175 | 979 | 29 |
2018799 | 2018799 | 2021-12-16 | Stephenson | Illinois | 17177 | 7898 | 136 |
2018800 | 2018800 | 2021-12-16 | Tazewell | Illinois | 17179 | 24458 | 399 |
2018801 | 2018801 | 2021-12-16 | Union | Illinois | 17181 | 3446 | 56 |
2018802 | 2018802 | 2021-12-16 | Unknown | Illinois | 0 | 1036 | |
2018803 | 2018803 | 2021-12-16 | Vermilion | Illinois | 17183 | 17913 | 243 |
2018804 | 2018804 | 2021-12-16 | Wabash | Illinois | 17185 | 2324 | 22 |
2018805 | 2018805 | 2021-12-16 | Warren | Illinois | 17187 | 2790 | 72 |
2018806 | 2018806 | 2021-12-16 | Washington | Illinois | 17189 | 2325 | 36 |
2018807 | 2018807 | 2021-12-16 | Wayne | Illinois | 17191 | 3413 | 67 |
2018808 | 2018808 | 2021-12-16 | White | Illinois | 17193 | 3010 | 43 |
2018809 | 2018809 | 2021-12-16 | Whiteside | Illinois | 17195 | 9987 | 235 |
2018810 | 2018810 | 2021-12-16 | Will | Illinois | 17197 | 106605 | 1277 |
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);