ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
103 rows where date = "2022-03-27" 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 |
---|---|---|---|---|---|---|---|
2347165 | 2347165 | 2022-03-27 | Adams | Illinois | 17001 | 22277 | 237 |
2347166 | 2347166 | 2022-03-27 | Alexander | Illinois | 17003 | 1274 | 15 |
2347167 | 2347167 | 2022-03-27 | Bond | Illinois | 17005 | 4310 | 37 |
2347168 | 2347168 | 2022-03-27 | Boone | Illinois | 17007 | 13774 | 128 |
2347169 | 2347169 | 2022-03-27 | Brown | Illinois | 17009 | 2403 | 21 |
2347170 | 2347170 | 2022-03-27 | Bureau | Illinois | 17011 | 8325 | 140 |
2347171 | 2347171 | 2022-03-27 | Calhoun | Illinois | 17013 | 1520 | 8 |
2347172 | 2347172 | 2022-03-27 | Carroll | Illinois | 17015 | 4237 | 49 |
2347173 | 2347173 | 2022-03-27 | Cass | Illinois | 17017 | 4603 | 44 |
2347174 | 2347174 | 2022-03-27 | Champaign | Illinois | 17019 | 62067 | 295 |
2347175 | 2347175 | 2022-03-27 | Christian | Illinois | 17021 | 10155 | 129 |
2347176 | 2347176 | 2022-03-27 | Clark | Illinois | 17023 | 4844 | 60 |
2347177 | 2347177 | 2022-03-27 | Clay | Illinois | 17025 | 4735 | 73 |
2347178 | 2347178 | 2022-03-27 | Clinton | Illinois | 17027 | 11892 | 122 |
2347179 | 2347179 | 2022-03-27 | Coles | Illinois | 17029 | 15225 | 172 |
2347180 | 2347180 | 2022-03-27 | Cook | Illinois | 17031 | 1124384 | 14793 |
2347181 | 2347181 | 2022-03-27 | Crawford | Illinois | 17033 | 6182 | 60 |
2347182 | 2347182 | 2022-03-27 | Cumberland | Illinois | 17035 | 3341 | 49 |
2347183 | 2347183 | 2022-03-27 | De Witt | Illinois | 17039 | 4308 | 44 |
2347184 | 2347184 | 2022-03-27 | DeKalb | Illinois | 17037 | 23228 | 199 |
2347185 | 2347185 | 2022-03-27 | Douglas | Illinois | 17041 | 6441 | 61 |
2347186 | 2347186 | 2022-03-27 | DuPage | Illinois | 17043 | 208874 | 1779 |
2347187 | 2347187 | 2022-03-27 | Edgar | Illinois | 17045 | 5147 | 79 |
2347188 | 2347188 | 2022-03-27 | Edwards | Illinois | 17047 | 1754 | 29 |
2347189 | 2347189 | 2022-03-27 | Effingham | Illinois | 17049 | 10611 | 146 |
2347190 | 2347190 | 2022-03-27 | Fayette | Illinois | 17051 | 7081 | 103 |
2347191 | 2347191 | 2022-03-27 | Ford | Illinois | 17053 | 4390 | 73 |
2347192 | 2347192 | 2022-03-27 | Franklin | Illinois | 17055 | 12259 | 177 |
2347193 | 2347193 | 2022-03-27 | Fulton | Illinois | 17057 | 10028 | 134 |
2347194 | 2347194 | 2022-03-27 | Gallatin | Illinois | 17059 | 1403 | 17 |
2347195 | 2347195 | 2022-03-27 | Greene | Illinois | 17061 | 3591 | 58 |
2347196 | 2347196 | 2022-03-27 | Grundy | Illinois | 17063 | 12582 | 140 |
2347197 | 2347197 | 2022-03-27 | Hamilton | Illinois | 17065 | 2172 | 34 |
2347198 | 2347198 | 2022-03-27 | Hancock | Illinois | 17067 | 4371 | 58 |
2347199 | 2347199 | 2022-03-27 | Hardin | Illinois | 17069 | 1050 | 20 |
2347200 | 2347200 | 2022-03-27 | Henderson | Illinois | 17071 | 1149 | 27 |
2347201 | 2347201 | 2022-03-27 | Henry | Illinois | 17073 | 12618 | 147 |
2347202 | 2347202 | 2022-03-27 | Iroquois | Illinois | 17075 | 7149 | 115 |
2347203 | 2347203 | 2022-03-27 | Jackson | Illinois | 17077 | 15501 | 129 |
2347204 | 2347204 | 2022-03-27 | Jasper | Illinois | 17079 | 2671 | 30 |
2347205 | 2347205 | 2022-03-27 | Jefferson | Illinois | 17081 | 11036 | 175 |
2347206 | 2347206 | 2022-03-27 | Jersey | Illinois | 17083 | 6196 | 89 |
2347207 | 2347207 | 2022-03-27 | Jo Daviess | Illinois | 17085 | 4016 | 38 |
2347208 | 2347208 | 2022-03-27 | Johnson | Illinois | 17087 | 4458 | 46 |
2347209 | 2347209 | 2022-03-27 | Kane | Illinois | 17089 | 125578 | 1171 |
2347210 | 2347210 | 2022-03-27 | Kankakee | Illinois | 17091 | 28723 | 373 |
2347211 | 2347211 | 2022-03-27 | Kendall | Illinois | 17093 | 30824 | 169 |
2347212 | 2347212 | 2022-03-27 | Knox | Illinois | 17095 | 12511 | 243 |
2347213 | 2347213 | 2022-03-27 | LaSalle | Illinois | 17099 | 28819 | 436 |
2347214 | 2347214 | 2022-03-27 | Lake | Illinois | 17097 | 148740 | 1438 |
2347215 | 2347215 | 2022-03-27 | Lawrence | Illinois | 17101 | 5474 | 51 |
2347216 | 2347216 | 2022-03-27 | Lee | Illinois | 17103 | 8750 | 118 |
2347217 | 2347217 | 2022-03-27 | Livingston | Illinois | 17105 | 10680 | 148 |
2347218 | 2347218 | 2022-03-27 | Logan | Illinois | 17107 | 9451 | 98 |
2347219 | 2347219 | 2022-03-27 | Macon | Illinois | 17115 | 30341 | 350 |
2347220 | 2347220 | 2022-03-27 | Macoupin | Illinois | 17117 | 12728 | 170 |
2347221 | 2347221 | 2022-03-27 | Madison | Illinois | 17119 | 70112 | 857 |
2347222 | 2347222 | 2022-03-27 | Marion | Illinois | 17121 | 11883 | 215 |
2347223 | 2347223 | 2022-03-27 | Marshall | Illinois | 17123 | 2759 | 33 |
2347224 | 2347224 | 2022-03-27 | Mason | Illinois | 17125 | 3887 | 61 |
2347225 | 2347225 | 2022-03-27 | Massac | Illinois | 17127 | 3860 | 69 |
2347226 | 2347226 | 2022-03-27 | McDonough | Illinois | 17109 | 7170 | 102 |
2347227 | 2347227 | 2022-03-27 | McHenry | Illinois | 17111 | 75612 | 503 |
2347228 | 2347228 | 2022-03-27 | McLean | Illinois | 17113 | 49410 | 325 |
2347229 | 2347229 | 2022-03-27 | Menard | Illinois | 17129 | 3495 | 24 |
2347230 | 2347230 | 2022-03-27 | Mercer | Illinois | 17131 | 3993 | 47 |
2347231 | 2347231 | 2022-03-27 | Monroe | Illinois | 17133 | 9451 | 127 |
2347232 | 2347232 | 2022-03-27 | Montgomery | Illinois | 17135 | 9756 | 110 |
2347233 | 2347233 | 2022-03-27 | Morgan | Illinois | 17137 | 9437 | 144 |
2347234 | 2347234 | 2022-03-27 | Moultrie | Illinois | 17139 | 4054 | 52 |
2347235 | 2347235 | 2022-03-27 | Ogle | Illinois | 17141 | 13921 | 136 |
2347236 | 2347236 | 2022-03-27 | Peoria | Illinois | 17143 | 46317 | 555 |
2347237 | 2347237 | 2022-03-27 | Perry | Illinois | 17145 | 7447 | 106 |
2347238 | 2347238 | 2022-03-27 | Piatt | Illinois | 17147 | 4383 | 29 |
2347239 | 2347239 | 2022-03-27 | Pike | Illinois | 17149 | 5016 | 68 |
2347240 | 2347240 | 2022-03-27 | Pope | Illinois | 17151 | 954 | 8 |
2347241 | 2347241 | 2022-03-27 | Pulaski | Illinois | 17153 | 1720 | 19 |
2347242 | 2347242 | 2022-03-27 | Putnam | Illinois | 17155 | 1128 | 10 |
2347243 | 2347243 | 2022-03-27 | Randolph | Illinois | 17157 | 10425 | 129 |
2347244 | 2347244 | 2022-03-27 | Richland | Illinois | 17159 | 5154 | 83 |
2347245 | 2347245 | 2022-03-27 | Rock Island | Illinois | 17161 | 33023 | 515 |
2347246 | 2347246 | 2022-03-27 | Saline | Illinois | 17165 | 7844 | 109 |
2347247 | 2347247 | 2022-03-27 | Sangamon | Illinois | 17167 | 54664 | 425 |
2347248 | 2347248 | 2022-03-27 | Schuyler | Illinois | 17169 | 1949 | 29 |
2347249 | 2347249 | 2022-03-27 | Scott | Illinois | 17171 | 1253 | 11 |
2347250 | 2347250 | 2022-03-27 | Shelby | Illinois | 17173 | 6186 | 77 |
2347251 | 2347251 | 2022-03-27 | St. Clair | Illinois | 17163 | 69167 | 767 |
2347252 | 2347252 | 2022-03-27 | Stark | Illinois | 17175 | 1510 | 32 |
2347253 | 2347253 | 2022-03-27 | Stephenson | Illinois | 17177 | 11459 | 175 |
2347254 | 2347254 | 2022-03-27 | Tazewell | Illinois | 17179 | 36509 | 495 |
2347255 | 2347255 | 2022-03-27 | Union | Illinois | 17181 | 5361 | 68 |
2347256 | 2347256 | 2022-03-27 | Unknown | Illinois | 0 | 2246 | |
2347257 | 2347257 | 2022-03-27 | Vermilion | Illinois | 17183 | 27841 | 311 |
2347258 | 2347258 | 2022-03-27 | Wabash | Illinois | 17185 | 3716 | 30 |
2347259 | 2347259 | 2022-03-27 | Warren | Illinois | 17187 | 3988 | 85 |
2347260 | 2347260 | 2022-03-27 | Washington | Illinois | 17189 | 3422 | 41 |
2347261 | 2347261 | 2022-03-27 | Wayne | Illinois | 17191 | 5286 | 84 |
2347262 | 2347262 | 2022-03-27 | White | Illinois | 17193 | 4399 | 58 |
2347263 | 2347263 | 2022-03-27 | Whiteside | Illinois | 17195 | 15311 | 266 |
2347264 | 2347264 | 2022-03-27 | Will | Illinois | 17197 | 161290 | 1583 |
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);