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-07-22 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1541087 | 1541087 | 2021-07-22 | Adams | Illinois | 17001 | 9364 | 157 |
1541088 | 1541088 | 2021-07-22 | Alexander | Illinois | 17003 | 485 | 11 |
1541089 | 1541089 | 2021-07-22 | Bond | Illinois | 17005 | 2112 | 30 |
1541090 | 1541090 | 2021-07-22 | Boone | Illinois | 17007 | 6906 | 92 |
1541091 | 1541091 | 2021-07-22 | Brown | Illinois | 17009 | 800 | 12 |
1541092 | 1541092 | 2021-07-22 | Bureau | Illinois | 17011 | 3835 | 100 |
1541093 | 1541093 | 2021-07-22 | Calhoun | Illinois | 17013 | 534 | 5 |
1541094 | 1541094 | 2021-07-22 | Carroll | Illinois | 17015 | 2041 | 38 |
1541095 | 1541095 | 2021-07-22 | Cass | Illinois | 17017 | 2094 | 36 |
1541096 | 1541096 | 2021-07-22 | Champaign | Illinois | 17019 | 21425 | 166 |
1541097 | 1541097 | 2021-07-22 | Christian | Illinois | 17021 | 3921 | 93 |
1541098 | 1541098 | 2021-07-22 | Clark | Illinois | 17023 | 1889 | 42 |
1541099 | 1541099 | 2021-07-22 | Clay | Illinois | 17025 | 1528 | 48 |
1541100 | 1541100 | 2021-07-22 | Clinton | Illinois | 17027 | 5852 | 102 |
1541101 | 1541101 | 2021-07-22 | Coles | Illinois | 17029 | 5832 | 103 |
1541102 | 1541102 | 2021-07-22 | Cook | Illinois | 17031 | 560675 | 11107 |
1541103 | 1541103 | 2021-07-22 | Crawford | Illinois | 17033 | 2167 | 42 |
1541104 | 1541104 | 2021-07-22 | Cumberland | Illinois | 17035 | 1309 | 31 |
1541105 | 1541105 | 2021-07-22 | De Witt | Illinois | 17039 | 1605 | 36 |
1541106 | 1541106 | 2021-07-22 | DeKalb | Illinois | 17037 | 10470 | 127 |
1541107 | 1541107 | 2021-07-22 | Douglas | Illinois | 17041 | 2624 | 42 |
1541108 | 1541108 | 2021-07-22 | DuPage | Illinois | 17043 | 93274 | 1406 |
1541109 | 1541109 | 2021-07-22 | Edgar | Illinois | 17045 | 1785 | 62 |
1541110 | 1541110 | 2021-07-22 | Edwards | Illinois | 17047 | 618 | 13 |
1541111 | 1541111 | 2021-07-22 | Effingham | Illinois | 17049 | 4802 | 85 |
1541112 | 1541112 | 2021-07-22 | Fayette | Illinois | 17051 | 3250 | 59 |
1541113 | 1541113 | 2021-07-22 | Ford | Illinois | 17053 | 1919 | 58 |
1541114 | 1541114 | 2021-07-22 | Franklin | Illinois | 17055 | 4759 | 90 |
1541115 | 1541115 | 2021-07-22 | Fulton | Illinois | 17057 | 4093 | 67 |
1541116 | 1541116 | 2021-07-22 | Gallatin | Illinois | 17059 | 477 | 5 |
1541117 | 1541117 | 2021-07-22 | Greene | Illinois | 17061 | 1507 | 47 |
1541118 | 1541118 | 2021-07-22 | Grundy | Illinois | 17063 | 6033 | 83 |
1541119 | 1541119 | 2021-07-22 | Hamilton | Illinois | 17065 | 877 | 19 |
1541120 | 1541120 | 2021-07-22 | Hancock | Illinois | 17067 | 1898 | 42 |
1541121 | 1541121 | 2021-07-22 | Hardin | Illinois | 17069 | 394 | 12 |
1541122 | 1541122 | 2021-07-22 | Henderson | Illinois | 17071 | 534 | 23 |
1541123 | 1541123 | 2021-07-22 | Henry | Illinois | 17073 | 5125 | 99 |
1541124 | 1541124 | 2021-07-22 | Iroquois | Illinois | 17075 | 3263 | 70 |
1541125 | 1541125 | 2021-07-22 | Jackson | Illinois | 17077 | 5350 | 76 |
1541126 | 1541126 | 2021-07-22 | Jasper | Illinois | 17079 | 1168 | 20 |
1541127 | 1541127 | 2021-07-22 | Jefferson | Illinois | 17081 | 4605 | 124 |
1541128 | 1541128 | 2021-07-22 | Jersey | Illinois | 17083 | 2763 | 71 |
1541129 | 1541129 | 2021-07-22 | Jo Daviess | Illinois | 17085 | 1833 | 27 |
1541130 | 1541130 | 2021-07-22 | Johnson | Illinois | 17087 | 1520 | 22 |
1541131 | 1541131 | 2021-07-22 | Kane | Illinois | 17089 | 59878 | 867 |
1541132 | 1541132 | 2021-07-22 | Kankakee | Illinois | 17091 | 14706 | 232 |
1541133 | 1541133 | 2021-07-22 | Kendall | Illinois | 17093 | 14023 | 109 |
1541134 | 1541134 | 2021-07-22 | Knox | Illinois | 17095 | 5711 | 188 |
1541135 | 1541135 | 2021-07-22 | LaSalle | Illinois | 17099 | 12894 | 308 |
1541136 | 1541136 | 2021-07-22 | Lake | Illinois | 17097 | 68926 | 1096 |
1541137 | 1541137 | 2021-07-22 | Lawrence | Illinois | 17101 | 2437 | 36 |
1541138 | 1541138 | 2021-07-22 | Lee | Illinois | 17103 | 4223 | 93 |
1541139 | 1541139 | 2021-07-22 | Livingston | Illinois | 17105 | 4929 | 104 |
1541140 | 1541140 | 2021-07-22 | Logan | Illinois | 17107 | 4044 | 78 |
1541141 | 1541141 | 2021-07-22 | Macon | Illinois | 17115 | 11104 | 224 |
1541142 | 1541142 | 2021-07-22 | Macoupin | Illinois | 17117 | 4924 | 118 |
1541143 | 1541143 | 2021-07-22 | Madison | Illinois | 17119 | 32023 | 606 |
1541144 | 1541144 | 2021-07-22 | Marion | Illinois | 17121 | 4685 | 123 |
1541145 | 1541145 | 2021-07-22 | Marshall | Illinois | 17123 | 1095 | 21 |
1541146 | 1541146 | 2021-07-22 | Mason | Illinois | 17125 | 1625 | 48 |
1541147 | 1541147 | 2021-07-22 | Massac | Illinois | 17127 | 1397 | 43 |
1541148 | 1541148 | 2021-07-22 | McDonough | Illinois | 17109 | 3022 | 63 |
1541149 | 1541149 | 2021-07-22 | McHenry | Illinois | 17111 | 29423 | 325 |
1541150 | 1541150 | 2021-07-22 | McLean | Illinois | 17113 | 18757 | 230 |
1541151 | 1541151 | 2021-07-22 | Menard | Illinois | 17129 | 1269 | 16 |
1541152 | 1541152 | 2021-07-22 | Mercer | Illinois | 17131 | 1513 | 34 |
1541153 | 1541153 | 2021-07-22 | Monroe | Illinois | 17133 | 4469 | 94 |
1541154 | 1541154 | 2021-07-22 | Montgomery | Illinois | 17135 | 3828 | 80 |
1541155 | 1541155 | 2021-07-22 | Morgan | Illinois | 17137 | 4195 | 114 |
1541156 | 1541156 | 2021-07-22 | Moultrie | Illinois | 17139 | 1660 | 36 |
1541157 | 1541157 | 2021-07-22 | Ogle | Illinois | 17141 | 6272 | 92 |
1541158 | 1541158 | 2021-07-22 | Peoria | Illinois | 17143 | 23661 | 374 |
1541159 | 1541159 | 2021-07-22 | Perry | Illinois | 17145 | 3261 | 70 |
1541160 | 1541160 | 2021-07-22 | Piatt | Illinois | 17147 | 1549 | 20 |
1541161 | 1541161 | 2021-07-22 | Pike | Illinois | 17149 | 1966 | 56 |
1541162 | 1541162 | 2021-07-22 | Pope | Illinois | 17151 | 337 | 4 |
1541163 | 1541163 | 2021-07-22 | Pulaski | Illinois | 17153 | 729 | 7 |
1541164 | 1541164 | 2021-07-22 | Putnam | Illinois | 17155 | 493 | 4 |
1541165 | 1541165 | 2021-07-22 | Randolph | Illinois | 17157 | 4262 | 93 |
1541166 | 1541166 | 2021-07-22 | Richland | Illinois | 17159 | 1791 | 49 |
1541167 | 1541167 | 2021-07-22 | Rock Island | Illinois | 17161 | 15334 | 372 |
1541168 | 1541168 | 2021-07-22 | Saline | Illinois | 17165 | 2670 | 73 |
1541169 | 1541169 | 2021-07-22 | Sangamon | Illinois | 17167 | 19437 | 286 |
1541170 | 1541170 | 2021-07-22 | Schuyler | Illinois | 17169 | 804 | 19 |
1541171 | 1541171 | 2021-07-22 | Scott | Illinois | 17171 | 501 | 1 |
1541172 | 1541172 | 2021-07-22 | Shelby | Illinois | 17173 | 2348 | 41 |
1541173 | 1541173 | 2021-07-22 | St. Clair | Illinois | 17163 | 32588 | 570 |
1541174 | 1541174 | 2021-07-22 | Stark | Illinois | 17175 | 655 | 25 |
1541175 | 1541175 | 2021-07-22 | Stephenson | Illinois | 17177 | 4872 | 105 |
1541176 | 1541176 | 2021-07-22 | Tazewell | Illinois | 17179 | 17391 | 341 |
1541177 | 1541177 | 2021-07-22 | Union | Illinois | 17181 | 2438 | 45 |
1541178 | 1541178 | 2021-07-22 | Unknown | Illinois | 0 | 437 | |
1541179 | 1541179 | 2021-07-22 | Vermilion | Illinois | 17183 | 10152 | 171 |
1541180 | 1541180 | 2021-07-22 | Wabash | Illinois | 17185 | 1452 | 15 |
1541181 | 1541181 | 2021-07-22 | Warren | Illinois | 17187 | 1859 | 53 |
1541182 | 1541182 | 2021-07-22 | Washington | Illinois | 17189 | 1674 | 31 |
1541183 | 1541183 | 2021-07-22 | Wayne | Illinois | 17191 | 1855 | 54 |
1541184 | 1541184 | 2021-07-22 | White | Illinois | 17193 | 1760 | 36 |
1541185 | 1541185 | 2021-07-22 | Whiteside | Illinois | 17195 | 7328 | 216 |
1541186 | 1541186 | 2021-07-22 | Will | Illinois | 17197 | 77623 | 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);